X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=show_bonus.php;h=97f9bd3c0dd46236941ebc0e7dee5e136a7915e7;hb=2164ff00dd24d381e1d412ae248f486230b2019a;hp=6814e52df7c19d2ade469593479b9e0ca9423f2c;hpb=ca256746fe0757a23df4064824c8fe2087ad5634;p=mailer.git
diff --git a/show_bonus.php b/show_bonus.php
index 6814e52df7..97f9bd3c0d 100644
--- a/show_bonus.php
+++ b/show_bonus.php
@@ -16,7 +16,7 @@
* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team *
+ * 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 *
@@ -41,7 +41,7 @@ require('inc/libs/security_functions.php');
// Init start time
$GLOBALS['__start_time'] = microtime(TRUE);
-// Set this because we have no module in URI
+// Set this because there is no module in URI
$GLOBALS['__module'] = 'show_bonus';
$GLOBALS['__output_mode'] = '0';
@@ -77,20 +77,20 @@ if ((isValidId(getRequestElement('userid'))) && (getRequestElement('d') > 0) &&
// Valid type?
if (!empty($t)) {
// Check for data
- $result = SQL_QUERY_ESC("SELECT
- d.`userid`,
- b.`level`,
- b.`points`
+ $result = sqlQueryEscaped("SELECT
+ `d`.`userid`,
+ `b`.`level`,
+ `b`.`points`
FROM
- `{?_MYSQL_PREFIX?}_user_data` AS d
+ `{?_MYSQL_PREFIX?}_user_data` AS `d`
INNER JOIN
- `{?_MYSQL_PREFIX?}_bonus_turbo` AS b
+ `{?_MYSQL_PREFIX?}_bonus_turbo` AS `b`
ON
- d.`userid`=b.`userid`
+ `d`.`userid`=`b`.`userid`
WHERE
- d.`status`='CONFIRMED' AND
- d.`userid`=%s AND
- b.`%s`=%s
+ `d`.`status`='CONFIRMED' AND
+ `d`.`userid`=%s AND
+ `b`.`%s`=%s
LIMIT 1",
array(
bigintval(getRequestElement('userid')),
@@ -99,9 +99,9 @@ LIMIT 1",
), __FILE__, __LINE__);
// Entry found?
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Load data
- $content = SQL_FETCHARRAY($result);
+ $content = sqlFetchArray($result);
// Prepare constants for the pre-template
$content['mailid'] = bigintval(getRequestElement('d'));
@@ -118,7 +118,7 @@ LIMIT 1",
}
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} else {
// Wrong type entered
$content['message'] = '{--BONUS_SHOW_WRONG_TYPE--}';
@@ -128,12 +128,6 @@ LIMIT 1",
$content['message'] = '{--BONUS_SHOW_WRONG_CALL--}';
}
-// Load send_bonus header template (for your banners, e.g.?)
-$content['header'] = loadTemplate('show_bonus_header', TRUE);
-
-// Load show_bonus footer template (for your banners, e.g.?)
-$content['footer'] = loadTemplate('show_bonus_footer', TRUE);
-
// Load final template
loadTemplate('show_bonus', FALSE, $content);