Vincent Posted July 28, 2013 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 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 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...
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