events
#1

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
Reply
#2

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 );
Reply
#3

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

the house will not sell anymore
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)