Halo Posted March 25, 2008 Posted March 25, 2008 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 Quote
Danny Posted March 25, 2008 Posted March 25, 2008 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. Quote
Halo Posted March 25, 2008 Author Posted March 25, 2008 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 Quote
Danny Posted March 25, 2008 Posted March 25, 2008 Re: Total Crime Income FREE c0der u got msn if so add me on [email protected] and i speak toyou how we could expand this Quote
Halo Posted March 25, 2008 Author Posted March 25, 2008 Re: Total Crime Income FREE c0der u got msn if so add me on [email protected] and i speak toyou how we could expand this I'm on my PSP atm so i cant but when i get on the PC or laptop i will Quote
Danny Posted March 25, 2008 Posted March 25, 2008 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 Quote
Halo Posted March 25, 2008 Author Posted March 25, 2008 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... Quote
Guest Anonymous Posted March 25, 2008 Posted March 25, 2008 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. Quote
Halo Posted March 25, 2008 Author Posted March 25, 2008 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 Quote
Halo Posted March 25, 2008 Author Posted March 25, 2008 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 Quote
Danny Posted March 25, 2008 Posted March 25, 2008 Re: Total Crime Income FREE fixed i donno y, i put a standrd 1 up Quote
Halo Posted March 25, 2008 Author Posted March 25, 2008 Re: Total Crime Income FREE kk i signing up Quote
Halo Posted March 25, 2008 Author Posted March 25, 2008 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); Quote
Beardy Posted March 26, 2008 Posted March 26, 2008 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 Quote
Klikoka Posted March 26, 2008 Posted March 26, 2008 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. Quote
Beardy Posted March 26, 2008 Posted March 26, 2008 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. Quote
Evolution™ Posted March 27, 2008 Posted March 27, 2008 Re: Total Crime Income FREE As im a noob, is this v1 or v2? if its v1 can anyone post it for v2 please? many thanks! Quote
Guest Anonymous Posted March 27, 2008 Posted March 27, 2008 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. Quote
Halo Posted March 27, 2008 Author Posted March 27, 2008 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. Quote
Guest Anonymous Posted March 27, 2008 Posted March 27, 2008 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(); Quote
Evolution™ Posted March 28, 2008 Posted March 28, 2008 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 Quote
Guest Anonymous Posted March 28, 2008 Posted March 28, 2008 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); Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.