Neler yeni

Foruma hoş geldin, Ziyaretçi

Forum içeriğine ve tüm hizmetlerimize erişim sağlamak için foruma kayıt olmalı ya da giriş yapmalısınız. Foruma üye olmak tamamen ücretsizdir.

Türkiye'nin İlk ve tek FiveM forum adresi

Forum adresimize hoş geldin FiveMTürk olarak amacımız siz değerli kullanıcılarımıza en aktif fikir ve paylaşım platformu sunmak bir yana en güvenilir şekilde alışveriş yapabileceğiniz bir platform sunmaktır.
DF DF
DF DF
DF DF

Cevaplandı Fivem 2.Galeri Scripti Nasıl yapılabilir.

Osker35

Üye
FT Kullanıcı
Katılım
4 yıl 6 gün
Mesajlar
44
Merhaba fivem sunucumda bir modlu araçlar için ve bir tane de normal araçlar için galeri yaptım ama sıkıntı şu yaptığım 2 .galeri çalışmadı yanı ayrı ayrı galeri yapamadım sadece bir galeri var gözüküyor discordum bu Osker#8003 eğer benim için esx_vehicleshop üzerinden yapabilecek varsa ricam ederim iletişime geçsin. Anlatabilir de!
 
DF
55178 1622545489462.png Hazır ymapim var kordinatları yazdım ama bunla karşı karşıyayım
 
DF
ESX = nil
local secilenKonum = nil
local isleniyor = false
local npc = vector3(-808.27, -207.95, 36.50)
local carPos = vector3(-785.9, -242.56, 36.40)
Citizen.CreateThread(function()
while ESX == nil do
TriggerEvent('esx:getSharedObject', function(obj) ESX = obj end)
Citizen.Wait(1)
end
end)
Citizen.CreateThread(function()
local blip = AddBlipForCoord(vector3(-808.27, -207.95, 36.50))
SetBlipSprite(blip, 85)
SetBlipDisplay(blip, 2)
SetBlipScale(blip, 0.7)
SetBlipColour(blip, 29)
SetBlipAsShortRange(blip, true)
BeginTextCommandSetBlipName("STRING")
AddTextComponentString("Lüks Galeri")
EndTextCommandSetBlipName(blip)
end)
Citizen.CreateThread(function()
while true do
Citizen.Wait(1)
local playerPed = PlayerPedId()
local pedCoords = GetEntityCoords(playerPed)
local distance = #(pedCoords - npc)
if distance < 20 then
DrawMarker(2, npc.x, npc.y, npc.z-0.5, 0, 0, 0, 0, 0, 0, 0.2, 0.2, 0.2, 32, 236, 54, 100, 0, 0, 0, 1, 0, 0, 0)
if distance < 2 then
DrawText3D(npc.x, npc.y, npc.z, "[E] - 2. El Arac Magazasi", 0.3)
if IsControlJustReleased(0, 38) then
openMenu()
end
end
end
end
end)
function DrawText3D(x, y, z, text, scale)
local onScreen, _x, _y = World3dToScreen2d(x, y, z)
local pX, pY, pZ = table.unpack(GetGameplayCamCoords())

SetTextScale(scale, scale)
SetTextFont(4)
SetTextProportional(1)
SetTextEntry("STRING")
SetTextCentre(1)
SetTextColour(255, 255, 255, 215)

AddTextComponentString(text)
DrawText(_x, _y)

