Problema Comanda

xNoAir · February 15, 2017

Nu se salveaza banul primeste 3/3 warn, dar tot se poate connecta pe sever

CMD:warn(playerid, params[])
{
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "Trebuie sa te loghezi  mai intai.");
    if(IsPlayerConnected(playerid))
     {
        if (PlayerInfo[playerid][pAdmin] >= 1)
        {
            new id,reason[128],string[200],giveplayer[30],sendername[30];
            if(sscanf(params, "us[128]", id, reason)) return SCM(playerid,COLOR_DS,"{00FF00}Folosire{FFFFFF}: /warno <Name/Playerid> <reason>");
            {
                if(IsPlayerConnected(id))
                {
                    new ip[25];
                    GetPlayerIp(id, ip, sizeof(ip));
                    if(id != INVALID_PLAYER_ID)
                    {
                        GetPlayerName(id, giveplayer, sizeof(giveplayer));
                        GetPlayerName(playerid, sendername, sizeof(sendername));
                        PlayerInfo[id][pWarns] += 1;
                        format(string, sizeof(string), "You warned %s, reason: %s", giveplayer, reason);
                        SendClientMessage(playerid, COLOR_LIGHTRED, string);
                        format(string, sizeof(string), "You were warned by %s, reason: %s", sendername, reason);
                        SendClientMessage(id, COLOR_LIGHTRED, string);
                        format(string, sizeof(string), "AdmCmd: %s was warned by %s, reason: %s", giveplayer, sendername, reason);
                        SendClientMessageToAll(COLOR_LIGHTRED, string);
                        format(string, sizeof(string), "AdmCmd: %s was warned by %s, reason: %s", giveplayer, sendername, reason);
                        Adminlog(string);
                        Update(id,pWarnsx);
                        if(PlayerInfo[id][pWarns] >= 3)
                        {
                            new year,month,day;
                            getdate(year, month, day);
                            day += 2;
                            if (IsMonth31(month))
                            {
                                if (day > 31)
                                {
                                    month += 1;
                                    if (month > 12)
                                    {
                                        year += 1;
                                        while(day > 31) day -= 31;
                                    }
                                    else while(day > 31) day -= 31;
                                }
                            }
                            else if (!IsMonth31(month))
                            {
                                if (day > 30)
                                {
                                    month += 1;
                                    if (month > 12)
                                    {
                                        year += 1;
                                        while(day > 30) day -= 30;
                                    }
                                    else while(day > 30) day -= 30;
                                }
                            }
                            else if (!IsMonth31(month) && IsMonth29(year) && month == 2)
                            {
                                if (day > 29)
                                {
                                    month += 1;
                                    if (month > 12)
                                    {
                                        year += 1;
                                        while(day > 29) day -= 29;
                                    }
                                    else while(day > 29) day -= 29;
                                }
                            }
                            else if (!IsMonth31(month) && !IsMonth29(year) && month == 2)
                            {
                                if (day > 28)
                                {
                                    month += 1;
                                    if (month > 12)
                                    {
                                        year += 1;
                                        while(day > 28) day -= 28;
                                    }
                                    else while(day > 28) day -= 28;
                                }
                            }
                            PlayerInfo[id][pBTemp] = 1;
                            PlayerInfo[id][pBYear] = year;
                            PlayerInfo[id][pBMonth] = month;
                            PlayerInfo[id][pBDay] = day;
                            strmid(PlayerInfo[id][pBBy], sendername, 0, strlen(sendername), 255);
                            strmid(PlayerInfo[id][pBReason], reason, 0, strlen(reason), 255);
                            Update(id,pBTempx);
                            Update(id,pBYearx);
                            Update(id,pBMonthx);
                            Update(id,pBDayx);
                            Update(id,pBByx);
                            Update(id,pBReasonx);
                            PlayerInfo[id][pWarns] = 0;
                            Update(id,pWarnsx);
                            format(string, sizeof(string), "AdmCmd: %s was banned by AdmBot for 2 days (had 3 Warnings), reason: %s", giveplayer,reason);
                            SendClientMessageToAll(COLOR_LIGHTRED, string);
                            Banlog(ip,PlayerInfo[id][pSQLID],PlayerInfo[playerid][pSQLID],"3 Warnings",2);
                            KickEx(id);
                        }
                        Warnlog(ip,PlayerInfo[id][pSQLID],PlayerInfo[playerid][pSQLID],reason);
                    }
                }
                else return SendClientMessage(playerid, COLOR_DS, "{FFFFCC}Error: Player not connected.");
            }
        }
        else return SendClientMessage(playerid, COLOR_DS,  AdminOnly);
    }
    return 1;
}

Edited February 15, 2017 by xNoAir

WopsS · February 15, 2017

Vezi la functia de autentificare daca verifici daca are interdictie pe server.

Krusher · February 15, 2017

Daca primeste ban prin comanda [/ban] se mai poate conecta? Daca nu, da-ne comanda [/ban], daca in continuare se poate conecta si la [/ban] da-ne OnPlayerConnect/OnPlayerLogin sau cum ai tu in gm.

AddisoN · February 15, 2017

Din cate vad pare a fi gm bigzone, eu primieam niste warninguri mysql il legatura cu pBtemp,pBday,pBmounth si pByear. Verifica logoul mysql,e posibil ca acele campuri sa lipseasca din baza de date sau sa fie apelate gresit in GM. (Logul mysql in format html sa il verifici)

xNoAir · February 16, 2017

23 hours ago, Krusher said:

Daca primeste ban prin comanda [/ban] se mai poate conecta? Daca nu, da-ne comanda [/ban], daca in continuare se poate conecta si la [/ban] da-ne OnPlayerConnect/OnPlayerLogin sau cum ai tu in gm.

poftim comanda ban, da la comanda ban nu se mai poate connecta, dar am mai multe variante de prima /ban care ii da permanent, si a doua banex si aia pe zile, si la aia se poate conecta dinou

CMD:ban(playerid, params[])
{
	if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "Trebuie sa te loghezi  mai intai.");
	if(IsPlayerConnected(playerid))
 	{
		if (PlayerInfo[playerid][pAdmin] >= 3)
		{
			new id,reason[128],string[200],giveplayer[30],sendername[30],Type,str[128];
			if(sscanf(params, "uds[128]", id,Type,reason)) return SCM(playerid,COLOR_DS,"{00FF00}Folosire{FFFFFF}: /ban <Name/Playerid> <Type(1-account 2-permanent)> <reason>");
   			if(IsPlayerConnected(id))
			{
			    if(id != INVALID_PLAYER_ID)
			    {
                    GetPlayerName(id, giveplayer, sizeof(giveplayer));
					GetPlayerName(playerid, sendername, sizeof(sendername));
					if(Type == 1)
					{
						format(string, sizeof(string), "AdmCmd: %s a fost banat de %s, motiv: %s", giveplayer, sendername, reason);
						SendClientMessageToAll(COLOR_LIGHTRED, string);
						PlayerInfo[id][pBanned] = 1;
	                    SendClientMessage(id,COLOR_LIGHTRED,"[BAN INFO]: Poti face o cerere de unban pe forumul nostru.Forumul este http://SincePlay.RO/.");
	                    SendClientMessage(id,COLOR_LIGHTRED,"[HINT]: Te sfatuim sa faci o poza la aceste informatii,si sa o postezi cand faci cerere unban.Apasa F8 pentru a face poza.");
						format(str,sizeof(str),"UPDATE users SET `Banned`='1' WHERE `name`='%s'",giveplayer);
						mysql_query(SQL,str);
						new ip[25];
				    	GetPlayerIp(id, ip, sizeof(ip));
						Banlog(ip,PlayerInfo[id][pSQLID],PlayerInfo[playerid][pSQLID],reason,0);
						KickEx(id);
					}
					else if(Type == 2)
					{
						format(string, sizeof(string), "AdmCmd: %s a fost banat de %s, motiv: %s", giveplayer, sendername, reason);
						SendClientMessageToAll(COLOR_LIGHTRED, string);
						PlayerInfo[id][pBanned] = 1;
	                    SendClientMessage(id,COLOR_LIGHTRED,"[BAN INFO]: Poti face o cerere de unban pe forumul nostru.Forumul este http://SincePlay.RO/.");
	                    SendClientMessage(id,COLOR_LIGHTRED,"[HINT]: Te sfatuim sa faci o poza la aceste informatii,si sa o postezi cand faci cerere unban.Apasa F8 pentru a face poza.");
            			format(str,sizeof(str),"UPDATE users SET `Banned`='1' WHERE `name`='%s'",giveplayer);
						mysql_query(SQL,str);
						new ip[25];
				    	GetPlayerIp(id, ip, sizeof(ip));
						Banlog(ip,PlayerInfo[id][pSQLID],PlayerInfo[playerid][pSQLID],reason,0);
						Ban(id);
					}
					return 1;
				}
			}
		    else return SendClientMessage(playerid, COLOR_DS, "{FFFFCC}Error: Player not connected.");
		}
		else return SendClientMessage(playerid, COLOR_DS, AdminOnly);
	}
	return 1;
}

