mirror of
https://github.com/Relintai/TC-Solo.git
synced 2024-11-17 20:37:31 +01:00
Relintai
3ae797661e
-Already done: -Levelling to 61. -Shaman gear 16-61. -Mage gear to some degree, Some lock, druid items. -Hunter gear up to ZG. -Hopefully all MC spells are disabled in the 1-60 range. -Added hacks to non working bosses. -Vendors are spawned in, in instances. -Basic gear vendor. -Fix for the allclass patch.
320 lines
11 KiB
SQL
320 lines
11 KiB
SQL
|
|
DELETE FROM item_template WHERE entry = 3493;
|
|
INSERT INTO item_template VALUES(3493, -- entry
|
|
2, 2, -1, "hunter lvl16 Bow", -- class, subclass, SoundOverrideSubclass, name
|
|
20664, 3, -- displayid, quality
|
|
0, 0, -- flags, flagsextra
|
|
1, 100, 100, -- buycount buyprice, sellprice
|
|
15, -- inventoryType
|
|
4, -1, -- allowableclass, allowablerace
|
|
20, -- itemlevel
|
|
14, 0, 0, 0, -- reqlevel, reqskill, reqskillrank, reqspell
|
|
0, 0, 0, 0, -- reqhonorrank, reqcityrank, reqrepfaction, reqreprank
|
|
0, 1, 0, -- maxcount stackable, containerslots
|
|
8, -- statscount
|
|
5, 100, -- stat1
|
|
7, 150, -- stat2
|
|
3, 100, -- stat3
|
|
31, 30, -- stat4
|
|
32, 50, -- stat5
|
|
36, 20, -- stat6
|
|
39, 500, -- stat7
|
|
43, 50, -- stat8
|
|
44, 100, -- stat9
|
|
46, 40, -- stat10
|
|
0, 0, -- scalingstatdistribution, scalingstatvalue
|
|
400, 500, 0, -- dmgMin1, DmgMax1, DmgType1
|
|
0, 0, 0, -- dmgMin2, DmgMax2, DmgType2
|
|
1000, -- armor
|
|
0, 0, 0, 0, 0, 0, -- res holy, fire, nature, frost, shadowm arcane
|
|
2600, -- delay
|
|
2, 100, -- ammoType, RangedModRange
|
|
0, 0, 0, 0, -1, 0, -1, -- 1 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 2 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 3 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 4 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 5 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
1, -- bonding
|
|
"Don\'t worry, it only seems to be messed up!", -- description
|
|
0, 0, 0, -- pagetext, languageid, pagematerial
|
|
0, 0, 2, -- startquest, lockid, material
|
|
0, -- sheath
|
|
0, 0, -- randomproperty, randomsuffix
|
|
0, -- block
|
|
0, -- itemset
|
|
80, -- maxdurability
|
|
0, 0, -- area, map
|
|
0, -- bagfamily
|
|
0, -- totemcategory
|
|
0, 0, -- 1 socketcolor, socketcontent
|
|
0, 0, -- 2 socketcolor, socketcontent
|
|
0, 0, -- 3 socketcolor, socketcontent
|
|
0, 0, -- socketbonus, gemproperties
|
|
25, -- reqdisenchantskill
|
|
0, -- armordamagemodifier
|
|
0, -- duration
|
|
0, -- itemlimitcategory
|
|
0, -- holidayId
|
|
"", -- scriptname
|
|
41, -- disenchantid
|
|
0, -- foodtype
|
|
0, 0, -- min, maxmoneyloot
|
|
0, -- flagscustom
|
|
0 -- verifiedbuild
|
|
);
|
|
|
|
DELETE FROM item_template WHERE entry = 2825;
|
|
INSERT INTO item_template VALUES(2825, -- entry
|
|
2, 2, -1, "hunter lvl32 Bow", -- class, subclass, SoundOverrideSubclass, name
|
|
20552, 4, -- displayid, quality
|
|
0, 0, -- flags, flagsextra
|
|
1, 100, 100, -- buycount buyprice, sellprice
|
|
15, -- inventoryType
|
|
4, -1, -- allowableclass, allowablerace
|
|
40, -- itemlevel
|
|
32, 0, 0, 0, -- reqlevel, reqskill, reqskillrank, reqspell
|
|
0, 0, 0, 0, -- reqhonorrank, reqcityrank, reqrepfaction, reqreprank
|
|
0, 1, 0, -- maxcount stackable, containerslots
|
|
10, -- statscount
|
|
5, 150, -- stat1
|
|
7, 200, -- stat2
|
|
3, 200, -- stat3
|
|
31, 100, -- stat4
|
|
32, 100, -- stat5
|
|
36, 100, -- stat6
|
|
39, 5000, -- stat7
|
|
43, 100, -- stat8
|
|
44, 200, -- stat9
|
|
45, 300, -- stat10
|
|
0, 0, -- scalingstatdistribution, scalingstatvalue
|
|
1, 2, 0, -- dmgMin1, DmgMax1, DmgType1
|
|
0, 0, 0, -- dmgMin2, DmgMax2, DmgType2
|
|
2000, -- armor
|
|
0, 0, 0, 0, 0, 0, -- res holy, fire, nature, frost, shadowm arcane
|
|
2800, -- delay
|
|
2, 100, -- ammoType, RangedModRange
|
|
0, 0, 0, 0, -1, 0, -1, -- 1 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 2 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 3 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 4 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 5 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
1, -- bonding
|
|
"Don\'t worry, it only seems to be messed up!", -- description
|
|
0, 0, 0, -- pagetext, languageid, pagematerial
|
|
0, 0, 2, -- startquest, lockid, material
|
|
0, -- sheath
|
|
0, 0, -- randomproperty, randomsuffix
|
|
0, -- block
|
|
0, -- itemset
|
|
80, -- maxdurability
|
|
0, 0, -- area, map
|
|
0, -- bagfamily
|
|
0, -- totemcategory
|
|
0, 0, -- 1 socketcolor, socketcontent
|
|
0, 0, -- 2 socketcolor, socketcontent
|
|
0, 0, -- 3 socketcolor, socketcontent
|
|
0, 0, -- socketbonus, gemproperties
|
|
25, -- reqdisenchantskill
|
|
0, -- armordamagemodifier
|
|
0, -- duration
|
|
0, -- itemlimitcategory
|
|
0, -- holidayId
|
|
"", -- scriptname
|
|
41, -- disenchantid
|
|
0, -- foodtype
|
|
0, 0, -- min, maxmoneyloot
|
|
0, -- flagscustom
|
|
0 -- verifiedbuild
|
|
);
|
|
|
|
DELETE FROM item_template WHERE entry = 17069;
|
|
INSERT INTO item_template VALUES(17069, -- entry
|
|
2, 2, -1, "hunter lvl60 5man Bow", -- class, subclass, SoundOverrideSubclass, name
|
|
30927, 4, -- displayid, quality
|
|
0, 0, -- flags, flagsextra
|
|
1, 100, 100, -- buycount buyprice, sellprice
|
|
15, -- inventoryType
|
|
4, -1, -- allowableclass, allowablerace
|
|
40, -- itemlevel
|
|
32, 0, 0, 0, -- reqlevel, reqskill, reqskillrank, reqspell
|
|
0, 0, 0, 0, -- reqhonorrank, reqcityrank, reqrepfaction, reqreprank
|
|
0, 1, 0, -- maxcount stackable, containerslots
|
|
10, -- statscount
|
|
5, 150, -- stat1
|
|
7, 400, -- stat2
|
|
3, 200, -- stat3
|
|
31, 100, -- stat4
|
|
32, 100, -- stat5
|
|
36, 100, -- stat6
|
|
39, 5000, -- stat7
|
|
43, 100, -- stat8
|
|
44, 400, -- stat9
|
|
45, 300, -- stat10
|
|
0, 0, -- scalingstatdistribution, scalingstatvalue
|
|
1, 2, 0, -- dmgMin1, DmgMax1, DmgType1
|
|
0, 0, 0, -- dmgMin2, DmgMax2, DmgType2
|
|
2000, -- armor
|
|
0, 0, 0, 0, 0, 0, -- res holy, fire, nature, frost, shadowm arcane
|
|
2800, -- delay
|
|
2, 100, -- ammoType, RangedModRange
|
|
0, 0, 0, 0, -1, 0, -1, -- 1 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 2 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 3 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 4 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 5 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
1, -- bonding
|
|
"Don\'t worry, it only seems to be messed up!", -- description
|
|
0, 0, 0, -- pagetext, languageid, pagematerial
|
|
0, 0, 2, -- startquest, lockid, material
|
|
0, -- sheath
|
|
0, 0, -- randomproperty, randomsuffix
|
|
0, -- block
|
|
0, -- itemset
|
|
80, -- maxdurability
|
|
0, 0, -- area, map
|
|
0, -- bagfamily
|
|
0, -- totemcategory
|
|
0, 0, -- 1 socketcolor, socketcontent
|
|
0, 0, -- 2 socketcolor, socketcontent
|
|
0, 0, -- 3 socketcolor, socketcontent
|
|
0, 0, -- socketbonus, gemproperties
|
|
25, -- reqdisenchantskill
|
|
0, -- armordamagemodifier
|
|
0, -- duration
|
|
0, -- itemlimitcategory
|
|
0, -- holidayId
|
|
"", -- scriptname
|
|
41, -- disenchantid
|
|
0, -- foodtype
|
|
0, 0, -- min, maxmoneyloot
|
|
0, -- flagscustom
|
|
0 -- verifiedbuild
|
|
);
|
|
|
|
DELETE FROM item_template WHERE entry = 20038;
|
|
INSERT INTO item_template VALUES(20038, -- entry
|
|
2, 2, -1, "hunter lvl60 10man Bow", -- class, subclass, SoundOverrideSubclass, name
|
|
32570, 4, -- displayid, quality
|
|
0, 0, -- flags, flagsextra
|
|
1, 100, 100, -- buycount buyprice, sellprice
|
|
15, -- inventoryType
|
|
4, -1, -- allowableclass, allowablerace
|
|
60, -- itemlevel
|
|
60, 0, 0, 0, -- reqlevel, reqskill, reqskillrank, reqspell
|
|
0, 0, 0, 0, -- reqhonorrank, reqcityrank, reqrepfaction, reqreprank
|
|
0, 1, 0, -- maxcount stackable, containerslots
|
|
10, -- statscount
|
|
5, 150, -- stat1
|
|
7, 650, -- stat2
|
|
3, 300, -- stat3
|
|
31, 120, -- stat4
|
|
32, 150, -- stat5
|
|
36, 150, -- stat6
|
|
39, 6000, -- stat7
|
|
43, 100, -- stat8
|
|
44, 400, -- stat9
|
|
45, 300, -- stat10
|
|
0, 0, -- scalingstatdistribution, scalingstatvalue
|
|
1, 2, 0, -- dmgMin1, DmgMax1, DmgType1
|
|
0, 0, 0, -- dmgMin2, DmgMax2, DmgType2
|
|
2000, -- armor
|
|
0, 0, 0, 0, 0, 0, -- res holy, fire, nature, frost, shadowm arcane
|
|
2800, -- delay
|
|
2, 100, -- ammoType, RangedModRange
|
|
37381, 1, 0, 0, -1, 0, -1, -- 1 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 2 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 3 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 4 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 5 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
1, -- bonding
|
|
"Don\'t worry, it only seems to be messed up!", -- description
|
|
0, 0, 0, -- pagetext, languageid, pagematerial
|
|
0, 0, 2, -- startquest, lockid, material
|
|
0, -- sheath
|
|
0, 0, -- randomproperty, randomsuffix
|
|
0, -- block
|
|
0, -- itemset
|
|
80, -- maxdurability
|
|
0, 0, -- area, map
|
|
0, -- bagfamily
|
|
0, -- totemcategory
|
|
0, 0, -- 1 socketcolor, socketcontent
|
|
0, 0, -- 2 socketcolor, socketcontent
|
|
0, 0, -- 3 socketcolor, socketcontent
|
|
0, 0, -- socketbonus, gemproperties
|
|
25, -- reqdisenchantskill
|
|
0, -- armordamagemodifier
|
|
0, -- duration
|
|
0, -- itemlimitcategory
|
|
0, -- holidayId
|
|
"", -- scriptname
|
|
41, -- disenchantid
|
|
0, -- foodtype
|
|
0, 0, -- min, maxmoneyloot
|
|
0, -- flagscustom
|
|
0 -- verifiedbuild
|
|
);
|
|
|
|
DELETE FROM item_template WHERE entry = 19558;
|
|
INSERT INTO item_template VALUES(19558, -- entry
|
|
2, 2, -1, "hunter lvl60 ZG Bow", -- class, subclass, SoundOverrideSubclass, name
|
|
32079, 4, -- displayid, quality
|
|
0, 0, -- flags, flagsextra
|
|
1, 100, 100, -- buycount buyprice, sellprice
|
|
15, -- inventoryType
|
|
4, -1, -- allowableclass, allowablerace
|
|
60, -- itemlevel
|
|
60, 0, 0, 0, -- reqlevel, reqskill, reqskillrank, reqspell
|
|
0, 0, 0, 0, -- reqhonorrank, reqcityrank, reqrepfaction, reqreprank
|
|
0, 1, 0, -- maxcount stackable, containerslots
|
|
10, -- statscount
|
|
5, 150, -- stat1
|
|
7, 1200, -- stat2
|
|
3, 300, -- stat3
|
|
31, 120, -- stat4
|
|
32, 150, -- stat5
|
|
36, 150, -- stat6
|
|
39, 6000, -- stat7
|
|
43, 100, -- stat8
|
|
44, 400, -- stat9
|
|
45, 300, -- stat10
|
|
0, 0, -- scalingstatdistribution, scalingstatvalue
|
|
1, 2, 0, -- dmgMin1, DmgMax1, DmgType1
|
|
0, 0, 0, -- dmgMin2, DmgMax2, DmgType2
|
|
2000, -- armor
|
|
0, 0, 0, 0, 0, 0, -- res holy, fire, nature, frost, shadowm arcane
|
|
2800, -- delay
|
|
2, 100, -- ammoType, RangedModRange
|
|
37381, 1, 0, 0, -1, 0, -1, -- 1 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 2 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 3 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 4 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
0, 0, 0, 0, -1, 0, -1, -- 5 spellId, trigger, charges, ppmrate, cooldown, category, categcooldown
|
|
1, -- bonding
|
|
"Don\'t worry, it only seems to be messed up!", -- description
|
|
0, 0, 0, -- pagetext, languageid, pagematerial
|
|
0, 0, 2, -- startquest, lockid, material
|
|
0, -- sheath
|
|
0, 0, -- randomproperty, randomsuffix
|
|
0, -- block
|
|
0, -- itemset
|
|
80, -- maxdurability
|
|
0, 0, -- area, map
|
|
0, -- bagfamily
|
|
0, -- totemcategory
|
|
0, 0, -- 1 socketcolor, socketcontent
|
|
0, 0, -- 2 socketcolor, socketcontent
|
|
0, 0, -- 3 socketcolor, socketcontent
|
|
0, 0, -- socketbonus, gemproperties
|
|
25, -- reqdisenchantskill
|
|
0, -- armordamagemodifier
|
|
0, -- duration
|
|
0, -- itemlimitcategory
|
|
0, -- holidayId
|
|
"", -- scriptname
|
|
41, -- disenchantid
|
|
0, -- foodtype
|
|
0, 0, -- min, maxmoneyloot
|
|
0, -- flagscustom
|
|
0 -- verifiedbuild
|
|
); |