Banking

Basic Installation

• Put the snipe-banking resource in your resources folder and ensure it in server.cfg at the end

• If you use any of the following management system mentioned below, check the steps your need to take.

Config Changes

• If you have renamed your qb-core folder, es_extended folder or any other events, make sure to change them at respective places. If you use the base qb-core or es_extended, you dont need to change anything in Config.FrameworkTriggers

• If you are using ESX, make sure to read comments near Config.JobAccounts before turning it true.

• Config.DefaultIdentifier is the identifier to whom the loans will be transferred when a player who gave out loans, deletes his character.

• Read through the comments for other config options properly before making changes.

JOB Accounts

• snipe-banking has the option to automatically detect the jobs on every server restart and create an entry for it in the database so you dont have to manually add anything in there.

• If you are using QBCore, just make sure you add a isboss = true for any job/gang grade in your jobs.lua file and it will automatically detect it as a job account.

• If you are using ESX, just set one of the grade names as boss and it will automatically detect it as a job account.

QB-Management Conversion (Only if you use qb-managament.) DO NOT MAKE THIS CHANGES IF YOU USE renewed-banking

• Restart the server. Make sure nobody connects the server.

• Run the command convertqbmanagement in your server console once the server is up.

• This will also move all the job money from management_funds into my database.

• Restart the server again.

• Go to qb-management/fxmanifest.lua and comment the following code. It should look like this.

-- server_exports {
--     'AddMoney',
--     'AddGangMoney',
--     'RemoveMoney',
--     'RemoveGangMoney',
--     'GetAccount',
--     'GetGangAccount',
-- }

• Go to qb-management/client/cl_boss.lua and comment the following code.

https://ibb.co/r0BJs1Z

• Go to qb-management/client/cl_gang.lua and comment the following code.

https://ibb.co/7pJNyq5

• This will make sure the jobs wont be able to deposit/withdraw money from management_funds and will use my database instead.

Renewed Banking

• Restart the server. Make sure nobody connects the server.

• Run the command convertrenewed in your server console once the server is up.

• This will move everyone's personal account money into their bank account and delete the personal account information.

• This will also move all the job money from bank_accounts_new into my database.

• Restart the server again.

QB Banking

• Restart the server. Make sure nobody connects the server.

• Run the command convertqbbanking in your server console once the server is up.

• This will move everyone's personal account money into their bank account and delete the personal account information.

• This will also move all the job money from your tables into my tables.

• Restart the server again.

QBCore

Changes in qb-core

• Look for the following function in qb-core/server/player.lua and replace it with the code below. Check the lines that say --added.

function QBCore.Player.DeleteCharacter(source, citizenid)
    exports["snipe-banking"]:DeleteCharacter(citizenid) --added
    local license = QBCore.Functions.GetIdentifier(source, 'license')
    local result = MySQL.scalar.await('SELECT license FROM players where citizenid = ?', { citizenid })
    if license == result then
        local query = "DELETE FROM %s WHERE citizenid = ?"
        local tableCount = #playertables
        local queries = table.create(tableCount, 0)

        for i = 1, tableCount do
            local v = playertables[i]
            queries[i] = {query = query:format(v.table), values = { citizenid }}
        end

        MySQL.transaction(queries, function(result2)
            if result2 then
                TriggerEvent('qb-log:server:CreateLog', 'joinleave', 'Character Deleted', 'red', '**' .. GetPlayerName(source) .. '** ' .. license .. ' deleted **' .. citizenid .. '**..')
            end
        end)
    else
        DropPlayer(source, Lang:t("info.exploit_dropped"))
        TriggerEvent('qb-log:server:CreateLog', 'anticheat', 'Anti-Cheat', 'white', GetPlayerName(source) .. ' Has Been Dropped For Character Deletion Exploit', true)
    end
end

ESX

Changes in es_extended

• Look for this function in es_extended/server/classes/player.lua and replace it with the code below. Check the lines that say --added.

function self.getAccount(account)
    if account == "bank" and exports["snipe-banking"]:IsAccountFrozenForIdentifier(self.identifier) then -- add this line
        return {name = "bank", money = 0}
    end
    for k,v in ipairs(self.accounts) do
        if v.name == account then
            return v
        end
    end
end

Changes in esx_addonaccounts

Replace this in esx_addonaccount/server/classes/addonaccount.lua

local function TrimString(name)
	-- remove word society_ from name
	return name:sub(9)
