Balkan SA:MP

PAWN skriptanje, gamemodovi, filterskripte, include fajlovi, mape, pluginovi => Razgovor u vezi PAWN - skriptanja => Temu započeo: Sef poslato Jul 08, 2018, 21:35:15 POSLE PODNE

Naslov: Ucitavanje Vozila MySQL
Poruka od: Sef poslato Jul 08, 2018, 21:35:15 POSLE PODNE
Problem(error/warning): Ovako koristim Imperium Gaming mod od dimia u mysqlu i imam problem sa privatnim vozilima znaci ovako ja kupim vozilo u salonu i ja kad kucam /v nalazi se tu vozilo i sve je uredu medjutim kad se disconnectujem i kad se opet konektujem to vozilo se despawnuje(to je napravljeno zbog limita valjda) i kad kucam /v pise da nemam nikakvo vozilo medjutim u bazi se to vozilo nalazi i pise da sam ja vlasnik pa me sad zanima kako da fixam to
Dio skripte: [pawn]dacu sta bude trebalo[/pawn]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log)://
Slika/video ingame problema(obavezno ako je ingame problem)://
Naslov: Odg: Ucitavanje Vozila MySQL
Poruka od: Sef poslato Jul 08, 2018, 22:07:01 POSLE PODNE
Izvinjavam se sto radim DP al evo sad mi je skripta ispisala errore kad sam se spawnao zasto nije mogla da loada vozila evo errora:
[19:59:40] [debug] Run time error 4: "Array index out of bounds"
[19:59:40] [debug]  Attempted to read/write array element at index 65535 in array of size 2000
[19:59:40] [debug] AMX backtrace:
[19:59:40] [debug] #0 0047a83c in public KGEyes_CreateVehicle (modelid=1, Float:x=1.00000, Float:y=1.00000, Float:z=2.00000, Float:angle=1.00000, color1=1, color2=1, respawn_delay=300000) at C:\Users\karan\Desktop\mod\gamemodes\IG.pwn:6203
[19:59:40] [debug] #1 005ed340 in public OnPlayerVehiclesLoad (playerid=0) at C:\Users\karan\Desktop\mod\gamemodes\IG.pwn:25261

