Wysłany: 2016-05-24, 20:41
mtm </3 Wiek: 26 3716 dniPiwa 252
Wykreowa?em taki algorytm:
function rebuild_database ()
local db_pickups = dbConnect ( "sqlite" , "database/data.db" )
local getPickups = dbQuery ( db_pickups , "SELECT * FROM pickups" )
local result = dbPoll ( getPickups , - 1 )
for i = 1 , #result do
dbExec ( db_pickups , "UPDATE pickups SET id = ?" , i )
end
restartResource ( getThisResource ())
end
Wysłany: 2016-05-24, 20:52
#404 Wiek: 26 4771 dniPiwa 2512
dbExec ( db_pickups , "UPDATE pickups SET id = ?" , i )
Wysłany: 2016-05-24, 20:56
mtm </3 Wiek: 26 3716 dniPiwa 252
masz jaki? pomys? jak z?o?y? by algorytm kt?ry dzia?a? by poprawnie?
[ Dodano : 2016-05-25, 22:15
Wysłany: 2016-05-26, 16:59
Prezes. Wiek: 27 4370 dni Nick w MP: Prezes.
Piwa 17
function rebuild_database ()
local db_pickups = dbConnect ( "sqlite" , "database/data.db" )
local getPickups = dbQuery ( db_pickups , "SELECT id FROM pickups" )
local result = dbPoll ( getPickups , - 1 )
if ( result ) then
for i , v in ipairs ( result ) do
dbExec ( db_pickups , "UPDATE pickups SET id = ?" , tonumber ( v . id ))
end
end
restartResource ( getThisResource ())
end
Wysłany: 2016-05-26, 17:12
luki123luki123 Place Game Wiek: 28 5275 dni Nick w MP: LuKiO
Piwa 6101
Maxlian , poniewa? dajesz kazdemu rekordowi 1 potem 2 i 3 nie dajesz to tylko dla jedengo rekorda jedno id.
function rebuild_database ()
local db_pickups = dbConnect ( "sqlite" , "database/data.db" )
local getPickups = dbQuery ( db_pickups , "SELECT * FROM pickups" )
local result = dbPoll ( getPickups , - 1 )
for i , row in ipairs ( result ) do
if i == 0 then dbExec ( db_pickups , "UPDATE pickups SET id = ?" , 1 ) end
if i > 1 then
dbExec ( db_pickups , "UPDATE pickups SET id = ?" , row [ "id" ] + 1 )
end
end
restartResource ( getThisResource ())
end
Tagi: algorytm :: selekcjonowanie
Anonymous 245 dni
Anonymous Koniecznie zajrzyj na:
Piwa: 252
