0) { // Mail orders are in pool so we can display them OUTPUT_HTML("
"); // 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."
"); $MAIL = true; if ((EXT_IS_ACTIVE("bonus")) && ($WHO == _ALL)) { // Check only if bonus extension is active if (SQL_NUMROWS($result_bonus) > 0) OUTPUT_HTML("

"); } } if ((EXT_IS_ACTIVE("bonus")) && ($WHO == _ALL)) { // Load bonus mails only when extension is active if (SQL_NUMROWS($result_bonus) > 0) { // Mail orders are in pool so we can display them OUTPUT_HTML("
"); // 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."
"); $MAIL = true; } } if (!$MAIL) { // No mail orders fond OUTPUT_HTML("".ADMIN_NO_MAILS_IN_POOL.""); } // ?>