1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MySQL loading
Ahmed21
Big Clucker
***
Posts: 158
Threads: 50
Joined: Jul 2016
Reputation: 0
#1

26.07.2016, 18:24
Hello everyone, I've made houses system based on a MySQL table.

So my problem is that, my house stops loading houses after loading an owned house.
Example: House ID 0 isn't owned. House ID 1 isn't owned. House ID 2 is owned. House ID 3 is not owned.

My script loads ID 0 and 1 and 2, but it doesn't load the 3rd one because an owned house was loaded before. (House ID 2)

Another example: house ID 0 isn't owned. House ID 1 is owned, house ID 2 isn't owned.
It will load ID 0, then ID 1 but it won't load ID 2 because an owned house was loaded before (House ID 1)

And if the first house in the table is owned, it will load it ONLY, it won't load the other houses on the table.
I'm serious and I can't find the bug, here's my loading script:

So in short, here's the problem: It keeps loading houses, and when the system loads an owned house, it will stop loading, it's like the owned house is the last house in the table.
PHP код:
forward LoadHouses();
public LoadHouses()
{
    new rows, fields;
     cache_get_data(rows, fields, mysql);
    if(rows)
    {
        new housepw[4], housetitle[MAX_HOUSE_NAME];
        for(new i = 0; i < cache_get_row_count(); i++)
        {
            hInfo[i][hID] = cache_get_row_int(i, 0);
            cache_get_row(i, 2, housetitle);
            cache_get_row(i, 3, housepw);
            
            hInfo[i][hOwner] = cache_get_row_int(i, 1);
            hInfo[i][hInterior] = cache_get_row_int(i, 10);
            hInfo[i][hPrice] = cache_get_row_int(i, 11);
            hInfo[i][hEnterX] = cache_get_row_float(i, 4);
            hInfo[i][hEnterY] = cache_get_row_float(i, 5);
            hInfo[i][hEnterZ] = cache_get_row_float(i, 6);
            hInfo[i][hExitX] = cache_get_row_float(i, 7);
            hInfo[i][hExitY] = cache_get_row_float(i, 8);
            hInfo[i][hExitZ] = cache_get_row_float(i, 9);
            hInfo[i][hTitle] = housetitle;
            hInfo[i][hPassword] = housepw;
            hInfo[i][hWorldID] = hInfo[i][hID];
            
            new hEntStr[200];
            if(hInfo[i][hOwner] == -1)
            {
                format(hEntStr, sizeof(hEntStr), ""COL_GOLD"House: "COL_WHITE"%s(%d)\n"COL_GOLD"Owner: "COL_WHITE"No-one\n"COL_GOLD"Price: "COL_WHITE"$%s", hInfo[i][hTitle], i, AC(hInfo[i][hPrice]));
            }
            else if(hInfo[i][hOwner] != -1)
            {
                format(hEntStr, sizeof(hEntStr), ""COL_GOLD"House: "COL_WHITE"%s(%d)\n"COL_GOLD"Owner: "COL_WHITE"%s\n"COL_GOLD"Price: "COL_WHITE"$%s", hInfo[i][hTitle], i, GetNameFromMySQLID(hInfo[i][hOwner]), AC(hInfo[i][hPrice]));
            }
            hInfo[i][sEnterLabel] = CreateDynamic3DTextLabel(hEntStr, -1, hInfo[i][hEnterX], hInfo[i][hEnterY], hInfo[i][hEnterZ], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, 0, -1, 100.0);
            hInfo[i][sExitLabel] = CreateDynamic3DTextLabel(""COL_GOLD"[EXIT]", -1, hInfo[i][hExitX], hInfo[i][hExitY], hInfo[i][hExitZ], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, hInfo[i][hWorldID], hInfo[i][hInterior], -1, 100.0);
            hInfo[i][hEnterCP] = CreateDynamicCP(hInfo[i][hEnterX], hInfo[i][hEnterY], hInfo[i][hEnterZ], 1.0, -1, 0, -1, 100.0);
            hInfo[i][hExitCP] = CreateDynamicCP(hInfo[i][hExitX], hInfo[i][hExitY], hInfo[i][hExitZ], 1.0, hInfo[i][hWorldID], hInfo[i][hInterior], -1, 100.0);
               LoadedHouses++;
        }
        printf("Loaded %d houses", LoadedHouses);
    }
    else if(!rows)
    {
        printf("There are NO houses to load");
    }
    return 1;
} 
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#2

