Help again :P

bladewolf2010 · June 3, 2010

Warning:  mysql_num_rows(): supplied argument is not a valid  MySQL result resource in /home/rainofhe/public_html/mainmenu.php  on line 68

64-75

print "
<tr><td>[url='newspaper.php']Newspaper[/url]</td></tr>
<tr><td>[url='search.php']Search[/url]</td></tr>";
$qq=mysql_query("SELECT * FROM cities1 WHERE cityowner1=$ir[userid1]");
if(mysql_num_rows($qq) > 0)
{
print "[url='cityadmin.php']City Admin Panel[/url]
";
}
if(!$ir['jail'] && $ir['gang'])
{
 print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>";
}

Zero-Affect · June 3, 2010

$qq=mysql_query("SELECT * FROM cities1 WHERE cityowner1={$ir[userid1]}");

bladewolf2010 · June 3, 2010

same error

Warning:  mysql_num_rows(): supplied argument is not a valid  MySQL result resource in /home/rainofhe/public_html/mainmenu.php  on line 68

Zero-Affect · June 3, 2010

   print "
	<tr>
<td>[url='newspaper.php']Newspaper[/url]</td>
	</tr>
	<tr>
<td>[url='search.php']Search[/url]</td>
	</tr>
  ";
$qq = mysql_query("SELECT * FROM cities1 WHERE cityowner1={$ir['userid1']}"); // curious is it supposed to be userid1?
if ( mysql_num_rows($qq) > 0) {
  print "[url='cityadmin.php']City Admin Panel[/url]
";
}
if(!$ir['jail'] && $ir['gang']) {
 print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>";
}

MDK666 · June 3, 2010

crimegame has it right but as the topic title says its for mc2

print "<tr><td>[url='newspaper.php']Newspaper[/url]</td></tr>
<tr><td>[url='search.php']Search[/url]</td></tr>";

