Lua MySQL calls Avesta 7.6

[Peacy]

Hey folks,

I'm struggling with this for a while and can't manage to find any solutions.. hope one of you can help me.

So, I'm trying to make database calls in Lua with Avesta 7.6. But I can't find any database functions in Avesta

Already tried db.executeQuery(); but db is not defined.



Anybody an idea?



- Peacy

 

[Limos]

Try mysqlQuery.

 

[Peacy]

Try mysqlQuery.

No unfortunately it's not working. Not defined..

 

[Limos]

It works for an other avesta server, did you use mysqlQuery and not db.mysqlQuery?

Edit: I quess it's added there
http://otland.net/threads/mysqlquery-in-otserv.57412/

 

[Peacy]

function onLogin(cid)
    getFirstItems(cid)
   
    mysqlQuery("SELECT id FROM players WHERE id=".. cid .." LIMIT 1")

    return 1

end

Am I doing something wrong here?

 

[Hartass]

Am I doing something wrong here?

Either you have a different function name on that particular function, or else and most likely your server lacks that function.

 

[Peacy]

your server lacks that function.

In what file(s) are these functions normally defined?

 

[Hartass]

Add this to your sources

It works for an other avesta server, did you use mysqlQuery and not db.mysqlQuery?

Edit: I quess it's added there
http://otland.net/threads/mysqlquery-in-otserv.57412/