Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

RevCMS Habbo Theme

Glee

Glee

Custom Title Activated
Loyal Member
1000 Posts 10 Happy Years
Joined
Jun 27, 2009
Messages
1,571
Reaction score
170
I know some people are having problems with the housekeeping I released with this version of RevCMS but I don't remember if I upload all SQL for it so here you go

Code: 
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 31, 2014 at 11:04 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET  [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET  [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET  [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cheer_dev`
--

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

--
-- Table structure for table `housekeeping_logins`
--

CREATE TABLE IF NOT EXISTS `housekeeping_logins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(999) NOT NULL,
  `user_id` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `ip` varchar(999) NOT NULL,
  `agent` varchar(999) NOT NULL,
  `type` enum('WEBSITE','HOUSEKEEPING') NOT NULL,
  `status` enum('TRUE','FALSE') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `housekeeping_logins`
--

INSERT INTO `housekeeping_logins` (`id`, `username`, `user_id`, `time`, `ip`, `agent`, `type`, `status`) VALUES
(1, 'Reality', 10026, 1409533457, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.102 Safari/537.36', 'HOUSEKEEPING', 'TRUE'),
(2, 'Reality', 10026, 1409533465, '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.102 Safari/537.36', 'HOUSEKEEPING', 'TRUE'),
(3, 'Reality', 10026, 1409533476, '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.102 Safari/537.36', 'HOUSEKEEPING', 'TRUE'),
(4, 'Reality', 10026, 1409533528, '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.102 Safari/537.36', 'HOUSEKEEPING', 'TRUE'),
(5, 'Reality', 10026, 1409533539, '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.102 Safari/537.36', 'HOUSEKEEPING', 'TRUE'),
(6, 'Reality', 10026, 1409533683, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.102 Safari/537.36', 'HOUSEKEEPING', 'TRUE'),
(7, 'Reality', 10026, 1409536187, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.102 Safari/537.36', 'HOUSEKEEPING', 'TRUE');

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

--
-- Table structure for table `housekeeping_logs`
--

CREATE TABLE IF NOT EXISTS `housekeeping_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `page` varchar(999) NOT NULL,
  `note` text NOT NULL,
  `ip` varchar(999) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=829 ;

--
-- Dumping data for table `housekeeping_logs`
--


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

--
-- Table structure for table `housekeeping_panel_catagories`
--

CREATE TABLE IF NOT EXISTS `housekeeping_panel_catagories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(999) NOT NULL,
  `permission` varchar(999) NOT NULL,
  `enabled` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `housekeeping_panel_catagories`
--

INSERT INTO `housekeeping_panel_catagories` (`id`, `title`, `permission`, `enabled`) VALUES
(1, 'System', 'hk.system', '1'),
(2, 'Hotel', 'hk.hotel', '1'),
(3, 'Logs', 'hk.logs', '1'),
(4, 'Users', 'hk.users', '1'),
(5, 'News', 'hk.news', '1'),
(6, 'Rooms', 'hk.rooms', '1');

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

--
-- Table structure for table `housekeeping_panel_pages`
--

CREATE TABLE IF NOT EXISTS `housekeeping_panel_pages` (
  `id` int(99) NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `title` varchar(999) NOT NULL,
  `page` varchar(999) NOT NULL,
  `permission` varchar(999) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `housekeeping_panel_pages`
--

INSERT INTO `housekeeping_panel_pages` (`id`, `cat_id`, `title`, `page`, `permission`) VALUES
(1, 1, 'Status', '?do=system&page=system_status', 'hk.system_status'),
(2, 2, 'Users Online', '?do=hotel&page=users_online', 'hk.hotel_users'),
(3, 1, 'Staff Online', '?do=system&page=staff_online', 'hk.system_staff'),
(4, 2, 'Hotel Alert', '?do=hotel&page=hotel_alert', 'hk.hotel_alert'),
(5, 1, 'Version Check', '?do=system&page=version_check', 'hk.system_version.check'),
(6, 3, 'Site Logins', '?do=logs&page=site_logins', 'hk.logs_site'),
(7, 3, 'Panel Logins', '?do=logs&page=panel_logins', 'hk.logs_panel'),
(8, 4, 'Account Information', '?do=users&page=account_information', 'hk.users_view'),
(9, 2, 'Settings', '?do=hotel&page=hotel_settings', 'hk.hotel_settings'),
(10, 2, 'Word Filter', '?do=hotel&page=word_filter', 'hk.hotel_word.filter'),
(11, 4, 'Permission Management', '?do=users&page=permission_management', 'hk.users_permissions'),
(12, 5, 'Post Article', '?do=news&page=post_news', 'hk.news_post'),
(13, 5, 'Manage News', '?do=news&page=manage_news', 'hk.news_edit'),
(14, 2, 'Catalogue Editor', '?do=hotel&page=catalogue_pages', 'hk.catalogue_edit'),
(15, 6, 'Bots', '?do=rooms&page=bots', 'hk.bots'),
(16, 4, 'Ban List', '?do=users&page=banlist', 'hk.users'),
(17, 4, 'Transactions', '?do=users&page=transactions', 'hk.transactions'),
(18, 6, 'Active Rooms', '?do=rooms&page=activerooms', 'hk.rooms'),
(19, 6, 'Room Chatlog', '?do=rooms&page=activerooms', 'hk.rooms'),
(20, 2, 'Call for Helps', '?do=hotel&page=cfhs', 'hk.cfhs'),
(21, 2, 'Chatlogs', '?do=hotel&page=chatlogs', 'hk.chatlogs');

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

--
-- Table structure for table `housekeeping_permissions`
--

CREATE TABLE IF NOT EXISTS `housekeeping_permissions` (
  `rank_id` int(1) unsigned NOT NULL,
  `hk.login` enum('1','0') NOT NULL DEFAULT '0',
  `hk.system` enum('1','0') NOT NULL DEFAULT '0',
  `hk.system_status` enum('1','0') NOT NULL DEFAULT '0',
  `hk.system_staff` enum('1','0') NOT NULL DEFAULT '0',
  `hk.system_version.check` enum('1','0') NOT NULL DEFAULT '0',
  `hk.system_kill` enum('1','0') NOT NULL DEFAULT '0',
  `hk.logs` enum('1','0') NOT NULL DEFAULT '0',
  `hk.logs_site` enum('1','0') NOT NULL DEFAULT '0',
  `hk.logs_panel` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users_view` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users_edit` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users_reports` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users_reports.delete` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users_change.password` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users_ban` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users_unban` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users_update.rank` enum('1','0') NOT NULL DEFAULT '0',
  `hk.users_permissions` enum('1','0') NOT NULL DEFAULT '0',
  `hk.hotel` enum('1','0') NOT NULL DEFAULT '0',
  `hk.hotel_users` enum('1','0') NOT NULL DEFAULT '0',
  `hk.hotel_settings` enum('1','0') NOT NULL DEFAULT '0',
  `hk.hotel_word.filter` enum('1','0') NOT NULL DEFAULT '0',
  `hk.hotel_alert` enum('1','0') NOT NULL DEFAULT '0',
  `hk.news` enum('1','0') NOT NULL DEFAULT '0',
  `hk.news_post` enum('1','0') NOT NULL DEFAULT '0',
  `hk.news_edit` enum('1','0') NOT NULL DEFAULT '0',
  `hk.news_delete` enum('1','0') NOT NULL DEFAULT '0',
  `hk.catalogue_edit` enum('1','0') NOT NULL DEFAULT '0',
  `hk.rooms` enum('1','0') NOT NULL DEFAULT '0',
  `hk.bots` enum('1','0') NOT NULL DEFAULT '0',
  `hk.transactions` enum('1','0') NOT NULL DEFAULT '0',
  `hk.cfhs` enum('1','0') NOT NULL DEFAULT '0',
  `hk.chatlogs` enum('1','0') NOT NULL DEFAULT '0',
  UNIQUE KEY `rank_id` (`rank_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `housekeeping_permissions`
--

INSERT INTO `housekeeping_permissions` (`rank_id`, `hk.login`, `hk.system`, `hk.system_status`, `hk.system_staff`, `hk.system_version.check`, `hk.system_kill`, `hk.logs`, `hk.logs_site`, `hk.logs_panel`, `hk.users`, `hk.users_view`, `hk.users_edit`, `hk.users_reports`, `hk.users_reports.delete`, `hk.users_change.password`, `hk.users_ban`, `hk.users_unban`, `hk.users_update.rank`, `hk.users_permissions`, `hk.hotel`, `hk.hotel_users`, `hk.hotel_settings`, `hk.hotel_word.filter`, `hk.hotel_alert`, `hk.news`, `hk.news_post`, `hk.news_edit`, `hk.news_delete`, `hk.catalogue_edit`, `hk.rooms`, `hk.bots`, `hk.transactions`, `hk.cfhs`, `hk.chatlogs`) VALUES
(10, '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1'),
(9, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(8, '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0'),
(7, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(6, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(5, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(4, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(3, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(2, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(1, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

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

--
-- Table structure for table `housekeeping_plugins`
--

CREATE TABLE IF NOT EXISTS `housekeeping_plugins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_name` varchar(999) NOT NULL,
  `plugin_version` varchar(999) NOT NULL,
  `plugin_author` int(225) NOT NULL,
  `timestamp_added` int(11) NOT NULL,
  `plugin_content` text NOT NULL,
  `plugin_uninstall` int(11) NOT NULL,
  `permission` varchar(999) NOT NULL,
  `disable` enum('1','0') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `housekeeping_plugins`
--


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

--
-- Table structure for table `housekeeping_sessions`
--

CREATE TABLE IF NOT EXISTS `housekeeping_sessions` (
  `user_id` int(225) NOT NULL,
  `user_name` varchar(999) NOT NULL,
  `user_session` varchar(999) NOT NULL,
  `user_ip` varchar(999) NOT NULL,
  `user_agent` text NOT NULL,
  `timestamp` int(225) NOT NULL,
  `timestamp_last` int(225) NOT NULL,
  `location` text NOT NULL,
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `housekeeping_sessions`
--

INSERT INTO `housekeeping_sessions` (`user_id`, `user_name`, `user_session`, `user_ip`, `user_agent`, `timestamp`, `timestamp_last`, `location`) VALUES
(10026, 'Reality', '901dafa6b2731973', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.102 Safari/537.36', 1409536187, 1409540510, '/housekeeping/index.php');

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

--
-- Table structure for table `housekeeping_settings`
--

CREATE TABLE IF NOT EXISTS `housekeeping_settings` (
  `variable` varchar(999) NOT NULL,
  `content` text NOT NULL,
  UNIQUE KEY `variable_2` (`variable`),
  KEY `variable` (`variable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `housekeeping_settings`
--

INSERT INTO `housekeeping_settings` (`variable`, `content`) VALUES
('site_name', 'Cheer Hotel'),
('site_link', 'cheerhotel.com'),
('client_ip', 'cheervps.cheerhotel.com'),
('client_port_mus', '30001'),
('cloudflare', '0'),
('current_build', '1.3'),
('current_cms', 'revcms'),
('language', 'english'),
('mus_enabled', '0');

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

--
-- Table structure for table `housekeeping_user_reports`
--

CREATE TABLE IF NOT EXISTS `housekeeping_user_reports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `timestamp` int(225) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `housekeeping_user_reports`
--


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

--
-- Table structure for table `housekeeping_user_reports_reply`
--

CREATE TABLE IF NOT EXISTS `housekeeping_user_reports_reply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `report_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `timestamp` int(225) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `housekeeping_user_reports_reply`
--


/*!40101 SET CHARACTER_SET_CLIENT  [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS  [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION  [USER=1333464006]old[/USER]_COLLATION_CONNECTION */;

If you're on cloudflare change in the houskeeping_settings set cloudflare to 1
 
The Best DDoS Protected Servers
T

TexJox

Newbie Spellweaver
Joined
Nov 20, 2013
Messages
52
Reaction score
3
baIklec - RevCMS Habbo Theme - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Glee

Glee

Custom Title Activated
Loyal Member
1000 Posts 10 Happy Years
Joined
Jun 27, 2009
Messages
1,571
Reaction score
170
TexJox said:
baIklec - RevCMS Habbo Theme - RaGEZONE Forums
Click to expand...

I think you need this:
Code: 
CREATE TABLE IF NOT EXISTS `cms_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `image` varchar(100) NOT NULL,
  `shortstory` text NOT NULL,
  `longstory` text NOT NULL,
  `author` varchar(100) NOT NULL,
  `author_id` varchar(100) NOT NULL,
  `date` int(11) NOT NULL,
  `type` enum('1','0') NOT NULL,
  `roomid` varchar(100) NOT NULL,
  `updated` enum('0','1') NOT NULL DEFAULT '0',
  `published` varchar(60) DEFAULT NULL,
  `rotwstatus` enum('1','0') NOT NULL,
  `rotwcat` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
 

Attachments

You must be registered for see attachments list
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
210
Guests online
6,876
Total visitors
7,086
Totals may include hidden visitors.

Forum statistics

Threads
429,066
Messages
4,590,110
Members
280,516
Latest member
pimittens
Most visitors online was 8830 , on 6 Feb 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top