uberCMS/rCMS [PHP,OOP] Fixed Updated [Phoenix]

Quote:

---

Originally Posted by Subway

Theres no Error uberCMS doesn't worked unless in root folder for e.g

C:/xampp/htdocs
not C:/xampp/htdocs/habbo1 it won't work like that <:mad:

---

Alright thanks . ill try that out lol

Can someone uplaod the SQL to another site? the link doesn't work anymore.

Just wondering, but is there a guide out for this? :P

http://i41.tinypic.com/4kgpl.png

This issue above has now been resolved, now i have another issue when i try to register, any help would be appreciated :] Register Issue:

http://i41.tinypic.com/10og11i.png

One more thing, my registering page looks nothing like the example you gave..

http://i39.tinypic.com/1z3t00l.png

EVERYTHING RESOLVED ABOVE THANKS TO Poizone2!

Next Issue:

Where is all the tabs? I can only see Housekeeping because I edited myself in phpmyadmin.. And also I can't edit things like dcr's in HK..

http://i40.tinypic.com/2s01bo0.png

ALTER TABLE users ADD expert enum('1','0') collate utf8_unicode_ci NOT NULL default '0';

Also update your webbuild...

Then Bam :)

I need a new download for the DB please, thanks:)

Client's not working and when i click Enter hotel it goes to http://yourip/vote
when i need it /client

please help me even if i type in myip/client in url box
it don't even show, anything just white and it's not my Dcr's or Swf's
something to do with CMS please help me

I set it up, but I think the CSS or something has messed up, how do I fix?

http://puu.sh/g2KC

Quote:

---

Originally Posted by ѕуѕтєм

This isn't a support section, and this thread has nothing to do with the emulator, and it's not urgent, but because I'm nice, I'll help you, run this query in your database:

PHP Code:

---

ALTER TABLE `rooms` ADD `wallthick` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `rooms` ADD `floorthick` int(1) NOT NULL DEFAULT '0'; 


---

---

:o omg thanks! :D

Quote:

---

Originally Posted by Funixeh

I set it up, but I think the CSS or something has messed up, how do I fix?

http://puu.sh/g2KC

---

You Need to update your webbuild in class.tpl file ;3

--

Thanks for this release Subway! ;D
:thumbup:

Quote:

---

Originally Posted by zuc0001

You Need to update your webbuild in class.tpl file ;3

--

Thanks for this release Subway! ;D
:thumbup:

---

I get a 500.0 Internal Web Server when I try to enter the client. It's a Vote.PHP problema.

Quote:

---

Originally Posted by Pascal.de

Now i have the problem that my client is white -.-

I edited the config, the client-tpl and the externals..
Can someone help?

---

Its yuor SWF I think

This looks very good. You got my vote! :thumbup:

Which one Emulator is recommendet for this CMS please Help :(

Dude read the title Uber or Phoenix :huh:

Quote:

---

Originally Posted by Subway

Dude read the title Uber or Phoenix :huh:

---

Subway, want to add groups & homes into this (;
I could help you getting group files etc

ADD them I CBF adding them & Re uploading whole cms & with New Phoenix 3.7.1 this won't work unless you add a few new things.

Yo the link to download the database doesnt work it comes up with an internal server error ;p

Heres fixed link to database uber-phoenx2 (12).sql
:closedeyes:

Could anyone here, help me make a r63/v26? if so please message me or add me on MSN - trick104@hotmail.com

thank you ;)

Very good !!!!

Subway btw nice jobb you and the other guys :D,

i getting a error when i run the codes

ALTER TABLE `users` ADD `forumname` VARCHAR( 50 ) NOT NULL AFTER `expert`
ALTER TABLE `users` ADD `expert` VARCHAR( 50 ) NOT NULL AFTER `vip`

i getting a error that saying "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `users` ADD `expert` VARCHAR( 50 ) NOT NULL AFTER `vip`' at line 2" please,reply :)

Quote:

---

Originally Posted by Subway

Great,Thanks!

---

I getting a error when i register idk why :P

the error says,Title: Unknown column 'expert' in 'field list'
Text: Unknown column 'expert' in 'field list':grr:

I get the same error whenever I try running that query too. ^^

Also, for some reason it says "Host name XXXXXX cannot connect to this MySQL server" and I'm using Server 5.5

Then add it yourself manually, lol.

can someone give me jsut a full database with the cms database cause it wont work all the code i run to get this site tot work with my phoenix server gives errors
it just womnt work i treid you db you uploaded doesnt work either someone help??? runner new phoenix 3.7.1

