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

Linear Mode
[Ajuda] qual problema no codigo?
iSoaD
Big Clucker
***
Posts: 189
Threads: 34
Joined: Jan 2016
Reputation: 0
#1

12.03.2018, 01:27
pessoal estou comeзando a mexer em mysql agora e nгo estou conseguindo resolver meu problema.
nos logs do servidor dб isso:

Код:
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
meu cуdigo
Код:
forward PlayerConnected(playerid);
public PlayerConnected(playerid)
{
	if (!IsPlayerConnected(playerid))
	    return 0;

	static
	    rows,
	    fields;

    cache_get_data(rows, fields, Conexao);

	if (!rows)
	{
		static query[160];

		mysql_format(Conexao, query, sizeof(query), "INSERT INTO `players` (`playerName`) VALUES('%s')", ReturnName(playerid));
		return mysql_tquery(Conexao, query,"","");
	}

	pCampLD[playerid] = cache_get_field_int(0, "campID");
	pCampID[playerid] = cache_get_field_int(0, "playerCampID");
	pStationID[playerid] = cache_get_field_int(0, "playerStationID");
	pCampSuccessor[playerid] = cache_get_field_int(0, "playerCampSuccessor");
 	pObjects[playerid] = cache_get_field_int(0, "playerObjects");
	return 1;
}

stock connectvarsbase(playerid)
{
	pCamps[playerid] = 1;
	pCampID[playerid] = -1;
	pEditAntenna[playerid] = -1;
	pAntennas[playerid] = 1;
	pStationID[playerid] = -1;
	pActualDistance[playerid] = 0.0;
	pCampInvited[playerid] = -1;
	pInvitedLeader[playerid] = INVALID_PLAYER_ID;
	pCampSuccessor[playerid] = -1;

	pSelected[playerid] = -1;
	pObjects[playerid] = 999999;

	new Query[70];

	mysql_format(Conexao, Query, sizeof(Query), "SELECT * FROM `players` WHERE `playerName` = '%s'", ReturnName(playerid));
	mysql_tquery(Conexao, Query, "PlayerConnected", "d", playerid);

return 1;
}
Find
Reply
« Next Oldest | Next Newest »


Messages In This Thread
qual problema no codigo? - by iSoaD - 12.03.2018, 01:27
Re: qual problema no codigo? - by PowerMwK - 14.03.2018, 11:08
Re: qual problema no codigo? - by F1N4L - 14.03.2018, 11:45
Re: qual problema no codigo? - by PowerMwK - 14.03.2018, 12:42
Re: qual problema no codigo? - by F1N4L - 14.03.2018, 12:53

Forum Jump:


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