📃Installation

Installation for KS-Bank

1

DRAG AND DROP

Drag KS-Bank into your resources folder.

2

Add to server.cfg

To ensure the script functions correctly, it must be started after its dependencies. The resource relies on ox_lib, ox_inventory, and a targeting solution (either ox_target or qb-target).

Open your server.cfg and ensure your start order looks like this:

# --- Dependencies ---
ensure ox_lib
ensure ox_inventory

# Choose your target system:
ensure ox_target 
# OR 
# ensure qb-target

# --- Katana Kraft Bank ---
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` bigint(20) NOT NULL DEFAULT 0,
  `investments` bigint(20) NOT NULL DEFAULT 0,
  `income` bigint(20) NOT NULL DEFAULT 0,
  `expenses` bigint(20) NOT NULL 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(20,6) NOT NULL DEFAULT 0.000000,
  `selled_crypto` decimal(20,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=303 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `ks_bank_loans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `amount` int(11) NOT NULL,
  `installments` int(11) NOT NULL,
  `interest_percent` float NOT NULL,
  `interest_amount` int(11) NOT NULL,
  `rate_amount` int(11) NOT NULL,
  `guarantee_amount` int(11) NOT NULL,
  `remaining_amount` int(11) NOT NULL,
  `installment_interval_hours` int(11) NOT NULL,
  `paid_installments` int(11) NOT NULL DEFAULT 0,
  `start_time` int(11) NOT NULL,
  `next_installment_time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_active_loan` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_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 DEFAULT 'N/A',
  `receiver_username` varchar(50) NOT NULL,
  `receiver_fullname` varchar(50) NOT NULL,
  `receiver_iban` varchar(50) NOT NULL DEFAULT 'N/A',
  `amount` bigint(20) NOT NULL,
  `amount_crypto` decimal(18,8) DEFAULT NULL,
  `reason` varchar(255) NOT NULL,
  `transaction_date` timestamp NULL DEFAULT current_timestamp(),
  `payment_type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25
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` decimal(20,6) DEFAULT NULL,
  `is_active` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

4

Install dependencies if not already present:

• ox_lib

• ox_target or qb-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!