Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[ReignFire]

Has anyone else had this problem?

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query was SELECT * FROM gangwars where warID=

[Danny696]

Yep, it hasent ever worked.

[ReignFire]

and nobody cares to fix it???

[Danny696]

People have fixed it, but they dont post it.

[ReignFire]

ok...well then i guess im hoping someone on here can point me in the right direction. im obviously not the only schmuck!

[Danny696]

Ill give it a go, when i get back in an hour.

[ReignFire]

i appreciate it...ive been slamming my head up against this for a few days...i cant figure it out. it can grab the call else where in the code, but for the surrender it has an issue and their are no differences between the ones that work

[Danny696]

Code: [Select]

<?php // remove this when adding
function gang_staff_surrender()
{
global $db,$ir,$c,$userid,$gangdata;
if(!isset($_POST['submit']))
{
print "<form action='yourgang.php?action=staff&act2=surrender' method='post'>
Choose who to surrender to.<br />
<input type='hidden' name='submit' value='submit' />
Gang: <select name='war' type='dropdown'>";
$wq=$db->query("SELECT * FROM gangwars WEHER warDECLARER=".$ir['gang']." OR warDECLARED=".$ir['gang']."");
while($r=$db->fetch_row($wq))
{
if($gangdata['gangID'] == $r['warDECLARER']) { $w="You"; $f="warDECLARED"; } else { $w="Them"; $f="warDECLARER"; }
$d=date('F j, Y, g:i:s a',$r['warTIME']);
$ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]."");
$them=$db->fetch_row($ggq);
print "<option value='".$r['warID']."'>".$them['gangNAME']."</option>";
}
print "</select><br />
Message: <input type='text' name='msg' /><br />
<input type='submit' value='Surrender' /></form>";
}
else
{
$_POST['war'] = abs((int) $_POST['war']);
$wq=$db->query("SELECT * FROM gangwars WHERE warID=."$_POST['war']."");
$r=$db->fetch_row($wq);
if($gangdata['gangID'] == $r['warDECLARER']) { $w="You";$f="warDECLARED"; } else { $w="Them";$f="warDECLARER"; }
$db->query("INSERT INTO surrenders VALUES('',".$_POST['war'].",".$ir['gang'].",".$r[$f].",'".$_POST['msg']."')");
$ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]."");
$them=$db->fetch_row($ggq);
$event=str_replace("'","''","<a href='gangs.php?action=view&ID=".$ir['gang']."'>".$gangdata['gangNAME']."</a> have asked to surrender the war against <a href='gangs.php?action=view&ID=".$them['gangID']."'>".$them['gangNAME']."</a>");
$db->query("INSERT INTO gangevents VALUES('',".$ir['gang'].",unix_timestamp(),'$event') , ('',".$r[$f].",unix_timestamp(),'$event')");
print "You have asked to surrender.";
}
}
Should work, untested.

[ReignFire]

is this going to  correct the surrender accepting portion as well? or is that a whole other beast to take down?

[ReignFire]

constant encapsed string in there somewhere and i couldnt find it...appreciate the effort though

[HauntedDawg]

Your method is wrong danny.

You see, 'cause of the war's gang's get deleted, so that screw's up the list. Check into fixing the remove from gang when 0 respect and make sure to delete all war entry's at the same time.

[Danny696]

Dabs made alot of mistakes on the gang file like this: WHERE gangID=".$r[$f]); And HD, im kinda confuzed what you mean

[ReignFire]

the whole thing is just messy if you ask me...its giving me a headache 

[Danny696]

Rite, me is haveing another go.

[Danny696]

Code: [Select]

<?php // remove when adding
function gang_staff_surrender()
{
global $db,$ir,$c,$userid,$gang;
if(!isset($_POST['submit']))
{
echo'<form action=\'?action=staff&act2=surrender\' method=\'post\'>
Choose who to surrender to.<br />
<input type=\'hidden\' name=\'submit\' value=\'submit\' />
Gang: <select name=\'war\' type=\'dropdown\'>';
$wq=$db->query("SELECT * FROM gangwars WHERE warDECLARER=".$ir['gang']." OR warDECLARED=".$ir['gang']."");
while($r=$db->fetch_row($wq))
{
if($gangdata['gangID'] == $r['warDECLARER']) { $w="You"; $f="warDECLARED"; } else { $w="Them"; $f="warDECLARER"; }
$d=date('F j, Y, g:i:s a',$r['warTIME']);
$them = $db->fetch_row($db->query("SELECT * FROM gangs WHERE gangID=".$r[$f].""));
echo'<option value=\''.$r['warID'].'\'>'.$them['gangNAME']'"</option>';
}
echo'</select><br />
Message: <input type=\'text\' name=\'msg\' /><br />
<input type=\'submit\' value=\'Surrender\' /></form>';
}
else
{
$_POST['war'] = abs((int) $_POST['war']);
$r = $db->fetch_row($db->query("SELECT * FROM gangwars WHERE warID=".$_POST['war'].""));
if($gangdata['gangID'] == $r['warDECLARER']) { $w="You";$f="warDECLARED"; } else { $w="Them";$f="warDECLARER"; }
$db->query("INSERT INTO surrenders VALUES('',".$_POST['war'].",".$ir['gang'].",".$r[$f].",'".$_POST['msg']."')");
$them = $db->fetch_row($db->query("SELECT * FROM gangs WHERE gangID=".$r[$f].""));
$event=str_replace("'","''","<a href='gangs?action=view&ID=".$ir['gang']."'>".$gang['gangNAME']."</a> have asked to surrender the war against <a href='gangs.php?action=view&ID=".$them['gangID']."'>".$them['gangNAME']."</a>");
$db->query("INSERT INTO gangevents VALUES('',".$ir['gang'].",unix_timestamp(),'$event') , ('',".$r[$f].",unix_timestamp(),'$event')");
print "You have asked to surrender.";
}
}
if theres any errors pleas copy and paste them