I haven't really worked with the other methods but I use a lot of MySQL. I only started learning SourcePawn back in January so I'm no master. I recommend watching this guy's videos:
https://www.youtube.com/watch?v=02Kaa_Qv5pk
That's how I learned how to work with MySQL having never used it before.
Here are some basic steps in how things should go:
1. Create a handle for the SQL connection and set it to INVALID_HANDLE, also set a string for SQL connection errors, like this:
PHP Code:
new Handle:g_hDatabase = INVALID_HANDLE;
new String:g_sError;
2. Connect to the database during OnPluginStart(), it'll look something like this:
PHP Code:
public OnPluginStart()
{
g_hDatabase = SQL_Connect("databasenamehere",true,g_sError,sizeof(g_sError));
if (g_hDatabase == INVALID_HANDLE)
{
PrintToServer("Unable to connect to MySQL server: %s",g_sError);
}
}
3. When someone uses the command to open the menu or choose a skin, however it'll work, do this so it won't function if it's not connected:
PHP Code:
public Action:Command_Callback(client,args)
{
if (g_hDatabase == INVALID_HANDLE)
{
return Plugin_Handled;
}
}
4. When someone chooses a skin, you'll need to query the database to see if their steamid is already in the database. If it is, UPDATE that row's skin column with the new skin they chose. If their steamid isn't in the database, INSERT INTO the database their steamid and the skin they chose.
5. When they someone connects to the server, query the database to see if their steamid is in the database and if that row has a skin set. If so, set their skin to whatever's in the field.
It's kind of hard to explain over text and I could write out a plugin example for what you need but I'm too lazy
My advice is to look at the source code of other plugins that use MySQL and learn from there.
Linear Mode
