#88 DBPager -- Sort on joined columns

[Eloi George]

This patch allows DBPager to show sort buttons for joied columns. To take advantage of it, first create the JOIN like so:
$pager->db->addColumn('phpwsbb_forums.title', null, 'forumname');
$pager->db->addWhere('phpwsbb_forums.id', 'phpwsbb_topics.fid');

(Note that the addcolumn() on the first line renames the column name "phpwsbb_forums.title" to "forumname". That was done because the main table used already had a column named "title")

then add the joined column to the list of table columns.

$pager->table_columns[] = 'phpwsbb_forums.title';

The template tag that will be generated for the sort button will be the mane of the column with all periods replaced by the underscore symbol. Therefore "phpwsbb_forums.title" creates a template tag of PHPWSBB_FORUMS_TITLE_SORT.

[Eloi George]

Patch for /core/class/DBPager.php

[Anonymous]

Logged In: YES
user_id=400519
Originator: NO

Added. Thanks.