<?php
//Проверка на авторизацию
User::a()->noLogin();
if(User::a()->user['id'] != 1)die(header("Location:/Lunapark/"));
$data = DB::a()->d->query("SELECT * FROM `cards` WHERE `status` = '0' ORDER BY `status` ASC,`id` DESC")->fetchAll();
function generate_password($number)
{
$arr = array(
'A','B','C','E','F',
'G','H','I','J','K','L',
'M','N','O','P','R','S',
'T','U','V','X','Y','Z',
'1','2','3','4','5','6',
'7','8','9','0');
$pass = "";
for($i = 0; $i < $number; $i++)
{
$index = rand(0, count($arr) - 1);
$pass .= $arr[$index];
}
return $pass;
}
if(isset($_POST['submit'])){
$amount = abs(intval($_POST['amount']));
if($amount == 0){
$_SESSION['info'] = "Укажите сумму больше 0!";
die(header("Location:/addCard/"));
}
DB::a()->d->query("INSERT INTO `cards`SET `amount` = '".$amount."',`number` = '".generate_password(10)."',`type` = '0'");
$_SESSION['info'] = "Подарочная карта добавлена!";
die(header("Location:/addCard/"));
}
if(isset($_POST['submit2'])){
$amount = abs(intval($_POST['amount']));
if($amount == 0){
$_SESSION['info'] = "Укажите сумму больше 0!";
die(header("Location:/addCard/"));
}
DB::a()->d->query("DELETE FROM `cards` WHERE `type` = '1'");
$text = "Подарочные карты на :bucks:".number_format($amount);
$text.= "<br>";
for($i=1;$i<21;$i++){
$pass = generate_password(10);
$text.= "<br>".$pass;
DB::a()->d->query("INSERT INTO `cards` SET `amount` = '".$amount."',`number` = '".$pass."',`type` = '1'");
}
DB::a()->d->query("UPDATE `users` SET `card` = '0'");
$idf = Forum::a()->addTopic(1,"Подарочные карты ".date('d.m.y'),1,$text);
Forum::a()->closed($idf);
$text = "Спешите!В новости добавлены новые подарочные карты на :bucks:".$amount."!";
DB::a()->d->query("INSERT INTO `chat` (`user`,`text`,`time`) VALUES ('".User::a()->user['id']."', '".$text."','".time()."')");
$users = DB::a()->d->query("SELECT * FROM `users` WHERE `date_last` > '".(time()-7200)."'")->fetchAll();
foreach($users as $value){
if($value['id']!=1)Mail::a()->addMess($value['id'],$text);
}
$_SESSION['info'] = "Подарочные карты добавлены!";
die(header("Location:/addCard/"));
}
Template::a()->setTitle('Подарочные карты');
Template::a()->set('data',$data);
Template::a()->display('addcard/index');
?>