GTAONLINE.PL :: Rejestracja w MySQL nie działa

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

Witam, ot?? nie dziala mi, system rejestracji i logowania, bo gdy przy rejestracji ustalimy has?o np, "12345" to do konta b?dzie pasowa?o ka?de inne has?o.
Prosze o pomc

Oto kod:

Kod:

#include <a_samp>

#include <zcmd>

#include <kolory>

#include <sscanf>

#include <mysql>

enum E_PLAYER

{

	pUID,

	pName[24],

	pPassword[24],

	pMoney,

	pScore,

	Float:pHealth,

	Float:pArmour,

	pSkin,

	pRanga

}

new PlayerCache[MAX_PLAYERS][E_PLAYER];

/*********************DIALOGI*******************/

#define D_LOGIN 1

#define D_REGISTER 2

/***********************************************/

public OnGameModeInit()

{

	mysql_init(LOG_ONLY_ERRORS);

	mysql_connect("XXXX", "XXXX", "XXXX", "XXXX");

	return 1;

}

public OnPlayerConnect(playerid)

{

	PlayerLogin(playerid);

	TogglePlayerSpectating(playerid, true);

	return 1;

}	

public OnPlayerDisconnect(playerid, reason)

{

	PlayerLogout(playerid);

	return 1;	

}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])

{

	if(dialogid == D_LOGIN)

	{

		if(strlen(inputtext) > 0)

		{

			if(!strcmp(PlayerCache[playerid][pPassword], inputtext, false))

			{

				TogglePlayerSpectating(playerid, false);

				SpawnPlayer(playerid);

			}

			else

			{

				ShowPlayerDialog(playerid, D_LOGIN, DIALOG_STYLE_PASSWORD, "{11d621}Logowanie", "{EB0000} Has?o nieprawid?owe !\n {FFFFFF}Podaj has?o aby si? zalogowa? !", "OK", "Anuluj");

			}

		}

		else

		{

			ShowPlayerDialog(playerid, D_LOGIN, DIALOG_STYLE_PASSWORD, "{11d621}Logowanie", "{EB0000} Has?o nieprawid?owe !\n {FFFFFF}Podaj has?o aby si? zalogowa? !", "OK", "Anuluj");

		}

	}

	if(dialogid == D_REGISTER)

	{

		if(strlen(inputtext) > 0)

		{

			new query[128];

			new string [128];

			format(query, sizeof(query), "INSERT INTO members (Name, Password) VALUES('%s', '%s')", PlayerName(playerid), inputtext);

			mysql_query(query);

			SendClientMessage(playerid, COLOR_LIGHTGREEN, "Rejestracja przebieg?a pomy?lnie !");

			format(string, sizeof(string), "Has?o do twojego konta to: %s ", inputtext);

			SendClientMessage(playerid, COLOR_LIGHTGREEN, string);

			PlayerLogin(playerid);

		}	

		else

		{

			Kick(playerid);

		}

	}

	return 0;

}

stock PlayerLogin(playerid)

{

    new query[128];

    new data[128];

	format(query, sizeof(query), "SELECT * FROM members WHERE name = '%s'", PlayerName(playerid));

	mysql_query(query);

	mysql_store_result();

	if(mysql_fetch_row(data, "|"))

	{

		sscanf(data, "p<|>ds[24]s[24]ddffdd", PlayerCache[playerid][pUID], PlayerCache[playerid][pName], PlayerCache[playerid][pPassword], PlayerCache[playerid][pMoney], PlayerCache[playerid][pScore], PlayerCache[playerid][pHealth], PlayerCache[playerid][pArmour], PlayerCache[playerid][pSkin], PlayerCache[playerid][pRanga]);

	} 

	else

	{

		SendClientMessage(playerid, 0xFFFF00FF, "Nie znaleziono Twojego konta!");

		ShowPlayerDialog(playerid, D_REGISTER, DIALOG_STYLE_INPUT, "{a50000}Rejestracja", "{00fff2}Witaj na serwerze !\nKonto o tym nicku nie zosta?o jeszcze stworzone !\n{FFFFFF}Wpisz has?o aby dokona? rejestracji !", "OK", "Anuluj");

		return 1;

	}

	mysql_free_result();

	ShowPlayerDialog(playerid, D_LOGIN, DIALOG_STYLE_PASSWORD, "{11d621}Logowanie", "{00fff2}Witaj na serwerze !\nKonto o tym nicku zosta?o ju? wcze?niej utworzone !\n{FFFFFF}Podaj has?o aby si? zalogow?:", "OK", "Anuluj");

	return 1;

}

