Файл: dvig/dobrak.php
Строк: 179
<?
if ($row['polmmg'] == 'Мужской')
{
$rsql = mysql_query("SELECT *
FROM `brak`
WHERE `name_m`= '$opredelenie' ") ;
$rowmyg=mysql_fetch_array($rsql);
$namemyg=$rowmyg['name_w'] ;$namemygn=$rowmyg['napravlenie'] ;
}
else
{
$rsql = mysql_query("SELECT *
FROM `brak`
WHERE `name_w`= '$opredelenie' ") ;
$rowmyg=mysql_fetch_array($rsql);
$namemyg=$rowmyg['name_m'] ;
$namemygn=$rowmyg['napravlenie'] ; ;
}
$qm=mysql_query("SELECT * FROM `table1` where `name`='$namemyg'");
$rm=mysql_fetch_array($qm);
if(isset($_GET['pir'])){
$f=htmlspecialchars($_GET['pir']);
ohotnikpirat($row, $opredelenie,$f);
;}
$time=time();
#################################################################################################
#################################################################################################
#################################################################################################
#################################################################################################
#################################################################################################
#################################################################################################
#################################################################################################
#################################################################################################
#################################################################################################
$cdate = date("H:i:s") ;
if (isset($_POST['shagi']))
{
$row['tp']-- ;
$kkkk = 1 ;
if (isset($_POST['south']))
{
$nap=1; $south = $_POST['south'] ;
$row['sever']-- ;
if($namemygn==0){
$queryst = "SELECT * FROM `mob_brak` WHERE `id`='4'";
$sqlst = mysql_query($queryst) or die(mysql_error());
$rowst = mysql_fetch_assoc($sqlst);
mysql_query("INSERT INTO `mob_tmp_brak` VALUES ('', '".mysql_real_escape_string($rowst['name'])."', '".mysql_real_escape_string($rowst['ataka'])."'
,'".mysql_real_escape_string($rowst['zashita'])."', '".mysql_real_escape_string($rowst['polog'])."', '".mysql_real_escape_string($rowst['polog1'])."', '-1', '0','".mysql_real_escape_string($rowst['hp'])."','".mysql_real_escape_string($rowst['number'])."','".mysql_real_escape_string($rowst['potroha'])."','0');")or die(mysql_error());;
}
}
if (isset($_POST['west']))
{
$nap=2;
$west = $_POST['west'] ;
$row['wostok']-- ;
if($namemygn==0){
$j=-1;$fg=1;
while($j>=-3){
$queryst = "SELECT * FROM `mob_brak` WHERE `id`='$fg'";
$sqlst = mysql_query($queryst) or die(mysql_error());
$rowst = mysql_fetch_assoc($sqlst);
mysql_query("INSERT INTO `mob_tmp_brak` VALUES ('', '".mysql_real_escape_string($rowst['name'])."', '".mysql_real_escape_string($rowst['ataka'])."'
,'".mysql_real_escape_string($rowst['zashita'])."', '".mysql_real_escape_string($rowst['polog'])."', '".mysql_real_escape_string($rowst['polog1'])."', '0', '$j','".mysql_real_escape_string($rowst['hp'])."','".mysql_real_escape_string($rowst['number'])."','".mysql_real_escape_string($rowst['potroha'])."','0');")or die(mysql_error());;
$j--;$fg++;
}
}
}
if (isset($_POST['north']))
{
$nap=3;
$north = $_POST['north'] ;
$row['sever']++ ;
if($namemygn==0){
$j=1;$fg=1;
while($j<=3){
$queryst = "SELECT * FROM `mob_brak` WHERE `id`='$fg'";
$sqlst = mysql_query($queryst) or die(mysql_error());
$rowst = mysql_fetch_assoc($sqlst);
mysql_query("INSERT INTO `mob_tmp_brak` VALUES ('', '".mysql_real_escape_string($rowst['name'])."', '".mysql_real_escape_string($rowst['ataka'])."'
,'".mysql_real_escape_string($rowst['zashita'])."', '".mysql_real_escape_string($rowst['polog'])."', '".mysql_real_escape_string($rowst['polog1'])."', '$j', '0','".mysql_real_escape_string($rowst['hp'])."','".mysql_real_escape_string($rowst['number'])."','".mysql_real_escape_string($rowst['potroha'])."','0');")or die(mysql_error());;
$j++;$fg++;
}
}
}
if (isset($_POST['east']))
{
$nap=4;
$east = $_POST['east'] ;
$row['wostok']++ ;
if($namemygn==0){
$j=1;$fg=1;
while($j<=3){
$queryst = "SELECT * FROM `mob_brak` WHERE `id`='$fg'";
$sqlst = mysql_query($queryst) or die(mysql_error());
$rowst = mysql_fetch_assoc($sqlst);
mysql_query("INSERT INTO `mob_tmp_brak` VALUES ('', '".mysql_real_escape_string($rowst['name'])."', '".mysql_real_escape_string($rowst['ataka'])."'
,'".mysql_real_escape_string($rowst['zashita'])."', '".mysql_real_escape_string($rowst['polog'])."', '".mysql_real_escape_string($rowst['polog1'])."', '0', '$j','".mysql_real_escape_string($rowst['hp'])."','".mysql_real_escape_string($rowst['number'])."','".mysql_real_escape_string($rowst['potroha'])."','0');")or die(mysql_error());;
$j++;$fg++;
}
}
}
if(isset($_POST['shagi'])){
$q=rand(1,4);
if($q==1){$tablee='artfizik'; $vi="к артфизику";}
if($q==2){$tablee='staratel';$vi="к старателю";}
if($q==3){$tablee='potroshital';$vi="к потрошителю";}
if($q==4){$tablee='enchayz';$vi="к ювелиру";}
if ($row['polmmg'] == 'Мужской')
{
$rsql = mysql_query("SELECT *
FROM `brak`
WHERE `name_m`= '$opredelenie' and `napravlenie`='0' ") ;
if (mysql_num_rows($rsql) > 0)
{
$textt = "$opredelenie и $namemyg получили +5 $vi" ;
$row[$tablee]+=5 ;
$query = "UPDATE `table1` SET `$tablee`='" . mysql_real_escape_string($row[$tablee]) .
"'WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
//////////////////////////////////////////////////////////
$queryn = "SELECT * FROM `table1` WHERE `name`='$namemyg'" ;
$sql1n = mysql_query($queryn) or die(mysql_error()) ;
$rown = mysql_fetch_assoc($sql1n);
$rown[$tablee]+=5 ;
$query = "UPDATE `table1` SET `$tablee`='" . mysql_real_escape_string($rown[$tablee]) .
"' WHERE `name`='" .
mysql_real_escape_string($namemyg) . "' LIMIT 1 ;" ;
mysql_query($query) ;
//////////////////////////////////////////////////////////////////////////////////////////////////////////
mysql_query("UPDATE `brak` SET `napravlenie` = '$nap' WHERE `name_m`='$opredelenie' ;") ;
;
$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='12'" ;
$sqlp = mysql_query($query) or die(mysql_error()) ;
}
;
}
else
{
$rsql = mysql_query("SELECT *
FROM `brak`
WHERE `name_w`= '$opredelenie' and `napravlenie`='0'") ;
if (mysql_num_rows($rsql) > 0)
{
$textt = "$opredelenie и $namemyg получили +5 $vi" ;
$row[$tablee]+=5 ;
$query = "UPDATE `table1` SET `$tablee`='" . mysql_real_escape_string($row[$tablee]) .
"' WHERE `name`='" .
mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;" ;
mysql_query($query) ;
//////////////////////////////////////////////////////////
$queryn = "SELECT * FROM `table1` WHERE `name`='$namemyg'" ;
$sql1n = mysql_query($queryn) or die(mysql_error()) ;
$rown = mysql_fetch_assoc($sql1n);
$rown[$tablee]+=5 ;
$query = "UPDATE `table1` SET `$tablee`='" . mysql_real_escape_string($row[$tablee]) .
"' WHERE `name`='" .
mysql_real_escape_string($namemyg) . "' LIMIT 1 ;" ;
mysql_query($query) ;
//////////////////////////////////////////////////////////////////////////////////////////////////////////
mysql_query("UPDATE `brak` SET `napravlenie` = '$nap' WHERE `name_m`='$opredelenie' ;") ;
;
$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='12'" ;
$sqlp = mysql_query($query) or die(mysql_error()) ;
mysql_query("UPDATE `brak` SET `napravlenie` = '$nap' WHERE `name_w`='$opredelenie' ;") ; }
;
}
;}
if ($row['sever']<-4){$row['sever']=4;}if ($row['sever']>4){$row['sever']=4;}
if ($row['wostok']<-4){$row['wostok']=-4;}if ($row['wostok']>4){$row['wostok']=4;}
mysql_query("UPDATE `table1` SET `tp` = '" . mysql_real_escape_string($row['tp']) .
"', `sever`='" . mysql_real_escape_string($row['sever']) . "',`wostok`='" .
mysql_real_escape_string($row['wostok']) . "',`timme`='" .
mysql_real_escape_string($time) . "'
WHERE `name`='" . mysql_real_escape_string($opredelenie) . "' LIMIT 1 ;") ;
;
}
;
#################################################################################################
#################################################################################################
#################################################################################################
#################################################################################################
#################################################################################################
#################################################################################################
if ($row['sever'] < 0)
{
$ntn = abs($row['sever']) ;
$ntnn = "$ntn S" ;
}
else
{
$ntnn = "" . $row['sever'] . "N" ;
}
if ($row['wostok'] < 0)
{
$ntnl = abs($row['wostok']) ;
$ntnnl = "$ntnl E" ;
}
else
{
$ntnnl = "" . $row['wostok'] . "W" ;
}
////////////////////////////////блок куда идем
?>