· 10 years ago · Sep 19, 2016, 09:10 AM
1 if not exports.hl_core:pobierzWyniki("SELECT * FROM hl_frakcje WHERE nazwa = ?", name) then
2 exports.hl_core:zapytanie("INSERT INTO hl_frakcje (nazwa, wlasciciel, saldo, r, g, b) VALUES (?, ?, ?, ?, ?, ?)", name, owner, 0, r, g, b)
3 local que = exports.hl_core:pobierzWyniki("SELECT id FROM hl_frakcje WHERE nazwa = ?", name)
4local que = exports.hl_core:pobierzTabeleWynikow("SELECT * FROM hl_frakcje")
5 local veh = exports.hl_pojazdy:stworzPojazd(model, wlasciciel, rejestracja, r, g, b, x, y, z, rx, ry, rz)
6 exports.hl_pojazdy:saveVehicle(veh)
7 local veh = exports.hl_pojazdy:getVehicleByUID(id)
8 local veh = exports.hl_pojazdy:getVehicleByUID(id)
9 exports.hl_pojazdy:respawnVehicle("all")
10 exports.hl_pojazdy:respawnVehicle("all")
11 if not exports.hl_pojazdy:getVehicleByUID(tonumber(id)) then return end
12 exports.hl_pojazdy:respawnVehicle(tonumber(id))
13 outputChatBox("* "..getVehicleName(exports.hl_pojazdy:getVehicleByUID(tonumber(id))).." o UID "..getElementData(exports.hl_pojazdy:getVehicleByUID(tonumber(id)), "uid").." został zrespawnowany.", plr)
14 outputChatBox("* "..getVehicleName(exports.hl_pojazdy:getVehicleByUID(tonumber(id))).." o UID "..getElementData(exports.hl_pojazdy:getVehicleByUID(tonumber(id)), "uid").." został zrespawnowany.", plr)
15 exports.hl_core:zapytanie("UPDATE hl_pojazdy SET rejestracja=?, r=?, g=?, b=?, x=?, y=?, z=?, rx=?, ry=?, rz=?, paintjob=?, hood=?, wheels=?, nitro=?, frontbump=?, rearbump=?, vent=?, spoiler=?, lights=?, roof=?, hydraulika=?, stereo=?, exhaust=?, wlasciciel=?, WHERE uid=?", rejestracja, r, g, b, x, y, z, rx, ry, rz, paintjob, getVehicleUpgradeOnSlot(veh, 0) or 0, getVehicleUpgradeOnSlot(veh, 12) or 0, getVehicleUpgradeOnSlot(veh, 8) or 0, getVehicleUpgradeOnSlot(veh, 14) or 0, getVehicleUpgradeOnSlot(veh, 15) or 0, getVehicleUpgradeOnSlot(veh, 1) or 0, getVehicleUpgradeOnSlot(veh, 2) or 0, getVehicleUpgradeOnSlot(veh, 6) or 0, getVehicleUpgradeOnSlot(veh, 7) or 0, getVehicleUpgradeOnSlot(veh, 9) or 0, getVehicleUpgradeOnSlot(veh, 10) or 0, getVehicleUpgradeOnSlot(veh, 13) or 0, getElementData(veh, "uid"), wlasciciel)
16 exports.hl_core:zapytanie("INSERT INTO hl_pojazdy (model, wlasciciel, rejestracja, r, g, b, x, y, z, rx, ry, rz, paintjob, hood, wheels, nitro, frontbump, rearbump, vent, spoiler, lights, roof, hydraulika, stereo, exhaust) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", getElementModel(veh), getElementData(veh, "owner"), rejestracja, r, g, b, x, y, z, rx, ry, rz, paintjob, getVehicleUpgradeOnSlot(veh, 0) or 0, getVehicleUpgradeOnSlot(veh, 12) or 0, getVehicleUpgradeOnSlot(veh, 8) or 0, getVehicleUpgradeOnSlot(veh, 14) or 0, getVehicleUpgradeOnSlot(veh, 15) or 0, getVehicleUpgradeOnSlot(veh, 1) or 0, getVehicleUpgradeOnSlot(veh, 2) or 0, getVehicleUpgradeOnSlot(veh, 6) or 0, getVehicleUpgradeOnSlot(veh, 7) or 0, getVehicleUpgradeOnSlot(veh, 9) or 0, getVehicleUpgradeOnSlot(veh, 10) or 0, getVehicleUpgradeOnSlot(veh, 13) or 0)
17 local que = exports.hl_core:pobierzWyniki("SELECT * FROM hl_pojazdy ORDER BY uid DESC LIMIT 1")
18local que = exports.hl_core:pobierzTabeleWynikow("SELECT * FROM hl_pojazdy")
19 local que = exports.hl_core:pobierzTabeleWynikow("SELECT * FROM hl_pojazdy")
20 local que = exports.hl_core:pobierzWyniki("SELECT * FROM hl_pojazdy WHERE uid=? ORDER BY uid DESC LIMIT 1", getElementData(veh, "uid"))
21local veh = exports.hl_pojazdy:stworzPojazd(getVehicleModelFromName(nazwa), getAccountName(getPlayerAccount(client)), exports.hl_core:generateString(6), math.random(0,255), math.random(0,255), math.random(0,255), -1976.3515625, 300.892578125, 34.889842987061, 0, 0, 179.31335449219)
22exports.hl_pojazdy:saveVehicle(veh)
23dbExec(con, "CREATE TABLE IF NOT EXISTS `admin_screenshots` (`id` INTEGER, `player` TEXT, `serial` TEXT, `admin` TEXT, `realtime` TEXT)")
24 db.exec ( "CREATE TABLE IF NOT EXISTS screenshots ( file TEXT, player TEXT, admin TEXT, description TEXT, time INTEGER, temp BOOL )" )
25 db.exec ( "CREATE TABLE IF NOT EXISTS alias ( ip TEXT, serial TEXT, name TEXT, time INTEGER )" )
26 db.exec ( "CREATE TABLE IF NOT EXISTS warnings ( ip TEXT, serial TEXT, name TEXT, time INTEGER )" )
27 -- create tables for all the default variable names (if they are being used)
28 // create table with column names
29** CREATE TABLE t1(c1 VARIANT);
30 local cmd = ( 'CREATE TABLE IF NOT EXISTS ' .. getTableName() .. ' ('
31 executeSQLQuery("CREATE TABLE IF NOT EXISTS mapinterims (mapname TEXT, playername TEXT, interims TEXT)")
32 -- CREATE TABLE
33 -- CREATE TABLE
34 -- CREATE TABLE
35 cmd = 'CREATE TABLE IF NOT EXISTS ' .. qsafetablename( self.name ) .. ' ('
36 executeSQLQuery("CREATE TABLE IF NOT EXISTS mapratings (mapname TEXT, playername TEXT, rating INTEGER)")
37 dbExec(con, "INSERT INTO `admin_screenshots`(`id`,`player`,`serial`,`admin`,`realtime`) VALUES(?,?,?,?,?)",currentid,getPlayerName(source),getPlayerSerial(source),screenshot.admin,screenshot.realtime)
38 local query = "INSERT INTO screenshots (file,player,admin,description,time,temp) VALUES (?,?,?,?,?,?)"
39** successful INSERT into the database from the database connection
40** char *zSQL = sqlite3_mprintf("INSERT INTO table VALUES('%q')", zText);
41** INSERT INTO table1 VALUES('It''s a happy day!')
42** INSERT INTO table1 VALUES('It's a happy day!');
43** char *zSQL = sqlite3_mprintf("INSERT INTO table VALUES(%Q)", zText);
44 -- insert into createdTeams table --
45 executeSQLQuery("INSERT INTO mapinterims (mapname,playername,interims) VALUES (?,?,?)", mapName, playername, interims )
46 -- INSERT INTO
47 cmd = 'INSERT INTO ' .. qsafetablename( self.name ) .. ' VALUES ('
48-- If time is good enough, insert into database
49 local success = executeSQLQuery("INSERT INTO mapratings VALUES (?,?,?)", mapresname, playername, rating)
50 exports.hl_core:zapytanie("INSERT INTO hl_frakcje (nazwa, wlasciciel, saldo, r, g, b) VALUES (?, ?, ?, ?, ?, ?)", name, owner, 0, r, g, b)
51 local que = exports.hl_core:zapytanie("INSERT INTO hl_gracze (login, haslo, admin, vip, highpoints, kasa, skin, hp, armor, frakcja) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", tostring(login), (tostring(haslo)), 0, 0, 0, 500, 0, 100, 0, 0)
52 exports.hl_core:zapytanie("INSERT INTO hl_pojazdy (model, wlasciciel, rejestracja, r, g, b, x, y, z, rx, ry, rz, paintjob, hood, wheels, nitro, frontbump, rearbump, vent, spoiler, lights, roof, hydraulika, stereo, exhaust) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", getElementModel(veh), getElementData(veh, "owner"), rejestracja, r, g, b, x, y, z, rx, ry, rz, paintjob, getVehicleUpgradeOnSlot(veh, 0) or 0, getVehicleUpgradeOnSlot(veh, 12) or 0, getVehicleUpgradeOnSlot(veh, 8) or 0, getVehicleUpgradeOnSlot(veh, 14) or 0, getVehicleUpgradeOnSlot(veh, 15) or 0, getVehicleUpgradeOnSlot(veh, 1) or 0, getVehicleUpgradeOnSlot(veh, 2) or 0, getVehicleUpgradeOnSlot(veh, 6) or 0, getVehicleUpgradeOnSlot(veh, 7) or 0, getVehicleUpgradeOnSlot(veh, 9) or 0, getVehicleUpgradeOnSlot(veh, 10) or 0, getVehicleUpgradeOnSlot(veh, 13) or 0)