[JasonRiggs]

Code:

format(query), sizeof(query), "SELECT  FROM accounts WHERE name = '%s'", pName;

this is a wrong use change it to this

Code:

format(query, sizeof(query), "SELECT FROM accounts WHERE name = '%s'", pName);

Same to this

Code:

	format(query), sizeof(query), "SELECT  FROM accounts WHERE name = '%s'", pName;

change to this

Code:

format(query, sizeof(query), "SELECT FROM accounts WHERE name = '%s' AND PASSWORD = '%s'", pName, inputtext);

and these lines

Code:

SendClientMessage(playerid, -1, "You have succesfully logged in!",
 		SetSpawnInfo(playerid, 1, 299, 1, 2, 3, 1, 1, 1, 999, 1, 999,
 		SpawnPlayer(playerid),;

to these

Code:

SendClientMessage(playerid, -1, "You have succesfully logged in!");
 		SetSpawnInfo(playerid, 1, 299, 1, 2, 3, 1, 1, 1, 999, 1, 999);
 		SpawnPlayer(playerid);

These

Code:

SendClientMessage(playerid, -1, "Incorrect password!",
			ShowPlayerDialog(playerid, 0, DIALOG_STYLE_INPUT, "Login", "Please enter your password to login.", "Login", "Cancel"),
 		,

to those

Code:

SendClientMessage(playerid, -1, "Incorrect password!");
			ShowPlayerDialog(playerid, 0, DIALOG_STYLE_INPUT, "Login", "Please enter your password to login.", "Login", "Cancel");

And finally

Code:

GetPlayerName(playerid, pName, sizeof(pName) );
			format (query, sizeof(query), "INSERT INTO accounts VALUES('%s', '%s')", pName, inputtext);
			mysql_query(query),

			SendClientMessage(playerid, -1, "You have succesfully registered your account!",
			
			SetSpawnInfo(playerid, 1, 299, 1, 2, 3, 1, 1, 1, 999, 1, 999,
			SpawnPlayer(playerid),

should be changed to

Code:

GetPlayerName(playerid, pName, sizeof(pName));
			format (query, sizeof(query), "INSERT INTO accounts VALUES('%s', '%s')", pName, inputtext);
			mysql_query(query),

			SendClientMessage(playerid, -1, "You have succesfully registered your account!");
			
			SetSpawnInfo(playerid, 1, 299, 1, 2, 3, 1, 1, 1, 999, 1, 999);
			SpawnPlayer(playerid);

Concentration man