Installation guide

Full guide to install the crypto money washer script.

Requirements

• Latest ESX framework

• OXMysql

1. OXMysql

To run the crypto money washer script, oxmysql must be installed and running on the server. https://github.com/overextended/oxmysql

2. SQL

Run the sql query on your mysql client

INSERT INTO `jobs` (`name`, `label`) VALUES ('hacker', 'Hacker');
INSERT INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES ('hacker', 0, 'recruit', 'Recruit', 0, '{}', '{}');
INSERT INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES ('hacker', 1, 'boss', 'Boss', 0, '{}', '{}');
INSERT INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`) VALUES ('computer', 'Computer', 1, 0, 1);
INSERT INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`) VALUES ('bag_of_cash', 'Bag of cash', 1, 0, 1);

CREATE TABLE `acn_bit2cash_transactions` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`identifier` VARCHAR(46) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`amount` INT(11) NULL DEFAULT NULL,
	`transaction_id` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`used` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	PRIMARY KEY (`id`) USING BTREE
)

CREATE TABLE `acn_bitcoins_amount` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`identifier` VARCHAR(46) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`wallet` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`currency_name` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
	`amount` DECIMAL(20,6) NOT NULL DEFAULT '0.000000',
	PRIMARY KEY (`id`) USING BTREE
)

CREATE TABLE `acn_bitcoin_value_rate` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`value` DECIMAL(10,2) NOT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
CREATE TABLE `acn_items_on_sale` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`player_identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb3_general_ci',
	`item_unique_ID` BIGINT(10) NOT NULL DEFAULT '0',
	`item_type` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
	`item_name` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
	`item_quantity` INT(11) NOT NULL,
	`item_price_bitcoins` DECIMAL(20,6) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)

CREATE TABLE `acn_player_levels` (
	`Identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb3_general_ci',
	`cut_level` INT(11) NULL DEFAULT '0',
	`alert_level` INT(11) NULL DEFAULT '0',
	`marketfee_level` INT(11) NULL DEFAULT '0',
	`farm_level` INT(11) NULL DEFAULT '0',
	`edrugs_level` INT(11) NULL DEFAULT '0',
	`vpn` INT(11) NULL DEFAULT '0',
	`stock` INT(11) NULL DEFAULT '0',
	`rack_status` INT(11) NULL DEFAULT '0',
	PRIMARY KEY (`Identifier`) USING BTREE
)

3. Restart

The server console must be restarted, or offline before attempting to run the script.