Файл: tankon.mobi/stepi4.php
Строк: 209
<?php
@mysql_connect('localhost', 'tankon', '385331581631vbnvb');
@mysql_select_db('tankon');
@mysql_set_charset('utf8');
/*1*/
mysql_query("UPDATE `tanks_tournament` SET `konec`='2' WHERE `name`='Битва в Степях' ");
$tour_winkass= mysql_fetch_array(mysql_query("SELECT * FROM `tanks_tournament` where `name`='Битва в Степях'"));
$tour_winka= mysql_query("SELECT * FROM `tanks_tournament_users` where `tour`='".$tour_winkass['id']."'");
while($tour_winkas = mysql_fetch_array($tour_winka)) {
mysql_query("UPDATE `tanks` SET `tour`='0' WHERE `id`='".$tour_winkas['user']."'");
mysql_query("UPDATE `tanks_tournament_users` SET `vkl`='1' WHERE `user`='".$tour_winkas ['user']."'");
}
$tour_win= mysql_query("SELECT * FROM `tanks_tournament_users` where `tour`='".$tour_winkass['id']."' ORDER BY win DESC LIMIT 3");
$i=0;
while($tour_wins = mysql_fetch_array($tour_win)) {
$i++;
$tourka= mysql_fetch_array(mysql_query("SELECT * FROM `tanks_tournament` where `id`='".$tour_wins['tour']."'"));
$mc_tour= mysql_fetch_array(mysql_query("SELECT * FROM `collective_user` WHERE `id_user` = '".$tour_wins['user']."'"));
mysql_query("UPDATE `collective` SET `rating` = `rating`+'".$tourka['rating']."' WHERE `id`='".$mc_tour['id_collective']."'");
mysql_query("UPDATE `collective_user` SET `rating` = `rating`+'".$tourka['rating']."' WHERE `id_user`='".$tour_wins['user']."'");
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `tanks_medal` WHERE `id_user` = '".$tour_wins['user']."' AND `zadan` = 'Победу в Сражении'"), 0)==0){
mysql_query("INSERT INTO `tanks_medal` (`id_user`,`name`,`screen`,`tank`,`zadan`) VALUES ('".$tour_wins['user']."','Счастливчик','lucky.png','".$tour_wins['tanks']."','Победу в Сражении')");
}else{
mysql_query("UPDATE `tanks_medal` SET `kollvo`=`kollvo`+'1' WHERE `id_user`='".$tour_wins['user']."' AND `zadan`='Победу в Сражении'");
}
if($i==1){$priz_zol=$tourka['zolota'];}
elseif($i==2){$priz_zol=$tourka['zolota']/2;}
elseif($i==3){$priz_zol=$tourka['zolota']/4;}
mysql_query("UPDATE `tanks` SET `zolota`=`zolota`+'".$priz_zol."',`rating`=`rating`+'".$tourka['rating']."',`pob_boj`=`pob_boj`+'1' WHERE `id`='".$tour_wins['user']."'");
mysql_query("UPDATE `zadan` SET `nachalo`=`nachalo`+'1' WHERE `id_user`='".$tour_wins['user']."' AND `type`='9'");
}
/*2*/
mysql_query("UPDATE `tanks_tournament` SET `konec`='2' WHERE `name`='Битва под Москвой' ");
$tour_winkass= mysql_fetch_array(mysql_query("SELECT * FROM `tanks_tournament` where `name`='Битва под Москвой'"));
$tour_winka= mysql_query("SELECT * FROM `tanks_tournament_users` where `tour`='".$tour_winkass['id']."'");
while($tour_winkas = mysql_fetch_array($tour_winka)) {
mysql_query("UPDATE `tanks` SET `tour`='0' WHERE `id`='".$tour_winkas['user']."'");
mysql_query("UPDATE `tanks_tournament_users` SET `vkl`='1' WHERE `user`='".$tour_winkas ['user']."'");
}
$tour_win= mysql_query("SELECT * FROM `tanks_tournament_users` where `tour`='".$tour_winkass['id']."' ORDER BY win DESC LIMIT 3");
$i=0;
while($tour_wins = mysql_fetch_array($tour_win)) {
$i++;
$tourka= mysql_fetch_array(mysql_query("SELECT * FROM `tanks_tournament` where `id`='".$tour_wins['tour']."'"));
$mc_tour= mysql_fetch_array(mysql_query("SELECT * FROM `collective_user` WHERE `id_user` = '".$tour_wins['user']."'"));
mysql_query("UPDATE `collective` SET `rating` = `rating`+'".$tourka['rating']."' WHERE `id`='".$mc_tour['id_collective']."'");
mysql_query("UPDATE `collective_user` SET `rating` = `rating`+'".$tourka['rating']."' WHERE `id_user`='".$tour_wins['user']."'");
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `tanks_medal` WHERE `id_user` = '".$tour_wins['user']."' AND `zadan` = 'Победу в Сражении'"), 0)==0){
mysql_query("INSERT INTO `tanks_medal` (`id_user`,`name`,`screen`,`tank`,`zadan`) VALUES ('".$tour_wins['user']."','Счастливчик','lucky.png','".$tour_wins['tanks']."','Победу в Сражении')");
}else{
mysql_query("UPDATE `tanks_medal` SET `kollvo`=`kollvo`+'1' WHERE `id_user`='".$tour_wins['user']."' AND `zadan`='Победу в Сражении'");
}
if($i==1){$priz_zol=$tourka['zolota'];}
elseif($i==2){$priz_zol=$tourka['zolota']/2;}
elseif($i==3){$priz_zol=$tourka['zolota']/4;}
mysql_query("UPDATE `tanks` SET `zolota`=`zolota`+'".$priz_zol."',`rating`=`rating`+'".$tourka['rating']."',`pob_boj`=`pob_boj`+'1' WHERE `id`='".$tour_wins['user']."'");
mysql_query("UPDATE `zadan` SET `nachalo`=`nachalo`+'1' WHERE `id_user`='".$tour_wins['user']."' AND `type`='9'");
}
/*3*/
mysql_query("UPDATE `tanks_tournament` SET `konec`='2' WHERE `name`='Битва в Заполярье' ");
$tour_winkass= mysql_fetch_array(mysql_query("SELECT * FROM `tanks_tournament` where `name`='Битва в Заполярье'"));
$tour_winka= mysql_query("SELECT * FROM `tanks_tournament_users` where `tour`='".$tour_winkass['id']."'");
while($tour_winkas = mysql_fetch_array($tour_winka)) {
mysql_query("UPDATE `tanks` SET `tour`='0' WHERE `id`='".$tour_winkas['user']."'");
mysql_query("UPDATE `tanks_tournament_users` SET `vkl`='1' WHERE `user`='".$tour_winkas ['user']."'");
}
$tour_win= mysql_query("SELECT * FROM `tanks_tournament_users` where `tour`='".$tour_winkass['id']."' ORDER BY win DESC LIMIT 3");
$i=0;
while($tour_wins = mysql_fetch_array($tour_win)) {
$i++;
$tourka= mysql_fetch_array(mysql_query("SELECT * FROM `tanks_tournament` where `id`='".$tour_wins['tour']."'"));
$mc_tour= mysql_fetch_array(mysql_query("SELECT * FROM `collective_user` WHERE `id_user` = '".$tour_wins['user']."'"));
mysql_query("UPDATE `collective` SET `rating` = `rating`+'".$tourka['rating']."' WHERE `id`='".$mc_tour['id_collective']."'");
mysql_query("UPDATE `collective_user` SET `rating` = `rating`+'".$tourka['rating']."' WHERE `id_user`='".$tour_wins['user']."'");
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `tanks_medal` WHERE `id_user` = '".$tour_wins['user']."' AND `zadan` = 'Победу в Сражении'"), 0)==0){
mysql_query("INSERT INTO `tanks_medal` (`id_user`,`name`,`screen`,`tank`,`zadan`) VALUES ('".$tour_wins['user']."','Счастливчик','lucky.png','".$tour_wins['tanks']."','Победу в Сражении')");
}else{
mysql_query("UPDATE `tanks_medal` SET `kollvo`=`kollvo`+'1' WHERE `id_user`='".$tour_wins['user']."' AND `zadan`='Победу в Сражении'");
}
if($i==1){$priz_zol=$tourka['zolota'];}
elseif($i==2){$priz_zol=$tourka['zolota']/2;}
elseif($i==3){$priz_zol=$tourka['zolota']/4;}
mysql_query("UPDATE `tanks` SET `zolota`=`zolota`+'".$priz_zol."',`rating`=`rating`+'".$tourka['rating']."',`pob_boj`=`pob_boj`+'1' WHERE `id`='".$tour_wins['user']."'");
mysql_query("UPDATE `zadan` SET `nachalo`=`nachalo`+'1' WHERE `id_user`='".$tour_wins['user']."' AND `type`='9'");
}
?>