Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `quest_mail_data` (
- `entry` INT(10) NOT NULL,
- `mailtemplate` INT(10) NOT NULL,
- `maildelay` INT(10) NOT NULL,
- PRIMARY KEY (`entry`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- INSERT INTO `quest_mail_data`(`entry`,`mailtemplate`,`maildelay`) VALUES (1141,87,0),(3644,103,86400),(3645,99,86400),(3646,104,86400),(3647,100,86400),(5128,98,86400),(5237,101,86400),(5238,107,86400),(6001,112,21600),(6002,116,21600),(6125,115,21600),(6130,114,21600),(7735,119,0),(7738,120,0),(8149,113,86400),(8150,111,86400),(8240,109,86400),(8323,93,21600),(8324,94,21600),(8619,84,21600),(8635,85,21600),(8636,86,21600),(8642,88,21600),(8643,89,21600),(8644,90,21600),(8645,91,21600),(8646,92,21600),(8647,95,21600),(8648,96,21600),(8649,97,21600),(8650,121,21600),(8651,124,21600),(8652,125,21600),(8653,126,21600),(8654,127,21600),(8670,128,21600),(8671,129,21600),(8672,130,21600),(8673,131,21600),(8674,132,21600),(8675,133,21600),(8676,134,21600),(8677,135,21600),(8678,136,21600),(8679,137,21600),(8680,138,21600),(8681,139,21600),(8682,140,21600),(8683,141,21600),(8684,142,21600),(8685,143,21600),(8686,144,21600),(8688,145,21600),(8713,146,21600),(8714,147,21600),(8715,148,21600),(8716,149,21600),(8717,150,21600),(8718,151,21600),(8719,152,21600),(8720,153,21600),(8721,154,21600),(8722,155,21600),(8723,156,21600),(8724,157,21600),(8725,158,21600),(8726,159,21600),(8727,160,21600),(8866,168,21600),(9671,180,0),(10588,183,0);
- UPDATE quests q JOIN quest_mail_data qm USING (entry)
- SET q.MailTemplateId = qm.mailtemplate,
- q.MailDelaySecs = qm.maildelay;
- DROP TABLE `quest_mail_data`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement