Script okokBanking

[ValeTMHD]

[SQL] ITS IN THE README
[DOWNLOAD]

Hidden link for visitors, to see Log in or register now.

 

[Zan1456]

Thx

 

[ikova]

Working but missing SQL file!

 

[Tidolop]

Working but missing SQL file!

Its in the readme

 

[monmam]

SQL



CREATE TABLE `okokBanking_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`receiver_identifier` varchar(255) NOT NULL,
`receiver_name` varchar(255) NOT NULL,
`sender_identifier` varchar(255) NOT NULL,
`sender_name` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`value` int(50) NOT NULL,
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE `okokBanking_societies` (
`society` varchar(255) NULL DEFAULT NULL,
`society_name` varchar(255) NULL DEFAULT NULL,
`value` int(50) NULL DEFAULT NULL,
`iban` varchar(255) NOT NULL,
`is_withdrawing` int(1) NULL DEFAULT NULL
);
ALTER TABLE `users` ADD COLUMN `iban` varchar(255) NULL DEFAULT NULL;
ALTER TABLE `users` ADD COLUMN `pincode` int(50) NULL DEFAULT NULL;

 

[monmam]

View attachment 1863

[SQL] ITS IN THE README
[DOWNLOAD]

Hidden link for visitors, to see Log in or register now.

Thx

 

[Faroki]

no for qbcore?

 

[ValeTMHD]

no for qbcore?

Of Course,

QbCore Download:

Hidden link for visitors, to see Log in or register now.

 

[JulienJohnson]

SQL



CREATE TABLE `okokBanking_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`receiver_identifier` varchar(255) NOT NULL,
`receiver_name` varchar(255) NOT NULL,
`sender_identifier` varchar(255) NOT NULL,
`sender_name` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`value` int(50) NOT NULL,
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE `okokBanking_societies` (
`society` varchar(255) NULL DEFAULT NULL,
`society_name` varchar(255) NULL DEFAULT NULL,
`value` int(50) NULL DEFAULT NULL,
`iban` varchar(255) NOT NULL,
`is_withdrawing` int(1) NULL DEFAULT NULL
);
ALTER TABLE `users` ADD COLUMN `iban` varchar(255) NULL DEFAULT NULL;
ALTER TABLE `users` ADD COLUMN `pincode` int(50) NULL DEFAULT NULL;

thank you very much for the time saving by not looking everywhere

 

[kkruse]

Yo.
I need help with this script, bcs when i want withdraw my money from bank, they are not in my inventory.
In console, it shows me this error:

[ script:es_extended] SCRIPT ERROR: @es_extended/server/classes/player.lua:299: attempt to index a nil value (local ‘account’)
[ script:es_extended] > ref (@es_extended/server/classes/player.lua:299)
[ script:es_extended] > handler (@okokBanking/server.lua:95)

 

[JulienJohnson]

Yo.
I need help with this script, bcs when i want withdraw my money from bank, they are not in my inventory.
In console, it shows me this error:

[ script:es_extended] SCRIPT ERROR: @es_extended/server/classes/player.lua:299: attempt to index a nil value (local ‘account’)
[ script:es_extended] > ref (@es_extended/server/classes/player.lua:299)
[ script:es_extended] > handler (@okokBanking/server.lua:95)

you put the sql in the database?

 

[kkruse]

you put the sql in the database?

Yes, all showing created tables with no issues, seems to be calling account in es extended but nit there? Not sure tbh but crying haha

 

[kkruse]

Anyone able to help? it reads the cash and balance ok, just can no pull money out or put money in with the above error.
[ script:es_extended] SCRIPT ERROR: @es_extended/server/classes/player.lua:299: attempt to index a nil value (local ‘account’)
[ script:es_extended] > ref (@es_extended/server/classes/player.lua:299)
[ script:es_extended] > handler (@okokBanking/server.lua:95)

 

[JulienJohnson]

did you follow all the instructions correctly? which version of esx do you have?

Anyone able to help? it reads the cash and balance ok, just can no pull money out or put money in with the above error.
[ script:es_extended] SCRIPT ERROR: @es_extended/server/classes/player.lua:299: attempt to index a nil value (local ‘account’)
[ script:es_extended] > ref (@es_extended/server/classes/player.lua:299)
[ script:es_extended] > handler (@okokBanking/server.lua:95)

1. First of all add the required tables to your database, executing the following code:

