Jump to content
MakeWebGames

help!!!!

Hybridd

By Hybridd
in Other Game Engines

 Share

Recommended Posts

Hybridd Newbie

Hybridd

Posted
Posted

need help getting these errors ..

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/*****/public_html/includes/style_top.php on line 1004

Warning: Division by zero in /home/*****/public_html/includes/style_top.php on line 1029

Warning: Division by zero in /home/*****/public_html/includes/style_top.php on line 1034

Warning: Division by zero in /home/*****/public_html/includes/style_top.php on line 1039

Warning: Division by zero in /home/*****/public_html/includes/style_top.php on line 1044

Hybridd Newbie

Hybridd

Posted
  • Author
Posted (edited)

right okay anyone wanna help fix my style_top?

errors are on lines:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/*****/public_html/includes/style_top.php on line 950

Warning: Division by zero in /home/*****/public_html/includes/style_top.php on line 1123

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/*****/public_html/includes/style_top.php on line 1004

Warning: Division by zero in /home/*****/public_html/includes/style_top.php on line 1029

Warning: Division by zero in /home/*****/public_html/includes/style_top.php on line 1034

Warning: Division by zero in /home/*****/public_html/includes/style_top.php on line 1039

Warning: Division by zero in /home/******/public_html/includes/style_top.php on line 1044

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <!--
     [rrrrrrr]  /cccccc]
     [rrr[]rrr][cc/
     [rrrrrrrr][cc\
     [rr]  [rrr]\cccccc]
                      -->
      <html xmlns="http://www.w3.org/1999/xhtml">
      <style type="text/css">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<?php

// Code from here on is Property of Ashley Jackson and is required to produce the audio for events

$sound = "<embed src='http://test.net/includes/test2.wav' height=0 width=0 hidden=true autostart=true loop=false volume=100 />";

       $q_ry = array();
  $q_ry = "SELECT `e_id`
           FROM `member_events`
           WHERE `e_playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'
           AND `e_read` = '0'";
  $evs = array();
  $evs = mysql_query($q_ry);
  if(mysql_num_rows($evs)){echo "$sound"; }

// End Ashley Jacksons Code


?>
       <style type="text/css">

      tr .odd {
      background: url(images/odd.png) repeat-y left top;
      }
      tr .even {
      background: url(images/even.png) repeat-y left top;
      }
body {
      margin-top:0px;
      text-align:center;
      color:black;
      }
      a:visited,a:active,a:link {
      color: black;text-decoration: underline;
      }
      a:hover {
      color: black;text-decoration: underline;
      }
<?php
      if(ae_detect_ie()) {
?>
      tr .odd {
      background: url(images/ieodd.png) no-repeat center top;
      }
      tr .even {
      background: url(images/ieeven.png) no-repeat center top;
      }
      tr .even:hover, tr .odd:hover {
      background: url(images/iehover.png) no-repeat center top;
      }
      tr .odds {
      background: url(images/ieodds.png) no-repeat center top;
      }
      tr .evens {
      background: url(images/ieevens.png) no-repeat center top;
      }
      tr .evens:hover, tr .odds:hover {
      background: url(images/iehovers.png) no-repeat center top;
      }
      input {
      border:0px;
      }
      input.nostyle {
      border:0px;
      }
      main {
      font-family:helvetica, arial, geneva, sans-serif;font-size:14px; color: black;
      font-weight: 800px;
      }
<?php
      }
?>
<?php
      if(!ae_detect_ie()) {
?>
      tr .odd {
      background: url(images/odd.png) repeat-y left top;
      }
      tr .even {
      background: url(images/even.png) repeat-y left top;
      }
      tr .even:hover, tr .odd:hover {
      background: url(images/ffhover.png) repeat-y left top;
      }
      tr .odds {
      background: url(images/odd.png) repeat-y left top;
      }
      tr .evens {
      background: url(images/even.png) repeat-y left top;
      }
      tr .evens:hover, tr .odds:hover {
      background: url(images/ffhover.png) repeat-y left top;
      }
      input {
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      background-color: #FFFFFF;
      -moz-border-radius: 7px;
      -webkit-border-radius: 5px;
      border:solid; style="
      background-color:
      #000000; 1px
      padding: 10px;"
      }
      input.nostyle {
      border:0px;
      }
      main {
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      font-weight: 800;
      text-shadow: #363636 0px 0px 4px;
      }
<?php
      }
?>
      input.chat {
      font-size:10px;
      border:1px lightblue solid;
      cursor:pointer;
      }
      textarea {
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      background-color: #FFFFFF;
      -moz-border-radius: 7px;
      -webkit-border-radius: 5px;
      border:solid; style="
      background-color:
      #000000; 1px
      padding: 10px;"
      }
      textarea.nostyle {
      font-size:10px;
      border:1px lightblue solid;
      }
      .maintable {
      margin-top:10px;
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;  
      -moz-border-radius: 7px;
      -webkit-border-radius: 5px;
      border: style="
      background-color:
      #000000; 1px solid #000000;
      padding: 5px;"
      }
      .maintable td {
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      font-size:12px;
      }
      .rounded {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;  
      -moz-border-radius: 1em;
      -moz-box-shadow: 0px 2px 20px rgba(0,0,0,0.9);
      border: style="
      background-color:
      #ffffff; 1px;
      padding: 5px;"
      }
      .bj {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      -moz-border-radius: 10em;
      -moz-box-shadow: 0px 2px 20px rgba(0,0,0,0.9);
      border: style="
      background-color:
      green; 1px;
      padding: 5px;"
      }
      .rounded td.round {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      -moz-border-radius: 1em;
      }
      .forum {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      background-color:#E3E3E3;
      -moz-border-radius: 1em;
      -moz-box-shadow: 0px 2px 20px rgba(0,0,255,0.9);
      border: style="
      background-color:
      #ffffff; 1px;
      padding: 5px;"
      }
      .red {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      background-color:#E3E3E3;
      -moz-border-radius: 1em;
      -moz-box-shadow: 0px 2px 20px rgba(252,3,3,0.9);
      border: style="
      background-color:
      #ffffff; 1px;
      padding: 5px;"
      }
      .orange {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      background-color:#E3E3E3;
      -moz-border-radius: 1em;
      -moz-box-shadow: 0px 2px 20px rgba(255,165,0,0.9);
      border: style="
      background-color:
      #ffffff; 1px;
      padding: 5px;"
      }
      .forum td.round {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      -moz-border-radius: 1em;
      }
      .properties {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      background-color:#E3E3E3;
      -moz-border-radius: 1em;
      -moz-box-shadow: 0px 2px 20px rgba(124,252,0,0.9);
      border: style="
      background-color:
      #ffffff; 1px;
      padding: 5px;"
      }
      .properties td.round {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      -moz-border-radius: 1em;
      }
      .properties table.movedin {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      -moz-border-radius: 1em;
      }
      .forumreply {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      -moz-border-radius: 1em;
      -moz-box-shadow: 0px 2px 20px rgba(255,0,0,1);
      border: style="
      background-color:
      #ffffff; 1px;
      padding: 5px;"
      }
      .forumreply td.round {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      -moz-border-radius: 1em;
      }
      .menu {
      margin-top:2px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      background-color:#E3E3E3;
      -moz-border-radius: 12px 22px;
      -moz-box-shadow: 0px 2px 20px rgba(0,0,0,0.9);
      border: style="
      background-color:
      #000000; 1px solid #000000;
      padding: 5px;"
      }
      .menu td {
      background-color: #FFFFFF;
      }
      .menu td.a:visited,a:active,a:link {
      color: black;text-decoration: none;
      }
      #banner {
      width:800px;
      height:70px;
      align:center;
      }
      #btmbar {
      bottom:0;
      right:5px;
      position:fixed;
      background-color:#FFFFFF;
      height:25px;
      }
      #staffbar {
      bottom:0px;
      right:0px;
      left:0px;
      border:1px;
      position:fixed;
      text-align: center;
      }
      #BARfrndlist {
      bottom:25px;
      right:9px;
      position:fixed;
      background-color:#A1A1A1;
      width:150px;
      }
      #BARwindow1 {
      bottom:25px;
      right:174px;
      position:fixed;
      background-color:#E3E3E3;
      width:175px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      }
      #BARwindow2 {
      bottom:25px;
      right:354px;
      position:fixed;
      background-color:#E3E3E3;
      width:175px;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      }
      #BARfriends {
      width:150px;
      border:1px #000000 solid;
      }
      .chtbx {
      width:175px;
      border:1px #000000 solid;
      text-align:left;
      }
      .popUp {
      display:none;
      left: auto;
      right: auto;
      }
      #procomments {
      display:none;
      }
      .popUpOpen {
      display:block;
      bottom:230px;
      left: 450px;
      position:fixed;
      background-color:#E3E3E3;
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      margin-top:2px;
      -moz-border-radius: 1em;
      -moz-box-shadow: 0px 2px 20px rgba(0,0,255,0.9);
      border: style="
      background-color:
      #ffffff; 1px;
      padding: 5px;"
      }
      tr .even:hover, tr .odd:hover {
   background: none repeat scroll 0 0 #54C2F0;
   border-bottom-right-radius: 7px;
   border-right: 1px solid transparent;
   box-shadow: 1px 2px 2px #999999;
   cursor: pointer;
      }
      tr .odds {
      background: url(images/odd.png) repeat-y left top;
      }
      tr .evens {
      background: url(images/even.png) repeat-y left top;
      }
      tr .evens:hover, tr .odds:hover{
   background: none repeat scroll 0 0 #54C2F0;
   border-bottom-right-radius: 7px;
   border-right: 1px solid transparent;
   box-shadow: 1px 2px 2px #999999;
   cursor: pointer;
}
      input { 
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      background-color: #FFFFFF;
      -moz-border-radius: 7px; 
      -webkit-border-radius: 5px; 
      border:1px solid #000000;
      }
      input.nostyle { 
      border:0px;
      }
#top_header-wrap {
position: fixed;
top: 0;
left: 0;
width: 100%;	
}

#hederimage {
height: 48px;
background: url( ../images/headerbgimage.png) repeat-x left bottom;
valign: center;
}

#headeroverlay {
width: 85%;
margin: 0 auto;
position: relative;
}

#top_header h1 {
color: #beffbf;
text-align: right;
width: 290px;
margin: 0;
position: absolute;
left: 0;
top: 20px;
}

#top_header h1 em{
color: #90b874;
font-size: small;
display: block;
}

#top_header ul {
margin: 0;
padding: 0;
list-style: none;
position: absolute;
top: 8px;
right: 0;
}

#top_header ul li {
float: left;
}

#top_header ul li a{
color: #90b874;
font-weight: bold;
font-size: 1.4em;
text-decoration: none;
}

#top_header ul li a:hover {
color: #beffbf;	
}
      main {
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color:#FFFFFF ;
      font-weight: 800;
      text-shadow: #363636 0px 0px 4px; 
      }

.crime_result {
border:1px solid #000000;
border-radius:5px;
background-color:#FFFFFF;
font-weight:bold;
}
.crime_stats {
border:1px solid #000000;
border-radius:5px;
color:#999999;
background-color:#555555;
}
#crimelink:hover{
background-color:#888888;
color:#222222;
cursor:pointer;
}
      #tooltip {position:absolute;
      font-size:12px;
   z-index: 99999999;
   min-width: 50px;
   text-shadow: none !important;
   background: -webkit-gradient(linear, left top, left bottom, from(#4E4E4E), to(#262626));
   background: -moz-linear-gradient(top,  #4E4E4E,  #262626);
   filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#4E4E4E', endColorstr='#262626');
   border: 1px solid #3A3A3A;
   -moz-border-radius: 5px;
   -webkit-border-radius: 5px;
   border-radius: 5px;
   box-shadow: 0px 0px 5px #FFFFFF;
   text-align:center;
   padding-left: 10px;
   padding-right: 10px;
      }
      #tooltip .tipHeader {
      height:8px;
      color:#ffffff;
      font-weight:bold;
      padding-bottom:8px;
      background:none;
      }
      #tooltip .tipBody {
      background: #000000;
      padding:5px;
      }

      #tooltip .tipFooter {
      height:8px;
      background:none;
      }
.stats-bar-fill {
height: 6px;
}
.clock_body {
   background: url("../images/crbar.png") repeat scroll 0 0 transparent;
   border: 1px solid #F1EFE1;
   border-radius: 10px 10px 10px 10px;
   color: #000000;
   cursor: default;
   text-align: center;
   padding-left:5px;
   padding-right:5px;
   font-weight:bold;
   text-align:center;
   font-size:11px;
   width: 55px;
}
#item_wrapper{
border:1px solid #000000;
text-align:center;
cursor:pointer;
}
#item_wrapper:hover{
background-color:#AABBCC;
}
.item_links{
background-color:#F5FFFA;
font-weight:bold;
width:100%;
}
      *html #tooltip .tipHeader {margin-bottom:-6px;}
        </style>
<style>	    #all > tr { 
    	float: left; width: 200px; 
    	padding: 0 10px 0 0; 
    }
    #all .turf_header {
		text-decoration: none; 
		display: block; 
		width:100%;
		border-radius: 20px; 
		background:#990000;
		color: white; 
		text-align: center;
		margin: 0 0 5px 0; 
		}
    #all a { 
		text-decoration: none; 
		display: block; 
		padding: 10px;
		color: white; 
		text-align: center;
		margin: 0 0 5px 0; 
		-webkit-transition: all 0.2s ease;
		-moz-transition: all 0.2s ease;
		-o-transition: all 0.2s ease;
    }
    #all:hover a {
		opacity: 0.2;
    }
    #all:hover tr:hover a {
		opacity: 0.5; 
    }
    #all:hover tr:hover a:hover {
		opacity: 1;
    }</style>   
<link href="/css/banner.css" media="all" rel="stylesheet" type="text/css">
<link href='http://www.streetmafia.net/css/newcss.css' rel='stylesheet' type='text/css'/> 
<link REL="SHORTCUT ICON" HREF="images/ico-icon.jpg">
        <title>test | Free Text Based RPG Game</title>
         <link type="text/css" rel="stylesheet" media="all" href="../css/chat.css" />
      <link type="text/css" rel="stylesheet" href="css/popup.css" />
 <link type="text/css" rel="stylesheet" href="css/profiles.css" />
 <link rel="stylesheet" type="text/css" href="css/incrementing.css" />
        <link type="text/css" rel="stylesheet" href="css/main_chat.css" />
         <link type="text/css" rel="stylesheet" href="css/style.css" />
           <link href="/css/lolno.css" media="all" rel="stylesheet" type="text/css">
<link href="/css/sidebar.css?v=<?php echo time()?>" rel="stylesheet" type="text/css" />

         <link href="/css/banner.css" media="all" rel="stylesheet" type="text/css">
        <link href="/css/dock.css" rel="stylesheet" type="text/css" />
 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
        <script type="text/javascript" src="../js/jquery.js"></script>
        <script type="text/javascript" src="../js/incrementing.js"></script>
        <script src="../js/jquery-1.4.2.js" type="text/javascript"></script>
        <script type="text/javascript" src="../js/dock.js"></script>
        <script src="../js/popups.js" type="text/javascript"></script>


<script type = 'text/javascript'>
       var timeoutId;
       $(document).ready(function() {
       $('[rel=tooltip]').mouseover(function(e) {
         var tip = $(this).attr('title');
         var tiptitle = $(this).attr('id');
         $(this).attr('title','','');
         $(this).css('cursor','pointer');
         $(this).append('<div id="tooltip"><div class="tipHeader">' + tiptitle + '</div><div class="tipBody">' + tip + '</div><div class="tipFooter"></div></div>');
         }).mouseout(function() {
         $(this).attr('title',$('.tipBody').html(),'id');
         $(this).children('div#tooltip').remove();
          });
       });
        </script>
<script type="text/javascript">

$(document).ready(
	function()
	{
		$('#dock').Fisheye(
			{
				maxWidth: 50,
				items: 'a',
				itemsText: 'span',
				container: '.dock-container',
				itemWidth: 40,
				proximity: 90,
				halign : 'center'
			}
		)
	}
);

</script>
<script language="javascript" type="text/javascript">

   var timeOut = new Array();
   function postFormAjax(formname, url, number) 
   {
   var xmlhttp;
   if (window.XMLHttpRequest)
   {
             xmlhttp=new XMLHttpRequest();
   }
   else
   {
	      xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
   }
   if(xmlhttp) 
   {
   var fields = new Array();
   if(formname)
   {
    var ajax = formname;
   }
   for(var x = 0; x < eval("document."+ajax+".elements.length"); x++)
{
    eval("fields.push(document."+ajax+".elements[x].name+'='+document."+ajax+".elements[x].value)");

   }
   var sendf = fields.join('&');
   xmlhttp.open("POST", url, true);
   xmlhttp.onreadystatechange = function()
{
  if(xmlhttp.readyState == 4) 
  {
    if(xmlhttp.status == 200)
    {
             var elemn = "actionstatus" + number;
             document.getElementById(elemn).innerHTML = '';
             document.getElementById(elemn).innerHTML = xmlhttp.responseText;
    } 
  }
}
   xmlhttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
   xmlhttp.send(sendf);
  }
 }

  function loadNotes() {
  var xmlhttp;
  if(window.XMLHttpRequest) {
  xmlhttp = new XMLHttpRequest();
  }
  else
     {
     xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
     }
     xmlhttp.onreadystatechange=function()
     {
     if(xmlhttp.readyState==4) {
     document.getElementById("shownotes").innerHTML = xmlhttp.responseText;
     }
   }
   xmlhttp.open("GET", "staffnotes.php?noteLoader=true", true); 
   xmlhttp.send(null);
   }

  function loadBar(type, url) {
  var xmlhttp;
  if(window.XMLHttpRequest) {
  xmlhttp = new XMLHttpRequest();
  }
  else
     {
     xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
     }
     xmlhttp.onreadystatechange=function()
     {
     if(xmlhttp.readyState==4) {
     var elemnt = "BAR" + type;
     document.getElementById(elemnt).innerHTML = xmlhttp.responseText;
     }
   }
   xmlhttp.open("GET", url, true); 
   xmlhttp.send(null);
   }


  function resetBar(elem) {
  document.getElementById(elem).innerHTML = '';
  }


  function startChat(who) {
  var xmlhttp;
  if(window.XMLHttpRequest) {
  xmlhttp = new XMLHttpRequest();
  }
  else
     {
     xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
     }
     xmlhttp.onreadystatechange=function()
     {
     if(xmlhttp.readyState==4) {
     loadBar('openchats', 'bar.php?load=chats');
     }
   }
   var url = "bar.php?load=start&id=" + who;
   xmlhttp.open("GET", url, true); 
   xmlhttp.send(null);
   }

// run the function below once the DOM(Document Object Model) is ready
$(document).ready(function() {
   // trigger the function when clicking on an assigned element
   $(".toggleAd").click(function () {
       // check the visibility of the next element in the DOM
       if ($(this).next().is(":hidden")) {
           $(this).next().slideDown("medium"); // slide it down
       } else {
           $(this).next().slideUp("medium"); // hide it
       }
   });
});
$(document).ready(function() {
   // trigger the function when clicking on an assigned element
   $(".toggleSec").click(function () {
       // check the visibility of the next element in the DOM
       if ($(this).next().is(":hidden")) {
           $(this).next().slideDown("medium"); // slide it down
       } else {
           $(this).next().slideUp("medium"); // hide it
       }
   });
});
$(document).ready(function() {
   // trigger the function when clicking on an assigned element
   $(".toggleMod").click(function () {
       // check the visibility of the next element in the DOM
       if ($(this).next().is(":hidden")) {
           $(this).next().slideDown("medium"); // slide it down
       } else {
           $(this).next().slideUp("medium"); // hide it
       }
   });
});
$(document).ready(function() {
   // trigger the function when clicking on an assigned element
   $(".toggleHelp").click(function () {
       // check the visibility of the next element in the DOM
       if ($(this).next().is(":hidden")) {
           $(this).next().slideDown("medium"); // slide it down
       } else {
           $(this).next().slideUp("medium"); // hide it
       }
   });
});
$(document).ready(function() {
   // trigger the function when clicking on an assigned element
   $(".toggleSnote").click(function () {
       // check the visibility of the next element in the DOM
       if ($(this).next().is(":hidden")) {
           $(this).next().slideDown("medium"); // slide it down
       } else {
           $(this).next().hide(); // hide it
       }
   });
});
$(document).ready(function() {
   // trigger the function when clicking on an assigned element
   $("div#NSbutton").click(function () {
       // check the visibility of the next element in the DOM
       $(this).hide();
   });
});


             function EnterSub(e, id)
             {
                       var key = (e.keyCode ? e.keyCode : e.which);
                       if(key == 13) {
                          var clicker = 'post' + id;
                   document.getElementById(clicker).click();
                }
             }
function closeMainChatBox(chatboxtitle,chatboxno) {
$('#chatbox_'+chatboxtitle).css('display','none');
	loadBar('window'+chatboxno, 'bar.php?load=min&id='+chatboxtitle);


}
<?php
      if(ae_detect_ie()) {
?>
      tr .odd {
      background: url(images/ieodd.png) no-repeat center top;
      }
      tr .even {
      background: url(images/ieeven.png) no-repeat center top;
      }
      tr .even:hover, tr .odd:hover {
      background: url(images/iehover.png) no-repeat center top;
      }
      tr .odds {
      background: url(images/ieodds.png) no-repeat center top;
      }
      tr .evens {
      background: url(images/ieevens.png) no-repeat center top;
      }
      tr .evens:hover, tr .odds:hover {
      background: url(images/iehovers.png) no-repeat center top;
      }
      input { 
      border:0px;
      }
      input.nostyle { 
      border:0px;
      }
      main {
      font-family:helvetica, arial, geneva, sans-serif;font-size:14px; color: black;
      font-weight: 800px;
      }
<?php
      }
      if(!ae_detect_ie()) {
?>
      tr .odd {
      background: url(images/odd.png) repeat-y left top;
      }
      tr .even {
      background: url(images/even.png) repeat-y left top;
      }
      tr .even:hover, tr .odd:hover {
      background: url(images/ffhover.png) repeat-y left top;
      }
      tr .odds {
      background: url(images/odd.png) repeat-y left top;
      }
      tr .evens {
      background: url(images/even.png) repeat-y left top;
      }
      tr .evens:hover, tr .odds:hover {
      background: url(images/ffhover.png) repeat-y left top;
      }
      input { 
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      background-color: #FFFFFF;
      -moz-border-radius: 7px; 
      -webkit-border-radius: 5px; 
      border:solid; style=" 
      background-color: 
      #000000; 1px 
      padding: 10px;" 
      }
      input.nostyle { 
      border:0px;
      }
      main {
      font-family:helvetica, arial, geneva, sans-serif;font-size:12px; color: black;
      font-weight: 800;
      text-shadow: #363636 0px 0px 4px; 
      }
<?php
      }
?>
      #tooltip {
      position:absolute;
      color:#ffffff;
      font-size:12px;
      width:300px;
      }
      #tooltip .tipHeader {
      height:8px;
      background: url('images/hover-top.png') no-repeat center top;
      }
      #tooltip .tipBody {
      background: url('images/hover-middle.png') repeat-y center top;
      padding:5px;
      }
      #tooltip .tipFooter {
      height:8px;
      background: url('images/hover-bottom.png') no-repeat center bottom;
      }
      *html #tooltip .tipHeader {margin-bottom:-6px;}
       </style>
        <link type="text/css" rel="stylesheet" media="all" href="css/chat.css" />
        <link type="text/css" rel="stylesheet" href="css/style.css" />
        <head>
        <link REL="SHORTCUT ICON" HREF="images/ico-icon.jpg">
        <title>test | Free Text Based RPG Game</title>
      <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
        <script type="text/javascript" src="js/jquery.js"></script>
        <script src="js/popups.js" type="text/javascript"></script>
        <script src="js/jquery-1.4.2.js" type="text/javascript"></script>
        <script type="text/javascript" src="js/chat.js"></script>

        <script type = 'text/javascript'>
var timeoutId;
       $(document).ready(function() {
       $('[rel=tooltip]').mouseover(function(e) {
         var tip = $(this).attr('title');
         $(this).attr('title','');
         $(this).css('cursor','pointer');
         $(this).append('<div id="tooltip"><div class="tipHeader"></div><div class="tipBody">' + tip + '</div><div class="tipFooter"></div></div>');
         $('#tooltip').css('top', e.pageY + 8 );
         $('#tooltip').css('left', e.pageX + 8 );
         }).mousemove(function(e) {
         $('#tooltip').css('top', e.pageY + 8 );
         $('#tooltip').css('left', e.pageX + 8 );
         }).mouseout(function() {
         $(this).attr('title',$('.tipBody').html());
         $(this).children('div#tooltip').remove();
       $(document).ready(function() {
        $(".openPopup1").click(function () {
            $("#po1").removeClass("popUp").addClass("popUpOpen");

          });
       });
        </script>
        </head>
<?php
ob_start();
ob_flush();
    if($_SESSION['attacking'])
    {
     header('location:run.php');
    }
            $jorh = array();
            $jorh = mysql_query("SELECT `my_jail`,`colour`,`my_hosp` FROM `members` WHERE 
            `playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'");
            $joh = array();
            $joh = mysql_fetch_array($jorh);
            $bgc = array(); $sides = array(); $banner = array();

            if($joh['my_jail'] > gmtime()) { $bgc='CD853F'; $sides='j'; } else
            if($joh['my_hosp'] > gmtime()) { $bgc='FDFDFD'; $sides='h'; } else 
            if($joh['colour'] == dgreen )  { $bgc='6E8B3D'; $sides='';  }

            if($joh['my_jail'] > gmtime()) { $bgc='CD853F'; $sides='j'; } else
            if($joh['my_hosp'] > gmtime()) { $bgc='FDFDFD'; $sides='h'; } else 
            if($joh['colour'] == gray )    { $bgc='CCCCCC'; $sides='';  } 

            if($joh['my_jail'] > gmtime()) { $bgc='CD853F'; $sides='j'; } else
            if($joh['my_hosp'] > gmtime()) { $bgc='FDFDFD'; $sides='h'; } else 
            if($joh['colour'] == hpink )   { $bgc='FF69B4'; $sides='hpink';  } 

            if($joh['my_jail'] > gmtime()) { $bgc='CD853F'; $sides='j'; } else
            if($joh['my_hosp'] > gmtime()) { $bgc='FDFDFD'; $sides='h'; } else 
            if($joh['colour'] == skyblue ) { $bgc='B0E2FF'; $sides='';  } 

            if($joh['my_jail'] > gmtime()) { $bgc='CD853F'; $sides='j'; } else
            if($joh['my_hosp'] > gmtime()) { $bgc='FDFDFD'; $sides='h'; } else 
            if($joh['colour'] == yellow ) { $bgc='FFFF00'; $sides='';  } 

            if($joh['my_jail'] > gmtime()) { $bgc='CD853F'; $sides='j'; } else
            if($joh['my_hosp'] > gmtime()) { $bgc='FDFDFD'; $sides='h'; } else 
            if($joh['colour'] == violet )  { $bgc='EE82EE'; $sides='';  } 



         echo "<body style='background: #".$bgc."'>
         <div align='center' class='headerBar'><a href='index.php'>
              <img src='images/logo.png' BORDER=0 height='40px'></a>
                               <span class='headerBarMsg'><center><!--<a href='donate.php'>--><b><font color=orange>Successful Change Server .. If u get some errors contact to Mr-Era[1]</b></font></a></center></span>
                               <form action='/search.php' method='post'>
                                       <input type='hidden' name='type' value='username' />
                                       <input type='text' name='name' placeholder='Search players' />
                                       <input type='submit' value='Go' name='srch' />
                               </form>
                               <input type='button' value='Logout' onclick=\"location.href='/logout.php'\" />
                       </div>
            <div align='center'>
            <table width='100%' border = '0' cellpadding='0' cellspacing='0' class='maintable' style='margin-top:10px;'>
            <tr>
            <td align='left' valign='top' width='20%' rowspan='2' style='margin-left:10px;'>";
      $pinfo = array();
      $pinfo = mysql_query("SELECT `playername`,`wallet`,`my_points`,`my_merits`,`my_level`,`my_energy`,`my_maxenergy`,

                                   `my_nerve`,`my_maxnerve`,`my_happy`,`my_maxhappy`,`my_respect`,`my_maxrespect`,

                                `my_gender`,`my_dondays`,`vipday`,`vip_point`,`am_i_staff`,`my_partner`,`my_life`,`my_jail`,`my_hosp`,
                               `jail_reason`,`hosp_reason`,`my_faction`,`my_flash_on`,`my_tuts_on`,`my_refpoints`,`my_reflose`,`my_credits`
                            FROM `members` 
                            WHERE `playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'");
      $pl = array();
      $pl = mysql_fetch_array($pinfo);

      $q_ry = array();
      $q_ry = "SELECT lc.lc_time,ed.edu_name
               FROM `live_courses` lc
               LEFT JOIN `educate_courses` ed
               ON lc.lc_course = ed.edu_id
               WHERE lc.lc_playerid = '".mysql_real_escape_string($_SESSION['playerid'])."'";
      $oncrs = array();
      $oncrs = mysql_query($q_ry);

      $q_ry = array();
      $q_ry = "SELECT `a_ammount`,`a_time`
               FROM `bank_accounts`
               WHERE `a_playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'";
      $bnka = array();
      $bnka = mysql_query($q_ry);

      $q_ry = array();
      $q_ry = "SELECT `my_job`
               FROM `members_extra`
               WHERE `playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'";
      $mjb = array();
      $mjb = mysql_fetch_array(mysql_query($q_ry));

               $ep = (int)(($pl['my_energy']/$pl['my_maxenergy'])*160);
               if($ep > 160)
               {
                 $ep = 160;
               }
               $np=(int)(($pl['my_nerve']/$pl['my_maxnerve'])*160);
               if($np > 160)
               {
                 $np = 160;
               }
               $hp=(int)(($pl['my_happy']/$pl['my_maxhappy'])*160);
               if($hp > 160)
               {
                 $hp = 160;
               }
               $rsp=(int)(($pl['my_respect']/$pl['my_maxrespect'])*160);
               if($rsp > 160)
               {
                 $rsp = 160;
           }
      echo "<table cellspacing = '0' cellpadding = '0' border = '0' width = '190px'>
        <tr>
           <td width = '14px'></td>
           <td align = 'center'>
            <table width='96%' cellpadding='0' cellspacing='0'>
            <tr><td align = 'left' class='sidebarTitle'> Overview</td></tr>
            <tr><td align = 'center' class='sidebarPlayer'>
            <table width='99%' cellpadding='0' cellspacing='0' border = '0'><tr>
            <td colspan = '2' align = 'left'>
            <img src='images/".$pl['my_gender'].".gif' title = '".$pl['my_gender']."'>";
      if($mjb['my_job']) { echo "<img src='images/";
      if($mjb['my_job'] == '1') { echo "army.png' alt = 'Job: Army' title='Job: Army"; }
      if($mjb['my_job'] == '2') { echo "market.png' alt = 'Job: Grocer' title='Job: Grocer"; }
      if($mjb['my_job'] == '3') { echo "casino.png' alt = 'Job: Casino' title='Job: Casino"; }
      echo "'>"; }

      if($pl['my_faction']) {
      $q_ry = array();
      $q_ry = "SELECT `fac_name`
               FROM `faction_s`
               WHERE `fac_id` = '".mysql_real_escape_string($pl['my_faction'])."'";
      $fn = array();
      $fn = mysql_fetch_array(mysql_query($q_ry));
      echo "<img src='images/faction.png' alt = 'Faction: ".$fn['fac_name']."' title='Faction: ".$fn['fac_name']."'>";
      }
      if($pl['my_partner']) {
      $q_ry = array();
      $q_ry = "SELECT `playername`
               FROM `members`
               WHERE `playerid` = '".mysql_real_escape_string($pl['my_partner'])."'";
      $pn = array();
      $pn = mysql_fetch_array(mysql_query($q_ry));
      echo "<img src='images/spouse.png' alt = 'Spouse: ".$pn['playername']."' title='Spouse: ".$pn['playername']."'>";
      }
      if(mysql_num_rows($bnka)) {
      $bk = array();
      $bk = mysql_fetch_array($bnka);
      echo "<img src='images/bank.png' alt = 'Investment: ".money_alter($bk['a_ammount'])." - ".gettimeleft($bk['a_time'])."' title='Investment: ".money_alter($bk['a_ammount'])." - 
           ".gettimeleft($bk['a_time'])."'>";
      }
      if(mysql_num_rows($oncrs)) {
      $onc = array();
      $onc = mysql_fetch_array($oncrs);
      echo "<img src='images/education.png' alt = '".$onc['edu_name'].": ".gettimeleft($onc['lc_time'])."' title='".$onc['edu_name'].": ".gettimeleft($onc['lc_time'])."'>";
      }
      $q_ry = array();
      $q_ry = "SELECT `mi_time`,`mi_effect_left`,`mi_drug_id`
               FROM `member_influences`
               WHERE `mi_playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'
               AND `mi_time` >= '".mysql_real_escape_string(time())."'";
      $druggy = array();
      $druggy = mysql_query($q_ry);
      if(mysql_num_rows($druggy)) {
      $dr = array();
      $dr = mysql_fetch_array($druggy);
      $type = array(9=>'Ecstacey',100=>'Vicodin',79=>'Xanax');
      echo "<img src='images/drug.png' title='".$type[$dr['mi_drug_id']].": ".gettimeleft($dr['mi_time'])."'>";
      }
      if($pl['my_dondays']) { echo "<img src='images/donator.gif' alt = 'Donator: ".$pl['my_dondays']." Days left' title='Donator: ".$pl['my_dondays']." Days left'>"; }
if($pl['vipday']) { echo "<img src='images/vip.jpg' alt = 'VIP: ".$pl['vipday']." Days left' title='VIP: ".$pl['vipday']." Days left'>"; }
      if($pl['am_i_staff'] > 1) { echo "<img src='images/staff.png' title='Staff member'>"; }
      echo "</td></tr>
            </table>
            <table width='99%' cellpadding='0' cellspacing='0' style = 'background: url(../images/1.jpg) repeat-y center top; height:57px;' border = '0'>
            <tr><td width = '30%' align = 'left'><b>Name:</b> </td><td align = 'left'><a href='profile.php?XID=".$_SESSION['playerid']."'>",stripslashes(htmlentities($pl['playername'])),"</a> [",$_SESSION['playerid'],"]</td></tr>
            <tr><td align = 'left'><b>Money:</b> </td><td align = 'left'><span id = 'moneyc'>\$",number_format($pl['wallet']),"</span></td></tr>
            <tr><td align = 'left'><b>Level:</b> </td><td align = 'left'>".$pl['my_level'];
      $q_ry = array();
      $q_ry = "SELECT `my_experience`,`my_crimeexp`
               FROM `members_extra`
               WHERE `playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'";
      $lvl = array();
      $lvl = mysql_query($q_ry);
      $lv = mysql_fetch_array($lvl);
      if(($lv['my_experience']+($lv['my_crimeexp']/$pl['my_level'])) > exp_level($pl['my_level'])) { echo "</td><td align = 'center'>[<a href='levelup.php'>Upg</a>]"; }
      echo "</td></tr>
       <tr><td align = 'left'><b>Bars:</b> </td><td align = 'left'>",number_format($pl['my_points'])," </td><td align = 'center'>[<a href='bexchange.php'>use</a>]</td></tr>
      <tr><td align = 'left'><b>Merits:</b> </td><td align = 'left'>",number_format($pl['my_merits']),"</td><td align = 'center'>[<a href='mexchange.php'>use</a>]</td></tr>
      <tr><td align = 'left'><b>Credits:</b> </td><td align = 'left'>",number_format($pl['my_credits'])," </td><td align = 'center'>[<a href='creditshop.php'>use</a>]</td></tr>
      <tr><td align = 'left'><b>V-Point:</b> </td><td align = 'left'>",number_format($pl['vip_point'])," </td><td align = 'center'>[<a href='vipexchange.php'>use</a>]</td></tr>
            </table>
            <table width='99%' cellpadding='0' cellspacing='0' style = 'background: url(../images/1.jpg) no-repeat center top; height:93px; margin-bottom:3px;' border = '0'>
     <tr><td align = 'left' colspan = '2' height = '8px'></td></tr>
      <tr><td width = '40%' align = 'left'><b><span  rel = 'tooltip' title = '<b>Energy</b><img src = \"images/energy.gif\"><br/>Use energy for attacking and in the gym.'>Energy:</span></b> </td><td align = 'left'><span id = 'mie'><small>",$pl['my_energy'],"/",$pl['my_maxenergy'],"(";
      $loadtime = date('i')+1;
      if($pl['my_energy'] >= $pl['my_maxenergy'])
      {
      echo "full";
      }
      else
      {
      if($pl['my_dondays'])
      {
           if($loadtime > '50') { echo (60-$loadtime); }
      else if($loadtime > '40') { echo (50-$loadtime); }
      else if($loadtime > '30') { echo (40-$loadtime); }
      else if($loadtime > '20') { echo (30-$loadtime); }
      else if($loadtime > '10') { echo (20-$loadtime); }
      else if($loadtime > '00') { echo (10-$loadtime); }
      }
      else
      {
           if($loadtime > '45') { echo (60-$loadtime); }
      else if($loadtime > '30') { echo (45-$loadtime); }
      else if($loadtime > '15') { echo (30-$loadtime); }
      else if($loadtime > '00') { echo (15-$loadtime); }
      }
      echo "m:".(60-date('s'))."s";
      }
      echo ")</small></span></td></tr>
      <tr><td colspan = '2' align = 'center'><span id = 'sbe'><img src='images/bar_green.jpg' width = '".$ep."' height = '6px'><img src='images/bar_red.jpg' width = '".(160-$ep)."' height = '6px'></span></td></tr>
      <tr><td align = 'left'><b><span  rel = 'tooltip' title = '<b>Graft</b><img src = \"images/graft.gif\"><br/>Use graft for crimes.'>Graft:</span></b> </td><td align = 'left'><span id = 'mig'><small>",$pl['my_nerve'],"/",$pl['my_maxnerve'],"(";
      if($pl['my_nerve'] >= $pl['my_maxnerve'])
      {
      echo "full";
      }
      else
      {
           if($loadtime > '55') { echo (60-$loadtime); }
      else if($loadtime > '50') { echo (55-$loadtime); }
      else if($loadtime > '45') { echo (50-$loadtime); }
      else if($loadtime > '40') { echo (45-$loadtime); }
      else if($loadtime > '35') { echo (40-$loadtime); }
      else if($loadtime > '30') { echo (35-$loadtime); }
      else if($loadtime > '25') { echo (30-$loadtime); }
      else if($loadtime > '20') { echo (25-$loadtime); }
      else if($loadtime > '15') { echo (20-$loadtime); }
      else if($loadtime > '10') { echo (15-$loadtime); }
      else if($loadtime > '05') { echo (10-$loadtime); }
      else if($loadtime > '00') { echo (05-$loadtime); }
      echo "m:".(60-date('s'))."s";
      }
      echo ")</small></span></td></tr>
      <tr><td colspan = '2' align = 'center'><span id = 'sbg'><img src='images/bar_grey.jpg' width = '".$np."' height = '6px'><img src='images/bar_red.jpg' width = '".(160-$np)."' height = '6px'></span></td></tr>
      <tr><td align = 'left'><b><span  rel = 'tooltip' title = '<b>Happy</b><img src = \"images/happy.gif\"><br/>The more happy you are the better you train your stats.'>Happy:</span></b> </td><td align = 'left'><span id = 'mih'><small>",$pl['my_happy'],"/",$pl['my_maxhappy'],"(";
      if($pl['my_happy'] >= $pl['my_maxhappy'])
      {
      echo "full";
      }
      else
      {
           if($loadtime > '45') { echo (60-$loadtime); }
      else if($loadtime > '30') { echo (45-$loadtime); }
      else if($loadtime > '15') { echo (30-$loadtime); }
      else if($loadtime > '00') { echo (15-$loadtime); }
      echo "m:".(60-date('s'))."s";
      }
      echo ")</small></span></td></tr>
      <tr><td colspan = '2' align = 'center'><span id = 'sbh'><img src='images/bar_blue.jpg' width = '".$hp."' height = '6px'><img src='images/bar_red.jpg' width = '".(160-$hp)."' height = '6px'></span></td></tr>
      <tr><td align = 'left'><b><span  rel = 'tooltip' title = '<b>Ruthless</b><img src = \"images/ruthless.gif\"><br/>Get full ruthless to gain a Energy, Graft and happy boost.'>Ruthless:</span></b> </td><td align = 'left'><small>",$pl['my_respect'],"/",$pl['my_maxrespect'],"</small></td></tr>
      <tr><td colspan = '2' align = 'center'><img src='images/bar_gold.jpg' width = '".$rsp."' height = '6px'><img src='images/bar_red.jpg' width = '".(160-$rsp)."' height = '6px'></td></tr></table>
      </td></tr>
      <tr><td align='left'>
      <table width='100%' cellpadding='0' cellspacing='0' style = 'padding-top:0px;'>";
include_once('navigation.php');
    echo "</td>
            <td align='center' valign='top' width = '80%'>
            <table cellspacing = '0' cellpadding = '0' border = '0' width = '100%'>
        <tr>


           <center><a href='donate.php'>*Become a donator today and receive a 150 energy bar + loads more!(LTD:<b>Gold Baseball bat</b>[<a href='iinfo.php?XID=110'>View</a>])*</a></center><br/>";


   if($pl['my_tuts_on'] == 'yes')
   {
      $q_ry = array();
      $q_ry = "SELECT `tut_text`
               FROM `tutorial_pages`
               WHERE `tut_page` = '".(str_replace("/", "", $_SERVER['SCRIPT_NAME']))."'";
      $paget = array();
      $paget = mysql_query($q_ry);
      if(mysql_num_rows($paget))
      {
      $pt = array();
      $pt = mysql_fetch_array($paget);
    echo "<center><table class='CityLink' width = '50%'>
            <tr><td class='CityLink' align = 'left' width = '80%' valign = 'top'>
            <u><b>Murder Tutorials:-</b></u><br/><br/>
            ".stripslashes($pt['tut_text'])."
            </td>
            <td class='CityLink' align = 'center' bgcolor = '#FFFFFF' width = '20%' valign = 'top'>
            <img src = 'images/tutbulb.png'><br/>
            [<a href='preferences.php?action=tutchange'>Switch off</a>]
            </td></tr></table></center><br/>";
      }
   }


    $q_ry = array();
    $q_ry = "SELECT *
             FROM `active_missions` am
             LEFT JOIN `game_missions` m ON
             am.am_mission = m.m_id
             WHERE am.am_playerid = '".mysql_real_escape_string($_SESSION['playerid'])."'";
    $active = array();
    $active = mysql_query($q_ry);
    if(mysql_num_rows($active))
    {
        $a = array();
        $a = mysql_fetch_array($active);
        if(($a['am_time']-time()) <= '0')
        {
                          $q_ry = array();
                          $q_ry = "INSERT INTO `member_mail`
                                   VALUES ('NULL',
                                           '".mysql_real_escape_string($_SESSION['playerid'])."',
                                           '".mysql_real_escape_string($a['m_playerid'])."',
                                           'Failed!',
                                           '".mysql_real_escape_string($a['m_failmessage'])."',
                                           unix_timestamp(),
                                           '0')";
                          mysql_query($q_ry);
           $q_ry = array();
           $q_ry = "DELETE FROM `active_missions`
                    WHERE `am_playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'";
           mysql_query($q_ry);
        }
        else
        {
        echo "<center><a href='missions.php?action=details'><font color = 'red'><b>You have ".gettimeleft($a['am_time'])." to finish the mission</font> ".stripslashes($a['m_name'])."</b></a></center>";
        }
    }
    echo "<img src = 'images/ieodd.png' style = 'display: none;'>
          <img src = 'images/ieeven.png' style = 'display: none;'>
          <img src = 'images/iehover.png' style = 'display: none;'>
          <img src = 'images/ieodds.png' style = 'display: none;'>
          <img src = 'images/ieevens.png' style = 'display: none;'>
          <img src = 'images/iehovers.png' style = 'display: none;'>";
