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


<?php
////////////////////Дом

/////////////////////////База комнат
$komnata1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_komnata` WHERE `id_komnata` = '1' AND `id_user` = '$ku[id]'"));
$komnata2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_komnata` WHERE `id_komnata` = '2' AND `id_user` = '$ku[id]'"));
$komnata3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_komnata` WHERE `id_komnata` = '3' AND `id_user` = '$ku[id]'"));
$komnata4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_komnata` WHERE `id_komnata` = '4' AND `id_user` = '$ku[id]'"));
$komnata5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_komnata` WHERE `id_komnata` = '5' AND `id_user` = '$ku[id]'"));
$komnata6=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_komnata` WHERE `id_komnata` = '6' AND `id_user` = '$ku[id]'"));
$komnata7=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_komnata` WHERE `id_komnata` = '7' AND `id_user` = '$ku[id]'"));
$komnata8=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_komnata` WHERE `id_komnata` = '8' AND `id_user` = '$ku[id]'"));
$komnata9=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house_komnata` WHERE `id_komnata` = '9' AND `id_user` = '$ku[id]'"));
////////////////////////////////////////////////////////////////////////////////////////////////////////База предметів
$house1_1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata1[atrebut_1]'"));
$house1_2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata1[atrebut_2]'"));
$house1_3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata1[atrebut_3]'"));
$house1_4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata1[atrebut_4]'"));
$house1_5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata1[atrebut_5]'"));
/////
$house2_1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata2[atrebut_1]'"));
$house2_2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata2[atrebut_2]'"));
$house2_3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata2[atrebut_3]'"));
$house2_4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata2[atrebut_4]'"));
$house2_5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata2[atrebut_5]'"));
$house2_6=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata2[atrebut_6]'"));
/////
$house3_1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata3[atrebut_1]'"));
$house3_2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata3[atrebut_2]'"));
$house3_3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata3[atrebut_3]'"));
$house3_4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata3[atrebut_4]'"));
$house3_5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata3[atrebut_5]'"));
$house3_6=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata3[atrebut_6]'"));
/////
$house4_1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata4[atrebut_1]'"));
$house4_2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata4[atrebut_2]'"));
$house4_3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata4[atrebut_3]'"));
$house4_4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata4[atrebut_4]'"));
$house4_5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata4[atrebut_5]'"));
$house4_6=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata4[atrebut_6]'"));
/////
$house5_1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata5[atrebut_1]'"));
$house5_2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata5[atrebut_2]'"));
$house5_3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata5[atrebut_3]'"));
$house5_4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata5[atrebut_4]'"));
$house5_5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata5[atrebut_5]'"));
$house5_6=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata5[atrebut_6]'"));
/////
$house6_1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata6[atrebut_1]'"));
$house6_2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata6[atrebut_2]'"));
$house6_3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata6[atrebut_3]'"));
$house6_4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata6[atrebut_4]'"));
$house6_5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata6[atrebut_5]'"));
$house6_6=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata6[atrebut_6]'"));
/////
$house7_1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata7[atrebut_1]'"));
$house7_2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata7[atrebut_2]'"));
$house7_3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata7[atrebut_3]'"));
$house7_4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata7[atrebut_4]'"));
$house7_5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata7[atrebut_5]'"));
$house7_6=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata7[atrebut_6]'"));
/////
$house8_1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata8[atrebut_1]'"));
$house8_2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata8[atrebut_2]'"));
$house8_3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata8[atrebut_3]'"));
$house8_4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata8[atrebut_4]'"));
$house8_5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata8[atrebut_5]'"));
$house8_6=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata8[atrebut_6]'"));
/////
$house9_1=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata9[atrebut_1]'"));
$house9_2=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata9[atrebut_2]'"));
$house9_3=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata9[atrebut_3]'"));
$house9_4=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata9[atrebut_4]'"));
$house9_5=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata9[atrebut_5]'"));
$house9_6=mysql_fetch_array(mysql_query("SELECT * FROM `farm_house` WHERE `id` = '$komnata9[atrebut_6]'"));
//////////////////////////////////////////////Собираэмо статус
$kulo1=$house1_1['status']+$house1_2['status']+$house1_3['status']+$house1_4['status']+$house1_5['status']+$house1_6['status'];
$kulo2=$house2_1['status']+$house2_2['status']+$house2_3['status']+$house2_4['status']+$house2_5['status']+$house2_6['status'];
$kulo3=$house3_1['status']+$house3_2['status']+$house3_3['status']+$house3_4['status']+$house3_5['status']+$house3_6['status'];
$kulo4=$house4_1['status']+$house4_2['status']+$house4_3['status']+$house4_4['status']+$house4_5['status']+$house4_6['status'];
$kulo5=$house5_1['status']+$house5_2['status']+$house5_3['status']+$house5_4['status']+$house5_5['status']+$house5_6['status'];
$kulo6=$house6_1['status']+$house6_2['status']+$house6_3['status']+$house6_4['status']+$house6_5['status']+$house6_6['status'];
$kulo7=$house7_1['status']+$house7_2['status']+$house7_3['status']+$house7_4['status']+$house7_5['status']+$house7_6['status'];
$kulo8=$house8_1['status']+$house8_2['status']+$house8_3['status']+$house8_4['status']+$house8_5['status']+$house8_6['status'];
$kulo9=$house9_1['status']+$house9_2['status']+$house9_3['status']+$house9_4['status']+$house9_5['status']+$house9_6['status'];
$pure=$kulo1+$kulo2+$kulo3+$kulo4+$kulo5+$kulo6+$kulo7+$kulo8+$kulo9;
////////////////////////////////////////////Собираэмо
$dssd1=$house1_1['conv']+$house1_2['conv']+$house1_3['conv']+$house1_4['conv']+$house1_5['conv']+$house1_6['conv'];
$dssd2=$house2_1['conv']+$house2_2['conv']+$house2_3['conv']+$house2_4['conv']+$house2_5['conv']+$house2_6['conv'];
$dssd3=$house3_1['conv']+$house3_2['conv']+$house3_3['conv']+$house3_4['conv']+$house3_5['conv']+$house3_6['conv'];
$dssd4=$house4_1['conv']+$house4_2['conv']+$house4_3['conv']+$house4_4['conv']+$house4_5['conv']+$house4_6['conv'];
$dssd5=$house5_1['conv']+$house5_2['conv']+$house5_3['conv']+$house5_4['conv']+$house5_5['conv']+$house5_6['conv'];
$dssd6=$house6_1['conv']+$house6_2['conv']+$house6_3['conv']+$house6_4['conv']+$house6_5['conv']+$house6_6['conv'];
$dssd7=$house7_1['conv']+$house7_2['conv']+$house7_3['conv']+$house7_4['conv']+$house7_5['conv']+$house7_6['conv'];
$dssd8=$house['beauty']+$house6_2['beauty']+$house6_3['beauty']+$house6_4['beauty']+$house6_5['beauty']+$house6_6['beauty'];
//////////////////////////////////////////////////
$xxxc1=$house1_1['beauty']+$house1_2['beauty']+$house1_3['beauty']+$house1_4['beauty']+$house1_5['beauty']+$house1_6['beauty'];
$xxxc2=$house2_1['beauty']+$house2_2['beauty']+$house2_3['beauty']+$house2_4['beauty']+$house2_5['beauty']+$house2_6['beauty'];
$xxxc3=$house3_1['beauty']+$house3_2['beauty']+$house3_3['beauty']+$house3_4['beauty']+$house3_5['beauty']+$house3_6['beauty'];
$xxxc4=$house4_1['beauty']+$house4_2['beauty']+$house4_3['beauty']+$house4_4['beauty']+$house4_5['beauty']+$house4_6['beauty'];
$xxxc5=$house5_1['beauty']+$house5_2['beauty']+$house5_3['beauty']+$house5_4['beauty']+$house5_5['beauty']+$house5_6['beauty'];
$xxxc6=$house6_1['conv']+$house8_2['conv']+$house8_3['conv']+$house8_4['conv']+$house8_5['conv']+$house8_6['conv'];
$xxxc7=$house7_1['beauty']+$house7_2['beauty']+$house7_3['beauty']+$house7_4['beauty']+$house7_5['beauty']+$house7_6['beauty'];
$xxxc8=$house8_1['beauty']+$house8_2['beauty']+$house8_3['beauty']+$house8_4['beauty']+$house8_5['beauty']+$house8_6['beauty'];
$xxxc9=$house9_1['beauty']+$house9_2['beauty']+$house9_3['beauty']+$house9_4['beauty']+$house9_5['beauty']+$house9_6['beauty'];
$pures=$xxxc1+$xxxc2+$xxxc3+$xxxc4+$xxxc5+$xxxc6+$xxxc7+$xxxc8+$xxxc9;
$dssd9=$house9_1['conv']+$house9_2['conv']+$house9_3['conv']+$house9_4['conv']+$house9_5['conv']+$house9_6['conv'];
$gut=$dssd1+$dssd2+$dssd3+$dssd4+$dssd5+$dssd6+$dssd7+$dssd8+$dssd9;
////////////////////////масиви
$beaty=$pures;
$conv=$gut;
$status=$pure;
$max=$beaty+$conv+$status;
$tut=500;
$maxc=$max/$tut;
$tut=round($maxc, 0);
////////////////////обновления
mysql_query("UPDATE `farm_user` SET `vidsotok_house` = '$tut' WHERE `id` = '$ku[id]' LIMIT 1");
mysql_query("UPDATE `farm_user` SET `beauty` = '$beaty' WHERE `id` = '$ku[id]' LIMIT 1");
mysql_query("UPDATE `farm_user` SET `conv` = '$conv' WHERE `id` = '$ku[id]' LIMIT 1");
mysql_query("UPDATE `farm_user` SET `statuss` = '$status' WHERE `id` = '$ku[id]' LIMIT 1");
////////////////////Дом/+/

?>