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); }
<table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr><td colspan="2"><hr size="3" noshade></td></tr> </tr> <td> <b><?php $message = MySQL_Query("SELECT * FROM lets_skupiny WHERE s_id = '{$sess['4']}'") or die($query_error); //vybíráme zprávy - seøazeno podle id $entry = MySQL_Fetch_Row($message); echo $entry[1]; ?> </b> </td> <td align="right"> <b>uniLETIM</b> <?php $date = date("Y-m-d"); $date = Explode("-", $date); echo " " . $date[2] . ". " . $date[1] . ". " . $date[0] . ""; ?> </td> </tr> </table> </td> <tr> </table> <?php foot_printing(); ?>
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); }