[Doc-Holiday]

Since i have absolutly no understanding of SQL

I would like some help in creating the SQL saving method for my plugin. if you can help the .sma's and the rest of the files are in the zip file attatched

[nikhilgupta345]

Check out SQLVault. It's really useful, and allows you to use vault style of coding (like you are using now), and still use SQL saving.

[Doc-Holiday]

Originally Posted by nikhilgupta345 Check out SQLVault. It's really useful, and allows you to use vault style of coding (like you are using now), and still use SQL saving.

For some reason when i try to connect to my DB it doesnt work.. Says it cant connect. Thats using the vault my exo and bugsy's nsqlx

[Xellath]

Is the connection information correct? On some servers SQL fails the first time it's loaded, try changing the map - that should sort the connection out (if the connection info is correct in the first place).

The nSQLx include by Bugsy should work just fine and fit your needs by the looks of it - but you could check out SQLVault if you would ever happen to need a paired key saving mechanism.

[Doc-Holiday]

Originally Posted by Xellath Is the connection information correct? On some servers SQL fails the first time it's loaded, try changing the map - that should sort the connection out (if the connection info is correct in the first place). The nSQLx include by Bugsy should work just fine and fit your needs by the looks of it - but you could check out SQLVault if you would ever happen to need a paired key saving mechanism.

its correct and added to my remote sql thing. However no matter how many times it restarts or changes the map it wont connect.

Ive used both the ip and web address....

[Sylwester]

test this and post console prints:

PHP Code:

#include <amxmodx>
#include <sqlx>

new Handle:g_sql_tuple

public plugin_init(){
    register_plugin("SQL test", "1.0", "Sylwester")
    register_clcmd("amx_sql_test", "sql_test")
    
    g_sql_tuple = SQL_MakeDbTuple("mysql_server_ip", "username", "password", "database")
    SQL_SetAffinity("mysql")
}

public sql_test(id){
    new data[1]
    data[0] = id
    SQL_ThreadQuery(g_sql_tuple, "qh_sql_test", "SELECT 10;", data, 1)
    client_print(id, print_console, "[SQL test] query sent")
    return PLUGIN_HANDLED
}

public qh_sql_test(FailState,Handle:Query,Error[],Errcode,Data[],DataSize){
    new id = Data[0]
    if(!is_user_connected(id))
        return
    if(FailState){
        client_print(id, print_console, "[SQL test] SQL Error : %s", Error)
        return
    }
    client_print(id, print_console, "[SQL test] SQL query successful, retrieved value: %d", SQL_ReadResult(Query, 0))
} 


[Doc-Holiday]

Originally Posted by Sylwester test this and post console prints:

] amx_sql_test
[SQL test] query sent
[SQL test] SQL query successful, retrieved value:

Seems to connect fine... I guess ill have to look into why battlefield wont connect to it then. Thanks.

Edit:
Well i got it to connect using Exolents SQL vault. I also have it use the default amx_sql settings which will allow for easier setup (less on my part haha)

Edit x2: I would rather just use Sql X.. I think i can do all the part where it connects and what not. Is there a way to loop through my xp data like i do in vault to save each class as its own set of ranks.

i.e. You can be a Special Ops General but if you switch to assault your only a Private.