Jump to content
Autentificarea cu Google și Facebook nu mai este disponibilă. ×

Question

Posted

Buna seara am si problema asta in mysql log

[23:05:59] [ERROR] CMySQLQuery::Execute[()] - (error #1146) Table 'spritetv.garages' doesn't exist
[23:08:06] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[23:08:28] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'Security' in 'field list'
[23:08:28] [ERROR] CMySQLQuery::Create - no query and orm object specified
[23:08:50] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'pHealth' in 'field list'
[23:08:55] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'pHealth' in 'field list'
[23:09:39] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'Security' in 'field list'
[23:09:39] [ERROR] CMySQLQuery::Create - no query and orm object specified

Si chiar nu stiu sa le rezolv nu imi pot da seama de la ce este.

Folosesc gm-ul lui @SkillZ_IT.
 

21 answers to this question

Recommended Posts

  • 0
Posted

Iti spune exact ce inseamna:

 

Table 'spritetv.garages' doesn't exist

- Pentru asta trebuie sa faci un tabel cu numele garages

Unknown column 'pHealth' in 'field list'

- Adauga variabila pHealth in tabelul 'users' ca FLOAT

Unknown column 'Security' in 'field list'

- Adauga variabila Security in tabelul `users` ca VARCHAR

 

Desi eu am impresia ca aceste variabile nu mai sunt folosite in gamemode pentru ca Security este o variabila de la burnedul oferit de edison care a fost scos de majoritatea celor care il foloseau si pHealth nu stiu daca este folosit in gamemode insa nu o sa afecteze semnificativ gamemodeul din punct de vedere al optimizarii

  • 0
Posted
Acum 15 minute, CTMBeast a spus:

Iti spune exact ce inseamna:

 


Table 'spritetv.garages' doesn't exist

- Pentru asta trebuie sa faci un tabel cu numele garages


Unknown column 'pHealth' in 'field list'

- Adauga variabila pHealth in tabelul 'users' ca FLOAT


Unknown column 'Security' in 'field list'

- Adauga variabila Security in tabelul `users` ca VARCHAR

 

 Desi eu am impresia ca aceste variabile nu mai sunt folosite in gamemode pentru ca Security este o variabila de la burnedul oferit de edison care a fost scos de majoritatea celor care il foloseau si pHealth nu stiu daca este folosit in gamemode insa nu o sa afecteze semnificativ gamemodeul din punct de vedere al optimizarii

@CTMBeast

am adaugat phealth in baza de date la users

dar security nu pot adauga

http://prntscr.com/m3uisn

iar la garages

am deja tabelul 

http://prntscr.com/m3ujcl

Si primesc urmatoarea in servar log

[23:39:16] [MySQL] Dealership models: 89
[23:39:17] [debug] Run time error 4: "Array index out of bounds"
[23:39:17] [debug]  Accessing element at index 10 past array upper bound 9
[23:39:17] [debug] AMX backtrace:
[23:39:17] [debug] #0 003423d4 in public LoadGarages () from gmm.amx
[23:39:17] Accesory loaded: 100

  • 0
Posted

poti sa imi arati variabila de la garaje? Ex: GarageInfo etc

Cat la Security am impresia ca trebuie sa ii setezi lungimea neaparat pentru ca e Varchar

 

  • 0
Posted
Acum 23 minute, CTMBeast a spus:

poti sa imi arati variabila de la garaje? Ex: GarageInfo etc

Cat la Security am impresia ca trebuie sa ii setezi lungimea neaparat pentru ca e Varchar

 

[00:36:01] Server: hosted
[00:36:01] Server vehicles: 170
[00:36:01] Safezones: 14
[00:36:01] [debug] Run time error 4: "Array index out of bounds"
[00:36:01] [debug]  Accessing element at index 100 past array upper bound 99
[00:36:01] [debug] AMX backtrace:
[00:36:01] [debug] #0 00296c34 in public LoadProperty () from gmm.amx
[00:36:01] [debug] #1 000b5008 in ?? () from gmm.amx
[00:36:01] [debug] #2 00028b30 in public L_AFK_OnGM () from gmm.amx
[00:36:01] [debug] #3 native CallLocalFunction () from samp03svr
[00:36:01] [debug] #4 00018b40 in public SSCANF_OnGameModeInit () from gmm.amx
[00:36:01] [debug] #5 00012ef0 in public Itter_OnGameModeInit () from gmm.amx
[00:36:01] [debug] #6 native CallLocalFunction () from samp03svr
[00:36:01] [debug] #7 00011f40 in public ScriptInit_OnGameModeInit () from gmm.amx
[00:36:01] [debug] #8 00010ec4 in public PZone_OnGameModeInit () from gmm.amx
[00:36:01] [debug] #9 native CallLocalFunction () from samp03svr
[00:36:01] [debug] #10 00006b28 in public OnGameModeInit () from gmm.amx
[00:36:01] Number of vehicle models: 65
[00:36:02] [debug] Run time error 4: "Array index out of bounds"
[00:36:02] [debug]  Accessing element at index 10 past array upper bound 9
[00:36:02] [debug] AMX backtrace:
[00:36:02] [debug] #0 003423d4 in public LoadGarages () from gmm.amx
[00:36:02] Accesory loaded: 100

acu primesc astea :(

  • 0
Posted
Just now, Sprite_RoPlayers said:

[00:36:01] Server: hosted
[00:36:01] Server vehicles: 170
[00:36:01] Safezones: 14
[00:36:01] [debug] Run time error 4: "Array index out of bounds"
[00:36:01] [debug]  Accessing element at index 100 past array upper bound 99
[00:36:01] [debug] AMX backtrace:
[00:36:01] [debug] #0 00296c34 in public LoadProperty () from gmm.amx
[00:36:01] [debug] #1 000b5008 in ?? () from gmm.amx
[00:36:01] [debug] #2 00028b30 in public L_AFK_OnGM () from gmm.amx
[00:36:01] [debug] #3 native CallLocalFunction () from samp03svr
[00:36:01] [debug] #4 00018b40 in public SSCANF_OnGameModeInit () from gmm.amx
[00:36:01] [debug] #5 00012ef0 in public Itter_OnGameModeInit () from gmm.amx
[00:36:01] [debug] #6 native CallLocalFunction () from samp03svr
[00:36:01] [debug] #7 00011f40 in public ScriptInit_OnGameModeInit () from gmm.amx
[00:36:01] [debug] #8 00010ec4 in public PZone_OnGameModeInit () from gmm.amx
[00:36:01] [debug] #9 native CallLocalFunction () from samp03svr
[00:36:01] [debug] #10 00006b28 in public OnGameModeInit () from gmm.amx
[00:36:01] Number of vehicle models: 65
[00:36:02] [debug] Run time error 4: "Array index out of bounds"
[00:36:02] [debug]  Accessing element at index 10 past array upper bound 9
[00:36:02] [debug] AMX backtrace:
[00:36:02] [debug] #0 003423d4 in public LoadGarages () from gmm.amx
[00:36:02] Accesory loaded: 100

acu primesc astea :(

Arata-mi functia LoadGarages()

  • 0
Posted
Acum 2 minute, CTMBeast a spus:

Arata-mi functia LoadGarages()

function LoadGarages() {
	new Cache: db = mysql_query(SQL, "SELECT * FROM `garages`");
	new x, result[126];
 	for(new i, j = cache_get_row_count (); i != j; ++i) {
	    garages ++;
       	cache_get_field_content(i, "ID", result); x = strval(result), garageInfo[garages][gID] = x;
       	cache_get_field_content(i, "Owner", result); format(garageInfo[x][gOwner], 32, result);
     	cache_get_field_content(i, "UserID", result); garageInfo[x][gUserID] = strval(result);
		cache_get_field_content(i, "Price", result); garageInfo[x][gPrice] = strval(result);

        garageInfo[x][gPos][0] = cache_get_field_content_float(i, "X"); 
       	garageInfo[x][gPos][1] = cache_get_field_content_float(i, "Y");
       	garageInfo[x][gPos][2] = cache_get_field_content_float(i, "Z"); 
		garageInfo[x][gAngle] = cache_get_field_content_float(i, "Angle"); 

       	garageInfo[x][gVirtualID] = x;    

       	garageInfo[x][gPickup] = CreateDynamicPickup(1277, 23, garageInfo[x][gPos][0], garageInfo[x][gPos][1], garageInfo[x][gPos][2]);
       	garage_label(x); 	
	}
	printf("Garages loaded: %d", garages);
	cache_delete(db);
	return 1;
}

 

  • 0
Posted

Du-te la garageInfo si schimba prima valoare dintre paranteze. Exemplu:

- Sa zicem ca ai

new garageInfo[10][gInfo];

- Schimba in 

new garageInfo[60][gInfo]

In loc de 60 poti sa pui cate case ai tu

  • 0
Posted
Acum 3 minute, CTMBeast a spus:

Du-te la garageInfo si schimba prima valoare dintre paranteze. Exemplu:

- Sa zicem ca ai


new garageInfo[10][gInfo];

 - Schimba in 


new garageInfo[60][gInfo]

In loc de 60 poti sa pui cate case ai tu

dar eu nu am in garage.inc new garage info wtf

am doar asta

http://prntscr.com/m3uwps

  • 0
Posted (edited)
Acum 9 minute, CTMBeast a spus:

Atunci cauta #define MAX_GARAGES si schimba acolo numarul

Acu am rezolvat asta dar acu am astea @CTMBeast

[00:49:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[00:50:10] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[00:50:10] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[00:50:30] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'pHealth' in 'field list'
[00:50:34] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'pHealth' in 'field list'
[00:51:41] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'Security' in 'field list'
[00:51:41] [ERROR] CMySQLQuery::Create - no query and orm object specified
[00:52:07] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'Security' in 'field list'
[00:52:07] [ERROR] CMySQLQuery::Create - no query and orm object specified
[00:58:27] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

 

Edited by Sprite_RoPlayers
  • 0
Posted
Acum 13 minute, Sprite_RoPlayers a spus:

Acu am rezolvat asta dar acu am astea @CTMBeast


[00:49:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[00:50:10] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[00:50:10] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[00:50:30] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'pHealth' in 'field list'
[00:50:34] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'pHealth' in 'field list'
[00:51:41] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'Security' in 'field list'
[00:51:41] [ERROR] CMySQLQuery::Create - no query and orm object specified
[00:52:07] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'Security' in 'field list'
[00:52:07] [ERROR] CMySQLQuery::Create - no query and orm object specified
[00:58:27] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

 

@CTMBeast

  • 0
Posted
1 minute ago, Sprite_RoPlayers said:

Afecteaza cu ceva alea? servar-ul?

La 50/100 ? sau 100/100?

Jucatori

Nu are legatura! Maxim sa se creeze un bug insa nu sunt sigur

  • 0
Posted
Acum 2 minute, CTMBeast a spus:

Nu are legatura! Maxim sa se creeze un bug insa nu sunt sigur

Eu folosesc gm-ul lui skillz sa incerc sa adug alea in users? cum ai zis tu doar ca la securitate nu merge.

  • 0
Posted
00:52:07] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column '---' in 'field list' 

 

Inseamna ca in baza de date nu ai coloana respectiva, intri in phpmyadmin si o faci... 

  • 0
Posted
Acum 12 ore, VeLo a spus:

00:52:07] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column '---' in 'field list' 

 

Inseamna ca in baza de date nu ai coloana respectiva, intri in phpmyadmin si o faci... 

@CTMBeast

Am rezolvat aceasta eroare cu phealt si securty iam pus vachard 75 cred ca ii k 

Si acu am astea 

[16:23:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

 

  • 0
Posted
5 minutes ago, Sprite_RoPlayers said:

@CTMBeast

Am rezolvat aceasta eroare cu phealt si securty iam pus vachard 75 cred ca ii k 

Si acu am astea 


[16:23:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

 

Inseamna ca nu se incarca undeva o variabila.. Verifica cand se intampla asta.. De exemplu daca iti da eroarea dupa ce te-ai logat inseamna ca e de la OnPlayerLogin

  • 0
Posted (edited)
Acum 2 ore, CTMBeast a spus:

Inseamna ca nu se incarca undeva o variabila.. Verifica cand se intampla asta.. De exemplu daca iti da eroarea dupa ce te-ai logat inseamna ca e de la OnPlayerLogin

Da fix dupa ce dau login imi apare

function OnPlayerLoginIn(playerid,password[]) {
	new playername2[MAX_PLAYER_NAME];
    GetPlayerName(playerid, playername2, sizeof(playername2));
    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()) {
			GameTextForPlayer(playerid, "~r~Loading account...", 20000, 4);
			PlayerTextdraws(playerid);
	
    		mysql_fetch_field_row(result,"password"); format(PlayerInfo[playerid][pKey], 128, result);

    		mysql_fetch_field_row(result,"SpinPoints"); PlayerInfo[playerid][pSpinPoints] = strval(result);


            mysql_fetch_field_row(result,"PetName"); format(PlayerInfo[playerid][pPetName], 100, result);
            mysql_fetch_field_row(result,"Case"); format(PlayerInfo[playerid][pCase], 100, result);
            mysql_fetch_field_row(result,"CaseKey"); format(PlayerInfo[playerid][pCaseKey], 100, 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,"CarieraSkill"); PlayerInfo[playerid][pCarieraSkill] = strval( result );
			mysql_fetch_field_row(result,"GroparSkill"); PlayerInfo[playerid][pGroparSkill] = strval( result );	
			mysql_fetch_field_row(result,"Backpack"); PlayerInfo[playerid][pBackpack] = strval( result );	
			mysql_fetch_field_row(result,"Propose"); format(PlayerInfo[playerid][pPropose], 64, result);

			mysql_fetch_field_row(result,"ShowProgress1"); PlayerInfo[playerid][pShowProgress][0] = strval( result );	
			mysql_fetch_field_row(result,"ShowProgress2"); PlayerInfo[playerid][pShowProgress][1] = strval( result );
			
			
			SetPVarInt(playerid, "AdminLevel", PlayerInfo[playerid][pAdmin]);

			mysql_fetch_field_row(result,"PetLevel"); PlayerInfo[playerid][pPetLevel] = strval( result );
			mysql_fetch_field_row(result,"PetPoints"); PlayerInfo[playerid][pPetPoints] = strval( result );
			mysql_fetch_field_row(result,"PetStatus"); PlayerInfo[playerid][pPetStatus] = strval( result );
			mysql_fetch_field_row(result,"Pet"); PlayerInfo[playerid][pPet] = strval( result );
		
			mysql_fetch_field_row(result,"DM"); PlayerInfo[playerid][pDM] = strval( result );
			mysql_fetch_field_row(result,"Vip"); PlayerInfo[playerid][pVip] = 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] = floatstr( 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,"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,"MowerSkill"); PlayerInfo[playerid][pWoodSkill] = strval( result );
			mysql_fetch_field_row(result,"StivuitorSkill"); PlayerInfo[playerid][pStivuitorSkill] = strval( result );
			mysql_fetch_field_row(result,"TruckerSkill"); PlayerInfo[playerid][pTruckerSkill] = strval( result );
			mysql_fetch_field_row(result,"IceSkill"); PlayerInfo[playerid][pJackerSkill] = strval( result );
			mysql_fetch_field_row(result,"GarbageSkill"); PlayerInfo[playerid][pGarbageSkill] = strval( result );
			mysql_fetch_field_row(result,"FarmerSkill"); PlayerInfo[playerid][pFarmerSkill] = 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][pPhone] = strval( result );
	        mysql_fetch_field_row(result,"House"); PlayerInfo[playerid][pHouse] = strval( result );
	        mysql_fetch_field_row(result,"Bizz"); PlayerInfo[playerid][pBizz] = strval( 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,"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,"Radio2"); PlayerInfo[playerid][pMP3] = 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,"WantedTime"); WantedTime[playerid] = 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,"WarTurf"); new turf = strval( result );
            mysql_fetch_field_row(result,"WarKills"); ucideri[playerid][turf] = strval( result );
			mysql_fetch_field_row(result,"WarDeaths"); decese[playerid][turf] = strval( result );
			WarKills[playerid] = ucideri[playerid][turf];
			WarDeaths[playerid] = decese[playerid][turf];
						
			mysql_fetch_field_row(result,"Referral"); PlayerInfo[playerid][pReferral] = strval( result );
			mysql_fetch_field_row(result,"ReferralRP"); PlayerInfo[playerid][pReferralRP] = strval( result );
			mysql_fetch_field_row(result,"ReferralMoney"); PlayerInfo[playerid][pReferralMoney] = strval( result );
				
			mysql_fetch_field_row(result,"referralp"); PlayerInfo[playerid][pReferralP] = 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,"ALeader"); PlayerInfo[playerid][pALeader] = strval( result );

			mysql_fetch_field_row(result,"ShowJob"); PlayerInfo[playerid][pShowJob] = strval( result );
			mysql_fetch_field_row(result,"GiftPoints"); PlayerInfo[playerid][pGiftPoints] = strval( result );
			mysql_fetch_field_row(result,"NewbieMute"); PlayerInfo[playerid][pNewbieMute] = strval( result );
			mysql_fetch_field_row(result,"ReportTime"); PlayerInfo[playerid][pReportTime] = strval( result );
			mysql_fetch_field_row(result, "WTChannel"); WTChannel[playerid] = strval( result );

			mysql_fetch_field_row(result,"HelpedPlayers"); PlayerInfo[playerid][pHelpedPlayers] = strval( result );
			mysql_fetch_field_row(result,"HelpedPlayersToday"); PlayerInfo[playerid][pHelpedPlayersToday] = strval( result );
			mysql_fetch_field_row(result,"ShowFP"); PlayerInfo[playerid][pShowFP] = strval( result );
			mysql_fetch_field_row(result,"ShowLogo"); PlayerInfo[playerid][pShowLogo] = strval( result );
			mysql_fetch_field_row(result,"ShowCeas"); PlayerInfo[playerid][pShowCeas] = strval( result );

			mysql_fetch_field_row(result,"GoldPoints"); PlayerInfo[playerid][pPremiumPoints] = strval( result );
		
			// tog
			NewbieChat[playerid] = cache_get_field_content_int(0, "NewbieChat", SQL);
			toglc[playerid] = cache_get_field_content_int(0, "TogLC", SQL);
			gFam[playerid] = cache_get_field_content_int(0, "TogFC", SQL);
			WTToggle[playerid] = cache_get_field_content_int(0, "TogWT", SQL);
			HidePM[playerid] = cache_get_field_content_int(0, "HidePM", SQL);
			gNews[playerid] = cache_get_field_content_int(0, "TogNews", SQL);
			toglicitatie[playerid] = cache_get_field_content_int(0, "TogLicitatie", SQL);
			togclan[playerid] = cache_get_field_content_int(0, "TogClan", SQL);
			togvip[playerid] = cache_get_field_content_int(0, "TogVip", SQL);
			togevent[playerid] = cache_get_field_content_int(0, "TogEvent", SQL);
			togding[playerid] = cache_get_field_content_int(0, "TogDing", SQL);
			togsurf[playerid] = cache_get_field_content_int(0, "TogSurf", SQL);			
			tograport[playerid] = cache_get_field_content_int(0, "TogRaport", SQL);
			togalert[playerid] = cache_get_field_content_int(0, "TogAlert", SQL);
			togjob[playerid] = cache_get_field_content_int(0, "TogJob", SQL);		
			togfind[playerid] = cache_get_field_content_int(0, "TogFind", SQL);
			PhoneOnline[playerid] = cache_get_field_content_int(0, "PhoneOnline", SQL);

			mysql_fetch_field_row(result,"Clan"); PlayerInfo[playerid][pClan] = strval( result );
			mysql_fetch_field_row(result,"Tag"); PlayerInfo[playerid][pTag] = strval( result );
			
			mysql_fetch_field_row(result,"ClanRank"); PlayerInfo[playerid][pClanRank] = strval( result );
			mysql_fetch_field_row(result,"ClanWarn"); PlayerInfo[playerid][pClanWarn] = strval( result );
			mysql_fetch_field_row(result,"ClanDays"); PlayerInfo[playerid][pClanDays] = strval( result );
																
			mysql_fetch_field_row(result,"InvalidCommands"); PlayerInfo[playerid][pInvalidCommands] = strval( result );			
			mysql_fetch_field_row(result,"Commands"); PlayerInfo[playerid][pCommands][0] = strval( result );
			mysql_fetch_field_row(result,"Commands2"); PlayerInfo[playerid][pCommands][1] = strval( result );
			mysql_fetch_field_row(result,"Commands3"); PlayerInfo[playerid][pCommands][2] = strval( result );
			mysql_fetch_field_row(result,"Commands4"); PlayerInfo[playerid][pCommands][3] = strval( result );
			mysql_fetch_field_row(result,"Commands5"); PlayerInfo[playerid][pCommands][4] = strval( result );

			if(SpecialWeek == 1) {
				new questsvar[1028];
				cache_get_field_content(0, "SpecialQuest", result); format(questsvar, 256, result);
				sscanf(questsvar, "p<|>iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii", 
				PlayerInfo[playerid][pSpecialQuest][0], PlayerInfo[playerid][pSpecialQuest][1], PlayerInfo[playerid][pSpecialQuest][2], PlayerInfo[playerid][pSpecialQuest][3], PlayerInfo[playerid][pSpecialQuest][4],
				PlayerInfo[playerid][pSpecialQuest][5], PlayerInfo[playerid][pSpecialQuest][6], PlayerInfo[playerid][pSpecialQuest][7], PlayerInfo[playerid][pSpecialQuest][8], PlayerInfo[playerid][pSpecialQuest][9],
				PlayerInfo[playerid][pSpecialQuest][10], PlayerInfo[playerid][pSpecialQuest][11], PlayerInfo[playerid][pSpecialQuest][12], PlayerInfo[playerid][pSpecialQuest][13], PlayerInfo[playerid][pSpecialQuest][14],
				PlayerInfo[playerid][pSpecialQuest][15], PlayerInfo[playerid][pSpecialQuest][16], PlayerInfo[playerid][pSpecialQuest][17], PlayerInfo[playerid][pSpecialQuest][18], PlayerInfo[playerid][pSpecialQuest][19],		
				PlayerInfo[playerid][pSpecialQuest][20], PlayerInfo[playerid][pSpecialQuest][21], PlayerInfo[playerid][pSpecialQuest][22], PlayerInfo[playerid][pSpecialQuest][23], PlayerInfo[playerid][pSpecialQuest][24],
				PlayerInfo[playerid][pSpecialQuest][25], PlayerInfo[playerid][pSpecialQuest][26], PlayerInfo[playerid][pSpecialQuest][27], PlayerInfo[playerid][pSpecialQuest][28], PlayerInfo[playerid][pSpecialQuest][29],	
				PlayerInfo[playerid][pSpecialQuest][30], PlayerInfo[playerid][pSpecialQuest][31], PlayerInfo[playerid][pSpecialQuest][32], PlayerInfo[playerid][pSpecialQuest][33], PlayerInfo[playerid][pSpecialQuest][34],
				PlayerInfo[playerid][pSpecialQuest][35], PlayerInfo[playerid][pSpecialQuest][36], PlayerInfo[playerid][pSpecialQuest][37], PlayerInfo[playerid][pSpecialQuest][38], PlayerInfo[playerid][pSpecialQuest][39],	
				PlayerInfo[playerid][pSpecialQuest][40], PlayerInfo[playerid][pSpecialQuest][41], PlayerInfo[playerid][pSpecialQuest][42], PlayerInfo[playerid][pSpecialQuest][43], PlayerInfo[playerid][pSpecialQuest][44],
				PlayerInfo[playerid][pSpecialQuest][45], PlayerInfo[playerid][pSpecialQuest][46], PlayerInfo[playerid][pSpecialQuest][47], PlayerInfo[playerid][pSpecialQuest][48], PlayerInfo[playerid][pSpecialQuest][49],
				PlayerInfo[playerid][pSpecialQuest][50], PlayerInfo[playerid][pSpecialQuest][51], PlayerInfo[playerid][pSpecialQuest][52], PlayerInfo[playerid][pSpecialQuest][53], PlayerInfo[playerid][pSpecialQuest][54],
				PlayerInfo[playerid][pSpecialQuest][55], PlayerInfo[playerid][pSpecialQuest][56], PlayerInfo[playerid][pSpecialQuest][57], PlayerInfo[playerid][pSpecialQuest][58], PlayerInfo[playerid][pSpecialQuest][59],
				PlayerInfo[playerid][pSpecialQuest][60], PlayerInfo[playerid][pSpecialQuest][61], PlayerInfo[playerid][pSpecialQuest][62], PlayerInfo[playerid][pSpecialQuest][63], PlayerInfo[playerid][pSpecialQuest][64],
				PlayerInfo[playerid][pSpecialQuest][65], PlayerInfo[playerid][pSpecialQuest][66], PlayerInfo[playerid][pSpecialQuest][67], PlayerInfo[playerid][pSpecialQuest][68], PlayerInfo[playerid][pSpecialQuest][69],		
				PlayerInfo[playerid][pSpecialQuest][70], PlayerInfo[playerid][pSpecialQuest][71], PlayerInfo[playerid][pSpecialQuest][72], PlayerInfo[playerid][pSpecialQuest][73], PlayerInfo[playerid][pSpecialQuest][74],
				PlayerInfo[playerid][pSpecialQuest][75], PlayerInfo[playerid][pSpecialQuest][76], PlayerInfo[playerid][pSpecialQuest][77], PlayerInfo[playerid][pSpecialQuest][78], PlayerInfo[playerid][pSpecialQuest][79],	
				PlayerInfo[playerid][pSpecialQuest][80], PlayerInfo[playerid][pSpecialQuest][81], PlayerInfo[playerid][pSpecialQuest][82], PlayerInfo[playerid][pSpecialQuest][83], PlayerInfo[playerid][pSpecialQuest][84],
				PlayerInfo[playerid][pSpecialQuest][85], PlayerInfo[playerid][pSpecialQuest][86], PlayerInfo[playerid][pSpecialQuest][87], PlayerInfo[playerid][pSpecialQuest][88], PlayerInfo[playerid][pSpecialQuest][89],	
				PlayerInfo[playerid][pSpecialQuest][90], PlayerInfo[playerid][pSpecialQuest][91], PlayerInfo[playerid][pSpecialQuest][92], PlayerInfo[playerid][pSpecialQuest][93], PlayerInfo[playerid][pSpecialQuest][94],
				PlayerInfo[playerid][pSpecialQuest][95], PlayerInfo[playerid][pSpecialQuest][96], PlayerInfo[playerid][pSpecialQuest][97], PlayerInfo[playerid][pSpecialQuest][98], PlayerInfo[playerid][pSpecialQuest][99]);	
				for(new i = 0; i < 100; i++) {
					if(PlayerInfo[playerid][pSpecialQuest][i] == 0) {				
						PlayerInfo[playerid][pObjectQuest][i] = CreatePlayerObject(playerid, 1240, QuestPos[i][0], QuestPos[i][1], QuestPos[i][2], 0, 0, 0, 300.0);
					}
				}
			}	

			new skin[64];
			cache_get_field_content(0, "Skin", result); format(skin, 64, result);
            sscanf(skin, "p<|>iiiiiiiiii", PlayerInfo[playerid][pSkins][0], PlayerInfo[playerid][pSkins][1], PlayerInfo[playerid][pSkins][2], PlayerInfo[playerid][pSkins][3], PlayerInfo[playerid][pSkins][4],
            PlayerInfo[playerid][pSkins][5], PlayerInfo[playerid][pSkins][6], PlayerInfo[playerid][pSkins][7], PlayerInfo[playerid][pSkins][8], PlayerInfo[playerid][pSkins][9]);
  
			new achivar[256];
			cache_get_field_content(0, "AchievementStatus", result); format(achivar, 256, result);
			sscanf(achivar, "p<|>iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii", 
			PlayerInfo[playerid][pAchievementStatus][0], PlayerInfo[playerid][pAchievementStatus][1], PlayerInfo[playerid][pAchievementStatus][2], PlayerInfo[playerid][pAchievementStatus][3], PlayerInfo[playerid][pAchievementStatus][4],
			PlayerInfo[playerid][pAchievementStatus][5], PlayerInfo[playerid][pAchievementStatus][6], PlayerInfo[playerid][pAchievementStatus][7], PlayerInfo[playerid][pAchievementStatus][8], PlayerInfo[playerid][pAchievementStatus][9],
			PlayerInfo[playerid][pAchievementStatus][10], PlayerInfo[playerid][pAchievementStatus][11], PlayerInfo[playerid][pAchievementStatus][12], PlayerInfo[playerid][pAchievementStatus][13], PlayerInfo[playerid][pAchievementStatus][14],
			PlayerInfo[playerid][pAchievementStatus][15], PlayerInfo[playerid][pAchievementStatus][16], PlayerInfo[playerid][pAchievementStatus][17], PlayerInfo[playerid][pAchievementStatus][18], PlayerInfo[playerid][pAchievementStatus][19],		
			PlayerInfo[playerid][pAchievementStatus][20], PlayerInfo[playerid][pAchievementStatus][21], PlayerInfo[playerid][pAchievementStatus][22], PlayerInfo[playerid][pAchievementStatus][23], PlayerInfo[playerid][pAchievementStatus][24],
			PlayerInfo[playerid][pAchievementStatus][25], PlayerInfo[playerid][pAchievementStatus][26], PlayerInfo[playerid][pAchievementStatus][27], PlayerInfo[playerid][pAchievementStatus][28], PlayerInfo[playerid][pAchievementStatus][29],	
			PlayerInfo[playerid][pAchievementStatus][30], PlayerInfo[playerid][pAchievementStatus][31]);
			
			SpawnChange[playerid] = cache_get_field_content_int(0, "SpawnChange");
			PlayerInfo[playerid][pSeconds] = cache_get_field_content_float(0, "Seconds");
			PlayerInfo[playerid][pUsed] = cache_get_field_content_int(0, "Used");
			
			PlayerInfo[playerid][pRacePlace][0] = cache_get_field_content_int(0, "RacePlace1");
			PlayerInfo[playerid][pRacePlace][1] = cache_get_field_content_int(0, "RacePlace2");
			PlayerInfo[playerid][pRacePlace][2] = cache_get_field_content_int(0, "RacePlace3");
			PlayerInfo[playerid][pRacePlace][3] = cache_get_field_content_int(0, "RacePlace4");
			PlayerInfo[playerid][pArenaStats][0] = cache_get_field_content_int(0, "ArenaKills");
			PlayerInfo[playerid][pArenaStats][1] = cache_get_field_content_int(0, "ArenaDeaths");
			PlayerInfo[playerid][pPaintKills][0] = cache_get_field_content_int(0, "PaintKills1");
			PlayerInfo[playerid][pPaintKills][1] = cache_get_field_content_int(0, "PaintKills2");
			PlayerInfo[playerid][pPaintKills][2] = cache_get_field_content_int(0, "PaintKills3");
			PlayerInfo[playerid][pPaintDeaths][2] = cache_get_field_content_int(0, "PaintDeaths1");
			PlayerInfo[playerid][pPaintDeaths][2] = cache_get_field_content_int(0, "PaintDeaths2");
			PlayerInfo[playerid][pPaintDeaths][2] = cache_get_field_content_int(0, "PaintDeaths3");
			PlayerInfo[playerid][pCarLicS] = cache_get_field_content_int(0, "CarLicS", SQL);
			PlayerInfo[playerid][pBoatLicS] = cache_get_field_content_int(0, "BoatLicS", SQL);
			PlayerInfo[playerid][pFlyLicS] = cache_get_field_content_int(0, "FlyLicS", SQL);
			PlayerInfo[playerid][pGunLicS] = cache_get_field_content_int(0, "GunLicS", SQL);		
			PlayerInfo[playerid][pCarKey][0] = cache_get_field_content_int(0, "CarKey1", SQL);
			PlayerInfo[playerid][pCarKey][1] = cache_get_field_content_int(0, "CarKey2", SQL);
			PlayerInfo[playerid][pCarKey][2] = cache_get_field_content_int(0, "CarKey3", SQL);
			PlayerInfo[playerid][pCarKey][3] = cache_get_field_content_int(0, "CarKey4", SQL);
			PlayerInfo[playerid][pCarKey][4] = cache_get_field_content_int(0, "CarKey5", SQL);
			PlayerInfo[playerid][pCarKey][5] = cache_get_field_content_int(0, "CarKey6", SQL);
			PlayerInfo[playerid][pCarKey][6] = cache_get_field_content_int(0, "CarKey7", SQL);
			PlayerInfo[playerid][pCarKey][7] = cache_get_field_content_int(0, "CarKey8", SQL);
			PlayerInfo[playerid][pCarKey][8] = cache_get_field_content_int(0, "CarKey9", SQL);
			PlayerInfo[playerid][pCarKey][9] = cache_get_field_content_int(0, "CarKey10", SQL);
			PlayerInfo[playerid][pShowDMG] = cache_get_field_content_int(0, "ShowDMG", SQL);
			PlayerInfo[playerid][pSlot][0] = cache_get_field_content_int(0, "Slot1", SQL);
			PlayerInfo[playerid][pSlot][1] = cache_get_field_content_int(0, "Slot2", SQL);
			PlayerInfo[playerid][pSlot][2] = cache_get_field_content_int(0, "Slot3", SQL);
			PlayerInfo[playerid][pSlot][3] = cache_get_field_content_int(0, "Slot4", SQL);
			PlayerInfo[playerid][pSlot][4] = cache_get_field_content_int(0, "Slot5", SQL);
			PlayerInfo[playerid][pDailyMission][0] = cache_get_field_content_int(0, "DailyMission", SQL);
			PlayerInfo[playerid][pDailyMission][1] = cache_get_field_content_int(0, "DailyMission2", SQL);
			PlayerInfo[playerid][pNeedProgress][0] = cache_get_field_content_int(0, "NeedProgress1", SQL);
			PlayerInfo[playerid][pNeedProgress][1] = cache_get_field_content_int(0, "NeedProgress2", SQL);			
			PlayerInfo[playerid][pProgress][0] = cache_get_field_content_int(0, "Progress", SQL);
			PlayerInfo[playerid][pProgress][1] = cache_get_field_content_int(0, "Progress2", SQL);
			PlayerInfo[playerid][pPizzaSkill] = cache_get_field_content_int(0, "PizzaSkill", SQL);
			PlayerInfo[playerid][pCurierSkill] = cache_get_field_content_int(0, "CurierSkill", SQL);
			PlayerInfo[playerid][pGasCan] = cache_get_field_content_int(0, "GasCan", SQL);
			new string[180];
			PlayerInfo[playerid][pGlasses] = cache_get_field_content_int(0, "Glasses", SQL);
			PlayerInfo[playerid][pShowGlasses] = cache_get_field_content_int(0, "ShowGlasses", SQL);

			PlayerInfo[playerid][pShowHP] = cache_get_field_content_int(0, "ShowHP", SQL);
			PlayerInfo[playerid][pShowCP] = cache_get_field_content_int(0, "ShowCP", SQL);
			PlayerInfo[playerid][pShowAP] = cache_get_field_content_int(0, "ShowAP", SQL);
			PlayerInfo[playerid][pPin] = cache_get_field_content_int(0, "Pin", SQL);
			PlayerInfo[playerid][pFires] = cache_get_field_content_int(0, "Fires", SQL);
			PlayerInfo[playerid][pColor] = cache_get_field_content_int(0, "Color", SQL);
			PlayerInfo[playerid][pDays] = cache_get_field_content_int(0, "Days", SQL);		
			PlayerInfo[playerid][pPilotSkill] = cache_get_field_content_int(0, "PilotSkill", SQL);		
			PlayerInfo[playerid][pEscapePoints] = cache_get_field_content_int(0, "EscapePoints", SQL);
			PlayerInfo[playerid][pHat] = cache_get_field_content_int(0, "Hat", SQL);
			PlayerInfo[playerid][pCoins] = cache_get_field_content_int(0, "Coins", SQL);
			PlayerInfo[playerid][pShowHat] = cache_get_field_content_int(0, "ShowHat", SQL);
			PlayerInfo[playerid][pDailyLogin] = cache_get_field_content_int(0, "DailyLogin", SQL);
			PlayerInfo[playerid][pCrash] = cache_get_field_content_int(0, "Crash", SQL);
  			PlayerInfo[playerid][pAJail] = cache_get_field_content_int(0, "AJail", SQL);		
			PlayerInfo[playerid][pHW] = cache_get_field_content_int(0, "HW", SQL);
			PlayerInfo[playerid][pAW] = cache_get_field_content_int(0, "AW", SQL);
			PlayerInfo[playerid][pLW] = cache_get_field_content_int(0, "LW", SQL);
			  
			new clanid = PlayerInfo[playerid][pClan];
			if(PlayerInfo[playerid][pClan] != 0 && PlayerInfo[playerid][pTag] == 0) {
			    format(string, sizeof(string), "%s%s", ClanInfo[clanid][clTag], PlayerInfo[playerid][pUsername]);
			    SetPlayerName(playerid, string);
			}
			else if(PlayerInfo[playerid][pClan] != 0 && PlayerInfo[playerid][pTag] == 1) {
			    format(string, sizeof(string), "%s%s", PlayerInfo[playerid][pUsername], ClanInfo[clanid][clTag]);
			    SetPlayerName(playerid, string);
			}
			
			LoadPlayerCars(playerid);			
			SetPlayerToTeamColor(playerid);
			ADeathMessage(playerid, INVALID_PLAYER_ID, 200);
			new ip[16];
			GetPlayerIp(playerid, ip, sizeof(ip));
			format(string, sizeof(string), "UPDATE `users` SET `Status` = '1', `IP`='%s' WHERE `ID`='%d'", ip, PlayerInfo[playerid][pSQLID]);
			mysql_tquery(SQL,string, "", "");
			UpdateVar(playerid, "DayLogin", 1);
			TextDrawHideForPlayer(playerid, ServerTD);
			GameTextForPlayer(playerid, " ", 1000, 4);
			SpawnPlayer(playerid);
	   	}
		for( new j = 0; j <= 100; j++) SCM(playerid, COLOR_WHITE, "");
	}
	else {
		new loginstring[128];
		format(loginstring,sizeof(loginstring),"Parola introdusa de tine este incorecta!\nIntrodu parola corecta altfel vei primi kick!",GetName(playerid));
		ShowPlayerDialog(playerid, DIALOG_LOGIN3,DIALOG_STYLE_PASSWORD,"Logare",loginstring,"Logare","Quit");
        mysql_free_result();
        gPlayerLogTries[playerid] += 1;
		new string[180];
		if(gPlayerLogTries[playerid] < 3) format(string, sizeof(string), "Parola incorecta! Mai ai la dispozitie %d incercari.", 3-gPlayerLogTries[playerid]);
		else format(string, sizeof(string), "Parola incorecta! Incercarile au fost epuizate si ai primit kick.", 3-gPlayerLogTries[playerid]);
		SCM(playerid, COLOR_WARNING, string);				
        if(gPlayerLogTries[playerid] == 3) KickEx(playerid);
        return 1;
	}
	mysql_free_result();
	ResetPlayerCash(playerid);
	GivePlayerCash(playerid,PlayerInfo[playerid][pCash]);
	CurrentMoney[playerid] = PlayerInfo[playerid][pCash];
	KillTimer(login[playerid]);
	if(PlayerInfo[playerid][pReg] == 0) {
		PlayerInfo[playerid][pLevel] = 1;
		PlayerInfo[playerid][pHealth] = 100.0;
		PlayerInfo[playerid][pInt] = 0;
		PlayerInfo[playerid][pLocal] = 255;
		PlayerInfo[playerid][pTeam] = 3;
		PlayerInfo[playerid][pModel] = 250;
		PlayerInfo[playerid][pHouse] = 999;
		PlayerInfo[playerid][pBizz] = 255;
		PlayerInfo[playerid][pAccount] = 1000;
		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[180];
		format(str,sizeof(str),"UPDATE users SET `pHealth`='100.0',`Team`='3',`Model`='250' WHERE `ID`='%d'",PlayerInfo[playerid][pSQLID]);
		mysql_query(SQL,str);
		Update(playerid,pCashx);
		Update(playerid,pLevelx);
		Update(playerid,pHousex);
		Update(playerid,pBizzx);
		Update(playerid,pPnumberx);
		Update(playerid,pRegx);
		Update(playerid,pRegistredDatex);
	}
	if(PlayerInfo[playerid][pBTemp] == 1) { TempBanCheck(playerid); return 1; }
	if(PlayerInfo[playerid][pBanned] == 1) {
		for( new j = 0; j <= 100; j++) SCM(playerid, COLOR_WHITE, "");
		SCM(playerid, COLOR_WARNING, "Acest cont este banat permanent!");
		new str[180];
		format(str, sizeof str, "Ai fost banat de adminul %s.",PlayerInfo[playerid][pBBy]);
		SCM(playerid, COLOR_CLIENT, str);
		format(str, sizeof str, "Motivul: %s",PlayerInfo[playerid][pBReason]);
		SCM(playerid, COLOR_CLIENT, str);
		KickEx(playerid);
		SetPlayerCameraPos(playerid, 1183.0143, -965.7394, 129.6071);
		SetPlayerCameraLookAt(playerid, 1183.7214, -965.0270, 129.2470);
		TogglePlayerSpectating(playerid, 0);		
		return 1;
	}
    StopAudioStreamForPlayer(playerid);
	SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
	new string2[180];
	if(PlayerInfo[playerid][pTut] != 0) {	
		for(new i = 0; i < 18; i++) TextDrawHideForPlayer(playerid, LoginTD[i]);
		format(string2, 256, "Bine ai venit, %s!", GetName(playerid));
		SCM(playerid, -1, string2);
		if(PlayerInfo[playerid][pMember] != 0) {
			if(PlayerInfo[playerid][pDays] == 30) {
				if(PlayerInfo[playerid][pMember] == 11) finishAchievement(playerid, 23);	
				else if(IsACop(playerid)) finishAchievement(playerid, 24);	
				else if(IsAMember(playerid)) finishAchievement(playerid, 25);	
				else finishAchievement(playerid, 22);		
			}
		}
	}	
	if(PlayerInfo[playerid][pWantedLevel] > 0 && PlayerInfo[playerid][pTut] != 0) {
		format(string2, sizeof(string2), "Aveai wanted %d inainte sa iesi de pe server.",PlayerInfo[playerid][pWantedLevel]);
		SetPlayerWantedLevel(playerid, PlayerInfo[playerid][pWantedLevel]);
		SCM(playerid, COLOR_LIGHTRED, string2);
	}
	SetSpawnInfo(playerid, PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModel], 937.1783,-1717.5684,13.5469, 1.0, -1, -1, -1, -1, -1, -1);
	if(gTeam[playerid] == 0) gTeam[playerid] = 3;
	else gTeam[playerid] = PlayerInfo[playerid][pTeam];
	if(PlayerInfo[playerid][pMember] != 0 && PlayerInfo[playerid][pTut] != 0) {
	    new disc[84];
	    format(disc,sizeof(disc),"(Factiune) %s s-a conectat pe server.",GetName(playerid));
	    SendFactionMessage(PlayerInfo[playerid][pMember], COLOR_CLIENT, disc);
	}

	HudProgress[playerid][0] = CreatePlayerProgressBar(playerid, 513.00, 150.00, 85.50, 2.50, 0x00FF00FF, 100.0);	
	HudProgress[playerid][1] = CreatePlayerProgressBar(playerid, 513.00, 175.00, 85.50, 2.50, 0x00FF00FF, 100.0);
	UpdateProgress(playerid, 0);
	UpdateProgress(playerid, 1);

	
	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),"%s(%d) connected on the server with IP: %s.",sendername,playerid,playersip);
	SendIP(COLOR_WHITE,iplog);
	IsPlayerLogged[playerid] = 1;
	if(PlayerInfo[playerid][pTut] == 0) {
		gOoc[playerid] = 1; gNews[playerid] = 1; gFam[playerid] = 1;
		TogglePlayerControllable(playerid, 0);
		RegistrationStep[playerid] = 1;
		SCM(playerid, 0xFFDE96FF, "Te rugam sa raspunzi la urmatoarele intrebari.");
		ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_MSGBOX, "Register:", "Care este sexul caracterului tau?\nMasculin sau Feminin?", "Masculin", "Feminin");
		SetPlayerInterior(playerid, 0);
	}	
	printf("%s has logged in with IP %s.",sendername,playersip);
	if(PlayerInfo[playerid][pDailyMission][0] == -1 || PlayerInfo[playerid][pDailyMission][1] == -1) GiveQuest(playerid);
	if(PlayerInfo[playerid][pTut] != 0) {
		if(PlayerInfo[playerid][pLevel] < 5) {
			SCM(playerid, -1, "Pentru a vedea ce misiuni ai in aceasta zi, foloseste /quests.");
			
		}
		new clanid = PlayerInfo[playerid][pClan], string[180];
		if(clanid != 0) {
			format(string, sizeof(string), "{%s}(CMOTD): %s.", ClanInfo[PlayerInfo[playerid][pClan]][clColor], ClanInfo[PlayerInfo[playerid][pClan]][clMotd]);
			MesajLung(playerid, -1, string);
		}
		if(PlayerInfo[playerid][pMember] != 0) {
			if(strlen(DynamicFactions[PlayerInfo[playerid][pMember]][fAnn]) > 0)
			{
				new factioninfo[128];
				format(factioninfo,sizeof(factioninfo), "(FMOTD): %s",DynamicFactions[PlayerInfo[playerid][pMember]][fAnn]);
				MesajLung(playerid,COLOR_YELLOW,factioninfo);
			}		
		}
		new szQuery[256], szString[180], onf, Cache: results;
		format(szQuery, sizeof(szQuery), "SELECT * FROM `friends` WHERE `AddBy` = '%d'", PlayerInfo[playerid][pSQLID]);
		results = mysql_query(SQL, szQuery);
		// playerid login
		for(new i, j = cache_get_row_count (); i != j; ++i)
		{
			cache_get_field_content(i, "friendName", szString);
			new userID = GetPlayerID(szString);
			if(userID != INVALID_PLAYER_ID) onf ++;
		}
		cache_delete(results);
		format(string, sizeof(string), "Ai %d prieteni conectati in lista ta de prieteni.", onf);
		
		if(onf != 0) {
			PlayerTextDrawSetString(playerid, FriendTD, string);
			PlayerTextDrawShow(playerid, FriendTD);
			SetTimerEx("HideFriendTD", 3000, false, "i", playerid);			
		}
	
		if(PlayerInfo[playerid][pDailyLogin] == 0) SCM(playerid, COLOR_LIGHTBLUE, "Vei primi de doua ori mai multi bani si puncte de respect la urmatorul payday.");
		if(PlayerInfo[playerid][pBizz] != 255) finishAchievement(playerid, 2);
		if(PlayerInfo[playerid][pHouse] != 999 && strcmp(GetName(playerid), HouseInfo[PlayerInfo[playerid][pHouse]][hOwner], true) == 0) finishAchievement(playerid, 3);

		// if exist player in other friend list
		foreach(Player, i) {
			if(IsPlayerConnected(i) && IsPlayerLogged[i] == 1) {
				format(szQuery, sizeof(szQuery), "SELECT * FROM `friends` WHERE `AddBy` = '%d' AND `friendID` = '%d'", PlayerInfo[i][pSQLID], PlayerInfo[playerid][pSQLID]);
				results = mysql_query(SQL, szQuery);
				cache_get_field_content(0, "AddBy", szString);
				new friendID = strval(szString);
				cache_delete(results);
				if(PlayerInfo[i][pSQLID] == friendID && friendID != 0) {
					if(PlayerInfo[playerid][pAdmin] < 7) {
						format(string, sizeof(string), "Prietenul tau, %s, s-a conectat pe server.", GetName(playerid));
						PlayerTextDrawSetString(i, FriendTD, string);
						PlayerTextDrawShow(i, FriendTD);
						SetTimerEx("HideFriendTD", 3000, false, "i", i);	
					}	
				}
			}
		}	
		CalculateEmails(playerid);
		check_save(playerid);
	}	
	return 1;
}

asta este onplayerlogin la mine

Edited by Sprite_RoPlayers

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • 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.