".(($_SESSION['admin']['id']!=2)?"Æàëîáû (".$j[0]."/".$j_no[0].")":"")." Âîïðîñû (".$v[0]."/".$v_no[0].") Âñå

"; if ((isset($_POST["send"])) && ($_POST["send"] == "ok")) { // Äîáàâëÿåì ïîëüçîâàòåëÿ $sql = sprintf("INSERT INTO zlo_users_message (`date`, `from`, `to`, `text`, `status`, `type`) VALUES (NOW(), %s, %s, %s, 3, '".trim(@$_REQUEST['toz'])."') ", GetSQLValueString($_SESSION['admin']['id'], "text"), GetSQLValueString($_GET['user'], "text"), GetSQLValueString($_POST['text'], "text")); $result = mysql_query($sql) or die(mysql_error()); if(trim(@$_REQUEST['pid'])!='') $piddddddrrr = trim(@$_REQUEST['pid']); else $piddddddrrr = mysql_insert_id(); $sql = "INSERT INTO links (`main`,`chil`,`type`,`uid`) VALUES ('".$piddddddrrr."','".mysql_insert_id()."','".trim(@$_REQUEST['toz'])."','".trim($_GET['user'])."');"; $result0 = mysql_query($sql) or die(mysql_error()); // Øëåì ïèñüìà eMailing('MessageToUser', $_GET['user']); echo ""; } if ((isset($_GET["action"])) && ($_GET["action"] == "del")) { if($_SESSION['admin']['group']=="1" || $_SESSION['admin']['id']=='6'){ $sql = "DELETE FROM zlo_users_message WHERE id='".$_GET['message']."'"; $result = mysql_query($sql) or die(mysql_error()); } echo ""; } // ============================== // ========== Âûâîä ============= // ============================== // ============= // ==== All ==== // ============= if (!isset($_GET["action"])) { echo"
"; // Âûâîä message $tttttt = ""; if(trim(@$_REQUEST['them'])!="") $tttttt = " WHERE `type`='".trim(@$_REQUEST['them'])."'"; $sql0 = "SELECT DISTINCT main FROM `links`".$tttttt." ORDER BY `main` DESC"; $pager['sql']= $sql0; $pager = pagerGetRun($pager,30,15); $result0 = mysql_query($pager['sql']) or die(mysql_error()); while ($message0=mysql_fetch_assoc($result0)){ $sql1 = "SELECT * FROM `links` WHERE `main`='".$message0['main']."' ORDER BY `id` ASC;"; $result1 = mysql_query($sql1) or die(mysql_error()); $elmario = 0; while ($message1=mysql_fetch_assoc($result1)){ $sql = "SELECT * FROM zlo_users_message WHERE `id`='".$message1['chil']."' ORDER BY `date` DESC"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { $i=0; $j=0; $elmario++; while ($message=mysql_fetch_assoc($result)) { $i++; $j++; $afa=""; if($elmario >1) $afa = "padding-left:40px;"; echo "
"; if ($message['status']==1) { $unread='unread-by-admin'; $unread2='unread'; } elseif ($message['status']==3) { $unread='unread-by-user'; } else { $unread=''; $unread2='';} if ($j==2) { $marked='marked'; } else { $marked=''; } echo""; echo""; echo""; echo""; echo""; if (strlen($message['text']) > 40 ) { $message['text']=substr(strip_tags($message['text']),0,40)."...";} echo""; echo""; // *********************** if ($j==2) { $j=0;} echo""; echo"
$i".date("d-m-Y h:i:s",strtotime($message['date']))."".(($message['from']==7)?"".viewBook('zlo_users', $message['from'], 'id', 'username')."":viewBook('zlo_users', $message['from'], 'id', 'username'))."".$message['text'].""; echo""; // ***** Àäìèí ðåæèì ***** if (isset($_SESSION['admin']['edit']) || $_SESSION['admin']['group']=='4') { if($message['from']!=$_SESSION['admin']['id']) { // îòïèñàòü echo""; } } echo""; // ***** Àäìèí ðåæèì ***** if (isset($_SESSION['admin']['edit'])) { // óäàëåíèå if($_SESSION['admin']['group']=="1" || $_SESSION['admin']['id']=='6') echo"
"; } echo"
"; } }} } // === Pager echo"
".str_replace("page","?them=".trim(@$_REQUEST['them'])."&page",pagerGetShow($pager))."
"; echo"
"; } // ============= // ====show ==== // ============= if ((isset($_GET["action"])) && ($_GET["action"] == "show")) { // Èçìåíÿåì ñòàòóñ íà "ïðî÷èòàíî" $sql = "SELECT `from` FROM zlo_users_message WHERE id='".$_GET['message']."'"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { $i=0; $j=0; $message_from=mysql_fetch_assoc($result); } if ($message_from['from']!=1) { // $_SESSION['admin']['id'] â áóäóþùåì áóäåò $sql = "UPDATE zlo_users_message SET status=2 WHERE id='".$_GET['message']."'"; $result = mysql_query($sql) or die(mysql_error()); } echo"
"; // Âûâîä message $sql = "SELECT * FROM zlo_users_message WHERE id='".$_GET['message']."'"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { $message=mysql_fetch_assoc($result); echo"
".$message['date']."
".viewBook('zlo_users', $message['from'], 'id', 'username')."
"; echo"
".$message['text']."
"; } echo"
"; } // ============= // ==== add ==== // ============= if ((isset($_GET["action"])) && ($_GET["action"] == "add")) { echo"
"; // Âûâîä message echo"
"; echo"
"; } ?>