[StR_MaRy]

hi i did something an autosellhouse if you didn't connect to the server 1 weak your house will autosell but the funny thing is in the Execute query 1 MINUTE and i put 300 = 5 mins on p.lastlogin will autosell after 1 min not 5 mins and the house will autosell still if i am online

http://imgur.com/0P2dMdb

[iiNzTicTx]

Try the following

UPDATE houses AS h INNER JOIN players AS p ON p.Name = h.Owner
SET h.Owner = 'The State', h.Owned = 0
WHERE NOW() >= DATE_ADD( p.LastLogin, INTERVAL 7 DAY );

[StR_MaRy]

yea but how could i test it faster ? should i put instead of INTERVAL 5 MINUTE ); ??

[StR_MaRy]

the house will not sell anymore