local factor = (string.len(text)) / 330
DrawRect(_x, _y + 0.0150, 0.0 + factor, 0.035, 41, 11, 41, 100)
end
function openMenu()
ESX.UI.Menu.CloseAll()
ESX.UI.Menu.Open('default', GetCurrentResourceName(), 'carMenu',
{
title = 'İkinci El Araç Satış',
align = 'left',
elements = {
{label = "Araç Satın Al", value = "buy"},
{label = "Aracını Satış Listesine Ekle", value = "sell"},
{label = "Satılığa Koyduğum Araçlar", value = "my_sell"}
}
},function(data, menu)
if data.current.value == "buy" then
buyCar()
elseif data.current.value == "sell" then
sellCar()
elseif data.current.value == "my_sell" then
mySellCar()
end
end, function(data, menu)
menu.close()
end)
end
function mySellCar()
local elements = {}
ESX.TriggerServerCallback('haze-ikinciel:my-sell-car', function(myCars)
if myCars then
for _, car in pairs(myCars) do
local carModelName = GetDisplayNameFromVehicleModel(json.decode(car.prop).model)
local plate = car.plate
table.insert(elements, {label = carModelName .. " " .. plate, value = plate})
end
else
table.insert(elements, {label = "Satılığa koyduğun herhangi bir aracın yok!"})
end
ESX.UI.Menu.Open('default', GetCurrentResourceName(), 'car_sell_menu',
{
title = 'Aracını Satıştan Kaldır',
align = 'left',
elements = elements
}, function(data, menu)
ESX.UI.Menu.CloseAll()
TriggerServerEvent("haze-ikinciel:delete-list", data.current.value)
end, function(data, menu)
menu.close()
end)
end)
end
function sellCar()
local elements = {}
ESX.TriggerServerCallback('haze-ikinciel:player-car', function(myCars)
if myCars then
for _, car in pairs(myCars) do
local carModelName = GetDisplayNameFromVehicleModel(json.decode(car.vehicle).model)
local plate = car.plate
local prop = car.vehicle
table.insert(elements, {label = carModelName .. " " .. plate, value = plate, prop = prop})
end
else
table.insert(elements, {label = "Satabileceğin bir aracın yok."})
end
ESX.UI.Menu.Open('default', GetCurrentResourceName(), 'car_sell_menu',
{
title = 'Araç Satış',
align = 'left',
elements = elements
}, function(data2, menu2)
ESX.UI.Menu.CloseAll()
if data2.current.value then
openPriceMenu(data2.current.value, data2.current.prop)
end
end, function(data2, menu2)
menu2.close()
end)
end)
end
function openPriceMenu(plate, prop)
ESX.UI.Menu.Open('dialog', GetCurrentResourceName(), 'sell_car_input_menu',
{
title = "Aracın Satış Fiyatı"
},
function(data3, menu3)
local sellPrice = tonumber(data3.value)
if type(sellPrice) == "number" then
TriggerServerEvent("haze-ikinciel:sell-car", sellPrice, plate, prop)
local gameVehicles = ESX.Game.GetVehicles()
for i = 1, #gameVehicles do
local vehicle = gameVehicles
if DoesEntityExist(vehicle) then
if trim(GetVehicleNumberPlateText(vehicle)) == trim(plate) then
ESX.Game.DeleteVehicle(vehicle)
break
end
end
end
else
ESX.ShowNotification("Hatalı miktar!", "error")
end
menu3.close()
end, function(data3, menu3)
menu3.close()
end)
end
local createdCamera = 0
function buyCar()
local elements = {}
local playerPed = PlayerPedId()
createdCamera = CreateCam("DEFAULT_SCRIPTED_CAMERA", 1)
SetCamCoord(createdCamera, -71.62, 75.67, 73.61)
SetCamRot(createdCamera, -25.0, 0.0, 98.0, 2)
RenderScriptCams(1, 0, 0, 1, 1)
ESX.TriggerServerCallback('haze-ikinciel:car-list', function(listedCars)
if listedCars then
for _, car in pairs(listedCars) do
local carModel = json.decode(car.prop).model
local carModelName = GetDisplayNameFromVehicleModel(carModel)
local plate = car.plate
local prop = json.decode(car.prop)
local price = car.price
local ownerId = car.owner
if _ == 1 then
WaitForVehicleToLoad(carModel)
ESX.Game.SpawnLocalVehicle(carModel, carPos, 210.0, function(vehicle)
FreezeEntityPosition(vehicle, true)
ESX.Game.SetVehicleProperties(vehicle, prop)
SetModelAsNoLongerNeeded(carModel)
TriggerEvent("x-hotwire:give-keys", vehicle)
end)
end
table.insert(elements, {label = carModelName .. " " .. plate .. " $" .. ESX.Math.GroupDigits(price), value = plate, prop = prop, price = price, owner = ownerId, model = carModel})
end
else
table.insert(elements, {label = "Satılık hiç bir araç yok"})
end
ESX.UI.Menu.Open('default', GetCurrentResourceName(), 'car_sell_menu',
{
title = 'Araç Satın Al',
align = 'left',
elements = elements
}, function(data4, menu4)
ESX.UI.Menu.CloseAll()
if data4.current.value then
ESX.UI.Menu.Open( 'default', GetCurrentResourceName(), 'menuname',
{
title = ('Onaylıyor musunuz?'),
align = 'top-left',
elements = {
{label = ('Satın Al '..data4.current.price.."$" ), value = 1},
{label = ('Geri Dön'), value = 2},
}
},
function(data5, menu5)
if data5.current.value == 1 then
menu5.close()
TriggerServerEvent("haze-ikinciel:buy-car", data4.current.value, data4.current.price, data4.current.owner)
elseif data5.current.value == 2 then
menu5.close()
buyCar()
end
end,
function(data5, menu5)
menu5.close()
end
)
end
end,function(data4, menu4)
-- esc
menu4.close()
DeleteDisplayVehicleInsideShop()
DestroyCam(createdCamera, 0)
RenderScriptCams(0, 0, 1, 1, 1)
createdCamera = 0
end,function(data4, menu4)
--aşağı yukar
local vehicleData = data4.current
if vehicleData.value then
DeleteDisplayVehicleInsideShop()
WaitForVehicleToLoad(vehicleData.model)
ESX.Game.SpawnLocalVehicle(vehicleData.model, carPos, 210.0, function(vehicle)
FreezeEntityPosition(vehicle, true)
ESX.Game.SetVehicleProperties(vehicle, vehicleData.prop)
SetModelAsNoLongerNeeded(vehicleData.model)
end)
end
end, function(data4, menu4)
--enter
DeleteDisplayVehicleInsideShop()
DestroyCam(createdCamera, 0)
RenderScriptCams(0, 0, 1, 1, 1)
createdCamera = 0
end)
end)
end
function WaitForVehicleToLoad(modelHash)
modelHash = (type(modelHash) == 'number' and modelHash or GetHashKey(modelHash))
if not HasModelLoaded(modelHash) then
RequestModel(modelHash)
BeginTextCommandBusyspinnerOn('STRING')
AddTextComponentSubstringPlayerName("Araç Yükleniyor...")
EndTextCommandBusyspinnerOn(4)
while not HasModelLoaded(modelHash) do
Citizen.Wait(0)
DisableAllControlActions(0)
end
BusyspinnerOff()
end
end
function DeleteDisplayVehicleInsideShop()
local vehicle, distance = ESX.Game.GetClosestVehicle(carPos)
if distance < 4 then
if DoesEntityExist(vehicle) then
ESX.Game.DeleteVehicle(vehicle)
end
end
end
function trim(value)
if value then
return (string.gsub(value, "^%s*(.-)%s*$", "%1"))
else
return nil
end
end
 
