Problema Baza de date

andrein2 · July 18, 2013

Deci cand un player cumpara o masina de la dealer sau una facuta de mine cu /vcreate se salveaza in baza de date dar cand se deschide server-ul nu le incarca ce pot face?

   			if(GetVehicleModel(GetPlayerVehicleID(playerid)) == 0)
				{
				    if(UsingDealership[playerid] == 1)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}A aparut o mica problema, te rog incearca din nou.");
			         	SetPlayerPos(playerid, 2131.8369,-1150.5486,24.1454);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
					if(UsingDealership[playerid] == 2)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}A aparut o mica problema, te rog incearca din nou.");
			         	SetPlayerPos(playerid, 1410.9225,-1701.1395,13.5395);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
     				if(UsingDealership[playerid] == 3)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}A aparut o mica problema, te rog incearca din nou.");
			         	SetPlayerPos(playerid, 2751.8899,-1468.2407,30.4531);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
     				if(UsingDealership[playerid] == 4)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}A aparut o mica problema, te rog incearca din nou.");
			         	SetPlayerPos(playerid, 370.9933,-2052.3145,8.0156);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
     				if(UsingDealership[playerid] == 5)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}A aparut o mica problema, te rog incearca din nou.");
			         	SetPlayerPos(playerid, 1606.3135,-2432.6738,13.5547);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
     				if(UsingDealership[playerid] == 6)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}A aparut o mica problema, te rog incearca din nou.");
			         	SetPlayerPos(playerid, 1948.2946,2068.7778,11.0610);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
					return 1;
				}
    			if(vehSlots[GetVehicleModel(GetPlayerVehicleID(playerid))] == 0)
				{
				    if(UsingDealership[playerid] == 1)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu mai sunt modele disponibile!");
			         	SetPlayerPos(playerid, 2131.8369,-1150.5486,24.1454);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
					if(UsingDealership[playerid] == 2)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu mai sunt modele disponibile!");
			         	SetPlayerPos(playerid, 1410.9225,-1701.1395,13.5395);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
     				if(UsingDealership[playerid] == 3)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu mai sunt modele disponibile!");
			         	SetPlayerPos(playerid, 2751.8899,-1468.2407,30.4531);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
     				if(UsingDealership[playerid] == 4)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu mai sunt modele disponibile!");
			         	SetPlayerPos(playerid, 370.9933,-2052.3145,8.0156);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
     				if(UsingDealership[playerid] == 5)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu mai sunt modele disponibile!");
			         	SetPlayerPos(playerid, 1606.3135,-2432.6738,13.5547);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
					if(UsingDealership[playerid] == 6)
			        {
				        SendClientMessage(playerid, COLOR_WHITE, " ");
				        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu mai sunt modele disponibile!");
			         	SetPlayerPos(playerid, 1948.2946,2068.7778,11.0610);
					    SetPlayerInterior(playerid, 0);
					    SetPlayerVirtualWorld(playerid, 0);
						VehPosition[playerid] = 0;
						SetCameraBehindPlayer(playerid);
						UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
						TogglePlayerControllable(playerid, 1);
					}
					return 1;
				}
		        GetPlayerName(playerid, sendername, sizeof(sendername));

				new
			    	Float:Pos[4];
			    	//ivModel,
			    	//ivPrice,
			    	//ivColors[2];

	            if(UsingDealership[playerid] == 1)
	            {
					Pos[0] = 2136.1687;
					Pos[1] = -1122.1735;
					Pos[2] = 25.0514;
					Pos[3] = 82.8414;
				    //format(string, sizeof(string), "Random a fost: %d", rand);
				    //SendClientMessage(playerid, COLOR_WHITE, string);
				}
    			if(UsingDealership[playerid] == 2)
	            {
					new rand = random(6);
        			if(rand == 1)
					{
				    	Pos[0] = 1413.3575;
				    	Pos[1] = -1709.1583;
				    	Pos[2] = 13.1213;
				    	Pos[3] = 271.4538;
				    }
        			else if(rand == 3)
					{
				    	Pos[0] = 1413.2527;
				    	Pos[1] = -1711.6610;
				    	Pos[2] = 13.1199;
				    	Pos[3] = 269.4991;
				    }
        			else if(rand == 4)
					{
				    	Pos[0] = 1413.1649;
				    	Pos[1] = -1714.1013;
				    	Pos[2] = 13.1172;
				    	Pos[3] = 262.5687;
				    }
        			else if(rand == 5)
					{
				    	Pos[0] = 1413.0980;
				    	Pos[1] = -1716.5648;
				    	Pos[2] = 13.1171;
				    	Pos[3] = 259.6882;
				    }
        			else
				    {
				    	Pos[0] = 1413.0980;
				    	Pos[1] = -1716.5648;
				    	Pos[2] = 13.1171;
				    	Pos[3] = 259.6882;
				    }
				}
    			if(UsingDealership[playerid] == 3)
	            {
					new rand = random(4);
        			if(rand == 1)
					{
				    	Pos[0] = 2743.3462;
				    	Pos[1] = -1454.5294;
				    	Pos[2] = 30.2013;
				    	Pos[3] = 1.2237;
				    }
        			else if(rand == 2)
					{
				    	Pos[0] = 2743.1753;
				    	Pos[1] = -1469.1836;
				    	Pos[2] = 30.1995;
				    	Pos[3] = 358.8545;
				    }
        			else if(rand == 3)
					{
				    	Pos[0] = 2743.4299;
				    	Pos[1] = -1433.9531;
				    	Pos[2] = 30.1970;
				    	Pos[3] = 179.5753;
				    }
        			else if(rand == 4)
					{
				    	Pos[0] = 2750.6560;
				    	Pos[1] = -1481.0592;
				    	Pos[2] = 30.0233;
				    	Pos[3] = 89.6613;
				    }
        			else
				    {
				    	Pos[0] = 2750.6560;
				    	Pos[1] = -1481.0592;
				    	Pos[2] = 30.0233;
				    	Pos[3] = 89.6613;
				    }
				}
    			if(UsingDealership[playerid] == 4)
	            {
					new rand = random(6);
        			if(rand == 1)
					{
				    	Pos[0] = 733.4745;
				    	Pos[1] = -1827.5787;
				    	Pos[2] = 0.3570;
				    	Pos[3] = 172.1759;
				    }
        			else if(rand == 2)
					{
				    	Pos[0] = 730.9171;
				    	Pos[1] = -1862.3824;
				    	Pos[2] = 0.0361;
				    	Pos[3] = 176.2033;
				    }
        			else if(rand == 3)
					{
				    	Pos[0] = 732.5975;
				    	Pos[1] = -1906.4794;
				    	Pos[2] = -0.0135;
				    	Pos[3] = 172.9082;
				    }
        			else if(rand == 4)
					{
				    	Pos[0] = 714.7449;
				    	Pos[1] = -1827.7794;
				    	Pos[2] = 0.2248;
				    	Pos[3] = 182.2101;
				    }
        			else if(rand == 5)
				    {
				    	Pos[0] = 715.4791;
				    	Pos[1] = -1855.4669;
				    	Pos[2] = 0.0197;
				    	Pos[3] = 180.5847;
				    }
        			else
				    {
				    	Pos[0] = 716.4482;
				    	Pos[1] = -1900.6501;
				    	Pos[2] = 0.2793;
				    	Pos[3] = 180.7001;
				    }
				}
    			if(UsingDealership[playerid] == 5)
	            {
					new rand = random(2);
        			if(rand == 0)
					{
				    	Pos[0] = 1459.8523;
				    	Pos[1] = -2601.0217;
				    	Pos[2] = 14.2718;
				    	Pos[3] = 269.6978;
				    }
        			else if(rand == 1)
					{
				    	Pos[0] = 1460.0812;
				    	Pos[1] = -2585.5745;
				    	Pos[2] = 14.0053;
				    	Pos[3] = 269.4033;
				    }
        			else
				    {
				    	Pos[0] = 1460.0812;
				    	Pos[1] = -2585.5745;
				    	Pos[2] = 14.0053;
				    	Pos[3] = 269.4033;
				    }
				}
    			if(UsingDealership[playerid] == 6)
	            {
					new rand = random(4);
        			if(rand == 0)
					{
				    	Pos[0] = 1945.7083;
				    	Pos[1] = 2042.2096;
				    	Pos[2] = 10.4418;
				    	Pos[3] = 359.9365;
				    }
        			else if(rand == 1)
					{
				    	Pos[0] = 1940.6300;
				    	Pos[1] = 2042.3811;
				    	Pos[2] = 10.4416;
				    	Pos[3] = 359.4194;
				    }
        			else if(rand == 2)
					{
				    	Pos[0] = 1940.4309;
				    	Pos[1] = 2063.7959;
				    	Pos[2] = 10.4453;
				    	Pos[3] = 359.9164;
				    }
        			else if(rand == 3)
					{
				    	Pos[0] = 1945.8125;
				    	Pos[1] = 2063.6035;
				    	Pos[2] = 10.4452;
				    	Pos[3] = 0.9561;
				    }
        			else
				    {
				    	Pos[0] = 1945.7083;
				    	Pos[1] = 2042.2096;
				    	Pos[2] = 10.4418;
				    	Pos[3] = 359.9365;
				    }
				}

				++ Total_Veh_Created;

                vInfo[Total_Veh_Created][vCariD]    = Total_Veh_Created;
				vInfo[Total_Veh_Created][vModel] 	= GetVehicleModel(GetPlayerVehicleID(playerid));
				vInfo[Total_Veh_Created][vColor1] 	= random(126);
				vInfo[Total_Veh_Created][vColor2] 	= random(126);
				vInfo[Total_Veh_Created][vPrice] 	= vehPrice[GetVehicleModel(GetPlayerVehicleID(playerid))];
				vInfo[Total_Veh_Created][vPosX] 	= Pos[0];
				vInfo[Total_Veh_Created][vPosY] 	= Pos[1];
				vInfo[Total_Veh_Created][vPosZ] 	= Pos[2];
				vInfo[Total_Veh_Created][vPosA] 	= Pos[3];
				GetPlayerName(playerid, sendername, sizeof(sendername));
				strmid(vInfo[Total_Veh_Created][vOwner], sendername, 0, 20, 20);
				strmid(vInfo[Total_Veh_Created][vPlate], "Game4Win", 0, 32, 32);
			    vInfo[Total_Veh_Created][vPaintJ]   = 6;
			    vInfo[Total_Veh_Created][vLocked]   = 1;
			    vInfo[Total_Veh_Created][vTowed]   = 0;

				new query[512];
				format(query, sizeof(query) ,"INSERT INTO `vehicles` (`CarID`,`Model`,`Color1`,`Color2`,`Price`,`vPosX`,`vPosY`,`vPosZ`,`vPosA`,`Owner`,`Plate`,`PaintJ`,`Locked`,`Towed`) VALUES ('%d','%d','%d','%d','%d','%f','%f','%f','%f','%s','%s','%d','%d','%d')",
				Total_Veh_Created,
				GetVehicleModel(GetPlayerVehicleID(playerid)),
				vInfo[Total_Veh_Created][vColor1],
				vInfo[Total_Veh_Created][vColor2],
				vInfo[Total_Veh_Created][vPrice],
				vInfo[Total_Veh_Created][vPosX],
				vInfo[Total_Veh_Created][vPosY],
				vInfo[Total_Veh_Created][vPosZ],
				vInfo[Total_Veh_Created][vPosA],
				vInfo[Total_Veh_Created][vOwner],
				vInfo[Total_Veh_Created][vPlate],
				vInfo[Total_Veh_Created][vPaintJ],
				vInfo[Total_Veh_Created][vLocked],
				vInfo[Total_Veh_Created][vTowed]);
				mysql_query(query);

		  		new cCar = CreateVehicle(GetVehicleModel(GetPlayerVehicleID(playerid)), Pos[0], Pos[1], Pos[2], Pos[3], vInfo[Total_Veh_Created][vColor1], vInfo[Total_Veh_Created][vColor2], 500000);
				SetVehicleNumberPlate(cCar, "Game4Win");
				GivePlayerCash(playerid, -vehPrice[GetVehicleModel(GetPlayerVehicleID(playerid))]);
				vehSlots[GetVehicleModel(GetPlayerVehicleID(playerid))] --;
				SaveVehModels();

				OwnedVeh(cCar) = Total_Veh_Created;

				//SavePrivVeh(Total_Veh_Created);
				//VehOwned[cCar] = Total_Veh_Created;
				if(PlayerInfo[playerid][pCar1] == 0) PlayerInfo[playerid][pCar1] = cCar;
				else if(PlayerInfo[playerid][pCar2] == 0) PlayerInfo[playerid][pCar2] = cCar;
				else if(PlayerInfo[playerid][pCar3] == 0) PlayerInfo[playerid][pCar3] = cCar;
			    SetPlayerInterior(playerid, 0);
			    SetPlayerVirtualWorld(playerid, 0);
				VehPosition[playerid] = 0;
				SetCameraBehindPlayer(playerid);
				UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
				TogglePlayerControllable(playerid, 1);
				PutPlayerInVehicle(playerid, cCar, 0);
				return 1;
			}
			else
		    {
		        if(UsingDealership[playerid] == 1)
		        {
			        SendClientMessage(playerid, COLOR_WHITE, " ");
			        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
		         	SetPlayerPos(playerid, 2131.8369,-1150.5486,24.1454);
				    SetPlayerInterior(playerid, 0);
				    SetPlayerVirtualWorld(playerid, 0);
					VehPosition[playerid] = 0;
					SetCameraBehindPlayer(playerid);
					UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
					TogglePlayerControllable(playerid, 1);
				}
				if(UsingDealership[playerid] == 2)
		        {
			        SendClientMessage(playerid, COLOR_WHITE, " ");
			        SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
		         	SetPlayerPos(playerid, 1410.9225,-1701.1395,13.5395);
				    SetPlayerInterior(playerid, 0);
				    SetPlayerVirtualWorld(playerid, 0);
					VehPosition[playerid] = 0;
					SetCameraBehindPlayer(playerid);
					UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
					TogglePlayerControllable(playerid, 1);
				}
    			if(UsingDealership[playerid] == 3)
       			{
		        	SendClientMessage(playerid, COLOR_WHITE, " ");
		        	SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
	         		SetPlayerPos(playerid, 2751.8899,-1468.2407,30.4531);
			    	SetPlayerInterior(playerid, 0);
				   	SetPlayerVirtualWorld(playerid, 0);
					VehPosition[playerid] = 0;
					SetCameraBehindPlayer(playerid);
					UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
					TogglePlayerControllable(playerid, 1);
				}
    			if(UsingDealership[playerid] == 4)
       			{
		        	SendClientMessage(playerid, COLOR_WHITE, " ");
		        	SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
	         		SetPlayerPos(playerid, 370.9933,-2052.3145,8.0156);
			    	SetPlayerInterior(playerid, 0);
				   	SetPlayerVirtualWorld(playerid, 0);
					VehPosition[playerid] = 0;
					SetCameraBehindPlayer(playerid);
					UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
					TogglePlayerControllable(playerid, 1);
				}
    			if(UsingDealership[playerid] == 5)
       			{
		        	SendClientMessage(playerid, COLOR_WHITE, " ");
		        	SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
	         		SetPlayerPos(playerid, 1606.3135,-2432.6738,13.5547);
			    	SetPlayerInterior(playerid, 0);
				   	SetPlayerVirtualWorld(playerid, 0);
					VehPosition[playerid] = 0;
					SetCameraBehindPlayer(playerid);
					UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
					TogglePlayerControllable(playerid, 1);
				}
    			if(UsingDealership[playerid] == 6)
       			{
		        	SendClientMessage(playerid, COLOR_WHITE, " ");
		        	SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
	         		SetPlayerPos(playerid, 1948.2946,2068.7778,11.0610);
			    	SetPlayerInterior(playerid, 0);
				   	SetPlayerVirtualWorld(playerid, 0);
					VehPosition[playerid] = 0;
					SetCameraBehindPlayer(playerid);
					UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
					TogglePlayerControllable(playerid, 1);
				}
		        return 1;
		    }
	    }
	    else
	    {
         	if(UsingDealership[playerid] == 1)
     		{
  	    		SendClientMessage(playerid, COLOR_WHITE, " ");
	        	//SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
         		SetPlayerPos(playerid, 2131.8369,-1150.5486,24.1454);
		    	SetPlayerInterior(playerid, 0);
			    SetPlayerVirtualWorld(playerid, 0);
				VehPosition[playerid] = 0;
				SetCameraBehindPlayer(playerid);
				UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
				TogglePlayerControllable(playerid, 1);
			}
			if(UsingDealership[playerid] == 2)
   			{
      			SendClientMessage(playerid, COLOR_WHITE, " ");
       			//SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
         		SetPlayerPos(playerid, 1410.9225,-1701.1395,13.5395);
		    	SetPlayerInterior(playerid, 0);
		    	SetPlayerVirtualWorld(playerid, 0);
				VehPosition[playerid] = 0;
				SetCameraBehindPlayer(playerid);
				UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
				TogglePlayerControllable(playerid, 1);
			}
   			if(UsingDealership[playerid] == 3)
   			{
      			SendClientMessage(playerid, COLOR_WHITE, " ");
       			//SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
         		SetPlayerPos(playerid, 2751.8899,-1468.2407,30.4531);
		    	SetPlayerInterior(playerid, 0);
		    	SetPlayerVirtualWorld(playerid, 0);
				VehPosition[playerid] = 0;
				SetCameraBehindPlayer(playerid);
				UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
				TogglePlayerControllable(playerid, 1);
			}
   			if(UsingDealership[playerid] == 4)
   			{
      			SendClientMessage(playerid, COLOR_WHITE, " ");
       			//SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
         		SetPlayerPos(playerid, 370.9933,-2052.3145,8.0156);
		    	SetPlayerInterior(playerid, 0);
		    	SetPlayerVirtualWorld(playerid, 0);
				VehPosition[playerid] = 0;
				SetCameraBehindPlayer(playerid);
				UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
				TogglePlayerControllable(playerid, 1);
			}
   			if(UsingDealership[playerid] == 5)
   			{
      			SendClientMessage(playerid, COLOR_WHITE, " ");
       			//SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
         		SetPlayerPos(playerid, 1606.3135,-2432.6738,13.5547);
		    	SetPlayerInterior(playerid, 0);
		    	SetPlayerVirtualWorld(playerid, 0);
				VehPosition[playerid] = 0;
				SetCameraBehindPlayer(playerid);
				UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
				TogglePlayerControllable(playerid, 1);
			}
   			if(UsingDealership[playerid] == 6)
   			{
     			SendClientMessage(playerid, COLOR_WHITE, " ");
       			//SendClientMessage(playerid, COLOR_WHITE, "{DC0C0C}Dealership: {FFFFFF}Nu ai destui bani!");
        		SetPlayerPos(playerid, 1948.2946,2068.7778,11.0610);
	    		SetPlayerInterior(playerid, 0);
		   		SetPlayerVirtualWorld(playerid, 0);
				VehPosition[playerid] = 0;
				SetCameraBehindPlayer(playerid);
				UsingDealership[playerid] = 0; SetPlayerVirtualWorld(playerid, 0); DealershipTimer[playerid] = 0;
				TogglePlayerControllable(playerid, 1);
			}
	        return 1;
	    }
	}

	if(strcmp(cmd, "/vcreate", true) == 0)
	{
	    if(PlayerInfo[playerid][pAdmin] < 5) return SendClientMessage(playerid, COLOR_RED, "Nu ai rangul administrativ necesar!");

		new
	    	Float:Pos[4],
	    	ivModel,
	    	ivPrice,
	    	ivColors[2],
			iMsg[148];


		//if(sscanf(params, "iiii", ivModel, ivPrice, ivColors[0], ivColors[1])) return SendClientMessage(playerid, -1, ""#CRED"{00FF00}Folosire:{FFFFFF} "#CORANGE"/VCreate < Vehicle Model > < Price > < Color 1 > < Color 2 >");
		tmp = strtok(cmdtext, idx);
		if(!strlen(tmp))
		{
		    return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /vcreate <vmodel> <vprice> <vcolor1> <vcolor2>");
		}
		ivModel = strvalEx(tmp);
		tmp = strtok(cmdtext, idx);
		if(!strlen(tmp))
		{
		    return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /vcreate <vmodel> <vprice> <vcolor1> <vcolor2>");
		}
		ivPrice = strvalEx(tmp);
		tmp = strtok(cmdtext, idx);
		if(!strlen(tmp))
		{
		    return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /vcreate <vmodel> <vprice> <vcolor1> <vcolor2>");
		}
		ivColors[0] = strvalEx(tmp);
		tmp = strtok(cmdtext, idx);
		if(!strlen(tmp))
		{
		    return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /vcreate <vmodel> <vprice> <vcolor1> <vcolor2>");
		}
		ivColors[1] = strvalEx(tmp);
		GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]);
		GetPlayerFacingAngle(playerid, Pos[3]);

		++ Total_Veh_Created;

        vInfo[Total_Veh_Created][vCariD]    = Total_Veh_Created;
		vInfo[Total_Veh_Created][vModel] 	= ivModel;
		vInfo[Total_Veh_Created][vColor1] 	= ivColors[0];
		vInfo[Total_Veh_Created][vColor2] 	= ivColors[1];
		vInfo[Total_Veh_Created][vPrice] 	= ivPrice;
		vInfo[Total_Veh_Created][vPosX] 	= Pos[0];
		vInfo[Total_Veh_Created][vPosY] 	= Pos[1];
		vInfo[Total_Veh_Created][vPosZ] 	= Pos[2];
		vInfo[Total_Veh_Created][vPosA] 	= Pos[3];
		strmid(vInfo[Total_Veh_Created][vOwner], "Unbought", 0, 20, 20);
		strmid(vInfo[Total_Veh_Created][vPlate], "Game4Win", 0, 32, 32);
	    vInfo[Total_Veh_Created][vPaintJ]   = 6;
	    vInfo[Total_Veh_Created][vLocked]   = 1;
	    vInfo[Total_Veh_Created][vTowed]   = 0;

		new query[512];
		format(query, sizeof(query) ,"INSERT INTO `vehicles` (`CarID`,`Model`,`Color1`,`Color2`,`Price`,`vPosX`,`vPosY`,`vPosZ`,`vPosA`,`Owner`,`Plate`,`PaintJ`,`Locked`,`Towed`) VALUES ('%d','%d','%d','%d','%d','%f','%f','%f','%f','%s','%s','%d','%d','%d')",
		Total_Veh_Created,
		GetVehicleModel(GetPlayerVehicleID(playerid)),
		vInfo[Total_Veh_Created][vColor1],
		vInfo[Total_Veh_Created][vColor2],
		vInfo[Total_Veh_Created][vPrice],
		vInfo[Total_Veh_Created][vPosX],
		vInfo[Total_Veh_Created][vPosY],
		vInfo[Total_Veh_Created][vPosZ],
		vInfo[Total_Veh_Created][vPosA],
		vInfo[Total_Veh_Created][vOwner],
		vInfo[Total_Veh_Created][vPlate],
		vInfo[Total_Veh_Created][vPaintJ],
		vInfo[Total_Veh_Created][vLocked],
		vInfo[Total_Veh_Created][vTowed]);
		mysql_query(query);

  		new cCar = CreateVehicle(ivModel, Pos[0], Pos[1], Pos[2], Pos[3], ivColors[0], ivColors[1], 500000);
		SetVehicleNumberPlate(cCar, "G4W:RP");
		SaveVehModels();

		OwnedVeh(cCar) = Total_Veh_Created;

		//SavePrivVeh(Total_Veh_Created);

		format(iMsg, sizeof(iMsg), ""#CYELLOW"Vehiculul: "#CBLUE"%i (VID: %i) "#CYELLOW"a fost creat. Pret: "#CBLUE"$%i "#CYELLOW"Numar: "#CBLUE"Game4Win", ivModel, Total_Veh_Created, ivPrice);
		SendClientMessage(playerid, -1, iMsg);
		return 1;
	}

