1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese

Threaded Mode
[Ajuda] MySQL R41
Marlon307
Huge Clucker
****
Posts: 386
Threads: 73
Joined: Mar 2014
Reputation: 0
#1

10.10.2016, 23:00
Atualizei o plugin e includes para a versгo mais recente e agora esta parecendo esses [debug] no log

Код:
[19:47:28] [DEBUG] mysql_errno(1)
[19:47:28] [DEBUG] CHandle::GetErrorId(this=0x805288)
[19:47:28] [DEBUG] CConnection::GetError(this=0x7ed120, connection=0x29111f0)
[19:47:28] [DEBUG] CHandle::GetErrorId - return value: true, error id: '0', error msg: ''
[19:47:28] [DEBUG] mysql_errno: return value: '0'
[19:47:52] [DEBUG] mysql_format(1, 0x03987F7C, 1024, "SELECT * FROM `contas` WHERE `usuario` = '%s'")
[19:47:52] [DEBUG] mysql_format: return value: '50'
[19:47:52] [DEBUG] mysql_query(1, "SELECT * FROM `contas` WHERE `usuario` = 'Swit_Cj'", 1)
[19:47:52] [DEBUG] CHandle::Execute(this=0x805288, type=3, query=0x824168)
[19:47:52] [DEBUG] CConnection::Execute(query=0x824168, this=0x7ed120, connection=0x29111f0)
[19:47:52] [DEBUG] CQuery::Execute(this=0x824168, connection=0x29111f0)
[19:47:52] [DEBUG] CResultSet::Create(connection=0x29111f0, query_str='SELECT * FROM `contas` WHERE `usuario` = 'Swit_Cj'')
[19:47:52] [DEBUG] created new resultset '0x838ca8'
[19:47:52] [DEBUG] fetched MySQL result '0x3dc0e78'
[19:47:52] [DEBUG] allocated 148 bytes for PAWN result
[19:47:52] [DEBUG] CHandle::Execute - return value: true
[19:47:52] [DEBUG] mysql_query: return value: '1'
[19:47:52] [DEBUG] cache_get_row_count(0x039E8D5C)
[19:47:52] [DEBUG] cache_get_row_count: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_int(0, "skin", 0x039CB200)
[19:47:52] [DEBUG] cache_get_value_name_int: assigned value: '270'
[19:47:52] [DEBUG] cache_get_value_name_int: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_int(0, "Admin", 0x03988FF8)
[19:47:52] [DEBUG] cache_get_value_name_int: assigned value: '5'
[19:47:52] [DEBUG] cache_get_value_name_int: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_int(0, "Gasolina", 0x039CB210)
[19:47:52] [DEBUG] cache_get_value_name_int: assigned value: '0'
[19:47:52] [DEBUG] cache_get_value_name_int: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_int(0, "Etanol", 0x039CB214)
[19:47:52] [DEBUG] cache_get_value_name_int: assigned value: '0'
[19:47:52] [DEBUG] cache_get_value_name_int: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_int(0, "Diesel", 0x039CB218)
[19:47:52] [DEBUG] cache_get_value_name_int: assigned value: '0'
[19:47:52] [DEBUG] cache_get_value_name_int: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_int(0, "GNV", 0x039CB21C)
[19:47:52] [DEBUG] cache_get_value_name_int: assigned value: '0'
[19:47:52] [DEBUG] cache_get_value_name_int: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_float(0, "CasaX", 0x039CB204)
[19:47:52] [DEBUG] cache_get_value_name_float: assigned value: '2227.71'
[19:47:52] [DEBUG] cache_get_value_name_float: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_float(0, "CasaY", 0x039CB208)
[19:47:52] [DEBUG] cache_get_value_name_float: assigned value: '-1262.31'
[19:47:52] [DEBUG] cache_get_value_name_float: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_float(0, "CasaZ", 0x039CB20C)
[19:47:52] [DEBUG] cache_get_value_name_float: assigned value: '23.919'
[19:47:52] [DEBUG] cache_get_value_name_float: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_int(0, "Dinheiro", 0x03989964)
[19:47:52] [DEBUG] cache_get_value_name_int: assigned value: '0'
[19:47:52] [DEBUG] cache_get_value_name_int: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_int(0, "sBancario", 0x039CB224)
[19:47:52] [DEBUG] cache_get_value_name_int: assigned value: '0'
[19:47:52] [DEBUG] cache_get_value_name_int: return value: '1'
[19:47:52] [DEBUG] cache_get_value_name_int(0, "Profissao", 0x039CB220)
[19:47:52] [DEBUG] cache_get_value_name_int: assigned value: '0'
[19:47:52] [DEBUG] cache_get_value_name_int: return value: '1'
[19:47:53] [DEBUG] mysql_format(1, 0x03987F7C, 1024, "SELECT * FROM `contas` WHERE `usuario` = '%s'")
[19:47:53] [DEBUG] mysql_format: return value: '50'
[19:47:53] [DEBUG] mysql_query(1, "SELECT * FROM `contas` WHERE `usuario` = 'Swit_Cj'", 1)
[19:47:53] [DEBUG] CHandle::Execute(this=0x805288, type=3, query=0x824168)
[19:47:53] [DEBUG] CConnection::Execute(query=0x824168, this=0x7ed120, connection=0x29111f0)
[19:47:53] [DEBUG] CQuery::Execute(this=0x824168, connection=0x29111f0)
[19:47:53] [DEBUG] CResultSet::Create(connection=0x29111f0, query_str='SELECT * FROM `contas` WHERE `usuario` = 'Swit_Cj'')
[19:47:53] [DEBUG] created new resultset '0x838d50'
[19:47:53] [DEBUG] fetched MySQL result '0x3dc0e78'
[19:47:53] [DEBUG] allocated 148 bytes for PAWN result
[19:47:53] [DEBUG] CHandle::Execute - return value: true
[19:47:53] [DEBUG] mysql_query: return value: '2'
[19:47:53] [DEBUG] cache_get_row_count(0x039E8E08)
[19:47:53] [DEBUG] cache_get_row_count: return value: '1'
[19:47:57] [DEBUG] mysql_format(1, 0x03987F7C, 1024, "SELECT * FROM `contas` WHERE `usuario` = '%s' AND `senha` = '%s'")
[19:47:57] [DEBUG] mysql_format: return value: '74'
[19:47:57] [DEBUG] mysql_query(1, "SELECT * FROM `contas` WHERE `usuario` = 'Swit_Cj' AND `senha` = '1234567'", 1)
[19:47:57] [DEBUG] CHandle::Execute(this=0x805288, type=3, query=0x824168)
[19:47:57] [DEBUG] CConnection::Execute(query=0x824168, this=0x7ed120, connection=0x29111f0)
[19:47:57] [DEBUG] CQuery::Execute(this=0x824168, connection=0x29111f0)
[19:47:58] [DEBUG] CResultSet::Create(connection=0x29111f0, query_str='SELECT * FROM `contas` WHERE `usuario` = 'Swit_Cj' AND `senha` = '1234567'')
[19:47:58] [DEBUG] created new resultset '0x838d88'
[19:47:58] [DEBUG] fetched MySQL result '0x3dc0e78'
[19:47:58] [DEBUG] allocated 148 bytes for PAWN result
[19:47:58] [DEBUG] CHandle::Execute - return value: true
[19:47:58] [DEBUG] mysql_query: return value: '3'
[19:47:58] [DEBUG] cache_get_row_count(0x039E8DFC)
[19:47:58] [DEBUG] cache_get_row_count: return value: '1'
[19:48:03] [DEBUG] mysql_format(1, 0x03987F7C, 1024, "UPDATE `contas` SET `skin` = '%d',`aAdmin` = '%d',`Gasolina` = '%d',`Etanol` = '%d',`Diesel` = '%d',`GNV` = '%d',`Dinheiro` = '%d',`sBancario` = '%d',`Profissao` = '%d' WHERE `usuario` = '%s'")
[19:48:03] [DEBUG] mysql_format: return value: '189'
[19:48:03] [DEBUG] mysql_query(1, "UPDATE `contas` SET `skin` = '270',`aAdmin` = '1',`Gasolina` = '0',`Etanol` = '0',`Diesel` = '0',`GNV` = '0',`Dinheiro` = '0',`sBancario` = '0',`Profissao` = '0' WHERE `usuario` = 'Swit_Cj'", 1)
[19:48:03] [DEBUG] CHandle::Execute(this=0x805288, type=3, query=0x824168)
[19:48:03] [DEBUG] CConnection::Execute(query=0x824168, this=0x7ed120, connection=0x29111f0)
[19:48:03] [DEBUG] CQuery::Execute(this=0x824168, connection=0x29111f0)
[19:48:03] [DEBUG] CResultSet::Create(connection=0x29111f0, query_str='UPDATE `contas` SET `skin` = '270',`aAdmin` = '1',`Gasolina` = '0',`Etanol` = '0',`Diesel` = '0',`GNV` = '0',`Dinheiro` = '0',`sBancario` = '0',`Profissao` = '0' WHERE `usuario` = 'Swit_Cj'')
[19:48:03] [DEBUG] created new resultset '0x838df8'
[19:48:03] [DEBUG] fetched MySQL result '0x0'
[19:48:03] [DEBUG] CHandle::Execute - return value: true
[19:48:03] [DEBUG] mysql_query: return value: '4'
Linha dos erro

