OFT:Im a bit lazy. Please refer to the development thread. I no longer support CookieMS.
This isn't optional, if you don't include images i'll close the thread.Im a bit lazy. Please refer to the development thread. I no longer support CookieMS.
Ok, grabbing them now.This isn't optional, if you don't include images i'll close the thread.
--
--- 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 ;