[Release] MacroCMS [PHP, MySQL, H4BBO]

[Livar]

Hello there, MacroCMS is released! Seeing as I'm really bored of having it in my htdocs, thought I'd put it to good use. It has NO known exploits or backdoors, you need a few queries aswell.

Run these queries:

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(14) NOT NULL AUTO_INCREMENT,
  `title` varchar(60) NOT NULL,
  `time` int(40) NOT NULL,
  `mainstory` varchar(5000) NOT NULL,
  `story` varchar(100) NOT NULL,
  `image` varchar(150) NOT NULL,
  `author` varchar(16) NOT NULL,
  `language` varchar(5) NOT NULL DEFAULT 'en',
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `author` (`author`),
  KEY `time` (`time`),
  KEY `title` (`title`),
  KEY `language` (`language`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `time`, `mainstory`, `story`, `image`, `author`, `language`) VALUES
(1, 'Welcome to H4BBO!', 1286015169, '<h2>Welcome to the new, bigger and awesomer H4BBO!</h2><br><b>What we can except?</b><br>- More users in many languages<br>- Faster (Not anymore that hard lags)<br>- Many competitions & events<br>- New furniture collections<br>- Fast updates<br>- More support (Many more moderators will be there soon!)<br><br>Please note that your Sulkea users have been automatically merged to this retro up on your first login here. Please use now <u>www.h4bbo.net</u> to access H4BBO, the previous domain will no longer work in future!<br><br><center><img src=''http://images.habbo.com/c_images/article_images_us/Rel11_DDeals_truck_145x114.gif''></center><br><br><b>Why many staffs have been disapeared from staff list?</b><br>They haven''t accessed H4BBO yet, after their first login they''re automatically merged to the Hotel and will be listed up on the Staff List again.', 'Grand opening: H4BBO', 'http://images.habbo.com/c_images/Top_Story_Images/topstory_newjackets.gif', 'Privilege', 'en'),
(2, 'Room of the month is back!', 1286101569, '<h2>Current theme: Halloween</h2><br>Room of the month is finally back!<br><br><b>How to participate?</b><br>Create a Halloween themed guestroom until 31.10. and tag it with <u>voodoo</u>. You can only have one room with this tag, if you have got more rooms with this tag you will be disqualified.<br><br><b>What can I win?</b><br>The prize is a nice rare set, a halloween releated badge and the best room will be visible for 2 weeks on the Staff recommented tab while users browse on navigator.<br><br><b>Tip:</b> Please wait a few weeks until you start! :-)<br><br><br><center><img src=''http://images.habbo.com/c_images/article_images_hq/art_hween09_gallows.gif''></center><br><br><br><br><center><h2>Only one can win: Good luck!</h2></center>', 'Room of the month is introduced again with the theme: Halloween', 'http://images.habbo.com/c_images/Top_Story_Images/topStory_hween10_1.gif', 'Privilege', 'en'),
(3, 'Hobbas have been replaced!', 1286101590, '<h2>The Hobba-System no longer exist!</h2><br>Some of the activest Hobbas have been forwarded as a Moderator!<br><br><b>Congratulations:</b> 3DiN, Gaetan, iHelp, MarcoPixel and YouTube<br><br><center><img src=''http://images.habbo.com/c_images/album18/hobbadges.gif''></center><br><br><br><i>All previous Hobbas have received an EX. Hobba Badge for their loyal service.</i>', 'What will happen to them?', 'http://images.habbo.com/c_images/Top_Story_Images/ts_exams_generic.gif', 'Privilege', 'en'),
(4, 'How to be safe on H4BBO?', 1286102000, '<img style=''float:right;'' src=''http://images.habbo.com/c_images/article_images_au/Phishing_2.gif''><h2>How to be safe on H4BBO?</h2><br><br>There are no Hackers who can hack into your accounts! Peoples who will loose their furnitures did something wrong, for example shared their password to another member.<br><br><b>Am I safe?</b><br>If you don''t share your password to another user you''ll stay safe. You also should not visit external websites by other members and never download something all over the web.<br><br><b>Will I get my furnitures back after a phish attempt?</b><br>No, faults are done by you will not restored. We only charge back stuff if it was our faults, for example database mistakes.<br><br><b>Should I tell staffs/moderators & co. my password?</b><br>No never do this! Also never login on an external website! Administrators & Moderators don''t use an external Housekeeping to login, they only login on www.h4bbo.net:8080 as you do :-)<br><br><b>Do phishers get banned?</b><br>Yes of course! Advertising to another website also gets you banned for a longer time!<br><br><b>Don''t lend your stuff to others!</b><br>You''ll not receive your stuff back from us if the other user phished you through this way!<br><br><br><center><img src=''http://images.habbo.com/c_images/tourimages/tour_hacker.gif''><br><br><h2>Stay safe!</h2></center>', 'A few rules to be safe.', 'http://images.habbo.com/c_images/Top_Story_Images/tp_xantinal.gif', 'Privilege', 'en'),
(5, 'Become a moderator!', 1286302645, '<h2>Want to become a moderator?</h2><br>We search alot of new moderators who can moderatore our local hotels (en, de, es & co.).<br><br><b>What you need to do?</b><br><a href=''javascript:alert("Applications all have been checked. We do not allow more users applying!");''>Send us an application here!</a> - The applications finally will be closed soon, so write the application in the next few days.<br><br><b>How I know I am accepted?</b><br>You''ll receive a minimail about it, you''ve a few days to answer it! - So if you already applied, please check your minimail before you apply a second time!<br><br>The first Moderator updates are on friday.<br><br><br><b>PLEASE READ CORRECTLY ON THE APPLICATION, for example: <i>your application must be in a fluent english</i>:-)</b><br><br><h2>Good luck!</h2>', 'Send us an application and have the chance!', 'http://images.habbo.com/c_images/Top_Story_Images/uk_bb_application_topstory_01.gif', 'Privilege', 'en'),
(6, 'Something big is coming to Sulkea soon!', 1286303400, '<h2>Something big is coming to Sulkea!</h2><br><br><b>What is new?</b><br>- Website will be avaible for more browsers: Internet Explorer, Google Chrome for example!<br>- The whole website has been rewritten<br>- Simpler handling on the website<br>- Themes are changing on the frontpage<br>- Languages are avaible via special links, you no more have to set the language always again<br>- Many more changes!<br><br><b>We introduce this newcommer soon, keep your eyes open!</b><br><br><br><center><img src=''http://img824.imageshack.us/img824/4964/newdesignv.png''></center><br><br>Please note that we currently still work on this new Version, it has not been finished yet!<br><br><br><center><h2>Please share your ideas here we should include, please type in english so our team can easier figure out your idea!</h2></center>', 'We''re updating to a new Version soon.', 'http://images.habbo.com/c_images/Top_Story_Images/top_story_web60.png', 'Privilege', 'en'),
(7, 'We search a web interface technician!', 1286304577, '<h2>We need a JS, CSS & HTML technician.</h2><br><b>You are good with two languages of them?</b><br>We offer the guy who wants to become a web interface technician a moderation rank (that user can easily become administrator later).<br><br><b>How to apply?</b><br>Send a minimail to Privilege with the informations what languages you are good with!<br><br><br><center><h2>Thanks!</h2></center>', 'You''re good at JS, CSS & HTML?', 'http://images.habbo.com/c_images/Top_Story_Images/top_story_staffpick2.png', 'Privilege', 'en'),
(8, 'The new Moderators are here!', 1286305478, '<h2>Alot of new moderators are here!</h2><br>We always try to get the Hotel more moderated, so here are they - The new moderators:<br><br>MOD-Tic326, MOD-Voetballer, MOD-Sixcore, MOD-MisterX, MOD-Gaetan, MOD-David, MOD-Stent, MOD-Snayder, MOD-MarcoPixel, MOD-SHAKE, MOD-Warped and MOD-Liipee<br><br><br><center><h2>Congratulations to them!</h2> - The best applicants of 250 applications -</center>', 'Who are the new moderators?', 'http://images.habbo.com/c_images/Top_Story_Images/top_story_note.png', 'Privilege', 'en'),
(9, 'A new version arrived!', 1286305790, '<img style=''float:right;'' src=''http://images.habbo.com/c_images/album310/rockin_posters2.gif''><h2>A new version arrived on H4bbo!</h2>We finally updated to a new Version.<br><br><br><b>What has been renewed and improved?</b><br>- Drag the room with your mouse to another place to view who else is in room? (For big room layouts, as there will be soon or for small Screens!)<br><br>- Posters are here<br><br>- Tutorial for all new users (Change username & Co. in Client)<br><br>- All usernames are free now, all in-active users got now a # appened to their names<br><br>- And many more stuff!<br><br><br><center><h2>Like the improvements?</h2></center>', 'What has been updated?', 'http://images.habbo.com/c_images/Top_Story_Images/ts_generic_78.gif', 'Privilege', 'en');

