[Request]Pet Scaling Fix

**Cocain** · 29-03-10, 01:29 PM

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. ^^

› See More: [Request]Pet Scaling Fix

**Cocain** · 29-03-10, 02:32 PM

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.

**~~Noblebeastx~~** · 29-03-10, 02:33 PM

[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** · 29-03-10, 02:35 PM

You missed a

Code:

Infront of all your Creature_Templates. Let me fix it.

**Cocain** · 29-03-10, 02:36 PM

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.

**Cocain** · 29-03-10, 02:39 PM

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'