859299 days, 12 hours, 58 mins

[shady9980]

Hi,

I can't find the file to edit my jail time for my minor crime, back to normal (2 minutes).

so now when i do the crime and fail, i get 859299 days, 12 hours, 58 mins jail time :S

In my head i see this file with alot of time numbers i could change, like if i where into that file a long time ago.. might be a dream lol..

please help :)

also if anyone could help me with my previous time issue i can make you free graphics, like items or something.

i am not the best but its not noobish either, here are some samples.

custom make by ur choice 100 pieces, in psd and png.

[POG1]

Re: 859299 days, 12 hours, 58 mins

whats the crime fail query?

[shady9980]

Re: 859299 days, 12 hours, 58 mins

Hello POG :)

There is no error mate, i just wan't to know how to reduce the time.. and what file :S

waiting 859299 days, 12 hours, 58 mins is kinda sick :S

[DELETE ME NOW!]

Re: 859299 days, 12 hours, 58 mins

 

Hello POG :)

There is no error mate, i just wan't to know how to reduce the time.. and what file :S

waiting 859299 days, 12 hours, 58 mins is kinda sick :S

Like POG1 said it could be the mysql query, or in the database for crimes..

[shady9980]

Re: 859299 days, 12 hours, 58 mins

 

Hello POG :)

There is no error mate, i just wan't to know how to reduce the time.. and what file :S

waiting 859299 days, 12 hours, 58 mins is kinda sick :S

Like POG1 said it could be the mysql query, or in the database for crimes..

aah, you know where i would find that query? i have checked the database and it looks fine, ive put "2" in the jail time.

And earlyer when everything worked i only had to sit 2 minutes in jail after the crime failed.

[shady9980]

Re: 859299 days, 12 hours, 58 mins

So then it must be the mysql query, but ive checked globals,globalsfunc and jailuser, jail etc but can't find any in them that has anything to do with the time on jail :S *sighs*

[DELETE ME NOW!]

Re: 859299 days, 12 hours, 58 mins

If its crimes check the docrime.php file.

[shady9980]

Re: 859299 days, 12 hours, 58 mins

 

<?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` = '".(time() + (2 * $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();
?>

 

Thats my docrime.php

[DELETE ME NOW!]

Re: 859299 days, 12 hours, 58 mins

What are you using v2 or v1?

[shady9980]

Re: 859299 days, 12 hours, 58 mins

Thank you both for the help! :P

Even thou you just pointed me in the right direction..

this was the fix :

change this code

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

 

with this code

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

 

let me know if you need anything graphical made :)

[POG1]

Re: 859299 days, 12 hours, 58 mins

(time() + (2 * $r[crimeJAILTIME]))

Thats why, its adding the timestamp plus twice the jail time.

[DELETE ME NOW!]

Re: 859299 days, 12 hours, 58 mins

Rofl i didnt see that then