Jürgen Schilling - Natur | Fotografie | Technik .

 

JürgenSchilling

Natur | Fotografie | Technik

 
 

 Home

 Black&White
 Cyanotypie
 Fotogramme
 Infrarot
 Jägerprüfung
 Kategorien
 Kirlianfotografie
 Lochkamera
 Makroaufnahmen



Lightbox


 Manuals:
 
Alle Manuals
 Aluminium eloxieren
 Hochspannungsgenerator
 Belichtungszeitentabelle
 Beurteilung v. Negativen
 Blitzlichtfotographie
 Farbmischung
 Filmentwicklung
 Infrarotfotografie
 Teslatrafo
 Teslatrafo Rechner
 Schrauben u. Gewinde

 Entwicklingszeiten:
 Agfa Rodinal
 Kodak D76

 Tiefenschäferechner

 
 Impressum


______

















  
  Bilder pro Gast
  phpMyAdmin
  Counter
  Most viewed
  Logout
  Login
  Theme curve
  Theme my-fruity

Hier werden die Bildaufrufe pro Host und pro Tag aus der Coppermine 1.5.14 Datenbank ausgelesen 
 
Datum 30.04.2017
Uhrzeit 22:39:19
Startzeit: 17272
Endzeit: 17286
Timestamp: 1493591959

