Mangos WOW_BC SQL and script fix'ss - Please review

Setup: Mangos 2.0.10, Mysql 5.0.24, SQLyog 5.24, Mangos Database Handler Rev.254

Hello all, thought i add a few thoughts on this. Don’t know if there is already a thread for this, couldn’t find one...but anyway. I found some errors in Mangos 2.0.10(to my knowledge, this only applies to this version, others can say if the older version had the same problem) and the mangos.conf file. I found most of the errors at the Dwarf and Gnomes starting point of Don mourgh(really haven’t had time to look through all the other factions). I only changed the items I knew where wrong, but there are some mods I left alone till I visually confirmed who they where.
(1) Wolfs come off as PVP when you are playing PVE(aka. Normal) and cant fight them (actually you CAN, but only when you first create your toon), AND they are setup as part of the horde (meaning the PVP part ;o)
(2) All dwarf mountaineers, guards, and mounted guards are setup as horde or enemy (nice, mods are wearing green(friendly), but act like they are wearing gray(non-friendly...aka. Dark Irons)
(3) All boar's are set up as alliance. aka. meaning you cant fight them unless you want to kill your reputation(even though that would be kinda kewl, a dwarf who is a horde). THAT and they will fight off all the wolfs and non-friendly mod in the game.

These are a few of the items that caught my eye off the bat. I will show what i did to repair the problems as list above in order:

(1) I moved all wolfs (except for mounted wolfs for the horde) to the same faction ID as leopards (ID-66), also modified my mangos.conf file. Where it says GameType = #, I changed the value it had by default ( 0 ) to 4.
(2) change the dwarf mountaineers, guards..etc from Faction_id 47 (which is currently setup as enemy(non-PVP and non-horde)) to faction_id 55.
(3) I remember the boars be passive in the game, so i moved all the boars (non-mounted weren’t included for this move) from faction_id 23 to faction_id 7 (same faction_id as the rabbits, good enough)


Here is the syntax that can be done to fix the issues (as always, whenever you do something like this, backup everything) in the same order as above.

(1) In the mangos.conf file
# 0 NORMAL 1 PVP 4 NORMAL 6 RP 8 RPPVP
GameType = 4

in Mysql
UPDATE creature_template SET faction='66' WHERE name ='Timber Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Starving Dire Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Young Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Mangy Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Rabid Dire Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Ragged Timber Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Ragged Young Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Winter Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Starving Winter Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Snow Tracker Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Diseased Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Gray Forest Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Vilebranch Raiding Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Silvermane Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Prairie Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Brave Running Wolf'
UPDATE creature_template SET faction='66' WHERE name ='Razormane Wolf'



(2)
UPDATE creature_template SET faction='55' WHERE name ='Dun Morogh Mountaineer'
UPDATE creature_template SET faction='55' WHERE name ='Mounted Ironforge mountaineer'
UPDATE creature_template SET faction='55' WHERE name ='Expeditionary Mountaineer'
UPDATE creature_template SET faction='55' WHERE name ='Ironforge Guard'
UPDATE creature_template SET faction='55' WHERE name ='Thelsamar Mountaineer'
UPDATE creature_template SET faction='55' WHERE name ='Dun Morogh Mountaineer'

(3)
UPDATE creature_template SET faction='7' WHERE name ='Stonetusk Boar'
UPDATE creature_template SET faction='7' WHERE name ='Young Goretusk'
UPDATE creature_template SET faction='7' WHERE name ='Rockhide Boar'
UPDATE creature_template SET faction='7' WHERE name ='Great Goretusk'
UPDATE creature_template SET faction='7' WHERE name ='Small Crag Boar'
UPDATE creature_template SET faction='7' WHERE name ='Crag Boar'
UPDATE creature_template SET faction='7' WHERE name ='Large Crag Boar'
UPDATE creature_template SET faction='7' WHERE name ='Elder Crag Boar'
UPDATE creature_template SET faction='7' WHERE name ='Mountain Boar'
UPDATE creature_template SET faction='7' WHERE name ='Mangy Mountain Boar'
UPDATE creature_template SET faction='7' WHERE name ='Elder Mountain Boar'
UPDATE creature_template SET faction='7' WHERE name ='Scarred Crag Boar'
UPDATE creature_template SET faction='7' WHERE name ='Thistle Boar'
UPDATE creature_template SET faction='7' WHERE name ='Mottled Boar'
UPDATE creature_template SET faction='7' WHERE name ='Dire Mottled Boar'
UPDATE creature_template SET faction='7' WHERE name ='Elder Mottled Boar'

Also, if you know a better way of doing a update statement, please make changes as needed and please post here.

Also, found a temp fix for the warlock pet fix's (noticed people where saying items about problem with pets). I moved most of the pets to the same faction_id as imp. Since imp is the default pet and it does work, I moved all the pets to the same faction_id. It works on my mangos_2.0.10

UPDATE creature_template SET faction='32' WHERE name ='Voidwalker'
UPDATE creature_template SET faction='32' WHERE name ='Succubus'
UPDATE creature_template SET faction='32' WHERE name ='Felhunter'


Please keep in mind if you do the dungeons quest, you might find a these guys just walking around. I haven’t tested that part yet, but as of right now, all my pets work.