// Main query
$result_main = SQL_QUERY("SELECT
- `id`, `sender` AS `sender_userid`, `subject`, `text`, `receivers`,
- `payment_id`, `timestamp`, `url`, `target_send`, `cat_id`
+ `id`,`sender` AS `sender_userid`,`subject`,`text`,`receivers`,
+ `payment_id`,`timestamp`,`url`,`target_send`,`cat_id`
".$HTML."
FROM
`{?_MYSQL_PREFIX?}_pool`
// No users left
$receivers = array(0);
}
- $dummy = $receivers;
+ $temporaryReceivers = $receivers;
// Now, if we are good little boys and girls Santa Claus left us some user-ids.
// We can now send mails to them...
//* DEBUG: */ debugOutput('!L:'.__LINE__.'/'.SQL_NUMROWS($result_stats).'!');
if (SQL_HASZERONUMS($result_stats)) {
// No entry was found, so we add him!
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_stats` (`pool_id` , `userid`, `cat_id`, `payment_id`, `subject`, `url` , `max_rec` , `timestamp_ordered`, `timestamp_sstart`) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s' , UNIX_TIMESTAMP())",
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_stats` (`pool_id` , `userid`,`cat_id`,`payment_id`,`subject`,`url` , `max_rec` , `timestamp_ordered`,`timestamp_sstart`) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s' , UNIX_TIMESTAMP())",
array(bigintval($mailData['id']), bigintval($mailData['sender_userid']), bigintval($mailData['cat_id']), bigintval($mailData['payment_id']), $mailData['subject'], $mailData['url'], $mailData['target_send'], bigintval($mailData['timestamp'])), __FILE__, __LINE__);
// Receive it's id for the links table
list($stats_id) = SQL_FETCHROW($result_stats);
// Remove receiver from list
- $status = removeReceiver($dummy, $key, bigintval($userid), bigintval($mailData['id']), bigintval($stats_id));
+ $status = removeReceiver($temporaryReceivers, $key, bigintval($userid), bigintval($mailData['id']), bigintval($stats_id));
- //* DEBUG: */ debugOutput('?L:'.__LINE__.'/'.$dummy.'/'.$key.'/'.$userid.'('.['sender_userid'].')/'.$mailData['id'].'/'.$stats_id.'?');
+ //* DEBUG: */ debugOutput('?L:'.__LINE__.'/'.$temporaryReceivers.'/'.$key.'/'.$userid.'('.['sender_userid'].')/'.$mailData['id'].'/'.$stats_id.'?');
switch ($status) {
case 'done':
// Prepare the mail
if ($GLOBALS['pool_cnt'] <= $mailData['target_send']) $add = ", target_send=target_send-".$GLOBALS['pool_cnt'];
SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_pool` SET `data_type`='NEW', receivers='%s'" . $add . " WHERE `id`=%s LIMIT 1",
array(
- implode(';', $dummy),
+ implode(';', $temporaryReceivers),
bigintval($mailData['id'])
), __FILE__, __LINE__);
}
// Remove entry from list
- unset($dummy[$key]);
+ unset($temporaryReceivers[$key]);
// Update receivers
SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_pool` SET `receivers`='%s' WHERE `id`=%s LIMIT 1",
- array(implode(';', $dummy), bigintval($mailData['id'])), __FILE__, __LINE__);
+ array(implode(';', $temporaryReceivers), bigintval($mailData['id'])), __FILE__, __LINE__);
}
} // END - foreach
} // END - if