Draenor lvl and faction sql

**Wise** · 16-04-15, 02:42 AM

Originally Posted by Coldblade

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

Credits: Coldblade