segunda-feira, 18 de abril de 2022

procedimento usado no ficheiro validation.php para apagar o token

SELECT idUsername, TIMESTAMPDIFF(minute, dateReg, now()) AS minutos FROM token WHERE TIMESTAMPDIFF(minute, dateReg, now()) > 60

-- delete_token BEGIN DELETE FROM psw WHERE idUsername = v_id LIMIT 1; DELETE FROM status_username WHERE idUsername = v_id LIMIT 1; DELETE FROM token WHERE idUsername = v_id LIMIT 1; DELETE FROM username WHERE idUsername = v_id LIMIT 1; END

Sem comentários:

Enviar um comentário