Jump to content
MakeWebGames

Gang surrender accept, SQL error.

03laceys

By 03laceys
in General Discussion

 Share

Recommended Posts

03laceys Newbie

03laceys

Posted
Posted

If any tries to accept a surrender they get the following error,

 

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=

The error is in this line but i cant see the error.

 

$wq=$db->query("SELECT * FROM gangwars where warID={$_POST['war']}");

 

Any help?

Thank you.

Link to comment
Share on other sites
03laceys Newbie

03laceys

Posted
  • Author
Posted

Re: Gang surrender accept, SQL error.

 

function gang_staff_surrender()
{
global $db,$ir,$c,$userid,$gangdata;
if(!isset($_POST['subm']))
{
print "<form action='yourgang.php?action=staff&act2=surrender' method='post'>
Choose who to surrender to.

<input type='hidden' name='subm' 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']);
$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>

Message: <input type='text' name='msg' />

<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("'","''","[url='gangs.php?action=view&ID={$ir[']{$gangdata['gangNAME']}[/url] have asked to surrender the war against [url='gangs.php?action=view&ID={$them[']{$them['gangNAME']}[/url]");
$db->query("INSERT INTO gangevents VALUES('',{$ir['gang']},unix_timestamp(),'$event') , ('',".$r[$f].",unix_timestamp(),'$event')");
print "You have asked to surrender.";
}
}

 

The function.

Link to comment
Share on other sites
Zero-Affect Newbie

Zero-Affect

Posted
Posted

Re: Gang surrender accept, SQL error.

looks exactly the same has mine

function gang_staff_surrender()
{
global $db,$ir,$c,$userid,$gangdata;
if(!isset($_POST['subm']))
{
print "<form action='yourgang.php?action=staff&act2=surrender' method='post'>
Choose who to surrender to.

<input type='hidden' name='subm' 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']);
$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>

Message: <input type='text' name='msg' />

<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("'","''","[url='gangs.php?action=view&ID={$ir[']{$gangdata['gangNAME']}[/url] have asked to surrender the war against [url='gangs.php?action=view&ID={$them[']{$them['gangNAME']}[/url]");
$db->query("INSERT INTO gangevents VALUES('',{$ir['gang']},unix_timestamp(),'$event') , ('',".$r[$f].",unix_timestamp(),'$event')");
print "You have asked to surrender.";
}
}
Link to comment
Share on other sites
Floydian Newbie

Floydian

Posted
Posted

Re: Gang surrender accept, SQL error.

Before the error, put in:

echo $_POST['war'];

and see if anything is output.

my money is still on the form not actually have a war value to submit (that doesn't mean the form doesn't submit an empty value for war, it means that the form may not be getting an actual value for it)

Link to comment
Share on other sites
Haunted Dawg Newbie

Haunted Dawg

Posted
Posted

Re: Gang surrender accept, SQL error.

This is a normal problem for all new v2 mccode game's.

 

