function renderCategory($level, $cat)
{
global $session;
global $db;
$qs = "SELECT " . "category_id, " . "category_name, " . "category_description, " . "category_created, " . "category_creator, " . "user_login, " . "user_name, " . "(SELECT COUNT(*) FROM phph_photos_categories WHERE phph_photos_categories.category_id = phph_categories.category_id) AS photos " . "FROM phph_categories " . "LEFT OUTER JOIN phph_users ON phph_categories.category_creator = phph_users.user_id ";
if (!empty($cat)) {
$qs .= "WHERE category_parent = {$cat} ";
} else {
$qs .= "WHERE category_parent IS NULL ";
}
$qs .= "ORDER BY category_order ASC";
$q = $db->prepare($qs);
$res = $db->execute($q);
if (PEAR::isError($res)) {
die($res->getMessage());
}
$i = 0;
while ($res->fetchInto($row)) {
$created = strftime("%Y-%m-%d %T", $row['category_created']);
?>
<tr>
<td><a href="<?php
echo HTML::addRef($session->addSID("category_info.php?cid=" . $row['category_id']));
?>
"><?php
echo $row['category_id'];
?>
</a></td>
<?php
$indent = $level * 30 + 4;
?>
<td style="padding-left: <?php
echo $indent;
?>
px;">
<a href="<?php
echo HTML::addRef($session->addSID("category_info.php?cid=" . $row['category_id']));
?>
"><?php
echo htmlspecialchars($row['category_name']);
?>
</a><div class="a_table_list_details"><?php
echo nl2br(htmlspecialchars($row['category_description']));
?>
</div></td>
<td><?php
echo $created;
?>
</td>
<td>
<?php
if ($row['category_creator'] > 0) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("user_info.php?uid=" . $row['category_creator']));
?>
"><?php
echo htmlspecialchars($row['user_login']);
?>
</a><div class="a_table_list_details"><?php
echo htmlspecialchars($row['user_name']);
?>
</div>
<?php
} else {
?>
-
<?php
}
?>
</td>
<td><?php
echo $row['photos'];
?>
</td>
<td class="a_icon">
<?php
if ($i > 0) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("cat_up.php?cid=" . $row['category_id'] . "&pcid=" . $cat));
?>
" title="Przenie¶ wy¿ej"><?php
HTML::img("up.gif", "Przenie¶ wy¿ej");
?>
</a>
<?php
}
?>
</td>
<td class="a_icon">
<?php
if ($i < $res->numRows() - 1) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("cat_down.php?cid=" . $row['category_id'] . "&pcid=" . $cat));
?>
" title="Przenie¶ ni¿ej"><?php
HTML::img("down.gif", "Przenie¶ ni¿ej");
?>
</a>
<?php
}
?>
</td>
<td class="a_icon">
<a href="<?php
echo HTML::addRef($session->addSID("edit_category.php?action=edit&cid=" . $row['category_id']));
?>
" title="<?php
echo _ADMIN_EDIT_CATEGORY;
?>
"><?php
HTML::img("edit.gif", _ADMIN_EDIT_CATEGORY);
?>
</a>
</td>
<td class="a_icon">
<a href="<?php
echo HTML::addRef($session->addSID("remove_category.php?cid=" . $row['category_id']));
?>
" title="<?php
echo _ADMIN_REMOVE_CATEGORY;
?>
" onclick='return confirm("<?php
echo sprintf(_ADMIN_CONFIRM_DELETE_CATEGORY, $row['category_name']);
?>
");'><?php
HTML::img("trash.gif", _ADMIN_REMOVE_CATEGORY);
?>
</a>
</td>
<td class="a_icon">
<a href="<?php
echo HTML::addRef($session->addSID("photos.php?cid=" . $row['category_id']));
?>
" title="<?php
echo _ADMIN_PHOTOS;
?>
"><?php
HTML::img("photo.gif", _ADMIN_PHOTOS);
?>
</a>
</td>
</tr>
<?php
$this->renderCategory($level + 1, $row['category_id']);
$i++;
}
}
function renderContent() {
$comments = $this->_photo->getComments();
$session = Session::singletone();
if (!empty($comments)) {
foreach ($comments as $cmnt) {
?>
<div class="a_comment">
<div class="a_comment_hdr"><?=htmlspecialchars($cmnt->_dbo->comment_title)?></div>
<div class="a_comment_text">
<div class="a_table_list_details"><?=htmlspecialchars($cmnt->_user->user_login)?>, <?=Utils::formatTime($cmnt->_dbo->comment_date)?></div>
<?=nl2br(htmlspecialchars($cmnt->_dbo->comment_text))?>
</div>
<div class="a_comment_actions">
<?php if ($cmnt->_dbo->user_id == $session->_uid || Permissions::checkPermAndLevel('edit_comments', $cmnt->_dbo->user_id)) { ?>
<a href="<?php echo HTML::addRef($session->addSID("edit_comment.php?cmid=" . $cmnt->_cmid));?>" title="Edytuj komentarz"><?php HTML::img("edit.gif", "Edytuj komentarz"); ?></a>
<? } ?>
<?php if ($cmnt->_dbo->user_id == $session->_uid || Permissions::checkPermAndLevel('delete_comments', $cmnt->_dbo->user_id)) { ?>
<a href="<?php echo HTML::addRef($session->addSID("remove_comment.php?cmid=" . $cmnt->_cmid));?>" onclick='return confirm("Czy na pewno usun±æ komentarz?");' title="Usuñ komentarz"><?php HTML::img("trash.gif", "Usuñ komentarz"); ?></a>
<?php } ?>
</div>
</div>
<?php
}
} else {
?>
<div class="a_comment">Brak komentarzy.</div>
<?php
}
}
function renderContent()
{
global $session;
global $db;
$q = $db->prepare("SELECT " . "group_id, " . "group_name, " . "group_created, " . "group_creator, " . "group_level, " . "user_login, " . "user_name, " . "(SELECT COUNT(*) FROM phph_group_users WHERE phph_group_users.group_id = phph_groups.group_id) AS users " . "FROM phph_groups " . "LEFT OUTER JOIN phph_users ON phph_groups.group_creator = phph_users.user_id " . "LIMIT " . $this->_start . ", " . $this->_count);
$res = $db->execute($q);
if (PEAR::isError($res)) {
die($res->getMessage());
}
while ($res->fetchInto($row)) {
$created = strftime("%Y-%m-%d %T", $row['group_created']);
?>
<tr>
<td><a href="<?php
echo HTML::addRef($session->addSID("group_info.php?gid=" . $row['group_id']));
?>
"><?php
echo $row['group_id'];
?>
</a></td>
<td><a href="<?php
echo HTML::addRef($session->addSID("group_info.php?gid=" . $row['group_id']));
?>
"><?php
echo htmlspecialchars($row['group_name']);
?>
</a></td>
<td><?php
echo $created;
?>
</td>
<td>
<?php
if ($row['group_creator'] > 0) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("user_info.php?uid=" . $row['group_creator']));
?>
"><?php
echo htmlspecialchars($row['user_login']);
?>
</a><div class="a_table_list_details"><?php
echo htmlspecialchars($row['user_name']);
?>
</div>
<?php
} else {
?>
-
<?php
}
?>
</td>
<td><?php
echo $row['users'];
?>
</td>
<td>
<?php
if (Permissions::checkPermAndLevelVal('edit_groups', $row['group_level'])) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("edit_group.php?action=edit&gid=" . $row['group_id']));
?>
" title="<?php
echo _ADMIN_EDIT_GROUP;
?>
"><?php
HTML::img("edit.gif", _ADMIN_EDIT_GROUP);
?>
</a>
<?php
}
?>
<?php
if (Permissions::checkPermAndLevelVal('change_groups_permissions', $row['group_level'])) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("perms.php?gid=" . $row['group_id']));
?>
" title="<?php
echo _ADMIN_PERMISSIONS;
?>
"><?php
HTML::img("flag.gif", _ADMIN_PERMISSIONS);
?>
</a>
<?php
}
?>
<?php
if (Permissions::checkPermAndLevelVal('delete_groups', $row['group_level'])) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("remove_group.php?gid=" . $row['group_id']));
?>
" title="<?php
echo _ADMIN_REMOVE_GROUP;
?>
" onclick='return confirm("<?php
echo sprintf(_ADMIN_CONFIRM_DELETE_GROUP, $row['group_name']);
?>
");'><?php
HTML::img("trash.gif", _ADMIN_REMOVE_GROUP);
?>
</a>
<?php
}
?>
<a href="<?php
echo HTML::addRef($session->addSID("group_users.php?gid=" . $row['group_id']));
?>
" title="<?php
echo _ADMIN_GROUP_MEMBERS;
?>
"><?php
HTML::img("users.gif", _ADMIN_GROUP_MEMBERS);
?>
</a>
</td>
</tr>
<?php
}
}
function renderContent()
{
global $session, $db, $gid;
$q = $db->prepare("SELECT " . "u.user_id AS memb_id, " . "u.user_login AS memb_login, " . "u.user_name AS memb_name, " . "gu.add_time, " . "ua.user_id AS add_id, " . "ua.user_login AS add_login, " . "ua.user_name AS add_name, " . "u.user_email AS memb_email, " . "u.user_www AS memb_www " . "FROM phph_group_users gu " . "INNER JOIN phph_users u ON gu.user_id = u.user_id " . "LEFT OUTER JOIN phph_users ua ON gu.added_by = ua.user_id " . "LIMIT " . $this->_start . ", " . $this->_count);
$res = $db->execute($q);
if (PEAR::isError($res)) {
die($res->getMessage());
}
while ($res->fetchInto($row)) {
$added = strftime("%Y-%m-%d %T", $row['add_time']);
?>
<tr>
<td><a href="<?php
echo HTML::addRef($session->addSID("user_info.php?uid=" . $row['memb_id']));
?>
"><?php
echo $row['memb_id'];
?>
</a></td>
<td>
<a href="<?php
echo HTML::addRef($session->addSID("user_info.php?uid=" . $row['memb_id']));
?>
"><?php
echo htmlspecialchars($row['memb_login']);
?>
</a>
<div class="a_table_list_details"><?php
echo htmlspecialchars($row['memb_login']);
?>
</div>
</td>
<td><?php
echo $added;
?>
</td>
<td>
<a href="<?php
echo HTML::addRef($session->addSID("user_info.php?uid=" . $row['add_id']));
?>
"><?php
echo htmlspecialchars($row['add_login']);
?>
</a>
<div class="a_table_list_details"><?php
echo htmlspecialchars($row['add_name']);
?>
</div>
</td>
<td>
<?php
if ($row['memb_id'] == $session->_uid || Permissions::checkPermAndLevel('remove_group_members', $row['memb_id'])) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("remove_member.php?uid=" . $row['memb_id'] . "&gid=" . $gid));
?>
" onclick='return confirm("<?php
echo _ADMIN_CONFIRM_REMOVE_MEMBER;
?>
");' title="<?php
echo _ADMIN_REMOVE_MEMBER;
?>
"><?php
HTML::img("remove.gif", _ADMIN_REMOVE_MEMBER);
?>
</a>
<?php
}
?>
<?php
if ($row['memb_id'] == $session->_uid || Permissions::checkPermAndLevel('edit_users', $row['memb_id'])) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("edit_user.php?uid=" . $row['memb_id']));
?>
" title="<?php
echo _ADMIN_EDIT_USER;
?>
"><?php
HTML::img("edit.gif", _ADMIN_EDIT_USER);
?>
</a>
<?php
}
?>
<?php
if ($row['memb_id'] == $session->_uid || Permissions::checkPermAndLevel('delete_users', $row['memb_id'])) {
?>
<a href="<?php
echo HTML::addRef($session->addSID("remove_user.php?uid=" . $row['memb_id']));
?>
" onclick='return confirm("<?php
echo sprintf(_ADMIN_CONFIRM_DELETE_USER, $row['memb_login']);
?>
");' title="<?php
echo _ADMIN_REMOVE_USER;
?>
"><?php
HTML::img("trash.gif", _ADMIN_REMOVE_USER);
?>
</a>
<?php
}
?>
<a href="mailto:<?php
echo htmlspecialchars($row['memb_email']);
?>
" title="<?php
echo _ADMIN_USER_EMAIL_T;
?>
"><?php
HTML::img("email.gif", _ADMIN_USER_EMAIL_T);
?>
</a>
<?php
if (!empty($row['memb_www'])) {
?>
<a href="<?php
echo htmlspecialchars($row['memb_www']);
?>
" target="_blank" title="<?php
echo _ADMIN_USER_HOME_PAGE_T;
?>
"><?php
HTML::img("www.gif", _ADMIN_USER_HOME_PAGE_T);
?>
</a>
<?php
}
?>
</td>
</tr>
<?php
}
}
