mastercjb

Tried that there is no change, im still getting the error.

I have a code for my game where people can donate cash and crystals to there gang. However I get this error: QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Query was INSERT INTO gangevents VALUES('',13,unix_timestamp(),"Homer donated $0 and/or 5 crystals to the Gang."); It will still put the cash or crystals into the tables in my database, but I dont see why I am getting this error... Here is the code where it puts the info into the tables. Do you guys see anything wrong? { $db->query("UPDATE users SET money=money-{$_POST['money']},crystals=crystals-{$_POST['crystals']} WHERE userid=$userid"); $db->query("UPDATE gangs SET gangMONEY=gangMONEY+{$_POST['money']},gangCRYSTALS=gangCRYSTALS+{$_POST['crystals']} WHERE gangID={$gangdata['gangID']}"); $db->query("INSERT INTO gangevents VALUES('',{$gangdata['gangID']},unix_timestamp(),\"<a href='viewuser.php?u=$userid'>{$ir['username']}</a> donated \${$_POST['money']} and/or {$_POST['crystals']} crystals to the Gang.\");"); print "You donated \${$_POST['money']} and/or {$_POST['crystals']} crystals to the Gang."; }

Thanks I re scripted it like this, and it worked: function conf_race_change() { global $ir,$c,$userid,$h; if($ir['race'] == "Pirate") { $r="Ninja"; } else { $r="Pirate"; } print "Switching your race will cost 1,500 points. Are you sure you want to become a $r?<br /> <a href='preferences.php?action=racechange2'>Yes</a> | <a href='preferences.php'>No</a>"; } function do_race_change() { global $db,$ir,$c,$userid,$h; if($ir['race'] == "Pirate") { $r="Ninja"; } else { $r="Pirate"; } if($ir['crystals'] < 1500) { die("You don't have enough points. You need 1,500 points."); } $db->query("UPDATE users SET race='$r' WHERE userid=$userid"); $db->query("UPDATE users SET crystals=crystals-1500 WHERE userid=$userid"); print "Success, you are now $r!<br /> <a href='preferences.php'>Back</a>"; } Thank you

I have this script for my game where they can change there race. This will cost them 2,500 points. However in our database points are called crystals. If the person has 500 points, and the script takes 2,500 it will put them at -2,000 points. I need the script to tell them they dont have enough points and then not change there race because they dont have enough to do so. However im not to sure on how I would write it. This is the race change script im editing, can anyone explain how to write this to do what I need: function conf_race_change() { global $ir,$c,$userid,$h; if($ir['race'] == "Pirate") { $r="Ninja"; } else { $r="Pirate"; } print "Switching your race will cost 2,500 points. Are you sure you want to become a $r?<br /> <a href='preferences.php?action=racechange2'>Yes</a> | <a href='preferences.php'>No</a>"; } function do_race_change() { global $db,$ir,$c,$userid,$h; if($ir['race'] == "Pirate") { $r="Ninja"; } else { $r="Pirate"; } $db->query("UPDATE users SET race='$r' WHERE userid=$userid"); $db->query("UPDATE users SET crystals=crystals-2500 WHERE userid=$userid"); print "Success, you are now $r!<br /> <a href='preferences.php'>Back</a>"; }

I was given this script however I was not told what to add in my MYSQL tables. This is part of the script I was given: <?php session_start(); require "global_func.php"; if($_SESSION['loggedin']==0) { header("Location: login.php");exit; } $userid=$_SESSION['userid']; require "header.php"; $h = new headers; $h->startheaders(); include "config.php"; global $c; $is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error()); $ir=mysql_fetch_array($is); check_level(); $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(); Now this part is throwing this error: Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/blt3/public_html/streets.php on line 11 This is line 11: $is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error()); What is that trying to select? I know its trying to pull something from my users table but what? What does LEFT JOIN mean? [td][/td]

