PHP/MySQL | Не добавляет лв PHP
Привет,столкнулся с проблемой вот код для перехода на следующий лв
$bigl=50;
if($arr['lv']<$bigl)
{
if($arr['lv']>1)
{
$rl=0;
$ql=$sql->query("SELECT * FROM `level`");
while($pl=$sql->obj_assoc($ql))
{
if($pl['level']<=$arr['lv']) $rl=$rl+$pl['xp'];
}
$kr=$ku['xp']-$rl;
}
else $kr=$arr['xp'];
$level=$sql->ass("SELECT * FROM `level` WHERE `level` = '".($arr['lv']+1)."' LIMIT 1");
if($kr>=$level['xp'])
{
echo "<div id='cnt'><div align='center'><div id='hdr_m'><b>Новый уровень!</b> Тебе стали доступны новые машины,запчасти и много чего другого.</br><b>Награда:</b> ";
if($level[dollars] > 0 && $level[ex] == 0) {
echo "<img width='16' height='16' src='../style/images/icons/i_h_money.gif' alt='o'> $level[dollars]";
}elseif ($level[ex] >0 && $level[dollars]==0 ) {
echo "<img width='16' height='16' src='../style/images/icons/i_h_ex.gif' alt='o'> $level[ex]";
}elseif ($level[dollars] > 0 && $level[ex] >0){
echo "<img width='16' height='16' src='../style/images/icons/i_h_money.gif' alt='o'> $level[dollars] ";
echo "<img width='16' height='16' src='../style/images/icons/i_h_ex.gif' alt='o'> $level[ex]";
}
echo"</div></div>";
$sql->query("UPDATE `users` SET `lv` = '$level[level]', `dollars` = '".($arr['dollars']+$level['dollars'])."', `ex` = '".($arr['ex']+($level['ex']))."' , `energy`= `max_energy` WHERE `id` = '$arr[id]'");
$arr['lv']=$level['level'];
$arr['dollars']=$arr['dollars']+($level['dollars']);
$arr['ex']=$arr['ex']+$level['ex'];
$rl=0;
$ql=$sql->query("SELECT * FROM `level`");
while($pl=$sql->obj_assoc($ql))
{
if($pl['level']<=$arr['lv'])$rl=$rl+$pl['xp'];
}
$kr=$arr['xp']-$rl;
$level=$sql->ass("SELECT * FROM `level` WHERE `level` = '".($arr['lv']+1)."' LIMIT 1");
}
}
База
CREATE TABLE `level` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`level` varchar(1000) DEFAULT '0',
`xp` varchar(1000) DEFAULT '0',
`dollars` varchar(1000) DEFAULT '0',
`ex` varchar(1000) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO level VALUES("1","2","1","200","0");
INSERT INTO level VALUES("2","3","5","300","0");
INSERT INTO level VALUES("3","4","10","400","0");
INSERT INTO level VALUES("4","5","15","500","0");
INSERT INTO level VALUES("5","6","20","600","0");
INSERT INTO level VALUES("6","7","25","700","0");
INSERT INTO level VALUES("7","8","30","800","0");
INSERT INTO level VALUES("8","9","35","900","0");
INSERT INTO level VALUES("9","10","40","1000","0");
INSERT INTO level VALUES("10","11","45","1100","0");
INSERT INTO level VALUES("11","12","50","2000","0");
Проблема в том что с первого на второй переходит без проблем,а дальше опыт набираешь ,но на следующий не переходит,подскажите в чем проблема с меня добрый +
$bigl=50;
if($arr['lv']<$bigl)
{
if($arr['lv']>1)
{
$rl=0;
$ql=$sql->query("SELECT * FROM `level`");
while($pl=$sql->obj_assoc($ql))
{
if($pl['level']<=$arr['lv']) $rl=$rl+$pl['xp'];
}
$kr=$ku['xp']-$rl;
}
else $kr=$arr['xp'];
$level=$sql->ass("SELECT * FROM `level` WHERE `level` = '".($arr['lv']+1)."' LIMIT 1");
if($kr>=$level['xp'])
{
echo "<div id='cnt'><div align='center'><div id='hdr_m'><b>Новый уровень!</b> Тебе стали доступны новые машины,запчасти и много чего другого.</br><b>Награда:</b> ";
if($level[dollars] > 0 && $level[ex] == 0) {
echo "<img width='16' height='16' src='../style/images/icons/i_h_money.gif' alt='o'> $level[dollars]";
}elseif ($level[ex] >0 && $level[dollars]==0 ) {
echo "<img width='16' height='16' src='../style/images/icons/i_h_ex.gif' alt='o'> $level[ex]";
}elseif ($level[dollars] > 0 && $level[ex] >0){
echo "<img width='16' height='16' src='../style/images/icons/i_h_money.gif' alt='o'> $level[dollars] ";
echo "<img width='16' height='16' src='../style/images/icons/i_h_ex.gif' alt='o'> $level[ex]";
}
echo"</div></div>";
$sql->query("UPDATE `users` SET `lv` = '$level[level]', `dollars` = '".($arr['dollars']+$level['dollars'])."', `ex` = '".($arr['ex']+($level['ex']))."' , `energy`= `max_energy` WHERE `id` = '$arr[id]'");
$arr['lv']=$level['level'];
$arr['dollars']=$arr['dollars']+($level['dollars']);
$arr['ex']=$arr['ex']+$level['ex'];
$rl=0;
$ql=$sql->query("SELECT * FROM `level`");
while($pl=$sql->obj_assoc($ql))
{
if($pl['level']<=$arr['lv'])$rl=$rl+$pl['xp'];
}
$kr=$arr['xp']-$rl;
$level=$sql->ass("SELECT * FROM `level` WHERE `level` = '".($arr['lv']+1)."' LIMIT 1");
}
}
База
CREATE TABLE `level` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`level` varchar(1000) DEFAULT '0',
`xp` varchar(1000) DEFAULT '0',
`dollars` varchar(1000) DEFAULT '0',
`ex` varchar(1000) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO level VALUES("1","2","1","200","0");
INSERT INTO level VALUES("2","3","5","300","0");
INSERT INTO level VALUES("3","4","10","400","0");
INSERT INTO level VALUES("4","5","15","500","0");
INSERT INTO level VALUES("5","6","20","600","0");
INSERT INTO level VALUES("6","7","25","700","0");
INSERT INTO level VALUES("7","8","30","800","0");
INSERT INTO level VALUES("8","9","35","900","0");
INSERT INTO level VALUES("9","10","40","1000","0");
INSERT INTO level VALUES("10","11","45","1100","0");
INSERT INTO level VALUES("11","12","50","2000","0");
Проблема в том что с первого на второй переходит без проблем,а дальше опыт набираешь ,но на следующий не переходит,подскажите в чем проблема с меня добрый +