Jump to content
  • 0

key car

Jimmi

Asked by Jimmi,

 Share

Question

Jimmi Proficient

Jimmi

Posted
Posted
Problema intalnita (descriere):Am rezolvat bug-ul la ds.Acuma iti da masina in baza de date.Dar pe server tot nu apare ca e ata.In baza de date in tabelul vehicles apare ca e a ta dar in players car1 nu si nici la /stats.La fel si cand ma urc in ea nu apare ca e a mea...
Ero(area / rile) / warning-(ul / urile):-
Liniile de cod / sursa / script-ul(obligatoriu):
Imagini / Video (optional):-
Ati incercat sa rezolvati singur?:Da, puteti verifica
 if(dialogid == 180 && PlayerInfo[playerid][pCar1] == 999)
                  {
                     PlayerInfo[playerid][pCar1] = idd;
                       format(string, sizeof(string), "UPDATE players SET Car='%d' WHERE id=%d", PlayerInfo[playerid][pCar1], PlayerInfo[playerid][pSQLID]);
                     mysql_query(string);
                     GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                      new string1[128];
                     format(string1, sizeof(string1), "Felicitari! Ai achizitionat un vehicul! Valoare: %d | slot #1]!", vInfo[idd][vPrice]);
                     SendClientMessage(playerid, -1, string1);
                     SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                     return 1;
                  }
                  else if(dialogid == 181)
                  {
                      PlayerInfo[playerid][pCar2] = idd;
                       format(string, sizeof(string), "UPDATE players SET Car2='%d' WHERE id=%d", PlayerInfo[playerid][pCar2], PlayerInfo[playerid][pSQLID]);
                     mysql_query(string);
                     GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                      new string1[128];
                     format(string1, sizeof(string1), "Felicitari! Ai achizitionat o motocicleta!  Valoare: %d | slot #2]!", vInfo[idd][vPrice]);
                     SendClientMessage(playerid, -1, string1);
                     SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                     return 1;
                  }
                   else if(dialogid == 182)
                  {
                        PlayerInfo[playerid][pCar3] = idd;
                          format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]);
                        mysql_query(string);
                         GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                        new string1[128];
                        format(string1, sizeof(string1), "Felicitari! Ai achizitionat o barca! Valoare: %d | slot #3]!", vInfo[idd][vPrice]);
                        SendClientMessage(playerid, -1, string1);
                        SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                        return 1;
                  }
                   else if(dialogid == 183)
                  {
                        PlayerInfo[playerid][pCar3] = idd;
                          format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]);
                        mysql_query(string);
                         GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                        new string1[128];
                        format(string1, sizeof(string1), "Felicitari! Ai achizitionat un avion/elicopter! Valoare: %d | slot #3]!", vInfo[idd][vPrice]);
                        SendClientMessage(playerid, -1, string1);
                        SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                        return 1;
                  }

21 answers to this question

Recommended Posts

  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted 
