<?php

/*-------------------------------------------------------+

| PHP-Fusion Content Management System

| Copyright (C) 2002 - 2013 Nick Jones

| http://www.php-fusion.co.uk/

+--------------------------------------------------------+

| Filename: panel.php

| Author: matze thanks David for NSS

+--------------------------------------------------------+

| This program is released as free software under the

| Affero GPL license. You can redistribute it and/or

| modify it under the terms of this license which you

| can read by viewing the included agpl.txt or online

| at www.gnu.org/licenses/agpl.html. Removal of this

| copyright header is strictly prohibited without

| written permission from the original author(s).

+--------------------------------------------------------*/

openside("test");

include_once INFUSIONS."panel/infusion_db.php";

$result = dbquery(

"SELECT ta.id, ta.name, ta.count, ta.datum, 

tac.cat_name, tac.cat_id, tac.cat_access

FROM ".DB_MEINE." AS ta

LEFT JOIN ".DB_MEINE." AS a2 

ON ta.cat = a2.cat AND ta.datum <= a2.datum

INNER JOIN ".DB_MEINE_CAT." AS tac 

ON ta.cat=tac.cat_id     

".(iSUPERADMIN ? "" : "WHERE ".groupaccess('tac.cat_access'))."

GROUP BY ta.id

HAVING COUNT(*) <= 3

ORDER BY ta.cat, ta.datum, ta.count"

);

if (dbrows($result)) {

$cat = "";

while($data = dbarray($result)) {

$num = dbcount("(cat)", DB_MEINE, "cat='".$data['cat_id']."'");

if($cat != $data['cat_id']) {

echo "<a href='".INFUSIONS."panel/datei.php?cat_id=".$data['cat_id']."'title='".$data['cat_name']."'>

".$data['cat_name']."></a> [".$num."]<br />";

$cat = $data['cat_id'];

}

$itemsubject = trimlink($data['name'], 15);

echo "<img src='".INFUSIONS."panel/images/join.gif' style='border:0px; vertical-align:middle;' />

<a href='".INFUSIONS."panel/datei.php?cat_id=".$data['cat_id']."&amp;id=".$data['id']."' class='side'>$itemsubject</a><br />";

}

}else{

echo "<div style='text-align:center'>Nix da</div>\n";

}

closeside();

?>