function InitializeAdminTemplate($tpl, $type, $page_title) { $rights = User::GetUserRights($_SESSION['user_id']); $tpl->assign('rights', $rights); $tpl->assign('session_user_id', $_SESSION['user_id']); $tpl->assign('type', $type); $tpl->assign('total', Functions::GetTotalRec()); $tpl->assign('day', Functions::GetRecSum(1)); $tpl->assign('week', Functions::GetRecSum(7)); $tpl->assign('month', Functions::GetRecSum(31)); #$tpl->assign('my_obj_day', Functions::GetRecSum(1,1)); $tpl->assign('my_new_flats', Functions::GetRecSumObjType(1, 1, 'flats')); $tpl->assign('my_new_houses', Functions::GetRecSumObjType(1, 1, 'houses')); $tpl->assign('usersonline', User::GetUserOnline()); $tpl->assign('message_all', Functions::GetMessage(1)); $tpl->assign('message_new', Functions::GetMessage(0)); $tpl->assign('my_client_flats_day', Functions::GetClientCnt(1, 'flats')); $tpl->assign('my_client_houses_day', Functions::GetClientCnt(1, 'houses')); $tpl->assign('page_title', $page_title); if ($rights['profiles_manager']) { $tpl->assign('cnt_obj_my_agents', Functions::GetCntObjMyAgents()); } $usr = $rights['profiles_agent'] || $rights['profiles_manager'] ? $_SESSION['user_id'] : 0; $tpl->assign('cnt_error_obj', Functions::GetErrorObject(2, $usr)); $link = dbh::connect(); $sql_order = "SELECT * FROM `nasledie`.`usersmessages` WHERE `to` = '" . $_SESSION['user_id'] . "' OR `from` = '" . $_SESSION['user_id'] . "' GROUP BY `from`,`to`"; $friends = array(); $result = mysql_query($sql_order); while ($row = mysql_fetch_array($result)) { if ($row['from'] == $_SESSION['user_id']) { $friends[] = $row['to']; } else { $friends[] = $row['from']; } } $friends = array_unique($friends); $messages = array(); foreach ($friends as $friend) { $sql = "SELECT * FROM `nasledie`.`usersmessages` WHERE `from` IN ('" . $friend . "','" . $_SESSION['user_id'] . "') AND `to` IN ('" . $friend . "','" . $_SESSION['user_id'] . "') ORDER BY time"; $res = mysql_query($sql); $key = $_SESSION['user_id'] . '~' . $friend; while ($rowmess = mysql_fetch_array($res)) { $messages[$key][] = $rowmess; } } $tpl->assign("allmessages", $messages); $sql = "SELECT * FROM `nasledie`.`users` WHERE `id`='" . $_SESSION['user_id'] . "'"; $res = mysql_query($sql); $result = mysql_fetch_array($res); $names[$_SESSION['user_id']] = $result['name']; $avatars[$_SESSION['user_id']] = '/newadmin/images/users/' . $result['hash_file'] . '_p.' . $result['ext']; $sql = "SELECT * FROM `nasledie`.`users` WHERE `id`='" . $_GET['id'] . "'"; $res = mysql_query($sql); $result = mysql_fetch_array($res); $names[$_GET['id']] = $result['name']; $avatars[$_GET['id']] = '/newadmin/images/users/' . $result['hash_file'] . '_p.' . $result['ext']; $result = array(); $result['names'] = $names; $result['avatars'] = $avatars; $sql = "SELECT * FROM `nasledie`.`users` WHERE `id`='" . $_SESSION['user_id'] . "'"; $res = mysql_query($sql); $result = mysql_fetch_array($res); $names[$_SESSION['user_id']] = $result['name']; if (file_exists($_SERVER['DOCUMENT_ROOT'] . '/newadmin/images/users/' . $result['hash_file'] . '_p.' . $result['ext'])) { $avatars[$_SESSION['user_id']] = '/newadmin/images/users/' . $result['hash_file'] . '_p.' . $result['ext']; } else { $avatars[$_SESSION['user_id']] = '/newadmin/images/notimage.png'; } //$avatars[$_SESSION['user_id']] = '/newadmin/images/users/' . $result['hash_file'] . '_p.' . $result['ext']; $sql = "SELECT * FROM `nasledie`.`users` WHERE `id`='" . $_GET['id'] . "'"; $res = mysql_query($sql); $result = mysql_fetch_array($res); $names[$_GET['id']] = $result['name']; if (file_exists($_SERVER['DOCUMENT_ROOT'] . '/newadmin/images/users/' . $result['hash_file'] . '_p.' . $result['ext'])) { $avatars[$_GET['id']] = '/newadmin/images/users/' . $result['hash_file'] . '_p.' . $result['ext']; } else { $avatars[$_GET['id']] = '/newadmin/images/notimage.png'; } //$avatars[$_GET['id']] = '/newadmin/images/users/' . $result['hash_file'] . '_p.' . $result['ext']; $result = array(); $result['names'] = $names; $result['avatars'] = $avatars; $tpl->assign('friend', $_GET['id']); $tpl->assign('names', $names); $tpl->assign('avatars', $avatars); $tpl->assign("usermessages", User::TranslateUsers(User::GetUsersList())); }