[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 |
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;
}
if(!cache_num_rows()) return SendClientMessage(playerid,-1,"user id doestn exists");
stock CheckAccount(playerid)
{
new query[500];
format(query, sizeof(query), "SELECT UserID, Password FROM `Accounts` WHERE `Username` = '%s' LIMIT 1", GetUser(playerid));
mysql_function_query(MySQL, query, true, "OnAccountCheck", "d", playerid);
return true;
}
public OnAccountCheck(playerid)
{
if(playerid != INVALID_PLAYER_ID)
{
new rows, fields;
cache_get_data(rows, fields, MySQL);
if(rows)
{
UserAccount[playerid][UserID] = cache_get_row_int(0, 0, MySQL);
cache_get_row(0, 1, UserAccount[playerid][Password], MySQL, 130);
new string[512];
format(string, sizeof(string), "{FFFFFF}Welcome back to San Fierro Cops and Robbers '%s', \nTo get start playing, we must ask you to login with your personal password below.\n\n{FF0000}Note: If you do not own this account, we highly recommend you to rejoin with a new name.", GetUser(playerid));
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FFFFFF}User authentication", string, "Login", "Cancel");
}
else
{
new string[512];
format(string, sizeof(string), "{FFFFFF}Welcome to San Fierro Cops and Robbers '%s', \nTo get start playing, we must ask you to sign up with a personal password below.\nWe highly recommend, that you use an unique password for our servers.\n\n{FF0000}Note: When you have signed up, this account (%s) will be your responsiblity!", GetUser(playerid), GetUser(playerid));
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FFFFFF}User authentication", string, "Register", "Cancel");
}
}
return true;
}
UserAccount[playerid][UserID] = cache_get_row_int(0, 0, MySQL);
printf("UserID: %d",UserAccount[playerid][UserID]);