Configs, Locales & SQL

Codesign resources contain various editable/unobscured files such as client/server functions etc.

Config

Config = {}
--███████╗██████╗  █████╗ ███╗   ███╗███████╗██╗    ██╗ ██████╗ ██████╗ ██╗  ██╗
--██╔════╝██╔══██╗██╔══██╗████╗ ████║██╔════╝██║    ██║██╔═══██╗██╔══██╗██║ ██╔╝
--█████╗  ██████╔╝███████║██╔████╔██║█████╗  ██║ █╗ ██║██║   ██║██████╔╝█████╔╝ 
--██╔══╝  ██╔══██╗██╔══██║██║╚██╔╝██║██╔══╝  ██║███╗██║██║   ██║██╔══██╗██╔═██╗ 
--██║     ██║  ██║██║  ██║██║ ╚═╝ ██║███████╗╚███╔███╔╝╚██████╔╝██║  ██║██║  ██╗
--╚═╝     ╚═╝  ╚═╝╚═╝  ╚═╝╚═╝     ╚═╝╚══════╝ ╚══╝╚══╝  ╚═════╝ ╚═╝  ╚═╝╚═╝  ╚═╝


Config.Database = 'mysql' --[ 'mysql' / 'ghmattimysql' / 'oxmysql' ] Choose your sql database script.
Config.Framework = 'esx' ---[ 'esx' / 'qbcore' / 'vrp' / 'none' / 'other' ] Choose your framework.
Config.Language = 'EN' --[ 'EN' / 'BG' / 'DE' / 'CZ' / 'ES' / 'FI' / 'FR' / 'NL' / 'SE' / 'SK' ] You can add your own locales to the Locales.lua. But make sure to change the Config.Language to match it.

Config.FrameworkTriggers = { --You can change the esx/qbcore events (IF NEEDED).
    main = 'esx:getSharedObject',   --ESX = 'esx:getSharedObject'   QBCORE = 'QBCore:GetObject'
    load = 'esx:playerLoaded',      --ESX = 'esx:playerLoaded'      QBCORE = 'QBCore:Client:OnPlayerLoaded'
    job = 'esx:setJob',             --ESX = 'esx:setJob'            QBCORE = 'QBCore:Client:OnJobUpdate'
	resource_name = 'es_extended'   --ESX = 'es_extended'           QBCORE = 'qb-core'
}

Config.NotificationType = { --[ 'esx' / 'qbcore' / 'mythic_old' / 'mythic_new' / 'chat' / 'other' ] Choose your notification script.
    server = 'esx',
    client = 'esx' 
}


--██╗███╗   ███╗██████╗  ██████╗ ██████╗ ████████╗ █████╗ ███╗   ██╗████████╗
--██║████╗ ████║██╔══██╗██╔═══██╗██╔══██╗╚══██╔══╝██╔══██╗████╗  ██║╚══██╔══╝
--██║██╔████╔██║██████╔╝██║   ██║██████╔╝   ██║   ███████║██╔██╗ ██║   ██║   
--██║██║╚██╔╝██║██╔═══╝ ██║   ██║██╔══██╗   ██║   ██╔══██║██║╚██╗██║   ██║   
--██║██║ ╚═╝ ██║██║     ╚██████╔╝██║  ██║   ██║   ██║  ██║██║ ╚████║   ██║   
--╚═╝╚═╝     ╚═╝╚═╝      ╚═════╝ ╚═╝  ╚═╝   ╚═╝   ╚═╝  ╚═╝╚═╝  ╚═══╝   ╚═╝


Config.SpawnOptions = {
	last = true, --Do you want to allow players to spawn in their last saved position 	(this requires either esx, qbcore or you can edit the code and use your own framework).
	job = true, --Do you want to allow players with defined jobs to spawn at their workplace 	(this requires either esx, qbcore or you can edit the code and use your own framework).
	personal = true, --Do you want to allow a player to set and choose their own personal spawn location 	(this requires either esx, qbcore or you can edit the code and use your own framework).
	personal_command = 'personalspawn' --Set the name of the command to show/set/delete your personal spawn location.
}


