Olá. Sou novo por aqui e não sei muito bem como funciona, então gostaria de pedir ajuda para resolver os seguintes erros que estão acontecendo em meu server. 

 

Um deles é que algumas escadas e sewers não estão funcionando. E o outro eu ainda não identifiquei, mas sei que há algo de errado pois aparecem essas informações quando o otserver fica online:

 

 

[9/5/2013 20:31:17] [Error - Spell Interface] 

[9/5/2013 20:31:17] mods/scripts/customspells/polymorph.lua

[9/5/2013 20:31:17] Description: 

[9/5/2013 20:31:17] (LuaInterface::getArea) Object on the stack is not a table

 

[9/5/2013 20:31:17] [Error - Spell Interface] 

[9/5/2013 20:31:17] mods/scripts/customspells/polymorph.lua

[9/5/2013 20:31:17] Description: 

[9/5/2013 20:31:17] (LuaInterface::luaSetCombatArea) Area not found

 

[9/5/2013 20:31:17] [Error - Spell Interface] 

[9/5/2013 20:31:17] mods/scripts/customspells/energy wave.lua

[9/5/2013 20:31:17] Description: 

[9/5/2013 20:31:17] (LuaInterface::getArea) Object on the stack is not a table

 

[9/5/2013 20:31:17] [Error - Spell Interface] 

[9/5/2013 20:31:17] mods/scripts/customspells/energy wave.lua

[9/5/2013 20:31:17] Description: 

[9/5/2013 20:31:17] (LuaInterface::getArea) Object on the stack is not a table

 

[9/5/2013 20:31:17] [Error - Spell Interface] 

 

 

 

[9/5/2013 20:31:58] Duplicate uniqueId 5031

[9/5/2013 20:31:58] Duplicate uniqueId 5040

[9/5/2013 20:31:58] Duplicate uniqueId 5035

[9/5/2013 20:31:58] Duplicate uniqueId 5036

[9/5/2013 20:31:58] Duplicate uniqueId 5032

[9/5/2013 20:32:1] Duplicate uniqueId 10258

[9/5/2013 20:32:8] Duplicate uniqueId 2152

[9/5/2013 20:32:14] Duplicate uniqueId 2345

 

 

[9/5/2013 20:33:48] [Warning - Dixi] NpcSystem:

[9/5/2013 20:33:48] Parameter 'keyword_reply1' missing. Skipping...

[9/5/2013 20:33:58] >>> Parsing time: 30.451 seconds.

[9/5/2013 20:34:56] >>> Synchronization time: 58.039 seconds.

[9/5/2013 20:34:57] >>> Unserialization time: 0.698 seconds.

[9/5/2013 20:34:57] >> Checking world type: Open PvP

[9/5/2013 20:34:57] >> Starting to dominate the world... done.

[9/5/2013 20:34:57] >> Initializing game state and binding services:

[9/5/2013 20:35:5] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name", "guild_wars"."frags" as "frags"  FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("begin" > 0 AND ("begin" + 460) > UNIX_TIMESTAMP()) AND "status" IN (0, 6))

[9/5/2013 20:35:5] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (UPDATE "guild_wars" SET "begin" = UNIX_TIMESTAMP(), "end" = (("end" - "begin") + UNIX_TIMESTAMP()), "status" = 1 WHERE "status" = 6)

[9/5/2013 20:35:5] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name", "g"."id" as "guild_id", "e"."id" as "enemy_id", "guild_wars".*  FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("begin" > 0 AND ("begin" + 460) > UNIX_TIMESTAMP()) AND "status" = 1)

[9/5/2013 20:35:5] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name"  FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("end" > 0 AND ("end" + 460) > UNIX_TIMESTAMP()) AND "status" = 2)

[9/5/2013 20:35:5] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name"  FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("end" > 0 AND ("end" + 460) > UNIX_TIMESTAMP()) AND "status" = 3)

[9/5/2013 20:35:5] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name", "guild_wars"."status" as "status", "g"."id" as "guild_id", "e"."id" as "enemy_id", "guild_wars".*   FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("end" > 0 AND ("end" + 460) > UNIX_TIMESTAMP()) AND "status" IN (7,8))

[9/5/2013 20:35:5] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (UPDATE "guild_wars" SET "end" = UNIX_TIMESTAMP(), "status" = 5 WHERE "status" IN (7,8))

[9/5/2013 20:35:5] >> Global IP address(es): 127.0.0.1

[9/5/2013 20:35:8] >>> Local IP address(es): 192.168.0.101

[9/5/2013 20:35:9] > Bound ports: 7171 7172

[9/5/2013 20:35:9] >> Everything smells good, server is starting up...

 

 

[9/5/2013 20:35:17] sqlite3_prepare_v2(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)

 

[9/5/2013 20:42:39] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name", "guild_wars"."frags" as "frags"  FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("begin" > 0 AND ("begin" + 460) > UNIX_TIMESTAMP()) AND "status" IN (0, 6))

[9/5/2013 20:42:39] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (UPDATE "guild_wars" SET "begin" = UNIX_TIMESTAMP(), "end" = (("end" - "begin") + UNIX_TIMESTAMP()), "status" = 1 WHERE "status" = 6)

[9/5/2013 20:42:39] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name", "g"."id" as "guild_id", "e"."id" as "enemy_id", "guild_wars".*  FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("begin" > 0 AND ("begin" + 460) > UNIX_TIMESTAMP()) AND "status" = 1)

[9/5/2013 20:42:39] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name"  FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("end" > 0 AND ("end" + 460) > UNIX_TIMESTAMP()) AND "status" = 2)

[9/5/2013 20:42:39] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name"  FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("end" > 0 AND ("end" + 460) > UNIX_TIMESTAMP()) AND "status" = 3)

[9/5/2013 20:42:39] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (SELECT "g"."name" as "guild_name", "e"."name" as "enemy_name", "guild_wars"."status" as "status", "g"."id" as "guild_id", "e"."id" as "enemy_id", "guild_wars".*   FROM "guild_wars" LEFT JOIN "guilds" as "g" ON "guild_wars"."guild_id" = "g"."id" LEFT JOIN "guilds" as "e" ON "guild_wars"."enemy_id" = "e"."id" WHERE ("end" > 0 AND ("end" + 460) > UNIX_TIMESTAMP()) AND "status" IN (7,8))

[9/5/2013 20:42:39] sqlite3_prepare_v2(): SQLITE ERROR: no such function: UNIX_TIMESTAMP (UPDATE "guild_wars" SET "end" = UNIX_TIMESTAMP(), "status" = 5 WHERE "status" IN (7,8))

[9/5/2013 20:42:46] sqlite3_prepare_v2(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)

 

 

SE alguém puder me ajudar a resolver algum desses problemas, ficarei muito grato!

 

Se não for um servidor que você colocou várias coisas de sua autoria(server baixado) sugiro que baixe outro.

O que posso fazer é que mostre o spell "energy wave(exevo vis hur)" e o outro para ver exatamente qual o problema, pois o que tô podendo ajudar melhor é o energy wave.

O sistema de guild wars está totalmente bugado, sugiro que pegue esse sistema de outro server e teste.

Já o problema do SQLITE, não sei o que é. Acho que seria melhor trocar o servidor para não ter dor de cabeça de consertar tudo.

Obrigado!