2 /************************************************************************
3 * MXChange v0.2.1 Start: 09/17/2005 *
4 * =============== Last change: 05/19/2008 *
6 * -------------------------------------------------------------------- *
8 * -------------------------------------------------------------------- *
9 * Short description : Welcome page for sponsor area *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Willkommensseite des Sponsorenbereiches *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * Needs to be in all Files and every File needs "svn propset *
18 * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
19 * -------------------------------------------------------------------- *
20 * Copyright (c) 2003 - 2008 by Roland Haeder *
21 * For more information visit: http://www.mxchange.org *
23 * This program is free software. You can redistribute it and/or modify *
24 * it under the terms of the GNU General Public License as published by *
25 * the Free Software Foundation; either version 2 of the License. *
27 * This program is distributed in the hope that it will be useful, *
28 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
29 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
30 * GNU General Public License for more details. *
32 * You should have received a copy of the GNU General Public License *
33 * along with this program; if not, write to the Free Software *
34 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
36 ************************************************************************/
38 // Some security stuff...
39 if (!defined('__SECURITY')) {
40 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
42 } elseif ((!EXT_IS_ACTIVE("sponsor"))
43 addFatalMessage(__FILE__, __LINE__, getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "sponsor");
45 } elseif (!IS_SPONSOR()) {
47 addFatalMessage(__FILE__, __LINE__, getMessage('SPONSOR_ONLY_AREA_ENTERED'));
52 $result = SQL_QUERY_ESC("SELECT gender, surname, family, (points_amount - points_used) AS points
53 FROM `{!_MYSQL_PREFIX!}_sponsor_data`
54 WHERE id='%s' AND password='%s' LIMIT 1",
55 array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
56 list($gender, $surname, $family, $points) = SQL_FETCHROW($result);
59 SQL_FREERESULT($result);
61 // Prepare data for the template
62 define('__GENDER' , TRANSLATE_GENDER($gender));
63 define('__SURNAME', $surname);
64 define('__FAMILY' , $family);
65 define('__POINTS' , TRANSLATE_COMMA($points));
68 $OUT = LOAD_TEMPLATE("sponsor_welcome", true);