I would love to see an option for an editable MDC where you can write reports. For example, when you pull over a suspect and check their license, the details are added to a page where you can write notes and input information such as car make, model etc. There could also be an option to check past records (or at least the past 10 or so) with the rest being stored locally on the computer or online.

Would these features be feasible? Would there be a way that your personal records could be pulled up along with the database records, assuming there was ever a match?

Well if you think about it, It would be a nice feature, but LCPD:FR is more for just responding to calls and having a good time; not filling out paperwork. Other than that, the names of the civilians are always completely random so there is a slim to none chance that you will run into the same name twice.

This isn't a hard feature to code into the system, however it would require a massive amount of SQL storage to contain the data stored by hundreds of thousands of users. A simple function that checks if someone by the name you've entered is already in the system, then it gives you the option to add notes, and if it's not exciting already it could simply input the name and data to a new field. Not too hard in theory. I like the idea.

Me and another member are working on this already

Yes, this is coming in the LCPDFR in-game computer soon. 

This isn't a hard feature to code into the system, however it would require a massive amount of SQL storage to contain the data stored by hundreds of thousands of users. A simple function that checks if someone by the name you've entered is already in the system, then it gives you the option to add notes, and if it's not exciting already it could simply input the name and data to a new field. Not too hard in theory. I like the idea.

The challenge for us when recording game data from thousands of users is making sure the database stays responsive and is indexed correctly. We have terabytes of storage, so storage isn't a problem for us -- indexing the data and making it efficent is the hard part.

Yes, this is coming in the LCPDFR in-game computer soon. 

The challenge for us when recording game data from thousands of users is making sure the database stays responsive and is indexed correctly. We have terabytes of storage, so storage isn't a problem for us -- indexing the data and making it efficent is the hard part.

Ah, I see the issue. I'm not too sure what functionality C# has for database manipulations. Is it at all possible to use PHP or SQL within the C# language inside of the game engine it's self? If so, I can think up a few ways to get past that, but none of which are too stable. 

Ah, I see the issue. I'm not too sure what functionality C# has for database manipulations. Is it at all possible to use PHP or SQL within the C# language inside of the game engine it's self? If so, I can think up a few ways to get past that, but none of which are too stable. 

I'm talking mostly of the limitations of MySQL. We don't use SQL at all in C# or in LCPDFR, LCPDFR just sends the information to our masterserver (which is coded in node.js and MySQL).

I'm talking mostly of the limitations of MySQL. We don't use SQL at all in C# or in LCPDFR, LCPDFR just sends the information to our masterserver (which is coded in node.js and MySQL).

 

Oh, I see. I haven't seen the code, so I have no idea what'd work in this situation, but assuming a function would be run each time a user entered data to the table, you could, in theory, use the WAITFOR() method of SQL to prevent it from stacking on top of it's self. For example, WAITFOR DELAY '00:00:02' would pause it for two seconds I believe, between each entry.