X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fdoubler_functions.php;h=b6eddaf4432c2349b6baacf6ab2f3428feb7ccb3;hp=2a2100f59272ed2a4613f8525377ed613aa071ff;hb=0715fa7aa8e5e70bcf1d957fb09ae655c3896c4e;hpb=263a089d8a499e0e26d0af9e7aa7639f88b8ca60

diff --git a/inc/libs/doubler_functions.php b/inc/libs/doubler_functions.php
index 2a2100f592..b6eddaf443 100644
--- a/inc/libs/doubler_functions.php
+++ b/inc/libs/doubler_functions.php
@@ -18,6 +18,7 @@
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -69,15 +70,21 @@ function generateDoublerTable ($userid = '0', $done = 'N', $ref = 'N', $sort = '
 	}
 
 	// List entries
-	$result = SQL_QUERY("SELECT
+	$result = SQL_QUERY_ESC("SELECT
 	`userid`, `refid`, `points`, `timemark`
 FROM
 	`{?_MYSQL_PREFIX?}_doubler`
 WHERE
-	`completed`='".$done."' AND `is_ref`='".$ref."'".$add."
+	`completed`='%s' AND `is_ref`='%s'" . $add . "
 ORDER BY
-	`timemark` ".$sort."
-LIMIT ".$limit, __FUNCTION__, __LINE__);
+	`timemark` %s
+LIMIT %s",
+		array(
+			$done,
+			$ref,
+			$sort,
+			$limit
+		), __FUNCTION__, __LINE__);
 
 	if (SQL_NUMROWS($result) > 0) {
 		// List entries
@@ -109,7 +116,7 @@ LIMIT ".$limit, __FUNCTION__, __LINE__);
 	} else {
 		// List no entries
 		$OUT = "<tr>
-  <td colspan=\"".$COLS."\" align=\"center\" class=\"doubler_big_row bottom2\">
+  <td colspan=\"".$COLS."\" align=\"center\" class=\"doubler_big_row bottom\">
     ".loadTemplate('admin_settings_saved', true, $message)."
   </td>
 </tr>\n";