[Release] esx_irpidentity - v1.0.53

DayZen · December 2, 2019, 3:06am

Yes, and even get the help text pop up about it. Im going to try and do a full db drop of EVERYTHING and rebuild and try again.

Christopher_Lauer · December 2, 2019, 3:09am

Yea, I need to know what kind of errors ur getting /what not to help you more

DayZen · December 2, 2019, 3:10am

Yea, after i do this fresh build, im going to capture everything i possibly can.

DayZen · December 2, 2019, 4:47am

Ok so when i first load in this is what i look like:

and then when i hit E i get this in server console:

there are no other errors, database was fully wiped, no esx_identity is running, no kashacters, so not sure whats going on now?

Christopher_Lauer · December 2, 2019, 4:48am

Image is broken

DayZen · December 2, 2019, 4:51am

so this is the error: https://i.imgur.com/Ns7h63O.png

and this is when i first load in: https://i.imgur.com/3modafm.jpg

and this is when i type /charlist https://i.imgur.com/PtXH5UB.png

and this if i type /char: https://i.imgur.com/KmQNlvH.png

Christopher_Lauer · December 2, 2019, 4:56am

Do you have MySQL async installed? You need to contact me via discord. Get my info through the website, and join the server for support please.

DayZen · December 2, 2019, 4:57am

Yes i do, and ive tried the new one and the old one just incase. WIll do

Christopher_Lauer · December 2, 2019, 5:04am

I cant post the link here
got to my website impulserp.com

mrdigital01 · December 2, 2019, 5:21am

any eta on when this will work with garages / properties and phone?

I.e
esx_advancedgarages
disc-property
gcPhone?

DayZen · December 2, 2019, 5:32am

So just to let everyone know who might have seen this…it is 100% something on my side, nothing at all with his script.

DayZen · December 2, 2019, 8:56pm

Got the script finally working, it was something on my side with es_extended and essentialmode. This script is amazing and working great now thanks to the support i received.

Christopher_Lauer · December 2, 2019, 11:52pm

Extremely happy you got this working!! @DayZen

Christopher_Lauer · December 4, 2019, 7:01am

v.1.0.53 was released with the wrong SQL file, be sure to check and make sure you have the proper, it was just fixed. Ur characters_inventory/characters/users/user inventory/and users table should have the irpid column added to these tables

Hurt · December 4, 2019, 9:08pm

im getting an error in database ? sqlerror

Christopher_Lauer · December 4, 2019, 9:09pm

change default to blank

Christopher_Lauer · December 4, 2019, 9:10pm

CREATE TABLE users (
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 NOT NULL DEFAULT ‘{}’,
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;

Hurt · December 4, 2019, 9:10pm

loadout longtext COLLATE utf8mb4_bin ‘[]’,

Christopher_Lauer · December 4, 2019, 9:10pm

SQL that, do for your characters table as well

Christopher_Lauer · December 4, 2019, 9:11pm

Once you upload to your database, then you should be able to change the default, you may/may not need to