Linkin Park Posted March 20, 2013 Group: Members Topic Count: 42 Topics Per Day: 0.01 Content Count: 227 Reputation: 11 Joined: 11/16/11 Last Seen: November 7, 2015 Share Posted March 20, 2013 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? Quote Link to comment Share on other sites More sharing options...
Linkin Park Posted March 21, 2013 Group: Members Topic Count: 42 Topics Per Day: 0.01 Content Count: 227 Reputation: 11 Joined: 11/16/11 Last Seen: November 7, 2015 Author Share Posted March 21, 2013 help anyone? Quote Link to comment Share on other sites More sharing options...
Linkin Park Posted March 23, 2013 Group: Members Topic Count: 42 Topics Per Day: 0.01 Content Count: 227 Reputation: 11 Joined: 11/16/11 Last Seen: November 7, 2015 Author Share Posted March 23, 2013 bumps Quote Link to comment Share on other sites More sharing options...
GmOcean Posted March 23, 2013 Group: Members Topic Count: 31 Topics Per Day: 0.01 Content Count: 666 Reputation: 93 Joined: 04/27/12 Last Seen: August 17, 2015 Share Posted March 23, 2013 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 1 Quote Link to comment Share on other sites More sharing options...
Question
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?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.