crimes

[XCU53S]

why do my crimes take double brave than they should btw i am running mccodes v2

[AlabamaHit]

Re: crimes

Sounds like the query is in there 2 times to do it...or they are refreshing the page.....post the query that takes there brave and i will help.

[XCU53S]

Re: crimes

This is my criminal.php

 

<?php
$macropage="criminal.php";
include "globals.php";
if($ir['jail'] or $ir['hospital']) { die("This page cannot be accessed while in jail or hospital."); }
$q2=$db->query("SELECT * FROM crimes ORDER BY crimeBRAVE ASC");
while ($r2=$db->fetch_row($q2))
{
$crimes[]=$r2;
}
$q=$db->query("SELECT * FROM crimegroups ORDER by cgORDER ASC");
print "[b]Military Missions[/b]

<table width='75%' cellspacing=1 class='table'><tr><th>Crime</th><th>Cost</th><th>Do</th></tr>";
while($r=$db->fetch_row($q))
{
print "<tr><td colspan='3' class='h'>{$r['cgNAME']}</td></tr>";
foreach($crimes as $v)
{
if($v['crimeGROUP'] == $r['cgID'])
{
print "<tr><td>{$v['crimeNAME']}</td><td>{$v['crimeBRAVE']} Brave</td><td>[url='docrime.php?c={$v[']Do[/url]</td></tr>";
}
}
}
print "</table>";
$h->endpage();
?>

 

this is my do crime.php:

 

<?php
$macropage="docrime.php?c={$_GET['c']}";
include "globals.php";
if($ir['jail'] or $ir['hospital']) { die("This page cannot be accessed while in jail or hospital."); }
$_GET['c']=abs((int) $_GET['c']);
if(!$_GET['c'])
{
print "Invalid crime";
}
else
{
$q=mysql_query("SELECT * FROM crimes WHERE crimeID={$_GET['c']}",$c);
$r=mysql_fetch_array($q);
if($ir['brave'] < $r['crimeBRAVE'])
{
print "You do not have enough Brave to perform this crime.";
}
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 $r['crimeITEXT'];
$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']);
$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 $r['crimeFTEXT'];
}
else
{
 print $r['crimeJTEXT'];
 $db->query("UPDATE `users` SET `jail` = '$r[crimeJAILTIME]', `jail_reason` = '$r[crimeJREASON]' WHERE `userid` = '$userid'");
}
}

print "
[url='docrime.php?c={$_GET[']Try Again[/url]

[url='criminal.php']Crimes[/url]";
}
}


$h->endpage();
?>

 

the SQL is the one that happens with the installer.php

[XCU53S]

Re: crimes

so can anyone help me?

[Isomerizer]

Re: crimes

Erm, can't see the potential error here, but this may help..

Change

mysql_query("UPDATE users SET brave={$ir['brave']} WHERE userid=$userid",$c);

to

mysql_query("UPDATE `users` SET `brave` = `brave` - ".$r['crimeBRAVE']." WHERE `userid` = ".$userid." ",$c);

[XCU53S]

Re: crimes

no luck still taking double may have to scrap missions and convert my script i made fot my other game using javascript.

[XCU53S]

Re: crimes

any one else got a working missions script? can you give it to me via PM

[XCU53S]

Re: crimes

will anyone find a fix? or mail me a working one im sitting here helpless :|