Wysłany: 2021-01-17, 12:52
Lucky!!! :)
Wiek: 20 Na forum: 2372 dni Posty: 121
Nick w MP: Lucky
Piwa : 1163
Powie mi kto? co robie ?le?
B??d: WARNING: [bazadanych]/pystories-db/s_db.lua:12: dbExec failed; (1136) Column count doesn't match value count at row 1
addCommandHandler ( 'kuppojazd' , function( plr , cmd )
for i , v in pairs ( positionVehicles ) do
local data = plr : getData ( 'vehsell:info' )
if not data then return end
local bankmoney = exports [ "pystories-db" ]: dbGet ( "SELECT `bank_money` FROM `pystories_users` WHERE `id` = ?" , getElementData ( plr , "player:sid" ))
for i , v in ipairs ( bankmoney ) do
plrmoney [ plr ] = v [ "bank_money" ]
end
if plrmoney [ plr ] < data . cost then
plr : outputChat ( 'Nie posiadasz wystarczaj?cej kwoty pieni?dzy w bankomacie!' )
return
end
local vehicle = plr : getOccupiedVehicle ()
local cost = data . cost
local model = data . model
local mileage = data . mileage
local pojemnosc = data . pojemnosc
local uid = getElementData ( plr , 'player:sid' )
local name = exports [ "pystories-vehicles" ]: getVehicleName ( model )
exports [ "pystories-db" ]: dbSet ( "UPDATE `pystories_users` SET `bank_money` = `bank_money` - ? WHERE `pystories_users`.`id` = ?" , cost , getElementData ( plr , "player:sid" ))
exports [ "pystories-db" ]: dbSet ( "INSERT INTO pystories_vehicles (model,ownedPlayer,mileage,pojemnosc,parking) VALUES (?,?,?,?,?,1)" , model , getElementData ( plr , "player:sid" ), mileage , pojemnosc )
triggerClientEvent ( plr , "addNotification" , root , string . format ( "Zakupi?e? sw?j pojazd " .. name .. ", znajdziesz go w przechowywalni." ), "info" )
triggerEvent ( "admin:addText" , resourceRoot , "#3399ffZAKUP POJAZDU SALON > #ffffff" .. getPlayerName ( plr ): gsub ( "#%x%x%x%x%x%x" , "" ).. " kupi? pojazd marki: " .. name .. "!" )
end
end )
Wysłany: 2021-01-17, 13:53
killercycDDS
Migacz
Wiek: 25 Na forum: 4512 dni Posty: 629
Nick w MP: killer_cyc[DDS]
Piwa : 1659
nie jestem pewien ale zobacz
addCommandHandler ( 'kuppojazd' , function( plr , cmd )
for i , v in pairs ( positionVehicles ) do
local data = plr : getData ( 'vehsell:info' )
if not data then return end
local wyk = exports [ "pystories-db" ]: dbGet ( "SELECT * FROM `pystories_users` WHERE id = ?" , getElementData ( plr , "player:sid" ))
if wyk and #wyk <= 0 then return end
plrmoney [ plr ] = wyk [ 1 ]. bank_money
if plrmoney [ plr ] < data . cost then
plr : outputChat ( 'Nie posiadasz wystarczaj?cej kwoty pieni?dzy w bankomacie!' )
return
end
local vehicle = plr : getOccupiedVehicle ()
local cost = data . cost
local model = data . model
local mileage = data . mileage
local pojemnosc = data . pojemnosc
local uid = getElementData ( plr , 'player:sid' )
local name = exports [ "pystories-vehicles" ]: getVehicleName ( model )
exports [ "pystories-db" ]: dbSet ( "UPDATE `pystories_users` SET `bank_money` = `bank_money` - ? WHERE `pystories_users`.`id` = ?" , cost , getElementData ( plr , "player:sid" ))
exports [ "pystories-db" ]: dbSet ( "INSERT INTO pystories_vehicles (model,ownedPlayer,mileage,pojemnosc,parking) VALUES (?,?,?,?,?,1)" , model , getElementData ( plr , "player:sid" ), mileage , pojemnosc )
triggerClientEvent ( plr , "addNotification" , root , string . format ( "Zakupi?e? sw?j pojazd " .. name .. ", znajdziesz go w przechowywalni." ), "info" )
triggerEvent ( "admin:addText" , resourceRoot , "#3399ffZAKUP POJAZDU SALON > #ffffff" .. getPlayerName ( plr ): gsub ( "#%x%x%x%x%x%x" , "" ).. " kupi? pojazd marki: " .. name .. "!" )
end
end
Wysłany: 2021-01-17, 14:39
Lucky!!! :)
Wiek: 20 Na forum: 2372 dni Posty: 121
Nick w MP: Lucky
Piwa : 1163
killercycDDS , Niestety nie
Wysłany: 2021-01-17, 14:49
killercycDDS
Migacz
Wiek: 25 Na forum: 4512 dni Posty: 629
Nick w MP: killer_cyc[DDS]
Piwa : 1659
"Lucky!!! " napisał/a :killercycDDS , Niestety nie
b??d?
Wysłany: 2021-01-17, 14:54
Lucky!!! :)
Wiek: 20 Na forum: 2372 dni Posty: 121
Nick w MP: Lucky
Piwa : 1163
killercycDDS , Dalej ten sam
Wysłany: 2021-01-17, 15:14
Wilq
Wiek: 24 Na forum: 4429 dni Posty: 3410
Piwa : 739
Linijka:
exports [ "pystories-db" ]: dbSet ( "INSERT INTO pystories_vehicles (model,ownedPlayer,mileage,pojemnosc,parking) VALUES (?,?,?,?,?,1)" , model , getElementData ( plr , "player:sid" ), mileage , pojemnosc )
Wskazujesz 5 kolumn, wstawiasz 6 warto?ci.
Więcej szczegółów
Wystawiono 1 piw(a):Lucky!!! :)
Wysłany: 2021-01-17, 15:40
Lucky!!! :)
Wiek: 20 Na forum: 2372 dni Posty: 121
Nick w MP: Lucky
Piwa : 1163
Wilq , Zupe?nie nie zwr?ci?em na to uwagi. Dzi?kuje! Piwko zostawione
Tagi: salony
Anonymous
Na forum: 245 dni
Posty: 1
Anonymous Koniecznie zajrzyj na: