[Website] Realm Status Error

[singoe]

Alright. Im having some trouble with the realm status for my Website. here are the errors it shows.

Northern Lights Fun Realm

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\includes\status.php on line 12
ONLINE: /2000

Here is my status.php

<!--// Written and coded by Gilles De Mey
// Copyrighted by the GNU GENERAL PUBLIC LICENSE (c)-->
<?php include('../includes/config.php'); ?>
<div class="side-content-realm"><b><?php echo $realm1; ?></b></div>
		  <?php
          if (test_serv() == "true")
              {
			  $con = mysql_connect($sqlip, $sqluser, $sqlpass);	  
              $db = mysql_select_db($arc_character);
              $query ="SELECT * from characters where online='1' "; 
              $result = mysql_query($query);
              $num = mysql_num_rows($result);
              echo "<div id='player_bar_online'>ONLINE: " . $num . "/".$maxplayers."</div>";
			  mysql_close($con);
              } else
              {
              echo "<div id='player_bar_offline'><font color='#FFFFFF'>SERVER OFFLINE</font></div>";
			  mysql_close($con);
              }
              
          function test_serv(){
              $errno = 6;
              $s = @fsockopen('xx.xxx.xxx.xx', 8093, $errno, $errstr, 2);
              if($s){
                  fclose($s);
                  return true;
                  } else 
                  return false;
          }
          ?>
        </div>

I noticed that whenever I refresh the page something shows up on my logonserver. It says "Server connection from 10.0.1.1:43368 DENIED, not an allowed IP." I'm guessing that has to do with the problem. Also when i try creating an account on the website i get "Mysql Error : Field 'banned' doesn't have a default value" how do i make it so the default value of 'banned' is 0.

[Kiev]

Create a account specifically for the website, and allow it from all hosts, (Do this in something like navicat or a managing program like that), then set the details to that.

You will have to edit the account creation script's SQL import, if you know basic SQL that should be easy.