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;