--███╗   ███╗ █████╗ ██╗███╗   ██╗
--████╗ ████║██╔══██╗██║████╗  ██║
--██╔████╔██║███████║██║██╔██╗ ██║
--██║╚██╔╝██║██╔══██║██║██║╚██╗██║
--██║ ╚═╝ ██║██║  ██║██║██║ ╚████║
--╚═╝     ╚═╝╚═╝  ╚═╝╚═╝╚═╝  ╚═══╝


Config.EnableTestCommand = false --Set to true to enable the test command '/openspawnselect'.
Config.BuggedSpawnCoords = {x = 314.86, y = -213.28, z = 54.09, h = 44.56} --If there is an error or the database coords are nil, this will be a backup spawn location.
Config.DayHours = {[1] = 6, [2] = 22} --If the game time is between 6am (6) to 10pm (22) then dark mode will be enabled, else lightmode will be enabled (using 24 hour clock).

Config.JobSpawnsCoords = { --If Config.Job_Spawns is enabled then you can customise which jobs are eligable and where they spawn.
  	['ambulance'] 		= {x = 296.09, y = -601.04, z = 43.35, h = 93.08, 		name = 'LSFD'},
    ['mechanic'] 		= {x = 949.64, y = -986.29, z = 39.83, h = 110.17,  	name = 'Mechanic'},
    ['police'] 			= {x = 435.48, y = -975.08, z = 30.72, h = 83.66,  		name = 'Police'},
    ['cardealer'] 		= {x = -815.98, y = -194.89, z = 37.52, h = 115.08,  	name = 'Car Dealer'}, 
    ['taxi'] 			= {x = 907.01, y = -164.23, z = 74.12, h = 162.66,  	name = 'Taxi'},
    --['change_me'] 		= {x = 00.0, y = 00.0, z = 00.0, z = 00.0, h = 00.0,	name = 'change_me'},
}

Config.MainSpawns = { --The names in the mapdata.js must match with the name here to get the correct coordinates.
  	['The Kortz Center'] 					= {x = -2291.47, y = 366.14, z = 174.6, h = 27.47},
  	['Maze Bank Arena'] 					= {x = -249.82, y = -2031.23, z = 29.95, h = 230.62},
  	['Sandy Shores Sheriff\'s Station'] 	= {x = 1877.17, y = 3706.46, z = 33.19, h = 169.16},
  	['Bolingbroke Penitentiary'] 			= {x = 1852.88, y = 2581.95, z = 45.67, h = 283.87},
  	['Luxury Autos'] 						= {x = -815.98, y = -194.89, z = 37.52, h = 115.08},
  	['Vinewood Motel'] 						= {x = 436.25, y = 215.84, z = 103.17, h = 338.43},
  	['Mission Row Police Department'] 		= {x = 435.48, y = -975.08, z = 30.72, h = 83.66},
  	['Paleto Bay Troopers Office'] 			= {x = -448.05, y = 5986.79, z = 31.49, h = 20.64},
  	['Paleto Garage'] 						= {x = 101.82, y = 6617.12, z = 32.47, h = 239.29},
  	['Grapeseed Store'] 					= {x = 1692.32, y = 4917.21, z = 42.08, h = 59.45},
  	['Airport - LSIA'] 						= {x = -1036.96, y = -2736.84, z = 20.17, h = 327.0},
  	['Del Perro Pier'] 						= {x = -1691.58, y = -1099.54, z = 13.15, h = 47.01},
  	['Eastern Motel'] 						= {x = 317.9, y = 2623.21, z = 44.47, h = 292.39},
  	['Stab City'] 							= {x = 79.08, y = 3708.11, z = 41.08, h = 53.36},
  	['Sandy Shores Airport'] 				= {x = 1759.0, y = 3298.66, z = 41.74, h = 143.01},
  	['Vinewood Casino'] 					= {x = 926.66, y = 45.63, z = 80.9, h = 57.57},
  	['Grove Street Garage'] 				= {x = -78.47, y = -1832.54, z = 27.03, h = 320.42},
  	['Mirror Park Garage'] 					= {x = 1033.57, y = -768.57, z = 58.0, h = 49.98},
  	--['change_me'] 							= {x = 00.0, y = 00.0, z = 00.0, h = 00.0},
}


