Skip to content

TheXYZNetwork/PoliceRP-OpenSource

master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
August 31, 2021 18:00
cfg
August 17, 2021 15:43
August 17, 2021 15:43
August 17, 2021 15:43
August 17, 2021 15:43
August 17, 2021 15:43

PoliceRP

This is a reupload of the main PoliceRP server. The reason we didn't make the original repo public is because there is a lot of private data in the git history (Webhook/passwords/paid addon). Here is a fresh reupload with all the sensitive information removed.

What is included?

Included is the entire policerp server with any paid addons removed. Any public addons used are still in the repo. For the most part, you should be able to just load the server if you create the right database connections and manually create the tables for the required addons

THERE ARE ALSO ADDONS THAT WERE CONNECTED AS SUB MODULES, YOU CAN FIND THEM HERE.

Where can I find the hotload assets?

All the hotload assets can be found here in the exact same structure as the hotloader loads them. You can reupload these assets and change the domain.

The following paids addons were originally used

Table creation statements

Auction House

CREATE TABLE `auction_active_listings` (
 `id` int(255) NOT NULL AUTO_INCREMENT,
 `userid` varchar(255) NOT NULL,
 `name` varchar(255) NOT NULL,
 `model` varchar(510) NOT NULL,
 `price` int(255) NOT NULL,
 `quantity` int(255) NOT NULL,
 `type` varchar(255) NOT NULL,
 `class` varchar(255) NOT NULL,
 `length` int(255) NOT NULL,
 `data` text NOT NULL,
 `server` int(2) DEFAULT NULL,
 `current_bid` int(255) DEFAULT NULL,
 `ended` int(1) DEFAULT NULL,
 `created` int(255) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `current_bid` (`current_bid`)
) 
CREATE TABLE `auction_bids` (
 `id` int(255) NOT NULL AUTO_INCREMENT,
 `listing` int(255) NOT NULL,
 `userid` varchar(255) NOT NULL,
 `amount` int(255) NOT NULL,
 `created` int(255) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `listing` (`listing`),
 CONSTRAINT `auction_bids_ibfk_1` FOREIGN KEY (`listing`) REFERENCES `auction_active_listings` (`id`)
)
CREATE TABLE `auction_notifications` (
 `id` int(255) NOT NULL AUTO_INCREMENT,
 `userid` varchar(255) NOT NULL,
 `message` text NOT NULL,
 `created` int(255) NOT NULL,
 PRIMARY KEY (`id`)
)

Badges

	
CREATE TABLE `badges` (
 `userid` bigint(32) DEFAULT NULL,
 `badge` varchar(64) DEFAULT NULL,
 `progress` text,
 `complete` text,
 UNIQUE KEY `unique_index` (`userid`,`badge`)
)

Inventory

CREATE TABLE `inventories` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `userid` varchar(32) NOT NULL,
 `item` text NOT NULL,
 `data` text,
 PRIMARY KEY (`id`)
) 
CREATE TABLE `banks` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `userid` varchar(32) NOT NULL,
 `item` text NOT NULL,
 `data` text,
 PRIMARY KEY (`id`)
)

DMV

CREATE TABLE `dmv_license` (
 `steamid` text,
 `date` text,
 `points` int(11) DEFAULT '0'
)
CREATE TABLE `dmv_revokes` (
 `steamid` varchar(128) NOT NULL,
 `date` text NOT NULL,
 `total` int(11) NOT NULL DEFAULT '1',
 PRIMARY KEY (`steamid`)
) 

Economy Stats

CREATE TABLE `economy_stats` (
 `date` date NOT NULL,
 `circulating` bigint(64) NOT NULL
)

Gov Tags

CREATE TABLE `gov_tag` (
 `userid` varchar(32) NOT NULL,
 `tag` int(4) NOT NULL,
 PRIMARY KEY (`userid`)
)

Impound

CREATE TABLE `impound` (
 `id` int(32) NOT NULL,
 `impounder` varchar(32) DEFAULT NULL,
 PRIMARY KEY (`id`)
) 

Job Tracker

CREATE TABLE `job_tracker` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `userid` varchar(32) NOT NULL,
 `join` int(11) NOT NULL,
 `leave` int(11) DEFAULT NULL,
 `job` varchar(64) NOT NULL,
 `jobType` varchar(32) NOT NULL,
 PRIMARY KEY (`id`)
)
CREATE TABLE `job_tracker_promo` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `userid` varchar(32) NOT NULL,
 `promoter` varchar(32) NOT NULL,
 `time` int(11) DEFAULT NULL,
 `job` varchar(64) NOT NULL,
 `jobType` varchar(32) NOT NULL,
 `state` varchar(10) NOT NULL,
 PRIMARY KEY (`id`)
)

Meeting Logs

CREATE TABLE `meeting_logs` (
 `host_id` text,
 `dep` text,
 `reason` text,
 `length` int(11) DEFAULT NULL,
 `crime` tinyint(1) DEFAULT NULL
)

Mining

CREATE TABLE `mining_inv` (
 `userid` varchar(32) NOT NULL,
 `ore` varchar(32) NOT NULL,
 `amount` int(11) NOT NULL,
 UNIQUE KEY `unique_index` (`userid`,`ore`)
)

Orgs

