Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
Illumina CMS - Client error
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="xSeanx" data-source="post: 213575" data-attributes="member: 34480"><p>run this in your sql all of it has pornban and everything in there run that should be no problems. - sean </p><p> </p><p> </p><p> </p><p> </p><ol> <li data-xf-list-type="ol"><span style="color: #000000">DROP TABLE IF EXISTS `hk_fuses`;</span></li> <li data-xf-list-type="ol"><span style="color: #000000">CREATE TABLE `hk_fuses` (</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `fuse` varchar(50) NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `minrank` int(11) NOT NULL DEFAULT '1'</span></li> <li data-xf-list-type="ol"><span style="color: #000000">) ENGINE=MyISAM DEFAULT CHARSET=utf8;</span></li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"><span style="color: #000000">INSERT INTO `hk_fuses` VALUES ('login', '9');</span></li> <li data-xf-list-type="ol"><span style="color: #000000">INSERT INTO `hk_fuses` VALUES ('site_manage', '11');</span></li> <li data-xf-list-type="ol"><span style="color: #000000">INSERT INTO `hk_fuses` VALUES ('pornban', '11');</span></li> <li data-xf-list-type="ol"><span style="color: #000000">INSERT INTO `hk_fuses` VALUES ('adv_edit', '11');</span></li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"><span style="color: #000000">DROP TABLE IF EXISTS `profile_wall`;</span></li> <li data-xf-list-type="ol"><span style="color: #000000">CREATE TABLE `profile_wall` (</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `id` int(11) NOT NULL AUTO_INCREMENT,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `page_id` int(11) NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `poster_id` int(11) NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `message` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `likes` int(11) NOT NULL DEFAULT '0',</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `owner_read` enum('0','1') NOT NULL DEFAULT '0',</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> PRIMARY KEY (`id`)</span></li> <li data-xf-list-type="ol"><span style="color: #000000">) ENGINE=MyISAM AUTO_INCREMENT=1343 DEFAULT CHARSET=latin1;</span></li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"><span style="color: #000000">DROP TABLE IF EXISTS `site_hotcampaigns`;</span></li> <li data-xf-list-type="ol"><span style="color: #000000">CREATE TABLE `site_hotcampaigns` (</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `id` int(11) NOT NULL AUTO_INCREMENT,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `order_id` int(11) NOT NULL DEFAULT '1',</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `enabled` enum('0','1') NOT NULL DEFAULT '1',</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `image_url` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `caption` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `descr` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `url` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> PRIMARY KEY (`id`)</span></li> <li data-xf-list-type="ol"><span style="color: #000000">) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;</span></li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"><span style="color: #000000">DROP TABLE IF EXISTS `site_news`;</span></li> <li data-xf-list-type="ol"><span style="color: #000000">CREATE TABLE `site_news` (</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `seo_link` varchar(120) NOT NULL DEFAULT 'news-article',</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `title` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `category_id` int(10) unsigned NOT NULL DEFAULT '1',</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `topstory_image` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `body` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `snippet` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `datestr` varchar(50) NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `timestamp` int(11) NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> PRIMARY KEY (`id`),</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> KEY `datestr` (`datestr`) USING BT<img src="https://cdn.devbest.com/data/assets/smilies/REE.png" srcset="https://cdn.devbest.com/data/assets/smilies/REE.png 1x, https://cdn.devbest.com/data/assets/smilies/REE-2x.png 2x" class="smilie" loading="lazy" alt="REE" title="REE REE" data-shortname="REE" /></span></li> <li data-xf-list-type="ol"><span style="color: #000000">) ENGINE=MyISAM AUTO_INCREMENT=512 DEFAULT CHARSET=latin1;</span></li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"><span style="color: #000000">DROP TABLE IF EXISTS `site_rotw_entries`;</span></li> <li data-xf-list-type="ol"><span style="color: #000000">CREATE TABLE `site_rotw_entries` (</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `room_id` int(11) NOT NULL AUTO_INCREMENT,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `user_id` int(11) NOT NULL DEFAULT '1',</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `room_name` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `room_owner` text NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> PRIMARY KEY (`room_id`)</span></li> <li data-xf-list-type="ol"><span style="color: #000000">) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;</span></li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"><span style="color: #000000">DROP TABLE IF EXISTS `badge_shop`;</span></li> <li data-xf-list-type="ol"><span style="color: #000000">CREATE TABLE `badge_shop` (</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `badge_id` varchar(12) NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> `cost` int(100) NOT NULL,</span></li> <li data-xf-list-type="ol"><span style="color: #000000"> KEY `badge_id` (`badge_id`)</span></li> <li data-xf-list-type="ol"><span style="color: #000000">) ENGINE=MyISAM DEFAULT CHARSET=utf8;</span></li> <li data-xf-list-type="ol"> </li> <li data-xf-list-type="ol"><span style="color: #000000">ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULL;</span></li> <li data-xf-list-type="ol"><span style="color: #000000">ALTER TABLE `users` ADD `acc_pornbanned` ENUM('0','1') NOT NULL DEFAULT '0';</span></li> <li data-xf-list-type="ol"><span style="color: #000000">ALTER TABLE `users` ADD COLUMN `vault_won` int(11) NOT NULL DEFAULT 0;</span></li> </ol></blockquote><p></p>
[QUOTE="xSeanx, post: 213575, member: 34480"] run this in your sql all of it has pornban and everything in there run that should be no problems. - sean [LIST=1] [*][COLOR=#000000]DROP TABLE IF EXISTS `hk_fuses`;[/COLOR] [*][COLOR=#000000]CREATE TABLE `hk_fuses` ([/COLOR] [*][COLOR=#000000] `fuse` varchar(50) NOT NULL,[/COLOR] [*][COLOR=#000000] `minrank` int(11) NOT NULL DEFAULT '1'[/COLOR] [*][COLOR=#000000]) ENGINE=MyISAM DEFAULT CHARSET=utf8;[/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000]INSERT INTO `hk_fuses` VALUES ('login', '9');[/COLOR] [*][COLOR=#000000]INSERT INTO `hk_fuses` VALUES ('site_manage', '11');[/COLOR] [*][COLOR=#000000]INSERT INTO `hk_fuses` VALUES ('pornban', '11');[/COLOR] [*][COLOR=#000000]INSERT INTO `hk_fuses` VALUES ('adv_edit', '11');[/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000]DROP TABLE IF EXISTS `profile_wall`;[/COLOR] [*][COLOR=#000000]CREATE TABLE `profile_wall` ([/COLOR] [*][COLOR=#000000] `id` int(11) NOT NULL AUTO_INCREMENT,[/COLOR] [*][COLOR=#000000] `page_id` int(11) NOT NULL,[/COLOR] [*][COLOR=#000000] `poster_id` int(11) NOT NULL,[/COLOR] [*][COLOR=#000000] `message` text NOT NULL,[/COLOR] [*][COLOR=#000000] `likes` int(11) NOT NULL DEFAULT '0',[/COLOR] [*][COLOR=#000000] `owner_read` enum('0','1') NOT NULL DEFAULT '0',[/COLOR] [*][COLOR=#000000] PRIMARY KEY (`id`)[/COLOR] [*][COLOR=#000000]) ENGINE=MyISAM AUTO_INCREMENT=1343 DEFAULT CHARSET=latin1;[/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000]DROP TABLE IF EXISTS `site_hotcampaigns`;[/COLOR] [*][COLOR=#000000]CREATE TABLE `site_hotcampaigns` ([/COLOR] [*][COLOR=#000000] `id` int(11) NOT NULL AUTO_INCREMENT,[/COLOR] [*][COLOR=#000000] `order_id` int(11) NOT NULL DEFAULT '1',[/COLOR] [*][COLOR=#000000] `enabled` enum('0','1') NOT NULL DEFAULT '1',[/COLOR] [*][COLOR=#000000] `image_url` text NOT NULL,[/COLOR] [*][COLOR=#000000] `caption` text NOT NULL,[/COLOR] [*][COLOR=#000000] `descr` text NOT NULL,[/COLOR] [*][COLOR=#000000] `url` text NOT NULL,[/COLOR] [*][COLOR=#000000] PRIMARY KEY (`id`)[/COLOR] [*][COLOR=#000000]) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;[/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000]DROP TABLE IF EXISTS `site_news`;[/COLOR] [*][COLOR=#000000]CREATE TABLE `site_news` ([/COLOR] [*][COLOR=#000000] `id` int(10) unsigned NOT NULL AUTO_INCREMENT,[/COLOR] [*][COLOR=#000000] `seo_link` varchar(120) NOT NULL DEFAULT 'news-article',[/COLOR] [*][COLOR=#000000] `title` text NOT NULL,[/COLOR] [*][COLOR=#000000] `category_id` int(10) unsigned NOT NULL DEFAULT '1',[/COLOR] [*][COLOR=#000000] `topstory_image` text NOT NULL,[/COLOR] [*][COLOR=#000000] `body` text NOT NULL,[/COLOR] [*][COLOR=#000000] `snippet` text NOT NULL,[/COLOR] [*][COLOR=#000000] `datestr` varchar(50) NOT NULL,[/COLOR] [*][COLOR=#000000] `timestamp` int(11) NOT NULL,[/COLOR] [*][COLOR=#000000] PRIMARY KEY (`id`),[/COLOR] [*][COLOR=#000000] KEY `datestr` (`datestr`) USING BTREE[/COLOR] [*][COLOR=#000000]) ENGINE=MyISAM AUTO_INCREMENT=512 DEFAULT CHARSET=latin1;[/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000]DROP TABLE IF EXISTS `site_rotw_entries`;[/COLOR] [*][COLOR=#000000]CREATE TABLE `site_rotw_entries` ([/COLOR] [*][COLOR=#000000] `room_id` int(11) NOT NULL AUTO_INCREMENT,[/COLOR] [*][COLOR=#000000] `user_id` int(11) NOT NULL DEFAULT '1',[/COLOR] [*][COLOR=#000000] `room_name` text NOT NULL,[/COLOR] [*][COLOR=#000000] `room_owner` text NOT NULL,[/COLOR] [*][COLOR=#000000] PRIMARY KEY (`room_id`)[/COLOR] [*][COLOR=#000000]) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;[/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000]DROP TABLE IF EXISTS `badge_shop`;[/COLOR] [*][COLOR=#000000]CREATE TABLE `badge_shop` ([/COLOR] [*][COLOR=#000000] `badge_id` varchar(12) NOT NULL,[/COLOR] [*][COLOR=#000000] `cost` int(100) NOT NULL,[/COLOR] [*][COLOR=#000000] KEY `badge_id` (`badge_id`)[/COLOR] [*][COLOR=#000000]) ENGINE=MyISAM DEFAULT CHARSET=utf8;[/COLOR] [*][COLOR=#000000] [/COLOR] [*][COLOR=#000000]ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULL;[/COLOR] [*][COLOR=#000000]ALTER TABLE `users` ADD `acc_pornbanned` ENUM('0','1') NOT NULL DEFAULT '0';[/COLOR] [*][COLOR=#000000]ALTER TABLE `users` ADD COLUMN `vault_won` int(11) NOT NULL DEFAULT 0;[/COLOR] [/LIST] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
Illumina CMS - Client error
Top