-- ██████╗ ████████╗██╗  ██╗███████╗██████╗ 
--██╔═══██╗╚══██╔══╝██║  ██║██╔════╝██╔══██╗
--██║   ██║   ██║   ███████║█████╗  ██████╔╝
--██║   ██║   ██║   ██╔══██║██╔══╝  ██╔══██╗
--╚██████╔╝   ██║   ██║  ██║███████╗██║  ██║
-- ╚═════╝    ╚═╝   ╚═╝  ╚═╝╚══════╝╚═╝  ╚═╝


function L(l) return Locales[Config.Language][l] end
if Config.Framework == 'vrp' or Config.Framework == 'none' then --if you use vrp or no framework we will disable last position, job spawns and personal spawns.
	Config.SpawnOptions.last = false
	Config.SpawnOptions.job = false
	Config.SpawnOptions.personal = false
end

Mapdata UI

let dotMap = {

    spawns: [
    {
        name: "The Kortz Center",
        x:-369.507,
        y:2291.913,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/kortzcenter.jpg",
        description:"The Center is home to cultural foundations, research centers, and museums. It is divided into four buildings: Low Rotunda, Bell Building, Biranda Building, and Moseley Building. There are sculptures, terraces, and gardens in its area, as well as a vehicle parking and a labyrinth."
    },
    {
        name:"Maze Bank Arena",
        x:2028.35,
        y:252.17,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/mazebankarena.jpg",
        description:"Home to the Los Santos Panic basketball team, auditions for the hit reality talent show Fame or Shame - hosted by the celebrity who just won't go away, Lazlow - are also being filmed at the Maze Bank Arena."
    },
    {
        name:"Sandy Shores Sheriff's Station",
        x:-3694.049,
        y:-1880.583,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/sandy.jpg",
        description:"The office occupies the eastern end of the long single level rectangular building."
    },
    {
        name:"Bolingbroke Penitentiary",
        x:-2592.443,
        y:-1869.958,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/bolingbroke.jpg",
        description:"It is governed by the San Andreas State Prison Authority. The prison is located on the Los Santos County side of Route 68, just down the road from Harmony. The prison's shape is that of an octagon."
    },{
        name: "Luxury Autos",
        x:241.99,
        y:809,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/dealer.jpg",
        description:"It is located on the ground floor of the multi-level Rockford Hills Valet Parking building at the intersection of Mad Wayne Thunder Drive and Eastbourne Way in Rockford Hills, Los Santos."
    },{
        name:"Vinewood Motel",
        x:-275.875,
        y:-376.42,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/vinewoodmotel.jpg",
        description:"Located in Vinewood, this motel serves as a starting ground to most Los Santos visitors, as it offers the cheapest services."
    },
    {
        name:"Mission Row Police Department",
        x:975,
        y:-435,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/mrpd.jpg",
        description:"The police station is a modern three-story building, demarcated by Sinner Street, Vespucci Boulevard, Atlee Street and Little Bighorn Avenue in Mission Row, Downtown Los Santos."
    },
    {
        name:"Paleto Bay Troopers Office",
        x:-6014.541,
        y:428.026,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/paletopd.jpg",
        description:"The complex consists of a large rectangular building with a smaller second story. A communications array antenna is on the roof on the west side. On the east side, a second attached brick building with barred windows houses the County Jail."
    },
    {
        name:"Paleto Garage",
        x:-6600.243,
        y:-142.675,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/paletogarage.jpg",
        description:"Paleto Bay is located on the lush northern coast of Blaine County, San Andreas. Sitting at the base of the massive Mount Chiliad, Paleto Bay is a coastal town, home to the Cluckin' Bell factory farm, used to process chicken for all of San Andreas to enjoy."
    },
    {
        name:"Grapeseed Store",
        x:-4929.627,
        y:-1695.409,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/grapeseed.jpg",
        description:"Located at the northeast tip of the Alamo Sea, Grapeseed is a thriving agricultural and industrial community involved in the manufacturing of high-fructose corn syrup and meth."
    },
    {
        name:"Airport - LSIA",
        x:3234.7006835938,
        y:1393.119140625,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/lsia.jpg",
        description:"One of the busiest airports in the world, with nowhere near enough infrastructure to support it, Los Santos International brings third-world service to first-world travel."
    },
    {
        name:"Del Perro Pier",
        x:1067.436,
        y:1678.713,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/delperro.jpg",
        description:"Del Perro Pier is, as its name suggests, located in Del Perro, Los Santos. It is mainly accessed through Red Desert Avenue. Del Perro Pier is renowned for its bright, vivid colors that shine at night, giving the surrounding beaches a sort of vibe."
    },
    {
        name:"Eastern Motel",
        x:-2620.2,
        y:-329.368,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/easternmotel.jpg",
        description:"The motel located at the intersection of Senora Road and the Route 68 approach in Harmony, Blaine County. It is a large motel featuring a large parking lot which serves as a spawn point for vehicles."
    },
    {
        name:"Stab City",
        x:-3702.08,
        y:-66.784,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/stabcity.jpg",
        description:"Located just off Calafia Road, Stab City is a poverty-stricken trailer park, located on the western coast of the Alamo Sea at the source of the Zancudo River. The settlement consists of numerous run-down trailers with a dirt road circling the entire trailer park."
    },
    {
        name:"Sandy Shores Airport",
        x:-3277.219,
        y:-1739.426,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/sandyairfield.jpg",
        description:"The airfield consists of three unnamed and unmarked runways: two large parallel runways that run east to west and a smaller runway that runs northeast to southwest."
    },
    {
        name:"Vinewood Casino",
        x:-46.753,
        y:-930.426,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/casino.jpg",
        description:"It is based on the Hollywood Park Casino in Inglewood, California. But also shows resemblance to the Garden Paddock of Santa Anita Park in Arcadia, California."
    },
    {
        name:"Grove Street Garage",
        x:1840.846,
        y:54.642,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/grovestreet.jpg",
        description:"Beginning at Davis Avenue in the northwest, with exits north to Brouge Avenue and an un-named northern street and ending in a cul-de-sac in the southeast, Grove Street is occupied by the Original Covenant Ballas."
    },
    {
        name:"Mirror Park Garage",
        x:773.067,
        y:-1033.638,
        icon:"pin",
        iconSelected:"pinSel",
        image:"images/mirrorpark.jpg",
        description:"Mirror Park, like the rest of East Vinewood, is home to post-ironic hipsters driving Issis and drinking Bean Machine coffee. The area is based on Echo Park and Silver Lake in Los Angeles, known for having a high concentration of hipsters in residence."
    }
]
}

Locales

https://github.com/RampBST/Codesign_Locales/blob/main/cd_spawnselect/locales.lua

Locales UI

https://github.com/RampBST/Codesign_Locales/blob/main/cd_spawnselect/locales_ui.js

SQL

Watch this video if you are unsure how to insert an SQL Query into your database. HeidiSQL / PHPMyAdmin.

CREATE TABLE IF NOT EXISTS `spawnselect` (
	`identifier` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`personal_spawn` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci'
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;