* -------------------------------------------------------------------- *
* Kurzbeschreibung : Statistik ueber gesendete Mails *
* -------------------------------------------------------------------- *
* -------------------------------------------------------------------- *
* Kurzbeschreibung : Statistik ueber gesendete Mails *
* -------------------------------------------------------------------- *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2008 by Roland Haeder *
* For more information visit: http://www.mxchange.org *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2008 by Roland Haeder *
* For more information visit: http://www.mxchange.org *
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
// Load waiting/pending orders
$result = SQL_QUERY_ESC("SELECT id, cat_id, payment_id, subject, url, timestamp, target_send, data_type, zip
// Load waiting/pending orders
$result = SQL_QUERY_ESC("SELECT id, cat_id, payment_id, subject, url, timestamp, target_send, data_type, zip
WHERE sender=%s AND data_type != 'SEND'
ORDER BY timestamp DESC",
WHERE sender=%s AND data_type != 'SEND'
ORDER BY timestamp DESC",
while ($data = SQL_FETCHARRAY($result)) {
// Is the ZIP code set? If not, set dashes
if (empty($data['zip'])) $data['zip'] = "---";
while ($data = SQL_FETCHARRAY($result)) {
// Is the ZIP code set? If not, set dashes
if (empty($data['zip'])) $data['zip'] = "---";
'cat' => GET_CATEGORY($data['cat_id']),
'pay' => GET_PAYMENT($data['payment_id']),
'subj' => COMPILE_CODE($data['subject']),
'url' => DEREFERER($data['url']),
'cat' => GET_CATEGORY($data['cat_id']),
'pay' => GET_PAYMENT($data['payment_id']),
'subj' => COMPILE_CODE($data['subject']),
'url' => DEREFERER($data['url']),
'recs' => $data['target_send'],
'type' => TRANSLATE_POOL_TYPE($data['data_type']),
'recs' => $data['target_send'],
'type' => TRANSLATE_POOL_TYPE($data['data_type']),
// Load sent orders
// 0 1 2 3 4 5 6 7 8
$result = SQL_QUERY_ESC("SELECT id, cat_id, payment_id, subject, url, timestamp_ordered, max_rec, timestamp_send, clicks
// Load sent orders
// 0 1 2 3 4 5 6 7 8
$result = SQL_QUERY_ESC("SELECT id, cat_id, payment_id, subject, url, timestamp_ordered, max_rec, timestamp_send, clicks
'pay' => GET_PAYMENT($data[2]),
'subj' => COMPILE_CODE($data[3]),
'url' => DEREFERER($data[4]),
'pay' => GET_PAYMENT($data[2]),
'subj' => COMPILE_CODE($data[3]),
'url' => DEREFERER($data[4]),