Mysql ucitavanje

forward UcitajKuce();
public UcitajKuce()
{
    if(!cache_num_rows()) return printf("\n: Kuce nisu kreirane.\n");
	new String:str;
	cache_get_row_count(TotalKuce);
	for(new i=0; i < TotalKuce; i++)
	{
        cache_get_value_name_int(i, "ID", KucaInfo);
        cache_get_value_name_int(i, "ProveraVlasnika", bool:KucaInfo);
        cache_get_value_name(i, "Vlasnik", KucaInfo, MAX_PLAYER_NAME+1);
		cache_get_value_name_float(i, "UlazX", KucaInfo);
        cache_get_value_name_float(i, "UlazY", KucaInfo);
        cache_get_value_name_float(i, "UlazZ", KucaInfo);
        cache_get_value_name_float(i, "IzlazX", KucaInfo);
        cache_get_value_name_float(i, "IzlazY", KucaInfo);
        cache_get_value_name_float(i, "IIzlazZ", KucaInfo);
        cache_get_value_name_int(i, "Level", KucaInfo);
        cache_get_value_name_int(i, "Cena", KucaInfo);
        cache_get_value_name_int(i, "Novac", KucaInfo);
        cache_get_value_name_int(i, "Int", KucaInfo);
        cache_get_value_name_int(i, "Zatvoreno", bool:KucaInfo);
        cache_get_value_name_int(i, "VW", KucaInfo);
        cache_get_value_name_int(i, "Oruzije", KucaInfo);
        cache_get_value_name_int(i, "Municija", KucaInfo);
        cache_get_value_name_int(i, "Rent", bool:KucaInfo);
        cache_get_value_name_int(i, "CenaRenta", KucaInfo);
        cache_get_value_name_int(i, "Zvono", bool:KucaInfo);
        cache_get_value_name_int(i, "Heal", KucaInfo);
        cache_get_value_name_int(i, "Skin", KucaInfo);
        cache_get_value_name_int(i, "PromenaIntKuce", KucaInfo);
        cache_get_value_name_int(i, "Neaktivnost", KucaInfo);

		if(!KucaInfo)
		{
            str = str_format("{e6ac00}[KUCA NA PRODAJU]\n{e6ac00}Cena: {ffffff}%d$\n{e6ac00}Level: {ffffff}%d\n{e6ac00}Broj kuce: {ffffff}%d\n{e6ac00}Za kupovinu /kupikucu", KucaInfo, KucaInfo, KucaInfo);
			KucaInfo = CreateDynamic3DTextLabel(str, 0x33CCFFAA, KucaInfo, KucaInfo, KucaInfo, 25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 25, -1, 0);
			KucaInfo = CreateDynamicPickup(1273, 1, KucaInfo, KucaInfo, KucaInfo, -1, -1, -1, 25, -1, 0);
		}
		else
		{
			if(!KucaInfo)
			{
			    str = str_format("{4747d1}Vlasnik: {ffffff}%s\n{4747d1}Cena: {ffffff}%d$\n{4747d1}Level: {ffffff}%d\n{4747d1}Cena renta: {ffffff}%d$\n{4747d1}Broj kuce: {ffffff}%d\n{4747d1}Neaktivnost: {ffffff}%d\n{4747d1}Rent: {ffffff}/rentajkucu",\
				KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo);
			}
			else
			{
                str = str_format("{4747d1}Vlasnik: {ffffff}%s\n{4747d1}Cena: {ffffff}%d$\n{4747d1}Level: {ffffff}%d\n{4747d1}Broj kuce: {ffffff}%d\n{4747d1}Neaktivnost: {ffffff}%d",\
				KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo, KucaInfo);
			}
			KucaInfo = CreateDynamic3DTextLabel(str, 0x33CCFFAA, KucaInfo, KucaInfo, KucaInfo, 25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 25, -1, 0);
			KucaInfo = CreateDynamicPickup(19522, 1, KucaInfo, KucaInfo, KucaInfo, -1, -1, -1, 25, -1, 0);
		}
	}
	printf("\n: %d Kuca je ucitano\n",TotalKuce);
	return 1;
}

Vaš odgovor

cache_get_value_name_int
Description:
Retrieves a value from the result set as a decimal number.

Parameters:
(row_idx, const column_name[], &destination)
row_idx	The row index (starts at '0'). // ovaj deo
const column_name[]	The column name.
&destination	The variable to store the number into.