| Server IP : 79.136.114.73 / Your IP : 216.73.216.61 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/www.astacus.se/dk/ |
Upload File : |
<?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("astacus_web");
$sql = "select count(*) as nbr from tblCounterLog where userdata not like '%bot%'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$sidvisning = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where userdata not like '%bot%' group by ip";
$result = mysql_query($sql);
$unika = 0;
while ($row = mysql_fetch_assoc($result)){
$unika++;
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%affars_forvaltning%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$affars_forvaltning = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%affars_projektering%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$affars_projektering = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%affars_samhallsservice%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$affars_samhallsservice = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%affars_mobila%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$affars_mobila = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%referenser%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$referenser = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%astacus%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$astacus = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%kontakt%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$kontakt = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%nyheter%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$nyheter = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%bestall%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$bestall = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where (page like '%start%' or page like '/' or page like '/new/' or page like '?id=') and page not like '%bot%'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$start = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%statistik%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$statistik = $row['nbr'];
}
$sql = "select count(*) as nbr from tblCounterLog where page like '%policy%' and userdata not like '%bot%'" ;
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$policy = $row['nbr'];
}
$arr = array();
$sql = "select referred from tblCounterLog";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$referred = $row['referred'];
$info = parse_url($referred);
$host = $info['host'];
if(!in_array( $host, $arr)) {
array_push($arr,$host);
}
}
$tot = $start+$nyheter+$kontakt +$astacus+$referenser+$affars_mobila+$affars_samhallsservice +$affars_projektering+$affars_forvaltning+$bestall+$statistik+$policy;
?><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<table width="1020" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3"><img src="images/omastacus.jpg" alt="" width="1020" height="204" /></td>
</tr>
<tr>
<td width="50"> </td>
<td width="920" align="left" valign="top"><p><br />
<span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><strong>Generell Statistik</strong>
<br />
(Sökmotorer har exkluderats)</span>
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="145"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Antal sidvisningar:<br />
Antal unika besökare:</span></td>
<td width="355"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo($sidvisning);?><br />
<?php echo($unika);?> </span></td>
</tr>
</table>
<p><br />
<span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><strong>Besökta sidor</strong></span><strong><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #000">:</span></strong>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Startsidan</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($start/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($start/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">F?rvaltning</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($affars_forvaltning/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($affars_forvaltning/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Projektering, byggnation & arkitektur</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($affars_projektering/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($affars_projektering/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Samhällsservice (kart- och ledningsinfo)</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($affars_samhallsservice/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($affars_samhallsservice/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Mobila plattformar och Appar</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($affars_mobila/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($affars_mobila/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Referenser</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($referenser/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($referenser/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Om Astacus</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($astacus/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($astacus/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Kontakta oss</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($kontakt/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($kontakt/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Nyheter</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($nyheter/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($nyheter/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Beställ</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($bestall/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(round(100*($bestall/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Statistik</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($statistik/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC"><table width="<?php echo(round(100*($statistik/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Policy</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(round(100*($policy/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC"><table width="<?php echo(round(100*($policy/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="230" height="25"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">Övrigt</span></td>
<td width="30"><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><?php echo(100-round(100*($tot/$sidvisning)));?>%</span></td>
<td width="640" align="left" nowrap="nowrap" bgcolor="#CCCCCC">
<table width="<?php echo(100-round(100*($tot/$sidvisning)));?>%" height="25" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#666666"> </td>
</tr>
</table>
</td>
</tr>
</table>
<p><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><strong></strong></span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><strong><br />
Användare kommer från domäner:<br />
</strong></span><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">
<?php
foreach($arr as $url){
echo($url."<br>");
}
?>
<br />
</span></p>
<p><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><br />
</span><strong>Supervision statistik</strong><br />
<br />
</p>
<table width="800" border="0" cellspacing="0" cellpadding="0" style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">
<tr>
<td width="244">F?retag</td>
<td width="254">Anv?ndare</td>
<td width="157">Antal objekt</td>
<td width="145">Senast inloggad</td>
</tr>
</table>
<?php
mysql_select_db ("supervision");
$sql = "SELECT tblCompany.name as company, tblUsers.username as username, userid FROM tblUsers, tblCompany where tblCompany.companyId = tblUsers.companyId order by tblCompany.name";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$company = $row['company'];
$username = $row['username'];
$userid = $row['userid'];
$sql = "SELECT count(*) as nbr FROM tblPositions where userid = ".$userid;
$result2 = mysql_query($sql);
while ($row2 = mysql_fetch_assoc($result2)){
$nbrsymbols = $row2['nbr'];
}
$sql = "SELECT * FROM tblUsers where userid = ".$userid;
$result2 = mysql_query($sql);
while ($row2 = mysql_fetch_assoc($result2)){
$lastlogin = $row2['lastLogin'];
}
?>
<table width="800" border="0" cellspacing="0" cellpadding="0" style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">
<tr>
<td width="246"><?php echo($company);?></td>
<td width="254"><?php echo($username);?></td>
<td width="155"><?php echo($nbrsymbols);?></td>
<td width="145"><?php echo($lastlogin);?></td>
</tr>
</table>
<?php }?>
<p><strong>Notes statistik</strong><br />
<br />
</p>
<table width="800" border="0" cellspacing="0" cellpadding="0" style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">
<tr>
<td width="178">Företag</td>
<td width="201">Användare</td>
<td width="119">App</td>
<td width="157">Antal filer</td>
<td width="145">Senast inloggad</td>
</tr>
</table>
<?php
function count_files($path) {
// (Ensure that the path contains an ending slash)
if(!is_dir($path)){
return 0;
}
$file_count = 0;
$dir_handle = opendir($path);
if (!$dir_handle) return -1;
while ($file = readdir($dir_handle)) {
if ($file == '.' || $file == '..') continue;
if (is_dir($path . $file)){
$file_count += count_files($path . $file . DIRECTORY_SEPARATOR);
}
else {
$file_count++; // increase file count
}
}
closedir($dir_handle);
return $file_count;
}
mysql_select_db ("notes");
$sql = "SELECT tblCompany.name as company, tblUsers.username as username,tblCompany.companyId as companyId, tblUsers.application as application, userid FROM tblUsers, tblCompany where tblCompany.companyId = tblUsers.companyId order by tblCompany.name";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$company = $row['company'];
$companyid = $row['companyId'];
$username = $row['username'];
$userid = $row['userid'];
$app = $row['application'];
$p = "/var/www/notes_files/".$companyid."/";
$nbrsymbols = count_files($p);
$sql = "SELECT * FROM tblUsers where userid = ".$userid;
$result2 = mysql_query($sql);
while ($row2 = mysql_fetch_assoc($result2)){
$lastlogin = $row2['lastLogin'];
}
?>
<table width="800" border="0" cellspacing="0" cellpadding="0" style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;">
<tr>
<td width="179"><?php echo($company);?></td>
<td width="200"><?php
if(strpos($username,".se")){
$username = "<strong>".$username."</strong>";
}
echo($username);?></td>
<td width="121"><?php echo($app);?></td>
<td width="155"><?php echo($nbrsymbols);?></td>
<td width="145"><?php echo($lastlogin);?></td>
</tr>
</table>
<?php }?>
<p> </p>
<p><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"> <br />
</span></p>
<p> </p>
<p><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"> <br />
<br />
<br />
</span>
<p><span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"> </span>
<p><br />
</p> <p><br />
<span style="font-family: Arial, Helvetica, sans-serif;color: #000;font-size: 12px;"><br />
<br />
<br />
</span></p></td>
<td width="50" valign="top"> </td>
</tr>
</table>
<br />
<table width="1020" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><img src="images/h_line.jpg" width="984" height="23" align="middle" /></td>
</tr>
</table>
<br />
<br />
<br />
<br />