I use phoenix emu 3.7.1 cracked i get error enable_cmdlogs.
What should I do?

Can anyone tell me how to get this working? coz the page comes up with

Quote:

---

PConnect($DBHOST, $DBUSER, $DBPASSWORD, $DBNAME); $sql = "SELECT * from sconfig"; $rsc = $conn->Execute($sql); if($rsc){while(!$rsc->EOF) { $field = $rsc->fields['soption']; $config[$field] = $rsc->fields['svalue']; STemplate::assign($field, $config[$field]); @$rsc->MoveNext(); }} STemplate::assign('bgcolor','#E8E8E8'); STemplate::assign('BASE_URL', $config['BASE_URL']); STemplate::assign('BASE_DIR', $config['BASE_DIR']); STemplate::assign('IMG_URL', $config['IMG_URL']); STemplate::assign('baseurl', $config['BASE_URL']); STemplate::assign('basedir', $config['BASE_DIR']); STemplate::assign('imgurl', $config['IMG_URL']); STemplate::assign('vdourl', $config['VDO_URL']); STemplate::assign('adourl', $config['ADO_URL']); STemplate::assign('flvdourl', $config['FLVDO_URL']); STemplate::assign('tmburl', $config['TMB_URL']); STemplate::setCompileDir($config['basedir']."/templates_c"); STemplate::setTplDir($config['basedir']."/templates"); ?>
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at C:\xampp\htdocs\include\config.php:86) in C:\xampp\htdocs\index.php on line 3

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\include\config.php:86) in C:\xampp\htdocs\index.php on line 3

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for '0.0/no DST' instead in C:\xampp\htdocs\index.php on line 7

Fatal error: Call to a member function Execute() on a non-object in C:\xampp\htdocs\index.php on line 9

---

someone help me with iis when i login i get this on Swagg: Best hotel around!

Code:

---

500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed.

---

How do you fix the news comments exploit without removing it?
Posted via Mobile Device

New download please.

Has anyone the MUS of phoenix working with this cms?

Quote:

---

Originally Posted by FreddyZoom

How do you fix the news comments exploit without removing it?
Posted via Mobile Device

---

Mysql escape string filter the $_GET expl0its..:P:

Quote:

---

Originally Posted by Subway

Mysql escape string filter the $_GET expl0its..:P:

---

I searched article.php exploit in the internet, got a great one straight away :)

Can you update Database Link? Please n Thanks!

Huh, this CMS do not work for me.. :/ CAn someone give me a Tut, I'm using Localhost.. do i need to use IIS to get it work?

Theres something wrong with web.config for me.

your web.config has nothing to do with this cms :blink:
Check your IIS cause thats where it comes from..

Well I get a 500 Internal Server Error I have the same result on 3 other computers...

I Got A Problem Here

Quote:

---

Notice: Undefined index: HTTP_CF_CONNECTING_IP in C:\xampp\htdocs\global.php on line 21

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

---

and this

Quote:

---

Notice: Undefined index: HTTP_CF_CONNECTING_IP in C:\xampp\htdocs\global.php on line 21

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

My Friends
My Groups
My Rooms
Help
Sign Out
Enter Hotel
Title: Table 'phoenixhotel2.fuserights' doesn't exist
Text: Table 'phoenixhotel2.fuserights' doesn't exist

---

I get

Quote:

---

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 17 in /home/a7334140/public_html/hotel/inc/class.core.php on line 197

---

Any help?

