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. ^^
Printable View
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. ^^
Updated, for all the pet family's.
Set the '1.0' to your desired scale.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
[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
You missed a
Infront of all your Creature_Templates. Let me fix it.Code:`
There you go.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
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'
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