Jump to content

Attempt to Index global 'mysql' (a nil value)


Controlled

Recommended Posts

Posted

Get the title error when I run a script with this.

   exports.mysql:query_free("UPDATE `accounts` SET `dm`=`dm`-".. amount*2000 .." WHERE `id`=".. tostring(gameAccountID)  .."") 

Amount and such are all properly defined

Posted
call(getResourceFromName("mysql"), "query_free", "UPDATE `accounts` SET `dm`=`dm`-".. amount*2000 .." WHERE `id`=".. tostring(gameAccountID)  .."")  

Something like that?

EDIT: I used what is above^ got the same error

EDIT 2: Tried

   mysql:query_free("UPDATE `accounts` SET `dm`=`dm`-2000 WHERE `id`=".. tostring(gameAccountID)  .."") 

and got the same error in LUA, but not in the SQL

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...