[Younes44]

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 ?)

[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")

[Younes44]

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 


[Shinja]

Show the queries and picture from the tables if possible also

[Slawiii]

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

[Younes44]

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 ?

[Shinja]

....

Quote:

Originally Posted by Shinja Show the queries and picture from the tables if possible also

[Younes44]

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

[asto63]

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

[Younes44]

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;
}