events - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: events (/showthread.php?tid=605201)

---

events - StR_MaRy - 15.04.2016

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

---

Re: events - iiNzTicTx - 16.04.2016

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 );

---

Re: events - StR_MaRy - 16.04.2016

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

---

Re: events - StR_MaRy - 16.04.2016

the house will not sell anymore

---