273b2c5c56a4ef3cf4509e0f4dc2d0319874aad3
[mailer.git] / inc / modules / sponsor / welcome.php
1 <?php
2 /************************************************************************
3  * MXChange v0.2.1                                    Start: 09/17/2005 *
4  * ===============                              Last change: 05/19/2008 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : welcome.php                                      *
8  * -------------------------------------------------------------------- *
9  * Short description : Welcome page for sponsor area                    *
10  * -------------------------------------------------------------------- *
11  * Kurzbeschreibung  : Willkommensseite des Sponsorenbereiches          *
12  * -------------------------------------------------------------------- *
13  *                                                                      *
14  * -------------------------------------------------------------------- *
15  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
16  * For more information visit: http://www.mxchange.org                  *
17  *                                                                      *
18  * This program is free software. You can redistribute it and/or modify *
19  * it under the terms of the GNU General Public License as published by *
20  * the Free Software Foundation; either version 2 of the License.       *
21  *                                                                      *
22  * This program is distributed in the hope that it will be useful,      *
23  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
24  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
25  * GNU General Public License for more details.                         *
26  *                                                                      *
27  * You should have received a copy of the GNU General Public License    *
28  * along with this program; if not, write to the Free Software          *
29  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
30  * MA  02110-1301  USA                                                  *
31  ************************************************************************/
32
33 // Some security stuff...
34 if (!defined('__SECURITY')) {
35         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
36         require($INC);
37 } elseif ((!EXT_IS_ACTIVE("sponsor"))
38         addFatalMessage(getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "sponsor");
39         return;
40 } elseif (!IS_SPONSOR()) {
41         // No sponsor!
42         addFatalMessage(getMessage('SPONSOR_ONLY_AREA_ENTERED'));
43         return;
44 }
45
46 // Load some data
47 $result = SQL_QUERY_ESC("SELECT gender, surname, family, (points_amount - points_used) AS points
48 FROM `{!_MYSQL_PREFIX!}_sponsor_data`
49 WHERE id='%s' AND password='%s' LIMIT 1",
50  array(bigintval(get_session('sponsorid')), get_session('sponsorpass')), __FILE__, __LINE__);
51 list($gender, $surname, $family, $points) = SQL_FETCHROW($result);
52
53 // Free memory
54 SQL_FREERESULT($result);
55
56 // Prepare data for the template
57 define('__GENDER'  , TRANSLATE_GENDER($gender));
58 define('__SURNAME', $surname);
59 define('__FAMILY' , $family);
60 define('__POINTS' , TRANSLATE_COMMA($points));
61
62 // Load main template
63 $OUT = LOAD_TEMPLATE("sponsor_welcome", true);
64
65 //
66 ?>