function announces_print($sess, $uoz, $rub, $pri, $keyword, $age)
{
// create header of page
head_printing();
?>
<table width="720" border="0" cellspacing="0" cellpadding="3" align="center">
<?php
if ($uoz != "") {
// user listing of announces
announces_print_selected($sess, $keyword, $age, $uoz);
} elseif ($keyword != "" || $age != "") {
// selected announces
$agesec = Time() - $age * 24 * 3600;
$agesel = "ann_date >= '{$agesec}'";
$keysel = "ann_text like '%{$keyword}%'";
$sel_keys = "{$agesel} AND {$keysel}";
@($sql_sub = mysql_query("SELECT count(ann_id) FROM uniletim_announces WHERE {$sel_keys} AND ul_group = '{$sess['4']}'"));
$row_sub = mysql_fetch_row($sql_sub);
if ($row_sub[0] < 20) {
// listing of selected announces
announces_print_selected($sess, $keyword, $age, $uoz);
} else {
// listing of subsections
announces_print_subsections($sess, $rub, $pri, $keyword, $age);
}
} else {
// listing of subsections
announces_print_subsections($sess, $rub, $pri, $keyword, $age);
}
// create footer of page
foot_printing($sess);
}
function services_list_printing($sess, $what)
{
// page header
head_printing();
?>
<table width="650" border="0" cellspacing="0" cellpadding="3" align="center">
<TR class="td_tmave">
<td colspan="5" class="dark">
<h2><?php
//zobrazujeme aktuální nebo staré zprávy
if ($what == "all") {
echo _ALL_SERVICES;
$sort = "ser_recipient like '%'";
} else {
echo "->> " . _PAYMENTS . ":";
$sort = "to_date < NOW()";
}
?>
</h25>
</td>
</TR>
<TR class="middle">
<TD width="100"><?php
echo _DATE;
?>
</TD>
<TD width="110"><?php
echo _SERVICE_RECIPIENT;
?>
</TD>
<TD width="110"><?php
echo _SERVICE_PROVIDER;
?>
</TD>
<TD><?php
echo _SERVICE;
?>
</TD>
<TD width="70" align=right><?php
echo _AMOUNT;
?>
</TD>
</TR>
<?php
$message = MySQL_Query("SELECT * FROM uniletim_services WHERE {$sort} AND ul_group = '{$sess['4']}' ORDER BY ser_time DESC") or die($query_error);
//vybíráme zprávy - seøazeno podle id
//vypiseme tabulky se zpravami
$i = 0;
while ($entry = MySQL_Fetch_Array($message)) {
if ($i % 2 == 0) {
$bgcolor = '';
} else {
$bgcolor = " class=row";
}
?>
<TR <?php
echo $bgcolor;
?>
>
<td><?php
$ke = Explode("-", $entry[3]);
echo " " . $ke[2] . ". " . $ke[1] . ". " . $ke[0] . "";
?>
</td>
<td><?php
member_name($entry[1]);
?>
</td>
<td><?php
member_name($entry[2]);
?>
</td>
<td><?php
echo "{$entry['4']}";
?>
</td>
<td align=right><?php
echo "{$entry['5']}";
?>
</td>
</TR>
<?php
$i++;
}
// page footer
foot_printing($sess);
}
<?php
include "./config.php";
include "./auth.php";
include "./includes/page.php";
include "./includes/announces.php";
include "language/lang-{$app_lang}.php";
head_printing();
?>
<table width="720" border="0" cellspacing="0" cellpadding="3">
<?php
if ($uoz == "") {
if ($rub != "") {
$sec_sel = "r_id = '{$rub}'";
// sections
} else {
$sec_sel = "r_name like '%'";
}
$sql_sec = mysql_query("SELECT * FROM lets_rubriky WHERE {$sec_sel} AND l_group = '{$sess['4']}'");
while ($row_sec = mysql_fetch_row($sql_sec)) {
$rub = $row_sec[0];
// subsections
if ($pri != "") {
$sub_sel = "S.pr_id='{$pri}'";
// sections
} else {
$sub_sel = "S.pr_rubrika='{$rub}'";
}
$sql_head = mysql_query("SELECT * FROM lets_rubriky WHERE r_id = '{$rub}' AND l_group = '{$sess['4']}'");
$row_head = mysql_fetch_row($sql_head);
?>
function members_list_printing($sess)
{
// page header
head_printing();
@($sqp = mysql_query("SELECT M.*, P.perm_group FROM uniletim_members M\r\n\t\t\t\t\t\t\t\tLEFT JOIN uniletim_perms P ON M.mbr_id = P.perm_member\r\n\t\t\t\t\t\t\t\tWHERE P.perm_group = '{$sess['4']}' AND M.mbr_state != 'd' ORDER BY M.mbr_login"));
if (mysql_num_rows($sqp) == 0) {
echo "<tr><td COLSPAN=5>" . _NO_USER . "</td></tr></table>\n";
} else {
?>
<table width="720" border="0" align="center" cellspacing="0" cellpadding="3">
<tr class="dark">
<td colspan="6"><h2><?php
echo _GROUP;
?>
:
<?php
$message = MySQL_Query("SELECT * FROM uniletim_groups WHERE grp_id = '{$sess['4']}'") or die($query_error);
//vybíráme zprávy - seøazeno podle id
$entry = MySQL_Fetch_Row($message);
echo $entry[1];
?>
</h25>
</td></tr>
<TR class="middle">
<td width="130">
<?php
echo _USER_NAME;
?>
</td>
<td><?php
echo _NAME;
?>
</td>
<td><?php
echo _SURNAME;
?>
</td>
<TD width="80"><?php
echo _PHONE;
?>
</td>
<TD width="120"><?php
echo _EMAIL;
?>
</td>
<td width="70" align="right"><?php
echo _ACCOUNT_STATUS;
?>
</td>
</tr>
<?php
$i = 0;
while ($row = mysql_fetch_row($sqp)) {
if ($i % 2 == 0) {
$bgcolor = '';
} else {
$bgcolor = " class=row";
}
?>
<TR <?php
echo $bgcolor;
?>
>
<TD <?php
echo $bgcolor;
?>
><?php
echo $row[1];
?>
</td>
<TD <?php
echo $bgcolor;
?>
><?php
echo $row[5];
?>
</td>
<TD <?php
echo $bgcolor;
?>
><?php
echo $row[4];
?>
</td>
<TD <?php
echo $bgcolor;
?>
><?php
echo $row[10];
?>
</td>
<TD <?php
echo $bgcolor;
?>
><?php
echo $row[6];
?>
</td>
<TD <?php
echo $bgcolor;
?>
align="right"><?php
$message = MySQL_Query("SELECT SUM(ser_amount) FROM uniletim_services WHERE ser_provider like '{$row['0']}' AND ul_group = '{$sess['4']}'") or die($query_error);
//vybíráme zprávy - seøazeno podle id
$entry = MySQL_Fetch_Row($message);
$count = $entry[0];
$message = MySQL_Query("SELECT SUM(ser_amount) FROM uniletim_services WHERE ser_recipient like '{$row['0']}' AND ul_group = '{$sess['4']}'") or die($query_error);
//vybíráme zprávy - seøazeno podle id
$entry = MySQL_Fetch_Row($message);
$count = $count - $entry[0];
echo $count;
?>
</td>
</tr>
<?php
$i++;
}
}
// page footer
foot_printing($sess);
}
