MYSQL does not seems doing JOB

MYSQL does not seems doing JOB - 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 does not seems doing JOB (/showthread.php?tid=546512)

MYSQL does not seems doing JOB - MCZOFT - 15.11.2014

hello guys , ihave a problem

im having mysql system in my server . and if a user went to store some drugs or materials or weapons , it stores and saving into mysql db only MATERIALS and Drugs , but Weapons after i restart my server there is no Weapons in the hosue where the user saves his stuff ( in his house )

Take a look about that

PHP код:





for(currentRow = 0; currentRow != rows; ++currentRow, fx = 0, loadedWeapons = 0) {

            tmp = cache_get_row_int(currentRow, fx++, dbhandle);


            if(previousId == tmp) {

                if(MAX_PROPERTY_WEAPONS != loadedWeapons) {

                    HouseInfo[idx][hWeapon][loadedWeapons] = cache_get_field_content_int(currentRow, "pw_weapon", dbhandle);

                    HouseInfo[idx][hAmmo][loadedWeapons] = cache_get_field_content_int(currentRow, "pw_ammo", dbhandle);

                    ++loadedWeapons;

                }

                continue;

            } else previousId = tmp;

            HouseInfo[idx][hdbID]         = tmp;

            HouseInfo[idx][hEntrancex]  = cache_get_row_float(currentRow, fx++, dbhandle);

            HouseInfo[idx][hEntrancey]  = cache_get_row_float(currentRow, fx++, dbhandle);

            HouseInfo[idx][hEntrancez]  = cache_get_row_float(currentRow, fx++, dbhandle);

            HouseInfo[idx][hExitx]         = cache_get_row_float(currentRow, fx++, dbhandle);

            HouseInfo[idx][hExity]         = cache_get_row_float(currentRow, fx++, dbhandle);

            HouseInfo[idx][hExitz]         = cache_get_row_float(currentRow, fx++, dbhandle);

            HouseInfo[idx][hHealthx]    = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hHealthy]     = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hHealthz]     = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hArmourx]     = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hArmoury]     = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hArmourz]     = cache_get_row_int(currentRow, fx++, dbhandle);

            cache_get_row(currentRow, fx++, HouseInfo[idx][hOwner], dbhandle, 255);

            cache_get_row(currentRow, fx++, HouseInfo[idx][hDiscription], dbhandle, 255);

            HouseInfo[idx][hValue]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hHel]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hArm]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hInt]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hLock]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hOwned]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hRooms]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hRentabil]     = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hRent]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hTakings]     = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hLevel]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hWorld]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hSetted]     = 1;

            HouseInfo[idx][hDrugs]         = cache_get_row_int(currentRow, fx++, dbhandle);

            HouseInfo[idx][hMaterials]  = cache_get_row_int(currentRow, fx++, dbhandle);

            cache_get_row(currentRow, fx++, HouseInfo[idx][hMessage], dbhandle, 255);


            OnHousePickupUpdate(idx);

            OnPropTextdrawUpdate(1, idx);


            Iter_Add(HouseInfo, idx);

            ++idx;

            if(idx == MAX_LOADED_PROPERTIES) {

                printf("[SCRIPT]: Notice - there's more properties in database than script can handle. Tweak your MAX_LOADED_PROPERTIES settings");

                break;

            }

        }

Re: MYSQL does not seems doing JOB - MD5 - 15.11.2014

Put your MySQL_Log here.

Re : MYSQL does not seems doing JOB - MCZOFT - 15.11.2014

and alot alot of lines like that , if you want to post them i'll post them with an UPLOAD (alot of lines there but its similar looks like all the same but the numbers changing of cours .. )

PHP код:



[21:16:49] [DEBUG] mysql_errno - connection: 1

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT value FROM events ORDER BY id ASC", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT value FROM events ORDER BY id ASC"..

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT p.maker, p.title, p.safesaving, pm.message FROM papers p ", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT p.maker, p.title, p.safesaving, pm.message FROM papers p LEFT JOIN paper_messages pm ON pm.pid = p.id"..

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT p.*,    pw.weapon AS pw_weapon, pw.ammo AS pw_ammo FROM prop", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT p.*,    pw.weapon AS pw_weapon, pw.ammo AS pw_ammo FROM properties p LEFT JOIN property_weapons pw ON pw.pid = p.id ORDER BY p.id ASC, pw.id ASC"..

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM business WHERE issbizz = 0 ORDER BY id ASC", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM business WHERE issbizz = 0 ORDER BY id ASC"..

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM channels ORDER BY id ASC", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM channels ORDER BY id ASC"..

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM families ORDER BY id ASC", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM families ORDER BY id ASC"..

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT t.id AS t_id, t.armour AS t_armour, tw.weapon AS tw_weapn", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT t.id AS t_id, t.armour AS t_armour, tw.weapon AS tw_weapn, tw.ammo AS tw_ammo FROM trunks t LEFT JOIN trunk_weapons tw ON tw.tid = t.id"..

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM character_kills ORDER BY id ASC", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM character_kills ORDER BY id ASC"..

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM boxer ORDER BY id ASC", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM boxer ORDER BY id ASC"..