DF
ESX = nil
local secilenKonum = nil
local isleniyor = false
local npc = vector3(-808.27, -207.95, 36.50)
local carPos = vector3(-785.9, -242.56, 36.40)
Citizen.CreateThread(function()
while ESX == nil do
TriggerEvent('esx:getSharedObject', function(obj) ESX = obj end)
Citizen.Wait(1)
end
end)
Citizen.CreateThread(function()
local blip = AddBlipForCoord(vector3(-808.27, -207.95, 36.50))
SetBlipSprite(blip, 85)
SetBlipDisplay(blip, 2)
SetBlipScale(blip, 0.7)
SetBlipColour(blip, 29)
SetBlipAsShortRange(blip, true)
BeginTextCommandSetBlipName("STRING")
AddTextComponentString("Lüks Galeri")
EndTextCommandSetBlipName(blip)
end)
Citizen.CreateThread(function()
while true do
Citizen.Wait(1)
local playerPed = PlayerPedId()
local pedCoords = GetEntityCoords(playerPed)
local distance = #(pedCoords - npc)
if distance < 20 then
DrawMarker(2, npc.x, npc.y, npc.z-0.5, 0, 0, 0, 0, 0, 0, 0.2, 0.2, 0.2, 32, 236, 54, 100, 0, 0, 0, 1, 0, 0, 0)
if distance < 2 then
DrawText3D(npc.x, npc.y, npc.z, "[E] - 2. El Arac Magazasi", 0.3)
if IsControlJustReleased(0, 38) then
openMenu()
end
end
end
end
end)
function DrawText3D(x, y, z, text, scale)
local onScreen, _x, _y = World3dToScreen2d(x, y, z)
local pX, pY, pZ = table.unpack(GetGameplayCamCoords())

SetTextScale(scale, scale)
SetTextFont(4)
SetTextProportional(1)
SetTextEntry("STRING")
SetTextCentre(1)
SetTextColour(255, 255, 255, 215)

AddTextComponentString(text)
DrawText(_x, _y)

