PDA

View Full Version : [TrinityCore] Draenor lvl and faction sql



Wise
16-04-15, 02:42 AM
In this thread i am going to share with you an sql file(lenght:11915 lines) made by myself.
I mined the necessary data from wowhead. the draenor.rar file contains level and faction correction for draenor mobs&npcs.
I am now working on hp corrections and on spawnpoints sqls.


Sql file contains:


-Ashran:


297
out of 574 npc faction corrections( friendly, unfriendly, hostile,Alliance friendly & Horde hated,Horde friendly & Alliance hated) ,

574
out of 574 mob&npc level corrections


-Frostfire Ridge:


720
out of 1545 npc faction corrections( friendly, unfriendly, hostile,Alliance friendly & Horde hated,Horde friendly & Alliance hated) ,

1545
out of 1545 mob&npc level corrections


-Gorgrond:


552
out of 689 npc faction corrections( friendly, unfriendly, hostile,Alliance friendly & Horde hated,Horde friendly & Alliance hated) ,

689
out of 689 mob&npc level corrections


-Nagrand:


671
out of 857 npc faction corrections( friendly, unfriendly, hostile,Alliance friendly & Horde hated,Horde friendly & Alliance hated) ,

857
out of 857 mob&npc level corrections


-Shadowmoon Valley:


818
out of 1748 npc faction corrections( friendly, unfriendly, hostile,Alliance friendly & Horde hated,Horde friendly & Alliance hated) ,

1546
out of 1748 mob&npc level corrections


-Spires of Arak:


590
out of 718 npc faction corrections( friendly, unfriendly, hostile,Alliance friendly & Horde hated,Horde friendly & Alliance hated) ,

718
out of 718 mob&npc level corrections


-Talador:


724
out of 956 npc faction corrections( friendly, unfriendly, hostile,Alliance friendly & Horde hated,Horde friendly & Alliance hated) ,

956
out of 956 mob&npc level corrections


-Tanaan Jungle:


115
out of 129 npc faction corrections( friendly, unfriendly, hostile,Alliance friendly & Horde hated,Horde friendly & Alliance hated) ,

129
out of 129 mob&npc level corrections



Exact factions:

(the last 414 lines in the file , this needs to be executed for the last time, so thats why it is on the oend of the sql file, so dont change it
)

-Arakkoa Outcasts -
90
out of 90 npc faction corrections
-Council of Exarchs -
1
out of 1 npc faction correction
-Frostwolf Orcs -
262
out of 262 npc faction corrections
-Laughing Skull Orcs -
15
out of 15 npc faction corrections
-Sha'tari Defense -
2
out of 2 npc faction corrections
-Steamwheedle Preservation Society -
44
out of 44 npc faction corrections

i am now working on hp corrections and on spawnpoint sqls.
sorry for my bad english!
only works with trinity core!!
please note that this file does not contain any loot data, or healthpoint correction
.
pictures: https://www.dropbox.com/s/gnhhjkjmhhd75bo/1.jpg?dl=0
https://www.dropbox.com/s/h544sm65x37yxqk/3.jpg?dl=0
https://www.dropbox.com/s/qquwnrqxbfumgn1/2.jpg?dl=0
https://www.dropbox.com/s/dhu5jdbrekc8him/4.jpg?dl=0

download:
https://www.dropbox.com/s/3q28wygn90...aenor.sql?dl=0 (https://www.dropbox.com/s/3q28wygn90fw2ap/draenor.sql?dl=0)



Credits: Coldblade

spureszka
10-08-15, 07:48 AM
Good job ! :)
You have full spawn of Draenor? or coming soon?

turgayacar
03-06-16, 09:41 AM
Lİnk Broken

xfreee
06-06-16, 01:22 PM
yea repair the link

Patate17
12-06-16, 04:43 PM
Reoair link please :(

mnuck
09-07-16, 07:27 AM
dl link is broken please update link for dl
thanks a lot