X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fbooking_functions.php;h=cbbde725902d4b423ad9aeba12acc6cfdd38824b;hb=ca11996eb52fa0a1ec45d6ab10f5331c4a54a116;hp=ad4601c0e4ed6d1d0a3d229f4b2f60c79d71ff48;hpb=24dfd21baed6a9a112992bdabf7da96576012bc4;p=mailer.git

diff --git a/inc/libs/booking_functions.php b/inc/libs/booking_functions.php
index ad4601c0e4..cbbde72590 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,22 @@ if (!defined('__SECURITY')) {
 	die();
 } // END - if
 
-// Add a record entry ("mode" can be add/sub!)
-function addBookingRecord ($subject, $userid, $points, $mode) {
+// Add a record entry ('pointsMode' can be add/sub!)
+function addBookingRecord ($subject, $userid, $points, $pointsMode) {
 	// 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`,`points_mode`,`points`) VALUES (%s,'%s','%s',%s)",
+		array(
+			bigintval($userid),
+			$subject,
+			strtoupper($pointsMode),
+			$points
+		), __FUNCTION__, __LINE__);
 }
 
 // [EOF]