01.11.2016, 22:52
i did it like this
but now is not giving me any player who owned a house and he didn't connect for more than 5 minute i have 1 house buyed 2 mins ago and a house buyed 1 weak a go and both are not showing
Код HTML:
mysql_format(handle, gQuery, sizeof(gQuery), "SELECT `AName`,`HouseKey`,`LastLogin` FROM `players` WHERE `HouseKey` > 0 AND `LastLogin` + INTERVAL 5 MINUTE <= NOW() ORDER BY `HouseKey` DESC LIMIT 100");