Lua/mysql select isnt working...

[Basboy7]

Hey all, i am trying to make a script that shows u when u have a new message on the website when u login.

Ive made this:

        local rows = assert(con:execute("SELECT * FROM `site_messages` WHERE `to_player` = " .. getPlayerGUID(cid) .. " AND `readed` = 0;"))

	if (rows:numrows() > 0) then	
	 doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You've got "..rows:numRows().." unreaded messages, please go to our website kybia.com to read them!")
	end

But I got much errors and i think this isnt working for TFS 3.0, who can help me ?

 

[Basboy7]

nobody?

 

[EvulMastah]

TFS 0.3 is using other functions to connect to database...

db.executeQuery(query)

 

[Basboy7]

Yes, but how can i open it in num rows?

 

[Basboy7]

Can some1 help me, how do i open de query result in num rows?

 

[Fare]

local rows = db.executeQuery("SELECT * FROM `site_messages` WHERE `to_player` = " .. getPlayerGUID(cid) .. " AND `readed` = 0;"))

    if (rows:numrows() > 0) then     
     doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You've got "..rows:numRows().." unreaded messages, please go to our website kybia.com to read them!") 
    end

I really don't know maybe this one:

local rows = db.executeQuery("SELECT * FROM `site_messages` WHERE `to_player` = " .. getPlayerGUID(cid) .. " AND `readed` = 0;"))

    if rows > 0 then     
     doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You've got "..rows.." unreaded messages, please go to our website kybia.com to read them!") 
    end

numRows it's standart function?