- if (SQL_AFFECTEDROWS($link) == 1) {
- // Update his login data
- UPDATE_LOGIN_DATA();
-
- // Load personal data...
- $result = SQL_QUERY_ESC("SELECT sex, surname, family, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",
- array($GLOBALS['userid']), __FILE__, __LINE__);
- list($sex, $sname, $fname, $email) = SQL_FETCHROW($result);
- SQL_FREERESULT($result);
-
- // Load mail again... 0 1 2 3 4 5 6 7
- $result = SQL_QUERY_ESC("SELECT subject, text, receivers, payment_id, timestamp, url, cat_id, target_send FROM "._MYSQL_PREFIX."_pool WHERE id=%d AND sender=%d LIMIT 1",
- array(bigintval($_GET['order']), $GLOBALS['userid']), __FILE__, __LINE__);
- $DATA = SQL_FETCHROW($result);
+ if (SQL_AFFECTEDROWS() == 1) {
+ // @TODO Unused: 2,4
+ // Load mail again... 0 1 2 3 4 5 6 7
+ $result = SQL_QUERY_ESC("SELECT `subject`, `text`, `receivers`, `payment_id`, `timestamp`, `url`, `cat_id`, `target_send` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s AND `sender`=%s LIMIT 1",
+ array(bigintval(getRequestParameter('order')), getMemberId()), __FILE__, __LINE__);
+ $content = merge_array($content, SQL_FETCHARRAY($result));