Halo

Re: [v2]Forum Credits w/ exchange[v2]   Thanks

Re: [v1]Attack Stats FREE[v1] Thanks

Re: [v2]Forum Credits w/ exchange[v2] If anyone got any updates please post! Cya :-D

Re: Counting (nr game) 1837

Re: Count Backwards :D 4988

Re: Forum error Try and uploading your old forums before you installed my mod, if it dosn't work you got a weird error

Re: Forum error Are you sure you never deleted any of the queries when you installed my mod

Re: [v2]Forum Credits w/ exchange[v2] True, but very little if its 10 posts per day, at least they can't send forum credits or that will lead to a lot of points being totaled up

Re: [v1]Attack Stats FREE[v1]   Where the queries are, around the bottom

Re: [v2]Forum Credits w/ exchange[v2] Or you can just set it to 1 credit per post or change the SQL into decimal 1,1 and set it to go up by 0.5 with a 10 posts per day limit

Re: [v2]Forum Credits w/ exchange[v2] True, well its your choice really

Re: [v2]Forum Credits w/ exchange[v2]   Thanks

Re: [v2]Forum Credits w/ exchange[v2] Then just make it so they can post only a few posts per day

Before anyone asks i can't convert this from v2 to v1 because v1 dosn't come with forums.php This is just like CE it gives you credits for every post you do and when you get enough credits you can exchange them for stuff. SQL QUERY   ALTER TABLE `users` ADD `fcredits` INT(11) NOT NULL DEFAULT '0';   First open forums.php Find:   $db->query("INSERT INTO forum_topics VALUES('', {$_GET['forum']}, '{$_POST['ft_name']}', '{$_POST['ft_desc']}', 0, $userid, '$u', unix_timestamp(), 0, '', 0, 0, 0)"); $i=$db->insert_id(); $db->query("INSERT INTO forum_posts VALUES('', {$i}, {$r['ff_id']}, $userid, '$u', unix_timestamp(), '{$_POST['ft_desc']}', '{$_POST['fp_text']}', 0, '', 0, 0)") or die(mysql_error()); $db->query("UPDATE forum_topics SET ft_last_id=$userid, ft_last_name='$u', ft_last_time=unix_timestamp(), ft_posts=ft_posts+1 WHERE ft_id={$i}"); $db->query("UPDATE forum_forums SET ff_lp_time=unix_timestamp(), ff_posts=ff_posts+1, ff_topics=ff_topics+1, ff_lp_poster_id=$userid, ff_lp_poster_name='$u', ff_lp_t_id={$i}, ff_lp_t_name='{$_POST['ft_name']}' WHERE ff_id={$r['ff_id']}"); $db->query("UPDATE users SET posts=posts+1 WHERE userid=$userid");   Add underneath:   $db->query("UPDATE users SET fcredits=fcredits+5 WHERE userid=$userid"); (NOTE: you can change the amount of credits they gain) Then find:   $db->query("INSERT INTO forum_posts VALUES('', {$_GET['reply']}, {$forum['ff_id']}, $userid, '$u', unix_timestamp(), '{$_POST['fp_subject']}', '{$_POST['fp_text']}', 0, '', 0, 0)") or die(mysql_error()); $db->query("UPDATE forum_topics SET ft_last_id=$userid, ft_last_name='$u', ft_last_time=unix_timestamp(), ft_posts=ft_posts+1 WHERE ft_id={$_GET['reply']}"); $db->query("UPDATE forum_forums SET ff_lp_time=unix_timestamp(), ff_posts=ff_posts+1, ff_lp_poster_id=$userid, ff_lp_poster_name='$u', ff_lp_t_id={$_GET['reply']}, ff_lp_t_name='{$topic['ft_name']}' WHERE ff_id={$forum['ff_id']}"); $db->query("UPDATE users SET posts=posts+1 WHERE userid=$userid");   add underneath:   $db->query("UPDATE users SET fcredits=fcredits+5 WHERE userid=$userid");   Then create a file called fctemple.php   <?php /* |------------------------------------------------| fctemple.php Part of the forum credits pack Copyright 2008 Ammo |------------------------------------------------| */ include "globals.php"; if(!$_GET['spend']) { print "Welcome to the forum credit temple! You have [b]{$ir['fcredits']}[/b] forum credits and you have posted [b] {$ir['posts']}[/b] forum posts. What would you like to spend your credits on? [url='fctemple.php?spend=crystals']100 Crystals - 500 Credits[/url] [url='fctemple.php?spend=dp']Donator Pack 1 - 5000 Credits[/url] [url='fctemple.php?spend=willpot']1 Will Potion - 2500 Credits[/url] "; } else { if($_GET['spend'] == 'crystals') { if($ir['fcredits'] < 5000) { print "You don't have enough credits!"; } else { $db->query("UPDATE users SET crystals=crystals+100,fcredits=fcredits-500 WHERE userid=$userid"); print "You have traded 1000 forum credits for 100 crystals."; } } else if($_GET['spend'] == 'dp') { if($ir['fcredits'] < 5000) { print "You don't have enough credits!"; } else { $db->query("UPDATE users SET crystals=crystals+50,fcredits=fcredits-5000,donatordays=donatordays+30 WHERE userid=$userid"); $db->query("UPDATE userstats SET iq=iq+50 WHERE userid=$userid"); print "You have traded 5000 forum credits for the donator pack one."; } } else if($_GET['spend'] == 'willpot') { if($ir['fcredits'] < 2500) { print "You don't have enough credits!"; } else { $db->query("UPDATE users SET fcredits=fcredits-2500 WHERE userid=$userid"); $db->query("INSERT INTO `inventory` VALUES (NULL, '{$set['willp_item']}', '$userid', '1')"); print "You have traded 2500 forum credits for a will potion."; } } } $h->endpage(); ?>   Add in veiwuser.php (OPTIONAL):   Forum Posts: {$r['posts']} Forum Credits: {$r['fcredits']}

