Module 07 · Lesson 22, Capstone

Capstone: a mini bank, step by step

By the end of this lesson you will run a working /bank command that lets a player deposit cash, withdraw cash, and check a balance saved in MariaDB. The balance lives only on the server, and a withdraw larger than the balance is refused. That refusal is the capstone idea: the server holds the truth, so the client cannot lie its way to free money.

You'll build: qu_bank: one balance table in MariaDB and one server file that runs /bank deposit, withdraw, and balance.
Time: About 60 minutes if you have never used oxmysql before.
Prereqs: Lessons 14 (events), 15 (callbacks), and 16 (ox_lib menus).
Outcome: A bank a cheater cannot drain, because the server holds the truth and rejects a withdraw larger than the balance.

Cruze builds an ATM robbery with ox_lib, the same server-authority pattern.

BEFORE YOU START

Build it

Make the resource folder

The server has one folder for this lesson.

Inside your server's folder, create this folder:

Capstone: a mini bank, step by step

Build it

Make the resource folder

Create the files

Write fxmanifest.lua

Create the balance table

Write the lesson code

Start and test it

Keep reading the full lesson