Reply to thread

Message

<blockquote data-quote="DaLightz" data-source="post: 121147" data-attributes="member: 17436">Ok, grabbing them now.[DOUBLEPOST=1342163317,1342163147][/DOUBLEPOST]Screenshots and features added to thread.[DOUBLEPOST=1342163414][/DOUBLEPOST]ALMOST FORGOT RUN THESE SQLS![CODE]----- Here is the SQL'S that are required to make CookieMS work properly.--&nbsp;----- CookieMS Groups Memberships--CREATE TABLE IF NOT EXISTS `cookiems_groups_memberships` (&nbsp; `userid` int(10) NOT NULL,&nbsp; `groupid` int(10) NOT NULL,&nbsp; `member_rank` enum('3','2','1') COLLATE latin1_general_ci NOT NULL DEFAULT '3',&nbsp; `is_current` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',&nbsp; `is_pending` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;&nbsp;&nbsp;&nbsp;----- CookieMS Groups Details--CREATE TABLE IF NOT EXISTS `cookiems_groups_details` (&nbsp; `id` int(10) NOT NULL AUTO_INCREMENT,&nbsp; `name` varchar(45) COLLATE latin1_general_ci NOT NULL,&nbsp; `description` varchar(200) COLLATE latin1_general_ci NOT NULL,&nbsp; `ownerid` int(10) NOT NULL,&nbsp; `roomid` int(10) NOT NULL,&nbsp; `created` varchar(50) COLLATE latin1_general_ci NOT NULL,&nbsp; `badge` text COLLATE latin1_general_ci NOT NULL,&nbsp; `type` int(1) NOT NULL DEFAULT '0',&nbsp; `recommended` int(1) NOT NULL DEFAULT '0',&nbsp; `views` int(15) NOT NULL,&nbsp; `pane` smallint(1) NOT NULL DEFAULT '0',&nbsp; `topics` smallint(1) NOT NULL DEFAULT '0',&nbsp; `bg` varchar(210) COLLATE latin1_general_ci NOT NULL DEFAULT 'b_bg_colour_08',&nbsp; PRIMARY KEY (`id`,`name`),&nbsp; KEY `bg` (`bg`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;&nbsp;&nbsp;----- CookieMS Campaigns--CREATE TABLE IF NOT EXISTS `cookiems_campaigns` (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `order_id` int(11) NOT NULL DEFAULT '1',&nbsp; `enabled` enum('0','1') NOT NULL DEFAULT '1',&nbsp; `image_url` text NOT NULL,&nbsp; `caption` text NOT NULL,&nbsp; `descr` text NOT NULL,&nbsp; `url` text NOT NULL,&nbsp; PRIMARY KEY (`id`)) ENGINE=MyISAM&nbsp; DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;&nbsp;INSERT INTO `cookiems_campaigns` (`id`, `order_id`, `enabled`, `image_url`, `caption`, `descr`, `url`) VALUES(2, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'Test 2', 'MOAR MOAR MOAR!', 'http://devbest.com'),(3, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'MOAR TEST!', 'LOOOOOL MOAR!', 'http://devbest.com'),(1, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'Test', 'This is a test for my shit..', 'http://devbest.com');&nbsp;----- CookieMS Items for groups/homes--CREATE TABLE IF NOT EXISTS `cookiems_items` (&nbsp; `id` int(100) NOT NULL AUTO_INCREMENT,&nbsp; `userId` int(100) NOT NULL,&nbsp; `groupId` int(10) NOT NULL,&nbsp; `position_left` int(4) NOT NULL,&nbsp; `position_top` int(4) NOT NULL,&nbsp; `position_z` int(4) NOT NULL,&nbsp; `var` varchar(100) NOT NULL,&nbsp; `skin` varchar(100) NOT NULL,&nbsp; `content` text NOT NULL,&nbsp; `type` enum('stickie','sticker','widget') NOT NULL DEFAULT 'sticker',&nbsp; `Temporal` enum('True','False') NOT NULL DEFAULT 'False',&nbsp; PRIMARY KEY (`id`)) ENGINE=MyISAM&nbsp; DEFAULT CHARSET=latin1 COMMENT='Stickies del Sitio' AUTO_INCREMENT=72 ;[/CODE]</blockquote>

[QUOTE="DaLightz, post: 121147, member: 17436"] Ok, grabbing them now.[DOUBLEPOST=1342163317,1342163147][/DOUBLEPOST]Screenshots and features added to thread.[DOUBLEPOST=1342163414][/DOUBLEPOST]ALMOST FORGOT RUN THESE SQLS! [CODE]-- --- Here is the SQL'S that are required to make CookieMS work properly. -- -- --- CookieMS Groups Memberships -- CREATE TABLE IF NOT EXISTS `cookiems_groups_memberships` ( `userid` int(10) NOT NULL, `groupid` int(10) NOT NULL, `member_rank` enum('3','2','1') COLLATE latin1_general_ci NOT NULL DEFAULT '3', `is_current` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0', `is_pending` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- --- CookieMS Groups Details -- CREATE TABLE IF NOT EXISTS `cookiems_groups_details` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(45) COLLATE latin1_general_ci NOT NULL, `description` varchar(200) COLLATE latin1_general_ci NOT NULL, `ownerid` int(10) NOT NULL, `roomid` int(10) NOT NULL, `created` varchar(50) COLLATE latin1_general_ci NOT NULL, `badge` text COLLATE latin1_general_ci NOT NULL, `type` int(1) NOT NULL DEFAULT '0', `recommended` int(1) NOT NULL DEFAULT '0', `views` int(15) NOT NULL, `pane` smallint(1) NOT NULL DEFAULT '0', `topics` smallint(1) NOT NULL DEFAULT '0', `bg` varchar(210) COLLATE latin1_general_ci NOT NULL DEFAULT 'b_bg_colour_08', PRIMARY KEY (`id`,`name`), KEY `bg` (`bg`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ; -- --- CookieMS Campaigns -- CREATE TABLE IF NOT EXISTS `cookiems_campaigns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `order_id` int(11) NOT NULL DEFAULT '1', `enabled` enum('0','1') NOT NULL DEFAULT '1', `image_url` text NOT NULL, `caption` text NOT NULL, `descr` text NOT NULL, `url` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; INSERT INTO `cookiems_campaigns` (`id`, `order_id`, `enabled`, `image_url`, `caption`, `descr`, `url`) VALUES (2, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'Test 2', 'MOAR MOAR MOAR!', 'http://devbest.com'), (3, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'MOAR TEST!', 'LOOOOOL MOAR!', 'http://devbest.com'), (1, 1, '1', 'http://65.96.141.124/app/tpl/skins/Habbo/images/facebookconnect.gif', 'Test', 'This is a test for my shit..', 'http://devbest.com'); -- --- CookieMS Items for groups/homes -- CREATE TABLE IF NOT EXISTS `cookiems_items` ( `id` int(100) NOT NULL AUTO_INCREMENT, `userId` int(100) NOT NULL, `groupId` int(10) NOT NULL, `position_left` int(4) NOT NULL, `position_top` int(4) NOT NULL, `position_z` int(4) NOT NULL, `var` varchar(100) NOT NULL, `skin` varchar(100) NOT NULL, `content` text NOT NULL, `type` enum('stickie','sticker','widget') NOT NULL DEFAULT 'sticker', `Temporal` enum('True','False') NOT NULL DEFAULT 'False', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stickies del Sitio' AUTO_INCREMENT=72 ; [/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members