|
|
|
|
<?php
****************************************************************
Автор скрипта : Koder_AS
****************************************************************
Мой профиль : http://gix.su/user/Kodes_AS
****************************************************************
Установка : просто выгрузите в корень с заменой файлов !
*****************************************************************
Спецально для StrongCMS
*****************************************************************
Установка :
1. Распаковать с заменой файлов
2. Выполнить запрос в базу
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
CREATE TABLE IF NOT EXISTS `help_msg` (
`id` int(250) NOT NULL AUTO_INCREMENT,
`id_user` int(250) NOT NULL,
`msg` varchar(10000) NOT NULL,
`id_help` int(250) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
НУЖНО ВЫПОЛНИТЬ ЕЩЕ ОДИН ЗАПРОС
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `help` (
`id` int(250) NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL,
`text` varchar(10000) NOT NULL,
`id_user` int(250) NOT NULL,
`type` enum('0','1') NOT NULL DEFAULT '1',
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
В кабинете прописать :
echo '<div class="menudiv"><a href="'.$HOME.'/user/help.php" class="k_menu"><img src="/images/cab/s_pass.png" alt="*" /> Мои тикеты</div></a>';
В админке прописать
$k_post1 = mysql_result(mysql_query("SELECT COUNT(*) FROM `help` WHERE `type` = '1'"),0);
$k_post0 = mysql_result(mysql_query("SELECT COUNT(*) FROM `help` WHERE `type` = '0'"),0);
echo '<div class="menudiv"><a href="'.$HOME.'/panel/help.php" class="k_menu">Все тикеты (Открытых : '.$k_post1.' / Закрытых : '.$k_post0.')</a></div>';
///////////////////
СКРИПТ ГОТОВ!!!
?>