stock PlayerLogout(playerid)

{

	new query[256];

	GetPlayerHealth(playerid, PlayerCache[playerid][pHealth]);

	GetPlayerArmour(playerid, PlayerCache[playerid][pArmour]);

	PlayerCache[playerid][pMoney] = GetPlayerMoney(playerid);

	PlayerCache[playerid][pScore] = GetPlayerScore(playerid);

    format(query, sizeof(query), "UPDATE members SET health = '%f', armour = '%f', money = '%d', score = '%d' WHERE uid = '%d'", PlayerCache[playerid][pHealth], PlayerCache[playerid][pArmour], PlayerCache[playerid][pMoney], PlayerCache[playerid][pScore], PlayerCache[playerid][pUID]);

    mysql_query(query);

	return 1;

}

stock PlayerName(playerid)

{

	new name[MAX_PLAYER_NAME];

    GetPlayerName(playerid, name, MAX_PLAYER_NAME);

	return name;

}

Dla ka?dego stawiam piwo

[ Dodano: 2017-01-11, 18:43 ]
Parametry bazy danych zamaza?em

[ Dodano: 2017-01-11, 18:57 ]
Ps. W MySQL Password to VARCHAR o d?ugo?ci 24

Nie wiem, mi wszystko dzia?a. Stworzy?em sobie now? baz? danych i do tego stworzy?em tabele members z dwoma warto?ciami Name, Password i dzia?a.

Brakuje Ci w tym kodzie main() {}. Jak dalej nie dzia?a to nie ??czysz si? z baz? danych.

Dziwneee... Bo skrpt wysy?a has?o do bazy danych, ale nie chce go pobra?... A co do main(){} to mam go w moim gmie, rejestracja to tylko wycinek

[ Dodano: 2017-01-11, 20:00 ]
A mapa si? l?czy bo pokazuje w konsoli [MySQL]Connected

[Ps. Masz piwko]

[ Dodano: 2017-01-11, 20:01 ]
EDIT// A podasz jak stworzy?e? te 2 warto?ci ? To by?y VARCHAR o d?ugo?ci 24 ?

KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828

Użytkownik: 05.11.2016
GTAO Member: 20.02.2019
Support-Team: 25.07.2018
Support-Team: 19.01.2019
Test Mod: 08.02.2019

Tak, VARCHAR a ilo?? znak?w to 32 chocia? to i tak nie ma znaczenia. Wyprintuj sobie dane z PlayerLogin(playerid) i sprawd? czy Ci dobrze dane pobiera, mo?liwe ?e co? zgubi?e?.

Edit: Przenie? sobie PlayerLogin i TogglePlayerSpectating do OnPlayerRequestClass

Pawn

public OnPlayerRequestClass(playerid, classid)
{    
    TogglePlayerSpectating(playerid, true);
    PlayerLogin(playerid);
    return 1;
}

Ale has?o ma sie pobiera? przed wybraniem skina

[ Dodano: 2017-01-11, 23:07 ]
ehh pr?bowa?em i nic, widz? ?e za darmo to nikt nie pomo?e opr?cz paru os?b... W takim razie zap?ac?

KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828

Użytkownik: 05.11.2016
GTAO Member: 20.02.2019
Support-Team: 25.07.2018
Support-Team: 19.01.2019
Test Mod: 08.02.2019

Nie rozumiem? Przecie? mi wszystko dzia?a, a to co Ci napisa?em ?eby? da? do OnPlayerRequest to chodzi?o mi bardziej o "ukrycie" strza?ek i spawnu. Ty co? ?le robisz bo mi tu ?miga wszystko.

