Jump to content

xNoAir

Membru
  • Posts

    16
  • Joined

  • Last visited

Profile Information

  • Level of knowledge
    Mediu

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

xNoAir's Achievements

Apprentice

Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. 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; }
  2. 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?
  3. 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; }
  4. 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; }
  5. xNoAir

    Ajutor

    Pai, cum se face de la ce sa incep ca, ce ai scris tu acolo pot sa scriu si eu, dar sa pun inpractica nu prea.
  6. xNoAir

    Ajutor

    Salut, am si eu o problema cu sistemul anti-teleport, adica cum pot sa fac imi dau seama ca cineva foloseste. imi puteti da un link cu un tutorial sa vad cum se face?
  7. Edit: Am refacut windowsul si merge totul bine acum.
  8. Salut, deci ma ajuta WopsS sa rezolv toate errorile, si dupa am luat ,,Atom'' si mergea perfect, am rezolvat tot, si cand dau sa porneasca serverul imi iasa direct, am dat uninstal la atom, mergea perfect, dupa ce dadeam f5 pe orice .pwn, nu mai pornea gm adica uitativa... poza: Am pus si eror server_log
  9. Merci, am rezolvat toate errorile.
  10. Cum se numeste programul? map editor sau cum
  11. Salut, ma poate ajuta cineva cu problema aceasta, am cautat pe net peste tot, si tot nu am gasit cum se rezolva problema aceasta. poza: Nu stiu cum sa rezolv problema aceasta, invat infiecare zi cum se rezolva unele probleme sau cum sa fac anumite sisteme etc... Dar nu gasesc cum se rezolva problema aceasta. P.S. sunt incepator nu ma criticatii daca nu prea stiu
  12. Stie cineva un game mode compatibil cu Since Play?
  13. xNoAir

    Problema tag

    Am rezolvat puteti da TC Merci la cei care au incercat sa ma ajute.
  14. dami pm cu contul daca esti asa darnic
  15. Vand contul xNoAir, de pe og-times Are pe el 350kk, si este in Taxi SF r2. https://og-times.ro/panel/profile/xNoAir/
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.