Jump to content
MakeWebGames

Help!!

DreamCoder

By DreamCoder
in Engine Support

 Share

Recommended Posts

DreamCoder Newbie

DreamCoder

Posted
Posted

i have a problem with mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\header.php on line 81

 

the codes is

 

";

$q=mysql_query("SELECT * FROM ads ORDER BY rand() LIMIT 1",$c);

if(mysql_num_rows($q))

{

 

}

print "<table width=100%><tr><td width=20% valign='top'>

";

 

 

can u reype the corrections please

Link to comment
Share on other sites
Wazam Newbie

Wazam

Posted
Posted

Sorry, I don't know much of MYSQL, so I cannot help you, sorry. But this is kind of p]weird. :/

 

";
$q=mysql_query("SELECT * FROM ads ORDER BY rand() LIMIT 1",$c);
if(mysql_num_rows($q))
{

}
print "<table width=100%><tr><td width=20% valign='top'>
";

 

Maybe try? o_0

 

// Put what ever come before this is. 
$Query = mysql_query("SELECT * FROM `ads` ORDER BY rand() LIMIT 1" , $c) or die('Mysql error!'); // Try to select WHAT'S needed
if (mysql_num_rows($Query) ) 
{ // Opening 

print "<table width = '100%'>
          <tr>
          <th>????</th>
          </tr>
          <tr>          
          <td width = '20%' valign='top'>WHAT EVER HERE</th>  // IOutput here.
          </tr>
          </table>";

} // Closing

 

I think the table should be included there(fully). If some things are there(in the table) that arn't needed. Just remove.

Link to comment
Share on other sites
DreamCoder Newbie

DreamCoder

Posted
  • Author
Posted 
<?php