I did what you said and I still get : Parse error: syntax error, unexpected T_VARIABLE So I took that part out and still got this error: syntax error, unexpected '}' on line 148 This is what I did to the page like you said... <?php $_SESSION['lovetap'] = 0; include "globals.php"; $_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="GM"; } else if($r['user_level'] == 0) { $userl="NPC"; } else {$userl="FM"; } $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['donatordays'] > 0) { if($r['race'] == "Pirate") { $color = "<font color='red'>"; $ecolor = "</font>"; $ccode = "<a alt='Elite Pirate: {$r['donatordays']} Days Left' title='Elite Pirate: {$r['donatordays']} Days Left'>"; $cend = "</a>"; } else if($r['race'] == "Ninja") { $color = "<font color='blue'>"; $ecolor = "</font>"; $ccode = "<a alt='Stealth Ninja: {$r['donatordays']} Days Left' title='Stealth Ninja: {$r['donatordays']} Days Left'>"; $cend = "</a>"; } } else { if($r['race'] == "Pirate") { $color = "<font color='light yellow'>"; $ecolor = "</font>"; $ccode = ""; $cend = ""; } else if($r['race'] == "Ninja") { $color = "<font color='white'>"; $ecolor = "</font>"; $ccode = ""; $cend = ""; } } require "bb.php"; $bbc = new bbcode; $buser = $db->query("SELECT * FROM profile_signature WHERE userid = {$r['userid']}"); $buserq = $db->fetch_row($buser); if($buserq['signature']) $view_signature = $bbc->bbcode_parse($buserq['signature']); else $view_signature = "No Signature!"; if($r['laston'] >= time()-15*60) { $on="<font color=green><b>[Online]</b></font>"; } else { $on="<font color=red><b>[Offline]</b></font>"; } ?> <table width='100%'> <td class=contentcontent width='25%' valign='top'> <?php if($r['display_pic']) { print "<img src='{$r['display_pic']}' alt='User Display Pic' title='User Display Pic' />"; } else { print "This user has no display pic!"; } ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Name:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php $ccode$color{$r['username']}$ecolor$cend ?> </td> </td> <td class=contentcontent width='20%' valign='top'> Health:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php {$r['hp']}/{$r['maxhp']} ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Type:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php $userl ?> </td> </td> <td class=contentcontent width='20%' valign='top'> Race:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php {$r['race']} ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Gender:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php {$r['gender']} ?> </td> </td> <td class=contentcontent width='20%' valign='top'> Fourm Posts:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php {$r['posts']} ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Level:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php {$r['level']} ?> </td> </td> <td class=contentcontent width='20%' valign='top'> Money:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php \${$r['money']} ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Age:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php {$r['daysold']} ?> </td> </td> <td class=contentcontent width='20%' valign='top'> Last Active:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php $str ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Online:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php $on ?> </td> </td> <td class=contentcontent width='20%' valign='top'> Gang:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php if($r['gang']) { print "<a href='gangs.php?action=view&ID={$r['gang']}'>{$r['gangNAME']}</a>"; } else { print "N/A"; } ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> City:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php {$r['cityname']} ?> </td> </td> <td class=contentcontent width='20%' valign='top'> House:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php {$r['hNAME']} ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Hospital Status:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php if($r['hospital']) { print "<font color=red>{$r['hospital']} minutes.</font>"; } else { print "Not in Hospital"; } ?> </td> </td> <td class=contentcontent width='20%' valign='top'> Prison Status:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php if($r['jail']) { print "<font color=red>{$r['jail']} minutes.</font>"; } else { print "Not in Prison"; } ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Referals:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php $rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}"); print $db->num_rows($rr); print " ?> </td> </td> <td class=contentcontent width='20%' valign='top'> Friends:</td> </td> <td class=contentcontent width='30%' valign='top'> <?php {$r['friend_count']} ?> </td> </td> </td></table> <br<br><br> <table width='100%'> <td class=contentcontent width='20%' valign='top'> <?php print "[<a href='mailbox.php?action=compose&ID={$r['userid']}'>Send Mail</a>]"; ?> </td> </td> <td class=contentcontent width='20%' valign='top'> <?php print "[<a href='sendcash.php?ID={$r['userid']}'>Send Cash</a>]"; ?> </td> </td> <td class=contentcontent width='20%' valign='top'> <?php if($set['sendcrys_on']) { print "[<a href='sendcrys.php?ID={$r['userid']}'>Send Points</a>]"; } ?> </td> </td> <td class=contentcontent width='20%' valign='top'> <?php if($set['sendbank_on']) { if($ir['bankmoney'] >= 0 && $r['bankmoney'] >= 0) { print "[<a href='sendbank.php?ID={$r['userid']}'>Bank Xfer</a>]"; } ?> </td> </td> <td class=contentcontent width='20%' valign='top'> <?php if($ir['cybermoney'] >= 0 && $r['cybermoney'] >= 0) { print "[<a href='sendcyber.php?ID={$r['userid']}'>CyberBank Xfer</a>]<br /><br />"; } } ?> </td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> <?php print " [<a href='attack.php?ID={$r['userid']}'>Attack</a>]"; ?> </td> </td> <td class=contentcontent width='20%' valign='top'> <?php print "[<a href='contactlist.php?action=add&ID={$r['userid']}'>Add Contact</a>]"; ?> </td> </td> <td class=contentcontent width='20%' valign='top'> <?php if($ir['donatordays'] > 0) { print " [<a href='friendslist.php?action=add&ID={$r['userid']}'>Add Friends</a>]"; } ?> </td> </td> <td class=contentcontent width='20%' valign='top'> <?php if($ir['donatordays'] > 0) { print " [<a href='blacklist.php?action=add&ID={$r['userid']}'>Add Enemies</a>]"; } ?> </td> </td> <td class=contentcontent width='20%' valign='top'> </td> </td> </td></table>"; <br><br> <table width='100%'> <td class=contentcontent width='30%' valign='top'> <?php if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { print "<br /><br /> [<a href='jailuser.php?userid={$r['userid']}'>Jail</a>]<br /><br /> [<a href='mailban.php?userid={$r['userid']}'>MailBan</a>]"; } ?> </td> </td> <td class=contentcontent width='70%' valign='top'> <?php 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']); print "<h3>Internet Info</h3><table width='100%' border='0' 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>"; print "<form action='staffnotes.php' method='post'> Staff Notes: <br /> <textarea rows=7 cols=40 name='staffnotes'>{$r['staffnotes']}</textarea> <br /><input type='hidden' name='ID' value='{$_GET['u']}' /> <input type='submit' value='Change' /></form>"; } else { print " "; } ?> </td> </td> </td></table><br><br> <table width='100%'> <td align=center colspan=3>SIGNATURE</td></tr> <tr> <td colspan=3>$view_signature</td> </tr> </table>"; } } <?php function checkblank($in) { if(!$in) { return "N/A"; } return $in; } $h->endpage(); ?>