Re: [v1]Attack Stats FREE[v1] Yes i tested this on my v2 game it should work

Re: [V2]Mass Donator Days Credit[V2] It works for me

Re: Hospital Escape for V2 A good code, but i wont use it in my game

Re: [v1]Attack Stats FREE[v1] This should be V2 This Shows All The Attack Stats Of A User SQL QUERY   ALTER TABLE `users` ADD `atotal` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `awon` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `alost` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `mmugged` BIGINT (92) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `pleft` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `pmugged` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `phosp` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `tattacked` INT (11) NOT NULL DEFAULT '0';   Add in attacklost.php   $db->query("UPDATE users SET alost=alost+1 WHERE userid=$userid",$c);   Add in attackwon.php   $db->query("UPDATE users SET mmugged=mmugged+$stole WHERE userid=$userid",$c); $db->query("UPDATE users SET pmugged=pmugged+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET awon=awon+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET atotal=atotal+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET tattacked=tattacked+1 WHERE userid={$r['userid']}",$c);   Add in attackbeat.php   $db->query("UPDATE users SET phosp=phosp+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET awon=awon+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET atotal=atotal+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET tattacked=tattacked+1 WHERE userid={$r['userid']}",$c);   Add in attacktake.php   $db->query("UPDATE users SET pleft=pleft+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET awon=awon+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET atotal=atotal+1 WHERE userid=$userid",$c); $db->query("UPDATE users SET tattacked=tattacked+1 WHERE userid={$r['userid']}",$c);   Add in viewuser.php   <u>Attack Statistics</u> Total Attacks: {$r['atotal']} Attacks Won: {$r['awon']} Attacks Lost: {$r['alost']} Times Attacked: {$r['tattacked']} People Left: {$r['pleft']} People Hospilatized: {$r['phosp']} People Mugged: {$r['pmugged']} Money Mugged: \${$r['mmugged']}   And your done!

Re: [v1]Attack Stats FREE[v1] Thanks

Re: Horse Racing[v1 + v2] Nice :-D, wasn't there one called The Bookies

