Incorrect password AP designs HELP

Incorrect password AP designs HELP - 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: Incorrect password AP designs HELP (/showthread.php?tid=547914)

Incorrect password AP designs HELP - kexy96 - 26.11.2014

Hi all!

I have AP designs Roleplay gamemode. I start mode and i register for server, the mysql is Save my account. I log off , and I log in and i try write my password and dont work , its write:"incorrect password"

I think problem is:

Код:

case DIALOG_LOGIN:
		{
	        if(!response){ SendClientMessage(playerid, COLOR_RED, "You decided to quit from the server."); Kick(playerid);}
	        if(response)
	        {
	            new query[1000],escapepass[26];
		        mysql_real_escape_string(inputtext, escapepass);
				format(query, sizeof(query), "SELECT Tutorial,Level,Cash,Admin,AdminPass,AdminLogged,AdminDuty,Skin,Posx,Posy,Posz,VWorld,Interior,Age,Gender,Kicks,Banned,Bans,Muted,Faction,Rank,Job,House FROM Accounts WHERE Username = '%s' AND Password = '%s'", pName(playerid), escapepass);
				mysql_query(query);
				mysql_store_result();
				if(mysql_num_rows() != 0)
			    {
					if(mysql_fetch_row_format(query, "|"))
					{
						sscanf(query,"p<|>ddddddddfffdddddddddddd",
						    
							PlayerInfo[playerid][Tutorial],
							PlayerInfo[playerid][Level],
							PlayerInfo[playerid][Cash],
							PlayerInfo[playerid][Admin],
							PlayerInfo[playerid][AdminPass],
							PlayerInfo[playerid][AdminLogged],
							PlayerInfo[playerid][AdminDuty],
							PlayerInfo[playerid][Skin],
							PlayerInfo[playerid][Posx],
							PlayerInfo[playerid][Posy],
							PlayerInfo[playerid][Posz],
							PlayerInfo[playerid][VWorld],
							PlayerInfo[playerid][Interior],
							PlayerInfo[playerid][Age],
							PlayerInfo[playerid][Gender],
							PlayerInfo[playerid][Kicks],
							PlayerInfo[playerid][Banned],
							PlayerInfo[playerid][Bans],
							PlayerInfo[playerid][Muted],
							PlayerInfo[playerid][Faction],
							PlayerInfo[playerid][Rank],
							PlayerInfo[playerid][Job],
							PlayerInfo[playerid][House]);

					}
					else
					{
					    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Incorrect Password: Input your password", "Login", "Cancel");
					}

HELP me, i dont know the problem

and don't have error,warning.. :/

Re: Incorrect password AP designs HELP - Raweresh - 26.11.2014

Try it:

Код:

case DIALOG_LOGIN:
		{
	        if(!response){ SendClientMessage(playerid, COLOR_RED, "You decided to quit from the server."); Kick(playerid);}
	        if(response)
	        {
	            new query[1000],escapepass[26];
		        mysql_real_escape_string(inputtext, escapepass);
				format(query, sizeof(query), "SELECT Tutorial,Level,Cash,Admin,AdminPass,AdminLogged,AdminDuty,Skin,Posx,Posy,Posz,VWorld,Interior,Age,Gender,Kicks,Banned,Bans,Muted,Faction,Rank,Job,House FROM Accounts WHERE Username = '%s' AND Password = '%s'", pName(playerid), escapepass);
				mysql_query(query);
				mysql_store_result();
				if(mysql_num_rows() != 0)
			    {
					if(mysql_fetch_row_format(query, "|"))
					{
						sscanf(query,"p<|>ddddddddfffdddddddddddd",

							PlayerInfo[playerid][Tutorial],
							PlayerInfo[playerid][Level],
							PlayerInfo[playerid][Cash],
							PlayerInfo[playerid][Admin],
							PlayerInfo[playerid][AdminPass],
							PlayerInfo[playerid][AdminLogged],
							PlayerInfo[playerid][AdminDuty],
							PlayerInfo[playerid][Skin],
							PlayerInfo[playerid][Posx],
							PlayerInfo[playerid][Posy],
							PlayerInfo[playerid][Posz],
							PlayerInfo[playerid][VWorld],
							PlayerInfo[playerid][Interior],
							PlayerInfo[playerid][Age],
							PlayerInfo[playerid][Gender],
							PlayerInfo[playerid][Kicks],
							PlayerInfo[playerid][Banned],
							PlayerInfo[playerid][Bans],
							PlayerInfo[playerid][Muted],
							PlayerInfo[playerid][Faction],
							PlayerInfo[playerid][Rank],
							PlayerInfo[playerid][Job],
							PlayerInfo[playerid][House]);

					}
				}
				else
				{
				    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Incorrect Password: Input your password", "Login", "Cancel");
				}

Re: Incorrect password AP designs HELP - kexy96 - 26.11.2014

Код:

C:\Users\Rendszergazda\Desktop\UJSZERVER!!!\gamemodes\testsamp.pwn(1169) : warning 217: loose indentation
C:\Users\Rendszergazda\Desktop\UJSZERVER!!!\gamemodes\testsamp.pwn(1213) : warning 217: loose indentation
C:\Users\Rendszergazda\Desktop\UJSZERVER!!!\gamemodes\testsamp.pwn(1213) : error 014: invalid statement; not in switch
C:\Users\Rendszergazda\Desktop\UJSZERVER!!!\gamemodes\testsamp.pwn(1213) : warning 215: expression has no effect
C:\Users\Rendszergazda\Desktop\UJSZERVER!!!\gamemodes\testsamp.pwn(1213) : error 001: expected token: ";", but found ":"
C:\Users\Rendszergazda\Desktop\UJSZERVER!!!\gamemodes\testsamp.pwn(1213) : error 029: invalid expression, assumed zero
C:\Users\Rendszergazda\Desktop\UJSZERVER!!!\gamemodes\testsamp.pwn(1213) : fatal error 107: too many error messages on one line

Error