not compatible with current esx … not steam id form or anything …
1 Like
I never had luck with the web site you sent, cant seem to find the right context or anything like that.
this template does not work :
ALTER TABLE <table_name> MODIFY <col_name> VARCHAR(60);
and I do not know how to use this example for our problem
ALTER TABLE emp CHANGE COLUMN name name VARCHAR(100);
any chance of getting a example of something say for <user_accounts> …(thats setting at 22 ) i think
this is what i get when i run the
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘identifier’
and this is what i get
when i use this
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘owner’
so i do see some under 60 numbers, i gotta fix those.
I don’t even know if this makes sense, but it seems people have stuff going missing from their apartments/houses after some time. Has anyone else experienced this? They have thousands of dirty money disappearing and I have no idea why. I am guessing maybe the ownership of apartments/houses is incorrect or something along those lines, but I don’t know for sure. In terms of people hacking or anything like that I highly doubt it as I monitor the SQL database closely and take daily backups and haven’t noticed anything unordinary
@icombustion Hey man, can you help me with my issue also when you will have some time, you look like to know a bit on this addons, and can’t make mine work properly. Thanks
this was back up on the topic,
AddEventHandler('esx:playerLoaded', function(source)
local result = MySQL.Sync.fetchAll('SELECT * FROM addon_account')
for i=1, #result, 1 do
local name = result[i].name
local label = result[i].label
local shared = result[i].shared
local result2 = MySQL.Sync.fetchAll('SELECT * FROM addon_account_data WHERE account_name = @account_name', {
['@account_name'] = name
})
if shared == 0 then
table.insert(AccountsIndex, name)
Accounts[name] = {}
for j=1, #result2, 1 do
local addonAccount = CreateAddonAccount(name, result2[j].owner, result2[j].money)
table.insert(Accounts[name], addonAccount)
end
end
end
local _source = source
local xPlayer = ESX.GetPlayerFromId(_source)
local addonAccounts = {}
for i=1, #AccountsIndex, 1 do
local name = AccountsIndex[i]
local account = GetAccount(name, xPlayer.identifier)
if account == nil then
MySQL.Async.execute('INSERT INTO addon_account_data (account_name, money, owner) VALUES (@account_name, @money, @owner)', {
['@account_name'] = name,
['@money'] = 0,
['@owner'] = xPlayer.identifier
})
account = CreateAddonAccount(name, xPlayer.identifier, 0)
table.insert(Accounts[name], account)
end
table.insert(addonAccounts, account)
end
xPlayer.set('addonAccounts', addonAccounts)
end)
crap i can’t find the original post
main.lua (2.7 KB)
esx_datastore/server
try to search using some of the words from the above I pasted, to find the original post, make sure you find it and read it before you use my stuff, you have been warned, My system is not 100% yet but this fixed dirty money. your mileage will vary. read read read its not my fault if you blow up your database, hope i have you a few more bread crumbs at least
me too do u know how to fix it now
so what are the top 3 reasons why property storage/wardrobes would not work correctly?
Have you configured the table in the server.lua?
yep everything that is flagged with identifier and owner
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘identifier’
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘owner’
main.lua (5.0 KB)
Hi,
I’m having issue with kashacter data entry duplication. I tried putting the code at bottom of esx_datastore but didnt worked out. Please help me as it causing issue in my server…
it says somethig like " addon_account_data set owner char1: …"
Please, need help to fix it or can someone show me his datastore code so i can copy that.
Thankyou!
I think the problem is that u dont follow the instructions and you dont do this.
local IdentifierTables = {
{table = “users”, column = “identifier”},
{table = “owned_vehicles”, column = “owner”},
{table = “user_accounts”, column = “identifier”},
}
This is what mine looks like, no one said those had to be in order… the first three are in that order is that what you are talking about
local IdentifierTables = {
{table = “daily_free”, column = “identifier”},
{table = “jsfour_criminalrecord”, column = “identifier”},
{table = “jsfour_criminaluserinfo”, column = “identifier”},
{table = “player_burglaries”, column = “identifier”},
{table = “user_contacts”, column = “identifier”},
{table = “user_parkings”, column = “identifier”},
{table = “whitelist”, column = “identifier”},
{table = “phone_messages”, column = “owner”},
{table = “users”, column = “identifier”},
{table = “owned_vehicles”, column = “owner”},
{table = “user_accounts”, column = “identifier”},
{table = “addon_account_data”, column = “owner”},
{table = “addon_inventory_items”, column = “owner”},
{table = “billing”, column = “identifier”},
{table = “characters”, column = “identifier”},
{table = “datastore_data”, column = “owner”},
{table = “owned_properties”, column = “owner”},
{table = “phone_calls”, column = “owner”},
{table = “phone_users_contacts”, column = “identifier”},
{table = “society_moneywash”, column = “identifier”},
{table = “rented_vehicles”, column = “owner”},
{table = “user_inventory”, column = “identifier”},
{table = “user_licenses”, column = “owner”},
{table = “wh_test”, column = “identifier”},
}
This is what mine looks like, no one said those had to be in order… the first three are in that order is that what you are talking about? is it that simple?
*** i cant tell who is talking to who, I was hopeing that @Hurstzy was asking if i configured in the table of server.lua its actually called server/main.lua
Hey guys. Iv got a solution to this script. Unless your really good with script and constantly updating your main.lua i would NOT recommend using it.
The dev’s who script for ESX_extended so far only have one goal.
and its to eradicate anything in there script that relates back to essensialmode.
Although i agree with this tutorial https://github.com/FiveEYZ/esx_kashacter
you have to keep in mind once extended release another update to there script. They wont add in the changes you have made following said tutorial. And almost 70% of this community are not coder’s/scripters and will come to a point you have to update and download the new update and copy over your current extended script. meaning the changes made will wipe your current main.lua thus making this resource faulty and not working. And you will just end up here again seeking answers. What i have done is simply edit the html folder in es_extended to how i want the identity/char creation HUD to look like.
Keep the folder and once they do an update. (which is very often to eradicate essentialmode) i get to compare and see if changes are made which would change my HUD look. Iv spent the last few days reading round this forum and all i can see is bad English and people chasseing the look of server’s like nopixel/legacy just to name a few. But unless you have a team off 4-5 and more devs behind you with years of experience you will be literally wasting your time. the current ESX build is fine and work’s so why change it?
Just so you can change the look of your server? to match another server that literally has a team of dev’s. Be unique stop chasing what has already been done. Learn to read code and do what makes your server unique.
1 Like
my problem might be coming down to this part of the instructions -
You MUST increase the varchar limit in all tables where column name owner or identifier occurs to at least 48 . u gave tried to “google it bro” and also tried to “learn to code noob” but I cannot find the answer to this.
i think the server I am working in is very unique and I don’t care what the multi-character looks like just want it to work 100%
What DB are you useing? i.e phpmyshitmin or heidi?
haha i think its the shit admin , phpMyAdmin might be the full name haha
HaHa PhPmyadmin is real crap. Heidi is much simpler and easy to use. And you can simply change your max VARCHAR in there.
your so lucky , that’s awesome thanks for showing it to me