20090921update.sql 694 B

1234
  1. UPDATE character_subclasses SET class_id=128 WHERE class_id=129 AND charId IN (SELECT charId FROM characters where race=5 AND sex=1); -- female main -> male soulbreaker sub
  2. UPDATE character_subclasses SET class_id=129 WHERE class_id=128 AND charId IN (SELECT charId FROM characters where race=5 AND sex=0); -- male main -> female soulbreaker sub
  3. UPDATE character_subclasses SET class_id=132 WHERE class_id=133 AND charId IN (SELECT charId FROM characters where race=5 AND sex=1); -- female main -> male soulhound sub
  4. UPDATE character_subclasses SET class_id=133 WHERE class_id=132 AND charId IN (SELECT charId FROM characters where race=5 AND sex=0); -- male main -> female soulhound sub