[alex2001]

#define DEBUG
#define PLUGIN_AUTHOR "Alex"
#define PLUGIN_VERSION "1.00"

#include <sourcemod>
#include <sdktools>
#include <cstrike>
//#include <sdkhooks>

#pragma semicolon 1
#pragma newdecls required

public Plugin myinfo =  {
	name = "BattlePass", 
	author = PLUGIN_AUTHOR, 
	description = "BattlePass plugin :)", 
	version = PLUGIN_VERSION, 
};

public void OnPluginStart() {
	char error[255];
	Database db = SQL_Connect("battlepass", true, error, sizeof(error));
	
	if (db == null)
	{
		PrintToServer("Could not connect: %s", error);
	}
	else
	{
		PrintToServer("Conectare reusita");
	}
	RegAdminCmd("sm_give_bp", CmdBp, ADMFLAG_ROOT, "");
}

public Action CmdBp(int client, int args) {
	if (args < 1) {
		ReplyToCommand(client, "Foloseste : sm_give_bp <nume>");
		return Plugin_Handled;
	}
	
	char arg1[32];
	GetCmdArg(1, arg1, 32);
	
	char name[32];
	GetClientName(client, name, 32);
	
	char query[200];
	PrintToChat(client, "HH");
	Format(query, 200, "INSERT INTO 'battlepass' (Test) VALUES ('%i')", sizeof(arg1));
	
	return Plugin_Handled;
}

but if in game use sm_give_bp name.. in tabel dosent appear sizeof(arg1)

[8guawong]

Originally Posted by alex2001 #define DEBUG #define PLUGIN_AUTHOR "Alex" #define PLUGIN_VERSION "1.00" #include <sourcemod> #include <sdktools> #include <cstrike> //#include <sdkhooks> #pragma semicolon 1 #pragma newdecls required public Plugin myinfo = { name = "BattlePass", author = PLUGIN_AUTHOR, description = "BattlePass plugin :)", version = PLUGIN_VERSION, }; public void OnPluginStart() { char error[255]; Database db = SQL_Connect("battlepass", true, error, sizeof(error)); if (db == null) { PrintToServer("Could not connect: %s", error); } else { PrintToServer("Conectare reusita"); } RegAdminCmd("sm_give_bp", CmdBp, ADMFLAG_ROOT, ""); } public Action CmdBp(int client, int args) { if (args < 1) { ReplyToCommand(client, "Foloseste : sm_give_bp <nume>"); return Plugin_Handled; } char arg1[32]; GetCmdArg(1, arg1, 32); char name[32]; GetClientName(client, name, 32); char query[200]; PrintToChat(client, "HH"); Format(query, 200, "INSERT INTO 'battlepass' (Test) VALUES ('%i')", sizeof(arg1)); return Plugin_Handled; } but if in game use sm_give_bp name.. in tabel dosent appear sizeof(arg1)

u only format the query

i don't even see where you try to insert into mysql

read https://wiki.alliedmods.net/SQL_(SourceMod_Scripting)

[alex2001]

can you help me.. i already write.but where is "INSERT" in your link..
i am begginer..

this is ok?
char query[200];
Format(query, 200, "INSERT INTO 'bptabel' (Test) VALUES ('%i')", sizeof(arg1));

SQL_LockDatabase(db);
DBResultSet queryH = SQL_Query(db, query);
if (queryH != null) {
PrintToChat(client, "SUCCES");
}
SQL_UnlockDatabase(db);
delete(queryH);

[8guawong]

Originally Posted by alex2001 can you help me.. i already write.but where is "INSERT" in your link.. i am begginer.. this is ok? char query[200]; Format(query, 200, "INSERT INTO 'bptabel' (Test) VALUES ('%i')", sizeof(arg1)); SQL_LockDatabase(db); DBResultSet queryH = SQL_Query(db, query); if (queryH != null) { PrintToChat(client, "SUCCES"); } SQL_UnlockDatabase(db); delete(queryH);

yes but use threading https://wiki.alliedmods.net/SQL_(Sou...ing)#Threading

[alex2001]

no.. dont unterstand...can you give me 1 example

[alex2001]

public Action CmdBp(int client, int args) { char arg1[32]; bool target; if (args < 1) { ReplyToCommand(client, "Foloseste : sm_give_bp <nume>"); return Plugin_Handled; } GetCmdArg(1, arg1, sizeof(arg1)); target = FindTarget(client, arg1); PrintToChat(client, "Nume %i", target); if (target == -1) { ReplyToCommand(client, "Jucatorul nu exista"); return Plugin_Handled; } else ReplyToCommand(client, "Jucatorul exista"); char query[200]; Format(query, 200, "INSERT INTO bptabel (Test,nume) VALUES ('%i','%s')", 1, arg1); DBResultSet queryH = SQL_Query(DB, query); if (queryH != INVALID_HANDLE) { ReplyToCommand(client, "succes"); } else ReplyToCommand(client, "FAIL"); return Plugin_Handled; }

if target==-1 .. dosent replay nothing..just command dosent exit

] sm_give_bp alex32
Unknown command: sm_give_bp