Zeitpunkt des ersten ZugriffsIP vom GastrechnerAufgerufenen Bilder
2017.04.30 - 22:25:22 - Sunday - 1728684.153.98.1311
2017.04.30 - 21:00:59 - Sunday - 1728693.133.179.69138
2017.04.30 - 20:41:12 - Sunday - 1728687.176.83.1413
2017.04.30 - 17:27:29 - Sunday - 17286188.105.213.2261
2017.04.30 - 15:34:24 - Sunday - 1728681.189.26.2162
2017.04.30 - 13:14:19 - Sunday - 1728688.128.80.22131
2017.04.30 - 05:52:54 - Sunday - 1728687.170.103.24789
2017.04.29 - 22:01:26 - Saturday - 1728585.56.138.756
2017.04.29 - 17:46:33 - Saturday - 1728591.15.59.887
2017.04.29 - 17:40:34 - Saturday - 17285185.54.59.9111
2017.04.29 - 17:26:03 - Saturday - 1728587.148.69.129188
2017.04.29 - 16:12:45 - Saturday - 1728588.128.81.215
2017.04.29 - 16:11:46 - Saturday - 1728589.217.83.144
2017.04.29 - 16:09:52 - Saturday - 1728562.46.198.1345
2017.04.29 - 15:31:51 - Saturday - 1728594.76.178.81
2017.04.29 - 14:17:16 - Saturday - 17285217.95.104.101
2017.04.29 - 06:49:52 - Saturday - 1728587.158.47.1841
2017.04.29 - 05:06:31 - Saturday - 1728591.48.15.1852
2017.04.28 - 19:20:50 - Friday - 1728479.224.125.4516
2017.04.28 - 19:09:45 - Friday - 1728487.158.162.1431
2017.04.28 - 18:00:49 - Friday - 1728483.125.121.258
2017.04.28 - 14:50:54 - Friday - 17284217.87.192.13366
2017.04.28 - 11:03:11 - Friday - 1728487.148.69.129125
2017.04.28 - 10:55:02 - Friday - 1728462.225.75.2695
2017.04.28 - 09:03:25 - Friday - 1728479.242.10.174384
2017.04.28 - 06:46:24 - Friday - 17284172.88.84.632
2017.04.28 - 05:54:53 - Friday - 17284195.200.70.538
2017.04.28 - 05:38:57 - Friday - 17284198.20.72.2341
2017.04.27 - 20:50:19 - Thursday - 1728383.150.19.2474
2017.04.27 - 18:36:38 - Thursday - 1728347.65.175.1807
2017.04.27 - 16:57:37 - Thursday - 1728387.159.225.19112
2017.04.27 - 16:45:58 - Thursday - 17283178.7.162.1271
2017.04.27 - 15:34:14 - Thursday - 1728389.1.57.7510
2017.04.27 - 14:00:39 - Thursday - 1728384.145.13.2123
2017.04.27 - 13:57:15 - Thursday - 1728391.221.59.253
2017.04.27 - 13:24:28 - Thursday - 17283217.5.198.1715
2017.04.27 - 11:58:42 - Thursday - 1728387.157.174.1841
2017.04.27 - 10:28:33 - Thursday - 1728391.6.180.561
2017.04.27 - 09:21:53 - Thursday - 1728331.25.126.15911
2017.04.27 - 07:09:02 - Thursday - 17283195.243.132.90132
2017.04.26 - 22:50:22 - Wednesday - 17282109.40.0.1351
2017.04.26 - 21:35:36 - Wednesday - 17282188.210.59.391
2017.04.26 - 21:06:16 - Wednesday - 1728279.206.147.2381
2017.04.26 - 20:59:16 - Wednesday - 1728284.57.54.1941
2017.04.26 - 18:54:45 - Wednesday - 1728287.148.84.5060
2017.04.26 - 17:51:03 - Wednesday - 1728295.90.231.492
2017.04.26 - 17:51:00 - Wednesday - 1728293.211.93.552
2017.04.26 - 17:41:45 - Wednesday - 1728284.170.211.17716
2017.04.26 - 16:04:34 - Wednesday - 17282217.5.230.9047
2017.04.26 - 15:08:47 - Wednesday - 17282213.251.182.1111
2017.04.26 - 15:01:26 - Wednesday - 1728277.22.252.2544
2017.04.26 - 12:48:54 - Wednesday - 1728293.203.10.2381
2017.04.26 - 12:14:28 - Wednesday - 1728287.191.133.356
2017.04.26 - 11:56:37 - Wednesday - 1728280.213.113.341
2017.04.26 - 11:55:13 - Wednesday - 17282195.243.132.90123
2017.04.26 - 10:51:00 - Wednesday - 1728284.129.123.1515
2017.04.26 - 09:02:25 - Wednesday - 1728291.112.35.2424
2017.04.26 - 07:37:23 - Wednesday - 17282138.246.2.233255
2017.04.26 - 07:26:56 - Wednesday - 17282217.251.51.947
2017.04.26 - 06:50:01 - Wednesday - 17282217.255.190.233125
2017.04.26 - 03:29:59 - Wednesday - 1728291.0.121.121108
2017.04.26 - 01:17:21 - Wednesday - 1728277.190.69.2122
2017.04.25 - 19:33:34 - Tuesday - 1728146.223.1.592
2017.04.25 - 18:54:24 - Tuesday - 1728185.98.246.251
2017.04.25 - 17:20:39 - Tuesday - 1728191.47.8.203
2017.04.25 - 16:56:02 - Tuesday - 1728191.0.121.121129
2017.04.25 - 16:21:32 - Tuesday - 17281121.35.225.2495
2017.04.25 - 15:29:24 - Tuesday - 1728180.153.52.799
2017.04.25 - 15:17:14 - Tuesday - 1728180.187.123.10054
2017.04.25 - 15:09:15 - Tuesday - 17281129.187.44.15314
2017.04.25 - 14:22:38 - Tuesday - 17281132.230.195.1114
2017.04.25 - 12:09:24 - Tuesday - 1728177.57.186.1443
2017.04.25 - 11:46:19 - Tuesday - 17281194.39.218.106
2017.04.25 - 11:01:17 - Tuesday - 17281212.95.7.991
2017.04.25 - 10:35:09 - Tuesday - 17281193.175.176.15019
2017.04.25 - 08:44:42 - Tuesday - 17281194.25.37.1866
2017.04.25 - 08:07:28 - Tuesday - 17281194.187.160.95255
2017.04.25 - 07:57:32 - Tuesday - 1728195.222.225.21
2017.04.25 - 06:13:42 - Tuesday - 17281195.243.149.947
2017.04.24 - 22:58:45 - Monday - 1728093.104.142.2082
2017.04.24 - 19:37:11 - Monday - 1728087.170.127.893
2017.04.24 - 19:14:35 - Monday - 1728087.181.151.13312
2017.04.24 - 19:05:51 - Monday - 1728095.222.26.24116
2017.04.24 - 17:41:55 - Monday - 17280178.193.5.1798
2017.04.24 - 15:37:54 - Monday - 1728080.131.143.12529
2017.04.24 - 13:53:37 - Monday - 172802.137.103.502
2017.04.24 - 13:50:32 - Monday - 17280141.78.102.764
2017.04.24 - 13:32:09 - Monday - 1728080.110.12.502
2017.04.24 - 13:16:17 - Monday - 17280217.10.52.101
2017.04.24 - 12:54:49 - Monday - 1728084.137.64.2491
2017.04.24 - 12:36:56 - Monday - 17280195.200.70.538
2017.04.24 - 12:18:25 - Monday - 1728080.154.95.2031
2017.04.24 - 11:29:53 - Monday - 1728065.208.151.1191
2017.04.24 - 10:17:50 - Monday - 1728065.208.151.1171
2017.04.24 - 08:28:47 - Monday - 1728084.150.189.924
2017.04.24 - 08:11:54 - Monday - 1728077.47.80.10312
2017.04.24 - 07:59:09 - Monday - 1728084.175.196.1082
2017.04.24 - 02:16:41 - Monday - 17280124.84.107.2194
2017.04.24 - 02:02:59 - Monday - 1728077.23.63.1706
2017.04.24 - 01:26:41 - Monday - 1728095.91.231.931
2017.04.23 - 19:34:02 - Sunday - 17279213.240.104.179123
2017.04.23 - 19:31:58 - Sunday - 1727977.119.130.987
2017.04.23 - 18:44:59 - Sunday - 17279191.185.224.723
2017.04.23 - 18:30:52 - Sunday - 1727965.208.151.1191
2017.04.23 - 17:21:01 - Sunday - 1727995.90.198.972
2017.04.23 - 17:01:40 - Sunday - 1727991.54.184.15710
2017.04.23 - 16:43:06 - Sunday - 1727993.236.61.1527
2017.04.23 - 15:24:59 - Sunday - 1727965.208.151.1141
2017.04.23 - 14:36:01 - Sunday - 1727993.229.148.723
2017.04.23 - 12:33:29 - Sunday - 1727980.133.31.20311
2017.04.23 - 12:10:55 - Sunday - 1727962.156.31.19914
2017.04.23 - 11:39:28 - Sunday - 1727980.187.103.1368
2017.04.23 - 10:34:37 - Sunday - 1727995.91.238.1113
2017.04.23 - 09:36:55 - Sunday - 1727992.224.60.20782
2017.04.23 - 08:45:14 - Sunday - 1727965.208.151.1161
2017.04.23 - 07:27:44 - Sunday - 1727993.233.83.1783
2017.04.23 - 06:44:06 - Sunday - 1727977.181.154.43142
2017.04.23 - 06:34:04 - Sunday - 1727980.135.227.3835
2017.04.22 - 18:22:09 - Saturday - 17278194.208.183.1741
2017.04.22 - 15:39:29 - Saturday - 1727887.147.197.1973
2017.04.22 - 15:13:47 - Saturday - 1727878.48.169.2714
2017.04.22 - 14:06:26 - Saturday - 17278217.239.0.448
2017.04.22 - 13:48:26 - Saturday - 1727877.119.130.1471
2017.04.22 - 13:23:44 - Saturday - 17278213.188.106.1275
2017.04.22 - 12:11:59 - Saturday - 1727865.208.151.1131
2017.04.22 - 09:02:28 - Saturday - 1727887.162.246.1582
2017.04.22 - 05:23:52 - Saturday - 17278203.151.64.662
2017.04.22 - 02:57:51 - Saturday - 1727865.208.151.1171
2017.04.21 - 20:01:46 - Friday - 1727793.194.113.2169
2017.04.21 - 18:19:36 - Friday - 1727731.16.178.72147
2017.04.21 - 16:07:59 - Friday - 1727793.245.102.12325
2017.04.21 - 15:15:28 - Friday - 1727765.208.151.1171
2017.04.21 - 14:40:52 - Friday - 17277178.200.194.826
2017.04.21 - 13:17:15 - Friday - 17277193.197.80.872
2017.04.21 - 12:52:37 - Friday - 17277217.229.139.2266
2017.04.21 - 10:48:54 - Friday - 1727762.216.206.310
2017.04.21 - 09:06:41 - Friday - 17277165.225.72.66124
2017.04.21 - 09:00:46 - Friday - 1727780.152.166.24443
2017.04.21 - 08:57:07 - Friday - 17277213.162.68.1732
2017.04.21 - 08:53:59 - Friday - 1727791.96.141.795
2017.04.21 - 05:49:51 - Friday - 17277195.200.70.537
2017.04.20 - 20:54:12 - Thursday - 1727691.14.84.6020
2017.04.20 - 18:44:50 - Thursday - 1727665.208.151.1184
2017.04.20 - 18:35:46 - Thursday - 1727665.208.151.1176
2017.04.20 - 18:35:37 - Thursday - 1727665.208.151.1136
2017.04.20 - 18:35:27 - Thursday - 1727665.208.151.1125
2017.04.20 - 18:35:18 - Thursday - 1727665.208.151.11414
2017.04.20 - 18:32:37 - Thursday - 1727665.208.151.1154
2017.04.20 - 18:28:45 - Thursday - 1727679.239.111.1891
2017.04.20 - 18:26:08 - Thursday - 1727687.158.246.214
2017.04.20 - 18:06:59 - Thursday - 17276188.63.144.1861
2017.04.20 - 18:02:39 - Thursday - 1727684.227.43.1234
2017.04.20 - 16:20:29 - Thursday - 1727695.91.211.2383
2017.04.20 - 15:52:53 - Thursday - 1727688.202.45.2241
2017.04.20 - 15:26:46 - Thursday - 1727687.164.203.472
2017.04.20 - 14:36:20 - Thursday - 1727691.96.182.1161
2017.04.20 - 12:48:19 - Thursday - 1727691.248.3.131
2017.04.20 - 12:22:07 - Thursday - 1727691.248.117.13284
2017.04.20 - 11:55:44 - Thursday - 17276178.3.23.801
2017.04.20 - 11:25:07 - Thursday - 1727680.187.101.892
2017.04.20 - 11:24:11 - Thursday - 1727692.75.45.1999
2017.04.20 - 11:03:51 - Thursday - 1727692.227.157.1087
2017.04.20 - 10:49:12 - Thursday - 1727665.208.151.1168
2017.04.20 - 10:08:05 - Thursday - 17276212.180.5.422
2017.04.20 - 09:46:31 - Thursday - 1727689.247.193.2940
2017.04.20 - 08:55:07 - Thursday - 172762.247.247.691
2017.04.20 - 08:53:36 - Thursday - 1727685.16.32.4215
2017.04.20 - 08:49:52 - Thursday - 1727665.208.151.1197
2017.04.20 - 07:19:03 - Thursday - 172765.10.4.831
2017.04.20 - 04:44:23 - Thursday - 17276187.19.24.2132
2017.04.19 - 21:09:33 - Wednesday - 1727591.57.219.1111
2017.04.19 - 20:18:40 - Wednesday - 1727584.136.250.1956
2017.04.19 - 19:59:59 - Wednesday - 17275217.228.6.629
2017.04.19 - 19:48:44 - Wednesday - 1727579.235.81.1632
2017.04.19 - 19:22:16 - Wednesday - 1727577.47.53.2035
2017.04.19 - 18:53:34 - Wednesday - 1727577.119.131.1736
2017.04.19 - 17:18:51 - Wednesday - 1727579.200.175.2011
2017.04.19 - 15:28:34 - Wednesday - 1727591.96.225.10439
2017.04.19 - 15:19:43 - Wednesday - 1727587.79.96.1202
2017.04.19 - 14:59:44 - Wednesday - 1727546.223.201.17837
2017.04.19 - 13:41:08 - Wednesday - 1727593.193.255.1324
2017.04.19 - 13:40:17 - Wednesday - 1727546.87.62.682
2017.04.19 - 13:30:39 - Wednesday - 1727584.190.191.1663
2017.04.19 - 13:14:50 - Wednesday - 1727580.110.102.2072
2017.04.19 - 13:06:27 - Wednesday - 1727591.14.91.2503
2017.04.19 - 13:05:50 - Wednesday - 172755.204.215.1154
2017.04.19 - 12:44:53 - Wednesday - 1727546.237.251.551
2017.04.19 - 10:15:44 - Wednesday - 17275118.212.113.1905
2017.04.19 - 10:13:20 - Wednesday - 1727580.152.166.244258
2017.04.19 - 07:09:05 - Wednesday - 17275178.27.216.15247
2017.04.19 - 06:29:57 - Wednesday - 1727584.187.158.1084
2017.04.19 - 05:29:08 - Wednesday - 17275110.168.60.2295
2017.04.19 - 03:29:28 - Wednesday - 17275189.26.91.7330
2017.04.18 - 21:28:20 - Tuesday - 1727477.67.245.2422
2017.04.18 - 17:18:22 - Tuesday - 1727492.231.33.10219
2017.04.18 - 15:36:58 - Tuesday - 1727490.187.249.431
2017.04.18 - 13:41:40 - Tuesday - 1727449.195.190.2081
2017.04.18 - 12:42:38 - Tuesday - 17274193.27.220.25431
2017.04.18 - 12:15:41 - Tuesday - 1727484.169.241.9221
2017.04.18 - 10:43:55 - Tuesday - 1727431.17.255.5724
2017.04.18 - 02:27:46 - Tuesday - 17274151.51.190.1592
2017.04.17 - 21:33:34 - Monday - 1727393.219.159.333
2017.04.17 - 17:35:20 - Monday - 17273217.250.134.2271
2017.04.17 - 16:07:44 - Monday - 1727391.34.195.301
2017.04.17 - 15:58:51 - Monday - 1727393.245.171.22421
2017.04.17 - 13:54:57 - Monday - 1727380.135.247.1771
2017.04.17 - 12:22:21 - Monday - 1727391.96.134.1071
2017.04.17 - 12:04:21 - Monday - 1727379.205.195.2356
2017.04.17 - 12:03:39 - Monday - 1727395.91.249.2451
2017.04.17 - 11:12:51 - Monday - 1727384.61.92.1399
2017.04.17 - 10:13:38 - Monday - 1727382.115.127.569
2017.04.16 - 19:13:33 - Sunday - 1727287.156.225.712
2017.04.16 - 18:54:56 - Sunday - 1727277.182.206.204123
2017.04.16 - 17:54:05 - Sunday - 1727280.187.81.32
2017.04.16 - 17:37:09 - Sunday - 1727280.110.8.2285
2017.04.16 - 15:40:16 - Sunday - 1727231.220.114.1315
2017.04.16 - 14:13:24 - Sunday - 1727282.113.121.1343
2017.04.16 - 14:00:07 - Sunday - 1727293.203.210.1373
2017.04.16 - 11:05:58 - Sunday - 1727293.197.12.304
2017.04.16 - 08:56:49 - Sunday - 1727281.202.97.1591
2017.04.16 - 08:28:20 - Sunday - 1727246.128.11.18711
2017.04.16 - 07:13:02 - Sunday - 17272109.90.146.1604




