Просмотр архива Новый колхоз


<?
$x = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `times` = '24'"),0);
$xx = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `time_soils` = '24'"),0);
$xxx1 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `ratings` > '24'"),0);
$xxx2 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `ratings` > '54'"),0);
$xxx3 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `ratings` > '74'"),0);
$xxx4 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `ratings` > '99'"),0);
$xxx5 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `ratings` > '124'"),0);
$xxx6 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `ratings` > '154'"),0);
$xxx7 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `ratings` > '174'"),0);
$xxx8 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `ratings` > '199'"),0);
$xxxx1 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `moneys` > '24'"),0);
$xxxx2 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `moneys` > '54'"),0);
$xxxx3 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `moneys` > '74'"),0);
$xxxx4 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `moneys` > '99'"),0);
$xxxx5 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `moneys` > '124'"),0);
$xxxx6 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `moneys` > '154'"),0);
$xxxx7 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `moneys` > '174'"),0);
$xxxx8 = mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_plant` WHERE `id_collective` = '$ct[id]' AND `moneys` > '199'"),0);
$nexxx =$x+$xx+$xxx1+$xxx2+$xxx3+$xxx4+$xxx5+$xxx6+$xxx7+$xxx8+$xxxx1+$xxxx2+$xxxx3+$xxxx4+$xxxx5+$xxxx6+$xxxx7+$xxxx8;
$ct['next_level']=$ct['level']+1;
$ct['flowerbed_max']=(($ct['level']*10));
$ct['users_max']=($ct['level']*5)+10+$ct['users_add'];
$ct['users']=mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_user` WHERE `id_collective` = '$ct[id]'"),0);

$z1 = mysql_result(mysql_query("SELECT SUM(ratings) FROM `farm_plant` WHERE `id_collective` = '$ct[id]'"), 0);
$z2 = mysql_result(mysql_query("SELECT SUM(times) FROM `farm_plant` WHERE `id_collective` = '$ct[id]'"), 0);
$z3 = mysql_result(mysql_query("SELECT SUM(time_soils) FROM `farm_plant` WHERE `id_collective` = '$ct[id]'"), 0);
$z4 = mysql_result(mysql_query("SELECT SUM(moneys) FROM `farm_plant` WHERE `id_collective` = '$ct[id]'"), 0);
$zexxx = $z1+$z2+$z3+$z4;
$bx = "1.09".(6999+$zexxx)."";
if($nexxx>0){$x3=pow($bx,$nexxx)*1000;}else{$x3=pow($bx,0.1)*1000;}

if(isset($_GET['cash']) && isset($mc) && $ct['id']==$mc['id'])include_once 'sys/collective/cash.php';
elseif(isset($_GET['drug'])){include_once 'sys/other/drug.php';}

elseif(isset($_GET['hangar'])){include_once 'sys/collective/hangar.php';}
else if(isset($_GET['selsovet'])){include_once 'sys/collective/selsovet/index.php';}
else if(isset($_GET['lab']) && isset($mc) && $mc['id']==$ct['id']){include_once 'sys/collective/lab/index.php';}
else if(isset($_GET['mailing']) && isset($mc) && $mcu['status']<=3 && $mc['id']==$ct['id']){include_once 'sys/collective/mailing_ct.php';}
else if(isset($_GET['nalog']) && isset($mc) && $mc['id']==$ct['id'] && $mcu['status']==1)include_once 'sys/collective/nalog.php';
else if(isset($_GET['flowerbed']) && isset($mc) && $mc['id']==$ct['id'])include_once 'sys/collective/flowerbed_ct.php';




elseif(isset($_GET['club']))include_once 'sys/collective/club.php';
elseif(isset($_GET['zags']))include_once 'sys/collective/zags.php';
elseif(isset($_GET['buildings']))include_once 'sys/collective/buildings.php';
else if(isset($_GET['station']))include_once 'sys/collective/hangar/station.php';


