[Release] CameraTech by Albo1125 (ANPR/ALPR system)

FiveM Resource Development & Modding Releases
, , , ,
45

Hi all,

Sorted this issue out!

Use the following to set up the ANPR table in your database:

CREATE TABLE anpr (

colour varchar(60) COLLATE latin1_bin NOT NULL,

model varchar(60) COLLATE latin1_bin NOT NULL,

anprname varchar(60) COLLATE latin1_bin NOT NULL,

dir varchar(60) COLLATE latin1_bin NOT NULL,

plate varchar(60) COLLATE latin1_bin NOT NULL,

marker varchar(60) COLLATE latin1_bin NOT NULL,

time varchar(60) COLLATE latin1_bin NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

After, change the following fields:

In _resource.lua:

Line 12 uncomment.

In sv_CameraTech.lua:

Uncomment anything to do with the database.

This will now save any anpr hits to the database, so if you have a website you can then create the connection to the database to show the results.

46

Is there theoretically, any way that this is able to be linked to a Sonoran CAD Database using your technique, Shane?

47

It’s not one that I am fluent with mate, apologies regarding this!

Hopefully someone can come along and help you :slight_smile:

48

Can we add ensure CameraTech in server.cfg instead?

49

ensure and start do the exact same thing when used in the server.cfg, and it really doens’t matter which one you put in there

1 Like
50

Thanks

51

anyone know why when i use commnads like /anpr or /anprinterface , ESX server , not using SQL side of script

52

boots officers off the server with error codes when a clocked car gets hit via a camera