Comments fixed, ext-network continued, fix for mod stats:
[mailer.git] / inc / modules / admin / what-list_doubler.php
index 675bc873f902976e1de750887743175a286da0a1..add9a8dfd566edd5d20511bfc8b6a96b7fc2c3e9 100644 (file)
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 02/12/2004 *
- * ================                             Last change: 02/12/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 02/12/2004 *
+ * ===================                          Last change: 02/12/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-list_doubler.php                            *
@@ -17,7 +17,7 @@
  * Needs to be in all Files and every File needs "svn propset           *
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  ************************************************************************/
 
 // Some security stuff...
-if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
-       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
-       require($INC);
-}
+if ((!defined('__SECURITY')) || (!isAdmin())) {
+       die();
+} // END - if
 
 // Add description as navigation point
-ADD_DESCR('admin', __FILE__);
+addMenuDescription('admin', __FILE__);
 
-if (!REQUEST_ISSET_GET(('mode'))) {
+if (!isGetRequestElementSet('mode')) {
        // Chosse the overview page as default
-       REQUEST_GET('mode', "overview");
+       setRequestGetElement('mode', 'overview');
 } else {
        // Set table title automatically
-       if (!REQUEST_ISSET_GET(('select'))) REQUEST_GET('select', "all");
-       $eval = "define('__ADMIN_DOUBLER_LIST_".strtoupper(REQUEST_GET('mode'))."', getMessage('ADMIN_DOUBLER_LIST_".strtoupper(REQUEST_GET('mode'))."_".strtoupper(REQUEST_GET('select'))."'));";
-       eval($eval);
+       if (!isGetRequestElementSet('select')) setRequestGetElement('select', 'all');
+
+       // Prepare header
+       $content['list_' . strtolower(getRequestElement('mode'))] = getMessage('ADMIN_DOUBLER_LIST_' . strtoupper(getRequestElement('mode')) . '_' . strtoupper(getRequestElement('select')).'');
 }
 
 // Load data for the template
-switch (REQUEST_GET('mode'))
-{
-case "already":  // Already payed out points
-       break;
-
-case "overview": // General overview page
-       $SUM_ALREADY = 0; $SUM_WAITING = 0;
-       // Number of direct already payouts and referal
-       $result = SQL_QUERY("SELECT COUNT(id) FROM `{!_MYSQL_PREFIX!}_doubler` WHERE completed='Y' AND is_ref='N'", __FILE__, __LINE__);
-       list($cnt) = SQL_FETCHROW($result);
-       SQL_FREERESULT($result);
-
-       if ((empty($cnt)) || ($cnt == "0"))
-       {
-               // Nothing payed out so far
-               define('__DOUBLER_ALREADY_DIRECT_LINK', "0");
-       }
-        else
-       {
-               // Something was payed out
-               $SUM_ALREADY += $cnt;
-               define('__DOUBLER_ALREADY_DIRECT_LINK', "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_doubler&amp;mode=already&amp;select=direct\">".$cnt."</a>");
-       }
-       $result = SQL_QUERY("SELECT COUNT(id) FROM `{!_MYSQL_PREFIX!}_doubler` WHERE completed='Y' AND is_ref='Y'", __FILE__, __LINE__);
-       list($cnt) = SQL_FETCHROW($result);
-       SQL_FREERESULT($result);
-
-       if ((empty($cnt)) || ($cnt == "0"))
-       {
-               // Nothing payed out so far
-               define('__DOUBLER_ALREADY_REF_LINK', "0");
-       }
-        else
-       {
-               // Something was payed out
-               $SUM_ALREADY += $cnt;
-               define('__DOUBLER_ALREADY_REF_LINK', "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_doubler&amp;mode=already&amp;select=ref\">".$cnt."</a>");
-       }
-       define('__DOUBLER_ALREADY_ALL_LINK', "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_doubler&amp;mode=already&amp;select=all\">".$SUM_ALREADY."</a>");
-
-       // And the same for waiting pouts (direct and referal)
-       $result = SQL_QUERY("SELECT COUNT(id) FROM `{!_MYSQL_PREFIX!}_doubler` WHERE completed='N' AND is_ref='N'", __FILE__, __LINE__);
-       list($cnt) = SQL_FETCHROW($result);
-       SQL_FREERESULT($result);
-
-       if ((empty($cnt)) || ($cnt == "0"))
-       {
-               // Nothing payed out so far
-               define('__DOUBLER_WAITING_DIRECT_LINK', "0");
-       }
-        else
-       {
-               // Something was payed out
-               $SUM_WAITING += $cnt;
-               define('__DOUBLER_WAITING_DIRECT_LINK', "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_doubler&amp;mode=waiting&amp;select=direct\">".$cnt."</a>");
-       }
-       $result = SQL_QUERY("SELECT COUNT(id) FROM `{!_MYSQL_PREFIX!}_doubler` WHERE completed='N' AND is_ref='Y'", __FILE__, __LINE__);
-       list($cnt) = SQL_FETCHROW($result);
-       SQL_FREERESULT($result);
-
-       if ((empty($cnt)) || ($cnt == "0"))
-       {
-               // Nothing payed out so far
-               define('__DOUBLER_WAITING_REF_LINK', "0");
-       }
-        else
-       {
-               // Something was payed out
-               $SUM_WAITING += $cnt;
-               define('__DOUBLER_WAITING_REF_LINK', "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_doubler&amp;mode=waiting&amp;select=ref\">".$cnt."</a>");
-       }
-       define('__DOUBLER_WAITING_ALL_LINK', "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_doubler&amp;mode=waiting&amp;select=all\">".$SUM_WAITING."</a>");
-
-       // All data is loaded here...
-       break;
-}
+switch (getRequestElement('mode')) {
+       case 'already':  // Already payed out points
+               break;
+
+       case 'overview': // General overview page
+               // Prepare links
+               foreach (array('already_direct','already_ref','waiting_direct','waiting_ref') as $entry) {
+                       $content[$entry . '_link'] = '0';
+               } // END - switch
+
+               // Init sums
+               $sumAlready = '0'; $sumWaiting = '0';
+
+               // Number of direct already payouts and referal
+               $cnt = countSumTotalData('Y','doubler','id','completed',true, " AND `is_ref`='N'");
+
+               if ($cnt > 0) {
+                       // Something was payed out
+                       $sumAlready += $cnt;
+                       $content['already_direct_link'] = "<a href=\"{?URL?}/modules.php?module=admin&amp;what=list_doubler&amp;mode=already&amp;select=direct\">".$cnt."</a>";
+               } // END - if
+
+               $cnt = countSumTotalData('Y','doubler','id','completed',true, " AND `is_ref`='Y'");
+
+               if ($cnt > 0) {
+                       // Something was payed out
+                       $sumAlready += $cnt;
+                       $content['already_ref_link'] = "<a href=\"{?URL?}/modules.php?module=admin&amp;what=list_doubler&amp;mode=already&amp;select=ref\">".$cnt."</a>";
+               } // END - if
+
+               // And the same for waiting pouts (direct and referal)
+               $cnt = countSumTotalData('N','doubler','id','completed',true, " AND `is_ref`='N'");
+
+               if ($cnt > 0) {
+                       // Something was payed out
+                       $sumWaiting += $cnt;
+                       $content['waiting_direct_link'] = "<a href=\"{?URL?}/modules.php?module=admin&amp;what=list_doubler&amp;mode=waiting&amp;select=direct\">".$cnt."</a>";
+               } // END - if
+
+               $cnt = countSumTotalData('N','doubler','id','completed',true, " AND `is_ref`='Y'");
+
+               if ($cnt > 0) {
+                       // Something was payed out
+                       $sumWaiting += $cnt;
+                       $content['waiting_ref_link'] = "<a href=\"{?URL?}/modules.php?module=admin&amp;what=list_doubler&amp;mode=waiting&amp;select=ref\">".$cnt."</a>";
+               } // END - if
+
+               // Links for all
+               $content['already_all_link'] = "<a href=\"{?URL?}/modules.php?module=admin&amp;what=list_doubler&amp;mode=already&amp;select=all\">".$sumAlready."</a>";
+               $content['waiting_all_link'] = "<a href=\"{?URL?}/modules.php?module=admin&amp;what=list_doubler&amp;mode=waiting&amp;select=all\">".$sumWaiting."</a>";
+
+               // All data is loaded here...
+               break;
+} // END - switch
 
 // Load mode template
-LOAD_TEMPLATE("admin_list_doubler_".REQUEST_GET('mode'));
+loadTemplate('admin_list_doubler_' . getRequestElement('mode'), false, $content);
 
-//
+// [EOF]
 ?>