Файл: vkolhoze.com/jobs/index.php
Строк: 65
<?php
if(isset($_GET['get_prize']) && is_numeric($_GET['get_prize'])){
$id=$_GET['get_prize'];
$j=mysql_fetch_assoc(mysql_query("SELECT * FROM `jobs_list` WHERE `id`='$id'"));
$ju=mysql_fetch_assoc(mysql_query("SELECT SUM(count) AS count FROM `jobs_user` WHERE `id_user` = '".$ku['id']."' AND `loc`='".$j['loc']."' "));
if($ju['count']<$j['count']){
header("Location: /?jobs");
}else{
$tim=time()+43200;
$loc='jloc'.$j['loc'];
$rn=rand(0,1);
mysql_query("DELETE FROM `jobs_user` WHERE `loc`='". $j['loc']."' AND `id_user`='". $ku['id']."'");
mysql_query("UPDATE `kolhoz_user` SET `". $loc."` = '$tim' WHERE `id`='".$ku['id']."'");
if($rn==0){
//сундук
mysql_query("INSERT INTO `kolhoz_box` SET `key`='0', `id_user`='".$ku['id']."'");
header("Location: /?jobs&prize=0");
}else{
//ключ
mysql_query("INSERT INTO `kolhoz_box` SET `key`='1', `id_user`='".$ku['id']."'");
header("Location: /?jobs&prize=1");
}
}
}
if(isset($_GET['prize']) && is_numeric($_GET['prize'])){
$p=$_GET['prize'];
if($p==0){
echo "<div class='feedback'>Награда: <img width='16' height='16' src='http://sadovnik.mobi/images/icons/chest.png' alt='o'> <span>1 сундук</span></div>";
}else{
echo "<div class='feedback'>Награда: <img width='16' height='16' src='http://sadovnik.mobi/images/icons/key.png' alt='o'> <span>1 ключ</span></div>";
}
}
$list=mysql_query("SELECT * FROM `jobs_list`");
?>
<div class="content"> <div class="block"> <div>
<img width="16"height="16" src="/images/icons/refresh.png" alt="o"> <a href="#">Обновить</a> </div><div>
<?php while($post=mysql_fetch_assoc($list)): ?>
<?php
$loc[0]='Собери урожай на '.$post['count'].' грядках.';
$ju=mysql_fetch_assoc(mysql_query("SELECT SUM(count) AS count FROM `jobs_user` WHERE `id_user` = '".$ku['id']."' AND `loc`='".$post['loc']."' "));
$pr=($ju['count']*100)/$post['count'];
if($ju['count']>=$post['count']){
$pr=100;
$ju['count']=$post['count'];
}
$lc='jloc'.$post['loc'];
if(!is_numeric($ju['count'])){
$ju['count']=0;
}
if($ku[$lc]<time()):
?>
<div class="pt"></div> <div class="fr"><span>
<?=$ju['count']?>
</span>/<span>
<?=$post['count']?>
</span></div> <div class="fl"> <img src="/images/icons/work_log.png" width="16"height="16" alt="o"> <span>
<?=$loc[$post[loc]]?>
</span></div> <div class="cb"></div> <div style="border:1px solid #242;border-radius:1px;" class="expBlock"> <div class="progline" style="width:<?=$pr?>%;"></div> </div> </div><div>
<?php if($pr==100): ?>
<div class="fr"> <img src="http://sadovnik.mobi/images/icons/chest.png" width="16"height="16" alt="o"> или <img src="http://sadovnik.mobi/images/icons/key.png" width="16" height="16" alt="o"> </div><div class="fl"> <img src="http://sadovnik.mobi/images/icons/forum_mark.png" width="16" height="16" alt="o"> <a href="/?jobs&get_prize=<?=$post['id']?>">Забрать награду</a> </div><div class="cb"></div> </div>
<?php endif; ?>
<br>
<?php endif; ?>
<?php endwhile; ?>
<?php
include_once"inc/foot.php";
?>