SQL & loop problem - Printable Version

SQL & loop problem - 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: SQL & loop problem (/showthread.php?tid=596262)

SQL & loop problem - TwinkiDaBoss - 15.12.2015

Alright so the problem is quite simple, it saves factory data for 2-3 but not for 1

PHP код:



public OnFactoryLoad()

{

    new rows, fields;

    cache_get_data(rows, fields, mysql);

    if(rows)

    {

        for(new i = 1; i < rows && i < MAX_FACTORIES; i++)

        {

            FactoryData[i][FactoryID] = cache_get_field_content_int(i,"ID");

            FactoryData[i][FactoryResources] = cache_get_field_content_int(i,"Resources");

        }

    }

    return true;

}


SaveFactories() {

    new query[128];

    for(new x = 1; x < MAX_FACTORIES; x++) {

        mysql_format(mysql, query, sizeof(query), "UPDATE `factories` SET `Resources`=%f WHERE `ID`=%d",\

        FactoryData[x][FactoryResources],FactoryData[x][FactoryID]);

    }

    return true;

}



CMD:test(playerid,params[]) {

    FactoryData[1][FactoryResources] = 500;

    FactoryData[2][FactoryResources] = 6520;

    FactoryData[3][FactoryResources] = 3000;

    return true;

}

Re: SQL & loop problem - zPain - 15.12.2015

Shouldn't the loops start at 0?

PHP код:



for(new i = 0; i < rows && i < MAX_FACTORIES; i++)

PHP код:



for(new x = 0; x < MAX_FACTORIES; x++)

Re: SQL & loop problem - TwinkiDaBoss - 15.12.2015

Quote:

Originally Posted by zPain

Shouldn't the loops start at 0?

PHP код:



for(new i = 0; i < rows && i < MAX_FACTORIES; i++)

PHP код:



for(new x = 0; x < MAX_FACTORIES; x++)

nah, the problem aint that, I dont want of it to start at 0. Basically the IDS are going from 1 inside the setup I made.
Also tried to test with 0 for fun, still nothing

Re: SQL & loop problem - zPain - 15.12.2015

Regardless, if you start fetching the results from row 1, you'll be actually starting from the second row.

Edit: Did you notice that the query wasn't submitted in the SaveFactories function?

Re: SQL & loop problem - TwinkiDaBoss - 15.12.2015

Yeah but still row 1 is set as NULL

PHP код:



[04:02:30] [DEBUG] Calling callback "OnFactoryLoad"..

[04:02:30] [DEBUG] cache_get_data - connection: 1

[04:02:30] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1