Ale przecie? serwer wysy?a do mysql zarejestrowane has?o... Ale juz chyba z pobraniem mam b?ad

Cxym to mozr by? spowodowane

Jezeli u cie bie dziala to dla czego taki sam kod u mniej nie dzia?a :.

Zrobi?em komende
CMD:haslo(playerid, params[])
{
New string[500];
Format(string, siezof(string), "Haslo: %s", PlayerCache[playerid][pPassword]);
SendClientMessage(playerid, COLOR_GREEN, string);
return 1;
}

I po wpisaniu tej komendy pojawia sie sam wyraz " Haslo:" I nie pokazuje hasla

[ Dodano: 2017-01-12, 13:55 ]
#include <a_samp>
#include <zcmd>
#include <kolory>
#include <sscanf>
#include <mysql>

main() {}

enum E_PLAYER
{
pUID,
pName[24],
pPassword[24],
pMoney,
pScore,
Float:pHealth,
Float:pArmour,
pSkin,
pRanga
}

new PlayerCache[MAX_PLAYERS][E_PLAYER];
#define D_LOGIN 1
#define D_REGISTER 2
#define D_ACMD 3
#define D_ADMINS 4
#define D_OFFLINE 5
/***********************************************/
//USTAWIENIA
#define CZASZMIANYKAMERY 15000

//ZMIENNE
new CameraMoveTimer[MAX_PLAYERS];
new Cammovcount[MAX_PLAYERS];

public OnGameModeInit()
{
SetGameModeText("TRUCK RP v.1.0");
mysql_init(LOG_ONLY_ERRORS);
mysql_connect("94.23.90.14", "db_21582", "CaBLbRgGZC99", "db_21582");
return 1;
}

public OnPlayerConnect(playerid)
{
PlayerLogin(playerid);
TogglePlayerSpectating(playerid, true);
CameraMove(playerid);
new Distance;
new Float:posX, Float:posY, Float:posZ;
PlayAudioStreamForPlayer(playerid, "https://www.dropbox.com/s/ru1ja6hk05naxck/welcome.mp3?raw=1", Float:posX, Float:posY, Float:posZ, Distance, 0);
new string2[500];
CameraMoveTimer[playerid] = SetTimerEx("CameraMove", CZASZMIANYKAMERY, true, "i", playerid);
format(string2,sizeof(string2)," {FFDC00}Gracz {009BFF}%s {FFDC00}do??czy? na serwer.", PlayerName(playerid));
SendClientMessageToAll(COLOR_WHITE,string2);
print(" ");
print(string2);
print(" ");
SetPlayerHealth(playerid, PlayerCache[playerid][pHealth]);
return 1;
}

SetupPlayerForClassSelection(playerid)
{
SetPlayerPos(playerid, 887.5981,1889.3594,10.8344);
SetPlayerCameraPos(playerid, 889.6438,1889.1420,11.8344);
SetPlayerCameraLookAt(playerid, 887.5981,1889.3594,10.8344);
SetPlayerFacingAngle(playerid, 269.5305);

return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
SetupPlayerForClassSelection(playerid);
return 1;
}

public OnPlayerSpawn(playerid)
{
StopAudioStreamForPlayer(playerid);
return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
new string2[500];
PlayerLogout(playerid);
switch(reason)
{
case 0: format(string2,sizeof(string2)," {8C8C8C}Gracz {00FBFF}%s {8C8C8C}Opu?ci? serwer. {007DFF}[CRASH/TIME OUT]", PlayerName(playerid));
case 1: format(string2,sizeof(string2)," {8C8C8C}Gracz {00FBFF}%s {8C8C8C}Opu?ci? serwer.", PlayerName(playerid));
case 2: format(string2,sizeof(string2)," {8C8C8C}Gracz {00FBFF}%s {8C8C8C}Opu?ci? serwer. {FF0041}[KICK/BAN]", PlayerName(playerid));
}
SendClientMessageToAll(COLOR_WHITE,string2);
print(" ");
print(string2);
print(" ");
return 1;
}

