|
forums.php
<?php
$gTitle = 'Forums'; // title to display in header
include_once('./header.php'); // init.php inside header.php
//--------------
// PREPARE GRID
$lens = new phplens('3a6a9aae',$gDB,
"select forumid,forumname,count(*) nummsgs from forums left join replies ".
" on forumid=forumkey group by forumid order by forumname");
//---------------------------------------
// If administrator, give extra privileges
if ($gAdmin) {
$lens->canEdit = true;
$lens->canDelete = true;
} else {
$lens->menuHide='new;filter;dynedit';
$lens->canEdit = false;
$lens->canDelete = false;
$lens->canNew = false;
}
$lens->menuNew = "<img src=$PHPLENS_PATH/img/new.gif width=20 height=20 border=0 title='New Forum'>";
$lens->gridTableHeader = 'width=100% BORDER=1 cellspacing=1 cellpadding=8';
$lens->colorNavBorder = 'ORANGE';
$lens->colorBackground = 'GRAY';
$lens->colorTitle = 'ORANGE';
$lens->colorOdd = 'LIGHTYELLOW';
$lens->colorEven = 'BLANCHEDALMOND';
$lens->lang->topCaption = '<b> <font color=white>PHPLens Forums</font> </b>';
$lens->lang->bottomCaption = '';
$lens->showHeaders = false;
$lens->showRecNo = 0;
// to disable dynamic editing, uncomment the line below
//$lens->dynEdit = 0;
$lens->keyTable = 'forums'; // Save Data Table
$lens->keyCol = 'forumid'; // Primary Key of Save Data Table
$lens->pageSize = 10; // rows per page
$lens->nameLens = 'FORUMNAME^forumname^^^';
$lens->gridLens = 'FORUMNAME;NUMMSGS';
$lens->newLens = 'FORUMNAME';
$lens->editLens = 'FORUMNAME';
$lens->powerLens = 'NUMMSGS^<div align=right>{nummsgs} messages</div>;'
.'FORUMNAME^="<b><font size=3><a href=topics.php?id=".{forumid}.">".{forumname}."</a>".NBSP.NBSP.NBSP."<font></b>"';
$lens->Render();
$lens->Close();
// Uncomment this if you want to switch from administrator to normal user
#if (!$gAdmin)print '<p align=center><a href=admin/admin.php>admin</a><br></p>';
#else print '<p align=center><a href=admin/logout.php>logout</a><br></p>';
include_once('./footer.php');
?>
|
|
