show_table_header($header);
$table = new CTableInfo(S_NO_SCREENS_DEFINED);
$table->SetHeader(array(make_sorting_link(S_NAME, 's.name'), make_sorting_link(S_DIMENSION_COLS_ROWS, 'size'), S_SCREEN));
$result = DBselect('SELECT s.screenid,s.name,s.hsize,s.vsize,(s.hsize*s.vsize) as s_size ' . ' FROM screens s ' . ' WHERE ' . DBin_node('s.screenid') . order_by('s.name,s_size', 's.screenid'));
while ($row = DBfetch($result)) {
if (!screen_accessible($row["screenid"], PERM_READ_WRITE)) {
continue;
}
$table->AddRow(array(new CLink($row["name"], "?config=0&form=update&screenid=" . $row["screenid"], 'action'), $row["hsize"] . " x " . $row["vsize"], new CLink(S_EDIT, "screenedit.php?screenid=" . $row["screenid"])));
$row_count++;
}
$table->Show();
}
} else {
if (isset($_REQUEST["form"])) {
insert_slideshow_form();
} else {
$row_count = 0;
$numrows = new CSpan(null, 'info');
$numrows->addOption('name', 'numrows');
$header = get_table_header(array(S_SLIDESHOWS_BIG, new CSpan(SPACE . SPACE . '|' . SPACE . SPACE, 'divider'), S_FOUND . ': ', $numrows));
show_table_header($header);
$table = new CTableInfo(S_NO_SLIDESHOWS_DEFINED);
$table->SetHeader(array(make_sorting_link(S_NAME, 's.name'), make_sorting_link(S_DELAY, 's.delay'), make_sorting_link(S_COUNT_OF_SLIDES, 'cnt')));
$db_slides = DBselect('SELECT s.slideshowid, s.name, s.delay, count(*) as cnt ' . ' FROM slideshows s ' . ' left join slides sl on sl.slideshowid=s.slideshowid ' . ' WHERE ' . DBin_node('s.slideshowid') . ' GROUP BY s.slideshowid,s.name,s.delay ' . order_by('s.name,s.delay,cnt', 's.slideshowid'));
while ($slide_data = DBfetch($db_slides)) {
if (!slideshow_accessible($slide_data['slideshowid'], PERM_READ_WRITE)) {
continue;
}
$table->AddRow(array(new CLink($slide_data['name'], '?config=1&form=update&slideshowid=' . $slide_data['slideshowid'], 'action'), $slide_data['delay'], $slide_data['cnt']));
$row_count++;
}
}
}
}
}
if ($_REQUEST['go'] != 'none' && isset($go_result) && $go_result) {
$url = new CUrl();
$path = $url->getPath();
insert_js('cookie.eraseArray("' . $path . '")');
}
$form = new CForm(null, 'get');
$form->addItem(new CButton("form", S_CREATE_SLIDESHOW));
$slide_wdgt = new CWidget();
$slide_wdgt->addPageHeader(S_CONFIGURATION_OF_SLIDESHOWS_BIG, $form);
if (isset($_REQUEST['form'])) {
$slide_wdgt->addItem(insert_slideshow_form());
} else {
$form = new CForm();
$form->setName('shows');
$numrows = new CDiv();
$numrows->setAttribute('name', 'numrows');
$slide_wdgt->addHeader(S_SLIDESHOWS_BIG);
$slide_wdgt->addHeader($numrows);
$table = new CTableInfo(S_NO_SLIDESHOWS_DEFINED);
$table->setHeader(array(new CCheckBox('all_shows', NULL, "checkAll('" . $form->getName() . "','all_shows','shows');"), make_sorting_header(S_NAME, 's.name'), make_sorting_header(S_DELAY, 's.delay'), make_sorting_header(S_COUNT_OF_SLIDES, 'cnt')));
$sql = 'SELECT s.slideshowid, s.name, s.delay, count(sl.slideshowid) as cnt ' . ' FROM slideshows s ' . ' LEFT JOIN slides sl ON sl.slideshowid=s.slideshowid ' . ' WHERE ' . DBin_node('s.slideshowid') . ' GROUP BY s.slideshowid,s.name,s.delay ' . order_by('s.name,s.delay,cnt', 's.slideshowid');
$db_slides = DBselect($sql);
// gathering all data we got from database in array, so we can feed it to pagination function
$slides_arr = array();
while ($slide_data = DBfetch($db_slides)) {
$slides_arr[] = $slide_data;
