Файл: comm/class/forum.class.php
Строк: 56
<?php
/** Модуль Сообщества
* @author Kratos
* @email wssy@mail.ua
* ICQ: 845348
* @version 1.0.0
*/
// Клас управленя форумом!
class forum{
// Проверка существует ли темы сообщества
static function issetT($id_soo){
$sql = db::query("SELECT count(*) FROM `comm_forum` WHERE `sid` = $id_soo")
or die(mysqli_error());
$res = db::result($sql,0);
return $res;
}
//Создаем первую тему
static function newTheme($id_soo,$text,$text2,$user_id){
$sql = db::query("INSERT INTO `comm_forum` SET
`sid`='$id_soo',
`user_id`='$user_id',
`text`='$text',
`type` = 't',
`time` = '" . time() . "'"
) or die(mysqli_error());
$id_l = mysqli_insert_id();
$sql2 = db::query("INSERT INTO `comm_forum` SET
`refid`='$id_l',
`cat`='$id_soo',
`user_id`='$user_id',
`text`='$text2',
`type` = 'm',
`from` = $user_id,
`time` = '" . time() . "'"
) or die(mysqli_error());
db::query("UPDATE `comm` SET
`time`='".time()."'
WHERE `id`=$id_soo");
if($sql and $sql2)
return $id_l;
}
static function showTheme($id_soo,$start,$kmess,$type = null){
switch($type){
case'5t':
$sql = "SELECT `text`,`id`,`vip`,`time` FROM `comm_forum` WHERE `sid` = $id_soo ORDER by `time` DESC LIMIT 5 ";
$res = db::query($sql) or die(mysqli_error());
if($res)
return $res;
break;
case'info':
$sql = "SELECT `text`,`id`,`vip`,`time` FROM `comm_forum` WHERE `id` = $id_soo";
$res = db::query($sql) or die(mysqli_error());
if($res)
return $res;
break;
default:
$sql = "SELECT `text`,`id`,`vip`,`time` FROM `comm_forum` WHERE `sid` = $id_soo ORDER BY `vip` DESC, `time` DESC LIMIT $start,$kmess ";
$res = db::query($sql) or die(mysqli_error());
if($res)
return $res;
break;
}
}
// Вывод сообщения в теме
static function showMess($id_t,$start,$kmess,$type = null){
switch($type){
case'1':
$sql = "SELECT * FROM `comm_forum` WHERE `id` = $id_t";
$res = db::query($sql) or die(mysqli_error());
if($res)
return $res;
break;
default:
$sql = "SELECT * FROM `comm_forum` WHERE `refid` = $id_t ORDER BY `id` LIMIT $start,$kmess ";
$res = db::query($sql) or die(mysqli_error());
if($res)
return $res;
}
break;
}
// Добавления сообщения в тему
static function newMess($id_t,$user_id,$msg,$cat){
$sql = db::query("INSERT INTO `comm_forum` SET
`refid`='$id_t',
`user_id`='$user_id',
`text`= '$msg',
`type` = 'm',
`from` = $user_id,
`cat` = $cat,
`time` = '" . time() . "'"
) or die(mysqli_error());
db::query("UPDATE `comm` SET
`time`='".time()."'
WHERE `id`=$cat");
$sql2 = db::query("UPDATE `comm_forum` SET
`time`='".time()."'
WHERE `id`=$id_t
AND `type` = 't'")
or die(mysqli_error());
if ($sql and $sql2)
return true;
}
// счетчик сообществ в раздели
static function countPost($id= null,$cat,$type = null){
switch($type){
case'1':
$req = db::query("SELECT COUNT(*) FROM `comm_forum` WHERE `type`= 'm' AND `cat` = $cat");
$total = db::result($req, 0);
return $total;
break;
default:
$req = db::query("SELECT COUNT(*) FROM `comm_forum` WHERE `type`= 'm' AND `refid` = $id");
$total = db::result($req, 0);
return $total;
break;
}
}
//Время входа в темы
static function upTopicTime($id_t,$user_id,$type = null){
switch($type){
case'up':
$sql = db::query("UPDATE `comm_forum_rdm` SET
`time`='".time()."'
WHERE `topic_id`=$id_t
AND `user_id` = $user_id")
or die(mysqli_error());
if ($sql)
return true;
break;
case'insert':
$sql = db::query("INSERT INTO `comm_forum_rdm`
SET `time` = '".time()."',
`user_id` = $user_id,
`topic_id` = $id_t")
or die(mysqli_error());
if($sql)
return true;
break;
default:
$req = db::query("SELECT COUNT(*) FROM `comm_forum_rdm` WHERE `topic_id` = $id_t AND `user_id` = $user_id");
$total = db::result($req, 0);
return $total;
break;
}
}
//удаления поста
static function deletePost($idt){
$sql = "DELETE FROM `comm_forum` WHERE `type` = 'm' AND `id` = $idt LIMIT 1";
$res = db::query($sql) or die(mysqli_error());
if($res)
return true;
}
// Обновления текста
static function upPost($idp,$text,$user_id){
$sql = db::query("UPDATE `comm_forum` SET
`text`='$text',
`edit` = '$user_id',
`tedit` = '".time()."'
WHERE `id`= $idp
AND `type` = 'm'")
or die(mysqli_error());
if ($sql)
return true;
}
//Закрепляем тему
static function vipT($idt,$vip){
$sql = db::query("UPDATE `comm_forum` SET
`vip`='$vip'
WHERE `id`= $idt
AND `type` = 't'")
or die(mysqli_error());
if ($sql)
return true;
}
//удаления темы
static function deleteT($idt){
$sql = "DELETE FROM `comm_forum` WHERE `type` = 't' AND `id` = $idt LIMIT 1";
$sql2 = "DELETE FROM `comm_forum` WHERE `type` = 'm' AND `refid` = $idt";
$res = db::query($sql) or die(mysqli_error());
$res2 = db::query($sql2) or die(mysqli_error());
if($res and $res2)
return true;
}
}
?>