Jump to content
×
×
  • Create New...

2 Screenshots

This mod adds all police stations, county sheriff offices, highway patrol, and the 3 federal agencies to your cad. When you install this, it will replace your current departments and is intended for first time server set up to save you the time it would normally take to create departments.

 

Adds a total of 18 departments to CAD
9 Los Santos Police Department
Mission Row
Davis Sheriff
Vinewood
La Mesa
Paletto Bay
Vespucci
Rockford Hills
Vespucci Beach
Del Perro

 

3 County Sheriffs
Sandy Shores
Los Santos County Sheriffs 
Blaine County Sheriff Office (BCSO)

 

2 Park Rangers
Beaver Bush Rangers
San Andreas State Park Rangers

 

1 San Andreas State
San Andreas Highway Patrol (SAHP)

 

3 Federal Agencies
Federal Investigation Bureau (FIB)
International Affairs Agency (IAA)
National Office of Security Enforcement (NOOSE)

 

Please note, this is compatible with both FivePD 1.1 and 1.2. This was created during FivePD 1.1. As of FivePD 1.2, you no longer need a database to play FivePD when you change the config.json from mysql to sqlite. To install Lore Friend CAD Departments, you must use mysql and not sqlite as you need a database through MyphpAdmin that is launched from XAMPP, which sqlite does not use. There are instructions in BGHDDevelopment FiveM Server + FivePD(V.1.1) - Full Setup/Install Tutorial on how to create a database. 

 

If you already have departments installed this will replace them entirely. 

 

Installation:

1. Download the rar file.

2. Extract using a program like WinRAR, WinZip or 7Zip.

3. Open your database using XAMPP.

4. Click on the FIVEPD link e on the sidebar on the left to open your database.

5. Find "departments." Click "Drop." This will delete your existing department to make room for the new ones.

6. A warning box will pop up saying you are about to destroy a complete table. Leave the checkbox checked and click OK. 

7. At the top bar, click Import.

8. Next to "Browse your computer": Click "Choose file."

9. Locate departments.sql where you extracted it and click "Open."

10.  Click "Go" in the bottom right corner.

11. At the top of the page it should have a green checkbox and say "Import has been successfully finished". Close your database and restart your server.

 

Known Bugs:

If you have more than 21 departments total you will be unable to see any departments beyond the 21stdepartment when you go to delete departments in game. 

Edited by Peelster1
Adding a known bug


What's New in Version 1.0.0   See changelog

Released

No changelog available for this version.

Peelster1

Q: Why does it fail to upload to my database?

A: You need to delete your existing departments listing first. Make sure you did step 5 in the installation guide.

 

Q: How can I change the order the departments are in?

A: Open departments in your phpMyAdmin database, click edit next to the department that you want to move and change the ID number. Lower numbers will appear at the beginning of your CAD.

It is very important that you do not change the department ID number if already have members in your department. It will lock them out of the departments CAD if the ID number they joined no longer exists, and they will be unable to join other departments with a message stating they are already in a department, but they will be unable to access their department to leave it if the ID number they joined no longer exists.

Same thing with reports and ranks. If you change the ID of your department, any reports created before the change will not carry over and will appear under a different department if you assign another department that ID number. So if you want your reports to stay with the department, do change the ID number of the department.

 

Q: This was created for FivePD 1.1.4. Is it compatible with FivePD 1.2.8?

A: Yes! You must make sure you have a database created and are using "mysql" and not "sqlite" in config.json This will only work with MySQL and not SQlite.. Follow the beginning of BGHDDevelopment FiveM Server + FivePD(V.1.1) - Full Setup/Install Tutorial  before installing FivePD 1.2 to see how to setup the database. You will also need to make sure your config.json file has "mysql" at the top and not "sqlite". This will not work with sqlite as sqlite does not use a database..

 

Q: Can I keep these departments if I upgrade from FivePD 1.1 to FivePD 1.2.

A: Yes, if you use MySQL ant not SQlite. As FivePD 1.2 is a much different version from FivePD 1.1 it is recommended by FivePD's staff that you make a fresh install by deleting your FivePD folder from your server-data folder and downloading the new one. This will not affect your database you created in any way or your server key. So if you want to keep your departments from the previous version, use mysql in config.json and not sqlite and you can use your original server key from the previous install of FivePD. You will still need to launch with XAMPP if you do this. Where sqlite does not use XAMPP., it is required when using mysql. You will also be able to keep your ranks, reports and members as they were as well.

 

Q: Is this compatible with Ranks SQLs?

A: No. Ranks must be set up for each individual department. Therefore with 18 different departments, there would have to be 18 different ranking lists inside of one Ranks.sql file. I intended this more for players who are playing alone on their localhost where ranks are not needed. I have no plans to make Ranks for this departments SQL.

Feel free to edit.

If you want to distribute/reupload, please give credit to Peelster1.

  • Like 3

User Feedback

Recommended Comments

Please note: This was last tested on FivePD v1.1.4. As such, when this was created the department limit was 100 people. It has be increased to 1000 people per department with the 1.2 update, but not in this mod. 

 

Due to FivePD 1.2+  having merged MySQL and SQLite and not necessarily needing a database the old way, the installation method may be different or may not work. If anyone using 1.2+ has successfully installed this, and there are any changes to how it is installed, or if the installation does not work at all, please comment with any differences if it works or if it does not. 

Edited by Peelster1
Link to comment
Share on other sites
On 11/8/2020 at 10:00 PM, DoubleTrouble56 said:

Does this work with the latest version or do I have to wait for it to get updated? Thank you for you're time

 

     Double

I am told there are not too many differences, so I think it should work, but it is untested. Try installing it and let me know if you run into any problems. If it doesn't work, you may be using a different type of SQL, in which case I would recommend trying Conway's SQL Departments

Link to comment
Share on other sites

Update: This still works as of FivePD 1.2.8. However, you must have a database. Therefore, this will only work with MySQL and not SQlite.. Follow the beginning of BGHDDevelopment FiveM Server + FivePD(V.1.1) - Full Setup/Install Tutorial  before installing FivePD 1.2 to see how to setup the database. You will also need to make sure your config.json file has "mysql" at the top and not "sqlite". This will not work with sqlite as sqlite does not use a database.

 

I have also updated the FAQ.

Edited by Peelster1
Link to comment
Share on other sites

Doesnt work for me, I installed it and shows the departments but when I try to join any of them it says error joining department

Link to comment
Share on other sites
On 3/8/2021 at 9:45 PM, StarLord said:

Doesnt work for me, I installed it and shows the departments but when I try to join any of them it says error joining department

I'm sorry it didn't work for you. It may be that it is out of date now. I last updated it in November of 2020 and there have been several FivePD updates since. It is interesting that it seems you were able to install it but you cannot join a department. Normally I would expect the departments not to show up if the install didn't work. I don't believe I will be able to offer technical support for your issue without seeing the installation process from the beginning. When I have some spare time I will run through a fresh install using the current version of FivePD to see if I can get it to work. Sorry for the delayed response. I rarely check here anymore.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Add a comment...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    No registered users viewing this page.

Important Information

Please view the site: Terms of Use, Privacy Policy, and Guidelines. // IMPORTANT: We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.