UberCMS Error

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

Attachment 132319

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.

Quote:

---

Originally Posted by 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.

---

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

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

Code:

---

<?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);

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

how can i disable this warning?

Quote:

---

Originally Posted by skelonton30

how can i disable this warning?

---

Google will help you out (:

Quote:

---

Originally Posted by BaasHotel

Google will help you out (:

---

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

Quote:

---

Originally Posted by skelonton30

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

---

You can try to change

PHP Code:

---

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


---

To

PHP Code:

---

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


---

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:

PHP Code:

---

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);
} 


---

Quote:

---

Originally Posted by 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:

PHP Code:

---

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

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

Quote:

---

Originally Posted by flx5

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);

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

Quote:

---

Originally Posted by flx5

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

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

Quote:

---

Originally Posted by flx5

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 )

Execute

Code:

---

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

---

and use your original inc.core.php

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

Quote:

---

Originally Posted by XiFy

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

Quote:

---

Originally Posted by flx5

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!

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

Quote:

---

Originally Posted by 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

---

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.

Quote:

---

Originally Posted by flx5

Execute

Code:

---

"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?

Sry, I was a bit unprecise...
You should execute the query above with PHPMyAdmin and then replace

PHP Code:

---

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);
} 


---

with

PHP Code:

---

public static function GetMaintenanceStatus()
{
   return mysql_result(dbquery("SELECT maintenance FROM site_config LIMIT 1"),0);
} 


---

Quote:

---

Originally Posted by flx5

Sry, I was a bit unprecise...
You should execute the query above with PHPMyAdmin and then replace

PHP Code:

---

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);
} 


---

with

PHP Code:

---

public static function GetMaintenanceStatus()
{
   return mysql_result(dbquery("SELECT maintenance FROM site_config LIMIT 1"),0);
} 


---

---

Now the website is a Parent Dictionary

what???? Did you delete your index file or what?

Do you test upon localhost or do you have a live site?

Quote:

---

Originally Posted by flx5

what???? Did you delete your index file or what?

Do you test upon localhost or do you have a live site?

---

hold up, i think i accidentally deleted something lmfao.

EDIT

ye i deleted index and stuff, but i put it back and theres no more error. Thanks dude