INSERT INTO `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) VALUES ('Regrowth_Bard_Spec_Greater_Heal1', 'Regrowth Bard Spec', '4861', '9'), ('Regrowth_Bard_Spec_Greater_Heal2', 'Regrowth Bard Spec', '4862', '14'), ('Regrowth_Bard_Spec_Greater_Heal3', 'Regrowth Bard Spec', '4863', '19'), ('Regrowth_Bard_Spec_Greater_Heal4', 'Regrowth Bard Spec', '4864', '25'), ('Regrowth_Bard_Spec_Greater_Heal5', 'Regrowth Bard Spec', '4865', '32'), ('Regrowth_Bard_Spec_Greater_Heal6', 'Regrowth Bard Spec', '4866', '41'), ('Regrowth_Bard_Spec_Greater_Heal7', 'Regrowth Bard Spec', '4867', '50');
INSERT INTO `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) VALUES
('Heretic_Rejuvenation_Spec_Heal1','Heretic Rejuvenation Spec', '1351', '7'),
('Heretic_Rejuvenation_Spec_Heal2','Heretic Rejuvenation Spec', '1352', '8'),
('Heretic_Rejuvenation_Spec_Heal3','Heretic Rejuvenation Spec', '1353', '11'),
('Heretic_Rejuvenation_Spec_Heal4','Heretic Rejuvenation Spec', '1355', '18'),
('Heretic_Rejuvenation_Spec_Heal5','Heretic Rejuvenation Spec', '1356', '24'),
('Heretic_Rejuvenation_Spec_Heal6','Heretic Rejuvenation Spec', '1357', '33'),
('Heretic_Rejuvenation_Spec_Heal7','Heretic Rejuvenation Spec', '1358', '43')
UPDATE `linexspell` SET `LineName` = 'Heretic Rejuvenation Spec' WHERE CONVERT( `linexspell`.`LineXSpell_ID` USING utf8 ) = 'f252525-f25252-5f252353' LIMIT 1 ;
UPDATE `spell` set `Duration` = '20' where `SpellID` = '14075'
tolakram wrote:DBHouse
Creation date is 0-0-0 0:0:0 which is a valid MySQL date but does not convert in the latest DOL code. I fixed it by running:
update dbhouse set creationtime = now();
UPDATE `house` SET `CreationDate` = NOW();
Etaew wrote:
- Code: Select all
UPDATE `house` SET `CreationDate` = NOW();
REPLACE INTO tablename (field1, field2, field3) VALUES ('value1', 'value2', 'value3')
INSERT INTO tablename (field1, field2, field3) VALUES ('value1', 'value2', 'value3')
Users browsing this forum: No registered users and 1 guest