That's what it looks like mysql command r6?
#1

That's what it looks like mysql command r6?
Код:
//========================================[CMD:FRIENDS]========================================================//
CMD:friends(playerid, params[])
{
	new query[128], name[MAX_PLAYER_NAME];
	GetPlayerName(playerid, name, sizeof(name));

	mysql_format(mysql_iConnectionHandle[0], query, sizeof(query), "SELECT * FROM `friendsdb` WHERE `UserDBID` = %i", PlayerInfo[playerid][pDBID]);
	mysql_function_query(mysql_iConnectionHandle[0], query, true, "OnPlayerRequestFriends", "ii", REQUEST_FRIEND_THREAD, playerid);
	return 1;
}
Reply
#2

upp,....
Reply
#3

upppp
Reply
#4

No that could be r7 or above, r6 still used mysql_query
Reply
#5

So:
C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(23922) : warning 213: tag mismatch
23922
Line:
Код:
	format(query, sizeof(query), "SELECT * FROM `friendsdb` WHERE `UserDBID` = %i", PlayerInfo[playerid][pDBID]);
All command:
Код:
//========================================[CMD:FRIENDS]========================================================//
CMD:friends(playerid, params[])
{
	new query[128], name[MAX_PLAYER_NAME];
	GetPlayerName(playerid, name, sizeof(name));

	format(query, sizeof(query), "SELECT * FROM `friendsdb` WHERE `UserDBID` = %i", PlayerInfo[playerid][pDBID]);
	mysql_query(query, true, "OnPlayerRequestFriends", "ii", REQUEST_FRIEND_THREAD, playerid);
	return 1;
}
Reply
#6

uppp
Reply
#7

Код:
//========================================[CMD:FRIENDS]========================================================//
CMD:friends(playerid, params[])
{
	new query[128], name[MAX_PLAYER_NAME];
	GetPlayerName(playerid, name, sizeof(name));

	format(query, sizeof(query), "SELECT * FROM `friendsdb` WHERE `UserDBID` = %i", PlayerInfo[playerid][pDBID]);
	mysql_query_callback(playerid, query, "OnPlayerRequestFriends", REQUEST_FRIEND_THREAD);
	return 1;
}
That page should help you, documentation for r6
https://sampwiki.blast.hk/wiki/MySQL#mysql_query_callback
Reply
#8

Hmm
C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(23909) : warning 213: tag mismatch
Idem line
format(query, sizeof(query), "SELECT * FROM `friendsdb` WHERE `UserDBID` = %i", PlayerInfo[playerid][pDBID]);
Reply
#9

There is nothing wrong with that line, the only tag mistake I could see would be PlayerInfo[playerid][pDBID] and that's your problem as I don't have that array

There are the two possibilities of a tag mistake

1. Possibility: pDBID has an unknown tag (not a Integer or Float)
2. Possibility: pDBID isn't from the correct enum

The first can be fixed easily with
pawn Код:
format(query, sizeof(query), "SELECT * FROM `friendsdb` WHERE `UserDBID` = %i", _: PlayerInfo[playerid][pDBID]);
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)