[Mysql] save account problem

[elking]

Hello people of OTLand.

I get this problem when I try to login with anycharacter or hit enter only
It might delay , it also happened during play in Ot

I use TFS 0.4 trunk 3884

BUMP

 

[elking]

BUMP

 

[Printer]

The img dont work

 

[elking]

The img dont work

Edited first post see it

 

[Printer]

Does this happen to all accounts?

 

[elking]

Does this happen to all accounts?

Yes , I also can't connect with any account

BUMP

@Printer BUMP

[Edited] this error appear before getting save account error

BUMP

 

[Limos]

ALTER TABLE `accounts` ADD `vipdays` int(11) NOT NULL DEFAULT 0;

If you use SQLite change int(11) to INTEGER.

 

[elking]

ALTER TABLE `accounts` ADD `vipdays` int(11) NOT NULL DEFAULT 0;

If you use SQLite change int(11) to INTEGER.

But I use vipdays to players not to accounts

[Edited] Now I get this

 

[Limos]

Post the function getPlayerVipDays you use.

 

[elking]

Post the function getPlayerVipDays you use.

function getPlayerVipDays(cid)
    local Info = db.getResult("SELECT `vipdays` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
        if Info:getID() ~= LUA_ERROR then
        local days= Info:getDataInt("vipdays")
        Info:free()
        return days
    end
    return LUA_ERROR
end

 

[Limos]

Use same query but then change accounts to players.

 

[elking]

Use same query but then change accounts to players.

Its already exist

 

[Frostie]

Use this one (if u have the table for accounts aswell)

function getPlayerVipDays(cid)
local Info = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
if Info:getID() ~= LUA_ERROR then
local days= Info:getDataInt("vipdays")
Info:free()
return days
end
return LUA_ERROR
end

 

[elking]

Use this one (if u have the table for accounts aswell)

function getPlayerVipDays(cid)
local Info = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
if Info:getID() ~= LUA_ERROR then
local days= Info:getDataInt("vipdays")
Info:free()
return days
end
return LUA_ERROR
end

Ty , But I use it for players

 

[Frostie]

Ty , But I use it for players

u added this querry then?

ALTER TABLE `players` ADD `vipdays` int(11) NOT NULL DEFAULT 0;

 

[elking]

u added this querry then?

ALTER TABLE `players` ADD `vipdays` int(11) NOT NULL DEFAULT 0;

Yes

 

[Cronox]

You edit in 050-Functions

function getPlayerVipDays(cid)
local Info = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
if Info:getID() ~= LUA_ERROR then
local days= Info:getDataInt("vipdays")
Info:free()
return days
end
return LUA_ERROR
end

for

function getPlayerVipDays(cid)
local Info = db.getResult("SELECT `vipdays` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
if Info:getID() ~= LUA_ERROR then
local days= Info:getDataInt("vipdays")
Info:free()
return days
end
return LUA_ERROR
end

and.. can u paste your vipeffect.lua?

 

[elking]

You edit in 050-Functions

function getPlayerVipDays(cid)
local Info = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
if Info:getID() ~= LUA_ERROR then
local days= Info:getDataInt("vipdays")
Info:free()
return days
end
return LUA_ERROR
end

for

function getPlayerVipDays(cid)
local Info = db.getResult("SELECT `vipdays` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
if Info:getID() ~= LUA_ERROR then
local days= Info:getDataInt("vipdays")
Info:free()
return days
end
return LUA_ERROR
end

and.. can u paste your vipeffect.lua?

vipeffect.lua

function onThink(interval, lastExecution)
         for _, name in ipairs(getOnlinePlayers()) do
         local cid = getPlayerByName(name)
if  getPlayerVipDays(cid) >= 1 then
                  doSendMagicEffect(getPlayerPosition(cid), 27)
                  doSendAnimatedText(getPlayerPosition(cid), "VIP!", TEXTCOLOR_RED)
               end
         end
         return true
end

 

[Cronox]

try added function on your script
change vipeffect for

function getPlayerVipDays(cid)
local Info = db.getResult("SELECT `vipdays` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
if Info:getID() ~= LUA_ERROR then
local days= Info:getDataInt("vipdays")
Info:free()
return days
end
return LUA_ERROR
end
       
function onThink(interval, lastExecution)
         for _, name in ipairs(getOnlinePlayers()) do
         local cid = getPlayerByName(name)
if getPlayerVipDays(cid) >= 1 then
                  doSendMagicEffect(getPlayerPosition(cid), 27)
                  doSendAnimatedText(getPlayerPosition(cid), "VIP!", TEXTCOLOR_RED)
               end
         end
         return true
end

 

[elking]

try added function on your script
change vipeffect for

function getPlayerVipDays(cid)
local Info = db.getResult("SELECT `vipdays` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. " LIMIT 1")
if Info:getID() ~= LUA_ERROR then
local days= Info:getDataInt("vipdays")
Info:free()
return days
end
return LUA_ERROR
end
      
function onThink(interval, lastExecution)
         for _, name in ipairs(getOnlinePlayers()) do
         local cid = getPlayerByName(name)
if getPlayerVipDays(cid) >= 1 then
                  doSendMagicEffect(getPlayerPosition(cid), 27)
                  doSendAnimatedText(getPlayerPosition(cid), "VIP!", TEXTCOLOR_RED)
               end
         end
         return true
end

still give same error

Can you give my your skype to contact with you ?