achievements snippet

forward showachiv(playerid);
public showachiv(playerid)
{
    new ids[256],ffield[256];
    GetPlayerName(playerid,player_name[playerid],16);
    format(mysqlquery[playerid],256,"SELECT achievements FROM achievements WHERE name = '%s'",player_name[playerid]);
    mysql_query(mysqlquery[playerid]);
    mysql_store_result();
    if(mysql_num_rows() == 0)
    {
        mysql_free_result();
        for(new gor=1;gor<=200;gor++) format(ids,256,"%s0",ids);
        mysql_free_result();
        format(mysqlquery[playerid],256,"INSERT INTO achievements (name,achievements) VALUES ('%s','%s')",player_name[playerid],ids);
        mysql_query(mysqlquery[playerid]);
    }
    else mysql_fetch_field("achievements",ids);
    mysql_free_result();

    new mid[128],pos[2],endstring[2048];
    for(new i=1;i<=200;i++)
    {
        pos[0] = i-1;
        pos[1] = i;
        strmid(mid,ids,pos[0],pos[1]);
        format(mysqlquery[playerid],256,"SELECT * FROM achiev_strings WHERE nummer = '%d' AND server='2'",i);
        mysql_query(mysqlquery[playerid]);
        mysql_store_result();
        if(mysql_num_rows() == 0)
        {
            mysql_free_result();
            continue;
        }
        mysql_fetch_field("titel",ffield);
        mysql_free_result();
        if(strval(mid) == 0) format(endstring,2048,"{FF0000}%s\n%s",ffield,endstring);
        else format(endstring,2048,"{33FF00}%s\n%s",ffield,endstring);
    }
    ShowPlayerDialog(playerid,911,2,"Auszeichnungen",endstring,"Bedingungen","Schließen");
    return 1;
}

forward countachiv(playerid);
public countachiv(playerid)
{
    GetPlayerName(playerid,player_name[playerid],16);
    format(mysqlquery[playerid],256,"SELECT achievements FROM achievements WHERE name = '%s'",player_name[playerid]);
    mysql_query(mysqlquery[playerid]);
    mysql_store_result();
    new ids[256];
    mysql_fetch_field("achievements",ids);
    mysql_free_result();
    new mid[128],pos[2],gesa;
    for(new i=1;i<=200;i++)
    {
        pos[0] = i-1;
        pos[1] = i;
        strmid(mid,ids,pos[0],pos[1]);
        if(strval(mid)==1) gesa+=1;
    }
    return gesa;
}

forward triggerachiv(playerid,idi);
public triggerachiv(playerid,idi)
{
    if(IsPlayerNPC(playerid)) return 1;
    new tlong[512];
    new ids[256],ffield[256];

    GetPlayerName(playerid,player_name[playerid],16);
    format(mysqlquery[playerid],256,"SELECT achievements FROM achievements WHERE name = '%s'",player_name[playerid]);
    mysql_query(mysqlquery[playerid]);
    mysql_store_result();
    if(mysql_num_rows() == 0)
    {
        mysql_free_result();
        for(new gor=1;gor<=200;gor++) format(ids,256,"%s0",ids);
        mysql_free_result();
        format(tlong,512,"INSERT INTO achievements (name,achievements) VALUES ('%s','%s')",player_name[playerid],ids);
        mysql_query(tlong);
    }
    else mysql_fetch_field("achievements",ids);
    mysql_free_result();

    new mid[128],pos[2];
    for(new i=1;i<=200;i++)
    {
        pos[0] = i-1;
        pos[1] = i;
        strmid(mid,ids,pos[0],pos[1]);
        if(i == idi)
        {
            if(strval(mid) == 1) return 1;
            GetPlayerName(playerid,player_name[playerid],16);
            format(mysqlquery[playerid],256,"UPDATE login SET rlmoney=rlmoney+1 WHERE name = '%s'",player_name[playerid]);
            mysql_query(mysqlquery[playerid]);
            getrlmoney(playerid);

            format(mysqlquery[playerid],256,"SELECT * FROM achiev_strings WHERE nummer = '%d'",i);
            mysql_query(mysqlquery[playerid]);
            mysql_store_result();
            new tit[128];
            mysql_fetch_field("string",ffield);
            mysql_fetch_field("titel",tit);
            format(ffield,256,"~r~AUSZEICHNUNG ERHALTEN~n~~n~~g~%s~n~~w~%s",tit,ffield);
            mysql_free_result();
            GameTextForPlayer(playerid,ffield,5000,3);
            strdel(ids,pos[0],pos[1]);
            strins(ids,"1",pos[0]);
            format(mysqlquery[playerid],256,"UPDATE achievements SET lastachv = '%s' WHERE name = '%s'",tit,player_name[playerid]);
            mysql_query(mysqlquery[playerid]);

            format(ffield,256,"%s hat die Auszeichnung '%s' erhalten",player_name[playerid],tit);
            SendClientMessageToAll(COLOR_GREEN,ffield);
            break;
        }
    }
    format(tlong,512,"UPDATE achievements SET achievements = '%s' WHERE name = '%s'",ids,player_name[playerid]);
    mysql_query(tlong);

    return 1;
}