|
@@ -1086,8 +1086,8 @@ |
|
|
block discarded – undo |
|
1086
|
1086
|
Database::prepare( |
|
1087
|
1087
|
"REPLACE INTO `##message` (message_id, sender, ip_address, user_id, subject, body, created)" . |
|
1088
|
1088
|
" SELECT m_id, m_from, '127.0.0.1', user_id, m_subject, m_body, (CASE " . |
|
1089
|
|
- " WHEN CHAR_LENGTH(m_created) = 20 THEN STR_TO_DATE(m_created, '%M %d %Y %H:%i:%s') ". |
|
1090
|
|
- " WHEN CHAR_LENGTH(m_created) = 0 THEN NULL ". |
|
|
1089
|
+ " WHEN CHAR_LENGTH(m_created) = 20 THEN STR_TO_DATE(m_created, '%M %d %Y %H:%i:%s') " . |
|
|
1090
|
+ " WHEN CHAR_LENGTH(m_created) = 0 THEN NULL " . |
|
1091
|
1091
|
" ELSE STR_TO_DATE(LEFT(m_created,25),'%a, %d %M %Y %H:%i:%s')" . |
|
1092
|
1092
|
" END)" . |
|
1093
|
1093
|
" FROM `{$DBNAME}`.`{$TBLPREFIX}messages`" . |
Please login to merge, or discard this patch.