Race Stats help..

[GanJaRuleZ]

Hai allz

I have a problem with the following script

- 

When i start it , it gives the following error :

SCRIPT ERROR: userpanel/Stats.lua:35: 'end' expected near

Can anybody help?

Edited December 23, 2011 by Guest

[CapY]

What you don't get ?

You have an missing 'end' in the beginning of the script.

Edited December 21, 2011 by Guest

[Xeno]

function start () 
executeSQLCreateTable("RaceStats", "serial STRING, RaceWins INT, RaceLoses INT") 
end 

[GanJaRuleZ]

heh , thanks im just a beginer in scripting

As i said , im just a begginer in scripting , so sorry for these noob questions

@got the problem

Edited December 21, 2011 by Guest

[Xeno]

Try using this:

addEventHandler("onPlayerWasted",getRootElement(), 

[GanJaRuleZ]

Thanks you both

I've got the problem..

Edited December 21, 2011 by Guest

[Xeno]

No problem.

[GanJaRuleZ]

Last problem :

I edited it and it gives the following thing :

ERROR:userpanel/server.lua:16: attemp to call global 'rootElement'

at the same script

thanks you both in advance

[Xeno]

As I said before, use this:

addEventHandler("onPlayerWasted",getRootElement(), 

[GanJaRuleZ]

Heh , yeah i got it now

Thanks

[Xeno]

No problem.

[GanJaRuleZ]

Finally i got it run

but

it gives the following errors :

ERROR: userpanel\stats.lua:22: attempt to concatenate local 'lua'

ERROR:userpanel\server.lua:19: attempt to perform arithmetic on a nil value

PS: Don't get mad on me , please I'm new in scripting

[CapY]

Give the script.( Last one is outdated )

[GanJaRuleZ]

STATS.LUA:

  
--Removed! 
  

SERVER.LUA

  
--Removed! 
  
  

Edited December 23, 2011 by Guest

[arezu]

is that the whole script? because i dont see any variable called 'lua'.

[GanJaRuleZ]

Where its 'lua'?

And yes thats the whole script

[CapY]

At line 19, in "server.lua", you didn't set the function name.

[myonlake]

function start() 
    executeSQLCreateTable("RaceStats", "serial STRING, RaceWins INT, RaceLoses INT") 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), start) 
  
