peterisgb

that sucks, well i'll have to leave it to you anyway, i've tried loads of ideas, the only one i got to work was include "globals.php" which is ovious lol.

thanks lord master :)

well the iframe is in header.php the iframe auto opens playerinfo.php which is the page i just posted,

tho this repeats the same name etc all the way down the page :'(

here you go.   <?php include "config.php"; global $db,$c,$ir,$set,$_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } define("MONO_ON", 1); require "class/class_db_{$_CONFIG['driver']}.php"; $db=new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c=$db->connection_id; $set=array(); $settq=$db->query("SELECT * FROM settings"); while($r=$db->fetch_row($settq)) { $set[$r['conf_name']]=$r['conf_value']; print " <a id='button1a'><b>Player Info</b><br /></a> <a id='button1a' href='usersonline.php'><b>Name:</b> $gn{$u} [{$ir['userid']}] $d $staff <br /></a> <a id='button1a' href='gym.php'><b>Level:</b> {$ir['level']}<br /></a> <a id='button1a' href='bank.php'><b>Money:</b> {$fm}<br /></a> <a id='button1a' href='bank.php'><b>Bank Money:</b> {$ir['bankmoney']}<br /></a> <a id='button1a' href='cyberbank.php'><b>Cyber Money:</b> {$ir['cybermoney']}<br /></a> <a id='button1a' href='creditcard.php'><b>Credit Card:</b> {$ir['creditcard']}<br/></a> <a id='button1a' href='crystaltemple.php'><b>Crystals:</b> {$ir['crystals']}<br /></a> <a id='button1a' href='cigarettes.php'><b>Smoking Level:</b> {$ir['smoking']}<br /></a> <a id='button1a' href='cigarettes.php'><b>Smoker:</b> $smoke<br /></a> <a id='button1a' href='logout.php'><font color='white'>[</font><font color='red'>Emergency Logout</font><font color='white'>]</font></a> "; } ?>

