opencad-community / opencad-php

Open Source Computer Aided Dispatch System for Roleplay Communities.

<p align="center">

---

OpenCAD

Open Source Computer Aided Dispatch System for Roleplay Communities.

Installation Requirements

• Operating System: Linux or Windows
• Webserver: Apache, IIS, or Nginx
• PHP: 7.3 (Recommended), 7.2 (Minimum)
• Database: MySQL >=5.5 or MariaDB >=10.0 (Recommended Version: 10.3)

Deployment Notes

Unsupported Environments

• Free hosting of any kind
• XAMPP

Important Notes

• This has been tested to work on Linux, Windows and cPanel.
• The OpenCAD Development team DOES NOT recommend the utilization of "free" webhosting solutions due to a multitude of reasons. We suggest Spearware Networks for web hosting.

Support

Need Help? View our Documentation which has all the documentation you need.

Still Having Trouble? on the community Discord post your issue in #general-help.

License

Do you suspect someone of violating the license of OpenCAD or plagiarizing code? Please send these reports to our security desk.

opencad-php's Issues

Adding subusers

From @justinfarmer14 on August 30, 2017 5:49

Issues adding assigned users to additional departments

Copied from original issue: phillf/openCad#5

Security issues

Expected behavior

1. Have CSRF protection.
2. Have session hijacking protection
3. Never ever output errors in production.
   1. https://github.com/StormlightTech/openCAD-php/blob/development-stable/actions/api.php#L101
   2. https://github.com/StormlightTech/openCAD-php/blob/development-stable/actions/api.php#L126
   3. https://github.com/StormlightTech/openCAD-php/blob/development-stable/actions/api.php#L309
   4. And more!

Actual behavior

• Nothing of the listed

Update Readme

From @XxROBOTICSxX on September 2, 2017 20:35

Would you be able to update the Readme with proper installation instructions, requirements, and information on how to create the first user account/admin accounts.

Copied from original issue: phillf/openCad#21

cant reject or accept or even view Civ identiy requests

unable to reject accept or even view a civ identity request possible work around direct add to the database dropping the need to approve

Random User ID

Should each user that is created have a randomly generated ID assigned to them rather than it be sequential? This would definitely improve security.

Spelling mistakes in README

Note: This could probably run on Apache/PHP/MySQL under Windows but was developed primarily in a Linux environments.

was developed in a Linux environments <-- Singular or plural, decide

Join the our Discord and someone will be able to help.

Join the our <-- the discord, or our discord, decide

cant access profile.php from admin.php

When your on admin.php
you click on your user profile and click on My profile it comes to an error with

/profile/profile.php

folder profile doesnt exist and profile.php is in main directory

SQL Query Error when Importing SQL Database

From @MrSmallZzy on August 31, 2017 17:34

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
issued_by text CHARACTER SET latin1 ' at line 6

Copied from original issue: phillf/openCad#16

Missing Api.php

Expected behavior

when you copy the files from the rar to the HTdocs it looks for api.php

Actual behavior

its missing from RC1

Steps to reproduce behavior

download the latest project

Support environment running older PHP releases.

From @ItsAGeekThing on September 3, 2017 1:43

Currently, openCad in its current state only supports PHP >= 5.5.
Unfortunately, a lot of hosting providers have not yet updated their offerings to include later versions of PHP. In order to put openCad in the hands of more people, it would be a good idea to provide support for environments running PHP < 5.5.

OpenCad requires the function password_hash which was introduced in PHP 5.5.
It shouldn't require too much effort to backport this individual function to expand compatibility with a wider range of environments.

Copied from original issue: phillf/openCad#24

Implement Steam Account Authentication

From @phillf on August 31, 2017 1:39

Copied from original issue: phillf/openCad#11

Civillian page not working

Enviorment Information

• Operating System: Windows 10
• PHP Version: 5.6.25
• MySQL Version: 5.7.14
• Web Server: wamp64 apache
  • Version: 3.0.6 apache: 2.4.23

Logs (if applicable)

Please use GitHub Gist.

• PHP Logs: https://gist.github.com/rhys19/dffb0ae4195ebfd9a0a9da54bdda99bb
• Web Server Logs: https://gist.github.com/rhys19/d386cf328cd075de73358fd94122893e
• MySQL Logs: https://gist.github.com/rhys19/622e0ae653346764c6031d263a3a91f4

