mysql help
#1

Helo guys i have a problem with loading my bank system in mysql r6 it dont want to load or start function i dont know a problem really and i need your help.

Код:
stock UcitajBanke()
{

        for(new id=0; id<MAX_BANKI; id++)
        {
            new Query[500], savingstring[20],string[256];
            format(Query,sizeof(Query),"SELECT * FROM banka WHERE ID =%d",id);
            mysql_query(Query);
            mysql_store_result();
            while(mysql_fetch_row_format(Query,"|"))
            {
            mysql_fetch_field_row(savingstring, "bX"); bInfo[id][bX] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bYY"); bInfo[id][bYY] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bZ"); bInfo[id][bZ] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bIntX"); bInfo[id][bIntX] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bIntY"); bInfo[id][bIntY] = floatstr(savingstring);
	    mysql_fetch_field_row(savingstring, "bIntZ"); bInfo[id][bIntZ] = floatstr(savingstring);
	    mysql_fetch_field_row(savingstring, "bmX"); bInfo[id][bmX] = floatstr(savingstring);
	    mysql_fetch_field_row(savingstring, "bmY"); bInfo[id][bmY] = floatstr(savingstring);
	    mysql_fetch_field_row(savingstring, "bmZ"); bInfo[id][bmZ] = floatstr(savingstring);
	    mysql_fetch_field_row(savingstring, "bInterior"); bInfo[id][bInterior] = strval(savingstring);
	    mysql_fetch_field_row(savingstring, "bVW"); bInfo[id][bVW] = strval(savingstring);
	    mysql_fetch_field_row(savingstring, "bmKreiran"); bInfo[id][bmKreiran] = strval(savingstring);
	    mysql_free_result();
            bkreiranaa++;
	    if(bInfo[id][bKreirana] == 1)
	    {
	    format(string,sizeof(string),"""{FFBB00}Ultra Bank\n\n{FFFFFF}Poslovnica Broj {FFBB00}%d\n\n{FFFFFF}Mesto za velika ulaganja\n\n{FFBB00}Za ulazak pritisnite {FFFFFF}F",id);
            bInfo[id][bLabel] = Create3DTextLabel(string, 0x33CCFFAA,  bInfo[id][bX], bInfo[id][bYY], bInfo[id][bZ],25,0,1);
            bInfo[id][bPickup] = CreateDynamicPickup(19133, 1, bInfo[id][bX], bInfo[id][bYY], bInfo[id][bZ]);
            }
            if(bInfo[id][bmKreiran] == 1)
            {
            format(string,sizeof(string),"""{FFBB00}Ultra Bank Salter\n\n{FFFFFF}Da ga otvorite stisnite {FFBB00}H");
            bInfo[id][bmLabel] = Create3DTextLabel(string, 0x33CCFFAA,  bInfo[id][bmX], bInfo[id][bmY], bInfo[id][bmZ],25,bInfo[id][bVW],1);
            bInfo[id][bmPickup] = CreateDynamicPickup(1239, 1, bInfo[id][bmX], bInfo[id][bmY], bInfo[id][bmZ], bInfo[id][bVW]);
            }
            }
        }
        return 1;
}
Reply
#2

please help
Reply
#3

format(Query,sizeof(Query),"SELECT * FROM banka WHERE ID =%d",id);

change it to

format(Query,sizeof(Query),"SELECT * FROM banka WHERE ID = '%d'",id);
Reply
#4

it wont work i dont know whati s the problem :S
Reply
#5

