MYSQL Register - Printable Version

MYSQL Register - 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 Register (/showthread.php?tid=500341)

MYSQL Register - Blademaster680 - 12.03.2014

For some reason, when I register in the game it doesnt create the row with the player data like it should. I have to keep registering. Its something to do with the "INSERT" line.
Anyone that can help?

Here is my code:

Код:

case DIALOG_REGISTER:
	    {
	        if(response)
	        {
			    if(strlen(inputtext) == 0)
			    {
			        new IP[16], str[128], string[168];
			        GetPlayerIp(playerid, IP, 16);
			        format(string, sizeof(string), "Welcome to Legion of Los Angeles, %s \n\n IP Address: %s \n\n You may register an account by entering a desired password here:", GetName(playerid), IP);
		            ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, str, string, "Register", "Cancel");
				}
				else
				{
				    new EscapedText[60], Query[168];
				    new skin = 1+random(298);
				    mysql_real_escape_string(inputtext, EscapedText);
				    format(Query, sizeof(Query), "INSERT INTO playerdata (Name, Password, Cash, Bank, Level, PosX, PosY, PosZ, AdminLevel) VALUES ('%s', MD5('%s'), 5000, 10000, 1, 1780.1759, -1933.6698, 13.3859, 0)", GetName(playerid), EscapedText);
				    mysql_query(Query);
				    SendClientMessage(playerid, -1, "You have successfully registered.");
				    GivePlayerMoney(playerid, 5000);
				    SetPlayerScore(playerid, 1);
				    SetSpawnInfo(playerid, 0, skin, 1780.1759, -1933.6698, 13.3859, 356.5534, 0, 0, 0, 0, 0, 0);
    				SpawnPlayer(playerid);
				    
				}
			}
		}

Thanks

Re: MYSQL Register - Matess - 12.03.2014

Bigger query?

Re: MYSQL Register - Keyhead - 12.03.2014

pawn Код:

format(Query, sizeof(Query), "INSERT INTO `playerdata` (`Name`, `Password`, `Cash`, `Bank`, `Level`, `PosX`, `PosY`, `PosZ`, `AdminLevel`) VALUES ('%s', MD5('%s'), '5000', '10000', '1', '1780.1759', '-1933.6698', '13.3859', '0')", GetName(playerid), EscapedText);

Try this but, have you made the table in the database?

Re: MYSQL Register - Blademaster680 - 12.03.2014

Quote:

Bigger query?

That helped thanks, Cant believe I didnt think of that