[REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

[Myth?]

You'll have to set up your MySQL Server.

Then on google search "Navicate Lite"

Try finding a Holograph Elemunator Tut, that'll explain it. I have to go.. I'll be back in a bit.

-- ----------------------------
-- Table structure for cms_alerts
-- ----------------------------
CREATE TABLE `cms_alerts` (
`username` varchar(25) collate latin1_general_ci NOT NULL COMMENT 'User to alert',
`alert` mediumtext collate latin1_general_ci NOT NULL COMMENT 'Message',
`pending` enum('0','1') collate latin1_general_ci NOT NULL COMMENT 'Alerted yet?'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_help
-- ----------------------------
CREATE TABLE `cms_help` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(25) collate latin1_general_ci NOT NULL,
`ip` varchar(50) collate latin1_general_ci NOT NULL,
`message` mediumtext collate latin1_general_ci NOT NULL,
`date` varchar(50) collate latin1_general_ci NOT NULL,
`picked_up` enum('0','1') collate latin1_general_ci NOT NULL,
`subject` varchar(50) collate latin1_general_ci NOT NULL,
`roomid` int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
CREATE TABLE `cms_news` (
`num` tinyint(4) NOT NULL,
`title` text collate latin1_general_ci NOT NULL,
`category` text collate latin1_general_ci NOT NULL,
`topstory` varchar(100) collate latin1_general_ci NOT NULL,
`short_story` text collate latin1_general_ci NOT NULL,
`story` longtext collate latin1_general_ci NOT NULL,
`date` date NOT NULL,
`author` text collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_posts
-- ----------------------------
CREATE TABLE `cms_posts` (
`id` int(11) NOT NULL auto_increment,
`thread` int(11) NOT NULL,
`poster` varchar(25) NOT NULL,
`date` varchar(25) NOT NULL,
`post` text NOT NULL,
`modified` varchar(50) NOT NULL,
`modified_by` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_system
-- ----------------------------
CREATE TABLE `cms_system` (
`sitename` varchar(30) collate latin1_general_ci NOT NULL,
`shortname` varchar(30) collate latin1_general_ci NOT NULL,
`site_closed` enum('0','1') collate latin1_general_ci NOT NULL COMMENT 'Maintenance Mode',
`enable_sso` enum('0','1') collate latin1_general_ci NOT NULL,
`language` varchar(2) collate latin1_general_ci NOT NULL,
`ip` varchar(50) collate latin1_general_ci NOT NULL,
`port` varchar(5) collate latin1_general_ci NOT NULL,
`texts` varchar(250) collate latin1_general_ci NOT NULL,
`variables` varchar(250) collate latin1_general_ci NOT NULL,
`dcr` varchar(250) collate latin1_general_ci NOT NULL,
`reload_url` varchar(250) collate latin1_general_ci NOT NULL,
`localhost` enum('0','1') collate latin1_general_ci NOT NULL COMMENT 'Local server?'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_tags
-- ----------------------------
CREATE TABLE `cms_tags` (
`id` int(255) NOT NULL auto_increment,
`owner` varchar(25) collate latin1_general_ci NOT NULL,
`tag` varchar(25) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_threads
-- ----------------------------
CREATE TABLE `cms_threads` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(20) NOT NULL,
`views` varchar(4) NOT NULL,
`replies` varchar(4) NOT NULL,
`starter` varchar(25) NOT NULL,
`lastposter` varchar(25) NOT NULL,
`lastpostdate` varchar(25) NOT NULL,
`lastposttime` varchar(50) NOT NULL,
`startdate` varchar(25) NOT NULL,
`unix` varchar(50) NOT NULL,
`firstpostid` int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for system
-- ----------------------------
CREATE TABLE `system` (
`onlinecount` int(3) NOT NULL default '0',
`test` text collate latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for system_config
-- ----------------------------
CREATE TABLE `system_config` (
`skey` varchar(100) collate latin1_general_ci NOT NULL,
`sval` text collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for system_stafflog
-- ----------------------------
CREATE TABLE `system_stafflog` (
`id` int(5) NOT NULL auto_increment,
`action` varchar(12) collate latin1_general_ci NOT NULL,
`message` text collate latin1_general_ci,
`note` text collate latin1_general_ci,
`userid` int(11) NOT NULL,
`targetid` int(11) default NULL,
`timestamp` varchar(50) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for system_strings
-- ----------------------------
CREATE TABLE `system_strings` (
`stringid` varchar(100) collate latin1_general_ci NOT NULL default 'null',
`var_en` text collate latin1_general_ci,
`var_de` text collate latin1_general_ci,
PRIMARY KEY (`stringid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

INSERT INTO `cms_news` VALUES ('1', 'Installation Complete', 'HoloCMS', 'http://images.habbohotel.co.uk/c_images/Top_Story_Images/topstory_accessories2.gif', 'HoloCMS was successfully installed!', 'Thank you for choosing HoloCMS! Everything appears to be working just fine..\r\n\r\nYou can edit this article by going into housekeeping and choosing Manage Existing Articles.', '2008-03-22', 'Meth0d');
INSERT INTO `cms_news` VALUES ('1', 'Installation Complete', 'HoloCMS', 'http://images.habbohotel.co.uk/c_images/Top_Story_Images/topstory_accessories2.gif', 'HoloCMS was successfully installed!', 'Thank you for choosing HoloCMS! Everything appears to be working just fine..\r\n\r\nYou can edit this article by going into housekeeping and choosing Manage Existing Articles.', '2008-03-22', 'Meth0d');
INSERT INTO `cms_system` VALUES ('Marks FUSE IT', 'Mark', '0', '1', 'en', '127.0.0.1', '21', 'http://www.habbohotel.co.uk/gamedata/external?id=external_texts', 'http://www.habbohotel.co.uk/gamedata/external?id=external_variables', 'http://images.habbohotel.co.uk/dcr/r21_20080317_0342_4666_5527e6590eba8f3fb66348bdf271b5a2/habbo.dcr', 'http://www.mysite.com/cms/client.php', '0');
INSERT INTO `system` VALUES ('1', '');
INSERT INTO `system_config` VALUES ('game_port', '90');
INSERT INTO `system_config` VALUES ('lang', 'en');
INSERT INTO `system_config` VALUES ('game_maxconnections', '400');
INSERT INTO `system_config` VALUES ('mus_port', '91');
INSERT INTO `system_config` VALUES ('mus_maxconnections', '100');
INSERT INTO `system_config` VALUES ('mus_host', '127.0.0.1'); like is this the sql

 

[sPLAZE]

real nicee mann imm try get this setted up

 

[Myth?]

You'll have to set up your MySQL Server.

Then on google search "Navicate Lite"

Try finding a Holograph Elemunator Tut, that'll explain it. I have to go.. I'll be back in a bit.

do i have to download this installions from here

To view the content, you need to sign in or register

 

[Extreme]

nice looks cool is this just the cms or cms and server ?

Laters,

 

[CujoDaMan]

The server is included the first link which says Marks FUSE IT Server that's the server.. Then MarkCMS is the CMS just by it self. I can include the server with the CMS in future releses if you wish

Also, yes Andre the stuff to download in that guide is the stuff you'll need to use for the CMS.

 

[Myth?]

The server is included the first link which says Marks FUSE IT Server that's the server.. Then MarkCMS is the CMS just by it self. I can include the server with the CMS in future releses if you wish

Also, yes Andre the stuff to download in that guide is the stuff you'll need to use for the CMS.

out of these stuff wat to put in the server setting sql i new at sqls

Installation:
1 - Open settings.ini in the "Server" folder in this package.
2 - Change the port if you want.
3 - Set host=localhost to your MySQL database host. (Same as in the "Installation: Webcontent" part.)
4 - Set port=3306 to your MySQL database port. (It's 3306 most of the times.)
5 - Set user=server to your MySQL username. (Same as in the "Installation: Webcontent" part.)
6 - Set pass=123 to your MySQL password. (Same as in the "Installation: Webcontent" part.)
7 - Set database=server to your database name. (Same as in the "Installation: Webcontent" part.)
8 - Save and close settings.ini
9 - You are done with this step.

i followed these steps to do server but it aint do

 

[Myth?]

The server is included the first link which says Marks FUSE IT Server that's the server.. Then MarkCMS is the CMS just by it self. I can include the server with the CMS in future releses if you wish

Also, yes Andre the stuff to download in that guide is the stuff you'll need to use for the CMS.

coz i download that xampp-win32-1.6.6a installer

 

[Parker]

Looks good,

To view the content, you need to sign in or register

Works alright.

 

[The-Stupid-One]

Very nice, so your getting groups to work ehh?

 

[HotelDelux]

Found bug:

Room making don't work in server,, he don't come further then: Wait a moment,, we going to your room.

Another bug:

Group making didn't work,, i got enough credits, and he says i don't have enough :sq_yellow

 

[KingAmir]

nice and Andre23 ..i know you wanted too many posts but dont double post

 

[Dimii15]

Do you only have to change config.php?

 

[Ivan66]

v3 Multi =>

To view the content, you need to sign in or register

 

[Schfoo]

Did you even ask GraphiX if you could use HoloCMS for this?

 

[RascaL]

GraphiX is gonna kill you mate, you should have asked him , fake

Cya,
RascaL

 

[Schfoo]

Nah, it's probably real, but no permission xD

 

[Meth0d]

GraphiX is gonna kill you mate

mhm..

As stated in the license he's free to remix the work and blah blah. But you do not meet all terms.

1. Attribution - CLEARLY give credit to me / HoloCMS in the release, not 'I took HoloCMS' on top of the thread
2. Non-commercial - Well from the looks of it you meet that one
3. Share-alike - You MUST publish it under the same license

Please make the neccessary changes to meet these things or who knows, I actually might do what RascaL said.

 

[Donkjam]

Yea ffs give some credit to GraphiX

 

[riki-r0ki]

i need help

i have problem with de user table... can anybody write this here pls.. and we can i bin the Habbo DB with the CMS DB... (User DB)

==> SRY for my bad english...

thx for help!!

 

[evilleader]

How to install it, please tell me. I have edited all files, but when I've uploaded, what next?