Update

new DB_QUERY[300]; // global Variable

public OnPlayerDeath(playerid, killerid, reason)
{
	PlayerInfo[playerid][pDeaths]++; // Self-death or kileld by someone
    if(PlayerInfo[playerid][pLoggedin])
    {
    	DB_QUERY[0] = '\0';
		mysql_format(sqlConnection, DB_QUERY, sizeof(DB_QUERY), "UPDATE accounts SET Player_Kills = %i WHERE Account_ID = %i LIMIT 1", PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDBID]);
		mysql_tquery(sqlConnection, DB_QUERY);
	}
    if(killerid != INVALID_PLAYER_ID)
    {
    	PlayerInfo[killerid][pKills]++;
	    if(PlayerInfo[killerid][pLoggedin])
	    {
	    	DB_QUERY[0] = '\0';
			mysql_format(sqlConnection, DB_QUERY, sizeof(DB_QUERY), "UPDATE accounts SET Player_Kills = %i WHERE Account_ID = %i LIMIT 1", PlayerInfo[killerid][pKills], PlayerInfo[killerid][pDBID]);
			mysql_tquery(sqlConnection, DB_QUERY);
		}

    }
	return 1;
}


CMD:givecash(playerid, params[])
{
	if(!PlayerInfo[playerid][pLoggedin]) return SendClientMessage(playerid, COLOR_ADMCMD, "* You need to be registered!*");
    new playerb, cash;

    if(sscanf(params, "ri", playerb, cash))
        return SendClientMessage(playerid, COLOR_ADMCMD, "* [CMD] > Usage: /givecash [Player ID/Part of name] [amount] *");

    if(!PlayerInfo[playerb][pLoggedin]) return SendClientMessage(playerid, COLOR_ADMCMD, "* The specified id is not a registered player! *");

    PlayerInfo[playerb][pCash] += cash;
    PlayerInfo[playerid][pCash] -= cash;


	DB_QUERY[0] = '\0';
	mysql_format(sqlConnection, DB_QUERY, sizeof(DB_QUERY), "UPDATE accounts SET Player_Cash = %i WHERE Account_ID = %i LIMIT 1", PlayerInfo[playerb][pCash], PlayerInfo[playerb][pDBID]);
	mysql_tquery(sqlConnection, DB_QUERY);

	DB_QUERY[0] = '\0';
	mysql_format(sqlConnection, DB_QUERY, sizeof(DB_QUERY), "UPDATE accounts SET Player_Cash = %i WHERE Account_ID = %i LIMIT 1", PlayerInfo[playerid][pCash], PlayerInfo[playerid][pDBID]);
	mysql_tquery(sqlConnection, DB_QUERY);

     return 1;
}


CMD:makeadmin(playerid, params[])
{
    if(PlayerInfo[playerid][pAdmin] >= 6 || IsPlayerAdmin(playerid))
    {
        new playerb, adminlvl;

        if(sscanf(params, "ui", playerb, adminlvl))
            return SendClientMessage(playerid, COLOR_ADMCMD, "* [AdmCMD] > Usage: /makeadmin [Player ID/Part of name] [Level 1-1337] *");

        if(adminlvl < 0 || adminlvl > 1337)
            return SendClientMessage(playerid, COLOR_ADMCMD, "* [AdmCMD] > The level specified is wrong, please choose a correct level. *");

        if(!PlayerInfo[playerb][pLoggedin]) return SendClientMessage(playerid, COLOR_ADMCMD, "* The specified id is not a registered player! *");

        SendClientMessageEx(playerid, COLOR_ADMCMD, "* [AdmCMD] > You've just made [%s] admin level [%i] *", ReturnName(playerb), adminlvl);
        SendClientMessageEx(playerb, COLOR_SERVER, "* [AdmCMD] > You've just been made admin level [%i] by [%s] *", adminlvl, ReturnName(playerid));

        PlayerInfo[playerb][pAdmin] = adminlvl;

        DB_QUERY[0] = '\0';
        mysql_format(sqlConnection, DB_QUERY, sizeof(DB_QUERY), "UPDATE accounts SET Admin_Level = %i WHERE Account_ID = %i", adminlvl, PlayerInfo[playerb][pDBID]); // this are the lines which update the mysql database
        mysql_tquery(sqlConnection, DB_QUERY); //
    }
    else return SendClientMessage(playerid, COLOR_ERROR, "** [SERVER] > You are not authorized to use this command! **");
    return 1;
}