20120428maintenance.sql 435 B

1234567
  1. UPDATE characters SET accesslevel = 8 WHERE accesslevel >= 127;
  2. UPDATE characters SET accesslevel = 7 WHERE accesslevel = 1;
  3. UPDATE characters SET accesslevel = 6 WHERE accesslevel = 2;
  4. UPDATE characters SET accesslevel = 5 WHERE accesslevel = 3;
  5. UPDATE characters SET accesslevel = 3 WHERE accesslevel = 5;
  6. UPDATE characters SET accesslevel = 2 WHERE accesslevel = 6;
  7. UPDATE characters SET accesslevel = 1 WHERE accesslevel = 7;