</tr>
</thead>
<tbody>
<?php
$lezaz_users_sql_x = '';
if (!$_REQUEST[page_users_sql]) {
$page_number = '0';
} else {
$page_number = ($_REQUEST[page_users_sql] - 1) * 5;
}
$limit = '';
$limit = " LIMIT {$page_number} , 5 ";
$users_sql = $lezaz->db->query("Select * From members {$limit}");
$lezaz_users_sql_num = $lezaz->db->num_row("Select * From members");
$lezaz_users_sql_multipage = page_counter($_REQUEST[page_users_sql], $lezaz_users_sql_num, 5, $lezaz->address(), 'users_sql', array(0 => ''));
$lezaz_users_sql_counter = 0 + $page_number;
if (is_array($users_sql)) {
foreach ($users_sql as $lezaz_users_sql) {
if (is_array($lezaz_users_sql)) {
$lezaz_users_sql_x = $lezaz_users_sql_x == '' ? '' : '';
?>
<tr id="tr<?php
echo $lezaz_users_sql[id];
?>
">
<td class="center"><label><input type="checkbox" /><span class="lbl"></span></label></td>
<td><?php
echo $lezaz_users_sql[id];
<a HREF="platby.php?action=write"><?php
echo _PAYING_ORDER;
?>
</A>
</th>
<th colspan="2" align="right">
<?php
//odkazy na dalsie stranky vypisu
if ($adesc == "ASC") {
$adesc = "DESC";
} else {
$adesc = "ASC";
}
$id = "ser_id";
$table = "uniletim_services";
$link = "platby.php?action=view&what={$what}&order={$order}&adesc={$adesc}&page=";
page_counter($id, $table, $sort, $view_number, $sess, $link, $i, $page);
?>
|
</th>
</tr>
<tr class="th_main">
<th colspan="5"><a target="_blank" href="platby.php?action=print"><?php
echo _PRINT;
?>
</a></th>
</tr>
</tfoot>
</table>
</div>
function announces_listing_admin($sess, $dopon, $select, $lres, $view_number, $page, $cs, $cs1, $uoz, $rub, $pri, $keyword, $age)
{
$cs = "4";
$cs1 = "3";
// dark row - name
?>
<col class="col_1">
<col class="col_2">
<col class="col_3">
<col class="col_4">
<col class="col_5">
<thead>
<tr class="th_main">
<th><?php
echo $lres;
?>
</td>
<th colspan="<?php
echo $cs1;
?>
"> </td>
</tr>
</thead>
<?php
$start = $page * $view_number;
//first announce for view
$sort = "ann_oq = '{$dopon}' and {$select}";
// mysql query
// query for announces
@($sqo = mysql_query("SELECT * FROM uniletim_announces WHERE {$sort} AND ul_group = '{$sess['4']}' ORDER BY ann_date DESC LIMIT {$start},{$view_number}")) or die($query_error);
if (mysql_num_rows($sqo) == 0) {
echo "<tr><td>" . _NO_ANNOUNCE . "</td></tr>\n";
} else {
$i = 0;
while ($roz = mysql_fetch_row($sqo)) {
@($sqp = mysql_query("SELECT * FROM uniletim_subsections WHERE sub_id = '{$roz['3']}' AND ul_group = '{$sess['4']}'"));
$rop = mysql_fetch_row($sqp);
if ($i % 2 == 0) {
$tb_class = '';
} else {
$tb_class = " class=tb_dark";
}
// announce text
?>
<tbody <?php
echo $tb_class;
?>
>
<tr class="tb_content" <?php
echo $bgcolor;
?>
>
<td colspan="<?php
echo $cs1;
?>
">
<?php
echo $roz[7];
?>
</td>
<td align="right" <?php
echo $bgcolor;
?>
>
<B><?php
echo _FROM;
?>
:</B><br />
<?php
member_link($roz[1]);
?>
</td>
</tr>
<tr class="tb_info">
<form method="post" action="index.php">
<td align="right" <?php
echo $bgcolor;
?>
>
<select name="ann_sub" class="paticka">
<OPTION value="0"><?php
echo _SELECT_SUB;
?>
</OPTION><?php
$pse = mysql_query("SELECT * FROM uniletim_subsections WHERE ul_group = '{$sess['4']}' ORDER BY sub_section");
while ($row = mysql_fetch_row($pse)) {
$psr = mysql_query("SELECT * FROM uniletim_sections WHERE sec_id = '{$row['2']}' AND ul_group = '{$sess['4']}'");
$ror = mysql_fetch_row($psr);
?>
<OPTION value="<?php
echo "{$row['0']}";
?>
"<?php
if ($row[0] == $roz[3]) {
echo " selected";
}
?>
><?php
echo "{$ror['1']} - {$row['1']}";
?>
</OPTION><?php
}
?>
</select>
</td>
<td align="right" <?php
echo $bgcolor;
?>
>
<input type="hidden" name="rub" value="<?php
echo $rub;
?>
">
<input type="hidden" name="pri" value="<?php
echo $pri;
?>
">
<input type="hidden" name="view" value="admin">
<input type="hidden" name="sedid" value="<?php
echo $roz[0];
?>
">
<input type="submit" class="paticka" value="<?php
echo _CHANGE . " " . _SUBSECTION;
?>
">
</td>
</form>
<form method="post" action="index.php?action=form&type=edit">
<td align="right" <?php
echo $bgcolor;
?>
>
<input type="hidden" name="eid" value="<?php
echo $roz[0];
?>
">
<input type="submit" class="paticka" value="<?php
echo _CHANGE;
?>
">
</b></td>
</form>
<form method="post" action="index.php?rub=<?php
echo "{$rub}";
?>
&pri=<?php
echo "{$pri}";
?>
&view=admin">
<td align="right" <?php
echo $bgcolor;
?>
>
<input type="hidden" name="did" value="<?php
echo $roz[0];
?>
">
<input type="submit" class="paticka" value="<?php
echo _DELETE;
?>
" onclick="return confirm('<?php
echo _RLY_DLT_ANNO;
?>
')">
</b></td>
</form>
</tr>
<?php
if ($i == 10) {
break;
}
$i++;
}
}
?>
<tfoot>
<tr class="th_sub">
<th><?php
if ($sess[5] >= "2" & $usoz != "") {
?>
<a HREF="index.php?action=form&type=new&dp=<?php
echo "{$dopon}";
?>
&rub=<?php
echo "{$rub}";
?>
&pri=<?php
echo "{$pri}";
?>
&a_id=<?php
echo "{$uoz}";
?>
"><?php
echo _INSERT;
?>
</A><?php
} elseif ($sess[5] >= "2" & $dopon == "news") {
?>
<a HREF="index.php?action=form&type=new&dp=<?php
echo "{$dopon}";
?>
"><?php
echo _INSERT;
?>
</A><?php
} else {
?>
<a HREF="index.php?action=form&type=new&dp=<?php
echo "{$dopon}";
?>
&rub=<?php
echo "{$rub}";
?>
&pri=<?php
echo "{$pri}";
?>
"><?php
echo _INSERT;
?>
</A><?php
}
?>
</th>
<th colspan="<?php
echo $cs1;
?>
"align="right"><?php
// paging of extracts
$id = "ann_id";
$table = "uniletim_announces";
if (isset($uoz)) {
$link = "index.php?action=user&uoz={$uoz}&page=";
} elseif (isset($pri)) {
$link = "index.php?rub={$rub}&pri={$pri}&page=";
} else {
$link = "index.php?rub={$rub}&keyword={$keyword}&age={$age}&view={$view}&page=";
}
page_counter($id, $table, $sort, $view_number, $sess, $link, $i, $page);
?>
|
</th>
</tr>
</tfoot>
<?php
}
