[Dokins]

pawn Код:

CMD:createfaction(playerid, params[])
{
    if(LoggedIn[playerid] == 0) return SendClientMessage(playerid, COLOUR_GREY, "You must be logged in to use this command.");
    new factionname[100],Float:x, Float:y, Float:z;
    new factionid = MySQL_GetValue(FactionSQLID[factionid], "FactionID", "factions");
    if(AdminLevel[playerid] < 4) return SendClientMessage(playerid, COLOUR_GREY, "You are not authorized to use this command.");
    if(sscanf(params, "s[100]", factionname)) return SendClientMessage(playerid, COLOUR_GREY, "Usage: /createfaction [factionname]");
    
    new query[256];
    strcat(query, "INSERT INTO `factions` (`FactionName`, `FactionRank1`,`FactionRank2`, `FactionRank3`, `FactionRank4`, `FactionRank5`, `FactionRank6,");
    strcat(query, "`FactionRank7`, `FactionSkin1`, `FactionSkin2`, `FactionSkin3`, `FactionSkin4`, `FactionSkin5`, `FactionSkin6`, `FactionSkin7`,`FactionSkin8`, `FactionSkin9`, `FactionSkin10`, `FactionEntX`, `FactionEntY`,");
    strcat(query, "`FactionEntZ`, `FactionIntX`, `FactionIntY`, `FactionIntZ`, `SpawnX`, `SpawnY`, `SpawnZ`, `FactionInt`,`FactionBank`) VALUES ('%s',0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1, %f, %f, %f, 0, 0, 0, 0, 0, 0, -1, 1000000) , factionname, x, y, z");

    mysql_query(query);
    
    GetPlayerPos(playerid, x, y, z);
    
    format(FactionName[factionid],100, factionname);
    FactionRank1[factionid] = 0;
    FactionRank2[factionid] = 0;
    FactionRank3[factionid] = 0;
    FactionRank4[factionid] = 0;
    FactionRank5[factionid] = 0;
    FactionRank6[factionid] = 0;
    FactionRank7[factionid] = 0;
    FactionSkin1[factionid] = 1;
    FactionSkin2[factionid] = 1;
    FactionSkin3[factionid] = 1;
    FactionSkin4[factionid] = 1;
    FactionSkin5[factionid] = 1;
    FactionSkin6[factionid] = 1;
    FactionSkin7[factionid] = 1;
    FactionSkin8[factionid] = 1;
    FactionSkin9[factionid] = 1;
    FactionSkin10[factionid] = 1;
    FactionIntX[factionid] = 0;
    FactionIntY[factionid] = 0;
    FactionIntZ[factionid] = 0;
    FactionEntX[factionid] = x;
    FactionEntY[factionid] = y;
    FactionEntZ[factionid] = z;
    FactionPickup[factionid] = CreateDynamicPickup(1318, 23, FactionEntX[factionid], FactionEntY[factionid], FactionEntZ[factionid], 0, -1, -1, 10.0);
    SpawnX[factionid] = 0;
    SpawnY[factionid] = 0;
    SpawnZ[factionid] = 0;
    FactionInt[factionid] = -1;
    FactionBank[factionid] = 1000000;
    return 1;
}

This wont work.

And: this returns "Invalid Faction ID" , MAX_FACTIONS is defined as 10.

pawn Код:

CMD:setfactionent(playerid, params[])
{
    if(LoggedIn[playerid] == 0) return SendClientMessage(playerid, COLOUR_GREY, "You must be logged in to use this command.");
    if(AdminLevel[playerid] < 4) return SendClientMessage(playerid, COLOUR_GREY, "You are not authorized to use this command.");
    new factionid;
    factionid = MySQL_GetValue(FactionSQLID[factionid], "FactionID", "factions");
    if(factionid < 1 || factionid > MAX_FACTIONS) return SendClientMessage(playerid, COLOUR_GREY, "Invalid faction id.");
    if(sscanf(params, "d", factionid)) return SendClientMessage(playerid, COLOUR_GREY, "Usage: /setfactionent [factionid]");

    
    new Float: x, Float: y, Float: z;
    GetPlayerPos(playerid, x, y, z);
    
    FactionEntX[factionid] = x;
    FactionEntY[factionid] = y;
    FactionEntZ[factionid] = z;

    MySQL_SetFloat(FactionSQLID[factionid], "FactionEntX", x, "factions");
    MySQL_SetFloat(FactionSQLID[factionid], "FactionEntY", y, "factions");
    MySQL_SetFloat(FactionSQLID[factionid], "FactionEntZ", z, "factions");
    new string[128];
    format(string, sizeof(string), "You have set %s's entrance", FactionName[factionid]);
    SendClientMessage(playerid, COLOUR_LIGHTBLUE, string);
    return 1;
}

and Yes, I have added the faction into MYSQL.

Please advise.

[Kingunit]

"This wont work."

Error? Just didn't worked ingame? More information?

[PrawkC]

Well one thing I noticed was your string size of your query was WAY to small.