civillian page shows a yellow box which usally is an error

image: https://gyazo.com/d88fe78900220076c7081c40a3c49503

Fix travis configuration

Expected behavior

• Travis dev should build.

Actual behavior

• Your travis build fails because it's not configured correctly.

Steps to reproduce behavior

• Look at your travis dev build: https://travis-ci.org/StormlightTech/openCAD-php

Citizens request

From @justinfarmer14 on August 30, 2017 5:47

Citizens aren't able to submit identity requests

Copied from original issue: phillf/openCad#4

Evaluate introducing Trello into our workflow.

In order to improve efficiency at managing issues and pull requests, we should evaluate adding Trello into our backend workflow. Trello will also allow us to prioritize new features and consolidate development.

Should we implement Trello into our workflow?

Unable to assign a call

From @Ramius1701 on August 31, 2017 2:59

Seem to be having issues assigning a call to a particular unit

Still shows as unassigned

Any thoughts on this?

Copied from original issue: phillf/openCad#15

Civilians

From @justinfarmer14 on September 1, 2017 20:50

Civilian are unable to register them selves I did what you suggested and formatted the database and imported the SQL file but still doesn't work

Copied from original issue: phillf/openCad#19

Application Icon Set

Improving the graphics set of openCAD would be a good idea. We definitely need a logo and icons for each subsequent application.

undefined variable on userManagement.php

on the userManagment an error occurs at the following undefined variable

Notice: Undefined variable: community in oc-admin\userManagement.php on line 273
CAD System

Police Page wont open

From @Dooms192 on August 30, 2017 17:50

Every time I try and open the Police page (responder.php) it signs me out. Is this common?

Copied from original issue: phillf/openCad#9

Perform a security audit of openCAD.

#26

Import Street Name into DB

A table for street names exists but is not populated.

Renaming of CAD Consoles

From @phillf on August 31, 2017 1:25

So I am going through and renaming the different CAD consoles to be more representative. In my next commit they won't be in sub-folders either, however I need a suggestion of the name of the civilian console. Here are the names for the others:

• Law Enforcement/Fire/EMS – mdt.php
• Dispatch – cad.php

I was also thinking about merging all the "responder" buttons on the launcher in to one but I think I am going to leave them separate because I think eventually I want to build in the capability of customisations (ie. maps, notice boards, etc...) on a per department basis.

Copied from original issue: phillf/openCad#10

missing direction.php

under oc-admin/userManagement.php

cad direction page its missing from the actions folder

Test Issue.

Test Issue.

Introduce an online installer to automate deployment.

From @ItsAGeekThing on September 3, 2017 1:36

Introduce an installer to automated deployment.

Copied from original issue: phillf/openCad#23

Close reopened issues from repo migration.

Issues that were previously marked as closed in the old repo are now open after being migrated over. We need to close issues that have already been addressed.

Status Bug

From @MinnesotaJames on August 30, 2017 0:40

Currently trying to resolve an issue related to setting your status available verse unavailable. Screenshot provided below.

Maybe because of how the SQL is set the statuses table is null.

Copied from original issue: phillf/openCad#3

Error when approving new members

After clicking "approve" on a new member, the next screen is a white page with "Duplicate entry '0-4' for key 'PRIMARY'"

Mysql injections

i was notified by a member on discord mysql injection is possible assign to Anthony for security flaw

ncicAdminActions.php missing acceptRequest and showDetails functions

From @phillf on August 29, 2017 16:25

Copied from original issue: phillf/openCad#1

Trying to input your 'openCad_Initialization.sql'

From @DoJoMan18 on August 29, 2017 19:39

I'm getting a error when I try to input your .sql file. Could you please help me?
---------Dutch--------
Fout
SQL-query:

CREATE DATABASE IF NOT EXISTS "opencad"
MySQL meldt: Documentatie

#1064 - Er is iets fout in de gebruikte syntax bij '"opencad"' in regel 1

---------English [Translated]--------
Error
SQL-query:

CREATE DATABASE IF NOT EXISTS "opencad"
MySQL Reports: Documentation

#1064 - There is something wrong in the syntax used '"opencad"' on line 1

---

Copied from original issue: phillf/openCad#2

