Set up vG script

[Nicolasdes]

Hello, I've found vG's Sapphire Script and when I launch server.exe, it said (at the end):

[2012-05-19 12:57:39] ERROR: mysql\connection.lua:13: attempt to call global 'mysql_connect' (a nil value)

[2012-05-19 12:57:55] ERROR: attempt to call a nil value

[2012-05-19 12:57:55] ERROR: call: failed to call 'mysql:query_fetch_assoc' [string "?"]

Some lines of my connection.lua:

-- connection settings 
local hostname = "**HOST**" 
local username = "** USR **" 
local password = "**PASS**" 
local database = "**DB**" 
local port = 3306 
  
-- global things. 
local MySQLConnection = nil 
local resultPool = { } 
local sqllog = false 
local countqueries = 0 
  
-- connectToDatabase - Internal function, to spawn a DB connection 
function connectToDatabase(res) 
    MySQLConnection = mysql_connect(hostname, username, password, database, port) 
     
    if (not MySQLConnection) then 
        if (res == getThisResource()) then 
            cancelEvent(true, "Cannot connect to the database.") 
        end 
        return nil 
    end 
     
    return nil 
end 

SQL works with another gamemodes.

[Smart.]

You need to set up a MySQL server. and then changing the connection details.

[Nicolasdes]

I hide MySQL details and the MySQL connection works on another gamemode.

[Jaysds1]

Here's the code again in LUA Syntax:

-- connection settings 
local hostname = "**HOST**" 
local username = "** USR **" 
local password = "**PASS**" 
local database = "**DB**" 
local port = 3306 
  
-- global things. 
local MySQLConnection = nil 
local resultPool = { } 
local sqllog = false 
local countqueries = 0 
  
-- connectToDatabase - Internal function, to spawn a DB connection 
function connectToDatabase(res) 
    MySQLConnection = mysql_connect(hostname, username, password, database, port) 
    
    if (not MySQLConnection) then 
        if (res == getThisResource()) then 
            cancelEvent(true, "Cannot connect to the database.") 
        end 
        return nil 
    end 
    
    return nil 
end 

Anyways, Did it output to the console: "Cannot connect to the database." ?

[Nicolasdes]

A lot of errors appear, but I think, it didn't

EDIT: When I close the server, it say: "Closing SQLite3", but the ressource is mysql.

[Jaysds1]

SQlite is another built-in MTA Database...

It's used for Accounts... but I doubt vG uses it...

[Nicolasdes]

Ok, I have the same message with the sqlite dll.

[Nicolasdes]

Screenshot:

[Jaysds1]

Did you downloaded the MTA-MySQL?

[Nicolasdes]

Yes.

[Jaysds1]

you forgot to add the .dll

[Nicolasdes]

Thank you, it works, but it has some errors again.

[Jaysds1]

There's no error when you restarted it.

[Nicolasdes]

It search tables in mysql but I haven't queries ?

[Jaysds1]

I think vG already has queries in the table

[Nicolasdes]

I think vG already has queries in the table

Yes, but my database is empty

[Jaysds1]

Did you created your own table?

Probably the script is running through vG's Database

[Nicolasdes]

The database is empty.

I haven't vG's database

[Jaysds1]

oh, What do you want to do then?

[Nicolasdes]

MTA Server hasn't command to create Table (like MTA: Paradise).

[Jaysds1]

oh, you're going to have to use the MTA functions to create a DB, unless you want to use the SQL Browser to create it...

[Nicolasdes]

How use this fonction ?

[Jaysds1]

ok, When you start a script you could do a check with the function to see if the db is created, if it's not created then you could use a function to create it, here's some MTA functions:

dbPoll 
dbConnect 
dbExec 
dbQuery 
dbFree 

[Nicolasdes]

If write your commands, nothing happen.

[Jaysds1]

Those aren't commands, they're suppose to be in a script...

[Nicolasdes]

I write that in connection.lua ? How ?

I haven't Lua knowledge.