UberCMS Error

[skelonton30]

Hey, so I've upgraded to UberCMS recently, and I've come across an annoying error which I do not understand, and therefore cannot fix. This is what it says, and here is a screenie.

Notice: Constant LB already defined in C:\xampp\htdocs\global.php on line 120

Notice: Constant INCLUDES already defined in C:\xampp\htdocs\global.php on line 121

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 18 in C:\xampp\htdocs\includes\class.core.php on line 191

[MentaL]

[Roper]

Your php/mysql version is too high, I'd recommend you downgrade versions.

If you're using XAMPP, uninstall it and install XAMPP 1.7.1 to fix this issue.

[skelonton30]

Your php/mysql version is too high, I'd recommend you downgrade versions.

If you're using XAMPP, uninstall it and install XAMPP 1.7.1 to fix this issue.

Now it says

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 17 in C:\xampp\htdocs\includes\class.core.php on line 191

[Roper]

Post the contents of "includes/class.core.php" please - or copy and paste line 191 for me

[skelonton30]

<?php
/*=======================================================================
| UberCMS - Advanced Website and Content Management System for uberEmu
| #######################################################################
| Copyright (c) 2010, Roy 'Meth0d' & Jonty McIntyre
| http://www.meth0d.org
| #######################################################################
| This program is free software: you can redistribute it and/or modify
| it under the terms of the GNU General Public License as published by
| the Free Software Foundation, either version 3 of the License, or
| (at your option) any later version.
| #######################################################################
| This program is distributed in the hope that it will be useful,
| but WITHOUT ANY WARRANTY; without even the implied warranty of
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
| GNU General Public License for more details.
\======================================================================*/

class uberCore
{
	public $config;
	public $execStart;
	
	public function __construct()
	{
		$this->execStart = microtime(true);
	}	
	
	public static function CheckBetaKey($keyCode)
	{
		return (mysql_num_rows(dbquery("SELECT null FROM betakeys WHERE keyc = '" . filter($keyCode) . "' AND qty > 0 LIMIT 1")) > 0) ? true : false;
	}
	
	public static function EatBetaKey($keyCode)
	{
		dbquery("UPDATE betakeys SET qty = qty - 1 WHERE keyc = '" . filter($keyCode) . "' LIMIT 1");
	}
	public static function zapHash($text)
	{
		return sha1(md5($text));
	}
	public static function CheckCookies()
	{
		if (LOGGED_IN)
		{
			return;
		}
	
		if (isset($_COOKIE['rememberme']) && $_COOKIE['rememberme'] == "true" && isset($_COOKIE['rememberme_token']) && isset($_COOKIE['rememberme_name']))
		{
			$name = filter($_COOKIE['rememberme_name']);
			$token = filter($_COOKIE['rememberme_token']);
			$find = dbquery("SELECT id,username FROM users WHERE username = '" . $name . "' AND password = '" . $token . "' LIMIT 1");
			
			if (mysql_num_rows($find) > 0)
			{
				$data = mysql_fetch_assoc($find);
				
				$_SESSION['UBER_USER_N'] = $data['username'];
				$_SESSION['UBER_USER_H'] = $token;
				$_SESSION['set_cookies'] = true; // renew cookies
				
				header("Location: " . WWW . "/security_check");
				exit;				
			}
		}
	}
	
	public static function FormatDate()
	{
		return date('j F Y, h:i:s A');
	}
	
	public function UberHash($input = '')
	{
		return md5($input);
	}
	
	public static function GenerateTicket($seed = '')
	{
		$ticket = "ST-";
		$ticket .= sha1($seed . 'Uber' . rand(118,283));
		$ticket .= '-' . rand(100, 255);
		$ticket .= '-uber-fe' . rand(0, 5);
		
		return $ticket;
	}

	public static function FilterInputString($strInput = '')
	{
		return mysql_real_escape_string(stripslashes(trim($strInput)));
	}
	
