Jump to content

Sprite_RoPlayers

Membru
  • Posts

    67
  • Joined

  • Last visited

Posts posted by Sprite_RoPlayers

  1. 1 oră în urmă, iSkull a spus:

    Prezinta tot scriptul ce tine de ce ai postat mai sus

    Pai asta este cod-ul pe care il am eu la KEY_YES adica asta este functia de iti ei job-ul

            if(PlayerInfo[playerid][pJob] == 0){
        	       for(new j = 1; j < MAX_JOBS; j++) {
                    if(IsPlayerInAnyVehicle(playerid)) return SCM(playerid, COLOR_LGREEN, "Eroare: Nu poti aceasta comanda dintr-un vehicul!");
    		        if(PlayerToPoint(3.0, playerid, JobInfo[j][jPosX], JobInfo[j][jPosY], JobInfo[j][jPosZ]) && j != 7) {
    			       if(PlayerInfo[playerid][pLevel] < JobInfo[j][jLevel]) {
    				   format(string, sizeof(string), "Ai nevoie de level %d pentru a lua jobul %s.",  JobInfo[j][jLevel], JobInfo[j][jName]);
    				   SCM(playerid, COLOR_WHITE, string);
    				   return 1;
       	               }
    
    	    		   format(string, sizeof(string), "*Felicitari! Noul tau job este acum %s.", JobInfo[j][jName]);
    			       SCM(playerid, COLOR_LIGHTBLUE, string);
    
        		       if(j == 7) SCM(playerid, COLOR_LIGHTBLUE, "Comenzile disponibile pentru acest job sunt: /repair si /refill.");
    			   	   else if(j == 8) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a localiza un player, foloseste comanda /find.");	
    			   	   else if(j == 11) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a incepe sa muncesti ai la dispozitie comanda /fish.");
    			   	   else if(j != 6) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a incepe sa muncesti, ai la dispozitie comanda /work.");
    			   	   else if(j == 16) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a incepe sa te antrenenzi, ai la dispozitie comanda /startantrenament.");
    			   	   //else if(j !- 16) SCM(playerid, COLOR_LIGHTGREEN,"Pentru a incepe sa te antrenenzi, ai la dispozitie comanda /startantrenament");
    
    			       PlayerInfo[playerid][pJob] = j;
    			
        			   new str [128];
    			       mysql_format(SQL, str, 128, "UPDATE `users` SET `Job`='%d' WHERE `ID`='%d' LIMIT 1",PlayerInfo[playerid][pJob],PlayerInfo[playerid][pSQLID]);
            	       mysql_tquery(SQL, str, "", "");
                  }
               }
            } 

     

  2. Hai seara buna.

    Am si eu urmatoare problema si nu stiu cum as putea sa o rezolv. Vreau ca atunci cand dai la un anumit job sa ii apara si comanda de care are nevoie pentru a folosi acel job ca sa inceapa 

    Am facut asa eu

    else if(j == 16) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a incepe sa te antrenenzi, ai la dispozitie comanda /startantrenament.");
    
    Si am incercat si asa
    
    else if(j != 16) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a incepe sa te antrenenzi, ai la dispozitie comanda /startantrenament.");

    asta este tot ce am in gm 

     if(PlayerInfo[playerid][pJob] == 0){
        	       for(new j = 1; j < MAX_JOBS; j++) {
                    if(IsPlayerInAnyVehicle(playerid)) return SCM(playerid, COLOR_LGREEN, "Eroare: Nu poti aceasta comanda dintr-un vehicul!");
    		        if(PlayerToPoint(3.0, playerid, JobInfo[j][jPosX], JobInfo[j][jPosY], JobInfo[j][jPosZ]) && j != 20) {
    			       if(PlayerInfo[playerid][pLevel] < JobInfo[j][jLevel]) {
    				   format(string, sizeof(string), "Ai nevoie de level %d pentru a lua jobul %s.",  JobInfo[j][jLevel], JobInfo[j][jName]);
    				   SCM(playerid, COLOR_WHITE, string);
    				   return 1;
       	               }
    
    	    		   format(string, sizeof(string), "*Felicitari! Noul tau job este acum %s.", JobInfo[j][jName]);
    			       SCM(playerid, COLOR_LIGHTBLUE, string);
    
        		       if(j == 7) SCM(playerid, COLOR_LIGHTBLUE, "Comenzile disponibile pentru acest job sunt: /repair si /refill.");
    			   	   else if(j == 8) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a localiza un player, foloseste comanda /find.");	
    			   	   else if(j == 11) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a incepe sa muncesti ai la dispozitie comanda /fish.");
    			   	   else if(j != 6) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a incepe sa muncesti, ai la dispozitie comanda /work.");
    			   	   else if(j == 16) SCM(playerid, COLOR_LIGHTBLUE, "Pentru a incepe sa te antrenenzi, ai la dispozitie comanda /startantrenament.");
    			   	   //else if(j !- 16) SCM(playerid, COLOR_LIGHTGREEN,"Pentru a incepe sa te antrenenzi, ai la dispozitie comanda /startantrenament");
    
    			       PlayerInfo[playerid][pJob] = j;
    			
        			   new str [128];
    			       mysql_format(SQL, str, 128, "UPDATE `users` SET `Job`='%d' WHERE `ID`='%d' LIMIT 1",PlayerInfo[playerid][pJob],PlayerInfo[playerid][pSQLID]);
            	       mysql_tquery(SQL, str, "", "");
                  }
               }
            } 

    Dar nu merge ce-ia ce am facut eu si nu stiu cum sa rezolv

  3. Acum 6 minute, L3monz a spus:
    
    ----------
    Loaded log file: "server_log.txt".
    ----------
    
    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team
    
    [05:03:48] 
    [05:03:48] Server Plugins
    [05:03:48] --------------
    [05:03:48]  Loading plugin: crashdetect
    [05:03:48]   Failed.
    [05:03:48]  Loading plugin: sscanf
    [05:03:48]   Failed.
    [05:03:48]  Loading plugin: mysql
    [05:03:48]  >> plugin.mysql: R34 successfully loaded.
    [05:03:48]   Loaded.
    [05:03:48]  Loading plugin: streamer
    [05:03:48]   Failed.
    [05:03:48]  Loaded 1 plugins.
    
    [05:03:48] 
    [05:03:48] Filterscripts
    [05:03:48] ---------------
    [05:03:48]   Loaded 0 filterscripts.
    
    [05:03:48] Script[gamemodes/wa-rpg.amx]: Run time error 19: "File or function is not found"
    [05:03:48] Number of vehicle models: 0
    
    ----------
    Loaded log file: "server_log.txt".
    ----------
    
    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team
    
    [05:05:54] 
    [05:05:54] Server Plugins
    [05:05:54] --------------
    [05:05:54]  Loading plugin: crashdetect
    [05:05:54]   Failed.
    [05:05:54]  Loading plugin: sscanf
    [05:05:54]   Failed.
    [05:05:54]  Loading plugin: mysql
    [05:05:54]  >> plugin.mysql: R34 successfully loaded.
    [05:05:54]   Loaded.
    [05:05:54]  Loading plugin: streamer
    [05:05:54]   Failed.
    [05:05:54]  Loaded 1 plugins.
    
    [05:05:54] 
    [05:05:54] Filterscripts
    [05:05:54] ---------------
    [05:05:54]   Loaded 0 filterscripts.
    
    [05:05:55] Script[gamemodes/wa-rpg.amx]: Run time error 19: "File or function is not found"
    [05:05:55] Number of vehicle models: 0
    
    ----------
    Loaded log file: "server_log.txt".
    ----------
    
    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team
    
    [07:01:40] 
    [07:01:40] Server Plugins
    [07:01:40] --------------
    [07:01:40]  Loading plugin: crashdetect
    [07:01:40]   Failed.
    [07:01:40]  Loading plugin: sscanf
    [07:01:40]   Failed.
    [07:01:40]  Loading plugin: mysql
    [07:01:40]  >> plugin.mysql: R34 successfully loaded.
    [07:01:40]   Loaded.
    [07:01:40]  Loading plugin: streamer
    [07:01:40]   Failed.
    [07:01:41]  Loaded 1 plugins.
    
    [07:01:41] 
    [07:01:41] Filterscripts
    [07:01:41] ---------------
    [07:01:41]   Loaded 0 filterscripts.
    
    [07:01:43] Script[gamemodes/wa-rpg.amx]: Run time error 19: "File or function is not found"
    [07:01:43] Number of vehicle models: 0
    
    ----------
    Loaded log file: "server_log.txt".
    ----------
    
    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team
    
    [07:04:57] 
    [07:04:57] Server Plugins
    [07:04:57] --------------
    [07:04:57]  Loading plugin: mysql
    [07:04:57]  >> plugin.mysql: R34 successfully loaded.
    [07:04:57]   Loaded.
    [07:04:57]  Loading plugin: streamer
    [07:04:57]   Failed.
    [07:04:57]  Loading plugin: crashdetect
    [07:04:57]   Failed.
    [07:04:57]  Loading plugin: sscanf
    [07:04:57]   Failed.
    [07:04:57]  Loaded 1 plugins.
    
    [07:04:57] 
    [07:04:57] Filterscripts
    [07:04:57] ---------------
    [07:04:57]   Loaded 0 filterscripts.
    
    [07:04:57] Script[gamemodes/wa-rpg.amx]: Run time error 19: "File or function is not found"
    [07:04:57] Number of vehicle models: 0
    
    ----------
    Loaded log file: "server_log.txt".
    ----------
    
    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team
    
    [07:05:51] 
    [07:05:51] Server Plugins
    [07:05:51] --------------
    [07:05:51]  Loading plugin: mysql.dll
    [07:05:51]  >> plugin.mysql: R34 successfully loaded.
    [07:05:51]   Loaded.
    [07:05:51]  Loading plugin: streamer.dll
    [07:05:51]   Failed.
    [07:05:51]  Loading plugin: crashdetect.dll
    [07:05:51]   Failed.
    [07:05:51]  Loading plugin: sscanf.dll
    [07:05:51]   Failed.
    [07:05:51]  Loaded 1 plugins.
    
    [07:05:51] 
    [07:05:51] Filterscripts
    [07:05:51] ---------------
    [07:05:51]   Loaded 0 filterscripts.
    
    [07:05:51] Script[gamemodes/wa-rpg.amx]: Run time error 19: "File or function is not found"
    [07:05:51] Number of vehicle models: 0

     

    Pune toate astea in folder-ul cu servar-ul. de unde il pornesti.

    http://www.girlshare.ro/3490241228.1

    Tu ai eroare la pluginuri.

    Incearca sa instalezi asta https://www.microsoft.com/en-us/download/details.aspx?id=48145

    Sau o versiune mai mare.

    Eu am aceasta versiune instalata.

    Ce windows folosesti?

    Recomand dupa ce ai instalat acel program sa dai si un restart la pc.

    Edit: sterge servar_log si dupa porneste sv si posteaza aici servar_log

  4. @L3monz

    Salut ai eroare la plugin-uri vezi sa nu ai in servar.cfg .so la sfarsit de denumire a plugin-ului.

    Daca nu ai atunci te rog descarca astea

    http://www.girlshare.ro/3490241227 (plugin-urile cu update la burned pe care le folosesc si eu )

    Ti-am mai pus si niste .dll-uri de care o sa ai nevoie acele .dll-uri vin in folder-ul cu servar.

    https://www.virustotal.com/#/url/a521921b636a13c33e11f4571515c65ce81521e61b9e0e69581e0e68583f2d13/detection

    Incaz ca nu ai incredere in ce ti-am dat eu.

    Daca te-am ajutat +1 Pace si iubire acolo man.

  5. Acum 3 ore, iSkull a spus:

    Ai probleme de array, la functia CreateVehicleEx & la comanda /work.

    YCMD:startwork(playerid, params[], help) {
    	if(PlayerInfo[playerid][pJob] == 11) return SCM(playerid, -1, "Foloseste /fish pentru a incepe munca la acest job!");
    	if(IsPlayerInAnyVehicle(playerid)) return SCM(playerid, COLOR_LGREEN, "Eroare: Nu poti aceasta comanda dintr-un vehicul!");
    	new Float: Pos[3], Float: CarAngle, string[128];
    	if(PlayerInfo[playerid][pJob] == 0) return SCM(playerid, COLOR_GREY, "Nu ai un job!");
    	if(JobWorking[playerid] == 1) return SCM(playerid, COLOR_WHITE, "Muncesti deja.");
    			
        GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]);
        if(targetfind[playerid] != -1) return ShowPlayerDialog(playerid, DIALOG_CHECKPOINT, DIALOG_STYLE_MSGBOX, "Checkpoint", "Ai deja un checkpoint activ.\nDoresti sa-l anulezi? Daca da, apasa pe 'Ok'.", "Ok", "Exit");
    	if(GetPlayerVirtualWorld(playerid) != 0) return 1;
    	if(JobDeelay[playerid][PlayerInfo[playerid][pJob]] != 0 && PlayerInfo[playerid][pAdmin] < 6) return JobTimeDeelay(playerid);
    	switch(PlayerInfo[playerid][pJob]) {
    	    case 1: {
    	        if(PlayerToPoint(7.0, playerid, -372.6979, -1456.3641, 26.4046)) {
    				if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de condus pentru a putea munci la acest job!");
    				JobSeconds[playerid] = 120;
                    CarAngle = -184.0199;
                    DisablePlayerCheckpointEx(playerid);
    			}
    	        else {
     				if(CP[playerid] != 0) return ShowPlayerDialog(playerid, DIALOG_CHECKPOINT, DIALOG_STYLE_MSGBOX, "Checkpoint", "Ai deja un checkpoint activ.\nDoresti sa-l anulezi? Daca da, apasa pe 'Ok'.", "Ok", "Exit");
    	          	CP[playerid] = 53;
    				SCM(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid, -372.6979, -1456.3641, 26.4046, 7.0);
    				return 1;
    		    }
    	    }
    	    case 2: {
    	        if(PlayerToPoint(7.0, playerid, -1017.3097,-638.8459,32.0078)) {
    				if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de condus pentru a putea munci la acest job!");
                    CarAngle = 74.1729;
                    CP[playerid] = 52;
                    DisablePlayerCheckpointEx(playerid);
    		    	new szDialog2[1024];				
    				strcat(szDialog2, "Category\tType\tSkill\n");
    				strcat(szDialog2, "Clothes\t{35DE1F}Legal\t1+\n");
    				strcat(szDialog2, "Food\t{35DE1F}Legal\t1+\n");
    				strcat(szDialog2, "Furniture\t{35DE1F}Legal\t1+\n");
    				strcat(szDialog2, "Explosible\t{35DE1F}Legal\t2+\n");
    				strcat(szDialog2, "Guns\t{F21313}Illegal\t3+\n");
    				strcat(szDialog2, "Stolen cars\t{F21313}Illegal\t3+\n");
    				ShowPlayerDialog(playerid, DIALOG_TRUCKER, DIALOG_STYLE_TABLIST_HEADERS, "Choose destination", szDialog2, "Select", "Cancel");			
    			}
    	        else {
     				if(CP[playerid] != 0) return ShowPlayerDialog(playerid, DIALOG_CHECKPOINT, DIALOG_STYLE_MSGBOX, "Checkpoint", "Ai deja un checkpoint activ.\nDoresti sa-l anulezi? Daca da, apasa pe 'Ok'.", "Ok", "Exit");
    	          	CP[playerid] = 53;
    				SCM(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid, -1017.3097,-638.8459,32.0078, 7.0);
    				return 1;
    		    }
    	    }
    	    case 3: {
    	        if(PlayerToPoint(7.0, playerid, -1966.2852,-2442.2708,30.6250)) {
    				if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de condus pentru a putea munci la acest job!");
    				format(string, sizeof(string), "Du-te la un copac din apropiere si foloseste tasta ~b~~h~LALT~w~~h~ pentru a-l taia.");
    				PlayerTextDrawSetString(playerid, InfosTD, string);
    				SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    				PlayerTextDrawShow(playerid, InfosTD);	
    				CarAngle = 222.7997;			}
    	        else {
     				if(CP[playerid] != 0) return ShowPlayerDialog(playerid, DIALOG_CHECKPOINT, DIALOG_STYLE_MSGBOX, "Checkpoint", "Ai deja un checkpoint activ.\nDoresti sa-l anulezi? Daca da, apasa pe 'Ok'.", "Ok", "Exit");
    	          	CP[playerid] = 53;
    				SCM(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid, -1966.2852,-2442.2708,30.6250, 7.0);
    				return 1;
    		    }		
    		}
    	    case 4: {
    			if(GetPlayerSkill(playerid) == 1) PlayerTextDrawSetString(playerid, InfosTD, "~y~Car Jacker~w~~h~~n~Fura un vehicul public!");
    			else if(GetPlayerSkill(playerid) == 2) PlayerTextDrawSetString(playerid, InfosTD, "~y~Car Jacker~w~~h~~n~Fura un vehicul personal descuiat!");
    			else if(GetPlayerSkill(playerid) == 3) PlayerTextDrawSetString(playerid, InfosTD, "~y~Car Jacker~w~~h~~n~Fura un vehicul ce apartine unei mafii!");
    			else if(GetPlayerSkill(playerid) == 4) PlayerTextDrawSetString(playerid, InfosTD, "~y~Car Jacker~w~~h~~n~Fura un vehicul personal incuiat!");
    			else if(GetPlayerSkill(playerid) == 5) PlayerTextDrawSetString(playerid, InfosTD, "~y~Car Jacker~w~~h~~n~Fura un vehicul ce apartine unui departament de politie!");
    			PlayerTextDrawShow(playerid, InfosTD);
    			JobWorking[playerid] = 1;
    			SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    			return 1;
    	    }
    		case 5: {
    			if(PlayerInfo[playerid][pWantedLevel] != 0) return SCM(playerid, -1, "Nu poti munci la acest job deoarece ai wanted!");
    			if(!PlayerToPoint(10.0, playerid, 2770.2822,-1610.9043,11.0418)) {				
    				SCM(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid, 2770.2822,-1610.9043,11.0418, 10.0);
    				CP[playerid] = 53;
    				return 1;
    			}
    			if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de condus pentru a putea munci la acest job!");
    			CP[playerid] = 156;
    			new rand = random(3);			
    			switch(rand) {
    				case 0: SetPlayerCheckpointEx(playerid, 2790.6213,-2523.6418,13.6704, 5.0);
    				case 1: SetPlayerCheckpointEx(playerid, 2529.4214,-2009.4240,13.5798, 5.0);
    				case 2: SetPlayerCheckpointEx(playerid, 2180.0774,-2317.1672,13.5703, 5.0); 
    				case 3: SetPlayerCheckpointEx(playerid, 681.2267,-442.6591,16.3633, 5.0);
    			}
    			
    			format(string, sizeof(string), "Du-te la checkpoint-ul de pe mapa pentru a livra materialele!");
    			PlayerTextDrawSetString(playerid, InfosTD, string);
    			SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    			PlayerTextDrawShow(playerid, InfosTD);
    			
    			CarAngle = 277.2561;
    			StartingWork[playerid] = 0;
    			CurseFacute[playerid] = 0;
    			MoneyEarned[playerid] = 0;		
    		}
    	    case 6..8: return 1;
    	    case 9: {
    	        if(PlayerToPoint(7.0, playerid, 2113.9392,-1775.1980,13.3918)) {
    				if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de condus pentru a putea munci la acest job!");
                    CarAngle = 0;
                    CP[playerid] = 155;
    				new j = random(housess)+1;
    				if(j == 0) j = 1;
    				SetPlayerCheckpointEx(playerid, HouseInfo[j][hEntrancex],HouseInfo[j][hEntrancey],HouseInfo[j][hEntrancez], 7.0);
    				format(string, sizeof(string), "Du-te la punctul ~r~~h~rosu~w~~h~ de pe mapa pentru a livra pizza.~n~Distanta: ~y~%0.1fm.", GetPlayerDistanceFromPoint(playerid, HouseInfo[j][hEntrancex],HouseInfo[j][hEntrancey],HouseInfo[j][hEntrancez]));
    				PlayerTextDrawSetString(playerid, InfosTD, string);
    				SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    				PlayerTextDrawShow(playerid, InfosTD);				
    			}
    	        else {
     				if(CP[playerid] != 0) return ShowPlayerDialog(playerid, DIALOG_CHECKPOINT, DIALOG_STYLE_MSGBOX, "Checkpoint", "Ai deja un checkpoint activ.\nDoresti sa-l anulezi? Daca da, apasa pe 'Ok'.", "Ok", "Exit");
    	          	CP[playerid] = 53;
    				SCM(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid,2113.9392,-1775.1980,13.3918, 7.0);
    				return 1;
    		    }
    	    }	
    		case 10: {
    			if(!PlayerToPoint(6.0, playerid, 844.6592,-601.3264,18.4219)) {
    				SCM(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid, 844.6592,-601.3264,18.4219, 6.0);
    				CP[playerid] = 53;
    				return 1;
    			}
    			if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de condus pentru a putea munci la acest job!");
    			CarAngle = 0.7028;
    			CP[playerid] = 57;
    			
    			new rand = random(3);
    			if(rand == 1) SetPlayerCheckpointEx(playerid, 830.0479, -611.8955, 16.3432, 5.0);
    			else if(rand == 2) SetPlayerCheckpointEx(playerid, 820.7677, -612.4786, 16.3432, 5.0);
    			else if(rand == 3) SetPlayerCheckpointEx(playerid, 790.9538, -612.2801, 16.3432, 5.0);
    			else SetPlayerCheckpointEx(playerid, 830.0479, -611.8955, 16.3432, 5.0);
    			
    			PlayerTextDrawSetString(playerid, InfosTD, "Du-te la punctul ~r~rosu~w~~h~ pentru a incarca coletele!");
    			SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    			PlayerTextDrawShow(playerid, InfosTD);	
    		}		
    		case 12: {
    			if(!PlayerToPoint(20.0, playerid, 1947.3197,-2387.1599,13.5469)) {
    				SCM(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid, 1947.3197,-2387.1599,13.5469, 20.0);
    				CP[playerid] = 53;
    				return 1;
    			}
    			if(PlayerInfo[playerid][pFlyLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de zbor pentru a putea munci la acest job!");
    			if(PlayerInfo[playerid][pWantedLevel] != 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Nu poti munci la acest job deoarece ai wanted!");			
    			CP[playerid] = 159;
    			SetPlayerRaceCheckpointEx(playerid, 3, 1897.3568,-2493.9583,14.4609,1337.7225,-2458.1738,52.1955, 5.0);
    			CarAngle = 90.6909;
    			StartingWork[playerid] = 0;
    			CurseFacute[playerid] = 0;
    			MoneyEarned[playerid] = 0;		
    		}
    		case 13: {
    			if(!PlayerToPoint(7.0, playerid, 2173.3965,-2265.2837,13.3579)) {
    				SCM(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid, 2173.3965,-2265.2837,13.3579, 7.0);
    				CP[playerid] = 53;
    				return 1;
    			}	
    			if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de condus pentru a putea munci la acest job!");
    			PlayerTextDrawSetString(playerid, InfosTD, "Du-te la ~r~~h~checkpoint-ul~w~~h~ de pe mapa pentru a lua marfa!");
    			SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    			PlayerTextDrawShow(playerid, InfosTD);			
    			new rand = random(2);
    			DisablePlayerCheckpointEx(playerid);
    			switch(rand) {
    				case 0: {
    					playerObject[playerid] = CreatePlayerObject(playerid, 1271, 2214.87109, -2287.46167, 14.06371,   0.00000, 0.00000, 45.00000);
    					SetPlayerCheckpointEx(playerid, 2214.87109, -2287.46167, 14.06371, 2.0);			
    				}
    				case 1: {
    					playerObject[playerid] = CreatePlayerObject(playerid, 1271, 2237.34399, -2294.11938, 14.08454,   0.00000, 0.00000, 45.00000);
    					SetPlayerCheckpointEx(playerid, 2237.34399, -2294.11938, 14.08454, 2.0);
    				}
    				case 2: {
    					playerObject[playerid] = CreatePlayerObject(playerid, 1271, 2216.74878, -2210.50146, 12.86219,   0.00000, 0.00000, 45.00000);	
    					SetPlayerCheckpointEx(playerid, 2216.74878, -2210.50146, 12.86219, 2.0);
    				}
    			}
    			CP[playerid] = 170;
    			UpdateJobStats(playerid);
    		}
    		case 14: {
    			if(!PlayerToPoint(7.0, playerid, 841.5203,854.4805,12.9194)) {
    				if(IsPlayerInAnyVehicle(playerid)) return SendClientMessage(playerid, -1, "Nu poti folosi aceasta comanda atata timp cat esti intr-un vehicul!");
    				if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de conducere pentru a putea munci la acest job!");
    				SendClientMessage(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid, 841.5203,854.4805,12.9194, 7.0);
    				CP[playerid] = 53;
    				return 1;
    			}
    			CP[playerid] = 408;
    			SetPlayerCheckpointEx(playerid, 544.6709,909.9449,-41.5904, 2.0);
    			PlayerTextDrawSetString(playerid, InfosTD, "Du-te la ~r~~h~checkpoint-urile~w~~h~ de pe minimap pentru a incarca ~n~excavatorul cu bolovani!");
    			SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    			PlayerTextDrawShow(playerid, InfosTD);
    		}
    		case 15: {
    			if(!PlayerToPoint(7.0, playerid, 935.1089,-1119.8901,24.0393)) {
    				if(IsPlayerInAnyVehicle(playerid)) return SendClientMessage(playerid, -1, "Nu poti folosi aceasta comanda atata timp cat esti intr-un vehicul!");
    				if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de conducere pentru a putea munci la acest job!");
    				SendClientMessage(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SetPlayerCheckpointEx(playerid, 935.1089,-1119.8901,24.0393, 7.0);
    				CP[playerid] = 53;
    				return 1;
    			}
    			CP[playerid] = 500;
    			SetPlayerCheckpointEx(playerid, 1288.5790,-1080.4321,25.8558, 2.0);
    			PlayerTextDrawSetString(playerid, InfosTD, "Urmareste ~r~~h~puncte-le~w~~h~ de pe minimap pentru a ajunge la ~n~Casele de unde trebuie sa iei mortii!");
    			SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    			PlayerTextDrawShow(playerid, InfosTD);
    		}
    		case 16: {
    			if(!PlayerToPoint(7.0, playerid, 1103.4166,-1655.3750,10.3646)) {
    				if(IsPlayerInAnyVehicle(playerid)) return SendClientMessage(playerid, -1, "Nu poti folosi aceasta comanda atata timp cat esti intr-un vehicul!");
    				//if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de conducere pentru a putea munci la acest job!");
    				SendClientMessage(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SendClientMessage(playerid, COLOR_GREY, "Intra in stadion pentru a incepe Antrenamentele!");
    				SetPlayerCheckpointEx(playerid, 1103.4166,-1655.3750,10.3646, 4.0);
    				CP[playerid] = 53;
    				return 1;
    			}
    			CP[playerid] = 600;
    			SetPlayerCheckpointEx(playerid, 1082.3163,-1666.6954,10.3646, 1.0);
    			PlayerTextDrawSetString(playerid, InfosTD, "Urmareste ~r~~h~puncte-le~w~~h~ de pe minimap pentru a termina ~n~Antrenamentele cu nota 10!");
    			SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    			PlayerTextDrawShow(playerid, InfosTD);
    		}	
    	}
    	SetPVarInt(playerid, "Pressed", 0);
    	SetPVarInt(playerid, "Trees", 0);
    	SetPVarInt(playerid, "JobStep", 0);				
    	SetPVarInt(playerid, "InHand", 0);				
    	
        MoneyEarned[playerid] = 0;
    	CurseFacute[playerid] = 0;
    	if(PlayerInfo[playerid][pShowJob] == 0 && PlayerInfo[playerid][pJob] != 5 && PlayerInfo[playerid][pLevel] < 3) SCM(playerid, COLOR_YELLOW, "Daca doresti sa vezi mai multe informatii folositoare de la job, o poti face prin comanda (/hud > Informatii job).");
    	new skill = GetPlayerSkill(playerid);
    	if(PlayerInfo[playerid][pJob] == 11) {
    		new rand = 1 + random(5);		
    		if(rand == 1) { Pos[0] = 877.5832; Pos[1] = -2126.4685; Pos[2] = 0.3231; CarAngle = -89.2800; }
    		if(rand == 2) { Pos[0] = 877.3463; Pos[1] = -2113.4219; Pos[2] = 0.3231; CarAngle = -89.2800; }
    		if(rand == 3) { Pos[0] = 796.3821; Pos[1] = -2114.0200; Pos[2] = -0.0049; CarAngle = 89.7000; }
    		if(rand == 4) { Pos[0] = 796.9351; Pos[1] = -2127.4446; Pos[2] = -0.0049; CarAngle = 89.7000; }
    		if(rand == 5) { Pos[0] = 796.1244; Pos[1] = -2100.6455; Pos[2] = -0.0049; CarAngle = 89.7000; }
    		if(rand == 6) { Pos[0] = 797.0450; Pos[1] = -2139.8650; Pos[2] = -0.0049; CarAngle = 89.7000; }
    	}
    	if(PlayerInfo[playerid][pJob] == 12) {
    		if(skill == 1) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill1Veh], 1982.5657,-2493.7964,14.4719, CarAngle, -1, -1, -1);
    		else if(skill == 2) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill2Veh], 1982.5657,-2493.7964,14.4719, CarAngle, -1, -1, -1);
    		else if(skill == 3) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill3Veh], 1982.5657,-2493.7964,14.4719, CarAngle, -1, -1, -1);
    		else if(skill == 4) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill4Veh], 1982.5657,-2493.7964,14.4719, CarAngle, -1, -1, -1);
    		else if(skill == 5) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill5Veh], 1982.5657,-2493.7964,14.4719, CarAngle, -1, -1, -1);	
    	}
    	else {
    		if(PlayerInfo[playerid][pJob] == 3) {
    			if(skill == 1) JobVehicle[playerid] = CreateVehicleEx(578, Pos[0], Pos[1], Pos[2], CarAngle, random(240), random(240), -1);
    			else if(skill == 2) JobVehicle[playerid] = CreateVehicleEx(578, Pos[0], Pos[1], Pos[2], CarAngle, random(240), random(240), -1);
    			else if(skill == 3) JobVehicle[playerid] = CreateVehicleEx(578, Pos[0], Pos[1], Pos[2], CarAngle, random(240), random(240), -1);
    			else if(skill == 4) JobVehicle[playerid] = CreateVehicleEx(578, Pos[0], Pos[1], Pos[2], CarAngle, random(240), random(240), -1);
    			else if(skill == 5) JobVehicle[playerid] = CreateVehicleEx(578, Pos[0], Pos[1], Pos[2], CarAngle, random(240), random(240), -1);		
    		}
    		else {
    			if(skill == 1) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill1Veh], Pos[0], Pos[1], Pos[2], CarAngle, -1, -1, -1);
    			else if(skill == 2) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill2Veh], Pos[0], Pos[1], Pos[2], CarAngle, -1, -1, -1);
    			else if(skill == 3) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill3Veh], Pos[0], Pos[1], Pos[2], CarAngle, -1, -1, -1);
    			else if(skill == 4) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill4Veh], Pos[0], Pos[1], Pos[2], CarAngle, -1, -1, -1);
    			else if(skill == 5) JobVehicle[playerid] = CreateVehicleEx(JobInfo[PlayerInfo[playerid][pJob]][jSkill5Veh], Pos[0], Pos[1], Pos[2], CarAngle, -1, -1, -1);
    		}	
    	}	
        PutPlayerInVehicleEx(playerid, JobVehicle[playerid], 0);
        JobWorking[playerid] = 1;
    	if(PlayerInfo[playerid][pJob] != 2) UpdateJobStats(playerid);
        Gas[JobVehicle[playerid]] = 100;
    	WorkingTime[playerid] = 0;
     	if(PlayerInfo[playerid][pJob] == 11) DisableRemoteVehicleCollisions(playerid, 1);
    	SetPlayerVirtualWorld(playerid, 0);
    
    	new engine,lights,alarm,doors,bonnet,boot,objective;
    	vehEngine[JobVehicle[playerid]] = 1;
    	GetVehicleParamsEx(JobVehicle[playerid],engine,lights,alarm,doors,bonnet,boot,objective);
    	SetVehicleParamsEx(JobVehicle[playerid],VEHICLE_PARAMS_ON,lights,alarm,doors,bonnet,boot,objective);	
    	return 1;
    }

    Asta este toata comanda eu la acest gamemode am comanda /editjob de unde setez masinile la fiecare job.

    Doar ca eu la job-ul case 16 nu folosesc masina si am setat in baza de date la veh 0.

    Si imi da aceasta problema din cauza la acest job.

    Daca scot case 16 de la /startwork nu mai am nici o eroare daca folosesc /startwork. :(

    Si nu gasesc nici o rezolvare.

  6. Acum 5 ore, CTMBeast a spus:

    Niste sfaturi:

    • Nu face 2 query-uri pentru a schimba 2 valori

    Si vezi ca nu ai facut sa se salveze timpul in baza de date.

     

    Acum 7 ore, iSkull a spus:
    
    	SCM(i, COLOR_WHITE, "Salariul tau a sosit! Viziteaza banca pentru a retrage banii.");            
    format(string, sizeof(string), "Ai primit %0.2f ore jucate. (%.0f minute)", PlayerInfo[i][pSeconds]/3600, PlayerInfo[i][pSeconds]/60);
    SCM(i, COLOR_WHITE, string);
    PlayerInfo[i][pConnectTime] += PlayerInfo[i][pSeconds]/3600;
    new query[110];
    mysql_format(SQL, query, sizeof(query), "UPDATE `users` SET `ConnectTime` = '%.3f' WHERE `ID` = '%d'", PlayerInfo[i][pSQLID]);
    mysql_tquery(SQL, query, "", "");
    if(PlayerInfo[i][pSeconds] >= 1800)
    {
        mysql_format(SQL, query, sizeof(query), "UPDATE `users` SET `DayHours`=`DayHours`+1, `HoursMonth`=`HoursMonth`+1 WHERE `ID`='%d'", PlayerInfo[i][pSQLID]);
        mysql_tquery(SQL, query, "", "");
    }
    	

    Faci poza la PayDay cand iti spune cate ore, etc. daca mai ai probleme

    Unde vezi ca nu ti se salveaza in DB verifica peste tot ce trimite update-uri catre DB de tip "mysql_query" si le modifici in "mysql_tquery", cum ti'am pus eu mai sus.

    In baza de date am pConnectTimex si pSecundex 

    Skull o sa pun aceste modificari date de tine acu si o sa revin pe zi cu problema de ore ce acu nu prea mai este nimeni pe sv.

    @iSkull

    Am adaugat ce mi-ai spus si primesc in mysql_log asta acu

    [08:00:02] [ERROR] mysql_format - no value for specifier "%d" available
    [08:00:02] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'ConnectTime' in 'field list'

     

  7. Buna seara.

    Am facut si eu un job si am urmatoarea problema . Job-ul acesta nu foloseste masina/masini folosesc gm-ul lui edison burned.

    Si am urmatoarea eroare in consola de la servar

    http://prntscr.com/m5l09m

    Si asta este ce-a ce am adaugat eu pentru job-ul meu 

    case 16: {
    			if(!PlayerToPoint(7.0, playerid, 1103.4166,-1655.3750,10.3646)) {
    				if(IsPlayerInAnyVehicle(playerid)) return SendClientMessage(playerid, -1, "Nu poti folosi aceasta comanda atata timp cat esti intr-un vehicul!");
    				//if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de conducere pentru a putea munci la acest job!");
    				SendClientMessage(playerid, COLOR_GREY, "Nu esti la locul unde poti incepe munca. Ti-am pus un checkpoint, du-te la el!");
    				SendClientMessage(playerid, COLOR_GREY, "Intra in stadion pentru a incepe Antrenamentele!");
    				SetPlayerCheckpointEx(playerid, 1103.4166,-1655.3750,10.3646, 4.0);
    				CP[playerid] = 53;
    				return 1;
    			}
    			CP[playerid] = 600;
    			SetPlayerCheckpointEx(playerid, 1082.3163,-1666.6954,10.3646, 1.0);
    			PlayerTextDrawSetString(playerid, InfosTD, "Urmareste ~r~~h~puncte-le~w~~h~ de pe minimap pentru a termina ~n~Antrenamentele cu nota 10!");
    			SetTimerEx("HideTextdraw", 8000, 0, "%d", playerid);
    			PlayerTextDrawShow(playerid, InfosTD);
    		}	

    Si nu gasesc nici o rezolvare . :((

  8. Acum 7 ore, iSkull a spus:

    Arata tot ce tine de "pConnectTime" si "pSeconds" inclusiv din enum.

    enum pInfo {
    	Float: pConnectTime, Float: pSeconds;
    
    cmds
    	else if(strcmp(item, "hours", true) == 0) {
    		if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pConnectTime] = valoare;
    		format(query, sizeof(query), "UPDATE `users` SET `ConnectedTime`='%0.3f' WHERE `name`='%s'", valoare, id);
    		mysql_query(SQL, query);
    		Update(playerid, pConnectTimex);	
    	}
    
    function UpdateSecondary(playerid) {
        if(IsPlayerLogged[playerid] != 0) {
    		Update(playerid, pConnectTimex);
    		Update(playerid, pBank);
    		Update(playerid, pCashx);
    		Update(playerid, pRP);
    		Update(playerid, pPayDayx);
    		Update(playerid, pJailTimex);
    		OnPlayerDateUpdateX2(playerid);
    	}
    	return 1;
    }
    
    if(PlayerInfo[i][pSleeping] == 0 && Spectate[i] == 255 && AFKSeconds[i] < 15) PlayerInfo[i][pSeconds] ++;
                                                                                 
                    PlayerInfo[i][pSeconds] = 0;
    				
    				if(PlayerInfo[i][pDailyLogin] == 0) {
    					PlayerInfo[i][pDailyLogin] = 1;
    					UpdateVar(i, "DailyLogin", 1);
    					SCM(i, COLOR_LIGHTBLUE, "Ai primit de doua ori mai multe respect points si bani pentru primul tau payday de astazi.");
    				}
    PlayerInfo[playerid][pSeconds] = cache_get_field_content_float(0, "Seconds");
                                                                                 
                                                                                 
                                                                                 

    cam asta am gasit .

  9. Buna ziua am si urmatoarea problema.

    La fiecare pay day in loc sa`i dea nush o ora jucata ii ia din ore.

    Si nu se salveaza in baza de date chiar nu inteleg de la ce este chestia asta.

    Folosesc gamemode-ul burned.

    SCM(i, COLOR_WHITE, "Salariul tau a sosit! Viziteaza banca pentru a retrage banii.");			
    				format(string, sizeof(string), "Ai primit %0.2f ore jucate. (%.0f minute)", PlayerInfo[i][pSeconds]/3600, PlayerInfo[i][pSeconds]/60);
    				SCM(i, COLOR_WHITE, string);
    				PlayerInfo[i][pConnectTime] += PlayerInfo[i][pSeconds]/3600;
    				if(PlayerInfo[i][pSeconds] >= 1800) {
    					new query[180];
    					format(query, sizeof(query), "UPDATE `users` SET `DayHours`=`DayHours`+1 WHERE `ID`='%d'", PlayerInfo[i][pSQLID]);
    					mysql_query(SQL, query);
    					format(query, sizeof(query), "UPDATE `users` SET `HoursMonth`=`HoursMonth`+1 WHERE `ID`='%d'", PlayerInfo[i][pSQLID]);
    					mysql_query(SQL, query);

     

  10. La 07.01.2019 la 16:44, CTMBeast a spus:

    Verifica coordonatele de unde iti da eroarea.

     

    Edit: Acestea sunt coordonatele de la paint 

    
    1310.1653, -1367.5322, 13.5082

    Salut CTM da astea sunt cordonatele si de la paint.

    Am rezolvat prin modificarea cordonatelor .

    Pwp dulke

     

    • Thanks 1
  11. 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

  12. 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')

     

  13. Buna ziua .

    Am si eu urmatoarea problema, ma aflu la arena de paint dau /enter si imi zice urmoarea

    eroare ca nu sunt langa arena de paint.

    G5O6oPv.jpg

    Comanda este asta 

    YCMD:enter(playerid, params[], help) {
        for(new i = 1; i < sizeof(BizzInfo); i++) {
    	    if(IsPlayerInRangeOfPoint(playerid,2,BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]) && BizzInfo[i][bStatic] == 1) {
    		   if(InWar[PlayerInfo[playerid][pMember]] == 1) return SCM(playerid, COLOR_LGREEN, "Eroare: Nu poti intra intr-o afacere in timpul war-ului!");
    		   if(GetPlayerCash(playerid) < BizzInfo[i][bFee]) return GameTextForPlayer(playerid, "~r~~h~Nu ai destui bani", 1000, 1);
    		   if(OnDuty[playerid] == 1 || PlayerHit[playerid] != -1) { }
    		   else if(BizzInfo[i][bLocked] == 1) return GameTextForPlayer(playerid, "~r~~h~Inchis", 1000, 1);
    		   if(i == 17) {
    				if(OnDuty[playerid] == 1) return SCM(playerid, COLOR_WHITE, "Esti la datorie, nu poti intra.");
    				if(InGame[playerid] == 1) return 1;
    				if(PlayerInfo[playerid][pWantedLevel] > 0) return SCM(playerid, -1, "Ai wanted, nu poti intra!");
    				if(PlayerInfo[playerid][pConnectTime] < 5) return SCM(playerid, COLOR_LGREEN, "Ai nevoie de 5 ore jucate pentru a putea intra in paintball!");
    				if(PlayerInfo[playerid][pGunLic] == 0) return SCM(playerid, COLOR_LGREEN, "Ai nevoie de o licenta de arme pentru a putea intra in paintball!");			
    				EnterGame(playerid);
    		   }
    		   else if(i == 20) {
    				if(OnDuty[playerid] == 1) return SCM(playerid, COLOR_WHITE, "Esti la datorie, nu poti intra.");
    				if(!PlayerToPoint(5.0, playerid, 1310.1653, -1367.5322, 13.5082)) return SCM(playerid, COLOR_GREY, "Nu esti la paintball. Foloseste /gps pentru a vedea unde este.");
    				if(PlayerInfo[playerid][pWantedLevel] > 0) return SCM(playerid, -1, "Ai wanted, nu poti intra!");
    				if(PlayerInfo[playerid][pConnectTime] < 5) return SCM(playerid, COLOR_LGREEN, "Ai nevoie de 5 ore jucate pentru a putea intra in paintball!");
    				if(PlayerInfo[playerid][pGunLic] == 0) return SCM(playerid, COLOR_LGREEN, "Ai nevoie de o licenta de arme pentru a putea intra in arena CS!");
    				new szDialog[1024], szDialog2[1024];
    				strcat(szDialog2, "Mod\tJucatori\tMapa\tStatus\n");
    				if(PaintTime[0] > 0) format(szDialog, 1024, "Clasic\t%d jucatori\t%s\t{FFE203}In desfasurare (%s)\n", PlayersOnPaint(0), MapName(0), CalculeazaTimp2(PaintTime[0]));
    				else format(szDialog, 1024, "Clasic\t%d jucatori\t%s\t{2BAD2B}In asteptare...\n", PlayersOnPaint(0), MapName(0));
    				strcat(szDialog2, szDialog);
    				if(PaintTime[1] > 0) format(szDialog, 1024, "Clasic cu armura\t%d jucatori\t%s\t{FFE203}In desfasurare (%s)\n", PlayersOnPaint(1), MapName(1), CalculeazaTimp2(PaintTime[1]));
    				else format(szDialog, 1024, "Clasic cu armura\t%d jucatori\t%s\t{2BAD2B}In asteptare...\n", PlayersOnPaint(1), MapName(1));
    				strcat(szDialog2, szDialog);
    				if(PaintTime[2] > 0) format(szDialog, 1024, "Gun Game\t%d jucatori\t%s\t{FFE203}In desfasurare (%s)\n", PlayersOnPaint(2), MapName(2), CalculeazaTimp2(PaintTime[2]));
    				else format(szDialog, 1024, "Gun Game\t%d jucatori\t%s\t{2BAD2B}In asteptare...\n", PlayersOnPaint(2), MapName(2));
    				strcat(szDialog2, szDialog);
    				ShowPlayerDialog(playerid, DIALOG_MODE, DIALOG_STYLE_TABLIST_HEADERS, "Paintball:", szDialog2, "Ok", "Exit");								
    		   } 
    		   else if(i == 22) {
    				if(OnDuty[playerid] == 1) return SCM(playerid, COLOR_WHITE, "Esti la datorie, nu poti intra.");
    				if(PlayersInRace() == 20) return SCM(playerid, COLOR_LGREEN, "Nu se mai poate intra acum in arena de curse deoarece este plina!");
    				if(RaceStarted == 1) return SCM(playerid, COLOR_LGREEN, "Nu se mai poate intra acum deoarece este o cursa pornita!");
    				if(PlayerInfo[playerid][pCarLic] == 0) return SCM(playerid, COLOR_LGREEN, "Eroare: Ai nevoie de o licenta de condus pentru a participa la o cursa!");
    				if(CP[playerid] != 0 || targetfind[playerid] != -1) return ShowPlayerDialog(playerid, DIALOG_CHECKPOINT, DIALOG_STYLE_MSGBOX, "Checkpoint", "Ai deja un checkpoint activ.\nDoresti sa-l anulezi? Daca da, apasa pe 'Ok'.", "Ok", "Exit");
    				EnterRaceArena(playerid);								
    		   }
    		   else return 1;
    		   new str1[64];
    		   format(str1, sizeof(str1), "~r~-$%d", BizzInfo[i][bFee]);		   
    		   GameTextForPlayer(playerid, str1, 1000, 1);	
    		   GivePlayerCash(playerid,-BizzInfo[i][bFee]);
    		   BizzInfo[i][bBalance] += BizzInfo[i][bFee];	
    		   new query[128];
    		   format(query,sizeof(query),"UPDATE `bizz` SET `Till`='%d' WHERE `ID`='%d'", BizzInfo[i][bBalance], i);
    		   mysql_query(SQL,query);		   
    		}			   
    	}				   
    	return 1;
    }

    Am cautat acel text in gm si in folder-ul sistems.inc dar nu l-am gasit nici sa mor 

    Folosesc gamemode-ul @SkillZ_IT.

  14. 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

  15. 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')

     

×
×
  • 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.