PHP Code farbig darstellen:

<?php
highlight_file('_pictures-per-guest_farbig.php');
?>



Der Code für des "Bildaufrufe pro Besucher" Skript:

  <?php

// Aktuelle Uhrzeit ausgeben
$datum date("d.m.Y");
$uhrzeit date("H:i:s");

// Zeitstempel
$timestamp time();

// Datumszahl seit 1.1.1970
// $endtag = round($timestamp / (24*3600));
// schneidet alle Nachkommastellen ab
$endtag floor($timestamp / (24*3600));

// Zahl der Tage die gezaehlt werden
$starttag $endtag -14;

echo 
"Datum $datum<br>";
echo 
"Uhrzeit $uhrzeit<br>";
echo 
"Startzeit: $starttag<br>";
echo 
"Endzeit: $endtag<br>";
echo 
"Timestamp: $timestamp<br>";

echo 
"<br>";

// Kopfzeile der Tabelle

echo "<table border=1 width=600 cellpadding=#0 cellspacing=#0 bordercolor=#D1D7DC bgcolor=#ffffff style='border-collapse:collapse'>";
echo 
"<tr style='font-family: Arial' style='font-size:11px'>";
echo 
"<td width=300>";
echo 
"Zeitpunkt des ersten Zugriffs";
echo 
"<td width=150>";
echo 
"IP vom Gastrechner";
echo 
"<td width=150>";
echo 
"Aufgerufenen Bilder";
echo 
"</tr>";
echo 
"</table>";


