- 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&what=list_doubler&mode=already&select=ref\">".$cnt."</a>");
- }
- define('__DOUBLER_ALREADY_ALL_LINK', "<a href=\"{!URL!}/modules.php?module=admin&what=list_doubler&mode=already&select=all\">".$SUM_ALREADY."</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&what=list_doubler&mode=already&select=ref\">".$cnt."</a>");
+ }
+ define('__DOUBLER_ALREADY_ALL_LINK', "<a href=\"{!URL!}/modules.php?module=admin&what=list_doubler&mode=already&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);