Page 1 of 1

Necromancer Spells

PostPosted: Thu Jul 19, 2007 10:42 am
by Aredhel
Added records for necromancer to linexspell and applied 2 small fixes to spell and spellline, so all necro spells will show up ingame now:
Code: Select all
update spellline set IsBaseLine = 1 where KeyName = 'Painworking';
Code: Select all
update spell set Name = 'Pain of the Dead' where SpellID = 9145;
Code: Select all
INSERT INTO linexspell () VALUES ('NecroBaseArmorDebuff2', 'Deathsight', 9001, 2);
INSERT INTO linexspell () VALUES ('NecroBaseArmorDebuff5', 'Deathsight', 9002, 5);
INSERT INTO linexspell () VALUES ('NecroBaseArmorDebuff9', 'Deathsight', 9003, 9);
INSERT INTO linexspell () VALUES ('NecroBaseArmorDebuff14', 'Deathsight', 9004, 14);
INSERT INTO linexspell () VALUES ('NecroBaseArmorDebuff21', 'Deathsight', 9005, 21);
INSERT INTO linexspell () VALUES ('NecroBaseArmorDebuff29', 'Deathsight', 9006, 29);
INSERT INTO linexspell () VALUES ('NecroBaseArmorDebuff39', 'Deathsight', 9007, 39);
INSERT INTO linexspell () VALUES ('NecroBaseArmorDebuff49', 'Deathsight', 9008, 49);
INSERT INTO linexspell () VALUES ('NecroBaseLifetap1', 'Deathsight', 9011, 1);
INSERT INTO linexspell () VALUES ('NecroBaseLifetap4', 'Deathsight', 9012, 4);
INSERT INTO linexspell () VALUES ('NecroBaseLifetap8', 'Deathsight', 9013, 8);
INSERT INTO linexspell () VALUES ('NecroBaseLifetap13', 'Deathsight', 9014, 13);
INSERT INTO linexspell () VALUES ('NecroBaseLifetap19', 'Deathsight', 9015, 19);
INSERT INTO linexspell () VALUES ('NecroBaseLifetap25', 'Deathsight', 9016, 25);
INSERT INTO linexspell () VALUES ('NecroBaseLifetap32', 'Deathsight', 9017, 32);
INSERT INTO linexspell () VALUES ('NecroBaseLifetap40', 'Deathsight', 9018, 40);
INSERT INTO linexspell () VALUES ('NecroBaseLifetap50', 'Deathsight', 9019, 50);
INSERT INTO linexspell () VALUES ('NecroBaseDexBuff3', 'Deathsight', 9021, 3);
INSERT INTO linexspell () VALUES ('NecroBaseDexBuff7', 'Deathsight', 9022, 7);
INSERT INTO linexspell () VALUES ('NecroBaseDexBuff12', 'Deathsight', 9023, 12);
INSERT INTO linexspell () VALUES ('NecroBaseDexBuff18', 'Deathsight', 9024, 18);
INSERT INTO linexspell () VALUES ('NecroBaseDexBuff26', 'Deathsight', 9025, 26);
INSERT INTO linexspell () VALUES ('NecroBaseDexBuff35', 'Deathsight', 9026, 35);
INSERT INTO linexspell () VALUES ('NecroBaseDexBuff45', 'Deathsight', 9027, 45);
INSERT INTO linexspell () VALUES ('NecroSpecABSBuff29', 'Necro Deathsight', 9101, 29);
INSERT INTO linexspell () VALUES ('NecroSpecABSBuff38', 'Necro Deathsight', 9102, 38);
INSERT INTO linexspell () VALUES ('NecroSpecABSBuff48', 'Necro Deathsight', 9103, 48);
INSERT INTO linexspell () VALUES ('NecroSpecPowertap1', 'Necro Deathsight', 9111, 1);
INSERT INTO linexspell () VALUES ('NecroSpecPowertap3', 'Necro Deathsight', 9112, 3);
INSERT INTO linexspell () VALUES ('NecroSpecPowertap7', 'Necro Deathsight', 9113, 7);
INSERT INTO linexspell () VALUES ('NecroSpecPowertap12', 'Necro Deathsight', 9114, 12);
INSERT INTO linexspell () VALUES ('NecroSpecPowertap18', 'Necro Deathsight', 9115, 18);
INSERT INTO linexspell () VALUES ('NecroSpecPowertap25', 'Necro Deathsight', 9116, 25);
INSERT INTO linexspell () VALUES ('NecroSpecPowertap34', 'Necro Deathsight', 9117, 34);
INSERT INTO linexspell () VALUES ('NecroSpecPowertap44', 'Necro Deathsight', 9118, 44);
INSERT INTO linexspell () VALUES ('NecroSpecPowerTransfer4', 'Necro Deathsight', 9121, 4);
INSERT INTO linexspell () VALUES ('NecroSpecPowerTransfer8', 'Necro Deathsight', 9122, 8);
INSERT INTO linexspell () VALUES ('NecroSpecPowerTransfer11', 'Necro Deathsight', 9123, 11);
INSERT INTO linexspell () VALUES ('NecroSpecPowerTransfer15', 'Necro Deathsight', 9124, 15);
INSERT INTO linexspell () VALUES ('NecroSpecPowerTransfer21', 'Necro Deathsight', 9125, 21);
INSERT INTO linexspell () VALUES ('NecroSpecPowerTransfer28', 'Necro Deathsight', 9126, 28);
INSERT INTO linexspell () VALUES ('NecroSpecPowerTransfer35', 'Necro Deathsight', 9127, 35);
INSERT INTO linexspell () VALUES ('NecroSpecPowerTransfer45', 'Necro Deathsight', 9128, 45);
INSERT INTO linexspell () VALUES ('NecroSpecArmorDebuff5', 'Necro Deathsight', 9131, 5);
INSERT INTO linexspell () VALUES ('NecroSpecArmorDebuff9', 'Necro Deathsight', 9132, 9);
INSERT INTO linexspell () VALUES ('NecroSpecArmorDebuff14', 'Necro Deathsight', 9133, 14);
INSERT INTO linexspell () VALUES ('NecroSpecArmorDebuff22', 'Necro Deathsight', 9134, 22);
INSERT INTO linexspell () VALUES ('NecroSpecArmorDebuff30', 'Necro Deathsight', 9135, 30);
INSERT INTO linexspell () VALUES ('NecroSpecArmorDebuff40', 'Necro Deathsight', 9136, 40);
INSERT INTO linexspell () VALUES ('NecroSpecArmorDebuff50', 'Necro Deathsight', 9137, 50);
INSERT INTO linexspell () VALUES ('NecroSpecLifetap2', 'Necro Deathsight', 9141, 2);
INSERT INTO linexspell () VALUES ('NecroSpecLifetap6', 'Necro Deathsight', 9142, 6);
INSERT INTO linexspell () VALUES ('NecroSpecLifetap10', 'Necro Deathsight', 9143, 10);
INSERT INTO linexspell () VALUES ('NecroSpecLifetap16', 'Necro Deathsight', 9144, 16);
INSERT INTO linexspell () VALUES ('NecroSpecLifetap23', 'Necro Deathsight', 9145, 23);
INSERT INTO linexspell () VALUES ('NecroSpecLifetap31', 'Necro Deathsight', 9146, 31);
INSERT INTO linexspell () VALUES ('NecroSpecLifetap39', 'Necro Deathsight', 9147, 39);
INSERT INTO linexspell () VALUES ('NecroSpecLifetap47', 'Necro Deathsight', 9148, 47);
INSERT INTO linexspell () VALUES ('NecroBaseConDebuff1', 'Painworking', 9201, 1);
INSERT INTO linexspell () VALUES ('NecroBaseConDebuff4', 'Painworking', 9202, 4);
INSERT INTO linexspell () VALUES ('NecroBaseConDebuff7', 'Painworking', 9203, 7);
INSERT INTO linexspell () VALUES ('NecroBaseConDebuff11', 'Painworking', 9204, 11);
INSERT INTO linexspell () VALUES ('NecroBaseConDebuff17', 'Painworking', 9205, 17);
INSERT INTO linexspell () VALUES ('NecroBaseConDebuff23', 'Painworking', 9206, 23);
INSERT INTO linexspell () VALUES ('NecroBaseConDebuff29', 'Painworking', 9207, 29);
INSERT INTO linexspell () VALUES ('NecroBaseConDebuff36', 'Painworking', 9208, 36);
INSERT INTO linexspell () VALUES ('NecroBaseConDebuff46', 'Painworking', 9209, 46);
INSERT INTO linexspell () VALUES ('NecroBaseSnare2', 'Painworking', 9211, 2);
INSERT INTO linexspell () VALUES ('NecroBaseSnare5', 'Painworking', 9212, 5);
INSERT INTO linexspell () VALUES ('NecroBaseSnare8', 'Painworking', 9213, 8);
INSERT INTO linexspell () VALUES ('NecroBaseSnare12', 'Painworking', 9214, 12);
INSERT INTO linexspell () VALUES ('NecroBaseSnare16', 'Painworking', 9215, 16);
INSERT INTO linexspell () VALUES ('NecroBaseSnare22', 'Painworking', 9216, 22);
INSERT INTO linexspell () VALUES ('NecroBaseSnare30', 'Painworking', 9217, 30);
INSERT INTO linexspell () VALUES ('NecroBaseSnare39', 'Painworking', 9218, 39);
INSERT INTO linexspell () VALUES ('NecroBaseSnare49', 'Painworking', 9219, 49);
INSERT INTO linexspell () VALUES ('NecroBaseFP3', 'Painworking', 9221, 3);
INSERT INTO linexspell () VALUES ('NecroSpecAoEStrConDebuff2', 'Necro Painworking', 9301, 2);
INSERT INTO linexspell () VALUES ('NecroSpecAoEStrConDebuff6', 'Necro Painworking', 9302, 6);
INSERT INTO linexspell () VALUES ('NecroSpecAoEStrConDebuff11', 'Necro Painworking', 9303, 11);
INSERT INTO linexspell () VALUES ('NecroSpecAoEStrConDebuff18', 'Necro Painworking', 9304, 18);
INSERT INTO linexspell () VALUES ('NecroSpecAoEStrConDebuff25', 'Necro Painworking', 9305, 25);
INSERT INTO linexspell () VALUES ('NecroSpecAoEStrConDebuff33', 'Necro Painworking', 9306, 33);
INSERT INTO linexspell () VALUES ('NecroSpecAoEStrConDebuff43', 'Necro Painworking', 9307, 43);
INSERT INTO linexspell () VALUES ('NecroSpecAoESnare5', 'Necro Painworking', 9311, 5);
INSERT INTO linexspell () VALUES ('NecroSpecAoESnare10', 'Necro Painworking', 9312, 10);
INSERT INTO linexspell () VALUES ('NecroSpecAoESnare15', 'Necro Painworking', 9313, 15);
INSERT INTO linexspell () VALUES ('NecroSpecAoESnare22', 'Necro Painworking', 9314, 22);
INSERT INTO linexspell () VALUES ('NecroSpecAoESnare30', 'Necro Painworking', 9315, 30);
INSERT INTO linexspell () VALUES ('NecroSpecAoESnare39', 'Necro Painworking', 9316, 39);
INSERT INTO linexspell () VALUES ('NecroSpecAoESnare49', 'Necro Painworking', 9317, 49);
INSERT INTO linexspell () VALUES ('NecroSpecAoEDoT1', 'Necro Painworking', 9321, 1);
INSERT INTO linexspell () VALUES ('NecroSpecAoEDoT4', 'Necro Painworking', 9322, 4);
INSERT INTO linexspell () VALUES ('NecroSpecAoEDoT8', 'Necro Painworking', 9323, 8);
INSERT INTO linexspell () VALUES ('NecroSpecAoEDoT12', 'Necro Painworking', 9324, 12);
INSERT INTO linexspell () VALUES ('NecroSpecAoEDoT16', 'Necro Painworking', 9325, 16);
INSERT INTO linexspell () VALUES ('NecroSpecAoEDoT21', 'Necro Painworking', 9326, 21);
INSERT INTO linexspell () VALUES ('NecroSpecAoEDoT27', 'Necro Painworking', 9327, 27);
INSERT INTO linexspell () VALUES ('NecroSpecAoEDoT35', 'Necro Painworking', 9328, 35);
INSERT INTO linexspell () VALUES ('NecroSpecAoEDoT44', 'Necro Painworking', 9329, 44);
INSERT INTO linexspell () VALUES ('NecroSpecStrConBuff9', 'Necro Painworking', 9331, 9);
INSERT INTO linexspell () VALUES ('NecroSpecStrConBuff14', 'Necro Painworking', 9332, 14);
INSERT INTO linexspell () VALUES ('NecroSpecStrConBuff17', 'Necro Painworking', 9333, 17);
INSERT INTO linexspell () VALUES ('NecroSpecStrConBuff24', 'Necro Painworking', 9334, 24);
INSERT INTO linexspell () VALUES ('NecroSpecStrConBuff32', 'Necro Painworking', 9335, 32);
INSERT INTO linexspell () VALUES ('NecroSpecStrConBuff42', 'Necro Painworking', 9336, 42);
INSERT INTO linexspell () VALUES ('NecroSpecDoT3', 'Necro Painworking', 9341, 3);
INSERT INTO linexspell () VALUES ('NecroSpecDoT7', 'Necro Painworking', 9342, 7);
INSERT INTO linexspell () VALUES ('NecroSpecDoT13', 'Necro Painworking', 9343, 13);
INSERT INTO linexspell () VALUES ('NecroSpecDoT19', 'Necro Painworking', 9344, 19);
INSERT INTO linexspell () VALUES ('NecroSpecDoT26', 'Necro Painworking', 9345, 26);
INSERT INTO linexspell () VALUES ('NecroSpecDoT34', 'Necro Painworking', 9346, 34);
INSERT INTO linexspell () VALUES ('NecroSpecDoT41', 'Necro Painworking', 9347, 41);
INSERT INTO linexspell () VALUES ('NecroSpecDoT50', 'Necro Painworking', 9348, 50);
INSERT INTO linexspell () VALUES ('NecroBaseSummonPet1', 'Death Servant', 9401, 1);
INSERT INTO linexspell () VALUES ('NecroBaseSummonPet4', 'Death Servant', 9402, 4);
INSERT INTO linexspell () VALUES ('NecroBaseSummonPet7', 'Death Servant', 9403, 7);
INSERT INTO linexspell () VALUES ('NecroBaseSummonPet12', 'Death Servant', 9404, 12);
INSERT INTO linexspell () VALUES ('NecroBaseSummonPet20', 'Death Servant', 9405, 20);
INSERT INTO linexspell () VALUES ('NecroBaseSummonPet32', 'Death Servant', 9406, 32);
INSERT INTO linexspell () VALUES ('NecroBaseSummonPet45', 'Death Servant', 9407, 45);
INSERT INTO linexspell () VALUES ('NecroBaseHoT2', 'Death Servant', 9411, 2);
INSERT INTO linexspell () VALUES ('NecroBaseHoT5', 'Death Servant', 9412, 5);
INSERT INTO linexspell () VALUES ('NecroBaseHoT10', 'Death Servant', 9413, 10);
INSERT INTO linexspell () VALUES ('NecroBaseHoT17', 'Death Servant', 9414, 17);
INSERT INTO linexspell () VALUES ('NecroBaseHoT25', 'Death Servant', 9415, 25);
INSERT INTO linexspell () VALUES ('NecroBaseHoT33', 'Death Servant', 9416, 33);
INSERT INTO linexspell () VALUES ('NecroBaseHoT40', 'Death Servant', 9417, 40);
INSERT INTO linexspell () VALUES ('NecroBaseHoT50', 'Death Servant', 9418, 50);
INSERT INTO linexspell () VALUES ('NecroBaseStrBuff3', 'Death Servant', 9421, 3);
INSERT INTO linexspell () VALUES ('NecroBaseStrBuff6', 'Death Servant', 9422, 6);
INSERT INTO linexspell () VALUES ('NecroBaseStrBuff11', 'Death Servant', 9423, 11);
INSERT INTO linexspell () VALUES ('NecroBaseStrBuff16', 'Death Servant', 9424, 16);
INSERT INTO linexspell () VALUES ('NecroBaseStrBuff23', 'Death Servant', 9425, 23);
INSERT INTO linexspell () VALUES ('NecroBaseStrBuff31', 'Death Servant', 9426, 31);
INSERT INTO linexspell () VALUES ('NecroBaseStrBuff41', 'Death Servant', 9427, 41);
INSERT INTO linexspell () VALUES ('NecroSpecPBAoE6', 'Death Servant Spec', 9501, 6);
INSERT INTO linexspell () VALUES ('NecroSpecPBAoE10', 'Death Servant Spec', 9502, 10);
INSERT INTO linexspell () VALUES ('NecroSpecPBAoE13', 'Death Servant Spec', 9503, 13);
INSERT INTO linexspell () VALUES ('NecroSpecPBAoE17', 'Death Servant Spec', 9504, 17);
INSERT INTO linexspell () VALUES ('NecroSpecPBAoE23', 'Death Servant Spec', 9505, 23);
INSERT INTO linexspell () VALUES ('NecroSpecPBAoE30', 'Death Servant Spec', 9506, 30);
INSERT INTO linexspell () VALUES ('NecroSpecPBAoE37', 'Death Servant Spec', 9507, 37);
INSERT INTO linexspell () VALUES ('NecroSpecPBAoE47', 'Death Servant Spec', 9508, 47);
INSERT INTO linexspell () VALUES ('NecroSpecDS2', 'Death Servant Spec', 9511, 2);
INSERT INTO linexspell () VALUES ('NecroSpecDS5', 'Death Servant Spec', 9512, 5);
INSERT INTO linexspell () VALUES ('NecroSpecDS7', 'Death Servant Spec', 9513, 7);
INSERT INTO linexspell () VALUES ('NecroSpecDS12', 'Death Servant Spec', 9514, 12);
INSERT INTO linexspell () VALUES ('NecroSpecDS18', 'Death Servant Spec', 9515, 18);
INSERT INTO linexspell () VALUES ('NecroSpecDS24', 'Death Servant Spec', 9516, 24);
INSERT INTO linexspell () VALUES ('NecroSpecDS32', 'Death Servant Spec', 9517, 32);
INSERT INTO linexspell () VALUES ('NecroSpecDS44', 'Death Servant Spec', 9518, 44);
INSERT INTO linexspell () VALUES ('NecroSpecDexQuiBuff4', 'Death Servant Spec', 9521, 4);
INSERT INTO linexspell () VALUES ('NecroSpecDexQuiBuff9', 'Death Servant Spec', 9522, 9);
INSERT INTO linexspell () VALUES ('NecroSpecDexQuiBuff15', 'Death Servant Spec', 9523, 15);
INSERT INTO linexspell () VALUES ('NecroSpecDexQuiBuff21', 'Death Servant Spec', 9524, 21);
INSERT INTO linexspell () VALUES ('NecroSpecDexQuiBuff29', 'Death Servant Spec', 9525, 29);
INSERT INTO linexspell () VALUES ('NecroSpecDexQuiBuff36', 'Death Servant Spec', 9526, 36);
INSERT INTO linexspell () VALUES ('NecroSpecDexQuiBuff48', 'Death Servant Spec', 9527, 48);
INSERT INTO linexspell () VALUES ('NecroSpecDD1', 'Death Servant Spec', 9531, 1);
INSERT INTO linexspell () VALUES ('NecroSpecDD3', 'Death Servant Spec', 9532, 3);
INSERT INTO linexspell () VALUES ('NecroSpecDD8', 'Death Servant Spec', 9533, 8);
INSERT INTO linexspell () VALUES ('NecroSpecDD14', 'Death Servant Spec', 9534, 14);
INSERT INTO linexspell () VALUES ('NecroSpecDD19', 'Death Servant Spec', 9535, 19);
INSERT INTO linexspell () VALUES ('NecroSpecDD25', 'Death Servant Spec', 9536, 25);
INSERT INTO linexspell () VALUES ('NecroSpecDD31', 'Death Servant Spec', 9537, 31);
INSERT INTO linexspell () VALUES ('NecroSpecDD38', 'Death Servant Spec', 9538, 38);
INSERT INTO linexspell () VALUES ('NecroSpecDD45', 'Death Servant Spec', 9539, 45);

PostPosted: Thu Jul 19, 2007 1:02 pm
by Overdriven
Locking this, and keeping it here. I didn't actually know Etaew/Tired deleted the whole LineXSpell for this *Glare*

Cheers for the update, I'll add it in A.S.A.P.

PostPosted: Thu Jul 19, 2007 1:34 pm
by Etaew
OD you removed them remember, to disable them so necros couldnt cast spells.

PostPosted: Thu Jul 19, 2007 2:08 pm
by Overdriven
That wasn't me. That was Tired. I wouldn't of done it that way.

I'd of just stuck a `-` in the Line name (at the end) so the spells wouldn't off been registered to the spell line.

PostPosted: Tue Jul 31, 2007 8:03 pm
by Tired
Yea, that was me awhile ago. I actually can't remember how long ago that was. But I did know that we had to get rid of the Necro spells within a few seconds. So that's why I did it the way that I did back then. Completely forgot about them too.

PostPosted: Tue Jul 31, 2007 8:26 pm
by Overdriven
Just need to know when to reimport these. :)

WTB NEW FIELD In LineXSpell:

"IsEnabled" :D