Hellu OTLand !
TFS 0.3.6 - console error
I dont know whats wrong and I dont have the skills to fix this..
the first error is a:
auto clean house mod from this thread: http://otland.net/threads/remove-house-owner.129065/
and the second 1 is Doggynub's auto db: http://otland.net/threads/advanced-auto-db-clean.107775/
can some1 be a bro and help me with this?
Thanks in advance !! ^^
TFS 0.3.6 - console error
I dont know whats wrong and I dont have the skills to fix this..
the first error is a:
auto clean house mod from this thread: http://otland.net/threads/remove-house-owner.129065/
and the second 1 is Doggynub's auto db: http://otland.net/threads/advanced-auto-db-clean.107775/
Code:
[06/03/2014 12:48:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "owner" ,"id" FROM "houses" WHERE "owner" IN (SELECT "id" FROM "players" WHERE "lastlogin" < UNIX_TIMESTAMP() - 7*24*60*60))
[06/03/2014 12:48:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT players.id AS id , players.name AS name FROM players WHERE players.name NOT IN ('Account Manager','Druid Sample','Knight Sample','Paladin Sample','Sorcerer Sample') AND group_id < 2 AND lastlogin > 0 AND lastlogin < UNIX_TIMESTAMP() - '2592000' ;)
can some1 be a bro and help me with this?
Thanks in advance !! ^^