Login Problem
#1

Код:
	new String[150];
	if(dialogid == DIALOG_LOGIN)
	{
	    if(response)
		{
		    format(Query,500,"SELECT * FROM `Players` WHERE `PlayerName` = '%s' AND `PlayerPassword` = '%s'",PlayerName[playerid],inputtext);
			new DBResult:DatabaseResult = db_query(Database,Query);
			if(!db_num_rows(DatabaseResult))
			{
			    SendClientMessage(playerid,0,""RED">>> Podałeś nieprawidłowe hasło.");
			    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Logowanie",""WHITE">>> Witaj ponownie na serwerze.\n"WHITE">>> Twуj nick został znaleziony w naszej bazie danych.\n"WHITE">>> Wpisz poniżej hasło do konta podane podczas rejestracji.","Ok","Anuluj");
				return 1;
			}
			db_free_result(DatabaseResult);
			new FieldDateOfRegister[20];
			db_get_field_assoc(DatabaseResult,"PlayerDateOfRegister",FieldDateOfRegister,20);
			format(PlayerDateOfRegister[playerid],20,"%s",strlen(FieldDateOfRegister));
			db_free_result(DatabaseResult);
			new FieldVisits[20];
			db_get_field_assoc(DatabaseResult,"PlayerVisits",FieldVisits,20);
			PlayerVisits[playerid] = strval(FieldVisits);
			db_free_result(DatabaseResult);
			new FieldMoney[20];
			db_get_field_assoc(DatabaseResult,"PlayerMoney",FieldMoney,20);
			PlayerMoney[playerid] = strval(FieldMoney);
			db_free_result(DatabaseResult);
			new FieldRespect[20];
			db_get_field_assoc(DatabaseResult,"PlayerRespect",FieldRespect,20);
			PlayerRespect[playerid] = strval(FieldRespect);
			db_free_result(DatabaseResult);
			new FieldLevel[5];
			db_get_field_assoc(DatabaseResult,"PlayerLevel",FieldLevel,5);
			PlayerLevel[playerid] = strval(FieldLevel);
			db_free_result(DatabaseResult);
			new FieldRespectToNextLevel[20];
			db_get_field_assoc(DatabaseResult,"PlayerRespectToNextLevel",FieldRespectToNextLevel,20);
			PlayerRespectToNextLevel[playerid] = strval(FieldRespectToNextLevel);
			db_free_result(DatabaseResult);
			new FieldSuicides[20];
			db_get_field_assoc(DatabaseResult,"PlayerSuicides",FieldSuicides,20);
			PlayerSuicides[playerid] = strval(FieldSuicides);
			db_free_result(DatabaseResult);
			new FieldDeaths[20];
			db_get_field_assoc(DatabaseResult,"PlayerDeaths",FieldDeaths,20);
			PlayerDeaths[playerid] = strval(FieldDeaths);
			db_free_result(DatabaseResult);
			new FieldKills[20];
			db_get_field_assoc(DatabaseResult,"PlayerKills",FieldKills,20);
			PlayerKills[playerid] = strval(FieldKills);
			db_free_result(DatabaseResult);
			new FieldRconAdministrator[1];
			db_get_field_assoc(DatabaseResult,"PlayerRconAdministrator",FieldRconAdministrator,1);
			PlayerRconAdministrator[playerid] = strval(FieldRconAdministrator);
			db_free_result(DatabaseResult);
			new FieldHeadAdministrator[1];
			db_get_field_assoc(DatabaseResult,"PlayerHeadAdministrator",FieldHeadAdministrator,1);
			PlayerHeadAdministrator[playerid] = strval(FieldHeadAdministrator);
			db_free_result(DatabaseResult);
			new FieldAdministrator[1];
			db_get_field_assoc(DatabaseResult,"PlayerAdministrator",FieldAdministrator,1);
			PlayerAdministrator[playerid] = strval(FieldAdministrator);
			db_free_result(DatabaseResult);
			new FieldJuniorAdministrator[1];
			db_get_field_assoc(DatabaseResult,"PlayerJuniorAdministrator",FieldJuniorAdministrator,1);
			PlayerHeadAdministrator[playerid] = strval(FieldJuniorAdministrator);
			db_free_result(DatabaseResult);
			new FieldModerator[1];
			db_get_field_assoc(DatabaseResult,"PlayerModerator",FieldModerator,1);
			PlayerModerator[playerid] = strval(FieldModerator);
			db_free_result(DatabaseResult);
			new FieldVip[1];
			db_get_field_assoc(DatabaseResult,"PlayerVip",FieldVip,1);
			PlayerVip[playerid] = strval(FieldVip);
			db_free_result(DatabaseResult);
			PlayerVisits[playerid] += 1;
			PlayerLoggedIn[playerid] = 1;
			SendClientMessage(playerid,0,""GREEN">>> Zalogowałeś się pomyślnie, życzymy miłej gry.");
		}
		if(!response)
		{
		    format(String,150,""RED">>> Gracz "DARK_RED"%s (%d) "RED"został wyrzucony. Powуd: Anulowanie logowania.",PlayerName[playerid],playerid);
		    SendClientMessageToAll(0,String);
		    Kick(playerid);
		}
	}
I logged in and is crashed server.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)