function AdminMenu()
{
global $page_id;
return FramedTable1() . '<table><TR>
<TD CLASS="menu"> <a href="' . PICMAN_INDEX . '" CLASS="menu">Index</a> </TD>
<TH CLASS="menu"> Category: </TH><TD CLASS="menu"> ' . sprintf('<a href="' . PICMAN_ADMIN_CAT . 'i%03dp%03d.html"', 0, $page_id) . ' CLASS="menu">New</a>' . ' :: ' . '<a href="" CLASS="menu">Modify</a> :: <a href="" CLASS="menu">Delete</a> </TD>
<TH CLASS="menu"> Collection: </TH><TD CLASS="menu"> <a href="' . PICMAN_ADMIN_COLLECTION . '" CLASS="menu">New</a> :: <a href="" CLASS="menu">Modify</a> :: <a href="" CLASS="menu">Delete</a> </TD>
<TH CLASS="menu"> Link: </TH><TD CLASS="menu"> <a href="' . PICMAN_ADMIN_LINK . '" CLASS="menu">New</a> :: <a href="" CLASS="menu">Delete</a> </TD>
</TR></table>' . FramedTable2();
}
function DisplayCategoryForm()
{
global $page_id, $page_pg, $frm;
// Wartości domyślne
if (!isset($frm)) {
$frm = array('catcol' => 1, 'catrow' => 8, 'grcol' => 4, 'grrow' => 4, 'datecr' => date('Y-m-d'));
}
if ($page_id) {
GetCategoryData($page_id);
}
$cat_id = $page_id;
// Jeżeli chcemy dodać nową kategorię to miejsce gdzie jesteśmy wskazuje page_pg
if (!$cat_id && $page_pg) {
$cat_id = $page_pg;
}
$hier_cat = GetCategoriesHierarchy($frm[parent], $cat_id, 0);
echo FramedTable1() . '<FORM METHOD="POST">' . '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1>' . '<TR><TH> Category </TH><TD> ' . FormCheckbox('cathid') . 'Hidden </TD></TR>' . '<TR><TD></TD><TD ALIGN=right> ' . FormSelect('action', array('mod' => 'Modify', 'del' => 'Delete', 'sort' => 'Sort')) . ' <INPUT TYPE=submit VALUE=" Send "> ' . '</TD></TR>' . '<TR><TD> Parent: </TD><TD> ' . '<SELECT NAME="frm[parent]">' . $hier_cat . '</SELECT>' . FormSelect('inspos', array(1 => 'First', 2 => 'Last', 3 => 'Sort')) . '</TD></TR>' . '<TR><TD> Uniqid & Date: </TD><TD> ' . FormInput('uniqid') . ' ' . FormInput('datecr', 12) . ' </TD></TR>' . '<TR><TD> Name: </TD><TD> ' . FormInput('name') . ' </TD></TR>' . '<TR><TD> Title: </TD><TD> ' . FormInput('title') . ' </TD></TR>' . '<TR><TD> Header: </TD><TD> ' . FormInput('header') . ' </TD></TR>' . '<TR><TD> Description: </TD><TD> ' . FormText('desc', 80, 5) . '<BR>' . FormCheckbox('addbr') . ' Auto add "break line" </TD></TR>' . '<TR><TD COLSPAN=2><HR></TD></TR>' . '<TR><TD> Subcats: </TD><TD> ' . FormSelect('catcol', range(1, 10), 0) . ' x ' . FormSelect('catrow', range(1, 20), 0) . ' (columns x rows) ' . '</TD></TR>' . '<TR><TD> Collections: </TD><TD> ' . FormSelect('grcol', range(1, 10), 0) . ' x ' . FormSelect('grrow', range(1, 20), 0) . ' (columns x rows) ' . '</TD></TR>' . '<TR><TD> Category directory: </TD><TD> ' . FormInput('dircat') . ' </TD></TR>' . '<TR><TD> Template directory: </TD><TD> ' . FormInput('dirtem', 40, PICMAN_DEFAULT_TEMP) . ' </TD></TR>' . '</TABLE>' . '</FORM>' . FramedTable2();
}
}
if (count($cond) > 3) {
$qid = db_query("\n\t\tSELECT DISTINCT\n\t\t\tC.id AS cid, C.name AS catname, C.catdir AS catdir, P.name AS parent,\n\t\t\tG.id AS id, G.name AS name, G.coldir AS coldir, G.icoindex AS icoindex,\n\t\t\tG.thumbsubdir AS thumbsubdir, G.thumbtemp AS thumbtemp,\n\t\t\tG.quantity AS quantity, G.date_create AS date_create\n\t\tFROM {collections} G, {categories} C, {categories} P\n\t\tWHERE " . join(" AND ", $cond) . "\n\t\tORDER BY G.date_create DESC\n\t\t");
echo '<table border="0">';
if (db_num_rows($qid) > 200) {
echo '<tr><td>More then 200 results!</td></tr>';
} else {
$o = array();
while ($out = db_fetch_array($qid)) {
$o[] = $out;
printf("\n<!-- %d:%d: %s -->\n", $out['cid'], $out['id'], $out['catname']);
}
foreach ($o as $out) {
$icon = GetDirForCat($out['cid']) . $out['coldir'] . '/';
$icoarr = split(':', $out['icoindex']);
if ($icoarr[0] == 'T') {
$icon .= sprintf($out['thumbsubdir'] . '/' . $out['thumbtemp'], $icoarr[1]);
} else {
$icon .= $out['icoindex'];
}
echo '<tr valign="top">' . '<td>' . '<a href="' . sprintf(PICMAN_COLLECTION . "i%03d.html", $out['id']) . '">' . '<img src="' . PICMAN_IMAGE . $icon . '" border="1" />' . '</a>' . '</td>' . '<td>' . '<b>' . $out['parent'] . ' / ' . $out['catname'] . '</b><br />' . 'Name: ' . $out['name'] . '<br />' . 'Pictures: ' . $out['quantity'] . '<br />' . 'Date: ' . date('Y-m-d', strtotime($out['date_create'])) . '<br />' . '</td>' . '</tr>';
}
}
echo '</table>';
}
}
echo FramedTable2();
?>
</DIV>
</BODY></HTML>
border: solid 1px black;
width: 700px;
}
//--></STYLE>
</HEAD>
<BODY BGCOLOR="silver">
<DIV ALIGN=center>
<?php
echo AdminMenu();
// Wartości domyślne
if (!isset($frm)) {
$frm = array('catcol' => 1, 'catrow' => 8, 'grcol' => 4, 'grrow' => 4);
}
//if ($page_id) GetLinkData($page_id);
if ($page_id) {
$result = db_query("SELECT G.id AS id, G.name AS name, C.id AS cid FROM {collections} G, {categories} C WHERE G.id = {$page_id} AND G.uid_cat = C.uniqid");
if (db_num_rows($result)) {
$item = db_fetch_array($result);
$frm[idgr] = $item['id'];
$frm[name] = $item['name'];
$frm[parent] = $item['cid'];
}
}
$hier_cat = GetCategoriesHierarchy($frm[parent], 0, 2);
echo '<BR><BR>' . FramedTable1() . '<FORM METHOD="POST">' . '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1>' . '<TR><TH> New Link </TH><TD> </TD></TR>' . '<TR><TD></TD><TD ALIGN=right> ' . ' <INPUT TYPE=submit VALUE=" Send "> ' . '</TD></TR>' . '<TR><TD> Collection name: </TD><TD> ' . $frm[name] . FormHidden('idgr') . ' </TD></TR>' . '<TR><TD> Category: </TD><TD> ' . '<SELECT NAME="frm[parent]">' . $hier_cat . '</SELECT>' . ' Position ' . FormInput('position', 4, 1) . ' </TD></TR>' . '</TABLE>' . '</FORM>' . FramedTable2();
?>
</DIV>
</BODY></HTML>
}
if ($page_pg > $item['quantity']) {
$page_pg = $item['quantity'];
}
$picperpage = $item['rows'] * $item['cols'];
$page_num = (int) ($page_pg / $picperpage);
if ($page_pg % $picperpage) {
$page_num++;
}
$mov_holes = 0;
// Dodanie numerów których nie ma
if (count($picholes)) {
$iter = 1;
$nr = $page_pg;
while ($iter <= $nr) {
if (in_array($iter + $item['startnum'] - 1, $picholes)) {
$mov_holes++;
$nr++;
}
$iter++;
}
}
$icon_num = $page_pg + $mov_holes + $item['startnum'] - 1;
$icon_name = sprintf($item['thumbtemp'], $icon_num);
$icon_add = $icondir . $icon_name;
echo FramedTable1() . '<TABLE BORDER=0><TR VALIGN=top>' . '<TD><IMG SRC="' . $icon_add . '"></TD>' . '<TD> Set Default icon (thumbnail) for group<BR>' . '<LI>Icon order: ' . $page_pg . '<LI>Icon number: ' . $icon_num . '<LI>Icon name: ' . $icon_name . '</TD>' . '</TR></TABLE>' . FramedTable2();
$result = db_query("UPDATE {collections} SET icoindex = 'T:%s' WHERE id = %s", $icon_num, $page_id);
?>
</DIV>
</BODY></HTML>
function DisplayThumbForm($group_id)
{
$item = db_fetch_array(db_query("SELECT * FROM {collections} WHERE id = {$group_id}"));
$imgdir = GetDirForCollection($group_id);
$icondir = preg_replace('/[\\/]+/', '/', PICMAN_IMAGE . "{$imgdir}/" . $item['thumbsubdir'] . "/");
$content = '';
$picholes = array();
if (!empty($item['holes'])) {
foreach (split(',', $item['holes']) as $range) {
list($range_from, $range_to) = split('-', $range);
if (isset($range_to) && $range_to) {
for ($i = $range_from; $i <= $range_to; $i++) {
$picholes[] = $i;
}
} else {
$picholes[] = $range_from;
}
}
}
$ico = split(':', $item['icoindex']);
$img_add = $item['startnum'] - 1;
$mov_holes = 0;
for ($inum = 1; $inum <= $item['quantity']; $inum++) {
if (count($picholes)) {
while (in_array($inum + $img_add, $picholes)) {
$img_add++;
}
}
$content .= sprintf('<img id="img-%d" src="%s" class="%s" onClick="selImg(\'%d\')" />', $inum, $icondir . sprintf($item['thumbtemp'], $inum + $img_add), $ico[0] == 'T' && $ico[1] == $inum ? 'thumb-sel' : 'thumb-img', $inum);
}
echo FramedTable1() . '<div class="thumbnails">' . $content . '</div>' . FramedTable2();
}
