Advertisement
jackpoz

quest mail data

Oct 22nd, 2011
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.59 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `quest_mail_data` (
  2.   `entry` INT(10) NOT NULL,
  3.   `mailtemplate` INT(10) NOT NULL,
  4.   `maildelay` INT(10) NOT NULL,
  5.   PRIMARY KEY (`entry`)
  6. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  7.  
  8. 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);
  9.  
  10. UPDATE quests q JOIN quest_mail_data qm USING (entry)
  11. SET q.MailTemplateId = qm.mailtemplate,
  12. q.MailDelaySecs = qm.maildelay;
  13.  
  14. DROP TABLE `quest_mail_data`;
  15.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement