PHP Code:
#include <amxmodx>
#include <sqlx>
#include <cstrike>
#include <core>
#include <amxmisc>
new Handle:g_SqlTuple
new Handle:SqlConnection
new g_Error[512]
public plugin_init()
{
register_plugin("SMS", "SQL", "ReymonARG")
register_clcmd("say /punkte", "func_get_punkte")
register_clcmd("say /ostavip", "func_get_vip")
set_task(0.2, "plugin_sql")
}
public plugin_sql()
{
new host[64], user[64], pass[64], db[64]
get_cvar_string("amx_sql_host", host, 63)
get_cvar_string("amx_sql_user", user, 63)
get_cvar_string("amx_sql_pass", pass, 63)
get_cvar_string("amx_sql_db", db, 63)
g_SqlTuple = SQL_MakeDbTuple("Fr546e", "frie456a", "sa567a", "friee45632a")
new ErrorCode
SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,511)
if(!SqlConnection)
{
server_print("[Kz-Arg] SQL: Could not connect to SQL database.!")
log_amx("[Kz-Arg] SQL: Could not connect to SQL database.")
return pause("a")
}
set_task(300.0, "func_get_punkte", 54564, _, _, "b")
set_task(300.0, "func_get_vip", 54564, _, _, "b")
return PLUGIN_CONTINUE
}
public func_get_punkte(id)
{
new createinto[1001]
new name[32]
get_user_info(id, "name", name,31)
formatex(createinto, 1000, "SELECT `punktid`, `name` FROM `ur_users` WHERE `name`='%s'",name)
SQL_ThreadQuery(g_SqlTuple, "QueryHandler", createinto)
}
public QueryHandler(iFailState, Handle:hQuery, szError[], iErrnum, cData[], iSize, Float:fQueueTime)
{
if( iFailState != TQUERY_SUCCESS )
{
return log_amx("[Kz-Arg] SQL: SQL Error #%d - %s", iErrnum, szError)
}
if( SQL_MoreResults(hQuery) )
{
new resultado[2][192]
SQL_ReadResult(hQuery, 0, resultado[0], 191)
SQL_ReadResult(hQuery, 1, resultado[1], 191)
client_print(0, print_chat, "Sul on %s punkti!", resultado[0])
}
return PLUGIN_CONTINUE
}
public func_get_vip(id)
{
new createinto[1001]
new name[32]
get_user_info(id, "name", name,31)
formatex(createinto, 1000, "SELECT `punktid`, `name` FROM `ur_users` WHERE `name`='%s'",name)
SQL_ThreadQuery(g_SqlTuple, "QueryVip", createinto)
}
public QueryVip(iFailState, Handle:hQuery, szError[], iErrnum, cData[], iSize, Float:fQueueTime)
{
new resultado[2][192]
new punktid
if( iFailState != TQUERY_SUCCESS )
{
return log_amx("[Kz-Arg] SQL: SQL Error #%d - %s", iErrnum, szError)
}
if( SQL_MoreResults(hQuery) )
{
read_argv(1, arg, 31)
SQL_ReadResult(hQuery, 0, resultado[0], 191)
SQL_ReadResult(hQuery, 1, resultado[1], 191)
punktid = str_to_num(resultado[0])
if (punktid >= 50)
{
client_print(0, print_chat, "Idip: %i", id)
client_print(0, print_chat, "ArgS: %s", id)
client_print(0, print_chat, "ArgD: %d", id)
client_print(0, print_chat, "Punktide arv: %s!", resultado[0])
client_print(0, print_chat, "Sa ostsid 50 punkti eest endale VIPi!", resultado[0])
cs_set_user_vip(1)
Here, I need to define USERID in cs_set_user_vip...but HOW? How can i get current user's id?
}
else
{
client_print(0, print_chat, "Sul ei ole piisavalt punkte (%s)!", resultado[0])
}
}
return PLUGIN_CONTINUE
}