Lua 3 problems in LUA

[Gothric]

1. I want to send player message when he look at item with uid ,
its function onLook and i tried if thing.uid == xxxx then

but its doesnt work :|

2. I want to get information from database about best player ( person who have the best level)

i tried this

 db.getResult("SELECT `level` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. ";"):getDataInt("level")

but it doesnt work but if it would work it would show Level of player cid :S but i want to show player who have the best level

3. The same as point 2 but i want to get information about concrete proffesion, for example i look on the door and i see the best knight on the server

 

[Doggynub]

1- tihng.itemid == XXXX

2 -

local c =  db.getResult("SELECT `level`,`name` FROM `players` ORDER BY `level` DESC LIMIT 1;")
local level = c:getDataInt('level')
local name = c:getDataString('name')

3 -

local c =  db.getResult("SELECT `level`,`name` FROM `players` WHERE `vocation` = '4' ORDER BY `level` DESC LIMIT 1;")
local level = c:getDataInt('level')
local name = c:getDataString('name')

 

[Gothric]

thank you very much for help me in point 2 and 3 but there is problem in point 2

there is unique id on map :/ and i want to use uid

 

[Doggynub]

thing.uniqueid ,

return true
and regestire creature event in login

 

[Gothric]

Ok thanks but one more question ^.^

look

local c = db.getResult("SELECT `level`,`name` FROM `players` WHERE `vocation` = '4' ORDER BY `level` DESC LIMIT 1;")

if i want to select from 2 vocations so i should change

`vocation` = '4'

to

`vocation` = '4' or '2'

?? yea?

 

[Doggynub]

no, you will repeat

WHERE `vocation` = '4' AND `vocation` = '2'

 

[Gothric]

thing.uniqueid ,

return true
and regestire creature event in login

i did it and it doesnt work :s there is no any msg and no error in console