?>
Edited by Hybridd
NonStopCoding Newbie

NonStopCoding

Posted
Posted 
$jorh = mysql_query("SELECT `my_jail`,`colour`,`my_hosp` FROM `members` WHERE
            `playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'");
            $joh = array();
            $joh = mysql_fetch_array($jorh);

 

i doubt you are missing the members sql but could be missing a field check that you have all 3 stated `my_jail`,`colour`,`my_hosp`

also same with this error check that you have all

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/reakcity/public_html/includes/style_top.php on line 1004

NonStopCoding Newbie

NonStopCoding

Posted
Posted

also in my copy of rc its like this

 

$ep = array();
$ep = (int)(($pl['my_energy']/$pl['my_maxenergy'])*100);
if($ep > 100)
{
   $ep = 100;
}
$np = array();
$np=(int)(($pl['my_nerve']/$pl['my_maxnerve'])*100);
if($np > 100)
{
   $np = 100;
}
$hp = array();
$hp=(int)(($pl['my_happy']/$pl['my_maxhappy'])*100);
if($hp > 100)
{
   $hp = 100;
}
$rsp = array();
$rsp=(int)(($pl['my_respect']/$pl['my_maxrespect'])*100);
if($rsp > 100)
{
  $rsp = 100;
}
lucky3809 Newbie

lucky3809

Posted
Posted (edited)

On line 950 and 1004, look at the main query, is those fields in the database? Are they spelt correctly? Usually that is the problem why it throws that error. Also make sure you are not using the same variable twice, that also gives that error try renaming them.

Edited by lucky3809
MrAnthony Newbie

MrAnthony

Posted
Posted

Urgg.... Ive been reading this thinking *hand over face* Well Ive actually been using rc for a while then stopped for a year, just recently ive come back into contact with it, SO if you need help! just throw me an inbox.

  • 2 weeks later...
Magictallguy Collaborator

Magictallguy

Posted
Posted

Find the first instance of:

<?php

Add below:

if(!isset($_SESSION['playerid']) || empty($_SESSION['playerid']) || !is_int($_SESSION['playerid']))
   exit;

 

Find:

$q_ry = "SELECT `e_id`
   FROM `member_events`
   WHERE `e_playerid` = '".mysql_real_escape_string($_SESSION['playerid'])."'
   AND `e_read` = '0'";

Replace with:

$q_ry = "SELECT `e_id` FROM `member_events` WHERE `e_read` = 0 AND `e_playerid` = ".$_SESSION['playerid'];

 

Find and remove:

$evs = array();

 

Find:

$evs = mysql_query($q_ry);

Replace with:

$evs = mysql_query($q_ry) or exit(mysql_error());

 

Optional edits:

Find:

if(mysql_num_rows($evs)){echo "$sound"; }

Replace with:

if(mysql_num_rows($q_ry))
   echo $sound;

 

Find (around line 942):

if($_SESSION['attacking'])
{
header('location:run.php');
}

Replace with:

if(isset($_SESSION['attacking'])) {
   header('Location: run.php');
   exit;
}

 

Find any instance of:

mysql_real_escape_string($_SESSION['playerid'])

Replace all with:

$_SESSION['playerid']

 

Also: Test all queries!

If it's failing, you want it to fail so you can debug it (and prevent it from failing again)

 

And, of course, it should go without saying..

Upgrade yourself to MySQLi at the very least!

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...