	public static function FilterSpecialChars($strInput, $allowLB = false)
	{
		$strInput = str_replace(chr(1), ' ', $strInput);
		$strInput = str_replace(chr(2), ' ', $strInput);
		$strInput = str_replace(chr(3), ' ', $strInput);
		$strInput = str_replace(chr(9), ' ', $strInput);
		
		if (!$allowLB)
		{
			$strInput = str_replace(chr(13), ' ', $strInput);
		}
		
		return $strInput;
	}
	
	public static function CleanStringForOutput($strInput = '', $ignoreHtml = false, $nl2br = false)
	{
		$strInput = stripslashes(trim($strInput));

		if (!$ignoreHtml)
		{
			$strInput = htmlentities($strInput);
		}
		
		if ($nl2br)
		{
			$strInput = nl2br($strInput);
		}

		return $strInput;
	}

	public static function SystemError($title, $text)
	{
		echo "<font face='verdana'><center>UberCMS has encountered an error <br /> " . $text . " </font></center>";
		exit;		
	}
	
	public function ParseConfig()
	{
		$configPath = config_directory . 'system_config.php';
		
		if (!file_exists($configPath))
		{
			$this->systemError('Configuration Error', 'The configuration file could not be located at ' . $configPath);
		}
		
		require_once $configPath;
		
		if (!isset($config) || count($config) < 2)
		{
			$this->systemError('Configuration Error', 'The configuration file was located, but is in an invalid format. Data is missing or in the wrong format.');
		}
		
		$this->config = $config;
		
		define('WWW', $this->config['Site']['www']);
	}
	
	public static function GetSystemStatusString($statsFig)
	{
		$amt = number_format(mysql_result(dbquery("SELECT `users_online` FROM `server_status`"), 0));
		
		switch (uberCore::getSystemStatus())
		{
			case 2:
			case 0:	return $amt . " " . regOnlineText;
				
			case 1:
			
				if (!$statsFig)
				{
					return $amt . " " . regOnlineText;
				}
				else
				{
					return  "<b><font color='black'> " . $amt  . '</font color></b> ' . regOnlineText;
				}
		
			default:
			
				return "Unknown";
		}
	}
	
	public static function GetSystemStatus()
	{
		return intval(mysql_result(dbquery("SELECT status FROM server_status LIMIT 1"), 0));
	}
	
	public static function GetUsersOnline()
	{
		return intval(mysql_result(dbquery("SELECT users_online FROM server_status"), 0));
	}
	
	public static function GetMaintenanceStatus()
	{
		return mysql_result(dbquery("SELECT maintenance FROM site_config LIMIT 1"), 0);
	}
	