Код:
public OnPlayerConnect(playerid)
{
    new pName[MAX_PLAYER_NAME],rows;
	GetPlayerName(playerid, pName, MAX_PLAYER_NAME);

    CleanChatBox(playerid,30);

    SendClientMessage(playerid,0x00F0F0AA,"Carregando Dados.");

    mysql_format(SqL, Query, sizeof(Query), "SELECT * FROM `contas` WHERE `usuario` = '%s'",pName);
    mysql_query(SqL,Query,true);

    if(cache_get_row_count(rows) > 0)
	{
        cache_get_value_int(0, "skin", PlayerInfo[playerid][Skin]);
        cache_get_value_int(0, "Admin", pAdmin[playerid]);
        cache_get_value_int(0, "Gasolina", PlayerInfo[playerid][Comb][0]);
        cache_get_value_int(0, "Etanol", PlayerInfo[playerid][Comb][1]);
        cache_get_value_int(0, "Diesel", PlayerInfo[playerid][Comb][2]);
        cache_get_value_int(0, "GNV", PlayerInfo[playerid][Comb][3]);
        cache_get_value_float(0, "CasaX", PlayerInfo[playerid][Casa][0]);
        cache_get_value_float(0, "CasaY", PlayerInfo[playerid][Casa][1]);
        cache_get_value_float(0, "CasaZ", PlayerInfo[playerid][Casa][2]);
        cache_get_value_int(0, "Dinheiro", GetPVarMoney(playerid));
        cache_get_value_int(0, "sBancario", PlayerInfo[playerid][sBancario]);
        cache_get_value_int(0, "Profissao", PlayerInfo[playerid][Profissao]);


        if(pAdmin[playerid] > 0)
		{
			admin[playerid] = 1;
		}
	}
	else
	{	//Ususario nгo existe
        admin[playerid] = 0;
		pAdmin[playerid] = 0;
        OnacessoriosLoad(playerid);
	}
    AimbotWarnings[playerid] = 0;
    LoadPlayerTextsDraws(playerid);
    return 1;
}
Find
Reply
Dayvison_
High-roller
*****
Posts: 1,308
Threads: 47
Joined: Nov 2013
Reputation: 0
#2

10.10.2016, 23:49
Isto nгo й erro, e vocк mesmo que definiu, provavelmente vocк estб usando algo como
PHP код:
mysql_log(ALL); 
Se vocк quer retirar o debug e as infos, use apenas:
PHP код:
mysql_log(ERROR | WARNING); 
Find
Reply
Marlon307
Huge Clucker
****
Posts: 386
Threads: 73
Joined: Mar 2014
Reputation: 0
#3

11.10.2016, 00:00
Quote:
Originally Posted by Day_
Посмотреть сообщение
Isto nгo й erro, e vocк mesmo que definiu, provavelmente vocк estб usando algo como
PHP код:
mysql_log(ALL); 
Se vocк quer retirar o debug e as infos, use apenas:
PHP код:
mysql_log(ERROR | WARNING); 
Estou usando dessa forma
Код:
mysql_log(WARNING | ERROR | DEBUG);
mas o [DEBUG] nгo interfere em nada?
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese