Файл: users/present.php
Строк: 211
<?
include('../core/core.php');
include(MAINDIR.'style/head.php');
if(is_user()){
$my = DB::run() -> queryFetch("SELECT * FROM `users` WHERE `login`=? LIMIT 1",array(check($_COOKIE['login'])));
title('Подарки');
switch ($mode):
case 'index':
$login = check($_GET['login']);
$_SESSION['who'] = $login;
echo'<div class="title">Выберите категорию:</div>';
define('TOPAGE',10); $num = TOPAGE;
$links = '?mode=index&page=';
$page = intval($_GET['page']);
$posts = DB::run() -> query("SELECT * FROM `present`") -> rowCount();
$total = intval(($posts - 1) / $num) + 1;
if(empty($page) or $page < 0) $page = 1;
if($page > $total) $page = $total;
$start = $page * $num - $num;
$themes = DB::run()->query("SELECT * FROM `present` ORDER BY `id` DESC LIMIT $start,".TOPAGE."");
$themes = $themes -> fetchAll();
foreach($themes AS $u){
echo'<div class="menu">';
echo'<a href="?mode=present&id='.$u['id'].'">'.$u['name'].'</a> ['.count_all('present_c','id_present',$u['id']).']';
echo'</div>';
}
if ($page != 1) $pervpage = '<a href= '.$links.'1><<</a> <a href= '.$links.''. ($page - 1) .'><</a> ';
if ($page != $total) $nextpage = ' <a href= '.$links.''. ($page + 1) .'>></a> <a href= '.$links.'' .$total. '>>></a>';
if($page - 2 > 0) $page2left = ' <a href= '.$links.''. ($page - 2) .'>'. ($page - 2) .'</a> | ';
if($page - 1 > 0) $page1left = '<a href= '.$links.''. ($page - 1) .'>'. ($page - 1) .'</a> | ';
if($page + 2 <= $total) $page2right = ' | <a href= '.$links.''. ($page + 2) .'>'. ($page + 2) .'</a>';
if($page + 1 <= $total) $page1right = ' | <a href= '.$links.''. ($page + 1) .'>'. ($page + 1) .'</a>';
if($posts == 0){ echo'<div class="menu">Категории еще не созданы</div>'; } else {echo '<div class="menu_2">'.$pervpage.$page2left.$page1left.'<b>'.$page.'</b>'.$page1right.$page2right.$nextpage.'</div>'; }
break;
case 'present':
$id = abs(intval($_GET['id']));
echo'<div class="title">Выберите подарок:</div>';
define('TOPAGE',10); $num = TOPAGE;
$links = '?mode=present&page=';
$page = intval($_GET['page']);
$posts = DB::run() -> query("SELECT * FROM `present_c` WHERE `id_present`=?",array($id)) -> rowCount();
$total = intval(($posts - 1) / $num) + 1;
if(empty($page) or $page < 0) $page = 1;
if($page > $total) $page = $total;
$start = $page * $num - $num;
$themes = DB::run()->query("SELECT * FROM `present_c` WHERE `id_present`=? ORDER BY `id` DESC LIMIT $start,".TOPAGE."",array($id));
$themes = $themes -> fetchAll();
foreach($themes AS $u){
echo'<div class="menu">';
echo'<a href="?mode=see&id='.$u['id'].'">'.$u['name'].'</a> ['.$u['money'].' руб.]<br />
<img src="/images/present/'.$u['img'].'" width="50" height="50">';
echo'</div>';
}
if ($page != 1) $pervpage = '<a href= '.$links.'1><<</a> <a href= '.$links.''. ($page - 1) .'><</a> ';
if ($page != $total) $nextpage = ' <a href= '.$links.''. ($page + 1) .'>></a> <a href= '.$links.'' .$total. '>>></a>';
if($page - 2 > 0) $page2left = ' <a href= '.$links.''. ($page - 2) .'>'. ($page - 2) .'</a> | ';
if($page - 1 > 0) $page1left = '<a href= '.$links.''. ($page - 1) .'>'. ($page - 1) .'</a> | ';
if($page + 2 <= $total) $page2right = ' | <a href= '.$links.''. ($page + 2) .'>'. ($page + 2) .'</a>';
if($page + 1 <= $total) $page1right = ' | <a href= '.$links.''. ($page + 1) .'>'. ($page + 1) .'</a>';
if($posts == 0){ echo'<div class="menu">Подарки еще не добавлены!</div>'; } else {echo '<div class="menu_2">'.$pervpage.$page2left.$page1left.'<b>'.$page.'</b>'.$page1right.$page2right.$nextpage.'</div>'; }
break;
case 'my_present':
$login = check($_GET['login']);
if($login == NULL){$login = check($_COOKIE['login']); } else { $login = $login; }
echo'<div class="title">Мои подарки:</div>';
define('TOPAGE',10); $num = TOPAGE;
$links = '?mode=my_present&page=';
$page = intval($_GET['page']);
$posts = DB::run() -> query("SELECT * FROM `present_users` WHERE `send_login`=?",array($login)) -> rowCount();
$total = intval(($posts - 1) / $num) + 1;
if(empty($page) or $page < 0) $page = 1;
if($page > $total) $page = $total;
$start = $page * $num - $num;
$themes = DB::run()->query("SELECT * FROM `present_user` WHERE `send_login`=? ORDER BY `id` DESC LIMIT $start,".TOPAGE."",array($login));
$themes = $themes -> fetchAll();
foreach($themes AS $u){
echo'<div class="menu">';
echo'<img src="/images/present/'.$u['img'].'"><br />';
if($u['my_login'] == $u['send_login']){} else { echo'Подарил: '.$u['my_login'].'<br />'; }
echo'Когда: '.$u['data'].'<br />
Подпись: '.$u['msg'].'';
echo'</div>';
}
if ($page != 1) $pervpage = '<a href= '.$links.'1><<</a> <a href= '.$links.''. ($page - 1) .'><</a> ';
if ($page != $total) $nextpage = ' <a href= '.$links.''. ($page + 1) .'>></a> <a href= '.$links.'' .$total. '>>></a>';
if($page - 2 > 0) $page2left = ' <a href= '.$links.''. ($page - 2) .'>'. ($page - 2) .'</a> | ';
if($page - 1 > 0) $page1left = '<a href= '.$links.''. ($page - 1) .'>'. ($page - 1) .'</a> | ';
if($page + 2 <= $total) $page2right = ' | <a href= '.$links.''. ($page + 2) .'>'. ($page + 2) .'</a>';
if($page + 1 <= $total) $page1right = ' | <a href= '.$links.''. ($page + 1) .'>'. ($page + 1) .'</a>';
if($posts == 0){ echo'<div class="menu">Подарков нету(</div>'; } else {echo '<div class="menu_2">'.$pervpage.$page2left.$page1left.'<b>'.$page.'</b>'.$page1right.$page2right.$nextpage.'</div>'; }
break;
case 'see':
$id = abs(intval($_GET['id']));
$pr = DB::run() -> queryFetch("SELECT * FROM `present_c` WHERE `id`=?",array($id));
echo'<div class="title">'.$pr['name'].'</div>';
$per = ($pr['money'] * $level) / 100;
$min = $pr['money'] - $per;
echo'<div class="menu">
Стоимость:<br />
'.$pr['money'].' - '.$level.'% = <strong>'.$min.'</strong> руб.<br />
<img src="/images/present/'.$pr['img'].'"><br />
<a href="?mode=buy&id='.$id.'">Купить себе</a><br />
<a href="?mode=dar&id='.$id.'">Подарить</a>
</div>';
break;
case 'dar':
echo'<div class="title">Отправить подарок</div>';
$id = abs(intval($_GET['id']));
echo'<div class="menu">
<form action="?mode=dar_send&id='.$id.'" method="post">
Логин получателя:<br />
<input name="login" type="text" maxlength="20" value="'.$_SESSION['who'].'" /><br />
Подпись:<br />
<input name="msg" type="text" value="Подарочек для тебя, '.$_SESSION['who'].'" maxlength="150" /><br />
<input name="" type="submit" value="Подарить" />
</form>
</div>';
break;
case 'dar_send':
echo'<div class="title">Отправить подарок</div>';
$id = abs(intval($_GET['id']));
$msg = check($_POST['msg']);
$login = check($_POST['login']);
$pr = DB::run() -> queryFetch("SELECT * FROM `present_c` WHERE `id`=?",array($id));
$per = ($pr['money'] * $level) / 100;
$min = $pr['money'] - $per;
if($users['money'] >= $min){
$u = DB::run() -> queryFetch("SELECT * FROM `users` WHERE `login`=?",array($login));
if(!empty($u['login'])){
echo'<div class="menu">Подарок отправлен. Получатель получит письмо о вашем сюрпризе.</a></div>';
$i = $lg;
$data = date("d.m.Y / H:i:s");
DB::run() -> query("INSERT INTO `present_user` SET `my_login`=?,`send_login`=?, `msg`=?, `data`=?, `img`=?",array($i,$login,$msg,$data,$pr['img']));
DB::run() -> query("UPDATE `users` SET `money`=`money` - $min WHERE `login`=?",array($i));
//--------//
$msge = 'Пользователь '.$i.' подарил вам <a href="/users/present.php?mode=my_present">подарок</a> стоимостью '.$min.' руб.';
send_mail('System',$login,$msge);
} else {echo'<div class="menu">Ошибка! Данного логина не существует!</div>';}
} else {echo'<div class="menu">Вам не хватает еще '.($min - $users['money']).' руб.</div>';}
break;
case 'buy':
echo'<div class="title">Купить подарок</div>';
$id = abs(intval($_GET['id']));
$pr = DB::run() -> queryFetch("SELECT * FROM `present_c` WHERE `id`=?",array($id));
$per = ($pr['money'] * $level) / 100;
$min = $pr['money'] - $per;
if($users['money'] >= $min){
echo'<div class="menu">Подарок куплен. Он внесен в <a href="?mode=my_present">личную коллекцию.</a></div>';
$i = $lg;
$data = date("d.m.Y / H:i:s");
DB::run() -> query("INSERT INTO `present_user` SET `my_login`=?,`send_login`=?, `msg`=?, `data`=?, `img`=?",array($i,$i,'Подарочек)',$data,$pr['img']));
DB::run() -> query("UPDATE `users` SET `money`=`money` - $min WHERE `login`=?",array($i));
} else {echo'<div class="menu">Вам не хватает еще '.($min - $users['money']).' руб.</div>';}
break;
default:
header ('location: ?mode=index');
endswitch;
} else {
title('Ошибка!');
echo'<div class="title">Ошибка!</div>';
echo'<div class="error">';
echo'Доступ разрешен только авторизованым!';
echo'</div>';
}
include(MAINDIR.'style/foot.php');
?>