Файл: zfarm.mobi/inc/assignments/index.php
Строк: 277
<?
$title='Задания';
include_once '../system/config.php';
$x=mysql_query("SELECT * FROM `assignments` WHERE `id` = '".intval($_GET['id'])."' ORDER BY `id` DESC");
while($ass1=mysql_fetch_assoc($x)){
if(isset($_GET['id']))
{
$assUser = mysql_fetch_array(mysql_query("SELECT * FROM `assignments_user` WHERE `id_user` = '$ku[id]'"));
$key = mysql_fetch_array(mysql_query("SELECT * FROM `key_user` WHERE `id_user` = '$ku[id]'"));
$log = mysql_fetch_array(mysql_query("SELECT * FROM `assignments_log` WHERE `id_user` = '$ku[id]' AND `assignment` ='".intval($_GET['id'])."'"));
if(isset($_GET['go']) && ($ku['level']>=$ass1['level'] && $assUser['assignment']<1 && $log<1)){
mysql_query("UPDATE `assignments_user` SET `assignment` = '$ass1[id]' WHERE `id_user` = '$ku[id]'");
header("Location: /assignments/id/$ass1[id]");
}
if(isset($_GET['no']) && ($assUser['assignment']>0 && $log<1)){
mysql_query("UPDATE `assignments_user` SET `assignment` = '0', `plant1` = '0', `plant2` = '0', `plant3` = '0', `pet1` = '0', `pet2` = '0', `pet3` = '0' WHERE `id_user` = '$ku[id]'");
header("Location: /assignments/id/$ass1[id]");
}
if(isset($_GET['prize']) && ($assUser['assignment']>0 && $log<1 && $assUser['plant1']>=$ass1['plant-1'] && $assUser['plant2']>=$ass1['plant-2'] && $assUser['plant3']>=$ass1['plant-3'] && $assUser['pet1']>=$ass1['pet-1'] && $assUser['pet2']>=$ass1['pet-2'] && $assUser['pet3']>=$ass1['pet-3'])){
mysql_query("UPDATE `assignments_user` SET `assignment` = '0', `plant1` = '0', `plant2` = '0', `plant3` = '0', `pet1` = '0', `pet2` = '0', `pet3` = '0' WHERE `id_user` = '$ku[id]'");
if($ass1['money']>0)
{
$money=$ass1['money'];
$ku['money']=plus_money($money);
}
if($ass1['ruby']>0)
{
mysql_query("UPDATE `kolhoz_user` SET `rubies` = '".($ku['rubies']+$ass1['ruby'])."' WHERE `id` = '$ku[id]'");
mysql_query("INSERT INTO `info_user` SET `id_user` = '$ku[id]', `status` = '+', `many` = '$ass1[ruby]', `kuda` = 'Награда за задание', `time` = '$time'");
}
if($ass1['scarerow']>0)
{
$timee=3600*$ass1['scarerow'];
mysql_query("UPDATE `kolhoz_user` SET `scarecrow_time` = '".($ku['scarecrow_time']>$time?"".($ku['scarecrow_time']+$timee)."":"".($time+$timee)."")."' WHERE `id` = '$ku[id]'");
}
if($ass1['hydropinics']>0)
{
$timee=3600*$ass1['hydropinics'];
$ps=$ku['hydropinics_type']+$ass1['type_hydropinics'];
if($ps>300)$ps=300;
mysql_query("UPDATE `kolhoz_user` SET `hydropinics_time` = '".($ku['hydropinics_time']>$time?"".($ku['hydropinics_time']+$timee)."":"".($time+$timee)."")."', `hydropinics_type` = '$ps' WHERE `id` = '$ku[id]'");
}
if($ass1['exp']>0)
{
mysql_query("UPDATE `kolhoz_user` SET `rating` = '".($ku['rating']+$ass1['exp'])."' WHERE `id` = '$ku[id]'");
}
if($ass1['colorName']>0)
{
$timee=3600*$ass1['colorName'];
mysql_query("UPDATE `kolhoz_user` SET `colorNameTime` = '".($ku['colorNameTime']>$time?"".($ku['colorNameTime']+$timee)."":"".($time+$timee)."")."', `colorName` = '$ass1[type_color]' WHERE `id` = '$ku[id]'");
}
if($ass1['key_gold']>0)
{
mysql_query("UPDATE `key_user` SET `gold` = '".($key['gold']+$ass1['key_gold'])."' WHERE `id_user` = '$ku[id]'");
}
if($ass1['key_normal']>0)
{
mysql_query("UPDATE `key_user` SET `normal` = '".($key['normal']+$ass1['key_normal'])."' WHERE `id_user` = '$ku[id]");
}
if($ass1['key_bronze']>0)
{
mysql_query("UPDATE `key_user` SET `bronze` = '".($key['bronze']+$ass1['key_bronze'])."' WHERE `id_user` = '$ku[id]");
}
if($ass1['key_magic']>0)
{
mysql_query("UPDATE `key_user` SET `magic` = '".($key['magic']+$ass1['key_magic'])."' WHERE `id_user` = '$ku[id]");
}
if($ass1['key_silver']>0)
{
mysql_query("UPDATE `key_user` SET `silver` = '".($key['silver']+$ass1['key_silver'])."' WHERE `id_user` = '$ku[id]");
}
mysql_query("INSERT INTO `assignments_log` SET `id_user` = '$ku[id]', `assignment` = '$ass1[id]', `time` = '$time'");
header("Location: /assignments/id/$ass1[id]");
}
echo"<div class='rzd2'></div><div class='menuin2'><div><div><div><div><div><div>";
echo'<div class="title">'.$ass1['name'].'</div>';
echo'<div class="block">'.$ass1['opis'].'</div>';
if($log<1){
$plant = mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_plant` WHERE `id` = '$ass1[plant1]'"));
$assUser = mysql_fetch_array(mysql_query("SELECT * FROM `assignments_user` WHERE `id_user` = '$ku[id]'"));
$plant1 = mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_plant` WHERE `id` = '$ass1[plant2]'"));
$plant2 = mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_plant` WHERE `id` = '$ass1[plant3]'"));
$pet = mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_pet` WHERE `id` = '$ass1[pet1]'"));
$pet2 = mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_pet` WHERE `id` = '$ass1[pet2]'"));
$pet3 = mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_pet` WHERE `id` = '$ass1[pet3]'"));
if($ass1['plant1']>0 && $assUser['plant1']<$ass1['plant-1'])echo'<div class="block">'.$plant['name'].', нужно: <img src="/img/icons/tomato.png">'.$ass1['plant-1'].'';
if($assUser['assignment']==$ass1['id'] && $assUser['plant1']<$ass1['plant-1'])echo', у вас: <img src="/img/icons/tomato.png">'.$assUser['plant1'].'';
echo'</div>';
if($ass1['plant1']>0 && $assUser['plant1']>=$ass1['plant-1'])echo'<div class="block">'.$plant['name'].' - Собрано!</div>';
///////////
if($ass1['plant2']>0 && $assUser['plant2']<$ass1['plant-2'])echo'<div class="block">'.$plant1['name'].', нужно: <img src="/img/icons/tomato.png">'.$ass1['plant-2'].'';
if($assUser['assignment']==$ass1['id'] && $assUser['plant2']<$ass1['plant-2'])echo', у вас <img src="/img/icons/tomato.png">'.$assUser['plant2'].'';
echo'</div>';
if($ass1['plant2']>0 && $assUser['plant2']>=$ass1['plant-2'])echo'<div class="block">'.$plant1['name'].' - Собрано!</div>';
///////////
if($ass1['plant3']>0 && $assUser['plant3']<$ass1['plant-3'])echo'<div class="block">'.$plant2['name'].', нужно: <img src="/img/icons/tomato.png">'.$ass1['plant-3'].'';
if($assUser['assignment']==$ass1['id'] && $assUser['plant3']<$ass1['plant-3'])echo', у вас <img src="/img/icons/tomato.png">'.$assUser['plant3'].'';
if($ass1['plant3']>0 && $assUser['plant3']>=$ass1['plant-3'])echo'<div class="block">'.$plant2['name'].' - Собрано!</div>';
//////////
if($ass1['pet1']>0 && $assUser['pet1']<$ass1['pet-1'])echo'<div class="block">'.$pet['tovar'].', нужно: <img src="/img/icons/animal.png">'.$ass1['pet-1'].'';
if($assUser['assignment']==$ass1['id'] && $assUser['pet1']<$ass1['pet-1'])echo', у вас <img src="/img/icons/animal.png">'.$assUser['pet1'].'';
echo'</div>';
if($ass1['pet1']>0 && $assUser['pet1']>=$ass1['pet-1'])echo'<div class="block">'.$pet['tovar'].' - Собрано!</div>';
//////////
if($ass1['pet2']>0 && $assUser['pet2']<$ass1['pet-2'])echo'<div class="block">'.$pet2['tovar'].', нужно: <img src="/img/icons/animal.png">'.$ass1['pet-2'].'';
if($assUser['assignment']==$ass1['id'] && $assUser['pet2']<$ass1['pet-2'])echo', у вас <img src="/img/icons/animal.png">'.$assUser['pet2'].'';
echo'</div>';
if($ass1['pet2']>0 && $assUser['pet2']>=$ass1['pet-2'])echo'<div class="block">'.$pet2['tovar'].' - Собрано!</div>';
if($ass1['pet3']>0 && $assUser['pet3']<$ass1['pet-3'])echo'<div class="block">'.$pet3['tovar'].', нужно: <img src="/img/icons/animal.png">'.$ass1['pet-3'].'';
if($assUser['assignment']==$ass1['id'] && $assUser['pet3']<$ass1['pet-3'])echo', у вас <img src="/img/icons/animal.png">'.$assUser['pet3'].'';
echo'</div>';
if($ass1['pet3']>0 && $assUser['pet3']>=$ass1['pet-3'])echo'<div class="block">'.$pet3['tovar'].' - Собрано!</div>';
if($ass1['money']>0) $a1='<br><img src="/img/icons/money.png"> '.$ass1['money'].' ';
if($ass1['ruby']>0) $a2='<br><img src="/img/icons/ruby.png"> '.$ass1['ruby'].' ';
if($ass1['scarerow']>0) $a3='<br><img src="/img/icons/scarerow.png"> '.$ass1['scarerow'].' часов ';
if($ass1['hydropinics']>0) $a4='<br><img src="/img/icons/hydropinics.png"> '.$ass1['type_hydropinics'].'% ('.$ass1['hydropinics'].' ч.) ';
if($ass1['exp']>0) $a5='<br><img src="/img/icons/experience.png"> '.$ass1['exp'].' ';
if($ass1['colorName']>0) $a6='<br><font color="'.$ass1['type_color'].'">цвет ника</font> ('.$ass1['colorName'].' ч.) ';
if($ass1['key_gold']>0) $a7='<br><img width="16" height="16" src="/img/icons/key.png"> золотой ключ ( '.$ass1['key_gold'].' шт.) ';
if($ass1['key_normal']>0) $a8='<br><img width="16" height="16" src="/img/icons/key.png"> обычный ключ ('.$ass1['key_normal'].' шт.) ';
if($ass1['key_bronze']>0) $a9='<br><img width="16" height="16" src="/img/icons/key.png"> бронзовый ключ ('.$ass1['key_bronze'].' шт.) ';
if($ass1['key_magic']>0) $a10='<br><img width="16" height="16" src="/img/icons/key.png"> проклятый ключ ('.$ass1['key_magic'].' шт.) ';
if($ass1['key_silver']>0) $a11='<br><img width="16" height="16" src="/img/icons/key.png"> серебрянный ключ ('.$ass1['key_silver'].' шт.) ';
echo'<div class="block">Награда: '.$a1.''.$a2.''.$a3.''.$a4.''.$a5.''.$a6.''.$a7.''.$a8.''.$a9.''.$a10.''.$a11.'</div>';
if($ass1['id']==$assUser['assignment'])echo'<div class="block"><img width="16" height="16" src="/img/icons/clock.png"> Задание выполняется....</div>';
if($assUser['assignment']<1 && $ku['level']>=$ass1['level'])echo'<div class="block"><a href="/assignments/id/'.$ass1['id'].'/go"><img src="/img/icons/tick.png"> Начать выполнение!</a></div>';
if($assUser['assignment']>0 && $ass1['id']==$assUser['assignment'])echo'<div class="block"><a href="/assignments/id/'.$ass1['id'].'/no"><img src="/img/icons/cross.png"> Отказаться</a></div>';
if($ass1['id']==$assUser['assignment'] && $assUser['plant1']>=$ass1['plant-1'] && $assUser['plant2']>=$ass1['plant-2'] && $assUser['plant3']>=$ass1['plant-3'] && $assUser['pet1']>=$ass1['pet-1'] && $assUser['pet2']>=$ass1['pet-2'] && $assUser['pet3']>=$ass1['pet-3'])echo'<div class="block"><a href="/assignments/id/'.$ass1['id'].'/prize"><img src="/img/icons/tick.png"> Забрать награду</a></div>';
}
}
if($log>0){echo'<div class="block"><img src="/img/icons/clock.png"> Вы выполняли это задание '.date('d.m.Y в H:i', $log['time']).'</div>';
echo'<a href="/assignments"><div class="block"><img src="/img/icons/back.png"> К списку заданий</a></div>';
}
echo'</div></div>';
echo"</div></div></div></div><div class='rzd2'></div>";
include_once'../system/foot.php';
}
echo"<div class='rzd2'></div><div class='menuin2'>";
echo'<div class="title">Задания</div>';
$ku['set'] = 100000;
$post = mysql_fetch_array(mysql_query("SELECT * FROM `assignments`"));
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `assignments`"),0);
if ($k_post==0)
{
echo "<div class='div'>Нет заданий</div>";
}
$k_page=k_page($k_post,$ku['set']);
$page=page($k_page);
$start=$ku['set']*$page-$ku['set'];
$assUser = mysql_fetch_array(mysql_query("SELECT * FROM `assignments_user` WHERE `id_user` = '$ku[id]'"));
$xx = mysql_query("SELECT * FROM `assignments` ORDER BY level ASC LIMIT $start, $ku[set]");
while($ass=mysql_fetch_assoc($xx)){
echo "<a href='/assignments/id/$ass[id]'><div class='block'>$ass[name] </a>";
if($ass['id']==$assUser['assignment'])echo "<img src='/img/icons/clock.png'>";
echo "<div style='float:right'><img src='/img/icons/experience.png'>$ass[level] ур.</div></div>";
}
echo'</div></div>';
echo"</div></div><div class='rzd2'></div>";
include_once'../system/foot.php';
?>