$SQL = ""; $MODE = "";
// Shall I sent activation or deactivation mail?
-$SQL = "SELECT userid, email FROM `{!MYSQL_PREFIX!}_user_data` WHERE (bonus_ral_notify ";
+$SQL = "SELECT userid, email FROM `{!_MYSQL_PREFIX!}_user_data` WHERE (bonus_ral_notify ";
switch (getConfig('bonus_active'))
{
case "Y": // Active rallye is activated
$result_main = SQL_QUERY($SQL, __FILE__, __LINE__);
if (SQL_NUMROWS($result_main) > 0) {
// Okay lets notify all users!
- while(list($uid, $email) = SQL_FETCHROW($result_main)) {
+ while (list($uid, $email) = SQL_FETCHROW($result_main)) {
// Update account
- SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_data`
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data`
SET bonus_ral_notify='%s', bonus_ral_%s_notify='%s'
WHERE userid=%s
LIMIT 1",