Public feed
#531843
begin
declare twoback int(4);
declare lastlevel int(4);
declare currentlevel int(4);
declare leveltofind int(4);
declare diff int(4);
set twoback = 0;
set lastlevel = 200;
set currentlevel = 2;
set leveltofind = 5;
label1: LOOP
if leveltofind = 2 then leave label2; end if;
SET diff = lastlevel - twoback;
SET diff = diff + 400;
SET twoback = lastlevel;
SET lastlevel = lastlevel + diff;
SET currentlevel = currentlevel+1;
if leveltofind = currentlevel then leave label2; end if;
iterate label1;
END LOOP label1;
select lastlevel;
end