[HELP] I can't figure it out

[JasperRieken]

I can't figure out a dxscoreboard thingy i wanted to add a time like what the've played in total and that it counts up but i would really not know how to if someone could help that would be really awesome

[GanJaRuleZ]

You mean to add time played in the scoreboard?

[JasperRieken]

yes

[GanJaRuleZ]

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

[JasperRieken]

I do believe it works but does it say if it reaches the 60 min does it say 1 Hour 2 Minutes or somting

[JasperRieken]

And it doesn't count either so it doesn't work

[GanJaRuleZ]

What doesen't counts ?

[JasperRieken]

It doesn't count so it doesn't work also could you make it so after 60 mins it will say 1 hour 2 minutes

[GanJaRuleZ]

I don't make scripts at command lol , you have to script it yourself

I gaved you an example!

[JasperRieken]

well i've been trying for three days can you please help me with reading what you will make i learn more because i really can't get it to work man

[Xeno]

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.

[JasperRieken]

so whats the full script

[NotAvailable]

so whats the full script

Oh hallo Jasper.

[GanJaRuleZ]

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) 

[NotAvailable]

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.

[Sparrow]

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) 

[GanJaRuleZ]

Huh , he wants to add it in the scoreboard ..

Just look there

@Edit : Whatever ..

[JasperRieken]

[2011-12-23 20:55:32] SCRIPT ERROR: dxscoreboard/time_Server.lua:8: '' expected near 'end'

[2011-12-23 20:55:32] WARNING: Loading script failed: dxscoreboard/time_Server.lua:8: '' expected near 'end'

[Sparrow]

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) 

[Xeno]

I've never done it before, I was only correcting the other dudes script so that it wasnt on a timer.

[NotAvailable]

I've never done it before, I was only correcting the other dudes script so that it wasnt on a timer.

Ill post mine soon...

[NotAvailable]

Here it is:

--REMOVED UPON REQUEST 

Edited December 23, 2011 by Guest

[Xeno]

That looks pretty good :3^

[JR10]

Here it is:

Releasing this on the community tommorrow so..

This is my script.

Can some mod or admin check Jesse's account IP?

He says it been hacked.

[JasperRieken]

well the thing is it just doesn't count