Jump to content
MakeWebGames

VegasKiller

Members
  • Posts

    72
  • Joined

  • Last visited

Everything posted by VegasKiller

  1. I get this error after i updated code Illusions had me change. Parse error: syntax error, unexpected '<' on line 301 Can somon please help m get this damn page working properly   <?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; include "mysql.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(); $h->startheaders(); $fm=money_formatter($ir['money']); $cm=money_formatter($ir['crystals'],''); $lv=date('F j, Y, g:i a',$ir['laston']); $kaperc=(int) ($ir['karma']/$ir['maxkarma']*100); $kaopp=100-$kaperc; $h->userdata($ir,$lv,$fm,$cm); $h->menuarea(); print "<table width='100%'><tr><td valign='left' width='90%'><h3>User {$r['username']}'s Profile</h3></td><td valign='left' width='10%'>[url='walkthrough.php#viewuser'][img=/GFX/layout_images/help.gif][/url]</td></tr></table> <center>[img=/GFX/layout_images/topnav.gif]</center> "; $_GET['u'] = abs((int) $_GET['u']); if(!$_GET['u']) { print "<center>[b]Invalid Use Of File.[/b]</center>"; } else { $q=mysql_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']}",$c); if(mysql_num_rows($q) == 0) { print "<center>[b]Sorry, We Could Not Find A User With That ID, Check Your Source.[/b]</center>"; } else { $r=mysql_fetch_array($q); if($r['gympass'] == 0) { $gym="<font color=red>No</font>"; } else if($r['gympass'] == 1) { $gym="<font color=green>Yes</font>";} 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 if($r['user_level']==4) { $userl="Moderator"; } else if($r['user_level']==5) { $userl="Assistant"; } else if($r['user_level'] == 6) { $userl="Watcher"; } else if($r['user_level'] == 7) { $userl="GFX"; } else if($r['user_level'] == 8) { $userl="I.A Officer"; } else if($r['user_level'] == 9) { $userl="Sales"; } else { $userl="Helper"; } $lon=date('F j, Y g:i:s a',$r['laston']); $sup=date('F j, Y g:i:s a',$r['signedup']); $ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ']; $d=""; $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"; } } $d=""; if($r['donatordays']) { $r['username'] = "<font color=darkblue>[b]{$r['username']}[/b]</font>";$d="[img=/GFX/layout_images/donator.gif]"; } $vp=""; if($r['vipdays']) { $r['username'] = "<font color=darkred>[b]{$r['username']}[/b]</font>";$vp="[img=GFX/layout_images/vip.gif]"; } $ww1=""; if($r['wknd_1_hours']) { $r['username'] = "<font color=red>[b]{$r['username']}[/b]</font>";$ww1="[img=GFX/layout_images/ww1.gif]"; } $ww2=""; if($r['wknd_2_hours']) { $r['username'] = "<font color=red>[b]{$r['username']}[/b]</font>";$ww2="[img=GFX/layout_images/ww2.gif]"; } $ww3=""; if($r['wknd_3_hours']) { $r['username'] = "<font color=red>[b]{$r['username']}[/b]</font>";$ww3="[img=GFX/layout_images/ww3.gif]"; } if($r['laston'] >= time()-15*60) { $on="<font color=green>[b]Online[/b]</font>"; } else { $on="<font color=red>[b]Offline[/b]</font>"; } print "<center><table width=90% border=1><tr><td>[b]<font size='3'>{$r['username']} $d $vp $ww1 $ww2 $ww3</font> {$r['conscious']}[/b]"; if($ir['userid'] == $r['userid']){ print" [[url='preferences.php?action=consciouschange'][b]Change[/b][/url]]"; } print "</table> <center><table width=90% border='1'><tr><td width='25%'>"; if($r['display_pic'] == '' AND $r['gender'] =='Female') { print "<center>[img=GFX/layout_images/female.gif]</center>"; } else if($r['display_pic'] == '' AND $r['gender'] =='Male') { print "<center>[img=GFX/layout_images/male.gif]</center>"; } else if($r['display_pic'] == '' AND $r['gender'] =='Private') { print "<center>[img=GFX/layout_images/anonomous.gif]</center>"; } else if($r['display_pic']) { print "<center>[img={$r[]</center>"; } print "<center><img src=/GFX/layout_images/karmadevil.gif width=16 height=16 title='Evil Karma'><img src=/GFX/bars/barred.gif width=$kaopp height=7><img src=/GFX/bars/barblue.gif width=$kaperc height=7><img src=/GFX/layout_images/karmaangel.gif width=16 height=16 title='Good Karma'></center>"; print "<center><a href=rating.php?change=up&ID={$r['userid']}><img src=positive.gif></a> {$r['rating']} <a href=rating.php?change=down&ID={$r['userid']}><img src=negative.gif></a></center>"; if($r['profileintro']) { print "<center></center>"; } else { print "<center>[b]This User Has No Intro Music[/b]</center>"; } print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; if($r['fedjail']) { print "[b]<font color=red>In Anarchy Asylum For {$r['fed_days']} Day(s). </font>[b]For:[/b]<font color=red> {$r['fed_reason']}</font> <center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($r['hospital']) { print "[b]<font color=red>In Clinic For {$r['hospital']} Minutes. </font>[b]For:[/b]<font color=red> {$r['hospreason']}</font>[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($r['jail']) { print "[b]<font color=red>In Grinder For {$r['jail']} Minutes. </font>[b]For:[/b]<font color=red> {$r['jailreason']}</font>[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($r['trials'] > 0) { print "[b]<font color=blue>User Has Been Put On Trial {$r['trials']} Time(s).</font>[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } print " [b]User ID:[/b] {$r['userid']} [b]Online Status:[/b] $on [b]User Level:[/b] $userl [b]Duties:[/b] {$r['duties']} [b]User Game Level:[/b] {$r['level']} [b]Signed Up:[/b] $sup [b]Days Old:[/b] {$r['daysold']} Days Old [b]Last Active:[/b] $lon [b]Last Action:[/b] $la $unit ago [b]Last Poked By:[/b] User {$r['pokedby']} "; $w=mysql_query("SELECT * FROM warnings WHERE user={$r['userid']}",$c); print " [b]Warnings:[/b]<font color=red> ".mysql_num_rows($w)." </font>"; if($ir['user_level'] > 1) { print "[<a href=warnings.php?action=index&user={$r['userid']}>[b]Manage[/b]</a>] "; } print "[b]Referrals:[/b] "; $rr=mysql_query("SELECT * FROM referals WHERE refREFER={$r['userid']}",$c); print mysql_num_rows($rr); $qqq=mysql_query("SELECT * FROM userbodytype WHERE userid=$userid",$c); $ub=mysql_fetch_array($qqq); print " <center>[img=/GFX/layout_images/topnav.gif]</center>"; $q_y=mysql_query("SELECT * FROM friendslist WHERE fl_ADDED={$r['userid']}",$c); $q_z=mysql_query("SELECT * FROM blacklist WHERE bl_ADDED={$r['userid']}",$c); print " [b]Health:[/b] {$r['hp']}/{$r['maxhp']} [b]Gender:[/b] {$r['gender']} [b]User Body Type:[/b] {$ub['bodytype']} [b]Bodytype Days Old:[/b] "; if($r['stds']) { print "[b]Diseased:[/b] <font color=red>Has A STD</font> "; } print " [b]District:[/b] [[url='hirespy.php?ID={$r['][b]Hire Spy[/b][/url]] [b]Property:[/b] {$r['hNAME']} "; $wo2=mysql_query("SELECT * From petowned WHERE userid={$_GET['u']}",$c); $ow2=mysql_fetch_array($wo2); $pe2=mysql_query("SELECT * FROM userpets WHERE userid={$_GET['u']}",$c) or die(mysql_error()); $pet2=mysql_fetch_array($pe2); if ($ow2['petowned'] == 0) { print "[b]Pet Owned:[/b] <font color='red'>[b]No[/b]</font> "; } else if ($ir['petowned'] == 1) { print "[b]Pet Owned:[/b] [url='petview.php?u={$pet2['][b]{$pet2['petname']}[/b][/url] "; } else { print "[b]Pet Owned:[/b] <font color=green>{$pet2['petname']}</font> "; } print "[b]Country:[/b] "; if(preg_match("/png/",$r['country'])) { print "[img=/GFX/flags/00.png] "; } else { print "[img=/GFX/flags/{$r[country]}.png] "; } print "[b]Faction:[/b] "; if($r['gang']) { print "[url='gangs.php?action=view&ID={$r['][b]{$r['gangNAME']}[/b][/url] "; } else { print "[b]N/A[/b] "; } print " [b]Friends:[/b] ".mysql_num_rows($q_y)." [b]Enemies:[/b] ".mysql_num_rows($q_z)." [b]Gym access:[/b] [b]$gym[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; print " [b]Credits:[/b] \${$r['money']} [b]Liberty Pieces:[/b] {$r['libpieces']} [b]Gold Coins:[/b] {$r['crystals']} "; print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; print " [b]Battling Wins:[/b] {$r['wontimes_dc']} "; if($r['won']) { print "[b]Last Won:[/b] [b][url='viewuser.php?u={$r[']<font color='green'>{$r['username']} [{$r['won']}][/url]</font>[/b] "; } else { print "[b]Last Won:[/b] [b]<font color='green'>N/A</font>[/b] "; } if($r['lost']) { print "[b]Last Lost:[/b] [b][url='viewuser.php?u={$r[']<font color='red'>{$r['username']} [{$r['lost']}]</font>[/url][/b] "; } else { print "[b]Last Lost:[/b] [b]<font color='red'>N/A</font>[/b] "; } print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; print " [b]Been Busted Out:[/b] {$r['getbust']} Time(s) [b]Busted Out:[/b] {$r['bust']} Time(s) [b]Bust Failures:[/b] {$r['bustfail']} Attempt(s) [b]Been Breaked Out:[/b] {$r['getbreak']} Time(s) [b]Breaked Out:[/b] {$r['break']} Users [b]GTA Attempts:[/b] {$r['gtas']} Time(s) [b]GTA Success:[/b] {$r['gtasus']} Time(s) <center>[img=/GFX/layout_images/topnav.gif]</center>"; if($r['married'] == 1) { $marryq=mysql_query("SELECT * FROM `marriages` WHERE (`marriage_from` = '$r[userid]') OR (`marriage_to` = '$r[userid]')",$c); $mr=mysql_fetch_array($marryq); if($mr['marriage_from'] == $userid) { $from=2; $themid=$mr['marriage_to']; } else { $from=1; $themid=$mr['marriage_from']; } if($from == 1) { $uq=mysql_query("SELECT * FROM users WHERE userid='$mr[marriage_to]'",$c); } else { $uq=mysql_query("SELECT * FROM users WHERE userid='$mr[marriage_from]'",$c); } $marr=mysql_fetch_array($uq); $married="[url='viewuser.php?u=$themid'][b]".$marr['username']."[/b][/url]"; $marriagetxt=" ([url='marriageinfo.php?ID=$themid'][b]Info[/b][/url])"; } else { $married="<font color=red>[b]No[/b]</font>"; $marriagetxt=""; } print "[b]Married:[/b] $married$marriagetxt [b]Married:[/b] [b]".number_format($r['married_times'])." Time(s).[/b] [b]Partnered:[/b]"; $q=mysql_query("SELECT * FROM users WHERE userid='".$r['partnered']."'",$c); $_i=mysql_fetch_array($q); if($r['partnered']!=0){ echo "<font color=green> [b]YES[/b] </font> [b]Partnered To:[/b] [b][url='viewuser.php?u={$_i[']{$_i['username']}[/b][/url] "; $q=mysql_query("SELECT * FROM users WHERE userid='".$r['partnered']."'",$c); $_i=mysql_fetch_array($q); }else{ echo "<font color=red>[b] NO [/b]</font> "; } print " [b]Partnered:[/b] [b]{$r['partnered_times']} Time(s).[/b] "; print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; if($r['personal'] == ON) { print " [b]Name:[/b] {$r['name']} [b]Last Name:[/b] {$r['last']} [b]Age:[/b] {$r['age']} [b]City:[/b] {$r['city']} [b]Aim Of The Game:[/b] {$r['aog']} [b]MSN:[/b] {$r['msn']} [b]AIM:[/b] {$r['aim']} [b]AOL:[/b] {$r['aol']} [b]Yahoo:[/b] {$r['yahoo']} <center>[img=/GFX/layout_images/topnav.gif]</center>"; } else if($r['personal'] == OFF) { print "[b]Personal Details Off.[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($ir['userid'] == $r['userid']) { print "<center>[b]<u>Your Pokes</u>[/b]</center>"; if($ir['pokedby']!=0) { print "[b]Last Poked By:[/b] [b]{$ir['pokedby']}[/b] [url='pokeuser.php?ID={$ir[']<font color=green>[b]Poke Back[/b]</font>[/url] "; } else { print "[b]You Have Not Been Poked.[/b] "; } print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; } print "</td><td valign=top><table width=100% border=1><tr><td><center>[url='viewuser.php?action=info'][b]Info[/b][/url]</center></td> <td><center>[url='viewuser.php?action=pics'][b]Photos[/b][/url]</center></td> <td><center>[url='viewuser.php?action=wall'][b]Wall[/b][/url]</center></td> <td><center>[url='viewuser.php?action=videos'][b]Videos[/b][/url]</td> <td><center>[url='viewuser.php?action=videos'][b]Videos[/b][/url]</center></td> <td><center>[url='viewuser.php?action=links'][b]Links[/b][/url]</center></td></tr> </table> "; <?PHP switch($_GET['action']) { case 'info': viewuser_info(); break; case 'pics': viewuser_pics(); break; case 'wall': viewuser_wall(); break; case 'videos': viewuser_videos(); break; case 'links': viewuser_links(); break; default: start_new_func(); break; } function start_new_func() { global $ir,$c,$userid,$h; print "</td><td valign=top><table width=100% border=1><tr><td><center>[url='viewuser.php?action=info'][b]Info[/b][/url]</center></td> <td><center>[url='viewuser.php?action=pics'][b]Photos[/b][/url]</center></td> <td><center>[url='viewuser.php?action=wall'][b]Wall[/b][/url]</center></td> <td><center>[url='viewuser.php?action=videos'][b]Videos[/b][/url]</td> <td><center>[url='viewuser.php?action=videos'][b]Videos[/b][/url]</center></td> <td><center>[url='viewuser.php?action=links'][b]Links[/b][/url]</center></td></tr> </table> "; } function viewuser_info() { global $ir,$c,$userid,$h; print "User Info Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Info</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_pics() { global $ir,$c,$userid,$h; print "User Pics Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Pics</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_wall() { global $ir,$c,$userid,$h; print "User Wall Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Wall</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_videos() { global $ir,$c,$userid,$h; print "User Videos Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Videos</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_links() { global $ir,$c,$userid,$h; print "User Links Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Links</th></tr>"; print "<tr><td></td></tr>"; } print "</table></td></tr></table></td><td width='20%' valign=top>"; print " <center>[b]<u><font color=green>Friendly</font></u>[/b] [[url='pokeuser.php?ID={$r['][b]Poke User[/b][/url]] [[url='mailbox.php?action=compose&ID={$r['][b]Send Mail[/b][/url]] <center>[img=/GFX/layout_images/topnav.gif]</center>"; print " <center>[b]<u><font color=yellow>Financial</font></u>[/b] [[url='sendcash.php?ID={$r['][b]Send Credits[/b][/url]] [[url='sendcyber.php?ID={$r['][b]Send Cyber Cash[/b][/url]] [[url='sendpoints.php?ID={$r['][b]Send Gold Coins[/b][/url]] "; $q=mysql_query("SELECT * FROM users WHERE userid='".$r['partnered']."'",$c); $_i=mysql_fetch_array($q); if($r['partnered']!=1){ print " [<a href=\"makepartnership.php?ID={$r['userid']}\">[b]Hire Partner[/b]</a>] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } print " <center>[b]<u><font color=green>Information</font></u>[/b] [[url='hirespy.php?ID={$r['][b]Hire Spy[/b][/url]] <center>[img=/GFX/layout_images/topnav.gif]</center> <center>[b]<u><font color=red>Hostile</font></u>[/b] [[url='mug.php?ID={$r['][b]Mug Cash[/b][/url]] [[url='attack.php?ID={$r['][b]Attack[/b][/url]] [[url='driveby.php?ID={$r['][b]Drive By[/b][/url]] [[url='breakin.php?ID={$r['][b]Break In Home[/b][/url]] [[url='hackpc.php?ID={$r['][b]Hack Bank Account[/b][/url]] [[url='arson.php?ID={$r['][b]Burn Down Home[/b][/url]] [[url='assassin.php?ID={$r['][b]Assassinate[/b][/url]] <center>[img=/GFX/layout_images/topnav.gif]</center>"; $type="Proposal"; $marq=mysql_query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_userid=$userid AND it.itmtypename='$type'",$c); if(mysql_num_rows($marq) and $ir['married']!=1) { print "<center>[b]<u><font color=hotpink>Marriage</font></u>[/b] [[url='propose.php?ID={$r['][b]Propose[/b][/url]] "; print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($ir['donatordays'] > 0){ print " <center>[b]<u><font color=blue>Donator</font></u>[/b] [[url='friendslist.php?action=add&ID={$r['][b]Add Friends[/b][/url]] [[url='blacklist.php?action=add&ID={$r['][b]Add Enemies[/b][/url]] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } $qq=mysql_query("SELECT * FROM cities WHERE cityowner=$ir[userid]"); if(mysql_num_rows($qq) > 0) { print "<center>[b]<u><font color=brown>District</font></u>[/b] [[url='cityadmin.php?action=banish&ID=$r[userid]'][b]Banish[/b][/url]] "; } $r4=mysql_fetch_array($qq); if($r4['cityid'] == $r['location']) { print "[[url='cityadmin.php?action=kick&ID=$r[userid]'][b]Kick Out City[/b][/url]] "; } $qq2=mysql_query("SELECT * FROM cities WHERE cityowner=$r[userid]"); if(mysql_num_rows($qq) > 0) { $rr2=mysql_fetch_array($qq2); print "[[url='cityadmin.php?action=makeadd&ID=$r[cityid]'][b]Request Alliance[/b][/url]] "; } print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; print "</td></tr></table><center><table width='90%' border='1'><tr><td>{$r['sig']}</td></tr></table></center>"; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 4 || $ir['user_level'] == 5 || $ir['user_level'] == 6 || $ir['user_level'] == 8 || $ir['user_level'] == 10) { print "<center><table width='90%' border='1'><tr style='background:gray'><th>Admin Info</th></tr> <tr><td width='50%'>"; print "IP Address: {$r['lastip']} "; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5 || $ir['user_level'] == 6 || $ir['user_level'] == 8 || $ir['user_level'] == 10) { print "[[url='jailuser.php?userid={$r['][b]Jail[/b][/url]] [[url='admin.php?action=cstep&ID={$r['][b]Send To Court[/b][/url]] [[url='mailban.php?userid={$r['][b]MailBan[/b][/url]] [<a href=giveitems.php?userid={$r['userid']}>[b]Give Item[/b]</a>]"; } print "<form action='staffnotes.php' method='post'> Staff Notes: <textarea rows=7 cols=40 name='staffnotes'>{$r['staffnotes']}</textarea> <input type='hidden' name='ID' value='{$_GET['u']}' /> <input type='submit' value='Change' /></form>"; print "</center></td><td width='50%'></tr></table> <center>[img=/GFX/layout_images/topnav.gif]</center> </td></tr></table></center>"; } } $h->endpage(); ?>
  2. Ok have added your code, now have this error. and yes I will use the php tags for now on, sorry about that.   Parse error: syntax error, unexpected '<' in /home/ab1074/public_html/viewuser.php on line 301   <?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; include "mysql.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(); $h->startheaders(); $fm=money_formatter($ir['money']); $cm=money_formatter($ir['crystals'],''); $lv=date('F j, Y, g:i a',$ir['laston']); $kaperc=(int) ($ir['karma']/$ir['maxkarma']*100); $kaopp=100-$kaperc; $h->userdata($ir,$lv,$fm,$cm); $h->menuarea(); print "<table width='100%'><tr><td valign='left' width='90%'><h3>User {$r['username']}'s Profile</h3></td><td valign='left' width='10%'>[url='walkthrough.php#viewuser'][img=/GFX/layout_images/help.gif][/url]</td></tr></table> <center>[img=/GFX/layout_images/topnav.gif]</center> "; $_GET['u'] = abs((int) $_GET['u']); if(!$_GET['u']) { print "<center>[b]Invalid Use Of File.[/b]</center>"; } else { $q=mysql_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']}",$c); if(mysql_num_rows($q) == 0) { print "<center>[b]Sorry, We Could Not Find A User With That ID, Check Your Source.[/b]</center>"; } else { $r=mysql_fetch_array($q); if($r['gympass'] == 0) { $gym="<font color=red>No</font>"; } else if($r['gympass'] == 1) { $gym="<font color=green>Yes</font>";} 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 if($r['user_level']==4) { $userl="Moderator"; } else if($r['user_level']==5) { $userl="Assistant"; } else if($r['user_level'] == 6) { $userl="Watcher"; } else if($r['user_level'] == 7) { $userl="GFX"; } else if($r['user_level'] == 8) { $userl="I.A Officer"; } else if($r['user_level'] == 9) { $userl="Sales"; } else { $userl="Helper"; } $lon=date('F j, Y g:i:s a',$r['laston']); $sup=date('F j, Y g:i:s a',$r['signedup']); $ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ']; $d=""; $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"; } } $d=""; if($r['donatordays']) { $r['username'] = "<font color=darkblue>[b]{$r['username']}[/b]</font>";$d="[img=/GFX/layout_images/donator.gif]"; } $vp=""; if($r['vipdays']) { $r['username'] = "<font color=darkred>[b]{$r['username']}[/b]</font>";$vp="[img=GFX/layout_images/vip.gif]"; } $ww1=""; if($r['wknd_1_hours']) { $r['username'] = "<font color=red>[b]{$r['username']}[/b]</font>";$ww1="[img=GFX/layout_images/ww1.gif]"; } $ww2=""; if($r['wknd_2_hours']) { $r['username'] = "<font color=red>[b]{$r['username']}[/b]</font>";$ww2="[img=GFX/layout_images/ww2.gif]"; } $ww3=""; if($r['wknd_3_hours']) { $r['username'] = "<font color=red>[b]{$r['username']}[/b]</font>";$ww3="[img=GFX/layout_images/ww3.gif]"; } if($r['laston'] >= time()-15*60) { $on="<font color=green>[b]Online[/b]</font>"; } else { $on="<font color=red>[b]Offline[/b]</font>"; } print "<center><table width=90% border=1><tr><td>[b]<font size='3'>{$r['username']} $d $vp $ww1 $ww2 $ww3</font> {$r['conscious']}[/b]"; if($ir['userid'] == $r['userid']){ print" [[url='preferences.php?action=consciouschange'][b]Change[/b][/url]]"; } print "</table> <center><table width=90% border='1'><tr><td width='25%'>"; if($r['display_pic'] == '' AND $r['gender'] =='Female') { print "<center>[img=GFX/layout_images/female.gif]</center>"; } else if($r['display_pic'] == '' AND $r['gender'] =='Male') { print "<center>[img=GFX/layout_images/male.gif]</center>"; } else if($r['display_pic'] == '' AND $r['gender'] =='Private') { print "<center>[img=GFX/layout_images/anonomous.gif]</center>"; } else if($r['display_pic']) { print "<center>[img={$r[]</center>"; } print "<center><img src=/GFX/layout_images/karmadevil.gif width=16 height=16 title='Evil Karma'><img src=/GFX/bars/barred.gif width=$kaopp height=7><img src=/GFX/bars/barblue.gif width=$kaperc height=7><img src=/GFX/layout_images/karmaangel.gif width=16 height=16 title='Good Karma'></center>"; print "<center><a href=rating.php?change=up&ID={$r['userid']}><img src=positive.gif></a> {$r['rating']} <a href=rating.php?change=down&ID={$r['userid']}><img src=negative.gif></a></center>"; if($r['profileintro']) { print "<center></center>"; } else { print "<center>[b]This User Has No Intro Music[/b]</center>"; } print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; if($r['fedjail']) { print "[b]<font color=red>In Anarchy Asylum For {$r['fed_days']} Day(s). </font>[b]For:[/b]<font color=red> {$r['fed_reason']}</font> <center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($r['hospital']) { print "[b]<font color=red>In Clinic For {$r['hospital']} Minutes. </font>[b]For:[/b]<font color=red> {$r['hospreason']}</font>[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($r['jail']) { print "[b]<font color=red>In Grinder For {$r['jail']} Minutes. </font>[b]For:[/b]<font color=red> {$r['jailreason']}</font>[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($r['trials'] > 0) { print "[b]<font color=blue>User Has Been Put On Trial {$r['trials']} Time(s).</font>[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } print " [b]User ID:[/b] {$r['userid']} [b]Online Status:[/b] $on [b]User Level:[/b] $userl [b]Duties:[/b] {$r['duties']} [b]User Game Level:[/b] {$r['level']} [b]Signed Up:[/b] $sup [b]Days Old:[/b] {$r['daysold']} Days Old [b]Last Active:[/b] $lon [b]Last Action:[/b] $la $unit ago [b]Last Poked By:[/b] User {$r['pokedby']} "; $w=mysql_query("SELECT * FROM warnings WHERE user={$r['userid']}",$c); print " [b]Warnings:[/b]<font color=red> ".mysql_num_rows($w)." </font>"; if($ir['user_level'] > 1) { print "[<a href=warnings.php?action=index&user={$r['userid']}>[b]Manage[/b]</a>] "; } print "[b]Referrals:[/b] "; $rr=mysql_query("SELECT * FROM referals WHERE refREFER={$r['userid']}",$c); print mysql_num_rows($rr); $qqq=mysql_query("SELECT * FROM userbodytype WHERE userid=$userid",$c); $ub=mysql_fetch_array($qqq); print " <center>[img=/GFX/layout_images/topnav.gif]</center>"; $q_y=mysql_query("SELECT * FROM friendslist WHERE fl_ADDED={$r['userid']}",$c); $q_z=mysql_query("SELECT * FROM blacklist WHERE bl_ADDED={$r['userid']}",$c); print " [b]Health:[/b] {$r['hp']}/{$r['maxhp']} [b]Gender:[/b] {$r['gender']} [b]User Body Type:[/b] {$ub['bodytype']} [b]Bodytype Days Old:[/b] "; if($r['stds']) { print "[b]Diseased:[/b] <font color=red>Has A STD</font> "; } print " [b]District:[/b] [[url='hirespy.php?ID={$r['][b]Hire Spy[/b][/url]] [b]Property:[/b] {$r['hNAME']} "; $wo2=mysql_query("SELECT * From petowned WHERE userid={$_GET['u']}",$c); $ow2=mysql_fetch_array($wo2); $pe2=mysql_query("SELECT * FROM userpets WHERE userid={$_GET['u']}",$c) or die(mysql_error()); $pet2=mysql_fetch_array($pe2); if ($ow2['petowned'] == 0) { print "[b]Pet Owned:[/b] <font color='red'>[b]No[/b]</font> "; } else if ($ir['petowned'] == 1) { print "[b]Pet Owned:[/b] [url='petview.php?u={$pet2['][b]{$pet2['petname']}[/b][/url] "; } else { print "[b]Pet Owned:[/b] <font color=green>{$pet2['petname']}</font> "; } print "[b]Country:[/b] "; if(preg_match("/png/",$r['country'])) { print "[img=/GFX/flags/00.png] "; } else { print "[img=/GFX/flags/{$r[country]}.png] "; } print "[b]Faction:[/b] "; if($r['gang']) { print "[url='gangs.php?action=view&ID={$r['][b]{$r['gangNAME']}[/b][/url] "; } else { print "[b]N/A[/b] "; } print " [b]Friends:[/b] ".mysql_num_rows($q_y)." [b]Enemies:[/b] ".mysql_num_rows($q_z)." [b]Gym access:[/b] [b]$gym[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; print " [b]Credits:[/b] \${$r['money']} [b]Liberty Pieces:[/b] {$r['libpieces']} [b]Gold Coins:[/b] {$r['crystals']} "; print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; print " [b]Battling Wins:[/b] {$r['wontimes_dc']} "; if($r['won']) { print "[b]Last Won:[/b] [b][url='viewuser.php?u={$r[']<font color='green'>{$r['username']} [{$r['won']}][/url]</font>[/b] "; } else { print "[b]Last Won:[/b] [b]<font color='green'>N/A</font>[/b] "; } if($r['lost']) { print "[b]Last Lost:[/b] [b][url='viewuser.php?u={$r[']<font color='red'>{$r['username']} [{$r['lost']}]</font>[/url][/b] "; } else { print "[b]Last Lost:[/b] [b]<font color='red'>N/A</font>[/b] "; } print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; print " [b]Been Busted Out:[/b] {$r['getbust']} Time(s) [b]Busted Out:[/b] {$r['bust']} Time(s) [b]Bust Failures:[/b] {$r['bustfail']} Attempt(s) [b]Been Breaked Out:[/b] {$r['getbreak']} Time(s) [b]Breaked Out:[/b] {$r['break']} Users [b]GTA Attempts:[/b] {$r['gtas']} Time(s) [b]GTA Success:[/b] {$r['gtasus']} Time(s) <center>[img=/GFX/layout_images/topnav.gif]</center>"; if($r['married'] == 1) { $marryq=mysql_query("SELECT * FROM `marriages` WHERE (`marriage_from` = '$r[userid]') OR (`marriage_to` = '$r[userid]')",$c); $mr=mysql_fetch_array($marryq); if($mr['marriage_from'] == $userid) { $from=2; $themid=$mr['marriage_to']; } else { $from=1; $themid=$mr['marriage_from']; } if($from == 1) { $uq=mysql_query("SELECT * FROM users WHERE userid='$mr[marriage_to]'",$c); } else { $uq=mysql_query("SELECT * FROM users WHERE userid='$mr[marriage_from]'",$c); } $marr=mysql_fetch_array($uq); $married="[url='viewuser.php?u=$themid'][b]".$marr['username']."[/b][/url]"; $marriagetxt=" ([url='marriageinfo.php?ID=$themid'][b]Info[/b][/url])"; } else { $married="<font color=red>[b]No[/b]</font>"; $marriagetxt=""; } print "[b]Married:[/b] $married$marriagetxt [b]Married:[/b] [b]".number_format($r['married_times'])." Time(s).[/b] [b]Partnered:[/b]"; $q=mysql_query("SELECT * FROM users WHERE userid='".$r['partnered']."'",$c); $_i=mysql_fetch_array($q); if($r['partnered']!=0){ echo "<font color=green> [b]YES[/b] </font> [b]Partnered To:[/b] [b][url='viewuser.php?u={$_i[']{$_i['username']}[/b][/url] "; $q=mysql_query("SELECT * FROM users WHERE userid='".$r['partnered']."'",$c); $_i=mysql_fetch_array($q); }else{ echo "<font color=red>[b] NO [/b]</font> "; } print " [b]Partnered:[/b] [b]{$r['partnered_times']} Time(s).[/b] "; print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; if($r['personal'] == ON) { print " [b]Name:[/b] {$r['name']} [b]Last Name:[/b] {$r['last']} [b]Age:[/b] {$r['age']} [b]City:[/b] {$r['city']} [b]Aim Of The Game:[/b] {$r['aog']} [b]MSN:[/b] {$r['msn']} [b]AIM:[/b] {$r['aim']} [b]AOL:[/b] {$r['aol']} [b]Yahoo:[/b] {$r['yahoo']} <center>[img=/GFX/layout_images/topnav.gif]</center>"; } else if($r['personal'] == OFF) { print "[b]Personal Details Off.[/b] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($ir['userid'] == $r['userid']) { print "<center>[b]<u>Your Pokes</u>[/b]</center>"; if($ir['pokedby']!=0) { print "[b]Last Poked By:[/b] [b]{$ir['pokedby']}[/b] [url='pokeuser.php?ID={$ir[']<font color=green>[b]Poke Back[/b]</font>[/url] "; } else { print "[b]You Have Not Been Poked.[/b] "; } print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; } print "</td><td valign=top><table width=100% border=1><tr><td><center>[url='viewuser.php?action=info'][b]Info[/b][/url]</center></td> <td><center>[url='viewuser.php?action=pics'][b]Photos[/b][/url]</center></td> <td><center>[url='viewuser.php?action=wall'][b]Wall[/b][/url]</center></td> <td><center>[url='viewuser.php?action=videos'][b]Videos[/b][/url]</td> <td><center>[url='viewuser.php?action=videos'][b]Videos[/b][/url]</center></td> <td><center>[url='viewuser.php?action=links'][b]Links[/b][/url]</center></td></tr> </table> "; <?PHP switch($_GET['action']) { case 'info': viewuser_info(); break; case 'pics': viewuser_pics(); break; case 'wall': viewuser_wall(); break; case 'videos': viewuser_videos(); break; case 'links': viewuser_links(); break; default: start_new_func(); break; } function start_new_func() { global $ir,$c,$userid,$h; print "</td><td valign=top><table width=100% border=1><tr><td><center>[url='viewuser.php?action=info'][b]Info[/b][/url]</center></td> <td><center>[url='viewuser.php?action=pics'][b]Photos[/b][/url]</center></td> <td><center>[url='viewuser.php?action=wall'][b]Wall[/b][/url]</center></td> <td><center>[url='viewuser.php?action=videos'][b]Videos[/b][/url]</td> <td><center>[url='viewuser.php?action=videos'][b]Videos[/b][/url]</center></td> <td><center>[url='viewuser.php?action=links'][b]Links[/b][/url]</center></td></tr> </table> "; } function viewuser_info() { global $ir,$c,$userid,$h; print "User Info Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Info</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_pics() { global $ir,$c,$userid,$h; print "User Pics Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Pics</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_wall() { global $ir,$c,$userid,$h; print "User Wall Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Wall</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_videos() { global $ir,$c,$userid,$h; print "User Videos Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Videos</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_links() { global $ir,$c,$userid,$h; print "User Links Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Links</th></tr>"; print "<tr><td></td></tr>"; } print "</table></td></tr></table></td><td width='20%' valign=top>"; print " <center>[b]<u><font color=green>Friendly</font></u>[/b] [[url='pokeuser.php?ID={$r['][b]Poke User[/b][/url]] [[url='mailbox.php?action=compose&ID={$r['][b]Send Mail[/b][/url]] <center>[img=/GFX/layout_images/topnav.gif]</center>"; print " <center>[b]<u><font color=yellow>Financial</font></u>[/b] [[url='sendcash.php?ID={$r['][b]Send Credits[/b][/url]] [[url='sendcyber.php?ID={$r['][b]Send Cyber Cash[/b][/url]] [[url='sendpoints.php?ID={$r['][b]Send Gold Coins[/b][/url]] "; $q=mysql_query("SELECT * FROM users WHERE userid='".$r['partnered']."'",$c); $_i=mysql_fetch_array($q); if($r['partnered']!=1){ print " [<a href=\"makepartnership.php?ID={$r['userid']}\">[b]Hire Partner[/b]</a>] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } print " <center>[b]<u><font color=green>Information</font></u>[/b] [[url='hirespy.php?ID={$r['][b]Hire Spy[/b][/url]] <center>[img=/GFX/layout_images/topnav.gif]</center> <center>[b]<u><font color=red>Hostile</font></u>[/b] [[url='mug.php?ID={$r['][b]Mug Cash[/b][/url]] [[url='attack.php?ID={$r['][b]Attack[/b][/url]] [[url='driveby.php?ID={$r['][b]Drive By[/b][/url]] [[url='breakin.php?ID={$r['][b]Break In Home[/b][/url]] [[url='hackpc.php?ID={$r['][b]Hack Bank Account[/b][/url]] [[url='arson.php?ID={$r['][b]Burn Down Home[/b][/url]] [[url='assassin.php?ID={$r['][b]Assassinate[/b][/url]] <center>[img=/GFX/layout_images/topnav.gif]</center>"; $type="Proposal"; $marq=mysql_query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_userid=$userid AND it.itmtypename='$type'",$c); if(mysql_num_rows($marq) and $ir['married']!=1) { print "<center>[b]<u><font color=hotpink>Marriage</font></u>[/b] [[url='propose.php?ID={$r['][b]Propose[/b][/url]] "; print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; } if($ir['donatordays'] > 0){ print " <center>[b]<u><font color=blue>Donator</font></u>[/b] [[url='friendslist.php?action=add&ID={$r['][b]Add Friends[/b][/url]] [[url='blacklist.php?action=add&ID={$r['][b]Add Enemies[/b][/url]] <center>[img=/GFX/layout_images/topnav.gif]</center>"; } $qq=mysql_query("SELECT * FROM cities WHERE cityowner=$ir[userid]"); if(mysql_num_rows($qq) > 0) { print "<center>[b]<u><font color=brown>District</font></u>[/b] [[url='cityadmin.php?action=banish&ID=$r[userid]'][b]Banish[/b][/url]] "; } $r4=mysql_fetch_array($qq); if($r4['cityid'] == $r['location']) { print "[[url='cityadmin.php?action=kick&ID=$r[userid]'][b]Kick Out City[/b][/url]] "; } $qq2=mysql_query("SELECT * FROM cities WHERE cityowner=$r[userid]"); if(mysql_num_rows($qq) > 0) { $rr2=mysql_fetch_array($qq2); print "[[url='cityadmin.php?action=makeadd&ID=$r[cityid]'][b]Request Alliance[/b][/url]] "; } print "<center>[img=/GFX/layout_images/topnav.gif]</center>"; print "</td></tr></table><center><table width='90%' border='1'><tr><td>{$r['sig']}</td></tr></table></center>"; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 4 || $ir['user_level'] == 5 || $ir['user_level'] == 6 || $ir['user_level'] == 8 || $ir['user_level'] == 10) { print "<center><table width='90%' border='1'><tr style='background:gray'><th>Admin Info</th></tr> <tr><td width='50%'>"; print "IP Address: {$r['lastip']} "; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5 || $ir['user_level'] == 6 || $ir['user_level'] == 8 || $ir['user_level'] == 10) { print "[[url='jailuser.php?userid={$r['][b]Jail[/b][/url]] [[url='admin.php?action=cstep&ID={$r['][b]Send To Court[/b][/url]] [[url='mailban.php?userid={$r['][b]MailBan[/b][/url]] [<a href=giveitems.php?userid={$r['userid']}>[b]Give Item[/b]</a>]"; } print "<form action='staffnotes.php' method='post'> Staff Notes: <textarea rows=7 cols=40 name='staffnotes'>{$r['staffnotes']}</textarea> <input type='hidden' name='ID' value='{$_GET['u']}' /> <input type='submit' value='Change' /></form>"; print "</center></td><td width='50%'></tr></table> <center>[img=/GFX/layout_images/topnav.gif]</center> </td></tr></table></center>"; } } $h->endpage(); ?>
  3. I do not understand what you mean. This is not in preferences. Deleted to make thread shorter, see below for updated code.
  4. This is what my friend has done in my code. So this is the part of the page where I am trying to have this function show, maybe its all totally wrong, but i dont know as it was a friend who did this for me, then bailed without fixing the errors. could you guys pls help me get this working properly, ty a big one. :thumbsup: print "</td><td valign=top><table width=100% border=1><tr><td><center>Info</center></td> <td><center>Photos</center></td> <td><center>Wall</center></td> <td><center>Videos</td> <td><center>Videos</center></td> <td><center>Links</center></td></tr> </table> "; switch($_GET['action']) { case 'info': viewuser_info(); break; case 'pics': viewuser_pics(); break; case 'wall': viewuser_wall(); break; case 'videos': viewuser_videos(); break; case 'links': viewuser_links(); break; default: viewuser_info(); break; } function viewuser_info() { global $ir,$c,$userid,$h; print "User Info Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Info</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_pics() { global $ir,$c,$userid,$h; print "User Pics Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Pics</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_wall() { global $ir,$c,$userid,$h; print "User Wall Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Wall</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_videos() { global $ir,$c,$userid,$h; print "User Videos Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Videos</th></tr>"; print "<tr><td></td></tr>"; } function viewuser_links() { global $ir,$c,$userid,$h; print "User Links Stuff Here. <table width=100% border=1><tr style='background:gray'><th>User Links</th></tr>"; print "<tr><td></td></tr>"; } print "</table></td></tr></table></td><td width='20%' valign=top>";
  5. Fatal error: Call to undefined function viewuser_info() in /home/ab1074/public_html/viewuser.php on line 330 I am trying to make a wall area in my profile area, But now am getting this error. I am a beginner coder so don't laugh at me, or laugh, but dont judge me on my noobness. 8)
  6. When I run my page I get this print out. -1 affected rows during this query. also my weather is not updating correctly. The time remaining stays at 0 always, And it is always raining, I think ive seen it snowing once so it may change the weather but not the time remaining. Pls help me get this working as it is a major thing in my game. thnx /// Weather Starts Here /// mysql_query("UPDATE weather_status SET remaining_minutes=remaining_minutes-1 WHERE remaining_minutes>0",$c); $wi=mysql_query("SELECT ws.*,w.* FROM weather_status ws LEFT JOIN weathers w ON ws.weather=w.w_id LIMIT 1;",$c); $w=mysql_fetch_array($wi); if($w['remaining_minutes'] == 0) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY rand() LIMIT 1;",$c)); $chance=rand(1,$weather['w_chance']*20); if($weather['w_chance'] < $chance) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY rand() LIMIT 1;",$c)); } $chance=rand(1,$weather['w_chance']*20); if($weather['w_chance'] < $chance) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY w_chance DESC LIMIT 1;",$c)); } $w2c=$weather['w_id']; mysql_query("UPDATE weather_status SET weather={$w2c} LIMIT 1;",$c); mysql_query("UPDATE weather_status SET remaining_minutes=rand(1,60) WHERE remaining_minutes=0",$c); } print mysql_affected_rows($c)." affected rows during this query. "; /// Weather Ends Here /// also in my header. I put my mouse over the weather icon and it says for next 0 minutes. so it is not showing the type of weathers name. $ws=mysql_query("SELECT * FROM weather_status",$c); $rws=mysql_fetch_array($ws); $tws=mysql_query("SELECT * FROM weathers",$c); $fws=mysql_fetch_array($tws); echo "<td valign='right' width='60'> ?(
  7. Thank you. I believe it works now. There is no error. when i run the page i get this. User has been notified. I appreciate all the help I have been getting from you guys. Admin pls delete this thread now.
  8. New error lol, I dont know what version it is. My friend tuned the crap out of the engine. User has been notified! Fatal error: Call to a member function query() on a non-object on line 176   your line: $newcq = $db->query('SELECT * FROM`cities`');
  9. Ok i replaced the line with yours and now I am getting this error. User has been notified! Error Executing Query 1 for updating users to Query was empty Error Code:1065
  10. I am getting a this error about 50 times. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource on line 180 172 $q=mysql_query("SELECT * FROM `users` WHERE `location` = '$r[cityid]'"); 173 $pricepay=mysql_fetch_array($q)*$r['citytaxprice']; 174 mysql_query("UPDATE users SET money=money+$pricepay WHERE userid=$r[cityowner]"); 175 } 176 $newcq=mysql_query("SELECT * FROM`cities`"); 177 while($newr=mysql_fetch_array($newcq)) 178 { 179 $daf=mysql_query("SELECT * FROM `users` WHERE `location` = '$newr[cityid]"); 180 if(mysql_num_rows($daf) > $newr['citymost']) 181 { 182 $rowstoupdate=mysql_num_rows($daf); 183 mysql_query("UPDATE cities SET citymost=$rowstoupdate WHERE cityid=$r[cityid]"); 184 mysql_query($query,$c) or die("\nError Executing Query 1 for updating users $i to $next\n$query\n".mysql_error()."\nError Code:".mysql_errno()); 185 }
  11. Weather Is Not Updating/Changing.   Code... /// Weather Starts Here /// $wi=mysql_query("SELECT ws.*,w.* FROM weather_status ws LEFT JOIN weathers w ON ws.weather=w.w_id LIMIT 1;",$c); $w=mysql_fetch_array($wi); if($w['remaining_minutes'] == 0) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY rand() LIMIT 1;",$c)); $chance=rand(1,$weather['w_chance']*20); if($weather['w_chance'] < $chance) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY rand() LIMIT 1;",$c)); } $chance=rand(1,$weather['w_chance']*20); if($weather['w_chance'] < $chance) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY w_chance DESC LIMIT 1;",$c)); } $w2c=$weather['w_id']; mysql_query("UPDATE weather_status SET weather={$w2c} LIMIT 1;",$c); mysql_query("UPDATE weather_status SET remaining_minutes=rand(1,60)",$c); } } print mysql_affected_rows($c)." affected rows during this query. "; /// Weather Ends Here ///   Also I do not see where it would update the remaining minutes for the new weather status. Should it be entering a random minutes remaining when the weather changes? And should this weather code be in the 1 minute cron instead of the 1 hour cron?   I get this print out when i run this code. -1 affected rows during this query.
  12. Third Error. Weather And Rehab Is Not Updating/Changing. Code... /// Rehab Starts Here /// $q = mysql_query("SELECT * FROM drug",$c); while($r=mysql_fetch_array($q)) { $q2 = mysql_query("SELECT * FROM users WHERE userid = '{$r['user']}'",$c); $r2=mysql_fetch_array($q2); if($r2['hospital'] > 0 and $r2['rehab'] > 0) { mysql_query("DELETE FROM drug WHERE user = '{$r2['userid']}'",$c); } /// Rehab Ends Here /// /// Weather Starts Here /// $wi=mysql_query("SELECT ws.*,w.* FROM weather_status ws LEFT JOIN weathers w ON ws.weather=w.w_id LIMIT 1;",$c); $w=mysql_fetch_array($wi); if($w['remaining_minutes'] == 0) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY rand() LIMIT 1;",$c)); $chance=rand(1,$weather['w_chance']*20); if($weather['w_chance'] < $chance) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY rand() LIMIT 1;",$c)); } $chance=rand(1,$weather['w_chance']*20); if($weather['w_chance'] < $chance) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY w_chance DESC LIMIT 1;",$c)); } $w2c=$weather['w_id']; mysql_query("UPDATE weather_status SET weather={$w2c} LIMIT 1;",$c); mysql_query("UPDATE weather_status SET remaining_minutes=rand(1,60)",$c); } } print mysql_affected_rows($c)." affected rows during this query. "; /// Weather Ends Here /// Also I do not see where it would update the remaining minutes for the new weather status. Should it be entering a random minutes remaining when the weather changes? And should this weather code be in the 1 minute cron instead of the 1 hour cron? I get this print out when i run this code. -1 affected rows during this query.
  13. Thank you, I did not even see that. Point for you. :)
  14. Second Error. The weather is not changing. Please help me...   <?php include "mysql.php"; global $c; /// Word War Packs Starts Here /// mysql_query("UPDATE users SET wknd_1_hours=wknd_1_hours-1 WHERE wknd_1_hours > 0",$c); mysql_query("UPDATE users SET wknd_2_hours=wknd_2_hours-1 WHERE wknd_2_hours > 0",$c); mysql_query("UPDATE users SET wknd_3_hours=wknd_3_hours-1 WHERE wknd_3_hours > 0",$c); /// World War Packs End Here /// /// Rehab Starts Here /// $q = mysql_query("SELECT * FROM `drug`",$c); while($r=mysql_fetch_array($q)) { $q2 = mysql_query("SELECT * FROM `users` WHERE `userid` = '{$r['user']}'",$c); $r2=mysql_fetch_array($q2); if($r2['hospital'] > 0 and $r2['rehab'] > 0) { mysql_query("DELETE FROM `drug` WHERE `user` = '{$r2['userid']}'",$c); } /// Rehab Ends Here /// /// Weather Starts Here /// $wi=mysql_query("SELECT ws.*,w.* FROM weather_status ws LEFT JOIN weathers w ON ws.weather=w.w_id LIMIT 1;",$c); $w=mysql_fetch_array($wi); if($w['remaining_minutes'] == 0) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY rand() LIMIT 1;",$c)); $chance=rand(1,$weather['w_chance']*20); if($weather['w_chance'] < $chance) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY rand() LIMIT 1;",$c)); } $chance=rand(1,$weather['w_chance']*20); if($weather['w_chance'] < $chance) { $weather=mysql_fetch_array(mysql_query("SELECT * FROM weathers ORDER BY w_chance DESC LIMIT 1;",$c)); } $w2c=$weather['w_id']; mysql_query("UPDATE weather_status SET weather={$w2c} LIMIT 1;",$c); } } print mysql_affected_rows($c)." affected rows during this query. "; /// Weather Ends Here /// /// Hunger Starts here /// mysql_query("UPDATE users SET hunger=hunger+(maxhunger/72) WHERE hunger < maxhunger AND donatordays = 0 AND wknd_1_hours = 0 AND wknd_2_hours = 0 AND wknd_3_hours = 0",$c); mysql_query("UPDATE users SET hunger=hunger+(maxhunger/96) WHERE hunger < maxhunger AND donatordays > 0",$c); mysql_query("UPDATE users SET hunger=hunger+(maxhunger/120) WHERE hunger < maxhunger AND wknd_1_hours > 0",$c); mysql_query("UPDATE users SET hunger=hunger+(maxhunger/144) WHERE hunger < maxhunger AND wknd_2_hours > 0",$c); mysql_query("UPDATE users SET hunger=hunger+(maxhunger/144) WHERE hunger < maxhunger AND wknd_3_hours > 0",$c); mysql_query("UPDATE users,userbodytype SET users.hunger=users.hunger+(users.maxhunger/24) WHERE users.hunger < users.maxhunger AND users.userid=userbodytype.userid AND userbodytype.vampire = 1",$c); mysql_query("UPDATE users SET bodyfat=bodyfat-1 WHERE hunger > maxhunger",$c); mysql_query("UPDATE users SET hospital='120' hospreason='Suffering From Starvation' WHERE bodyfat = -6",$c); mysql_query("UPDATE users SET hunger=0 WHERE bodyfat = -6",$c); mysql_query("UPDATE users SET bodyfat=0 WHERE bodyfat = -6",$c); mysql_query("UPDATE users SET hunger=maxhunger WHERE hunger > maxhunger",$c); /// Hunger Ends Here /// ?>
  15. Yayyy. Thank You So Much. The Error Is Gone. :)
  16. /// Validation Starts Here /// mysql_query("UPDATE users SET validated=validated-1 WHERE validated>0",$c); mysql_query("UPDATE users SET validated=0 WHERE validated<0",$c); *24* mysql_query("UPDATE users SET fedjail=1 WHERE screwups>4",$c); *25* mysql_query("INSERT INTO fedjail VALUES('',$r['userid'],5,1,'Failed To Validate Account Randomly') WHERE $r['screwups']>4",$c); mysql_query("UPDATE users SET screwups=0 WHERE screwups>4",$c); /// Validation Ends Here ///
  17. First Error First Error.       Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING on line 25 Line 25: mysql_query("INSERT INTO fedjail VALUES('',$r['userid'],5,1,'Failed To Validate Account Randomly') WHERE $r['screwups']>4",$c);   If you can also tell me what i did wrong it may help future T String errors from occurring thanks.
  18. Hello, My Name Is Michael C. I Am From Canada And Am New To This Amazing Forum And Coding. I Am A Beginner PHP Programmer And Would Appreciate All The Help With My Errors As I Can Get. The highest point holder when the errors are all fixed will get a very amazing award. ConflictChaos.com 1 Point StreetSyndicate 1 Point
×
×
  • Create New...