I gave all the information so people can help. I said its a syntax error, its because theres HTML in the PHP script. It give me an error at the start of the tables. So its all the tables giving the error. I just need know how I would format the tables to work in the PHP set up. Here is the beginning area of the tables that are throwing the code: <table width='100%'> <td class=contentcontent width='25%' valign='top'> if($r['display_pic']) { print "<img src='{$r['display_pic']}' alt='User Display Pic' title='User Display Pic' />"; } else { print "This user has no display pic!"; }</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Name:</td> </td> <td class=contentcontent width='30%' valign='top'> $ccode$color{$r['username']}$ecolor$cend</td> </td> <td class=contentcontent width='20%' valign='top'> Health:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['hp']}/{$r['maxhp']}</td> </td> </td></table>

Ok but can anyone tell me how I might be able to put those tables in there. Like how do I attempt to fix it?

I'm still learning all the PHP stuff. I wrote all of this by hand in notepad so I dont know about the indenting stuff. I really just need help understanding how I can make the tables work in the PHP set-up.

syntax error's because of the html in the php

I have tried to echo and everything, I cant get these tables to work with the php inside! Its a profile page for my game! <?php $_SESSION['lovetap'] = 0; include "globals.php"; $_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="GM"; } else if($r['user_level'] == 0) { $userl="NPC"; } else {$userl="FM"; } $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['donatordays'] > 0) { if($r['race'] == "Pirate") { $color = "<font color='red'>"; $ecolor = "</font>"; $ccode = "<a alt='Elite Pirate: {$r['donatordays']} Days Left' title='Elite Pirate: {$r['donatordays']} Days Left'>"; $cend = "</a>"; } else if($r['race'] == "Ninja") { $color = "<font color='blue'>"; $ecolor = "</font>"; $ccode = "<a alt='Stealth Ninja: {$r['donatordays']} Days Left' title='Stealth Ninja: {$r['donatordays']} Days Left'>"; $cend = "</a>"; } } else { if($r['race'] == "Pirate") { $color = "<font color='light yellow'>"; $ecolor = "</font>"; $ccode = ""; $cend = ""; } else if($r['race'] == "Ninja") { $color = "<font color='white'>"; $ecolor = "</font>"; $ccode = ""; $cend = ""; } } require "bb.php"; $bbc = new bbcode; $buser = $db->query("SELECT * FROM profile_signature WHERE userid = {$r['userid']}"); $buserq = $db->fetch_row($buser); if($buserq['signature']) $view_signature = $bbc->bbcode_parse($buserq['signature']); else $view_signature = "No Signature!"; if($r['laston'] >= time()-15*60) { $on="<font color=green><b>[Online]</b></font>"; } else { $on="<font color=red><b>[Offline]</b></font>"; } <table width='100%'> <td class=contentcontent width='25%' valign='top'> if($r['display_pic']) { print "<img src='{$r['display_pic']}' alt='User Display Pic' title='User Display Pic' />"; } else { print "This user has no display pic!"; }</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Name:</td> </td> <td class=contentcontent width='30%' valign='top'> $ccode$color{$r['username']}$ecolor$cend</td> </td> <td class=contentcontent width='20%' valign='top'> Health:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['hp']}/{$r['maxhp']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Type:</td> </td> <td class=contentcontent width='30%' valign='top'> $userl</td> </td> <td class=contentcontent width='20%' valign='top'> Race:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['race']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Gender:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['gender']}</td> </td> <td class=contentcontent width='20%' valign='top'> Fourm Posts:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['posts']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Level:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['level']}</td> </td> <td class=contentcontent width='20%' valign='top'> Money:</td> </td> <td class=contentcontent width='30%' valign='top'> \${$r['money']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Age:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['daysold']}</td> </td> <td class=contentcontent width='20%' valign='top'> Last Active:</td> </td> <td class=contentcontent width='30%' valign='top'> $str</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Online:</td> </td> <td class=contentcontent width='30%' valign='top'> $on</td> </td> <td class=contentcontent width='20%' valign='top'> Gang:</td> </td> <td class=contentcontent width='30%' valign='top'> "; if($r['gang']) { print "<a href='gangs.php?action=view&ID={$r['gang']}'>{$r['gangNAME']}</a>"; } else { print "N/A"; }</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> City:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['cityname']}</td> </td> <td class=contentcontent width='20%' valign='top'> House:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['hNAME']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Hospital Status:</td> </td> <td class=contentcontent width='30%' valign='top'> if($r['hospital']) { print "<font color=red>{$r['hospital']} minutes.</font>"; } else { print "Not in Hospital"; }</td> </td> <td class=contentcontent width='20%' valign='top'> Prison Status:</td> </td> <td class=contentcontent width='30%' valign='top'> if($r['jail']) { print "<font color=red>{$r['jail']} minutes.</font>"; } else { print "Not in Prison"; }</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Referals:</td> </td> <td class=contentcontent width='30%' valign='top'> "; $rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}"); print $db->num_rows($rr); print "</td> </td> <td class=contentcontent width='20%' valign='top'> Friends:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['friend_count']}</td> </td> </td></table> <br<br><br> <table width='100%'> <td class=contentcontent width='20%' valign='top'> print "[<a href='mailbox.php?action=compose&ID={$r['userid']}'>Send Mail</a>]";</td> </td> <td class=contentcontent width='20%' valign='top'> print "[<a href='sendcash.php?ID={$r['userid']}'>Send Cash</a>]";</td> </td> <td class=contentcontent width='20%' valign='top'> if($set['sendcrys_on']) { print "[<a href='sendcrys.php?ID={$r['userid']}'>Send Points</a>]"; }</td> </td> <td class=contentcontent width='20%' valign='top'> if($set['sendbank_on']) { if($ir['bankmoney'] >= 0 && $r['bankmoney'] >= 0) { print "[<a href='sendbank.php?ID={$r['userid']}'>Bank Xfer</a>]"; }</td> </td> <td class=contentcontent width='20%' valign='top'> if($ir['cybermoney'] >= 0 && $r['cybermoney'] >= 0) { print "[<a href='sendcyber.php?ID={$r['userid']}'>CyberBank Xfer</a>]<br /><br />"; } }</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> print " [<a href='attack.php?ID={$r['userid']}'>Attack</a>]";</td> </td> <td class=contentcontent width='20%' valign='top'> print "[<a href='contactlist.php?action=add&ID={$r['userid']}'>Add Contact</a>]";</td> </td> <td class=contentcontent width='20%' valign='top'> if($ir['donatordays'] > 0) { print " [<a href='friendslist.php?action=add&ID={$r['userid']}'>Add Friends</a>]"; }</td> </td> <td class=contentcontent width='20%' valign='top'> if($ir['donatordays'] > 0) { print " [<a href='blacklist.php?action=add&ID={$r['userid']}'>Add Enemies</a>]"; }</td> </td> <td class=contentcontent width='20%' valign='top'> </td> </td> </td></table>"; <br><br> <table width='100%'> <td class=contentcontent width='30%' valign='top'> if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { print "<br /><br /> [<a href='jailuser.php?userid={$r['userid']}'>Jail</a>]<br /><br /> [<a href='mailban.php?userid={$r['userid']}'>MailBan</a>]"; }</td> </td> <td class=contentcontent width='70%' valign='top'> 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']); print "<h3>Internet Info</h3><table width='100%' border='0' 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>"; print "<form action='staffnotes.php' method='post'> Staff Notes: <br /> <textarea rows=7 cols=40 name='staffnotes'>{$r['staffnotes']}</textarea> <br /><input type='hidden' name='ID' value='{$_GET['u']}' /> <input type='submit' value='Change' /></form>"; } else { print " "; }</td> </td> </td></table><br><br> <table width='100%'> <td align=center colspan=3>SIGNATURE</td></tr> <tr> <td colspan=3>$view_signature</td> </tr> </table>"; } } function checkblank($in) { if(!$in) { return "N/A"; } return $in; } $h->endpage(); ?>

