
VegasKiller
Members-
Posts
72 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Everything posted by VegasKiller
-
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(); ?>
-
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(); ?>
-
I do not understand what you mean. This is not in preferences. Deleted to make thread shorter, see below for updated code.
-
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>";
-
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)
-
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'> ?(
-
Getting An Not A Vaid MYSQL Error, Please Help
VegasKiller replied to VegasKiller's topic in Modification Support
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. -
Getting An Not A Vaid MYSQL Error, Please Help
VegasKiller replied to VegasKiller's topic in Modification Support
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`'); -
Getting An Not A Vaid MYSQL Error, Please Help
VegasKiller replied to VegasKiller's topic in Modification Support
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 -
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 }
-
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.
-
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.
-
Thank you, I did not even see that. Point for you. :)
-
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 /// ?>
-
Yayyy. Thank You So Much. The Error Is Gone. :)
-
/// 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 ///
-
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.
-
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