SA-MP Forums Archive
[ERROR]cache_get_field_content_int and Clan system problems - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [ERROR]cache_get_field_content_int and Clan system problems (/showthread.php?tid=617156)


[ERROR]cache_get_field_content_int and Clan system problems - Younes44 - 16.09.2016

Hello
i've UPDATE MY Gamemode(thx to jlalt), but i've 2 problems..
first: i found those errors: on mysql_log
PHP код:
[03:19:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`clanmesID` = 0 WHERE `Clan` = '[SAS]'' at line 1
[03:20:34] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`clanmesID` = 0 WHERE `Clan` = '[SAS]'' at line 1
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:46] [WARNING] CMySQLResult::GetRowDataByName - field not found ("pdate")
[03:25:46] [ERROR] cache_get_field_content_int - invalid datatype 
and second: my clan system
i can added player to my clan, but i can see his name on clan members..( i've try to added anothers players and problem still.. but it's working fine for me ?)

Re: [ERROR]cache_get_field_content_int and Clan system problems - sammp - 16.09.2016

It's exactly what it says: You're using different datatypes from which cache_get_field_content_int allows; AKA you're using datatypes other than integers and you're trying to express that value in an integer, but it doesn't work, example: playerData[playerid][Name] = cache_get_field_content_int(0, "Name")

Re: [ERROR]cache_get_field_content_int and Clan system problems - Younes44 - 16.09.2016

Quote:
Originally Posted by sammp
Посмотреть сообщение
It's exactly what it says: You're using different datatypes from which cache_get_field_content_int allows; AKA you're using datatypes other than integers and you're trying to express that value in an integer, but it doesn't work, example: playerData[playerid][Name] = cache_get_field_content_int(0, "Name")
oki how to fix it ??

