Файл: panel/chat.php
Строк: 169
<?php
/**
* @package Prime Social
* @link http://primesocial.ru
* @copyright Copyright (C) 2016 Prime Social
* @author BoB | http://primesocial.ru/about
*/
require_once('../core/start.php');
check_auth();
head('Chatni boshqarish');
if (privilegy('chat') == FALSE) {
header("Location: ".HOME."/panel");
exit();
}
$all = DB::$dbs->querySingle("SELECT COUNT(`id`) FROM ".CHAT_MSG." ");
if (isset($_GET['clean'])) {
DB::$dbs->query("TRUNCATE ".CHAT_MSG."");
header("Location: ".HOME."/panel/chat/");
}
if (!empty($_GET['cleanroom'])) {
DB::$dbs->query("DELETE FROM ".CHAT_MSG." WHERE `room_id` = ? ", array(num($_GET['cleanroom'])));
header("Location: ".HOME."/panel/chat/");
}
if (!empty($_GET['delroom'])) {
if (!isset($_GET['go'])) {
echo DIV_LI . '<b>O`chirishni tastiqlang:</b> <a href="'.HOME.'/panel/chat/?delroom='.(int)$_GET['delroom'].'&go">[o`chirish]</a> <a href="'.HOME.'/panel/chat/">[yo`q]</a>' . CLOSE_DIV;
} else {
DB::$dbs->query("DELETE FROM ".CHAT_MSG." WHERE `room_id` = ? ", array(num($_GET['delroom'])));
DB::$dbs->query("DELETE FROM ".CHAT_ROOM." WHERE `id` = ? ", array(num($_GET['delroom'])));
header("Location: ".HOME."/panel/chat/");
}
}
if (!empty($_POST['str'])) {
$str = num($_POST['str']);
if (empty($str)) {
echo DIV_ERROR . 'Xech nima tanlanmagan' . CLOSE_DIV;
} else {
DB::$dbs->query("UPDATE ".CONFIG." SET `write_room` = ? ", array($str));
header("Location: ".HOME."/panel/chat/");
}
}
if (!empty($_GET['editroom'])) {
if ($_POST['edit']) {
$room = html($_POST['room']);
$type = num($_POST['type']);
if (empty($room)) {
echo DIV_ERROR . 'Xona nomi ko`rsatilmadi' . CLOSE_DIV;
} else {
DB::$dbs->query("UPDATE ".CHAT_ROOM." SET `name` = ?, `type` = ? WHERE `id` = ?", array($room, $type, num($_GET['editroom'])));
header("Location: ".HOME."/panel/chat/");
}
}
$room = DB::$dbs->queryFetch("SELECT `id`, `name`, `type`, `icon` FROM ".CHAT_ROOM." WHERE `id` = ?",array(num($_GET['editroom'])));
/* Ikonkani o`chirish */
if (isset($_GET['icon_delete'])) {
@unlink('../files/icons_chat/' . $room['icon']);
DB::$dbs->query("UPDATE ".CHAT_ROOM." SET `icon` = ? WHERE `id` = ?", array('', num($_GET['editroom'])));
header("Location: ".HOME."/panel/chat/?editroom=".$room['id']);
}
echo DIV_AUT;
echo '<form action="#" method="POST" enctype="multipart/form-data">';
echo 'Nomi:<br /><input type="text" value="'.$room['name'].'" name="room" /><br />';
echo '<select name="type">';
echo '<option '.(0 == $room['type'] ? 'selected="selected"' : NULL).' value="0">Oddiy</option>';
echo '<option '.(1 == $room['type'] ? 'selected="selected"' : NULL).' value="1">"Bilimdon" boti bilan</option>';
echo '<option '.(2 == $room['type'] ? 'selected="selected"' : NULL).' value="2">"Xazilkash" boti bilan</option>';
echo '</select>';
if ($room['icon']) {
echo '<b>Rasmcha:</b><br /><img src="'.HOME.'/files/icons_chat/'.$room['icon'].'" alt="[icon]" /> <a href="'.HOME.'/panel/chat/?editroom='.$room['id'].'&icon_delete">[x]</a><br />';
}
echo '<input type="submit" name="edit" value="O`zgartirish" /></form>';
echo CLOSE_DIV;
}
echo '<div class="white" style="font-size:11px;color:green;">Chatdagi xabarlar soni: <b>' . $all . '</b> <a href="?clean">[Tozalash]</a>' . CLOSE_DIV;
$all = DB::$dbs->querySingle("SELECT COUNT(`id`) FROM ".CHAT_ROOM."");
if (empty($all)) {
echo DIV_BLOCK . 'Xonalar ochilmagan' . CLOSE_DIV;
} else {
$sql = DB::$dbs->query("SELECT * FROM ".CHAT_ROOM." ORDER BY `id` DESC");
while($room = $sql -> fetch()) {
echo DIV_BLOCK;
echo ($room['icon'] ? '<img src="'.HOME.'/files/icons_chat/'.$room['icon'].'" alt="[icon]" /> ' : NULL) . '<a href="'.HOME.'/chat/'.$room['id'].'/">'.$room['name'].'</a><br />';
$allmsg = DB::$dbs->querySingle("SELECT COUNT(`id`) FROM ".CHAT_MSG." WHERE `room_id` = ? ", array($room['id']));
echo 'Habarlar: <b>' . $allmsg . '</b> <a href="?cleanroom='.$room['id'].'">[Tozalash]</a> <a href="?delroom='.$room['id'].'">[O`chr.]</a> <a href="?editroom='.$room['id'].'">[O`zg.]</a><br />';
echo CLOSE_DIV;
}
}
if ($_POST['add']) {
$room = html($_POST['room']);
$type = num($_POST['type']);
if (empty($room)) {
echo DIV_ERROR . 'Xona nomi ko`rsatilmadi' . CLOSE_DIV;
} else {
if (!empty($_FILES['file'])) {
$name = $_FILES['file']['name']; # Fayl nomi
$ext = strtolower(strrchr($name, '.')); # Fayl formati
$par = getimagesize($_FILES['file']['tmp_name']); # Rasm shakli
$icon_uri = time().$ext;
$pictures = array('.jpg', '.jpeg', '.gif', '.png'); # Mumkun bo`lgan formatlar
if ($par[0] > 216 || $par[1] > 216) {
$err .= 'Foto hajmi belgilangan miqdordan ortmoqda. [Max. 16x16]<br />';
}
if (preg_match('/.php/i', $name) || preg_match('/.pl/i', $name) || $name == '.htaccess' || !in_array($ext, $pictures)) {
$err .= 'Fayl formati noto`g`ri.<br />';
}
if (empty($err)) {
copy($_FILES['file']['tmp_name'], '../files/icons_chat/'.$icon_uri);
} else {
echo $err;
}
}
$icon_uri = ($icon_uri ? $icon_uri : '');
DB::$dbs->query("INSERT INTO ".CHAT_ROOM." (`name`, `type`, `icon`) VALUES (?, ?, ?)", array($room, $type, $icon_uri));
header("Location: ".HOME."/panel/chat/");
}
}
echo DIV_AUT;
echo '<form action="#" method="POST" enctype="multipart/form-data">';
echo '<b>Yangi xona</b>:<br /><input type="text" name="room" /><br />';
echo '<select name="type">';
echo '<option value="0">Oddiy</option>';
echo '<option value="1">"Bilimdon" boti bilan</option>';
echo '<option value="2">"Xazilkash" boti bilan</option>';
echo '</select>
<br/>
Rasmcha [16x16, jpg|jpeg|gif|png]:<br/>
<input type="file" name="file" /><br/>';
echo '<input type="submit" name="add" value="Yaratish" /></form>';
echo CLOSE_DIV;
echo DIV_AUT;
echo '<b>Xonadagi habarlar soni:</b><br />';
echo '<form action="#" method="POST">';
echo '<select name="str">';
echo '<option '.(5 == $config['write']['room'] ? 'selected="selected"' : NULL).' value="5">5</option>';
echo '<option '.(10 == $config['write']['room'] ? 'selected="selected"' : NULL).' value="10">10</option>';
echo '<option '.(15 == $config['write']['room'] ? 'selected="selected"' : NULL).' value="15">15</option>';
echo '<option '.(20 == $config['write']['room'] ? 'selected="selected"' : NULL).' value="20">20</option>';
echo '<option '.(30 == $config['write']['room'] ? 'selected="selected"' : NULL).' value="30">30</option>';
echo '<option '.(50 == $config['write']['room'] ? 'selected="selected"' : NULL).' value="50">50</option>';
echo '</select>';
echo '<input type="submit" name="sett" value="O`zgartirish" /></form>';
echo CLOSE_DIV;
echo DIV_GO . '<a href="'.HOME.'/">Bosh sahifa</a> / <a href="'.HOME.'/panel">Boshqaruv paneli</a> / <b>Chatni boshqarish</b>' . CLOSE_DIV;
require_once('../core/stop.php');
?>