i tried i tried the crons login code yesterday and it didnt work :( global $db,$c,$ir, $set;

yup, shame the links not here no more, wanted to have a look :(

I've been working on a game, on the mccodes header you get the info from Username and ID down to the last stats bar aka health bar, on the header i i placed an Iframe, in that iframe the Player stats, I cant figure out the love of god how to get the Iframe page to actually load the Database stuff, any help here would be good, what code would i need to put to get this to work? Thanks

For Users who dont see this code Correctly Here is the missing code if ($i['itmid'] == ITEMIDHERE) { print " [<a href=dpuse8.php?ID={$i['inv_id]}'>Use</a>]"; }

  updating this bbcode crap has messed up the site, now i see why nearly all the users left......

UPDATED ORIGINAL

anyone got the link for the v2 edition yet? or hasnt this been completed

yup,   < a href='updatevote.php'>Update Vote Ranks</a><br />   you can use the ones the site provides but i dont like them myself.

ok, not alot of sites offer javascirpt to display there ranks, so i made this so Vote Ranks can be updated from the staff Panel. I havent secured this, if you decide to secure it then post it here, thanks voting.php <?php //######################################### //##### Voting.php Made by Peterisgb ##### //######################################### include "globals.php"; print "<h3>Voting</h3> Here you may vote for {$set['game_name']} at various RPG toplists and be rewarded.<br /><br /> <table border='1'><td> <hr /> <a href='voteapex.php' target='_blank'><b>Vote at APEX </a><br /><hr /> <b>Rank:</b> <font color='green'><b> {$set['rpgrank1']} </b></font><br /><hr /> <font color='red'><b>Voted Today? </b></font> "; $q=$db->query("SELECT * FROM votes WHERE userid=$userid AND list='apex'"); if($db->num_rows($q)) { print "<font color='green'>Yes</font>"; } else { print "<font color='red'>No</font>"; } print "<br /><hr /><font color='yellow'><b>(Reward: \$30,000 & 100 Crystals)</font></b><br /> </td> <td> <hr /> <a href='votetwg.php' target='_blank'><b>Vote at TWG </a><br /><hr /> <b>Rank: </b><font color='green'><b> {$set['rpgrank2']} </b></font><br /><hr /> <font color='red'><b>Voted Today? </b></font> "; $q=$db->query("SELECT * FROM votes WHERE userid=$userid AND list='twg'"); if($db->num_rows($q)) { print "<font color='green'>Yes</font>"; } else { print "<font color='red'>No</font>"; } print "<br /><hr /><font color='yellow'>(Reward: \$30,000 & 100 Crystals)</font></b><br /> </td> <td> <hr /> <a href='votetrpg.php' target='_blank'><b>Vote at TOPRPG </a><br /><hr /> <b>Rank: </b><font color='green'><b> {$set['rpgrank3']} </b></font><br /><hr /> <font color='red'><b>Voted Today? </b></font> "; $q=$db->query("SELECT * FROM votes WHERE userid=$userid AND list='trpg'"); if($db->num_rows($q)) { print "<font color='green'>Yes</font>"; } else { print "<font color='red'>No</font>"; } print "<br /><hr /><font color='yellow'>(Reward: \$30,000 & 100 Crystals)</font></b><br /> </td> </tr> <tr> <td> <hr /> <a href='voteag.php' target='_blank'><b>Vote at MMORPG </a><br /><hr /> <b>Rank: </b><font color='green'><b> {$set['rpgrank4']} </b></font><br /><hr /> <font color='red'><b>Voted Today? </b></font> "; $q=$db->query("SELECT * FROM votes WHERE userid=$userid AND list='mmorpg'"); if($db->num_rows($q)) { print "<font color='green'>Yes</font>"; } else { print "<font color='red'>No</font>"; } print "<br /><hr /><font color='yellow'>(Reward: \$30,000 & 100 Crystals)</font></b><br /> </td> <td> <hr /> <a href='voteaga.php' target='_blank'><b>Vote at MMORPG 100</a><br /><hr /> <b>Rank: </b><font color='green'><b> {$set['rpgrank5']} </b></font><br /><hr /> <font color='red'><b>Voted Today? </b></font> "; $q=$db->query("SELECT * FROM votes WHERE userid=$userid AND list='mmorpg100'"); if($db->num_rows($q)) { print "<font color='green'>Yes</font>"; } else { print "<font color='red'>No</font>"; } print "<br /><hr /><font color='yellow'>(Reward: \$30,000 & 100 Crystals)</font></b><br /> </td> <td> <hr /> <a href='votempog.php' target='_blank'><b>Vote at MPOG 100</a><br /><hr /> <b>Rank: </b><font color='green'><b> {$set['rpgrank6']} </b></font><br /><hr /> <font color='red'><b>Voted Today? </b></font> "; $q=$db->query("SELECT * FROM votes WHERE userid=$userid AND list='mpog100'"); if($db->num_rows($q)) { print "<font color='green'>Yes</font>"; } else { print "<font color='red'>No</font>"; } print "<br /><hr /><font color='yellow'>(Reward: \$30,000 & 100 Crystals)</font></b><br /> </td></table> <hr /> "; $h->endpage(); ?> updatevote.php <?php include "sglobals.php"; switch($_GET['action']) { case 'namechange2': do_name_change(); break; case 'namechange': name_change(); break; case 'name1change2': do_name1_change(); break; case 'name1change': name1_change(); break; case 'name2change2': do_name2_change(); break; case 'name2change': name2_change(); break; case 'name3change2': do_name3_change(); break; case 'name3change': name3_change(); break; case 'name4change2': do_name4_change(); break; case 'name4change': name4_change(); break; default: prefs_home(); break; } function prefs_home() { global $db,$ir,$c,$userid,$h; print "<h3>Update Voting Site Ranks</h3> <a href='updatevote.php?action=namechange'>APEX</a><br /> <a href='updatevote.php?action=name1change'>TWG</a><br /> <a href='updatevote.php?action=name2change'>TOPRPG</a><br /> <a href='updatevote.php?action=name3change'>MMORPG</a><br /> "; } function name_change() { global $ir,$c,$userid,$set,$h; print "<h3>Apex</h3> <form action='updatevote.php?action=namechange2' method='post'> Apex Rank: <input type='text' name='newname' value='{$set['rpgrank1']}' /><br /> <input type='submit' value='Change Rank' /></form>"; } function do_name_change() { global $db,$ir,$c,$userid,$h; if($_POST['newname'] == "") { print "You did not enter a new rank.<br /> <a href='updatevote.php?action=namechange'>> Back</a>"; } else { $_POST['newname']=str_replace(array("<", ">", "\\\'"), array("<", ">", "'"), $_POST['newname']); $db->query("UPDATE settings SET conf_value='{$_POST['newname']}' WHERE conf_name='rpgrank1'"); print "Vote Rank Updated!<br /><a href='updatevote.php'>> Back</a> "; } } function name1_change() { global $ir,$c,$userid,$set,$h; print "<h3>TWG</h3> <form action='updatevote.php?action=name1change2' method='post'> TWG Rank: <input type='text' name='newname' value='{$set['rpgrank2']}' /><br /> <input type='submit' value='Change Rank' /></form>"; } function do_name1_change() { global $db,$ir,$c,$userid,$h; if($_POST['newname'] == "") { print "You did not enter a new rank.<br /> <a href='updatevote.php?action=name1change'>> Back</a>"; } else { $_POST['newname']=str_replace(array("<", ">", "\\\'"), array("<", ">", "'"), $_POST['newname']); $db->query("UPDATE settings SET conf_value='{$_POST['newname']}' WHERE conf_name='rpgrank2'"); print "Vote Rank Updated!<br /><a href='updatevote.php'>> Back</a>"; } } function name2_change() { global $ir,$c,$userid,$set,$h; print "<h3>TOPRPG</h3> <form action='updatevote.php?action=name2change2' method='post'> TOPRPG Rank: <input type='text' name='newname' value='{$set['rpgrank3']}' /><br /> <input type='submit' value='Change Rank' /></form>"; } function do_name2_change() { global $db,$ir,$c,$userid,$h; if($_POST['newname'] == "") { print "You did not enter a new rank.<br /> <a href='updatevote.php?action=name2change'>> Back</a>"; } else { $_POST['newname']=str_replace(array("<", ">", "\\\'"), array("<", ">", "'"), $_POST['newname']); $db->query("UPDATE settings SET conf_value='{$_POST['newname']}' WHERE conf_name='rpgrank3'"); print "Vote Rank Updated!<br /><a href='updatevote.php'>> Back</a>"; } } function name3_change() { global $ir,$c,$userid,$set,$h; print "<h3>MMORPG</h3> <form action='updatevote.php?action=name3change2' method='post'> MMORPG Rank: <input type='text' name='newname' value='{$set['rpgrank4']}' /><br /> <input type='submit' value='Change Rank' /></form>"; } function do_name3_change() { global $db,$ir,$c,$userid,$h; if($_POST['newname'] == "") { print "You did not enter a new rank.<br /> <a href='updatevote.php?action=name3change'>> Back</a>"; } else { $_POST['newname']=str_replace(array("<", ">", "\\\'"), array("<", ">", "'"), $_POST['newname']); $db->query("UPDATE settings SET conf_value='{$_POST['newname']}' WHERE conf_name='rpgrank4'"); print "Vote Rank Updated!<br /><a href='updatevote.php'>> Back</a>"; } } $h->endpage(); ?> SQL -- Table structure for table `settings` -- CREATE TABLE `settings` ( `conf_id` int(11) NOT NULL AUTO_INCREMENT, `conf_name` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '', `conf_value` text COLLATE latin1_general_ci NOT NULL, PRIMARY KEY (`conf_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=54 ; -- -- Dumping data for table `settings` -- INSERT INTO `settings` VALUES(17, 'rpgrank2', '1st'); INSERT INTO `settings` VALUES(18, 'rpgrank4', '1st'); INSERT INTO `settings` VALUES(19, 'rpgrank1', '1st'); INSERT INTO `settings` VALUES(20, 'rpgrank3', '1st');

this is good, on your filedata on a few lines down its is default to $file = 'preferences.php'; is tehre a way to create a new page and to be able to choose the file you want to edit instead of a preslected one, the idea of this mod is to make life easier but i still have to go into the file manager to be able to select which page to edit.

cool, of course i had to tweak it, looking at yours i can now see why it wasnt working lol i like the actions you added in, i didnt think of that lol, for others to add other useful links, find   <small>[<a href='viewuser.php?u={$r['userid']}'>View</a>]   add underneath   [<a href='attack.php?ID={$r['userid']}'>Attack</a>] [<a href='mailbox.php?action=compose&ID={$r['userid']}'>Mail</a>] Thanks :)

removed source

Hi, i'm working on this code and i cant seem to get it to work right, it displays all the images for all the users instead of the selected images for certain, can anyone help me. Lines - 89 - 106   <?php require "globals.php"; if ($_GET['time']) { $time=$_GET['time']; } else { $time=60; } $cn=0; $lk=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-1440*60"); $aa=mysql_num_rows($lk); $ll=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-60*60"); $ab=mysql_num_rows($ll); $lm=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-45*60"); $ac=mysql_num_rows($lm); $ln=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-30*60"); $ad=mysql_num_rows($ln); $lo=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-15*60"); $ae=mysql_num_rows($lo); $he=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-1*60"); $hu=mysql_num_rows($he); $q=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-{$time}*60 ORDER BY laston DESC"); ?> <table border="0" class=table width="100%" cellpading="0" cellspacing="0"> <tr> <td class=table> <h3>Time Selecter</h3> <a href='usersonline.php?time=1'>(1 Min)</a><br /> <a href='usersonline.php?time=15'>(15 Mins)</a><br /> <a href='usersonline.php?time=30'>(30 Mins)</a><br /> <a href='usersonline.php?time=45'>(45 Mins)</a><br /> <a href='usersonline.php?time=60'">(60 Mins)</a><br /> <a href='usersonline.php?time=1440'>(24 Hours)</a><br /> </td> <td class=table> <h3>Statistics</h3> Users online in the last minute: <?php print"{$hu}"; ?><br /> Users online in the last 15 minutes: <?php print"{$ae}"; ?><br /> Users online in the last 30 minutes: <?php print"{$ad}"; ?><br /> Users online in the last 45 minutes: <?php print"{$ac}"; ?><br /> Users online in the last hour: <?php print"{$ab}"; ?><br /> Users online in the last 24 hours: <?php print"{$aa}"; ?><br /> </td> <tr> </table> <table border="0" class=table width="100%" cellpading="0" cellspacing="0"> <tr> <td class=table> <h3></h3> </td> <td class=table> <h3>Gang Tag</h3> </td> <td class=table> <h3><center>User</center></h3> </td> <td class=table> <h3>Last Action</h3> </td> <td class=table> <h3>Time Online</h3> </td> </tr> <?php while($r=mysql_fetch_assoc($q)) { $la=time()-$r['laston']; $unit="secs"; if($la >= 60) { $la=(int) ($la/60); $unit="mins"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } $cn++; $name=$r['username']; $gangtag=$r['yourgangPREF']; if($r['donatordays']) { $donator="VIP:<img src='donator.gif' alt='Donator: {$r['donatordays']} Days Left' title='Donator: {$r['donatordays']} Days Left' />"; } if($r['user_level']==2) { $staff="Staff: <img src='images/admin.gif' alt='Game Staff' />"; } if($r['userid']==1) { $owner=" <img src='images/owner.gif' alt='Game Owner' />"; } $r['username']="<b>$staff $owner $donator<a href='viewuser.php?u={$r['userid']}'><font color='{$r['colour']}'> $name</b></font></a>"; print "<tr> <td class=table> $cn. </td> <td class=table> <a href='gangs.php?action=view&ID={$r['gang']}'>$gangtag</a> </td> <td class=table> {$r['username']} </td> <td class=table> ($la $unit) </td> <td class=table>"; $lb=time()-$r['last_login']; $units="secs"; if($lb >= 60) { $lb=(int) ($lb/60); $units="mins"; } if($lb >= 60) { $lb=(int) ($lb/60); $units="hours"; if($lb >= 24) { $lb=(int) ($lb/24); $units="days"; } } if($r['laston'] <= time()-60*60) { $lb="offline"; $unit=""; } print "{$lb} {$units}</td></tr>"; } ?> </td> </tr> </table> <?php $h->endpage(); ?>

the change gender dont work either... i cant change gender either so there must be something wrong on the page. i cant find it at all i'll post the whole page to see if this helps.   <?php include "globals.php"; switch($_GET['action']) { case 'colchange2': do_col_change(); break; case 'colchange': col_change(); break; case 'sexchange2': do_sex_change(); break; case 'sexchange': conf_sex_change(); break; case 'racechange2': do_race_change(); break; case 'racechange': conf_race_change(); break; case 'passchange2': do_pass_change(); break; case 'passchange': pass_change(); break; case 'namechange2': do_name_change(); break; case 'namechange': name_change(); break; case 'namegchange2': do_nameg_change(); break; case 'namegchange': nameg_change(); break; case 'picchange2': do_pic_change(); break; case 'picchange': pic_change(); break; case 'signaturechange2': do_signature_change(); break; case 'signaturechange': signature_change(); break; case 'forumchange2': do_forum_change(); break; case 'forumchange': forum_change(); break; default: prefs_home(); break; } function prefs_home() { global $db,$ir,$c,$userid,$h; print "<h3>Preferences</h3> <a href='preferences.php?action=sexchange'>Sex Change</a><br /> <a href='preferences.php?action=passchange'>Password Change</a><br /> <a href='preferences.php?action=namechange'>Name Change</a><br /> <a href='preferences.php?action=namegchange'>Gang Tag Change</a><br /> <a href='preferences.php?action=racechange'>Race Change</a><br /> <a href='preferences.php?action=picchange'>Display Pic Change</a><br /> <a href='preferences.php?action=forumchange'>Forum Info Change</a><br /> <a href='preferences.php?action=signaturechange'>Sig Change</a><br /> <a href='preferences.php?action=colchange'>Change Chat Room Font colour</a><br /> <hr /> "; } function signature_change() { global $ir,$c,$userid,$h; print "<h3>Profile Signature Change</h3> <form action='preferences.php?action=signaturechange2' method='post'> New Profile Signature: <textarea rows=30 cols=90 name='newsignature' wrap='virtual' class='input'>{$ir['profileSIG']}</textarea> <input type='submit' value='Change Signature' /></form> <small>> </small><a href='preferences.php'>Back</a>"; } function do_signature_change() { global $db,$ir,$c,$userid,$h; if($_POST['newsignature'] == "") { print "You did not enter a new profile signature. <small>> </small><a href='preferences.php?action=signaturechange'>Back </a>"; } else { $db->query("UPDATE users SET profileSIG='{$_POST['newsignature']}' WHERE userid=$userid"); print "Profile Signature changed! <small>> </small><a href='preferences.php'>Back</a>"; } } function conf_sex_change() { global $ir,$c,$userid,$h; if($ir['gender'] == "Male") { $g="Female"; } else { $g="Male"; } print "Are you sure you want to become a $g? <a href='preferences.php?action=sexchange2'>Yes</a> | <a href='preferences.php'>No</a>"; } function do_sex_change() { global $db,$ir,$c,$userid,$h; if($ir['gender'] == "Male") { $g="Female"; } else { $g="Male"; } $db->query("UPDATE users SET gender='$g' WHERE userid=$userid"); print "Success, you are now $g! <a href='preferences.php'>Back</a>"; } function pass_change() { global $ir,$c,$userid,$h; print "<h3>Password Change</h3><form action='preferences.php?action=passchange2' method='post'>Current Password: <input type='password' name='oldpw' /><br /> New Password: <input type='password' name='newpw' /><br /> Confirm: <input type='password' name='newpw2' /><br /> <input type='submit' value='Change PW' /></form>"; } function do_pass_change() { global $db,$ir,$c,$userid,$h; if(md5($_POST['oldpw']) != $ir['userpass']) { print "The current password you entered was wrong. <a href='preferences.php?action=passchange'>> Back</a>"; } else if($_POST['newpw'] !== $_POST['newpw2']) { print "The new passwords you entered did not match! <a href='preferences.php?action=passchange'>> Back</a>"; } else { $db->query("UPDATE users SET userpass=md5('{$_POST['newpw']}') WHERE userid=$userid"); print "Password changed!"; } } function name_change() { global $ir,$c,$userid,$h; print "<h3>Name Change</h3> Please note that you still use the same name to login, this procedure simply changes the name that is displayed. <form action='preferences.php?action=namechange2' method='post'> New Name: <input type='text' name='newname' /> <input type='submit' value='Change Name' /></form>"; } function do_name_change() { global $db,$ir,$c,$userid,$h; if($_POST['newname'] == "") { print "You did not enter a new name. <a href='preferences.php?action=namechange'>> Back</a>"; } else { $_POST['newname']=str_replace(array("<", ">", "\\\'"), array("<", ">", "'"), $_POST['newname']); $db->query("UPDATE users SET username='{$_POST['newname']}' WHERE userid=$userid"); print "Username changed!"; } } function nameg_change() { global $ir,$c,$userid,$h; print "<h3>Gang Tag Change</h3> <form action='preferences.php?action=namegchange2' method='post'> New Tag: <input type='text' name='newnameg' /><br /> <input type='submit' value='Change Tag' /></form>"; } function do_nameg_change() { global $db,$ir,$c,$userid,$h; if($_POST['newnameg'] == "") { print "You did not enter a new name.<br /> <a href='preferences.php?action=namechange'>> Back</a>"; } else { global $db,$ir,$c,$userid,$h; $db->query("UPDATE users SET yourgangPREF='{$_POST['newnameg']}' WHERE userid=$userid"); print "Tag changed!"; } } function conf_race_change() { global $ir,$c,$userid,$h; print "<center><hr width='20%'>Race Change<hr width='20%'><br /> Mail Admins to select your race untill this is fixed, thanks <br /> <form action='preferences.php?action=racechange2' method='post'> <select class=textbox name='race'> <option value='Wizard'>Wizard</option> <option value='Unknown'>Unknown</option> <option value='Ware Wolf'>Ware Wolf</option> <option value='Vampire'>Vampire</option> <option value='Yeti'>Yeti</option> <option value='Elf'>Elf</option> <option value='Zombie'>Zombie</option> <option value='Beast'>Beast</option> <option value='Dwarf'>Dwarf</option> <option value='Gangsta'>Gangsta</option> <option value='Criminal'>Criminal</option> <option value='Pimp'>Pimp</option> <option value='Member'>Member</option> <option value='God'>God</option> <option value='Pilot'>Pilot</option> <option value='Boxer'>Boxer</option> <option value='Chief'>Chief</option> <option value='Cop'>Cop</option> <option value='Creature'>Creature</option> <option value='Seller'>Seller</option> <option value='Buyer'>Buyer</option> <option value='Goth'>Goth</option> <option value='Thief'>Thief</option> <option value='Hacker'>Hacker</option> <option value='Skeleton'>Skeleton</option> <option value='Demon'>Demon</option> <option value='Goblin'>Goblin</option> <option value='Unknown' SELECTED>Unknown</option> </Select> <input class='textbox' type='submit' value='Change Race' /> </form>"; } function do_race_change() { global $db,$ir,$c,$userid,$h; $db->query("UPDATE users SET race='{$_POST['race']}' WHERE userid=$userid"); print "You Have Changed your Race Type! <a href='preferences.php'>Back</a>"; } function pic_change() { global $ir,$c,$userid,$h; print "<h3>Pic Change</h3> Please note that this must be externally hosted, <a href='http://imageshack.us'>ImageShack</a> is our recommendation. Any images that are not 150x150 will be automatically resized <form action='preferences.php?action=picchange2' method='post'> New Pic: <input type='text' name='newpic' value='{$ir['display_pic']}' /> <input type='submit' value='Change Name' /></form>"; } function do_pic_change() { global $db,$ir,$c,$userid,$h; if($_POST['newpic'] == "") { print "You did not enter a new pic. <a href='preferences.php?action=picchange'>> Back</a>"; } else { $_POST['newpic']=str_replace('\\\'',''', $_POST['newpic']); $db->query("UPDATE users SET display_pic='{$_POST['newpic']}' WHERE userid=$userid"); print "Pic changed!"; } } function forum_change() { global $ir,$c,$userid,$h; print "<h3>Forum Info Change</h3> Please note that the avatar must be externally hosted, <a href='http://imageshack.us'>ImageShack</a> is our recommendation. Any avatars that are not 100x100 will be automatically resized <form action='preferences.php?action=forumchange2' method='post'> Avatar: <input type='text' name='forums_avatar' value='{$ir['forums_avatar']}' /> Signature (you may use BBcode): <textarea rows=10 cols=50 name='forums_signature'>{$ir['forums_signature']}</textarea> <input type='submit' value='Change Info' /></form>"; } function do_forum_change() { global $db,$ir,$c,$userid,$h; $_POST['forums_avatar']=str_replace(array("<", ">"), array("<", ">"), $_POST['forums_avatar']); $db->query("UPDATE users SET forums_avatar='{$_POST['forums_avatar']}', forums_signature='{$_POST['forums_signature']}' WHERE userid=$userid"); print "Forum Info changed!"; } function col_change() { global $ir,$c,$userid,$h; print "<h3>Change chat font colour</h3> <form action='preferences.php?action=colchange2' method='post'> Chat Colour: <input type='text' name='colour' value='{$ir['colour']}' /> <input type='submit' value='Change font colour' /></form>"; } function do_col_change() { global $db,$ir,$c,$userid,$h; $db->query("UPDATE users SET colour='{$_POST['colour']}', colour='{$_POST['colour']}' WHERE userid=$userid"); print "colour changed!"; } $h->endpage(); ?>   i just tested the db query on posting the race to the database and that code does work, do it has to be the page somewhere.... :'(

nice code but nope Parse error: syntax error, unexpected T_STRING in /home/a6998742/public_html/game/preferences.php on line 248

erm, line 62/63 in the first post, chat.php, its wrong can anyone help fix this please, thanks looking thro it, there might be abit more wrong with this,

so can anyone see the problem here?

Hi, below is the race mod, i dunno whats wrong with it, i just cant figure it out, can anyone help, It shows that its done it but when i go and check it dont to have seemed to have posted it into the database, Its probs something so simple but i cant see it, thanks. ------------------------------------------------------------------------------------------------------------------------------------------------- case 'racechange2': do_race_change(); break; case 'racechange': conf_race_change(); break; ------------------------------------------------------------------------------------------------------------------------------------------------- function conf_race_change() { global $ir,$c,$userid,$h; print "<center>Race Change<br /> <form action='preferences.php?action=racechange2' method='post'> <select class='textbox' name='myrace'> <option value='Wizard'>Wizard</option> <option value='Ware Wolf'>Ware Wolf</option> <option value='Vampire'>Vampire</option> <option value='Yeti'>Yeti</option> <option value='Elf'>Elf</option> <option value='Zombie'>Zombie</option> <option value='Beast'>Beast</option> <option value='Dwarf'>Dwarf</option> <option value='Gangsta'>Gangsta</option> <option value='Criminal'>Criminal</option> <option value='Pimp'>Pimp</option> <option value='Member'>Member</option> <option value='God'>God</option> <option value='Pilot'>Pilot</option> <option value='Boxer'>Boxer</option> <option value='Chief'>Chief</option> <option value='Cop'>Cop</option> <option value='Creature'>Creature</option> <option value='Seller'>Seller</option> <option value='Buyer'>Buyer</option> <option value='Goth'>Goth</option> <option value='Thief'>Thief</option> <option value='Hacker'>Hacker</option> <option value='Skeleton'>Skeleton</option> <option value='Demon'>Demon</option> <option value='Goblin'>Goblin</option> <option value='Unknown' SELECTED>Unknown</option> </Select> <input class='textbox' type='submit' value='Change Race' /> </form>"; } function do_race_change() { global $db,$ir,$c,$userid,$h; $db->query("UPDATE users SET myrace='{$_POST['myrace']}' WHERE userid=$userid"); print "You Have Changed your Race Type!<br /> <a href='preferences.php'>Back</a>"; ------------------------------------------------------------------------------------------------------------------------------------------------- ALTER TABLE `users` ADD `myrace` enum('Wizard','Unknown','Ware Wolf','Vampire','Elf','Yeti','Zombie','Beast','Dwarf','Gangsta','Criminal','Pimp','Member','God','Pilot','Boxer','Chief','Cop','Creature','Seller','Buyer','Goth','Thief','Hacker','Skeleton','Demon','Goblin') NOT NULL default 'Unknown' -------------------------------------------------------------------------------------------------------------------------------------------------

i'll post up the fixed version tomorrw as i'm going bed now. UPDATE, Sorry i cant post it here as i dont seem to have this anywhere,

hmm, i would offer my services but i had already done this and cba helping to do it all over again