Mysql not loading - Printable Version

Mysql not loading - 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: Mysql not loading (/showthread.php?tid=511967)

Mysql not loading - Blademaster680 - 08.05.2014

I can login fine but it is not loading my spawn location etc.
It wont load my "ID".

Does anyone know what the problem is?
Thanks

Код:

stock LoginPlayer(playerid)
{
	new query[126];
	format(query, sizeof(query), "SELECT * FROM playerdata WHERE Name = '%s'", GetName(playerid));
	mysql_query(query);
	mysql_store_result();

	while(mysql_fetch_row_format(query,"|"))
	{
		mysql_fetch_field_row(query, "ID"); PlayerInfo[playerid][ID] = strval(query);
		mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name");
		mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password");
		mysql_fetch_field_row(query, "AdminLevel"); PlayerInfo[playerid][AdminLevel] = strval(query);
		mysql_fetch_field_row(query, "PlayerPos");
		sscanf(query, "fff", PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2]);
		mysql_fetch_field_row(query, "Cash"); PlayerInfo[playerid][Cash] = strval(query);
	}
	GivePlayerMoney(playerid, PlayerInfo[playerid][Cash]);
	SetSpawnInfo(playerid, 0, 299, PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2], 0, 0, 0, 0, 0, 0, 0);
	SpawnPlayer(playerid);
	SetPlayerPos(playerid, PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2]);
}

I think this line is the problem

Код:

mysql_fetch_field_row(query, "ID"); PlayerInfo[playerid][ID] = strval(query);

Re: Mysql not loading - ikbenremco - 08.05.2014

Debug your code, see if the query is correct, ect.

Also, you should try to switch to threaded queries.

Re: Mysql not loading - Blademaster680 - 08.05.2014

How would I do that?

Re: Mysql not loading - ikbenremco - 08.05.2014

PHP код:



stock LoginPlayer(playerid)

{

    new query[126];

    format(query, sizeof(query), "SELECT * FROM playerdata WHERE Name = '%s'", GetName(playerid));

    mysql_query(query);

        printf("Debug 1:%s", query); // Like this

    mysql_store_result();


    while(mysql_fetch_row_format(query,"|"))

    {

        mysql_fetch_field_row(query, "ID"); PlayerInfo[playerid][ID] = strval(query);

        mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name");

        mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password");

        mysql_fetch_field_row(query, "AdminLevel"); PlayerInfo[playerid][AdminLevel] = strval(query);

        mysql_fetch_field_row(query, "PlayerPos");

        sscanf(query, "fff", PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2]);

        mysql_fetch_field_row(query, "Cash"); PlayerInfo[playerid][Cash] = strval(query);

    }

    GivePlayerMoney(playerid, PlayerInfo[playerid][Cash]);

    SetSpawnInfo(playerid, 0, 299, PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2], 0, 0, 0, 0, 0, 0, 0);

    SpawnPlayer(playerid);

    SetPlayerPos(playerid, PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2]);

}

Btw, try this:

PHP код:



format(query, sizeof(query), "SELECT * FROM playerdata WHERE `Name` = '%s'", GetName(playerid));