// Check for mails
$result_main = SQL_QUERY("SELECT
- `id`,`sender`,`subject`,`payment_id` AS `payment`,`timestamp`,`url`,`target_send`,`cat_id` AS category
+ `id`, `sender`, `subject`, `payment_id`, `timestamp`, `url`, `target_send`, `cat_id`
FROM
`{?_MYSQL_PREFIX?}_pool`
WHERE
$OUT = ''; $SW = 2;
while ($content = SQL_FETCHARRAY($result_main)) {
// Prepare data for the template
- $content = array(
- 'sw' => $SW,
- 'id' => $content['id'],
- 'sender' => $content['sender'],
- 'u_link' => generateUserProfileLink($content['sender']),
- 'subject' => $content['subject'],
- 'tester' => generateFrametesterUrl($content['url']),
- 'url' => $content['url'],
- 'cat_title' => str_replace('"', '"', getCategory($content['category'])),
- 'cat_link' => $content['category'],
- 'pay_title' => str_replace('"', '"', getPaymentTitlePrice($content['payment'], true)),
- 'pay_link' => $content['payment'],
- 'timestamp' => generateDateTime($content['timestamp'], 2),
- 'target_send' => $content['target_send'],
- );
+ $content['sw'] = $SW;
+ $content['timestamp'] = generateDateTime($content['timestamp'], 2);
// Load row template and switch colors
$OUT .= loadTemplate('admin_unlock_emails_row', true, $content);