SimpleMachines /
SMF2.1
| @@ 214-221 (lines=8) @@ | ||
| 211 | smf_db_error_backtrace('Wrong value type sent to the database. Time expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 212 | break; |
|
| 213 | ||
| 214 | case 'datetime': |
|
| 215 | 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) |
|
| 216 | return 'to_timestamp('. |
|
| 217 | 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]). |
|
| 218 | ',\'YYYY-MM-DD HH24:MI:SS\')'; |
|
| 219 | else |
|
| 220 | smf_db_error_backtrace('Wrong value type sent to the database. Datetime expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 221 | break; |
|
| 222 | ||
| 223 | case 'float': |
|
| 224 | if (!is_numeric($replacement)) |
|
| @@ 253-260 (lines=8) @@ | ||
| 250 | smf_db_error_backtrace('Wrong value type sent to the database. Time expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 251 | break; |
|
| 252 | ||
| 253 | case 'datetime': |
|
| 254 | 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) |
|
| 255 | return 'str_to_date('. |
|
| 256 | 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]). |
|
| 257 | ',\'%Y-%m-%d %h:%i:%s\')'; |
|
| 258 | else |
|
| 259 | smf_db_error_backtrace('Wrong value type sent to the database. Datetime expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 260 | break; |
|
| 261 | ||
| 262 | case 'float': |
|
| 263 | if (!is_numeric($replacement)) |
|