OVDJE DOLJE JE LINIJA 6203
[pawn]
forward KGEyes_CreateVehicle( modelid, Float:x, Float:y, Float:z, Float:angle, color1, color2, respawn_delay );
public KGEyes_CreateVehicle( modelid, Float:x, Float:y, Float:z, Float:angle, color1, color2, respawn_delay ) {

   if( ServerInfo[ BrojKreiranihVozila ] <= MaxBrojKreiranih ) {
      ServerInfo[ BrojKreiranihVozila ]++;
      new idKreiranog;

      if( color1 < 0 || color2 < 0 ) {
          color1 = random(127);
             color2 = random(127);
        }

      if( modelid == 538 ) {
           idKreiranog = AddStaticVehicleEx( modelid, Float:x, Float:y, Float:z, Float:angle, color1, color2, respawn_delay );
      }
      else {
         idKreiranog = CreateVehicle( modelid, Float:x, Float:y, Float:z, Float:angle, color1, color2, respawn_delay );
      }

        new colorStr[24] ;
        format(colorStr, sizeof(colorStr), "%d-%d", color1, color2);
        setproperty(_, "", PROPERTY_OFFSET(idKreiranog), colorStr);

      RealVehiclePositions[ idKreiranog ][ 0 ] = x; // LINIJA 6023
      RealVehiclePositions[ idKreiranog ][ 1 ] = y;
      RealVehiclePositions[ idKreiranog ][ 2 ] = z;

      BusyVehicle[ idKreiranog ] = -1;
      garbagemanVehicles[ idKreiranog ][ gPlayerID ] = -1;
      return idKreiranog;

   } else return -1;
}
[/pawn]
OVDJE DOLJE JE LINIJA 25261
[pawn]forward OnPlayerVehiclesLoad( playerid );
public OnPlayerVehiclesLoad( playerid ) {

    new rows, vehicleid;
      cache_get_row_count(rows);

   if( rows ) {
      for( new i = 0; i < rows; i ++ ){

            if( ServerInfo[ BrojKreiranihVozila ] > MaxBrojKreiranih ) return SCM( playerid, ANTICHEAT, "[ANTICHEAT]"col_white" Nemoguce je trenutno kreirati vasa vozila, limit vozila na serveru je dosegnut.");

            cache_get_value_name_int( i, "v_model", VehicleInfo[ i ][ vModel ] );
            cache_get_value_name_float( i, "v_pos_x", VehicleInfo[ i ][ vLokacijaX ] );
            cache_get_value_name_float( i, "v_pos_y", VehicleInfo[ i ][ vLokacijaY ] );
            cache_get_value_name_float( i, "v_pos_z", VehicleInfo[ i ][ vLokacijaZ ] );
            cache_get_value_name_float( i, "v_pos_a", VehicleInfo[ i ][ vLokacijaA ] );
            cache_get_value_name_int( i, "v_color_1", VehicleInfo[ i ][ vColor1 ] );
            cache_get_value_name_int( i, "v_color_2", VehicleInfo[ i ][ vColor2 ] );

            vehicleid = KGEyes_CreateVehicle( cache_get_value_name_int( i, "v_model", VehicleInfo[ i ][ vModel ] ), //25261 LINIJA
                                    cache_get_value_name_float( i, "v_pos_x", VehicleInfo[ i ][ vLokacijaX ] ),
                                    cache_get_value_name_float( i, "v_pos_y", VehicleInfo[ i ][ vLokacijaY ] ),
                                    cache_get_value_name_float( i, "v_pos_z", VehicleInfo[ i ][ vLokacijaZ ] )+1.0,
                                    cache_get_value_name_float( i, "v_pos_a", VehicleInfo[ i ][ vLokacijaA ] ),
                                    cache_get_value_name_int( i, "v_color_1", VehicleInfo[ i ][ vColor1 ] ),
                                    cache_get_value_name_int( i, "v_color_2", VehicleInfo[ i ][ vColor2 ] ), 300000 );

            cache_get_value_name_int( i, "veh_id", VehicleInfo[ vehicleid ][ vSqlID ] );
         cache_get_value_name_int( i, "owner_sqlID", VehicleInfo[ vehicleid ][ vOwner_sqlID ] );
         strmid( VehicleInfo[ vehicleid ][ vOwner ], ImeIgraca( playerid ), 0, strlen( ImeIgraca( playerid ) ), 24);
         cache_get_value_name_int( i, "v_price", VehicleInfo[ vehicleid ][ vPrice ] );
         cache_get_value_name_int( i, "v_locked", VehicleInfo[ vehicleid ][ vLocked ] );
         cache_get_value_name_float( i, "v_pos_x", VehicleInfo[ vehicleid ][ vLokacijaX ] );
         cache_get_value_name_float( i, "v_pos_y", VehicleInfo[ vehicleid ][ vLokacijaY ] );
         cache_get_value_name_float( i, "v_pos_z", VehicleInfo[ vehicleid ][ vLokacijaZ ] );
         cache_get_value_name_float( i, "v_pos_a", VehicleInfo[ vehicleid ][ vLokacijaA ] );
         cache_get_value_name_int( i, "v_virtualw", VehicleInfo[ vehicleid ][ vVirtualWorld ] );
         cache_get_value_name_int( i, "v_interior", VehicleInfo[ vehicleid ][ vInterior ] );
         cache_get_value_name_int( i, "v_usage", VehicleInfo[ vehicleid ][ vUsage ] );
         cache_get_value_name_int( i, "v_organization", VehicleInfo[ vehicleid ][ vOrganizationSQLID ] );
         VehicleInfo[ vehicleid ][ vOrganization ] = -1;
         cache_get_value_name_int( i, "v_job", VehicleInfo[ vehicleid ][ vJob ] );
         cache_get_value_name_int( i, "v_fuel_station", VehicleInfo[ vehicleid ][ vFuelStation ] );
         cache_get_value_name_int( i, "v_color_1", VehicleInfo[ vehicleid ][ vColor1 ] );
         cache_get_value_name_int( i, "v_color_2", VehicleInfo[ vehicleid ][ vColor2 ] );
         cache_get_value_name_int( i, "v_model", VehicleInfo[ vehicleid ][ vModel ] );
         cache_get_value_name_int( i, "v_teh", VehicleInfo[ vehicleid ][ vTeh ] );
         cache_get_value_name_int( i, "v_reg", VehicleInfo[ vehicleid ][ vReg ] );
         cache_get_value_name_int( i, "v_reg_vreme", VehicleInfo[ vehicleid ][ vRegVreme ] );
         cache_get_value_name( i, "v_tablice", VehicleInfo[ vehicleid ][ vTablice ], 16 );
         cache_get_value_name_int( i, "v_gps", VehicleInfo[ vehicleid ][ vGPS ] );
         cache_get_value_name_int( i, "v_insurance", VehicleInfo[ vehicleid ][ vOsiguranje ] );
         cache_get_value_name_int( i, "v_lock", VehicleInfo[ vehicleid ][ vLock ] );
         cache_get_value_name_int( i, "v_alarm", VehicleInfo[ vehicleid ][ vAlarm ] );
         cache_get_value_name_int( i, "v_fuel", VehicleInfo[ vehicleid ][ vFuel ] );
         cache_get_value_name_int( i, "v_fuel_type", VehicleInfo[ vehicleid ][ vFuelType ] );
         cache_get_value_name_int( i, "v_neon", VehicleInfo[ vehicleid ][ vNeon ] );
          cache_get_value_name_int( i, "v_tuned", VehicleInfo[ vehicleid ][ vTuned ] );
         cache_get_value_name_int( i, "v_imobilizator", VehicleInfo[ vehicleid ][ vImobilizator ] );
         cache_get_value_name_int( i, "v_spoiler", VehicleInfo[ vehicleid ][ vSpoiler ] );
         cache_get_value_name_int( i, "v_hood", VehicleInfo[ vehicleid ][ vHood ] );
         cache_get_value_name_int( i, "v_roof", VehicleInfo[ vehicleid ][ vRoof ] );
         cache_get_value_name_int( i, "v_skirt", VehicleInfo[ vehicleid ][ vSkirt ] );
         cache_get_value_name_int( i, "v_lamps", VehicleInfo[ vehicleid ][ vLamps ] );
         cache_get_value_name_int( i, "v_nitro", VehicleInfo[ vehicleid ][ vNitro ] );
         cache_get_value_name_int( i, "v_exhaust", VehicleInfo[ vehicleid ][ vExhaust ] );
         cache_get_value_name_int( i, "v_wheels", VehicleInfo[ vehicleid ][ vWheels ] );
         cache_get_value_name_int( i, "v_stereo", VehicleInfo[ vehicleid ][ vStereo ] );
         cache_get_value_name_int( i, "v_hydraulics", VehicleInfo[ vehicleid ][ vHydraulics ] );
         cache_get_value_name_int( i, "v_front_bumper", VehicleInfo[ vehicleid ][ vFrontBumper ] );
         cache_get_value_name_int( i, "v_rear_bumper", VehicleInfo[ vehicleid ][ vRearBumper ] );
         cache_get_value_name_int( i, "v_vents", VehicleInfo[ vehicleid ][ vVents ] );
         cache_get_value_name_int( i, "v_paintjob", VehicleInfo[ vehicleid ][ vPaintJob ] );
         cache_get_value_name_int( i, "v_drug_ammount_1", VehicleInfo[ vehicleid ][ vDrugAmmount ][ 0 ] );
         cache_get_value_name_int( i, "v_drug_ammount_2", VehicleInfo[ vehicleid ][ vDrugAmmount ][ 1 ] );
         cache_get_value_name_int( i, "v_drug_ammount_3", VehicleInfo[ vehicleid ][ vDrugAmmount ][ 2 ] );
         cache_get_value_name_int( i, "v_drug_ammount_4", VehicleInfo[ vehicleid ][ vDrugAmmount ][ 3 ] );
         cache_get_value_name_int( i, "v_drug_ammount_5", VehicleInfo[ vehicleid ][ vDrugAmmount ][ 4 ] );
         cache_get_value_name_int( i, "v_drug_ammount_6", VehicleInfo[ vehicleid ][ vDrugAmmount ][ 5 ] );
         cache_get_value_name_int( i, "v_mats", VehicleInfo[ vehicleid ][ vMaterijali ] );
         cache_get_value_name_int( i, "v_weapon_melee", VehicleInfo[ vehicleid ][ vMelee ] );
         cache_get_value_name_int( i, "v_weapon_slot_1", VehicleInfo[ vehicleid ][ vWeap1 ] );
         cache_get_value_name_int( i, "v_weapon_ammo_1", VehicleInfo[ vehicleid ][ vAmmo1 ] );
         cache_get_value_name_int( i, "v_weapon_slot_2", VehicleInfo[ vehicleid ][ vWeap2 ] );
         cache_get_value_name_int( i, "v_weapon_ammo_2", VehicleInfo[ vehicleid ][ vAmmo2 ] );
         cache_get_value_name_int( i, "v_gajbica_slot_1", VehicleInfo[ vehicleid ][ vGajbica ][ 0 ] );
         cache_get_value_name_int( i, "v_gajbica_slot_2", VehicleInfo[ vehicleid ][ vGajbica ][ 1 ] );
         cache_get_value_name_int( i, "v_gajbica_slot_3", VehicleInfo[ vehicleid ][ vGajbica ][ 2 ] );
         cache_get_value_name_int( i, "v_gajbica_slot_4", VehicleInfo[ vehicleid ][ vGajbica ][ 3 ] );
         cache_get_value_name_int( i, "v_gajbica_slot_5", VehicleInfo[ vehicleid ][ vGajbica ][ 4 ] );
         cache_get_value_name_int( i, "v_gajbica_kolicina_1", VehicleInfo[ vehicleid ][ vGajbicaAmmount ][ 0 ] );
         cache_get_value_name_int( i, "v_gajbica_kolicina_2", VehicleInfo[ vehicleid ][ vGajbicaAmmount ][ 1 ] );
         cache_get_value_name_int( i, "v_gajbica_kolicina_3", VehicleInfo[ vehicleid ][ vGajbicaAmmount ][ 2 ] );
         cache_get_value_name_int( i, "v_gajbica_kolicina_4", VehicleInfo[ vehicleid ][ vGajbicaAmmount ][ 3 ] );
         cache_get_value_name_int( i, "v_gajbica_kolicina_5", VehicleInfo[ vehicleid ][ vGajbicaAmmount ][ 4 ] );
         cache_get_value_name_int( i, "v_kilometri", VehicleInfo[ vehicleid ][ vKilometri ] );
         cache_get_value_name_int( i, "v_metri", VehicleInfo[ vehicleid ][ vMetri ] );
         VehicleInfo[ vehicleid ][ v_owner_id ] = playerid;

         LinkVehicleToInterior( vehicleid, VehicleInfo[ vehicleid ][ vInterior ] );
           SetVehicleVirtualWorld( vehicleid, VehicleInfo[ vehicleid ][ vVirtualWorld ] );
         vCanDrive[ vehicleid ] = 1;

              VehicleInfo[ vehicleid ][ Validv3DText ] = false;
          if( VehicleInfo[ vehicleid ][ vFuelType ] == 0 ) {

            if( Diesel( vehicleid ) ) VehicleInfo[ vehicleid ][ vFuelType ] = 1;
            else if( Gasoline( vehicleid ) ) VehicleInfo[ vehicleid ][ vFuelType ] = 2;
            else if( GasOil( vehicleid ) ) VehicleInfo[ vehicleid ][ vFuelType ] = 3;
         }

           SetVehicleParamsEx( vehicleid, 0, 0, 0, VehicleInfo[ vehicleid ][ vLocked ], 0, 0, 0 );
           if( IsVehicleBajs( vehicleid ) ) {
            SetVehicleParamsEx( vehicleid, 1, 0, 0, VehicleInfo[ vehicleid ][ vLocked ], 0, 0, 0 );
         }
           ResetVehicleStatistics( vehicleid );
         VehicleInfo[ vehicleid ][ vFuel ] = getAmountFuel( vehicleid );

          Fuel[ vehicleid ] = VehicleInfo[ vehicleid ][ vFuel ];

         SetVehicleLabels( vehicleid );

         if( VehicleInfo[ vehicleid ][ vReg ] == 1 ) {
            SetTablice( vehicleid );
         }
         else if( VehicleInfo[ vehicleid ][ vReg ] == 2 ) {
            SetVehicleNumberPlate( vehicleid, VehicleInfo[ vehicleid ][ vTablice ] );
         }
         else  {
            SetVehicleNumberPlate( vehicleid, "NEMA" );
         }

         TuneVehicle( vehicleid );

            for( new j = 0; j < MAX_VEH_SLOT; j ++ ){
                if( (j+1) <= PlayerInfo[ playerid ][ xSlotoviVozila ] && player_veh[ playerid ][ vehicle_id ][ j ] == -1 ) {
               player_veh[ playerid ][ vehicle_id ][ j ] = vehicleid;
               break;
            }
         }
      }
   }
   return true;
}[/pawn]
Naslov: Odg: Ucitavanje Vozila MySQL
Poruka od: Ino42O poslato Jul 08, 2018, 23:15:51 POSLE PODNE
probaj ovako