$qq=$db->query("SELECT * FROM cities1 WHERE cityowner1={$ir['userid1']}");  //userid1 might be a seperate table to test the mod.
if($db->num_rows($qq) >0)
{
print "[url='cityadmin.php']City Admin Panel[/url]
";
}
if(!$ir['jail'] && $ir['gang'])
{
print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>";

that might work well it should as its converted to mc2 so if theres any errors let us know and well go over it.

bladewolf2010 · June 3, 2010

Parse error:  syntax error, unexpected $end in /home/rainofhe/public_html/mainmenu.php  on line 87

line 87

?>

MDK666 · June 3, 2010

yea it should work as a unexpected end means you dont have ?> in it, if it still gives you errors post the full script and ill go over it for u

bladewolf2010 · June 3, 2010

<?php
/**
* Layout made by: Shaved92bravada Idea came from another post on CE
* Rest of code is just standard V2 MCcodes
* Made as a free mod so it is not to be sold.
*/
global $db,$c,$ir, $set;
$hc=$set['hospital_count'];
$jc=$set['jail_count'];
$ec=$ir['new_events'];
$mc=$ir['new_mail'];
if($ir['hospital'])
{
 print "<table width=145 class=menu><th>Main</th><tr><td>
 [url='hospital.php']Hospital ($hc)[/url]</td></tr>
 <tr><td>[url='inventory.php']Inventory[/url]</td></tr>";
}
elseif($ir['jail'])
{
 print "<table width=145 class=menu><th>Main</th><tr><td>
 [url='jail.php']Jail ($jc)[/url]</td></tr>
 <tr><td>[url='inventory.php']Inventory[/url]</td></tr>";
}
else
{
 print "<table width=145 class=menu><th>Main</th><tr><td>
 [url='index.php']Home[/url]</td></tr>
 <tr><td>[url='streets.php']Explore Streets<font color='red'><blink>(new)</blink></font>[/url]</td></tr>
 <tr><td>[url='inventory.php']Inventory[/url]</td></tr>";
}
if($ec > 0) { print "<tr><td>[url='events.php']Events ($ec)[/url]</td></tr>"; }
else { print "<tr><td>[url='events.php']Events (0)[/url]</td></tr>"; }
if($mc > 0) { print "<tr><td>[url='mailbox.php']Mailbox ($mc)<image src='mail.jpg'>[/url]</td></tr>"; }
else { print "<tr><td>[url='mailbox.php']Mailbox (0)[/url]</td></tr>"; }
if($ir['jail'] and !$ir['hospital'])
{
 print "<tr><td>[url='gym.php']Jail Gym[/url]</td></tr>
 <tr><td>[url='hospital.php']Hospital ($hc)[/url]</td></tr>";
}
else if (!$ir['hospital'])
{
 print "<tr><td>[url='explore.php']Explore[/url]</td></tr>
 <tr><td>[url='gym.php']Gym[/url]</td></tr>
 <tr><td>[url='criminal.php']Crimes[/url]</td></tr>
 <tr><td>[url='job.php']Your Job[/url]</td></tr>
 <tr><td>[url='education.php']Local School[/url]</td></tr>
 <tr><td>[url='hospital.php']Hospital ($hc)[/url]</td></tr>
 <tr><td>[url='jail.php']Jail ($jc)[/url]</td></tr>";
}
else
{
 print "<tr><td>[url='jail.php']Jail ($jc)[/url]</td></tr>";
}
print "<tr><td>[url='/forums']Forums[/url]</td></tr>";
if($ir['new_announcements'])
{
print "<tr><td>[url='announcements.php']Announcements ({$ir['new_announcements']})[/url]</td></tr>";
}
else
{
print "<tr><td>[url='announcements.php']Announcements (0)[/url]</td></tr>";
}
print "<tr><td>[url='newspaper.php']Newspaper[/url]</td></tr>
<tr><td>[url='search.php']Search[/url]</td></tr>";

$qq=$db->query("SELECT * FROM cities1 WHERE cityowner1={$ir['userid1']}");  //userid1 might be a seperate table to test the mod.
if($db->num_rows($qq) >0)
{
print "[url='cityadmin.php']City Admin Panel[/url]
";
}
if(!$ir['jail'] && $ir['gang'])
{
print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>";
if(!$ir['jail'] && $ir['gang'])
{
 print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>";
}
print "<th>[b]Personal:[/b]</th>
<tr><td>[url='preferences.php']Preferences[/url]</td></tr>
<tr><td>[url='preport.php']Player Report[/url]</td></tr>
<tr><td>[url='breport.php']Bug Report<font color='red'><blink>(new)</blink>[/url]</td></tr>
<tr><td>[url='helptutorial.php']Help Tutorial[/url]</td></tr>
<tr><td>[url='gamerules.php']Game Rules[/url]</td></tr>
<tr><td>[url='viewuser.php?u={$ir[']My Profile[/url]</td></tr>
<tr><td>[url='logout.php']Logout[/url]</td></tr>
</table>";
?>

Zero-Affect · June 3, 2010

<?php
/**
* Layout made by: Shaved92bravada Idea came from another post on CE
* Rest of code is just standard V2 MCcodes
* Made as a free mod so it is not to be sold.
*/
global $db,$c,$ir, $set;
$hc=$set['hospital_count'];
$jc=$set['jail_count'];
$ec=$ir['new_events'];
$mc=$ir['new_mail'];
if($ir['hospital'])
{
 print "<table width=145 class=menu><th>Main</th><tr><td>
 [url='hospital.php']Hospital ($hc)[/url]</td></tr>
 <tr><td>[url='inventory.php']Inventory[/url]</td></tr>";
}
elseif($ir['jail'])
{
 print "<table width=145 class=menu><th>Main</th><tr><td>
 [url='jail.php']Jail ($jc)[/url]</td></tr>
 <tr><td>[url='inventory.php']Inventory[/url]</td></tr>";
}
else
{
 print "<table width=145 class=menu><th>Main</th><tr><td>
 [url='index.php']Home[/url]</td></tr>
 <tr><td>[url='streets.php']Explore Streets<font color='red'><blink>(new)</blink></font>[/url]</td></tr>
 <tr><td>[url='inventory.php']Inventory[/url]</td></tr>";
}
if($ec > 0) { print "<tr><td>[url='events.php']Events ($ec)[/url]</td></tr>"; }
else { print "<tr><td>[url='events.php']Events (0)[/url]</td></tr>"; }
if($mc > 0) {
print "<tr><td>[url='mailbox.php']Mailbox ($mc)<image src='mail.jpg'>[/url]</td></tr>";
} else {
print "<tr><td>[url='mailbox.php']Mailbox (0)[/url]</td></tr>";
}
if($ir['jail'] and !$ir['hospital'])
{
 print "<tr><td>[url='gym.php']Jail Gym[/url]</td></tr>
 <tr><td>[url='hospital.php']Hospital ($hc)[/url]</td></tr>";
}
else if (!$ir['hospital'])
{
 print "<tr><td>[url='explore.php']Explore[/url]</td></tr>
 <tr><td>[url='gym.php']Gym[/url]</td></tr>
 <tr><td>[url='criminal.php']Crimes[/url]</td></tr>
 <tr><td>[url='job.php']Your Job[/url]</td></tr>
 <tr><td>[url='education.php']Local School[/url]</td></tr>
 <tr><td>[url='hospital.php']Hospital ($hc)[/url]</td></tr>
 <tr><td>[url='jail.php']Jail ($jc)[/url]</td></tr>";
}
else
{
 print "<tr><td>[url='jail.php']Jail ($jc)[/url]</td></tr>";
}
print "<tr><td>[url='/forums']Forums[/url]</td></tr>";
if($ir['new_announcements'])
{
print "<tr><td>[url='announcements.php']Announcements ({$ir['new_announcements']})[/url]</td></tr>";
}
else
{
print "<tr><td>[url='announcements.php']Announcements (0)[/url]</td></tr>";
}
print "<tr><td>[url='newspaper.php']Newspaper[/url]</td></tr>
<tr><td>[url='search.php']Search[/url]</td></tr>";

$qq = $db->query("SELECT * FROM cities1 WHERE cityowner1={$ir['userid1']}");
if($db->num_rows($qq) >0)
{
print "[url='cityadmin.php']City Admin Panel[/url]
";
}
if(!$ir['jail'] && $ir['gang'])
{
print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>";
if(!$ir['jail'] && $ir['gang'])
{
 print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>";
}
echo "
<th>[b]Personal:[/b]</th>
<tr><td>[url='preferences.php']Preferences[/url]</td></tr>
<tr><td>[url='preport.php']Player Report[/url]</td></tr>
<tr><td>[url='breport.php']Bug Report<font color='red'><blink>(new)</blink>[/url]</td></tr>
<tr><td>[url='helptutorial.php']Help Tutorial[/url]</td></tr>
<tr><td>[url='gamerules.php']Game Rules[/url]</td></tr>
<tr><td>[url='viewuser.php?u={$ir[']My Profile[/url]</td></tr>
<tr><td>[url='logout.php']Logout[/url]</td></tr>
</table>
";
}
?>

bladewolf2010 · June 3, 2010

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

MDK666 · June 3, 2010

pm me on yahoo andrew_032686 or msn [email protected] cuz im gonna test this on my local server right now and see why you keep getting these errors.

bladewolf2010 · June 3, 2010

I added you onto msn

lucky3809 · June 3, 2010

the one you posted before was only missing a } at the end of it before ?>

MDK666 · June 3, 2010

<?php
/**
* Layout made by: Shaved92bravada Idea came from another post on CE
* Rest of code is just standard V2 MCcodes
* Made as a free mod so it is not to be sold.
*/
global $db,$c,$ir, $set;
$hc=$set['hospital_count'];
$jc=$set['jail_count'];
$ec=$ir['new_events'];
$mc=$ir['new_mail'];
if($ir['hospital'])
{
 print "<table width=145 class=menu><th>Main</th><tr><td>
 [url='hospital.php']Hospital ($hc)[/url]</td></tr>
 <tr><td>[url='inventory.php']Inventory[/url]</td></tr>";
}
elseif($ir['jail'])
{
 print "<table width=145 class=menu><th>Main</th><tr><td>
 [url='jail.php']Jail ($jc)[/url]</td></tr>
 <tr><td>[url='inventory.php']Inventory[/url]</td></tr>";
}
else
{
 print "<table width=145 class=menu><th>Main</th><tr><td>
 [url='index.php']Home[/url]</td></tr>
 <tr><td>[url='streets.php']Explore Streets<font color='red'><blink>(new)</blink></font>[/url]</td></tr>
 <tr><td>[url='inventory.php']Inventory[/url]</td></tr>";
}
if($ec > 0) { print "<tr><td>[url='events.php']Events ($ec)[/url]</td></tr>"; }
else { print "<tr><td>[url='events.php']Events (0)[/url]</td></tr>"; }
if($mc > 0) { print "<tr><td>[url='mailbox.php']Mailbox ($mc)<image src='mail.jpg'>[/url]</td></tr>"; }
else { print "<tr><td>[url='mailbox.php']Mailbox (0)[/url]</td></tr>"; }
if($ir['jail'] and !$ir['hospital'])
{
 print "<tr><td>[url='gym.php']Jail Gym[/url]</td></tr>
 <tr><td>[url='hospital.php']Hospital ($hc)[/url]</td></tr>";
}
else if (!$ir['hospital'])
{
 print "<tr><td>[url='explore.php']Explore[/url]</td></tr>
 <tr><td>[url='gym.php']Gym[/url]</td></tr>
 <tr><td>[url='criminal.php']Crimes[/url]</td></tr>
 <tr><td>[url='job.php']Your Job[/url]</td></tr>
 <tr><td>[url='education.php']Local School[/url]</td></tr>
 <tr><td>[url='hospital.php']Hospital ($hc)[/url]</td></tr>
 <tr><td>[url='jail.php']Jail ($jc)[/url]</td></tr>";
}
else
{
 print "<tr><td>[url='jail.php']Jail ($jc)[/url]</td></tr>";
}
print "<tr><td>[url='/forums']Forums[/url]</td></tr>";
if($ir['new_announcements'])
{
print "<tr><td>[url='announcements.php']Announcements ({$ir['new_announcements']})[/url]</td></tr>";
}
else
{
print "<tr><td>[url='announcements.php']Announcements (0)[/url]</td></tr>";
}
print "<tr><td>[url='newspaper.php']Newspaper[/url]</td></tr>
<tr><td>[url='search.php']Search[/url]</td></tr>";

$q=$db->query("SELECT * FROM cities1 WHERE cityowner11={$ir['userid']}");  //its userid not userid1 as its pulling from the users table.
if($db->num_rows($q)>0)
{
print "[url='cityadmin.php']City Admin Panel[/url]
";
}
if(!$ir['jail'] && $ir['gang'])
{
print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>";
if(!$ir['jail'] && $ir['gang'])
{
 print "<tr><td>[url='yourgang.php']Your Gang[/url]</td></tr>";
}
print "<th>[b]Personal:[/b]</th>
<tr><td>[url='preferences.php']Preferences[/url]</td></tr>
<tr><td>[url='preport.php']Player Report[/url]</td></tr>
<tr><td>[url='breport.php']Bug Report<font color='red'><blink>(new)</blink>[/url]</td></tr>
<tr><td>[url='helptutorial.php']Help Tutorial[/url]</td></tr>
<tr><td>[url='gamerules.php']Game Rules[/url]</td></tr>
<tr><td>[url='viewuser.php?u={$ir[']My Profile[/url]</td></tr>
<tr><td>[url='logout.php']Logout[/url]</td></tr>
</table>";
}
?>

Sign In

Help again :P

Recommended Posts

bladewolf2010

Zero-Affect

bladewolf2010

Zero-Affect

MDK666

bladewolf2010

MDK666

bladewolf2010

Zero-Affect

bladewolf2010

MDK666

bladewolf2010

lucky3809

MDK666

Join the conversation

Browse

Activity

Hosting