Файл: dvig/kopat.php
Строк: 169
<?php
/**
* @author Ololo
* @copyright 2012
*/
class Kopat
{
function ogranichenie($row,$opredelenie,$pers_info)
{
if ($row['polog'] == 'gorod')
{
header('location:88.php?go=do') ;
exitt($row,$opredelenie);
}
$queryob = "SELECT * FROM `raspologenie_obektob` WHERE `severobekt`='" .
mysql_real_escape_string($row['sever']) . "' AND `wostokobekt`='" .
mysql_real_escape_string($row['wostok']) . " ' " ;
$sqlob = mysql_query($queryob) or die(mysql_error()) ;
$rowob = mysql_fetch_assoc($sqlob) ;
if (mysql_num_rows($sqlob) !== 1)
{
header('location:88.php?go=do') ;
exitt($row,$opredelenie); ;
}
$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 = $row['lvl'] + 99+$pers_info['rukzak'] ;;
if ($ru <= $num_rows)
{
$_SESSION['statusis']="Вы не можете продолжать освободите рюкзак!!<br><a href=88.php?go=do style=color:#CC3333>В игру</a>" ;
header('location:88.php?go=do') ;
exitt($row,$opredelenie); ;
}
}
function vivod_capchi()
{
$im = @imagecreate(60, 30);
$background_color = imagecolorallocate($im, 255, 255, 255) ;
$text_color = imagecolorallocate($im, 233, 14, 91) ;
$a = mt_rand(1, 9991) ;
$b=mt_rand(1, 999) ;
imagestring($im, 5, 22, 10, "$b", $text_color) ;
imagepng($im, "./kap/" . htmlspecialchars($a) . ".png") ;
print "<div class="chat_conteiner"><form name=form1 action=88.php?go=mine&kart=".htmlspecialchars($a)." method=post><img src=./kap/" .
htmlspecialchars($a) . ".png alt=число>
<input type=text class=tixti name=capcha maxlength=4 size=5><br>
<input type=submit class=select name=otkolot value=Отколоть>
</form></div>" ;
$_SESSION['a'] = $b ;
}
function plus($row,$opredelenie,$tip,$dobil)
{
$opitstar = $row[$tip] * 100 ;
$obshopit = $row['obshopit'] + $opitstar ;
$tekopit = $row['tekopit'] + $opitstar ;
print "<div class="style_mess_yes">Вы повысили ваш навык <br><font color=red><b>$dobil +1! Вы получили $opitstar опыта</b></font></div>" ;
$cdate = date("H:i:s") ;
$textt = "<font color=a0c0c0> " . $row['name'] .
" повысил навык </font><font color=red><b>$dobil +1</b></font>" ;
$row[$tip]++ ;
$query = "UPDATE `table1` SET `$tip`='" . mysql_real_escape_string($row[$tip]) .
"',`obshopit`='" . mysql_real_escape_string($obshopit) . "',`tekopit`='" .
mysql_real_escape_string($tekopit) . "' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
$sql = mysql_query($query) or die(mysql_error()) ;
$query = "INSERT INTO `loctext` SET sever='" . mysql_real_escape_string($row['sever']) .
"', wostok='" . mysql_real_escape_string($row['wostok']) . "', text='" .
mysql_real_escape_string($textt) . "', date='" . mysql_real_escape_string($cdate) .
"',timee='" . mysql_real_escape_string(time()) . "',polog='" .
mysql_real_escape_string($row['polog']) . "'" ;
$sqlp = mysql_query($query) or die(mysql_error()) ;
}
function zapis_time($row, $opredelenie,$tip)
{
$row['tp']-- ;
$vremja = 20 ;
if ($row[$tip] >= 100)
{
$vremja = $vremja - (round($row[$tip] / 100)) ;
}
if($row['gild_digger']==10){
if($tip=='digger'){
$vremja=$vremja/2;
;}
}
if($row['gild_rudokop']==10){
if($tip=='rudokop'){
$vremja=$vremja/2;
;}
}
$past = time() + $vremja ; //время отдыха ;
$query = "UPDATE `table1` SET `tp`='" .
mysql_real_escape_string($row['tp']) . "',`timme`='" . time() .
"',`time_ruda`='" . mysql_real_escape_string($past) . "' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
}
function dobicha($row,$opredelenie,$tip,$rowzakls)
{
if ($row['auratip'] == '110')
{
mysql_query("UPDATE `table1` SET `aura` = '',`aura_x` = '0',`auratip`='0',`time_aura`='0'
WHERE `name`='" . mysql_real_escape_string($opredelenie) . "';") or die(mysql_error
()) ;
}
$cdate = date("H:i:s") ;
if($tip=='rudokop'){
$text1 = " " . htmlspecialchars($row['name']) .
" отколол кусок рудной породы " ;
$r = mysql_query("select*from new_qwest_pers where name='" . $row['ID'] . "' and `6`='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 qwest='6' and `kolvo`>'0'");
if(mysql_num_rows($r2)==1){
$rr2=mysql_fetch_array($r2);
}
$rr2['kolvo']--;$_SESSION['statusi']="Осталось добыть ".$rr2['kolvo']." руды!<br>";
if($rr2['kolvo']<=0){
$_SESSION['statusi']="Вы выполнили задание. Возращайтесь в гильдию!<br>";
mysql_query("update new_qwest_pers set `6`='2' where name='".$row['ID']."'");
;}mysql_query("update new_qwest_kolvo set kolvo='".$rr2['kolvo']."' where name='".$row['ID']."' and qwest='6'");
;}
////////////////////////////////////
if($rowzakls[3]==0){
mysql_query( "UPdate `slava_pers` set `3`='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']."'") ;
$_SESSION['statusis']="Вы выполнили 3-е достижение";
;}
//////////////////////////////////////////////////////
$e = "Рудная порода" ;
mysql_query("INSERT INTO `rukzak` ( `name` , `tip` , `nazvanie`,`chit`,`time`,`rus_tip` )
VALUES (
'" . mysql_real_escape_string($opredelenie) . "', 'ruda', '" .
mysql_real_escape_string($e) . "','ruda','".time()."','Сплав, используемый кузнецом для получения метала'
)") or die(mysql_error()) ;}
if($tip=='kamenotes'){
$text1 = " " . htmlspecialchars($row['name']) .
" отколол кусок камня " ;
////////////////////////////////////
//////////////////////////////////////////////////////
$e = "Камень" ;
mysql_query("INSERT INTO `rukzak` ( `name` , `tip` , `nazvanie`,`chit`,`time`,`rus_tip` )
VALUES (
'" . mysql_real_escape_string($opredelenie) . "', 'kamen', '" .
mysql_real_escape_string($e) . "','kamen','".time()."','Обычный камень, требуется для постройки и восстановления зданий!'
)") or die(mysql_error()) ;}
if($tip=='digger'){
$r = mysql_query("select*from new_qwest_pers where name='" . $row['ID'] . "' and `7`='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 qwest='7' and `kolvo`>'0'");
if(mysql_num_rows($r2)==1){
$rr2=mysql_fetch_array($r2);
}
$rr2['kolvo']--;$_SESSION['statusi']="Осталось добыть ".$rr2['kolvo']." кристаллов!<br>";
if($rr2['kolvo']<=0){
$_SESSION['statusi']="Вы выполнили задание. Возращайтесь в гильдию!<br>";
mysql_query("update new_qwest_pers set `7`='2' where name='".$row['ID']."'");
;}mysql_query("update new_qwest_kolvo set kolvo='".$rr2['kolvo']."' where name='".$row['ID']."' and qwest='7'");
;}
$qrud = "SELECT * FROM `gemi` WHERE `id`='".rand(1,26)."' " ;
$srud = mysql_query($qrud) or die(mysql_error()) ;
$rrud = mysql_fetch_assoc($srud) ;
$text1 = " " .htmlspecialchars( $row['name']) . " добыл " . htmlspecialchars($rrud['nazvan']) .
" " ;
$k=0;
if($rowzakls[5]==0){
mysql_query( "UPdate `slava_pers` set `5`='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']."'") ;
$_SESSION['statusis']="Вы выполнили 5-е достижение";
;}
mysql_query("INSERT INTO `rukzak` ( `name` , `tip`, `nazvanie`,`try`,`time` ,`lvl`,`chit`,`gem`,`table`,`rus_tip`,`rus_par` )
VALUES (
'" . mysql_real_escape_string($opredelenie) . "', '".$rrud['tipid']."', '" .
mysql_real_escape_string($rrud['nazvan']) . "','".$rrud['par']."','".time()."','".$rrud['lvl']."','gem','','".$rrud['table']."','Кристалл','".$rrud['rus_tip']."'
)") or die(mysql_error()) ;
}
$query = "INSERT INTO `loctext` SET sever='" . mysql_real_escape_string($row['sever']) .
"', wostok='" . mysql_real_escape_string($row['wostok']) . "', text='" .
mysql_real_escape_string($text1) . "', date='" . mysql_real_escape_string($cdate) .
"',timee='" . mysql_real_escape_string(time()) . "',polog='" .
mysql_real_escape_string($row['polog']) . "'" ;
$sqlp = mysql_query($query) or die(mysql_error()) ;
}
function ne_dobil($row,$tip)
{if($tip=='rudokop'){$text1 = " " . htmlspecialchars($row['name']) .
" не смог отколоть породу" ;;}
if($tip=='digger'){$text1 = " " . htmlspecialchars($row['name']) .
" не смог добыть кристалл" ;;}
$cdate = date("H:i:s") ;
$query = "INSERT INTO `loctext` SET sever='" . mysql_real_escape_string($row['sever']) .
"', wostok='" . mysql_real_escape_string($row['wostok']) . "', text='" .
mysql_real_escape_string($text1) . "', date='" . mysql_real_escape_string($cdate) .
"',timee='" . mysql_real_escape_string(time()) . "',polog='" .
mysql_real_escape_string($row['polog']) . "'" ;
$sqlp = mysql_query($query) or die(mysql_error()) ;
}
}
?>