[Release] RevCMS habbo theme edit! & RevCMS Housekeeping

[Snappy]

yh

Could you provide me with a emu preferably r63b that will work with this?

 

[Data]

Could you provide me with a emu preferably r63b that will work with this?

Any r63b emu should work with this, PlusEMU, Bcstorm any of these should work may have to make a few SSO code changes to work with bcstorm or swift.

 

[Snappy]

Any r63b emu should work with this, PlusEMU, Bcstorm any of these should work may have to make a few SSO code changes to work with bcstorm or swift.

I know what to do I need to make the table 'r63b.cms_news' But im bad at making tables

 

[Data]

I know what to do I need to make the table 'r63b.cms_news' But im bad at making tables

You have to get the cms_news sql from phx db or anything that has it, can you avoid posting here make a help thread I won't be helping you through this thread now.

 

[Adrian]

I tried using build 3, but the client didn't work?

 

[Netskyau]

Copy your old client.php and config.php

 

[Data]

I tried using build 3, but the client didn't work?

I'll post a updated version later after I have tested it.

 

[Sab]

@Data

Why does my news slide show only stay at one news image? Any fix for that?

 

[Data]

@Data

Why does my news slide show only stay at one news image? Any fix for that?

What do you mean?

 

[Sab]

What do you mean?

I've made a post about it here;

You must be registered for see links

Any solutions?

 

[Kieron]

It's so confusing. I don't understand you could of just completed it all and released it? I honestly don't see the point.

 

[Kieron]

Take that back...

 

[Data]

Take that back...

What?

 

[arfeus]

Hello date'm a good problem I installed the cms correctly but was testing HK and noticed that she has a line that determines just one rank to access the panel, as I remember the line 270 rank 6, as I do to be able to access to all ranks just for example staff team 5-8 deculpe my english I'm Brazilian.
Print -

You must be registered for see links

 

[Data]

Hello date'm a good problem I installed the cms correctly but was testing HK and noticed that she has a line that determines just one rank to access the panel, as I remember the line 270 rank 6, as I do to be able to access to all ranks just for example staff team 5-8 deculpe my english I'm Brazilian.
Print -

You must be registered for see links

This version is broken, will probably post download link for latest version later.

 

[Snap]

I've got that before and I fixed it all you need to do is add rank 6+ to your account in navicat

 

[arfeus]

Got it'll be waiting for the next version to be able to be using in some hotels that I have thanks.

 

[Data]

Made a new HK was bored.
RevCMS HK
What should I do if I find a bug? Feel free to post it here, then I can fix it for everyone else.
What should I do if I find a exploit? PM me it and will get it fixed.
Before people ask I done most of this myself but some of it is using functions from another HK(GrapeASE, done it about a week ago will redo it in a different way soon - Edit user page.)

Download:Mirror 1 -

You must be registered for see links

Mirror 2 -

You must be registered for see links

Here is the user of the week script.

<div class="habblet-container ">
<div class="cbb clearfix settings ">
<?php

$q = mysql_query("SELECT * FROM settings WHERE id = 1");
$newq = mysql_fetch_assoc($q);

$q = mysql_query("SELECT * FROM users WHERE username = '" . $newq['uotw'] . "'");
$lol = mysql_fetch_assoc($q);
?>
<h2 class="title">User of the week</h2>
<div style="padding:5px">
<img src = "http://www.habbo.nl/habbo-imaging/avatarimage?figure=<?php echo $lol['look']; ?>">
<div style = "float:right;padding:12px;margin-right:-15px;width:200px;">
<span>Username: <?php echo $lol['username']; ?></span></br>
<span>Motto: <?php echo $lol['motto']; ?></span></br>
<span>Last Online: <?php echo date("l jS \of F",$m['last_online']); ?></span>
</div>
</div>
</div>
</div>

Forgot to do SQLs in download.

-- ----------------------------
-- Table structure for `hk_logs`
-- ----------------------------
DROP TABLE IF EXISTS `hk_logs`;
CREATE TABLE `hk_logs` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`who_done` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `settings`
-- ----------------------------
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uotw` varchar(255) DEFAULT NULL,
`hk_alert` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of settings
-- ----------------------------
INSERT INTO `settings` VALUES ('1', 'Test', 'Fkng awesome');

Code isn't the best, I am still learning will update it every few days.

 

[GarettM]

Doesn't RevolutionCMS use Phoenix DB?
if so this is useless: (below) because cms_news can deliver the same results? also InnoDB is better then MyISAM in my eyes

Spoiler: CODE

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for site_hotcampaigns
-- ----------------------------
DROP TABLE IF EXISTS `site_hotcampaigns`;
CREATE TABLE `site_hotcampaigns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`image_url` text NOT NULL,
`caption` text NOT NULL,
`desc` text NOT NULL,
`url` text NOT NULL,
`order_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

 

[Jezus]

Incorrect integer value: 'Ben' for column 'author' at row 1

got a fix?!