end
function CreateAddonAccount(name, owner, money)
	local self = {}

	self.name  = name
	self.job  = TrimString(name)
	self.owner = owner
	self.money = exports["snipe-banking"]:GetAccountBalance(self.job)

	function self.addMoney(m)
		self.money = self.money + m
		self.save()
		exports["snipe-banking"]:AddMoneyToAccount(self.job, m)
	end

	function self.removeMoney(m)
		self.money = self.money - m
		self.save()
		exports["snipe-banking"]:RemoveMoneyFromAccount(self.job, m)
	end

	function self.setMoney(m)
		self.money = m
		self.save()
		exports["snipe-banking"]:SetAccountMoney(self.job, m)
	end

	function self.save()
		-- if self.owner == nil then
		-- 	MySQL.update('UPDATE addon_account_data SET money = ? WHERE account_name = ?', {self.money, self.name})
		-- else
		-- 	MySQL.update('UPDATE addon_account_data SET money = ? WHERE account_name = ? AND owner = ?', {self.money, self.name, self.owner})
		-- end

		
		TriggerClientEvent('esx_addonaccount:setMoney', -1, self.job, self.money)

	end

	return self
end

Also in esx_addonaccounts/server/main.lua, Remove the whole event that says onResourceStart and replace it with the following code. Check The Screenshot on how it should look

