GTAONLINE.PL :: Pobieranie danych z mysql. Nieprawidłowe dane!

Zaloguj się by uzyskać pełen dostęp. Nie masz jeszcze konta? Założ je już teraz w kilka sekund.

Witam. Mam w bazie dane, gdy gracz wchodzi na serwer, wy?wietla kompletnie inne dane ni? s? w bazie.

Dane wy?wietlane:

Dane w bazie:

kod:

Kod:

public OnPlayerConnect(playerid)

{

        new name[MAX_PLAYER_NAME];

        GetPlayerName(playerid, name, MAX_PLAYER_NAME);

        new query[128];

        new data[128];

		new pass[30];

        format(query, sizeof(query), "SELECT id, nick, password, cash, score, skin FROM konta WHERE nick = '%s'", name);

        mysql_query(query);

        mysql_store_result();

        if(mysql_fetch_row(data, "|"))

		sscanf(data, "p<|>dddd", pInfo[playerid][p_id], pInfo[playerid][p_score], pInfo[playerid][p_cash], pInfo[playerid][p_skin]);

		GetPlayerName(playerid, data, sizeof(data));

		mysql_real_escape_string(data, pInfo[playerid][p_nick]);	

		mysql_real_escape_string(pass, pInfo[playerid][p_password]);

        mysql_free_result();

        format(query, sizeof(query), "nick: %s kasa: %d skin: %d haslo: %s", pInfo[playerid][p_nick], pInfo[playerid][p_cash], pInfo[playerid][p_skin], pInfo[playerid][p_password]);

		SendClientMessage(playerid, COLOR_RED, query);

	return 1;

}

W zapytaniu pobierasz odpowiednio id, nick, has?o, kas?, respekt i skin, wi?c tak te? otrzymasz dane i takiej samej kolejno?ci musisz u?y? podczas rozdzielania danych w funkcji sscanf.

Mam to zrobione tak:

Kod:

public OnPlayerConnect(playerid)

{

        new name[MAX_PLAYER_NAME];

        GetPlayerName(playerid, name, MAX_PLAYER_NAME);

        new query[128];

        new data[128];

		new pass[30];

        format(query, sizeof(query), "SELECT id, nick, password, cash, score, skin FROM konta WHERE nick = '%s'", name);

        mysql_query(query);

        mysql_store_result();

        if(mysql_fetch_row(data, "|"))

		sscanf(data, "p<|>dddd", pInfo[playerid][p_id], pInfo[playerid][p_nick], pInfo[playerid][p_password], pInfo[playerid][p_cash], pInfo[playerid][p_score], pInfo[playerid][p_skin]);

		GetPlayerName(playerid, data, sizeof(data));

		mysql_real_escape_string(data, pInfo[playerid][p_nick]);	

		mysql_real_escape_string(pass, pInfo[playerid][p_password]);

        mysql_free_result();

        format(query, sizeof(query), "nick: %s kasa: %d skin: %d haslo: %s", pInfo[playerid][p_nick], pInfo[playerid][p_cash], pInfo[playerid][p_skin], pInfo[playerid][p_password]);

		SendClientMessage(playerid, COLOR_RED, query);

	return 1;

}

I to samo co wczesniej

Jeszcze format daty musisz zmieni?, chodzi o to dddd.

Kod:

public OnPlayerConnect(playerid)

{

        new name[MAX_PLAYER_NAME];

        GetPlayerName(playerid, name, MAX_PLAYER_NAME);

        new query[128];

        new data[128];

		new pass[30];

        format(query, sizeof(query), "SELECT id, nick, password, cash, score, skin FROM konta WHERE nick = '%s'", name);

        mysql_query(query);

        mysql_store_result();

        if(mysql_fetch_row(data, "|"))

		sscanf(data, "p<|>dssddd", pInfo[playerid][p_id], pInfo[playerid][p_nick], pInfo[playerid][p_password], pInfo[playerid][p_cash], pInfo[playerid][p_score], pInfo[playerid][p_skin]);

		GetPlayerName(playerid, data, sizeof(data));

		mysql_real_escape_string(data, pInfo[playerid][p_nick]);	

		mysql_real_escape_string(pass, pInfo[playerid][p_password]);

        mysql_free_result();

        format(query, sizeof(query), "nick: %s kasa: %d skin: %d haslo: %s", pInfo[playerid][p_nick], pInfo[playerid][p_cash], pInfo[playerid][p_skin], pInfo[playerid][p_password]);

		SendClientMessage(playerid, COLOR_RED, query);

	return 1;

}

Nadal to samo[/code]