function onPlayerJoinLoadStats() 
    local serial = getPlayerSerial(source) 
    local result = executeSQLSelect("RaceStats", "*", "serial = '" .. tostring(serial) .. "'") 
    if (type(result) == "table" and #result == 0) or not result then 
        setElementData(source, "Race Wins", tonumber(re[1]["RaceWins"]) or 0) 
        setElementData(source, "Race Loses", tonumber(re2[1]["RaceLoses"]) or 0) 
    else 
        executeSQLInsert("RaceStats", "'" .. tostring(serial) .. "', '0', '0', '0', '0'") 
    end 
end 
addEventHandler("onPlayerJoin", getRootElement(), onPlayerJoinLoadStats) 
  
function publicstatsinfo() 
    local askdname = getPlayerName(source) 
    local wins = getElementData(source, "Race Wins") 
    local loses = getElementData(source, "Race Loses") 
    outputChatBox("* You won " .. wins .. " times and you losed " .. loses .. " times", source, 255, 12, 15) 
end 
addEvent("stats", true) 
addEventHandler("stats", getRootElement(), publicstatsinfo) 
  
function checkCommand(message, messageType) 
    if (messageType == 0) then 
        if (message == "!stats") then 
            cancelEvent() 
            setTimer(triggerEvent, 100, 1, "stats", source) 
        end 
    end 
end 
addEventHandler("onPlayerChat", getRootElement(), checkCommand) 

function DestructionMoney2() 
    local alivePlayers = getAlivePlayers() 
    if info == "Destruction derby" then 
        if #alivePlayers == 1 then 
            local playername = getPlayerName(alivePlayers[1]) 
            local serial = getPlayerSerial(alivePlayers[1]) 
            local oldData = executeSQLSelect( "RaceStats", "RaceWins","serial = '" .. serial .. "'") 
            local oldData = executeSQLSelect( "RaceStats", "RaceWins","serial = '" .. serial .. "'") 
            newData = tonumber(oldData[1]["RaceWins"]) + 1 
            setElementData(alivePlayers[1], "Race Wins", tonumber(getElementData(alivePlayers[1], "Race Wins")) + 1)   
            executeSQLUpdate("RaceStats", "RaceWins = '" .. newData .. "'","serial = '" .. serial .. "'") 
            outputChatBox(getPlayerName(alivePlayers[1] ) .. " is the last player alive!", rootElement, 0, 255, 0) 
        end 
    end 
end 
  
addEventHandler("onPlayerWasted", getRootElement(), 
function() 
    local serial = getPlayerSerial(source) 
    local oldData = executeSQLSelect("RaceStats", "RaceLoses", "serial = '" .. serial .. "'") 
    setElementData(source, "Race Loses", tonumber(getElementData(source, "Race Loses")) + 1) 
    newData = tonumber(oldData[1]["RaceWins"]) + 1 
    executeSQLUpdate("RaceStats", "RaceLoses = '" .. newData.. "'","serial = '" .. serial .. "'")    
end) 

[GanJaRuleZ]

Hai , thank you but it give me the following error :

ERROR: userpnael/Stats.lua:22: attempt to concatenate local 'loses; < a boolean value > (here the line is 21 )

This error gives in the following script

--Removed! 

Thanks in advance

Edited December 23, 2011 by Guest

[myonlake]

Hai , thank you but it give me the following error :

ERROR: userpnael/Stats.lua:22: attempt to concatenate local 'loses; < a boolean value > (here the line is 21 )

This error gives in the following script

function start() 
    executeSQLCreateTable("RaceStats", "serial STRING, RaceWins INT, RaceLoses INT") 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), start) 
  
function onPlayerJoinLoadStats() 
    local serial = getPlayerSerial(source) 
    local result = executeSQLSelect("RaceStats", "*", "serial = '" .. tostring(serial) .. "'") 
    if (type(result) == "table" and #result == 0) or not result then 
        setElementData(source, "RaceWins", tonumber(re[1]["RaceWins"]) or 0) 
        setElementData(source, "RaceLoses", tonumber(re2[1]["RaceLoses"]) or 0) 
    else 
        executeSQLInsert("RaceStats", "'" .. tostring(serial) .. "', '0', '0', '0', '0'") 
    end 
end 
addEventHandler("onPlayerJoin", getRootElement(), onPlayerJoinLoadStats) 
  
function publicstatsinfo() 
    local askdname = getPlayerName(source) 
    local wins = getElementData(source, "RaceWins") 
    local loses = getElementData(source, "RaceLoses") 
    outputChatBox("* You won " .. wins .. " times and you losed " .. loses .. " times", source, 255, 12, 15) 
end 
addEvent("stats", true) 
addEventHandler("stats", getRootElement(), publicstatsinfo) 
  
function checkCommand(message, messageType) 
    if (messageType == 0) then 
        if (message == "!stats") then 
            cancelEvent() 
            setTimer(triggerEvent, 100, 1, "stats", source) 
        end 
    end 
end 
addEventHandler("onPlayerChat", getRootElement(), checkCommand) 

Thanks in advance

Then the source doesn't have that data.

Make a check like this:

if loses and wins then 
     -- stuff here 
     else 
     -- stuff here 
end 

[GanJaRuleZ]

Can you give me a example?

Im pretty new in scripting

Thank you...

@EDIT : yeap , i made it working , i remove all the scripts , cuz i dont want someone to steal it until the final version

P.S: The final version will be released as public resource in community tab!

Thanks all , i will put special thanks , with ur names guys , thank you once more!

[GanJaRuleZ]

Back again on the topic...

At the first test , it seems that it doesen't saves the data , can anyone help?