	public function Mus($header, $data = '')
	{
		if ($this->config['MUS']['enabled'] == "false" || $this->getSystemStatus() == "0")
		{
			return;
		}
		
		$musData = $header . chr(1) . $data;
		
		$sock = @socket_create(AF_INET, SOCK_STREAM, getprotobyname('tcp'));
		@socket_connect($sock, $this->config['MUS']['ip'], intval($this->config['MUS']['port']));
		@socket_send($sock, $musData, strlen($musData), MSG_DONTROUTE);	
		@socket_close($sock);
	}

	
	public static function AddBan($type, $value, $reason, $expireTime, $addedBy, $blockAppeal)
	{
		dbquery("INSERT INTO bans (id,bantype,value,reason,expire,added_by,added_date,appeal_state) VALUES (NULL,'" . $type . "','" . $value . "','" . $reason . "','" . $expireTime . "','" . $addedBy . "','" . date('d/m/Y H:i') . "','" . (($blockAppeal) ? '0' : '1') . "')");
	}
	 public static function fixText($str, $quotes = true, $clean = false, $ltgt = false, $transform = false, $guestbook = false)
    {
		$str = str_replace("&Acirc;", "Â", $str);
        $str = str_replace("¡", "¡", $str);
        $str = str_replace("¿", "¿", $str);
        $str = str_replace("í‘", "Ñ", $str);
        $str = str_replace("ñ", "ñ", $str);
        $str = str_replace("í", "Á", $str);
        $str = str_replace("á", "á", $str);
        $str = str_replace("í‰", "É", $str);
        $str = str_replace("é", "é", $str);
        $str = str_replace("í“", "Ó", $str);
        $str = str_replace("ó", "ó", $str);
        $str = str_replace("íš", "Ú", $str);
        $str = str_replace("ú", "ú", $str);
        $str = str_replace("í", "Í", $str);
        $str = str_replace("ä", "ä", $str);
        $str = str_replace("­", "", $str);
        $str = str_replace("Ã", "í", $str);
        $str = str_replace(")", "&#x29;", $str);
        $str = str_replace("(", "&#x28;", $str);
		$str = str_replace("Â¥", "¥", $str);
		$str = str_replace("\\\\r\\\\n", "<br />", $str);
		$str = str_replace("\\\\\\\\r\\\\\\\\n", "<br />", $str);
        $str = str_replace("\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'", "&apos;", $str);
        $str = str_replace("\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;", "&#x22;", $str);
        $str = str_replace("\'", "'", $str);
        $str = str_replace('\"', '"', $str);
        $str = str_replace("\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"", "&#x22;", $str);
        $str = str_replace("\\\\\\\\\\\\\\\\r\\\\\\\\\\\\\\\\n", "<br />", $str);
        $str = str_replace('\\\\n', "<br />", $str);
        $str = str_replace('\\\\\\\\\\\\"', '"', $str);
        $str = str_replace('\\\\r\\\\n', "<br />", $str);
        $str = str_replace('\\\\\\\\r\\\\\\\\n', "<br />", $str);
		$str = str_replace('\r\n', "<br />", $str);
		$str = str_replace('\\', "", $str);
        
        if ($quotes) {
            $str = str_replace('"', "&#x22;", $str);
            $str = str_replace("'", "&apos;", $str);
        }
        
        
        
        if ($clean) {
            $str = str_replace("Ñ", "N", $str);
            $str = str_replace("ñ", "n", $str);
            $str = str_replace("Á", "A", $str);
            $str = str_replace("á", "a", $str);
            $str = str_replace("É", "E", $str);
            $str = str_replace("é", "e", $str);
            $str = str_replace("Ó", "O", $str);
            $str = str_replace("ó", "o", $str);
            $str = str_replace("Ú", "U", $str);
            $str = str_replace("ú", "u", $str);
            $str = str_replace("Í", "I", $str);
            $str = str_replace("í", "i", $str);
        }
        
        if ($ltgt) {
            $str = str_replace("<", "&lt;", $str);
            $str = str_replace(">", "&gt;", $str);
        }
        
        if ($transform) {
            $str = str_replace("'", '"', $str);
        }
		
		if($guestbook) {
			$str = str_replace("&lt;br /&gt;", '<br />', $str);
			$str = str_replace("&lt;b&gt;", '<b>', $str);
			$str = str_replace("&lt;/b&gt;", '</b>', $str);
			$str = str_replace("&lt;u&gt;", '<u>', $str);
			$str = str_replace("&lt;/u&gt;", '</u>', $str);
			$str = str_replace("&lt;i&gt;", '<i>', $str);
			$str = str_replace("&lt;/i&gt;", '</i>', $str);
			$str = str_replace("&lt;/i&gt;", '<br />', $str);
			$str = preg_replace("/\&lt;a href=\"(.*?)\"\&gt;(.*?)\&lt;\/a&gt;/is", "<a href=\"$1\" target=\"_blank\">$2</a>", $str);
			$str = preg_replace("/\&lt;div class=\"bbcode-quote\"\&gt;(.*?)\&lt;\/div&gt;/is", "<div class=\"bbcode-quote\">$1</div>", $str);
			$str = preg_replace("/\&lt;span style=\"(.*?)\"\&gt;(.*?)\&lt;\/span&gt;/is", "<span style=\"$1\">$2</span>", $str);
			$str = preg_replace("/\&lt;span style=\"font-size: 14px\"\&gt;(.*?)\&lt;\/span&gt;/is", "<span style=\"font-size: 14px\">$1</span>", $str);
		}
        
        
        
        return $str;
    }
    
    public static function CheckComment($comment = '')
    {
		$comment = strtolower($comment);
	
        $denied  = array(
            'puto',
			'puta',
            'mierda',
            'aaaaaaaaaaaaaaaaaaaaaaaa',
            'cabrones',
            'http',
            '.com',
            '.org',
            '.net',
            '.info'
        );
        $allowed = array(
            'youtube',
            'facebook',
            'xukys',
            'google'
        ); 
        
        foreach ($denied as $deny) {
            if (strstr($comment, $deny)) {
                foreach ($allowed as $allow) {
                    if (strstr($comment, $allow)) {
                        return true;
                    }
                }
                
                uberCore::AddPermBan('user', $_SESSION['UBER_USER_N'], $comment);
                return false;
            }
            
        }
        
        return true;
    }
    
    
    
    public static function GenRandom()
    {
        return substr(md5(uniqid(rand())), 0, 15);
    }
    
    
    public static function BBcode($texto)
    {
        $texto = htmlentities($texto);
        $a     = array(
            "/\[i\](.*?)\[\/i\]/is",
            "/\[b\](.*?)\[\/b\]/is",
            "/\[u\](.*?)\[\/u\]/is",
            "/\[quote\](.*?)\[\/quote\]/is",
            "/\[url=(.*?)\](.*?)\[\/url\]/is",
			"/\[color=red\](.*?)\[\/color\]/is",
			"/\[color=orange\](.*?)\[\/color\]/is",
			"/\[color=yellow\](.*?)\[\/color\]/is",
			"/\[color=green\](.*?)\[\/color\]/is",
			"/\[color=cyan\](.*?)\[\/color\]/is",
			"/\[color=blue\](.*?)\[\/color\]/is",
			"/\[color=gray\](.*?)\[\/color\]/is",
			"/\[color=black\](.*?)\[\/color\]/is",
			"/\[size=large\](.*?)\[\/size\]/is",
			"/\[size=small\](.*?)\[\/size\]/is"
        );
        $b     = array(
            "<i>$1</i>",
            "<b>$1</b>",
            "<u>$1</u>",
            "<div class=\"bbcode-quote\">$1</div>",
            "<a href=\"$1\" target=\"_blank\">$2</a>",
			"<span style=\"color: #d80000\">$1</span>",
			"<span style=\"color: #fe6301\">$1</span>",
			"<span style=\"color: #ffce00\">$1</span>",
			"<span style=\"color: #6cc800\">$1</span>",
			"<span style=\"color: #00c6c4\">$1</span>",
			"<span style=\"color: #0070d7\">$1</span>",
			"<span style=\"color: #828282\">$1</span>",
			"<span style=\"color: #000000\">$1</span>",
			"<span style=\"font-size: 14px\">$1</span>",
			"<span style=\"font-size: 9px\">$1</span>"
        );
        $texto = preg_replace($a, $b, $texto);
        $texto = nl2br($texto);
        return $texto;
    }

	public static function GenerateRandom($length = 0, $letters = true, $numbers = false, $other = false)
	{
		$data = "";
		$possible = "";
		$i = 0;
		
		if($letters)
		{
			$possible .= "abcdefhijkl"; 
		}
		
		if($numbers)
		{
			$possible .= "0123456789";
		}
		
		if($other)
		{
			$possible .= "ABCDEFHIJKL@%&^*/(){}";
		}
		
		while ($i < $length) 
		{ 
			$char = substr($possible, mt_rand(0, strlen($possible)-1), 1);
			$data .= $char;
			$i++;
		}
		return $data;
	}
}
?>

Line 191 =

return mysql_result(dbquery("SELECT maintenance FROM site_config LIMIT 1"), 0);

[Gaby]

It's just a warning, you don't have to worry about it. You can disable warnings at XAMPP.

[skelonton30]

how can i disable this warning?

[Gaby]

how can i disable this warning?

Google will help you out (:

[skelonton30]

Google will help you out (:

Still shows the warning. Can I get a fix that doesn't involve changing like, actual XAMPP files?

[Gaby]

Still shows the warning. Can I get a fix that doesn't involve changing like, actual XAMPP files?

You can try to change

return mysql_result(dbquery("SELECT maintenance FROM site_config LIMIT 1"), 0); 

To

return intval(mysql_result(dbquery("SELECT maintenance FROM site_config LIMIT 1"), 0)); 

[flx5]

1. Never suppress warnings, only in production mode...
2. intval isn't a real solution as it's a error within the database.
Have you ever checked wether there is a column named maintenance within site_config?
If it's there then try what this code says:

public static function GetMaintenanceStatus()
{
   $sql = dbquery("SELECT maintenance FROM site_config LIMIT 1");
   if(!$sql) 
      echo mysql_error();
   else
      echo "MYSQL SEEMS OK";

   if(mysql_num_rows($sql) != 1) 
      echo "MYSQL DOES NOT RETURN ANYTHING";
   else 
      echo "EVERYTHINGS OK";
   
   return mysql_result($sql,0);
} 

[skelonton30]

1. Never suppress warnings, only in production mode...
2. intval isn't a real solution as it's a error within the database.
Have you ever checked wether there is a column named maintenance within site_config?
If it's there then try what this code says:

public static function GetMaintenanceStatus()
{
   $sql = dbquery("SELECT maintenance FROM site_config LIMIT 1");
   if(!$sql) 
      echo mysql_error();
   else
      echo "MYSQL SEEMS OK";

   if(mysql_num_rows($sql) != 1) 
      echo "MYSQL DOES NOT RETURN ANYTHING";
   else 
      echo "EVERYTHINGS OK";
   }
   return mysql_result($sql,0);
} 

How do I run this code? I made a PHP file with this text in, went to the url but it was just text

[flx5]

I meant that you should replace the method in line 191 with this one

[skelonton30]

I meant that you should replace the method in line 191 with this one

Parse error: parse error, expecting `T_FUNCTION' in C:\xampp\htdocs\includes\class.core.php on line 202

Line 202 is: return mysql_result($sql,0);

[flx5]

Sorry, somehow I've got a "}" too much into the code...
Just corrected it so try again now.

[skelonton30]

Sorry, somehow I've got a "}" too much into the code...
Just corrected it so try again now.

Now it says

MYSQL SEEMS OKMYSQL DOES NOT RETURN ANYTHING
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 17 in C:\xampp\htdocs\includes\class.core.php on line 202

[flx5]

That's strange...
What happens when you enter this within PHPMyAdmin:
SELECT maintenance FROM site_config LIMIT 1;

[skelonton30]

That's strange...
What happens when you enter this within PHPMyAdmin:
SELECT maintenance FROM site_config LIMIT 1;

It says in the green box: MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0004 sec )

[flx5]

Execute

 "INSERT INTO site_config (maintenance) VALUES (1);

and use your original inc.core.php

[KyleeIsProzZ]

I had this issue before, I just did this.
and it seemed to fix it.

TRUNCATE TABLE `site_config`

I'm sorry if it doesn't for you.


Kind Regards,
XiFy

[flx5]

I had this issue before, I just did this.
and it seemed to fix it.

TRUNCATE TABLE `site_config`

I'm sorry if it doesn't for you.


Kind Regards,
XiFy

Truncate would empty the table, and as it says it gets a empty result set, exactly that's the problem...

[KyleeIsProzZ]

Truncate would empty the table, and as it says it gets a empty result set, exactly that's the problem...

Well, I just ran this query and that jump to MySQL error was gone!

[flx5]

Yeah, but" i just ran this query" isn't any explanation and if you know about MySQL then you'd be able to read the error message.
Perhaps you've got a cms that automatically returns 0 when it doesn't receive any data

[KyleeIsProzZ]

Yeah, but" i just ran this query" isn't any explanation and if you know about MySQL then you'd be able to read the error message.
Perhaps you've got a cms that automatically returns 0 when it doesn't receive any data

I don't really know about MySQL,
All I know is half of C# and PHP i'm learning the rest.

And I use the exact CMS as the OP is using.

[skelonton30]

Execute

 "INSERT INTO site_config (maintenance) VALUES (1);

and use your original inc.core.php

What do you mean by 'using my original inc.core.php'? How can I use that in SQL?