PHP/MySQL | что здесь неправильно в этом коде
<?php
include_once"banzz/banzz.php";
include_once"files/ini.php";
include_once"files/data.php";
include_once"files/lvl.php";
include_once"files/lvlclan.php";
include_once"files/pit.php";
include_once"files/regeneration.php";
include_once"files/gzip.php";
include_once"files/l2pirates_Antihack.php";
//echo'<div class = "up" ></div><div class = "body" ><script src="sneg.js"></script><left><br/>';
//echo"<left>";
include_once"files/themes.php";
include_once"files/opiti.php";
include_once"files/opitpit.php";
/*$pr_q = mysql_query("SELECT * from `config` ");
while($arr = mysql_fetch_array($pr_q)){
$time=time();
$arr[time]=$arr['time']+2592000;
if($time>$arr['time']){
mysql_query("TRUNCATE TABLE battle_log ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE gb ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE gb1 ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE clan_chat ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE msg_r ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE sell ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE l2pirates_hystory ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE viktorina_chat ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE zametki ") or die("Сука не пашет!");
$t=time();
mysql_query("UPDATE `config` SET `time`='$t' ");
}}*/
if($udata37==TWI){
$kkk=time()-86400;
if($udata52<=$kkk){
mysql_query("UPDATE `users` SET `udata37`='' WHERE `udata0`='$log'");
}
}
$rr = mysql_query("SELECT * FROM `item_shadow` WHERE `time`<='".time()."' and `usr`='$log'");
$av=mysql_num_rows($req);
if($av > 0){
while($sh=mysql_fetch_array($rr)){
if($sh['type'] == 'weapon'){
$req = mysql_query("SELECT * FROM `weapon_item` WHERE `name`='".$sh['id_item']."' and `usr`='$log'");
$w=mysql_fetch_array($req);
$pa = $udata4 - $w['p_dam'];
$ma = $udata83 - $w['m_dam'];
if($udata12 == $sh['name']){
$weapon = 'Пусто';
}else{
$weapon = $udata12;
}
if($udata45 == $sh['name']){
$weapon = 'Пусто';
}else{
$weapon = $udata45;
}
mysql_query("UPDATE `users` SET `udata4`='$pa', `udata83` = '$ma', `udata45` = '$weapon', `udata12` = '$weapon' WHERE `udata0`='$log'");
mysql_query("DELETE FROM `weapon_item` WHERE `login`='".$sh['usr']."' and `name` = '".$sh['id_item']."'");
}elseif($sh['type'] == 'armor'){
$pa = $udata3 - $w['p_def'];
$ma = $udata82 - $w['m_def'];
if($udata10 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata10;
}
if($udata11 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata11;
}
if($udata84 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata84;
}
if($udata46 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata46;
}
if($udata13 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata13;
}
mysql_query("UPDATE `users` SET `udata3`='$pa', `udata82` = '$ma', `udata10` = '$armor', `udata11` = '$armor'
, `udata84` = '$armor', `udata46` = '$armor', `udata13` = '$armor' WHERE `udata0`='$log'");
mysql_query("DELETE FROM `armor_item` WHERE `login`='".$sh['usr']."'");
}
}
mysql_query("DELETE FROM `item_shadow` WHERE `time`<='".time()."' and `usr` = '$log'");
}
$time=time();
///////
$req = mysql_query("SELECT * FROM `table_vip` WHERE `time`<='$time' and `nick`='$log'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto=='1'){
mysql_query("UPDATE `users` SET `udata75`='' WHERE `udata0`='$log'");
mysql_query("DELETE FROM `table_vip` WHERE `nick`='$log' LIMIT 1");
}
////////////////////////////////Рекомендации////////////////////////////////////////////////
mysql_query("DELETE FROM `rec` WHERE `time`<'".time()."' ");
///////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////Викторина////////////////////////////////////////////////
$v=mysql_query("SELECT * FROM `v_question` LIMIT 1");
$vik=mysql_fetch_array($v);
$vik[answer] = mb_substr ($vik[answer], 0, 1, 'UTF-8');
$tim=time();
$time=time()+60;
if($vik[hint]<$tim and $vik[type]=="1"){
mysql_query("INSERT INTO `viktorina_chat` VALUES ('', '<font color=#FFD700>Подсказка :<b> $vik[answer]...</b></font>', 'Умник', '".$tim."')") or die(mysql_error());
mysql_query("UPDATE `v_question` SET `hint`='$time',`type`='2' WHERE `question`='$vik[question]' ");
}
$v1=mysql_query("SELECT * FROM `viktorina` ORDER BY RAND () LIMIT 1");
$vik1=mysql_fetch_array($v1);
$time=time()+60;
$tim=time();
if($vik[hint]<$tim and $vik[type]=="2"){
mysql_query("TRUNCATE TABLE v_question ") or die("Сука не пашет!");
mysql_query("INSERT INTO `v_question` VALUES ('$vik1[question]','$vik1[answer]','$time','1')") or die(mysql_error());
$str = strlen($vik1[answer])/2;
mysql_query("INSERT INTO `viktorina_chat` VALUES ('', '<font color=red>На вопрос никто не ответил.</font>', 'Умник', '".$tim."')") or die(mysql_error());
mysql_query("INSERT INTO `viktorina_chat` VALUES ('', '<font color=green>Следующий вопрос :<b>$vik1[question] ($str букв)</b></font>', 'Умник', '".$tim."')&quo
include_once"banzz/banzz.php";
include_once"files/ini.php";
include_once"files/data.php";
include_once"files/lvl.php";
include_once"files/lvlclan.php";
include_once"files/pit.php";
include_once"files/regeneration.php";
include_once"files/gzip.php";
include_once"files/l2pirates_Antihack.php";
//echo'<div class = "up" ></div><div class = "body" ><script src="sneg.js"></script><left><br/>';
//echo"<left>";
include_once"files/themes.php";
include_once"files/opiti.php";
include_once"files/opitpit.php";
/*$pr_q = mysql_query("SELECT * from `config` ");
while($arr = mysql_fetch_array($pr_q)){
$time=time();
$arr[time]=$arr['time']+2592000;
if($time>$arr['time']){
mysql_query("TRUNCATE TABLE battle_log ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE gb ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE gb1 ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE clan_chat ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE msg_r ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE sell ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE l2pirates_hystory ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE viktorina_chat ") or die("Сука не пашет!");
mysql_query("TRUNCATE TABLE zametki ") or die("Сука не пашет!");
$t=time();
mysql_query("UPDATE `config` SET `time`='$t' ");
}}*/
if($udata37==TWI){
$kkk=time()-86400;
if($udata52<=$kkk){
mysql_query("UPDATE `users` SET `udata37`='' WHERE `udata0`='$log'");
}
}
$rr = mysql_query("SELECT * FROM `item_shadow` WHERE `time`<='".time()."' and `usr`='$log'");
$av=mysql_num_rows($req);
if($av > 0){
while($sh=mysql_fetch_array($rr)){
if($sh['type'] == 'weapon'){
$req = mysql_query("SELECT * FROM `weapon_item` WHERE `name`='".$sh['id_item']."' and `usr`='$log'");
$w=mysql_fetch_array($req);
$pa = $udata4 - $w['p_dam'];
$ma = $udata83 - $w['m_dam'];
if($udata12 == $sh['name']){
$weapon = 'Пусто';
}else{
$weapon = $udata12;
}
if($udata45 == $sh['name']){
$weapon = 'Пусто';
}else{
$weapon = $udata45;
}
mysql_query("UPDATE `users` SET `udata4`='$pa', `udata83` = '$ma', `udata45` = '$weapon', `udata12` = '$weapon' WHERE `udata0`='$log'");
mysql_query("DELETE FROM `weapon_item` WHERE `login`='".$sh['usr']."' and `name` = '".$sh['id_item']."'");
}elseif($sh['type'] == 'armor'){
$pa = $udata3 - $w['p_def'];
$ma = $udata82 - $w['m_def'];
if($udata10 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata10;
}
if($udata11 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata11;
}
if($udata84 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata84;
}
if($udata46 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata46;
}
if($udata13 == $sh['name']){
$armor = 'Пусто';
}else{
$armor = $udata13;
}
mysql_query("UPDATE `users` SET `udata3`='$pa', `udata82` = '$ma', `udata10` = '$armor', `udata11` = '$armor'
, `udata84` = '$armor', `udata46` = '$armor', `udata13` = '$armor' WHERE `udata0`='$log'");
mysql_query("DELETE FROM `armor_item` WHERE `login`='".$sh['usr']."'");
}
}
mysql_query("DELETE FROM `item_shadow` WHERE `time`<='".time()."' and `usr` = '$log'");
}
$time=time();
///////
$req = mysql_query("SELECT * FROM `table_vip` WHERE `time`<='$time' and `nick`='$log'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto=='1'){
mysql_query("UPDATE `users` SET `udata75`='' WHERE `udata0`='$log'");
mysql_query("DELETE FROM `table_vip` WHERE `nick`='$log' LIMIT 1");
}
////////////////////////////////Рекомендации////////////////////////////////////////////////
mysql_query("DELETE FROM `rec` WHERE `time`<'".time()."' ");
///////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////Викторина////////////////////////////////////////////////
$v=mysql_query("SELECT * FROM `v_question` LIMIT 1");
$vik=mysql_fetch_array($v);
$vik[answer] = mb_substr ($vik[answer], 0, 1, 'UTF-8');
$tim=time();
$time=time()+60;
if($vik[hint]<$tim and $vik[type]=="1"){
mysql_query("INSERT INTO `viktorina_chat` VALUES ('', '<font color=#FFD700>Подсказка :<b> $vik[answer]...</b></font>', 'Умник', '".$tim."')") or die(mysql_error());
mysql_query("UPDATE `v_question` SET `hint`='$time',`type`='2' WHERE `question`='$vik[question]' ");
}
$v1=mysql_query("SELECT * FROM `viktorina` ORDER BY RAND () LIMIT 1");
$vik1=mysql_fetch_array($v1);
$time=time()+60;
$tim=time();
if($vik[hint]<$tim and $vik[type]=="2"){
mysql_query("TRUNCATE TABLE v_question ") or die("Сука не пашет!");
mysql_query("INSERT INTO `v_question` VALUES ('$vik1[question]','$vik1[answer]','$time','1')") or die(mysql_error());
$str = strlen($vik1[answer])/2;
mysql_query("INSERT INTO `viktorina_chat` VALUES ('', '<font color=red>На вопрос никто не ответил.</font>', 'Умник', '".$tim."')") or die(mysql_error());
mysql_query("INSERT INTO `viktorina_chat` VALUES ('', '<font color=green>Следующий вопрос :<b>$vik1[question] ($str букв)</b></font>', 'Умник', '".$tim."')&quo
ой не вместился весь код
Ты хоть укажи тип ошибки и строку где она
Макс, с этим файлом всё в иероглифах беру от другого двига этот файл всё норм но не отображает тему оформления и низ панель
Benavent, заменил но мне бы эти родные заги запилить а за что они отвечают ещё кроме как за верх низ тему
Стр.: 1, 2