Lua Clean Kills and Death

[corolho]

Hello .. How can i clean kills and death in my ot using a lua file?

 

[mbruzaca]

What do you mean with "using a lua file"? U wanna call a lua script that will clean your kills in databse?

 

[corolho]

That's it.

 

[Cronox]

I make 1 script try this:
globalevents.xml

<globalevent name="clean" type="startup" event="script" value="clean.lua"/>

clean.lua

function onStartup()
         db.executeQuery("DELETE FROM  player_deaths WHERE player_id IN (SELECT id FROM players);")
         db.executeQuery("DELETE FROM  player_killers WHERE  player_id IN (SELECT id FROM players);")
         return TRUE
end

You onStartup your otserver execute automatic 2 querys.. and delete player deaths and player killers..

 

[Critico]

db.executeQuery("DELETE FROM player_deaths;")
db.executeQuery("DELETE FROM player_killers;")