public OnPlayerText(playerid, text[])
{
new Gname[MAX_PLAYER_NAME];
GetPlayerName(playerid,Gname,sizeof(Gname));
new ranga = PlayerCache[playerid][pRanga];
new wiadomosc[500];
new RangaText[64];
if(ranga == 0){RangaText = "{bababa}Nowy";}
if(ranga == 1){RangaText = "{a0a0a0}Gracz";}
if(ranga == 2){RangaText = "{2000c1}Do?wiadczony";}
if(ranga == 3){RangaText = "{9989ff}Legenda";}
if(ranga == 4){RangaText = "VIP";}
if(ranga == 5){RangaText = "{ffd89b}Sponsor";}
if(ranga == 6){RangaText = "{87f975}Test Moderator";}
if(ranga == 7){RangaText = "{26ff05}Junior Moderator";}
if(ranga == 8){RangaText = "{17af00}Moderator";}
if(ranga == 9){RangaText = "{0292f2}Junior Admin";}
if(ranga == 10){RangaText = "{0069af}Admin";}
if(ranga == 11){RangaText = "{ed8a00}Global Admin";}
if(ranga == 12){RangaText = "{820000}Vice HeadAdmin";}
if(ranga == 13){RangaText = "{e20000}HeadAdmin";}
format(wiadomosc, sizeof(wiadomosc), "{FFFFFF}(ID:%d) {BF0000}%s{FFFFFF}(%s{FFFFFF}): %s",playerid,Gname,RangaText,text);
SendClientMessageToAll(COLOR_WHITE, wiadomosc);
print(" ");
print(wiadomosc);
print(" ");
return 0;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if(dialogid == D_LOGIN)
{
if(strlen(inputtext) > 0)
{
if(!strcmp(PlayerCache[playerid][pPassword], inputtext, false))
{
TogglePlayerSpectating(playerid, false);
SpawnPlayer(playerid);
KillTimer(CameraMoveTimer[playerid]);
}
else
{
ShowPlayerDialog(playerid, D_LOGIN, DIALOG_STYLE_PASSWORD, "{11d621}Logowanie", "{EB0000} Has?o nieprawid?owe !\n {FFFFFF}Podaj has?o aby si? zalogowa? !", "OK", "Anuluj");
}
}
else
{
ShowPlayerDialog(playerid, D_LOGIN, DIALOG_STYLE_PASSWORD, "{11d621}Logowanie", "{EB0000} Has?o nieprawid?owe !\n {FFFFFF}Podaj has?o aby si? zalogowa? !", "OK", "Anuluj");
}
}

if(dialogid == D_REGISTER)
{
if(strlen(inputtext) > 0)
{
new query[128];
new string [128];
format(query, sizeof(query), "INSERT INTO members (Name, Password) VALUES('%s', '%s')", PlayerName(playerid), inputtext);
mysql_query(query);
SendClientMessage(playerid, COLOR_LIGHTGREEN, "Rejestracja przebieg?a pomy?lnie !");
format(string, sizeof(string), "Has?o do twojego konta to: %s ", inputtext);
SendClientMessage(playerid, COLOR_LIGHTGREEN, string);
PlayerLogin(playerid);
KillTimer(CameraMoveTimer[playerid]);
}
else
{
Kick(playerid);
}
}
return 0;
}