CREATE TABLE `orgs` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` text NOT NULL,
 `xp` int(11) NOT NULL DEFAULT '1000',
 `funds` int(11) NOT NULL DEFAULT '0',
 `upgrades` json NOT NULL,
 `roles` json NOT NULL,
 `achievements` json NOT NULL,
 PRIMARY KEY (`id`),
 KEY `id` (`id`)
) 
CREATE TABLE `orgs_members` (
 `steamid` varchar(64) NOT NULL,
 `orgid` int(11) NOT NULL,
 `role` tinyint(4) NOT NULL,
 KEY `org` (`orgid`),
 CONSTRAINT `org` FOREIGN KEY (`orgid`) REFERENCES `orgs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) 
CREATE TABLE `orgs_inventories` (
 `orgid` int(11) NOT NULL,
 `item` text NOT NULL,
 `data` text,
 KEY `orgi` (`orgid`),
 CONSTRAINT `orgi` FOREIGN KEY (`orgid`) REFERENCES `orgs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
)

Play Time

CREATE TABLE `play_time` (
 `userid` text,
 `total` int(11) DEFAULT NULL,
 `last` int(11) DEFAULT NULL
)

PNC

CREATE TABLE `pnc_911` (
 `userid` varchar(32) NOT NULL,
 `name` varchar(128) NOT NULL,
 `reason` varchar(500) NOT NULL,
 `time` int(11) NOT NULL
)
CREATE TABLE `pnc_911_new` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `userid` varchar(32) NOT NULL,
 `name` varchar(128) NOT NULL,
 `reason` varchar(500) NOT NULL,
 `responders` text,
 `time` int(11) NOT NULL,
 PRIMARY KEY (`id`)
)
CREATE TABLE `pnc_confiscated` (
 `userid` varchar(32) NOT NULL,
 `username` varchar(32) NOT NULL,
 `officerid` varchar(32) NOT NULL,
 `officername` varchar(32) NOT NULL,
 `class` varchar(128) NOT NULL,
 `name` varchar(500) NOT NULL,
 `time` int(11) NOT NULL
) 
CREATE TABLE `pnc_tickets` (
 `userid` varchar(32) NOT NULL,
 `ticketby` varchar(32) NOT NULL,
 `time` int(11) NOT NULL,
 `charges` json NOT NULL
)
CREATE TABLE `pnc_arrests` (
 `userid` varchar(32) NOT NULL,
 `arrestby` varchar(32) NOT NULL,
 `time` int(11) NOT NULL,
 `charges` json NOT NULL
)

Quests

CREATE TABLE `quest_progress` (
 `userid` varchar(17) NOT NULL,
 `story_id` varchar(128) NOT NULL,
 `quest_id` int(32) NOT NULL,
 `data` text,
 `complete` tinyint(1) NOT NULL DEFAULT '0',
 `started` int(32) NOT NULL,
 `finished` int(32) DEFAULT NULL,
 UNIQUE KEY `unique_index` (`userid`,`story_id`,`quest_id`)
) 

Rewards

CREATE TABLE `rewards` (
 `userid` varchar(32) NOT NULL,
 `type` varchar(64) NOT NULL,
 `progress` int(32) DEFAULT NULL,
 `updated` int(32) NOT NULL,
 UNIQUE KEY `unique_index` (`userid`,`type`)
) 

Car Dealer

CREATE TABLE `vehicles` (
 `id` int(32) NOT NULL AUTO_INCREMENT,
 `userid` varchar(32) NOT NULL,
 `class` varchar(128) NOT NULL,
 `color` varchar(128) NOT NULL,
 `skin` int(2) NOT NULL,
 `bodygroups` varchar(256) NOT NULL,
 `mods` varchar(256) NOT NULL,
 `performance` varchar(256) NOT NULL,
 `damage` varchar(256) NOT NULL,
 PRIMARY KEY (`id`)
)

Chat Tags

CREATE TABLE `user_tags` (
 `userid` varchar(255) NOT NULL,
 `tag` text,
 `color` text,
 PRIMARY KEY (`userid`)
)

Weapon Skins

CREATE TABLE `wep_skins` (
 `userid` varchar(32) NOT NULL,
 `wep` varchar(128) NOT NULL,
 `skin` varchar(64) NOT NULL,
 UNIQUE KEY `unique_index` (`userid`,`wep`)
)

Christmas Content

CREATE TABLE `christmas_credits` (
 `userid` varchar(32) NOT NULL,
 `credits` int(11) DEFAULT NULL,
 PRIMARY KEY (`userid`)
) 
CREATE TABLE `advent_doors` (
 `userid` varchar(32) NOT NULL,
 `door` int(11) DEFAULT NULL,
 `reward` varchar(32) NOT NULL
)

xStore extra

The server specific xStore tables are auto generated, but these need to be manually made

CREATE TABLE `credits` (
 `userid` varchar(32) NOT NULL,
 `credits` int(11) NOT NULL,
 PRIMARY KEY (`userid`)
)
CREATE TABLE `credit_logs` (
 `userid` varchar(32) NOT NULL,
 `type` varchar(32) NOT NULL,
 `creditchange` int(11) NOT NULL,
 `cost` int(11) NOT NULL,
 `netcredits` int(11) NOT NULL,
 `date` varchar(32) NOT NULL
)

About

An open source release of our main PoliceRP server

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages