[HELP] Money issues

[pavpd]

Hello. I have a major issue. Yesterday, my server was working fine, no issues at all. I added some scripts and noticed that when I add myself money from es_admin, I don’t get any. I tried stopping scripts and such, and nothing worked. When I withdraw/deposit money from my bank account, it works fine. When I buy a car, it still works fine. When I buy a property from esx_property it does not work… I looked in the files and the database and noticed something weird. My server’s custom UI synchronises with “account” column but es_admin adds money into “bank” and “money”. esx_property didn’t take money from anywhere. Society money collects money from police fines but doesn’t take the money from “account” table. I don’t know if I missed something to say/do but it just doesn’t work.

[Lil_Ripac]

idk man

[Th3Cha0s]

Your explanation is vague and lacks script code. Focus on one issue and highlight it maybe that’ll attract more people to try and help you.

Try taking a look at the code that’s supposed to read from the SQL (supposed to be in the server side of the scripts) and see what could be the issue through that.

Good luck!

[pavpd]

So I found that when I remove the scripts added from 19-20 march it is still glitched, so I realised that I did something wrong, because on the backup from 19 March it works great with no issues. So this night I’m updating the backup and seeing if it works. If I find what I did wrong the last time, I will make sure to write here. Thanks for your response

[pavpd]

Apparently, that fully-functional backup doesn’t work anymore. I don’t have any idea anymore, I’m tired of this glitch… I see no forum posts about it so I feel quite sad… I tried to test that in a brand new server. I noticed I can’t import esplugin_mysql and es_extended at the same time. They create errors when I add them. When esplugin_mysql is imported, importing es_extended leads to this error in phpmyadmin:

CREATE TABLE `users` (
	`identifier` VARCHAR(40) NOT NULL,
	`accounts` LONGTEXT NULL DEFAULT NULL,
	`group` VARCHAR(50) NULL DEFAULT 'user',
	`inventory` LONGTEXT NULL DEFAULT NULL,
	`job` VARCHAR(20) NULL DEFAULT 'unemployed',
	`job_grade` INT(11) NULL DEFAULT 0,
	`loadout` LONGTEXT NULL DEFAULT NULL,
	`position` VARCHAR(53) NULL DEFAULT '{"x":-269.4,"y":-955.3,"z":31.2,"heading":205.8}',

	PRIMARY KEY (`identifier`)
)
MySQL said: Documentation

#1050 - Table 'users' already exists

I tried fixing this myself by changig es_extended to this:

CREATE DATABASE IF NOT EXISTS `essentialmode`;
USE `essentialmode`;

CREATE TABLE `users` (
	`identifier` VARCHAR(40) NOT NULL,
	`accounts` LONGTEXT NULL DEFAULT NULL,
	`inventory` LONGTEXT NULL DEFAULT NULL,
	`job` VARCHAR(20) NULL DEFAULT 'unemployed',
	`job_grade` INT(11) NULL DEFAULT 0,
	`loadout` LONGTEXT NULL DEFAULT NULL,
	`position` VARCHAR(53) NULL DEFAULT '{"x":-269.4,"y":-955.3,"z":31.2,"heading":205.8}',
	`license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
	`money` int(11) DEFAULT NULL,
	`bank` int(11) DEFAULT NULL,
	`permission_level` int(11) DEFAULT NULL,
	`group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
	PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `items` (
	`name` VARCHAR(50) NOT NULL,
	`label` VARCHAR(50) NOT NULL,
	`weight` INT(11) NOT NULL DEFAULT 1,
	`rare` TINYINT(1) NOT NULL DEFAULT 0,
	`can_remove` TINYINT(1) NOT NULL DEFAULT 1,

	PRIMARY KEY (`name`)
);

CREATE TABLE `job_grades` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`job_name` VARCHAR(50) DEFAULT NULL,
	`grade` INT(11) NOT NULL,
	`name` VARCHAR(50) NOT NULL,
	`label` VARCHAR(50) NOT NULL,
	`salary` INT(11) NOT NULL,
	`skin_male` LONGTEXT NOT NULL,
	`skin_female` LONGTEXT NOT NULL,

	PRIMARY KEY (`id`)
);

INSERT INTO `job_grades` VALUES (1,'unemployed',0,'unemployed','Unemployed',200,'{}','{}');

CREATE TABLE `jobs` (
	`name` VARCHAR(50) NOT NULL,
	`label` VARCHAR(50) DEFAULT NULL,

	PRIMARY KEY (`name`)
);

INSERT INTO `jobs` VALUES ('unemployed','Unemployed');

But it now just doesn’t work. The same bug all over again. I set money from es_admin2 and it doesn’t change in the hud. Es_admin2 saving money into “money” column and hud is showing from “accounts” column. If you need more information I’d love to answer…

[Th3Cha0s]

Try truncating your database completely and see if that allows you to import the first query command you mentioned properly.

Good luck!