Saving skins etc.

[Thehookerkiller01]

Hello, I'm thinking to save Wanted levels, player money, player skins, player weapons, cars in a database automaticly.

But where is the best place I can store it? MySQL? (and how) or a XML file or a plain text file (like lua or something).

And how can you get those things when a player disconnect? (Also for when a player have Network Trouble, because I have many players who have money and a tuned car, and they got disconnected, and when they reconnect their skin, weapons, money and car etc is resetted. What I want is to save it automaticly when a player disconnects, log out's, or MTA closes directly (or shut down the pc).

[50p]

It all depends on how you're going to use the data saved. If you want to use MySQL you could make a website where users could log in and sell the cars, buy "new skins", buy weapons, etc. If you're not going to make a website then you can use SQLite or XML. One problem with MySQL/SQLite is that you have to think of a way to save cars.. It's not that simple especially if you haven't got much knowledge about SQL engines. Saving cars in XML files would be easy though.

To save all your stuff when player leaves use: onPlayerQuit

[knash94]

function createdb () 
        executeSQLCreateTable ( "ppplayers", "money INTEGER, health INTEGER, armour INTEGER, job TEXT, wanted INTEGER, player TEXT" ) 
end 
addCommandHandler ("dbadd", createdb ) 
  
  
function updatedb ( sourcePlayer, theTeam )  
    sourcename = getClientName ( sourcePlayer ) 
    player = executeSQLSelect ( "ppplayers", "player", "player = '" .. sourcename .. "'" ) 
        if ( player == false ) then 
            outputChatBox("You have no account to update", sourcePlayer) 
        else     
            executeSQLUpdate ( "ppplayers", "money = '800', health = '50', armour = '100', job = 'Police', wanted = '1'", "player = '" .. sourcename .. "'" ) 
            outputChatBox ("Update finished", sourcePlayer) 
        end 
end 
addCommandHandler ("updatedb", updatedb) 
  
  
  
  
function onjoindb ()  
local sourcename = getClientName ( source )  
        player = executeSQLSelect ( "ppplayers", "player", "player = '" .. sourcename .. "'" ) 
        if ( player == false ) then    
                executeSQLInsert ( "ppplayers", "'600', '100', '0', 'Civillian', '0', '" .. sourcename .. "'" ) 
                outputChatBox ( "This is your first time here! Welcome " .. sourcename .. "!", source ) 
        else 
                local money = executeSQLSelect ( "ppplayers", "money", "player = '" .. sourcename .. "'" ) 
                setPlayerMoney( source, money[1][1] ) 
                -- 
                local wanted = executeSQLSelect ( "ppplayers", "wanted", "player = '" .. sourcename .. "'" ) 
                setPlayerWantedLevel ( source, wanted[1][1] ) 
                -- 
                local job = executeSQLSelect ( "ppplayers", "job", "player = '" .. sourcename .. "'" ) 
                setPlayerTeam( source, getTeamFromName( job[1][1] ) ) 
                outputChatBox("Welcome back " .. sourcename .. " to the " .. job[1][1] .. " team... You have $" .. money[1][1], source) 
        end      
         
end 
  
addEventHandler ( "onPlayerJoin", getRootElement(), onjoindb ) 
  
function onquitdb () 
local sourcename = getClientName ( source ) 
        getmoney = getPlayerMoney ( source ) 
        getplayerTeam = getPlayerTeam ( source )  
        wanted = getPlayerWantedLevel( source ) 
        playerTeam = getTeamName ( getplayerTeam ) 
        executeSQLUpdate ( "ppplayers", "money = '" .. getmoney .. "', health = '50', armour = '100', job = '" .. playerTeam .. "', wanted = '" .. wanted .. "'", "player = '" .. sourcename .. "'" ) 
end 
addEventHandler ( "onPlayerQuit", getRootElement(), onquitdb )      
  

You may want to delete the useless information.. its very is moddable too.

Their may be a few bugs but this is just finished so.. dont rely on it too much

[Thehookerkiller01]

You may want to delete the useless information.. its very is moddable too.

Their may be a few bugs but this is just finished so.. dont rely on it too much

Thx man

Edit: should I have to type every time that the server start dbadd or not?

Edit2: why health 50?

[knash94]

I aint fixed it up for regular use and it was 50 health for when i was testing it

also you wont need to put dbadd evry time.. if you wish you can change the handler for when resource starts. ( But it dont make no diffrence )

[Thehookerkiller01]

[19:11:24] ERROR: script.lua:30: attempt to index field '?' (a nil value)

Line 30: setPlayerMoney( source, money[1][1] )

[knash94]

  
function dbadd () 
        executeSQLCreateTable ( "ppplayers", "money INTEGER, health INTEGER, armour INTEGER, job TEXT, wanted INTEGER, player TEXT" ) 
end 
addCommandHandler ("dbadd", dbadd) 
  
  
function updatedb ( sourcePlayer, theTeam )  
    sourcename = getClientName ( sourcePlayer ) 
    player = executeSQLSelect ( "ppplayers", "player", "player = '" .. sourcename .. "'" ) 
        if ( player == false ) then 
            outputChatBox("You have no account to update", sourcePlayer) 
        else     
            executeSQLUpdate ( "ppplayers", "money = '800', health = '50', armour = '100', job = 'Police', wanted = '1'", "player = '" .. sourcename .. "'" ) 
            outputChatBox ("Update finished", sourcePlayer) 
        end 
end 
addCommandHandler ("updatedb", updatedb) 
  
  
  
  
function onjoindb ()  
local sourcename = getClientName ( source )  
        player = executeSQLSelect ( "ppplayers", "player", "player = '" .. sourcename .. "'" ) 
        if ( player == false ) then    
                executeSQLInsert ( "ppplayers", "'600', '100', '0', 'Civillian', '0', '" .. sourcename .. "'" ) 
                outputChatBox ( "This is your first time here! Welcome " .. sourcename .. "!", source ) 
        else 
                local money = executeSQLSelect ( "ppplayers", "money", "player = '" .. sourcename .. "'" ) 
                setPlayerMoney( source, money[1][1] ) 
                -- 
                local wanted = executeSQLSelect ( "ppplayers", "wanted", "player = '" .. sourcename .. "'" ) 
                setPlayerWantedLevel ( source, wanted[1][1] ) 
                -- 
                local job = executeSQLSelect ( "ppplayers", "job", "player = '" .. sourcename .. "'" ) 
                setPlayerTeam( source, getTeamFromName( job[1][1] ) ) 
                outputChatBox("Welcome back " .. sourcename .. " to the " .. job[1][1] .. " team... You have $" .. money[1][1], source) 
        end      
         
end 
  
addEventHandler ( "onPlayerJoin", getRootElement(), onjoindb ) 
  
function onquitdb () 
local sourcename = getClientName ( source ) 
        getmoney = getPlayerMoney ( source ) 
        getplayerTeam = getPlayerTeam ( source )  
        wanted = getPlayerWantedLevel( source ) 
        playerTeam = getTeamName ( getplayerTeam ) 
        executeSQLUpdate ( "ppplayers", "money = '" .. getmoney .. "', health = '50', armour = '100', job = '" .. playerTeam .. "', wanted = '" .. wanted .. "'", "player = '" .. sourcename .. "'" ) 
end 
addEventHandler ( "onPlayerQuit", getRootElement(), onquitdb )      
    
function cash ( sourcePlayer ) 
    setPlayerMoney ( sourcePlayer, "50000") 
end 
addCommandHandler ("cash", cash) 
  

I keep getting error: db.lua line 33: attempt to call index field '?' (A nil value)

This is on MTA nightly and if anyone can help to clean up this script to mta 1 i will be grateful..

Thank you.

[Thehookerkiller01]

I'm using the nightly version..

[knash94]

Sorry to bump but i need to start moving on with some scripts and this needs to be fixed before i can continue... Anyone knows what the problem is? works like a dream in DP2.3 tho ;\

[Lordy]

The wanted[1] doesn't exist. (line 34) And you're trying to get wanted[1][1], that means, take the first index from the nil value.

I'm not sure why tho.. Had something to do with rows and colums, but honestly, I don't know much about SQL(ite)

[knash94]

Is that why it works in DP2.3? But thanks for trying to help (Y)

[50p]

Why don't you debug it? Do some outputs and see why you get this error... It seems that executeSQLSelect doesn't return what it meant to. As I said, make some outputs and see why you get error.

[Thehookerkiller01]

Already had sent the error.

[knash94]

I now know its

player = executeSQLSelect ( "ppplayers", "player", "player = '" .. sourcename .. "'" ) 
        if ( player == false ) then 

There has been no change to SQLselect recently and that has not been announced ? Sorry for the hassle.. Im just stuck

[50p]

I now know its

player = executeSQLSelect ( "ppplayers", "player", "player = '" .. sourcename .. "'" ) 
        if ( player == false ) then 

There has been no change to SQLselect recently and that has not been announced ? Sorry for the hassle.. Im just stuck

If you haven't changed anything (inside the code and table structure) and you run it on nightly build then I guess executeSQLSelect needs some testing.