if you ever worked with sql
PHP Code:
#include <amxmodx>
#include <amxmisc>
#include <sqlx>
new Handle:g_h_Sql, Handle:g_h_Sql_Connect, bool:g_b_Connected_SQL = false
new g_szResult[33][32]
public plugin_init()
{
register_plugin("get_some_damn_results_and_display_them", "6.6", "worldspawn")
register_clcmd("say result", "get_result")
}
public plugin_cfg()
{
new s_Error[128], i_Error
g_h_Sql = SQL_MakeDbTuple("--host--", "--dbuser--", "--dbpass--", "--dbname--")
g_h_Sql_Connect = SQL_Connect(g_h_Sql, i_Error, s_Error, charsmax(s_Error))
if (g_h_Sql_Connect == Empty_Handle)
{
server_print("Can't connect to MySQL, error: %s", s_Error)
log_amx("Can't connect to MySQL, error: %s", s_Error)
return PLUGIN_HANDLED
}else
g_b_Connected_SQL = true
return PLUGIN_CONTINUE
}
public get_result(id)
{
if (g_b_Connected_SQL)
{
new Handle:query, authid[33], s_Error[128]
get_user_authid(id, authid, charsmax(authid))
query = SQL_PrepareQuery(g_h_Sql_Connect, "SELECT column FROM table WHERE (authid='%s')", authid)
if (!SQL_Execute(query))
{
SQL_QueryError(query, s_Error, charsmax(s_Error))
log_amx("Can't execute MySQL query, error: %s", s_Error)
}else{
new i_Column
i_Column = SQL_FieldNameToNum(query, "column")
while (SQL_MoreResults(query))
{
SQL_ReadResult(query, i_Column, g_szResult[id], charsmax(g_szResult[]))
if (equal(g_szResult[id], ""))
{
}else{
remove_task(id);
set_task(2.0, "showHud", id, _, _, "b")
}
SQL_NextRow(query)
}
SQL_FreeHandle(query)
}
}
}
public showHud(id)
{
set_hudmessage(210, 105, 30, 0.01, 0.76, 0, _, 1.9, 0.1, 0.1, -1)
show_hudmessage(id, "Your result: %s ", g_szResult[id])
}
public plugin_end()
{
SQL_FreeHandle(g_h_Sql_Connect)
SQL_FreeHandle(g_h_Sql)
}
it works for me only now, not for other players
so when player types "result" his some stats will load and i want them to be shown only to him
and that's like for all players