// While-Schleife wird fuer jeden Tag des Jahres durchlaufen.


while($starttag <= $endtag)



$db mysql_connect("localhost""xxxx""yyyyy");

mysql_select_db("imagedb",$db);

$sql_ip mysql_query ("SELECT sdate, ip, COUNT(ip) FROM cpg11d_hit_stats  WHERE sdate LIKE '%$endtag' GROUP BY ip ORDER BY sdate DESC ",$db);

// Tabelle fuer die Datenausgabe
echo "<table border=1 width=600 cellpadding=#0 cellspacing=#0 bordercolor=#D1D7DC bgcolor=#ffffff style='border-collapse:collapse'>";

while(
$myrow mysql_fetch_array($sql_ip))
{

echo 
"<tr style='font-family: Arial' style='font-size:11px'>";
echo 
"<td width=300><font color=#000000>";
echo 
$myrow["sdate"];
echo 
"</td>";


// Den Link fuer die URL und die WHOIS IP Aufloesung erstellen
// Das muss rauskommen:
// http://whois.domaintools.com/234.174.137.117

echo "<td width=150>";
echo 
"<a target=\"_blank\" href=\"http://whois.domaintools.com/";
echo 
$myrow["ip"];
echo 
"\">";
echo 
$myrow["ip"];
echo 
"</a>";


// ECHO $myrow["ip"]">"$myrow["ip"]"</a>
// Anzahl der Zugriffe pro IP

echo "<td width=150><font color=#0000FF>";
echo 
$myrow["COUNT(ip)"];
echo 
" </tr>";

}

