[Request]Pet Scaling Fix

[Noblebeastx]

ya im kinda sick of having to do .mod scale everytiem i zone some where or when i relog,ive tried to make my own fixes a few times but it hasnt worked to good failed attempts but anyways..im trying to find a fix for all pets caz once they are tamed they go from 1.0 scale to 0.5 and there very tiny i wanna make all pets after tame stay 1.0 scale no matter what anyone got a idea of how to fix this or aready has it fixed and wants to share.+rep to if someone can help

Edit:Forgot I Need It For Mangos

[Cocain]

I believe you can edit your Beasts scale in your database. If you want to do a mass update, just do


UPDATE `...` SET `scalecollumn`='...'

[Noblebeastx]

How bout say for a whole 500 playes with a hunter pet mass update at ocne insetad of editing it all at ocne for mangos lol trying to help eclonedwow or whatever out caz i play on tehre blizzliek and its jsut like retial but they got a bug where when u tame a pet it goes to 0.5 scale instead of 1.0 liek supsoe to and then there so small it annoys every hunter and it does me to i was told if i could come up with a fix i could prob get a spot as a dev,but ive tried a few things on my test core is use mangos and they all filed any help will be good

[Cocain]

I've had that problem when I was working for Infinity, a 255 realm. You can just update the collumns for the creatures with the 'pet' restricted collumn.

[Noblebeastx]

how do i posibly do it for over 500 toon's that have a pet and so that everytime someone tames a pet it turns to 1.0scale caz i gotta do this for a whole 500 or more people and i also dont got acess to echolenedwow datbase i was told if i could try to fix it i could be dev tehre li9ek i said plus there on the top like 10 list for servers so i really wanan help them also caz iam hunter like could u possibly make a Sql that i could send to Khell so he can excute into teh database,thats my issue i am not dev yet so i cant look into teh database

[Cocain]

You need database for the SQL to execute. And I don't know the ManGOS DB structure, but I know that it is possible.

[Noblebeastx]

i know that but can u make up a sql Fix for it caz i can send it to Khell and hell put it in

[Cocain]

I believe that the ManGOS Database structure works with the same way as an ArcEmu structure does. Let me download a repack, and if I find it, I'll make you a quick SQL patch.

[Cocain]

Perhaps this :

Try :

UPDATE `creature_template` SET `scale`='1.0' where `family` = 2

