SA-MP Forums Archive
Why it's not working ? - 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: Why it's not working ? (/showthread.php?tid=651573)


Why it's not working ? - Nru - 23.03.2018

I get no error even in the MySQL log file but it's not saving why ?

Код:
stock SaveBankAccounts()
{
	new DB_Query[200];
	for(new i= 1; i <= MAX_BANK_ACCOUNTS; i++)
	{
	    if(bAccount[i][Used])
	    {
	        mysql_format(Database, DB_Query, sizeof(DB_Query),"UPDATE `BANKACCOUNTS` SET `VALUE` = %d WHERE `ID` = %d LIMIT 1",
	        bAccount[i][Value], i);
	        mysql_tquery(Database, DB_Query);
	    }
	}
	return 1;
}
stock SaveBusiness()
{
	new DB_Query[1000];
	for(new i; i < MAX_BUSINESS; i++)
	{
	    if(Business[i][Used])
	    {
			mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `BUSINESS` SET `TYPE` = %d, `PRODUCT` = %d, `FEE` = %d, `SAFE` = %d, `VW` = %d, `INT` = %d, `IINT` = %d, `OWNER` = %d, `PRICE` = %d, `PosX` = %f, `PosY` = %f, `PosZ` = %f, `CpPosX` = %f, `CpPosY` = %f, `CpPosZ` = %f, `IPosX` = %f, `IPosY` = %f, `IPosZ` = %f WHERE `ID` = %d LIMIT 1",
			Business[i][Type],Business[i][Product],Business[i][Fee],Business[i][Safe],Business[i][Vw],Business[i][Int],Business[i][IInt],Business[i][Owner],Business[i][Price],Business[i][PosX],Business[i][PosY],Business[i][PosZ],Business[i][CpPosX],Business[i][CpPosY],Business[i][CpPosZ],Business[i][IPosX],Business[i][IPosY],Business[i][IPosZ],i);
			mysql_tquery(Database, DB_Query);
		}
	}
	return 1;
}


Re: Why it's not working ? - kovac - 23.03.2018

PHP код:
SaveBusiness();
SaveBankAccounts(); 
Do you have this in your command or whatever?

Re: Why it's not working ? - Nru - 23.03.2018

Yes under OnGameModeExit

Re: Why it's not working ? - kovac - 23.03.2018

You're making the same mistake once again, please carefully read something you're told.

PHP код:
for(new i= 1; i <= MAX_BANK_ACCOUNTS; i++) 
If you start the loop with 1, the first row in MySQL won't be read because they start from 0.
And don't put equality sign (=)

Re: Why it's not working ? - Nru - 23.03.2018

And what about the business save ?

EDIT: It didn't work tho..
EDIT: It should start from 1 because the the bankaccounts ID starts with 1 not 0

Re: Why it's not working ? - kovac - 23.03.2018

Try this and if doesn't work, check your server log and see whether the message is printed.
PHP код:
stock SaveBankAccounts()
{
    new query[256];
    for(new i = 1; i < MAX_BANK_ACCOUNTS; i++)
    {
        if(bAccount[i][Used])
        {
            print("Is variable true test");
            mysql_format(Database, query, sizeof(query), "UPDATE `BANKACCOUNTS` SET `VALUE`='%d' WHERE `ID`='%d' LIMIT 1", bAccount[i][Value], i);
            mysql_query(Database, query);
        }
    }
} 
Quote:
Originally Posted by Nru
Посмотреть сообщение
EDIT: It should start from 1 because the the bankaccounts ID starts with 1 not 0
You're right, my bad. Sorry about that.

Re: Why it's not working ? - Nru - 23.03.2018

Quote:
Originally Posted by kovac
Посмотреть сообщение
Try this and if doesn't work, check your server log and see whether the message is printed.
PHP код:
stock SaveBankAccounts()
{
    new query[256];
    for(new i = 1; i < MAX_BANK_ACCOUNTS; i++)
    {
        if(bAccount[i][Used])
        {
            print("Is variable true test");
            mysql_format(Database, query, sizeof(query), "UPDATE `BANKACCOUNTS` SET `VALUE`='%d' WHERE `ID`='%d' LIMIT 1", bAccount[i][Value], i);
            mysql_query(Database, query);
        }
    }
} 

You're right, my bad. Sorry about that.
Thank you it worked fine now +REP <3

Re: Why it's not working ? - kovac - 23.03.2018

Quote:
Originally Posted by Nru
Посмотреть сообщение
Thank you it worked fine now +REP <3
I'm glad, thanks

And then for businesses try this:
PHP код:
stock SaveBusiness()
{
    new query[1000];
    for(new i = 1; i < MAX_BUSINESS; i++)
    {
        if(Business[i][Used])
        {
            mysql_format(query, sizeof(query), "UPDATE `BUSINESS` SET `TYPE`='%d', `PRODUCT`= '%d',`FEE`= '%d', `SAFE`='%d', `VW`='%d', `INT`='%d',`IINT`='%d',`OWNER`='%d', `PRICE`='%d', `PosX`='%f', `PosY`='%f', `PosZ`='%f', `CpPosX`='%f',`CpPosY`='%f', `CpPosZ`= '%f', `IPosX`='%f', `IPosY`='%f',`IPosZ`='%f' WHERE `ID`='%d' LIMIT 1",
            Business[i][Type],Business[i][Product],Business[i][Fee],Business[i][Safe],Business[i][Vw],Business[i][Int],Business[i][IInt],Business[i][Owner],Business[i][Price],Business[i][PosX],Business[i][PosY],Business[i][PosZ],Business[i][CpPosX],Business[i][CpPosY],Business[i][CpPosZ],Business[i][IPosX],Business[i][IPosY],Business[i][IPosZ],i);
            mysql_query(Database, query);
        }
    }
}