Файл: modules/padmin/smiles.php
Строк: 234
<?php
/**
* Licensed under The MIT License
* For full copyright and license information, please see the LICENSE.txt
* Redistributions of files must retain the above copyright notice.
*
* @copyright Copyright (c) 2013, Taras Chornyi, Sergiy Mazurenko, Ivan Kotliar
* @link http://perf-engine.net
* @package PerfEngine
* @license http://www.opensource.org/licenses/mit-license.php MIT License
*/
$locate = 'in_padmin';
if(User::logged() && $user['level'] >= 6) {
#############____ Создание папки ____#############
if(isset($_GET['act']) && $_GET['act'] == 'add_dir')
{
if(isset($_POST['send']))
{
$name = input($_POST['name']);
if(!empty($name))
{
$db->query("INSERT INTO `smiles` SET `name` = '$name', `type` = '0'");
redirect('/padmin/smiles/');
}
}
$title = _t('dl_add_dir') .' - '._t('smiles');
include_header($title);
Template::div('title', _t('dl_add_dir') .' - '._t('smiles'));
echo '<div class="post">
<form action="/padmin/smiles/?act=add_dir" method="post">
'._t('name').':<br/>
<input type="text" name="name" /><br/>
<input name="send" type="submit" value="'. _t('add') .'" />
</form>
</div>';
Template::div('block', img('smiley-smile.png').' <a href="/padmin/smiles/">'. _t('back') .'</a><br/>'. img('admin.png') .'<a href="/padmin/">'. _t('padmin') .'</a><br/>'. HICO .'<a href="/">'. _t('home') .'</a>');
include_footer();
exit;
}
#############____ Категории ____#############
if(isset($_GET['id']) && $db->query("SELECT * FROM `smiles` WHERE `id` = '".abs(intval($_GET['id']))."' AND `type` = '0'")->rowCount() != 0)
{
$title = _t('smiles');
include_header($title);
Template::div('title', $db->query("SELECT name FROM `smiles` WHERE `id` = '".abs(intval($_GET['id']))."'")->fetchColumn() .' - '. _t('smiles'));
$smiles_cat = $db->query("SELECT * FROM `smiles` WHERE `cat` = '".abs(intval($_GET['id']))."' AND `type` = '1'")->rowCount();
$pages = new Paginator($smiles_cat, $ames);
if($smiles_cat == 0)
{
Template::div('menu', _t('smiles_no'));
}
else
{
$cat = $db->query("SELECT * FROM `smiles` WHERE `cat` = '".abs(intval($_GET['id']))."' AND `type` = '1' ORDER BY id ASC LIMIT $start, $ames");
foreach($cat as $cats)
{
echo '<div class="menu">
<img src="/files/smiles/'.$cats['id'].'.'.$cats['ext'].'" alt="." /> '.$cats['smile'].'<br />
[<a href="/padmin/smiles/?smile='.$cats['id'].'">'. _t('edit') .'</a>]
</div>';
}
$pages->view();
}
Template::div('block', img('add.png').' <a href="/padmin/smiles/?add_smile='.abs(intval($_GET['id'])).'">'. _t('add') .'</a><br/>'. img('smiley-smile.png').' <a href="/padmin/smiles/">'. _t('back') .'</a><br/>'. img('admin.png') .'<a href="/padmin/">'. _t('padmin') .'</a><br/>'. HICO .'<a href="/">'. _t('home') .'</a>');
include_footer();
exit;
}
#############____ Удаление категории ____#############
if(isset($_GET['delete']) && $db->query("SELECT * FROM `smiles` WHERE `id` = '".abs(intval($_GET['delete']))."' AND `type` = '0'")->rowCount() != 0)
{
if(isset($_POST['delete'])) {
$db->query("DELETE FROM `smiles` WHERE `id` = '".abs(intval($_GET['delete']))."'");
$db->query("DELETE FROM `smiles` WHERE `cat` = '".abs(intval($_GET['delete']))."'");
redirect('/padmin/smiles/');
}
$title = _t('smiles');
include_header($title);
Template::div('title', _t('smiles'));
echo '<div class="menu">
<form action="/padmin/smiles/?delete='.abs(intval($_GET['delete'])).'" method="post">
'._t('delete').' <b>'.$db->query("SELECT name FROM `smiles` WHERE `id` = '".abs(intval($_GET['delete']))."'")->fetchColumn().'</b> ?<br />
<input name="delete" type="submit" value="'. _t('delete') .'" />
</form>
</div>';
Template::div('block', img('smiley-smile.png').' <a href="/padmin/smiles/">'. _t('back') .'</a><br/>'. img('admin.png') .'<a href="/padmin/">'. _t('padmin') .'</a><br/>'. HICO .'<a href="/">'. _t('home') .'</a>');
include_footer();
exit;
}
#############____ Редактирование категории ____#############
if(isset($_GET['edit']) && $db->query("SELECT * FROM `smiles` WHERE `id` = '".abs(intval($_GET['edit']))."' AND `type` = '0'")->rowCount() != 0)
{
if(isset($_POST['edit'])) {
$name = input($_POST['name']);
if(!empty($name))
{
$db->query("UPDATE `smiles` SET `name` = '$name' WHERE `id` = '".abs(intval($_GET['edit']))."'");
redirect('/padmin/smiles/');
exit;
}
redirect('/padmin/smiles/');
}
$title = _t('smiles');
include_header($title);
Template::div('title', _t('smiles'));
echo '<div class="menu">
<form action="/padmin/smiles/?edit='.abs(intval($_GET['edit'])).'" method="post">
'._t('name').':<br/>
<input type="text" name="name" value="'.$db->query("SELECT name FROM `smiles` WHERE `id` = '".abs(intval($_GET['edit']))."'")->fetchColumn().'" /><br/>
<input name="edit" type="submit" value="'. _t('edit') .'" />
</form>
</div>';
Template::div('block', img('smiley-smile.png').' <a href="/padmin/smiles/">'. _t('back') .'</a><br/>'. img('admin.png') .'<a href="/padmin/">'. _t('padmin') .'</a><br/>'. HICO .'<a href="/">'. _t('home') .'</a>');
include_footer();
exit;
}
#############____ Изменения смайла ____#############
if(isset($_GET['smile']) && $db->query("SELECT * FROM `smiles` WHERE `id` = '".abs(intval($_GET['smile']))."' AND `type` = '1'")->rowCount() != 0)
{
$smile = $db->query("SELECT * FROM `smiles` WHERE `id` = '".abs(intval($_GET['smile']))."'")->fetch();
if(isset($_POST['edit'])) {
$smile_nam = input($_POST['smile']);
if(!empty($smile_nam)) {
$db->query("UPDATE `smiles` SET `smile` = '". $smile_nam."' WHERE `id` = '".$smile['id'] ."'");
redirect('/padmin/smiles/'.$smile['cat'].'');
} }
if(isset($_POST['delete'])) {
$db->query("DELETE FROM `smiles` WHERE `id` = '".$smile['id'] ."'");
unlink(ROOT.'/files/smiles/'.$smile['id'].'.'.$smile['ext']);
redirect('/padmin/smiles/'.$smile['cat'].'');
}
$title = _t('smiles');
include_header($title);
Template::div('title', _t('smiles'));
echo '<div class="menu">
<form action="/padmin/smiles/?smile='.abs(intval($_GET['smile'])).'" method="post">
<img src="/files/smiles/'.$smile['id'].'.'.$smile['ext'].'" alt="." /><br />
'._t('mark').': <input type="text" size="2" name="smile" value = "'.$smile['smile'].'" /><br/>
<input name="edit" type="submit" value="'. _t('edit') .'" />
<input name="delete" type="submit" value="'. _t('delete') .'" />
</form>
</div>';
Template::div('block', img('back.png').' <a href="/padmin/smiles/'.$smile['cat'].'">'. _t('back') .'</a><br/>'. img('smiley-smile.png').' <a href="/padmin/smiles/">'. _t('smiles') .'</a><br/>'. img('admin.png') .'<a href="/padmin/">'. _t('padmin') .'</a><br/>'. HICO .'<a href="/">'. _t('home') .'</a>');
include_footer();
exit;
}
#############____ Добавление смайла ____#############
if(isset($_GET['add_smile']) && isset($_GET['add_smile']) && $db->query("SELECT * FROM `smiles` WHERE `id` = '".abs(intval($_GET['add_smile']))."' AND `type` = '0'")->rowCount() != 0)
{
if(isset($_POST['add'])) {
$smile = input($_POST['smile']);
if($_FILES['file']['tmp_name'] && !empty($smile))
{
$file_info = pathinfo($_FILES['file']['name']);
$file_info['extension'] = strtolower($file_info['extension']);
$db->query("INSERT INTO `smiles` SET `smile` = '".$smile."', `ext` = '".$file_info['extension']."', `cat` = '".abs(intval($_GET['add_smile']))."', `type` = '1'");
// print_r($db->errorInfo());
$servname = $db->lastInsertId().'.'.$file_info['extension'];
move_uploaded_file($_FILES['file']['tmp_name'], ROOT.'/files/smiles/'.$servname);
redirect('/padmin/smiles/'.abs(intval($_GET['add_smile'])).'');
}
}
$title = _t('add_smile');
include_header($title);
Template::div('title', _t('add_smile'));
echo '<div class="menu">
<form action="/padmin/smiles/?add_smile='.abs(intval($_GET['add_smile'])).'" method="post" enctype="multipart/form-data">
<b>'. _t('image_smile') .'</b>:<br/>
<input name="file" type="file" accept="image/*"/><br/>
'._t('mark').': <input type="text" size="2" name="smile" /><br/>
<input name="add" type="submit" value="'. _t('add') .'" />
</form>
</div>';
Template::div('block', img('back.png').' <a href="/padmin/smiles/'.abs(intval($_GET['add_smile'])).'">'. _t('back') .'</a><br/>'.img('smiley-smile.png').' <a href="/padmin/smiles/">'. _t('smiles') .'</a><br/>'. img('admin.png') .'<a href="/padmin/">'. _t('padmin') .'</a><br/>'. HICO .'<a href="/">'. _t('home') .'</a>');
include_footer();
exit;
}
#############____ Главная страница подарков ____#############
$title = _t('smiles');
include_header($title);
Template::div('title', _t('smiles'));
$smiles_cat = $db->query("SELECT * FROM `smiles` WHERE `type` = '0'")->rowCount();
$pages = new Paginator($smiles_cat, $ames);
if($smiles_cat == 0)
{
Template::div('menu', _t('dl_dir_empty'));
}
else
{
$cat = $db->query("SELECT * FROM `smiles` WHERE `type` = '0' ORDER BY id ASC LIMIT $start, $ames");
foreach($cat as $cats)
{
Template::div('menu', img('smiley-smile.png') .'<a href="/padmin/smiles/'. $cats['id'] .'">'. _t($cats['name']) .'</a> ('.$db->query("SELECT * FROM `smiles` WHERE `cat` = '". $cats['id'] ."' AND `type` = '1'")->rowCount().') <span style="float: right;">[<a href="/padmin/smiles/?delete='. $cats['id'] .'">x</a> | <a href="/padmin/smiles/?edit='. $cats['id'] .'">+</a>]</span>');
}
$pages->view();
}
Template::div('block', img('add.png').' <a href="/padmin/smiles/?act=add_dir">'. _t('dl_add_dir') .'</a><br/>'. img('admin.png') .'<a href="/padmin/">'. _t('padmin') .'</a><br/>'. HICO .'<a href="/">'. _t('home') .'</a>');
include_footer();
} else { header('Location: /'); exit;}
?>