SA-MP Forums Archive
MySQL 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 loading (/showthread.php?tid=613337)



MySQL loading - Ahmed21 - 26.07.2016

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 
rowsfields;
     
cache_get_data(rowsfieldsmysql);
    if(
rows)
    {
        new 
housepw[4], housetitle[MAX_HOUSE_NAME];
        for(new 
0cache_get_row_count(); i++)
        {
            
hInfo[i][hID] = cache_get_row_int(i0);
            
cache_get_row(i2housetitle);
            
cache_get_row(i3housepw);
            
            
hInfo[i][hOwner] = cache_get_row_int(i1);
            
hInfo[i][hInterior] = cache_get_row_int(i10);
            
hInfo[i][hPrice] = cache_get_row_int(i11);
            
hInfo[i][hEnterX] = cache_get_row_float(i4);
            
hInfo[i][hEnterY] = cache_get_row_float(i5);
            
hInfo[i][hEnterZ] = cache_get_row_float(i6);
            
hInfo[i][hExitX] = cache_get_row_float(i7);
            
hInfo[i][hExitY] = cache_get_row_float(i8);
            
hInfo[i][hExitZ] = cache_get_row_float(i9);
            
hInfo[i][hTitle] = housetitle;
            
hInfo[i][hPassword] = housepw;
            
hInfo[i][hWorldID] = hInfo[i][hID];
            
            new 
hEntStr[200];
            if(
hInfo[i][hOwner] == -1)
            {
                
format(hEntStrsizeof(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], iAC(hInfo[i][hPrice]));
            }
            else if(
hInfo[i][hOwner] != -1)
            {
                
format(hEntStrsizeof(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], iGetNameFromMySQLID(hInfo[i][hOwner]), AC(hInfo[i][hPrice]));
            }
            
hInfo[i][sEnterLabel] = CreateDynamic3DTextLabel(hEntStr, -1hInfo[i][hEnterX], hInfo[i][hEnterY], hInfo[i][hEnterZ], 20.0INVALID_PLAYER_IDINVALID_VEHICLE_ID1, -10, -1100.0);
            
hInfo[i][sExitLabel] = CreateDynamic3DTextLabel(""COL_GOLD"[EXIT]", -1hInfo[i][hExitX], hInfo[i][hExitY], hInfo[i][hExitZ], 20.0INVALID_PLAYER_IDINVALID_VEHICLE_ID1hInfo[i][hWorldID], hInfo[i][hInterior], -1100.0);
            
hInfo[i][hEnterCP] = CreateDynamicCP(hInfo[i][hEnterX], hInfo[i][hEnterY], hInfo[i][hEnterZ], 1.0, -10, -1100.0);
            
hInfo[i][hExitCP] = CreateDynamicCP(hInfo[i][hExitX], hInfo[i][hExitY], hInfo[i][hExitZ], 1.0hInfo[i][hWorldID], hInfo[i][hInterior], -1100.0);
               
LoadedHouses++;
        }
        
printf("Loaded %d houses"LoadedHouses);
    }
    else if(!
rows)
    {
        
printf("There are NO houses to load");
    }
    return 
1;




Re: MySQL loading - Konstantinos - 26.07.2016

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.


Re: MySQL loading - Ahmed21 - 26.07.2016

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 ..?


Re: MySQL loading - Ahmed21 - 26.07.2016

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(outputsizeof(output), "%d"number);
    for(new 
strlen(output) - 3&& output[i-1] != '-'-= 3)
    {
        
strins(outputseparatori);
    }
    return 
output;

