SA-MP Forums Archive
That's what it looks like mysql command r6? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: That's what it looks like mysql command r6? (/showthread.php?tid=585822)


That's what it looks like mysql command r6? - Jimmi - 16.08.2015

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;
}


Re: That's what it looks like mysql command r6? - Jimmi - 16.08.2015

upp,....

Re: That's what it looks like mysql command r6? - Jimmi - 16.08.2015

upppp

AW: That's what it looks like mysql command r6? - Nero_3D - 17.08.2015

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

Re: That's what it looks like mysql command r6? - Jimmi - 17.08.2015

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;
}


Re: That's what it looks like mysql command r6? - Jimmi - 17.08.2015

uppp

AW: Re: That's what it looks like mysql command r6? - Nero_3D - 17.08.2015

Код:
//========================================[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

Re: That's what it looks like mysql command r6? - Jimmi - 17.08.2015

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]);

AW: That's what it looks like mysql command r6? - Nero_3D - 17.08.2015

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]);