function gang_staff_surrender()
{
   global $db,$ir,$c,$userid,$gangdata;
   if(!isset($_POST['subm']))
   {
      echo '<form action="yourgang.php?action=staff&act2=surrender" method="post">
         Choose who to surrender to.[b]
            <input type="hidden" name="subm" value="submit">
            Gang: <select type="dropdown" name="war">';
            $wq = mysql_query("SELECT * FROM gangwars where warDECLARER=".$ir['gang']." or warDECLARED=".$ir['gang']) or die(mysql_error());
            while($r = mysql_fetch_assoc($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 = mysql_query("SELECT * FROM gangs WHERE gangID=".$r['$f']) or die(mysql_error());
                  $them = mysql_fetch_assoc($ggq);
                  echo '<option value="'.$r['warID'].'" name="war">'.$them['gangNAME'].'</option>';
            }
            echo '</select>

                  Message: <input type="text" name="msg">

                  <input type="submit" value="Surrender"></form>';
   }
   else
   {
       $_POST['war'] = abs(@intval($_POST['war']));
       $wq = mysql_query("SELECT * FROM gangwars where warID=".$_POST['war'].") or die(mysql_error());
       $r = mysql_fetch_assoc($wq);
       if($gangdata['gangID'] == $r['warDECLARER'])
    { 
        $w = "You";
        $f = "warDECLARED"; 
    } 
    else 
    { 
        $w = "Them";
        $f = "warDECLARER"; 
    }
       mysql_query("INSERT INTO surrenders VALUES(NULL,".$_POST['war'].",".$ir['gang'].",".$r[$f].",'".$_POST['msg']."')") or die(mysql_error());
       $ggq = mysql_query("SELECT * FROM gangs WHERE gangID=".$r['$f']) or die(mysql_error());
       $them = mysql_fetch_assoc($ggq);
       $event = str_replace("'","''","[url='gangs.php?action=view&ID=".$ir[']".$gangdata['gangNAME']."[/url] have asked to surrender the war against [url='gangs.php?action=view&ID=".$them[']".$them['gangNAME']."[/url]");
       mysql_query("INSERT INTO gangevents VALUES('',".$ir['gang'].",unix_timestamp(),'".$event."') , ('',".$r['$f'].",unix_timestamp(),'".$event."')") or die(mysql_error());
       echo 'You have asked to surrender';
   }
}

 

See if that helps.

Link to comment
Share on other sites
03laceys Newbie

03laceys

Posted
  • Author
Posted

Re: Gang surrender accept, SQL error.

According to the error the problem is:

Here,

$db->query("DELETE FROM gangwars WHERE warID={$_POST['war']}");

Or Here,

$wq=$db->query("SELECT * FROM gangwars where warID={$_POST['war']}");

 

Ummmm any help?

 

Whole function if it help's

function gang_staff_viewsurrenders()
{
global $db,$ir,$c,$userid,$gangdata;
if(!isset($_POST['subm']))
{
print "<form action='yourgang.php?action=staff&act2=viewsurrenders' method='post'>
Choose who to accept the surrender from.

<input type='hidden' name='subm' value='submit' />
Gang: <select name='sur' type='dropdown'>";
$wq=$db->query("SELECT s.*,w.* FROM surrenders s LEFT JOIN gangwars w ON s.surWAR=w.warID WHERE surTO={$ir['gang']}");

while($r=$db->fetch_row($wq))
{
if($gangdata['gangID'] == $r['warDECLARER']) { $w="You";$f="warDECLARED"; } else { $w="Them";$f="warDECLARER"; }
$ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]);
$them=$db->fetch_row($ggq);
print "<option value='{$r['surID']}'>War vs. {$them['gangNAME']} (Msg: {$r['surMSG']})</option>";
}






print "</select>
<input type='submit' value='Accept Surrender' /></form>";

}
else
{
$_POST['sur'] = abs((int) $_POST['sur']);

$q=$db->query("SELECT surWAR FROM surrenders WHERE surID={$_POST['sur']}");

list($_POST['war']) = $db->fetch_row($q);

$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("DELETE FROM surrenders WHERE surID={$_POST['sur']}");

$db->query("DELETE FROM gangwars WHERE warID={$_POST['war']}");

$ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]);$them=$db->fetch_row($ggq);$event=str_replace("'","''","[url='gangs.php?action=view&ID={$ir[']{$gangdata['gangNAME']}[/url] have accepted the surrender from [url='gangs.php?action=view&ID={$them[']{$them['gangNAME']}[/url], the war is over!");$db->query("INSERT INTO gangevents VALUES('',{$ir['gang']},unix_timestamp(),'$event') , ('',".$r[$f].",unix_timestamp(),'$event')");print "You have accepted surrender, the war is over.";
}}

 

There is no gang_surrender_accept() so it must be in the fuction provided.

Any help?

Link to comment
Share on other sites
Haunted Dawg Newbie

Haunted Dawg

Posted
Posted

Re: Gang surrender accept, SQL error.

 

function gang_staff_viewsurrenders()
{
global $db,$ir,$c,$userid,$gangdata;
if(!isset($_POST['subm']))
{
print "<form action='yourgang.php?action=staff&act2=viewsurrenders' method='post'>
Choose who to accept the surrender from.

<input type='hidden' name='subm' value='submit' />
Gang: <select name='sur' type='dropdown'>";
$wq=$db->query("SELECT s.*,w.* FROM surrenders s LEFT JOIN gangwars w ON s.surWAR=w.warID WHERE surTO={$ir['gang']}");
while($r=$db->fetch_row($wq))
{
if($gangdata['gangID'] == $r['warDECLARER']) { $w="You";$f="warDECLARED"; } else { $w="Them";$f="warDECLARER"; }
$ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]);
$them=$db->fetch_row($ggq);
print "<option value='{$r['surID']}'>War vs. {$them['gangNAME']} (Msg: {$r['surMSG']})</option>";
}
print "</select>
<input type='submit' value='Accept Surrender' /></form>";
}
else
{
$_POST['sur'] = abs((int) $_POST['sur']);
$q=$db->query("SELECT surWAR FROM surrenders WHERE surID={$_POST['sur']}");
list($_POST['war']) = $db->fetch_row($q);
$wq=$db->query("SELECT * FROM gangwars where warID={$_POST['sur']}");
$r=$db->fetch_row($wq);
if($gangdata['gangID'] == $r['warDECLARER']) 
{ 
$w="You";
$f="warDECLARED"; 
} 
else 
{ 
$w="Them";
$f="warDECLARER"; 
}
$db->query("DELETE FROM surrenders WHERE surID={$_POST['sur']}");
$db->query("DELETE FROM gangwars WHERE warID={$_POST['sur']}");
$ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]);$them=$db->fetch_row($ggq);$event=str_replace("'","''","[url='gangs.php?action=view&ID={$ir[']{$gangdata['gangNAME']}[/url] have accepted the surrender from [url='gangs.php?action=view&ID={$them[']{$them['gangNAME']}[/url], the war is over!");$db->query("INSERT INTO gangevents VALUES('',{$ir['gang']},unix_timestamp(),'$event') , ('',".$r[$f].",unix_timestamp(),'$event')");print "You have accepted surrender, the war is over.";
}
}

 

You had to change all your $_POST['war'] to $_POST['sur']

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...