[platal.git] / upgrade / 1.1.1 / 05_xnet_accounts.sql

-- Disables non-activated xnet accounts.

   UPDATE  accounts              AS a
LEFT JOIN  register_pending_xnet AS r ON (r.uid = a.uid)
      SET  a.state = 'disabled'
    WHERE  a.password IS NULL AND a.type = 'xnet' AND r.hash IS NULL;

-- vim:set syntax=mysql:
Commit	Line	Data
312d41ce SJ	1	-- Disables non-activated xnet accounts.
	2
	3	UPDATE accounts AS a
	4	LEFT JOIN register_pending_xnet AS r ON (r.uid = a.uid)
	5	SET a.state = 'disabled'
	6	WHERE a.password IS NULL AND a.type = 'xnet' AND r.hash IS NULL;
	7
	8	-- vim:set syntax=mysql: