SimpleMachines /
SMF2.1
| @@ 213-220 (lines=8) @@ | ||
| 210 | smf_db_error_backtrace('Wrong value type sent to the database. Time expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 211 | break; |
|
| 212 | ||
| 213 | case 'datetime': |
|
| 214 | 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) |
|
| 215 | return 'to_timestamp('. |
|
| 216 | 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]). |
|
| 217 | ',\'YYYY-MM-DD HH24:MI:SS\')'; |
|
| 218 | else |
|
| 219 | smf_db_error_backtrace('Wrong value type sent to the database. Datetime expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); |
|
| 220 | break; |
|
| 221 | ||
| 222 | case 'float': |
|
| 223 | if (!is_numeric($replacement)) |
|
| @@ 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)) |
|