//STOCKI
stock PlayerLogin(playerid)
{
new query[128];
new data[128];
format(query, sizeof(query), "SELECT * FROM members WHERE name = '%s'", PlayerName(playerid));
mysql_query(query);

mysql_store_result();

if(mysql_fetch_row(data, "|"))
{
sscanf(data, "p<|>ds[24]s[24]ddffdd", PlayerCache[playerid][pUID], PlayerCache[playerid][pName], PlayerCache[playerid][pPassword], PlayerCache[playerid][pMoney], PlayerCache[playerid][pScore], PlayerCache[playerid][pHealth], PlayerCache[playerid][pArmour], PlayerCache[playerid][pSkin], PlayerCache[playerid][pRanga]);
}
else
{
SendClientMessage(playerid, 0xFFFF00FF, "Nie znaleziono Twojego konta!");
ShowPlayerDialog(playerid, D_REGISTER, DIALOG_STYLE_INPUT, "{a50000}Rejestracja", "{00fff2}Witaj na serwerze !\nKonto o tym nicku nie zosta?o jeszcze stworzone !\n{FFFFFF}Wpisz has?o aby dokona? rejestracji !", "OK", "Anuluj");
return 1;
}

mysql_free_result();

ShowPlayerDialog(playerid, D_LOGIN, DIALOG_STYLE_PASSWORD, "{11d621}Logowanie", "{00fff2}Witaj na serwerze !\nKonto o tym nicku zosta?o ju? wcze?niej utworzone !\n{FFFFFF}Podaj has?o aby si? zalogow?:", "OK", "Anuluj");
return 1;
}

stock PlayerLogout(playerid)
{
new query[256];
GetPlayerHealth(playerid, PlayerCache[playerid][pHealth]);
GetPlayerArmour(playerid, PlayerCache[playerid][pArmour]);
PlayerCache[playerid][pMoney] = GetPlayerMoney(playerid);
PlayerCache[playerid][pScore] = GetPlayerScore(playerid);

format(query, sizeof(query), "UPDATE members SET health = '%f', armour = '%f', money = '%d', score = '%d' WHERE uid = '%d'", PlayerCache[playerid][pHealth], PlayerCache[playerid][pArmour], PlayerCache[playerid][pMoney], PlayerCache[playerid][pScore], PlayerCache[playerid][pUID]);
mysql_query(query);
return 1;
}

stock PlayerName(playerid)
{
new name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, MAX_PLAYER_NAME);
return name;
}

stock KickEx(playerid, kickid, powod[])
{
new string[200];
new stringpow[200];
new Gname[MAX_PLAYER_NAME];
new Kickname[MAX_PLAYER_NAME];
GetPlayerName(playerid, Gname, sizeof(Gname));
GetPlayerName(kickid, Kickname, sizeof(Kickname));
format(string, sizeof(string), ">>> Admin %s wyrzuci³ gracza %s",Gname,Kickname);\
format(stringpow, sizeof(stringpow), ">>> Pow?d: %s",powod);
SendClientMessageToAll(COLOR_RED, string);
SendClientMessageToAll(COLOR_RED, stringpow);
SetTimerEx("Kickerr", 100, false, "i", kickid);
return 1;
}

stock BannEx(playerid, banid, powod[])
{
new string[200];
new stringpow[200];
new Gname[MAX_PLAYER_NAME];
new Banname[MAX_PLAYER_NAME];
GetPlayerName(playerid, Gname, sizeof(Gname));
GetPlayerName(banid, Banname, sizeof(Banname));
format(string, sizeof(string), ">>> Admin %s zbanowa³ gracza %s",Gname,Banname);
format(stringpow, sizeof(stringpow), ">>> Pow?d: %s",powod);
SendClientMessageToAll(COLOR_RED, string);
SendClientMessageToAll(COLOR_RED, stringpow);
SetTimerEx("Bannerr", 100, false, "i", banid);
return 1;
}