A simple mod that took me only 5mins to code, tested and working! This Shows All The Attack Stats Of A User SQL QUERY   ALTER TABLE `users` ADD `atotal` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `awon` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `alost` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `mmugged` BIGINT (92) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `pleft` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `pmugged` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `phosp` INT (11) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `tattacked` INT (11) NOT NULL DEFAULT '0';   Add in attacklost.php   mysql_query("UPDATE users SET alost=alost+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET atotal=atotal+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET tattacked=tattacked+1 WHERE userid={$r['userid']}",$c);   Add in attackmug.php   mysql_query("UPDATE users SET mmugged=mmugged+$stole WHERE userid=$userid",$c); mysql_query("UPDATE users SET pmugged=pmugged+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET awon=awon+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET atotal=atotal+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET tattacked=tattacked+1 WHERE userid={$r['userid']}",$c);   Add in attackhosp.php   mysql_query("UPDATE users SET phosp=phosp+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET awon=awon+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET atotal=atotal+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET tattacked=tattacked+1 WHERE userid={$r['userid']}",$c);   Add in attackleave.php   mysql_query("UPDATE users SET pleft=pleft+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET awon=awon+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET atotal=atotal+1 WHERE userid=$userid",$c); mysql_query("UPDATE users SET tattacked=tattacked+1 WHERE userid={$r['userid']}",$c);   Add in viewuser.php   <u>Attack Statistics</u> Total Attacks: {$r['atotal']} Attacks Won: {$r['awon']} Attacks Lost: {$r['alost']} Times Attacked: {$r['tattacked']} People Left: {$r['pleft']} People Hospitalized: {$r['phosp']} People Mugged: {$r['pmugged']} Money Mugged: \${$r['mmugged']}   And your done!

Re: Ajax chat for V2 You have to change the permissions to 0777

