MySQL plugin R39-3 // cache, bad loading

MySQL plugin R39-3 // cache, bad loading - 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 plugin R39-3 // cache, bad loading (/showthread.php?tid=604030)

MySQL plugin R39-3 // cache, bad loading - bogushas - 30.03.2016

This is the stock im using on gamemodeinit();

PHP код:



stock LoadFirms()

{

    new string[61], string2[61];

    printf("LOADING");

    mysql_format(dbHandle,g_szBuffer, 500,"SELECT * FROM `firms`");

    new Cache:result=mysql_query(dbHandle,g_szBuffer);

    printf("%d\n",cache_get_row_count());

    for(new i; i < cache_get_row_count(); i++){

        firma[ i ][ idas ] = cache_get_field_content_int(i, "ID");


        cache_get_field_content(i,"name", string, dbHandle, 60);

        format(firma[ i ][ name ], 59,"%s", string);

        printf("%s  1\n", string);

        cache_get_field_content(i,"place", string2, dbHandle, 60);

        format(firma[ i ][ place ], 59,"%s", string2);

        printf("%s  2\n", string2);


        firma[ i ][ pos ][ 0 ] = cache_get_field_content_float(i,"x");

        firma[ i ][ pos ][ 1 ] = cache_get_field_content_float(i,"y");

        firma[ i ][ pos ][ 2 ] = cache_get_field_content_float(i,"z");

        firma[ i ][ Owned ] = cache_get_field_content_int(i, "owned");

        printf("%i OWNED\n", firma[ i ][ Owned ]);



        cache_get_field_content(i,"owner",firma[ i ][Owner], dbHandle, 25);

        printf("%s OWNER\n", firma[ i ][Owner]);


        firma[ i ][ price ] = cache_get_field_content_int(i, "price");

        printf("%i KAINA\n", firma[ i ][ price ]);

        firma[ i ][ workers ][ 0 ] = cache_get_field_content_int(i, "workers");

        printf("%i DARBUOTOJAI\n", firma[ i ][ workers ][ 0 ]);

        firma[ i ][ workers ][ 1 ] = cache_get_field_content_int(i, "workerslimit");

        printf("%i DARBUOTOJAI 1\n", firma[ i ][ workers ][ 1 ]);

        firma[ i ][ workers ][ 2 ] = cache_get_field_content_int(i, "workersAccepting");

        printf("%i ISIDARBINIMAS\n", firma[ i ][ workers ][ 2 ]);

        firma[ i ][ profit ] = cache_get_field_content_int(i, "profit");

        printf("%i PROFIT\n", firma[ i ][ profit ]);

        firma[ i ][ contractTime ] = cache_get_field_content_int(i, "contract");

        printf("%i KONTRAKT\n", firma[ i ][ contractTime ]);


        if(firma[ i ][ Owned ])

        {

            new priemimas[70];

            switch(firma[ i ][ workers ][ 2 ]){

                case 0: format(priemimas, sizeof(priemimas), "{69B86E}įsidarbinimas leidћiamas{B89769}");

                case 1: format(priemimas, sizeof(priemimas), "{B87669}įsidarbinimas draudћiamas{B89769}");

            }

            format( g_szBuffer, 600,"{B89769}%s{ffffff} firma,\n \n{B89769}%s{ffffff}\n{B89769}%s{ffffff} firmos savininkas\n{B89769}%i (  ){ffffff} laisvos darbo vietos\n{B89769}%s{ffffff} darbo kontrakto laikas",firma[ i ][ name ],firma[ i ][ place ],firma[ i ][Owner],(firma[ i ][ workers ][ 1 ]-firma[ i ][ workers ][ 0 ]), priemimas, ConvertSeconds(firma[ i ][ contractTime ]));

            firma[ i ][ firmLabel ] = Create3DTextLabel( g_szBuffer, 0xFFFFFFF, firma[ i ][ pos ][ 0 ],firma[ i ][ pos ][ 1 ],firma[ i ][ pos ][ 2 ], 30, 0, 1 )    ;

            firma[ i ][ pickup ] = CreateDynamicPickup( 1275, 1, firma[ i ][ pos ][ 0 ],firma[ i ][ pos ][ 1 ],firma[ i ][ pos ][ 2 ]);

        }

        else

        {

            format( g_szBuffer, 600,"{B89769}%s{ffffff} firma,\n \n{B89769}%s{ffffff}\n{B89769}%i "EURAS"{ffffff} firmos kaina\n \nNorėdami pirkti firmą spauskite {B89769}ENTER",firma[ i ][ name ],firma[ i ][ place ],firma[ i ][ price ]);

            firma[ i ][ firmLabel ] = Create3DTextLabel( g_szBuffer, 0xFFFFFFF, firma[ i ][ pos ][ 0 ],firma[ i ][ pos ][ 1 ],firma[ i ][ pos ][ 2 ], 30, 0, 1 )    ;

            firma[ i ][ pickup ] = CreateDynamicPickup( 1275, 1, firma[ i ][ pos ][ 0 ],firma[ i ][ pos ][ 1 ],firma[ i ][ pos ][ 2 ]);

        }

        printf("%s %s uћkrauta\n", firma[ i ][ name ],firma[ i ][ place ]);

        printf("X : %0.3f Y : %0.3f Z : %0.3f uћkrauta\n", firma[ i ][ pos ][ 0 ],firma[ i ][ pos ][ 1 ],firma[ i ][ pos ][ 2 ]);

        cache_delete(result);

    }

}

