cod mw2

//=== load / save ===
// save player data
public SAVE(id)
{
	if (player_rank[id] == 1 && player_points[id] == 0)
		return

	#if defined _sqlx_included

	SaveData(id)

	#endif

	#if defined _nvault_included

	new szKey[40], szData[32]
	formatex(szKey, charsmax(szKey), "%sMW2", g_szAuthID[id])
	formatex(szData, charsmax(szData), "%d %d %d", player_rank[id], player_points[id], player_class[id])
	nvault_set(g_vault, szKey, szData)

	#endif
}

// retrieve player data
public LOAD(id)
{
	#if defined _sqlx_included

	LoadData(id)

	#endif

	#if defined _nvault_included

	new szKey[40], szData[32]
	formatex(szKey, charsmax(szKey), "%sMW2", g_szAuthID[id])
	if (nvault_get(g_vault, szKey, szData, charsmax(szData)))
	{
		new params[3][32]
		parse(szData, params[0], 31, params[1], 31, params[2], 31)
		player_rank[id] = str_to_num(params[0])
		if (!player_rank[id]) player_rank[id] = 1
		player_points[id] = str_to_num(params[1])
		player_class[id] = str_to_num(params[2])
		user_next_class[id] = player_class[id]
	}
	// else no player data found

	#endif
}
#if defined _sqlx_included
public MySql_Init()
{
	g_SqlTuple = SQL_MakeDbTuple(sqlx_host,sqlx_user,sqlx_pass,sqlx_db)

	new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,charsmax(g_Error))
	if(SqlConnection == Empty_Handle)
	{
		set_fail_state(g_Error)
	}
	new Handle:Queries
	Queries = SQL_PrepareQuery(SqlConnection,"CREATE TABLE IF NOT EXISTS mw2 (steamid varchar(32), rank TEXT(11), points INT(11), class INT(11))")

	if(!SQL_Execute(Queries))
	{
		SQL_QueryError(Queries,g_Error,charsmax(g_Error))
		set_fail_state(g_Error)
	}

	SQL_FreeHandle(Queries)
	SQL_FreeHandle(SqlConnection)
}

public LoadData(id)
{
	new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,charsmax(g_Error))

	if(g_SqlTuple == Empty_Handle)
		set_fail_state(g_Error)

	new szSteamId[32], szTemp[512]
	get_user_authid(id, szSteamId, charsmax(szSteamId))

	new Data[1]
	Data[0] = id

	format(szTemp,charsmax(szTemp),"SELECT * FROM `mw2` WHERE (`mw2`.`steamid` = '%s')", szSteamId)
	SQL_ThreadQuery(g_SqlTuple,"register_client",szTemp,Data,1)
	SQL_FreeHandle(SqlConnection)
}