[20:12:37] CMySQLHandler::Query(SELECT c.player_uid FROM `members` m, `srv_characters` c WHERE m.`members_pass_hash` = MD5(CONCAT(MD5(m.members_pass_salt),'', MD5('xxx123'))) AND m.`member_id` = c.`global_id` AND c.`nickname` = 'Tomy_Gun' LIMIT 1) - An error has occured. (Error ID: 1267, Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=')
[20:12:37] >> mysql_store_result( Connection handle: 1 )
[20:12:37] CMySQLHandler::StoreResult() - No data to store.
[20:12:37] >> mysql_num_rows( Connection handle: 1 )
[20:12:37] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[20:12:37] >> mysql_fetch_int( Connection handle: 1 )
[20:12:37] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[20:12:37] >> mysql_query( Connection handle: 1 )

public OnPlayerLogin(playerid, charid)
{
	new query[512],
	last_online,
	logged,
	data[64];
	
	mysql_query_format("SELECT * FROM `srv_characters` WHERE `player_uid` = '%d' LIMIT 1", charid);
	
	mysql_store_result();
	if(mysql_num_rows())
	{
		mysql_fetch_row_format(query);
		sscanf(query,  "p<|>dds[24]ddddddfddddfffdddddddddddddddddddddddddddddfdd",
		CharacterInfo[playerid][pUID],
		CharacterInfo[playerid][pGID],
		CharacterInfo[playerid][pNick],
		CharacterInfo[playerid][pAge],
		CharacterInfo[playerid][pSex],
		CharacterInfo[playerid][pSkin],
		CharacterInfo[playerid][pCash],
		CharacterInfo[playerid][pHours],
		CharacterInfo[playerid][pMinutes],
		CharacterInfo[playerid][pHealth],
		CharacterInfo[playerid][pAdmin],
		CharacterInfo[playerid][pHide],
		CharacterInfo[playerid][pCredit],
		CharacterInfo[playerid][pBW],
		CharacterInfo[playerid][pPos][0],
		CharacterInfo[playerid][pPos][1],
		CharacterInfo[playerid][pPos][2],
		CharacterInfo[playerid][pVW],
		CharacterInfo[playerid][pInt],
		CharacterInfo[playerid][pTog],
		CharacterInfo[playerid][pBlock],
		CharacterInfo[playerid][pGlod],
		CharacterInfo[playerid][pSpawnOption],
		CharacterInfo[playerid][pSpawnOptionHouseID],
		CharacterInfo[playerid][pBlockNoGun],
		CharacterInfo[playerid][pBlockNoCar],
		CharacterInfo[playerid][pBlockNoOOC],
		CharacterInfo[playerid][pBlockNoRun],
		CharacterInfo[playerid][pJail],
		CharacterInfo[playerid][pJailTime],
		logged,
		last_online,
		CharacterInfo[playerid][pOnlineToday],
		CharacterInfo[playerid][pJob],
		CharacterInfo[playerid][pJobCount],
		CharacterInfo[playerid][pDocs],
		CharacterInfo[playerid][pPhone],
		CharacterInfo[playerid][pKanal],
		CharacterInfo[playerid][pHotel],
		CharacterInfo[playerid][pPenaltyPoints],
		CharacterInfo[playerid][pStrength],
		CharacterInfo[playerid][pStrengthToday],
		CharacterInfo[playerid][pDriverPenalty],
		CharacterInfo[playerid][pCelebrity],
		CharacterInfo[playerid][pFightStyle],
		CharacterInfo[playerid][pSuplement],
		CharacterInfo[playerid][pLastDMG],
		CharacterInfo[playerid][pLastHB],
		CharacterInfo[playerid][pLastWEAP]);
		
		mysql_free_result();
		// Wczytywanie informacji OOC
		format(query,sizeof(query),"SELECT `members_display_name`, `score`,  `premium`, `warn`, `curse`, `aj` FROM `members` WHERE `member_id` = '%d'", CharacterInfo[playerid][pGID]);
		mysql_query(query);
		mysql_store_result();
		
		while(mysql_fetch_row_format(data, "|") == 1)
			sscanf(data, "p<|>s[32]ddddd", CharacterInfo[playerid][pGlobalNick], CharacterInfo[playerid][pGlobalScore], CharacterInfo[playerid][pPremium], CharacterInfo[playerid][pWarn], CharacterInfo[playerid][pCurse], CharacterInfo[playerid][pAJ]);
		
		mysql_free_result();
		
		if(CheckBan(playerid, CharacterInfo[playerid][pGID]))
		{
			msg_info(playerid,"Twoje konto jest niekatywne lub posiada aktywną banicję.\nJeśli jest to błąd - zapraszamy na forum.");
			KickWithWait(playerid);
		}
		else if((CharacterInfo[playerid][pBlock] & BLOCK_CHAR) || (CharacterInfo[playerid][pBlock] & BLOCK_CK))
		{
			msg_info(playerid,"Twoja postać została zablokowana lub uśmiercona.");
			KickWithWait(playerid);
		}		
		else if(CharacterInfo[playerid][pBlock] & BLOCK_BAN)
		{
			msg_info(playerid,"Twoja postać została zbanowana.");
			KickWithWait(playerid);
		}
		else
		{
			ForeachPlayer(i)
			{
				if(CharacterInfo[i][pGID] == CharacterInfo[playerid][pGID] && Logged[i])
				{
					msg_error(playerid, "Jedna z Twoich postaci jest już zalogowana na serwerze.");
					KickWithWait(playerid);
					break;
				}
			}
			
			format(query,sizeof(query),"UPDATE `srv_characters` SET `logged` = '1', `last_online` = '%d' WHERE `player_uid` = '%d'", gettime(), CharacterInfo[playerid][pUID]);
			mysql_query(query);
			
			format(query,sizeof(query),"INSERT INTO `srv_login_logs` VALUES ('%d','%d','%s','%d')", CharacterInfo[playerid][pGID], CharacterInfo[playerid][pUID], GetAccountIP(playerid), gettime());
			mysql_query(query);

			LoadPlayerGroups(playerid);
			
			if(!(CharacterInfo[playerid][pTog] & TOG_QS) && (gettime()-last_online < 900))
				CharacterInfo[playerid][pTog] += TOG_QS;
			
			if(Spawned[playerid] < 5)
				Spawned[playerid] = 5;
			
			SetPlayerSpawn(playerid);
			
			TogglePlayerSpectating(playerid, false);
			
			SpawnPlayer(playerid);
			
			if(CharacterInfo[playerid][pTog] & TOG_QS)
				SetTimerEx("PlayerTogQsOffOnLogin", 1500, false, "i", playerid);
			
			// Ustawianie HP
			SetPlayerHealth(playerid, CharacterInfo[playerid][pHealth]);
			SetPlayerScore(playerid, CharacterInfo[playerid][pGlobalScore]);
			
			// Aktualizacja gotуwki
			ResetPlayerMoney(playerid);
			GivePlayerMoney(playerid, CharacterInfo[playerid][pCash]);
			
			//Skill broni
			SetPlayerSkillLevel(playerid, 0, 500);
			SetPlayerSkillLevel(playerid, 1, 999);
			SetPlayerSkillLevel(playerid, 2, 999);
			SetPlayerSkillLevel(playerid, 3, 999);
			SetPlayerSkillLevel(playerid, 4, 500);
			SetPlayerSkillLevel(playerid, 5, 500);
			SetPlayerSkillLevel(playerid, 6, 500);
			SetPlayerSkillLevel(playerid, 7, 999);
			SetPlayerSkillLevel(playerid, 8, 500);
			SetPlayerSkillLevel(playerid, 9, 500);
			SetPlayerSkillLevel(playerid, 10, 500);
			
			switch(CharacterInfo[playerid][pFightStyle])
			{
				case 0:
					SetPlayerFightingStyle(playerid, FIGHT_STYLE_GRABKICK);
				case 1:
					SetPlayerFightingStyle(playerid, FIGHT_STYLE_BOXING);
				case 2:
					SetPlayerFightingStyle(playerid, FIGHT_STYLE_KUNGFU);
				case 3:
					SetPlayerFightingStyle(playerid, FIGHT_STYLE_KNEEHEAD);
				default:
					SetPlayerFightingStyle(playerid, FIGHT_STYLE_GRABKICK);
			}
			
			// Ustawienia TOG
			if(!(CharacterInfo[playerid][pTog] & TOG_NAME))
			{
				TextDrawShowForPlayer(playerid, TD_IRPName);
				TextDrawShowForPlayer(playerid, TD_IRPName2);
			}
			
			if(!(CharacterInfo[playerid][pTog] & TOG_LSN))
			{
				TextDrawShowForPlayer(playerid, TD_LSN);
				TextDrawShowForPlayer(playerid, TD_LSN2);
			}
			
			// Aktualizacja głodu
			FoodBar[playerid] = CreatePlayerProgressBar(playerid, 548.4, 28.0, 57.7, 4.5, COLOR_GREEN, 100.0);
			if(!(CharacterInfo[playerid][pTog] & TOG_GLOD))
			{
				ShowPlayerProgressBar(playerid, FoodBar[playerid]);
				
				SetPlayerProgressBarValue(playerid, FoodBar[playerid], CharacterInfo[playerid][pGlod]);
				UpdatePlayerProgressBar(playerid, FoodBar[playerid]);
			}

			//włączenie telefonu
			new phone = CharacterInfo[playerid][pPhone];
			if(phone && ItemInfo[phone][iType] == ITEM_TYPE_TELEFON && ItemInfo[phone][iOwnerTyp] == OWNER_PLAYER &&  ItemInfo[phone][iOwner] == CharacterInfo[playerid][pUID])
			{
				ItemInfo[phone][iUsed] = 1;
				format(query,sizeof(query),"UPDATE `srv_items` SET `used` = 1 WHERE `uid` = '%d' LIMIT 1", phone);
				mysql_query(query);
			}
			else
				CharacterInfo[playerid][pPhone] = 0;
			
			// Informacje startowe //CC990
			new first_string[144]; 
			format(first_string, sizeof(first_string),"** {ffffff}Witaj %s na "DEF_COLOR"SeasonLife.pl!", CharacterInfo[playerid][pGlobalNick]);
			SendClientMessage(playerid, COLOR_GREEN, first_string);
			format(first_string, sizeof(first_string),"** {ffffff}Zalogowano się na postać: "DEF_COLOR"%s {ffffff}(ID: %d, UID: %d)", PlayerName2(playerid), playerid, CharacterInfo[playerid][pUID]);
			SendClientMessage(playerid, COLOR_GREEN, first_string);
			
			if(CharacterInfo[playerid][pAdmin])
			{
				switch(CharacterInfo[playerid][pAdmin])
				{
					case 1:
						format(first_string,sizeof(first_string),"** {FFFFFF}Status konta: {FF9900}Opiekun");
					case 2,3,4:
						format(first_string,sizeof(first_string),"** {FFFFFF}Status konta: {8B00B0}GameMaster");
					case 5:
						format(first_string,sizeof(first_string),"** {FFFFFF}Status konta: {B00000}Administrator");
					case 6:
						format(first_string,sizeof(first_string),"** {FFFFFF}Status konta: {FF0000}Administrator Głуwny");	
				}
				SendClientMessage(playerid, COLOR_GREEN, first_string);
			}
			else if(IsPlayerPremium(playerid)) SendClientMessage(playerid, COLOR_GREEN, "** {ffffff}Status konta: {FCDF1E}Premium{FFFFFF}.");
			else SendClientMessage(playerid, COLOR_GREEN, "** {ffffff}Status konta: Użytkownik (brak premium).");
			
			#if defined DEBUG_MODE
				SendClientMessage(playerid, COLOR_RED, "Tryb testowy aktywny!");
			#endif
			
			for(new i=1;i<MAX_PLAYER_GROUPS;i++)
				if(MemberGroup[playerid][i][GroupID] && strlen(GroupInfo[MemberGroup[playerid][i][GroupID]][gNotice])>4)
					SendClientMessageFormat(playerid, GetGroupColor(MemberGroup[playerid][i][GroupID]), "[GRUPA][%s] Ogłoszenie: %s", GroupInfo[MemberGroup[playerid][i][GroupID]][gTag], GroupInfo[MemberGroup[playerid][i][GroupID]][gNotice]);
			
			if(SettingInfo[sPremiumEventDays] && !IsPlayerPremium(playerid))
			{
				SendClientMessageFormat(playerid, COLOR_YELLOW, "[INFO] W związku z trwającym aktualnie eventem otrzymujesz KONTO PREMIUM na okres %d dni.", SettingInfo[sPremiumEventDays]);
				
				GivePlayerPremium(playerid, SettingInfo[sPremiumEventDays]);
			}
			
			if(IsPlayerPremium(playerid))
			{
				CharacterInfo[playerid][pNickColor] = COLOR_PREMIUM;
				SetPlayerColor(playerid, COLOR_PREMIUM);
			}
			else
			{
				CharacterInfo[playerid][pNickColor] = COLOR_USER;
				SetPlayerColor(playerid, COLOR_USER);
			}
			
			Attach3DTextLabelToPlayer(NameTags[playerid], playerid, 0.0, 0.0, 0.2);
			
			Attach3DTextLabelToPlayer(Description[playerid], playerid, 0.0, 0.0, -0.6);
			
			if(!IsPlayerNPC(playerid))
				Logged[playerid] = true;
			
			SetPlayerMapIcon(playerid, 0, 548.1733, -1277.9405, 17.2482, 55, 0, MAPICON_GLOBAL);
			//ICONID 10-30 zajęte na cornery
			
			for(new d = 0; d<MAX_DOORS_MAPICONS; d++)
			{
				if(DOORS_MAPICONS[playerid][d] != -1)
					DestroyDynamicMapIcon(DOORS_MAPICONS[playerid][d]);
				
				DOORS_MAPICONS[playerid][d] = -1;
			}
			
			for(new i = 0; i<_DOOR_COUNT; i++)
			{
				if(DoorsInfo[i][dIconID])
				{
					new icon = -1;
					for(new s = 0; s<MAX_DOORS_MAPICONS; s++)
					{
						if(DOORS_MAPICONS[playerid][s] == -1)
						{
							icon = s;
							break;
						}
					}
					
					DOORS_MAPICONS[playerid][icon] = CreateDynamicMapIcon(DoorsInfo[i][dEnterX], DoorsInfo[i][dEnterY], DoorsInfo[i][dEnterZ], DoorsInfo[i][dIconID], 0, -1, -1, playerid, -1, MAPICON_LOCAL );
				}
			}
			
			new gangid;
			if((gangid = IsPlayerInGroupType(playerid,GROUP_GANG)))
				for(new i=1;i<MAX_CORNERS;i++)
					if(CornerInfo[i][cOwner]==gangid)
						SetPlayerMapIcon(playerid, CornerInfo[i][cIcon], CornerInfo[i][cPosX], CornerInfo[i][cPosY], CornerInfo[i][cPosZ], 23, 0, MAPICON_LOCAL_CHECKPOINT);
		}
	}

	return 1;
}