[Tanush123]

pawn Code:

CMD:createbar(playerid,params[])
{
    if(PlayerData[playerid][AdminLevel] < 4) return 0;
    if(sscanf(params,"i",barid)) return SendClientMessage(playerid,grey,"USAGE: /createbar [Bar ID]");
    if(barid > MAX_BARS) return SendClientMessage(playerid,red,"Available BARS 1-9");
    CheckMySQL();
    format(str,sizeof(str),"SELECT * FROM Bars WHERE ID = '%d'",barid);
    mysql_query(str);
    mysql_store_result();
    if(mysql_num_rows() == 0)
    {
        mysql_free_result();
        GetPlayerPos(playerid,X,Y,Z);
        format(str,sizeof(str),"INSERT INTO Bars (ID,PosX,PosY,PosZ) VALUES ('%d','%f','%f','%f')",barid,X,Y,Z);
        mysql_query(str);
        format(str,sizeof(str),"You have created Bar ID: %d!",barid);
        SendClientMessage(playerid,orange,str);
        BarInfo[barid][barcheck] = CreateDynamicCP(X,Y,Z,1,-1,-1,-1,50);
        format(str,sizeof(str),"ID: {FFFFFF}%d",barid);
        BarInfo[barid][bartext] = Create3DTextLabel(str,Niceyellow,X,Y,Z,100.0,-1,1);
    }
    else
    {
        SendClientMessage(playerid,red,"ERROR: This Bar ID is already used.");
    }
    return 1;
}