SimpleMachines /
SMF2.1
| @@ 263-270 (lines=8) @@ | ||
| 260 | smf_db_error_backtrace('Wrong value type sent to the database. Time expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 261 | break; |
|
| 262 | ||
| 263 | case 'datetime': |
|
| 264 | if (preg_match('~^(\d{4})-([0-1]?\d)-([0-3]?\d) ([0-1]?\d|2[0-3]):([0-5]\d):([0-5]\d)$~', $replacement, $datetime_matches) === 1) |
|
| 265 | return 'str_to_date('. |
|
| 266 | sprintf('\'%04d-%02d-%02d %02d:%02d:%02d\'', $datetime_matches[1], $datetime_matches[2], $datetime_matches[3], $datetime_matches[4], $datetime_matches[5] ,$datetime_matches[6]). |
|
| 267 | ',\'%Y-%m-%d %h:%i:%s\')'; |
|
| 268 | else |
|
| 269 | smf_db_error_backtrace('Wrong value type sent to the database. Datetime expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 270 | break; |
|
| 271 | ||
| 272 | case 'float': |
|
| 273 | if (!is_numeric($replacement)) |
|
| @@ 223-230 (lines=8) @@ | ||
| 220 | smf_db_error_backtrace('Wrong value type sent to the database. Time expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 221 | break; |
|
| 222 | ||
| 223 | case 'datetime': |
|
| 224 | if (preg_match('~^(\d{4})-([0-1]?\d)-([0-3]?\d) ([0-1]?\d|2[0-3]):([0-5]\d):([0-5]\d)$~', $replacement, $datetime_matches) === 1) |
|
| 225 | return 'to_timestamp('. |
|
| 226 | sprintf('\'%04d-%02d-%02d %02d:%02d:%02d\'', $datetime_matches[1], $datetime_matches[2], $datetime_matches[3], $datetime_matches[4], $datetime_matches[5] ,$datetime_matches[6]). |
|
| 227 | ',\'YYYY-MM-DD HH24:MI:SS\')'; |
|
| 228 | else |
|
| 229 | smf_db_error_backtrace('Wrong value type sent to the database. Datetime expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 230 | break; |
|
| 231 | ||
| 232 | case 'float': |
|
| 233 | if (!is_numeric($replacement)) |
|
