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__);
+ $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);
$SUM_ALREADY += $cnt;
define('__DOUBLER_ALREADY_DIRECT_LINK', "<a href=\"".URL."/modules.php?module=admin&what=list_doubler&mode=already&select=direct\">".$cnt."</a>");
}
- $result = SQL_QUERY("SELECT COUNT(id) FROM "._MYSQL_PREFIX."_doubler WHERE completed='Y' AND is_ref='Y'", __FILE__, __LINE__);
+ $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);
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__);
+ $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);
$SUM_WAITING += $cnt;
define('__DOUBLER_WAITING_DIRECT_LINK', "<a href=\"".URL."/modules.php?module=admin&what=list_doubler&mode=waiting&select=direct\">".$cnt."</a>");
}
- $result = SQL_QUERY("SELECT COUNT(id) FROM "._MYSQL_PREFIX."_doubler WHERE completed='N' AND is_ref='Y'", __FILE__, __LINE__);
+ $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);