<?php
/***********************************************************************
Copyright (C) 2005 Connor Dunn (Connorhd@mypunbb.com)
This software is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published
by the Free Software Foundation; either version 2 of the License,
or (at your option) any later version.
This software is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston,
MA 02111-1307 USA
************************************************************************/
// Make sure no one attempts to run this script "directly"
if (!defined('PUN'))
exit;
// Tell admin_loader.php that this is indeed a plugin and that it is loaded
define('PUN_PLUGIN_LOADED', 1);
generate_admin_menu($plugin);
?>
<div class="block">
<h2><span>User Subscriptions</span></h2>
<div class="box">
<div class="inbox">
<p>Shows you what topics users are subscribed to, grouped by username</p>
</div>
</div>
</div>
<div class="block">
<h2 class="block2"><span>User Subscriptions</span></h2>
<div class="box">
<div class="inbox">
<table class="aligntop" cellspacing="0">
<?php
$result = $db->query('SELECT u.username, t.subject FROM '.$db->prefix.'subscriptions AS s LEFT JOIN '.$db->prefix.'users AS u ON s.user_id=u.id LEFT JOIN '.$db->prefix.'topics AS t ON s.topic_id=t.id ORDER BY u.username;');
while ($row = $db->fetch_assoc($result))
{
if (!isset($last_user)) {
echo "<tr>\n\t\t\t\t\t\t<th scope=\"row\">\n\t\t\t\t\t\t\t".$row['username']."\n\t\t\t\t\t\t</th>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<span>";
echo $row['subject'];
}
elseif ($last_user == $row['username']) {
echo ', '.$row['subject'];
}
else
{
echo "</span>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th scope=\"row\">\n\t\t\t\t\t\t\t".$row['username']."\n\t\t\t\t\t\t</th>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<span>";
echo $row['subject'];
}
$last_user = $row['username'];
}
echo "\n"
?></span>
</td>
</tr>
</table>
</div>
</div>
</div>
much better, it displays properly, it doesn't use the db plugin so its not full of all the stuff from that, and it groups by username
