<?
require_once ('power.php');
require_once ('head.php');
$sql = $db -> query("SELECT * FROM `ferma_terr` where `id`='".$id."' and `user`='".$ya['id']."'");
$sql_what = $db -> query("SELECT * FROM `ferma_what` where `id`='".$fermer['semena']."'");
if ($sql -> num_rows > 0 and $sql_what->num_rows>0) {
$terr=$sql->fetch_assoc();
$what=$sql_what->fetch_assoc();
switch($do) {
//новая грядка
case 'newzemlya':
$sql = $db -> query("SELECT * FROM `ferma_lic` where `user`='".$ya['id']."'");
if ($sql -> num_rows > 0 ) {
$cena=$func->zemlya($fermer['id']);
if (!isset($_GET['true'])) {
$msg .= '<div class="bgdiv">Вы точно желаете приобрести новую грядку за <img src="img/kris.png" alt=""/> '.$cena.'?<br/>
<a href="?do=newzemlya&true">Да</a> | <a href="index.php">Нет</a></div>';
} else {
if($fermer['kris']>=$cena){
$db -> query("INSERT INTO `ferma_terr` SET `user` = '".$ya['id']."'");
$db->query("UPDATE `ferma_users` SET `kris`=kris-".$cena." where `id`=".$fermer['id']." LIMIT 1");
header('location: index.php');
}else echo '<div class="bgdiv">Недостаточно средств!</div>';
}
}else echo '<div class="bgdiv">Для расширения земель необходима лицензия!</div>';
break;
//полив грядок
case 'poliv':
if($terr['polivnext']-$terr['poliv']<=0){
$poliv=time()+$what['poliv'];
$db->query("UPDATE `ferma_terr` SET `poliv`='".time()."',`polivnext`='".$poliv."' where `id`=".$id." LIMIT 1");
$db->query("UPDATE `ferma_users` SET `exp`=exp+10 where `user`=".$ya['id'] . " LIMIT 1");
$db -> query("INSERT INTO `ferma_news` SET `lvltype`='2',`user` = '".$ya['id']."',`img`='exp.png',`kol`='10',`time`='".time()."',`view`='1'");
header('location: index.php');
}else header('location: index.php');
break;
//сбор урожая
case 'sobr':
if($terr['timenext']-$terr['time']<=0){
$what = $db -> query("SELECT * FROM `ferma_what` where `id`='".$fermer['semena']."'")->fetch_assoc();
$db->query("UPDATE `ferma_users` SET `exp`=exp+".$what['exp']." where `user`=".$ya['id']." LIMIT 1");
$assoc = $db -> query("SELECT * FROM `ferma_sklad_what` where `what`='".$what['id']."' and `sklad`='".$sklad['id']."'");
$vmest = $db -> dbcount('SUM(`razmer`)','ferma_sklad_what','`user`='.$ya['id'].'');
if($vmest!=0)$vmest=$vmest+$what['resulr']; else $vmest=0;
if($sklad['razmer']>=$vmest){
if ($assoc -> num_rows > 0 ) {
$db->query("UPDATE `ferma_sklad_what` SET `razmer`=razmer+'".$what['resulr']."' where `sklad`=".$sklad['id']." and `what`=".$what['id']." LIMIT 1");
}else{
$db -> query("INSERT INTO `ferma_sklad_what` SET `sklad`='".$sklad['id']."',`user` = '".$ya['id']."',`what`='".$what['id']."',`razmer`='".$what['resulr']."'");
}
$db->query("UPDATE `ferma_terr` SET `status`='3',`what`='0',`time`=".time().",`timenext`=".(time()+600).",`poliv`='0',`polivnext`='0' where `id`=".$id." LIMIT 1");
$db -> query("INSERT INTO `ferma_news` SET `lvltype`='3',`user` = '".$ya['id']."',`img`='".$what['name']."',`kol`='".$what['resulr']."',`time`='".time()."',`view`='1'");
header('location: index.php');
}else header('location: sklad.php');
}else header('location: index.php');
break;
//посадка
default:
if ($terr['status']==0) {
if($fermer['lvl']>=$what['lvl'] or $fermer['money']>=$what['cena']){
$posadka=time()+$what['time'];
$poliv=time()+$what['poliv'];
$my_exp=$fermer['exp']+$what['exp'];
$db->query("UPDATE `ferma_terr` SET `status`='2',`time`=".time().",`timenext`=".$posadka.",`poliv`=".time().",`polivnext`=".$poliv.",`what`=".$fermer['semena']." where `id`=".$id." LIMIT 1");
$db->query("UPDATE `ferma_users` SET `exp`=".$my_exp.",`money`=money-".$what['cena']." where `user`=".$ya['id'] . " LIMIT 1");
$db -> query("INSERT INTO `ferma_news` SET `lvltype`='2',`user` = '".$ya['id']."',`img`='exp.png',`kol`='".$what['exp']."',`time`='".time()."',`view`='1'");
header('location: index.php');
} else header('location: index.php');
} else header('location: index.php');
}
///foot
include_once ('foot.php');
///
}else header('location: index.php');
#####Копирайт#######
$diz -> out($msg);
?>