if(dialogid == 179)// DealerShip
		{
			if(!response)
            {
                SendClientMessage(playerid, -1, "Ai inchis meniul cu optiuni!");
                return 1; // We processed it
            }
			switch(listitem)
            {
				case 0:
                {
                    new CheckStock[1024];
					new result;
					new string2[2056];
					new numarStoc;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='401'");
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc1;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='405'");
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc1 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc2;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='410'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc2 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc3;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='529'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc3 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc4;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='426'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc4 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc5;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='436'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc5 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc6;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='445'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc6 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc7;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='458'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc7 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc8;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='495'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc8 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc9;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='496'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc9 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc10;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='535'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc10 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStocFlash;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='565'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStocFlash = mysql_fetch_int(result);
					mysql_free_result();
					new numarStocSavanna;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='567'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStocSavanna = mysql_fetch_int(result);
					mysql_free_result();
					new numarStocTornado;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='576'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStocTornado = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc11;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='560'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc11 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc12;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='562'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc12 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc13;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='402'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc13 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc14;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='602'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc14 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc15;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='429'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc15 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc16;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='541'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc16 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc17;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='415'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc17 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc18;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='494'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc18 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc19;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='411'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc19 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc20;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='559'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc20 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc21;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='603'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc21 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc22;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='506'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc22 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc23;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='451'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc23 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc24;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='477'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc24 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc25;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='558'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc25 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStocMesa;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='500'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStocMesa = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc31;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='479'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc31 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc37;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='404'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc37 = mysql_fetch_int(result);
					mysql_free_result();
					new coordsstring[2056];
					format(string2, sizeof(string2), "1. Regina: 170.000$ [Stock: {FF0000}%d{FFFFFF}]\n2. Perenniel: 180.000$ [Stock: {FF0000}%d{FFFFFF}]\n3.Bravura: 300.000$ [Stock: {FF0000}%d{FFFFFF}]\n4. Sentinel: 400.000$ [Stock: {FF0000}%d{FFFFFF}]\n5.Manana: 250.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc31,numarStoc37,numarStoc,numarStoc1,numarStoc2,numarStoc3,numarStoc4,numarStoc5);
					strcat(string2,coordsstring);
					format(coordsstring, sizeof(coordsstring), "6.Willard: 320.000$ [Stock: {FF0000}%d{FFFFFF}]\n7.Premier: 370.000$ [Stock: {FF0000}%d{FFFFFF}]\n8.Previon: 280.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc3,numarStoc4,numarStoc5);
					strcat(string2,coordsstring);
					format(coordsstring, sizeof(coordsstring), "9. Admiral: 290.000$ [Stock: {FF0000}%d{FFFFFF}]\n10. Solair: 330.000$ [Stock: {FF0000}%d{FFFFFF}]\n11. Mesa: 700.000$ [Stock: {FF0000}%d{FFFFFF}]\n12. Sandking: $1.200.000$ [Stock: {FF0000}%d{FFFFFF}]\n13. Blista Compact: 450.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc6,numarStoc7,numarStocMesa,numarStoc8,numarStoc9);
					strcat(string2,coordsstring);
					format(coordsstring, sizeof(coordsstring), "14. Slamvan: 350.000$ [Stock: {FF0000}%d{FFFFFF}]\n15. Flash: 800.000$ [Stock: {FF0000}%d]\n16. Savanna: 900.000$ [Stock: {FF0000}%d]\n17. Tornado: 850.000$ [Stock: {FF0000}%d{FFFFFF}]\n18. Sultan: 1.300.000$ [Stock: {FF0000}%d{FFFFFF}]\n19. Elegy: 900.000$ [Stock: {FF0000}%d{FFFFFF}]\n20. Buffalo: 1.500.000$ [Stock: {FF0000}%d{FFFFFF}]\n", numarStoc10,numarStocFlash,numarStocSavanna,numarStocTornado,numarStoc11,numarStoc12,numarStoc13);
					strcat(string2,coordsstring);
					format(coordsstring, sizeof(coordsstring), "21. Alpha: 600.000$ [Stock: {FF0000}%d{FFFFFF}]\n22. Banshee: 2.220.000$ [Stock: {FF0000}%d{FFFFFF}]\n23. Bullet: 3.520.000$ [Stock: {FF0000}%d{FFFFFF}]\n24. Cheetah: 2.500.000$ [Stock: {FF0000}%d{FFFFFF}]\n25. Hotring Racer: 1.300.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc14,numarStoc15,numarStoc16,numarStoc17,numarStoc18);
					strcat(string2,coordsstring);
					format(coordsstring, sizeof(coordsstring), "26. Infernus: 3.500.000$ [Stock: {FF0000}%d{FFFFFF}]\n27. Jester: 950.000$ [Stock: {FF0000}%d{FFFFFF}]\n28. Phoenix: 750.000$ [Stock: {FF0000}%d{FFFFFF}]\n29. Super GT: 900.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc19,numarStoc20,numarStoc21,numarStoc22);
					strcat(string2,coordsstring);
					format(coordsstring, sizeof(coordsstring), "30. Turismo: $2.600.000$ [Stock: {FF0000}%d{FFFFFF}]\n31. ZR-350: 950.000$ [Stock: {FF0000}%d{FFFFFF}]\n32. Uranus: 900.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc23,numarStoc24,numarStoc25);
					strcat(string2,coordsstring);
					ShowPlayerDialog (playerid, 180 ,DIALOG_STYLE_LIST, "{C00000}D{FFFFFF}ealership - Automobile" , string2, "Ok" , "Cancel" );

				}
				case 1:
                {
                    new result;
                    new CheckStock[1024];
					new numarStoc26;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='586'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc26 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc27;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='521'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc27 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc28;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='463'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc28 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc29;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='462'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc29 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStocNRG;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='522'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStocNRG = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc30;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='461'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc30 = mysql_fetch_int(result);
					mysql_free_result();
                    new string2[512];
                    new coordsstring[2056];
					format(string2, sizeof(string2), "1. Wayfarer: 250.000$ [Stock: {FF0000}%d{FFFFFF}]\n2. FCR-900: 1.750.000$ [Stock: {FF0000}%d{FFFFFF}]\n3. Freeway: 500.000$ [Stock: {FF0000}%d{FFFFFF}]\n4. NRG-500: 3.000.000$ [Stock: {FF0000}%d{FFFFFF}]\n5. Faggio: 150.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc26,numarStoc27,numarStoc28,numarStocNRG,numarStoc29);
					strcat(string2,coordsstring);
					format(coordsstring, sizeof(coordsstring), "6. PCJ-600: 1.630.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc30);
					strcat(string2,coordsstring);
					ShowPlayerDialog (playerid, 181 ,DIALOG_STYLE_LIST, "{C00000}D{FFFFFF}ealership - Mototciclete" , string2, "Ok" , "Cancel" );
				}
				case 2:
                {
                    new result;
                    new CheckStock[1024];
					new numarStoc32;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='446'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc32 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc33;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='452'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc33 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc34;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='453'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc34 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc35;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='473'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc35 = mysql_fetch_int(result);
					mysql_free_result();
                    new string2[512];
                    new coordsstring[2056];
					format(string2, sizeof(string2), "1. Squallo: 1.000.000$ [Stock: {FF0000}%d{FFFFFF}]\n2. Speeder: 2.000.000$ [Stock: {FF0000}%d{FFFFFF}]\n3. Reefer: 400.000$ [Stock: {FF0000}%d{FFFFFF}]\n4. Dinghy: 250.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc32,numarStoc33,numarStoc34,numarStoc35);
					strcat(string2,coordsstring);
					ShowPlayerDialog (playerid, 182 ,DIALOG_STYLE_LIST, "{C00000}D{FFFFFF}ealership - Barci" , string2, "Ok" , "Cancel" );
				}
				case 3:
				{
				    new result;
				    new CheckStock[1024];
				    new numarStoc36;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='487'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc36 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc38;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='404'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc38 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc39;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='512'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc39 = mysql_fetch_int(result);
					mysql_free_result();
					new numarStoc40;
					format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='593'", VehDSmod[playerid]);
					result = mysql_query(CheckStock);
					mysql_store_result();
					numarStoc40 = mysql_fetch_int(result);
					mysql_free_result();
				    new string2[512];
                    new coordsstring[2056];
					format(string2, sizeof(string2), "1. Maverick: 3.300.000$ [Stock: {FF0000}%d{FFFFFF}]\n2. Sparrow: 1.000.000$ [Stock: {FF0000}%d{FFFFFF}]\n3. Cropduster: 450.000$ [Stock: {FF0000}%d{FFFFFF}]\n4. Dodo: 520.000$ [Stock: {FF0000}%d{FFFFFF}]\n",numarStoc36,numarStoc38,numarStoc39,numarStoc40);
					strcat(string2,coordsstring);
					ShowPlayerDialog (playerid, 183 ,DIALOG_STYLE_LIST, "{C00000}D{FFFFFF}ealership - Aeronave" , string2, "Ok" , "Cancel" );
				}
			}
		}
		if((dialogid == 180) || (dialogid == 181) || (dialogid == 182) || (dialogid == 183))
		{
			if(!response)
            {
                SendClientMessage(playerid, -1, "Ai inchis meniul cu optiuni!");
                return 1; // We processed it
            }
			if(dialogid == 180)
			{
			    if(PlayerInfo[playerid][pLevel] < 3)
			    {
			        SendClientMessage(playerid, -1, "Iti trebuie level 3 pentru a utiliza aceasta comanda (/dealership)!");
			        return 1;
				}
			    if(PlayerInfo[playerid][pCar1] != 999 && PlayerInfo[playerid][pDonateRank] == 0)
				{
				    SendClientMessage(playerid, -1, "Detii deja un vehicul personal!");
				    return 1;
				}
				switch(listitem)
				{
				case 0:
				{
				    VehDSmod[playerid]=479;
					VehDSpret[playerid]=170000;
				}
				case 1:
				{
				    VehDSmod[playerid]=404;
					VehDSpret[playerid]=180000;
				}
                case 2:
                {
					VehDSmod[playerid]=401;
					VehDSpret[playerid]=300000;
                }
				case 3:
                {
					VehDSmod[playerid]=405;
					VehDSpret[playerid]=400000;
                }
				case 4:
                {
					VehDSmod[playerid]=410;
					VehDSpret[playerid]=250000;
                }
				case 5:
                {
					VehDSmod[playerid]=529;
					VehDSpret[playerid]=320000;
                }
				case 6:
                {
					VehDSmod[playerid]=426;
					VehDSpret[playerid]=370000;
                }
				case 7:
                {
					VehDSmod[playerid]=436;
					VehDSpret[playerid]=280000;
                }
				case 8:
                {
					VehDSmod[playerid]=445;
					VehDSpret[playerid]=290000;
                }
				case 9:
                {
					VehDSmod[playerid]=458;
					VehDSpret[playerid]=330000;
                }
                case 10:
                {
                    VehDSmod[playerid]=500;
					VehDSpret[playerid]=700000;
                }
				case 11:
                {
					VehDSmod[playerid]=495;
					VehDSpret[playerid]=1200000;
                }
				case 12:
                {
					VehDSmod[playerid]=496;
					VehDSpret[playerid]=450000;
                }
				case 13:
                {
					VehDSmod[playerid]=535;
					VehDSpret[playerid]=350000;
                }
                case 14:
                {
                	VehDSmod[playerid]=565; //Flash
					VehDSpret[playerid]=800000;
                }
                case 15:
                {
                	VehDSmod[playerid]=567; // Tornado
					VehDSpret[playerid]=850000;
                }
                case 16:
                {
                	VehDSmod[playerid]=576; // Savanna
					VehDSpret[playerid]=900000;
                }
				case 17:
                {
					VehDSmod[playerid]=560;
					VehDSpret[playerid]=1300000;
                }
				case 18:
                {
					VehDSmod[playerid]=562;
					VehDSpret[playerid]=900000;
                }
                case 19:
                {
					VehDSmod[playerid]=402;
					VehDSpret[playerid]=150000;
                }
				case 20:
                {
					VehDSmod[playerid]=602;
					VehDSpret[playerid]=600000;
                }
				case 21:
                {
					VehDSmod[playerid]=429;
					VehDSpret[playerid]=2200000;
                }
				case 22:
                {
					VehDSmod[playerid]=541;
					VehDSpret[playerid]=3520000;
                }
				case 23:
                {
					VehDSmod[playerid]=415;
					VehDSpret[playerid]=2500000;
                }
				case 24:
                {
					VehDSmod[playerid]=494;
					VehDSpret[playerid]=1300000;
                }
				case 25:
                {
					VehDSmod[playerid]=411;
					VehDSpret[playerid]=3500000;
                }
				case 26:
                {
					VehDSmod[playerid]=559;
					VehDSpret[playerid]=950000;
                }
				case 27:
                {
					VehDSmod[playerid]=603;
					VehDSpret[playerid]=750000;
                }
				case 28:
                {
					VehDSmod[playerid]=506;
					VehDSpret[playerid]=900000;
                }
				case 29:
                {
					VehDSmod[playerid]=451;
					VehDSpret[playerid]=2600000;
                }
				case 30:
                {
					VehDSmod[playerid]=477;
					VehDSpret[playerid]=950000;
                }
				case 31:
                {
					VehDSmod[playerid]=558;
					VehDSpret[playerid]=900000;
                }
			}
		}
		else if(dialogid == 181)
		{
		    if(PlayerInfo[playerid][pLevel] < 3)
			    {
			        SendClientMessage(playerid, -1, "Iti trebuie level 3 pentru a utiliza aceasta comanda (/dealership)!");
			        return 1;
				}
			if(PlayerInfo[playerid][pCar2] != 999)
			{
			    SendClientMessage(playerid, -1, "Detii deja o motocicleta personala!");
			    return 1;
			}
			switch(listitem)
            {
				case 0:
				{
					VehDSmod[playerid]=586;
					VehDSpret[playerid]=250000;
                }
				case 1:
                {
					VehDSmod[playerid]=521;
					VehDSpret[playerid]=175000;
                }
				case 2:
                {
					VehDSmod[playerid]=463;
					VehDSpret[playerid]=500000;
                }
				case 3:
                {
					VehDSmod[playerid]=522;
					VehDSpret[playerid]=3000000;
                }
				case 4:
                {
					VehDSmod[playerid]=462;
					VehDSpret[playerid]=150000;
                }
				case 5:
                {
					VehDSmod[playerid]=461;
					VehDSpret[playerid]=1630000;
                }
			}
		}
	    else if(dialogid == 182)
		{
		    if(PlayerInfo[playerid][pLevel] < 3)
			    {
			        SendClientMessage(playerid, -1, "Iti trebuie level 3 pentru a utiliza aceasta comanda (/dealership)!");
			        return 1;
				}
		    if(PlayerInfo[playerid][pCar3] != 999)
			{
			    SendClientMessage(playerid, -1, "Detii deja o barca personala!");
			    return 1;
			}
			switch(listitem)
            {
				case 0:
                {
					VehDSmod[playerid]=446;
					VehDSpret[playerid]= 1000000;
                }
				case 1:
                {
					VehDSmod[playerid]=452;
					VehDSpret[playerid]= 2000000;
                }
				case 2:
                {
					VehDSmod[playerid]=453;
					VehDSpret[playerid]= 400000;
                }
				case 3:
                {
					VehDSmod[playerid]=473;
					VehDSpret[playerid]= 250000;
                }
			}
		}
		else if(dialogid == 183)
		{
		    if(PlayerInfo[playerid][pLevel] < 3)
			    {
			        SendClientMessage(playerid, -1, "Iti trebuie level 3 pentru a utiliza aceasta comanda (/dealership)!");
			        return 1;
				}
			if(PlayerInfo[playerid][pCar3] != 0)
			{
			    SendClientMessage(playerid, -1, "Detii deja un avion personal!");
			    return 1;
			}
			switch(listitem)
            {
            	case 0:
                {
					VehDSmod[playerid]=487; //heli
					VehDSpret[playerid]=3300000;
                }
				case 1:
                {
					VehDSmod[playerid]=447; //heli
					VehDSpret[playerid]= 1000000;
                }
				case 2:
                {
					VehDSmod[playerid]=512; //avion
					VehDSpret[playerid]= 450000;
                }
				case 3:
                {
					VehDSmod[playerid]=593; //avion
					VehDSpret[playerid]= 520000;
                }
			}
  		}
			if(GetPlayerCash(playerid) > VehDSpret[playerid])
         {
            new CheckStock[128];
    new result;
            new numarStoc;
            format(CheckStock,sizeof(CheckStock),"SELECT stoc FROM stocds WHERE modelid='%i'", VehDSmod[playerid]);
            result = mysql_query(CheckStock);
            mysql_store_result();
            numarStoc = mysql_fetch_int(result);
            mysql_free_result();
            if(numarStoc >= 1)
            {
                  numarStoc--;
                  format(CheckStock,sizeof(CheckStock),"UPDATE stocds SET stoc='%i' WHERE modelid='%i'", numarStoc, VehDSmod[playerid]);
                  mysql_query(CheckStock);
                  numarStoc = 0;
                        new idd;
                  mysql_query("SELECT * FROM `vehicles`");
                  mysql_store_result();
                  idd = mysql_num_rows()+1;
                  mysql_free_result();
                       format(string, sizeof(string), "%s",ArIsim[VehDSmod[playerid]-400]);
                  strmid(vInfo[idd][vOwner], sendername, 0, strlen(sendername), 999);
                  new rand;
                  rand = random(sizeof(VehicleSpawns));
                  new rand1;
                  new rand2;
                  rand1 = random(sizeof(FlySpawns));
                  rand2 = random(sizeof(BoatSpawns));
                    if(dialogid == 180)
                  {
                        vInfo[idd][vCariD] = VehDSmod[playerid];
                     vInfo[idd][vPrice] = VehDSpret[playerid];
                     vInfo[idd][vPosX] = VehicleSpawns[rand][0];
                     vInfo[idd][vPosY] = VehicleSpawns[rand][1];
                     vInfo[idd][vPosZ] = VehicleSpawns[rand][2];
                  }
                    if(dialogid == 181)
                  {
                        vInfo[idd][vCariD] = VehDSmod[playerid];
                     vInfo[idd][vPrice] = VehDSpret[playerid];
                     vInfo[idd][vPosX] = VehicleSpawns[rand][0];
                     vInfo[idd][vPosY] = VehicleSpawns[rand][1];
                     vInfo[idd][vPosZ] = VehicleSpawns[rand][2];
                  }
                    if(dialogid == 182)
                  {
                        vInfo[idd][vCariD] = VehDSmod[playerid];
                     vInfo[idd][vPrice] = VehDSpret[playerid];
                     vInfo[idd][vPosX] = BoatSpawns[rand2][0];
                     vInfo[idd][vPosY] = BoatSpawns[rand2][1];
                     vInfo[idd][vPosZ] = BoatSpawns[rand2][2];
                  }
                   if(dialogid == 183)
                     {
                      vInfo[idd][vCariD] = VehDSmod[playerid];
                     vInfo[idd][vPrice] = VehDSpret[playerid];
                     vInfo[idd][vPosX] = FlySpawns[rand1][0];
                     vInfo[idd][vPosY] = FlySpawns[rand1][1];
                     vInfo[idd][vPosZ] = FlySpawns[rand1][2];
                  }
                  format( vInfo[ idd ][ vOwner ], MAX_PLAYER_NAME, GetName(playerid) );
                  vInfo[idd][vVechime] = 0;
                    AddStaticVehicle(vInfo[idd][vCariD],vInfo[idd][vPosX],vInfo[idd][vPosY],vInfo[idd][vPosZ],0,0,0);
                  format(string, sizeof(string),"INSERT INTO vehicles (CarID, Model) VALUES (%d, %d)",  idd, vInfo[idd][vCariD]);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vPosX='%f' WHERE CarID=%d", vInfo[idd][vPosX], idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vPosY='%f' WHERE CarID=%d", vInfo[idd][vPosY], idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vPosZ='%f' WHERE CarID=%d", vInfo[idd][vPosZ], idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vPosA='%f' WHERE CarID=%d", vInfo[idd][vPosA], idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET Color1='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET Color2='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET Price ='%d' WHERE CarID=%d", vInfo[idd][vPrice], idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET Towed='0'WHERE CarID=%d", vInfo[idd][vTowed], idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET Owner='%s' WHERE CarID=%d", vInfo[idd][vOwner], idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET Plate='%s' WHERE CarID=%d", vInfo[idd][vPlate], idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET Locked='0' WHERE CarID=%d", vInfo[idd][vLocked], idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET Vechime='0' WHERE CarID=%d", vInfo[idd][vVechime], idd);
                  mysql_query(string);
              format(string, sizeof(string), "UPDATE vehicles SET PlateModel='0' WHERE CarID=%d", vInfo[idd][vPlateMod], idd);
              mysql_query(string);
              format(string, sizeof(string), "UPDATE vehicles SET Registred='0' WHERE CarID=%d", vInfo[idd][vReg], idd);
              mysql_query(string);
              format(string, sizeof(string), "UPDATE vehicles SET PaintJ='0' WHERE CarID=%d", vInfo[idd][vPaintJ], idd);
              mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod1='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod2='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod3='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod4='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod5='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod6='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod7='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod8='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod9='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod10='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod11='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod12='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                  format(string, sizeof(string), "UPDATE vehicles SET vMod13='0' WHERE CarID=%d", idd);
                  mysql_query(string);
                    if(dialogid == 180 && PlayerInfo[playerid][pCar1] == 999)
                  {
                     PlayerInfo[playerid][pCar1] = idd;
                       format(string, sizeof(string), "UPDATE players SET Car='%d' WHERE id=%d", PlayerInfo[playerid][pCar1], PlayerInfo[playerid][pSQLID]);
                     mysql_query(string);
                     GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                      new string1[128];
                     format(string1, sizeof(string1), "Felicitari! Ai achizitionat un vehicul! Valoare: %d | slot #1]!", vInfo[idd][vPrice]);
                     SendClientMessage(playerid, -1, string1);
                     SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                     return 1;
                  }
                  else if(dialogid == 181)
                  {
                      PlayerInfo[playerid][pCar2] = idd;
                       format(string, sizeof(string), "UPDATE players SET Car2='%d' WHERE id=%d", PlayerInfo[playerid][pCar2], PlayerInfo[playerid][pSQLID]);
                     mysql_query(string);
                     GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                      new string1[128];
                     format(string1, sizeof(string1), "Felicitari! Ai achizitionat o motocicleta!  Valoare: %d | slot #2]!", vInfo[idd][vPrice]);
                     SendClientMessage(playerid, -1, string1);
                     SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                     return 1;
                  }
                   else if(dialogid == 182)
                  {
                        PlayerInfo[playerid][pCar3] = idd;
                          format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]);
                        mysql_query(string);
                         GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                        new string1[128];
                        format(string1, sizeof(string1), "Felicitari! Ai achizitionat o barca! Valoare: %d | slot #3]!", vInfo[idd][vPrice]);
                        SendClientMessage(playerid, -1, string1);
                        SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                        return 1;
                  }
                   else if(dialogid == 183)
                  {
                        PlayerInfo[playerid][pCar3] = idd;
                          format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]);
                        mysql_query(string);
                         GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                        new string1[128];
                        format(string1, sizeof(string1), "Felicitari! Ai achizitionat un avion/elicopter! Valoare: %d | slot #3]!", vInfo[idd][vPrice]);
                        SendClientMessage(playerid, -1, string1);
                        SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                        return 1;
                  }

            }
            else return SendClientMessage(playerid,COLOR_WHITE,"Aceasta masina nu mai este in stoc.");

         }
         else
         {
            SendClientMessage(playerid, -1, "Nu ai suficienti bani.");
            return 1;
         }
      }

Daca fac o masina cu comanda /vcreate imi da cheia de la masina.....dar daca cumpar din ds nu...

Comanda /vcreate

if(strcmp(cmd, "/vcreate", true) == 0)
	{
	    if(PlayerInfo[playerid][pAdmin] < 6) return SendClientMessage(playerid, COLOR_RED, "Nu poti folosi aceasta comanda!");
		new
	    	Float:Pos[4],
	    	ivModel,
	    	ivPrice,
	    	ivColors[2],
			iMsg[148];
		tmp = strtok(cmdtext, idx);
		if(!strlen(tmp))
		{
		    return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Usage:{FFFFFF} /vcreate <vmodel> <vprice> <vcolor1> <vcolor2>");
		}
		ivModel = strvalEx(tmp);
		tmp = strtok(cmdtext, idx);
		if(!strlen(tmp))
		{
		    return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Usage:{FFFFFF} /vcreate <vmodel> <vprice> <vcolor1> <vcolor2>");
		}
		ivPrice = strvalEx(tmp);
		tmp = strtok(cmdtext, idx);
		if(!strlen(tmp))
		{
		    return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Usage:{FFFFFF} /vcreate <vmodel> <vprice> <vcolor1> <vcolor2>");
		}
		ivColors[0] = strvalEx(tmp);
		tmp = strtok(cmdtext, idx);
		if(!strlen(tmp))
		{
		    return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Usage:{FFFFFF} /vcreate <vmodel> <vprice> <vcolor1> <vcolor2>");
		}
		ivColors[1] = strvalEx(tmp);
		GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]);
		GetPlayerFacingAngle(playerid, Pos[3]);
		format(string, sizeof(string), "B 0%d%d%d%d%d",random(9),random(9),random(9),random(9),random(9));
		++ Total_Veh_Created;

        vInfo[Total_Veh_Created][vCariD]    = Total_Veh_Created;
		vInfo[Total_Veh_Created][vModel] 	= ivModel;
		vInfo[Total_Veh_Created][vColor1] 	= random(126);
		vInfo[Total_Veh_Created][vColor2] 	= random(126);
		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], string, 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,
		vInfo[Total_Veh_Created][vModel],
		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(string);
		printf("%s",query);

 		new cCar = CreateVehicle(ivModel, Pos[0], Pos[1], Pos[2], Pos[3], ivColors[0], ivColors[1], 500000);
		SetVehicleNumberPlate(cCar, vInfo[cCar][vPlate]);
		OwnedVeh(cCar) = Total_Veh_Created;
		format(iMsg, sizeof(iMsg), ""#CYELLOW"Vehiculul: "#CBLUE"%i (VID: %i) "#CYELLOW"a fost creeat. Pret: "#CBLUE"$%i "#CYELLOW"Plate: "#CBLUE"PG-ZONE", ivModel, Total_Veh_Created, ivPrice);
		SendClientMessage(playerid, -1, iMsg);
		return 1;
	}

 

  • 0
NoNamed Veteran

NoNamed

Posted
Posted

Nu , eu spun : ai facut o functie care sa incarce masinile din baza de date atunci cand server-ul porneste ? Adica pe cele deja existente, sa le seteze playerlor din tabele ...

  • 0
NoNamed Veteran

NoNamed

Posted
Posted

Poi observ ca acel vehicles le incarca doar dupa ce cumperi masina din DS . Dupa restart cum ai facut sa ti le citeasca ?

  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted (edited) 
forward LoadCar();
public LoadCar()
{
    new Query[255];
    mysql_query("SELECT * FROM vehicles"); // Querys the "Query" Variable.
    mysql_store_result(); // Stores the result from Query
    personalcars = mysql_num_rows();
    for(new idx = 1; idx <= personalcars; idx++)
	{
	    format(Query, sizeof(Query), "SELECT * FROM vehicles WHERE id = '%d'", idx);
        mysql_query(Query); // Querys the "Query" Variable.
        mysql_store_result(); // Stores the result from Query
        if(mysql_num_rows()) // Checks if theres anyrow.
        if(mysql_fetch_row_format(Query,"|")) // Splits the row
        {
			sscanf(Query, "p<|>e<iiffffffffiis[182]s[182]iiiiis[255]iiiiiiiiiiiiiiii>",vInfo[idx]);
			masini++;
		}

	}
	printf("> Vehicule personale: %d", masini);
	return 1;
}

 

Edited by jimmi
  • 0
NoNamed Veteran

NoNamed

Posted
Posted (edited)

Este apelata pe undeva acea functie ? La OnPlayerConnect , OnPlayerLogin sau undeva ? Daca nu, adauga asa la OnGamemodeInit :

 

LoadCar();

 

Explicatie : Functia aceasta iti incarca masinile pe server . Daca aceasta functie nu este apelata niciodata ea nu se va executa niciodata, adica nu iti va incarca nici o data nici o masina .

Edited by NoNamed
  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted

Ma nu ai inteles bine problema.Deci cand ma duc pe server la DS sa cumpar o masina.O cumpar imi adauga masina in vehicles apare ca e a mea dar nu am cheie.Cand intru in masina nu apartine nimanui....Ar trebui sa am cheia masini.daca stau /stats la cheie apare 0 semn ca nu am cheia.Nici in db in players>>car 1 2 sau 3 nu se modifica cu cheia masini.Aici mai exact:

if(dialogid == 180 && PlayerInfo[playerid][pCar1] == 999)
                  {
                     PlayerInfo[playerid][pCar1] = idd;
                       format(string, sizeof(string), "UPDATE players SET Car='%d' WHERE id=%d", PlayerInfo[playerid][pCar1], PlayerInfo[playerid][pSQLID]);
                     mysql_query(string);
                     GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                      new string1[128];
                     format(string1, sizeof(string1), "Felicitari! Ai achizitionat un vehicul! Valoare: %d | slot #1]!", vInfo[idd][vPrice]);
                     SendClientMessage(playerid, -1, string1);
                     SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                     return 1;
                  }
                  else if(dialogid == 181)
                  {
                      PlayerInfo[playerid][pCar2] = idd;
                       format(string, sizeof(string), "UPDATE players SET Car2='%d' WHERE id=%d", PlayerInfo[playerid][pCar2], PlayerInfo[playerid][pSQLID]);
                     mysql_query(string);
                     GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                      new string1[128];
                     format(string1, sizeof(string1), "Felicitari! Ai achizitionat o motocicleta!  Valoare: %d | slot #2]!", vInfo[idd][vPrice]);
                     SendClientMessage(playerid, -1, string1);
                     SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                     return 1;
                  }
                   else if(dialogid == 182)
                  {
                        PlayerInfo[playerid][pCar3] = idd;
                          format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]);
                        mysql_query(string);
                         GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                        new string1[128];
                        format(string1, sizeof(string1), "Felicitari! Ai achizitionat o barca! Valoare: %d | slot #3]!", vInfo[idd][vPrice]);
                        SendClientMessage(playerid, -1, string1);
                        SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                        return 1;
                  }
                   else if(dialogid == 183)
                  {
                        PlayerInfo[playerid][pCar3] = idd;
                          format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerInfo[playerid][pCar3], PlayerInfo[playerid][pSQLID]);
                        mysql_query(string);
                         GivePlayerMoneyEx(playerid, - VehDSpret[playerid]);
                        new string1[128];
                        format(string1, sizeof(string1), "Felicitari! Ai achizitionat un avion/elicopter! Valoare: %d | slot #3]!", vInfo[idd][vPrice]);
                        SendClientMessage(playerid, -1, string1);
                        SendClientMessage(playerid, -1, "Tasteaza /vinfo pentru a afla locatia noului tau vehicul!");
                        return 1;
                  }

 

Sper ca ai inteles acuma

Guest
This topic is now closed to further replies.
 Share
Go to question listing
×
×
  • 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.