Illumina CMS - Client error

[Creation]

I recently started a new hotel and I decided to use Illumina CMS, I am trying to get it to use r63b but the acc_pornbanned poppes up when I try to run the the client.

If anyone can give me the code or download for a r63b client that would be great.

 

[StreetMoney]

I recently started a new hotel and I decided to use Illumina CMS, I am trying to get it to use r63b but the acc_pornbanned poppes up when I try to run the the client.

If anyone can give me the code or download for a r63b client that would be great.

Can You take a screenshot please.

 

[xSeanx]

run this in your sql all of it has pornban and everything in there run that should be no problems. - sean

1. DROP TABLE IF EXISTS `hk_fuses`;
2. CREATE TABLE `hk_fuses` (
3. `fuse` varchar(50) NOT NULL,
4. `minrank` int(11) NOT NULL DEFAULT '1'
5. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
8. INSERT INTO `hk_fuses` VALUES ('login', '9');
9. INSERT INTO `hk_fuses` VALUES ('site_manage', '11');
10. INSERT INTO `hk_fuses` VALUES ('pornban', '11');
11. INSERT INTO `hk_fuses` VALUES ('adv_edit', '11');
14. DROP TABLE IF EXISTS `profile_wall`;
15. CREATE TABLE `profile_wall` (
16. `id` int(11) NOT NULL AUTO_INCREMENT,
17. `page_id` int(11) NOT NULL,
18. `poster_id` int(11) NOT NULL,
19. `message` text NOT NULL,
20. `likes` int(11) NOT NULL DEFAULT '0',
21. `owner_read` enum('0','1') NOT NULL DEFAULT '0',
22. PRIMARY KEY (`id`)
23. ) ENGINE=MyISAM AUTO_INCREMENT=1343 DEFAULT CHARSET=latin1;
26. DROP TABLE IF EXISTS `site_hotcampaigns`;
27. CREATE TABLE `site_hotcampaigns` (
28. `id` int(11) NOT NULL AUTO_INCREMENT,
29. `order_id` int(11) NOT NULL DEFAULT '1',
30. `enabled` enum('0','1') NOT NULL DEFAULT '1',
31. `image_url` text NOT NULL,
32. `caption` text NOT NULL,
33. `descr` text NOT NULL,
34. `url` text NOT NULL,
35. PRIMARY KEY (`id`)
36. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
39. DROP TABLE IF EXISTS `site_news`;
40. CREATE TABLE `site_news` (
41. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
42. `seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
43. `title` text NOT NULL,
44. `category_id` int(10) unsigned NOT NULL DEFAULT '1',
45. `topstory_image` text NOT NULL,
46. `body` text NOT NULL,
47. `snippet` text NOT NULL,
48. `datestr` varchar(50) NOT NULL,
49. `timestamp` int(11) NOT NULL,
50. PRIMARY KEY (`id`),
51. KEY `datestr` (`datestr`) USING BT
52. ) ENGINE=MyISAM AUTO_INCREMENT=512 DEFAULT CHARSET=latin1;
54. DROP TABLE IF EXISTS `site_rotw_entries`;
55. CREATE TABLE `site_rotw_entries` (
56. `room_id` int(11) NOT NULL AUTO_INCREMENT,
57. `user_id` int(11) NOT NULL DEFAULT '1',
58. `room_name` text NOT NULL,
59. `room_owner` text NOT NULL,
60. PRIMARY KEY (`room_id`)
61. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
64. DROP TABLE IF EXISTS `badge_shop`;
65. CREATE TABLE `badge_shop` (
66. `badge_id` varchar(12) NOT NULL,
67. `cost` int(100) NOT NULL,
68. KEY `badge_id` (`badge_id`)
69. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
71. ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULL;
72. ALTER TABLE `users` ADD `acc_pornbanned` ENUM('0','1') NOT NULL DEFAULT '0';
73. ALTER TABLE `users` ADD COLUMN `vault_won` int(11) NOT NULL DEFAULT 0;

 

[Creation]

run this in your sql all of it has pornban and everything in there run that should be no problems. - sean

1. DROP TABLE IF EXISTS `hk_fuses`;
2. CREATE TABLE `hk_fuses` (
3. `fuse` varchar(50) NOT NULL,
4. `minrank` int(11) NOT NULL DEFAULT '1'
5. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
6. INSERT INTO `hk_fuses` VALUES ('login', '9');
7. INSERT INTO `hk_fuses` VALUES ('site_manage', '11');
8. INSERT INTO `hk_fuses` VALUES ('pornban', '11');
9. INSERT INTO `hk_fuses` VALUES ('adv_edit', '11');
10. DROP TABLE IF EXISTS `profile_wall`;
11. CREATE TABLE `profile_wall` (
12. `id` int(11) NOT NULL AUTO_INCREMENT,
13. `page_id` int(11) NOT NULL,
14. `poster_id` int(11) NOT NULL,
15. `message` text NOT NULL,
16. `likes` int(11) NOT NULL DEFAULT '0',
17. `owner_read` enum('0','1') NOT NULL DEFAULT '0',
18. PRIMARY KEY (`id`)
19. ) ENGINE=MyISAM AUTO_INCREMENT=1343 DEFAULT CHARSET=latin1;
20. DROP TABLE IF EXISTS `site_hotcampaigns`;
21. CREATE TABLE `site_hotcampaigns` (
22. `id` int(11) NOT NULL AUTO_INCREMENT,
23. `order_id` int(11) NOT NULL DEFAULT '1',
24. `enabled` enum('0','1') NOT NULL DEFAULT '1',
25. `image_url` text NOT NULL,
26. `caption` text NOT NULL,
27. `descr` text NOT NULL,
28. `url` text NOT NULL,
29. PRIMARY KEY (`id`)
30. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
31. DROP TABLE IF EXISTS `site_news`;
32. CREATE TABLE `site_news` (
33. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
34. `seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
35. `title` text NOT NULL,
36. `category_id` int(10) unsigned NOT NULL DEFAULT '1',
37. `topstory_image` text NOT NULL,
38. `body` text NOT NULL,
39. `snippet` text NOT NULL,
40. `datestr` varchar(50) NOT NULL,
41. `timestamp` int(11) NOT NULL,
42. PRIMARY KEY (`id`),
43. KEY `datestr` (`datestr`) USING BT
44. ) ENGINE=MyISAM AUTO_INCREMENT=512 DEFAULT CHARSET=latin1;
45. DROP TABLE IF EXISTS `site_rotw_entries`;
46. CREATE TABLE `site_rotw_entries` (
47. `room_id` int(11) NOT NULL AUTO_INCREMENT,
48. `user_id` int(11) NOT NULL DEFAULT '1',
49. `room_name` text NOT NULL,
50. `room_owner` text NOT NULL,
51. PRIMARY KEY (`room_id`)
52. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
53. DROP TABLE IF EXISTS `badge_shop`;
54. CREATE TABLE `badge_shop` (
55. `badge_id` varchar(12) NOT NULL,
56. `cost` int(100) NOT NULL,
57. KEY `badge_id` (`badge_id`)
58. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
59. ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULL;
60. ALTER TABLE `users` ADD `acc_pornbanned` ENUM('0','1') NOT NULL DEFAULT '0';
61. ALTER TABLE `users` ADD COLUMN `vault_won` int(11) NOT NULL DEFAULT 0;

Thanks. (;