local factor = (string.len(text)) / 330
DrawRect(_x, _y + 0.0150, 0.0 + factor, 0.035, 41, 11, 41, 100)
end
function openMenu()
ESX.UI.Menu.CloseAll()
ESX.UI.Menu.Open('default', GetCurrentResourceName(), 'carMenu',
{
title = 'İkinci El Araç Satış',
align = 'left',
elements = {
{label = "Araç Satın Al", value = "buy"},
{label = "Aracını Satış Listesine Ekle", value = "sell"},
{label = "Satılığa Koyduğum Araçlar", value = "my_sell"}
}
},function(data, menu)
if data.current.value == "buy" then
buyCar()
elseif data.current.value == "sell" then
sellCar()
elseif data.current.value == "my_sell" then
mySellCar()
end
end, function(data, menu)
menu.close()
end)
end
function mySellCar()
local elements = {}
ESX.TriggerServerCallback('haze-ikinciel:my-sell-car', function(myCars)
if myCars then
for _, car in pairs(myCars) do
local carModelName = GetDisplayNameFromVehicleModel(json.decode(car.prop).model)
local plate = car.plate
table.insert(elements, {label = carModelName .. " " .. plate, value = plate})
end
else
table.insert(elements, {label = "Satılığa koyduğun herhangi bir aracın yok!"})
end
ESX.UI.Menu.Open('default', GetCurrentResourceName(), 'car_sell_menu',
{
title = 'Aracını Satıştan Kaldır',
align = 'left',
elements = elements
}, function(data, menu)
ESX.UI.Menu.CloseAll()
TriggerServerEvent("haze-ikinciel:delete-list", data.current.value)
end, function(data, menu)
menu.close()
end)
end)
end
function sellCar()
local elements = {}
ESX.TriggerServerCallback('haze-ikinciel:player-car', function(myCars)
if myCars then
for _, car in pairs(myCars) do
local carModelName = GetDisplayNameFromVehicleModel(json.decode(car.vehicle).model)
local plate = car.plate
local prop = car.vehicle
table.insert(elements, {label = carModelName .. " " .. plate, value = plate, prop = prop})
end
else
table.insert(elements, {label = "Satabileceğin bir aracın yok."})
end
ESX.UI.Menu.Open('default', GetCurrentResourceName(), 'car_sell_menu',
{
title = 'Araç Satış',
align = 'left',
elements = elements
}, function(data2, menu2)
ESX.UI.Menu.CloseAll()
if data2.current.value then
openPriceMenu(data2.current.value, data2.current.prop)
end
end, function(data2, menu2)
menu2.close()
end)
end)
end
function openPriceMenu(plate, prop)
ESX.UI.Menu.Open('dialog', GetCurrentResourceName(), 'sell_car_input_menu',
{
title = "Aracın Satış Fiyatı"
},
function(data3, menu3)
local sellPrice = tonumber(data3.value)
if type(sellPrice) == "number" then
TriggerServerEvent("haze-ikinciel:sell-car", sellPrice, plate, prop)
local gameVehicles = ESX.Game.GetVehicles()
for i = 1, #gameVehicles do
local vehicle = gameVehicles
if DoesEntityExist(vehicle) then
if trim(GetVehicleNumberPlateText(vehicle)) == trim(plate) then
ESX.Game.DeleteVehicle(vehicle)
break
end
end
end
else
ESX.ShowNotification("Hatalı miktar!", "error")
end
menu3.close()
end, function(data3, menu3)
menu3.close()
end)
end
local createdCamera = 0
function buyCar()
local elements = {}
local playerPed = PlayerPedId()
createdCamera = CreateCam("DEFAULT_SCRIPTED_CAMERA", 1)
SetCamCoord(createdCamera, -71.62, 75.67, 73.61)
SetCamRot(createdCamera, -25.0, 0.0, 98.0, 2)
RenderScriptCams(1, 0, 0, 1, 1)
ESX.TriggerServerCallback('haze-ikinciel:car-list', function(listedCars)
if listedCars then
for _, car in pairs(listedCars) do
local carModel = json.decode(car.prop).model
local carModelName = GetDisplayNameFromVehicleModel(carModel)
local plate = car.plate
local prop = json.decode(car.prop)
local price = car.price
local ownerId = car.owner
if _ == 1 then
WaitForVehicleToLoad(carModel)
ESX.Game.SpawnLocalVehicle(carModel, carPos, 210.0, function(vehicle)
FreezeEntityPosition(vehicle, true)
ESX.Game.SetVehicleProperties(vehicle, prop)
SetModelAsNoLongerNeeded(carModel)
TriggerEvent("x-hotwire:give-keys", vehicle)
end)
end
table.insert(elements, {label = carModelName .. " " .. plate .. " $" .. ESX.Math.GroupDigits(price), value = plate, prop = prop, price = price, owner = ownerId, model = carModel})
end
else
table.insert(elements, {label = "Satılık hiç bir araç yok"})
end
ESX.UI.Menu.Open('default', GetCurrentResourceName(), 'car_sell_menu',
{
title = 'Araç Satın Al',
align = 'left',
elements = elements
}, function(data4, menu4)
ESX.UI.Menu.CloseAll()
if data4.current.value then
ESX.UI.Menu.Open( 'default', GetCurrentResourceName(), 'menuname',
{
title = ('Onaylıyor musunuz?'),
align = 'top-left',
elements = {
{label = ('Satın Al '..data4.current.price.."$" ), value = 1},
{label = ('Geri Dön'), value = 2},
}
},
function(data5, menu5)
if data5.current.value == 1 then
menu5.close()
TriggerServerEvent("haze-ikinciel:buy-car", data4.current.value, data4.current.price, data4.current.owner)
elseif data5.current.value == 2 then
menu5.close()
buyCar()
end
end,
function(data5, menu5)
menu5.close()
end
)
end
end,function(data4, menu4)
-- esc
menu4.close()
DeleteDisplayVehicleInsideShop()
DestroyCam(createdCamera, 0)
RenderScriptCams(0, 0, 1, 1, 1)
createdCamera = 0
end,function(data4, menu4)
--aşağı yukar
local vehicleData = data4.current
if vehicleData.value then
DeleteDisplayVehicleInsideShop()
WaitForVehicleToLoad(vehicleData.model)
ESX.Game.SpawnLocalVehicle(vehicleData.model, carPos, 210.0, function(vehicle)
FreezeEntityPosition(vehicle, true)
ESX.Game.SetVehicleProperties(vehicle, vehicleData.prop)
SetModelAsNoLongerNeeded(vehicleData.model)
end)
end
end, function(data4, menu4)
--enter
DeleteDisplayVehicleInsideShop()
DestroyCam(createdCamera, 0)
RenderScriptCams(0, 0, 1, 1, 1)
createdCamera = 0
end)
end)
end
function WaitForVehicleToLoad(modelHash)
modelHash = (type(modelHash) == 'number' and modelHash or GetHashKey(modelHash))
if not HasModelLoaded(modelHash) then
RequestModel(modelHash)
BeginTextCommandBusyspinnerOn('STRING')
AddTextComponentSubstringPlayerName("Araç Yükleniyor...")
EndTextCommandBusyspinnerOn(4)
while not HasModelLoaded(modelHash) do
Citizen.Wait(0)
DisableAllControlActions(0)
end
BusyspinnerOff()
end
end
function DeleteDisplayVehicleInsideShop()
local vehicle, distance = ESX.Game.GetClosestVehicle(carPos)
if distance < 4 then
if DoesEntityExist(vehicle) then
ESX.Game.DeleteVehicle(vehicle)
end
end
end
function trim(value)
if value then
return (string.gsub(value, "^%s*(.-)%s*$", "%1"))
else
return nil
end
end
Client.lua
 
