Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 - Page 2 | HowtoForge - Linux Howtos and Tutorials

Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 - Page 2 | HowtoForge - Linux Howtos and Tutorials: "$_prefs['initial_application'] = array( 'value' => 'imp', 'locked' => true, 'shared' => true, 'type' => 'select', 'desc' => sprintf(_('What application should %s display after login?'), $GLOBALS['registry']->get('name')) );"

天狼星資源部 SiriusResource: SQL 2008 Express 安裝問題 SQL 2008 Express Installation Problem

天狼星資源部 SiriusResource: SQL 2008 Express 安裝問題 SQL 2008 Express Installation Problem: "SQL 2008 Express 安裝問題 SQL 2008 Express Installation Problem

在安裝SQL 2008 Express 的時候,
會有一個Installation Check的物體出現.

而Failed的就係這個:

Performance counter registry hive consistency check:
'The Performance counter registry hive is corrupted'



會要求你去看技術文件http://support.microsoft.com/kb/300956
但就無講Windows Vista的解決方法.
在找過滿多網站及用不同的關鍵字之後.
以下就係各個解決方法:
(註*:Windows XP & Windows Server 個個未用過.)

Windows XP & Windows Server
方法出處:Link

Windows Vista
用regedit在[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\]加個004機碼,
之後係009機碼複製Counter同Help的內容過去004機碼中,就可以解決上面的問題!
之於出於什麼問題,可能係SQL 2008 Express的語言問題.
方法出處:Link"

OVER Clause (Transact-SQL)

OVER Clause (Transact-SQL): "Ranking Window Functions < OVER_CLAUSE > :: = OVER ( [ PARTITION BY value_expression , ... [ n ] ] <ORDER BY_Clause> ) Aggregate Window Functions < OVER_CLAUSE > :: = OVER ( [ PARTITION BY value_expression , ... [ n ] ] )"

phplist 2.10.10 : fixing FCK editor’s image upload problem | Life, Work and Technology

phplist 2.10.10 : fixing FCK editor’s image upload problem | Life, Work and Technology: "Open file :
view sourceprint?
1.PHPListRoot/admin/FCKeditor/editor/filemanager/connectors/phplist/config.php

on line number 28 change:
view sourceprint?
1.} elseif (is_file('../../../../../../../../config/config.php')) {

to:
view sourceprint?
1.} elseif (is_file('../../../../../../config/config.php')) {

and on line number 29, change:
view sourceprint?
1.include '../../../../../../../../config/config.php';

to
view sourceprint?
1.include '../../../../../../config/config.php';

Thats it! Save the file and you should be able to instantly upload images using the FCK editor"

phplist Documentation: Message Tracking

phplist Documentation: Message Tracking: "Click tracking

Click tracking monitors whether a recipient has clicked on a link contained within a HTML or Text message. When enabled, all links in your messages will be converted to links that go through phplist. This will make sure that clicks are tracked and registered in the database. Click tracking can therefore be a simple and reliable way to monitor how many people have clicked through to your site from a message you have sent.
Note: Keep in mind that click tracking still is experimental. Your feedback is welcome and may help improve this feature.

If you want to use click tracking, you need to enable the clicktrack setting in your config.php file:

# Click tracking
# If you set this to 1, all links in your emails will be converted to links that
# go via phplist. This will make sure that clicks are tracked. This is experimental and
# all your findings when using this feature should be reported to mantis
# for now it's off by default until we think it works correctly
define('CLICKTRACK',1);

# Click track, list detail
# if you enable this, you will get some extra statistics about unique users who have clicked the
# links in your messages, and the breakdown between clicks from text or html messages.
# However, this will slow down the process to view the statistics, so it is
# recommended to leave it off, but if you're very curious, you can enable it
define('CLICKTRACK_SHOWDETAIL',0);"

phplist 標題亂碼問題 « 更夜

phplist 標題亂碼問題 « 更夜:

admin/send_core.php

"找到 1034 行 , 原始碼應該長這樣
//value=''.htmlentities(iconv('ISO-8859-1','UTF-8',$subject),ENT_QUOTES,'UTF-8').'' size=40></td></tr>
改成
//value=''.htmlentities($subject,ENT_QUOTES,'UTF-8').'' size=40></td></tr>

下面的1040行, 原來的code
value=''.htmlentities(iconv('ISO-8859-1','UTF-8',$from),ENT_QUOTES,'UTF-8').'' size=40></td></tr>
改成
value=''.htmlentities($from,ENT_QUOTES,'UTF-8').'' size=40></td></tr>"

SQL Server Date Time Format

SQL Server Date Time Format:
"In SQL Server used Cast or Convert function to Format DateTime value or column into a specific date format.Both function are used to convert datetime to varchar or string.

CAST function Syntax: CAST(expression as data_type)

Let's convert current date time to varchar

select cast(getdate() as varchar)

CONVERT function is used to change or convert the DateTime formats.By using convert function you can get only Date part or only Time part from the datetime.

CONVERT Function Syntax: CONVERT(data_type,expression,date Format style)

Let's take Sql Server DateTtime styles example:

Format


Query

USA mm/dd/yy


select convert(varchar, getdate(), 1)

ANSI yy.mm.dd


select convert(varchar, getdate(), 2)

British/French dd/mm/yy


select convert(varchar, getdate(), 3)

German dd.mm.yy


select convert(varchar, getdate(), 4)

Italian dd-mm-yy


select convert(varchar, getdate(), 5)

dd mon yy


select convert(varchar, getdate(), 6)

Mon dd, yy


select convert(varchar, getdate(), 7)

USA mm-dd-yy


select convert(varchar, getdate(), 10)

JAPAN yy/mm/dd


select convert(varchar, getdate(), 11)

ISO yymmdd


select convert(varchar, getdate(), 12)

mon dd yyyy hh:miAM (or PM)


select convert(varchar, getdate(), 100)

mm/dd/yyyy


select convert(varchar, getdate(), 101)

yyyy.mm.dd


select convert(varchar, getdate(), 102)

dd/mm/yyyy


select convert(varchar, getdate(), 103)

dd.mm.yyyy


select convert(varchar, getdate(), 104)

dd-mm-yyyy


select convert(varchar, getdate(), 105)

dd mon yyyy


select convert(varchar, getdate(), 106)

Mon dd, yyyy


select convert(varchar, getdate(), 107)

hh:mm:ss


select convert(varchar, getdate(), 108)

Default + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or PM)


select convert(varchar, getdate(), 109)

mm-dd-yyyy


select convert(varchar, getdate(), 110)

yyyy/mm/dd


select convert(varchar, getdate(), 111)

yyyymmdd


select convert(varchar, getdate(), 112)

Europe default + milliseconds dd mon yyyy hh:mm:ss:mmm(24h)


select convert(varchar, getdate(), 113) or select convert(varchar, getdate(), 13)

hh:mi:ss:mmm(24h)


select convert(varchar, getdate(), 114)"