message on login

[Larb]

i need player receive message on login if mail is empty
i tried

local mail = db.storeQuery("SELECT email from accounts where email = '';")
    if mail == true then
       player:sendTextMessage(MESSAGE_EVENT_ADVANCE, "xx")
end

but not have success =x
sry my english

 

[Infernum]

local mail = db.storeQuery("SELECT `email` FROM `accounts` WHERE `id` = ".. player:getAccountId() .. ";")
if mail then
   player:sendTextMessage(MESSAGE_EVENT_ADVANCE, result.getString(mail, "email"))
end

 

[Larb]

local mail = db.storeQuery("SELECT `email` FROM `accounts` WHERE `id` = ".. player:getAccountId() .. ";")
if mail then
   player:sendTextMessage(MESSAGE_EVENT_ADVANCE, result.getString(mail, "email"))
end

Perfect thank you very much