[TUT] MySQL Configure - UPDATED 2012-04-08

[Ryancit2]

Well..I mean i dont know how people make .db file inside their scripts..I wanna know how to? Is that automatic? If so, how?

[Karuzo]

  
local connect 
  
addEventHandler("onResourceStart", resourceRoot,function() 
    connect  = dbConnect( "sqlite", "file.db", "", "", "share=0" ) 
    if connect then 
        outputDebugString("Connected to the Database!") 
        local tablec = dbQuery ( connect , "CREATE TABLE IF NOT EXISTS tablename (columna,columnb,columnc)" ) 
        if tablec then 
            outputChatBox("Table Created") 
             
        else 
            outputChatBox("Table couldn't be created!") 
        end 
    else 
        outputDebugString("Couldn't connect to the databse!", 1) 
         
    end 
end) 

This will create a .db file called file.db .

And will create a Table if no table exists.

[Ryancit2]

Okay thanks alot

Oh and do i still gotta install those two modules to run DB files?

[Karuzo]

No

[Ryancit2]

Okay thanks..I got it. Thanks to all.

[Runcias]

Server.zip don't work. (download) Please fix it.

[ArromG]

Hi

For connection MySQL with server , think i need 2 files

File is

1.Folder Name << Mysql >> and files << connection.lua , meta.xml , s_mysql.lua >>

2.Folder Name << SQL >> and files << layout.lua , meta.xml mysql.lua >>

in this is really for need 2 files to connection????

[Noki]

Hi

For connection MySQL with server , think i need 2 files

File is

1.Folder Name << Mysql >> and files << connection.lua , meta.xml , s_mysql.lua >>

2.Folder Name << SQL >> and files << layout.lua , meta.xml mysql.lua >>

in this is really for need 2 files to connection????

That's what you need for a custom system that relies on exports.

[~DarkRacer~]

Please update Server.zip link

[Twisted]

Please update Server.zip link

This has been outdated for a long time now. I suggest using MTA's built in db functions now.

[Sergioks]

server.zip not found or never existed. Please update the link

( Sorry for bad english )

[Twisted]

server.zip not found or never existed. Please update the link

( Sorry for bad english )

You may wanna read all the comments. This is outdated, has been since like day 1. Use MTA's db functions instead.