- $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 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($_CONFIG['url_tlock'] / 60 / 60);
-
- // Minutes...
- $MIN = round(($_CONFIG['url_tlock'] - $STD * 60 * 60) / 60);
-
- // And seconds
- $SEC = $_CONFIG['url_tlock'] - $STD * 60 * 60 - $MIN * 60;
-
- // Finally contruct the message
- $MSG = MEMBER_URL_TIME_LOCK."<br />".CONFIG_URL_TLOCK." ".$STD." ".
- _HOURS.", ".$MIN." "._MINUTES." "._AND." ".$SEC." "._SECONDS."<br />".
- MEMBER_LAST_TLOCK.": ".$LORDER;
- break;
-
- case CODE_OVERLENGTH:
- $MSG = MEMBER_TEXT_OVERLENGTH;
- break;
-
- case CODE_URL_FOUND:
- $MSG = MEMBER_TEXT_CONTAINS_URL;
- break;
-
- case CODE_SUBJ_URL:
- $MSG = MEMBER_SUBJ_CONTAINS_URL;
- break;
-
- case CODE_BLIST_URL:
- $MSG = MEMBER_URL_BLACK_LISTED."<br />
-".MEMBER_BLIST_TIME.": ".MAKE_DATETIME($_GET['blist'], "0");
- break;
-
- case CODE_NO_RECS_LEFT:
- $MSG = MEMBER_SELECTED_MORE_RECS;
- break;
-
- case CODE_INVALID_TAGS:
- $MSG = MEMBER_HTML_INVALID_TAGS;
- break;
-
- case CODE_MORE_POINTS:
- $MSG = MEMBER_MORE_POINTS_NEEDED;
- break;
-
- case CODE_MORE_RECEIVERS1:
- $MSG = MEMBER_ENTER_MORE_RECEIVERS;
- break;
-
- case CODE_MORE_RECEIVERS2:
- $MSG = MEMBER_NO_MORE_RECEIVERS_FOUND;
- break;
-
- case CODE_MORE_RECEIVERS3:
- $MSG = MEMBER_ENTER_MORE_MIN_RECEIVERS_1.$_CONFIG['order_min'].MEMBER_ENTER_MORE_MIN_RECEIVERS_2;
- break;