Somthing like that should update the scale of ALL cat pets to 1.0, or you can make it less. (Cat - Hunter Pet - World of Warcraft (http://www.wowhead.com/?pet=2))

Do the same, but than search the ID for the other pet sorts. I'm not sure if this will work though, I suck with ManGOS, but hey. I gave it a shot. ^^

[Cocain]

Note : I just tested it & that query worked perfectly. All the 'Tamable beats of the "cat" family' had a scale of 0.5 after executing that. :)


I'm not sure if this will fix your issue though.

[Cocain]

Please TEST this on a alt database first though. I don't want it on my conscience to **** your server up. However the batch works. So. ^^

[Cocain]

Updated, for all the pet family's.


UPDATE `creature_template` SET `scale`='1.0' where `family` = 1
UPDATE `creature_template` SET `scale`='1.0' where `family` = 2
UPDATE `creature_template` SET `scale`='1.0' where `family` = 3
UPDATE `creature_template` SET `scale`='1.0' where `family` = 4
UPDATE `creature_template` SET `scale`='1.0' where `family` = 5
UPDATE `creature_template` SET `scale`='1.0' where `family` = 6
UPDATE `creature_template` SET `scale`='1.0' where `family` = 7
UPDATE `creature_template` SET `scale`='1.0' where `family` = 8
UPDATE `creature_template` SET `scale`='1.0' where `family` = 9

Set the '1.0' to your desired scale.

[Noblebeastx]

[SQL] creature_template` SET `scale`='1.0' where `family` = 2
creature_template` SET `scale`='1.0' where `family` = 7
creature_template` SET `scale`='1.0' where `family` = 45
creature_template` SET `scale`='1.0' where `family` = 39
creature_template` SET `scale`='1.0' where `family` = 25
creature_template` SET `scale`='1.0' where `family` = 37
creature_template` SET `scale`='1.0' where `family` = 11
creature_template` SET `scale`='1.0' where `family` = 46
creature_template` SET `scale`='1.0' where `family` = 12
creature_template` SET `scale`='1.0' where `family` = 44
creature_template` SET `scale`='1.0' where `family` = 1
creature_template` SET `scale`='1.0' where `family` = 24
creature_template` SET `scale`='1.0' where `family` = 26
creature_template` SET `scale`='1.0' where `family` = 38
creature_template` SET `scale`='1.0' where `family` = 30
creature_template` SET `scale`='1.0' where `family` = 34
creature_template` SET `scale`='1.0' where `family` = 31
creature_template` SET `scale`='1.0' where `family` = 35
creature_template` SET `scale`='1.0' where `family` = 41
creature_template` SET `scale`='1.0' where `family` = 3
creature_template` SET `scale`='1.0' where `family` = 33
creature_template` SET `scale`='1.0' where `family` = 27
creature_template` SET `scale`='1.0' where `family` = 4
creature_template` SET `scale`='1.0' where `family` = 5
creature_template` SET `scale`='1.0' where `family` = 8
creature_template` SET `scale`='1.0' where `family` = 6
creature_template` SET `scale`='1.0' where `family` = 9
creature_template` SET `scale`='1.0' where `family` = 43
creature_template` SET `scale`='1.0' where `family` = 20
creature_template` SET `scale`='1.0' where `family` = 21
creature_template` SET `scale`='1.0' where `family` = 32
creature_template` SET `scale`='1.0' where `family` = 42





[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'creature_template` SET `scale`='1.0' where `family` = 2
creature_template` SET ' at line 1
what am i doing wrong tahts what i did and has all classes

[Cocain]

You missed a


`

Infront of all your Creature_Templates. Let me fix it.

[Cocain]

`creature_template` SET `scale`='1.0' where `family` = 2
`creature_template` SET `scale`='1.0' where `family` = 7
`creature_template` SET `scale`='1.0' where `family` = 45
`creature_template` SET `scale`='1.0' where `family` = 39
`creature_template` SET `scale`='1.0' where `family` = 25
`creature_template` SET `scale`='1.0' where `family` = 37
`creature_template` SET `scale`='1.0' where `family` = 11
`creature_template` SET `scale`='1.0' where `family` = 46
`creature_template` SET `scale`='1.0' where `family` = 12
`creature_template` SET `scale`='1.0' where `family` = 44
`creature_template` SET `scale`='1.0' where `family` = 1
`creature_template` SET `scale`='1.0' where `family` = 24
`creature_template` SET `scale`='1.0' where `family` = 26
`creature_template` SET `scale`='1.0' where `family` = 38
`creature_template` SET `scale`='1.0' where `family` = 30
`creature_template` SET `scale`='1.0' where `family` = 34
`creature_template` SET `scale`='1.0' where `family` = 31
`creature_template` SET `scale`='1.0' where `family` = 35
`creature_template` SET `scale`='1.0' where `family` = 41
`creature_template` SET `scale`='1.0' where `family` = 3
`creature_template` SET `scale`='1.0' where `family` = 33
`creature_template` SET `scale`='1.0' where `family` = 27
`creature_template` SET `scale`='1.0' where `family` = 4
`creature_template` SET `scale`='1.0' where `family` = 5
`creature_template` SET `scale`='1.0' where `family` = 8
`creature_template` SET `scale`='1.0' where `family` = 6
`creature_template` SET `scale`='1.0' where `family` = 9
`creature_template` SET `scale`='1.0' where `family` = 43
`creature_template` SET `scale`='1.0' where `family` = 20
`creature_template` SET `scale`='1.0' where `family` = 21
`creature_template` SET `scale`='1.0' where `family` = 32
`creature_template` SET `scale`='1.0' where `family` = 42



There you go.

[Cocain]

Woops, just saw another error, in the Family collumn, you forgot to put your numbers in the last collumn between '

Fixed :


update `creature_template` SET `scale`='1.0' where `family` = '2'
update `creature_template` SET `scale`='1.0' where `family` = '7'
update `creature_template` SET `scale`='1.0' where `family` = '45'
update `creature_template` SET `scale`='1.0' where `family` = '39'
update `creature_template` SET `scale`='1.0' where `family` = '25'
update `creature_template` SET `scale`='1.0' where `family` = '37'
update `creature_template` SET `scale`='1.0' where `family` = '11'
update `creature_template` SET `scale`='1.0' where `family` = '46'
update `creature_template` SET `scale`='1.0' where `family` = '12'
update `creature_template` SET `scale`='1.0' where `family` = '44'
update `creature_template` SET `scale`='1.0' where `family` = '1'
update `creature_template` SET `scale`='1.0' where `family` = '24'
update `creature_template` SET `scale`='1.0' where `family` = '26'
update `creature_template` SET `scale`='1.0' where `family` = '38'
update `creature_template` SET `scale`='1.0' where `family` = '30'
update `creature_template` SET `scale`='1.0' where `family` = '34'
update `creature_template` SET `scale`='1.0' where `family` = '31'
update `creature_template` SET `scale`='1.0' where `family` = '35'
update `creature_template` SET `scale`='1.0' where `family` = '41'
update `creature_template` SET `scale`='1.0' where `family` = '3'
update `creature_template` SET `scale`='1.0' where `family` = '33'
update `creature_template` SET `scale`='1.0' where `family` = '27'
update `creature_template` SET `scale`='1.0' where `family` = '4'
update `creature_template` SET `scale`='1.0' where `family` = '5'
update `creature_template` SET `scale`='1.0' where `family` = '8'
update `creature_template` SET `scale`='1.0' where `family` = '6'
update `creature_template` SET `scale`='1.0' where `family` = '9'
update `creature_template` SET `scale`='1.0' where `family` = '43'
update `creature_template` SET `scale`='1.0' where `family` = '20'
update `creature_template` SET `scale`='1.0' where `family` = '21'
update `creature_template` SET `scale`='1.0' where `family` = '32'
update `creature_template` SET `scale`='1.0' where `family` = '42'

[.SalMAX™]

Thanks Cocain for the Fix. I has been bugging me because I could never figure it Out and you helped me out friend +rep :D