Vincent Posted July 28, 2013 Group: Members Topic Count: 130 Topics Per Day: 0.03 Content Count: 528 Reputation: 18 Joined: 09/11/12 Last Seen: March 5, 2020 Share Posted July 28, 2013 (edited) Hi, how can i create a list as Message out of Database. Like a Toplist. is there any standart script for those jobs? The DB strucur is: [char_id] [Points] Edited July 28, 2013 by Thor v2 Quote Link to comment Share on other sites More sharing options...
Xynvaroth Posted July 28, 2013 Group: Members Topic Count: 39 Topics Per Day: 0.01 Content Count: 254 Reputation: 72 Joined: 07/10/13 Last Seen: October 9, 2017 Share Posted July 28, 2013 1. Delete the arrays you will use for query_sql( ). 2. Use query_sql( ) to get the datasets (order the result by `Points`). 3. Loop through the datasets using for( ). 4. For each dataset, select the character names from the `char` table and display both the names and the points. This will only work if you have less than 128 entries in the top list. See this suggestion if you want more than 128 entries. Quote Link to comment Share on other sites More sharing options...
Vincent Posted July 28, 2013 Group: Members Topic Count: 130 Topics Per Day: 0.03 Content Count: 528 Reputation: 18 Joined: 09/11/12 Last Seen: March 5, 2020 Author Share Posted July 28, 2013 Thanks i will try if i get it. Quote Link to comment Share on other sites More sharing options...
Question
Vincent
Hi,
how can i create a list as Message out of Database. Like a Toplist.
is there any standart script for those jobs?
The DB strucur is: [char_id] [Points]
Edited by Thor v2Link to comment
Share on other sites
2 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.