Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Проблема с авторизацией на MySql R8

Статус
В этой теме нельзя размещать новые ответы.
p1zde0z

p1zde0z

Ученик
Проблема заключается в том что после авторизации персонажа появляется диалоговое окно с выбором пола.В чем дело не знаю.Может кто сталкивался с этой проблемой?Помогите...У меня открытие 21 декабря!
Вот диалоговые окна авторизации с регистрацией:
[/CODE] case 55:
{
if(response)
{
if(!strlen(inputtext))
{
format(string,500,"{FFFFFF}Добро Пожаловать на сервер {0080FF}Titanic-Rp\n{FFFFFF}Ваш аккаунт зарегистрирован\n\nЛогин: {0080FF}%s\n{FFFFFF}Введите пароль указанный при регистрации:", Name(playerid));
SPD(playerid, 55, 3,"{0080FF}Авторизация",string,"Войти","Отмена");
return true;
}
for(new i = strlen(inputtext); i != 0; --i)
switch(inputtext)
{
case 'А'..'Я', 'а'..'я', ' ':
return SPD(playerid, 55, 0, "Ошибка!", "{00FF21}Введенный вами пароль содержит русские буквы.\n Смените раскладку клавиатуры!", "Повтор", "");
}
new string2[200];
format(string2, sizeof(string2), "SELECT * FROM `"TABLE_ACCOUNT"` WHERE name = '%s'",Name(playerid));
mysql_query(string2);
mysql_store_result();
if(mysql_fetch_row_format(string2))
{
BaseGet("pKey",PlayerInfo[playerid][pKey]);
}
OnPlayerLoginToServer(playerid,(inputtext));
}
else
{
SCM(playerid, 0xFF6347AA, "Для выхода из игры используйте /q(uit)");
fix_kick(playerid);
}
}[/CODE]
Код: 
public OnPlayerRequestClass(playerid, classid)
{
	SetPlayerCameraPos(playerid,1543.4708,-2428.6719,52.8717);
	SetPlayerCameraLookAt(playerid,1543.5131,-2421.0459,52.8717);
	new bac[500];
	if(PlayerInfo[playerid][pLogin] == 1) return SpawnPlayer(playerid);
	format(LIFECMDstr, sizeof(LIFECMDstr), "SELECT `Name` FROM `"TABLE_ACCOUNT"` WHERE Name = '%s'",Name(playerid));
	mysql_query(LIFECMDstr);
	mysql_store_result();
	if(mysql_fetch_row_format(LIFECMDstr))
	{
		format(bac, sizeof(bac),"{FFFFFF}Добро Пожаловать на сервер {0080FF}Titanic-Rp\n{FFFFFF}Ваш аккаунт зарегистрирован\n\nЛогин: {0080FF}%s\n{FFFFFF}Введите пароль указанный при регистрации:", Name(playerid));
		SPD(playerid, 55, 3,"{0080FF}Авторизация",bac,"Войти","Отмена");
	}
	else
	{
		format(bac, sizeof(bac),"{FFFFFF}Добро Пожаловать на сервер {0080FF}Titanic-Rp\n{FFFFFF}Чтобы начать игру вам необходимо пройти регистрацию\n\nВведите пароль для вашего аккаунта\nОн будет запрашиваться каждый раз, когда вы входите на сервер\n\n{0080FF}			Примечания:\n			- Пароль может состоять из руских и латинских символов\n			- Пароль чуствителен к регистру\n			- Длинна пароля от 6-ти до 15-ти символов",Name(playerid));
		SPD(playerid, 142, 3,"{0080FF}Регистрация",bac,"Войти","Отмена");
	}
	//mysql_free_result();
	return true;
}
Вот public OnPlayerSpawn
Код: 
public OnPlayerSpawn(playerid)
{
	SetPVarInt(playerid,"K_Chater",0);
	SetPVarInt(playerid, "NoAB", 1);
	SetPVarInt(playerid,"K_Times",0);
	FullyConnected[playerid] = true;
	//==========================================================================
	if(PlayerInfo[playerid][pLogin] == 0) return SCM(playerid, 0xB4B5B7FF, "Необходимо авторизоваться!"), fix_kick(playerid);
	if(PlayerInfo[playerid][pMember] > 0) SetPlayerSkin(playerid, PlayerInfo[playerid][pModel]);
	if(PlayerInfo[playerid][pMember] <= 0) SetPlayerSkin(playerid, PlayerInfo[playerid][pChar]);
	if(PlayerInfo[playerid][pHP] > 100) PlayerInfo[playerid][pHP] = 100;
	if(PlayerInfo[playerid][pWantedLevel] >= 1)
	{
		WantedPoints[playerid] = PlayerInfo[playerid][pWantedLevel];
		WantedLevel[playerid] = PlayerInfo[playerid][pWantedLevel];
		SetPlayerWantedLevel(playerid, PlayerInfo[playerid][pWantedLevel]);
	}
	//==========================================================================
	SetPlayerHealthAC(playerid, PlayerInfo[playerid][pHP]);
	//==========================================================================
	StopAudioStreamForPlayer(playerid);
	ResetPlayerWeapons(playerid);
	SetPlayerToTeamColor(playerid);
	SetPlayerWeapons(playerid);
	SetPlayerSkills(playerid);
	SetCameraBehindPlayer(playerid);
	PlayerPlaySound(playerid, 1188, 0.0, 0.0, 0.0);
	if(PlayerInfo[playerid][pTut] == 0)
	{
		SetPlayerHealthAC(playerid,100);
		PlayerInfo[playerid][pHP] = 100;
		SetPlayerCameraPos(playerid,-1020.5228,1127.1028,59.0580);
		SetPlayerCameraLookAt(playerid,-1157.9843,1063.6970,59.0580);
		PlayerPlaySound(playerid, 1188, 0.0, 0.0, 0.0);
        SPD(playerid, 147, 0,"{E2A71C}Пол","        {FFFFFF}Теперь выберите пол вашего персонажа:","Мужчина","Женщина");
		TogglePlayerControllable(playerid, 0);
	}
	if(PlayerInfo[playerid][pJailed] == 1)
	{
		if(PlayerInfo[playerid][pMestoJail] == 1)
		{
			SetPlayerInterior(playerid, 6);
			SetPlayerPos(playerid,264.1425,77.4712,1001.0391);
			SetPlayerFacingAngle(playerid, 263.0160);
			return true;
		}
		if(PlayerInfo[playerid][pMestoJail] == 2)
		{
			SetPlayerInterior(playerid, 10);
			SetPlayerPos(playerid,219.5400,109.9767,999.0156);
			SetPlayerFacingAngle(playerid, 1.0000);
			return true;
		}
		if(PlayerInfo[playerid][pMestoJail] == 3)
		{
			SetPlayerInterior(playerid, 3);
			SetPlayerPos(playerid,198.3642,161.8103,1003.0300);
			SetPlayerFacingAngle(playerid, 1.0000);
			return true;
		}
	}
	else if(PlayerInfo[playerid][pJailed] == 4)
	{
		SetPlayerInterior(playerid, 0);
		SetPlayerPos(playerid,RandomPrison[random(sizeof(RandomPrison))][0],RandomPrison[random(sizeof(RandomPrison))][1],RandomPrison[random(sizeof(RandomPrison))][2]);
		SetPlayerFacingAngle(playerid,RandomPrison[random(sizeof(RandomPrison))][3]);
		return true;
	}
	if(PlayerInfo[playerid][pCheat] == 1)
	{
		SetPlayerInterior(playerid, 18);
		SetPlayerPos(playerid,-219.7144,1410.6461,27.7734);
		SetPlayerFacingAngle(playerid, 276.6526);
		SetPlayerVirtualWorld(playerid, 1);
		SCM(playerid, 0xFF6347AA, "Мы рекомендуем вам удалить чит программу");
		return true;
	}
	SetPlayerVirtualWorld(playerid,0);
	if(PlayerInfo[playerid][pPhousekey] != 255)
	{
		if(PlayerInfo[playerid][pMember] == 0)
		{
			if(PlayerInfo[playerid][pSex] == 1 || PlayerInfo[playerid][pSex] == 2)
			{
				if(SpawnChange[playerid])
				{
					SetPlayerInterior(playerid,HouseInfo[PlayerInfo[playerid][pPhousekey]][hInt]);
					SetPlayerPos(playerid, HouseInfo[PlayerInfo[playerid][pPhousekey]][hExitx], HouseInfo[PlayerInfo[playerid][pPhousekey]][hExity],HouseInfo[PlayerInfo[playerid][pPhousekey]][hExitz]);
					PlayerInfo[playerid][pLocal] = PlayerInfo[playerid][pPhousekey];
					PlayerInfo[playerid][pInt] = HouseInfo[PlayerInfo[playerid][pPhousekey]][hInt];
					SetPlayerVirtualWorld(playerid, PlayerInfo[playerid][pPhousekey]+50);
					return true;
				}
			}
		}
	}
	if(PlayerInfo[playerid][pPhousekey] != 255)
	{
		if(SpawnChange[playerid])
		{
			SetPlayerInterior(playerid,HouseInfo[PlayerInfo[playerid][pPhousekey]][hInt]);
			SetPlayerPos(playerid, HouseInfo[PlayerInfo[playerid][pPhousekey]][hExitx], HouseInfo[PlayerInfo[playerid][pPhousekey]][hExity],HouseInfo[PlayerInfo[playerid][pPhousekey]][hExitz]); // Warp the player
			PlayerInfo[playerid][pLocal] = PlayerInfo[playerid][pPhousekey];
			PlayerInfo[playerid][pInt] = HouseInfo[PlayerInfo[playerid][pPhousekey]][hInt];
			SetPlayerVirtualWorld(playerid, PlayerInfo[playerid][pPhousekey]+50);
			return true;
		}
	}
	switch(PlayerInfo[playerid][pMember])
	{
	case 2:
		{
			SetPlayerInterior(playerid, 5);
			SetPlayerPos(playerid, 322.4131,316.9056,999.1484);
			PlayerInfo[playerid][pInt] = 10;
			SetPlayerFacingAngle(playerid, 180.5557);
			return true;
		}
	case 3:
		{
			if(forma[playerid] == 1)
			{
				SetPlayerSkin(playerid, 252);
				SetPlayerInterior(playerid, 0);
				SetPlayerPos(playerid, -1346.2050,492.3983,11.2027);
				PlayerInfo[playerid][pInt] = 0;
				SetPlayerVirtualWorld(playerid, 0);
				return true;
			}
			SetPlayerInterior(playerid, 0);
			SetPlayerPos(playerid, -1346.2050,492.3983,11.2027);
			PlayerInfo[playerid][pInt] = 0;
			SetPlayerVirtualWorld(playerid, 0);
			return true;
		}
	case 10:
		{
			SetPlayerInterior(playerid, 10);
			SetPlayerPos(playerid, 225.1647,121.0442,999.0786);
			SetPlayerFacingAngle(playerid, 89.0733);
			PlayerInfo[playerid][pInt] = 10;
			return true;
		}
	case 20:
		{
			SetPlayerInterior(playerid, 3);
			SetPlayerPos(playerid, 373.8919,192.2131,1014.1875);
			SetPlayerFacingAngle(playerid, 182.7769);
			PlayerInfo[playerid][pInt] = 3;
			SetPlayerVirtualWorld(playerid, 2);
			return true;
		}
	case 19:
		{
			if(forma[playerid] == 1)
			{
				SetPlayerSkin(playerid, 252);
				SetPlayerInterior(playerid, 0);
				SetPlayerPos(playerid, 241.7503,1852.6790,8.7578);
				PlayerInfo[playerid][pInt] = 0;
				SetPlayerVirtualWorld(playerid, 0);
				return true;
			}
			SetPlayerInterior(playerid, 0);
			SetPlayerPos(playerid, 241.7503,1852.6790,8.7578);
			PlayerInfo[playerid][pInt] = 0;
			SetPlayerVirtualWorld(playerid, 0);
			return true;
		}
	case 21:
		{
			SetPlayerInterior(playerid, 3);
			SetPlayerPos(playerid, 211.3636,184.3113,1003.0313);
			SetPlayerFacingAngle(playerid, 174.3579);
			PlayerInfo[playerid][pInt] = 122;
			SetPlayerVirtualWorld(playerid, 122);
			return true;
		}
	case 9:
		{
			SetPlayerInterior(playerid, 3);
			SetPlayerPos(playerid, 373.8919,192.2131,1014.1875);
			SetPlayerFacingAngle(playerid, 182.7769);
			PlayerInfo[playerid][pInt] = 3;
			SetPlayerVirtualWorld(playerid, 1);
			return true;
		}
	case 16:
		{
			SetPlayerInterior(playerid, 0);
			SetPlayerPos(playerid, 654.3481,-1349.8336,13.5756);
			SetPlayerFacingAngle(playerid, 2.0000);
			SetPlayerVirtualWorld(playerid, 0);
			lNews[playerid] = 0;
			return true;
		}
	case 6:
		{
			SetPlayerInterior(playerid, 5);
			SetPlayerFightingStyle (playerid, FIGHT_STYLE_KUNGFU);
			SetPlayerPos(playerid, 1265.7104,-793.7453,1084.0078);
			PlayerInfo[playerid][pInt] = 5;
			SetPlayerVirtualWorld(playerid, 0);
			return true;
		}
	case 14:
		{
			SetPlayerFightingStyle (playerid, FIGHT_STYLE_BOXING);
			SetPlayerInterior(playerid, 5);
			SetPlayerPos(playerid, 1265.7104,-793.7453,1084.0078);
			PlayerInfo[playerid][pInt] = 5;
			SetPlayerVirtualWorld(playerid, 1);
			return true;
		}
	case 11:
		{
			SetPlayerPos(playerid, -2031.7778,-117.3789,1035.1719);
			SetPlayerFacingAngle(playerid, 268.5241);
			SetPlayerInterior(playerid,3);
			PlayerInfo[playerid][pInt] = 3;
			SetPlayerVirtualWorld(playerid, 1);
			return true;
		}
	case 5:
		{
			SetPlayerFightingStyle (playerid, FIGHT_STYLE_KNEEHEAD);
			SetPlayerInterior(playerid, 5);
			SetPlayerPos(playerid, 1265.7104,-793.7453,1084.0078);
			PlayerInfo[playerid][pInt] = 5;
			SetPlayerVirtualWorld(playerid, 2);
			return true;
		}
	case 22:
		{
			SetPlayerInterior(playerid, 0);
			SetPlayerVirtualWorld(playerid, 0);
			SetPlayerPos(playerid, 2034.5505,-1405.2250,17.2393);
			SetPlayerFacingAngle(playerid, 150.1613);
			Medics += 1;
			return true;
		}
	case 4:
		{
			SetPlayerInterior(playerid, 15);
			SetPlayerVirtualWorld(playerid, 3);
			SetPlayerPos(playerid, 372.0985,-53.2946,1076.4708);
			SetPlayerFacingAngle(playerid, 90.0000);
			return true;
		}
	case 12:
		{
			SetPlayerPos(playerid, -61.2984,1364.5847,1080.2109);
			SetPlayerFacingAngle(playerid, 100);
			SetPlayerInterior(playerid,6);
			SetPlayerVirtualWorld(playerid, 34);
			PlayerInfo[playerid][pInt] = 6;
			return true;
		}
	case 18:
		{
			SetPlayerInterior(playerid, 8);
			SetPlayerVirtualWorld(playerid, 63);
			SetPlayerPos(playerid, 2817.0813,-1168.2172,1025.5778);
			RemovePlayerAttachedObject(playerid, 1);
			PlayerInfo[playerid][pInt] = 0;
			return true;
		}
	case 17:
		{
			SetPlayerFacingAngle(playerid, 90.4248);
			SetPlayerPos(playerid, -49.7558,1400.3553,1084.4297);
			SetPlayerInterior(playerid,8);
			SetPlayerVirtualWorld(playerid, 36);
			PlayerInfo[playerid][pInt] = 0;
			return true;
		}
	case 13:
		{
			SetPlayerInterior(playerid, 4);
			SetPlayerVirtualWorld(playerid, 75);
			SetPlayerFacingAngle(playerid, 263.0497);
			SetPlayerPos(playerid, 308.7524,306.6759,1003.3047);
			PlayerInfo[playerid][pInt] = 0;
			return true;
		}
	case 15:
		{
			SetPlayerInterior(playerid, 3);
			SetPlayerVirtualWorld(playerid, 0);
			SetPlayerPos(playerid, 2492.3748,-1703.7333,1018.3438);
			SetPlayerFacingAngle(playerid, 0.191693);
			PlayerInfo[playerid][pInt] = 3;
			SetPlayerVirtualWorld(playerid, 1);
			return true;
		}
	case 8:
		{
			SetPlayerInterior(playerid, 18);
			SetPlayerVirtualWorld(playerid, 1);
			SetPlayerPos(playerid, -226.2673,1408.9325,27.7734);
			SetPlayerFacingAngle(playerid, 178.6021);
			return true;
		}
	case 1:
		{
			SetPlayerInterior(playerid, 6);
			SetPlayerPos(playerid, 235.8750,73.5106,1005.0391);
			PlayerInfo[playerid][pInt] = 6;
			SetPlayerVirtualWorld(playerid, 0);
			return true;
		}
	case 7:
		{
			SetPlayerInterior(playerid, 3);
			SetPlayerPos(playerid, 373.8919,192.2131,1014.1875);
			SetPlayerFacingAngle(playerid, 182.7769);
			PlayerInfo[playerid][pInt] = 3;
			SetPlayerVirtualWorld(playerid, 0);
			return true;
		}
	case 23:
		{
			PlayerInfo[playerid][pInt] = 0;
			SetPlayerInterior(playerid, 0);
			SetPlayerVirtualWorld(playerid, 0);
			SetPlayerPos(playerid, -1633.2841,-2235.5200,31.4766);
			SetPlayerFacingAngle(playerid, 180.1550);
			return true;
		}
	case 24:
		{
			PlayerInfo[playerid][pInt] = 0;
			SetPlayerInterior(playerid, 0);
			SetPlayerVirtualWorld(playerid, 0);
			SetPlayerPos(playerid, 1707.8319,1082.4387,11.0859);
			SetPlayerFacingAngle(playerid, 154.9711);
			return true;
		}
	}
	if(PlayerInfo[playerid][pLevel] >= 1 && PlayerInfo[playerid][pLevel] <= 2014)
	{
		    SetPlayerPos(playerid,1402.8489,-1691.0475,18.5759);
			SetPlayerFacingAngle(playerid, 353.6634);
			SetPlayerInterior(playerid,0);
			PlayerInfo[playerid][pInt] = 0;
			SetPlayerVirtualWorld(playerid, 0);
			return true;
	}
	if(PlayerInfo[playerid][pPhousekey] == 255)
	{
		SetPlayerHealth(playerid,100);
		PlayerInfo[playerid][pHP] = 100;
	}
	return true;
}

И сорри,ошибся MySql версии R5

---------- Post added at 20:10 ---------- Previous post was at 19:33 ----------

Пожайлуста!Ну помогите долблюсь с этой проблемой уже 3 недели!
 
Последнее редактирование:
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу