// Add a record entry ("mode" can be add/sub!)
function addBookingRecord ($subject, $userid, $points, $mode) {
// Is the sql_patches updated?
- if (isExtensionOlder('sql_patches', '0.5.7')) {
+ if (isExtensionInstalledAndOlder('sql_patches', '0.5.7')) {
// Abort here
return;
} // END - if
// Add record entry here
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_book` (`userid`,`subject`,`mode`,`points`) VALUES(%s,'%s','%s',%s)",
- array($userid, $subject, $mode, $points), __FUNCTION__, __LINE__);
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_booking` (`userid`,`subject`,`mode`,`points`) VALUES(%s,'%s','%s',%s)",
+ array(
+ bigintval($userid),
+ $subject,
+ $mode,
+ $points
+ ), __FUNCTION__, __LINE__);
}
// [EOF]