echo "{$rn}"; ?> > <?php echo _ALL; ?> </H3> <table width="460" border="0" cellspacing="0" cellpadding="3"> <?php //numbers of table colums $cs = "4"; $cs1 = "3"; // subsections announces_subsections($sess, $rub, $pri, $cs, $cs1); // vypis hlasiek if ($result != "" || $error != "") { ?> <tr><td> <div class="res"><?php echo "{$result}"; ?> </div> <div class="error"><?php echo "{$error}"; ?> </div> </td></tr> <?php
function announces_selected($sess, $rub, $pri, $keyword, $age, $page) { global $welcome_call, $view; if (!isset($age)) { $age = "2000"; } $pag = $page + 1; // select extract - sections, subsections if ($pri != "") { $rubsel = "ann_sub = '{$pri}'"; $sql = mysql_query("SELECT * FROM uniletim_subsections WHERE sub_id = '{$pri}' AND ul_group = '{$sess['4']}'"); $sub_row = mysql_fetch_row($sql); $prn = $sub_row[1]; $rub = $sub_row[2]; $sql = mysql_query("SELECT * FROM uniletim_sections WHERE sec_id = '{$rub}' AND ul_group = '{$sess['4']}'"); $sec_row = mysql_fetch_row($sql); $rn = $sec_row[1]; $is_H3 = "<a href=index.php?rub={$sec_row['0']}>{$sec_row['1']}</a> > <a href=index.php?rub={$sec_row['0']}&pri={$sub_row['0']}>{$sub_row['1']}</a> > {$pag}"; } elseif ($rub != "") { $rubsel = "ann_sec = '{$rub}'"; $sql = mysql_query("SELECT * FROM uniletim_sections WHERE sec_id = '{$rub}' AND ul_group = '{$sess['4']}'"); $sec_row = mysql_fetch_row($sql); $rn = $sec_row[1]; $is_H3 = "<a href=index.php?rub={$sec_row['0']}>{$sec_row['1']}</a> > {$pag}"; } else { if ($keyword != "") { $sa = _SELECTED_ANNO; $is_H3 = "{$sa} > {$pag}"; } else { @($sql_user = mysql_query("SELECT * FROM uniletim_members WHERE mbr_id = '{$sess['2']}'")); $row_user = mysql_fetch_row($sql_user); $wel = "<b>{$row_user['1']}</b>{$welcome_call}<br>"; } $rubsel = "ann_text like '%'"; } $agesec = Time() - $age * 24 * 3600; $agesel = "ann_date >= '{$agesec}'"; $keysel = "ann_text like '%{$keyword}%'"; $select = "{$agesel} AND {$keysel} AND {$rubsel}"; //numbers of table colums $cs = "4"; $cs1 = "3"; $menu = "ann"; page_location_announces($sess, $menu, $rub, $pri, $uoz, $eid, $loc_page); page_result_error($result, $error); // welcome call if ($wel == "d") { ?> <div class="content-noborder"> <?php echo $wel; ?> </div><?php } if ($age != "2000" || $keyword != "") { ?> <div class="search"> <?php if ($keyword != "") { echo _KEYWORD_R; ?> : <?php echo $keyword; ?> <?php } ?> <?php if ($age != "" & $age != "2000") { echo _AGE_R; ?> : <?php echo $age; } ?> </div><?php } if ($rub != "" || $pri != "") { // subsections announces_subsections($sess, $rub, $pri, $cs, $cs1); // news } else { announces_sections($sess, $rub); } if ($sess[3] == "d" & $rub == "") { ?> <div class="content-border"> <table cellspacing="0" class="content" cellspacing="0"><?php $lres = _NEWS; $dopon = "news"; $view_number = 10; // number of listed items announces_listing($sess, $dopon, $select, $lres, $view_number, $page, $cs, $cs1, $uoz, $rub, $pri, $keyword, $age); ?> </table> </div><?php } ?> <div class="content-border"> <table cellspacing="0" class="content" cellspacing="0"><?php $view_number = 10; // number of listed items if ($tbp != "dop") { // offers $lres = _OFFER; $dopon = "ponuka"; if ($view == "admin") { $view_number = 30; announces_listing_admin($sess, $dopon, $select, $lres, $view_number, $page, $cs, $cs1, $uoz, $rub, $pri, $keyword, $age); } else { announces_listing($sess, $dopon, $select, $lres, $view_number, $page, $cs, $cs1, $uoz, $rub, $pri, $keyword, $age); } } ?> </table> </div> <div class="content-border"> <table cellspacing="0" class="content" cellspacing="0"><?php if ($tbp != "pon") { // queries $lres = _QUERY; $dopon = "dopyt"; if ($view == "admin") { $view_number = 30; announces_listing_admin($sess, $dopon, $select, $lres, $view_number, $page, $cs, $cs1, $uoz, $rub, $pri, $keyword, $age); } else { announces_listing($sess, $dopon, $select, $lres, $view_number, $page, $cs, $cs1, $uoz, $rub, $pri, $keyword, $age); } } ?> </table> </div> <div class="content-border"> <table cellspacing="0" class="content" cellspacing="0"> <thead> <tr class="th_main"> <form method="post" action="index.php"> <th colspan="<?php echo $cs1; ?> "> <input type="text" name="keyword" size="10" maxlength="40"> <select name="rub"> <OPTION value=""<?php if ($row[0] == $rub) { echo " selected"; } ?> ><?php echo _ALL; ?> </OPTION><?php $sql = mysql_query("SELECT * FROM uniletim_sections where ul_group = '{$sess['4']}'"); if (mysql_num_rows($sql)) { while ($row = mysql_fetch_row($sql)) { ?> <OPTION value="<?php echo "{$row['0']}"; ?> "<?php if ($row[0] == $rub) { echo " selected"; } ?> ><?php echo "{$row['1']}"; ?> </OPTION><?php } } ?> </select> <select name="age"> <OPTION value="2000"><?php echo _NO_LIMIT; ?> </OPTION> <OPTION value="1"<?php if ($age == "1") { echo " selected"; } ?> ><?php echo _1DAY; ?> </OPTION> <OPTION value="3"<?php if ($age == "3") { echo " selected"; } ?> ><?php echo _3DAYS; ?> </OPTION> <OPTION value="7"<?php if ($age == "7") { echo " selected"; } ?> ><?php echo _WEEK; ?> </OPTION> <OPTION value="14"<?php if ($age == "14") { echo " selected"; } ?> ><?php echo _2WEEKS; ?> </OPTION> <OPTION value="31"<?php if ($age == "31") { echo " selected"; } ?> ><?php echo _MONTH; ?> </OPTION> <OPTION value="92"<?php if ($age == "92") { echo " selected"; } ?> ><?php echo _3MONTHS; ?> </OPTION> </SELECT> <input type="submit" value="<?php echo _SEARCH; ?> "> </th> </form> <th align="right"> <b><a target="_blank" href="index.php?action=print&rub=<?php echo "{$rub}"; ?> &pri=<?php echo "{$pri}"; ?> &keyword=<?php echo "{$keyword}"; ?> &age=<?php echo "{$age}"; ?> "><?php echo _PRINT; ?> </a></b> </th> </tr> </thead> </table> </div> <?php }