[VIDEN]

Hello! I'm doing an simple rank plugin thats works with my mysql database. I want to print kills deaths and assists (stats from my mysql database) when u write /stats but i cant get it to work.

It had been very nice if someone could help me with it and show me how to do it. (:

[Kailo]

#define TABLENAME MyTable
//Need to know table structure, 1st field (column) have 0 number
#define FIELDNUM_STEAMID 0
#define FIELDNUM_KILLS 1
#define FIELDNUM_ASSISTS 2
#define FIELDNUM_DEATHS 3

//somewhere in code (In cmd handler)
char query[255], steamid[32];
GetClientAuthId(client, AuthId_Steam2, steamid, 32);
Format(query, 255, "SELECT * FROM `%s` WHERE `steamid` LIKE '%s';", TABLENAME, steamid);
g_db.Query(T_ReadPlayerStats, query, client);
//

//handler function
public void T_ReadPlayerStats(Database db, DBResultSet results, const char[] error, any client)
{
  if (results == INVALID_HANDLE)
    LogError("Failed to query (error: %s)", error);
  else {
    results.FetchRow();
    //Getting results
    int kills = results.FetchInt(FIELDNUM_KILLS);
    int assists = results.FetchInt(FIELDNUM_ASSISTS);
    int deaths = results.FetchInt(FIELDNUM_DEATHS);
    PrintToChat(client, "Your stats: %d kills, %d assists, %d deaths.", kills, assists, deaths);
    //
  }
}

[Impact123]

Here are a few suggestions

• Don't use a like query when it's not needed
• Don't select all fields with *, only the ones you need
• Don't try to fetch fields without checking if there were any rows in the result set first
• Use sizeof instead of writing the size of strings / arrays twice
• Don't pass client indexes to asynchronous functions

[VIDEN]

Thx you both! I wil try it! ( :

[VIDEN]

When I use your code Kalio I get one error. "error 17: undifined symbol g_db"

How do I define it? Sry for the newbie question.

[Kailo]

g_db is global variable of Database type. (Prefix g_ mean that this is need to be global)
I do (in my plugins) connection to database in OnPluginStart and delete handle in OnPluginEnd.
Then you connect need to store a connection handle in var. g_db is var where i store this handle.
Example:

Database g_db;

OnPluginStart()
{
  g_db = SQL_Connect("default", false, error, 255);
  if (g_db == INVALID_HANDLE)
    LogError("Could not connect: %s", error);
  g_db.SetCharset("utf8");
}

OnPluginEnd()
{
  delete g_db;
}

[VIDEN]

Thank you for that information! I works nice now! (:

[Impact123]

A few more suggestions

• Plugins can be late-loaded during the game - You should use SQL_TConnect to not block the server while the connection is being established
• Database handles don't need to be closed manually when the plugin is being unloaded
• Instead of using LogError, use SetFailState - In case the handle is invalid, your plugin would log your error message and then an invalid handle error would be thrown because you're still passing it to SetCharSet