Configuration
Configs
shared_config, everything should be self explanatory
shared_config = {
Open = {
RequirePoliceJob = false,
PoliceJob = "police"
},
Command = {
Use = true,
CommandName = "policeipad"
},
-- Event == "force_policeipad:openMdt" it's a client event
Design = {
Locale = "sv",
StartTab = "individual-page", -- home-page, individual-page, vehicles-page, crimes-page, penalties-page or wanted-page
Image = {
UseImage = true, -- This is if you have a image columm in your characters table in your SQL
NoImage = "None", -- The default value on image colum if the player doesn't have an image
},
},
WantedLables = {
Yes = "Ja",
No = "Nej"
},
UnkownLabel = "Okänd",
Penalties = {
["Trafic"] = {
{["crime"] = "Hastighet 1-10km/h", ["fine"] = "2.500 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Hastighet 11-15km/h", ["fine"] = "4.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Hastighet 16-20km/h", ["fine"] = "4.800 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Hastighet 21-25km/h", ["fine"] = "5.600 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Hastighet 26-30km/h", ["fine"] = "6.400 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Varning"},
{["crime"] = "Hastighet 31-35km/h", ["fine"] = "7.200 kr", ["jail"] = "Nej", ["RemoveLicense"] = "4 Månader"},
{["crime"] = "Hastighet 36-50km/h", ["fine"] = "8.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "6 Månader"},
{["crime"] = "Hastighet 51-60km/h", ["fine"] = "8.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "8 Månader"},
{["crime"] = "Hastighet 61-70km/h", ["fine"] = "8.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "10 Månader"},
{["crime"] = "Hastighet 71-80km/h", ["fine"] = "8.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "12 Månader"},
{["crime"] = "Hastighet 81km/h", ["fine"] = "8.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "16 Månader"},
{["crime"] = "Missbruk av singnalhorn", ["fine"] = "1.600 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Felaktig modifiering", ["fine"] = "2.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "8 Månader"},
{["crime"] = "Forcerad rödljus", ["fine"] = "1.600 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Upprepat gångar 6månaders"},
{["crime"] = "Forcerad stopp plikt", ["fine"] = "1.600 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Upprepat gångar 6månaders"},
{["crime"] = "Olovlig pakering", ["fine"] = "1.500 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Olovlig körning", ["fine"] = "5.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov olovlig körning", ["fine"] = "10.000 kr", ["jail"] = "5 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Fel Regskylt/ingen", ["fine"] = "6.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Bilen får ej köras om den inte har skylt"},
{["crime"] = "Vårdslöshet i trafik", ["fine"] = "7.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Upprepat gångar 6månaders"},
{["crime"] = "Grov vårdslöshet i trafik", ["fine"] = "15.000 kr", ["jail"] = "5-12 Månader", ["RemoveLicense"] = "12-48 månader efter avtjänat straff"},
{["crime"] = "Smitning från olycka", ["fine"] = "5.000 kr", ["jail"] = "3 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Felaktig belysning", ["fine"] = "3.500 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Ombesiktning"},
{["crime"] = "Trafikfarligt fordon", ["fine"] = "4.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Brott mot mobilförbud", ["fine"] = "2.500 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Köra utan hjälm", ["fine"] = "2.500 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Rattfylleri över 0,2", ["fine"] = "5.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "6 Månader"},
{["crime"] = "Grov rattfylleri 1,0-över", ["fine"] = "15.000 kr", ["jail"] = "4-8 Månader", ["RemoveLicense"] = "12-120 Månader"},
{["crime"] = "Drogfylleri", ["fine"] = "8.000 kr", ["jail"] = "4 Månader", ["RemoveLicense"] = "6-18 Månader"},
{["crime"] = "Aggrasiv körning", ["fine"] = "3.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Köra för nära framförvarande fordon", ["fine"] = "4.750 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Forcerat heldragen linje", ["fine"] = "4.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "köra i felfärdriktning (hög hastighet)", ["fine"] = "15.000 kr", ["jail"] = "5-12 Månader", ["RemoveLicense"] = "12-48 Månader"},
{["crime"] = "Inte stannat på polismans tecken", ["fine"] = "2.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Höger regel", ["fine"] = "1.500 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Utfarts regel", ["fine"] = "1.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Burnout= vårdlöshet i trafik", ["fine"] = "7.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "köra på backhjul/framhjul", ["fine"] = "7.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "får sladd på bil= vårdlöshet i trafik", ["fine"] = "7.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "köra utan bälte ", ["fine"] = "1.600 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Helljus", ["fine"] = "1.600 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
},
["General"] = {
{["crime"] = "Störa den allmänna ordningen", ["fine"] = "5.000 kr", ["jail"] = "0-5 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Kränkning", ["fine"] = "4.500 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Ohörsamhet mot ordningsmakten", ["fine"] = "5.750 kr", ["jail"] = "0-5 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Brott mot skyddslagen", ["fine"] = "15.000 kr", ["jail"] = "6-24 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Olaga hot", ["fine"] = "9.500 kr", ["jail"] = "0-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov olaga hot", ["fine"] = "16.000 kr", ["jail"] = "6-18 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Hot mot tjänsteman", ["fine"] = "14.500 kr", ["jail"] = "6-18 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov hot mot tjänste man", ["fine"] = "27.000 kr", ["jail"] = "8-24 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Förgivande av allmän ställning", ["fine"] = "14.500 kr", ["jail"] = "10-24 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Övergrepp i rättsak", ["fine"] = "15.000 kr", ["jail"] = "4-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Brott mot knivlagen", ["fine"] = "7.500 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Ringa stöld upp till 1250kr", ["fine"] = "3.500 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Stöld", ["fine"] = "7.500 kr", ["jail"] = "0-4 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov stöld över 200000kr", ["fine"] = "10.000 kr", ["jail"] = "6-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Skadegörelse", ["fine"] = "4.500 kr", ["jail"] = "0-6 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov skadegörelse", ["fine"] = "12.000 kr", ["jail"] = "6-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Ofredande", ["fine"] = "2.000 kr", ["jail"] = "0-8 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Sexuellt ofredande", ["fine"] = "20.000 kr", ["jail"] = "6-24 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Bedrägeri", ["fine"] = "14.500 kr", ["jail"] = "6-36 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Urkundsförfalskning", ["fine"] = "5.000 kr", ["jail"] = "4-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Falsk larm", ["fine"] = "5.000 kr", ["jail"] = "0-4 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Brott mot Tystnadsplikt", ["fine"] = "9.000 kr", ["jail"] = "0-14 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Olagliga intrång", ["fine"] = "4.500 kr", ["jail"] = "0-5 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov olagliga intrång", ["fine"] = "10.000 kr", ["jail"] = "6-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Hemfridsbrott", ["fine"] = "9.500 kr", ["jail"] = "4-8 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Förtal", ["fine"] = "4.000 kr", ["jail"] = "0-2 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov förtal", ["fine"] = "7.500 kr", ["jail"] = "2-10 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Sabotage mot blåljusverksamhet", ["fine"] = "15.000 kr", ["jail"] = "1-4 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov sabotage mot blåljusverksamhet", ["fine"] = "28.000 kr", ["jail"] = "6-14 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Medhjälp till brott ", ["fine"] = "Nej", ["jail"] = "Vanliga straffet delat på 2", ["RemoveLicense"] = "Nej"},
{["crime"] = "Skyddande av annan brottsling", ["fine"] = "Nej", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Försvårande av utredning", ["fine"] = "18.000 kr", ["jail"] = "0-24 Månader", ["RemoveLicense"] = "Nej"},
},
["Rougher"] = {
{["crime"] = "Människorov", ["fine"] = "18.000 kr", ["jail"] = "12-48 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Vållande till annans korppskada ", ["fine"] = "25.000 kr", ["jail"] = "6-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov vållande till annans korppskada ", ["fine"] = "40.000 kr", ["jail"] = "12-24 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Ringa Misshandel", ["fine"] = "10.000 kr", ["jail"] = "0-6 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Misshandel", ["fine"] = "14.000 kr", ["jail"] = "4-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grov misshandel", ["fine"] = "20.000 kr", ["jail"] = "8-18 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Försökt till mord", ["fine"] = "100.000 kr", ["jail"] = "30-120 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Mord", ["fine"] = "200.000 kr", ["jail"] = "120-240 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Våld mot tjänsteman", ["fine"] = "15.000 kr", ["jail"] = "6-16 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Ringa vapenbrott", ["fine"] = "8.000 kr", ["jail"] = "0-6 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Vapenbrott", ["fine"] = "50.000 kr", ["jail"] = "6-20 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grovt vapenbrott", ["fine"] = "200.000 kr", ["jail"] = "18-36 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Försökt till rån", ["fine"] = "45.000 kr", ["jail"] = "6-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Rån", ["fine"] = "75.000 kr", ["jail"] = "12-36 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grovt rån", ["fine"] = "125.000 kr", ["jail"] = "24-48 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Olagligt förföljelse", ["fine"] = "12.000 kr", ["jail"] = "6-18 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Terrorhot", ["fine"] = "65.000 kr", ["jail"] = "60-120 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Terrorbrott", ["fine"] = "250.000 kr", ["jail"] = "Förvaring", ["RemoveLicense"] = "Nej"},
{["crime"] = "Brott mot brand/explosiva varor", ["fine"] = "20.000 kr", ["jail"] = "6-30 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grovt brott mot brand/explosiva varor", ["fine"] = "40.000 kr", ["jail"] = "12-48 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Ringa nakotika brott", ["fine"] = "6.000 kr", ["jail"] = "Nej", ["RemoveLicense"] = "Nej"},
{["crime"] = "Narkotika brott", ["fine"] = "16.000 kr", ["jail"] = "4-18 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Grovt narkotika brott", ["fine"] = "30.000 kr", ["jail"] = "12-36 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Olovlig befattnings med natokika", ["fine"] = "15.000 kr", ["jail"] = "6-20 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Narkotika försäljning", ["fine"] = "30.000 kr", ["jail"] = "6-48 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Bilstöld", ["fine"] = "15.000 kr", ["jail"] = "2-12 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Koruption", ["fine"] = "500.000+ kr", ["jail"] = "20-500 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Fritagnings försök", ["fine"] = "150.000 kr", ["jail"] = "30-200 Månader", ["RemoveLicense"] = "Nej"},
{["crime"] = "Fritagning", ["fine"] = "250.000 kr", ["jail"] = "200+ Månader", ["RemoveLicense"] = "Nej"},
}
},
TimeBeforeMessageRemoves = 86400, -- Seconds 86400 == 24h ish
}server_config = {
FetchAllPlayers = function(cb)
MySQL.Async.fetchAll("SELECT * FROM " .. force_lib.FetchSQLInfo("Tables", "character"), {
}, function(resp)
cb(resp)
end)
end,
FetchAllVehicles = function(cb)
MySQL.Async.fetchAll("SELECT * FROM " .. force_lib.FetchSQLInfo("Tables", "vehicles"), {
}, function(resp)
cb(resp)
end)
end,
FetchAllWantedPlayers = function(cb)
MySQL.Async.fetchAll("SELECT * FROM " .. force_lib.FetchSQLInfo("Tables", "character") .. " WHERE " .. "efterlyst = @efterlyst", {
["@efterlyst"] = shared_config.WantedLables.Yes
}, function(resp)
cb(resp)
end)
end
}
force_lib.CreateCallback("force_policeipad:fetchPlayerInfo", function(source, cb, identifier)
MySQL.Async.fetchAll("SELECT * FROM " .. force_lib.FetchSQLInfo("Tables", "character") .. " WHERE " .. force_lib.FetchSQLInfo("Columns", "identifier") .. " = @" .. force_lib.FetchSQLInfo("Columns", "identifier"), {
["@" .. force_lib.FetchSQLInfo("Columns", "identifier")] = identifier
}, function(respUser)
if respUser[1] then
MySQL.Async.fetchAll("SELECT * FROM " .. force_lib.FetchSQLInfo("Tables", "licenses") .. " WHERE " .. force_lib.FetchSQLInfo("Columns", "licensesOwner") .. " = @" .. force_lib.FetchSQLInfo("Columns", "licensesOwner"), {
["@" .. force_lib.FetchSQLInfo("Columns", "licensesOwner")] = identifier
}, function(respDMV)
if respDMV then
local licenses = {drive = "Nej", drive_truck = "Nej", drive_bike = "Nej"}
for k,v in pairs(respDMV) do
-- print(v.licenseName)
if licenses[v.type] then
licenses[v.type] = "Ja"
end
end
MySQL.Async.fetchAll("SELECT * FROM " .. force_lib.FetchSQLInfo("Tables", "jobs") .. " WHERE " .. force_lib.FetchSQLInfo("Columns", "jobName") .. " = @" .. force_lib.FetchSQLInfo("Columns", "jobName"), {
["@" .. force_lib.FetchSQLInfo("Columns", "jobName")] = respUser[1].job
}, function(respJob)
MySQL.Async.fetchAll("SELECT * FROM " .. force_lib.FetchSQLInfo("Tables", "jobGrades") .. " WHERE " .. force_lib.FetchSQLInfo("Columns", "jobGradesName") .. " = @" .. force_lib.FetchSQLInfo("Columns", "jobGradesName") .. " AND " .. force_lib.FetchSQLInfo("Columns", "jobGradesGrade") .. " = @" .. force_lib.FetchSQLInfo("Columns", "jobGradesGrade"), {
["@" .. force_lib.FetchSQLInfo("Columns", "jobGradesName")] = respUser[1].job,
["@" .. force_lib.FetchSQLInfo("Columns", "jobGradesGrade")] = respUser[1].job_grade
}, function(respJobGrade)
local playerInfo = {
identifier = respUser[1].identifier,
firstname = respUser[1].firstname,
lastname = respUser[1].lastname,
dob = respUser[1].dateofbirth,
sex = respUser[1].sex,
height = respUser[1].height,
phonenumber = respUser[1].phonenumber,
image = respUser[1].image,
dmv = licenses,
jobLabel = respJob[1].label,
jobGradeLabel = respJobGrade[1].label,
wanted = respUser[1].efterlyst,
wantedReason = respUser[1].efterlystReason,
wantedBy = respUser[1].efterlystBy,
}
cb(playerInfo)
end)
end)
end
end)
end
end)
end)
force_lib.CreateCallback("force_policeipad:attemptChangeWantedOnIdentifier", function(source, cb, identifier)
MySQL.Async.fetchAll("SELECT * FROM " .. force_lib.FetchSQLInfo("Tables", "character") .. " WHERE " .. force_lib.FetchSQLInfo("Columns", "identifier") .. " = @" .. force_lib.FetchSQLInfo("Columns", "identifier"), {
["@" .. force_lib.FetchSQLInfo("Columns", "identifier")] = identifier
}, function(respUser)
if respUser[1].efterlyst == shared_config.WantedLables.No then
MySQL.Async.execute("UPDATE `" .. force_lib.FetchSQLInfo("Tables", "character") .. "` SET `efterlyst` = @efterlyst WHERE ".. force_lib.FetchSQLInfo("Columns", "identifier") .." = @" .. force_lib.FetchSQLInfo("Columns", "identifier"),
{
["@" .. force_lib.FetchSQLInfo("Columns", "identifier")] = identifier,
['@efterlyst'] = shared_config.WantedLables.Yes,
})
cb(true)
else
MySQL.Async.execute("UPDATE `" .. force_lib.FetchSQLInfo("Tables", "character") .. "` SET `efterlyst` = @efterlyst WHERE ".. force_lib.FetchSQLInfo("Columns", "identifier") .." = @" .. force_lib.FetchSQLInfo("Columns", "identifier"),
{
["@" .. force_lib.FetchSQLInfo("Columns", "identifier")] = identifier,
['@efterlyst'] = shared_config.WantedLables.No,
})
cb(true)
end
end)
end)
force_lib.CreateCallback("force_policeipad:FetchVehiclesFromIdentifier", function(source, cb, identifier)
MySQL.Async.fetchAll("SELECT * FROM " .. force_lib.FetchSQLInfo("Tables", "vehicles") .. " WHERE " .. force_lib.FetchSQLInfo("Columns", "owner") .. " = @" .. force_lib.FetchSQLInfo("Columns", "owner"), {
["@".. force_lib.FetchSQLInfo("Columns", "owner")] = identifier
}, function(resp)
cb(resp)
end)
end)
force_lib.CreateCallback("force_policeipad:FetchPoliceMenAndMessages", function(source, cb)
local players = force_lib.GetPlayers()
local policeMen = {}
for k,v in pairs(players) do
local player = force_lib.GetPlayer(v)
if player.job.name == "police" then
table.insert(policeMen, player.character)
end
end
MySQL.Async.fetchAll("SELECT * FROM force_policeipad_messages", {}, function(resp)
policeMessages = resp
cb({policeMen = policeMen, messages = resp})
end)
end)Client Config
client_config = {
IsPlayerPolice = function()
if force_lib.GetPlayerData().job and force_lib.GetPlayerData().job.name == shared_config.Open.PoliceJob then
return true
else
return false
end
end
}Last updated