Jump to content
MakeWebGames

Recommended Posts

Posted

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

Posted

Re: Total Crime Income FREE

 

thanks this works, im doingto mod this abit so only donators can see it and wat non-donators have done.

gd idea

Posted

Re: Total Crime Income FREE

kk, in stead of adding Crime Income: \${$r['cincome']}

into viewuser.php add

 

You're unable to view this code.

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

 

to make this a donator feature

Posted

Re: Total Crime Income FREE

yh it works, but i will just keep it like it is

I am going to be making other stuff e.g Total Crime Failed, Total Crime Success etc...

Guest Anonymous
Posted

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.

Posted

Re: Total Crime Income FREE

Danny6 whats wrong with your game when i want to sign up the register page is full with queries and text that should be invisble when its on the web

Posted

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.

yh i'm doing that for my new mods

Posted

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);

Posted

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

Posted

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.

Posted

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.

Guest Anonymous
Posted

Re: Total Crime Income FREE

v2.

You're unable to view this code.

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

Posted

Re: Total Crime Income FREE

 

v2.

You're unable to view this code.

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

 

Above v2 is wrong

This is v2:

 

You're unable to view this code.

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

Guest Anonymous
Posted

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();

Posted

Re: Total Crime Income FREE

Parse error: syntax error, unexpected T_OBJECT_OPERATOR in /home/kanerose/public_html/docrime.php on line 15

 

still an error here somewhere lol, i cant seem to do it, if anyone can please post it

Guest Anonymous
Posted

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);

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