[No Fear]

Hi, just have a trouble with a code... So my mod is MySQL... And i need a code ore ir simple command... ZCMD will be better... okay /fkick [player] And i need a code, to kick a player in offline mode... Imagine You're a faction leader, and you need to kick some one, but hes offlince, /fkick [player] boom and hes kicked...

Thanks

[wups]

pawn Код:

CMD:fkick(playerid,params[])
{
        new name[128];
        if (sscanf(params, "s",name))
        {
            SendClientMessage(playerid,WHITE,"* Usage /fkick [Name]");
            return 1;
        }
        new query[256];
        format(query,sizeof(query),"SELECT `Lead` FROM `Account` WHERE `Name`='%s' LIMIT 1",name);
        mysql_query(query);
        mysql_store_result();
        if(!mysql_num_rows()){ SendClientMessage(playerid, RED," * There's no such player!!"); mysql_free_result(); return 1;}
        if(mysql_fetch_int() == 0) { SendClientMessage(playerid, RED," * This player is not a leader!!"); mysql_free_result(); return 1; }
        mysql_free_result();
        format(query,sizeof(query),"UPDATE `Account` SET `Lead`=0 WHERE `Name`='%s' LIMIT 1",name);
        mysql_query(query);

        SendClientMessage(playerid, 0xD9E916FF, "* Success.");
        return 1;
}

This is what i use
Don't forget to change the query's to fit your database.

[Cameltoe]

pawn Код:

new Query[128];
format(Query, sizeof(Query), "DELETE FROM factions WHERE username = '%s' AND faction = %d;", Usernamehere, Faction id here);
mysql_query(Query);

Do not forget to check if the user actually exists.

[No Fear]

Okay thanks to wups, and cameltoe

[No Fear]

Okay now hes saying "There's no such player"
any help
and i got this

"[18:44:36] sscanf warning: Strings without a length are deprecated, please add a destination size."

[wups]

replace
if (sscanf(params, "s",name))
with
if (sscanf(params, "s[128]",name))

[Speed]

how to make this not MySql ??

[Cameltoe]

Use the same method as Wups showed you, read the file with name, check if faction inside file = desired faction, if equals set faction inside file to -1 or so.