| Server IP : 93.86.61.54 / Your IP : 216.73.216.60 Web Server : Apache/2.4.62 (Ubuntu) System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64 User : www-data ( 33) PHP Version : 8.4.22 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/projects/ilink/ |
Upload File : |
<!DOCTYPE html>
<!--
*********************************
Project: Internet Link
File :
Version: 2021-01-13
Author : M. Kukic
Note : PHP v5 + MySQL + Apache
**********************************
-->
<html>
<style>
table, th, td {
border: 1px solid black;
}
th, td {
padding: 4px;
text-align: center;
}
</style>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<link rel='shortcut icon' type='image/png' href='favicon.ico'/>
<title>ILink</title>
</head>
<body>
<?php
//
//
include "config.php";
//include "func.php";
//
echo"<div style='width:".$resn."px; word-wrap:break-word;'>";
echo "<fieldset>";
echo "<legend><h3>iLink - Log</h3></legend>";
echo "<table border=\"0\">";
echo "</fieldset>";
//
//db user
$sql = "SELECT * FROM user ORDER BY user ASC";
if ($phpv==5){
$result = mysql_query($sql, $dbh) or die(mysql_error());
$numu = mysql_num_rows($result);
}else{
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$numu = mysql_num_rows($result);
}
//
echo "Broj User-a: ".$numu."<br><br>";
//
for ($i = 0; $i < $numu; $i++) {
if ($phpv==5){
$row = mysql_fetch_array($result);
}else{
$row = mysqli_fetch_array($result);
}
//
$ime[$i]=$row['user'];
}
//echo "User: ".$ime[0]."<br>User: ".$ime[1]."<br>";
echo "User akcija:<br>";
// SELECT COUNT(*) FROM event WHERE euser = "Pera";
for ($i = 0; $i < $numu; $i++) {
$sql ="SELECT COUNT(*) FROM event WHERE euser = '".$ime[$i]."'";
if ($phpv==5){
$result = mysql_query($sql, $dbh) or die(mysql_error());
$rowe = mysql_fetch_array($result);
}else{
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$rowe = mysqli_fetch_array($result);
}
echo $i+1;
echo ". ".$ime[$i]." - ".$rowe[0]."<br>";
}
//
//db event
$sql = "SELECT * FROM event ORDER BY eid DESC LIMIT 64";
if ($phpv==5){
$result = mysql_query($sql, $dbh) or die(mysql_error());
$numofrows = mysql_num_rows($result);
}else{
$result = mysqli_query($dbh, $sql) or die(mysqli_error($dbh));
$numofrows = mysql_num_rows($result);
}
echo "<br>";
echo "User akcije - poslednjih: ".$limit."<br><br>";
echo "<table border='1'>";
echo "<tr>";
echo "<th>ID</th>";
echo "<th>Date-Time</th>";
echo "<th>User</th>";
echo "<th>DBp</th>";
echo "<th>ID-Link</th>";
echo "<th>Akc</th>";
echo "</tr>";
for ($i = 0; $i < $limit; $i++) {
if ($phpv==5){
$row = mysql_fetch_array($result);
}else{
$row = mysqli_fetch_array($result);
}
//
echo "<tr>";
echo "<td>".$row['eid']."</td>";
echo "<td>".$row['time']."</td>";
echo "<td>".$row['euser']."</td>";
echo "<td>".$row['edbp']."</td>";
echo "<td>".$row['id_link']."</td>";
echo "<td>".$row['id_akc']."</td>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
echo "<hr>";
echo "<a href='javascript:history.go(-1)'><img src='img/back.png'></a><a href='ident.php?txt=".$u_pass."'><img src='img/hom.png'></a>";
?>
</div>
</body>
</html>