1.)Rename patch.sql & dump.sql (eg. to origpatch.sql & origdump.sql). (in your server sql folder)
2.)Create a blank File named patch.sql in your server sql folder.
(inside patch.sql you can load your database modifications if you re-/start your server)
3.) Place this line in patch.sql
- Code: Select all
-- Unit weight is lowered
UPDATE `objects_types` SET `UnitWeight`=200 WHERE `ID` in (33,34,35,36,40,42,46,48,49,204,233,241,242,243,244,245,246,254,256,160,261,262,263,264,265,266,267,268,269,270,271,272,282,283,284,324,325,326,327,328,329,330,331,332,333,334,339,348,358,361,362,374,375,376,383,384,385,386,387,388,389,390,391,392,393,394,401,402,403,404,405,406,407,408,409,410,411,412,528,602,603,607,1026,1032,1101);
This lower the weight of many object_types. The 'ID' show an object you can find in table object_types in your database. This affect a weight loss for "all" Players.