X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_doubler.php;h=add9a8dfd566edd5d20511bfc8b6a96b7fc2c3e9;hp=6ba8c6ddc84d817b3718950d240d640a005f6048;hb=e2148142f8b1a8f40fd6e7ca32185569c5a9083e;hpb=66b91ce490ab549425619c95fc12086e126d541b diff --git a/inc/modules/admin/what-list_doubler.php b/inc/modules/admin/what-list_doubler.php index 6ba8c6ddc8..add9a8dfd5 100644 --- a/inc/modules/admin/what-list_doubler.php +++ b/inc/modules/admin/what-list_doubler.php @@ -1,7 +1,7 @@ 0) { // Something was payed out - $SUM_ALREADY += $cnt; - define('__DOUBLER_ALREADY_DIRECT_LINK', "".$cnt.""); - } - - $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', "".$cnt.""); - } - define('__DOUBLER_ALREADY_ALL_LINK', "".$SUM_ALREADY.""); - - // 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', "".$cnt.""); - } - - $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', "".$cnt.""); - } - define('__DOUBLER_WAITING_ALL_LINK', "".$SUM_WAITING.""); - - // All data is loaded here... - break; -} + $sumAlready += $cnt; + $content['already_direct_link'] = "".$cnt.""; + } // 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'] = "".$cnt.""; + } // 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'] = "".$cnt.""; + } // 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'] = "".$cnt.""; + } // END - if + + // Links for all + $content['already_all_link'] = "".$sumAlready.""; + $content['waiting_all_link'] = "".$sumWaiting.""; + + // 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] ?>