[04:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"

[04:02:30] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Resources", connection: 1

[04:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Resources", data: "NULL"

[04:02:30] [ERROR] cache_get_field_content_int - invalid datatype

[04:02:30] [DEBUG] cache_get_field_content_int - row: 1, field_name: "ID", connection: 1

[04:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ID", data: "2"

[04:02:30] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Resources", connection: 1

[04:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Resources", data: "6520"

[04:02:30] [DEBUG] cache_get_field_content_int - row: 2, field_name: "ID", connection: 1

[04:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "ID", data: "3"

[04:02:30] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Resources", connection: 1

[04:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Resources", data: "3000"

[04:02:30] [DEBUG] cache_get_field_content_int - row: 3, field_name: "ID", connection: 1

I fixed the prob with invalid datatype
I was using int instead of float but still the problem remains

EDIT: SA:MP log

PHP код:



[04:14:19] UPDATE `factories` SET `Resources`=500.0 WHERE `ID`=1

[04:14:19] UPDATE `factories` SET `Resources`=6520.0 WHERE `ID`=2

[04:14:19] UPDATE `factories` SET `Resources`=3000.0 WHERE `ID`=3

It prints as it should be but still not saving the ID 1 at all

EDIT 2: new SQL log

PHP код:



[04:28:15] [DEBUG] Calling callback "OnFactoryLoad"..

[04:28:15] [DEBUG] cache_get_data - connection: 1

[04:28:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1

[04:28:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"

[04:28:15] [DEBUG] cache_get_field_content_float - row: 0, field_name: "Resources", connection: 1

[04:28:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Resources", data: "000000000000"

[04:28:15] [DEBUG] cache_get_field_content_int - row: 1, field_name: "ID", connection: 1

[04:28:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ID", data: "2"

[04:28:15] [DEBUG] cache_get_field_content_float - row: 1, field_name: "Resources", connection: 1

[04:28:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Resources", data: "000000006520"

[04:28:15] [DEBUG] cache_get_field_content_int - row: 2, field_name: "ID", connection: 1

[04:28:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "ID", data: "3"

[04:28:15] [DEBUG] cache_get_field_content_float - row: 2, field_name: "Resources", connection: 1

[04:28:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Resources", data: "000000003000"

Re: SQL & loop problem - zPain - 15.12.2015

PHP код:



[04:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"

I still think the problem is about the index (0-1) matter. Otherwise, you should share more of the source code with us.

Re: SQL & loop problem - TwinkiDaBoss - 15.12.2015

Quote:

Originally Posted by zPain

PHP код:



[04:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"

I still think the problem is about the index (0-1) matter. Otherwise, you should share more of the source code with us.

Well that is the actual full code mate, nothing besides it really.
This is the only thing left to share to be honest

PHP код:



CREATE TABLE `factories` (

    `ID` INT(10) NOT NULL AUTO_INCREMENT,

    `Name` VARCHAR(50) NULL DEFAULT NULL,

    `Resources` FLOAT UNSIGNED ZEROFILL NULL DEFAULT '000000000000',

    PRIMARY KEY (`ID`)

)

COLLATE='latin1_swedish_ci'

ENGINE=InnoDB

AUTO_INCREMENT=11

;

Re: SQL & loop problem - Vince - 15.12.2015

You're overlooking the fact that the query is not even sent to the server. You're formatting it, but it's not actually being sent.

Re: SQL & loop problem - vassilis - 15.12.2015

Quote:

Originally Posted by TwinkiDaBoss

Alright so the problem is quite simple, it saves factory data for 2-3 but not for 1

PHP код:



public OnFactoryLoad()

{

    new rows, fields;

    cache_get_data(rows, fields, mysql);

    if(rows)

    {

        for(new i = 1; i < rows && i < MAX_FACTORIES; i++)

        {

            FactoryData[i][FactoryID] = cache_get_field_content_int(i,"ID");

            FactoryData[i][FactoryResources] = cache_get_field_content_int(i,"Resources");

        }

    }

    return true;

}


SaveFactories() {

    new query[128];

    for(new x = 1; x < MAX_FACTORIES; x++) {

        mysql_format(mysql, query, sizeof(query), "UPDATE `factories` SET `Resources`=%f WHERE `ID`=%d",\

        FactoryData[x][FactoryResources],FactoryData[x][FactoryID]);

    }

    return true;

}



CMD:test(playerid,params[]) {

    FactoryData[1][FactoryResources] = 500;

    FactoryData[2][FactoryResources] = 6520;

    FactoryData[3][FactoryResources] = 3000;

    return true;

}

How you demand the table to be updated when you format but doesn't send the query?

PHP код:



        mysql_format(mysql, query, sizeof(query), "UPDATE `factories` SET `Resources`=%f WHERE `ID`=%d",\

        FactoryData[x][FactoryResources],FactoryData[x][FactoryID]);

                mysql_tquery(mysql,query);

Re: SQL & loop problem - TwinkiDaBoss - 15.12.2015

Quote:

Originally Posted by vassilis

How you demand the table to be updated when you format but doesn't send the query?

PHP код:



        mysql_format(mysql, query, sizeof(query), "UPDATE `factories` SET `Resources`=%f WHERE `ID`=%d",\

        FactoryData[x][FactoryResources],FactoryData[x][FactoryID]);

                mysql_tquery(mysql,query);

I havent included this part

PHP код:



mysql_tquery(mysql, "SELECT * FROM `factories`", "OnFactoryLoad", "");