mysql help - Printable Version

mysql help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql help (/showthread.php?tid=502917)

mysql help - GrandMasterX - 26.03.2014

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;
}

Re: mysql help - GrandMasterX - 26.03.2014

please help

Re: mysql help - TheFlyer - 26.03.2014

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);

Re: mysql help - GrandMasterX - 26.03.2014

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

Re: mysql help - TheFlyer - 26.03.2014

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]);
            }

Re: mysql help - GrandMasterX - 26.03.2014

its not working mate..