class headers {
function startheaders() {
global $ir;
echo <<<EOF
<html>
<head>
<title>Rage-Mafia</title>
<style>
body { font-family:helvetica, arial, geneva, sans-serif;font-size:12;color: #666000;
  scrollbar-base-color: #666000;
  scrollbar-arrow-color: #666000;
  scrollbar-DarkShadow-Color: #666000; }
a:visited,a:active,a:hover,a:link { color: #666000;text-decoration: none; }
table,tr,td { font-family:helvetica, arial, geneva, sans-serif;font-size: 12; }
img { border:none; }
textarea { font-family:helvetica, arial, geneva, sans-serif;font-size:12;color:#666000; }
</style>
</head>

EOF;

}
function userdata($ir,$lv,$fm,$cm,$dosessh=1)
{
global $c,$userid;
$ip = ($_SERVER['HTTP_X_FORWARDED_FOR'])
   ?  $_SERVER['HTTP_X_FORWARDED_FOR']
   :  $_SERVER['REMOTE_ADDR'];
mysql_query("UPDATE users SET laston=unix_timestamp(),lastip='$ip' WHERE userid=$userid",$c);
if(!$ir['email'])
{
die ("<body>Your account may be broken. Please mail [email][email protected][/email] stating your username and player ID.");
}
if($dosessh && $_SESSION['attacking'])
{
print "You lost all your EXP for running from the fight.";
mysql_query("UPDATE users SET exp=0 WHERE userid=$userid",$c);
$_SESSION['attacking']=0;
}
$enperc=(int) ($ir['energy']/$ir['maxenergy']*100);
$wiperc=(int) ($ir['will']/$ir['maxwill']*100);
$experc=(int) ( $ir['exp']/$ir['exp_needed']*100);
$brperc=(int) ($ir['brave']/$ir['maxbrave']*100);
$hpperc=(int) ($ir['hp']/$ir['maxhp']*100);
$enopp=100-$enperc;
$wiopp=100-$wiperc;
$exopp=100-$experc;
$bropp=100-$brperc;
$hpopp=100-$hpperc;
$d="";
$u=$ir['username'];
if($ir['donatordays']) { $u = "<font color=red>{$ir['username']}</font>";$d="[img=donator.gif]"; }
if($ir['gang']) {
$qg=mysql_query("SELECT * FROM gangs WHERE gangID={$ir['gang']}",$c);
$rr=mysql_fetch_array($qg);
$gn=$rr['gangPREF']."";
}
else { $gn=""; }
print "<body bgcolor='black'>
<table width=100%><tr><td>[img=logo.png]</td>
<td>[b]Name:[/b] $gn{$u} [{$ir['userid']}] $d

[b]Money:[/b] {$fm}

[b]Level:[/b] {$ir['level']}

[b]ReWard points:[/b] {$ir['crystals']}

[[url='logout.php']Logout[/url]]</td><td>
[b]Energy:[/b] {$enperc}%

<img src=bargreen.gif width=$enperc height=10><img src=barred.gif width=$enopp height=10>

[b]Will:[/b] {$wiperc}%

<img src=bargreen.gif width=$wiperc height=10><img src=barred.gif width=$wiopp height=10>

[b]Rage:[/b] {$ir['brave']}/{$ir['maxbrave']}

<img src=bargreen.gif width=$brperc height=10><img src=barred.gif width=$bropp height=10>

[b]EXP:[/b] {$experc}%

<img src=bargreen.gif width=$experc height=10><img src=barred.gif width=$exopp height=10>

[b]Health:[/b] {$hpperc}%

<img src=bargreen.gif width=$hpperc height=10><img src=barred.gif width=$hpopp height=10></td></tr></table></div>[url='voting.php'][b]<center><u>Vote for Rage-Mafia on various gaming sites and be rewarded!</u></center>[/b][/url]

[url='donator.php'][b]<center><u>Donate to Rage-Mafia, it's only \$3-30 and gets you a lot of benefits!</u></center>[/b][/url]

";
$q=mysql_query("SELECT * FROM ads ORDER BY rand() LIMIT 1",$c);
if(mysql_num_rows($q))
{

}
print "<table width=100%><tr><td width=20% valign='top'>
";
if($ir['fedjail'])
{
$q=mysql_query("SELECT * FROM fedjail WHERE fed_userid=$userid",$c);
$r=mysql_fetch_array($q);
die("[b]<font color=red size=+1>You have been put in the Rage-Mafia Federal Jail for {$r['fed_days']} day(s).

Reason: {$r['fed_reason']}</font>[/b]</body></html>");
}
if(file_exists('ipbans/'.$ip))
{
die("[b]<font color=red size=+1>Your IP has been banned, there is no way around this.</font>[/b]</body></html>");
}
}
function menuarea()
{
include "mainmenu.php";
global $ir,$c;
print "</td><td valign='top'>
";
}
function endpage()
{
print "</td></tr></table></body>
</html>";
}
}
?>
Link to comment
Share on other sites
Wazam Newbie

Wazam

Posted
Posted

Well.. All fair do's.. But. Why are you owning a game, or building a game, if you can hardly take care of problems yourself. I think you need to spend more time on http://www.php.net & http://www.w3schools.com && http://www.mysql.com and then start working on your game.

Anyway...

 

$ip = ($_SERVER['HTTP_X_FORWARDED_FOR'])
   ?  $_SERVER['HTTP_X_FORWARDED_FOR']
   :  $_SERVER['REMOTE_ADDR'];

Can become

$ip =  $_SERVER['REMOTE_ADDR'];

 

$qg=mysql_query("SELECT * FROM gangs WHERE gangID={$ir['gang']}",$c);

Can become

$qg = mysql_query("SELECT * FROM `gangs` WHERE `gangID` = ".$ir['gang']." " , $c) or die('Mysql ERROR!');
Link to comment
Share on other sites
Wazam Newbie

Wazam

Posted
Posted

Yes.. and my comment below, involving helping you, isn't me helping you?

You cannot depend on us to keep helping you with errors, if you can't sort it out yourself, and don't really attempt to fix the error, then what's the point of learning? You have MCC to experiment on, use that. Unlike me, I have to try and do things without using CPanel or MCC, GRPG, etc.. I can't even download WAMP, mum won't let me download squat. :P

Instead on trying to make mods on your game.. Go on W3Schools, and get back learning on HTML.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...