Opps, not all elements for sprintf() has been set.

[mailer.git] / inc / libs / booking_functions.php

diff --git a/inc/libs/booking_functions.php b/inc/libs/booking_functions.php
index 5e5fb3166878fc42042db020ba2f99e73ec874b5..758dc7d847407294c885a88c041bca3705f3c2d9 100644 (file)
--- a/inc/libs/booking_functions.php
+++ b/inc/libs/booking_functions.php
@@ -14,11 +14,10 @@
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
- * Needs to be in all Files and every File needs "svn propset           *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2013 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 *
@@ -41,23 +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']);
+       sqlQueryEscaped("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]