• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

novichotel.com CMS (My IlluminaCMS edit)

Status
Not open for further replies.
Junior Spellweaver
Joined
Jun 1, 2010
Messages
152
Reaction score
27
So I'm leaving retros for a bit and thought i'd release my cms. I fixed all the exploits in it so there shouldn't be any exploits. Filtered all the things users input and also used prepare statements for some querys since it's mysqli.

i'll explain some of the functions..

Poll System

You can create polls for news articles on the housekeeping page, for competitions etc.. once you created the poll you just copy the Poll ID and enter it in when you are creating a news article. You can view poll submissions and toggle opening and closing the poll on the Poll submissions page in housekeeping. Pretty neat for ROTW submissions?

Help System

Create a help ticket via website, shows on the /me page, staff get alerts and reply via housekeeping.

Avatar of the month

Changed by aotm column in site_config.sql

Vault

Automatically changed when someone guesses it, captcha required if the user has won already.

Point Shop

Points are the websites currency, used for VIP etc, add points in housekeeping.

There is also a form that is like 70% complete, to enable it just edit me.php and allow the form template to show..

Screenshots:

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

owot - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums

DOWNLOAD

can someone please mirror?

This is the FULL database as there has been too much database work to get all the querys for you. Works with bcstorm and firewind or whatever everyone uses now. If you have another database then just take stuff from this full database until the CMS stops giving errors. I will NOT be providing support so please don't pm me or post support in here..

Credits

Lasuni
Me for doing all the PHP coding and creating it basically.
Jonty for the base
Habbo?
and whoever else.
 
Hakuna Matata
Joined
Sep 5, 2012
Messages
804
Reaction score
137
Just looked through the pictures, looks like a very great CMS.
Thank you for this release.
 
Junior Spellweaver
Joined
Jun 1, 2010
Messages
152
Reaction score
27
Just looked through the pictures, looks like a very great CMS.
Thank you for this release.
Thank you.

I forgot, there are some codes in housekeeping viewstaff.php that checks if the username is jayden. Just remove that sorry.

Also some codes in lightcms.php that checks to see if the username is "lenny" and just posts on the website as a novic hotel account, nothing too serious but can be removed aswell. Did not have time.
 
Joined
Jun 2, 2012
Messages
765
Reaction score
294
PHP:
if($db->stmt = $db->prepare("UPDATE profile_about SET bio = '" . $bio . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}
			if($db->stmt = $db->prepare("UPDATE profile_about SET facebookUrl = '" . $fb . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}
			if($db->stmt = $db->prepare("UPDATE profile_about SET twitterUrl = '" . $tw . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}
			if($db->stmt = $db->prepare("UPDATE profile_about SET flag = '" . $flag . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}
			if($db->stmt = $db->prepare("UPDATE profile_about SET youtube_url = '" . $yt . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}

People really need to learn how to use prepared statements properly.
OVERKILL MUCH!
 
Developer
Loyal Member
Joined
Jul 28, 2009
Messages
983
Reaction score
133
Screens aren't working unfortunately
 
Newbie Spellweaver
Joined
May 12, 2013
Messages
35
Reaction score
4
captcha on register does not work please provide a fix?
424GhtE - novichotel.com CMS (My IlluminaCMS edit) - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
idk what to put here
Loyal Member
Joined
Oct 19, 2007
Messages
491
Reaction score
159
yo screenshots are broken.
 
Hakuna Matata
Joined
Sep 5, 2012
Messages
804
Reaction score
137
Images:




























 
Experienced Elementalist
Joined
Jun 3, 2012
Messages
224
Reaction score
55
Mega;
Mediafire;
 
Experienced Elementalist
Joined
Jan 17, 2012
Messages
229
Reaction score
132
Great Work I must say. :congrats:
This CMS includes a lot of features that will improve some new hotels to get a better hotel management, I certainly talk about the automated help ticket system on website, brilliant not that much hotel use this (or get a free alternative like Zendesk).

Get this in my archive for sure will take a look at the code, the design is pretty neat actually I love it, it match the Habbo Theme well.
 
Junior Spellweaver
Joined
Jun 1, 2010
Messages
152
Reaction score
27
PHP:
if($db->stmt = $db->prepare("UPDATE profile_about SET bio = '" . $bio . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}
			if($db->stmt = $db->prepare("UPDATE profile_about SET facebookUrl = '" . $fb . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}
			if($db->stmt = $db->prepare("UPDATE profile_about SET twitterUrl = '" . $tw . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}
			if($db->stmt = $db->prepare("UPDATE profile_about SET flag = '" . $flag . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}
			if($db->stmt = $db->prepare("UPDATE profile_about SET youtube_url = '" . $yt . "' WHERE user_id = '" . USER_ID . "'")) {
				$db->stmt->execute();
				$db->stmt->close();
			}

People really need to learn how to use prepared statements properly.
OVERKILL MUCH!

I'm actually not quite sure why I did that, I was not really good at PHP when I first started on this.
 
Experienced Elementalist
Joined
Dec 25, 2011
Messages
278
Reaction score
57
Looks good!

But i can't even translate it :S everything disapears
 
Status
Not open for further replies.
Back
Top