AddEventHandler('onResourceStart', function(resourceName)
	if resourceName == GetCurrentResourceName() then
		local accounts = MySQL.query.await('SELECT * FROM addon_account LEFT JOIN addon_account_data ON addon_account.name = addon_account_data.account_name UNION SELECT * FROM addon_account RIGHT JOIN addon_account_data ON addon_account.name = addon_account_data.account_name')
		
		local newAccounts = {}
		for i = 1, #accounts do
			local account = accounts[i]
			if account.shared == 0 then
				if not Accounts[account.name] then
					AccountsIndex[#AccountsIndex + 1] = account.name
					Accounts[account.name] = {}
				end
				Accounts[account.name][#Accounts[account.name] + 1] = CreateAddonAccount(account.name, account.owner, account.money)
			end
		end

		if next(newAccounts) then
			MySQL.prepare('INSERT INTO addon_account_data (account_name, money) VALUES (?, ?)', newAccounts)
			for i = 1, #newAccounts do
				local newAccount = newAccounts[i]
				SharedAccounts[newAccount[1]] = CreateAddonAccount(newAccount[1], nil, 0)
			end
		end

	end
end)

CreateThread(function()
	-- wait until snipe-banking starts
	while not GetResourceState('snipe-banking') == 'started' do
		Wait(100)
	end
	Wait(5000)
	local accounts = exports["snipe-banking"]:GetJobGangAccounts()
	for k, v in pairs(accounts) do
	local accountName = "society_"..k
		SharedAccounts[accountName] = CreateAddonAccount(accountName, nil, v)
	end
end)

Alt text

Changes in esx_multicharacter Scripts (Only if you use it)

• If you use a custom esx_multicharacter script, you will have to ask the author of the script to find the similar event/function in their script so you can add the export

• Look for the following code in esx_multicharacter and add the export below it. Check the lines that say --added.

local function DeleteCharacter(source, charid)
	local identifier = ('%s%s:%s'):format(PREFIX, charid, GetIdentifier(source))
    exports["snipe-banking"]:DeleteCharacter(identifier) --added
	local query = 'DELETE FROM %s WHERE %s = ?'
	local queries = {}
	local count = 0

	for table, column in pairs(DB_TABLES) do
		count = count +  1
		queries[count] = {query = query:format(table, column), values = {identifier}}
	end

	MySQL.transaction(queries, function(result)
		if result then
			print(('[^2INFO^7] Player ^5%s %s^7 has deleted a character ^5(%s)^7'):format(GetPlayerName(source), source, identifier))
			Wait(50)
			SetupCharacters(source)
		else
			error('\n^1Transaction failed while trying to delete '..identifier..'^0')
		end
	end)
end

Conversion Command

• Restart the server. Make sure nobody connects the server.

• Run the command convertesxsociety in your server console once the server is up.

• This will also move all the job money from addon_account_data into my database.

• Restart the server again.

Dispatch Changes

Moz Dispatch

local function FlaggedAccount()
    local alertInfo = functions.getAlertInfo()
    local alert = {
        information = 'Flagged Account Accessed',
        priority = 'low',
        department = 'police',
        duration = 10000,
        code = '10-13A',
        location = alertInfo.location,
        blip = {
            radius = 50.0,
            sprite = 1,
            color = 1,
            scale = 1.0,
            alpha = 128,
            shortRange = true,
            name = 'Flagged Account',
            fadeAfter = 10000,
        }
    }
    TriggerServerEvent('moz-dispatch:server:sendAlert', alert)
end
exports('FlaggedAccount', FlaggedAccount)

PS Dispatch

• If you use ps-dispatch v2, no changes are required

1. Open sv_dispatchcodes.lua and add the department you want to add to the list for the alert you want them to receive

 ["flagged_account"] =  {displayCode = '10-13', description ="Flagged Account", radius = 0, recipientList = {'police'}, blipSprite = 110, blipColour = 1, blipScale = 1.5, blipLength = 2, sound = "Lose_1st", sound2 = "GTAO_FM_Events_Soundset", offset = "false", blipflash = "false"},

1. Open cl_events.lua and add the department to the corresponding alert to the one you edited above

local function FlaggedAccount()
    local currentPos = GetEntityCoords(PlayerPedId())
    local locationInfo = getStreetandZone(currentPos)
    local gender = GetPedGender()
    local PlayerPed = PlayerPedId()
    TriggerServerEvent("dispatch:server:notify", {
        dispatchcodename = "flagged_account", -- has to match the codes in sv_dispatchcodes.lua so that it generates the right blip
        dispatchCode = "10-11",
        firstStreet = locationInfo,
        gender = gender,
        model = nil,
        plate = nil,
        priority = 2,
        firstColor = nil,
        automaticGunfire = false,
        origin = {
            x = currentPos.x,
            y = currentPos.y,
            z = currentPos.z
        },
        dispatchMessage = "Flagged Account Accessed",
        job = {"police"} -- has to match the recipientList in sv_dispatchcodes.lua
    })
end

exports("FlaggedAccount", FlaggedAccount)

Developer Exports

Server Exports	Description
GetAccountBalance(job/gang)	Returns the account money for the job/gang.
AddMoneyToAccount(job/gang, amount)	Adds money to the job/gang account. This doesnt register the transaction, you need to use the exports below to create a transaction to show on ui
RemoveMoneyFromAccount(job/gang, amount)	Removes money from the job/gang account. This doesnt register the transaction, you need to use the exports below to create a transaction to show on ui
IsAccountFlaggedForPlayerId(playerId)	Returns true if the player's account is flagged. Parameter required is player source id
IsAccountFlaggedForIdentifier(playerIdentifier)	Returns true if the player's account is flagged. Parameter required is player Identifier (citizenid for qbcore and charid for esx).
IsAccountFrozenForPlayerId(playerId)	Returns true if the player's account is flagged. Parameter required is player source id.
IsAccountFrozenForIdentifier(playerIdentifier)	Returns true if the account is flagged. Parameter required is player Identifier (citizenid for qbcore and charid for esx)
DeleteCharacter(citizenid)	Should be triggered from place where the character is deleted. Parameter required is citizenid
CreatePersonalTransactions(identifier, amount, memo, type, otherPlayerIdentifier, isJob)	Should be triggered from place where the transaction is made. Parameters required are identifier (citizenid for qbcore and charid for esx), amount, memo, type (deposit/withdraw/transfer), otherPlayerIdentifier (citizenid for qbcore and charid for esx, if type is transfer), isJob to true if you are sending to job and otherPlayerIdentifier will be the job/gang name, isJob to true if you are sending to job and otherPlayerIdentifier will be the job/gang name
CreateJobTransactions(jobgang, amount, memo, type, identifier, otherPlayerIdentifier, isJob)	Should be triggered from place where the transaction is made. Parameters required are jobgang (job name or gang name), amount, memo, type (deposit/withdraw/transfer), identifier (citizenid for qbcore and charid for esx), otherPlayerIdentifier (citizenid for qbcore and charid for esx, if type is transfer), isJob to true if you are sending to job and otherPlayerIdentifier will be the job/gang name
CreateJobGangAccount(name, label, amount, isJob)	name is the account name which will be used to add/remove get job money (use only snipe-banking exports for these operations). label is what you will see in transactions. amount is starting balance for the account. isJob is true if the account is a job account, false if it is a gang account

Client Exports	Description
IsAccountFlagged()	Returns true if the player's account is flagged.
IsAccountFrozen()	Returns true if the player's account is Frozen.
DoProgress(boolean)	Usage exports["snipe-banking"]:DoProgress(true) to show the progress bar and then open BANK UI and exports["snipe-banking"]:DoProgress(false) to show progressbar and then open ATM UI.
OpenBank()	Usage exports["snipe-banking"]:OpenBank() to open the bank ui without progressbar.
OpenATM()	Usage exports["snipe-banking"]:OpenATM() to open the atm ui without progressbar.

FAQ

1. I have frozen a person's account but he is still able to buy things using his bank account?

• For QBCore, money is removed using the following function Player.Functions.RemoveMoney, but most of the scripts in qbcore dont rely on that false to be returned, instead they check the bank balance and then just trigger the RemoveMoney function and irrespective of the return value, they continue with the purchase. If I add a snippet for checking if player's bank account is frozen then return false, it will start giving them stuff for free. So you can use the exports provided above to do checks if account is frozen.

• For ESX, I have added a check in getAccount function to return 0 if his account is frozen. But again, it might work at some places while it may not at some places.

1. Why is my money deposited by jobs in their management menu not showing in the bank? (ONLY QBCore)

• You did not follow the steps mentioned under qb-management section above. Jobs should not be able to deposit/withdraw money from the management menu, but they should be using bank instead.