tB7k2Lum

1function bankinitTable()
2
3	MySQLite.begin()   // <---------------- idk if you even need this, I saw it in sv_data.lua
4
5	MySQLite.query([[
6             CREATE TABLE IF NOT EXISTS darkrp_bank(
7             uid BIGINT NOT NULL PRIMARY KEY,
8             rpname VARCHAR(45),
9             salary INTEGER NOT NULL DEFAULT 45,
10             wallet INTEGER NOT NULL
11             bank INTEGER DEFAULT 1000
12            );
13	]])
14
15	MySQLite.query([[
16	INSERT INTO darkrp_bank
17	(uid, rpname, salary, wallet)
18	SELECT (uid, rpname, salary, wallet)
19	FROM darkrp_player;
20	]])
21end
22
23function GM:Initialize()
24	bankinitTable()
25end
26
27
28function DarkRP.storeBank(ply, amount)
29	MySQLite.query([[UPDATE darkrp_player SET wallet = ]] .. -amount .. [[ WHERE uid = ]] .. ply:UniqueID() .. [[ OR uid = ]] .. ply:SteamID64())
30	MySQLite.query([[UPDATE darkrp_bank SET bank = ]] .. amount .. [[ WHERE uid = ]] .. ply:UniqueID() .. [[ OR uid = ]] .. ply:SteamID64())
31end