# Configuration shared\_config, everything should be self explanatory ```lua 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 } ``` ```lua 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 ```lua 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 } ``` --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://force-developing.gitbook.io/force_policemdt/configuration.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.