startup

function getStates(str)
    output = ""
    for i=0, (string.len(str)) do
      cc = string.sub(str, i, i)
      if((cc=='[') or (cc=='"') or (cc==',') or (cc == ']')) then
        i = i+1
      else
        output = output .. cc
      end
    end
    return output
  end

function lamp()
  response = http.get("http://35.204.206.85/transmit.php?server=35.187.40.176&user=nosk&password=1234&query=Select+*+FROM+Traverskran.Traverskran")
  data = response.readAll()
  response.close()

  status = (string.sub(getStates(data), 1, 1) == '1')
  redstone.setOutput("top", status)
  sleep(1)
end

function button(port, state)
http.get(("http://35.204.206.85/transmit.php?server=35.187.40.176&user=nosk&password=1234&query=UPDATE%20Traverskran.Traverskran%20SET%20Status=" .. boolean(state) .. "%20WHERE%20Utgang=" .. port))
end

function boolean(stte)
if(stte) then return "1" else return "0"end
end

while true do
    leverState = redstone.getInput("back")
  if leverState ~= prevLeverState then
    button(1, leverState)
  end

  prevLeverState = leverState
  lamp()
end