26.07.2016, 18:36
You could have posted in your old thread as it is related to the houses.

Anyway, load crashdetect plugin and compile with debug info:
https://github.com/Zeex/samp-plugin-...etect/releases
https://github.com/Zeex/samp-plugin-...ith-debug-info

The problem is probably in one of these two functions: GetNameFromMySQLID and AC.

---

You forgot to replace with:
pawn Код:
for(new i = 0; i < rows; i++)
to avoid calling cache_get_row_count many times and declare "hEntStr" out of the loop.
Find
Reply
Ahmed21
Big Clucker
***
Posts: 158
Threads: 50
Joined: Jul 2016
Reputation: 0
#3

26.07.2016, 18:44
Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
You could have posted in your old thread as it is related to the houses.

Anyway, load crashdetect plugin and compile with debug info:
https://github.com/Zeex/samp-plugin-...etect/releases
https://github.com/Zeex/samp-plugin-...ith-debug-info

The problem is probably in one of these two functions: GetNameFromMySQLID and AC.

---

You forgot to replace with:
pawn Код:
for(new i = 0; i < rows; i++)
to avoid calling cache_get_row_count many times and declare "hEntStr" out of the loop.
crashdetect isn't showing anything wrong, even that printf, if I make the first house owned, printf says: "loaded one house" while having 10 other houses on the table.

So ..?
Find
Reply
Ahmed21
Big Clucker
***
Posts: 158
Threads: 50
Joined: Jul 2016
Reputation: 0
#4

26.07.2016, 18:50
Here's my AC function -- it's to format a number, example: AC(5000) returns 5,000;

PHP код:
stock AC(number, const separator[] = ",")
{
    new output[15];
    format(output, sizeof(output), "%d", number);
    for(new i = strlen(output) - 3; i > 0 && output[i-1] != '-'; i -= 3)
    {
        strins(output, separator, i);
    }
    return output;
} 
And here's my GetNameFromMySQLID
PHP код:
stock GetNameFromMySQLID(sqlid)
{
    new query[128], name[24], lelo[24], count;
    mysql_format(mysql, query, sizeof(query), "SELECT * FROM `accounts` WHERE ID = %d LIMIT 1", sqlid);
    new Cache:result = mysql_query(mysql, query);
    count = cache_get_row_count();
    cache_get_row_count();
    cache_get_row(0, 1, lelo);
    cache_delete(result);
    name = lelo;
    if(count < 1)
    {
        name = "0";
        return name;
    }
    return name;
} 
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#5

26.07.2016, 19:24
It gets more tricky right now since crashdetect did not report anything. I've seen similar thing once but was a bug with NULL from the plugin - not sure in which version it was and what version you are using.

Let's begin by debugging it manually to see where it stops:
pawn Код:
new rows, fields; 
cache_get_data(rows, fields, mysql); 
printf("rows: %i", rows);
pawn Код:
hInfo[i][hID] = cache_get_row_int(i, 0); 
printf("hInfo[%i][hID] = %i", i, hInfo[i][hID]);
cache_get_row(i, 2, housetitle); 
printf("housetitle: %s", housetitle);
cache_get_row(i, 3, housepw); 
printf("housepw: %s", housepw);
            
hInfo[i][hOwner] = cache_get_row_int(i, 1); 
printf("hInfo[i][Owner] = %i", hInfo[i][hOwner]);
hInfo[i][hInterior] = cache_get_row_int(i, 10);
printf("hInfo[i][hInterior] = %i", hInfo[i][hInterior]);
and so on, continue the rest (print every line).

---

Something I forgot to mention the previous times is what happens when there are more rows that the size of the hInfo array. In this case, you don't have any run time error as crashdetect did not report anything but we gotta prevent it in case it happens in the future.

