[UNFINISHED, UNSUPPORTED!] CookieMS- Stable

DaLightz

See ya'll in the afterlife.
May 19, 2012
1,136
262
CookieMS Revision, now in development. Thread can be found here: See you there!

Mod, close this thread.
 

DaLightz

See ya'll in the afterlife.
May 19, 2012
1,136
262
This isn't optional, if you don't include images i'll close the thread.
Ok, grabbing them now. 
Screenshots and features added to thread. 
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 ;
 

Users who are viewing this thread

Top