Hybridd Posted June 16, 2014 Posted June 16, 2014 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 Quote
DidNotCompute Posted June 16, 2014 Posted June 16, 2014 For your first error, the query probably failed (for any number of reasons). Division by zero means your dividing by 0 i.e. NULL. Quote
Hybridd Posted June 16, 2014 Author Posted June 16, 2014 (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 June 16, 2014 by Hybridd Quote
NonStopCoding Posted June 16, 2014 Posted June 16, 2014 $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 Quote
NonStopCoding Posted June 16, 2014 Posted June 16, 2014 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; } Quote
NonStopCoding Posted June 16, 2014 Posted June 16, 2014 ALTER TABLE `members` ADD `color` int(11) NOT NULL DEFAULT '0' try that Quote
DidNotCompute Posted June 16, 2014 Posted June 16, 2014 ALTER TABLE `members` ADD `color` int(11) NOT NULL DEFAULT '0' try that Why are you using INT here? Are the colours assigned to integer values? Quote
lucky3809 Posted June 16, 2014 Posted June 16, 2014 (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 June 16, 2014 by lucky3809 Quote
MrAnthony Posted June 16, 2014 Posted June 16, 2014 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. Quote
Magictallguy Posted June 30, 2014 Posted June 30, 2014 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! Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.