Помощь по скриптам | помощь по коду
AI_Helper
Эллиот Алдерсон , site.ru/bank?q
.http.
Anonymous [PRO] , за казну у меня отвечает колонка gold в таблице clan
Zarts , попробуйте site.ru/bank?d=true
mrcatoff
Zarts , if(isset($_GET['d'])){
mysql_query("INSERT INTO `zur_gold` set `kto` = '".$user['id']."', `kol`= `kol` + '10', `time` = '".$t."', `clan`= '".$clan['id']."'");
mysql_query("UPDATE `user` set `gold` = `gold` - '10' where `id` = '".$user['id']."'");
mysql_query("UPDATE `clan` set `gold` = `gold` + '10' where `id` = '".$clan['id']."'");
}else{$_SESSION['err'] = $err;}
Пробуй
________
посл. ред. 28.06.2017 в 23:09; всего 1 раз(а); by Anonymous [PRO]
[BAN] mysql_query("INSERT INTO `zur_gold` set `kto` = '".$user['id']."', `kol`= `kol` + '10', `time` = '".$t."', `clan`= '".$clan['id']."'");
mysql_query("UPDATE `user` set `gold` = `gold` - '10' where `id` = '".$user['id']."'");
mysql_query("UPDATE `clan` set `gold` = `gold` + '10' where `id` = '".$clan['id']."'");
}else{$_SESSION['err'] = $err;}
Пробуй
________
посл. ред. 28.06.2017 в 23:09; всего 1 раз(а); by Anonymous [PRO]
Zarts , Либо же
if(isset($_GET['d'])){
mysql_query("INSERT INTO `zur_gold` set `kto` = '".num($user['id'])."', `kol`= `kol` + '10', `time` = '".$t."', `clan`= '".$clan['id']."'");
mysql_query("UPDATE `user` set `gold` = `gold` - '10' where `id` = '".num($user['id'])."'");
mysql_query("UPDATE `clan` set `gold` = `gold` + '10' where `id` = '".num($clan['id'])."'");
}else{$_SESSION['err'] = $err;}
if(isset($_GET['d'])){
mysql_query("INSERT INTO `zur_gold` set `kto` = '".num($user['id'])."', `kol`= `kol` + '10', `time` = '".$t."', `clan`= '".$clan['id']."'");
mysql_query("UPDATE `user` set `gold` = `gold` - '10' where `id` = '".num($user['id'])."'");
mysql_query("UPDATE `clan` set `gold` = `gold` + '10' where `id` = '".num($clan['id'])."'");
}else{$_SESSION['err'] = $err;}
или добавляй к запросу or die(mysql_error());
if(isset($_GET['d'])){
mysql_query("INSERT INTO `zur_gold` set `kto` = '".num($user['id'])."', `kol`= `kol` + '10', `time` = '".$t."', `clan`= '".num($clan['id'])."'");
mysql_query("UPDATE `user` set `gold` = `gold` - '10' where `id` = '".num($user['id'])."'");
mysql_query("UPDATE `clan` set `gold` = `gold` + '10' where `id` = '".num($clan['id'])."'");
}else{$_SESSION['err'] = $err;}
Либо так.
mysql_query("INSERT INTO `zur_gold` set `kto` = '".num($user['id'])."', `kol`= `kol` + '10', `time` = '".$t."', `clan`= '".num($clan['id'])."'");
mysql_query("UPDATE `user` set `gold` = `gold` - '10' where `id` = '".num($user['id'])."'");
mysql_query("UPDATE `clan` set `gold` = `gold` + '10' where `id` = '".num($clan['id'])."'");
}else{$_SESSION['err'] = $err;}
Либо так.
Anonymous [PRO] , все работает кроме + 10 золота в казну клана не идёт чего-то хоть запрос верный
if($_GET['act']==go) {
mysql_query("INSERT INTO `zur_gold` set `kto` = ".num($user['id']).", `kol`= `kol` + '10', `time` = ".$t.", `clan`= ".$clan['id']."");
mysql_query("UPDATE `user` set `gold` = `gold` - '10' where `id` = ".num($user['id'])."");
mysql_query("UPDATE `clan` set `gold` = `gold` + '10' where `id` = ".$clan['id']."");
header('location:?');
}else{$_SESSION['err'] = $err;}
//вот так запашет //
Ресторатор mysql_query("INSERT INTO `zur_gold` set `kto` = ".num($user['id']).", `kol`= `kol` + '10', `time` = ".$t.", `clan`= ".$clan['id']."");
mysql_query("UPDATE `user` set `gold` = `gold` - '10' where `id` = ".num($user['id'])."");
mysql_query("UPDATE `clan` set `gold` = `gold` + '10' where `id` = ".$clan['id']."");
header('location:?');
}else{$_SESSION['err'] = $err;}
//вот так запашет //
Zarts , убери '10' , зделай просто 10) бывало такое)