X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fbooking_functions.php;h=9b7e78dc45e62e418191e3a1822b1a052847a250;hb=f888a0bda52e7dd2ea799837ed2991c263864e9f;hp=ad4601c0e4ed6d1d0a3d229f4b2f60c79d71ff48;hpb=24dfd21baed6a9a112992bdabf7da96576012bc4;p=mailer.git diff --git a/inc/libs/booking_functions.php b/inc/libs/booking_functions.php index ad4601c0e4..9b7e78dc45 100644 --- a/inc/libs/booking_functions.php +++ b/inc/libs/booking_functions.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -40,17 +40,23 @@ if (!defined('__SECURITY')) { die(); } // END - if -// 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')) { +// Add a record entry ('pointsMode' can be add/sub!) +function addBookingRecord ($subject, $userid, $points, $pointsMode, $accountType) { + // Is the ext-sql_patches updated? + 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`, `points_mode`, `points_account_type`, `points`) VALUES (%s, '%s', '%s', '%s', %s)", + array( + bigintval($userid), + $subject, + strtoupper($pointsMode), + strtoupper($accountType), + $points + ), __FUNCTION__, __LINE__); } // [EOF]