And here's my GetNameFromMySQLID
PHP код:
stock GetNameFromMySQLID(sqlid)
{
    new 
query[128], name[24], lelo[24], count;
    
mysql_format(mysqlquerysizeof(query), "SELECT * FROM `accounts` WHERE ID = %d LIMIT 1"sqlid);
    new 
Cache:result mysql_query(mysqlquery);
    
count cache_get_row_count();
    
cache_get_row_count();
    
cache_get_row(01lelo);
    
cache_delete(result);
    
name lelo;
    if(
count 1)
    {
        
name "0";
        return 
name;
    }
    return 
name;




Re: MySQL loading - Konstantinos - 26.07.2016

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(mysqlquerysizeof(query), "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"sqlid);  
    new 
Cacheresult mysql_query(mysqlquery);
  
    if (
cache_get_row_count()) cache_get_row(00query);
    else 
query "0";
  
    
cache_delete(result);
    return 
query;




Re: MySQL loading - PrO.GameR - 26.07.2016

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.


Re: MySQL loading - Ahmed21 - 27.07.2016

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.


Re: MySQL loading - Ahmed21 - 27.07.2016

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 
rowsfields;
     
cache_get_data(rowsfieldsmysql);
    if(
rows)
    {
        new 
housepw[4], housetitle[MAX_HOUSE_NAME];
        for(new 
0rowsi++)
        {
            
hInfo[i][hID] = cache_get_row_int(i0);
            
cache_get_row(i2housetitle);
            
cache_get_row(i3housepw);
            
            
hInfo[i][hOwner] = cache_get_row_int(i1);
            
hInfo[i][hInterior] = cache_get_row_int(i10);
            
hInfo[i][hPrice] = cache_get_row_int(i11);
            
hInfo[i][hEnterX] = cache_get_row_float(i4);
            
hInfo[i][hEnterY] = cache_get_row_float(i5);
            
hInfo[i][hEnterZ] = cache_get_row_float(i6);
            
hInfo[i][hExitX] = cache_get_row_float(i7);
            
hInfo[i][hExitY] = cache_get_row_float(i8);
            
hInfo[i][hExitZ] = cache_get_row_float(i9);
            
hInfo[i][hTitle] = housetitle;
            
hInfo[i][hPassword] = housepw;
            
hInfo[i][hWorldID] = hInfo[i][hID];
            
            new 
hEntStr[200];
            if(
hInfo[i][hOwner] == -1)
            {
                
format(hEntStrsizeof(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], iAC(hInfo[i][hPrice]));
            }
            else if(
hInfo[i][hOwner] != -1)
            {
                   new 
query[50];
                
mysql_format(mysqlquerysizeof(query), "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"hInfo[i][hOwner]);
                new 
Cacheresult mysql_query(mysqlquery);
                if (
cache_get_row_count()) cache_get_row(01query);
                
cache_delete(result);
                
format(hEntStrsizeof(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], iqueryAC(hInfo[i][hPrice]));
            }
            
hInfo[i][sEnterLabel] = CreateDynamic3DTextLabel(hEntStr, -1hInfo[i][hEnterX], hInfo[i][hEnterY], hInfo[i][hEnterZ], 20.0INVALID_PLAYER_IDINVALID_VEHICLE_ID1, -10, -1100.0);
            
hInfo[i][sExitLabel] = CreateDynamic3DTextLabel(""COL_GOLD"[EXIT]", -1hInfo[i][hExitX], hInfo[i][hExitY], hInfo[i][hExitZ], 20.0INVALID_PLAYER_IDINVALID_VEHICLE_ID1hInfo[i][hWorldID], hInfo[i][hInterior], -1100.0);
            
hInfo[i][hEnterCP] = CreateDynamicCP(hInfo[i][hEnterX], hInfo[i][hEnterY], hInfo[i][hEnterZ], 1.0, -10, -1100.0);
            
hInfo[i][hExitCP] = CreateDynamicCP(hInfo[i][hExitX], hInfo[i][hExitY], hInfo[i][hExitZ], 1.0hInfo[i][hWorldID], hInfo[i][hInterior], -1100.0);
               
LoadedHouses++;
        }
        
printf("Loaded %d houses"LoadedHouses);
    }
    else if(!
rows)
    {
        
printf("There are NO houses to load");
    }
    return 
1;




Re: MySQL loading - Konstantinos - 27.07.2016

Код:
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.


Re: MySQL loading - Ahmed21 - 27.07.2016

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] [DEBUGmysql_connect host"localhost"user"f3413_ahcnr"database"f3413_ahcnr"password"****"port3306autoreconnecttruepool_size2
[05:50:04] [DEBUGCMySQLHandle::Create creating new connection..
[
05:50:04] [DEBUGCMySQLHandle::CMySQLHandle constructor called
[05:50:04] [DEBUGCMySQLHandle::Create connection created (id1)
[
05:50:04] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
05:50:04] [DEBUGCMySQLConnection::Connect connection was successful
[05:50:04] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[05:50:04] [DEBUGmysql_errno connection1
[05:50:04] [DEBUGmysql_format connection1len128format"SELECT * FROM stores"
[05:50:04] [DEBUGmysql_tquery connection1query"SELECT * FROM stores"callback"LoadStores"format"(null)"
[05:50:04] [DEBUGmysql_format connection1len128format"SELECT * FROM houses"
[05:50:04] [DEBUGmysql_tquery connection1query"SELECT * FROM houses"callback"LoadHouses"format"(null)"
[05:50:04] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
05:50:04] [DEBUGCMySQLConnection::Connect connection was successful
[05:50:04] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[05:50:04] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
05:50:04] [DEBUGCMySQLConnection::Connect connection was successful
[05:50:04] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[05:50:04] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
05:50:04] [DEBUGCMySQLConnection::Connect connection was successful
[05:50:04] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[05:50:04] [DEBUGCMySQLQuery::Execute[LoadStores] - starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute[LoadStores] - query was successfully executed within 0.51 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLQuery::Execute[LoadHouses] - starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute[LoadHouses] - query was successfully executed within 0.211 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCalling callback "LoadStores"..
[
05:50:04] [DEBUGcache_get_data connection1
[05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_get_row_int row0field_idx0connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'0'data"2"
[05:50:04] [DEBUGcache_get_row row0field_idx1connection1max_len100
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'1'data"beloBolo"
[05:50:04] [DEBUGcache_get_row_int row0field_idx11connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'11'data"51"
[05:50:04] [DEBUGcache_get_row_int row0field_idx12connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'12'data"15"
[05:50:04] [DEBUGcache_get_row_int row0field_idx14connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'14'data"5"
[05:50:04] [DEBUGcache_get_row_int row0field_idx13connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'13'data"29"
[05:50:04] [DEBUGcache_get_row_float row0field_idx2connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'2'data"-1808.61"
[05:50:04] [DEBUGcache_get_row_float row0field_idx3connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'3'data"945.813"
[05:50:04] [DEBUGcache_get_row_float row0field_idx4connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'4'data"24.8906"
[05:50:04] [DEBUGcache_get_row_float row0field_idx5connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'5'data"372.355"
[05:50:04] [DEBUGcache_get_row_float row0field_idx6connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'6'data"-133.523"
[05:50:04] [DEBUGcache_get_row_float row0field_idx7connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'7'data"1001.49"
[05:50:04] [DEBUGcache_get_row_float row0field_idx8connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'8'data"377.601"
[05:50:04] [DEBUGcache_get_row_float row0field_idx9connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'9'data"-113.971"
[05:50:04] [DEBUGcache_get_row_float row0field_idx10connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'10'data"1001.49"
[05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_get_row_int row1field_idx0connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'0'data"3"
[05:50:04] [DEBUGcache_get_row row1field_idx1connection1max_len100
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'1'data"Victim"
[05:50:04] [DEBUGcache_get_row_int row1field_idx11connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'11'data"5000"
[05:50:04] [DEBUGcache_get_row_int row1field_idx12connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'12'data"2500"
[05:50:04] [DEBUGcache_get_row_int row1field_idx14connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'14'data"5"
[05:50:04] [DEBUGcache_get_row_int row1field_idx13connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'13'data"45"
[05:50:04] [DEBUGcache_get_row_float row1field_idx2connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'2'data"-1694.58"
[05:50:04] [DEBUGcache_get_row_float row1field_idx3connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'3'data"951.918"
[05:50:04] [DEBUGcache_get_row_float row1field_idx4connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'4'data"24.8906"
[05:50:04] [DEBUGcache_get_row_float row1field_idx5connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'5'data"227.563"
[05:50:04] [DEBUGcache_get_row_float row1field_idx6connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'6'data"-8.1016"
[05:50:04] [DEBUGcache_get_row_float row1field_idx7connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'7'data"1002.21"
[05:50:04] [DEBUGcache_get_row_float row1field_idx8connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'8'data"204.854"
[05:50:04] [DEBUGcache_get_row_float row1field_idx9connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'9'data"-7.8775"
[05:50:04] [DEBUGcache_get_row_float row1field_idx10connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'1'field'10'data"1001.21"
[05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCalling callback "LoadHouses"..
[
05:50:04] [DEBUGcache_get_data connection1
[05:50:04] [DEBUGcache_get_row_int row0field_idx0connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'0'data"33"
[05:50:04] [DEBUGcache_get_row row0field_idx2connection1max_len35
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'2'data"Home"
[05:50:04] [DEBUGcache_get_row row0field_idx3connection1max_len4
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'3'data"N/A"
[05:50:04] [DEBUGcache_get_row_int row0field_idx1connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'1'data"3"
[05:50:04] [DEBUGcache_get_row_int row0field_idx10connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'10'data"2"
[05:50:04] [DEBUGcache_get_row_int row0field_idx11connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'11'data"1337"
[05:50:04] [DEBUGcache_get_row_float row0field_idx4connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'4'data"-1780.6"
[05:50:04] [DEBUGcache_get_row_float row0field_idx5connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'5'data"901.42"
[05:50:04] [DEBUGcache_get_row_float row0field_idx6connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'6'data"25.219"
[05:50:04] [DEBUGcache_get_row_float row0field_idx7connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'7'data"266.499"
[05:50:04] [DEBUGcache_get_row_float row0field_idx8connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'8'data"304.978"
[05:50:04] [DEBUGcache_get_row_float row0field_idx9connection1
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'9'data"999.148"
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 3 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.66 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_get_row row0field_idx0connection1max_len50
[05:50:04] [DEBUGCMySQLResult::GetRowData row'0'field'0'data"Cloudy"
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:04] [DEBUGcache_get_row_int row1field_idx0connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row row1field_idx2connection1max_len35
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row row1field_idx3connection1max_len4
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row_int row1field_idx1connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row1field_idx10connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row1field_idx11connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_float row1field_idx4connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row1field_idx5connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row1field_idx6connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row1field_idx7connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row1field_idx8connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row1field_idx9connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 0 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.171 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:04] [DEBUGcache_get_row_int row2field_idx0connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row row2field_idx2connection1max_len35
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row row2field_idx3connection1max_len4
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row_int row2field_idx1connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row2field_idx10connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row2field_idx11connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_float row2field_idx4connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row2field_idx5connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row2field_idx6connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row2field_idx7connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row2field_idx8connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row2field_idx9connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 0 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.75 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:04] [DEBUGcache_get_row_int row3field_idx0connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row row3field_idx2connection1max_len35
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row row3field_idx3connection1max_len4
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row_int row3field_idx1connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row3field_idx10connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row3field_idx11connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_float row3field_idx4connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row3field_idx5connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row3field_idx6connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row3field_idx7connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row3field_idx8connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row3field_idx9connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 0 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.35 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:04] [DEBUGcache_get_row_int row4field_idx0connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row row4field_idx2connection1max_len35
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row row4field_idx3connection1max_len4
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row_int row4field_idx1connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row4field_idx10connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row4field_idx11connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_float row4field_idx4connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row4field_idx5connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row4field_idx6connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row4field_idx7connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row4field_idx8connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row4field_idx9connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 0 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.32 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:04] [DEBUGcache_get_row_int row5field_idx0connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row row5field_idx2connection1max_len35
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row row5field_idx3connection1max_len4
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row_int row5field_idx1connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row5field_idx10connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row5field_idx11connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_float row5field_idx4connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row5field_idx5connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row5field_idx6connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row5field_idx7connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row5field_idx8connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row5field_idx9connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 0 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.47 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:04] [DEBUGcache_get_row_int row6field_idx0connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row row6field_idx2connection1max_len35
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row row6field_idx3connection1max_len4
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row_int row6field_idx1connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row6field_idx10connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row6field_idx11connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_float row6field_idx4connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row6field_idx5connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row6field_idx6connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row6field_idx7connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row6field_idx8connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row6field_idx9connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 0 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.210 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:04] [DEBUGcache_get_row_int row7field_idx0connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row row7field_idx2connection1max_len35
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row row7field_idx3connection1max_len4
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row_int row7field_idx1connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row7field_idx10connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row7field_idx11connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_float row7field_idx4connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row7field_idx5connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row7field_idx6connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row7field_idx7connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row7field_idx8connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row7field_idx9connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 0 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.24 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:04] [DEBUGcache_get_row_int row8field_idx0connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row row8field_idx2connection1max_len35
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row row8field_idx3connection1max_len4
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row_int row8field_idx1connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row8field_idx10connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row8field_idx11connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_float row8field_idx4connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row8field_idx5connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row8field_idx6connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row8field_idx7connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row8field_idx8connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row8field_idx9connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 0 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.39 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:04] [DEBUGcache_get_row_int row9field_idx0connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row row9field_idx2connection1max_len35
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row row9field_idx3connection1max_len4
[05:50:04] [WARNINGcache_get_row no active cache
[05:50:04] [DEBUGcache_get_row_int row9field_idx1connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row9field_idx10connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_int row9field_idx11connection1
[05:50:04] [WARNINGcache_get_row_int no active cache
[05:50:04] [DEBUGcache_get_row_float row9field_idx4connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row9field_idx5connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row9field_idx6connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row9field_idx7connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row9field_idx8connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGcache_get_row_float row9field_idx9connection1
[05:50:04] [WARNINGcache_get_row_float no active cache
[05:50:04] [DEBUGmysql_format connection1len50format"SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUGmysql_query connection1query"SELECT Name FROM accounts WHERE ID = 0 LIMIT 1"use_cachetrue
[05:50:04] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:04] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.25 milliseconds
[05:50:04] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:04] [DEBUGcache_get_row_count connection1
[05:50:04] [DEBUGcache_delete cache_id1connection1
[05:50:04] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:18] [DEBUGmysql_format connection1len128format"SELECT * FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[05:50:18] [DEBUGmysql_query connection1query"SELECT * FROM `accounts` WHERE `Name` = 'Cloudy' LIMIT 1"use_cachetrue
[05:50:18] [DEBUGCMySQLQuery::Execute starting query execution
[05:50:18] [DEBUGCMySQLQuery::Execute query was successfully executed within 0.414 milliseconds
[05:50:18] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:18] [DEBUGCMySQLHandle::SaveActiveResult cache saved (id1)
[
05:50:18] [DEBUGcache_get_row_count connection1
[05:50:18] [DEBUGcache_get_row_count connection1
[05:50:18] [DEBUGcache_get_row_int row0field_idx0connection1
[05:50:18] [DEBUGCMySQLResult::GetRowData row'0'field'0'data"3"
[05:50:18] [DEBUGcache_delete cache_id1connection1
[05:50:18] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:18] [DEBUGCMySQLHandle::DeleteSavedResult result deleted
[05:50:18] [DEBUGmysql_format connection1len128format"SELECT * FROM `bans` WHERE `BannedAccID` = '%d' LIMIT 1"
[05:50:18] [DEBUGmysql_tquery connection1query"SELECT * FROM `bans` WHERE `BannedAccID` = '3' LIMIT 1"callback"OnBanCheck"format"i"
[05:50:18] [DEBUGCMySQLQuery::Execute[OnBanCheck] - starting query execution
[05:50:18] [DEBUGCMySQLQuery::Execute[OnBanCheck] - query was successfully executed within 0.96 milliseconds
[05:50:18] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:18] [DEBUGCalling callback "OnBanCheck"..
[
05:50:18] [DEBUGcache_get_data connection1
[05:50:18] [DEBUGmysql_format connection1len128format"SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[05:50:18] [DEBUGmysql_tquery connection1query"SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = 'Cloudy' "callback"OnAccountCheck"format"i"
[05:50:18] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:18] [DEBUGCMySQLQuery::Execute[OnAccountCheck] - starting query execution
[05:50:18] [DEBUGCMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.380 milliseconds
[05:50:18] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:18] [DEBUGCalling callback "OnAccountCheck"..
[
05:50:18] [DEBUGcache_get_data connection1
[05:50:18] [DEBUGcache_get_field_content row0field_name"Password"connection1max_len129
[05:50:18] [DEBUGCMySQLResult::GetRowDataByName row'0'field"Password"data"3F4811B9E6C37CE5900ADA5BC660C8632D13EA28A11DD0C54E3E0FD4C776F285AB1678C7FA708FF0078FB495BC05C09D654B063F07EB1859F3440E4B5F1B5449"
[05:50:18] [DEBUGcache_get_field_content_int row0field_name"ID"connection1
[05:50:18] [DEBUGCMySQLResult::GetRowDataByName row'0'field"ID"data"3"
[05:50:18] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:19] [DEBUGmysql_format connection1len100format"SELECT * FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[05:50:19] [DEBUGmysql_tquery connection1query"SELECT * FROM `accounts` WHERE `Name` = 'Cloudy' LIMIT 1"callback"OnAccountLoad"format"i"
[05:50:19] [DEBUGCMySQLQuery::Execute[OnAccountLoad] - starting query execution
[05:50:19] [DEBUGCMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.92 milliseconds
[05:50:19] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[05:50:19] [DEBUGCalling callback "OnAccountLoad"..
[
05:50:19] [DEBUGcache_get_field_content_int row0field_name"ID"connection1
[05:50:19] [DEBUGCMySQLResult::GetRowDataByName row'0'field"ID"data"3"
[05:50:19] [DEBUGcache_get_field_content_int row0field_name"Admin"connection1
[05:50:19] [DEBUGCMySQLResult::GetRowDataByName row'0'field"Admin"data"6"
[05:50:19] [DEBUGcache_get_field_content_int row0field_name"VIP"connection1
[05:50:19] [DEBUGCMySQLResult::GetRowDataByName row'0'field"VIP"data"6"
[05:50:19] [DEBUGcache_get_field_content_int row0field_name"Money"connection1
[05:50:19] [DEBUGCMySQLResult::GetRowDataByName row'0'field"Money"data"433554"
[05:50:19] [DEBUGcache_get_field_content_int row0field_name"Score"connection1
[05:50:19] [DEBUGCMySQLResult::GetRowDataByName row'0'field"Score"data"523"
[05:50:19] [DEBUGcache_get_field_content_int row0field_name"Owner"connection1
[05:50:19] [DEBUGCMySQLResult::GetRowDataByName row'0'field"Owner"data"1"
[05:50:19] [DEBUGcache_get_field_content_int row0field_name"Wanted"connection1
[05:50:19] [DEBUGCMySQLResult::GetRowDataByName row'0'field"Wanted"data"0"
[05:50:19] [DEBUGcache_get_field_content_int row0field_name"XP"connection1
[05:50:19] [DEBUGCMySQLResult::GetRowDataByName row'0'field"XP"data"1759"
[05:50:19] [DEBUGmysql_format connection1len128format"UPDATE `accounts` SET `LoggedIn` = %d, `LastLogged` = %d WHERE `ID` = %d"
[05:50:19] [DEBUGmysql_tquery connection1query"UPDATE `accounts` SET `LoggedIn` = 1, `LastLogged` = 14838 WHERE"callback"(null)"format"(null)"
[05:50:19] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[05:50:19] [DEBUGCMySQLQuery::Execute[] - starting query execution
[05:50:19] [DEBUGCMySQLQuery::Execute[] - query was successfully executed within 25.682 milliseconds
[05:50:19] [DEBUGCMySQLQuery::Execute[] - no callback specifiedskipping result saving