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;