well I have a system like this but diferent....
pawn Код:
while(mysql_fetch_row_format(Query,"|"))
            {
            mysql_fetch_field_row(savingstring, "bX"); bInfo[id][bX] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bYY"); bInfo[id][bYY] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bZ"); bInfo[id][bZ] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bIntX"); bInfo[id][bIntX] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bIntY"); bInfo[id][bIntY] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bIntZ"); bInfo[id][bIntZ] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bmX"); bInfo[id][bmX] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bmY"); bInfo[id][bmY] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bmZ"); bInfo[id][bmZ] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bInterior"); bInfo[id][bInterior] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "bVW"); bInfo[id][bVW] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "bmKreiran"); bInfo[id][bmKreiran] = strval(savingstring);
        mysql_free_result();
            bkreiranaa++;
        if(bInfo[id][bKreirana] == 1)
        {
        format(string,sizeof(string),"""{FFBB00}Ultra Bank\n\n{FFFFFF}Poslovnica Broj {FFBB00}%d\n\n{FFFFFF}Mesto za velika ulaganja\n\n{FFBB00}Za ulazak pritisnite {FFFFFF}F",id);
            bInfo[id][bLabel] = Create3DTextLabel(string, 0x33CCFFAA,  bInfo[id][bX], bInfo[id][bYY], bInfo[id][bZ],25,0,1);
            bInfo[id][bPickup] = CreateDynamicPickup(19133, 1, bInfo[id][bX], bInfo[id][bYY], bInfo[id][bZ]);
            }
            if(bInfo[id][bmKreiran] == 1)
            {
            format(string,sizeof(string),"""{FFBB00}Ultra Bank Salter\n\n{FFFFFF}Da ga otvorite stisnite {FFBB00}H");
            bInfo[id][bmLabel] = Create3DTextLabel(string, 0x33CCFFAA,  bInfo[id][bmX], bInfo[id][bmY], bInfo[id][bmZ],25,bInfo[id][bVW],1);
            bInfo[id][bmPickup] = CreateDynamicPickup(1239, 1, bInfo[id][bmX], bInfo[id][bmY], bInfo[id][bmZ], bInfo[id][bVW]);
            }
            }
change it to:

pawn Код:
while(mysql_fetch_row_format(Query,"|"))
            {
            mysql_fetch_field_row(savingstring, "bX"); bInfo[id][bX] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bYY"); bInfo[id][bYY] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bZ"); bInfo[id][bZ] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bIntX"); bInfo[id][bIntX] = floatstr(savingstring);
            mysql_fetch_field_row(savingstring, "bIntY"); bInfo[id][bIntY] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bIntZ"); bInfo[id][bIntZ] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bmX"); bInfo[id][bmX] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bmY"); bInfo[id][bmY] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bmZ"); bInfo[id][bmZ] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "bInterior"); bInfo[id][bInterior] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "bVW"); bInfo[id][bVW] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "bmKreiran"); bInfo[id][bmKreiran] = strval(savingstring);
        }
            mysql_free_result();
            bkreiranaa++;
        if(bInfo[id][bKreirana] == 1)
        {
        format(string,sizeof(string),"""{FFBB00}Ultra Bank\n\n{FFFFFF}Poslovnica Broj {FFBB00}%d\n\n{FFFFFF}Mesto za velika ulaganja\n\n{FFBB00}Za ulazak pritisnite {FFFFFF}F",id);
            bInfo[id][bLabel] = Create3DTextLabel(string, 0x33CCFFAA,  bInfo[id][bX], bInfo[id][bYY], bInfo[id][bZ],25,0,1);
            bInfo[id][bPickup] = CreateDynamicPickup(19133, 1, bInfo[id][bX], bInfo[id][bYY], bInfo[id][bZ]);
            }
            if(bInfo[id][bmKreiran] == 1)
            {
            format(string,sizeof(string),"""{FFBB00}Ultra Bank Salter\n\n{FFFFFF}Da ga otvorite stisnite {FFBB00}H");
            bInfo[id][bmLabel] = Create3DTextLabel(string, 0x33CCFFAA,  bInfo[id][bmX], bInfo[id][bmY], bInfo[id][bmZ],25,bInfo[id][bVW],1);
            bInfo[id][bmPickup] = CreateDynamicPickup(1239, 1, bInfo[id][bmX], bInfo[id][bmY], bInfo[id][bmZ], bInfo[id][bVW]);
            }
Reply
#6

its not working mate..
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)