Renamed all SQL-related functions to camel-case notation

[mailer.git] / inc / modules / sponsor / welcome.php

diff --git a/inc/modules/sponsor/welcome.php b/inc/modules/sponsor/welcome.php
index 38d37008dab41c0e79099ea49edd2a41cd532e5e..0f2f9275c8d45ddb9cbf94f4cc31b76b9f2f2e2f 100644 (file)
--- a/inc/modules/sponsor/welcome.php
+++ b/inc/modules/sponsor/welcome.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 09/17/2005 *
- * ===============                              Last change: 05/19/2008 *
+ * Mailer v0.2.1-FINAL                                Start: 09/17/2005 *
+ * ===================                          Last change: 05/19/2008 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : welcome.php                                      *
@@ -10,14 +10,19 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Willkommensseite des Sponsorenbereiches          *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision::                                                        $ *
+ * $Date::                                                            $ *
+ * $Tag:: 0.2.1-FINAL                                                 $ *
+ * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * 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 *
+ * 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 *
- * the Free Software Foundation; either version 2 of the License.       *
+ * the Free Software Foundation; either version 2 of the License, or    *
+ * (at your option) any later version.                                  *
  *                                                                      *
  * This program is distributed in the hope that it will be useful,      *
  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
@@ -32,35 +37,40 @@
 
 // Some security stuff...
 if (!defined('__SECURITY')) {
-       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
-       require($INC);
-} elseif ((!EXT_IS_ACTIVE("sponsor"))
-       addFatalMessage(__FILE__, __LINE__, getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "sponsor");
+       exit();
+} elseif (!isExtensionActive('sponsor')) {
+       displayMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=sponsor%}');
        return;
-} elseif (!IS_SPONSOR()) {
+} elseif (!isSponsor()) {
        // No sponsor!
-       addFatalMessage(__FILE__, __LINE__, getMessage('SPONSOR_ONLY_AREA_ENTERED'));
+       addFatalMessage(__FILE__, __LINE__, '{--SPONSOR_ONLY_AREA_ENTERED--}');
        return;
 }
 
 // Load some data
-$result = SQL_QUERY_ESC("SELECT gender, surname, family, (points_amount - points_used) AS points
-FROM `{!_MYSQL_PREFIX!}_sponsor_data`
-WHERE id='%s' AND password='%s' LIMIT 1",
- array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
-list($gender, $surname, $family, $points) = SQL_FETCHROW($result);
+$result = sqlQueryEscaped('SELECT
+       `id`,
+       `gender`,
+       `surname`,
+       `family`,
+       (`points_amount` - `points_used`) AS `points`
+FROM
+       `{?_MYSQL_PREFIX?}_sponsor_data`
+WHERE
+       `id`=%s
+LIMIT 1',
+       array(
+               bigintval(getSession('sponsor_id'))
+       ), __FILE__, __LINE__);
 
-// Free memory
-SQL_FREERESULT($result);
+// Fetch data
+$content = sqlFetchArray($result);
 
-// Prepare data for the template
-define('__GENDER'  , TRANSLATE_GENDER($gender));
-define('__SURNAME', $surname);
-define('__FAMILY' , $family);
-define('__POINTS' , TRANSLATE_COMMA($points));
+// Free memory
+sqlFreeResult($result);
 
 // Load main template
-$OUT = LOAD_TEMPLATE("sponsor_welcome", true);
+$GLOBALS['sponsor_output'] = loadTemplate('sponsor_welcome', TRUE, $content);
 
-//
+// [EOF]
 ?>