-- phpMyAdmin SQL Dump -- version 2.8.0.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1:3306 -- Generation Time: May 14, 2007 at 07:09 AM -- Server version: 4.1.20 -- PHP Version: 4.3.11 -- -- Database: `kalimdo_dragonfly` -- -- -------------------------------------------------------- -- -- Table structure for table `cms_wowrosterdf_roster_event_limits` -- CREATE TABLE `cms_wowrosterdf_roster_event_limits` ( `eventid` int(11) NOT NULL default '0', `class` varchar(100) NOT NULL default '', `min` int(11) NOT NULL default '0', `max` int(11) NOT NULL default '0', KEY `eventid` (`eventid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `cms_wowrosterdf_roster_event_limits` -- INSERT INTO `cms_wowrosterdf_roster_event_limits` (`eventid`, `class`, `min`, `max`) VALUES (14, 'Priest', 1, 2), (14, 'Shaman', 1, 2), (14, 'Rogue', 1, 2), (14, 'Druid', 1, 2), (14, 'Warrior', 1, 2), (14, 'Hunter', 1, 2), (14, 'Warlock', 1, 2), (14, 'Mage', 1, 2), (14, 'Paladin', 1, 2), (15, 'Priest', 0, 1), (15, 'Shaman', 0, 2), (15, 'Rogue', 0, 2), (15, 'Druid', 0, 2), (15, 'Warrior', 0, 2), (15, 'Hunter', 0, 2), (15, 'Warlock', 0, 1), (15, 'Mage', 0, 1), (15, 'Paladin', 0, 2); -- -------------------------------------------------------- -- -- Table structure for table `cms_wowrosterdf_roster_event_members` -- CREATE TABLE `cms_wowrosterdf_roster_event_members` ( `name` varchar(100) NOT NULL default '', `guild` varchar(255) NOT NULL default '', `class` varchar(100) NOT NULL default '', `level` int(11) NOT NULL default '0', UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `cms_wowrosterdf_roster_event_members` -- INSERT INTO `cms_wowrosterdf_roster_event_members` (`name`, `guild`, `class`, `level`) VALUES ('Crimsonclaw', 'The Dark Sun', 'Rogue', 60), ('Dinalle', 'Kalimdor Tribe', 'Priest', 70), ('Forgar', 'The Dark Sun', 'Hunter', 60), ('Drabga', 'The Dark Sun', 'Priest', 65), ('Cordjacorick', 'The Dark Sun', 'Hunter', 60), ('Bittertongue', 'The Dark Sun', 'Rogue', 64), ('Jaxia', 'The Dark Sun', 'Priest', 70), ('Bonescraper', 'The Dark Sun', 'Mage', 70), ('Zhoie', 'The Dark Sun', 'Priest', 58), ('Logrith', 'The Dark Sun', 'Rogue', 66), ('Chobee', 'Kalimdor Border Patrol', 'Warrior', 60), ('Sindia', 'Kalimdor Tribe', 'Warrior', 60), ('Botta', 'The Dark Sun', 'Rogue', 57), ('Tunka', 'Kalimdor Tribe', 'Warrior', 55), ('Lokuta', 'The Dark Sun', 'Hunter', 60), ('Obya', 'The Dark Sun', 'Druid', 58), ('Elexanie', 'The Dark Sun', 'Warrior', 42), ('Daklor', '', '', 52), ('Nagish', 'The Dark Sun', 'Warrior', 60), ('Shabzz', 'Kalimdor Tribe', 'Mage', 60), ('Reanna', 'The Dark Sun', 'Warlock', 60), ('Othalla', 'The Dark Sun', 'Shaman', 66), ('Peeves', 'The Dark Sun', 'Rogue', 60), ('Okaithul', 'The Dark Sun', 'Shaman', 62), ('Syrric', 'The Dark Sun', 'Warrior', 53), ('Ungar', 'The Dark Sun', 'Hunter', 63), ('Phaq', 'The Dark Sun', 'Warrior', 66), ('Lucentdeath', 'Tribute', 'Warlock', 70), ('Psaltery', 'Tribute', 'Priest', 70), ('Shadowghost', 'Tribute', 'Rogue', 70), ('Sproutweed', 'Tribute', 'Priest', 70), ('Neremac', 'Tribute', 'Hunter', 66), ('Teis', 'Tribute', 'Hunter', 29), ('Karras', 'Tribute', 'Shaman', 41), ('Arrackus', 'Tribute', 'Paladin', 65), ('Zeekie', 'Tribute', 'Druid', 70), ('Zhadkal', 'Tribute', 'Rogue', 67), ('Blackbarron', 'Tribute', 'Shaman', 70), ('Tetiona', 'The Dark Sun', 'Paladin', 67), ('Sukulai', 'Tribute', 'Hunter', 70), ('Dungan', 'Tribute', 'Warrior', 70), ('Gorgnet', 'Tribute', 'Warlock', 70), ('Rennoko', 'Tribute', 'Hunter', 70), ('Lucrecious', 'Tribute', 'Mage', 70), ('Bacca', 'Tribute', 'Warrior', 70), ('Murderous', 'Tribute', 'Mage', 70), ('Warpaint', 'Tribute', 'Warrior', 70), ('Ethris', 'Tribute', 'Shaman', 70), ('Myrmidia', 'Tribute', 'Paladin', 70), ('Revetant', 'Kalimdor Tribe', 'Rogue', 70), ('Takoda', 'Kalimdor Tribe', 'Shaman', 70), ('Marclawley', 'Kalimdor Tribe', 'Mage', 70), ('Rydien', 'The Dark Sun', 'Warlock', 64), ('Maj', 'The Dark Sun', 'Mage', 62), ('Whytlighter', 'Tribute', 'Hunter', 70), ('Harkonnen', 'Tribute', 'Priest', 70), ('Karya', 'Tribute', 'Warrior', 70), ('Samirah', 'Kalimdor Tribe', 'Warlock', 65), ('Denicalis', 'Kalimdor Tribe', 'Warrior', 70), ('Devlo', 'Kalimdor Tribe', 'Shaman', 70), ('Zolend', 'Kalimdor Tribe', 'Mage', 60), ('Goulthor', '', '', 0), ('Afari', 'Kalimdor Tribe', 'Shaman', 53), ('Gangrenna', '', '', 0), ('Tyriddan', 'Kalimdor Tribe', 'Paladin', 57), ('Tral', 'Kalimdor Tribe', 'Rogue', 70), ('Maggio', 'Kalimdor Tribe', 'Paladin', 62), ('Eganrac', 'Kalimdor Tribe', 'Warrior', 66), ('Eviscerateer', 'Kalimdor Tribe', 'Rogue', 70), ('Mikromm', 'Kalimdor Tribe', 'Druid', 70), ('Tormy', 'Kalimdor Tribe', 'Rogue', 70), ('Arielis', 'Kalimdor Tribe', 'Rogue', 70); -- -------------------------------------------------------- -- -- Table structure for table `cms_wowrosterdf_roster_event_subscribers` -- CREATE TABLE `cms_wowrosterdf_roster_event_subscribers` ( `eventid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `place` varchar(10) NOT NULL default '', `status` varchar(100) NOT NULL default '', `note` varchar(255) NOT NULL default '', KEY `eventid` (`eventid`), KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `cms_wowrosterdf_roster_event_subscribers` -- INSERT INTO `cms_wowrosterdf_roster_event_subscribers` (`eventid`, `name`, `place`, `status`, `note`) VALUES (9, 'Devlo', '1', 'Y', ''), (14, 'Marclawley', '1', 'Y', ''), (14, 'Arielis', '2', 'Y', 'as long i still breath free air i will be in!'), (15, 'Marclawley', '1', 'Y', ''), (15, 'Samirah', '2', 'Y', ''); -- -------------------------------------------------------- -- -- Table structure for table `cms_wowrosterdf_roster_events` -- CREATE TABLE `cms_wowrosterdf_roster_events` ( `eventid` int(6) NOT NULL auto_increment, `date` datetime NOT NULL default '0000-00-00 00:00:00', `title` varchar(100) NOT NULL default '', `type` varchar(100) NOT NULL default '', `note` varchar(255) NOT NULL default '', `leader` varchar(100) NOT NULL default '', `minLevel` int(11) NOT NULL default '0', `maxLevel` int(11) NOT NULL default '0', `maxCount` int(11) NOT NULL default '0', KEY `eventid` (`eventid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ; -- -- Dumping data for table `cms_wowrosterdf_roster_events` -- INSERT INTO `cms_wowrosterdf_roster_events` (`eventid`, `date`, `title`, `type`, `note`, `leader`, `minLevel`, `maxLevel`, `maxCount`) VALUES (1, '2007-05-15 00:00:00', '', 'Birth', 'eviscerateer''s birthday', 'Eviscerateer', 0, 0, 0), (2, '2007-05-16 00:00:00', 'Tunka''s Birthday', 'Birth', 'Tunka hits the big 27', 'Tunka', 0, 0, 0), (3, '2007-06-05 00:00:00', 'Zildijins Birthday!', 'Birth', 'Zildijin''s BIRTHDAY!', 'Zildijin', 0, 0, 0), (4, '2007-07-22 00:00:00', '', 'Birth', '', 'Tral', 0, 0, 0), (5, '2007-10-15 00:00:00', '', 'Birth', 'so I get 1 year older...', 'Samirah', 0, 0, 0), (6, '2007-06-29 00:00:00', 'AX bishes!', 'Vacation', 'Deni and Ish are gonna be in Cali for AX for... naughty stuff! Heh. Uh. June 29-July 2-3, I think.', 'Denicalis', 0, 0, 0), (7, '2007-07-25 00:00:00', 'Deni''s Birthday', 'Birth', 'Huzzah. 23. More cake.', 'Denicalis', 0, 0, 0), (8, '2007-07-08 00:00:00', 'Devlo''s B-day', 'Birth', 'A stylin'' mail hat', 'Devlo', 0, 0, 0), (9, '2007-05-19 19:00:00', 'BM', 'Portal', '', 'Devlo', 70, 70, 0), (10, '2008-02-14 00:00:00', '', 'Birth', '', 'Dolamarr', 0, 0, 0), (11, '2007-05-17 00:00:00', 'Teegar''s Birthday', 'Birth', 'I wouldnt have said anything but its cool that there is three in a row. NOW BUY ME A DRINK', 'Teegar', 0, 0, 0), (12, '2007-12-25 00:00:00', 'Maggio''s Birthday', 'Birth', '', 'Maggio', 0, 0, 0), (13, '2008-02-11 00:00:00', 'Marclawley', 'Birth', '16 woot', 'Marclawley', 0, 0, 0), (14, '2007-05-25 21:00:00', '', 'Karazhan', 'must have the master''s key', 'Marclawley', 70, 70, 10), (15, '2007-05-18 22:00:00', '', 'Crypts', '', 'Marclawley', 65, 70, 5), (16, '2007-06-19 00:00:00', '', 'Vacation', 'Im going out to san diego cali to visit my twin brother frylis ^ ^', 'Eganrac', 0, 0, 0), (17, '2007-09-22 00:00:00', 'Eqan''s 25th', 'Birth', 'The big 25 > <', 'Eganrac', 0, 0, 0), (18, '2007-10-18 00:00:00', 'Tormy''s Birthday', 'Birth', '', 'Tormy', 0, 0, 0);