$SQL = ""; $MODE = "";
// Shall I sent activation or deactivation mail?
-$SQL = "SELECT userid, email FROM `"._MYSQL_PREFIX."_user_data` WHERE (beg_ral_notify ";
+$SQL = "SELECT userid, email FROM `{!MYSQL_PREFIX!}_user_data` WHERE (beg_ral_notify ";
switch (getConfig('beg_rallye'))
{
case "Y": // Begging rallye is activated
// Okay lets notify all users!
while(list($uid, $email) = SQL_FETCHROW($result_main)) {
// Update account
- $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data
-SET beg_ral_notify='%s', beg_ral_%s_notify='%s' WHERE userid=%s LIMIT 1",
- array(time(), $MODE, time(), $uid), __FILE__, __LINE__);
+ SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_data`
+SET beg_ral_notify='%s', beg_ral_%s_notify='%s'
+WHERE userid=%s
+LIMIT 1",
+ array(time(), $MODE, time(), $uid), __FILE__, __LINE__);
// Load email template and send it to the user!
if ($MAIL_MODE) {
$RECEIVER = implode(";", $UIDs);
// Prepare URL
- $url = URL."/modules.php?module=index&what=login";
+ $URL = "modules.php?module=index&what=login";
// Insert mail
- ADD_BONUS_MAIL_TO_QUEUE($SUBJECT, $MSG, $RECEIVER, getConfig('beg_notify_bonus'), getConfig('beg_notify_wait'), $url, 0, "normal", SQL_NUMROWS($result_main));
+ ADD_BONUS_MAIL_TO_QUEUE($SUBJECT, $MSG, $RECEIVER, getConfig('beg_notify_bonus'), getConfig('beg_notify_wait'), $URL, 0, "normal", SQL_NUMROWS($result_main));
} // END - if
} // END - if