pawn Код:
for(new i = 0; i < rows; i++) 
{
    if (i == sizeof hInfo)
    {
        printf("House limit (%i) was reached. %i rows returned.", sizeof hInfo, rows);
        break; // stop the loop
    }

    hInfo[i][hID] = cache_get_row_int(i, 0);
    ...
---

The player's name can be selected in the same query you select all the data but let's leave it out for now to fix the issue first. At least use this version:
PHP код:
GetNameFromMySQLID(sqlid)
{
    // Don't select all the data, just the column for the name. Modify to match your table's structure
  
    new query[50];
    mysql_format(mysql, query, sizeof(query), "SELECT Name FROM accounts WHERE ID = %d LIMIT 1", sqlid);  
    new Cache: result = mysql_query(mysql, query);
  
    if (cache_get_row_count()) cache_get_row(0, 0, query);
    else query = "0";
  
    cache_delete(result);
    return query;
} 
Find
Reply
PrO.GameR
Gangsta
****
Posts: 694
Threads: 2
Joined: Oct 2012
Reputation: 0
#6

26.07.2016, 22:13
Tbh I'm not sure how crashdetect reported nothing, that loop most certainly crashes if it doesn't create any labels and stuff
However as Konstantinos suggested, you need to manually debug it to see where it actually stops and whats the value it stops at.
Find
Reply
Ahmed21
Big Clucker
***
Posts: 158
Threads: 50
Joined: Jul 2016
Reputation: 0
#7

27.07.2016, 07:17
There is "if hOwner != 1." The bug is in that "if" function. I think it is because the getNameFromMysqlid function, anyway i will test the function u given me @Konstantinos and thanks both for da help.
Find
Reply
Ahmed21
Big Clucker
***
Posts: 158
Threads: 50
Joined: Jul 2016
Reputation: 0
#8

27.07.2016, 09:35
So, this is what I done, and now, when it loads an owned house, it sets the owner name to NULL and stops loading after loading an owned house:

I've tried to let the system show the owner acc ID, not name, and it worked well and it didn't stop loading after an owned house, but when I added that mysql shit, it stopped again.

Focus to that if(hInfo[i][hOwner] != -1) ..
PHP код:
forward LoadHouses();
public LoadHouses()
{
    new rows, fields;
     cache_get_data(rows, fields, mysql);
    if(rows)
    {
        new housepw[4], housetitle[MAX_HOUSE_NAME];
        for(new i = 0; i < rows; i++)
        {
            hInfo[i][hID] = cache_get_row_int(i, 0);
            cache_get_row(i, 2, housetitle);
            cache_get_row(i, 3, housepw);
            
            hInfo[i][hOwner] = cache_get_row_int(i, 1);
            hInfo[i][hInterior] = cache_get_row_int(i, 10);
            hInfo[i][hPrice] = cache_get_row_int(i, 11);
            hInfo[i][hEnterX] = cache_get_row_float(i, 4);
            hInfo[i][hEnterY] = cache_get_row_float(i, 5);
            hInfo[i][hEnterZ] = cache_get_row_float(i, 6);
            hInfo[i][hExitX] = cache_get_row_float(i, 7);
            hInfo[i][hExitY] = cache_get_row_float(i, 8);
            hInfo[i][hExitZ] = cache_get_row_float(i, 9);
            hInfo[i][hTitle] = housetitle;
            hInfo[i][hPassword] = housepw;
            hInfo[i][hWorldID] = hInfo[i][hID];
            
            new hEntStr[200];
            if(hInfo[i][hOwner] == -1)
            {
                format(hEntStr, sizeof(hEntStr), ""COL_GOLD"House: "COL_WHITE"%s(%d)\n"COL_GOLD"Owner: "COL_WHITE"No-one\n"COL_GOLD"Price: "COL_WHITE"$%s", hInfo[i][hTitle], i, AC(hInfo[i][hPrice]));
            }
            else if(hInfo[i][hOwner] != -1)
            {
                   new query[50];
                mysql_format(mysql, query, sizeof(query), "SELECT Name FROM accounts WHERE ID = %d LIMIT 1", hInfo[i][hOwner]);
                new Cache: result = mysql_query(mysql, query);
                if (cache_get_row_count()) cache_get_row(0, 1, query);
                cache_delete(result);
                format(hEntStr, sizeof(hEntStr), ""COL_GOLD"House: "COL_WHITE"%s(%d)\n"COL_GOLD"Owner: "COL_WHITE"%s\n"COL_GOLD"Price: "COL_WHITE"$%s", hInfo[i][hTitle], i, query, AC(hInfo[i][hPrice]));
            }
            hInfo[i][sEnterLabel] = CreateDynamic3DTextLabel(hEntStr, -1, hInfo[i][hEnterX], hInfo[i][hEnterY], hInfo[i][hEnterZ], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, 0, -1, 100.0);
            hInfo[i][sExitLabel] = CreateDynamic3DTextLabel(""COL_GOLD"[EXIT]", -1, hInfo[i][hExitX], hInfo[i][hExitY], hInfo[i][hExitZ], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, hInfo[i][hWorldID], hInfo[i][hInterior], -1, 100.0);
            hInfo[i][hEnterCP] = CreateDynamicCP(hInfo[i][hEnterX], hInfo[i][hEnterY], hInfo[i][hEnterZ], 1.0, -1, 0, -1, 100.0);
            hInfo[i][hExitCP] = CreateDynamicCP(hInfo[i][hExitX], hInfo[i][hExitY], hInfo[i][hExitZ], 1.0, hInfo[i][hWorldID], hInfo[i][hInterior], -1, 100.0);
               LoadedHouses++;
        }
        printf("Loaded %d houses", LoadedHouses);
    }
    else if(!rows)
    {
        printf("There are NO houses to load");
    }
    return 1;
} 
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#9

27.07.2016, 09:40
Код:
if (cache_get_row_count()) cache_get_row(0, 0, query);
Field IDs start from 0.

Can you enable LOG_ALL, remove anything written in mysql logs and let it load the houses? Afterwards, post your mysql logs.
Find
Reply
Ahmed21
Big Clucker
***
Posts: 158
Threads: 50
Joined: Jul 2016
Reputation: 0
#10

27.07.2016, 09:54
Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
Код:
if (cache_get_row_count()) cache_get_row(0, 0, query);
Field IDs start from 0.

Can you enable LOG_ALL, remove anything written in mysql logs and let it load the houses? Afterwards, post your mysql logs.
Well, printf says loaded 10 houses but it loaded only the first because it's owned.

I removed the whole logs and made the file empty, and restarted the server, and here you are:

PHP код:
[05:50:04] [DEBUG] mysql_connect - host: "localhost", user: "f3413_ahcnr", database: "f3413_ahcnr", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[05:50:04] [DEBUG] CMySQLHandle::Create - creating new connection..
[05:50:04] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[05:50:04] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[05:50:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[05:50:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[05:50:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[05:50:04] [DEBUG] mysql_errno - connection: 1
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM stores"
[05:50:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM stores", callback: "LoadStores", format: "(null)"
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM houses"
[05:50:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM houses", callback: "LoadHouses", format: "(null)"
[05:50:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[05:50:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[05:50:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[05:50:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[05:50:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[05:50:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[05:50:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[05:50:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[05:50:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[05:50:04] [DEBUG] CMySQLQuery::Execute[LoadStores] - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute[LoadStores] - query was successfully executed within 0.51 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLQuery::Execute[LoadHouses] - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute[LoadHouses] - query was successfully executed within 0.211 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] Calling callback "LoadStores"..
[05:50:04] [DEBUG] cache_get_data - connection: 1
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 0, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "2"
[05:50:04] [DEBUG] cache_get_row - row: 0, field_idx: 1, connection: 1, max_len: 100
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "beloBolo"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 11, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '11', data: "51"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 12, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '12', data: "15"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 14, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '14', data: "5"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 13, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '13', data: "29"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 2, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '2', data: "-1808.61"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 3, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "945.813"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 4, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "24.8906"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 5, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "372.355"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 6, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "-133.523"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 7, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "1001.49"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 8, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "377.601"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 9, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '9', data: "-113.971"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 10, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '10', data: "1001.49"
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 0, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '0', data: "3"
[05:50:04] [DEBUG] cache_get_row - row: 1, field_idx: 1, connection: 1, max_len: 100
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '1', data: "Victim"
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 11, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '11', data: "5000"
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 12, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '12', data: "2500"
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 14, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '14', data: "5"
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 13, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '13', data: "45"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 2, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '2', data: "-1694.58"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 3, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '3', data: "951.918"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 4, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '4', data: "24.8906"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 5, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '5', data: "227.563"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 6, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '6', data: "-8.1016"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 7, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '7', data: "1002.21"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 8, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '8', data: "204.854"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 9, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '9', data: "-7.8775"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 10, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '10', data: "1001.21"
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] Calling callback "LoadHouses"..
[05:50:04] [DEBUG] cache_get_data - connection: 1
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 0, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "33"
[05:50:04] [DEBUG] cache_get_row - row: 0, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '2', data: "Home"
[05:50:04] [DEBUG] cache_get_row - row: 0, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "N/A"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "3"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 10, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '10', data: "2"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 11, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '11', data: "1337"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 4, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "-1780.6"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 5, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "901.42"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 6, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "25.219"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 7, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "266.499"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 8, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "304.978"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 9, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '9', data: "999.148"
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 3 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.66 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 50
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "Cloudy"
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 1, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 1, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.171 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 2, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 2, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 2, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 2, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 2, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 2, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.75 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 3, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 3, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 3, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 3, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 3, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 3, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.35 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 4, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 4, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 4, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 4, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 4, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 4, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.32 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 5, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 5, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 5, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 5, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 5, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 5, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.47 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 6, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 6, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 6, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 6, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 6, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 6, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.210 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 7, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 7, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 7, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 7, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 7, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 7, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.24 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 8, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 8, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 8, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 8, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 8, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 8, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.39 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 9, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 9, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 9, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 9, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 9, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 9, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.25 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:18] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[05:50:18] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `accounts` WHERE `Name` = 'Cloudy' LIMIT 1", use_cache: true
[05:50:18] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:18] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.414 milliseconds
[05:50:18] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:18] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:18] [DEBUG] cache_get_row_count - connection: 1
[05:50:18] [DEBUG] cache_get_row_count - connection: 1
[05:50:18] [DEBUG] cache_get_row_int - row: 0, field_idx: 0, connection: 1
[05:50:18] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "3"
[05:50:18] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:18] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:18] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:18] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `bans` WHERE `BannedAccID` = '%d' LIMIT 1"
[05:50:18] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `bans` WHERE `BannedAccID` = '3' LIMIT 1", callback: "OnBanCheck", format: "i"
[05:50:18] [DEBUG] CMySQLQuery::Execute[OnBanCheck] - starting query execution
[05:50:18] [DEBUG] CMySQLQuery::Execute[OnBanCheck] - query was successfully executed within 0.96 milliseconds
[05:50:18] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:18] [DEBUG] Calling callback "OnBanCheck"..
[05:50:18] [DEBUG] cache_get_data - connection: 1
[05:50:18] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[05:50:18] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = 'Cloudy' ", callback: "OnAccountCheck", format: "i"
[05:50:18] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:18] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[05:50:18] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.380 milliseconds
[05:50:18] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:18] [DEBUG] Calling callback "OnAccountCheck"..
[05:50:18] [DEBUG] cache_get_data - connection: 1
[05:50:18] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129
[05:50:18] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "3F4811B9E6C37CE5900ADA5BC660C8632D13EA28A11DD0C54E3E0FD4C776F285AB1678C7FA708FF0078FB495BC05C09D654B063F07EB1859F3440E4B5F1B5449"
[05:50:18] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[05:50:18] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "3"
[05:50:18] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:19] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[05:50:19] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `Name` = 'Cloudy' LIMIT 1", callback: "OnAccountLoad", format: "i"
[05:50:19] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution
[05:50:19] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.92 milliseconds
[05:50:19] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:19] [DEBUG] Calling callback "OnAccountLoad"..
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "3"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Admin", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Admin", data: "6"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VIP", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "VIP", data: "6"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Money", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Money", data: "433554"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Score", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Score", data: "523"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Owner", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Owner", data: "1"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Wanted", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Wanted", data: "0"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "XP", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "XP", data: "1759"
[05:50:19] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `accounts` SET `LoggedIn` = %d, `LastLogged` = %d WHERE `ID` = %d"
[05:50:19] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `LoggedIn` = 1, `LastLogged` = 14838 WHERE", callback: "(null)", format: "(null)"
[05:50:19] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:19] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[05:50:19] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 25.682 milliseconds
[05:50:19] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving 
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help