2 /************************************************************************
3 * MXChange v0.2.1 Start: 06/10/2005 *
4 * =============== Last change: 05/18/2008 *
6 * -------------------------------------------------------------------- *
7 * File : what-sponsor_infos.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Informations and prices for the sponsor *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Informationen/Preise fuer den Sponsoren *
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");
47 // Add description as navigation point
48 ADD_DESCR("guest", __FILE__);
50 // Init both results (see footer of this file)
54 // Load all sponsor actions
55 $result_act = SQL_QUERY("SELECT DISTINCT m.title, c.conv_rate, c.conv_name
56 FROM `{!_MYSQL_PREFIX!}_sponsor_menu` AS m
57 LEFT JOIN `{!_MYSQL_PREFIX!}_sponsor_action_convert` AS c ON m.what=c.ext_name
58 LEFT JOIN `{!_MYSQL_PREFIX!}_sponsor_registry` AS r ON m.what=r.ext_name
59 WHERE m.action='actions' AND r.is_active='Y'
60 ORDER BY m.sort ASC", __FILE__, __LINE__);
62 if (SQL_NUMROWS($result_act) > 0) {
64 $OUT_ACT = ""; $SW = 2;
65 while ($content = SQL_FETCHARRAY($result_act)) {
66 // Prepare data for the row template
67 // @TODO Rewritings: conv->conv_rate,name->conv_name in template
70 'title' => $content['title'],
71 'conv' => round($content['conv_rate']),
72 'name' => $content['conv_name'],
75 // Load row template and switch color
76 $OUT_ACT .= LOAD_TEMPLATE("guest_sponsor_act_row", true, $content);
80 // Check for pay types
81 $result_pay = SQL_QUERY("SELECT pay_name, pay_rate, pay_min_count, pay_currency FROM `{!_MYSQL_PREFIX!}_sponsor_paytypes` ORDER BY pay_name", __FILE__, __LINE__);
82 if (SQL_NUMROWS($result_pay) > 0) {
84 $OUT_PAY = ""; $SW = 2;
85 while ($content = SQL_FETCHARRAY($result_pay)) {
86 // Prepare data for the row template
87 // @TODO Rewritings: name->pay_name,min->pay_min_count,min->pay_min_count,curr->pay_currency
90 'name' => $content['pay_name'],
91 'rate' => TRANSLATE_COMMA($content['pay_rate']),
92 'min' => $content['pay_min_count'],
93 'curr' => $content['pay_currency'],
94 'price' => TRANSLATE_COMMA($content['pay_min_count']),
97 // Load row template and switch color
98 $OUT_PAY .= LOAD_TEMPLATE("guest_sponsor_pay_row", true, $content);
102 // No pay types setuped so far!
103 $OUT_PAY = LOAD_TEMPLATE("guest_sponsor_infos_none_row", LOAD_TEMPLATE("admin_settings_saved", true, getMessage('SPONSOR_NO_ACTIONS_ACTIVATED')));
106 // No actions activated so far!
107 $OUT_ACT = LOAD_TEMPLATE("guest_sponsor_infos_none_row", LOAD_TEMPLATE("admin_settings_saved", true, getMessage('SPONSOR_NO_ACTIONS_ACTIVATED')));
108 $OUT_PAY = LOAD_TEMPLATE("guest_sponsor_infos_none_row", LOAD_TEMPLATE("admin_settings_saved", true, getMessage('SPONSOR_NO_ACTIONS_ACTIVATED')));
112 SQL_FREERESULT($result_act);
113 SQL_FREERESULT($result_pay);
115 // Transfer rows to an array
117 'actions' => $OUT_ACT,
118 'paytypes' => $OUT_PAY
121 // Load main template
122 LOAD_TEMPLATE("guest_sponsor_infos", false, $content);