почему награду в минус зачисляет?
//
//
if($m1['tour'] >= 1){
//
//
$coll1 = intval($m1['tour']*15/300);
//
//
if($m1){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll1-50,$m1['id']));
}
//
//
$m2 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m1['tour'],$m1['id']));
//
//
$coll2 = intval($m2['tour']*15/300);
//
//
if($m2){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll2-50,$m2['id']));
}
//
//
$m3 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m2['tour'],$m1['id'],$m2['id']));
//
//
$coll3 = intval($m3['tour']*15/300);
//
//
if($m3){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll3-50,$m3['id']));
}
//
//
$m4 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m3['tour'],$m1['id'],$m2['id'],$m3['id']));
//
//
$coll4 = intval($m4['tour']*15/300);
//
//
if($m4){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll4-50,$m4['id']));
}
//
//
$m5 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m4['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id']));
//
//
$coll5 = intval($m5['tour']*15/300);
//
//
if($m5){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll5-50,$m5['id']));
}
//
//
$m6 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m5['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id']));
//
//
$coll6 = intval($m6['tour']*15/300);
//
//
if($m6){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll6-50,$m6['id']));
}
//
//
$m7 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m6['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id'],$m6['id']));
//
//
$coll7 = intval($m7['tour']*15/300);
//
//
if($m7){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll7-50,$m7['id']));
}
//
//
$m8 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m7['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id'],$m6['id'],$m7['id']));
//
//
$coll8 = intval($m8['tour']*15/300);
//
//
if($m8){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll8-50,$m8['id']));
}
//
//
$m9 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m8['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id'],$m6['id'],$m7['id'],$m8['id']));
//
//
$coll9 = intval($m8['tour']*15/300);
//
//
if($m9){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll9-50,$m9['id']));
}
//
//
$m10 = fch("SELECT * FROM `users` WHERE `tour` <= ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? AND `id` != ? ORDER BY `tour` DESC LIMIT 1", array($m9['tour'],$m1['id'],$m2['id'],$m3['id'],$m4['id'],$m5['id'],$m6['id'],$m7['id'],$m8['id'],$m9['id']));
//
//
$coll10 = intval($m10['tour']*15/300);
//
//
if($m10){
qry("UPDATE `users` SET `gold` = `gold` + ? WHERE `id` = ? LIMIT 1", array($coll10-50,$m10['id']));
}

Подскажет кто?

Во всём коде $collN-50 замени на $collN+50
________
посл. ред. 22.01.2021 в 11:37; всего 2 раз(а); by Hryhorii_Ivlev

Hryhorii_Ivlev , золото в коде же видно,почему тока в минус?может из-за того что -50 стоит где кол-во?

Именно

Hryhorii_Ivlev , Награда в рубинах рассчитывается по формуле (Ваши кубки*5/100).

И что? Запрос в бд идёт с минусом, поставь везде плюс и всё

Hryhorii_Ivlev , по формуле мне ее как поправить?чтоб не переволило за 5000тыс рубинов?

?

Hryhorii_Ivlev , Награда в рубинах рассчитывается по формуле (Ваши кубки*5/100).