[SQL][Lua] Check information in table sql players

[Armed]

Hi,
i have question, how i can check in TFS [1.2+] what players have in table players.

local accid = getAccountNumberByPlayerName(getPlayerName(cid))
local data = db.storeQuery("SELECT `lang` FROM `players` WHERE `id` ='"..accid.."';")
local lang = data.getDataInt(data, "lang")

This is have error:

 attempt to index local 'data' (a boolean value)

im new in this language and i have problem. Do you have any tutorials or tips how i can check this information?

Sorry for my english.

 

[Bogart]

local lang = data.getDataInt(data, "lang")

should be

local lang = result.getNumber(data, "lang")

 

[Armed]

Okey, thx i dont have error now, but my if dosent work:

if lang == 1 then
    keywordHandler:addKeyword({'money'}, StdModule.say, {npcHandler = npcHandler, text = 'Mozemy wymienic {change} monet dla ciebie. Dostep do konta uzyskasz {bank account}.'})
else
    keywordHandler:addKeyword({'money'}, StdModule.say, {npcHandler = npcHandler, text = 'We can {change} money for you. You can also access your {bank account}.'})
end

Now i have lang = 1 in mysql but NPC says only "else" options.

 

[Bogart]

print(lang) and check the result on the console.

 

[Armed]

Okey i have false for print(lang) but in mysql default value is 1. In lua how check it?

 

[Bogart]

Post whole code

 

[Armed]

I edit npc code lua:

local accid = getAccountNumberByPlayerName(getPlayerName(cid))
local data = db.storeQuery("SELECT `lang` FROM `players` WHERE `id` ='"..accid.."';")
local lang = result.getNumber(data, "lang")
print(lang)
if lang == 1 then
    keywordHandler:addKeyword({'money'}, StdModule.say, {npcHandler = npcHandler, text = 'Mozemy wymienic {change} monet dla ciebie. Dostep do konta uzyskasz {bank account}.'})
else
    keywordHandler:addKeyword({'money'}, StdModule.say, {npcHandler = npcHandler, text = 'We can {change} money for you. You can also access your {bank account}.'})
end
[code]
this is all my code

 

[Bogart]

Your're searching for players with account_id but comparing with player id, your database structure is kinda bad if you assign a different language for each player instead of each account.

 

[Armed]

Okey you have right, i dont see that. How i can check ID player?

 

[Armed]

-bump?

 

[MyAAC]

Its better when you save lang in accounts table.

And you can check it like this:

local player = Player(cid)
local accid = player:getAccountId()
local data = db.storeQuery("SELECT `lang` FROM `accounts` WHERE `id` ='"..accid.."';")
local lang = result.getNumber(data, "lang")

 

[Armed]

Okey but i have error:

 attempt to index local 'player' (a nil value)
stack traceback:

This is new for me that is why i have problem with this ;/

 

[2Rec]

Post the script if you're making changes along whole error.
Did you copy whole code that myAac has posted?

You gotta have a language column in your accounts table.
Run this in your DB:

ALTER TABLE accounts
ADD lang INT(16);

Then you're gotta update a table and copy data from players:

UPDATE accounts
  SET lang = (
    SELECT lang
    FROM players
    WHERE account_id = id);

Then lua will be:

local player = Player(cid)
local accid = player:getAccountId()
local data = db.storeQuery("SELECT `lang` FROM `accounts` WHERE `id` ="..accid)
local lang = result.getNumber(data, "lang")

 

[Armed]

I know how add column to base, i copy MyAac code to file:

local player = Player(cid)
local accid = player:getAccountId()
local data = db.storeQuery("SELECT `lang` FROM `accounts` WHERE `id` ='"..accid.."';")
local lang = result.getNumber(data, "lang")
if lang == 1 then
    keywordHandler:addKeyword({'money'}, StdModule.say, {npcHandler = npcHandler, text = 'Mozemy wymienic {change} monet dla ciebie. Dostep do konta uzyskasz {bank account}.'})
else
    keywordHandler:addKeyword({'money'}, StdModule.say, {npcHandler = npcHandler, text = 'We can {change} money for you. You can also access your {bank account}.'})
end

And i have error:

[LIST=1]
[*] attempt to index local 'player' (a nil value)
[*]stack traceback

[/LIST]

 

[Armed]

Okey solved, you can close thread. Thx for help.

 

[Infernum]

8. Removing Solved Content:
- If you solved your problem, post the solution, do not remove the content in your posts. Instead write the solution you found. This can help other users with the same problem.
- Threads with removed content are useless and are seen as spam.
- If you were able to solve the issue yourself, post the solution and report your own post so a moderator can tag it as the "Best Answer".

Rules for the Support board