//TIMERY
forward CameraMove(playerid);
public CameraMove(playerid)
{
if(Cammovcount[playerid] == 0)
{
InterpolateCameraPos(playerid, -903.4108, 1058.1233, 103.1653, -1425.5233, 999.4176, 118.9412, CZASZMIANYKAMERY + 3000, CAMERA_MOVE);
InterpolateCameraLookAt(playerid, -1152.3232, 1017.8775, 75.4375, -1152.3232, 1017.8775, 75.4375, CZASZMIANYKAMERY, CAMERA_MOVE);
Cammovcount[playerid] = 1;
return 1;
}
if(Cammovcount[playerid] == 1)
{
InterpolateCameraPos(playerid, 1004.6501, 1073.3196, 101.6271, 1923.5216, 1493.1898, 75.8794, CZASZMIANYKAMERY + 3000, CAMERA_MOVE);
InterpolateCameraLookAt(playerid, 1540.8579, 1255.2631, 119.9292, 2107.3770, 833.0124, 132.0835, CZASZMIANYKAMERY, CAMERA_MOVE);
Cammovcount[playerid] = 2;
return 1;
}
if(Cammovcount[playerid] == 2)
{
InterpolateCameraPos(playerid, 1400.4580, -827.4955, 116.2382, 774.0320, -1480.4689, 105.7643, CZASZMIANYKAMERY, CAMERA_MOVE);
InterpolateCameraLookAt(playerid, 739.3037, -1572.1199, 100.3714, 753.8964, -1552.0175, 80.9374, CZASZMIANYKAMERY, CAMERA_MOVE);
Cammovcount[playerid] = 0;
return 1;
}
return 1;
}

forward Kickerr(playerid);
public Kickerr(playerid)
{
return Kick(playerid);
}

forward Bannerr(playerid);
public Bannerr(playerid)
{
return Ban(playerid);
}[/code]

daje ca?y kod, mo?e gdzie? tu jest b??d ?

KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828

Użytkownik: 05.11.2016
GTAO Member: 20.02.2019
Support-Team: 25.07.2018
Support-Team: 19.01.2019
Test Mod: 08.02.2019

Bingo! Ju? wiesz gdzie jest b??d a mianowicie w odczytywaniu danych. Wyprintuj sobie tego sscanfa i wszystko b?dziesz wiedzial.

Czyli jak wyprintowa?

? A i jeszcze zauwa?y?em ?e zawsze jak odpalam domowy serwer i wchodz? na niego to w momencie gdy pokazuje sie dialog z logowaniem to s?ycha? d?wi?k b??du systemu, ale nic w logach ani ?aden komunikat sie nie pojawia

KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828

Użytkownik: 05.11.2016
GTAO Member: 20.02.2019
Support-Team: 25.07.2018
Support-Team: 19.01.2019
Test Mod: 08.02.2019

Adikoo1302, u?ywasz do tego funkcji printf. Odsy?am Ci? do SAMP Wiki.

http://wiki.sa-mp.com/wiki/Printf

Wiem ?e jest taka funkcja, ale jak to zastosowa? w moim kodzie

KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828

Użytkownik: 05.11.2016
GTAO Member: 20.02.2019
Support-Team: 25.07.2018
Support-Team: 19.01.2019
Test Mod: 08.02.2019

Z jakiej wersji sscanfa korzystasz?
Pobierz sobie t?:

http://gtao.pl.com/showthread.php?t=570927

Przyk?adowo dajesz tak.

Pawn


printf("Has?o: %s", PlayerCache[playerid][Password]);

Oczywi?cie parametry sobie wstawiasz sam po przecinku i wy?wietlanie w stringu r?wnie?.
W zale?no?ci od tego czy zmienna jest intem, ci?giem znak?w lub floatem.

Zrobi?em to tak:
printf("Your Password: %d", PlayerCache[playerid][pPassword]);
pr?bowa?em tak?e tak:
printf("Your Password: %s", PlayerCache[playerid][pPassword]);

Odpowied? od tego z %d :
Your Password: 0

Odpowied? od tego z %s:
Your Password:

czyli nie pobiera mi danych ? Dlaczego

Jak temu zaradzi? ?

[ Dodano: 2017-01-12, 16:16 ]
MrKacu13,
Podasz gg albo jaki? kontakt ? Je?eli pomo?esz, zap?ac?

KONTAKT:
GG: 60968224
Discord: Adiś.exe#3828

Użytkownik: 05.11.2016
GTAO Member: 20.02.2019
Support-Team: 25.07.2018
Support-Team: 19.01.2019
Test Mod: 08.02.2019

Na pewno tworzy Ci si? rekord(konto)? W phpmyadmin w strukturze tabeli members pole ID na pewno masz ustawione na AUTO_INCREMENT oraz g??wny klucz?