SQL Database question

[AMARANT]

I want to learn more how to use SQL database within MTA. So I tried to create one when my resource starts. I used this:

function createSQLOnStart (res) 
  if res==getThisResource() then 
     executeSQLCreateTable ( "mostwanted", "nickname TEXT, reward NUMBER, desc TEXT" ) 
  end 
end 
addEventHandler ( "onResourceStart", getRootElement(),createSQLOnStart ) 

In the console it says "Creating new DB table mostwanted" so I figured that I did it right. But where that database is located on the server? Where can I see it like I do with 'internal.db'?

[Edikosh998]

on the SQL Browser, load...registry.db at server/mods/deathmatch

[AMARANT]

Thanks man, I didn't know that it's there

[Alpha]

It's better to use the new database functions:

dbConnect 
dbQuery 
dbExec 
dbPoll 
dbFree 

[Maurize]

It's much better to create functions like "getDatabase( element, "row" ) and setDatabase( element, "row", value ) to handle database and have a smart use. if u have any questions or need help simply write a message and i will help you:)

[Edikosh998]

It's better to use the new database functions:

dbConnect 
dbQuery 
dbExec 
dbPoll 
dbFree 

Yeah, MySQL is much better. You can use XAMPP for it (localhost). But be careful, because you must use "dbPoll" to get a table data. Then, if you want to INSERT, DELETE or UPDATE something, you can use "dbExec"

[Alpha]

Also, I advise you to use callbacks, using dbPoll(queryHandle, -1) freezes the server.

[AMARANT]

How can I check that in my table in "nickname" column a row "AMARANT" already exists? I mean blocking possibility to add the same names to it.

[Castillo]

Try this:

    local query = dbQuery ( handler, "SELECT columnName FROM nickname WHERE columnName = ?", "AMARANT" ) 
    local result, numrows, errmsg = dbPoll ( query, -1 ) 
    if ( type ( result ) == "table" and #result == 0 or not result ) then 
        return false 
    else 
        return true 
    end 

[AMARANT]

I did it in a different way with executeSQLQuery but thanks anyway