DF
Biraz daha detaylandırır mısın olan hatayı ve yapmak istediğin şeyi.
şu şekilde ben lüks galeri açacağım ymapini yükledim oyun içi kordinatlarını aldım ve araçların çıkması için kordinatları ayarladım ama ne zaman araç satın ala basayım script için ayarlanmış ymapin oraya atıyor ve hiç birşey gözükmüyor ben de kendi ymapime kordinatlarımı uyarlamaya çalıştım ama olmadı
 
DF
Kod:
local npc = vector3(-69.09934, 63.71236, 72.388885)

local carPos = vector3(-77.11, 87.67, 71.49)





  SetCamCoord(createdCamera, -69.61, 79.89, 76.61)

  SetCamRot(createdCamera, -20.0, 0.0, 45.0, 2)




Verdiklerim ile değiştirmeyi deneyebilir misiniz ?

Arka taraftaki garajda spawn olur.
 
DF
Kod:
local npc = vector3(-69.09934, 63.71236, 72.388885)

local carPos = vector3(-77.11, 87.67, 71.49)





  SetCamCoord(createdCamera, -69.61, 79.89, 76.61)

  SetCamRot(createdCamera, -20.0, 0.0, 45.0, 2)




Verdiklerim ile değiştirmeyi deneyebilir misiniz ?

Arka taraftaki garajda spawn olur.
Kamerayı herşeyi ayarladım ama şimdi databaseden araç ekledim satın almaya çalışıyorum ve almaya çalıştığımda script bir hata veriyor
 
DF
yapmanız gerek şu visual studio code'dan client ve server'da esx_vehicleshop'u aratıcaksınız ve esx_vehicleshop olanları esx_vehicleshop2 diye değiştiriceksiniz sonra yeni sql tabloları açıcaksınız isimleri farklı olan server.luadan isimlerini değiştiriceksiniz bu kadar yapmak istemezseniz bir boş zamanımda yapıp paylaşabilirim.
 
DF
yapmanız gerek şu visual studio code'dan client ve server'da esx_vehicleshop'u aratıcaksınız ve esx_vehicleshop olanları esx_vehicleshop2 diye değiştiriceksiniz sonra yeni sql tabloları açıcaksınız isimleri farklı olan server.luadan isimlerini değiştiriceksiniz bu kadar yapmak istemezseniz bir boş zamanımda yapıp paylaşabilirim.
deneyeyim olmazsa size sorarım zaten
 
DF
55200 yapmaya çalışırken böyle bir hata aldım bu da sql


USE `essentialmode`;

INSERT INTO `addon_account` (name, label, shared) VALUES
('society_cardealer2','Concessionnaire',1)
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
('society_cardealer2','Concesionnaire',1)
;

INSERT INTO `jobs` (name, label) VALUES
('cardealer2','Concessionnaire')
;

INSERT INTO `job_grades` (job_name, grade, name, label, skin_male, skin_female) VALUES
('cardealer2',0,'recruit','Recrue',10,'{}','{}'),
('cardealer2',1,'novice','Novice',25,'{}','{}'),
('cardealer2',2,'experienced','Experimente',40,'{}','{}'),
('cardealer2',3,'boss','Patron',0,'{}','{}')
;

CREATE TABLE `cardealer_vehicles2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vehicle` varchar(255) NOT NULL,
`price` int(11) NOT NULL,

PRIMARY KEY (`id`)
);

CREATE TABLE `vehicle_sold2` (
`client` VARCHAR(50) NOT NULL,
`model` VARCHAR(50) NOT NULL,
`plate` VARCHAR(50) NOT NULL,
`soldby` VARCHAR(50) NOT NULL,
`date` VARCHAR(50) NOT NULL,

PRIMARY KEY (`plate`)
);

CREATE TABLE `owned_vehicles2` (
`owner` varchar(22) NOT NULL,
`plate` varchar(12) NOT NULL,
`vehicle` longtext,
`type` VARCHAR(20) NOT NULL DEFAULT 'car',
`job` VARCHAR(20) NULL DEFAULT NULL,
`stored` TINYINT(1) NOT NULL DEFAULT '0',

PRIMARY KEY (`plate`)
);

