Jump to content
MakeWebGames

Help with Jailing

? Sparks ?

By ? Sparks ?
in Game Support

 Share

Recommended Posts

? Sparks ? Newbie

? Sparks ?

Posted
Posted

Ok So My crimes are up and running! but when you get caught for the crime and It says you go to jail you don't

QUERY ERROR: Unknown column 'jailed' in 'field list'

Query was UPDATE users SET jailed=jailed+1 WHERE userid=6

CrazyT Newbie

CrazyT

Posted
Posted

Re: Help with Jailing

 

Ok So My crimes are up and running! but when you get caught for the crime and It says you go to jail you don't

QUERY ERROR: Unknown column 'jailed' in 'field list'

Query was UPDATE users SET jailed=jailed+1 WHERE userid=6

Because users dont have 'jailed' it jail..

? Sparks ? Newbie

? Sparks ?

Posted
  • Author
Posted

Re: Help with Jailing

 

<?php
$macropage="docrime.php?c={$_GET['c']}";
include "globals.php";
print "<div id='content'>";
if($ir['jail'] or $ir['hospital']) { die("

<prb>This page cannot be accessed while in jail or hospital.</prb>
[url='index.php']> Home[/url]"); }
$_GET['c']=abs((int) $_GET['c']);
if(!$_GET['c'])
{
print "

<prb>ERROR! - Invalid crime</prb>
[url='index.php']> Home[/url]";
}
else
{
$q=mysql_query("SELECT * FROM crimes WHERE crimeID={$_GET['c']}",$c);
$r=mysql_fetch_array($q);
if($ir['brave'] < $r['crimeBRAVE'])
{
print "

<prb>You do not have enough Brave to perform this crime.</prb>
[url='index.php']> Home[/url]";
}
else
{
$ec="\$sucrate=".str_replace(array("LEVEL","CRIMEXP","EXP","WILL","IQ"), array($ir['level'], $ir['crimexp'], $ir['exp'], $ir['will'], $ir['IQ']),$r['crimePERCFORM']).";";
eval($ec);
print "<h1>".$r['crimeNAME']."</h1><hr width='90%' align='left' />


".$r['crimeITEXT']."</p>
";
$ir['brave']-=$r['crimeBRAVE'];
mysql_query("UPDATE users SET brave={$ir['brave']} WHERE userid=$userid",$c);
if(rand(1,100) <= $sucrate)
{
print "

".str_replace("{money}",$r['crimeSUCCESSMUNY'],$r['crimeSTEXT'])."</p>";
$ir['money']+=$r['crimeSUCCESSMUNY'];
$ir['crystals']+=$r['crimeSUCCESSCRYS'];
$ir['exp']+=(int) ($r['crimeSUCCESSMUNY']/8);
mysql_query("UPDATE users SET money={$ir['money']}, crystals={$ir['crystals']}, exp={$ir['exp']},crimexp=crimexp+{$r['crimeXP']} WHERE userid=$userid",$c);
if($r['crimeSUCCESSITEM'])
{
 item_add($userid, $r['crimeSUCCESSITEM'], 1);
}
}
else
{
if(rand(1, 2) == 1)
{
print "<p class='crimefail'>".$r['crimeFTEXT']."</p>";
}
else
{
 print "<p class='crimejail'>".$r['crimeJTEXT']."</p>";
 $db->query("UPDATE users SET jailed=jailed+1 WHERE userid=$userid");
 $db->query("UPDATE users SET busted=busted+1 WHERE userid=$userid");
 $db->query("UPDATE `users` SET `jailed` = '$r[crimeJAILTIME]', `jail_reason` = '$r[crimeJREASON]' WHERE `userid` = '$userid'");
 $h->endpage();
 exit;
}
}

print "


[url='docrime.php?c={$_GET[']> Try Again[/url]</p>

[url='criminal.php']> Back to Crimes[/url]</p>";
}
}


$h->endpage();
?>

 

There Is the code, I switched it to jailed and nothing!

Or do I go to a different file, This one Is docrime.php

CrazyT Newbie

CrazyT

Posted
Posted

Re: Help with Jailing

 

$db->query("UPDATE `users` SET `jail` = `jail` + '$r[crimeJAILTIME]', `jail_reason` = '$r[crimeJREASON]' WHERE `userid` = '$userid'");

there wasn't so hard was it?

Uridium Rising Star

Uridium

Posted
Posted

Re: Help with Jailing

try this

 

<?php
$macropage="docrime.php?c={$_GET['c']}";
include "globals.php";
print "<div id='content'>";
if($ir['jail'] or $ir['hospital']) { die("

<prb>This page cannot be accessed while in jail or hospital.</prb>
[url='index.php']> Home[/url]"); }
$_GET['c']=abs((int) $_GET['c']);
if(!$_GET['c'])
{
print "

<prb>ERROR! - Invalid crime</prb>
[url='index.php']> Home[/url]";
}
else
{
$q=mysql_query("SELECT * FROM crimes WHERE crimeID={$_GET['c']}",$c);
$r=mysql_fetch_array($q);
if($ir['brave'] < $r['crimeBRAVE'])
{
print "

<prb>You do not have enough Brave to perform this crime.</prb>
[url='index.php']> Home[/url]";
}
else
{
$ec="\$sucrate=".str_replace(array("LEVEL","CRIMEXP","EXP","WILL","IQ"), array($ir['level'], $ir['crimexp'], $ir['exp'], $ir['will'], $ir['IQ']),$r['crimePERCFORM']).";";
eval($ec);
print "<h1>".$r['crimeNAME']."</h1><hr width='90%' align='left' />


".$r['crimeITEXT']."</p>
";
$ir['brave']-=$r['crimeBRAVE'];
mysql_query("UPDATE users SET brave={$ir['brave']} WHERE userid=$userid",$c);
if(rand(1,100) <= $sucrate)
{
print "

".str_replace("{money}",$r['crimeSUCCESSMUNY'],$r['crimeSTEXT'])."</p>";
$ir['money']+=$r['crimeSUCCESSMUNY'];
$ir['crystals']+=$r['crimeSUCCESSCRYS'];
$ir['exp']+=(int) ($r['crimeSUCCESSMUNY']/8);
mysql_query("UPDATE users SET money={$ir['money']}, crystals={$ir['crystals']}, exp={$ir['exp']},crimexp=crimexp+{$r['crimeXP']} WHERE userid=$userid",$c);
if($r['crimeSUCCESSITEM'])
{
 item_add($userid, $r['crimeSUCCESSITEM'], 1);
}
}
else
{
if(rand(1, 2) == 1)
{
print "<p class='crimefail'>".$r['crimeFTEXT']."</p>";
}
else
{
 print "<p class='crimejail'>".$r['crimeJTEXT']."</p>";
 $db->query("UPDATE users SET jail=jail+1 WHERE userid=$userid");
 $db->query("UPDATE users SET busted=busted+1 WHERE userid=$userid");
 $db->query("UPDATE `users` SET `jail` = '$r[crimeJAILTIME]', `jail_reason` = '$r[crimeJREASON]' WHERE `userid` = '$userid'");
 $h->endpage();
 exit;
}
}

print "


[url='docrime.php?c={$_GET[']> Try Again[/url]</p>

[url='criminal.php']> Back to Crimes[/url]</p>";
}
}


$h->endpage();
?>
Haunted Dawg Newbie

Haunted Dawg

Posted
Posted

Re: Help with Jailing

 

<?php
$macropage="docrime.php?c={$_GET['c']}";
include "globals.php";
print "<div id='content'>";
if($ir['jail'] or $ir['hospital']) { die("

<prb>This page cannot be accessed while in jail or hospital.</prb>
[url='index.php']> Home[/url]"); }
$_GET['c']=abs((int) $_GET['c']);
if(!$_GET['c'])
{
print "

<prb>ERROR! - Invalid crime</prb>
[url='index.php']> Home[/url]";
}
else
{
$q=mysql_query("SELECT * FROM crimes WHERE crimeID={$_GET['c']}",$c);
$r=mysql_fetch_array($q);
if($ir['brave'] < $r['crimeBRAVE'])
{
print "

<prb>You do not have enough Brave to perform this crime.</prb>
[url='index.php']> Home[/url]";
}
else
{
$ec="$sucrate=".str_replace(array("LEVEL","CRIMEXP","EXP","WILL","IQ"), array($ir['level'], $ir['crimexp'], $ir['exp'], $ir['will'], $ir['IQ']),$r['crimePERCFORM']).";";
eval($ec);
print "<h1>".$r['crimeNAME']."</h1><hr width='90%' align='left' />


".$r['crimeITEXT']."</p>
";
$ir['brave']-=$r['crimeBRAVE'];
mysql_query("UPDATE users SET brave={$ir['brave']} WHERE userid=$userid",$c);
if(rand(1,100) <= $sucrate)
{
print "

".str_replace("{money}",$r['crimeSUCCESSMUNY'],$r['crimeSTEXT'])."</p>";
$ir['money']+=$r['crimeSUCCESSMUNY'];
$ir['crystals']+=$r['crimeSUCCESSCRYS'];
$ir['exp']+=(int) ($r['crimeSUCCESSMUNY']/8);
mysql_query("UPDATE users SET money={$ir['money']}, crystals={$ir['crystals']}, exp={$ir['exp']},crimexp=crimexp+{$r['crimeXP']} WHERE userid=$userid",$c);
if($r['crimeSUCCESSITEM'])
{
 item_add($userid, $r['crimeSUCCESSITEM'], 1);
}
}
else
{
if(rand(1, 2) == 1)
{
print "<p class='crimefail'>".$r['crimeFTEXT']."</p>";
}
else
{
 print "<p class='crimejail'>".$r['crimeJTEXT']."</p>";
 $db->query("UPDATE `users` SET `jail` = '$r[crimeJAILTIME]', `jail_reason` = '$r[crimeJREASON]' WHERE `userid` = '$userid'");
 $h->endpage();
 exit;
}
}

print "


[url='docrime.php?c={$_GET[']> Try Again[/url]</p>

[url='criminal.php']> Back to Crimes[/url]</p>";
}
}


$h->endpage();
?>

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...