CREATE TABLE `okokBanking_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`receiver_identifier` varchar(255) NOT NULL,
`receiver_name` varchar(255) NOT NULL,
`sender_identifier` varchar(255) NOT NULL,
`sender_name` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`value` int(50) NOT NULL,
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
);

CREATE TABLE `okokBanking_societies` (
`society` varchar(255) NULL DEFAULT NULL,
`society_name` varchar(255) NULL DEFAULT NULL,
`value` int(50) NULL DEFAULT NULL,
`iban` varchar(255) NOT NULL,
`is_withdrawing` int(1) NULL DEFAULT NULL
);

ALTER TABLE `users` ADD COLUMN `iban` varchar(255) NULL DEFAULT NULL;

ALTER TABLE `users` ADD COLUMN `pincode` int(50) NULL DEFAULT NULL;

2. To add salary/paycheck transactions navigate to 'es_extended/server' and open 'paycheck.lua'.

2.1. Add the following code (just like in the example below).

TriggerEvent('okokBanking:AddTransferTransactionFromSocietyToP', salary, "salary", "Salary", xPlayer.identifier, xPlayer.getName())

Example:

if salary > 0 then
if job == 'unemployed' then -- unemployed
xPlayer.addAccountMoney('bank', salary)
TriggerEvent('okokBanking:AddTransferTransactionFromSocietyToP', salary, "salary", "Salary", xPlayer.identifier, xPlayer.getName())
TriggerClientEvent('esx:showAdvancedNotification', xPlayer.source, _U('bank'), _U('received_paycheck'), _U('received_help', salary), 'CHAR_BANK_MAZE', 9)
elseif Config.EnableSocietyPayouts then -- possibly a society
TriggerEvent('esx_society:getSociety', xPlayer.job.name, function (society)
if society ~= nil then -- verified society
TriggerEvent('esx_addonaccount:getSharedAccount', society.account, function (account)
if account.money >= salary then -- does the society money to pay its employees?
xPlayer.addAccountMoney('bank', salary)
account.removeMoney(salary)
TriggerEvent('okokBanking:AddTransferTransactionFromSocietyToP', salary, "salary", "Salary", xPlayer.identifier, xPlayer.getName())
TriggerClientEvent('esx:showAdvancedNotification', xPlayer.source, _U('bank'), _U('received_paycheck'), _U('received_salary', salary), 'CHAR_BANK_MAZE', 9)
else
TriggerClientEvent('esx:showAdvancedNotification', xPlayer.source, _U('bank'), '', _U('company_nomoney'), 'CHAR_BANK_MAZE', 1)
end
end)
else -- not a society
xPlayer.addAccountMoney('bank', salary)
TriggerEvent('okokBanking:AddTransferTransactionFromSocietyToP', salary, "salary", "Salary", xPlayer.identifier, xPlayer.getName())
TriggerClientEvent('esx:showAdvancedNotification', xPlayer.source, _U('bank'), _U('received_paycheck'), _U('received_salary', salary), 'CHAR_BANK_MAZE', 9)
end
end)
else -- generic job
xPlayer.addAccountMoney('bank', salary)
TriggerEvent('okokBanking:AddTransferTransactionFromSocietyToP', salary, "salary", "Salary", xPlayer.identifier, xPlayer.getName())
TriggerClientEvent('esx:showAdvancedNotification', xPlayer.source, _U('bank'), _U('received_paycheck'), _U('received_salary', salary), 'CHAR_BANK_MAZE', 9)
end
end

3. To replace the "okokBanking" logo, simply replace it with yours on the 'web' folder.

 

[kkruse]

I have ESX 1.1 with essential mode mate, yes all tables are there and can see my name in one of them

 

[Thomas Shelby]

Alguém pode ajudar? ele lê o dinheiro e o saldo ok, só não pode retirar dinheiro ou colocar dinheiro com o erro acima.
[script: es_extended] ERRO DE SCRIPT: @ es_extended / server / classes / player.lua: 299: tentativa de indexar um valor nulo ('conta' local)
[script: es_extended]> ref (@ es_extended / server / classes / player.lua: 299)
[script: es_extended]> manipulador (@ okokBanking / server.lua: 95)

I'm having the same problem... did you manage to fix it?

 

[Mr.Unkown]

i'm having the same to, when i get out the cash from bank the money is missing,

 

[rushez]

Has anyone managed to make mistakes like the two of them

 

[Jeril achu]

Auto payment issue

 

[Jeril achu]

Its bcoz of es extended, account type only bank is there below v1 thats y this error showing

I'm having the same problem... did you manage to fix it