$query = "\r\n(SELECT {$SNAME}_reply.date+" . GMT_TIME . " AS date, {$SNAME}_newmsg.sez, {$SNAME}_newmsg.EDIT_OF,{$SNAME}_newmsg.title\r\nFROM {$SNAME}_reply\r\nJOIN {$SNAME}_newmsg ON {$SNAME}_newmsg.EDIT_OF = {$SNAME}_reply.rep_of\r\nWHERE {$SNAME}_reply.autore = '{$hash}')\r\nUNION \r\n(SELECT {$SNAME}_newmsg.date+" . GMT_TIME . " AS date, {$SNAME}_newmsg.sez, {$SNAME}_newmsg.EDIT_OF, {$SNAME}_newmsg.title\r\nFROM {$SNAME}_newmsg\r\nWHERE {$SNAME}_newmsg.autore = '{$hash}')\r\nORDER BY date DESC \r\nLimit 1";
$last_data = $db->get_row($query);
/*
Struct User:
NULL may be filled a day.............
'' is fileld now. Do not remove pls
*/
$user = array('id' => $_GET['MEM_ID'], 'nick' => $pdata->AUTORE, 'surnick' => '', 'reg_date' => $pdata->reg_date, 'group' => array('text' => $pdata->title, 'image' => NULL), 'msg_num' => array('tot' => $pdata->msg_num, 'daily' => '', 'perc' => ''), 'msg_sez' => array('tot' => $sez_data['num_reply'], 'perc' => '', 'sez_id' => $sez_data['sez_id'], 'sez_name' => $sez_data['SEZ_NAME']), 'home' => '', 'avatar' => $pdata->avatar, 'sign' => $pdata->firma, 'icq' => NULL, 'msn' => NULL, 'email' => $pdata->email, 'location' => $pdata->provenienza, 'compleanno' => $pdata->nascita, 'online' => array('text' => '', 'image' => ''), 'last_action' => array('title' => $last_data->title, 'data' => $last_data->date, 'sez' => $last_data->sez, 'reply_id' => $last_data->EDIT_OF), 'extra' => $pdata->extra);
unset($pdata);
unset($sez_data);
unset($last_data);
//PREPROCESSING DATA
if (!$core) {
$core = new CoreSock();
}
$user['extra'] = $core->BinDump2Var($user['extra']);
//Securing data
$user['nick'] = secure_v($user['nick']);
$user['avatar'] = secure_v($user['avatar']);
$user['sign'] = secure_v($user['sign']);
$user['home'] = secure_v($user['home']);
$user['location'] = secure_v($user['location']);
$user['msg_sez']['sez_name'] = secure_v($user['msg_sez']['sez_name']);
$user['last_action']['title'] = $user['last_action']['title'] ? secure_v($user['last_action']['title']) : '(untitled)';
//array_walk($user,secure_v);
//Default data
$user['group']['text'] = $user['group']['text'] ? $user['group']['text'] : 'membri';
$user['avatar'] = $user['avatar'] ? "<div><img src='{$user['avatar']}' border='0' alt='avatar' /></div>" : '';
//Default avatar?::NULL
$user['email'] = $user['email'] ? "<a href='mailto:{$user['email']}'>{$user['email']}</a>" : NULL;
//Default email
