[cicinho]

Olб warriorfrog, aqui estб o comando funcional:

Код:

CMD:givedp(playerid, params[])
{
	new Nameid[25], valor,string[128],query[160],idplayer;
	if(sscanf(params,"s[25]i", Nameid, valor))
		return SendClientMessage(playerid, -1, "Use: /givedp [player-name] [ammount]");

    idplayer = GetPlayerIdFromName(Nameid);
	if(IsPlayerConnected(idplayer))
	{
		DP[idplayer] += valor;
		format(string, sizeof(string), "O admin %s adicionou %i DONATE POINTS para %s (ONLINE)", PlayerName(playerid), valor, PlayerName(idplayer));
		SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
		SendClientMessage(idplayer, COLOR_LIGHTBLUE, string);
	}else{
		mysql_format(ConnectMYSQL, query, sizeof query, "SELECT `Username`, `DP` FROM accounts WHERE Username = '%e' LIMIT 1", Nameid);
		mysql_tquery(ConnectMYSQL, query, "AddDP", "isi", playerid, Nameid, valor);
	}
	return true;
}

forward AddDP(playerid, Nameid[], valor);
public AddDP(playerid, Nameid[], valor)
{
	new query[200], string[128];
	if(cache_get_row_count(ConnectMYSQL) == 1)
	{
	    dpatual = cache_get_field_content_int(0, "DP");
	    
		mysql_format(ConnectMYSQL, query, sizeof query, "UPDATE accounts SET DP = '%d' WHERE Username = '%s'", dpatual+valor, Nameid);
		mysql_tquery(ConnectMYSQL, query, "", "");

		format(string, sizeof(string), "O admin %s adicionou %i DONATE POINTS para %s (OFFLINE)", PlayerName(playerid), valor, Nameid);
		SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
	}
	else
	    SendClientMessage(playerid, -1, "Nгo hб nenhum player com esse nome.");
	return true;
}