I tried this, but is didn't work. I'm out of idea's here... if($r['laston'] >= time()-15*60) { $on="<font color=green><b>[Online]</b></font>"; } else { $on="<font color=red><b>[Offline]</b></font>"; } echo "<table width='100%'> <td class=contentcontent width='25%' valign='top'>"; if($r['display_pic']) { print "<img src='{$r['display_pic']}' alt='User Display Pic' title='User Display Pic' />"; } else { print "This user has no display pic!"; }echo "</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Name:</td> </td> <td class=contentcontent width='30%' valign='top'>"; $ccode$color{$r['username']}$ecolor$cendecho echo "</td> </td> <td class=contentcontent width='20%' valign='top'> Health:</td> </td> <td class=contentcontent width='30%' valign='top'>"; {$r['hp']}/{$r['maxhp']}echo "</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Type:</td> </td> <td class=contentcontent width='30%' valign='top'>"; $userlecho "</td> </td> <td class=contentcontent width='20%' valign='top'> Race:</td> </td> <td class=contentcontent width='30%' valign='top'>"; {$r['race']}echo "</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Gender:</td> </td> <td class=contentcontent width='30%' valign='top'>"; {$r['gender']}echo "</td> </td> <td class=contentcontent width='20%' valign='top'> Fourm Posts:</td> </td> <td class=contentcontent width='30%' valign='top'>"; {$r['posts']}echo "</td> </td> </td></table>";

I'm lost on this one then because if I echo the table theres php in the table, so it will send an error... And if I close the php tags it will not use the php that it in the tables...

This has worked on many different page of the site, this is the one page its not working on....

