maybe you haven't setup a database or mysql server[18/07/2009 17:40:43] >> Testing SQL connection... MySQL.
[18/07/2009 17:40:43] > MySQL ERROR mysql_real_connect: Unknown database 'forgottenserver'
[18/07/2009 17:40:43] > ERROR: Failed to connect to database, read doc/MYSQL_HELP for information or try SqLite which doesn't require any connection.
How
concert as this error .
someone help me.
plx
Zerak shut the fuck up! stop spamming this thread damn!
Thanks talaturen, you rock!... Elf sux cuz he is delayed 1 week with tfs 0.3.5..
local combat1 = createCombatObject()
setCombatParam(combat1, COMBAT_PARAM_TYPE, COMBAT_ENERGYDAMAGE)
setCombatParam(combat1, COMBAT_PARAM_EFFECT, CONST_ME_EXPLOSIONAREA)
etCombatFormula(combat1, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr1)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
local combat2 = createCombatObject()
setCombatParam(combat2, COMBAT_PARAM_TYPE, COMBAT_HOLYDAMAGE)
setCombatParam(combat2, COMBAT_PARAM_EFFECT, CONST_ME_YELLOW_RINGS)
etCombatFormula(combat2, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr2)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
local combat3 = createCombatObject()
setCombatParam(combat3, COMBAT_PARAM_TYPE, COMBAT_LIFEDRAIN)
setCombatParam(combat3, COMBAT_PARAM_EFFECT, CONST_ME_HITAREA)
etCombatFormula(combat3, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr3)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
local combat4 = createCombatObject()
setCombatParam(combat4, COMBAT_PARAM_TYPE, COMBAT_MANADRAIN)
setCombatParam(combat4, COMBAT_PARAM_EFFECT, CONST_ME_MAGIC_GREEN)
etCombatFormula(combat4, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr4)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
local combat5 = createCombatObject()
setCombatParam(combat5, COMBAT_PARAM_TYPE, COMBAT_DROWNDAMAGE)
setCombatParam(combat5, COMBAT_PARAM_EFFECT, CONST_ME_DRAWBLOOD)
etCombatFormula(combat5, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr5)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
local combat6 = createCombatObject()
setCombatParam(combat6, COMBAT_PARAM_TYPE, COMBAT_PHYSICALDAMAGE)
setCombatParam(combat6, COMBAT_PARAM_EFFECT, CONST_ME_EXPLOSIONAREA)
etCombatFormula(combat6, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr6)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
local combat7 = createCombatObject()
setCombatParam(combat7, COMBAT_PARAM_TYPE, COMBAT_POISONDAMAGE)
setCombatParam(combat7, COMBAT_PARAM_EFFECT, CONST_ME_HITAREA)
etCombatFormula(combat7, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr7)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
local combat8 = createCombatObject()
setCombatParam(combat8, COMBAT_PARAM_TYPE, COMBAT_FIREDAMAGE)
setCombatParam(combat8, COMBAT_PARAM_EFFECT, CONST_ME_POFF)
etCombatFormula(combat8, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr8)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
local combat9 = createCombatObject()
setCombatParam(combat9, COMBAT_PARAM_TYPE, COMBAT_DEATHDAMAGE)
setCombatParam(combat9, COMBAT_PARAM_EFFECT, CONST_ME_MORTAREA)
etCombatFormula(combat9, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr5)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
local combat10 = createCombatObject()
setCombatParam(combat10, COMBAT_PARAM_TYPE, COMBAT_HOLYDAMAGE)
setCombatParam(combat10, COMBAT_PARAM_EFFECT, CONST_ME_HOLYAREA)
etCombatFormula(combat10, COMBAT_FORMULA_LEVELMAGIC, -2.0, -1000, 2.0, 5000)
local area = createCombatArea(arr1)
setCombatArea(combat, area)
function onCastSpell(cid, var)
return doCombat(cid, combat, var)
arr1 = {
{1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1},
{0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0},
{0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0},
{0, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{0, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0},
{0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0},
{0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0},
{1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1},
}
arr2 = {
{0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0},
{0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0},
{0, 0, 0, 1, 1, 0, 1, 1, 0, 0, 0},
{0, 0, 1, 1, 0, 1, 0, 1, 1, 0, 0},
{0, 1, 1, 0, 0, 1, 0, 0, 1, 1, 0},
{1, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1},
{0, 1, 1, 0, 0, 1, 0, 0, 1, 0, 0},
{0, 0, 1, 1, 0, 1, 0, 1, 1, 0, 0},
{0, 0, 0, 1, 1, 0, 1, 1, 0, 0, 0},
{0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0},
{0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0},
}
arr3 = {
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
}
arr4 = {
{1, 0, 1, 0, 0, 1, 0, 0, 1, 0, 1},
{0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0},
{1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1},
{0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0},
{0, 0, 1, 0, 1, 1, 1, 0, 1, 0, 0},
{1, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1},
{0, 0, 1, 0, 1, 1, 1, 0, 1, 0, 0},
{0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0},
{1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1},
{0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0},
{1, 0, 1, 0, 0, 1, 0, 0, 0, 1, 1},
}
arr5 = {
{1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1},
{0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0},
{0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0},
{0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0},
{0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0},
{0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0},
{1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1},
}
arr6 = {
{1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1},
{0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0},
{1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1},
{0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0},
{1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1},
{0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0},
{1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1},
{0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0},
{1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1},
{0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0},
{1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1},
}
arr7 = {
{0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0},
{0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0},
{0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0},
{0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0},
{0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0},
{0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0},
}
arr8 = {
{0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0},
{0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0},
{0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0},
{0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0},
{1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1},
{1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1},
{0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0},
{0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0},
{0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0},
{0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0},
{0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0},
}
[19/07/2009 13:48:20] The Forgotten Server - Version 0.2.4 (Mystic Spirit).
[19/07/2009 13:48:20] A server developed by Talaturen, Kiper, Kornholijo, Jonern, Lithium & Elf.
[19/07/2009 13:48:20] Visit our forum for updates, support and resources: http://otland.net/.
[19/07/2009 13:48:20] >> Loading config
[19/07/2009 13:48:20] >> Loading RSA key
[19/07/2009 13:48:20] >> Testing SQL connection... SqLite.
[19/07/2009 13:48:20] >> Loading bans
[19/07/2009 13:48:20] >> Loading vocations
[19/07/2009 13:48:20] >> Loading commands
[19/07/2009 13:48:20] >> Loading items
[19/07/2009 13:48:21] >> Loading script systems
[19/07/2009 13:48:22] >> Loading monsters
[19/07/2009 13:48:23] >> Loading outfits
[19/07/2009 13:48:23] >> Loading admin protocol config
[19/07/2009 13:48:23] >> Loading experience stages
[19/07/2009 13:48:23] >> Using plaintext passwords
[19/07/2009 13:48:23] >> Checking world type... PVP
[19/07/2009 13:48:23] >> Loading map
[19/07/2009 13:48:23] > Map size: 1000x1000.
[19/07/2009 13:48:24] > Map loading time: 1.438 seconds.
[19/07/2009 13:48:24] Notice: Map load (relational) took : 0.234 s
[19/07/2009 13:48:24] >> Setting gamestate to: GAME_STATE_INIT
[19/07/2009 13:48:26] >> All modules has been loaded, server starting up...
[19/07/2009 13:48:26] >> Forgotten Server Online!
[19/07/2009 13:48:42] SQLITE ERROR sqlite_exec: UPDATE `accounts` SET `premdays` = 65535, `warnings` = 0, `lastday` = 1248022122 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:48:42] > ERROR: Failed to save account: 1!
[19/07/2009 13:48:43] Account Manager has logged in.
[19/07/2009 13:48:43] > Broadcasted message: "New record: 1 players are logged in.".
[19/07/2009 13:48:43] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 1 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:09] Account Manager has logged out.
[19/07/2009 13:49:09] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 0 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:09] SQLITE ERROR sqlite_exec: UPDATE `players` SET `lastlogin` = 1248022123, `lastip` = 16777343 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:09] SQLITE ERROR sqlite_exec: UPDATE `players` SET `lastlogin` = 1248022123, `lastip` = 16777343 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:09] SQLITE ERROR sqlite_exec: UPDATE `players` SET `lastlogin` = 1248022123, `lastip` = 16777343 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:09] Error while saving player: Account Manager
[19/07/2009 13:49:18] SQLITE ERROR sqlite_exec: UPDATE `accounts` SET `premdays` = 0, `warnings` = 0, `lastday` = 1248022158 WHERE `id` = 5653575 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:18] > ERROR: Failed to save account: 5653575!
[19/07/2009 13:49:19] Account Manager has logged in.
[19/07/2009 13:49:19] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 1 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:39] Account Manager has logged out.
[19/07/2009 13:49:39] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 0 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:39] SQLITE ERROR sqlite_exec: UPDATE `players` SET `lastlogin` = 1248022159, `lastip` = 16777343 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:39] SQLITE ERROR sqlite_exec: UPDATE `players` SET `lastlogin` = 1248022159, `lastip` = 16777343 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:39] SQLITE ERROR sqlite_exec: UPDATE `players` SET `lastlogin` = 1248022159, `lastip` = 16777343 WHERE `id` = 1 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:39] Error while saving player: Account Manager
[19/07/2009 13:49:44] SQLITE ERROR sqlite_exec: UPDATE `accounts` SET `premdays` = 0, `warnings` = 0, `lastday` = 1248022184 WHERE `id` = 5653575 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:44] > ERROR: Failed to save account: 5653575!
[19/07/2009 13:49:45] Aramant has logged in.
[19/07/2009 13:49:45] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 1 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:56] Aramant has logged out.
[19/07/2009 13:49:56] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:56] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 1, `group_id` = 1, `vocation` = 0, `health` = 150, `healthmax` = 150, `experience` = 0, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 129, `lookaddons` = 0, `maglevel` = 0, `mana` = 0, `manamax` = 0, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 95, `posy` = 127, `posz` = 7, `cap` = 400, `sex` = 1, `lastlogin` = 1248022185, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1248022196, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:56] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 1, `group_id` = 1, `vocation` = 0, `health` = 150, `healthmax` = 150, `experience` = 0, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 129, `lookaddons` = 0, `maglevel` = 0, `mana` = 0, `manamax` = 0, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 95, `posy` = 127, `posz` = 7, `cap` = 400, `sex` = 1, `lastlogin` = 1248022185, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1248022196, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:56] SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 1, `group_id` = 1, `vocation` = 0, `health` = 150, `healthmax` = 150, `experience` = 0, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 39, `looktype` = 129, `lookaddons` = 0, `maglevel` = 0, `mana` = 0, `manamax` = 0, `manaspent` = 0, `soul` = 100, `town_id` = 1, `posx` = 95, `posy` = 127, `posz` = 7, `cap` = 400, `sex` = 1, `lastlogin` = 1248022185, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 1248022196, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 2 LIMIT 1; near "LIMIT": syntax error
[19/07/2009 13:49:56] Error while saving player: Aramant
Getting lots of erros here (Tibia 8.50 Windows + Windows GUI server):
BTW, what's the most stable Client Version/Server combination? It doesn't matter if it's old version. I just want to play Open Tibia without the debug messages/crash!
Thanks!
I need help with ip config part.
" ip = "127.0.0.1"
loginProtocolPort = 7171
gameProtocolPort = 7172
adminProtocolPort = 7171
statusProtocolPort = 7171"
I have no clue what all these ports are used for!?
Please help