Проблема Не спавнит после регистрации

[polovnev1 0]

MySQL r39-2 

MySQL выдает лог :

[spoiler=Тэк][ERROR] CMySQLQuery::Execute[Registr] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Name', 'Level', 'Skin', 'Sex', 'Pass') VALUES ('Polo_Kirl', '1', 'пароль', '1'' at line 1

 

Сама строка :

mysql_format(ConnectMySQL, string, sizeof(string), "INSERT INTO `accounts` ('Name', 'Level', 'Skin', 'Sex', 'Pass') VALUES ('%s', '%d', '%s', '%d', '%d')", GN(playerid), PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pPass], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pSkin]);
mysql_function_query(ConnectMySQL, string, true, "Registr", "d", playerid);

Stock со спавном 

stock SetPlayerSpawn(playerid)
{
	SetPlayerSkin(playerid, PlayerInfo[playerid][pSkin]);
	SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
	if(PlayerInfo[playerid][pLevel] > 0)
	{
	    SetPlayerPos(playerid, 2549.7544,-2204.5852,21.9585);
	    SetPlayerFacingAngle(playerid, 358.8031);
	    SetPlayerInterior(playerid, 0);
	    SetPlayerVirtualWorld(playerid, 0);
	    SetCameraBehindPlayer(playerid);
	}
}

GN(playerid) это PlayerInfo[playerid][pName]

 

Сам Registr 

publics Registr(i)
{
	new string[128];
	mysql_format(ConnectMySQL, string, sizeof(string), "SELECT * FROM `accounts` WHERE `Name` = '%e' AND `Pass` = '%e', GN(i), PlayerInfo[i][pPass]");
	return mysql_function_query (ConnectMySQL, string, true, "OnLogin", "d", i);
}

Диолог :

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	new string[250];
	switch(dialogid)
	{
	    case 1:
	    {
	        if(response)
	        {
	    		if(!strlen(inputtext))
	    		{
	    	    	f("{FFFFFF}?????????? ??? {00FFFF}%s{FFFFFF}!\n{FFFFFF}????? ?????????? ?? ?????? {7CFC00}PoloCRMP{FFFFFF}|{FFD700}Role_Play\n\n{FFFFFF}?? ??? ?? ????????????????\n{FFFFFF}??????? ??????:", GN(playerid));
	    			SPD(playerid, 1, DSI, "???????????", string, "?????", "?????");
	    			return true;
	    		}
    			for(new i = strlen(inputtext); i != 0; --i)
     			switch(inputtext[i])
            	{
                	case '?'..'?', '?'..'?': return SPD(playerid, 1, DSI, "{FF0000}??????!", "{FF4500}?????? ?? ?????? ????????? ??????? ?????!\n\n??????? ?????? ??????????? ???????:", "??", "?????");
            	}
				if(strlen(inputtext) < 5 || strlen(inputtext) > 24) return SPD(playerid, 1, DSI, "{FF0000}??????!", "{FF4500}?????? ?? ?????? ???? ?????? 5-?? ? ?? ?????? 24 ????????!\n\n??????? ?????? ??????:", "??", "?????");
				strmid(PlayerInfo[playerid][pPass], inputtext, 0, strlen(inputtext), 24);
				SPD(playerid, 2, DSM, "????? ????", "{FF1493}???????? ???", "???????", "???????");
			}
			else
			{
	   			SCM(playerid, COLOR_RED, "????? ????? ??? ????? ?????? ??????? /q ??? /q(uit).");
			    Kickk(playerid);
			}
	    }
	    case 2:
	    {
	        if(response)
	        {
	            PlayerInfo[playerid][pSex] = 1;
	            PlayerInfo[playerid][pSkin] = 3;
	        }
	        else
	        {
	            PlayerInfo[playerid][pSex] = 2;
	            PlayerInfo[playerid][pSkin] = 13;
	        }
	        PlayerInfo[playerid][pLevel] = 1;
			mysql_format(ConnectMySQL, string, sizeof(string), "INSERT INTO `accounts` ('Name', 'Level', 'Skin', 'Sex', 'Pass') VALUES ('%s', '%d', '%s', '%d', '%d')", GN(playerid), PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pPass], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pSkin]);
			mysql_function_query(ConnectMySQL, string, true, "Registr", "d", playerid);
			Login[playerid] = true;
			SpawnPlayer(playerid);
			SCM(playerid, COLOR_GREEN, "??????????? ??? ? ???????? ????????????!!!");
	    }
		case 3:
		{
		    if(response)
		    {
		    
		    }
		    else
		    {
		        SCM(playerid, COLOR_RED, "????? ????? ??? ????? ?????? ??????? /q ??? /q(uit).");
			    Kickk(playerid);
		    }
		}
	
	return 1;
}

Странные символы это русские буквы. 

 

ах да после реги появляеться надпись "STAY WITHIN THE WORLD BOUNDRIES" без ковычек

Мод писал с нуля

[SCRIPTMAN 358]

 

 

ах да после реги появляеться надпись "STAY WITHIN THE WORLD BOUNDRIES" без ковычек

в OnGameModeInit в самое начало вставь это:

AddPlayerClass(2, 1958.33, 1343.12, 15.36, 269.15, 26, 36, 28, 150, 0, 0);

 

 

Странные символы это русские буквы. 

просто когда копируешь из Pawno куда-то - смотри, чтобы была русская раскладка.

 

 

 

mysql_format(ConnectMySQL, string, sizeof(string), "INSERT INTO `accounts` ('Name', 'Level', 'Skin', 'Sex', 'Pass') VALUES ('%s', '%d', '%s', '%d', '%d')", GN(playerid), PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pPass], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pSkin]); mysql_function_query(ConnectMySQL, string, true, "Registr", "d", playerid);

mysql_format(ConnectMySQL, string, sizeof(string), "INSERT INTO `accounts` ('Name', 'Level', 'Skin', 'Sex', 'Pass') VALUES ('%s', '%d', '%d', '%d', '%s')", GN(playerid), PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pPass]);
mysql_function_query(ConnectMySQL, string, true, "Registr", "d", playerid);

Скинь OnLogin.

В OnPlayerSpawn прописано:?

SetPlayerSpawn(playerid);