echo 
"</table>";

// Datumszahl seit 1.1.1970 wird um eins verringert
 
$endtag--;



echo 
"<br>";

?>



 


Coppermine so einstellen, daß die Bildaufrufe pro Besucher gezählt werden können:
 

In der Tabelle "cpg11d_hit_stats" stehen die aufgerufenen Bilder, der Host, und die Aufrufzeit.


cpg11d_hit_stats:

 

 sid pid ip search_phrase  sdate referer browser os
13 13847 87.174.245.31   2012.01.01 - 19:06:26 - Sunday - 15340 http://www.sr71.dyndns.info/thumbnails.php?album=s... Opera Windows Vista
16 14371 87.174.232.118   2012.01.01 - 03:09:37 - Sunday - 15340 http://www.sr71.dyndns.info/thumbnails.php?album=2... IE Windows 7

Damit die Zeit korrekt dargestellt wird, muss die Spaltendefinition von "sdate" von biginit (20) nach "text" umgewandelt werden.





Dann in der /www/www.sr71.com/include/functions.inc.php folgenden String suchen:
 

$time = time();

 



und durch folgenden String ersetzen:


 


//$time = time();


$datum = date("Y.m.d - H:i:s - l - ");

// erzeugt eine Datumszahl - pro Tag eine Zahl

$timestamp = time();
$endtag = floor($timestamp / (24*3600));

// Dieser Eintrag schreibt in die Datenbank
$time = $datum . $endtag;
 





(c) Jürgen Schilling 14.01.2012