[pawn]
vehicleid = KGEyes_CreateVehicle(
   VehicleInfo[vModel],
   VehicleInfo[vLokacijaX],
   VehicleInfo[vLokacijaY],
   VehicleInfo[vLokacijaZ] + 1.0,
   VehicleInfo[vLokacijaA],
   VehicleInfo[vColor1],
   VehicleInfo[vColor2],
   300000
);

[/pawn]
Naslov: Odg: Ucitavanje Vozila MySQL
Poruka od: Sef poslato Jul 08, 2018, 23:24:43 POSLE PODNE
Citat: Ino42O poslato Jul 08, 2018, 23:15:51 POSLE PODNE
probaj ovako

[pawn]
vehicleid = KGEyes_CreateVehicle(
   VehicleInfo[vModel],
   VehicleInfo[vLokacijaX],
   VehicleInfo[vLokacijaY],
   VehicleInfo[vLokacijaZ] + 1.0,
   VehicleInfo[vLokacijaA],
   VehicleInfo[vColor1],
   VehicleInfo[vColor2],
   300000
);

[/pawn]

Fixao si hvala <3
Naslov: Odg: Ucitavanje Vozila MySQL
Poruka od: Tosic ツ poslato Jul 09, 2018, 00:24:09 PRE PODNE
Opet kazem da se manete tog moda ako nemate bar osnove..

http://balkan-samp.com/forum/index.php?topic=121699.msg840680#msg840680