This code fails to load some things, the connection some how drops down or something happens.

The logs of mysql and server prints:

PHP код:



[21:30:32] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.458 milliseconds

[21:30:32] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:30:32] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)

[21:30:32] [DEBUG] cache_get_row_count - connection: 1

[21:30:32] [DEBUG] cache_get_row_count - connection: 1

[21:30:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "0"

[21:30:32] [DEBUG] cache_get_field_content - row: 0, field_name: "name", connection: 1, max_len: 60

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "name", data: "Blueberry transport shipping"

[21:30:32] [DEBUG] cache_get_field_content - row: 0, field_name: "place", connection: 1, max_len: 60

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "place", data: "Blueberry village"

[21:30:32] [DEBUG] cache_get_field_content_float - row: 0, field_name: "x", connection: 1

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "x", data: "-49.8717"

[21:30:32] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

 1

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "y", data: "-269.363"

[21:30:32] [DEBUG] cache_get_field_content_float - row: 0, field_name: "z", connection: 1

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "z", data: "6.6332"

[21:30:32] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

n: 1

[21:30:32] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "owned", data: "0"

[21:30:32] [DEBUG] cache_get_field_content - row: 0, field_name: "village", connection: 1, max_len: 25

[21:30:32] [WARNING] CMySQLResult::GetRowDataByName - field not found ("village")

[21:30:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "price", connection: 1

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "price", data: "5000"

[21:30:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "workers", connection: 1

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "workers", data: "0"

[21:30:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ULL", connection: 1

[21:30:32] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ULL")

[21:30:32] [ERROR] cache_get_field_content_int - invalid datatype

[21:30:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "workersAccepting", connection: 1

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "workersAccepting", data: "0"

[21:30:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "profit", connection: 1

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "profit", data: "0"

[21:30:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "contract", connection: 1

[21:30:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "contract", data: "36000"

[21:30:32] [DEBUG] CMySQLConnection::Connect - connection was successful

[21:30:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[21:30:32] [DEBUG] CMySQLConnection::Connect - connection was successful

[21:30:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[21:30:32] [DEBUG] CMySQLConnection::Connect - connection was successful

[21:30:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[21:30:32] [DEBUG] cache_delete - cache_id: 1, connection: 1

[21:30:32] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[21:30:32] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted

[21:30:32] [DEBUG] cache_get_row_count - connection: 1

[21:30:32] [WARNING] cache_get_row_count - no active cache


[21:30:32] LOADING

[21:30:32] 1


[21:30:32] ing

[21:30:32] Blueberry village  2


[21:30:32] Blueberry village

[21:30:32] e

[21:30:32] 5000 KAINA


[21:30:32] 0 DARBUOT&#159;w-I

[21:30:32] 0 DARBUOTO&#136;

[21:30:32] 0 ISIDARBINIMAS


[21:30:32] 0 PROFIT


[21:30:32] 36000 KONTRAKT


[21:30:32] Blueberry transport shipping Blueberry village uћkrauta


[21:30:32] X : -49.871 Y : -269.363 Z : 6.633 uћkrauta


[21:30:32] 







[21:31:19] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "truckmania", password: "****", port: 3306, autoreconnect: true, pool_size: 2

[21:31:19] [DEBUG] CMySQLHandle::Create - creating new connection..

[21:31:19] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called

[21:31:19] [DEBUG] CMySQLHandle::Create - connection created (id: 1)

[21:31:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[21:31:19] [DEBUG] CMySQLConnection::Connect - connection was successful

[21:31:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[21:31:19] [DEBUG] mysql_format - connection: 1, len: 500, format: "SELECT * FROM `firms`"

[21:31:19] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `firms`", use_cache: true

[21:31:19] [DEBUG] CMySQLQuery::Execute - starting query execution

[21:31:19] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.438 milliseconds

[21:31:19] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:31:19] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)

[21:31:19] [DEBUG] cache_get_row_count - connection: 1

[21:31:19] [DEBUG] cache_get_row_count - connection: 1

[21:31:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "0"

[21:31:19] [DEBUG] cache_get_field_content - row: 0, field_name: "name", connection: 1, max_len: 60

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "name", data: "Blueberry transport shipping"

[21:31:19] [DEBUG] cache_get_field_content - row: 0, field_name: "place", connection: 1, max_len: 60

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "place", data: "Blueberry village"

[21:31:19] [DEBUG] cache_get_field_content_float - row: 0, field_name: "x", connection: 1

[21:31:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[21:31:19] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "x", data: "-49.8717"

[21:31:19] [DEBUG] cache_get_field_content_float - row: 0, field_name: "y", connection: 1

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "y", data: "-269.363"

[21:31:19] [DEBUG] cache_get_field_content_float - row: 0, field_name: "z", connection: 1

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "z", data: "6.6332"

[21:31:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "owned", connection: 1

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "owned", data: "0"

[21:31:19] [DEBUG] cache_get_field_content - row: 0, field_name: "village", connection: 1, max_len: 25

[21:31:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("village")

[21:31:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "price", connection: 1

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "price", data: "5000"

[21:31:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "workers", connection: 1

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "workers", data: "0"

[21:31:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ULL", connection: 1

[21:31:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ULL")

[21:31:19] [ERROR] cache_get_field_content_int - invalid datatype

[21:31:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "workersAccepting", connection: 1

[21:31:19] [DEBUG] CMySQLConnection::Connect - connection was successful

ersAccepting", data: "0"

[21:31:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[21:31:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "profit", connection: 1

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "profit", data: "0"

[21:31:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "contract", connection: 1

[21:31:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "contract", data: "36000"

[21:31:19] [DEBUG] cache_delete - cache_id: 1, connection: 1

[21:31:19] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[21:31:19] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted

[21:31:19] [DEBUG] cache_get_row_count - connection: 1

[21:31:19] [WARNING] cache_get_row_count - no active cache

[21:31:19] [DEBUG] CMySQLConnection::Connect - connection was successful

[21:31:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[21:31:19] [DEBUG] CMySQLConnection::Connect - connection was successful

[21:31:19] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled




[21:31:19] LOADING

[21:31:19] 1


[21:31:19] ing

[21:31:19] Blueberry village  2


[21:31:19] Blueberry village

[21:31:19] e

[21:31:19] 5000 KAINA


[21:31:19] 0 DARBUOTw-I

[21:31:19] 0 DARBUOTO

[21:31:19] 0 ISIDARBINIMAS


[21:31:19] 0 PROFIT


[21:31:19] 36000 KONTRAKT


[21:31:19] Blueberry transport shipping Blueberry village uћkrauta


[21:31:19] X : -49.871 Y : -269.363 Z : 6.633 uћkrauta


[21:31:19]

Re: MySQL plugin R39-3 // cache, bad loading - IstuntmanI - 30.03.2016

Put

pawn Код:

cache_delete(result);

after }, not before it. This happened because you deleted the result right when the reading of the first row finished.

Also, replace

pawn Код:

for(new i; i < cache_get_row_count(); i++){

with

pawn Код:

for(new i, j = cache_get_row_count(); i < j; i++){