Re: [mccode] Whore House Mod FREE This should be v2:   <?php /*----------------------------------------------------- -- Whore House v1.0 -- A product of Stage3Gaming -- [url]http://www.stage3gaming.com[/url] -- whorehouse.php -----------------------------------------------------*/ include "globals.php"; if(!$_GET['spend']) { if($ir['user_level'] <1) { print"Page closed for developement."; $h->endpage(); exit; } if($ir['brothel'] >2) { print"You would visit this establishment more than three times a day? Are you really trying to make it fall off?"; $h->endpage(); exit; } if ($ir['energy'] < $ir['maxenergy']) { print "<font color='red'>[b]You can only visit here when you have at least 100% energy.</font>[/b]"; $h->endpage(); exit; } print "<table border='1' width='90%'class='table' bordercolor='#939393'><th><h3>Speakeasy Brothel</h3></th><tr><td> Welcome, we have many fine prostitutes here, both male and female. Prices and payment options are listed below. Each time you sleep with someone you will gain will but you will also lose energy and some of your money! P.S. They love you long time!</td></tr></table> <h3>For The Guys</h3> <table border='1' width='90%' bordercolor='#939393' class='table'><tr><th>Prostitute</th><th>Age</th><th>Sex</th><th>Price</th><th><center>Hire</th></tr><tr> <td><center>April</td><td><center>19</td><td><center>Female</td><td><center>$300,000</td><td><center>[url='whorehouse.php?spend=april']Hire April[/url]</td></tr><tr> <td><center>Kelly</td><td><center>18</td><td><center>Female</td><td><center>$500,000</td><td><center>[url='whorehouse.php?spend=kelly']Hire Kelly[/url]</td></tr><tr> <td><center>Violet</td><td><center>23</td><td><center>Female</td><td><center>$1,000,000</td><td><center>[url='whorehouse.php?spend=shan']Hire Violet[/url]</td></tr><tr> <td><center>Emma</td><td><center>20</td><td><center>Female</td><td><center>$5,000,000</td><td><center>[url='whorehouse.php?spend=rhonda']Hire Emma[/url]</td></tr></table>"; print " <h3>For The Ladies</h3> <table border='1' width='90%' bordercolor='#939393' class='table'><tr><th>Prostitute</th><th>Age</th><th>Sex</th><th>Price</th><th><center>Hire</th></tr><tr> <td><center>Mark</td><td><center>26</td><td><center>Male</td><td><center>$300,000</td><td><center>[url='whorehouse.php?spend=mark']Hire Mark[/url]</td></tr><tr> <td><center>Bill</td><td><center>23</td><td><center>Male</td><td><center>$500,000</td><td><center>[url='whorehouse.php?spend=jason']Hire Bill[/url]</td></tr><tr> <td><center>Eddy</td><td><center>20</td><td><center>Male</td><td><center>$1,000,000</td><td><center>[url='whorehouse.php?spend=jaq']Hire Eddy[/url]</td></tr><tr> <td><center>Matthew</td><td><center>29</td><td><center>Male</td><td><center>$5,000,000</td><td><center>[url='whorehouse.php?spend=matt']Hire Matthew[/url]</td></tr></table>"; print " <h3>Gay And Lesbian Only</h3> <table border='1' width='90%' bordercolor='#939393' class='table'><tr><th>Prostitute</th><th>Age</th><th>Sex</th><th>Price</th><th><center>Hire</th></tr><tr> <td><center>Tommy</td><td><center>22</td><td><center>Male</td><td><center>$1,000,000</td><td><center>[url='whorehouse.php?spend=tom']Hire Tommy[/url]</td></tr><tr> <td><center>Tina</td><td><center>18</td><td><center>Female</td><td><center>$5,000,000</td><td><center>[url='whorehouse.php?spend=tina']Hire Tina[/url]</td></tr><tr> <td><center>Riko</td><td><center>20</td><td><center>Male</td><td><center>$7,000,000</td><td><center>[url='whorehouse.php?spend=riko']Hire Riko[/url]</td></tr><tr> <td><center>Michelle</td><td><center>18</td><td><center>Female</td><td><center>$10,000,000</td><td><center>[url='whorehouse.php?spend=mich']Hire Michelle[/url]</td></tr></table>"; } else { if($_GET['spend'] == 'april') { if($ir['money'] <300000) { print "You don't have enough money to hire a April!"; } else { db->query("UPDATE users SET will=will+35,energy=0,money=money-300000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed a April \$300,000, took her to the back room and had your way with her. You feel some of your will coming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'kelly') { if($ir['money'] <500000) { print "You don't have enough money to hire a Kelly!"; } else { db->query("UPDATE users SET will=will+70,energy=0,money=money-500000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed a Kelly \$500,000, took her to the back room and had your way with her. You feel some of your will coming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'shan') { if($ir['money'] <1000000) { print "You don't have enough money to hire a Violet!"; } else { db->query("UPDATE users SET will=will+140,energy=0,money=money-1000000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed Violet \$1,000,000, took her to the back room and had your way with her. You feel some of your will coming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'rhonda') { if($ir['money'] <5000000) { print "You don't have enough money to hire a Emma!"; } else { db->query("UPDATE users SET will=will+250,energy=0,money=money-5000000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed Emma \$5,000,000, took her to the back room and had your way with her. You feel some of your will coming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'mark') { if($ir['money'] <300000) { print "You don't have enough money to hire a Mark!"; } else { db->query("UPDATE users SET will=will+35,energy=0,money=money-300000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed a Mark \$300,000, took him to the back room and had your way with him. You feel some of your will coming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'jason') { if($ir['money'] <500000) { print "You don't have enough money to hire a Bill!"; } else { db->query("UPDATE users SET will=will+70,energy=0,money=money-500000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed Bill \$500,000, took him to the back room and had your way with him. You feel some of your will coming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'jaq') { if($ir['money'] <1000000) { print "You don't have enough money to hire a Eddy!"; } else { db->query("UPDATE users SET will=will+140,energy=0,money=money-1000000, brothel=brothel+1WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed Eddy \$1,000,000, took him to the back room and had your way with him. You feel some of your will coming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'matt') { if($ir['money'] <5000000) { print "You don't have enough money to hire a Matthew!"; } else { db->query("UPDATE users SET will=will+250,energy=0,money=money-5000000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed a Matthew \$5,000,000, took him to the back room and had your way with him. You feel some of your will comming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'tommy') { if($ir['money'] <1000000) { print "You don't have enough money to hire a Tommy!"; } else { db->query("UPDATE users SET will=will+35,energy=0,money=money-1000000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed a Tommy \$1,000,000, took him to the back room and had your way with him. You feel some of your will comming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'tina') { if($ir['money'] <5000000) { print "You don't have enough money to hire a Tina!"; } else { db->query("UPDATE users SET will=will+70,energy=0,money=money-5000000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed a Tina \$5,000,000, took her to the back room and had your way with her. You feel some of your will comming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'riko') { if($ir['money'] <7000000) { print "You don't have enough money to hire a Riko!"; } else { db->query("UPDATE users SET will=will+140,energy=0,money=money-7000000,brothel=brothel+1 WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed a Riko \$7,000,000, took him to the back room and had your way with him. You feel some of your will comming back to you. [url='index.php']>Home[/url]</center>"; } } else if($_GET['spend'] == 'mich') { if($ir['money'] <10000000) { print "You don't have enough money to hire a Michelle!"; } else { db->query("UPDATE users SET will=will+250,energy=0,money=money-10000000, brothel=brothel+1WHERE userid=$userid",$c); db->query("UPDATE users SET will=maxwill WHERE will > maxwill",$c); print "<center>You payed a Michelle \$10,000,000, took her to the back room and had your way with her. You feel some of your will comming back to you. [url='index.php']>Home[/url]</center>"; } } } $h->endpage(); ?>   db->query("UPDATE users SET brothel=0 WHERE userid=$userid",$c);   ALTER TABLE `users` ADD `brothel` int(11) NOT NULL ;

Re: Total Crime Income FREE   Above v2 is wrong This is v2:   <?php /*----------------------------------------------------- -- Coded By Beardy -- Free Mod -- docrime.php -----------------------------------------------------*/ include "globals.php"; $_GET['c']=abs((int) $_GET['c']); if(!$_GET['c']) { print "Invalid crime"; } else { $q=db->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']; db->query("UPDATE users SET brave={$ir['brave']} WHERE userid=$userid",$c); db->query("UPDATE users SET crimes=crimes+1 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); db->query("UPDATE users SET cincome=cincome+{$r['crimeSUCCESSMUNY']} WHERE userid=$userid",$c); db->query("UPDATE users SET money={$ir['money']}, crystals={$ir['crystals']}, exp={$ir['exp']},crimexp=crimexp+{$r['crimeXP']} WHERE userid=$userid",$c); db->query("UPDATE users SET crimesdone=crimesdone+1 WHERE userid=$userid", $c); if($r['crimeSUCCESSITEM']) { item_add($userid, $r['crimeSUCCESSITEM'], 1); } } else { $j1per=db->query("SELECT conf_value FROM settings WHERE id=19",$c); if(rand(1,100) <= $jj1per['conf_value']) { print $r['crimeFTEXT']; } else { print $r['crimeJTEXT']; db->query("UPDATE `users` SET `jail` = '$r[crimeJAILTIME]', `jail_reason` = '$r[crimeJREASON]' WHERE `userid` = '$userid'"); db->query("UPDATE users SET crimesfailed=crimesfailed+1 WHERE userid=$userid", $c); } } print " [url='docrime.php?c={$_GET[']Try Again[/url] [url='criminal.php']Crimes[/url]"; } } $h->endpage(); ?>

This is linked with: http://criminalexistence.com/ceforums/index.php?topic=18099.0 SQL Query   ALTER TABLE `users` ADD `crimes` INT (11) NOT NULL DEFAULT '0';   In veiwuser.php add   Crimes Done: {$r['crimes']}   In docrime.php add   mysql_query("UPDATE users SET crimes=crimes+1WHERE userid=$userid",$c);