Scarfacial

I just started with php, and I'm teaching myself >_< So it's not too bad I don't think. Thanks everybody for commenting :) I didn't expect anybody would even look at this for over 5 seconds :P

Thanks :)

Alright everybody. This is my first mod I've done, so hopefully it's good :P Basically what I've done with this mod is: I've added a quote to the top of profiles, and a signature to the bottom. Then I've incorporated the BBCode that comes already with the forums into the Profile Signature and Quote. And freely added in, I've done a new staff panel on the bottom of the profiles, but I'm sure it needs some work done as I've just barely finished it to replace the old one I've been using. Alrighty then, lets do this. NOTICE: If you're too lazy to copy and paste, I've attached a .zip file with these files in it. REPLACE viewuser.php with this: [expander] <?php ########################### # PROFILE MOD # # BY # # SCARFACIAL # ########################### # Please keep this notice # ########################### class bbcode { var $engine=""; function bbcode() { require "bbcode_engine.php"; $this->engine= new bbcode_engine; $this->engine->cust_tag("/</","<"); $this->engine->cust_tag("/>/",">"); $this->engine->cust_tag("/\n/","&nbrlb;"); $this->engine->simple_bbcode_tag("b"); $this->engine->simple_bbcode_tag("i"); $this->engine->simple_bbcode_tag("u"); $this->engine->simple_bbcode_tag("s"); $this->engine->simple_bbcode_tag("sub"); $this->engine->simple_bbcode_tag("sup"); $this->engine->simple_bbcode_tag("big"); $this->engine->simple_bbcode_tag("small"); $this->engine->adv_bbcode_tag("list","ul"); $this->engine->adv_bbcode_tag("olist","ol"); $this->engine->adv_bbcode_tag("item","li"); $this->engine->adv_option_tag("font","font","family"); $this->engine->adv_option_tag("size","font","size"); $this->engine->adv_option_tag("url","a","href"); $this->engine->adv_option_tag("color","font","color"); $this->engine->adv_option_tag("style","span","style"); $this->engine->simp_option_notext("img","src"); $this->engine->simp_bbcode_att("img","src"); $this->engine->cust_tag("/\(c\)/","©"); $this->engine->cust_tag("/\(tm\)/","?"); $this->engine->cust_tag("/\(r\)/","®"); $this->engine->adv_option_tag_em("email","a","href"); $this->engine->adv_bbcode_att_em("email","a","href"); $this->engine->cust_tag("/\[left\](.+?)\[\/left\]/","<div align='left'>\\1</div>"); $this->engine->cust_tag("/\[center\](.+?)\[\/center\]/","<div align='center'>\\1</div>"); $this->engine->cust_tag("/\[right\](.+?)\[\/right\]/","<div align='right'>\\1</div>"); $this->engine->cust_tag("/\[quote name='(.+?)\'](.+?)\[\/quote\]/","<div class='quotetop'>QUOTE(\\1)</div><div class='quotemain'>\\2</div>"); $this->engine->cust_tag("/\[quote\](.+?)\[\/quote\]/","<div class='quotetop'>QUOTE</div><div class='quotemain'>\\1</div>"); $this->engine->cust_tag("/\[code\](.+?)\[\/code\]/","<div class='codetop'>CODE</div><div class='codemain'><code>\\1</code></div>"); $this->engine->cust_tag("/\[codebox\](.+?)\[\/codebox\]/","<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'>\\1</div>"); $this->engine->cust_tag("/&nbrlb;/"," \n"); } function bbcode_parse($html) { return $this->engine->parse_bbcode($html); } } function strip_html_tags($text) { return preg_replace("/<(.+?)>/is","", $text); } require "globals.php"; $bbc = new bbcode; if($_POST['column']) { $db->query("UPDATE `users` SET {$_POST['column']}='{$_POST['change']}' WHERE userid='{$_POST['id']}'"); $db->query("INSERT INTO staffcplogs VALUES ('', {$ir['userid']}, {$_POST['id']}, '{$_POST['column']}', unix_timestamp())"); print "Updated! [url='viewuser.php?u={$_POST[']Back[/url]"; } else if($_POST['column2']) { $db->query("UPDATE `userstats` SET {$_POST['column2']}='{$_POST['change']}' WHERE userid='{$_POST['id']}'"); $db->query("INSERT INTO staffcplogs VALUES ('', {$ir['userid']}, {$_POST['id']}, '{$_POST['column']}', unix_timestamp())"); print "Updated! [url='viewuser.php?u={$_POST[']Back[/url]"; } else { $_GET['u'] = abs((int) $_GET['u']); if(!$_GET['u']) { print "Invalid use of file"; } else { $q=$db->query("SELECT u.*,us.*,c.*,h.*,g.*,f.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN cities c ON u.location=c.cityid LEFT JOIN houses h ON u.maxwill=h.hWILL LEFT JOIN gangs g ON g.gangID=u.gang LEFT JOIN fedjail f ON f.fed_userid=u.userid WHERE u.userid={$_GET['u']}"); if($db->num_rows($q) == 0) { print "Sorry, we could not find a user with that ID, check your source."; } else { $r=$db->fetch_row($q); if($r['user_level'] == 1) { $userl="Member"; } else if($r['user_level'] == 2) { $userl="Admin"; } else if ($r['user_level'] == 3) { $userl="Secretary"; } else if($r['user_level'] == 0) { $userl="NPC"; } else {$userl="Assistant"; } $lon=($r['laston'] > 0) ?date('F j, Y g:i:s a',$r['laston']) : "Never"; $sup=date('F j, Y g:i:s a',$r['signedup']); $ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ']; $d=""; if($r['laston'] > 0) { $la=time()-$r['laston']; $unit="seconds"; if($la >= 60) { $la=(int) ($la/60); $unit="minutes"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } $str="$la $unit ago"; } else { $str="--"; } if($r['last_login'] > 0) { $ll=time()-$r['last_login']; $unit2="seconds"; if($ll >= 60) { $ll=(int) ($ll/60); $unit2="minutes"; } if($ll >= 60) { $ll=(int) ($ll/60); $unit2="hours"; if($ll >= 24) { $ll=(int) ($ll/24); $unit2="days"; } } $str2="$ll $unit2 ago"; } else { $str2="--"; } if($r['laston'] >= time()-15*60) { $on="<font color=green>[b]Online[/b]</font>"; } else { $on="<font color=red>[b]Offline[/b]</font>"; } if($r[quote]) {$r[quote] = "$r[quote]";} else {$r[quote] = "I am quoteless!";} print "<table width=100% cellspacing=1 class='table '><tr style='background:gray'> <th colspan='3'>Quote</th> <tr><td colspan='3'><center><font size='3'>[b]User's Quote:[/b] ".$bbc->bbcode_parse($r['quote'])."</font></center></td></tr> <th>General Info</th><th>Financial Info</th> <th>Display Pic</th></tr> <tr><td>Name: $gangcheck [url='viewuser.php?u={$r[']$username[/url] [{$r['userid']}] $d User Level: $userl Duties: {$r['duties']} Gender: {$r['gender']} Signed Up: $sup Last Active: $lon Last Action: $str Last Login: $str2 Online: $on Days Old: {$r['daysold']} Location: {$r['cityname']}</td><td> Money: \${$r['money']} Crystals: {$r['crystals']} Property: {$r['hNAME']} Referals: "; $rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}"); print $db->num_rows($rr); print " Friends: {$r['friend_count']} Enemies: {$r['enemy_count']} </td> <td>"; if($r['display_pic']) { print "[img={$r[]"; } else { print "This user has no display pic!"; } $sh=($ir['user_level'] >1) ? "Staff Info" : ""; print "</td></tr> <tr style='background:gray'><th>Physical Info</th><th>Links</th><th>$sh</th></tr> <tr><td>Level: {$r['level']} Health: {$r['hp']}/{$r['maxhp']} Gang: "; if($r['gang']) { print "[url='gangs.php?action=view&ID={$r[']{$r['gangNAME']}[/url]"; } else { print "N/A"; } if($r['banned']) { print " [b]<font color=red>This user has been banned from the game. {$r['fed_reason']}</font>"; } if($r['fedjail']) { print " [b]<font color=red>This user has been frozen for {$r['fed_days']} day(s). {$r['fed_reason']}</font>"; } if($r['hospital']) { print " [b]<font color=red>In hospital for {$r['hospital']} minutes. {$r['hospreason']}</font>[/b]"; } if($r['jail']) { print " [b]<font color=red>In jail for {$r['jail']} minutes. {$r['jail_reason']}</font>[/b]"; } print "</td><td colspan='2'><table border='0' width='100%'><tr><td width='50%'>[[url='mailbox.php?action=compose&ID={$r[']Send Mail[/url]] [[url='sendcash.php?ID={$r[']Send Cash[/url]] "; if($set['sendcrys_on']) { print "[[url='sendcrys.php?ID={$r[']Send Crystals[/url]] "; } if($set['sendbank_on']) { if($ir['bankmoney'] >= 0 && $r['bankmoney'] >= 0) { print "[[url='sendbank.php?ID={$r[']Bank Xfer[/url]] "; } if($ir['cybermoney'] >= 0 && $r['cybermoney'] >= 0) { print "[[url='sendcyber.php?ID={$r[']CyberBank Xfer[/url]]"; } } print "</td><td width='50%'> [[url='attack.php?ID={$r[']Attack[/url]] [[url='contactlist.php?action=add&ID={$r[']Add Contact[/url]]"; if($ir['donatordays'] > 0) { print " [[url='friendslist.php?action=add&ID={$r[']Add Friends[/url]] [[url='blacklist.php?action=add&ID={$r[']Add Enemies[/url]] "; } if($r['signature']) { $r['signature'] = "{$r['signature']}"; } else { $r['signature'] = "This user has no signature!"; } print "</td></tr></table> <tr><th colspan='3'>Signature</th></tr> <tr><td colspan='3' class='profilesig'>".$bbc->bbcode_parse($r['signature'])."</td></tr></table>"; ################################################ # STAFF AREA STARTS # ################################################ if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { { $r['lastiph']=@gethostbyaddr($r['lastip']); $r['lastiph']=checkblank($r['lastiph']); $r['lastip_loginh']=@gethostbyaddr($r['lastip_login']); $r['lastip_loginh']=checkblank($r['lastip_loginh']); $r['lastip_signuph']=@gethostbyaddr($r['lastip_signup']); $r['lastip_signuph']=checkblank($r['lastip_signuph']); if($ir['staff_rules'] != 1) { print " <a href=staffrules.php>Click here to read the staff rules</a>"; } else if($ir['staff_punish']) { print " Your staff powers have temporarily been removed. Reason: {$ir['punish_reason']}"; } else { $user_levels=array( "0" => "NPC", "1" => "Regular Player", "2" => "Admin", "3" => "Secretary", "4" => "Assistant" ); print " <h3>Staff Panel</h3> <table width='100%' cellspacing='20'><tr><td> <table width='100%' border='0px' cellspacing='1' class='table'> <tr><td></td><td class='h'>IP</td><td class='h'>Hostname</td></tr> <tr><td class='h'>Last Hit</td><td>$r[lastip]</td><td>$r[lastiph]</td></tr> <tr><td class='h'>Last Login</td><td>$r[lastip_login]</td><td>$r[lastip_loginh]</td></tr> <tr><td class='h'>Signup</td><td>$r[lastip_signup]</td><td>$r[lastip_signuph]</td></tr></table> </td><td> Staff Notes: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='staffnotes' /> <input type='hidden' name='id' value='{$r['userid']}' /> <textarea rows='7' cols='50' name='change'>{$r['staffnotes']}</textarea> <input type='submit' value='Change' /> </form> </td></tr></table> <table width='100%' cellspacing='20'> <tr><td width=33%> Username: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='username' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['username']}' /> <input type='submit' value='Change' /> </form> </td><td width=33%> User Level: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='user_level' /> <input type='hidden' name='id' value='{$r['userid']}' /> <select name='change' type='dropdown'>"; foreach($user_levels as $k => $v) { if($k == $set['validate_period']) { print "<option value='{$k}' selected='selected'>{$v}</option>"; } else { print "<option value='{$k}'>{$v}</option>"; } } print " <input type='submit' value='Change' /> </form> </td><td width=33%> Donator days: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='donatordays' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['donatordays']}' /> <input type='submit' value='Change' /> </form> </td></tr> <tr> <td> Duties: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='duties' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['duties']}' /> <input type='submit' value='Change' /> </form> </td> <td> Level: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='level' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['level']}' /> <input type='submit' value='Change' /> </form> </td> <td> Exp: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='exp' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['exp']}' /> <input type='submit' value='Change' /> </form> </td> </tr> <tr> <td> Money: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='money' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['money']}' /> <input type='submit' value='Change' /> </form> </td> <td> Bank Money: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='bankmoney' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['bankmoney']}' /> <input type='submit' value='Change' /> </form> </td> <td> Crystals: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='crystals' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['crystals']}' /> <input type='submit' value='Change' /> </form> </td> </tr> <tr> <td> Jail Time: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='jail' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['jail']}' /> <input type='submit' value='Change' /> </form> </td> <td> Hospital Time: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='hospital' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['hospital']}' /> <input type='submit' value='Change' /> </form> </td> <td> Jail Reason: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='jail_reason' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['jail_reason']}' /> <input type='submit' value='Change' /> </form> </td> </tr> <tr> <td> Hospital Reason: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='hospreason' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['hospreason']}' /> <input type='submit' value='Change' /> </form> </td> <td> Energy: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='energy' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['maxenergy']}' /> <input type='submit' value='Change' /> </form> </td> <td> Will: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='will' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['maxwill']}' /> <input type='submit' value='Change' /> </form> </td> </tr> <tr> <td> Brave: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='brave' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['maxbrave']}' /> <input type='submit' value='Change' /> </form> </td> <td> Hit Points: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='hp' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['maxhp']}' /> <input type='submit' value='Change' /> </form> </td> <td> Strength: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column2' value='strength' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['strength']}' /> <input type='submit' value='Change' /> </form> </td> </tr> <tr> <td> Agility: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column2' value='agility' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['agility']}' /> <input type='submit' value='Change' /> </form> </td> <td> Guard: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column2' value='guard' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['guard']}' /> <input type='submit' value='Change' /> </form> </td> <td> IQ: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column2' value='IQ' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['IQ']}' /> <input type='submit' value='Change' /> </form> </td> </tr> <tr> <td colspan='3'> <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column2' value='display_pic' /> <input type='hidden' name='id' value='{$r['userid']}' /> <input type='text' name='change' value='{$r['display_pic']}' /> <input type='submit' value='Change' /> </form> </td> </tr> </table> <table width='100%' cellspacing='20'> <tr><td width=50%> Quote: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='quote' /> <input type='hidden' name='id' value='{$r['userid']}' /> <textarea rows='7' cols='50' name='change'>{$r['quote']}</textarea> <input type='submit' value='Change' /> </form> </td><td width=50%> Signature: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='signature' /> <input type='hidden' name='id' value='{$r['userid']}' /> <textarea rows='7' cols='50' name='change'>{$r['signature']}</textarea> <input type='submit' value='Change' /> </form> </td></tr><tr><td colspan='2'> Forum Signature: <form action='viewuser.php?u={$ir['userid']}' method='post'> <input type='hidden' name='column' value='forums_signature' /> <input type='hidden' name='id' value='{$r['userid']}' /> <textarea rows='7' cols='50' name='change'>{$r['forums_signature']}</textarea> <input type='submit' value='Change' /> </form> </td></tr></table>"; $q=$db->query("SELECT * FROM staffcplogs WHERE userid={$r['userid']} ORDER BY time DESC;"); print " <table width=75% cellspacing=1 class=table> <tr style='background:gray;'> <td class='h' align=center>Staff Member ID</td> <td class='h' align=center>Changed</td> <td class='h' align=center>Time</td> </tr>"; while($r=$db->fetch_row($q)) { print " <tr> <td>{$r['staffid']}</td> <td>{$r['changed']}</td> <td>".date('F j Y, g:i:s a',$r['time'])."</td> <tr> </table>"; } } } } print ""; } } } function checkblank($in) { if(!$in) { return "N/A"; } return $in; } $h->endpage(); ?> [/expander] REPLACE preferences with this: [expander] <?php ########################### # PROFILE MOD # # BY # # SCARFACIAL # ########################### # Please keep this notice # ########################### include "globals.php"; switch($_GET['do']) { case 'gender': sex_change(); break; case 'passchange': pass_change(); break; case 'passsubmit': submit_pass(); break; case 'submit': submit_all(); break; default: index(); break; } function sex_change() { global $db,$ir,$c,$userid,$h; if($ir['gender'] == "Male") { $ng="Female"; $g="Male"; } else { $ng="Male"; $g="Female"; } $db->query("UPDATE users SET gender='$ng' WHERE userid=$userid"); print "Success, you are now $ng! [url='preferences.php']Back[/url]"; } function pass_change() { global $ir,$c,$userid,$h; print "<h3>Password Change</h3> <form action='preferences.php?do=passsubmit' method='post'> Current Password: <input type='password' name='oldpw' /> New Password: <input type='password' name='newpw' /> Confirm: <input type='password' name='newpw2' /> <input type='submit' value='Change Password' /></form>"; } function submit_pass() { global $db,$ir,$c,$userid,$h; if(md5($_POST['oldpw']) != $ir['userpass']) { print "The current password you entered was wrong. [url='preferences.php?do=passchange']> Back[/url]"; } else if($_POST['newpw'] !== $_POST['newpw2']) { print "The new passwords you entered did not match! [url='preferences.php?do=passchange']> Back[/url]"; } else { $db->query("UPDATE users SET userpass=md5('{$_POST['newpw']}') WHERE userid=$userid"); print "Password changed! [url='preferences.php']Back[/url]"; } } function submit_all() { global $db,$ir,$c,$userid,$h; $db->query("UPDATE users SET username='{$_POST['username']}' WHERE userid=$userid"); $db->query("UPDATE users SET display_pic='{$_POST['display_pic']}' WHERE userid=$userid"); $db->query("UPDATE users SET user_quote='{$_POST['quote']}' WHERE userid=$userid"); $db->query("UPDATE users SET signature='{$_POST['sig']}' WHERE userid=$userid"); $db->query("UPDATE users SET forums_signature='{$_POST['forum_sig']}' WHERE userid=$userid"); print "Preferences updated! [url='preferences.php']Back[/url]"; } function index() { global $db,$ir,$c,$userid,$h; if($ir['gender'] == "Male") { $ng="Female"; $g="Male"; } else { $ng="Male"; $g="Female"; } if($ir[display_pic]) {$display_pic = "$ir[display_pic]";} else {$display_pic = "images/no-avatar.png";} if($ir[user_quote]) {$quote = "$ir[user_quote]";} else {$quote = "I am quoteless!";} if($ir[forums_signature]) {$forumsig = "$ir[forums_signature]";} else {$forumsig = "No Signature";} print "<h3>Preferences</h3> You are a $g. Would you like to switch to a $ng? [url='preferences.php?do=gender'][ Yes[/url] | [url='#']No[/url] ] [[url='preferences.php?do=passchange']Password Change[/url]] <form action='preferences.php?do=submit' method='post'><table> <tr><td>Username:</td><td><input type='text' name='username' value='$ir[username]'/></td></tr> <tr><td>Avatar</td><td><input type='text' name='display_pic' value='$display_pic'/></td></tr> <tr><td colspan='2'>Quote</td></tr><tr><td colspan='2'><textarea rows=3 cols=40 name='quote'>$quote</textarea></td></tr> <tr><td colspan='2'>Profile Signature</td></tr><tr><td colspan='2'><textarea rows=3 cols=40 name='sig'>{$ir['signature']}</textarea></td></tr> <tr><td colspan='2'>Forum Signature</td></tr><tr><td colspan='2'><textarea rows=3 cols=40 name='forum_sig'>$forumsig</textarea></td></tr> </table> <input type='submit' value='Update' /></form>"; } $h->endpage(); ?> [/expander] And last but not least, SQL this into the database: [expander][mysql]CREATE TABLE IF NOT EXISTS `staffcplogs` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT, `staffid` int(11) NOT NULL DEFAULT '0', `userid` int(11) NOT NULL DEFAULT '0', `changed` VARCHAR( 250 ) NOT NULL DEFAULT '0', `time` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ALTER TABLE `users` ADD `quote` TEXT NOT NULL; ALTER TABLE `users` ADD `signature` TEXT NOT NULL;[/mysql][/expander] As far as I know, this mod works. It may not be the best though as I had to try to convert it into the original profiles from MCCodes V2. Thanks for looking at my first mod, have fun, and good luck with your MCCodes game. :)

What exactly would the different races do?