$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