"); // Add navigation (with change box and colspan=3) if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $CONFIG['mails_page'], false, "3"); while ($pool = SQL_FETCHROW($result_list)) { // Unconfirmed mails and sent mails $result_uncon = SQL_QUERY_ESC("SELECT max_rec, clicks FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%d LIMIT 1", array(bigintval($pool[0])), __FILE__, __LINE__); list($sent, $clicks) = SQL_FETCHROW($result_uncon); SQL_FREERESULT($result_uncon); // Unconfirmed mails $unconfirmed = $sent - $clicks; if ($unconfirmed > 0) { // Add link to list_unconfirmed what-file $unconfirmed = "".$unconfirmed.""; } elseif ($unconfirmed < 0) { // Sometimes rarely displayed minus values will be "fixed" to zero $unconfirmed = "0"; } // List mail OUTPUT_HTML (""); } // Free memory SQL_FREERESULT($result_list); // Add navigation (without change box but with colspan=3) if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $CONFIG['mails_page'], false, "3"); // Output footer OUTPUT_HTML ("

".ADMIN_POOL_CONTENT." (".$WHO.")
".EMAIL_SENDER.": ".ADMIN_USER_PROFILE_LINK($pool[1])."	".EMAIL_SUBJECT.": ".COMPILE_CODE($pool[2])."	".EMAIL_TEXT.": ".COMPILE_CODE($pool[3])."
".EMAIL_PAYMENT.": ".GET_PAYMENT($pool[5])."	".EMAIL_CATEGORY.": ".GET_CATEGORY($pool[10])."
".EMAIL_RECEIVERS.": ".$sent." (".EMAIL_RUIDS.": ".str_replace(";", ", ", $pool[4]).")	".USERS_LINKS.": ".$unconfirmed."	".EMAIL_POOL_TYPE.": ".GET_POOL_TYPE($pool[6])."
".EMAIL_TSEND.": ".$pool[9]."	".EMAIL_URL.": ".EMAIL_URL_TEST."	".EMAIL_TIMESTAMP.": ".MAKE_DATETIME($pool[7], "0")."
".ADMIN_DELETE_NORMAL_MAIL."

"); // Calculate pages $PAGES = round(SQL_NUMROWS($result_bonus) / $CONFIG['mails_page'] + 0.5); // Add navigation (with change box and colspan=3) if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $CONFIG['mails_page'], true, "3"); // List emails while ($bonus = SQL_FETCHROW($result_bonus)) { // Unconfirmed mails $unconfirmed = $bonus[11] - $bonus[12]; if ($unconfirmed > 0) { // Add link to list_unconfirmed what-file $unconfirmed = "".$unconfirmed.""; } OUTPUT_HTML (""); } // Add navigation (without change box but with colspan=3) if ($PAGES > 1) ADD_EMAIL_NAV($PAGES, $CONFIG['mails_page'], false, "3"); // Output footer OUTPUT_HTML ("

".ADMIN_BONUS_CONTENT."
".EMAIL_SUBJECT.": ".$bonus[1]."	".EMAIL_TEXT.": ".$bonus[2]."
".EMAIL_POINTS.": ".$bonus[4]." ".POINTS."	".EMAIL_SECONDS.": ".$bonus[5]." ".SECS."	".EMAIL_CATEGORY.": ".GET_CATEGORY($bonus[9])."
".EMAIL_RECEIVERS.": ".$bonus[11]." (".EMAIL_RUIDS.": ".str_replace(";", ", ", $bonus[3]).")	".USERS_LINKS.": ".$unconfirmed."	".EMAIL_POOL_TYPE.": ".GET_POOL_TYPE($bonus[6])."
".EMAIL_TSEND.": ".$bonus[10]."	".EMAIL_URL.": ".EMAIL_URL_TEST."	".EMAIL_TIMESTAMP.": ".MAKE_DATETIME($bonus[7], "0")."
".ADMIN_DELETE_BONUS_MAIL."