This is an old revision of the document!

userek

SELECT * FROM `password` WHERE expiration = '2020-01-01 00:00:00';
UPDATE `password` SET expiration = '2021-01-01 00:00:00' WHERE expiration = '2020-01-01 00:00:00'

node-ok

-- status='reg'; category_id='' -> 11 fact, 9 off, 2 gu --

-- azok a regisztráltak, akik regisztrációja unregdate-kor jár le
SELECT `mac`,`pid`,`category_id`,`regdate`,`unregdate`,`status`,`computername` FROM `node` WHERE `status`='reg' AND category_id>0 AND `unregdate`= '2021-01-01 00:00:00' ;


SELECT `mac`,`pid`,`category_id`,`regdate`,`unregdate`,`status`,`computername` FROM `node` WHERE `unregdate` > '2020-01-01 00:00:00' AND category_id <> 2 AND pid='default' ORDER BY `unregdate`;