[UPDATED] Standalone Currency System

FiveM Resource Development & Modding Releases
, , , ,
83

The Money_Script has now been updated, the ATM and Bank script are in the process of being updated.

4 Likes
84

Awesome!! I love that you included Discord Roles and Logs! One question I have is does this still support the use of exports? I was working on some modifications to some of our existing scripts where events could trigger giving/losing money (like Badger’s Bank Robbery script would use a random math function and then send that number to an export to give the person money for completing the robbery).

85

@andyyy7666 i have having touble and having this error "no such escort checkbank in resource money_script " and I don’t see the amount of money I have in the top right.

86

does this work with vmenu?

1 Like
87

yes it does

1 Like
88

can we edit peoples money accounts on the sql database

89

You can, but you will need to know their license ID because that’s what they are saved under in the DB.

90

SQL query: Copy

``

CREATE TABLE `money` (
	`license` VARCHAR(200) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_0900_ai_ci',
	`cash` INT(200) NULL DEFAULT NULL,
	`bank` INT(200) NULL DEFAULT NULL
)
COLLATE='utf8mb4_0900_ai_ci'
ENGINE=InnoDB;

MySQL said: Documentation

#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'

91

I had the same problem as you. Try utf8mb4_general_ci

92

replace ‘utf8mb4_09000_ai_ci’ with ‘utf8mb4_unicode_ci’ in both places in the query.sql and then try again.

93

no such export CheckBank in Money_Script anyone know what this is

94

so i am having a problem i set it up to our discord and added people to admin and the whole script isn’t working and nothing is showing up on our screen in game with the atm card and cash

95

Yes it’s because I haven’t updated the bank to work with the new exports, I will do that pretty soon. ATMs should be working fine tho.

1 Like
96

Can you check the client and server console and let me know if there’s any errors?

1 Like
97

is says unknown collation

99

you need to replace ‘utf8mb4_09000_ai_ci’ with ‘utf8mb4_unicode_ci’ in both places in the query.sql and then try again.

1 Like
100

Is this the export error the other guy was having too? when attempting to go to bank teller

[      script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: Money_Script was unable to execute a query!
[      script:oxmysql]     Out of range value for column 'bank' at row 36
[      script:oxmysql]     UPDATE money SET bank = bank + '9999999999' WHERE license = 'license:52f21970b206e43fc5fb7226f66a1ef09f47ff7e'
[      script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16101)
[      script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[      script:oxmysql] 
[      script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: Money_Script was unable to execute a query!
[      script:oxmysql]     Truncated incorrect DOUBLE value: '9999999''
[      script:oxmysql]     UPDATE money SET bank = bank + '9999999\'' WHERE license = 'license:52f21970b206e43fc5fb7226f66a1ef09f47ff7e'
[      script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16101)
[      script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[      script:oxmysql] 
[      script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: Money_Script was unable to execute a query!
[      script:oxmysql]     Truncated incorrect DOUBLE value: '9999999''
[      script:oxmysql]     UPDATE money SET bank = bank + '9999999\'' WHERE license = 'license:52f21970b206e43fc5fb7226f66a1ef09f47ff7e'
[      script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16101)
[      script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[      script:oxmysql] 
[      script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: Money_Script was unable to execute a query!
[      script:oxmysql]     Truncated incorrect DOUBLE value: '9999999''
[      script:oxmysql]     UPDATE money SET bank = bank + '9999999\'' WHERE license = 'license:52f21970b206e43fc5fb7226f66a1ef09f47ff7e'
[      script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16101)
[      script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[      script:oxmysql] 
[      script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: Money_Script was unable to execute a query!
[      script:oxmysql]     Truncated incorrect DOUBLE value: '9999999''
[      script:oxmysql]     UPDATE money SET bank = bank + '9999999\'' WHERE license = 'license:52f21970b206e43fc5fb7226f66a1ef09f47ff7e'
[      script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16101)
[      script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[      script:oxmysql] 
[      script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: Money_Script was unable to execute a query!
[      script:oxmysql]     Truncated incorrect DOUBLE value: '9999999''
[      script:oxmysql]     UPDATE money SET bank = bank + '9999999\'' WHERE license = 'license:52f21970b206e43fc5fb7226f66a1ef09f47ff7e'
[      script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16101)
[      script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[      script:oxmysql] 
[      script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: Money_Script was unable to execute a query!
[      script:oxmysql]     Truncated incorrect DOUBLE value: '9999999''
[      script:oxmysql]     UPDATE money SET bank = bank + '9999999\'' WHERE license = 'license:52f21970b206e43fc5fb7226f66a1ef09f47ff7e'
[      script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16101)
[      script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[      script:oxmysql] 
[      script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: Money_Script was unable to execute a query!
[      script:oxmysql]     Out of range value for column 'bank' at row 36
[      script:oxmysql]     UPDATE money SET bank = bank + '999999999' WHERE license = 'license:52f21970b206e43fc5fb7226f66a1ef09f47ff7e'
[      script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16101)
[      script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[      script:oxmysql] 
[      script:oxmysql] SCRIPT ERROR in promise (unhandled): Error: Money_Script was unable to execute a query!
[      script:oxmysql]     Out of range value for column 'bank' at row 36
[      script:oxmysql]     UPDATE money SET bank = bank + '9999999999' WHERE license = 'license:52f21970b206e43fc5fb7226f66a1ef09f47ff7e'
[      script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16101)
[      script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
101

The bank script isn’t updated yet. The money system itself and the ATM script both work, but not the bank yet

1 Like
102

sql
sql1076×93 3.94 KB

Call me stupid, but what is this error? I dragged and dropped like it said in the instructions, however it doesn’t work in game. I have added it to my server.cfg and it’s on, just nothing seems new.

103

You need to download oxmysql from the releases section on GitHub.

1 Like