Code:
--
-- Definition of table `customquestinfo`
--
DROP TABLE IF EXISTS `customquestinfo`;
CREATE TABLE `customquestinfo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`questid` int(11) NOT NULL,
`skillid` int(11) NOT NULL,
`startReqs` varchar(255) NOT NULL DEFAULT '0,0,0',
`completeReqs` varchar(255) NOT NULL DEFAULT '0,0,0',
`comments` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `customquestinfo`
--
/*!40000 ALTER TABLE `customquestinfo` DISABLE KEYS */;
INSERT INTO `customquestinfo` (`id`,`questid`,`skillid`,`startReqs`,`completeReqs`,`comments`) VALUES
(1,190000,0,'0,0,0','0,0,0','Family Buff'),
(2,190001,0,'0,0,0','0,0,0','Family Buff'),
(3,190002,0,'0,0,0','0,0,0','Family Buff'),
(4,190003,0,'0,0,0','0,0,0','Family Buff'),
(5,190004,0,'0,0,0','0,0,0','Family Buff'),
(6,190005,0,'0,0,0','0,0,0','Family Buff'),
(7,190006,0,'0,0,0','0,0,0','Family Buff'),
(8,190007,0,'0,0,0','0,0,0','Family Buff'),
(9,190008,0,'0,0,0','0,0,0','Family Buff'),
(10,190009,0,'0,0,0','0,0,0','Family Buff'),
(11,190010,0,'0,0,0','0,0,0','Family Buff'),
(12,100000,0,'0,0,0','0,0,0','First Storyline quest, start at Agent P'),
(13,100001,0,'0,0,0','0,0,0','Start at OSSS Researcher, complete at Dr.Bing'),
(14,100002,0,'0,0,0','mob,100100,30;item,4000019,15','Help Dr Bing hunt Snail and Snail shells'),
(15,100003,0,'0,0,0','item,4001458,5','Get Crystanol Fragments from Reactors'),
(16,100004,0,'0,0,0','0,0,0','Start laboratory quest, someone looking.'),
(17,200000,0,'0,0,0','0,0,0','All storyline done check.'),
(18,150000,0,'0,0,0','0,0,0','Mulung Resting Map save'),
(19,170000,0,'0,0,0','0,0,0','Quick Slot Data'),
(20,170001,0,'0,0,0','0,0,0','Pet Ignore Tag'),
(21,170002,0,'0,0,0','0,0,0','Pet Auto HP'),
(22,170003,0,'0,0,0','0,0,0','Pet Auto MP'),
(23,170004,0,'0,0,0','0,0,0','Report'),
(24,170005,0,'0,0,0','0,0,0','Fixed Skills on KeyMap'),
(25,190011,0,'0,0,0','0,0,0','Speed Quiz'),
(26,100005,0,'0,0,0','item,4032708,10','Deep sea\'s hunting mainboard'),
(27,100006,0,'0,0,0','0,0,0','Choose occupation.'),
(28,100007,0,'0,0,0','item,4031752,20','Unblock 2nd portal and hunt TM part'),
(29,100008,0,'0,0,0','item,4001459,1','Go to future after time machine fixed'),
(31,100009,0,'0,0,0','0,0,0','Find osss Boss'),
(33,190012,0,'0,0,0','0,0,0','@clone command time log'),
(34,190013,0,'0,0,0','0,0,0','@Bomb NX Whores'),
(35,190014,0,'0,0,0','0,0,0','@Heal <name>'),
(36,190015,0,'0,0,0','0,0,0','@Strip <name>'),
(37,190016,0,'0,0,0','0,0,0','@Kill <name>');
/*!40000 ALTER TABLE `customquestinfo` ENABLE KEYS */;
That is what's inside the SQL file. You expect me to add every single other table that is missing? How exactly should I know what columns are missing without doing extreme edits/research through the entire resource pack?