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