EndlessTower Time Records

[Linkin Park]

I want to create a ladder NPC that shows the Top 5 Best Time to finish Endless Tower, is there a specific variable that holds it or a database entry that holds the time value of a party when they finished the Endless Tower?

[Linkin Park]

help anyone?

[Linkin Park]

bumps

[GmOcean]

You would need to add this yourself. A good start, would be to add a variable in the begining of the Endless Tower script, that is activated when a party enters the dungeon for the FIRST time during their cooldown. Then, when they finish the tower, you would just add the data the variable has into a sql query (Since this is the easiest way to make a ladder IMO).

setd "$@ET_Time"+ getcharid(2) +"", gettimetick(2);

AT END OF TOWER

setd "$@ET_Time"+ getcharid(2) +"", gettimetick(2) - getd( "$@ET_Time"+ getcharid(2) +"");

query_sql "INSERT INTO 'time' FROM 'endless_time' VALUE ' "+ getd( "$@ET_Time"+ getcharid(2) +"") +" ' ";
end;

Or Atleast, something like that. Sorry, i've been absent from the RO scripting scene for a bit, kinda rusty on the actual sql syntax =p