1803 Creations

This page (and the future github link below) will be where I will keep updated versions of SQL queries to run against the Persistent World database. This SQL Query is to edit the local database that comes with this plugin: What is a SQL Query? Code you can run against a SQL database that allows for fast changes. You can either manually make changes to the database or you can use code. HOW TO RUN: Download and install an app that can read and run SQL Lite database Queries. I use DB Browser for SQL Lite. File>Open>Open database file: PersistentWorld.db. Then click the "Execute SQL" tab and paste in the text in the text file in the SQL Query. Run the query. Save the database. It is recommended to backup before running queries. You can also try running by clicking the SQL file that is included. One is a text version, one is the sql file version. AI Generated Query 1: Part 1: Vehicle Registrations (5% expired, 1% no registration)What it does: First makes ALL vehicles have valid registration (expires in 1 year) Then randomly selects 5% of vehicles and makes their registration expired at various intervals: 15 days expired (recent) 30 days expired (1 month) 60 days expired (2 months) 90 days expired (3 months) 180 days expired (6 months) Then randomly selects 1% of vehicles and marks them as "NO REGISTRATION" (never registered) Part 2: Vehicle Insurance (5% expired, 2% no insurance)What it does: First makes ALL vehicles have valid insurance (expires in 1 year) Randomly selects 5% of vehicles and makes insurance expired at various intervals Randomly selects 2% of vehicles and marks them as "NO INSURANCE" Part 3: License Status (20 suspended, 20 revoked, 10 no license)What it does: First makes ALL people have valid licenses (expires in 4 years) Randomly selects 20 people and marks licenses as SUSPENDED with realistic reasons: DUI Reckless driving Failure to appear Points accumulation Randomly selects 20 people and marks licenses as REVOKED (permanent) with severe reasons: Multiple DUIs Vehicular manslaughter Felony with vehicle Randomly selects 10 people and marks as NO LICENSE (never had one)

Showcase: This is a LSPDFR plugin that acts as a plate reader (and notification) system for the Remembrance system. This ALPR checks against the local database for Registration, Insurance, Stolen/Suspended/Revoked Status, Warrants, and Incarcerated vehicle flags. This License Plate Notification System runs off of the plugin below: https://www.lcpdfr.com/downloads/gta5mods/scripts/53518-remembrance-persistent-world/ How to install: Files go into GTA\Plugins\LSPDFR folder. Hits will turn the license plate color in the ALPR system a color below. Notifications and temporary car blips are also added for ALPR hits. GREEN: Clean vehicles (no hits) YELLOW: Registration and insurance issues ORANGE: Suspended or revoked licenses RED: Warrants and stolen vehicles PURPLE: Incarcerated owners

This is a simple ScripthookVdotnetV3 script. Files go into the GTA/scripts folder. Showcase: https://www.youtube.com/watch?v=ZxqRMoaA28Y This will be a standalone plate reader that simply just displays up to two nearby plates on the bottom right of the screen as seen in the picture. A separate plugin/script will build off of this to work as an ALPR system for the Remembrance system that runs on the local database. That system will send notifications for ALPR hits for vehicle information like stolen/insurance/registration/license issues. This was created with AI in under an hour. This was tested for 4-5 hours on LSPDFR patrol with no issues.

