[The_Gangstas]

1. converted to gstylezzz
2. it didn't load cus it only printed printf("[System] Loading Groups's....");
and this doesnt work either, even though i converted

pawn Код:

stock LoadGroup(id)
{
    new data[256];
    format(GlobalQuery1, sizeof(GlobalQuery1), "SELECT * FROM Groups WHERE Groupid = %d LIMIT 1",id);
    mysql_query(GlobalQuery1);
    mysql_store_result();
    if(mysql_num_rows() > 0)
    {
        new line[700];
        if(mysql_fetch_row(line))
        {
            new Gstr[9][70],Gvar[1];
            sscanf(line, "p<|>ds[255]s[255]s[255]s[255]s[255]s[255]s[255]s[255]s[255]",Gvar[0],Gstr[0],Gstr[1],Gstr[2],Gstr[3],Gstr[4],Gstr[5],Gstr[6],Gstr[7],Gstr[8]);
            Groups[id][Groupid] = Gvar[0];
            strmid(Groups[id][GroupName], Gstr[0], false, strlen(Groups[id][GroupName]), 255);
            strmid(Groups[id][RankName0], Gstr[1], false, strlen(Groups[id][RankName0]), 255);
            strmid(Groups[id][RankName1], Gstr[2], false, strlen(Groups[id][RankName1]), 255);
            strmid(Groups[id][RankName2], Gstr[3], false, strlen(Groups[id][RankName2]), 255);
            strmid(Groups[id][RankName3], Gstr[4], false, strlen(Groups[id][RankName3]), 255);
            strmid(Groups[id][RankName4], Gstr[5], false, strlen(Groups[id][RankName4]), 255);
            strmid(Groups[id][RankName5], Gstr[6], false, strlen(Groups[id][RankName5]), 255);
            strmid(Groups[id][RankName6], Gstr[7], false, strlen(Groups[id][RankName6]), 255);
            strmid(Groups[id][MOTD], Gstr[8], false, strlen(Groups[id][MOTD]), 255);
            printf("Loaded Groupid:%d",id);
            printf("Groupid:%d Name:%s Rank0:%s Rank1:%s Rank2:%s Rank3:%s Rank4:%s Rank5:%s Rank6:%s MOTD:%s",
            Groups[id][Groupid],Groups[id][GroupName],Groups[id][RankName0],Groups[id][RankName1],Groups[id][RankName2],
            Groups[id][RankName3],Groups[id][RankName4],Groups[id][RankName5],Groups[id][RankName6],Groups[id][MOTD]);
        }
        GroupCount++;
        mysql_fetch_field_row("Groupid",data);
        Groups[id][Groupid]=strval(data);
        mysql_fetch_field_row("GroupName",data);
        strmid(Groups[id][GroupName], data, false, strlen(Groups[id][GroupName]), 255);
        mysql_fetch_field_row("RankName0",data);
        strmid(Groups[id][RankName0], data, false, strlen(Groups[id][RankName0]), 255);
        mysql_fetch_field_row("RankName1",data);
        strmid(Groups[id][RankName1], data, false, strlen(Groups[id][RankName1]), 255);
        mysql_fetch_field_row("RankName2",data);
        strmid(Groups[id][RankName2], data, false, strlen(Groups[id][RankName2]), 255);
        mysql_fetch_field_row("RankName3",data);
        strmid(Groups[id][RankName3], data, false, strlen(Groups[id][RankName3]), 255);
        mysql_fetch_field_row("RankName4",data);
        strmid(Groups[id][RankName4], data, false, strlen(Groups[id][RankName4]), 255);
        mysql_fetch_field_row("RankName5",data);
        strmid(Groups[id][RankName5], data, false, strlen(Groups[id][RankName5]), 255);
        mysql_fetch_field_row("RankName6",data);
        strmid(Groups[id][RankName6], data, false, strlen(Groups[id][RankName6]), 255);
        mysql_fetch_field_row("MOTD",data);
        strmid(Groups[id][MOTD], data, false, strlen(Groups[id][MOTD]), 255);
        printf("Loaded Groupid:%d",id);
        printf("Groupid:%d Name:%s Rank0:%s Rank1:%s Rank2:%s Rank3:%s Rank4:%s Rank5:%s Rank6:%s MOTD:%s",
        Groups[id][Groupid],Groups[id][GroupName],Groups[id][RankName0],Groups[id][RankName1],Groups[id][RankName2],
        Groups[id][RankName3],Groups[id][RankName4],Groups[id][RankName5],Groups[id][RankName6],Groups[id][MOTD]);
    }
    mysql_free_result();
    return 1;
}

pawn Код:

stock LoadGroups2()
{
    printf("[System] Loading Groups's....");
    new data[256], i;
    format(GlobalQuery, sizeof(GlobalQuery), "SELECT * FROM Groups ORDER BY Groupid");
    mysql_query(GlobalQuery);
    mysql_store_result();
    if(mysql_num_rows() > 0)
    {
        new line[1024];
        while(mysql_fetch_row(line)==1)
        {
            GroupCount++;
            i = GroupCount;
            mysql_fetch_field_row(data,"Groupid");
            Groups[i][Groupid]=strval(data);
            mysql_fetch_field_row(data,"GroupName");
            strmid(Groups[i][GroupName], data, false, strlen(Groups[i][GroupName]), 255);
            mysql_fetch_field_row(data,"RankName0");
            strmid(Groups[i][RankName0], data, false, strlen(Groups[i][RankName0]), 255);
            mysql_fetch_field_row(data,"RankName1");
            strmid(Groups[i][RankName1], data, false, strlen(Groups[i][RankName1]), 255);
            mysql_fetch_field_row(data,"RankName2");
            strmid(Groups[i][RankName2], data, false, strlen(Groups[i][RankName2]), 255);
            mysql_fetch_field_row(data,"RankName3");
            strmid(Groups[i][RankName3], data, false, strlen(Groups[i][RankName3]), 255);
            mysql_fetch_field_row(data,"RankName4");
            strmid(Groups[i][RankName4], data, false, strlen(Groups[i][RankName4]), 255);
            mysql_fetch_field_row(data,"RankName5");
            strmid(Groups[i][RankName5], data, false, strlen(Groups[i][RankName5]), 255);
            mysql_fetch_field_row(data,"RankName6");
            strmid(Groups[i][RankName6], data, false, strlen(Groups[i][RankName6]), 255);
            mysql_fetch_field_row(data,"MOTD");
            strmid(Groups[i][MOTD], data, false, strlen(Groups[i][MOTD]), 255);
            printf("Loaded Groupid:%d",GroupCount);
            printf("Groupid:%d Name:%s Rank0:%s Rank1:%s Rank2:%s Rank3:%s Rank4:%s Rank5:%s Rank6:%s MOTD:%s",
            Groups[i][Groupid],Groups[i][GroupName],Groups[i][RankName0],Groups[i][RankName1],Groups[i][RankName2],
            Groups[i][RankName3],Groups[i][RankName4],Groups[i][RankName5],Groups[i][RankName6],Groups[i][MOTD]);
            GroupCount++;
        }
    }
    printf("[System] A Total Of %d Groups Spawned!",GroupCount);
    mysql_free_result();
    return 1;
}