- UPDATE characters SET accesslevel = 8 WHERE accesslevel >= 127;
- UPDATE characters SET accesslevel = 7 WHERE accesslevel = 1;
- UPDATE characters SET accesslevel = 6 WHERE accesslevel = 2;
- UPDATE characters SET accesslevel = 5 WHERE accesslevel = 3;
- UPDATE characters SET accesslevel = 3 WHERE accesslevel = 5;
- UPDATE characters SET accesslevel = 2 WHERE accesslevel = 6;
- UPDATE characters SET accesslevel = 1 WHERE accesslevel = 7;
|