function DB_Count($TablesIDs, $Query = array())
{
/****************************************************************************/
$__args_types = array('string,array', 'array');
#-----------------------------------------------------------------------------
$__args__ = Func_Get_Args();
eval(FUNCTION_INIT);
/****************************************************************************/
if (!Is_Array($TablesIDs)) {
$TablesIDs = array($TablesIDs);
}
#-----------------------------------------------------------------------------
$Sql = SPrintF('SELECT COUNT(*) FROM %s', Implode(',', $TablesIDs));
#-----------------------------------------------------------------------------
if ($Where = DB_Where($Query)) {
$Sql = SPrintF('%s WHERE %s', $Sql, $Where);
}
if (isset($Query['GroupBy'])) {
$Sql = SPrintF('%s GROUP BY %s', $Sql, $Query['GroupBy']);
}
$Result = DB_Query($Sql);
#-----------------------------------------------------------------------------
switch (ValueOf($Result)) {
case 'error':
return ERROR | @Trigger_Error('[DB_Count]: невозможно осуществить запрос');
case 'resource':
#-------------------------------------------------------------------------
if (isset($Query['GroupBy'])) {
return mysql_num_rows($Result);
} else {
$Result = MySQL_Fetch_Row($Result);
return (int) Current($Result);
}
default:
return ERROR | @Trigger_Error(101);
}
}
function foot_printing($sess)
{
global $conn;
?>
<tr>
<td colspan="6">
<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 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];
?>
</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>
<br><br>
<p class=help>
<a href="#" OnClick="history.back()"><?php
echo _BACK;
?>
</a>
>
<a href="javascript:window.print();"><?php
echo _PRINT;
?>
</a></p>
</td>
<tr>
</table>
</BODY>
</HTML>
<?php
mysql_close($conn);
}
FUNCTION Fetch_Row() {
RETURN MySQL_Fetch_Row($this->result);
}
} else {
// user listing of announces
announces_print_user($uoz, $sess);
}
?>
<tr>
<td colspan="6">
<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>
chmod("config.php", 0666);
echo "The file <b>config.php</b> successfully created. Please reload the page.";
exit;
}
// configuration file
include "./config.php";
// authorization of users
$SN = "hvxator";
Session_name("{$SN}");
Session_start();
$sid = Session_id();
$date = Date("U");
$ad = Date("U") - 1800;
$MSQ = @MySQL_Query("SELECT * FROM uniletim_auth WHERE (aut_id = '{$sid}')");
// AND (aut_date >= '$ad')
$sess = @MySQL_Fetch_Row($MSQ);
if (@MySQL_Num_Rows($MSQ) < 1) {
$auth = "0";
// test if the db.tables are created; if not, jump to install.php
$dbInstalled = MySQL_Num_Rows(MySQL_Query("SHOW TABLES")) ? 1 : 0;
if (!$dbInstalled) {
include "./includes/tables.inc.php";
}
$memberExists = MySQL_Num_Rows(MySQL_Query("SELECT mbr_id FROM uniletim_members")) ? 1 : 0;
if (!$memberExists) {
include "./install.php";
exit;
}
if ($lang == "") {
$lang = $app_lang;
}
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);
}
function group_list($sess, $group, $result, $result1, $result2, $error, $error1, $error2)
{
$cs1 = " colspan=2";
$cs2 = " colspan=6";
$loc_page = _GROUPS;
page_location_announces($sess, $menu, $rub, $pri, $uoz, $eid, $loc_page);
page_result_error($result, $error);
?>
<?php
$sql = mysql_query("SELECT * FROM uniletim_groups ORDER BY 'grp_name'");
?>
<div class="content-border">
<table class="content">
<tr class="td_tmave">
<td colspan="5"><?php
echo _GROUPS;
?>
:
</td></tr>
<?php
$i = 0;
while ($row = mysql_fetch_row($sql)) {
if ($i % 2 == 0) {
$bgcolor = '';
} else {
$bgcolor = " class=td_rd";
}
?>
<TR <?php
echo $bgcolor;
?>
>
<TD><A HREF="group.php?action=info&group=<?php
echo $row[0];
?>
"><?php
echo $row[1];
?>
</A></TD>
<TD><?php
group_type($row);
?>
</TD>
<TD align="right"><?php
$message = MySQL_Query("SELECT M.mbr_id FROM uniletim_members M LEFT JOIN uniletim_perms P ON M.mbr_id = P.perm_member WHERE P.perm_group = '{$row['0']}'") or die($query_error);
$i = 0;
while ($entry = MySQL_Fetch_Row($message)) {
$i++;
}
echo "{$i} l ";
$message = MySQL_Query("SELECT count(ann_id) FROM uniletim_announces WHERE ul_group = '{$row['0']}'") or die($query_error);
$entry = MySQL_Fetch_Row($message);
echo "{$entry['0']} l ";
$message = MySQL_Query("SELECT count(ser_id) FROM uniletim_services WHERE ul_group = '{$row['0']}'") or die($query_error);
$entry = MySQL_Fetch_Row($message);
echo "{$entry['0']}";
?>
</TD>
<TD align="right">
<A HREF="index.php?group_ch=<?php
echo $row[0];
?>
&grp_name=<?php
echo $row[1];
?>
"><?php
echo _LOGIN;
?>
</A></TD>
<TD align="right">
<A HREF="group.php?action=list&group_del=<?php
echo "{$row['0']}";
?>
" onclick="return confirm('<?php
echo _RLY_DLT_GRP;
?>
')"><?php
echo _DELETE;
?>
</A>
</td>
<?php
$i++;
}
?>
<tr class="td_tmave">
<td colspan="5"><a class="tm" href="group.php?action=new"><?php
echo _NEW_GROUP;
?>
</a>
</td></tr>
</TR>
</TABLE>
</div>
<?php
}
