[fmmymir]

Hello guys, can someone teach me how can i save a value (like an array) on a database table.
I want something simple which is working. Please don't post this link https://wiki.alliedmods.net/SQL_(SourceMod_Scripting) cause it didn't helped me. Thank you!

[Neuro Toxin]

If it's working why ask for help?

Please provide more specific information including code.

[fmmymir]

#include <sourcemod>
#include <cstrike>

Database db;
new g_Credits[MAXPLAYERS+1];

public Plugin:myinfo =
{
	name = "Very Basic Shop",
	author = "Fmmymir",
	description = "Test",
	version = "1.0",
	url = ""
};

public OnPluginStart()
{
	HookEvent("player_death", playerDeath);
	
	new String:error[256];
	db = SQL_DefConnect(error, sizeof(error))
	
	if(db == INVALID_HANDLE)
	{
		PrintToServer("Could not connect: %s", error)
	}
}

public Action:playerDeath(Handle:event, const String:name[], bool:dontBroadcast) 
{
	new attacker = GetClientOfUserId(GetEventInt(event, "attacker"));
	new client = GetClientOfUserId(GetEventInt(event, "userid"));
	if(attacker != 0 && attacker != client)
	{
		if(GetClientTeam(attacker) == CS_TEAM_T && GetClientTeam(client) == CS_TEAM_CT)
		{
			g_Credits[attacker] += 2;
			PrintToChat(attacker, "You got 2 points!");
		}
	}
}

My small plugin, and im trying to make it save the points on database.

[DarkDeviL]

Originally Posted by fmmymir Hello guys, can someone teach me how can i save a value (like an array) on a database table. I want something simple which is working. Please don't post this link https://wiki.alliedmods.net/SQL_(SourceMod_Scripting) cause it didn't helped me. Thank you!

This is a scripting help forum, not a "spoon-feed" or babysitter forum where you get everything served on a silver platter.

There are already at least 3 admin-related plugins included with SouceMod you can have a look at:

-> admin-sql-threaded.sp
-> admin-sql-prefetch.sp
-> sql-admin-manager.sp

If these as well are of no help to you, the way for you to go would be to hire a developer instead.

[Reiko1231]

For points only you can use clientprefs. It is much simplier and similar to trie. And you don't have to work with databases at all. Everything is done and perfectly fits your need for points storage.