Queries on Custom Pages with Multiple Results
 

I know that the answer exists somewhere.. I just have no idea what I should be searching for.

I have a custom table with userids, win and losses for a game I made. I want to display these results on a custom page using only plugins and templates. I'd rather not create a physical file.

Can someone please point me in the right direction? I don't understand how to create a query in the plugin and display it in the template.

Thanks.

If you don't want to create a new file, you can use a plugin on hook misc_start and have your plugin check for a specific value of $_REQUEST['do'], like:

then the url for your page would be misc.php?do=game_stats.


To format your page, you would do your query then build a string with the results, then probably use that string in a template, like:

You could also use a small template to format your game stats if you prefer, rather than putting html formatting in your plugin code.

You are easily the most helpful person I have ever dealt with on this website. No credit taken away from the others that have helped me.. but you are awesome.

Thank you so much. Works perfectly.