[Admigo]

Heey all,

Whats wrong with this command?

pawn Код:

dcmd_cclan(playerid,params[])
{
     new cname[30], ctag[30], cpass[30], cw1, cw2, cw3;
     if(!sscanf(params, "s[30]s[30]s[30]iii", cname, ctag, cpass, cw1, cw2, cw3))
     {
          CreateClan(playerid, cname, ctag, cpass, "", "", cw1, cw2, cw3);
          return 1;
     }
     else SendClientMessage(playerid,-1,"USAGE: /cclan <clan-name> <clan-tag> <clan-pass> <weap1> <weap2> <weap3>");
     return 1;
}

stock CreateClan(playerid, clan_name[], clan_tag[], clan_pass[], clan_description[], clan_motd[], weap1, weap2, weap3)
{
    if(strlen(clan_pass) < 3 || strlen(clan_pass) > 10) return SendClientMessage(playerid,-1,"{FF0000}ERROR: {FFFFFF}Clan password lenght is {FF0000}invalid{FFFFFF}, please try again!");
    if(IsPlayerAnyClanMember(playerid) == 0)
    {
        CallLocalFunction("OnPlayerClanCreate", "is", playerid, clan_name);
        new clanquery3[100];
        format(clanquery3, sizeof(clanquery3), "SELECT clanname FROM a_clans WHERE clanname = '%s'", clan_name);
        mysql_query(clanquery3, _THREAD_GET_CLAN_CLAN_NAME, playerid, gSQL);
        mysql_store_result();
        new rows = mysql_num_rows();
        if(rows >= 1) return SendClientMessage(playerid,-1,"{FF0000}ERROR: {FFFFFF}Clan with that name already exists!");
        mysql_free_result();
        new clanquery[300];
        format(clanquery,sizeof(clanquery),"INSERT INTO a_clans(clanname, clantag, clanpass, clandes, clanmotd, weap1, weap2, weap3) VALUES('%s', '%s', '%s', '%s', '%s', %d, %d, %d)", clan_name, clan_tag, clan_pass, clan_description, clan_motd, weap1, weap2, weap3);
        mysql_query(clanquery, _THREAD_SET_CLAN, playerid, gSQL);
        new player_name[MAX_PLAYER_NAME];
        GetPlayerName(playerid,player_name,sizeof(player_name));
        new clanquery2[300];
        format(clanquery2,sizeof(clanquery2),"INSERT INTO a_clans_members(clanname, playername, playerclanrank, isinclan) VALUES('%s', '%s', 4, 1)", clan_name, player_name);
        mysql_query(clanquery2, _THREAD_SET_CLAN_MEMBER, playerid, gSQL);
        new name[MAX_PLAYER_NAME];
        GetPlayerName(playerid, name, sizeof(name));
        new msg_for_all[100];
        format(msg_for_all,sizeof(msg_for_all),"{03F2FF}CLAN: {00FF40}%s {FFFFFF}have created a clan named {00FF40}%s", name, clan_name);
        SendClientMessageToAll(-1,msg_for_all);
        return 1;
    }
    else SendClientMessage(playerid,-1,"{FF0000}ERROR: {FFFFFF}You are already in a clan, you cant create new one!");
    return 1;
}
stock IsPlayerAnyClanMember(playerid)
{
    new player_name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,player_name,sizeof(player_name));
    new clanquery[100];
    format(clanquery, sizeof(clanquery), "SELECT playername FROM a_clans_members WHERE playername = '%s'", player_name);
    mysql_query(clanquery, _THREAD_GET_MEMBER_IS_IN_A_CLAN, playerid, gSQL);
    mysql_store_result();
    new rows = mysql_num_rows();
    mysql_free_result();
    if(!rows) return 0;
    else return 1; 
}

When i use the command it says i am already in a clan.
How can i fix this? I am not even in the mysql database.

Admigo

[Necip]

pawn Код:

dcmd_cclan(playerid,params[])
{
     new cname[30], ctag[30], cpass[30], cw1, cw2, cw3;
     if(!sscanf(params, "s[30]s[30]s[30]iii", cname, ctag, cpass, cw1, cw2, cw3))
     {
          CreateClan(playerid, cname, ctag, cpass, "", "", cw1, cw2, cw3);
          return 1;
     }
     else SendClientMessage(playerid,-1,"USAGE: /cclan <clan-name> <clan-tag> <clan-pass> <weap1> <weap2> <weap3>");
     return 1;
}

