forward LoadFraks();
public LoadFraks()
{
    new query[128];
	for(new idx=0; idx<MAX_FRAKS; idx++)
	{
	    format(query, sizeof(query), "SELECT * FROM `frakbase` WHERE `id`='%i'", idx);
	    mysql_pquery(mysqlcon, query, "LoadMysqlFraks", "i",idx);
	}
	return 1;
}

forward LoadMysqlFraks(idx);
public LoadMysqlFraks(idx)
{
	new rows;

    cache_get_row_count(rows);
	if(rows)
	{





		cache_get_value_name_int(0, "fcreated", FrakInfo[idx][fCreated]);
		cache_get_value_name(0, "tmessage", FrakInfo[idx][fMessage],128);

		cache_get_value_name_float(0, "fexitx", FrakInfo[idx][fExitX]);
		cache_get_value_name_float(0, "fexity", FrakInfo[idx][fExitY]);
		cache_get_value_name_float(0, "fexitz", FrakInfo[idx][fExitZ]);

		cache_get_value_name_float(0, "tentrancex", FrakInfo[idx][fEntranceX]);
		cache_get_value_name_float(0, "tentrancey", FrakInfo[idx][fEntranceY]);
		cache_get_value_name_float(0, "tentrancez", FrakInfo[idx][fEntranceZ]);

		cache_get_value_name_int(0, "finterior", FrakInfo[idx][fInterior]);
		cache_get_value_name_int(0, "ffrak", FrakInfo[idx][fFrak]);
		cache_get_value_name_int(0, "fopen", FrakInfo[idx][fOpen]);


		cache_get_value_name_int(0, "tdrugprice", FrakInfo[idx][fDrugsPrice]);
		cache_get_value_name_int(0, "tmatsprice", FrakInfo[idx][fMatsPrice]);
		cache_get_value_name_int(0, "tmats", FrakInfo[idx][fMats]);
        cache_get_value_name_int(0, "tdrugs", FrakInfo[idx][fDrugs]);




    	if(FrakInfo[idx][fCreated] == 1)
		{
	            format(frakbasetring, sizeof(frakbasetring), "Fraktionsbase %d\n\n%s",idx,FrakInfo[idx][fMessage]);
				FrakInfo[idx][f_text] = Create3DTextLabel(frakbasetring,0xFFFFFFAA,FrakInfo[idx][fEntranceX], FrakInfo[idx][fEntranceY], FrakInfo[idx][fEntranceZ]+1.25,15,0,1);
	   			Update3DTextLabelText(FrakInfo[idx][f_text],0xFFFFFFAA,frakbasetring);
				FrakInfo[idx][fPickup]	= CreatePickup(1318, 0, FrakInfo[idx][fEntranceX], FrakInfo[idx][fEntranceY], FrakInfo[idx][fEntranceZ]+0.25);
				pickups++;
		}

	}
}