and hat about this error ?
PHP код:
[03:19:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`clanmesID` = 0 WHERE `Clan` = '[SAS]'' at line 1
[03:20:34] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`clanmesID` = 0 WHERE `Clan` = '[SAS]'' at line 1 


Re: [ERROR]cache_get_field_content_int and Clan system problems - Shinja - 16.09.2016

Show the queries and picture from the tables if possible also

Re: [ERROR]cache_get_field_content_int and Clan system problems - Slawiii - 16.09.2016

Check the table
and check the mean column if it has the same datatype

Re: [ERROR]cache_get_field_content_int and Clan system problems - Younes44 - 17.09.2016

others are fixed but those no:
PHP код:
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype
[03:25:26] [ERROR] cache_get_field_content_int - invalid datatype 
how to fix that ?

Re: [ERROR]cache_get_field_content_int and Clan system problems - Shinja - 17.09.2016

....
Quote:
Originally Posted by Shinja
Посмотреть сообщение
Show the queries and picture from the tables if possible also


Re: [ERROR]cache_get_field_content_int and Clan system problems - Younes44 - 17.09.2016

Table here you go
http://imgur.com/a5vgVr2
But about queries ? what do you mean ? which one should i sent you ?
i'am using Latest MySQL Plugin btw

Re: [ERROR]cache_get_field_content_int and Clan system problems - asto63 - 17.09.2016

We need to know the request where you have this error !
To solve your problem, you should have something like that :

Код:
new tempString[MAX_PLAYER_NAME];
cache_get_field_content(0, COLUMN_NAME, tempString); // Get the content of the column "name"
format(UserData[name], MAX_PLAYER_NAME, "%s", tempString); Put the "name" in the data of your player


Re: [ERROR]cache_get_field_content_int and Clan system problems - Younes44 - 17.09.2016

PHP код:
        for(new i = 0; i < rows; i++)
        {
           cache_get_field_content(i, "Clan", Clan, Mysql);
           score = cache_get_field_content_int(i, "Clanscore", Mysql);
           format(content,sizeof(content),"%s%s\t\t%d Score\n",content,Clan,score);
        } 
and here's some code of my clan system
PHP код:
ChangeClanInfo(playerid,string[])
{
    new clanID = GetPVarInt(playerid,"dialogV");
    if(clanID == 0)
    {
        SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
        return createClanDialog(playerid);
    }
    new query[200];
    new info[130];
    mysql_real_escape_string(string,info);
    format(query,sizeof(query),"UPDATE `clans` SET `Info` = '%s' WHERE `Id` = %d",info,clanID);
    mysql_tquery(Mysql, query);
    createClanInfoDialog(playerid);
    return 1;
}
createMemberDialog(playerid)
{
    new Tag[8];
    new clanID = GetPVarInt(playerid,"dialogV");
    if(clanID == 0)
    {
        SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
        return createClanDialog(playerid);
    }
    new query[200];
    format(query,sizeof(query),"SELECT `Clan` FROM `clans` WHERE `ID` = %d",clanID);
    new Cache:Result = mysql_query(Mysql, query);
    //mysql_store_result();
    new rows = cache_num_rows(Mysql);
    if(rows) cache_get_field_content(0, "Clan", Tag, Mysql); //mysql_fetch_row(Tag);
    mysql_free_result();
    format(query,sizeof(query),"SELECT * FROM `users` WHERE `Clan` = '%s' AND `ClanRank` > 0",Tag);
    Result = mysql_query(Mysql, query);
    //mysql_store_result();
    new num = cache_num_rows(Mysql);
    mysql_free_result();
    if(GetPVarInt(playerid,"clanmembers") > num) return createClanMenuDialog(playerid);
    if(GetPVarInt(playerid,"clanmembers") < 0)
    {
        SetPVarInt(playerid,"clanmembers",0);
    }
    format(query,sizeof(query),"SELECT `ID`,`Name`,`ClanRank`,`date` FROM `users` WHERE `Clan` = '%s' AND `ClanRank` > 0 ORDER BY `ClanRank` DESC LIMIT %d,20",Tag,GetPVarInt(playerid,"clanmembers"));
    Result = mysql_query(Mysql, query);
    //mysql_store_result();
    new content[1500],list,header[50],activity;
    if(GetPVarInt(playerid,"clanmembers") < 20)
    {
        switch(Sprache[playerid])
        {
            case 0: format(content,sizeof(content),"%s Mitglieder:\n",Tag);
            case 1: format(content,sizeof(content),"%s Members:\n",Tag);
            case 2: format(content,sizeof(content),"%s Miembros:\n",Tag);
        }
    }
    else
    {
        switch(Sprache[playerid])
        {
            case 0: format(content,sizeof(content),"<< Letzte Seite\n");
            case 1: format(content,sizeof(content),"<< Previous page\n");
            case 2: format(content,sizeof(content),"<< Pagina anterior\n");
        }
    }
    if(cache_num_rows(Mysql) != 0)
    {
//        new line[25];
        new ID,name[24],clan,dtime;
        new daycheck = gettime();
        new rowsz = cache_num_rows(Mysql);
        for(new i = 0; i < rowsz; i++)
          {
              //sscanf(line,"p<|>ds[24]dd",ID,name,clan,dtime);
              ID = cache_get_field_content_int(i, "ID", Mysql);
              clan = cache_get_field_content_int(i, "ClanRank", Mysql);
              dtime = cache_get_field_content_int(i, "date", Mysql);
              cache_get_field_content(i, "Name", name, Mysql);
            list++;
            switch(Sprache[playerid])
            {
                case 0:
                {
                    if(daycheck - dtime > 604800) format(content,sizeof(content),"%s%30s\tLevel: %d\t{FF0000}INAKTIV{FFFFFF}\n",content,name,clan);
                    else format(content,sizeof(content),"%s%30s\tLevel: %d\t{00FF00}AKTIV{FFFFFF}\n",content,name,clan),activity++;
                }
                case 1:
                {
                    if(daycheck - dtime > 604800) format(content,sizeof(content),"%s%24s\tLevel: %d\t{FF0000}INACTIVE{FFFFFF}\n",content,name,clan);
                    else format(content,sizeof(content),"%s%30s\tLevel: %d\t{00FF00}ACTIVE{FFFFFF}\n",content,name,clan),activity++;
                }
                case 2:
                {
                    if(daycheck - dtime > 604800) format(content,sizeof(content),"%s%24s\tNivel: %d\t\t{FF0000}INACTIVO{FFFFFF}\n",content,name,clan);
                    else format(content,sizeof(content),"%s%30s\tNivel: %d\t\t{00FF00}ACTIVO{FFFFFF}\n",content,name,clan),activity++;
                }
            }
            clanmembercheck[playerid]
  •  = ID;
            }
        }
        if(list >     0)
        {
            if(    GetPVarInt(playerid,"clanmembers") < num - 20)
            {
                switch(    Sprache[playerid])
                {
                    case     0: format(content,sizeof(content),"%s>>Nдchste Seite\n",content);
                    case     1: format(content,sizeof(content),"%s>>Next page\n",content);
                    case     2: format(content,sizeof(content),"%s>>Siguiente pagina\n",content);
                }
            }
        }
            mysql_free_result();
        switch(    Sprache[playerid])
        {
            case     0:
            {
                if(list ==     0) format(content,sizeof(content),"%sKeine Mitglieder gefunden!\n",content);
                    format(header,sizeof(header),"Mitglieds Liste.    Anzahl der Mitglieder: %d",num);
                    ShowPlayerDialog(playerid,2006,DIALOG_STYLE_LIST,header,content,"Akzeptieren", "Zurьck");
            }
            case     1:
            {
                if(list ==     0) format(content,sizeof(content),"%sNo members found!\n",content);
                    format(header,sizeof(header),"Member List.    Total members: %d",num);
                    ShowPlayerDialog(playerid,2006,DIALOG_STYLE_LIST,header,content,"Accept", "Back");
            }
            case     2:
            {
                if(list ==     0) format(content,sizeof(content),"%sNo se han encontrado miembros!\n",content);
                    format(header,sizeof(header),"Lista de miembros.    Miembros en total: %d",num);
                    ShowPlayerDialog(playerid,2006,DIALOG_STYLE_LIST,header,content,"Aceptar", "Atras");
            }
        }
        return     1;
    }
    dismissMember(playerid)
    {
        new     clanID = GetPVarInt(playerid,"dialogV");
        new     memberID = GetPVarInt(playerid,"dialogVb");
        if(    clanID == 0 || memberID == 0)
        {
                SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
            return     createClanDialog(playerid);
        }
        new     Tag[8];
        new     Name[MAX_PLAYER_NAME],query[128];
            format(query,sizeof(query),"SELECT `Clan` FROM `clans` WHERE `ID` = %d",clanID);
        new     Cache:Result = mysql_query(Mysql, query);
            //mysql_store_result();
            new rows = cache_num_rows(Mysql);
        if(    rows) cache_get_field_content(0, "Clan", Tag, Mysql);
            mysql_free_result();
            format(query,sizeof(query),"SELECT `Name` FROM `users` WHERE `ID` = %d",memberID);
            Result = mysql_query(Mysql, query);
            //mysql_store_result();
            rows = cache_num_rows(Mysql);
        if(    rows != 0)
        {
            new     name[24];
            if(    rows)
            {
                    cache_get_field_content(0, "Name", name, Mysql);
                    format(Name,sizeof(Name),"%s",name);
            }
        }
            mysql_free_result();
        new     deleted = 0;
        foreach (    Player,id)
        {
                //gmx fix
            //if(GetPVarInt(id, "ClanRank") != 0)
                if(gClanRank[id] != 0)
            {
                if(    GetPVarInt(id, "ClanID") == clanID)
                {
                    if(!    strcmp(Name, PlayerName(id), false, sizeof(Name)))
                    {
                            RemoveFromClan(id,0,playerid);
                            deleted = 1;
                    }
                }
            }
        }
        if(    deleted == 0)
        {
                format(query,sizeof(query),"UPDATE `users` SET `ClanRank` = -1 WHERE `ID` = %d",memberID);
                mysql_tquery(Mysql, query);
        }
            SendLangMessage(playerid, _COLOR_GREEN, "Du hast den Member erfolgreich entlassen!","Member dismissed successfully!","Miembro expulsado con йxito!");
            createClanMenuDialog(playerid);
        return     1;
    }
    setMemberLevel(playerid,rank)
    {
        new     clanID = GetPVarInt(playerid,"dialogV");
        new     memberID = GetPVarInt(playerid,"dialogVb");
        if(    clanID == 0 || memberID == 0)
        {
                SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
            return     createClanDialog(playerid);
        }
        new     Name[MAX_PLAYER_NAME],query[128];
            format(query,sizeof(query),"SELECT `Name` FROM `users` WHERE `ID` = %d",memberID);
        new     Cache:Result = mysql_query(Mysql, query);
            //mysql_store_result();
            new rows = cache_num_rows(Mysql);
        if(    rows != 0)
        {
            new     /*line[24],*/name[24];
            if(    rows)
            {
                    //sscanf(line,"p<|>s[24]",name);
                    cache_get_field_content(0, "Name", name, Mysql);
                    format(Name,sizeof(Name),"%s",name);
            }
                mysql_free_result();
        }
        new     fail = 0;
        foreach (    Player,id)
        {
                //gmx fix
            //if(GetPVarInt(id, "ClanRank") != 0)
                if(gClanRank[id] != 0)
            {
                if(    GetPVarInt(id, "ClanID") == clanID)
                {
                    if(!    strcmp(Name, PlayerName(id), false, sizeof(Name)))
                    {
                            //gmx fix
                        //if(GetPVarInt(id, "ClanRank") != rank) SetClanRank(id,rank);
                            if(gClanRank[id] != rank) SetClanRank(id,rank,playerid);
                        else     fail = 1;
                    }
                }
            }
        }
        if(    fail == 0)
        {
                format(query,sizeof(query),"UPDATE `users` SET `ClanRank` = %d WHERE `ID` = %d",rank,memberID);
                mysql_tquery(Mysql, query);
                SendLangMessage(playerid, _COLOR_GREEN, "Level erfolgreich gegeben!","Member Level set successfully!","Nivel de miembro establecido con йxito!");
        }
        else     SendLangMessage(playerid, _COLOR_RED, "Dieser Member ist bereits das Level!","This Member is already this Level!","Este miembro ya esta en este nivel!");
            createMemberDetailsDialog(playerid);
        return     1;
    }
    forceJoinClan(playerid,params[])
    {
        new     clanID = GetPVarInt(playerid,"dialogV");
        if(    clanID == 0)
        {
                SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
            return     createClanDialog(playerid);
        }
        new     id,placement[6];
        if (    sscanf(params, "is[6]", id, placement))
        {
                SendLangMessage(playerid, _COLOR_WHITE, "Benutzung: [ID] [FRONT/BACK]","Usage: [ID] [FRONT/BACK]","Uso: [ID] [FRONT/BACK]");
            switch(    Sprache[playerid])
            {
                case     0: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Clan Mitglied hinzufьgen:","Verwendung: [ID] [FRONT/BACK]","Akzeptieren", "Zurьck");
                case     1: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Add Clan Member:","Usage: [ID] [FRONT/BACK]","Accept", "Back");
                case     2: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Anadir miembro al clan:","Usa: [ID] [FRONT/BACK]","Aceptar", "Atras");
            }
        }
        if(!    IsPlayerConnected(id))
        {
                SendLangMessage(playerid, _COLOR_WHITE, "Spieler nicht gefunden!","Player not found!","Jugador no encontrado!");
            switch(    Sprache[playerid])
            {
                case     0: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Clan Mitglied hinzufьgen:","Verwendung: [ID] [FRONT/BACK]","Akzeptieren", "Zurьck");
                case     1: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Add Clan Member:","Usage: [ID] [FRONT/BACK]","Accept", "Back");
                case     2: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Anadir miembro al clan:","Usa: [ID] [FRONT/BACK]","Aceptar", "Atras");
            }
        }
        if(    strcmp(placement, "Front", true, 5) && strcmp(placement, "Back", true, 4))
        {
                SendLangMessage(playerid, _COLOR_WHITE, "Falsche Tag position! Es muss Front oder Back sein.","Invalid Tag position! Must be Front or Back.","Posiciуn de la etiqueta no valida! Debe ser al comienzo o al final.");
            switch(    Sprache[playerid])
            {
                case     0: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Clan Mitglied hinzufьgen:","Verwendung: [ID] [FRONT/BACK]","Akzeptieren", "Zurьck");
                case     1: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Add Clan Member:","Usage: [ID] [FRONT/BACK]","Accept", "Back");
                case     2: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Anadir miembro al clan:","Usa: [ID] [FRONT/BACK]","Aceptar", "Atras");
            }
        }
            //gmx fix
        //if(GetPVarInt(id,"ClanRank") != 0)
            if(gClanRank[id] != 0)
        {
                SendLangMessage(playerid, _COLOR_WHITE, "Diese Person ist bereits in einen Clan!","This person is already in a clan!","Esta persona ya esta en un clan!");
            switch(    Sprache[playerid])
            {
                case     0: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Clan Mitglied hinzufьgen:","Verwendung: [ID] [FRONT/BACK]","Akzeptieren", "Zurьck");
                case     1: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Add Clan Member:","Usage: [ID] [FRONT/BACK]","Accept", "Back");
                case     2: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Anadir miembro al clan:","Usa: [ID] [FRONT/BACK]","Aceptar", "Atras");
            }
        }
        if(    GetPVarInt(id,"undercover") == 1)
        {
                SendLangMessage(playerid, _COLOR_WHITE, "Diese Person ist ein Undercover Admin!","This person is an Undercover Admin!","Esta perona es un administrador encubierto!");
            switch(    Sprache[playerid])
            {
                case     0: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Clan Mitglied hinzufьgen:","Verwendung: [ID] [FRONT/BACK]","Akzeptieren", "Zurьck");
                case     1: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Add Clan Member:","Usage: [ID] [FRONT/BACK]","Accept", "Back");
                case     2: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Anadir miembro al clan:","Usa: [ID] [FRONT/BACK]","Aceptar", "Atras");
            }
        }
        if(    LoggedIn[id] == 0)
        {
                SendLangMessage(playerid, _COLOR_WHITE, "Der Spieler muss eingeloggt sein!","Player must be logged in!","El jugador debe haber iniciado sesiуn!");
            switch(    Sprache[playerid])
            {
                case     0: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Clan Mitglied hinzufьgen:","Verwendung: [ID] [FRONT/BACK]","Akzeptieren", "Zurьck");
                case     1: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Add Clan Member:","Usage: [ID] [FRONT/BACK]","Accept", "Back");
                case     2: return ShowPlayerDialog(playerid,2007,DIALOG_STYLE_INPUT,"Anadir miembro al clan:","Usa: [ID] [FRONT/BACK]","Aceptar", "Atras");
            }
        }
        if(    AdminLevel{id} == 255) return 0;
            AddToClan(id,clanID,placement);
            createMemberDialog(playerid);
        return     1;
    }
    AddToClan(playerid,clanID,placement[])
    {
        if(    clanID == 0)
        {
                SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
            return     createClanDialog(playerid);
        }
        new     Tag[8];
        new     query[128];
            format(query,sizeof(query),"SELECT `Clan` FROM `clans` WHERE `ID` = %d",clanID);
        new     Cache:Result = mysql_query(Mysql, query);
            //mysql_store_result();
            new rows = cache_num_rows(Mysql);
        if(    rows) cache_get_field_content(0, "Clan", Tag, Mysql);//mysql_fetch_row(Tag);
            mysql_free_result();
        new     Name[MAX_PLAYER_NAME];
            Name = PlayerName(playerid);
        new     NewName[20];
        if(!    strcmp(placement, "Front", true, 5)) format(NewName,sizeof(NewName),"%s%s",Tag,Name);
        else     format(NewName,sizeof(NewName),"%s%s",Name,Tag);
        new     string[128],string2[128],string3[128];
            format(string, sizeof (string), "%s hat den Clan %s betreten", Name, Tag);
            format(string2, sizeof (string2), "%s has joined %s", Name, Tag);
            format(string3, sizeof (string3), "%s se ha unido a %s", Name, Tag);
            SendLangMessageToAll(_COLOR_YELLOW, string,string2, string3);
            //gmx fix
        //SetPVarString(playerid,"Clan",Tag);
        //SetPVarInt(playerid,"ClanRank",1);
            gClan[playerid] = Tag;
            gClanRank[playerid] = 1;
            SetPVarInt(playerid,"ClanID",clanID);
            ChangeName(playerid,NewName);
            format(string, sizeof (string), "Dein neuer Username ist %s. Benutze diesen Name wenn du dich einloggst!", NewName);
            format(string2, sizeof (string2), "Your new username is %s. Use this name when logging in!", NewName);
            format(string3, sizeof (string3), "Tu nuevo nombre es %s. Usa este nombre al iniciar sesiуn!", NewName);
            SendLangMessage(playerid,_COLOR_GREEN, string,string2,string3);
            format(string,sizeof(string),"%s hat den Clan betreten.",PlayerName(playerid));
            format(string2,sizeof(string2),"%s has joined the clan.",PlayerName(playerid));
            format(string3,sizeof(string3),"%s se ha unido al clan.",PlayerName(playerid));
            SendClanNews(gClan[playerid],string,string2,string3);
            format(query,sizeof(query),"SELECT * FROM `clanmessages` WHERE `Clan` = '%s'",Tag);
            mysql_query(Mysql, query);
            //mysql_store_result();
            new check = cache_num_rows(Mysql);
            clanmesID[playerid] = check;
            mysql_free_result();
        if(    GetPVarInt(playerid,"undercover") == 0) MySQL_SaveStats(playerid);
        return     1;
    }
    createMemberDetailsDialog(playerid)
    {
        new     clanID = GetPVarInt(playerid,"dialogV");
        if(    clanID == 0)
        {
                SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
            return     createClanDialog(playerid);
        }
        new     memberID = GetPVarInt(playerid,"dialogVb");
        if(    memberID == 0)
        {
                SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
            return     createClanDialog(playerid);
        }
        new     query[128],content[50];
            format(query,sizeof(query),"SELECT `Name`,`ClanRank` FROM `users` WHERE `ID` = '%d'",memberID);
        new     Cache:Result = mysql_query(Mysql, query);
            //mysql_store_result();
            new rows = cache_num_rows(Mysql);
        if(    rows != 0)
        {
            new     /*line[30],*/name[24],clanrank,checkname[24],checkrank;
            if(    rows)
            {
                    //sscanf(line,"p<|>s[24]d",name,clanrank);
                    cache_get_field_content(0, "Name", name, Mysql);
                    clanrank = cache_get_field_content_int(0, "ClanRank", Mysql);
                
                    format(checkname,sizeof(checkname),"%s",name);
                    checkrank = clanrank;
                    format(content,sizeof(content),"%s%s   Level: %d\n",content,checkname,checkrank);
            }
        }
            mysql_free_result();
        switch(    Sprache[playerid])
        {
            case     0: format(query,sizeof(query),"Level einstellen\nRauswerfen\nAls Haupt-Leader einstellen");
            case     1: format(query,sizeof(query),"Set level\nDismiss\nSet as main leader");
            case     2: format(query,sizeof(query),"Sleccionar nivel\nExpulsar\nSeleccionar como el lider principal");
        }
        switch(    Sprache[playerid])
        {
            case     0: ShowPlayerDialog(playerid,2008,DIALOG_STYLE_LIST,content,query,"Akzeptieren", "Zurьck");
            case     1: ShowPlayerDialog(playerid,2008,DIALOG_STYLE_LIST,content,query,"Accept", "Back");
            case     2: ShowPlayerDialog(playerid,2008,DIALOG_STYLE_LIST,content,query,"Aceptar", "Atras");
        }
        return     1;
    }
    DeleteClan(playerid)
    {
        new     clanID = GetPVarInt(playerid,"dialogV");
        if(    clanID == 0)
        {
                SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
            return     createClanDialog(playerid);
        }
        new     Tag[8];
        new     query[128];
            format(query,sizeof(query),"SELECT `Clan` FROM `clans` WHERE `ID` = %d",clanID);
        new     Cache:Result = mysql_query(Mysql, query);
            //mysql_store_result();
            new rows = cache_num_rows(Mysql);
        if(    rows) cache_get_field_content(0, "Clan", Tag, Mysql); //mysql_fetch_row(Tag);
            mysql_free_result();
            format(query,sizeof(query),"DELETE from `clans` WHERE `Id` = %d",clanID);
            mysql_tquery(Mysql, query);
            format(query,sizeof(query),"UPDATE `users` SET `ClanRank` = '-1', `clanmesID` = '0' WHERE `Clan` = '%s'",Tag);
            mysql_tquery(Mysql, query);
        foreach(    Player,id)
        {
            if(    gClanRank[id] != 0)
            {
                new     TagB[8];
                    TagB = gClan[id];
                if(!    strcmp(Tag, TagB, true))
                {
                        RemoveFromClan(id,-1,-1);
                }
            }
        }
        foreach(    Player,id)
        {
                //gmx fix
            //if(GetPVarInt(id,"ClanRank") != 0) GetClanID(id);
                if(gClanRank[id] != 0) GetClanID(id);
            if(    GetPVarInt(id,"dialogV") != 0) DeletePVar(id,"dialogV");
            if(    GetPVarInt(id,"ClanRecruit") != 0) DeletePVar(id,"ClanRecruit");
        }
            SendLangMessage(playerid, _COLOR_GREEN, "Clan erfolgreich gelцscht!","Clan deleted successfully!","Clan borrado con йxito!");
            createClanDialog(playerid);
        return     1;
    }
    //HERE IT ENDS
    createClanStatistics(playerid)
    {
        new     Tag[25];
        new     clanID = GetPVarInt(playerid,"dialogV");
        if(    clanID == 0)
        {
                SendLangMessage(playerid, _COLOR_RED, "Es ist ein Fehler aufgetreten.","There has been an error processing your request.","Ha habido un error al al solicitar tu pedido.");
            return     createClanDialog(playerid);
        }
        new     query[150],memberscount,activity,woncws,lostcws;
            format(query,sizeof(query),"SELECT `Clan` FROM `clans` WHERE `ID` = %d",clanID);
        new     Cache:Result = mysql_query(Mysql, query);
            //mysql_store_result();
            if(cache_num_rows(Mysql)) cache_get_field_content(0, "Clan", Tag, Mysql); //mysql_fetch_row(Tag);
            mysql_free_result();
            format(query,sizeof(query),"SELECT `date` FROM `users` WHERE `Clan` = '%s' AND `ClanRank` > 0",Tag);
            Result = mysql_query(Mysql, query);
            //mysql_store_result();
            memberscount = cache_num_rows(Mysql);
        if(    memberscount > 0)
        {
            new     /*string[20],*/pdate, cdate = gettime();
            for(new     i = 0; i < memberscount; i++)
            {
                    //sscanf(string,"d",pdate);
                    pdate = cache_get_field_content_int(i, "date", Mysql);
                if(    cdate - pdate < 604800) activity++;
            }
        }
            mysql_free_result();
            format(query,sizeof(query),"SELECT `woncws`,`lostcws` FROM `clans` WHERE `Clan` = '%s'",Tag);
            Result = mysql_query(Mysql, query);
            //mysql_store_result();
            new rows = cache_num_rows(Mysql);
        if(    rows > 0)
        {
    //        new string[20];
                for(new i = 0; i < rows; i++)//while(mysql_fetch_row(string))
                {
                    //sscanf(string,"p<|>dd",woncws,lostcws);
                    woncws = cache_get_field_content_int(i, "woncws", Mysql);
                    lostcws = cache_get_field_content_int(i, "lostcws", Mysql);
            }
        }
            mysql_free_result();
        new     acheck,ccheck;
        if(    activity == 0 || memberscount == 0) acheck = 0;
        else     acheck = activity * 100 / memberscount;
        if(    woncws == 0 || woncws + lostcws == 0) ccheck = 0;
        else     ccheck = woncws * 100 / (woncws+lostcws);
        switch(    Sprache[playerid])
        {
            case     0:
            {
                    format(query,sizeof(query),"Anzahl der Mitglieder:\t\t%d\nAktivitдt:\t\t\t%d %%\nAnzahl der Clanwars:\t\t%d\nGewonnene Clanwars:\t\t%d\nVerlorene Clanwars:\t%d\nErfolg in Clanwars:\t\t%d %%",memberscount,acheck,woncws+lostcws,woncws,lostcws,ccheck);
                    format(Tag,sizeof(Tag),"Statistik von %s",Tag);
                    ShowPlayerDialog(playerid,2011,DIALOG_STYLE_MSGBOX,Tag,query,"Akzeptieren", "Abbruch");
            }
            case     1:
            {
                    format(query,sizeof(query),"Total members:\t%d\nActivity:\t\t%d %%\nTotal clanwars:\t%d\nWon clanwars:\t\t%d\nLost clanwars:\t\t%d\nSuccess in clanwars:\t%d %%",memberscount,acheck,woncws+lostcws,woncws,lostcws,ccheck);
                    format(Tag,sizeof(Tag),"Statistics of %s",Tag);
                    ShowPlayerDialog(playerid,2011,DIALOG_STYLE_MSGBOX,Tag,query,"Accept","Cancel");
            }
            case     2:
            {
                    format(query,sizeof(query),"Miembros totales:\t\t%d\nActividad:\t\t\t%d %%\nGuerras de clanes totales:\t%d\nGuerras ganadas:\t\t%d\nGuerras perdidas:\t\t%d\nЙxito en guerras de clanes:\t%d %%",memberscount,acheck,woncws+lostcws,woncws,lostcws,ccheck);
                    format(Tag,sizeof(Tag),"Estadisticas de %s",Tag);
                    ShowPlayerDialog(playerid,2011,DIALOG_STYLE_MSGBOX,Tag,query,"Aceptar","Cancelar");
            }
        }
        return     1;
    }