(Resolvido)UPDATE 'table' SET 'old_name'

[Andersen96 10]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''table' SET 'old_name' = 'nick name' WHERE 'old_name' = '' and 'name' = 'nick na' at line 1

[Rusherzin 527]

Se é quando tu loga com o novo char, manda os arquivos onLogin do teu servidor para podermos ver onde está a query com erro.

[Andersen96 10]

É sim, quando eu logo no novo char que aparece a mensagem!
Bom, não tem "OnLogin" Só "Login.lua" segue abaixo:

-------------------------------------------------------------------------------------------------------------------------------

 

  Mostrar conteúdo oculto

local config = {
    loginMessage = getConfigValue('loginMessage')
}

function onLogin(cid)
    local loss = getConfigValue('deathLostPercent')
    if(loss ~= nil) then
        doPlayerSetLossPercent(cid, PLAYERLOSS_EXPERIENCE, loss * 10)
    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 = "Acesse http://www.xtibia.com/forum/user/251027-subwat/"
        else
            str = str .. " www.subwatsoft.com"
            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, "killctf")
    registerCreatureEvent(cid, "ZombieAttack")
    registerCreatureEvent(cid, "Mail")
    registerCreatureEvent(cid, "Recompensa")
    registerCreatureEvent(cid, "GuildMotd")
    registerCreatureEvent(cid, "Idle")
    registerCreatureEvent(cid, "SkullCheck")
    registerCreatureEvent(cid, "ExpVip")
    registerCreatureEvent(cid, "ReportBug")
    registerCreatureEvent(cid, "AdvanceSave")
    registerCreatureEvent(cid, "attackguild")    
    registerCreatureEvent(cid, "ExpVip")
    registerCreatureEvent(cid, "advance")
    registerCreatureEvent(cid, "forever amulet")
    registerCreatureEvent(cid, "task_count")
    registerCreatureEvent(cid, "killbossesbroadcast")
    registerCreatureEvent(cid, "FirstItems")
    registerCreatureEvent(cid, "goldplayer")
    registerCreatureEvent(cid, "promotion")
        registerCreatureEvent(cid, "castAttack")
        registerCreatureEvent(cid, "castHits")
        registerCreatureEvent(cid, "castLogout")
    registerCreatureEvent(cid, "goldplayer2")
    registerCreatureEvent(cid,'PlayerCheck')
    registerCreatureEvent(cid, "FimVip")
    registerCreatureEvent(cid, "EndPremium")
    registerCreatureEvent(cid, "onPrepareDeath")
    registerCreatureEvent(cid, "SkullCheck")
    registerCreatureEvent(cid, "demonOakLogout")
    registerCreatureEvent(cid, "AntiHacker")
    registerCreatureEvent(cid, "demonOakDeath")
    registerCreatureEvent(cid, "demonOakComplete")
    registerCreatureEvent(cid, "ReportBug")
    registerCreatureEvent(cid, "VipReceive")
        registerCreatureEvent(cid, "VocationVip")
    registerCreatureEvent(cid, "PlayerKill")
        registerCreatureEvent(cid, "ZombieAttack")
    registerCreatureEvent(cid, "KillingInTheNameOf")
    registerCreatureEvent(cid, "PythiusDead")
    registerCreatureEvent(cid, "blessedfeather")

    if (InitArenaScript ~= 0) then
    InitArenaScript = 1

        for i = 42300, 42309 do
            setGlobalStorageValue(i, 0)
            setGlobalStorageValue(i+100, 0)
        end
    end

    if getPlayerStorageValue(cid, 42309) < 1 then
        for i = 42300, 42309 do
            setPlayerStorageValue(cid, i, 0)
        end
    end

    if getPlayerStorageValue(cid, 42319) < 1 then
        for i = 42310, 42319 do
            setPlayerStorageValue(cid, i, 0)
        end
    end

    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)
    end
    setPlayerStorageValue(cid, 42350, 0)
    setPlayerStorageValue(cid, 42352, 0)

end 
   if not (getVipTime(cid)) then
   local name = getCreatureName(cid)
   if string.find(tostring(name):lower(),"[VIP]") then
   local newname = string.sub(tostring(name), 7)  -- conta o nome a partir do sétimo caractere. "[VIP] God Wolf" vai virar "God Wolf"
   end      
   db.executeQuery("UPDATE `players` SET `name` = '".. newname .."' WHERE `id` = "..getPlayerGUID(cid)..";")
end
return TRUE
end

 

Editado Novembro 28, 2016 por Andersen96
Trocando Titulo (veja o histórico de edições)

[Rusherzin 527]

Olha no creaturescripts.xml todos os eventos que tem type="login".

[Andersen96 10]

Achei...
Em creaturescripts.xml tem...
 

  Mostrar conteúdo oculto

<event type="login" name="OldName" script="oldname.lua"/>

 Fui até o arquivo.lua "Oldname.lua"...

  Mostrar conteúdo oculto

function onLogin(cid)
if getPlayerStorageValue(cid, 23112) == -1 then
setPlayerStorageValue(cid, 23112, 1)
db.executeQuery("UPDATE `table` SET `old_name` = '"..getCreatureName(cid).."' WHERE `old_name` = '' and `name` = '"..getCreatureName(cid).."';")
end
return true
end