MySQL error
#3

Quote:
Originally Posted by NeamPojma
View Post
Do you have closing " quotes?
yes, check the error code
my register code
HTML Code:
		case 126:
		{
			new string[200];
                        new nam[24]; format(nam, 24, PlayerInfo[playerid][Nick]);
			if(!response)
			{

				format(string, sizeof(string),""cwhite"Welcome {0080FF}%s "cwhite"you are already registered\nKindly enter password to {0080FF}login"cwhite" to your account\n"cred"Please Register", nam);
				return ShowPlayerDialogEx(playerid, 126, DIALOG_STYLE_INPUT, "Register",string,"Register","");
			}
			        if (strlen(inputtext) < 4 || strlen(inputtext) > 20) {
				format(string, sizeof(string),""cwhite"Welcome {0080FF}%s "cwhite"you are already registered\nKindly enter password to {0080FF}login"cwhite" to your account\n"cred"Too short or Too long Password", nam);
				return ShowPlayerDialogEx(playerid, 126, DIALOG_STYLE_INPUT, "Register",string,"Register","");
			}
			new query[505];
			WP_Hash(PlayerInfo[playerid][Pass], 129, inputtext);
			mysql_format(mysql, query, sizeof(query), "INSERT INTO `playerbase` (`name`, `pass`, `ip`, `adminlvl`, `vip`, `money`, `medkit` ,`armourpack`, `score`,`inclan`,`clanlead`,`clanown`,`ddm`,`dcbdm`,`dsdm`,`head`, `dmusickit`,`clancoown`,`classes`,`XP`,`VPB`) VALUES ('%e','%s', '%s', 0, 0, 0, 0, 0, 0,-1,-1,-1,0,0,0,0,0,-1,'00000000000000000000',0,0)", nam,PlayerInfo[playerid][Pass],PlayerInfo[playerid][lastip]);
			mysql_tquery(mysql, query, "OnAccountRegister", "di", playerid, rCheck[playerid]);
			PlayerInfo[playerid][LoggedIn] = true;
			GiveCash(playerid,100000);
			SetPlayerScore(playerid,15);
			SendClientMessage(playerid, -1, "*You are {0080FF}registered {FFFFFF}and logged in");
			PlayerPlaySound(playerid,1057,0.0,0.0,0.0);
		}
Reply


Messages In This Thread
MySQL error - by PemburuHantu - 23.04.2020, 01:01
Re: MySQL error - by NeamPojma - 23.04.2020, 01:43
Re: MySQL error - by PemburuHantu - 23.04.2020, 02:10
Re: MySQL error - by SiaReyes - 23.04.2020, 04:23
Re: MySQL error - by PemburuHantu - 23.04.2020, 05:50
Re: MySQL error - by PemburuHantu - 25.04.2020, 01:49
Re: MySQL error - by SiaReyes - 25.04.2020, 01:52
Re: MySQL error - by ShadowMortar - 25.04.2020, 07:47
Re: MySQL error - by Kent - 25.04.2020, 11:41
Re: MySQL error - by Kwarde - 25.04.2020, 14:57

Forum Jump:


Users browsing this thread: 3 Guest(s)