Functie:
public LoadJobs() {
    new
        Cache: db = mysql_query (g_Sql, "SELECT * FROM `jobs` ORDER BY `jobs`.`ID` ASC"),
        x, jobs, string[180];

    for (new i, j = cache_num_rows (); i != j; ++i) {
        jobs ++;

        cache_get_value_int(i, "ID", x);
        cache_get_value_int(i, "Name", JobInfo[x][jName]);
        cache_get_value_int(i, "NeedLevel", JobInfo[x][jLevel]);
        cache_get_value_name_float(i, "PosX", JobInfo[x][jPosX]);
        cache_get_value_name_float(i, "PosY", JobInfo[x][jPosY]);
        cache_get_value_name_float(i, "PosZ", JobInfo[x][jPosZ]);
        cache_get_value_int(i, "Legal", JobInfo[x][jLegal]);
        cache_get_value_int(i, "Skill1Veh", JobInfo[x][jSkill1Veh]);
        cache_get_value_int(i, "Skill2Veh", JobInfo[x][jSkill2Veh]);
        cache_get_value_int(i, "Skill3Veh", JobInfo[x][jSkill3Veh]);
        cache_get_value_int(i, "Skill4Veh", JobInfo[x][jSkill4Veh]);
        cache_get_value_int(i, "Skill5Veh", JobInfo[x][jSkill5Veh]);
        cache_get_value_int(i, "Skill6Veh", JobInfo[x][jSkill6Veh]);
        if(x != 7) {
            format(string, sizeof(string), "{ffffff}Job ID: {33CCFFFF}%d{FFFFFF}\n{ffffff}Job: {33CCFFFF}%s{FFFFFF}\nLevel: {33CCFFFF}%d{FFFFFF}\nPress {33CCFFAA}Y{FFFFFF} to get the job\nPress {33CCFFFF}N{FFFFFF} to quit job", x, JobInfo[x][jName], JobInfo[x][jLevel]);
            JobInfo[x][jLabel] = CreateDynamic3DTextLabel(string, -1, JobInfo[x][jPosX], JobInfo[x][jPosY], JobInfo[x][jPosZ], 25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, 0, -1, -1, 100.0);
            JobInfo[x][jPickup] = CreateDynamicPickup(1274, 23, JobInfo[x][jPosX], JobInfo[x][jPosY], JobInfo[x][jPosZ], 0, -1, -1, 100.0);
        }
    }
    printf("Joburi incarcate: %d", jobs);
    cache_delete(db);
    return 1;
}

Comanda:

CMD:jobs(playerid, params[]) {
    new szDialog[1024], szDialog2[1024], szTitle[50], xx;
    strcat(szDialog2, "Job name\tDistance\n");
    for(new j = 0; j < MAX_JOBS; j++) {
        if(strlen(JobInfo[j][jName]) >= 1 && j != 6) {
            format(szDialog, sizeof(szDialog), "%s\t{CBFF96}%0.2fm\n", JobInfo[j][jName], GetPlayerDistanceFromPoint(playerid, JobInfo[j][jPosX],JobInfo[j][jPosY],JobInfo[j][jPosZ]));
            strcat(szDialog2, szDialog);
            xx++;
        }
    }
    format(szTitle, sizeof(szTitle), "Jobs: %d", xx);
    ShowPlayerDialog(playerid, DIALOG_JOBS, DIALOG_STYLE_TABLIST_HEADERS, szTitle, szDialog2, "Ok", "Cancel");
    return 1;
}