- $result = SQL_QUERY("SELECT id, price, payment, mail_title FROM `{!_MYSQL_PREFIX!}_payments` ORDER BY payment", __FILE__, __LINE__);
-
- $typeS = array();
- if (SQL_NUMROWS($result) > 0) {
- // Check for message ID in URL
- $MSG = "";
- switch ($_GET['msg'])
- {
- case constant('CODE_URL_TLOCK'):
- $result = SQL_QUERY_ESC("SELECT timestamp FROM `{!_MYSQL_PREFIX!}_pool` WHERE id=%s LIMIT 1",
- array(bigintval($_GET['id'])), __FILE__, __LINE__);
-
- // Load timestamp from last order
- list($LORDER) = SQL_FETCHROW($result);
- $LORDER = MAKE_DATETIME($LORDER, "1");
-
- // Free memory
- SQL_FREERESULT($result);
-
- // Calculate hours...
- $STD = round(getConfig('url_tlock') / 60 / 60);
-
- // Minutes...
- $MIN = round((getConfig('url_tlock') - $STD * 60 * 60) / 60);
-
- // And seconds
- $SEC = getConfig('url_tlock') - $STD * 60 * 60 - $MIN * 60;
-
- // Finally contruct the message
- // @TODO Rewrite this old lost code to a template
- $MSG = "{--MEMBER_URL_TIME_LOCK--}<br />{--CONFIG_URL_TLOCK--} ".$STD."
- {--_HOURS--}, ".$MIN." {--_MINUTES--} {--_AND--} ".$SEC." {--_SECONDS--}<br />
- {--MEMBER_LAST_TLOCK--}: ".$LORDER;
- break;
-
- case constant('CODE_OVERLENGTH'):
- $MSG = getMessage('MEMBER_TEXT_OVERLENGTH');
- break;
-
- case constant('CODE_URL_FOUND'):
- $MSG = getMessage('MEMBER_TEXT_CONTAINS_URL');
- break;
-
- case constant('CODE_SUBJ_URL'):
- $MSG = getMessage('MEMBER_SUBJ_CONTAINS_URL');
- break;
-
- case constant('CODE_BLIST_URL'):
- $MSG = "{--MEMBER_URL_BLACK_LISTED--}<br />\n{--MEMBER_BLIST_TIME--}: ".MAKE_DATETIME($_GET['blist'], "0");
- break;
-
- case constant('CODE_NO_RECS_LEFT'):
- $MSG = getMessage('MEMBER_SELECTED_MORE_RECS');
- break;
-
- case constant('CODE_INVALID_TAGS'):
- $MSG = getMessage('MEMBER_HTML_INVALID_TAGS');
- break;
-
- case constant('CODE_MORE_POINTS'):
- $MSG = getMessage('MEMBER_MORE_POINTS_NEEDED');
- break;
-
- case constant('CODE_MORE_RECEIVERS1'):
- $MSG = getMessage('MEMBER_ENTER_MORE_RECEIVERS');
- break;
-
- case constant('CODE_MORE_RECEIVERS2'):
- $MSG = getMessage('MEMBER_NO_MORE_RECEIVERS_FOUND');
- break;
-
- case constant('CODE_MORE_RECEIVERS3'):
- $MSG = "{--MEMBER_ENTER_MORE_MIN_RECEIVERS_1--}".getConfig('order_min')."{--MEMBER_ENTER_MORE_MIN_RECEIVERS_2--}";
- break;
-
- case constant('CODE_INVALID_URL'):
- $MSG = getMessage('MEMBER_ENTER_INVALID_URL');
- break;
-
- case "": // When no error code is included in the URL we do not need to output an error message as well...
- break;
-
- default:
- DEBUG_LOG(__FILE__, __LINE__, sprintf("Unknown error code %s detected.", $_GET['msg']));
- $MSG = "{--UNKNOWN_CODE_1--}".$_GET['msg']."{--UNKNOWN_CODE_2--}";
- break;
- }
-
- if (!empty($MSG)) {
- // We got system message so we drop it out to the user
- LOAD_TEMPLATE("admin_settings_saved", false, $MSG);