[21:16:49] [DEBUG] mysql_format - connection: 1, len: 36, format: "SELECT * FROM drugs ORDER BY id ASC"

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM drugs ORDER BY id ASC", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT * FROM drugs ORDER BY id ASC"..

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `key`, offset, value FROM simple_values ORDER BY `key` DE", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT `key`, offset, value FROM simple_values ORDER BY `key` DESC, offset ASC, id ASC"..

[21:16:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT offset, value FROM security ORDER BY `offset` ASC", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"

[21:16:49] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Create - inline function detected

[21:16:49] [DEBUG] mysql_tquery - scheduling query "SELECT offset, value FROM security ORDER BY `offset` ASC"..

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - starting query execution

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - query was successful

[21:16:49] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[21:16:49] [DEBUG] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL(d)] - data being passed to ProcessCallbacks()

[21:16:50] [DEBUG] Calling callback "FJ37DH3JG_MYSQL_INTERNAL"..

[21:16:50] [DEBUG] cache_get_data - connection: 1

[21:16:50] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[21:16:50] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called

[21:16:50] [DEBUG] Calling callback "FJ37DH3JG_MYSQL_INTERNAL"..

[21:16:50] [DEBUG] cache_get_data - connection: 1

[21:16:50] [DEBUG] cache_get_field_content - row: 0, field_name: "message", connection: 1, max_len: 129

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "message", data: "NULL"

[21:16:50] [DEBUG] cache_get_field_content - row: 1, field_name: "message", connection: 1, max_len: 129

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "message", data: "NULL"

[21:16:50] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[21:16:50] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called

[21:16:50] [DEBUG] Calling callback "FJ37DH3JG_MYSQL_INTERNAL"..

[21:16:50] [DEBUG] cache_get_data - connection: 1

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 0, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "612"

[21:16:50] [DEBUG] cache_get_row_float - row: 0, field_idx: 1, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "2067.87"

[21:16:50] [DEBUG] cache_get_row_float - row: 0, field_idx: 2, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '2', data: "-1717.09"

[21:16:50] [DEBUG] cache_get_row_float - row: 0, field_idx: 3, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "13.55"

[21:16:50] [DEBUG] cache_get_row_float - row: 0, field_idx: 4, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "223.19"

[21:16:50] [DEBUG] cache_get_row_float - row: 0, field_idx: 5, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "1287.08"

[21:16:50] [DEBUG] cache_get_row_float - row: 0, field_idx: 6, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "1082.14"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 7, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 8, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 9, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '9', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 10, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '10', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 11, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '11', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 12, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '12', data: "0"

[21:16:50] [DEBUG] cache_get_row - row: 0, field_idx: 13, connection: 1, max_len: 255

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '13', data: "The State"

[21:16:50] [DEBUG] cache_get_row - row: 0, field_idx: 14, connection: 1, max_len: 255

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '14', data: "House"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 15, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '15', data: "35000"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 16, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '16', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 17, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '17', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 18, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '18', data: "1"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 19, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '19', data: "1"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 20, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '20', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 21, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '21', data: "1"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 22, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '22', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 23, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '23', data: "1"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 24, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '24', data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 25, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '25', data: "3"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 26, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '26', data: "1"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 27, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '27', data: "50"

[21:16:50] [DEBUG] cache_get_row_int - row: 0, field_idx: 28, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '28', data: "0"

[21:16:50] [DEBUG] cache_get_row - row: 0, field_idx: 29, connection: 1, max_len: 255

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '29', data: "For Sale"

[21:16:50] [DEBUG] cache_get_row_int - row: 1, field_idx: 0, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '0', data: "612"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 1, field_name: "pw_weapon", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "pw_weapon", data: "0"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 1, field_name: "pw_ammo", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "pw_ammo", data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 2, field_idx: 0, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '2', field: '0', data: "612"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 2, field_name: "pw_weapon", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "pw_weapon", data: "0"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 2, field_name: "pw_ammo", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "pw_ammo", data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 3, field_idx: 0, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '3', field: '0', data: "612"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "pw_weapon", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "pw_weapon", data: "0"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 3, field_name: "pw_ammo", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "pw_ammo", data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 4, field_idx: 0, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '4', field: '0', data: "612"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 4, field_name: "pw_weapon", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "pw_weapon", data: "0"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 4, field_name: "pw_ammo", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "pw_ammo", data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 5, field_idx: 0, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '5', field: '0', data: "612"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 5, field_name: "pw_weapon", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '5', field: "pw_weapon", data: "0"

[21:16:50] [DEBUG] cache_get_field_content_int - row: 5, field_name: "pw_ammo", connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowDataByName - row: '5', field: "pw_ammo", data: "0"

[21:16:50] [DEBUG] cache_get_row_int - row: 6, field_idx: 0, connection: 1

[21:16:50] [DEBUG] CMySQLResult::GetRowData - row: '6', field: '0', data: "613"

Re: MYSQL does not seems doing JOB - sammp - 16.11.2014

Show me the saving code