A lot while() conditions rewritten to SQL_FETCHARRAY(), see bug #107, @TODO tags...
[mailer.git] / inc / libs / payout_functions.php
1 <?php
2 /************************************************************************
3  * MXChange v0.2.1                                    Start: 10/19/2003 *
4  * ===============                              Last change: 08/12/2004 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : what-points.php                                  *
8  * -------------------------------------------------------------------- *
9  * Short description : All your collected points...                     *
10  * -------------------------------------------------------------------- *
11  * Kurzbeschreibung  : Alle Ihrer gesammelten Punkte                    *
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, or    *
21  * (at your option) any later version.                                  *
22  *                                                                      *
23  * This program is distributed in the hope that it will be useful,      *
24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
26  * GNU General Public License for more details.                         *
27  *                                                                      *
28  * You should have received a copy of the GNU General Public License    *
29  * along with this program; if not, write to the Free Software          *
30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
31  * MA  02110-1301  USA                                                  *
32  ************************************************************************/
33
34 // Some security stuff...
35 if (!defined('__SECURITY')) {
36         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
37         require($INC);
38 }
39
40 //
41 function PAYOUT_OUTPUT_PAYOUT_LIST ($points) {
42         // Replace german decimal comma with CPU's decimal dot
43         $points = REVERT_COMMA($points);
44
45         // Enougth points?
46         if ($points > 0) {
47                 // Pay this out!
48                 $result = SQL_QUERY_ESC("SELECT id, type, rate, min_points
49 FROM `{!_MYSQL_PREFIX!}_payout_types`
50 WHERE %s >= min_points
51 ORDER BY type", array($points), __FUNCTION__, __LINE__);
52                 if (SQL_NUMROWS($result) > 0) {
53                         OUTPUT_HTML("<br /><div align=\"center\">
54 <div align=\"center\"><strong>{--PAYOUT_NOW--}:</strong></div><br />
55 <ul>");
56                         // Now let's check
57                         while ($content = SQL_FETCHARRAY($result)) {
58                                 // Compile the type
59                                 $content['type'] = COMPILE_CODE($content['type']);
60
61                                 // Are these points enougth?
62                                 if ($points >= $content['min_points']) {
63                                         // Ok we found one
64                                         $P = $points * $content['rate'] - 0.5;
65                                         OUTPUT_HTML("<li>{--PAYOUT_IN--}: <strong><a href=\"{!URL!}/modules.php?module=login&amp;what=payout&amp;payout=".$content['id']."\">".$content['type']." ({--PAYOUT_MAX--} ".round($P)." ".$content['type'].")</a></strong></li>");
66                                 } // END - if
67                         } // END - while
68
69                         OUTPUT_HTML("</ul></div>");
70                 } else {
71                         // No payout types setup so far
72                         LOAD_TEMPLATE("admin_settings_saved", false, "<div class=\"guest_failed\">{--PAYOUT_NO_PAYOUT_TYPES--}</div");
73                 }
74
75                 // Free memory
76                 SQL_FREERESULT($result);
77         } else {
78                 // Points is empty
79                 LOAD_TEMPLATE("admin_settings_saved", false, "<div class=\"guest_failed\">{--PAYOUT_NO_POINTS_ENTERED--}</div");
80         }
81 }
82
83 // [EOF]
84 ?>