[CrazyChoco]

Hello. I am scripting a gamemode, but added a new feature so I thought I would like to test it all out. I deleted my account from database, and tried to register but now it simply wont send the information to the database.


I keep getting this annoying bitch:

Quote:

[01:28:31] [DEBUG] mysql_tquery - connection: 1, query: "SELECT UserID, Password FROM `Accounts` WHERE `Username` = 'Zenx", callback: "OnAccountCheck", format: "d" [01:28:31] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution [01:28:31] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 1.409 milliseconds [01:28:31] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [01:28:31] [DEBUG] Calling callback "OnAccountCheck".. [01:28:31] [DEBUG] cache_get_data - connection: 1 [01:28:31] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [01:28:51] [DEBUG] mysql_escape_string - source: "asd", connection: 1, max_len: 512 [01:28:51] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `Accounts` WHERE `UserID` = '0'", callback: "OnAccountLoad", format: "d" [01:28:51] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution [01:28:51] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 1.31 milliseconds [01:28:51] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [01:28:51] [DEBUG] Calling callback "OnAccountLoad".. [01:28:51] [DEBUG] cache_get_row_int - row: 0, field_idx: 3, connection: 1 [01:28:51] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('3') [01:28:51] [ERROR] cache_get_row_int - invalid datatype [01:28:51] [DEBUG] cache_get_row_int - row: 0, field_idx: 4, connection: 1 [01:28:51] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('4') [01:28:51] [ERROR] cache_get_row_int - invalid datatype [01:28:51] [DEBUG] cache_get_row_int - row: 0, field_idx: 5, connection: 1 [01:28:51] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('5') [01:28:51] [ERROR] cache_get_row_int - invalid datatype [01:28:51] [DEBUG] cache_get_row_int - row: 0, field_idx: 6, connection: 1 [01:28:51] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('6') [01:28:51] [ERROR] cache_get_row_int - invalid datatype [01:28:51] [DEBUG] cache_get_row_int - row: 0, field_idx: 7, connection: 1 [01:28:51] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('7') [01:28:51] [ERROR] cache_get_row_int - invalid datatype [01:28:51] [DEBUG] cache_get_row_int - row: 0, field_idx: 8, connection: 1 [01:28:51] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('8') [01:28:51] [ERROR] cache_get_row_int - invalid datatype [01:28:51] [DEBUG] cache_get_row_int - row: 0, field_idx: 9, connection: 1 [01:28:51] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('9') [01:28:51] [ERROR] cache_get_row_int - invalid datatype [01:28:51] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

and I know the issue must be that. I've searched and searched no luck.

The code to the above statement:

pawn Код:

public OnAccountLoad(playerid)
{
    UserAccount[playerid][Money] = cache_get_row_int(0, 3, MySQL);
    UserAccount[playerid][Score] = cache_get_row_int(0, 4, MySQL);
    UserAccount[playerid][Adminlevel] = cache_get_row_int(0, 5, MySQL);
    UserAccount[playerid][Viplevel] = cache_get_row_int(0, 6, MySQL);
    UserAccount[playerid][Class] = cache_get_row_int(0, 7, MySQL);
    UserAccount[playerid][RankXP] = cache_get_row_int(0, 8, MySQL);
    UserAccount[playerid][Rank] = cache_get_row_int(0, 9, MySQL);

    ResetPlayerMoney(playerid);
    GivePlayerMoney(playerid, UserAccount[playerid][Money]);
    SetPlayerScore(playerid, UserAccount[playerid][Score]);
    return true;
}

My MYSQL tables (check picture). Anyway any help is very much appreciated, as it's buggs me a lot.