Jump to content
MakeWebGames

Total Crime Income FREE


Halo

Recommended Posts

This is a very easy code but for people who ain't bothered to make it here it is:

SQL QUERY

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Add In docrime.php

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Add in veiwuser.php

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

And your done

Link to comment
Share on other sites

Guest Anonymous

Re: Total Crime Income FREE

Remember you don't need to create one field for every element, a comma separated field would suffice rather nicely here.

Link to comment
Share on other sites

Re: Total Crime Income FREE

This is the crime failed mod, i only did crime failed because when you try and do both they both go up even when you didn't fail a crime,

SQL

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Add in viewuser.php

Crimes Failed: {$r['cfailed']}

 

Add in docrime.php

mysql_query("UPDATE users SET cfailed=cfailed+1 WHERE userid=$userid", $c);

Link to comment
Share on other sites

Re: Total Crime Income FREE

Here i have made one with

Crimes Successful

Crimes Failed

Crimes Total

And Total Crime Income

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

And The Sql's And Links Are:

Crimes Successful

ALTER TABLE `users` ADD `crimesdone` INT (11) NOT NULL DEFAULT '0';
Crimes: {$ir['crimesdone']} Successful

Crimes Failed

ALTER TABLE `users` ADD `crimesfailed` INT (11) NOT NULL DEFAULT '0';
Crimes: {$ir['crimesfailed']} Failed

Crimes Total

ALTER TABLE `users` ADD `crimes` INT (11) NOT NULL DEFAULT '0';
Crimes: {$ir['crimes']} Total

Total Crime Income

ALTER TABLE `users` ADD `cincome` INT(11) NOT NULL DEFAULT '0';
Crimes Income: \${$ir['cincome']}

This Should Work Fine Any Problem Just Post Or Pm Me :-D

Link to comment
Share on other sites

Re: Total Crime Income FREE

you missed a bit out of that script i saw it when i looked over it is:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

add that after:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

Link to comment
Share on other sites

Re: Total Crime Income FREE

 

Posted on: Today at 11:22:00Posted by: Klikoka

Insert Quote

you missed a bit out of that script i saw it when i looked over it is:

Code:

mysql_query("UPDATE users SET crimes=crimes+1 WHERE userid=$userid", $c);:

add that after

Code:

mysql_query("UPDATE users SET crimesfailed=crimesfailed+1 WHERE userid=$userid", $c);

Yh but if you did that then everytime you passed a crime it would say that you failed one aswell

if you look through the script you will notice that is where it should be.

Link to comment
Share on other sites

Guest Anonymous

Re: Total Crime Income FREE

Oh yeah did not past the include properly.

$fm=money_formatter($ir['money']);

$cm=money_formatter($ir['crystals'],'');

$lv=date('F j, Y, g:i a',$ir['laston']);

$h->userdata($ir,$lv,$fm,$cm);

$h->menuarea();

Link to comment
Share on other sites

Guest Anonymous

Re: Total Crime Income FREE

Without really looking it in any detail ... the obvious fault would appear to be in the line

$q=db->query("SELECT * FROM crimes WHERE crimeID={$_GET['c']}",$c);

Now, by inserting the missing $ you may find an improvement...

$q=$db->query("SELECT * FROM crimes WHERE crimeID={$_GET['c']}",$c);

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.

×
×
  • Create New...