same exact thing for characters?
or just edit the loadout part?
can you send me the character part lol sorry
CREATE TABLE characters (
id int(11) NOT NULL,
identifier varchar(50) COLLATE utf8mb4_bin NOT NULL,
irpid varchar(50) COLLATE utf8mb4_bin NOT NULL,
license varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
money int(11) DEFAULT NULL,
name varchar(50) COLLATE utf8mb4_bin DEFAULT ‘’,
skin longtext COLLATE utf8mb4_bin DEFAULT NULL,
job varchar(50) COLLATE utf8mb4_bin DEFAULT ‘unemployed’,
job_grade int(11) DEFAULT 0,
loadout longtext COLLATE utf8mb4_bin,
position varchar(36) COLLATE utf8mb4_bin DEFAULT NULL,
bank int(11) DEFAULT NULL,
permission_level int(11) DEFAULT NULL,
group varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
firstname varchar(50) COLLATE utf8mb4_bin DEFAULT ‘’,
lastname varchar(50) COLLATE utf8mb4_bin DEFAULT ‘’,
dateofbirth varchar(25) COLLATE utf8mb4_bin DEFAULT ‘’,
sex varchar(10) COLLATE utf8mb4_bin DEFAULT ‘’,
height varchar(5) COLLATE utf8mb4_bin DEFAULT ‘’,
status longtext COLLATE utf8mb4_bin DEFAULT NULL,
is_dead tinyint(1) DEFAULT 0,
last_property varchar(255) COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
thank you sm m8
1 Like
I have this error?!
ERROR] [MySQL] An error happens on MySQL for query “INSERT INTO users (identifier, money, bank, group, permission_level, license) VALUES (@identifier, @money, @bank, @group, @permission_level, @license); {identifier=steam:11000011427038f;permission_level=0;license=license:10574d65a88aed4f42ba31cf75990fd41f283a10;group=user;bank=0;money=0}”: Field ‘irpid’ doesn’t have a default value
I have change in the database “irpid”
from irpid varchar(50) COLLATE utf8mb4_bin NOT NULL,
in irpid varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT ‘’,
that helped!
now everything seems to work!
1 Like
How do i make it to where I dont spawn at the hospital whenever I am revived or when I spawn into the server? I love this script, just have these issues
Thanks to a few people who have reported a a few new issues. I have pushed an update that fixed money issues with toons as well as updated the importMe.SQL. Be sure to report any issues you may have so that I can fix them or help you fix them. Thank you.
I see you bringa good script in the community @Christopher_Lauer seems really nice but the codding are so bad that the server hitch is going rappadly up like 600-900 ms with 125 Players is that scrippt more as Sloppy try to fix that @Christopher_Lauer
I am working on this. Thank you. I have increased performance in recent updates, but I am currently still attempting to increase performance, thank you for your feedback @Capitan_KaraTV
not a problem try the Citizens Wait from 0 to 300 givvs you a little boost
1 Like
I do believe it is the queries that hog up the resources, thus why I shrank them individually. However, I will look into Citizen.Waits for more of a performance increase, again. Thank you for your feedback, much appreciated.
Is there a new update already?
I just mean the “update” with the Character bound items, propertys etx
All items, load outs, cash, bank, etc are now character bound @Nevos, you will need to edit other resources such as phone and what not to work with characters
I have not