Krusher · February 16, 2017

Arata-mi callbackul care incarca datele la logare.

xNoAir · February 16, 2017

4 minutes ago, Krusher said:

Arata-mi callbackul care incarca datele la logare.

      	if(mysql_retrieve_row())
      	{
    		mysql_fetch_field_row(result,"password"); format(PlayerInfo[playerid][pKey], 128, result);
			mysql_fetch_field_row(result,"Level"); PlayerInfo[playerid][pLevel] = strval( result );
			mysql_fetch_field_row(result,"Admin"); PlayerInfo[playerid][pAdmin] = strval( result );
			mysql_fetch_field_row(result,"Helper"); PlayerInfo[playerid][pHelper] = strval( result );
			mysql_fetch_field_row(result,"Premium"); PlayerInfo[playerid][pPremiumAccount] = strval( result );
			mysql_fetch_field_row(result,"ConnectedTime"); PlayerInfo[playerid][pConnectTime] = strval( result );
			mysql_fetch_field_row(result,"Registered"); PlayerInfo[playerid][pReg] = strval( result );
			mysql_fetch_field_row(result,"Sex"); PlayerInfo[playerid][pSex] = strval( result );
			mysql_fetch_field_row(result,"Age"); PlayerInfo[playerid][pAge] = strval( result );
			mysql_fetch_field_row(result,"Origin"); PlayerInfo[playerid][pOrigin] = strval( result );
			mysql_fetch_field_row(result,"Muted"); PlayerInfo[playerid][pMuted] = strval( result );
			mysql_fetch_field_row(result,"MuteTime"); PlayerInfo[playerid][pMuteTime] = strval( result );
			mysql_fetch_field_row(result,"Respect"); PlayerInfo[playerid][pExp] = strval( result );
			mysql_fetch_field_row(result,"Money"); PlayerInfo[playerid][pCash] = strval( result );
			mysql_fetch_field_row(result,"Bank"); PlayerInfo[playerid][pAccount] = strval( result );
			mysql_fetch_field_row(result,"Crimes"); PlayerInfo[playerid][pCrimes] = strval( result );
			mysql_fetch_field_row(result,"Kills"); PlayerInfo[playerid][pKills] = strval( result );
			mysql_fetch_field_row(result,"Deaths"); PlayerInfo[playerid][pDeaths] = strval( result );
			mysql_fetch_field_row(result,"Arrested"); PlayerInfo[playerid][pArrested] = strval( result );
			mysql_fetch_field_row(result,"WantedDeaths"); PlayerInfo[playerid][pWantedDeaths] = strval( result );
			mysql_fetch_field_row(result,"Phonebook"); PlayerInfo[playerid][pPhoneBook] = strval( result );
			mysql_fetch_field_row(result,"LottoNr"); PlayerInfo[playerid][pLottoNr] = strval( result );
			mysql_fetch_field_row(result,"WantedLevel"); PlayerInfo[playerid][pWantedLevel] = strval( result );
			mysql_fetch_field_row(result,"Fishes"); PlayerInfo[playerid][pFishes] = strval( result );
			mysql_fetch_field_row(result,"RFishes"); PlayerInfo[playerid][pRFishes] = strval( result );
			mysql_fetch_field_row(result,"Job"); PlayerInfo[playerid][pJob] = strval( result );
			mysql_fetch_field_row(result,"Paycheck"); PlayerInfo[playerid][pPayCheck] = strval( result );
			mysql_fetch_field_row(result,"HeadValue"); PlayerInfo[playerid][pHeadValue] = strval( result );
			mysql_fetch_field_row(result,"Jailed"); PlayerInfo[playerid][pJailed] = strval( result );
			mysql_fetch_field_row(result,"JailTime"); PlayerInfo[playerid][pJailTime] = strval( result );
			mysql_fetch_field_row(result,"Materials"); PlayerInfo[playerid][pMats] = strval( result );
			mysql_fetch_field_row(result,"Drugs"); PlayerInfo[playerid][pDrugs] = strval( result );
			mysql_fetch_field_row(result,"Leader"); PlayerInfo[playerid][pLeader] = strval( result );
			mysql_fetch_field_row(result,"Member"); PlayerInfo[playerid][pMember] = strval( result );
			mysql_fetch_field_row(result,"Rank"); PlayerInfo[playerid][pRank] = strval( result );
			mysql_fetch_field_row(result,"CChar"); PlayerInfo[playerid][pChar] = strval( result );
			mysql_fetch_field_row(result,"FWarn"); PlayerInfo[playerid][pFACWarns] = strval( result );
			mysql_fetch_field_row(result,"FPunish"); PlayerInfo[playerid][pFpunish] = strval( result );
			mysql_fetch_field_row(result,"Acceptpoints"); PlayerInfo[playerid][pLawyer] = strval( result );
			mysql_fetch_field_row(result,"SexSkill"); PlayerInfo[playerid][pSexSkill] = strval( result );
			mysql_fetch_field_row(result,"LawSkill"); PlayerInfo[playerid][pLawSkill] = strval( result );
			mysql_fetch_field_row(result,"MechSkill"); PlayerInfo[playerid][pMechSkill] = strval( result );
			mysql_fetch_field_row(result,"NewsSkill"); PlayerInfo[playerid][pNewsSkill] = strval( result );
			mysql_fetch_field_row(result,"DrugsSkill"); PlayerInfo[playerid][pDrugsSkill] = strval( result );
			mysql_fetch_field_row(result,"MuncitorSkill"); PlayerInfo[playerid][pMuncitorSkill] = strval( result );
			mysql_fetch_field_row(result,"CamiongiuSkill"); PlayerInfo[playerid][pCamiongiuSkill] = strval( result );
			mysql_fetch_field_row(result,"FishSkill"); PlayerInfo[playerid][pFishSkill] = strval( result );
			mysql_fetch_field_row(result,"MatSkill"); PlayerInfo[playerid][pMatSkill] = strval( result );
			mysql_fetch_field_row(result,"RobSkill"); PlayerInfo[playerid][pRobSkill] = strval( result );
	        mysql_fetch_field_row(result,"pHealth"); PlayerInfo[playerid][pHealth] = floatstr( result );
	        mysql_fetch_field_row(result,"Inter"); PlayerInfo[playerid][pInt] = strval( result );
	        mysql_fetch_field_row(result,"Local"); PlayerInfo[playerid][pLocal] = strval( result );
	        mysql_fetch_field_row(result,"Team"); PlayerInfo[playerid][pTeam] = strval( result );
	        mysql_fetch_field_row(result,"Model"); PlayerInfo[playerid][pModel] = strval( result );
	        mysql_fetch_field_row(result,"PhoneNr"); PlayerInfo[playerid][pPnumber] = strval( result );
	        mysql_fetch_field_row(result,"House"); PlayerInfo[playerid][pPhousekey] = strval( result );
	        mysql_fetch_field_row(result,"Bizz"); PlayerInfo[playerid][pPbiskey] = strval( result );
	        mysql_fetch_field_row(result,"Radio"); PlayerInfo[playerid][pRadioCars] = strval( result );
	        mysql_fetch_field_row(result,"Pos_x"); PlayerInfo[playerid][pPos_x] = floatstr( result );
	        mysql_fetch_field_row(result,"Pos_y"); PlayerInfo[playerid][pPos_y] = floatstr( result );
	        mysql_fetch_field_row(result,"Pos_z"); PlayerInfo[playerid][pPos_z] = floatstr( result );
	        mysql_fetch_field_row(result,"Rob"); PlayerInfo[playerid][pRob] = strval( result );
	        mysql_fetch_field_row(result,"CarLicT"); PlayerInfo[playerid][pCarLicT] = strval( result );
	        mysql_fetch_field_row(result,"CarLic"); PlayerInfo[playerid][pCarLic] = strval( result );
	        mysql_fetch_field_row(result,"FlyLicT"); PlayerInfo[playerid][pFlyLicT] = strval( result );
	        mysql_fetch_field_row(result,"FlyLic"); PlayerInfo[playerid][pFlyLic] = strval( result );
	        mysql_fetch_field_row(result,"BoatLicT"); PlayerInfo[playerid][pBoatLicT] = strval( result );
	        mysql_fetch_field_row(result,"BoatLic"); PlayerInfo[playerid][pBoatLic] = strval( result );
	        mysql_fetch_field_row(result,"FishLicT"); PlayerInfo[playerid][pFishLicT] = strval( result );
	        mysql_fetch_field_row(result,"FishLic"); PlayerInfo[playerid][pFishLic] = strval( result );
	        mysql_fetch_field_row(result,"GunLicT"); PlayerInfo[playerid][pGunLicT] = strval( result );
	        mysql_fetch_field_row(result,"GunLic"); PlayerInfo[playerid][pGunLic] = strval( result );
	        mysql_fetch_field_row(result,"PayDay"); PlayerInfo[playerid][pPayDay] = strval( result );
	        mysql_fetch_field_row(result,"PayDayHad"); PlayerInfo[playerid][pPayDayHad] = strval( result );
	        mysql_fetch_field_row(result,"Tutorial"); PlayerInfo[playerid][pTut] = strval( result );
	        mysql_fetch_field_row(result,"Warnings"); PlayerInfo[playerid][pWarns] = strval( result );
	        mysql_fetch_field_row(result,"Rented"); PlayerInfo[playerid][pRented] = strval( result );
	        mysql_fetch_field_row(result,"Fuel"); PlayerInfo[playerid][pFuel] = strval( result );
	        mysql_fetch_field_row(result,"Married"); PlayerInfo[playerid][pMarried] = strval( result );
	        mysql_fetch_field_row(result,"MarriedTo"); strmid(PlayerInfo[playerid][pMarriedTo], result, 0, strlen(result), 255);
	        mysql_fetch_field_row(result,"WTalkie"); PlayerInfo[playerid][pWTalkie] = strval( result );
	        mysql_fetch_field_row(result,"Lighter"); PlayerInfo[playerid][pLighter] = strval( result );
	        mysql_fetch_field_row(result,"Cigarettes"); PlayerInfo[playerid][pCigarettes] = strval( result );
	        mysql_fetch_field_row(result,"Tow"); PlayerInfo[playerid][pTow] = strval( result );
			mysql_fetch_field_row(result,"Email"); strmid(PlayerInfo[playerid][pEmail], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"RegisterDate"); strmid(PlayerInfo[playerid][pRegistredDate], result, 0, strlen(result), 255);
	        mysql_fetch_field_row(result,"Banned"); PlayerInfo[playerid][pBanned] = strval( result );
            mysql_fetch_field_row(result,"ClanTag"); strmid(PlayerInfo[playerid][pClanTag], result, 0, strlen(result), 255);
            mysql_fetch_field_row(result,"Clan"); PlayerInfo[playerid][pClan] = strval( result );
            mysql_fetch_field_row(result,"Radio2"); PlayerInfo[playerid][pRadio] = strval( result );
            mysql_fetch_field_row(result,"HitT"); PlayerInfo[playerid][pHitT] = strval( result );
            mysql_fetch_field_row(result,"CRank"); PlayerInfo[playerid][pCRank] = strval( result );
			mysql_fetch_field_row(result,"Phone"); PlayerInfo[playerid][pPhone] = strval( result );
			mysql_fetch_field_row(result,"id"); PlayerInfo[playerid][pSQLID] = strval( result );
			mysql_fetch_field_row(result,"referral"); PlayerInfo[playerid][pReferral] = strval( result );
			mysql_fetch_field_row(result,"referralp"); PlayerInfo[playerid][pReferralP] = strval( result );
			mysql_fetch_field_row(result,"HPoints"); PlayerInfo[playerid][pHPoints] = strval( result );
			mysql_fetch_field_row(result,"Gift"); PlayerInfo[playerid][pGift] = strval( result );
	        mysql_fetch_field_row(result,"Carkey"); PlayerInfo[playerid][pPcarkey] = strval( result );
			mysql_fetch_field_row(result,"motokey"); PlayerInfo[playerid][pmotokey] = strval( result );
			mysql_fetch_field_row(result,"helikey"); PlayerInfo[playerid][phelikey] = strval( result );
			mysql_fetch_field_row(result,"prcarkey"); PlayerInfo[playerid][pprcarkey] = strval( result );
			mysql_fetch_field_row(result,"Laptop"); PlayerInfo[playerid][pLaptop] = strval( result );
            mysql_fetch_field_row(result,"Victim"); strmid(PlayerInfo[playerid][pVictim], result, 0, strlen(result), 255);
            mysql_fetch_field_row(result,"Accused"); strmid(PlayerInfo[playerid][pAccused], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Crime1"); strmid(PlayerInfo[playerid][pCrime1], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Crime2"); strmid(PlayerInfo[playerid][pCrime2], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Crime3"); strmid(PlayerInfo[playerid][pCrime3], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"BTemp"); PlayerInfo[playerid][pBTemp] = strval( result );
			mysql_fetch_field_row(result,"BYear"); PlayerInfo[playerid][pBYear] = strval( result );
			mysql_fetch_field_row(result,"BMonth"); PlayerInfo[playerid][pBMonth] = strval( result );
			mysql_fetch_field_row(result,"BDay"); PlayerInfo[playerid][pBDay] = strval( result );
			mysql_fetch_field_row(result,"BBy"); strmid(PlayerInfo[playerid][pBBy], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"BReason"); strmid(PlayerInfo[playerid][pBReason], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Fakea"); PlayerInfo[playerid][pFakea] = strval( result );
			mysql_fetch_field_row(result,"ALeader"); PlayerInfo[playerid][pALeader] = strval( result );
	   	}
	}

Cele care ar trebui sa le incarce ar fi ..BTeamp, BMonth, BDay, BBy, BReason, dar nu se intamplat, daca nu e aici unde sa caut?

Krusher · February 16, 2017

45 minutes ago, xNoAir said:


      	if(mysql_retrieve_row())
      	{
    		mysql_fetch_field_row(result,"password"); format(PlayerInfo[playerid][pKey], 128, result);
			mysql_fetch_field_row(result,"Level"); PlayerInfo[playerid][pLevel] = strval( result );
			mysql_fetch_field_row(result,"Admin"); PlayerInfo[playerid][pAdmin] = strval( result );
			mysql_fetch_field_row(result,"Helper"); PlayerInfo[playerid][pHelper] = strval( result );
			mysql_fetch_field_row(result,"Premium"); PlayerInfo[playerid][pPremiumAccount] = strval( result );
			mysql_fetch_field_row(result,"ConnectedTime"); PlayerInfo[playerid][pConnectTime] = strval( result );
			mysql_fetch_field_row(result,"Registered"); PlayerInfo[playerid][pReg] = strval( result );
			mysql_fetch_field_row(result,"Sex"); PlayerInfo[playerid][pSex] = strval( result );
			mysql_fetch_field_row(result,"Age"); PlayerInfo[playerid][pAge] = strval( result );
			mysql_fetch_field_row(result,"Origin"); PlayerInfo[playerid][pOrigin] = strval( result );
			mysql_fetch_field_row(result,"Muted"); PlayerInfo[playerid][pMuted] = strval( result );
			mysql_fetch_field_row(result,"MuteTime"); PlayerInfo[playerid][pMuteTime] = strval( result );
			mysql_fetch_field_row(result,"Respect"); PlayerInfo[playerid][pExp] = strval( result );
			mysql_fetch_field_row(result,"Money"); PlayerInfo[playerid][pCash] = strval( result );
			mysql_fetch_field_row(result,"Bank"); PlayerInfo[playerid][pAccount] = strval( result );
			mysql_fetch_field_row(result,"Crimes"); PlayerInfo[playerid][pCrimes] = strval( result );
			mysql_fetch_field_row(result,"Kills"); PlayerInfo[playerid][pKills] = strval( result );
			mysql_fetch_field_row(result,"Deaths"); PlayerInfo[playerid][pDeaths] = strval( result );
			mysql_fetch_field_row(result,"Arrested"); PlayerInfo[playerid][pArrested] = strval( result );
			mysql_fetch_field_row(result,"WantedDeaths"); PlayerInfo[playerid][pWantedDeaths] = strval( result );
			mysql_fetch_field_row(result,"Phonebook"); PlayerInfo[playerid][pPhoneBook] = strval( result );
			mysql_fetch_field_row(result,"LottoNr"); PlayerInfo[playerid][pLottoNr] = strval( result );
			mysql_fetch_field_row(result,"WantedLevel"); PlayerInfo[playerid][pWantedLevel] = strval( result );
			mysql_fetch_field_row(result,"Fishes"); PlayerInfo[playerid][pFishes] = strval( result );
			mysql_fetch_field_row(result,"RFishes"); PlayerInfo[playerid][pRFishes] = strval( result );
			mysql_fetch_field_row(result,"Job"); PlayerInfo[playerid][pJob] = strval( result );
			mysql_fetch_field_row(result,"Paycheck"); PlayerInfo[playerid][pPayCheck] = strval( result );
			mysql_fetch_field_row(result,"HeadValue"); PlayerInfo[playerid][pHeadValue] = strval( result );
			mysql_fetch_field_row(result,"Jailed"); PlayerInfo[playerid][pJailed] = strval( result );
			mysql_fetch_field_row(result,"JailTime"); PlayerInfo[playerid][pJailTime] = strval( result );
			mysql_fetch_field_row(result,"Materials"); PlayerInfo[playerid][pMats] = strval( result );
			mysql_fetch_field_row(result,"Drugs"); PlayerInfo[playerid][pDrugs] = strval( result );
			mysql_fetch_field_row(result,"Leader"); PlayerInfo[playerid][pLeader] = strval( result );
			mysql_fetch_field_row(result,"Member"); PlayerInfo[playerid][pMember] = strval( result );
			mysql_fetch_field_row(result,"Rank"); PlayerInfo[playerid][pRank] = strval( result );
			mysql_fetch_field_row(result,"CChar"); PlayerInfo[playerid][pChar] = strval( result );
			mysql_fetch_field_row(result,"FWarn"); PlayerInfo[playerid][pFACWarns] = strval( result );
			mysql_fetch_field_row(result,"FPunish"); PlayerInfo[playerid][pFpunish] = strval( result );
			mysql_fetch_field_row(result,"Acceptpoints"); PlayerInfo[playerid][pLawyer] = strval( result );
			mysql_fetch_field_row(result,"SexSkill"); PlayerInfo[playerid][pSexSkill] = strval( result );
			mysql_fetch_field_row(result,"LawSkill"); PlayerInfo[playerid][pLawSkill] = strval( result );
			mysql_fetch_field_row(result,"MechSkill"); PlayerInfo[playerid][pMechSkill] = strval( result );
			mysql_fetch_field_row(result,"NewsSkill"); PlayerInfo[playerid][pNewsSkill] = strval( result );
			mysql_fetch_field_row(result,"DrugsSkill"); PlayerInfo[playerid][pDrugsSkill] = strval( result );
			mysql_fetch_field_row(result,"MuncitorSkill"); PlayerInfo[playerid][pMuncitorSkill] = strval( result );
			mysql_fetch_field_row(result,"CamiongiuSkill"); PlayerInfo[playerid][pCamiongiuSkill] = strval( result );
			mysql_fetch_field_row(result,"FishSkill"); PlayerInfo[playerid][pFishSkill] = strval( result );
			mysql_fetch_field_row(result,"MatSkill"); PlayerInfo[playerid][pMatSkill] = strval( result );
			mysql_fetch_field_row(result,"RobSkill"); PlayerInfo[playerid][pRobSkill] = strval( result );
	        mysql_fetch_field_row(result,"pHealth"); PlayerInfo[playerid][pHealth] = floatstr( result );
	        mysql_fetch_field_row(result,"Inter"); PlayerInfo[playerid][pInt] = strval( result );
	        mysql_fetch_field_row(result,"Local"); PlayerInfo[playerid][pLocal] = strval( result );
	        mysql_fetch_field_row(result,"Team"); PlayerInfo[playerid][pTeam] = strval( result );
	        mysql_fetch_field_row(result,"Model"); PlayerInfo[playerid][pModel] = strval( result );
	        mysql_fetch_field_row(result,"PhoneNr"); PlayerInfo[playerid][pPnumber] = strval( result );
	        mysql_fetch_field_row(result,"House"); PlayerInfo[playerid][pPhousekey] = strval( result );
	        mysql_fetch_field_row(result,"Bizz"); PlayerInfo[playerid][pPbiskey] = strval( result );
	        mysql_fetch_field_row(result,"Radio"); PlayerInfo[playerid][pRadioCars] = strval( result );
	        mysql_fetch_field_row(result,"Pos_x"); PlayerInfo[playerid][pPos_x] = floatstr( result );
	        mysql_fetch_field_row(result,"Pos_y"); PlayerInfo[playerid][pPos_y] = floatstr( result );
	        mysql_fetch_field_row(result,"Pos_z"); PlayerInfo[playerid][pPos_z] = floatstr( result );
	        mysql_fetch_field_row(result,"Rob"); PlayerInfo[playerid][pRob] = strval( result );
	        mysql_fetch_field_row(result,"CarLicT"); PlayerInfo[playerid][pCarLicT] = strval( result );
	        mysql_fetch_field_row(result,"CarLic"); PlayerInfo[playerid][pCarLic] = strval( result );
	        mysql_fetch_field_row(result,"FlyLicT"); PlayerInfo[playerid][pFlyLicT] = strval( result );
	        mysql_fetch_field_row(result,"FlyLic"); PlayerInfo[playerid][pFlyLic] = strval( result );
	        mysql_fetch_field_row(result,"BoatLicT"); PlayerInfo[playerid][pBoatLicT] = strval( result );
	        mysql_fetch_field_row(result,"BoatLic"); PlayerInfo[playerid][pBoatLic] = strval( result );
	        mysql_fetch_field_row(result,"FishLicT"); PlayerInfo[playerid][pFishLicT] = strval( result );
	        mysql_fetch_field_row(result,"FishLic"); PlayerInfo[playerid][pFishLic] = strval( result );
	        mysql_fetch_field_row(result,"GunLicT"); PlayerInfo[playerid][pGunLicT] = strval( result );
	        mysql_fetch_field_row(result,"GunLic"); PlayerInfo[playerid][pGunLic] = strval( result );
	        mysql_fetch_field_row(result,"PayDay"); PlayerInfo[playerid][pPayDay] = strval( result );
	        mysql_fetch_field_row(result,"PayDayHad"); PlayerInfo[playerid][pPayDayHad] = strval( result );
	        mysql_fetch_field_row(result,"Tutorial"); PlayerInfo[playerid][pTut] = strval( result );
	        mysql_fetch_field_row(result,"Warnings"); PlayerInfo[playerid][pWarns] = strval( result );
	        mysql_fetch_field_row(result,"Rented"); PlayerInfo[playerid][pRented] = strval( result );
	        mysql_fetch_field_row(result,"Fuel"); PlayerInfo[playerid][pFuel] = strval( result );
	        mysql_fetch_field_row(result,"Married"); PlayerInfo[playerid][pMarried] = strval( result );
	        mysql_fetch_field_row(result,"MarriedTo"); strmid(PlayerInfo[playerid][pMarriedTo], result, 0, strlen(result), 255);
	        mysql_fetch_field_row(result,"WTalkie"); PlayerInfo[playerid][pWTalkie] = strval( result );
	        mysql_fetch_field_row(result,"Lighter"); PlayerInfo[playerid][pLighter] = strval( result );
	        mysql_fetch_field_row(result,"Cigarettes"); PlayerInfo[playerid][pCigarettes] = strval( result );
	        mysql_fetch_field_row(result,"Tow"); PlayerInfo[playerid][pTow] = strval( result );
			mysql_fetch_field_row(result,"Email"); strmid(PlayerInfo[playerid][pEmail], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"RegisterDate"); strmid(PlayerInfo[playerid][pRegistredDate], result, 0, strlen(result), 255);
	        mysql_fetch_field_row(result,"Banned"); PlayerInfo[playerid][pBanned] = strval( result );
            mysql_fetch_field_row(result,"ClanTag"); strmid(PlayerInfo[playerid][pClanTag], result, 0, strlen(result), 255);
            mysql_fetch_field_row(result,"Clan"); PlayerInfo[playerid][pClan] = strval( result );
            mysql_fetch_field_row(result,"Radio2"); PlayerInfo[playerid][pRadio] = strval( result );
            mysql_fetch_field_row(result,"HitT"); PlayerInfo[playerid][pHitT] = strval( result );
            mysql_fetch_field_row(result,"CRank"); PlayerInfo[playerid][pCRank] = strval( result );
			mysql_fetch_field_row(result,"Phone"); PlayerInfo[playerid][pPhone] = strval( result );
			mysql_fetch_field_row(result,"id"); PlayerInfo[playerid][pSQLID] = strval( result );
			mysql_fetch_field_row(result,"referral"); PlayerInfo[playerid][pReferral] = strval( result );
			mysql_fetch_field_row(result,"referralp"); PlayerInfo[playerid][pReferralP] = strval( result );
			mysql_fetch_field_row(result,"HPoints"); PlayerInfo[playerid][pHPoints] = strval( result );
			mysql_fetch_field_row(result,"Gift"); PlayerInfo[playerid][pGift] = strval( result );
	        mysql_fetch_field_row(result,"Carkey"); PlayerInfo[playerid][pPcarkey] = strval( result );
			mysql_fetch_field_row(result,"motokey"); PlayerInfo[playerid][pmotokey] = strval( result );
			mysql_fetch_field_row(result,"helikey"); PlayerInfo[playerid][phelikey] = strval( result );
			mysql_fetch_field_row(result,"prcarkey"); PlayerInfo[playerid][pprcarkey] = strval( result );
			mysql_fetch_field_row(result,"Laptop"); PlayerInfo[playerid][pLaptop] = strval( result );
            mysql_fetch_field_row(result,"Victim"); strmid(PlayerInfo[playerid][pVictim], result, 0, strlen(result), 255);
            mysql_fetch_field_row(result,"Accused"); strmid(PlayerInfo[playerid][pAccused], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Crime1"); strmid(PlayerInfo[playerid][pCrime1], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Crime2"); strmid(PlayerInfo[playerid][pCrime2], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Crime3"); strmid(PlayerInfo[playerid][pCrime3], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"BTemp"); PlayerInfo[playerid][pBTemp] = strval( result );
			mysql_fetch_field_row(result,"BYear"); PlayerInfo[playerid][pBYear] = strval( result );
			mysql_fetch_field_row(result,"BMonth"); PlayerInfo[playerid][pBMonth] = strval( result );
			mysql_fetch_field_row(result,"BDay"); PlayerInfo[playerid][pBDay] = strval( result );
			mysql_fetch_field_row(result,"BBy"); strmid(PlayerInfo[playerid][pBBy], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"BReason"); strmid(PlayerInfo[playerid][pBReason], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Fakea"); PlayerInfo[playerid][pFakea] = strval( result );
			mysql_fetch_field_row(result,"ALeader"); PlayerInfo[playerid][pALeader] = strval( result );
	   	}
	}

Cele care ar trebui sa le incarce ar fi ..BTeamp, BMonth, BDay, BBy, BReason, dar nu se intamplat, daca nu e aici unde sa caut?

Nu e aia, eu ma refeream sa-mi dai tot callback-ul.

xNoAir · February 16, 2017

3 minutes ago, Krusher said:

Nu e aia, eu ma refeream sa-mi dai tot callback-ul.

public OnPlayerLogin(playerid,password[])
{
	new playername2[MAX_PLAYER_NAME];
    GetPlayerName(playerid, playername2, sizeof(playername2));
    PlayAudioStreamForPlayer(playerid, "http://k003.kiwi6.com/hotlink/1kmyunrjz6/Game-Arena_RPG.mp3");
    GameTextForPlayer(playerid, "~g~~h~~h~Se Incarca...", 1500, 5);
    new qstr[100];
    new result[456];
    format(qstr,100,"SELECT * FROM users WHERE `name`='%s' AND `password`='%s'",playername2,password);
    mysql_query(SQL,qstr);
    mysql_store_result();
    if(mysql_num_rows() > 0)
    {
      	if(mysql_retrieve_row())
      	{
    		mysql_fetch_field_row(result,"password"); format(PlayerInfo[playerid][pKey], 128, result);
			mysql_fetch_field_row(result,"Level"); PlayerInfo[playerid][pLevel] = strval( result );
			mysql_fetch_field_row(result,"Admin"); PlayerInfo[playerid][pAdmin] = strval( result );
			mysql_fetch_field_row(result,"Helper"); PlayerInfo[playerid][pHelper] = strval( result );
			mysql_fetch_field_row(result,"Premium"); PlayerInfo[playerid][pPremiumAccount] = strval( result );
			mysql_fetch_field_row(result,"ConnectedTime"); PlayerInfo[playerid][pConnectTime] = strval( result );
			mysql_fetch_field_row(result,"Registered"); PlayerInfo[playerid][pReg] = strval( result );
			mysql_fetch_field_row(result,"Sex"); PlayerInfo[playerid][pSex] = strval( result );
			mysql_fetch_field_row(result,"Age"); PlayerInfo[playerid][pAge] = strval( result );
			mysql_fetch_field_row(result,"Origin"); PlayerInfo[playerid][pOrigin] = strval( result );
			mysql_fetch_field_row(result,"Muted"); PlayerInfo[playerid][pMuted] = strval( result );
			mysql_fetch_field_row(result,"MuteTime"); PlayerInfo[playerid][pMuteTime] = strval( result );
			mysql_fetch_field_row(result,"Respect"); PlayerInfo[playerid][pExp] = strval( result );
			mysql_fetch_field_row(result,"Money"); PlayerInfo[playerid][pCash] = strval( result );
			mysql_fetch_field_row(result,"Bank"); PlayerInfo[playerid][pAccount] = strval( result );
			mysql_fetch_field_row(result,"Crimes"); PlayerInfo[playerid][pCrimes] = strval( result );
			mysql_fetch_field_row(result,"Kills"); PlayerInfo[playerid][pKills] = strval( result );
			mysql_fetch_field_row(result,"Deaths"); PlayerInfo[playerid][pDeaths] = strval( result );
			mysql_fetch_field_row(result,"Arrested"); PlayerInfo[playerid][pArrested] = strval( result );
			mysql_fetch_field_row(result,"WantedDeaths"); PlayerInfo[playerid][pWantedDeaths] = strval( result );
			mysql_fetch_field_row(result,"Phonebook"); PlayerInfo[playerid][pPhoneBook] = strval( result );
			mysql_fetch_field_row(result,"LottoNr"); PlayerInfo[playerid][pLottoNr] = strval( result );
			mysql_fetch_field_row(result,"WantedLevel"); PlayerInfo[playerid][pWantedLevel] = strval( result );
			mysql_fetch_field_row(result,"Fishes"); PlayerInfo[playerid][pFishes] = strval( result );
			mysql_fetch_field_row(result,"RFishes"); PlayerInfo[playerid][pRFishes] = strval( result );
			mysql_fetch_field_row(result,"Job"); PlayerInfo[playerid][pJob] = strval( result );
			mysql_fetch_field_row(result,"Paycheck"); PlayerInfo[playerid][pPayCheck] = strval( result );
			mysql_fetch_field_row(result,"HeadValue"); PlayerInfo[playerid][pHeadValue] = strval( result );
			mysql_fetch_field_row(result,"Jailed"); PlayerInfo[playerid][pJailed] = strval( result );
			mysql_fetch_field_row(result,"JailTime"); PlayerInfo[playerid][pJailTime] = strval( result );
			mysql_fetch_field_row(result,"Materials"); PlayerInfo[playerid][pMats] = strval( result );
			mysql_fetch_field_row(result,"Drugs"); PlayerInfo[playerid][pDrugs] = strval( result );
			mysql_fetch_field_row(result,"Leader"); PlayerInfo[playerid][pLeader] = strval( result );
			mysql_fetch_field_row(result,"Member"); PlayerInfo[playerid][pMember] = strval( result );
			mysql_fetch_field_row(result,"Rank"); PlayerInfo[playerid][pRank] = strval( result );
			mysql_fetch_field_row(result,"CChar"); PlayerInfo[playerid][pChar] = strval( result );
			mysql_fetch_field_row(result,"FWarn"); PlayerInfo[playerid][pFACWarns] = strval( result );
			mysql_fetch_field_row(result,"FPunish"); PlayerInfo[playerid][pFpunish] = strval( result );
			mysql_fetch_field_row(result,"Acceptpoints"); PlayerInfo[playerid][pLawyer] = strval( result );
			mysql_fetch_field_row(result,"SexSkill"); PlayerInfo[playerid][pSexSkill] = strval( result );
			mysql_fetch_field_row(result,"LawSkill"); PlayerInfo[playerid][pLawSkill] = strval( result );
			mysql_fetch_field_row(result,"MechSkill"); PlayerInfo[playerid][pMechSkill] = strval( result );
			mysql_fetch_field_row(result,"NewsSkill"); PlayerInfo[playerid][pNewsSkill] = strval( result );
			mysql_fetch_field_row(result,"DrugsSkill"); PlayerInfo[playerid][pDrugsSkill] = strval( result );
			mysql_fetch_field_row(result,"MuncitorSkill"); PlayerInfo[playerid][pMuncitorSkill] = strval( result );
			mysql_fetch_field_row(result,"CamiongiuSkill"); PlayerInfo[playerid][pCamiongiuSkill] = strval( result );
			mysql_fetch_field_row(result,"FishSkill"); PlayerInfo[playerid][pFishSkill] = strval( result );
			mysql_fetch_field_row(result,"MatSkill"); PlayerInfo[playerid][pMatSkill] = strval( result );
			mysql_fetch_field_row(result,"RobSkill"); PlayerInfo[playerid][pRobSkill] = strval( result );
	        mysql_fetch_field_row(result,"pHealth"); PlayerInfo[playerid][pHealth] = floatstr( result );
	        mysql_fetch_field_row(result,"Inter"); PlayerInfo[playerid][pInt] = strval( result );
	        mysql_fetch_field_row(result,"Local"); PlayerInfo[playerid][pLocal] = strval( result );
	        mysql_fetch_field_row(result,"Team"); PlayerInfo[playerid][pTeam] = strval( result );
	        mysql_fetch_field_row(result,"Model"); PlayerInfo[playerid][pModel] = strval( result );
	        mysql_fetch_field_row(result,"PhoneNr"); PlayerInfo[playerid][pPnumber] = strval( result );
	        mysql_fetch_field_row(result,"House"); PlayerInfo[playerid][pPhousekey] = strval( result );
	        mysql_fetch_field_row(result,"Bizz"); PlayerInfo[playerid][pPbiskey] = strval( result );
	        mysql_fetch_field_row(result,"Radio"); PlayerInfo[playerid][pRadioCars] = strval( result );
	        mysql_fetch_field_row(result,"Pos_x"); PlayerInfo[playerid][pPos_x] = floatstr( result );
	        mysql_fetch_field_row(result,"Pos_y"); PlayerInfo[playerid][pPos_y] = floatstr( result );
	        mysql_fetch_field_row(result,"Pos_z"); PlayerInfo[playerid][pPos_z] = floatstr( result );
	        mysql_fetch_field_row(result,"Rob"); PlayerInfo[playerid][pRob] = strval( result );
	        mysql_fetch_field_row(result,"CarLicT"); PlayerInfo[playerid][pCarLicT] = strval( result );
	        mysql_fetch_field_row(result,"CarLic"); PlayerInfo[playerid][pCarLic] = strval( result );
	        mysql_fetch_field_row(result,"FlyLicT"); PlayerInfo[playerid][pFlyLicT] = strval( result );
	        mysql_fetch_field_row(result,"FlyLic"); PlayerInfo[playerid][pFlyLic] = strval( result );
	        mysql_fetch_field_row(result,"BoatLicT"); PlayerInfo[playerid][pBoatLicT] = strval( result );
	        mysql_fetch_field_row(result,"BoatLic"); PlayerInfo[playerid][pBoatLic] = strval( result );
	        mysql_fetch_field_row(result,"FishLicT"); PlayerInfo[playerid][pFishLicT] = strval( result );
	        mysql_fetch_field_row(result,"FishLic"); PlayerInfo[playerid][pFishLic] = strval( result );
	        mysql_fetch_field_row(result,"GunLicT"); PlayerInfo[playerid][pGunLicT] = strval( result );
	        mysql_fetch_field_row(result,"GunLic"); PlayerInfo[playerid][pGunLic] = strval( result );
	        mysql_fetch_field_row(result,"PayDay"); PlayerInfo[playerid][pPayDay] = strval( result );
	        mysql_fetch_field_row(result,"PayDayHad"); PlayerInfo[playerid][pPayDayHad] = strval( result );
	        mysql_fetch_field_row(result,"Tutorial"); PlayerInfo[playerid][pTut] = strval( result );
	        mysql_fetch_field_row(result,"Warnings"); PlayerInfo[playerid][pWarns] = strval( result );
	        mysql_fetch_field_row(result,"Rented"); PlayerInfo[playerid][pRented] = strval( result );
	        mysql_fetch_field_row(result,"Fuel"); PlayerInfo[playerid][pFuel] = strval( result );
	        mysql_fetch_field_row(result,"Married"); PlayerInfo[playerid][pMarried] = strval( result );
	        mysql_fetch_field_row(result,"MarriedTo"); strmid(PlayerInfo[playerid][pMarriedTo], result, 0, strlen(result), 255);
	        mysql_fetch_field_row(result,"WTalkie"); PlayerInfo[playerid][pWTalkie] = strval( result );
	        mysql_fetch_field_row(result,"Lighter"); PlayerInfo[playerid][pLighter] = strval( result );
	        mysql_fetch_field_row(result,"Cigarettes"); PlayerInfo[playerid][pCigarettes] = strval( result );
	        mysql_fetch_field_row(result,"Tow"); PlayerInfo[playerid][pTow] = strval( result );
			mysql_fetch_field_row(result,"Email"); strmid(PlayerInfo[playerid][pEmail], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"RegisterDate"); strmid(PlayerInfo[playerid][pRegistredDate], result, 0, strlen(result), 255);
	        mysql_fetch_field_row(result,"Banned"); PlayerInfo[playerid][pBanned] = strval( result );
            mysql_fetch_field_row(result,"ClanTag"); strmid(PlayerInfo[playerid][pClanTag], result, 0, strlen(result), 255);
            mysql_fetch_field_row(result,"Clan"); PlayerInfo[playerid][pClan] = strval( result );
            mysql_fetch_field_row(result,"Radio2"); PlayerInfo[playerid][pRadio] = strval( result );
            mysql_fetch_field_row(result,"HitT"); PlayerInfo[playerid][pHitT] = strval( result );
            mysql_fetch_field_row(result,"CRank"); PlayerInfo[playerid][pCRank] = strval( result );
			mysql_fetch_field_row(result,"Phone"); PlayerInfo[playerid][pPhone] = strval( result );
			mysql_fetch_field_row(result,"id"); PlayerInfo[playerid][pSQLID] = strval( result );
			mysql_fetch_field_row(result,"referral"); PlayerInfo[playerid][pReferral] = strval( result );
			mysql_fetch_field_row(result,"referralp"); PlayerInfo[playerid][pReferralP] = strval( result );
			mysql_fetch_field_row(result,"HPoints"); PlayerInfo[playerid][pHPoints] = strval( result );
			mysql_fetch_field_row(result,"Gift"); PlayerInfo[playerid][pGift] = strval( result );
	        mysql_fetch_field_row(result,"Carkey"); PlayerInfo[playerid][pPcarkey] = strval( result );
			mysql_fetch_field_row(result,"motokey"); PlayerInfo[playerid][pmotokey] = strval( result );
			mysql_fetch_field_row(result,"helikey"); PlayerInfo[playerid][phelikey] = strval( result );
			mysql_fetch_field_row(result,"prcarkey"); PlayerInfo[playerid][pprcarkey] = strval( result );
			mysql_fetch_field_row(result,"Laptop"); PlayerInfo[playerid][pLaptop] = strval( result );
            mysql_fetch_field_row(result,"Victim"); strmid(PlayerInfo[playerid][pVictim], result, 0, strlen(result), 255);
            mysql_fetch_field_row(result,"Accused"); strmid(PlayerInfo[playerid][pAccused], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Crime1"); strmid(PlayerInfo[playerid][pCrime1], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Crime2"); strmid(PlayerInfo[playerid][pCrime2], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Crime3"); strmid(PlayerInfo[playerid][pCrime3], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"BTemp"); PlayerInfo[playerid][pBTemp] = strval( result );
			mysql_fetch_field_row(result,"BYear"); PlayerInfo[playerid][pBYear] = strval( result );
			mysql_fetch_field_row(result,"BMonth"); PlayerInfo[playerid][pBMonth] = strval( result );
			mysql_fetch_field_row(result,"BDay"); PlayerInfo[playerid][pBDay] = strval( result );
			mysql_fetch_field_row(result,"BBy"); strmid(PlayerInfo[playerid][pBBy], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"BReason"); strmid(PlayerInfo[playerid][pBReason], result, 0, strlen(result), 255);
			mysql_fetch_field_row(result,"Fakea"); PlayerInfo[playerid][pFakea] = strval( result );
			mysql_fetch_field_row(result,"ALeader"); PlayerInfo[playerid][pALeader] = strval( result );
	   	}
	}
 	else
	{
		new loginstring[128];
		new loginname[64];
		GetPlayerName(playerid,loginname,sizeof(loginname));
        PlayAudioStreamForPlayer(playerid, "http://k003.kiwi6.com/hotlink/1kmyunrjz6/Game-Arena_RPG_mp3");
		format(loginstring,sizeof(loginstring),"Parola incorecta!\n\nVa rugam sa scrii parola mai jos pentru a va conecta pe server.",loginname);
		ShowPlayerDialog(playerid,DIALOG_LOGIN3,DIALOG_STYLE_PASSWORD,"Logare",loginstring,"Logare","Iesire");
        mysql_free_result();
        gPlayerLogTries[playerid] += 1;
        if(gPlayerLogTries[playerid] == 4)
		{
			KickEx(playerid);
		}
        return 1;
	}
	mysql_free_result();
	ResetPlayerCash(playerid);
	GivePlayerCash(playerid,PlayerInfo[playerid][pCash]);
	CurrentMoney[playerid] = PlayerInfo[playerid][pCash];
	KillTimer(login[playerid]);
	TempBanCheck(playerid);
	if(PlayerInfo[playerid][pReg] == 0)
	{
		PlayerInfo[playerid][pLevel] = 1;
		PlayerInfo[playerid][pHealth] = 100.0;
 	    PlayerInfo[playerid][pPos_x] = 2246.6;
 	    PlayerInfo[playerid][pPos_y] = -1161.9;
 	    PlayerInfo[playerid][pPos_z] = 1029.7;
		PlayerInfo[playerid][pInt] = 0;
		PlayerInfo[playerid][pLocal] = 255;
		PlayerInfo[playerid][pTeam] = 3;
		PlayerInfo[playerid][pModel] = 250;
		new randphone = 10000 + random(9999);//minimum 1000  max 9999 //giving one at the start
		PlayerInfo[playerid][pPnumber] = randphone;
		PlayerInfo[playerid][pPhousekey] = 999;
		PlayerInfo[playerid][pPbiskey] = 255;
		PlayerInfo[playerid][pAccount] = 100;
		PlayerInfo[playerid][pPcarkey] = 0;
		PlayerInfo[playerid][pmotokey] = 0;
		PlayerInfo[playerid][phelikey] = 0;
		PlayerInfo[playerid][pprcarkey] = 0;
		PlayerInfo[playerid][pReg] = 1;
		SetPlayerInterior(playerid,0);
		new string[300];
		new d,m,y;
		getdate(y,m,d);
		new h,mine,s;
		gettime(h,mine,s);
		format(string,sizeof(string),  "%d/%d/%d %d:%d:%d",d,m,y,h,mine,s);
		strmid(PlayerInfo[playerid][pRegistredDate], string, 0, strlen(string), 255);
		new str[256],wakaname[25];
		GetPlayerName(playerid,wakaname,sizeof(wakaname));
		format(str,sizeof(str),"UPDATE users SET `pHealth`='100.0',`Team`='3',`Model`='250' WHERE `name`='%s'",wakaname);
		mysql_query(SQL,str);
		Update(playerid,pCashx);
		Update(playerid,pLevelx);
		Update(playerid,pPhousekeyx);
		Update(playerid,pPbiskeyx);
		Update(playerid,pPnumberx);
		Update(playerid,pRegx);
		Update(playerid,pRegistredDatex);
		Update(playerid,pPcarkeyx);
		Update(playerid,pmotokeyx);
		Update(playerid,phelikeyx);
		Update(playerid,pprcarkeyx);
	}
	SpawnMyVehicle(playerid);
	if(PlayerInfo[playerid][pBanned] == 1) //autoban
	{
        SendClientMessage(playerid, COLOR_LIGHTRED, "[BAN INFO]: Ai ban pe acest server !");
        SendClientMessage(playerid, COLOR_LIGHTRED, "[BAN INFO]: Daca crezi ca ai fost nedreptatit, fa o cerere de unban pe forum http://SincePlay.RO/.");
		Ban(playerid);
	}
    StopAudioStreamForPlayer(playerid);
    new string2[128];
    if(PlayerInfo[playerid][pTut] == 1)
    {
		format(string2, sizeof(string2), "SERVER: Bun venit {99FFCC}%s.",playername2);
		SendClientMessage(playerid, COLOR_DS,string2);
	}
	SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
	if (PlayerInfo[playerid][pPremiumAccount] == 1)
	{
		SendClientMessage(playerid, COLOR_DS,"SERVER: Sunteti un utilizator cu Cont Premium.");
	}
	if (PlayerInfo[playerid][pAdmin] > 0)
	{
		format(string2, sizeof(string2), "Te-ai logat ca admin level %d .",PlayerInfo[playerid][pAdmin]);
		SendClientMessage(playerid, COLOR_DS,string2);
	}
	if (PlayerInfo[playerid][pHelper] > 0)
	{
		SendClientMessage(playerid, COLOR_DS,"Te-ai logat ca helper.");
	}
	if (PlayerInfo[playerid][pWantedLevel] > 0)
	{
		format(string2, sizeof(string2), "Cand ai esit de pe server ai avut Wanted %d.",PlayerInfo[playerid][pWantedLevel]);
		SetPlayerWantedLevel(playerid, PlayerInfo[playerid][pWantedLevel]);
		SendClientMessage(playerid, COLOR_LIGHTRED, string2);
		wantedlost[playerid] = 1800;
		WantedPoints[playerid] = PlayerInfo[playerid][pWantedLevel]*2;
	}
	SetSpawnInfo(playerid, PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModel], 1642.4756,-2239.6516,13.4959, 1.0, -1, -1, -1, -1, -1, -1);
    if(happyday == 0)
    {
    	SendClientMessage(playerid, COLOR_LIGHTBLUE,"Intre Orele 7:00 - 12:00 Vei primi dublu Respect Points.");
    	SendClientMessage(playerid, COLOR_LIGHTBLUE,"");
    }
	if(gTeam[playerid] == 0)
	{
		gTeam[playerid] = 3;
	}
	else
	{
		gTeam[playerid] = PlayerInfo[playerid][pTeam];
	}
	if(PlayerInfo[playerid][pMember] != 0)
	{
	    new namex[25],disc[84];
	    GetPlayerName(playerid,namex,sizeof(namex));
	    format(disc,sizeof(disc),"Membrul %s sa conectat pe server.",namex);
	    SendLeaderMessage(PlayerInfo[playerid][pMember], COLOR_YELLOW, disc);
	}
	if(PlayerInfo[playerid][pMember] != 0)
	{
		if(strlen(DynamicFactions[PlayerInfo[playerid][pMember]][fAnn]) > 0)
		{
		    new factioninfo[128];
			format(factioninfo,sizeof(factioninfo), "{AA3333}** Stiri: %s",DynamicFactions[PlayerInfo[playerid][pMember]][fAnn]);
			SCM(playerid,COLOR_DS,factioninfo);
		}
	}
	new sendername[25],playersip[64],iplog[184];
	GetPlayerName(playerid,sendername,sizeof(sendername));
	GetPlayerIp(playerid,playersip,sizeof(playersip));
	LogIP(playersip,PlayerInfo[playerid][pSQLID]);
	format(iplog,sizeof(iplog),"{5CAD5C}%s(%d) connected on the server with IP: %s.",sendername,playerid,playersip);
	SendIP(COLOR_DS,iplog);
	gPlayerLogged[playerid] = 1;
	SpawnPlayer(playerid);
	new qqerry[128];
	format(qqerry, sizeof(qqerry), "UPDATE `users` SET `Status` = '1' WHERE `name` = '%s'", sendername);
    mysql_query(SQL,qqerry);
	printf("%s has logged in with IP %s.",sendername,playersip);
	Starts0bCheck(playerid,0);
	SetTimer("Ceastest",1000, 1);
	return 1;
}

Krusher · February 17, 2017

Pai e clar, ai verificare doar daca banul este permanent, trebuie sa faci sa verifice si daca este temporar, si eventual sa faci sistemul de expirare ban in cazul in care nu e facut.

Ca idee (nu-ti dau mura-n gura, te las sa te descurci):

Sub:

	if(PlayerInfo[playerid][pBanned] == 1) //autoban
	{
        SendClientMessage(playerid, COLOR_LIGHTRED, "[BAN INFO]: Ai ban pe acest server !");
        SendClientMessage(playerid, COLOR_LIGHTRED, "[BAN INFO]: Daca crezi ca ai fost nedreptatit, fa o cerere de unban pe forum http://SincePlay.RO/.");
		Ban(playerid);
	}

Adaugi:

if(PlayerInfo[playerid][pBTemp] == 1)
{ 	
  SendClientMessage(playerid, -1, "Contul tau este banat permanent.");	
  KickEx(playerid); // banuiesc ca ai KickEx in gm(kick cu delay)
}

Edited February 17, 2017 by Krusher

Sign In

Problema Comanda

Question

xNoAir

9 answers to this question

Recommended Posts

WopsS

Krusher

AddisoN

xNoAir

Krusher

xNoAir

Krusher

xNoAir

Krusher

Similar Content

Actualizare textdraw (speedometer) la secunda (problema)

Ajutor, cum gasesc o comanda ascunsa ?!?!

Problema /vehicles

Problema billboards (la expirarea billboard-ului nu seteaza variabila Billboard 0 jucatorului offline)

Problema clan members: Nu afiseaza membrii.

Recently Browsing 0 members

Browse

Activity

Important Information