stock LoadPVehicles()
{
    new result[24], index = 0; TuneTimer = 10;
    mysql_query("SELECT * FROM `vehicles` ORDER BY `vehicles`.`CarID` ASC");
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        // LOADING DATA     \====================================================================/
        index++;
        mysql_get_field("CarID", result);			vInfo[index][vCariD] = strval(result);
        mysql_get_field("Model", result);			vInfo[index][vModel] = strval(result);
        mysql_get_field("Color1", result);			vInfo[index][vColor1] = strval(result);
        mysql_get_field("Color2", result);			vInfo[index][vColor2] = strval(result);
        mysql_get_field("Price", result);			vInfo[index][vPrice] = strval(result);
        mysql_get_field("Owner", result);			strmid(vInfo[index][vOwner], result, false, strlen(result), 24);
        mysql_get_field("vPosX", result);			vInfo[index][vPosX] = floatstr(result);
        mysql_get_field("vPosY", result);			vInfo[index][vPosY] = floatstr(result);
        mysql_get_field("vPosZ", result);			vInfo[index][vPosZ] = floatstr(result);
        mysql_get_field("vPosA", result);			vInfo[index][vPosA] = floatstr(result);
        mysql_get_field("Plate", result);			strmid(vInfo[index][vPlate], result, false, strlen(result), 24);
        mysql_get_field("PaintJ", result);			vInfo[index][vPaintJ] = strval(result);
        mysql_get_field("Locked", result);			vInfo[index][vLocked] = strval(result);
        mysql_get_field("Towed", result);			vInfo[index][vTowed] = strval(result);
		mysql_get_field("vMod1", result);			vMods[index][0] = strval(result);
        mysql_get_field("vMod2", result);			vMods[index][1] = strval(result);
        mysql_get_field("vMod3", result);			vMods[index][2] = strval(result);
        mysql_get_field("vMod4", result);			vMods[index][3] = strval(result);
        mysql_get_field("vMod5", result);			vMods[index][4] = strval(result);
        mysql_get_field("vMod6", result);			vMods[index][5] = strval(result);
        mysql_get_field("vMod7", result);			vMods[index][6] = strval(result);
        mysql_get_field("vMod8", result);			vMods[index][7] = strval(result);
        mysql_get_field("vMod9", result);			vMods[index][8] = strval(result);
        mysql_get_field("vMod10", result);			vMods[index][9] = strval(result);
        mysql_get_field("vMod11", result);			vMods[index][10] = strval(result);
        mysql_get_field("vMod12", result);			vMods[index][11] = strval(result);

		// CREATING VEHICLE  \====================================================================/

		new i = index;

  		if(vInfo[i][vPosX] == 0.0 && vInfo[i][vPosY] == 0.0 && vInfo[i][vPosZ] == 0.0) { ++ Total_Veh_Created; /*INI_Close();*/ continue; }

		new
			vCarID = CreateVehicle(vInfo[i][vModel], vInfo[i][vPosX], vInfo[i][vPosY], vInfo[i][vPosZ], vInfo[i][vPosA], vInfo[i][vColor1], vInfo[i][vColor2], 500000);
		SetVehicleNumberPlate(vCarID, vInfo[i][vPlate]);
		ChangeVehiclePaintjob(vCarID, vInfo[i][vPaintJ]);

	   	OwnedVeh(vCarID) = index;

		for(new iMod = 0; iMod < MAX_VEH_MODS; ++iMod)
		{
		    if(vMods[index][iMod] > 0)
		    {
		        AddVehicleComponent(vCarID, vMods[index][iMod]);
			}
		}

		Total_Veh_Created = vInfo[index][vCariD];

		//    MYSQL PART     \====================================================================/

		new query[512];
		format(query, sizeof(query),"UPDATE `vehicles` SET `CarID` = '%d' WHERE `CarID` = '%d';", index, vInfo[index][vCariD]);
		mysql_query(query);
    }
    mysql_free_result();
	printf("%d cars created!", Total_Veh_Created);
    return 1;
}

JoKeRy · July 18, 2013

Nu ma pricep eu prea bine, dar te-as sfatui sa folosesti alt sistem de masini personale.

andrein2 · July 19, 2013

Pentru ce sa pun alt sistem cand asta e bun are decat eroarea aia , cand cumpar masina apare in baza de date dar nu se incarca dupa restart

Sign In

Problema Baza de date

Question

andrein2

2 answers to this question

Recommended Posts

JoKeRy

andrein2

Similar Content

Actualizare textdraw (speedometer) la secunda (problema)

Problema /vehicles

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

Problema clan members: Nu afiseaza membrii.

Problema dialog dealership (nu afiseaza ID-ul masinii)

Recently Browsing 0 members

Browse

Activity

Important Information