[Ajuda] Erro no server

[IagoNp 50]

Galera to com um erro no meu server.. eu coloquei o site pra testar o server mas toda vez que eu deslogo e logo o char estar no templo dinovo!

e tbm deu esse erro quando iniciei o server :

[14/11/2012 09:47:36] mysql_real_query(): INSERT INTO `server_record` (`record`, `world_id`, `timestamp`) VALUES (1, 0, 1352893656); - MYSQL ERROR: Duplicate entry '1-0-1352893656' for key 'record' (1062)

alguem sabe como ajudar? pf!

[WalaceBz 101]

A Segunda você faiz o seguinte

CREATE TABLE `server_record`

(

`record` INT NOT NULL,

`world_id` TINYINT(4) UNSIGNED NOT NULL DEFAULT 0,

`timestamp` BIGINT NOT NULL,

UNIQUE (`record`, `world_id`, `timestamp`)

) ENGINE = InnoDB;

E Veja se ajudou

1º Poste aqui seu Login.lua

Editado Novembro 14, 2012 por WalaceBz (veja o histórico de edições)

[IagoNp 50]

meu login.lua ta assim:

local config = {

loginMessage = getConfigValue('loginMessage'),

useFragHandler = getBooleanFromString(getConfigValue('useFragHandler'))

}

function onLogin(cid)

local loss = getConfigValue('deathLostPercent')

if(loss ~= nil) then

  doPlayerSetLossPercent(cid, PLAYERLOSS_EXPERIENCE, loss * 10)

  doPlayerSetLossPercent(cid, PLAYERLOSS_SKILL_POINT, loss * 1000)

end

local accountManager = getPlayerAccountManager(cid)

if(accountManager == MANAGER_NONE) then

  local lastLogin, str = getPlayerLastLoginSaved(cid), config.loginMessage

  if(lastLogin > 0) then

   doPlayerSendTextMessage(cid, MESSAGE_STATUS_DEFAULT, str)

   str = "Site: www.starbr.com"

   doPlayerSendTextMessage(cid, MESSAGE_STATUS_DEFAULT, str)

   str = "Sua última visita foi em " .. os.date("%d/%m/%Y às %X", lastLogin) .. "."

  else

   str = str .. " Please choose your outfit."

   doPlayerSendOutfitWindow(cid)

  end

  doPlayerSendTextMessage(cid, MESSAGE_STATUS_DEFAULT, str)

elseif(accountManager == MANAGER_NAMELOCK) then

  doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, it appears that your character has been namelocked, what would you like as your new name?")

elseif(accountManager == MANAGER_ACCOUNT) then

  doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, type 'account' to manage your account and if you want to start over then type 'cancel'.")

else

  doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "Hello, type 'account' to create an account or type 'recover' to recover an account.")

end

if(not isPlayerGhost(cid)) then

  doSendMagicEffect(getCreaturePosition(cid), CONST_ME_TELEPORT)

end

registerCreatureEvent(cid, "Mail")

registerCreatureEvent(cid, "GuildMotd")

registerCreatureEvent(cid, "questLook")

registerCreatureEvent(cid, "Idle")

if(config.useFragHandler) then

  registerCreatureEvent(cid, "SkullCheck")

  registerCreatureEvent(cid, "Reward")

end

registerCreatureEvent(cid, "ReportBug")

registerCreatureEvent(cid, "AdvanceSave")

registerCreatureEvent(cid, "advance")

registerCreatureEvent(cid, "FimVip")

registerCreatureEvent(cid, "SkullCheck")

registerCreatureEvent(cid, "ReportBug")

registerCreatureEvent(cid, VipReceive)

registerCreatureEvent(cid, "PlayerKill")

registerCreatureEvent(cid, "ProtectLevel")

  if (InitArenaScript ~= 0) then

  InitArenaScript = 1

  -- make arena rooms free

    for i = 42300, 42309 do

	  setGlobalStorageValue(i, 0)

	  setGlobalStorageValue(i+100, 0)

end

  end

  -- if he did not make full arena 1 he must start from zero

  if getPlayerStorageValue(cid, 42309) < 1 then

    for i = 42300, 42309 do

	  setPlayerStorageValue(cid, i, 0)

end

  end

  -- if he did not make full arena 2 he must start from zero

  if getPlayerStorageValue(cid, 42319) < 1 then

    for i = 42310, 42319 do

	  setPlayerStorageValue(cid, i, 0)

end

  end

  -- if he did not make full arena 3 he must start from zero

  if getPlayerStorageValue(cid, 42329) < 1 then

    for i = 42320, 42329 do

	  setPlayerStorageValue(cid, i, 0)

end

  end

  if getPlayerStorageValue(cid, 42355) == -1 then

    setPlayerStorageValue(cid, 42355, 0) -- did not arena level

  end

  setPlayerStorageValue(cid, 42350, 0) -- time to kick 0

  setPlayerStorageValue(cid, 42352, 0) -- is not in arena

  local resets = getPlayerStorageValue(cid,1020)

  doPlayerSetSpecialDescription(cid, ". [Resets: "..(resets < 0 and 0 or resets).."]")

  return true

end