Ucitavanje Vozila MySQL


Započeo Sef, Jul 08, 2018, 21:35:15 POSLE PODNE

prethodna tema - sledeća tema

0 članova i 1 gost pregledaju ovu temu.

Sef

*

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:
dacu sta bude trebalo

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log)://
Slika/video ingame problema(obavezno ako je ingame problem)://
Poslednja Izmena: Jul 09, 2018, 10:17:13 PRE PODNE od Bašovski
Life Quotes:
"Successful people do what unsuccessful people are not willing to do. Don't wish it were easier; wish you were better."

“To learn something new, you need to try new things and not be afraid to be wrong.”

Sef

*

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
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;
}

OVDJE DOLJE JE LINIJA 25261
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;
}
Poslednja Izmena: Jul 08, 2018, 22:09:59 POSLE PODNE od Sef
Life Quotes:
"Successful people do what unsuccessful people are not willing to do. Don't wish it were easier; wish you were better."

“To learn something new, you need to try new things and not be afraid to be wrong.”

probaj ovako

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

Sef

*

Citat: Ino42O poslato Jul 08, 2018, 23:15:51 POSLE PODNE
probaj ovako

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


Fixao si hvala <3
Life Quotes:
"Successful people do what unsuccessful people are not willing to do. Don't wish it were easier; wish you were better."

“To learn something new, you need to try new things and not be afraid to be wrong.”