Not Operable from a Sub-Directory

Enviorment Information

• Operating System: Ubuntu 16.04 LTS
• PHP Version: 7.0
• MySQL Version: MariaDB 10.2
• Web Server: Apache 2.4.18
  • Version: N/A (Pre RC1)

Logs (if applicable)

Please use GitHub Gist.

• PHP Logs:
• Web Server Logs:
• MySQL Logs:

Expected behavior

Be functional when installed in a sub-directory.

Actual behavior

When installed in a sub-directory multiple JS errors occur.

Steps to reproduce behavior

1. Follow base installation instructions and install in a sub-directory (eg. opencad).
2. Login and navigate to the MDT (LEO/Rescue).

Accessibility Testing

@Cambridgeport90: Once we are push RC1 can you perform an accessibility audit?

NCIC actions

From @justinfarmer14 on August 30, 2017 5:53

Administration isnt able to add date of birth manually or change said user

Copied from original issue: phillf/openCad#7

My Status on responder,php not updating

From @Ramius1701 on August 31, 2017 2:25

The My Status box is grayed out even if the status was already chosen.

Might be helpful to not have it ask for a call sign every time you enter the page, there is already a change call sign button on the sidebar

Copied from original issue: phillf/openCad#13

Moving NCIC items to sidebar

From @Ramius1701 on August 31, 2017 2:13

It might be easier for navigation purposes to move the NCIC items to the sidebar.

Here is the thinking, Having them on the dispatch page and searching for a particular person, plate, etc could produce multiple results. Hench having them on their own page might be easier for viewing

Thoughts?

Copied from original issue: phillf/openCad#12

Search Option

From @Ramius1701 on August 31, 2017 2:50

Very helpful when you want to find previous calls to a particular address, person, vehicle, etc.

Copied from original issue: phillf/openCad#14

Report SENSITIVE Bug Reports (i.e. security vulnerabilities)

Hey everyone,
We have a new system in place to handle sensitive bug reports (i.e. security vulnerabilities).

Simply send an email to [email protected] and the report will automatically be sent to the right place! Pretty cool, right?
Submit a bug report through this email as if you were sending one on GitHub. Thanks!

(Abuse of this email will get yourself blacklisted. 👎 )

Ncic actions

From @justinfarmer14 on August 30, 2017 5:59

unable to edit any of user data in ncic data base

Copied from original issue: phillf/openCad#8

admin actions

From @justinfarmer14 on August 30, 2017 5:51

issue returning said user when adding users to sub groups that it gives you the id rather redirecting back

Copied from original issue: phillf/openCad#6

Unable to View current status in mdt.php

When viewing mdt.php users are unable to view their current status however they are able to change their status and it is accurately reflected in cad.php.

Remove vendor folder from source-control

Expected behavior

• Very bad practice!
  https://stackoverflow.com/a/30356071

Actual behavior

• You have the vendors directory in source control....

Steps to reproduce behavior

• Look at your repository.

BOLO Display on Dashboard

From @justinfarmer14 on September 1, 2017 21:10

Why not have it where when someone dispatches a bolo all officer can see it when the open up the cad

Copied from original issue: phillf/openCad#20

Ncic admin

From @justinfarmer14 on September 1, 2017 10:2

hey man after reinstalling it and using the new sql im unable to look up license plates now

Copied from original issue: phillf/openCad#17

Enhanced Dashboard

The current state of dashboard.php leaves a bit to be desired. Here are a few ideas to improve it:

• Design the page to look like the Office 365 dashboard page
• Introduce "Recent Cases" and "Recent Scenarios" section showable based on user groups.
  • Maybe split out "Recent Cases" to be based on a per-department basis for those who are in multiple departments.

Implement support for users to add custom PAL destinations.

Have users be able to edit PAL links and customize them
i have templates they can copy off of ¯_(ツ)_/¯

php error

From @justinfarmer14 on September 1, 2017 20:30

hi im attaching this error log as i just pasted droped and edited the database connection

error_log-converted.txt

Copied from original issue: phillf/openCad#18

Implent a Oauth2 login flow

Implement the ability to provide client authorization via a Oauth2 provider.

This supersedes #7.

discord

From @justinfarmer14 on September 3, 2017 1:5

hey your discord link has expired

Copied from original issue: phillf/openCad#22