I'm trying to write a code for a profile on my game site. However I keep getting this error. Parse error: syntax error, unexpected '<' in /home/blt3/public_html/profile2.php on line 120 This is the script im working with... <?php $_SESSION['lovetap'] = 0; include "globals.php"; $_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="GM"; } else if($r['user_level'] == 0) { $userl="NPC"; } else {$userl="FM"; } $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['donatordays'] > 0) { if($r['race'] == "Pirate") { $color = "<font color='red'>"; $ecolor = "</font>"; $ccode = "<a alt='Elite Pirate: {$r['donatordays']} Days Left' title='Elite Pirate: {$r['donatordays']} Days Left'>"; $cend = "</a>"; } else if($r['race'] == "Ninja") { $color = "<font color='blue'>"; $ecolor = "</font>"; $ccode = "<a alt='Stealth Ninja: {$r['donatordays']} Days Left' title='Stealth Ninja: {$r['donatordays']} Days Left'>"; $cend = "</a>"; } } else { if($r['race'] == "Pirate") { $color = "<font color='light yellow'>"; $ecolor = "</font>"; $ccode = ""; $cend = ""; } else if($r['race'] == "Ninja") { $color = "<font color='white'>"; $ecolor = "</font>"; $ccode = ""; $cend = ""; } } require "bb.php"; $bbc = new bbcode; $buser = $db->query("SELECT * FROM profile_signature WHERE userid = {$r['userid']}"); $buserq = $db->fetch_row($buser); if($buserq['signature']) $view_signature = $bbc->bbcode_parse($buserq['signature']); else $view_signature = "No Signature!"; 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['display_pic']) <table width='100%'> <td class=contentcontent width='25%' valign='top'> { print "<img src='{$r['display_pic']}' alt='User Display Pic' title='User Display Pic' />"; } else { print "This user has no display pic!"; }</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Name:</td> </td> <td class=contentcontent width='30%' valign='top'> $ccode$color{$r['username']}$ecolor$cend</td> </td> <td class=contentcontent width='20%' valign='top'> Health:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['hp']}/{$r['maxhp']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Type:</td> </td> <td class=contentcontent width='30%' valign='top'> $userl</td> </td> <td class=contentcontent width='20%' valign='top'> Race:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['race']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Gender:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['gender']}</td> </td> <td class=contentcontent width='20%' valign='top'> Fourm Posts:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['posts']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Level:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['level']}</td> </td> <td class=contentcontent width='20%' valign='top'> Money:</td> </td> <td class=contentcontent width='30%' valign='top'> \${$r['money']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Age:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['daysold']}</td> </td> <td class=contentcontent width='20%' valign='top'> Last Active:</td> </td> <td class=contentcontent width='30%' valign='top'> $str</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Online:</td> </td> <td class=contentcontent width='30%' valign='top'> $on</td> </td> <td class=contentcontent width='20%' valign='top'> Gang:</td> </td> <td class=contentcontent width='30%' valign='top'> "; if($r['gang']) { print "<a href='gangs.php?action=view&ID={$r['gang']}'>{$r['gangNAME']}</a>"; } else { print "N/A"; }</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> City:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['cityname']}</td> </td> <td class=contentcontent width='20%' valign='top'> House:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['hNAME']}</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Hospital Status:</td> </td> <td class=contentcontent width='30%' valign='top'> if($r['hospital']) { print "<font color=red>{$r['hospital']} minutes.</font>"; } else { print "Not in Hospital"; }</td> </td> <td class=contentcontent width='20%' valign='top'> Prison Status:</td> </td> <td class=contentcontent width='30%' valign='top'> if($r['jail']) { print "<font color=red>{$r['jail']} minutes.</font>"; } else { print "Not in Prison"; }</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> Referals:</td> </td> <td class=contentcontent width='30%' valign='top'> "; $rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}"); print $db->num_rows($rr); print "</td> </td> <td class=contentcontent width='20%' valign='top'> Friends:</td> </td> <td class=contentcontent width='30%' valign='top'> {$r['friend_count']}</td> </td> </td></table> <br<br><br> <table width='100%'> <td class=contentcontent width='20%' valign='top'> print "[<a href='mailbox.php?action=compose&ID={$r['userid']}'>Send Mail</a>]";</td> </td> <td class=contentcontent width='20%' valign='top'> print "[<a href='sendcash.php?ID={$r['userid']}'>Send Cash</a>]";</td> </td> <td class=contentcontent width='20%' valign='top'> if($set['sendcrys_on']) { print "[<a href='sendcrys.php?ID={$r['userid']}'>Send Points</a>]"; }</td> </td> <td class=contentcontent width='20%' valign='top'> if($set['sendbank_on']) { if($ir['bankmoney'] >= 0 && $r['bankmoney'] >= 0) { print "[<a href='sendbank.php?ID={$r['userid']}'>Bank Xfer</a>]"; }</td> </td> <td class=contentcontent width='20%' valign='top'> if($ir['cybermoney'] >= 0 && $r['cybermoney'] >= 0) { print "[<a href='sendcyber.php?ID={$r['userid']}'>CyberBank Xfer</a>]<br /><br />"; } }</td> </td> </td></table> <table width='100%'> <td class=contentcontent width='20%' valign='top'> print " [<a href='attack.php?ID={$r['userid']}'>Attack</a>]";</td> </td> <td class=contentcontent width='20%' valign='top'> print "[<a href='contactlist.php?action=add&ID={$r['userid']}'>Add Contact</a>]";</td> </td> <td class=contentcontent width='20%' valign='top'> if($ir['donatordays'] > 0) { print " [<a href='friendslist.php?action=add&ID={$r['userid']}'>Add Friends</a>]"; }</td> </td> <td class=contentcontent width='20%' valign='top'> if($ir['donatordays'] > 0) { print " [<a href='blacklist.php?action=add&ID={$r['userid']}'>Add Enemies</a>]"; }</td> </td> <td class=contentcontent width='20%' valign='top'> </td> </td> </td></table> <br><br> <table width='100%'> <td class=contentcontent width='30%' valign='top'> if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { print "<br /><br /> [<a href='jailuser.php?userid={$r['userid']}'>Jail</a>]<br /><br /> [<a href='mailban.php?userid={$r['userid']}'>MailBan</a>]"; }</td> </td> <td class=contentcontent width='70%' valign='top'> 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']); print "<h3>Internet Info</h3><table width='100%' border='0' 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>"; print "<form action='staffnotes.php' method='post'> Staff Notes: <br /> <textarea rows=7 cols=40 name='staffnotes'>{$r['staffnotes']}</textarea> <br /><input type='hidden' name='ID' value='{$_GET['u']}' /> <input type='submit' value='Change' /></form>"; } else { print " "; }</td> </td> </td></table><br><br> <td align=center colspan=3>SIGNATURE</td></tr> <tr> <td colspan=3>$view_signature</td> </tr> </table>"; } } function checkblank($in) { if(!$in) { return "N/A"; } return $in; } $h->endpage(); ?>