stock CreateClan(playerid, clan_name[], clan_tag[], clan_pass[], clan_description[], clan_motd[], weap1, weap2, weap3)
{
    if(strlen(clan_pass) < 3 || strlen(clan_pass) > 10) return SendClientMessage(playerid,-1,"{FF0000}ERROR: {FFFFFF}Clan password lenght is {FF0000}invalid{FFFFFF}, please try again!");
    if(IsPlayerAnyClanMember(playerid) == 0)
    {
        CallLocalFunction("OnPlayerClanCreate", "is", playerid, clan_name);
        new clanquery3[100];
        format(clanquery3, sizeof(clanquery3), "SELECT clanname FROM a_clans WHERE clanname = '%s'", clan_name);
        mysql_query(clanquery3, _THREAD_GET_CLAN_CLAN_NAME, playerid, gSQL);
        mysql_store_result();
        new rows = mysql_num_rows();
        if(rows >= 1) return SendClientMessage(playerid,-1,"{FF0000}ERROR: {FFFFFF}Clan with that name already exists!");
        mysql_free_result();
        new clanquery[300];
        format(clanquery,sizeof(clanquery),"INSERT INTO a_clans(clanname, clantag, clanpass, clandes, clanmotd, weap1, weap2, weap3) VALUES('%s', '%s', '%s', '%s', '%s', %d, %d, %d)", clan_name, clan_tag, clan_pass, clan_description, clan_motd, weap1, weap2, weap3);
        mysql_query(clanquery, _THREAD_SET_CLAN, playerid, gSQL);
        new player_name[MAX_PLAYER_NAME];
        GetPlayerName(playerid,player_name,sizeof(player_name));
        new clanquery2[300];
        format(clanquery2,sizeof(clanquery2),"INSERT INTO a_clans_members(clanname, playername, playerclanrank, isinclan) VALUES('%s', '%s', 4, 1)", clan_name, player_name);
        mysql_query(clanquery2, _THREAD_SET_CLAN_MEMBER, playerid, gSQL);
        new name[MAX_PLAYER_NAME];
        GetPlayerName(playerid, name, sizeof(name));
        new msg_for_all[100];
        format(msg_for_all,sizeof(msg_for_all),"{03F2FF}CLAN: {00FF40}%s {FFFFFF}have created a clan named {00FF40}%s", name, clan_name);
        SendClientMessageToAll(-1,msg_for_all);
        return 1;
    }
    else 
    {
    SendClientMessage(playerid,-1,"{FF0000}ERROR: {FFFFFF}You are already in a clan, you cant create new one!");
    }
    return 1;
}
stock IsPlayerAnyClanMember(playerid)
{
    new player_name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,player_name,sizeof(player_name));
    new clanquery[100];
    format(clanquery, sizeof(clanquery), "SELECT playername FROM a_clans_members WHERE playername = '%s'", player_name);
    mysql_query(clanquery, _THREAD_GET_MEMBER_IS_IN_A_CLAN, playerid, gSQL);
    mysql_store_result();
    new rows = mysql_num_rows();
    mysql_free_result();
    if(!rows) return 0;
    else return 1;

I didn't really test it but you shall test it.Hope it helps

[RalphHaro]

Thanks Necip

[Admigo]

Quote:

Originally Posted by RalphHaro Thanks Necip

Still same error message:S
Mysql server log:

Код:

[18:47:44] >> mysql_query_callback(Connection handle: 1)
[18:47:44] >> mysql_store_result(Connection handle: 1)
[18:47:44] CMySQLHandler::StoreResult() - No data to store.
[18:47:44] >> mysql_free_result(Connection handle: 1)
[18:47:44] CMySQLHandler::FreeResult() - The result is already empty.
[18:47:44] >> mysql_num_rows(Connection handle: 1)
[18:47:44] CMySQLHandler::NumRows() - You cannot call this function now (no result).
[18:47:44] ProcessQueryThread(OnQueryFinish) - Executing query SELECT playername FROM a_clans_members WHERE playername = 'Admigo'...
[18:47:44] ProcessQueryThread(OnQueryFinish) - Query was successful.
[18:47:44] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[18:47:44] OnQueryFinish(siii) - Callback is being called...