CREATE TABLE `rented_vehicles2` (
`vehicle` varchar(60) NOT NULL,
`plate` varchar(12) NOT NULL,
`player_name` varchar(255) NOT NULL,
`base_price` int(11) NOT NULL,
`rent_price` int(11) NOT NULL,
`owner` varchar(22) NOT NULL,

PRIMARY KEY (`plate`)
);

CREATE TABLE `vehicle_categories2` (
`name` varchar(60) NOT NULL,
`label` varchar(60) NOT NULL,

PRIMARY KEY (`name`)
);

INSERT INTO `vehicle_categories2` (name, label) VALUES
('compacts','Compacts'),
('coupes','Coupés'),
('sedans','Sedans'),
('sports','Sports'),
('sportsclassics','Sports Classics'),
('super','Super'),
('muscle','Muscle'),
('offroad','Off Road'),
('suvs','SUVs'),
('vans','Vans'),
('motorcycles','Motos')
;

CREATE TABLE `vehicles2` (
`name` varchar(60) NOT NULL,
`model` varchar(60) NOT NULL,
`price` int(11) NOT NULL,
`category` varchar(60) DEFAULT NULL,

PRIMARY KEY (`model`)
);

INSERT INTO `vehicles2` (name, model, price, category) VALUES
('Blade','blade',15000,'muscle'),
('Buccaneer','buccaneer',18000,'muscle'),
('Buccaneer Rider','buccaneer2',24000,'muscle'),
('Chino','chino',15000,'muscle'),
('Chino Luxe','chino2',19000,'muscle'),
('Coquette BlackFin','coquette3',55000,'muscle'),
('Dominator','dominator',35000,'muscle'),
('Dukes','dukes',28000,'muscle'),
('Gauntlet','gauntlet',30000,'muscle'),
('Hotknife','hotknife',125000,'muscle'),
('Faction','faction',20000,'muscle'),
('Faction Rider','faction2',30000,'muscle'),
('Faction XL','faction3',40000,'muscle'),
('Nightshade','nightshade',65000,'muscle'),
('Phoenix','phoenix',12500,'muscle'),
('Picador','picador',18000,'muscle'),
('Sabre Turbo','sabregt',20000,'muscle'),
('Sabre GT','sabregt2',25000,'muscle'),
('Slam Van','slamvan3',11500,'muscle'),
('Tampa','tampa',16000,'muscle'),
('Virgo','virgo',14000,'muscle'),
('Vigero','vigero',12500,'muscle'),
('Voodoo','voodoo',7200,'muscle'),
('Blista','blista',8000,'compacts'),
('Brioso R/A','brioso',18000,'compacts'),
('Issi','issi2',10000,'compacts'),
('Panto','panto',10000,'compacts'),
('Prairie','prairie',12000,'compacts'),
('Bison','bison',45000,'vans'),
('Bobcat XL','bobcatxl',32000,'vans'),
('Burrito','burrito3',19000,'vans'),
('Burrito','gburrito2',29000,'vans'),
('Camper','camper',42000,'vans'),
('Gang Burrito','gburrito',45000,'vans'),
('Journey','journey',6500,'vans'),
('Minivan','minivan',13000,'vans'),
('Moonbeam','moonbeam',18000,'vans'),
('Moonbeam Rider','moonbeam2',35000,'vans'),
('Paradise','paradise',19000,'vans'),
('Rumpo','rumpo',15000,'vans'),
('Rumpo Trail','rumpo3',19500,'vans'),
('Surfer','surfer',12000,'vans'),
('Youga','youga',10800,'vans'),
('Youga Luxuary','youga2',14500,'vans'),
('Asea','asea',5500,'sedans'),
('Cognoscenti','cognoscenti',55000,'sedans'),
('Emperor','emperor',8500,'sedans'),
('Fugitive','fugitive',12000,'sedans'),
('Glendale','glendale',6500,'sedans'),
('Intruder','intruder',7500,'sedans'),
('Premier','premier',8000,'sedans'),
('Primo Custom','primo2',14000,'sedans'),
('Regina','regina',5000,'sedans'),
('Schafter','schafter2',25000,'sedans'),
('Stretch','stretch',90000,'sedans'),
('Super Diamond','superd',130000,'sedans'),
('Tailgater','tailgater',30000,'sedans'),
('Warrener','warrener',4000,'sedans'),
('Washington','washington',9000,'sedans'),
('Baller','baller2',40000,'suvs'),
('Baller Sport','baller3',60000,'suvs'),
('Cavalcade','cavalcade2',55000,'suvs'),
('Contender','contender',70000,'suvs'),
('Dubsta','dubsta',45000,'suvs'),
('Dubsta Luxuary','dubsta2',60000,'suvs'),
('Fhantom','fq2',17000,'suvs'),
('Grabger','granger',50000,'suvs'),
('Gresley','gresley',47500,'suvs'),
('Huntley S','huntley',40000,'suvs'),
('Landstalker','landstalker',35000,'suvs'),
('Mesa','mesa',16000,'suvs'),
('Mesa Trail','mesa3',40000,'suvs'),
('Patriot','patriot',55000,'suvs'),
('Radius','radi',29000,'suvs'),
('Rocoto','rocoto',45000,'suvs'),
('Seminole','seminole',25000,'suvs'),
('XLS','xls',32000,'suvs'),
('Btype','btype',62000,'sportsclassics'),
('Btype Luxe','btype3',85000,'sportsclassics'),
('Btype Hotroad','btype2',155000,'sportsclassics'),
('Casco','casco',30000,'sportsclassics'),
('Coquette Classic','coquette2',40000,'sportsclassics'),
('Manana','manana',12800,'sportsclassics'),
('Monroe','monroe',55000,'sportsclassics'),
('Pigalle','pigalle',20000,'sportsclassics'),
('Stinger','stinger',80000,'sportsclassics'),
('Stinger GT','stingergt',75000,'sportsclassics'),
('Stirling GT','feltzer3',65000,'sportsclassics'),
('Z-Type','ztype',220000,'sportsclassics'),
('Bifta','bifta',12000,'offroad'),
('Bf Injection','bfinjection',16000,'offroad'),
('Blazer','blazer',6500,'offroad'),
('Blazer Sport','blazer4',8500,'offroad'),
('Brawler','brawler',45000,'offroad'),
('Bubsta 6x6','dubsta3',120000,'offroad'),
('Dune Buggy','dune',8000,'offroad'),
('Guardian','guardian',45000,'offroad'),
('Rebel','rebel2',35000,'offroad'),
('Sandking','sandking',55000,'offroad'),
('The Liberator','monster',210000,'offroad'),
('Trophy Truck','trophytruck',60000,'offroad'),
('Trophy Truck Limited','trophytruck2',80000,'offroad'),
('Cognoscenti Cabrio','cogcabrio',55000,'coupes'),
('Exemplar','exemplar',32000,'coupes'),
('F620','f620',40000,'coupes'),
('Felon','felon',42000,'coupes'),
('Felon GT','felon2',55000,'coupes'),
('Jackal','jackal',38000,'coupes'),
('Oracle XS','oracle2',35000,'coupes'),
('Sentinel','sentinel',32000,'coupes'),
('Sentinel XS','sentinel2',40000,'coupes'),
('Windsor','windsor',95000,'coupes'),
('Windsor Drop','windsor2',125000,'coupes'),
('Zion','zion',36000,'coupes'),
('Zion Cabrio','zion2',45000,'coupes'),
('9F','ninef',65000,'sports'),
('9F Cabrio','ninef2',80000,'sports'),
('Alpha','alpha',60000,'sports'),
('Banshee','banshee',70000,'sports'),
('Bestia GTS','bestiagts',55000,'sports'),
('Buffalo','buffalo',12000,'sports'),
('Buffalo S','buffalo2',20000,'sports'),
('Carbonizzare','carbonizzare',75000,'sports'),
('Comet','comet2',65000,'sports'),
('Coquette','coquette',65000,'sports'),
('Drift Tampa','tampa2',80000,'sports'),
('Elegy','elegy2',38500,'sports'),
('Feltzer','feltzer2',55000,'sports'),
('Furore GT','furoregt',45000,'sports'),
('Fusilade','fusilade',40000,'sports'),
('Jester','jester',65000,'sports'),
('Jester(Racecar)','jester2',135000,'sports'),
('Khamelion','khamelion',38000,'sports'),
('Kuruma','kuruma',30000,'sports'),
('Lynx','lynx',40000,'sports'),
('Mamba','mamba',70000,'sports'),
('Massacro','massacro',65000,'sports'),
('Massacro(Racecar)','massacro2',130000,'sports'),
('Omnis','omnis',35000,'sports'),
('Penumbra','penumbra',28000,'sports'),
('Rapid GT','rapidgt',35000,'sports'),
('Rapid GT Convertible','rapidgt2',45000,'sports'),
('Schafter V12','schafter3',50000,'sports'),
('Seven 70','seven70',39500,'sports'),
('Sultan','sultan',15000,'sports'),
('Surano','surano',50000,'sports'),
('Tropos','tropos',40000,'sports'),
('Verlierer','verlierer2',70000,'sports'),
('Adder','adder',900000,'super'),
('Banshee 900R','banshee2',255000,'super'),
('Bullet','bullet',90000,'super'),
('Cheetah','cheetah',375000,'super'),
('Entity XF','entityxf',425000,'super'),
('ETR1','sheava',220000,'super'),
('FMJ','fmj',185000,'super'),
('Infernus','infernus',180000,'super'),
('Osiris','osiris',160000,'super'),
('Pfister','pfister811',85000,'super'),
('RE-7B','le7b',325000,'super'),
('Reaper','reaper',150000,'super'),
('Sultan RS','sultanrs',65000,'super'),
('T20','t20',300000,'super'),
('Turismo R','turismor',350000,'super'),
('Tyrus','tyrus',600000,'super'),
('Vacca','vacca',120000,'super'),
('Voltic','voltic',90000,'super'),
('X80 Proto','prototipo',2500000,'super'),
('Zentorno','zentorno',1500000,'super'),
('Akuma','AKUMA',7500,'motorcycles'),
('Avarus','avarus',18000,'motorcycles'),
('Bagger','bagger',13500,'motorcycles'),
('Bati 801','bati',12000,'motorcycles'),
('Bati 801RR','bati2',19000,'motorcycles'),
('BF400','bf400',6500,'motorcycles'),
('BMX (velo)','bmx',160,'motorcycles'),
('Carbon RS','carbonrs',18000,'motorcycles'),
('Chimera','chimera',38000,'motorcycles'),
('Cliffhanger','cliffhanger',9500,'motorcycles'),
('Cruiser (velo)','cruiser',510,'motorcycles'),
('Daemon','daemon',11500,'motorcycles'),
('Daemon High','daemon2',13500,'motorcycles'),
('Defiler','defiler',9800,'motorcycles'),
('Double T','double',28000,'motorcycles'),
('Enduro','enduro',5500,'motorcycles'),
('Esskey','esskey',4200,'motorcycles'),
('Faggio','faggio',1900,'motorcycles'),
('Vespa','faggio2',2800,'motorcycles'),
('Fixter (velo)','fixter',225,'motorcycles'),
('Gargoyle','gargoyle',16500,'motorcycles'),
('Hakuchou','hakuchou',31000,'motorcycles'),
('Hakuchou Sport','hakuchou2',55000,'motorcycles'),
('Hexer','hexer',12000,'motorcycles'),
('Innovation','innovation',23500,'motorcycles'),
('Manchez','manchez',5300,'motorcycles'),
('Nemesis','nemesis',5800,'motorcycles'),
('Nightblade','nightblade',35000,'motorcycles'),
('PCJ-600','pcj',6200,'motorcycles'),
('Ruffian','ruffian',6800,'motorcycles'),
('Sanchez','sanchez',5300,'motorcycles'),
('Sanchez Sport','sanchez2',5300,'motorcycles'),
('Sanctus','sanctus',25000,'motorcycles'),
('Scorcher (velo)','scorcher',280,'motorcycles'),
('Sovereign','sovereign',22000,'motorcycles'),
('Shotaro Concept','shotaro',320000,'motorcycles'),
('Thrust','thrust',24000,'motorcycles'),
('Tri bike (velo)','tribike3',520,'motorcycles'),
('Vader','vader',7200,'motorcycles'),
('Vortex','vortex',9800,'motorcycles'),
('Woflsbane','wolfsbane',9000,'motorcycles'),
('Zombie','zombiea',9500,'motorcycles'),
('Zombie Luxuary','zombieb',12000,'motorcycles'),
('blazer5', 'blazer5', 1755600, 'offroad'),
('Ruiner 2', 'ruiner2', 5745600, 'muscle'),
('Voltic 2', 'voltic2', 3830400, 'super'),
('Ardent', 'ardent', 1150000, 'sportsclassics'),
('Oppressor', 'oppressor', 3524500, 'super'),
('Visione', 'visione', 2250000, 'super'),
('Retinue', 'retinue', 615000, 'sportsclassics'),
('Cyclone', 'cyclone', 1890000, 'super'),
('Rapid GT3', 'rapidgt3', 885000, 'sportsclassics'),
('raiden', 'raiden', 1375000, 'sports'),
('Yosemite', 'yosemite', 485000, 'muscle'),
('Deluxo', 'deluxo', 4721500, 'sportsclassics'),
('Pariah', 'pariah', 1420000, 'sports'),
('Stromberg', 'stromberg', 3185350, 'sports'),
('SC 1', 'sc1', 1603000, 'super'),
('riata', 'riata', 380000, 'offroad'),
('Hermes', 'hermes', 535000, 'muscle'),
('Savestra', 'savestra', 990000, 'sportsclassics'),
('Streiter', 'streiter', 500000, 'sports'),
('Kamacho', 'kamacho', 345000, 'offroad'),
('GT 500', 'gt500', 785000, 'sportsclassics'),
('Z190', 'z190', 900000, 'sportsclassics'),
('Viseris', 'viseris', 875000, 'sportsclassics'),
('Autarch', 'autarch', 1955000, 'super'),
('Comet 5', 'comet5', 1145000, 'sports'),
('Neon', 'neon', 1500000, 'sports'),
('Revolter', 'revolter', 1610000, 'sports'),
('Sentinel3', 'sentinel3', 650000, 'sports'),
('Hustler', 'hustler', 625000, 'muscle')
;
 
DF

Forumdan daha fazla yararlanmak için giriş yapın yada üye olun!

Forumdan daha fazla yararlanmak için giriş yapın veya kayıt olun!

Kayıt ol

Forumda bir hesap oluşturmak tamamen ücretsizdir.

Şimdi kayıt ol
Giriş yap

Eğer bir hesabınız var ise lütfen giriş yapın

Giriş yap

Bu konuyu görüntüleyen kullanıcılar

Tema düzenleyici

Tema özelletirmeleri

Granit arka planlar

Lütfen Javascript'i etkinleştirin!Javascript'i etkinleştirin!
// Adblock Kod Start // // Adblock Kod End//