I gave a nice edited this CMS! Visual changed some parts, I fixed some things in Housekeeping and still put their own Web-Build (:

Here the my Hotel: Wizard: O melhor com certeza !

And i edited the cproxy, and i will try fix the cproxy of wichard (:

Obs: My Hotel is Portuguese (:
Obs²: If you need of some help with Web-Build, contact me: helpi95@live.com

Hey man, i created the SQL system of notes, which is the main housekeeping ...

Code:

---

CREATE TABLE `notes` (
  `id` int(10) NOT NULL,
  `content` varchar(999) NOT NULL,
  `date` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

Run this SQL in your Database, and will Works the Notes ;)

Wait I'm confused, So do I delete everything but the swf folder from my htdocs and copy your files in just like that?

@Xenogenics
No, the c_images of CMs is to read the badges on some pages, you need not replace your c_images of swf!

Title: Could not execute cron job 'credits.php': could not locate script file.
Text: Could not execute cron job 'credits.php': could not locate script file.

Any help?

Paste the codes release in the thread^ -.-

Title: Could not execute cron job 'credits.php': could not locate script file.
Text: Could not execute cron job 'credits.php': could not locate script file.

Any help?, I got same problem.

*EDIT* Doesn't matter fixed it, But having problems, the register page is awful and login doesn't work.

The Database download is not working

Notice: Undefined index: HTTP_CF_CONNECTING_IP in C:\xampp\htdocs\global.php on line 21
Title: Could not execute cron job 'credits.php': could not locate script file.
Text: Could not execute cron job 'credits.php': could not locate script file.

Problem :(
How To Fix It?!

New problem:
Title: Unknown column 'expert' in 'field list'
Text: Unknown column 'expert' in 'field list'

Your sql didn't work, new one?

I get this error when I add news:

Title: Incorrect string value: '\xE9 rede...' for column 'body' at row 1
Text: Incorrect string value: '\xE9 rede...' for column 'body' at row 1

Compatible with a phoenix 3.7.1 database? Because I noticed that there is no forumname or expert table in my database to run.

Still getting an internal server error.


----

update: Nevermind. Didn't add web.config correctly. xD

http://txt.sharefast.net/1324394666981884922290.sql = dead.

"Title: Table 'db.fuserights' doesn't exist
Text: Table 'db.fuserights' doesn't exist"

> enter the SQL

Spoiler:

Code:

---

--
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Table structure for table `site_config`
--

CREATE TABLE IF NOT EXISTS `site_config` (
  `maintenance` enum('0','1') NOT NULL DEFAULT '0',
  `web_build` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `site_cron`
--

CREATE TABLE IF NOT EXISTS `site_cron` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prio` int(11) NOT NULL DEFAULT '5',
  `enabled` enum('0','1') NOT NULL DEFAULT '1',
  `scriptfile` varchar(50) NOT NULL,
  `last_exec` int(11) NOT NULL,
  `exec_every` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_hotcampaigns`
--

CREATE TABLE IF NOT EXISTS `site_hotcampaigns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL DEFAULT '1',
  `enabled` enum('0','1') NOT NULL DEFAULT '1',
  `IMG_url` text NOT NULL,
  `caption` text NOT NULL,
  `descr` text NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_minimail`
--

CREATE TABLE IF NOT EXISTS `site_minimail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sender_id` int(10) unsigned NOT NULL,
  `receiver_id` int(10) unsigned NOT NULL,
  `folder` enum('inbox','sent','trash') NOT NULL DEFAULT 'inbox',
  `is_read` enum('0','1') NOT NULL DEFAULT '0',
  `subject` varchar(120) NOT NULL,
  `date` varchar(120) NOT NULL,
  `isodate` varchar(120) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `body` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7075 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_navi`
--

CREATE TABLE IF NOT EXISTS `site_navi` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `order_id` int(11) NOT NULL,
  `caption` text NOT NULL,
  `class` text NOT NULL,
  `url` text NOT NULL,
  `visibility` enum('0','1','2','3') NOT NULL COMMENT '0 = Never, 1 = Always, 2 = Logged in only, 3 = Guests only',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_news`
--

CREATE TABLE IF NOT EXISTS `site_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
  `title` text NOT NULL,
  `category_id` int(10) unsigned NOT NULL DEFAULT '1',
  `topstory_IMG` text NOT NULL,
  `body` text NOT NULL,
  `snippet` text NOT NULL,
  `datestr` varchar(50) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_news_categories`
--

CREATE TABLE IF NOT EXISTS `site_news_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `caption` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_news_comments`
--

CREATE TABLE IF NOT EXISTS `site_news_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `posted_on` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1525 ;

---

get >

Spoiler:

Code:

---


--
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";# MySQL returned an empty result set (i.e. zero rows).

SET time_zone = "+00:00";# MySQL returned an empty result set (i.e. zero rows).

--
-- Table structure for table `site_config`
--

CREATE TABLE IF NOT EXISTS `site_config` (
  `maintenance` enum('0','1') NOT NULL DEFAULT '0',
  `web_build` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;# MySQL returned an empty result set (i.e. zero rows).


-- --------------------------------------------------------

--
-- Table structure for table `site_cron`
--

CREATE TABLE IF NOT EXISTS `site_cron` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prio` int(11) NOT NULL DEFAULT '5',
  `enabled` enum('0','1') NOT NULL DEFAULT '1',
  `scriptfile` varchar(50) NOT NULL,
  `last_exec` int(11) NOT NULL,
  `exec_every` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;# MySQL returned an empty result set (i.e. zero rows).


-- --------------------------------------------------------

--
-- Table structure for table `site_hotcampaigns`
--

CREATE TABLE IF NOT EXISTS `site_hotcampaigns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL DEFAULT '1',
  `enabled` enum('0','1') NOT NULL DEFAULT '1',
  `IMG_url` text NOT NULL,
  `caption` text NOT NULL,
  `descr` text NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;# MySQL returned an empty result set (i.e. zero rows).


-- --------------------------------------------------------

--
-- Table structure for table `site_minimail`
--

CREATE TABLE IF NOT EXISTS `site_minimail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sender_id` int(10) unsigned NOT NULL,
  `receiver_id` int(10) unsigned NOT NULL,
  `folder` enum('inbox','sent','trash') NOT NULL DEFAULT 'inbox',
  `is_read` enum('0','1') NOT NULL DEFAULT '0',
  `subject` varchar(120) NOT NULL,
  `date` varchar(120) NOT NULL,
  `isodate` varchar(120) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `body` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7075 ;# MySQL returned an empty result set (i.e. zero rows).


-- --------------------------------------------------------

--
-- Table structure for table `site_navi`
--

CREATE TABLE IF NOT EXISTS `site_navi` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `order_id` int(11) NOT NULL,
  `caption` text NOT NULL,
  `class` text NOT NULL,
  `url` text NOT NULL,
  `visibility` enum('0','1','2','3') NOT NULL COMMENT '0 = Never, 1 = Always, 2 = Logged in only, 3 = Guests only',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;# MySQL returned an empty result set (i.e. zero rows).


-- --------------------------------------------------------

--
-- Table structure for table `site_news`
--

CREATE TABLE IF NOT EXISTS `site_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
  `title` text NOT NULL,
  `category_id` int(10) unsigned NOT NULL DEFAULT '1',
  `topstory_IMG` text NOT NULL,
  `body` text NOT NULL,
  `snippet` text NOT NULL,
  `datestr` varchar(50) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;# MySQL returned an empty result set (i.e. zero rows).


-- --------------------------------------------------------

--
-- Table structure for table `site_news_categories`
--

CREATE TABLE IF NOT EXISTS `site_news_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `caption` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;# MySQL returned an empty result set (i.e. zero rows).


-- --------------------------------------------------------

--
-- Table structure for table `site_news_comments`
--

CREATE TABLE IF NOT EXISTS `site_news_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `posted_on` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1525 ;# MySQL returned an empty result set (i.e. zero rows).

---

Thanks for this!

The full database dosent work... Can I get a new one?

New Download, Seems like Mediafire is not working currently :(

for the error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `users` ADD `expert` VARCHAR( 50 ) NOT NULL AFTER `vip`' at line 2

Run this on SQL

ALTER TABLE `users` ADD `expert` VARCHAR( 50 ) NOT NULL AFTER `vip`
ALTER TABLE `users` ADD `forumname` VARCHAR( 50 ) NOT NULL AFTER `expert`

Instead

ALTER TABLE `users` ADD `forumname` VARCHAR( 50 ) NOT NULL AFTER `expert`
ALTER TABLE `users` ADD `expert` VARCHAR( 50 ) NOT NULL AFTER `vip`

How do i get rid of this error?
Notice: Undefined index: HTTP_CF_CONNECTING_IP in C:\xampp\htdocs\global.php on line 21

Where do i change the facebook?

Just delete the row 21 in global.php

It's still there, The Like us on facebook part

for YouHotel

Is this better than UberCMS 2?

ubercms 2 is abit buggy logging in id say this is stabler

"Title: MySQL server has gone away
Text: MySQL server has gone away"

What the fuck, it takes forever to load.

I have this error
Title: Could not execute cron job 'credits.php': could not locate script file.
Text: Could not execute cron job 'credits.php': could not locate script file.
and whem i submit the registration it comes up as
Title: Could not execute cron job 'Expert.php': could not locate script file.
Text: Could not execute cron job 'Expert.php': could not locate script file.


I need help Guys :(
Nash,

Help me plz.

I have a error

Notice: Undefined index: HTTP_CF_CONNECTING_IP in C:\xampp\htdocs\global.php on line 21

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\inc\class.db.mysql.php on line 49
Title: Access denied for user 'root'@'localhost' (using password: YES)
Text: Access denied for user 'root'@'localhost' (using password: YES)

I first import phoenix3.sql.svn-base to the database from C:\xampp\htdocs\inc\tpl\.svn\text-base. After run this command

PHP Code:

---

ALTER TABLE  `users` ADD  `forumname` VARCHAR( 50 ) NOT NULL AFTER  `expert`
ALTER TABLE  `users` ADD  `expert` VARCHAR( 50 ) NOT NULL AFTER  `vip` 


---

after

PHP Code:

---

TRUNCATE TABLE  `site_cron` 


---

and after

PHP Code:

---

--
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Table structure for table `site_config`
--

CREATE TABLE IF NOT EXISTS `site_config` (
  `maintenance` enum('0','1') NOT NULL DEFAULT '0',
  `web_build` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `site_cron`
--

CREATE TABLE IF NOT EXISTS `site_cron` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prio` int(11) NOT NULL DEFAULT '5',
  `enabled` enum('0','1') NOT NULL DEFAULT '1',
  `scriptfile` varchar(50) NOT NULL,
  `last_exec` int(11) NOT NULL,
  `exec_every` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_hotcampaigns`
--

CREATE TABLE IF NOT EXISTS `site_hotcampaigns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL DEFAULT '1',
  `enabled` enum('0','1') NOT NULL DEFAULT '1',
  `IMG_url` text NOT NULL,
  `caption` text NOT NULL,
  `descr` text NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_minimail`
--

CREATE TABLE IF NOT EXISTS `site_minimail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sender_id` int(10) unsigned NOT NULL,
  `receiver_id` int(10) unsigned NOT NULL,
  `folder` enum('inbox','sent','trash') NOT NULL DEFAULT 'inbox',
  `is_read` enum('0','1') NOT NULL DEFAULT '0',
  `subject` varchar(120) NOT NULL,
  `date` varchar(120) NOT NULL,
  `isodate` varchar(120) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `body` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7075 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_navi`
--

CREATE TABLE IF NOT EXISTS `site_navi` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `order_id` int(11) NOT NULL,
  `caption` text NOT NULL,
  `class` text NOT NULL,
  `url` text NOT NULL,
  `visibility` enum('0','1','2','3') NOT NULL COMMENT '0 = Never, 1 = Always, 2 = Logged in only, 3 = Guests only',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_news`
--

CREATE TABLE IF NOT EXISTS `site_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
  `title` text NOT NULL,
  `category_id` int(10) unsigned NOT NULL DEFAULT '1',
  `topstory_IMG` text NOT NULL,
  `body` text NOT NULL,
  `snippet` text NOT NULL,
  `datestr` varchar(50) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_news_categories`
--

CREATE TABLE IF NOT EXISTS `site_news_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `caption` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `site_news_comments`
--

CREATE TABLE IF NOT EXISTS `site_news_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `comment` varchar(500) NOT NULL,
  `posted_on` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1525 ; 


---

I type settings in the inc/class.db.mysql.php

My settings

PHP Code:

---

<?php
/*=======================================================================
| UberCMS - Advanced Website and Content Management System for uberEmu
| #######################################################################
| Copyright (c) 2010, Roy 'Meth0d'
| 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 MySQL
{
    private $connected = true;
    private $hostname = "localhost";
    private $username = "root";
    private $password = "mypass";
    private $database = "habbo";
    private $link;
    
    public function MySQL($host, $user, $pass, $db)
    {
        $this->connected = false;    
        $this->hostname = $host;
        $this->username = $user;
        $this->password = $pass;
        $this->database = $db;
    }
    
    public function IsConnected()
    {
        if ($this->connected)
        {
            return true;
        }
        
        return false;
    }

    public function Connect()
    {
        $this->link = mysql_connect($this->hostname, $this->username, $this->password) or $this->error(mysql_error());
        mysql_select_db($this->database, $this->link) or $this->error(mysql_error());
         
        $this->connected = true;
    }
    
    public function Disconnect()
    {
        if($this->connected)
        {
            @mysql_close($this->link) or $this->error("could not close conn");
            $this->connected = false;
        }
    }
    
    public function DoQuery($query)
    {
        $resultset = @mysql_query($query, $this->link) or $this->error(mysql_error());
        return $resultset;
    }
    
    public function Evaluate($resultset)
    {
        return @mysql_result($resultset, 0);
    }
    
    public function Error($errorString)
    {
        global $core;
        
        $core->systemError('Database Error', $errorString);
    }
    
    public function __destruct()
    {
        $this->disconnect();
    }
}

?>

---

Help me please!