I cant for the life of me find out how to hide or show a box, like with a + or - button. Heres the script I'm working with. I need the top contentcontent box to hide. How would I do that? <? include 'header.php';?> <table class="content"> <tr> <td class="contenthead">Become A Respected Mobster</td> </tr> <tr> <td class="contentcontent"> <table width='100%'> <tr> <td width='50%'><center>You're not a Respected Mobster yet! Why not?<br><br> You're missing out!<br><br> <a href="rmstore.php">Upgrade Now!<br> Starting From $3.00!</a></td><br></center> <td width='50%'>.: Bank Interest is DOUBLED!<br> .: Respected MR Member Status!<br> .: Cash Bonus on Purchase!<br> .: Points Bonus on Purchase<br> .: Access to RM Only Features!</td> </tr> </table> </td> </tr> <tr> <td class="contenthead">General Information</td> </tr> <tr> <td class="contentcontent"> <table width='100%'> <tr> <td width='15%'>Name:</td> <td width='35%'><a href='profiles.php?id=<? echo $user_class->id; ?>'><? echo $user_class->formattedname; ?></a></td> <td width='15%'>HP:</td> <td width='35%'><?php echo $user_class->formattedhp; ?></td> </tr> <tr> <td width='15%'>Level:</td> <td width='35%'><? echo $user_class->level; ?></td> <td width='15%'>Energy:</td> <td width='35%'><?php echo $user_class->formattedenergy; ?></td> </tr> <tr> <td width='15%'>Money:</td> <td width='35%'>$<? echo $user_class->money; /*money_format('%(#10n', $user_class->money);*/ ?></td> <td width='15%'>Awake:</td> <td width='35%'><?php echo $user_class->formattedawake; ?></td> </tr> <tr> <td width='15%'>Bank:</td> <td width='35%'>$<? echo $user_class->bank; /*money_format('%(#10n', $user_class->bank);*/ ?></td> <td width='15%'>Nerve:</td> <td width='35%'><?php echo $user_class->formattednerve; ?></td> </tr> <tr> <td width='15%'>EXP:</td> <td width='35%'><?php echo $user_class->formattedexp; ?></td> <td width='15%'>Work EXP:</td> <td width='35%'><? echo $user_class->workexp; ?></td> </tr> <tr> <td width='15%'>Prostitutes:</td> <td width='35%'><?php echo $user_class->hookers; ?></td> <td width='15%'>Marijuana:</td> <td width='35%'><?php echo $user_class->marijuana; ?></td> </tr> </table> </td> </tr> <tr> <td class="contenthead">Attributes</td> </tr> <tr> <td class="contentcontent"> <table width='100%'> <tr> <td width='15%'>Strength:</td> <td width='35%'><? echo $user_class->strength; ?></td> <td width='15%'>Defense:</td> <td width='35%'><? echo $user_class->defense; ?></td> </tr> <tr> <td width='15%'>Speed:</td> <td width='35%'><? echo $user_class->speed; ?></td> <td width='15%'>Total:</td> <td width='35%'><? echo $user_class->totalattrib; ?></td> </tr> </table> </td> </tr> <tr><td class="contenthead">Battle Stats</td></tr> <tr><td class="contentcontent"> <table width='100%'> <tr> <td width='15%'>Won:</td> <td width='35%'><? echo $user_class->battlewon ?></td> <td width='15%'>Lost:</td> <td width='35%'><? echo $user_class->battlelost; ?></td> </tr> <tr> <td width='15%'>Total:</td> <td width='35%'><? echo $user_class->battletotal; ?></td> <td width='15%'>Money Gain:</td> <td width='35%'>$<? echo $user_class->battlemoney; ?></td> </tr> </table> </td> </tr> <tr> <td class="contenthead">Crime Stats</td> </tr> <tr> <td class="contentcontent"> <table width='100%'> <tr> <td width='15%'>Succeeded:</td> <td width='35%'><? echo $user_class->crimesucceeded; ?></td> <td width='15%'>Failed:</td> <td width='35%'><? echo $user_class->crimefailed; ?></td> </tr> <tr> <td width='15%'>Total:</td> <td width='35%'><? echo $user_class->crimetotal; ?></td> <td width='15%'>Money Gain:</td> <td width='35%'>$<? echo $user_class->crimemoney; ?></td> </tr> </table></td> </tr> <? include 'footer.php'; ?>

Ok I get that, and thought of that. But how would I do it. I'm just learning php so I dont know what the code would look like...

how would that help hide the script?

I have a script im trying to modify. this script shows users there stats, I have made a table at the top that should only be seen by people with 0 rmdays, meaning they are not a member. I need a code that when a user hits 0 rmdays this message will then show to them, but will not show to people with rmdays. Here is the full page script: <? include 'header.php'; ?> <table class="content"> <tr> <td class="contenthead">Become A Respected Mobster</td> </tr> <tr> <td class="contentcontent"> <table width='100%'> <tr> <td width='50%'><center>You're not a Respected Mobster yet! Why not?<br><br> You're missing out!<br><br> <a href="rmstore.php">Upgrade Now!<br> Starting From $3.00!</a></td><br></center> <td width='50%'>.: Bank Interest is DOUBLED!<br> .: Respected MR Member Status!<br> .: Cash Bonus on Purchase!<br> .: Points Bonus on Purchase<br> .: Access to RM Only Features!</td> </tr> </table> </td> </tr> <tr> <td class="contenthead">General Information</td> </tr> <tr> <td class="contentcontent"> <table width='100%'> <tr> <td width='15%'>Name:</td> <td width='35%'><a href='profiles.php?id=<? echo $user_class->id; ?>'><? echo $user_class->formattedname; ?></a></td> <td width='15%'>HP:</td> <td width='35%'><?php echo $user_class->formattedhp; ?></td> </tr> <tr> <td width='15%'>Level:</td> <td width='35%'><? echo $user_class->level; ?></td> <td width='15%'>Energy:</td> <td width='35%'><?php echo $user_class->formattedenergy; ?></td> </tr> <tr> <td width='15%'>Money:</td> <td width='35%'>$<? echo $user_class->money; /*money_format('%(#10n', $user_class->money);*/ ?></td> <td width='15%'>Awake:</td> <td width='35%'><?php echo $user_class->formattedawake; ?></td> </tr> <tr> <td width='15%'>Bank:</td> <td width='35%'>$<? echo $user_class->bank; /*money_format('%(#10n', $user_class->bank);*/ ?></td> <td width='15%'>Nerve:</td> <td width='35%'><?php echo $user_class->formattednerve; ?></td> </tr> <tr> <td width='15%'>EXP:</td> <td width='35%'><?php echo $user_class->formattedexp; ?></td> <td width='15%'>Work EXP:</td> <td width='35%'><? echo $user_class->workexp; ?></td> </tr> <tr> <td width='15%'>Prostitutes:</td> <td width='35%'><?php echo $user_class->hookers; ?></td> <td width='15%'>Marijuana:</td> <td width='35%'><?php echo $user_class->marijuana; ?></td> </tr> </table> </td> </tr> <tr> <td class="contenthead">Attributes</td> </tr> <tr> <td class="contentcontent"> <table width='100%'> <tr> <td width='15%'>Strength:</td> <td width='35%'><? echo $user_class->strength; ?></td> <td width='15%'>Defense:</td> <td width='35%'><? echo $user_class->defense; ?></td> </tr> <tr> <td width='15%'>Speed:</td> <td width='35%'><? echo $user_class->speed; ?></td> <td width='15%'>Total:</td> <td width='35%'><? echo $user_class->totalattrib; ?></td> </tr> </table> </td> </tr> <tr><td class="contenthead">Battle Stats</td></tr> <tr><td class="contentcontent"> <table width='100%'> <tr> <td width='15%'>Won:</td> <td width='35%'><? echo $user_class->battlewon ?></td> <td width='15%'>Lost:</td> <td width='35%'><? echo $user_class->battlelost; ?></td> </tr> <tr> <td width='15%'>Total:</td> <td width='35%'><? echo $user_class->battletotal; ?></td> <td width='15%'>Money Gain:</td> <td width='35%'>$<? echo $user_class->battlemoney; ?></td> </tr> </table> </td> </tr> <tr> <td class="contenthead">Crime Stats</td> </tr> <tr> <td class="contentcontent"> <table width='100%'> <tr> <td width='15%'>Succeeded:</td> <td width='35%'><? echo $user_class->crimesucceeded; ?></td> <td width='15%'>Failed:</td> <td width='35%'><? echo $user_class->crimefailed; ?></td> </tr> <tr> <td width='15%'>Total:</td> <td width='35%'><? echo $user_class->crimetotal; ?></td> <td width='15%'>Money Gain:</td> <td width='35%'>$<? echo $user_class->crimemoney; ?></td> </tr> </table></td> </tr> <? include 'footer.php'; ?> Here is the table in there that I need to be only veiwable by people with 0 rmdays left: <table class="content"> <tr> <td class="contenthead">Become A Respected Mobster</td> </tr> <tr> <td class="contentcontent"> <table width='100%'> <tr> <td width='50%'><center>You're not a Respected Mobster yet! Why not?<br><br> You're missing out!<br><br> <a href="rmstore.php">Upgrade Now!<br> Starting From $3.00!</a></td><br></center> <td width='50%'>.: Bank Interest is DOUBLED!<br> .: Respected MR Member Status!<br> .: Cash Bonus on Purchase!<br> .: Points Bonus on Purchase<br> .: Access to RM Only Features!</td> </tr> </table> </td> </tr>

Solved. Thanks.

I have a code for selling a house in my game. I'm trying to figure out how to make it to where, if someone clicks Sell Your House then it will ask you "Are You Sure You Wish To Sell Your House?". The only way I can think to do it would be with javascript, but I cant seem to get java into this code... Can someone please help. Heres my page script. <?php include 'header.php'; if($_GET['buy'] != ''){ $result = mysql_query("SELECT * FROM `houses` WHERE `id`='".$_GET['buy']."'"); $worked = mysql_fetch_array($result); $cost = $worked['cost']; if($user_class->house != 0){ $result2 = mysql_query("SELECT * FROM `houses` WHERE `id`='".$user_class->house."'"); $worked2 = mysql_fetch_array($result2); $cost = $cost - ($worked2['cost'] * .75); echo Message('You have sold your house for 75% of what it was worth ($'.$cost."). That amount will go towards the purchase of the new house."); } if($cost > $user_class->money) { echo Message("You don't have enough money to buy that house."); } if($cost <= $user_class->money && $worked['name'] != "") { $newmoney = $user_class->money - $cost; $result = mysql_query("UPDATE `grpgusers` SET `house` = '".$_GET['buy']."', `money` = '".$newmoney."' WHERE `id`='".$_SESSION['id']."'"); echo Message("You have purchased and moved into ".$worked['name']."."); $user_class = new User($_SESSION['id']); } if ($worked['name'] == ""){ echo Message("That's not a real house."); } } ?> <tr><td class="contenthead">Move House</td></tr> <? if($user_class->house > 0){ echo "<tr><td class='contentcontent' align='center'><a href='house.php?action=sell'>Sell Your House</a></td></tr>"; } ?> <tr><td class="contentcontent"> <table width='100%'> <tr> <td width='45%'><b>Type</b></td> <td width='15%'><b>Awake</b></td> <td width='20%'><b>Cost</b></td> <td width='20%'><b>Move</b></td> </tr> <?php $result = mysql_query("SELECT * FROM `houses` ORDER BY `id` ASC"); while($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "<tr><td width='45%'>".$line['name']."</td><td>".$line['awake']."</td><td>\$".$line['cost']."</td><td>"; if($line['id'] > $user_class->house){ echo "<a href='house.php?buy=".$line['id']."'>Move In</a>"; } echo "</td></tr>"; } ?> </table> </td></tr> <?php include 'footer.php'; ?>

I Found a code that will check the database for me, but it wont change the name lol. Maybe this code will be easier to work with, it changes the sig also, heres that code... <?php include 'header.php'; if (isset($_POST['submit'])) { $avatar = $_POST["avatar"]; if($_POST['name'] == $user_class->username) { //Do nothing } else { $name = str_replace(array("<",">"),"&", $_POST['name']); $name = strip_tags($name); $name = htmlentities($name); if(mysql_num_rows(mysql_query("SELECT id FROM grpgusers WHERE username='".$name."'")) != 0) { echo Message('<center>The username you have entered already exist\'s. Go back and try again.</center><br>'); die; } } $quote = strip_tags($_POST["quote"]); $prosig = strip_tags($_POST["prosig"]); //insert the values if (!isset($message)){ $result= mysql_query("UPDATE `grpgusers` SET `username`='".$name."', `avatar`='".$avatar."', `quote`='".$quote."', `prosig`='".$prosig."' WHERE `id`='".$user_class->id."'"); echo Message('<center>Your preferences have been saved.<br /></center>'); die(); } } ?> <?php if (isset($message)) { echo Message($message); } print "<tr><td class='contenthead'> Account Preferences </td></tr> <tr><td class='contentcontent'> <form name='login' method='post'> <table width='100%' border='0' align='center' cellpadding='0' cellspacing='0'> <tr> <td height='50' align='right'> <font size='2' face='verdana'> UserName </font> </td> <td> <font size='2' face='verdana'> <input type='text' name='name' value='$user_class->username'> </font> </td> </tr> <tr> </tr> <tr> <td height='50' align='right'> <font size='2' face='verdana'> Avatar (Image Location) </font> </td> <td> <font size='2' face='verdana'> <input type='text' name='avatar' value='$user_class->avatar'> (NB: This will also change your login name!) </font> </td> </tr> <tr> </tr> <tr> <td height='50' align='right'><font size='2' face='verdana'>Quote (60 Chars MAX) </font></td> <td><font size='2' face='verdana'> <input type='text' name='quote' maxlength='60' value='$user_class->quote'> </font></td> </tr> </tr> <tr> </tr> <tr> <td align='right'><font size='2' face='verdana'>Profile Signature </font></td> <td><font size='2'> <textarea type='text' name='prosig' cols='53' rows='7' maxlength='2500'>$user_class->prosig</textarea> </font></td> </tr> <tr> <td> </td> <td><font size='2' face='verdana'> <input type='submit' name='submit' value='Save Preferences'> </font></td> </tr> </table> </form>"; include 'footer.php'; ?>

Ok Sorry, it works for the max length, but I can still use other peoples names....

anupamsaha: That code did not work, I could still have any name, and I could still type however many characters I wanted... br3nn4n: I put in the code and it threw an error, maybe it was my placement, where would you put it in my code?

I'm making a script so people can change there picture, quote, and username. I need help on how to limit the number of characters they can put into the username field. I dont want them to be able to put more then 20 characters in the box. Here is the full page script im working with. EDIT: It would also be nice if the script could look in my database to see if the username has been taken, and if it is, then tell them it has been. <? include 'header.php'; if (isset($_POST['submit'])) { $avatar = $_POST["avatar"]; $quote = $_POST["quote"]; $username = $_POST["username"]; //insert the values if (!isset($message)){ $result= mysql_query("UPDATE `grpgusers` SET `avatar`='".$avatar."', `quote`='".$quote."', `username`='".$username."' WHERE `id`='".$user_class->id."'"); echo Message('Your preferences have been saved.'); die(); } } ?> <? if (isset($message)) { echo Message($message); } ?> <tr><td class="contenthead"> Account Preferences </td></tr> <tr><td class="contentcontent"> <form name='login' method='post'> <table width='50%' border='0' align='center' cellpadding='0' cellspacing='0'> <tr> <td height='28'><font size='2' face='verdana'>Avatar Image Location: </font></td> <td><font size='2' face='verdana'> <input type='text' name='avatar' value='<?= $user_class->avatar ?>'> </font></td> </tr> <tr> <tr> <td height='28' align="right"><font size='2' face='verdana'>Quote: </font></td> <td><font size='2' face='verdana'> <input type='text' name='quote' value='<?= $user_class->quote ?>'> </font></td> </tr> <tr> <tr> <td height='28' align="right"><font size='2' face='verdana'>Username: </font></td> <td><font size='2' face='verdana'> <input type='text' name='username' value='<?= $user_class->username ?>'> </font></td> </tr> <tr> <tr> <td> </td> <td><font size='2' face='verdana'> <input type='submit' name='submit' value='Save Preferences'> </font></td> </tr> </table> </form> <? include 'footer.php'; ?>