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