[Request]Pet Scaling Fix

Printable View

27-03-10, 09:12 PM
Noblebeastx

[Request]Pet Scaling Fix

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
28-03-10, 04:23 AM
Cocain

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

Code:

UPDATE `...` SET `scalecollumn`='...'
29-03-10, 02:13 AM
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
29-03-10, 08:40 AM
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.
29-03-10, 10:14 AM
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
29-03-10, 11:13 AM
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.
29-03-10, 11:26 AM
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
29-03-10, 12:15 PM
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.
29-03-10, 12:26 PM
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)

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. ^^
29-03-10, 12:27 PM
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.
29-03-10, 12:29 PM
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. ^^
29-03-10, 01:32 PM
Cocain

Updated, for all the pet family's.

Code:

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.
29-03-10, 01:33 PM
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
29-03-10, 01:35 PM
Cocain

You missed a

Code:

`

Infront of all your Creature_Templates. Let me fix it.
29-03-10, 01:36 PM
Cocain

Code:

`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.
29-03-10, 01:39 PM
Cocain

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

Fixed :

Code:

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'
08-04-10, 03:10 AM
.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