Hello everybody!
I'd like to introduce you my own-made systems based on internal.db for small gamemodes or simple servers. I was thinking about how good it'd be if we'd have an abillity to work with account's saved data better and faster only using standard MTA database. I've been looking for an information that could help me to put a lot of data (as player's position, skin, money and so on) in 1 key to internal.db account's data. As for me - this is the best way of using saveAccountData() for non-global servers because it reduces the amount of trash-files in database. I made some researches on that and found out that it doesn't affect the perfomance.
Download: https://community.multitheftauto.com/index.php?p=resources&s=details&id=18786
Preview:
-------------------------------
----ACCOUNT ID SYSTEM UTILS----
-------------------------------
function getAccountDatabaseID( account )
if account and not isGuestAccount( account ) then
accID = 0 -- Set account ID to default
if getAccountData( account, "data" ) and getAccountData( account, "data" ) ~= nil then -- Check out for account's data table
local data = fromJSON( getAccountData( account, "data" ) ) -- Get account's data table
if data[ "ID" ] == nil then
accID = 0 -- Set account ID to default in cause of ID == nil
else
accID = data[ "ID" ] -- Set account ID to account's data table ID
end
else
accID = 0 -- Set account ID to default in cause of account's data table == nil
end
return accID -- Return account's ID
end
end
function getFreeDatabaseID()
local accounts = getAccounts()
missedID = false -- Set an ID to default for operation
for i, v in pairs( accounts ) do -- Start a loop for all server accounts
if i ~= getAccountDatabaseID( v ) then
missedID = i
break
end
end
if missedID ~= false then
return missedID
--[[
ETC: There were 5 accounts. The 3rd one have been deleted.
To avoid dissolution of an ID after deleting account we look for the gap and fill it with new account.
It means that new account, created afther the 5th, would get 3rd ID of deleted account.
--]]
else
return #accounts + 1 -- There were no gaps in ID row, so we return ID as a count of all accounts + created one.
end
end
-----------------------------------------
----ACCOUNT ID SYSTEM UTILS ENDS HERE----
-----------------------------------------
--------------------------
----ACCOUNT DATA TABLE----
--------------------------
function getAccountDataTable( account )
if account and not isGuestAccount( account ) then
if getAccountData( account, "data" ) and getAccountData( account, "data" ) ~= nil then
local data = fromJSON( getAccountData( account, "data" ) ) -- Get account data table
local id = data[ "ID" ] -- Get account ID from data table
local position = data[ "Position" ] -- Get account position from data table
local skin = data[ "Skin" ] -- Get account skin from data table
local money = data[ "Money" ] -- Get account money from data table
return id, position, skin, money -- Return all collected data
end
end
end
function saveAccountDataTable( account, data )
if account and not isGuestAccount( account ) then
setAccountData( account, "data", data )
end
end
addEvent( "saveAccountDataTable", true )
addEventHandler( "saveAccountDataTable", getRootElement(), saveAccountDataTable )
function getPlayerDataTable( player )
local x, y, z = getElementPosition( player ) -- Get player's position
local rotx, roty, rotz = getElementRotation( player ) -- Get player's rotation
local interior = getElementInterior( player ) -- Get player's current interior
local dimension = getElementDimension( player ) -- Get player's current dimension
local skin = getElementModel( player ) -- Get player's skin
local money = getPlayerMoney( player ) -- Get player's money
local accID = getElementData( player, "ID" ) or 0 -- Get player's account ID
----
local data = toJSON( {
[ "ID" ] = accID, -- Prepare account ID to save
[ "Position" ] = { x, y, z, rotz, interior, dimension }, -- Prepare player's position to save
[ "Skin" ] = skin, -- Prepare skin to save
[ "Money" ] = money, -- Prepare money to save
} )
----
return data -- Return all data that we've collected from the player
end
------------------------------------
----ACCOUNT DATA TABLE ENDS HERE----
------------------------------------
----------------------------------------
----IMPLEMENT ALL STUFF THAT WE HAVE----
----------------------------------------
addEventHandler( "onPlayerLogin", getRootElement(), function( _, account )
if account and not isGuestAccount( account ) then
if getAccountData( account, "data" ) and getAccountData( account, "data" ) ~= nil then
----------------------------------------------------
----Spawn player from saved account's data table----
----------------------------------------------------
local ID, position, skin, money = getAccountDataTable( account )
spawnPlayer( source, position[ 1 ], position[ 2 ], position[ 3 ], position[ 4 ], skin, position[ 5 ], position[ 6 ] )
fadeCamera( source, true, 3 )
setCameraTarget( source, source )
setPlayerMoney( source, money, true )
setElementData( source, "ID", ID ) -- Apply player's ID
outputChatBox( "Welcome back, "..getPlayerName( source ).."!", source, 255, 255, 255, true ) -- Output a welcome message
outputChatBox( "Your ID: "..ID, source, 255, 255, 255, true ) -- Output a message to chat for logged player to make a sure that we've got the right ID
else
-------------------------------------------------------------------------------
----Spawn player for the first time or in cause of data table reading error----
-------------------------------------------------------------------------------
local ID = getFreeDatabaseID() -- Get free ID for our player to apply it later
spawnPlayer( source, 0, 0, 0, 0, 0, 0, 0 )
fadeCamera( source, true, 3 )
setCameraTarget( source, source )
setPlayerMoney( source, 0, true )
setElementData( source, "ID", ID ) -- Apply player's ID
outputChatBox( "First time, "..getPlayerName( source ).."? Welcome!", source, 255, 255, 255, true ) -- Output a welcome message
outputChatBox( "Your ID: "..ID, source, 255, 255, 255, true ) -- Output a message to chat for logged player to make a sure that we've got the right ID
end
end
end)
addEventHandler( "onPlayerLogout", getRootElement(), function( account, _ )
local data = getPlayerDataTable( source ) -- Get player's data to save it
saveAccountDataTable( account, data ) -- Save player's data table on log out
end)
addEventHandler( "onPlayerQuit", getRootElement(), function()
local account = getPlayerAccount( source )
local data = getPlayerDataTable( source ) -- Get player's data to save it
saveAccountDataTable( account, data ) -- Save player's data table on exit
end)
P.S: I appreciate any opinion and advice, thank you!?
You can use this script for any purpose - the code is opened! I've also tried to explain the whole script. I hope it'd help!
Download: https://community.multitheftauto.com/index.php?p=resources&s=details&id=18786