Jump to content

[HELP] I can't figure it out


JasperRieken

Recommended Posts

This is client side..

  
function Columns() 
    exports.scoreboard:scoreboardAddColumn("TimePlayed") 
    setElementData(localPlayer,"TimePlayed",0) 
end 
addEventHandler("onClientResourceStart", getResourceRootElement(getThisResource()), Columns) 

serverside

  
function start () 
executeSQLCreateTable("TimePlayed", "serial STRING, TimePlayed INT") 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), start) 
  
function addASecond() 
local serial = getPlayerSerial(player) 
local oldData = executeSQLSelect( "TimePlayed", "TimePlayed","serial = '" .. serial .. "'") 
newData = tonumber(oldData[1]["TimePlayed"]) + 1 
setElementData(alivePlayers[1],"TimePlayed",tonumber(getElementData(player,"TimePlayed"))+1)    
executeSQLUpdate ( "TimePlayed", "TimePlayed = '"..newData.."'","serial = '" .. serial .. "'") 
     end  
   end 
end 
  
  
setTimer ( addASecond, 1000, 9999999 )  

@EDIT : It isnt tested :)

Link to comment
function addASecond() 
local serial = getPlayerSerial(player) 
local oldData = executeSQLSelect( "TimePlayed", "TimePlayed","serial = '" .. serial .. "'") 
newData = tonumber(oldData[1]["TimePlayed"]) + 1 
setElementData(alivePlayers[1],"TimePlayed",tonumber(getElementData(player,"TimePlayed"))+1)   
executeSQLUpdate ( "TimePlayed", "TimePlayed = '"..newData.."'","serial = '" .. serial .. "'") 
     end 
   end 
end 
addEventHandler ( "onClientRender", getRootElement(), addASecond) 

Use and onClientRender which will update the timer every second. If you use a setTimer it will lag the server because its being used a lot.

Link to comment

ClientSide ( by me )

  
function Columns() 
    exports.scoreboard:scoreboardAddColumn("TimePlayed") 
    setElementData(localPlayer,"TimePlayed",0) 
end 
addEventHandler("onClientResourceStart", getResourceRootElement(getThisResource()), Columns) 

ServerSide (by Xeno)

  
function addASecond() 
local serial = getPlayerSerial(player) 
local oldData = executeSQLSelect( "TimePlayed", "TimePlayed","serial = '" .. serial .. "'") 
newData = tonumber(oldData[1]["TimePlayed"]) + 1 
setElementData(player,"TimePlayed",tonumber(getElementData(player,"TimePlayed"))+1)   
executeSQLUpdate ( "TimePlayed", "TimePlayed = '"..newData.."'","serial = '" .. serial .. "'") 
     end 
   end 
end 
addEventHandler ( "onClientRender", getRootElement(), addASecond) 

Link to comment
ClientSide ( by me )
  
function Columns() 
    exports.scoreboard:scoreboardAddColumn("TimePlayed") 
    setElementData(localPlayer,"TimePlayed",0) 
end 
addEventHandler("onClientResourceStart", getResourceRootElement(getThisResource()), Columns) 

ServerSide (by Xeno)

  
function addASecond() 
local serial = getPlayerSerial(player) 
local oldData = executeSQLSelect( "TimePlayed", "TimePlayed","serial = '" .. serial .. "'") 
newData = tonumber(oldData[1]["TimePlayed"]) + 1 
setElementData(player,"TimePlayed",tonumber(getElementData(player,"TimePlayed"))+1)   
executeSQLUpdate ( "TimePlayed", "TimePlayed = '"..newData.."'","serial = '" .. serial .. "'") 
     end 
   end 
end 
addEventHandler ( "onClientRender", getRootElement(), addASecond) 

Why client?

This can be done much easier.

Link to comment
This is client side..
  
function Columns() 
    exports.scoreboard:scoreboardAddColumn("TimePlayed") 
    setElementData(localPlayer,"TimePlayed",0) 
end 
addEventHandler("onClientResourceStart", getResourceRootElement(getThisResource()), Columns) 

He say he want it with dxscoreboard so it's:

function Columns() 
    exports.dxscoreboard:scoreboardAddColumn("TimePlayed") 
    setElementData(localPlayer,"TimePlayed",0) 
end 
addEventHandler("onClientResourceStart", getResourceRootElement(getThisResource()), Columns) 

Link to comment
function addASecond() 
        local serial = getPlayerSerial(player) 
        local oldData = executeSQLSelect( "TimePlayed", "TimePlayed","serial = '" .. serial .. "'") 
            newData = tonumber(oldData[1]["TimePlayed"]) + 1 
        setElementData(player,"TimePlayed",tonumber(getElementData(player,"TimePlayed"))+1)   
    executeSQLUpdate ( "TimePlayed", "TimePlayed = '"..newData.."'","serial = '" .. serial .. "'") 
end 
  
addEventHandler ( "onClientRender", getRootElement(), addASecond) 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...