📃Installation

Installation for KS-Bank

1

DRAG AND DROP

Drag KS-Bank into your resources folder.

2

Ensure the script is started in your server.cfg

ensure KS-Bank

3

Import the SQL file provided into your database.

CREATE TABLE IF NOT EXISTS `ks_bank` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `account_type` varchar(20) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `balance` int(11) DEFAULT 0,
  `investments` int(11) DEFAULT 0,
  `income` int(11) DEFAULT 0,
  `expenses` int(11) DEFAULT 0,
  `saved_credentials` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `owner_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `iban` varchar(8) DEFAULT NULL,
  `photo` text DEFAULT NULL,
  `debit_card` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `prepaid_card` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'none',
  `credit_card` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'none',
  `last_debit_regeneration` timestamp NULL DEFAULT NULL,
  `last_credit_regeneration` timestamp NULL DEFAULT NULL,
  `last_prepaid_regeneration` timestamp NULL DEFAULT NULL,
  `crypto` decimal(25,6) NOT NULL DEFAULT 0.000000,
  `selled_crypto` decimal(25,6) NOT NULL DEFAULT 0.000000,
  `buyed_crypto` decimal(25,6) NOT NULL DEFAULT 0.000000,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nome_utente` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `ks_bank_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_username` varchar(50) NOT NULL,
  `sender_fullname` varchar(50) NOT NULL,
  `sender_iban` varchar(50) NOT NULL,
  `receiver_username` varchar(50) NOT NULL,
  `receiver_fullname` varchar(50) NOT NULL,
  `receiver_iban` varchar(50) NOT NULL,
  `amount` decimal(18,8) DEFAULT NULL,
  `reason` varchar(255) NOT NULL,
  `transaction_date` timestamp NULL DEFAULT current_timestamp(),
  `payment_type` varchar(50) NOT NULL,
  `transazione_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `transazione_id` (`transazione_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `ks_warehouse` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` varchar(50) NOT NULL,
  `size` varchar(20) NOT NULL,
  `invqt` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]',
  `rigqt` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]',
  `wrname` varchar(50) DEFAULT NULL,
  `access_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]' CHECK (json_valid(`access_list`)),
  `kw_consumption` int(11) DEFAULT 0,
  `crypto_balance` int(11) DEFAULT 0,
  `is_active` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

4

Install dependencies if not already present:

• ox_lib

• ox_target

• ox_inventory

5

Configure the script in the KS-Bank/shared/config.lua file based on your server's needs.

📬 Need Help or Support?

If you have any questions, need help with setup, or want to report a bug, feel free to join our support Discord:

👉 Join our Discord server

We're happy to help and welcome all feedback and suggestions!