Такая ерунда в колизее при вставании в очередь на бой выдает +3 а надо +1,код ниже,что не так?

<?
require_once ('core/base.php');
falseauth();
$coliseum_quest = $base -> query("SELECT * FROM `coliseum_quest` WHERE `id_user` = '$u[id]' LIMIT 1") -> fetch_assoc();
if(!$coliseum_quest){
$base -> query("INSERT INTO `coliseum_quest` SET `id_user` = '$u[id]'");
header('Location: ?');
exit();
}
if(isset($_GET['nagrada']) and $coliseum_quest['wins_koll'] >= 2){
$base -> query("UPDATE `users` SET `gold` = `gold`+'5', `exp` = `exp`+'500' WHERE `id` = '$u[id]' LIMIT 1");
$orden = $base -> query("SELECT * FROM `orden_users` WHERE `id_user` = '".$u['id']."' LIMIT 1") -> fetch_assoc();
if($orden)
{
if($orden['rang'] == 6 and $orden['loyalty'] < 15)$exp_orden = ceil(500*15/100);
else $exp_orden = ceil(500*$orden['loyalty']/100);
$base -> query("UPDATE `orden_users` SET `exp` = `exp`+'$exp_orden' WHERE `id` = '$orden[id]' LIMIT 1");
$base -> query("UPDATE `ordens` SET `exp` = `exp`+'$exp_orden' WHERE `id` = '$orden[id_orden]' LIMIT 1");
}
$base -> query("UPDATE `coliseum_quest` SET `wins_koll` = '0', `last` = '".(time()+60*60*24)."' WHERE `id` = '$coliseum_quest[id]' LIMIT 1");
$_SESSION['message'] = 'Награда получена успешно';
header('Location: ?');
exit();
}
switch($act){
case 'battle':
$user = $base -> query("SELECT * FROM `coliseum_battle_users` WHERE `id_user` = '$u[id]' AND `battle_end` = '0' LIMIT 1") -> fetch_assoc();
if(!$user){
header('Location: /coliseum/');
exit();
}
$battle = $base -> query("SELECT * FROM `coliseum_battle` WHERE `id` = '$user[id_battle]' AND `start` >= '2' LIMIT 1") -> fetch_assoc();
if($battle['start'] == 3){
#### Задание Легенда Колизея ####
$quest_glav = $base -> query("SELECT * FROM `quest_glavs_users` WHERE `id_user` = '$u[id]' LIMIT 1") -> fetch_assoc();
$quest = $base -> query("SELECT * FROM `quest` WHERE `name` = 'Легенда Колизея' AND `id_glav` = '$quest_glav[id_glav]' LIMIT 1") -> fetch_assoc();
$quest_user = $base -> query("SELECT * FROM `quest_users` WHERE `id_quest` = '$quest[id]' AND `id_user` = '$u[id]' LIMIT 1") -> fetch_assoc();
if($quest_user and $quest_user['yes'] == 0 AND $quest_user['progress'] < $quest_user['max_progress']){
$base -> query("UPDATE `quest_users` SET `progress` = `progress`+'1' WHERE `id` = '$quest_user[id]' LIMIT 1");
}
#################################
$base -> query("UPDATE `coliseum_battle_users` SET `battle_end` = '1' WHERE `id` = '$user[id]' LIMIT 1");
$header = 'Колизей';
require_once ('core/head.php');
echo '<div class="cntr">';
$sql = $base -> query("SELECT * FROM `coliseum_battle_users` WHERE `id_battle` = '$battle[id]' ORDER BY `battle_end_time` DESC, `urons` DESC LIMIT 5");
while($v = $sql -> fetch_assoc()){
$a++;
$users = $base -> query("SELECT * FROM `users` WHERE `id` = '$v[id_user]' LIMIT 1") -> fetch_assoc();
if($users['id'] == $u['id']){
if($a == 1){
$exp = 100;
$silver = 500;
}
if($a == 2){
$exp = 70;
$silver = 400;
}
if($a == 3){
$exp = 50;
$silver = 300;
}
if($a == 4){
$exp = 30;
$silver = 200;
}
if($a == 5){
$exp = 10;
$silver = 100;
}
$amulet = $base -> query("SELECT * FROM `amulet` WHERE `id_user` = '".$users['id']."' LIMIT 1") -> fetch_assoc();
if($amulet){
$exp += ceil($exp*amulet_exp($amulet['level'])/100);
$silver += ceil($silver*amulet_silver($amulet['level'])/100);
}
$orden = $base -> query("SELECT * FROM `orden_users` WHERE `id_user` = '".$users['id']."' LIMIT 1") -> fetch_assoc();
if($orden)
{
if($orden['rang'] == 6 and $orden['loyalty'] < 15)$exp_orden = ceil($exp*15/100);
else $exp_orden = ceil($exp*$orden['loyalty']/100);
$base -> query("UPDATE `orden_users` SET `exp` = `exp`+'$exp_orden' WHERE `id` = '$orden[id]' LIMIT 1");
$base -> query("UPDATE `ordens` SET `exp` = `exp`+'$exp_orden' WHERE `id` = '$orden[id_orden]' LIMIT 1");
}
$base -> query("UPDATE `users` SET `exp` = `exp`+'".$exp."', `silver` = `silver`+'".$silver."' WHERE `id` = '$users[id]' LIMIT 1");
echo '<span class="c_lgreen2 bold">Награда за '.$a.' место</span><br>';
echo '<img src="/design/images/icons/exp.png" class="icons"> '.$exp.' опыта и <img src="/design/images/icons/silver.png" class="icons"> '.$silver.' серебра';
echo '<div class="hr"><div class="hr_end"></div></div>';
}
}
$sql = $base -> query("SELECT * FROM `coliseum_battle_users` WHERE `id_battle` = '$battle[id]' ORDER BY `battle_end_time` DESC, `urons` DESC LIMIT 1");
$v = $sql -> fetch_assoc();
$users = $base -> query("SELECT * FROM `users` WHERE `id` = '$v[id_user]' LIMIT 1") -> fetch_assoc();
if($users['id'] == $u['id'] and $coliseum_quest['last'] <= time()){
$base -> query("UPDATE `coliseum_quest` SET `wins_koll` = `wins_koll`+'1' WHERE `id` = '$coliseum_quest[id]' LIMIT 1");
}
echo '<span class="c_lgreen2">Самый лучший</span> '.user_img($users['id']).' '.who($users['id']).'';
echo '<div class="hr"><div class="hr_end"></div></div>';
$rating_nagrada = array(1 => '+4', 2 => '+2', 3 => '+0', 4 => '-2', 5 => '-4');
$sql = $base -> query("SELECT * FROM `coliseum_battle_users` WHERE `id_battle` = '$battle[id]' ORDER BY `battle_end_time` DESC, `urons` DESC LIMIT 5");
while($v = $sql -> fetch_assoc()){
$i++;
$users = $base -> query("SELECT * FROM `users` WHERE `id` = '$v[id_user]' LIMIT 1") -> fetch_assoc();
if($users['id'] == $u['id'])$base -> query("UPDATE `users` SET `coliseum_ra

че спеклись?

кодеры мля

Лаз?????

одни говнокодеры боже зря я увидел надо было глаз закрыть как открыл тему

Для начала научись код нормально скидывать, что бы его можно было удобно читать...

Вы просите помощи, а это добровольная основа + тем кто на доске не очень то и хочется помогать.

JCtapuk , нормальный код,у тебя лучше?

ZnTor , нормально скинут