Copying data up in single SQL statement
Look for

SELECT * 
FROM ( SELECT events.*, 
              CASE WHEN in_event 
                   THEN @tmp := level
                   ELSE @tmp
              END delta
       FROM events, 
            (select @tmp := 0) var -- or another value for "unknown"
       ORDER BY date ASC
     ) tmp
ORDER BY date DESC;