echo "<title>Колхоз: $ct[name]</title>";

echo"<div class='content'><div class='block'>";
if($ku['photo_open']==1)
{
echo"<div><img src='/images/guild480_.jpg' width = '100%'alt='kolhoz'></div>";
}
echo"<ul class='minor'>";
echo"<li>Уровень: <span class='title'>$ct[level]</span></li>";
$rating_need=pow(2.71,$ct['level']+1)*1000;
echo"<li>Опыт: <span class='title'>".rating($ct['rating'])."</span>/<span>".rating($rating_need)."</span></li>";
echo"<li>Механизация: <span class='title'> $ct[tehnika]</span><span>(<span>".(round($ct['tehnika']/20,2))."</span>%)</span></li>";

echo"<li>Рейтинг по селекции: <span class='title'>".floor($x3)."</span> (<span><span class='nobr'><img width='16' height='16' src='/images/icons/ruby.png' alt='o'> <span class='title'>$nexxx</span></span></span>)</li>";
echo"</ul>";
if(isset($mc) && $ct['id']==$mc['id']){
if($mcu['status']<=3 && $ct['titleText']==NULL || $ct['titleText']!=NULL)echo "<div><h3>Объявление</h3><div><ul>";
if($mcu['status']<=3 && isset($_GET['titleText'])){
if(isset($_POST['titleText']) && strlen2($_POST['titleText'])<=64){
mysql_query("UPDATE `farm_collective` SET `titleText` = '".mysql_real_escape_string($_POST['titleText'])."', `titleText_user` = '$ku[id]', `titleText_time` = '$time' WHERE `id` = '$ct[id]'");
header("Location:/mycollective");}
else echo "<form method='post'><div><label for='titleText'>Текст объявления:</label></div>n
<div><textarea id='titleText' class='wide' rows='2' name='titleText'>".htmlspecialchars($ct['titleText'])."</textarea></div>n
<input type='submit' value='Сохранить'>n
</form>n";
}
if($ct['titleText']!=NULL)
{
$uk=mysql_fetch_array(mysql_query("SELECT * FROM `farm_user` WHERE `id` = '$ct[titleText_user]'"));
echo "<li><span>";
echo "".on_k($uk['id'])."";
echo " <a class='' href='/user/$uk[id]'><span>".nc($ct['titleText_user'])."</span></a> <span class='minor'>".vremja($ct['titleText_time'])."<span></span></span></span></li>";
echo "<li><span class='title'><p>".output_text($ct['titleText'])."</p></span></li>";
}
if($mcu['status']<=3 && !isset($_GET['titleText']))echo "<li><a".($ct['titleText']!=NULL?" class='minor'":null)." href='/mycollective/titleText'>".($ct['titleText']!=NULL?"изменить":"Дать объявление")."</a></li>";
if($mcu['status']<=3 && $ct['titleText']==NULL || $ct['titleText']!=NULL)echo "</ul></div><div></div></div>
";
}

echo"<h3>Здания</h3>";

echo"<li><img width='16' height='16' src='/images/icons/new/favorite.png' alt='*'> <a class='epic' href='/collective-$ct[id]/selsovet'>Сельсовет</a> <span class='minor'>(<span>$ct[users]</span>/<span>$ct[users_max]</span>)</span> <span class='minor small'>Чат, колхозники, рейтинги, история колхоза.</span></li>";

if(isset($mc) && $mc['id']==$ct['id']){
$count_max=$ct['level']*10;
$time_rubies=floor(86400/$count_max);
$time_mezh=$time-$ct['time_obmen'];
$count_rubies=floor($time_mezh/$time_rubies);
if($count_rubies>$count_max)$count_rubies=$count_max;
$count_flowerbed=$count_rubies;
$hhh=$ct['flowerbed_max']+$nexxx;
echo "<li><img width='16' height='16' src='/images/icons/new/guild_flowerbed.png' alt='*'> <a class='epic' href='/collective-$ct[id]/flowerbed'>Цветник</a> ".($ct['flowerbed']==1?"<span class='minor'>(<span>$count_flowerbed</span>/<span>$hhh</span>)</span>":null)."<span class='small minor'>Обмен колхозных монет на алмазы.</span></li>";
}