This will be the main engine the Remembrance systems runs on. This GTAV plugin is called Persistent World. This is a GTAV/LSPDFR plugin that uses a local SQL lite database. The database stays the same across game sessions and updates in real time. If you write a ticket, see the ticket forever on the record unless you delete it in the admin tool. This mod also handles vehicle plate and spawning so peds always have the same plate. Vehicles will change across sessions, however, the database updates automatically. More details below. More plugins and scripts will be released in the future and will be tagged something along the lines of “Rememberance:Gang Callouts, Remembrance: Active Speeders, etc. This is compatible with any plugin that can read name/vehicle data. This was tested with StopThePed. You can use stoptheped to get i.d.'s and vehicle plates but you would want to use the computer system displayed below, CompuLite or LSPDR computer WILL NOT be compatible, they have no way of reading or knowing about the local database. You can still use those computer systems if you wish but be warned they are not related to the local database described below. Version 1.4: For new installs: Use the new install folder. Place the files in the GTAV folder in the root of your GTAV folder. For updating: To update: Replace the .pdb and .dll files that are in the GTA5\plugins\lspdfr folder. Replace the two files config.xml and vehicleattach.xml in the persistentworld folder. -Now includes a dispatch lookup, default keys are below and can be changed in the config.xml file located in the plugins/lspdfr/persistentworld folder. Controller: Triple tap the D-pad UP button, use dpad to scroll, A to select, B to close menu/cancel Keyboard: T as in "TOM" to open/close menu, arrows on keyboard and enter to select Small fix: Gender Matching should be near 100% now for male/female names matching the correct face/model for the AI peds. Version 1.3 contains a major update (Released 3/6/2026) -ini file does not need updated. Incarceration System Stolen Vehicle Logic Fleet Vehicles with Company Owners Incarceration System: The incarceration system is now fully functional with drivers and vehicles. Before: You would arrest people and they become incarcerated but could spawn again. Now: Incarcerated people and plates are changed to a non-incarcerated person and plate so you no longer see incarcerated people spawn in traffic patrol. (Will work when future plugins use these new programmed methods to spawn wanted but not incarcerated people) Stolen Vehicle Logic Stolen vehicles now spawn with different drivers than owners, Before: Due to continued testing, all drivers were matched with vehicle owner, Now: Stolen vehicle plates stay locked (so stay stolen) but driver name changes and stays locked so driver is not the owner of the stolen vehicle. Fleet Vehicles with Company Owners (Test Release) A whole new system that has been created to allow vehicle models to belong to companies. For example, if you have a car model named “AmazonVan” and wanted it to belong to a company “Amazon”, this is supported. You must create the companies in the company tab on the admin tool and then create vehicles on the vehicle tab and link them to companies. NOTE: Whatever you create and link in the company and vehicle sections in the admin tool is what will show up in the database. There is an xml file that is used to tell the game which models belong to which companies. You still must create the companies then create vehicles for each company. The game will change all models to the plates if they exist. If you create 10 Amazon cars with plates, the plugin can assign up to 10 plates for the Amazon cars. It will detect and re-use deleted cars plates. Scenario l: AmazonVan is set to company Amazon Inc. Everytime you pullover any AmaazonVan car model, the computer will return “Amazon Inc” as the owner but the driver will be a person. Depending on the citation, you could write a ticket to either the person or the company. I would probably write expired registration/insurance issues to company and speeding/everything else to person. V 1.2(Updated 3/1/26) -Internal computer changes to fix it reading empty fields without errors. V 1.1 (Updated 2/22/26) Internal Computer: Small changes for easier scrolling and fixed auto fill with vehicle plate adding an extra space at the end sometimes Vehicle Attach system: Major update: Now re-inforcing name and gender after plates are changed to match name. Before:The game would sometimes change the name again thus creating a loop of changing names>changing plate>LSPDFR changes name>this mod changes plate. Now: When plates change, plates stay locked and name (and gender) are forced back if they change. This change also helps make the ALPR system 100% consistent with vehicle owners and drivers. Showcase: ALPR System: https://www.lcpdfr.com/downloads/gta5mods/scripts/53528-remembrance-lprns-v10/ How to Install Video: https://www.youtube.com/watch?v=M-9TVfbjKNY Open-source: GITHUB https://github.com/1803creations/Remembrance-PersistentWorld- Features: Plate / Name Matching automatically updates in game world Vehicle model / color updates automatic in Database Local Database: The main feature of this plugin Preloaded with 2500+ LSPDFR database names. Saves info to a local database that stays consistent across sessions. Names, vehicle plates, and citations/records stay the same. Vehicle model and color updates to the database as plates are changed. This allows the plugin to run without spawning people or cars and letting the game naturally spawn them. **If you don't come across a name in the database, you have the ability to add someone in the admin tool. Three ways to access the database: Internal Police Computer: Admin Tool: External Police MDT:

This is a LSPDFR plugin that goes into the GTA5\plugins\lspdfr folder. This plugin will change the vehicle registration owner (in LSPDFR and StopThePed /CompuLite) for vehicle models and owners defined in the ,ini fle. Note: Pictures currently pick a random face, I have not found a way to disable/blank/replace the photos that come up in CompuLite. Future Update Plans: Try to have plugin use same exact ped so when given citations, it will work when game is restarted. (Right now, just changes name) Try to update pictures (like a RON oil logo for Ron Oil Company ) Showcase: This plugin will change all the car "model" owners to be the owner defined in the ini file. In this example, we set "nspeedo" cars to be "Amazon Inc." and "Oiltanker" to be Ron Oil_CO. Yes, I am aware the nspeedo car spawned a fedex car during this showcase, the nspeedo car has many different liveries, in a real case scenario, I would make an Amazon Car with one livery as Amazon only, For the sake of this showcase, I showed that all "nspeedo" cars will spawn with "Amazon Inc."

These are textures for license plates. Made with AI and GIMP as the picture editor. Each texture is ready to be changed to "plate#.dds". The screenshot is to show multiple plates at once, that's not how the files actually come. Replace plate.dds files in vehshare default path: C:\Program Files (x86)\Steam\steamapps\common\Grand Theft Auto V\mods\update\x64\dlcpacks\patchday27ng\dlc.rpf\x64\levels\gta5\vehicles.rpf\ See my license plate script to change the numbers/letters on plates: Video: Note: YOU DO NOT NEED the additional add-on plate mod shown in this video. You only need to know how to replace the plates in the vehshare file and possibly change the carcols.ymt file if you want to change the format/colors of the text on the plates. The add-on is simply to show you how to add a variety of plates if you so wish. The add-on shown is not mine. The license plate changer script shown is mine.