public LoadJobs

public LoadJobs()
{
    mysql_query("SELECT *  FROM `jobs` ORDER BY Bid ASC");
    mysql_store_result();

    new idx, result[128], string[256], stringfile[64];
    format(stringfile, sizeof(stringfile), "gm_init/%s", SERVERinit);

    while(mysql_retrieve_row())
    {
        if(idx >= sizeof(JobInfo)) { return 1; }

        mysql_fetch_field_row(result,"Bid"); JobInfo[idx][jSQL] = strval(result);
		mysql_fetch_field_row(JobInfo[idx][jName],"Name");
        mysql_fetch_field_row(result,"Public"); JobInfo[idx][jPublic] = strval(result);
        mysql_fetch_field_row(result,"Caisse"); JobInfo[idx][jCaisse] = strval(result);
        mysql_fetch_field_row(JobInfo[idx][jPerm1],"Perm1");
        mysql_fetch_field_row(JobInfo[idx][jPerm2],"Perm2");
        mysql_fetch_field_row(JobInfo[idx][jPerm3],"Perm3");
        mysql_fetch_field_row(JobInfo[idx][jPerm4],"Perm4");
        mysql_fetch_field_row(JobInfo[idx][jPerm5],"Perm5");
        mysql_fetch_field_row(JobInfo[idx][jPerm6],"Perm6");
        mysql_fetch_field_row(result,"VestX"); JobInfo[idx][jVestX] = floatstr(result);
        mysql_fetch_field_row(result,"VestY"); JobInfo[idx][jVestY] = floatstr(result);
        mysql_fetch_field_row(result,"VestZ"); JobInfo[idx][jVestZ] = floatstr(result);
        mysql_fetch_field_row(result,"VestWorld"); JobInfo[idx][jVestWorld] = strval(result);
        mysql_fetch_field_row(result,"Phone"); JobInfo[idx][jPhone] = strval(result);
        mysql_fetch_field_row(JobInfo[idx][jPhoneText],"PhoneText");
        mysql_fetch_field_row(result,"Freq"); JobInfo[idx][jFreq] = strval(result);
        mysql_fetch_field_row(result,"Interim"); JobInfo[idx][jInterim] = strval(result);
		if(floatround(JobInfo[idx][jVestX]) != 0 && floatround(JobInfo[idx][jVestY]) != 0 && floatround(JobInfo[idx][jVestZ]) != 0)
		{ CreatePickup(1275, 1, JobInfo[idx][jVestX], JobInfo[idx][jVestY], JobInfo[idx][jVestZ], JobInfo[idx][jVestWorld]); }
        format(string, sizeof(string), "LoadJobs:%d SQL:%d Name:\"%s\" Public:%d Caisse:%d Phone:%d Freq:%d Interim:%d",idx, JobInfo[idx][jSQL], JobInfo[idx][jName], JobInfo[idx][jPublic], JobInfo[idx][jCaisse], JobInfo[idx][jPhone], JobInfo[idx][jFreq], JobInfo[idx][jInterim]);
		WriteFile(stringfile, string);
		idx++;
    }
    mysql_free_result();
    WriteFile(stringfile, "");
    return 1;
}