Jump to content
  • 0

Nu seteaza corect numele

Jimmi

Asked by Jimmi,

 Share

Question

Jimmi Proficient

Jimmi

Posted
Posted (edited)

Problema intalnita (descriere):Am facut un ds.Imi dadea multe erori la parametri dar le-am rezolvat.Ma duc in joc cumpar o masina/avion dar nu imi da masina...
Ero(area / rile) / warning-(ul / urile):-
Liniile de cod / sursa / script-ul(obligatoriu):

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];
                  }
                  vInfo[idd][vOwner] = 1;
                  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;
         }
      }

Imagini / Video (optional):
[17:16:22] CMySQLHandler::Query(UPDATE vehicles SET Owner='nbought' WHERE CarID=1) - Successfully executed.

[17:16:22] >> mysql_query( Connection handle: 1 )

Ati incercat sa rezolvati singur?:da

Edited by jimmi
Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0
Ath9 Collaborator

Ath9

Posted
Posted

dar avionul ti-l da? glumesc. Vezi daca ai in baza de date coloana "vehicles" unde vad ca ti se salveaza masinile.

Respect acestei comunitati, dar mai presus respect membrilor ei !

Link to comment
Share on other sites
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.