X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fbooking_functions.php;h=9b7e78dc45e62e418191e3a1822b1a052847a250;hb=f888a0bda52e7dd2ea799837ed2991c263864e9f;hp=957c46cf418f6751cc3e0a411771599c28beaeeb;hpb=c3b4eaf29946349ff058691db2dcb615a5379bb2;p=mailer.git diff --git a/inc/libs/booking_functions.php b/inc/libs/booking_functions.php index 957c46cf41..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,26 +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__); -} - -// Filter for adding booking record -function FILTER_ADD_BOOKING_RECORD ($data) { - // Add a record - addBookingRecord($data['subject'], $data['userid'], $data['points'], $data['mode']); - - // Return data - return $data; + 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]