echo"<li><img width='16' height='16' src='/images/icons/new/forum.png' alt='*'> <a class='epic' href='/collective-$ct[id]/club'>Дом культуры</a></span> <span class='small minor'>Колхозные форумы.</span></li>";
if(isset($mc) && $mc['id']==$ct['id']){
echo "<li><img width='16' height='16' src='/images/icons/new/mails.png' alt='*'> ".($mcu['status']<=3?"<a class='epic' href='/collective-$ct[id]/mailing'>":"<span class='epic'>")."Почтамт".($mcu['status']<=3?"</a>":"</span>")."".($mcu['status']>3?" <span class='small minor'>(доступно начиная с агронома)</span>":null)." <span class='small minor'>Рассылка жителям колхоза.</span></li>";
echo"<li><img width='16' height='16' src='/images/icons/new/ruby.png' alt='*'> <a class='epic' href='/collective-$ct[id]/cash'>Касса</a> <span class='minor'><span><img width='16' height='16' src='/images/icons/ruby.png' alt='o'> <span class='title'>".numbers($ct['rubies'])."</span></span> <span><img width='16' height='16' src='/images/icons/money.png' alt='o'> <span class='title'>".numbers($ct['money'])."</span></span></span> <span class='small minor'>Пополнение кассы, рейтинги плательщиков.</span></li>";
}



echo "<li><img width='16' height='16' src='/images/icons/new/tax.png' alt='o'> ".($mcu['status']==1 && isset($mc) && $mc['id']==$ct['id']?"<a class='epic' href='/collective-$ct[id]/nalog'>":"<span class='epic'>")."Налоговая".($mcu['status']==1 && isset($mc) && $mc['id']==$ct['id']?"</a>":"</span>")."".($ct['nalog']>0?" <span class='minor'><span>$ct[nalog]</span>%</span>":null)." <span class='small minor'>Колхозный налог на монеты.</span></li>";


echo"<li><img width='16' height='16' src='/images/icons/new/hangar.png' alt='o'> <a class='epic' href='/collective-$ct[id]/hangar'>Ангар</a> <span class='minor'>(<span>".mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_heli` WHERE `id_collective` = '$ct[id]' AND `heli` = '1'"),0)."</span>, <span>".mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_heli` WHERE `id_collective` = '$ct[id]' AND `heli` = '2'"),0)."</span>, <span>".mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_heli` WHERE `id_collective` = '$ct[id]' AND `heli` = '3'"),0)."</span>, <span>".mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_heli` WHERE `id_collective` = '$ct[id]' AND `heli` = '4'"),0).",<span>".mysql_result(mysql_query("SELECT COUNT(*) FROM `farm_collective_heli` WHERE `id_collective` = '$ct[id]' AND `heli` = '5'"),0)."</span>)</span> <span class='small minor'>Колхозные вертолеты.</span></li>";


echo"<li><img width='16' height='16' src='/images/icons/new/zags.png' alt='o'> <a class='epic' href='/collective-$ct[id]/zags'>Загс</a> <span class='small minor'>Заключение браков.</span></li>";
echo"<li><img width='16' height='16' src='/images/icons/new/guild.png' alt='o'> <a class='epic' href='/collective-$ct[id]/buildings'>Постройки</a></li>";

if(isset($mc) && $mc['id']==$ct['id']){echo"<li><img width='16' height='16' src='/images/icons/new/lab.png' alt='o'> <a class='epic' href='/collective-$ct[id]/lab'>Лаборатория</a> <span class='small minor'>Селекция растений.</span></li>";}
echo"</div>";

include_once 'sys/other/foot.php';


?>