Файл: data/travyzabrat1.dat.php
Строк: 230
<?
$sf="";
if($row['polog1']==1001){$POLANA=1;}
if ((isset($_SESSION['w'])) && (isset($_POST['capcha'])) && ($_SESSION['w'] == $_POST['capcha']))
{
$q_b = mysql_query("select*from `qwest_book` where `id_pers`='" . $row['ID'] .
"' and `id_qw`='13'")or die(mysql_errno());
if ((mysql_num_rows($q_b) == 1)&&($row['polog1']==1001) ){
$qwest_book = mysql_fetch_array($q_b);
if ($qwest_book['tek_status'] == 1) {
if($row['trava']=='17hpall'){
$qwest_book['qw_kolvo']--;
mysql_query("update qwest_book set qw_kolvo='".$qwest_book['qw_kolvo']."'where `id_pers`='" . $row['ID'] ."' and `id_qw`='13'");
if($qwest_book['qw_kolvo']<1){
mysql_query("update qwest_book set `tek_status`='2',`opisan_qw`='Отнести Цветки Алхимику!' where id_pers='".$row['ID']."' and id_qw='13'");
$sf=$sf."Задание Обновлено!!";
;}
;}
;}
$querymob0 = "SELECT * FROM `rostenia` WHERE `id`='" . mysql_real_escape_string($row['trava']) .
"' ;" ;
$sqlm0 = mysql_query($querymob0) or die(mysql_error()) ;
$row000 = mysql_fetch_assoc($sqlm0) ;
if($row000['rand']==19){
$r = mysql_query("select*from new_qwest_pers where name='" . $row['ID'] . "' and `1`='4' and `kolvo`>'0' ");
if(mysql_num_rows($r)==1){
$rr=mysql_fetch_array($r);
$rr['kolvo']--;$sf=$sf."Осталось найти ".$rr['kolvo']."Петерии!";
if($rr['kolvo']<=0){
$sf=$sf."Возращайтесь к колдуньи!";
mysql_query("update new_qwest_pers set `1`='5' where name='".$row['ID']."'");
;}mysql_query("update new_qwest_pers set kolvo='".$rr['kolvo']."' where name='".$row['ID']."'");
;} ;}
$r = mysql_query("select*from new_qwest_pers where name='" . $row['ID'] . "' and `2`='1' ");
if(mysql_num_rows($r)==1){
$rr=mysql_fetch_array($r);
$r2=mysql_query("select*from new_qwest_kolvo where name='".$row['ID']."' and `kolvo`>'0'and qwest='2'");
if(mysql_num_rows($r2)==1){
$rr2=mysql_fetch_array($r2);
}
$rr2['kolvo']--;$sf=$sf."Осталось найти ".$rr2['kolvo']." травы!<br>";
if($rr2['kolvo']<=0){
$sf=$sf."Вы нашли 200 травы. Возращайтесь в гильдию!<br>";
mysql_query("update new_qwest_pers set `2`='2' where name='".$row['ID']."'");
;}mysql_query("update new_qwest_kolvo set kolvo='".$rr2['kolvo']."' where name='".$row['ID']."'and qwest='2'");
;}
$query = "UPDATE `table1` SET `trava`='q' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
if ($row['trava'] !== 'q')
{
$query7 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'" ;
$sql7 = mysql_query($query7) or die(mysql_error()) ;
$row7 = mysql_fetch_assoc($sql7) ;
$queryl0 = "SELECT*
FROM `rukzak` where `name`='" . mysql_real_escape_string($opredelenie) .
"' and `odeto`='0'" ;
$sqll0 = mysql_query($queryl0) or die(mysql_error()) ;
$num_rows = mysql_num_rows($sqll0) ;
$ru = $row7['lvl'] + 99 +$pers_info['rukzak'] ;;
if ($ru <= $num_rows)
{
print"Вы не можете продолжать освободите рюкзак!!<br>" ;
exitt($row, $opredelenie) ;
}
if ($row000['hp'] > 0)
{
$par = $row000['hp'] ;
$m = "хп" ;
}
if ($row000['mp'] > 0)
{
$par = $row000['mp'] ;
$m = "мп" ;
}
if ($row000['tp'] > 0)
{
$par = $row000['tp'] ;
$m = "тп" ;
}
if($row['gild_travnik']==10){
$proc=((rand(1,50)/100)+1);
$par=round($par*$proc);
}
mysql_query("INSERT INTO `rukzak` (`idrukzak`, `name` , `tip` , `nazvanie`,`try`,`time`,`sozdatel`,`lvl`,`chit` ,`cena`,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '" .
mysql_real_escape_string($row000['id']) . "', '" . mysql_real_escape_string($row000['nami']) .
"','$par','" . time() . "','','','trava','" . mysql_real_escape_string($row000['cena']) .
"','','" . mysql_real_escape_string($row000['rus_tip']) . "','" . mysql_real_escape_string($row000['rus_par']) . "'
)") or die(mysql_error()) ;
if($rowzakls[6]==0){
mysql_query( "UPdate `slava_pers` set `6`='1' WHERE `id_pers`='".$row['ID']."'") ;
$row['slava']+=100; $row['bank']+=300;
mysql_query( "UPdate `table1` set `slava`='".$row['slava']."',`bank`=".$row['bank']." WHERE `ID`='".$row['ID']."'") ;
$sf=$sf."Вы выполнили 6-е достижение<br>";
;}
$sf=$sf."Вы положили траву в рюкзак!" ;
$plusohotn = (100 / $row['travnik']) +1;
$tz1 = rand(1, 150) ;
if($_SESSION['travnik']==1){$plusohotn=$plusohotn*2;}
if ($plusohotn > $tz1)
{
$opitstar1 = $row['travnik'] * 100 ;
$obshopit = $row['obshopit'] + $opitstar1 ;
$tekopit = $row['tekopit'] + $opitstar1 ;
$row['travnik']++ ;
$sf=$sf. "Вы повысили ваш навык <br><font color=red><b>Травник +1! Вы получили " .
htmlspecialchars($opitstar1) . " опыта</b></font>" ;
$row['ohotnik']++ ;
$query = "UPDATE `table1` SET `travnik`='" . mysql_real_escape_string($row['travnik']) .
"',`obshopit`='" . mysql_real_escape_string($obshopit) . "',`tekopit`='" .
mysql_real_escape_string($tekopit) . "' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "'" ;
mysql_query($query) ;
$sql = mysql_query($query) or die(mysql_error()) ;
}
;
;
}
$_SESSION['statusis']=$sf;header('location:88.php?go=do') ;}
///////////////////////////////////////////////
if($POLANA==1){
$querymob0 = "SELECT * FROM `rostenia` WHERE `id`='" . mysql_real_escape_string($row['trava']) .
"' ;" ;
$sqlm0 = mysql_query($querymob0) or die(mysql_error()) ;
$row000 = mysql_fetch_assoc($sqlm0) ;
if($row000['rand']==19){
$r = mysql_query("select*from new_qwest_pers where name='" . $row['ID'] . "' and `1`='4' and `kolvo`>'0' ");
if(mysql_num_rows($r)==1){
$rr=mysql_fetch_array($r);
$rr['kolvo']--;$sf=$sf."Осталось найти ".$rr['kolvo']."Петерии!";
if($rr['kolvo']<=0){
$sf=$sf."Возращайтесь к колдуньи!";
mysql_query("update new_qwest_pers set `1`='5' where name='".$row['ID']."'");
;}mysql_query("update new_qwest_pers set kolvo='".$rr['kolvo']."' where name='".$row['ID']."'");
;} ;}
$r = mysql_query("select*from new_qwest_pers where name='" . $row['ID'] . "' and `2`='1' ");
if(mysql_num_rows($r)==1){
$rr=mysql_fetch_array($r);
$r2=mysql_query("select*from new_qwest_kolvo where name='".$row['ID']."' and `kolvo`>'0'and qwest='2'");
if(mysql_num_rows($r2)==1){
$rr2=mysql_fetch_array($r2);
}
$rr2['kolvo']--;$sf=$sf."Осталось найти ".$rr2['kolvo']." травы!<br>";
if($rr2['kolvo']<=0){
$sf=$sf."Вы нашли 200 травы. Возращайтесь в гильдию!<br>";
mysql_query("update new_qwest_pers set `2`='2' where name='".$row['ID']."'");
;}mysql_query("update new_qwest_kolvo set kolvo='".$rr2['kolvo']."' where name='".$row['ID']."'and qwest='2'");
;}
$query = "UPDATE `table1` SET `trava`='q' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
if ($row['trava'] !== 'q')
{
$query7 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'" ;
$sql7 = mysql_query($query7) or die(mysql_error()) ;
$row7 = mysql_fetch_assoc($sql7) ;
$queryl0 = "SELECT*
FROM `rukzak` where `name`='" . mysql_real_escape_string($opredelenie) .
"' and `odeto`='0'" ;
$sqll0 = mysql_query($queryl0) or die(mysql_error()) ;
$num_rows = mysql_num_rows($sqll0) ;
$ru = $row7['lvl'] + 99 +$pers_info['rukzak'] ;;
if ($ru <= $num_rows)
{
print"Вы не можете продолжать освободите рюкзак!!<br>" ;
exitt($row, $opredelenie) ;
}
if ($row000['hp'] > 0)
{
$par = $row000['hp'] ;
$m = "хп" ;
}
if ($row000['mp'] > 0)
{
$par = $row000['mp'] ;
$m = "мп" ;
}
if ($row000['tp'] > 0)
{
$par = $row000['tp'] ;
$m = "тп" ;
}
if($row['gild_travnik']==10){
$proc=((rand(1,50)/100)+1);
$par=round($par*$proc);
}
mysql_query("INSERT INTO `rukzak` (`idrukzak`, `name` , `tip` , `nazvanie`,`try`,`time`,`sozdatel`,`lvl`,`chit` ,`cena`,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '" .
mysql_real_escape_string($row000['id']) . "', '" . mysql_real_escape_string($row000['nami']) .
"','$par','" . time() . "','','','trava','" . mysql_real_escape_string($row000['cena']) .
"','','" . mysql_real_escape_string($row000['rus_tip']) . "','" . mysql_real_escape_string($row000['rus_par']) . "'
)") or die(mysql_error()) ;
if($rowzakls[6]==0){
mysql_query( "UPdate `slava_pers` set `6`='1' WHERE `id_pers`='".$row['ID']."'") ;
$row['slava']+=100; $row['bank']+=300;
mysql_query( "UPdate `table1` set `slava`='".$row['slava']."',`bank`=".$row['bank']." WHERE `ID`='".$row['ID']."'") ;
$sf=$sf."Вы выполнили 6-е достижение<br>";
;}
$sf=$sf."Вы положили траву в рюкзак!" ;
$plusohotn = (100 / $row['travnik']) +1;
$tz1 = rand(1, 150) ;
if($_SESSION['travnik']==1){$plusohotn=$plusohotn*2;}
if ($plusohotn > $tz1)
{
$opitstar1 = $row['travnik'] * 100 ;
$obshopit = $row['obshopit'] + $opitstar1 ;
$tekopit = $row['tekopit'] + $opitstar1 ;
$row['travnik']++ ;
$sf=$sf. "Вы повысили ваш навык <br><font color=red><b>Травник +1! Вы получили " .
htmlspecialchars($opitstar1) . " опыта</b></font>" ;
$row['ohotnik']++ ;
$query = "UPDATE `table1` SET `travnik`='" . mysql_real_escape_string($row['travnik']) .
"',`obshopit`='" . mysql_real_escape_string($obshopit) . "',`tekopit`='" .
mysql_real_escape_string($tekopit) . "' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "'" ;
mysql_query($query) ;
$sql = mysql_query($query) or die(mysql_error()) ;
};}
$_SESSION['statusis']=$sf;header('location:88.php?go=do') ;}
if($POLANA==2){
$sf="";
$querymob0 = "SELECT * FROM `rostenia` WHERE `id`='" . mysql_real_escape_string($row['trava']) .
"' ;" ;
$sqlm0 = mysql_query($querymob0) or die(mysql_error()) ;
$row000 = mysql_fetch_assoc($sqlm0) ;
$query = "UPDATE `table1` SET `trava`='q' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
if ($row['trava'] !== 'q')
{
$query7 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'" ;
$sql7 = mysql_query($query7) or die(mysql_error()) ;
$row7 = mysql_fetch_assoc($sql7) ;
$queryl0 = "SELECT*
FROM `rukzak` where `name`='" . mysql_real_escape_string($opredelenie) .
"' and `odeto`='0'" ;
$sqll0 = mysql_query($queryl0) or die(mysql_error()) ;
$num_rows = mysql_num_rows($sqll0) ;
$ru = $row7['lvl'] + 99 +$pers_info['rukzak'] ;;
if ($ru <= $num_rows)
{
print"Вы не можете продолжать освободите рюкзак!!" ;
exitt($row, $opredelenie) ;
}
$par = $row000['jad'] ;
$m = "яда" ;
if($row['gild_travnik']==10){
$proc=((rand(1,50)/100)+1);
$par=round($par*$proc);
}
mysql_query("INSERT INTO `rukzak` (`idrukzak`, `name` , `tip` , `nazvanie`,`try`,`time`,`sozdatel`,`lvl`,`chit` ,`cena`,`table`,`rus_tip`,`rus_par`)
VALUES ('','" . mysql_real_escape_string($opredelenie) . "', '" .
mysql_real_escape_string($row000['id']) . "', '" . mysql_real_escape_string($row000['nami']) .
"','$par','" . time() . "','','','ja','" . mysql_real_escape_string($row000['cena']) .
"','','" . mysql_real_escape_string($row000['rus_tip']) . "','" . mysql_real_escape_string($row000['rus_par']) . "'
)") or die(mysql_error()) ;
if($rowzakls[6]==0){
mysql_query( "UPdate `slava_pers` set `6`='1' WHERE `id_pers`='".$row['ID']."'") ;
$row['slava']+=100; $row['bank']+=300;
mysql_query( "UPdate `table1` set `slava`='".$row['slava']."',`bank`=".$row['bank']." WHERE `ID`='".$row['ID']."'") ;
$sf=$sf."Вы выполнили 6-е достижение<br>";
;}
$sf=$sf."Вы положили траву в рюкзак!" ;
$plusohotn = (100 / $row['travnik']) +1;
$tz1 = rand(1, 150) ;
if($_SESSION['travnik']==1){$plusohotn=$plusohotn*2;}
if ($plusohotn > $tz1)
{
$opitstar1 = $row['travnik'] * 100 ;
$obshopit = $row['obshopit'] + $opitstar1 ;
$tekopit = $row['tekopit'] + $opitstar1 ;
$row['travnik']++ ;
$sf=$sf. "Вы повысили ваш навык <br><font color=red><b>Травник +1</b>! Вы получили " .
htmlspecialchars($opitstar1) . " опыта</font>" ;
$row['ohotnik']++ ;
$query = "UPDATE `table1` SET `travnik`='" . mysql_real_escape_string($row['travnik']) .
"',`obshopit`='" . mysql_real_escape_string($obshopit) . "',`tekopit`='" .
mysql_real_escape_string($tekopit) . "' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "'" ;
mysql_query($query) ;
$sql = mysql_query($query) or die(mysql_error()) ;
}
;
;
}
$_SESSION['statusis']=$sf;header('location:88.php?go=do') ;}
}else{$_SESSION['statusis']="Неверный код";
header('location:88.php?go=do') ;
;
;;;}
?>