ALTER table server_status ADD column site_name TEXT;

Here's the download link:
htdocs.zip

Screenies:









Credits:
- Me,
- Exeyous (inspiration),
- Jonteh (inspiration and tips as I wen't),
- Pure (thanks George2000),
- and Pr1v3l3g3.

Enjoy, .

saywot? deleting my rant sean.

[ησвяαιη]

Seems good, nice work.

[George2000]

The credits to Pure, a big helper to Privilege?

Good release, will use this.

[Livar]

Seems good, nice work.

Thank's for your comment.

The credits to Pure, a big helper to Privilege?

Good release, will use this.

Added, and atleast someone who appreciates it.

[Adde]

Good joob Powah!

[LucasReis]

And work with Phoenix?

[Livar]

And work with Phoenix?

Indeed, check the footer.

[Resource]

Nice work , hope to see more of you
Posted via Mobile Device

[Livar]

Nice work , hope to see more of you
Posted via Mobile Device

Certainly, I'm really intrested in PHP, more than ever.

[Hejula]

Looks good, thanks for releasing.

[Livar]

Looks good, thanks for releasing.

People like you keep me going, thank-you so much.

[WantedMan]

Looks good, will be using this soon :D

[Kryptos]

Reminds me of PhoenixPHP ( Procedural and sloppy ), only that this is secure.

PS: Not trying to be mean, but it's true.

[n0minal]

Awesome, thanks Livar ;3.

[Livar]

Awesome, thanks Livar ;3.

Your welcome, hope this can help you, in any form or shape.

Reminds me of PhoenixPHP ( Procedural and sloppy ), only that this is secure.

PS: Not trying to be mean, but it's true.

Nah, I wouldn't class that as mean, I'm a beginner in PHP, you could give me a few tips, and if I plan on making a new CMS, I'll use a template system.

Looks good, will be using this soon :D

Enjoy it then.