mrstats 40705 1750 310 0 10242370750 5643 5mrstats/admin_stat.php100604 1750 310 3570 10242366455 10610 ".$userinfo."

"; echo "Sind Sie sicher, da dieser Befehl ausgefhrt werden soll? Wenn JA, dann klicken Sie bitte hier"; } if ($confirm == 'yes') { echo "Der Befehl wurde ausgefhrt...
"; $db->query($sql); } ?> mrstats/htmlhead.php100604 1750 310 326 10242366455 10227 mrstats/index.php100604 1750 310 733 10242366456 7553 mrstats/index_.php100604 1750 310 37550 10242366457 7762 auth['uid']; //Modul DeDi-Tracker fr Der-Dirigent //von Manuel Reindorf //variablen bernehmen $deditable = $cfg_dedi['db_table_prefix'] . "mod_deditracker"; $dedicats = $cfg_dedi['db_table_prefix'] . "cat_lang"; $dedisides = $cfg_dedi['db_table_prefix'] . "side_lang"; $textstyle = 'Arial-8pt'; $headstyle = 'Arial-12pt'; $ModulMode = 'all-act-data'; //alle daten fr aktuellen Tag, Woche, Monat Jahr if ($ModulMode == 'all-act-data') { //zahlen fr aktuellen tag $blockstretch = '1.0'; $blockwidth = '15'; $thisday = date("d-m-Y"); $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_time LIKE '$hour' AND info_date = '$thisday'AND dedi_backend='no';"; echo ""; echo ""; for ($d = 0; $d <= 23; $d++) { $hour = $d.":%"; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_time LIKE '$hour' AND info_date = '$thisday'AND dedi_backend='no';"; echo $sql; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten fr heute: ".date("d-m-Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; //zahlen fr aktuelle woche $blockstretch = '0.1'; $blockwidth = '30'; $thisweek = date("W"); $thisyear = date("Y"); echo ""; echo ""; for ($d = 1; $d <= 7; $d++) { $day = $d."|".$thisweek."|%|".$thisyear; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_datestamp LIKE '$day' AND dedi_backend='no';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten fr diese Woche: ".date("W-Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; //zahlen fr aktuellen monat $blockstretch = '0.1'; $blockwidth = '15'; $thismonth = date("m-Y"); echo ""; echo ""; for ($d = 1; $d <= 31; $d++) { if ($d < 10) {$d = '0'.$d;} $day = $d."-".$thismonth; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date = '$day' AND dedi_backend='no';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten fr diesen Monat: ".date("m-Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; //zahlen fr aktuelles jahr $blockstretch = '0.1'; $blockwidth = '20'; $thisyear = date("Y"); echo ""; echo ""; for ($d = 1; $d <= 12; $d++) { if ($d < 10) {$d = '0'.$d;} $thismonth = "%-".$d."-".$thisyear; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date LIKE '$thismonth' AND dedi_backend='no';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten fr dieses Jahr: ".date("Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; } //alle daten fr aktuellen Tag, Woche, Monat Jahr ohne robotbesuche if ($ModulMode == 'all-act-data-nobots') { //zahlen fr aktuellen tag $blockstretch = '1.0'; $blockwidth = '15'; $thisday = date("d-m-Y"); echo ""; echo ""; for ($d = 0; $d <= 23; $d++) { $hour = $d.":%"; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_time LIKE '$hour' AND info_date = '$thisday'AND dedi_backend='no' AND brow_browser NOT LIKE '%bot%';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten ohne Robots/Spider fr heute: ".date("d-m-Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; //zahlen fr aktuelle woche $blockstretch = '0.1'; $blockwidth = '30'; $thisweek = date("W"); $thisyear = date("Y"); echo ""; echo ""; for ($d = 1; $d <= 7; $d++) { $day = $d."|".$thisweek."|%|".$thisyear; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_datestamp LIKE '$day' AND dedi_backend='no' AND brow_browser NOT LIKE '%bot%';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten ohne Robots/Spider fr diese Woche: ".date("W-Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; //zahlen fr aktuellen monat $blockstretch = '0.1'; $blockwidth = '15'; $thismonth = date("m-Y"); echo ""; echo ""; for ($d = 1; $d <= 31; $d++) { if ($d < 10) {$d = '0'.$d;} $day = $d."-".$thismonth; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date = '$day' AND dedi_backend='no' AND brow_browser NOT LIKE '%bot%';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten ohne Robots/Spider fr diesen Monat: ".date("m-Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; //zahlen fr aktuelles jahr $blockstretch = '0.1'; $blockwidth = '20'; $thisyear = date("Y"); echo ""; echo ""; for ($d = 1; $d <= 12; $d++) { if ($d < 10) {$d = '0'.$d;} $thismonth = "%-".$d."-".$thisyear; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date LIKE '$thismonth' AND dedi_backend='no' AND brow_browser NOT LIKE '%bot%';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten ohne Robots/Spider fr dieses Jahr: ".date("Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; } //alle daten fr aktuellen Tag, Woche, Monat Jahr nur robotbesuche if ($ModulMode == 'all-act-data-onlybots') { //zahlen fr aktuellen tag $blockstretch = '1.0'; $blockwidth = '15'; $thisday = date("d-m-Y"); echo ""; echo ""; for ($d = 0; $d <= 23; $d++) { $hour = $d.":%"; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_time LIKE '$hour' AND info_date = '$thisday'AND dedi_backend='no' AND brow_browser LIKE '%bot%';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten nur Robots/Spider fr heute: ".date("d-m-Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; //zahlen fr aktuelle woche $blockstretch = '0.1'; $blockwidth = '30'; $thisweek = date("W"); $thisyear = date("Y"); echo ""; echo ""; for ($d = 1; $d <= 7; $d++) { $day = $d."|".$thisweek."|%|".$thisyear; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_datestamp LIKE '$day' AND dedi_backend='no' AND brow_browser LIKE '%bot%';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten nur Robots/Spider fr diese Woche: ".date("W-Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; //zahlen fr aktuellen monat $blockstretch = '0.1'; $blockwidth = '15'; $thismonth = date("m-Y"); echo ""; echo ""; for ($d = 1; $d <= 31; $d++) { if ($d < 10) {$d = '0'.$d;} $day = $d."-".$thismonth; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date = '$day' AND dedi_backend='no' AND brow_browser LIKE '%bot%';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten nur Robots/Spider fr diesen Monat: ".date("m-Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; //zahlen fr aktuelles jahr $blockstretch = '0.1'; $blockwidth = '20'; $thisyear = date("Y"); echo ""; echo ""; for ($d = 1; $d <= 12; $d++) { if ($d < 10) {$d = '0'.$d;} $thismonth = "%-".$d."-".$thisyear; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date LIKE '$thismonth' AND dedi_backend='no' AND brow_browser LIKE '%bot%';"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo ""; } echo "
alle Daten nur Robots/Spider fr dieses Jahr: ".date("Y")."

"; //echo $hits."
"; $blockheight = $hits * $blockstretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
"; echo "

"; } /* //Seiten- und Ordnerstatistik if ($ModulMode == 'pagestats') { $blockheight = '10'; $blockstretch = '10'; echo ""; $sqlcat = "SELECT * FROM $dedicats WHERE visible = '1' ORDER BY idcat;"; $db->query($sqlcat); while ($db->next_record()) { $idcat = $db->f("idcat"); $catname = $db->f("name"); echo ""; $sqlside = "SELECT * FROM $dedisides WHERE online = '1' ORDER BY idside;"; $db2->query($sqlside); while ($db2->next_record()) { $idside = $db2->f("idside"); $sidename = $db2->f("title"); //$sqlsidehits = "SELECT COUNT(*) AS total FROM $deditable WHERE dedi_idcatside = '$idside';"; //$db3->query($sqlsidehits); //$db3->next_record(); //$hits = $db3->f('total'); //$blockwidth = $hits * $blockstretch; echo ""; } } echo "
".$catname."
".$sidename."
".$hits." Seitenabrufe
"; } */ //Seiten- und Ordnerstatistik if ($ModulMode == 'pagestats') { $blockheight = '10'; $blockstretch = '10'; echo ""; $sqlcats = "SELECT COUNT(*) AS total FROM $dedicats;"; $db->query($sqlcats); $db->next_record(); $cats = $db->f('total'); $sqlsides = "SELECT COUNT(*) AS total FROM $dedisides;"; $db->query($sqlsides); $db->next_record(); $sides = $db->f('total'); for ($c = 1; $c <= $cats; $c++) { if ($con_tree[$c][name] != '') { echo ""; } //echo "".$con_tree[$c][name]."
"; for ($s = 1; $s <= $sides; $s++) { if ($con_side[$s][idcat] == $c) { $sqlsidehits = "SELECT COUNT(*) AS total FROM $deditable WHERE dedi_idcatside = '$s' AND dedi_backend='no' AND brow_browser NOT LIKE '%bot%';"; $db->query($sqlsidehits); $db->next_record(); $hits = $db->f('total'); $blockwidth = $hits * $blockstretch; echo ""; //echo "--".$con_side[$s][name]." ".$hits."
"; } } } } ?> mrstats/menu.php100604 1750 310 13414 10242366460 7443 query($sql); $db->next_record(); $dbentry = $db->f('total'); //eintrge ohne robots zhlen $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE brow_browser NOT LIKE '%bot%' AND brow_browser NOT LIKE '%spid%' AND brow_browser NOT LIKE '%crawl%';"; $db->query($sql); $db->next_record(); $dbhits = $db->f('total'); //eintrge nur robots zhlen $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE brow_browser LIKE '%bot%' OR brow_browser LIKE '%spid%' OR brow_browser LIKE '%crawl%';"; $db->query($sql); $db->next_record(); $dbrobots = $db->f('total'); //ersten eintrag ermitteln $sql = "SELECT * FROM $deditable ORDER BY ID LIMIT 0,1;"; $db->query($sql); while ($db->next_record()) { $dbfirst = $db->f("info_date")." - ".$db->f("info_time"); } //letzten eintrag ermitteln $sql = "SELECT * FROM $deditable ORDER BY ID DESC LIMIT 0,1;"; $db->query($sql); while ($db->next_record()) { $dblast = $db->f("info_date")." - ".$db->f("info_time"); } echo "
".$con_tree[$c][name]."
".$con_side[$s][name]."
".$hits." Seitenabrufe ".$hits."
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
Datum:".$thisday."
Eintrge:".$dbentry."
Hits:".$dbhits."
Robots:".$dbrobots."
erster:".$dbfirst."
letzter:".$dblast."
"; ?>

alle Infos ohne Robots
Seitenabrufe heute
Seitenabrufe diese Woche
Seitenabrufe diesen Monat
Seitenabrufe dieses Jahr

alle Infos nur Robots
Seitenabrufe heute
Seitenabrufe diese Woche
Seitenabrufe diesen Monat
Seitenabrufe dieses Jahr

alle Infos einschl. Robots
Seitenabrufe heute
Seitenabrufe diese Woche
Seitenabrufe diesen Monat
Seitenabrufe dieses Jahr

Statistikadmin
Backendhits lschen
letztes Jahr lschen
letzten Monat lschen
Suchmaschinen lschen
alle Eintrge lschen

MR-Statistik
entwickelt von Manuel Reindorf als PlugIn fr das CMS Der-Dirigent

info@reindorf-edv.de
www.reindorf-edv.de

mrstats/output.php100604 1750 310 3623 10242366460 10020 query($sql); echo ""; echo "\n"; while ($db->next_record()) { $RemoteAddr = $db->f("requ_remoteaddr"); $RemoteName = $db->f("requ_remotename"); if ($RemoteName == '') {$RemoteName = 'unbekannter Host';} $RequestUrl = $db->f("requ_scriptname"); $Referer = $db->f("brow_referer"); $Browser = $db->f("brow_browser"); $Protocol = $db->f("brow_protocol"); $QueryURL = $db->f("brow_query"); $ClientLang = $db->f("brow_language"); $RequestDate = $db->f("info_date"); $RequestTime = $db->f("info_time"); $PageID = $db->f("dedi_idcatside"); $PageName = $con_tree[$PageID][name]; $DediSession = $db->f("dedi_session"); $Spacer = "   "; echo ""; } echo "
Seitenaufrufe heute ".$thisday."

\n"; echo "Datum: ".$RequestDate.$Spacer."Zeit: ".$RequestTime.$Spacer."IP: ".$RemoteAddr.$Spacer."Host: ".$RemoteName.$Spacer."Session: ".$DediSession."
\n"; echo "Seite: ".$PageName.$Spacer."Referer: ".$Referer."\n"; echo "

"; ?> mrstats/output_hitdetail.php100604 1750 310 6720 10242366461 12051 query($sql); while ($db->next_record()) { $pagename = $db->f("title"); } if ($caller == 'thisday') { $querydate = $date; $sql = "SELECT * FROM $deditable WHERE info_date = '$date' AND dedi_idcatside = '$pageid' AND dedi_backend='no'".$sqlfilter.";"; } if ($caller == 'thisweek') { $querydate = $date; $sql = "SELECT * FROM $deditable WHERE info_datestamp LIKE '$querydate' AND dedi_idcatside = '$pageid' AND dedi_backend='no'".$sqlfilter.";"; } if ($caller == 'thismonth') { $querydate = "%".$date; $sql = "SELECT * FROM $deditable WHERE info_date LIKE '$querydate' AND dedi_idcatside = '$pageid' AND dedi_backend='no'".$sqlfilter.";"; } if ($caller == 'thisyear') { $querydate = $date; $sql = "SELECT * FROM $deditable WHERE info_date LIKE '%$querydate' AND dedi_idcatside = '$pageid' AND dedi_backend='no'".$sqlfilter.";"; } $db->query($sql); echo ""; echo "\n"; while ($db->next_record()) { $RemoteAddr = $db->f("requ_remoteaddr"); $RemoteName = $db->f("requ_remotename"); if ($RemoteName == '') {$RemoteName = 'unbekannter Host';} //$RemoteName = wordwrap( $RemoteName,25, "
", 1); $RequestUrl = $db->f("requ_scriptname"); $Referer = $db->f("brow_referer"); //$Referer = wordwrap( $Referer,40, "
", 1); $Browser = $db->f("brow_browser"); $Protocol = $db->f("brow_protocol"); $QueryURL = $db->f("brow_query"); $ClientLang = $db->f("brow_language"); $RequestDate = $db->f("info_date"); $RequestTime = $db->f("info_time"); $PageID = $db->f("dedi_idcatside"); $PageName = $con_tree[$PageID][name]; $DediSession = $db->f("dedi_session"); $Spacer = "   "; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; } echo "
Details der Seitenaufrufe bei Seite ".$pagename." (ID:".$pageid.") fr ".$querydate."

Datum: ".$RequestDate."
Zeit: ".$RequestTime."
IP: ".$RemoteAddr."
Host: ".$RemoteName."
Session: ".$DediSession."
Seite: ".$PageName."
Referer: ".$Referer."


"; ?> mrstats/output_pagehits.php100604 1750 310 4257 10242366461 11711 query($sql); $db->next_record(); $pagecount = $db->f('total'); //seiten durchlaufen echo ""; for ($pcount = 0; $pcount < $pagecount; $pcount++) { $sql = "SELECT * FROM $dedicatside ORDER BY idcat ASC LIMIT $pcount,1;"; $db->query($sql); while ($db->next_record()) { $idcatside = $db->f("idcatside"); $idside = $db->f("idside"); $idcat = $db->f("idcat"); } //categoriename auflsen $sql = "SELECT * FROM $dedicats WHERE idcat = '$idcat';"; $db->query($sql); while ($db->next_record()) { $catname = $db->f("name"); $catvisible = $db->f("visible"); } //seitenname auflsen $sql = "SELECT * FROM $dedisides WHERE idside = '$idside';"; $db->query($sql); while ($db->next_record()) { $pagename = $db->f("title"); $pageonline = $db->f("online"); } //hits fr aktuelle seite holen aber nur wenn categorie visible und side online if ($catvisible == 1 and $pageonline == 1) { $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE dedi_idcatside = '$idside' AND dedi_backend='no'".$sqlfilter.";"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); $blockwidth = $hits * $blockstretch; echo ""; } } ?> mrstats/output_sessioncheck.php100604 1750 310 4461 10242366462 12564 query($sql); echo "
".$catname." -> ".$pagename."
".$hits." Seitenabrufe ".$hits."
"; echo "\n"; while ($db->next_record()) { $RemoteAddr = $db->f("requ_remoteaddr"); $RemoteName = $db->f("requ_remotename"); if ($RemoteName == '') {$RemoteName = 'unbekannter Host';} $RequestUrl = $db->f("requ_scriptname"); $Referer = $db->f("brow_referer"); $Browser = $db->f("brow_browser"); $Protocol = $db->f("brow_protocol"); $QueryURL = $db->f("brow_query"); $ClientLang = $db->f("brow_language"); $RequestDate = $db->f("info_date"); $RequestTime = $db->f("info_time"); $PageID = $db->f("dedi_idcatside"); $PageName = $con_tree[$PageID][name]; $DediSession = $db->f("dedi_session"); $Spacer = "   "; echo ""; } echo "
Einzelinformationen zum Besucher mit der Session ".$dedisess." vom ".$thisday."

\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
Zeit: ".$RequestTime."
Seite: ".$PageName."
IP: ".$RemoteAddr."
Host: ".$RemoteName."
Referer: ".$Referer."
Parameter: ".$QueryURL."
Browser: ".$Browser."
"; echo "

"; ?> mrstats/output_thisday.php100604 1750 310 7105 10242414254 11537 \n"; echo "alle Daten fr: ".$thisday." von 0-23 Uhr\n"; for ($d = 0; $d <= 23; $d++) { $hour = $d.":%"; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_time LIKE '$hour' AND info_date = '$thisday'AND dedi_backend='no'".$sqlfilter.";"; //echo $sql; $db->query($sql); $db->next_record(); $hits = $db->f('total'); echo "

"; $blockheight = $hits * $verti_stretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "\n"; } echo "\n"; echo "

\n"; //anzahl der seiten ermitteln $sql = "SELECT COUNT(*) AS total FROM $dedicatside;"; $db->query($sql); $db->next_record(); $pagecount = $db->f('total'); //seiten durchlaufen echo "\n"; for ($pcount = 0; $pcount < $pagecount; $pcount++) { $sql = "SELECT * FROM $dedicatside ORDER BY idcat ASC LIMIT $pcount,1;"; $db->query($sql); while ($db->next_record()) { $idcatside = $db->f("idcatside"); $idside = $db->f("idside"); $idcat = $db->f("idcat"); } //categoriename auflsen $sql = "SELECT * FROM $dedicats WHERE idcat = '$idcat';"; $db->query($sql); while ($db->next_record()) { $catname = $db->f("name"); $catvisible = $db->f("visible"); } //seitenname auflsen $sql = "SELECT * FROM $dedisides WHERE idside = '$idside';"; $db->query($sql); while ($db->next_record()) { $pagename = $db->f("title"); $pageonline = $db->f("online"); } //hits fr aktuelle seite holen aber nur wenn categorie visible und side online if ($catvisible == 1 and $pageonline == 1) { $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE dedi_idcatside = '$idside' AND dedi_backend='no' AND info_date = '$thisday'".$sqlfilter.";"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); $blockwidth = $hits * $hori_stretch; if ($hits != 0) { echo "\n"; } } } ?> mrstats/output_thismonth.php100604 1750 310 7673 10242414305 12116 \n"; echo "\n"; for ($d = 1; $d <= 31; $d++) { if ($d < 10) {$d = '0'.$d;} $day = $d."-".$thismonth."-".$thisyear; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date = '$day' AND dedi_backend='no'".$sqlfilter.";"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); echo "\n"; } echo "
".$catname." -> ".$pagename."
".$hits." Seitenabrufe - klicken fr Details... ".$hits."
alle Daten ohne Robots/Spider fr diesen Monat: ".$thismonth."-".$thisyear." gelistet nach Tagen

"; $blockheight = $hits * $verti_stretch; echo $hits."
"; echo ""; echo "".$hits." Seitenabrufe - klicken um Details anzuzeigen..."; echo ""; echo "
".$d."

"; echo "
\n"; echo "

\n"; //anzahl der seiten ermitteln $sql = "SELECT COUNT(*) AS total FROM $dedicatside;"; $db->query($sql); $db->next_record(); $pagecount = $db->f('total'); //seiten durchlaufen $thismonth = "%".$thismonth."-".$thisyear; echo "\n"; for ($pcount = 0; $pcount < $pagecount; $pcount++) { $sql = "SELECT * FROM $dedicatside ORDER BY idcat ASC LIMIT $pcount,1;"; $db->query($sql); while ($db->next_record()) { $idcatside = $db->f("idcatside"); $idside = $db->f("idside"); $idcat = $db->f("idcat"); } //categoriename auflsen $sql = "SELECT * FROM $dedicats WHERE idcat = '$idcat';"; $db->query($sql); while ($db->next_record()) { $catname = $db->f("name"); $catvisible = $db->f("visible"); } //seitenname auflsen $sql = "SELECT * FROM $dedisides WHERE idside = '$idside';"; $db->query($sql); while ($db->next_record()) { $pagename = $db->f("title"); $pageonline = $db->f("online"); } //hits fr aktuelle seite holen aber nur wenn categorie visible und side online if ($catvisible == 1 and $pageonline == 1) { $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date LIKE '$thismonth' AND dedi_idcatside = '$idside' AND dedi_backend='no'".$sqlfilter.";"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); $blockwidth = $hits * $hori_stretch; if ($hits != 0) { $date = $datearray[0]."-".$datearray[1]; echo "\n"; } } } ?> mrstats/output_thisweek.php100604 1750 310 7353 10242414323 11717 \n"; echo "\n"; for ($d = 1; $d <= 7; $d++) { $day = $d."|".$thisweek."|%|".$thisyear; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_datestamp LIKE '$day' AND dedi_backend='no'".$sqlfilter.";"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); echo "\n"; } echo "
".$catname." -> ".$pagename."
".$hits." Seitenabrufe - klicken fr Details... ".$hits."
alle Daten fr diese Woche: ".$thisweek." nach Wochentagen beginnend mit Montag

"; $blockheight = $hits * $verti_stretch; echo $hits."
"; echo "".$hits." Seitenabrufe"; echo "
".$d."

"; echo "
\n"; echo "

\n"; //anzahl der seiten ermitteln $sql = "SELECT COUNT(*) AS total FROM $dedicatside;"; $db->query($sql); $db->next_record(); $pagecount = $db->f('total'); //seiten durchlaufen echo "\n"; $thisweek = "%|".$thisweek."|%|".$thisyear; for ($pcount = 0; $pcount < $pagecount; $pcount++) { $sql = "SELECT * FROM $dedicatside ORDER BY idcat ASC LIMIT $pcount,1;"; $db->query($sql); while ($db->next_record()) { $idcatside = $db->f("idcatside"); $idside = $db->f("idside"); $idcat = $db->f("idcat"); } //categoriename auflsen $sql = "SELECT * FROM $dedicats WHERE idcat = '$idcat';"; $db->query($sql); while ($db->next_record()) { $catname = $db->f("name"); $catvisible = $db->f("visible"); } //seitenname auflsen $sql = "SELECT * FROM $dedisides WHERE idside = '$idside';"; $db->query($sql); while ($db->next_record()) { $pagename = $db->f("title"); $pageonline = $db->f("online"); } //hits fr aktuelle seite holen aber nur wenn categorie visible und side online if ($catvisible == 1 and $pageonline == 1) { $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE dedi_idcatside = '$idside' AND info_datestamp LIKE '$thisweek' AND dedi_backend='no'".$sqlfilter.";"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); $blockwidth = $hits * $hori_stretch; if ($hits != 0) { echo "\n"; } } } ?> mrstats/output_thisyear.php100604 1750 310 7457 10242414345 11735 \n"; echo "\n"; for ($d = 1; $d <= 12; $d++) { if ($d < 10) {$d = '0'.$d;} $thismonth = "%-".$d."-".$thisyear; $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date LIKE '$thismonth' AND dedi_backend='no'".$sqlfilter.";"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); //echo $d." | ".$hits." | ".$sql."
"; echo "\n"; } echo "
".$catname." -> ".$pagename."
".$hits." Seitenabrufe - klicken fr Details ".$hits."
alle Daten ohne Robots/Spider fr dieses Jahr: ".$thisyear."

"; //echo $hits."
"; $blockheight = $hits * $verti_stretch; echo $hits."
"; echo ""; echo "".$hits." Seitenabrufe - klicken um Details anzuzeigen..."; echo ""; echo "
".$d."

"; echo "
\n"; echo "

\n"; //anzahl der seiten ermitteln $sql = "SELECT COUNT(*) AS total FROM $dedicatside;"; $db->query($sql); $db->next_record(); $pagecount = $db->f('total'); //seiten durchlaufen echo "\n"; for ($pcount = 0; $pcount < $pagecount; $pcount++) { $sql = "SELECT * FROM $dedicatside ORDER BY idcat ASC LIMIT $pcount,1;"; $db->query($sql); while ($db->next_record()) { $idcatside = $db->f("idcatside"); $idside = $db->f("idside"); $idcat = $db->f("idcat"); } //categoriename auflsen $sql = "SELECT * FROM $dedicats WHERE idcat = '$idcat';"; $db->query($sql); while ($db->next_record()) { $catname = $db->f("name"); $catvisible = $db->f("visible"); } //seitenname auflsen $sql = "SELECT * FROM $dedisides WHERE idside = '$idside';"; $db->query($sql); while ($db->next_record()) { $pagename = $db->f("title"); $pageonline = $db->f("online"); } //hits fr aktuelle seite holen aber nur wenn categorie visible und side online if ($catvisible == 1 and $pageonline == 1) { $sql = "SELECT COUNT(*) AS total FROM $deditable WHERE info_date LIKE '%$thisyear' AND dedi_idcatside = '$idside' AND dedi_backend='no'".$sqlfilter.";"; $db->query($sql); $db->next_record(); $hits = $db->f('total'); $blockwidth = $hits * $hori_stretch; if ($hits != 0) { echo "\n"; } } } ?> mrstats/test_meta.php100604 1750 310 3262 10242366464 10450 @Homepage http://www.der-dirigent.de about: general metafile access class for dediplugins how2use: set the dirname into the class name and constructor sample: dirname = /myplugin root_name = myplugin filename = 'myplugin_meta.php' classname = class myplugin_meta constructor = function myplugin_meta() ******************************************************************************/ /** * 1. Bentigte Funktionen und Klassen includieren */ include_once('inc/class.plugin_meta.php'); /** * 2. Eventuelle Actions/ Funktionen abarbeiten */ class test_meta extends plugin_meta{ /* * public */ /* * vars */ // general plugin configuration! /* * enable functions for each client as a singel plugin * this feature supports sql-statements for each client */ var $multi_client = false; /* * enable auto load of plugin settings on DeDi startup * this feature supports dedi_values with group_named settings * sample: * dirname = /myplugin * group_name = myplugin * $cfg_myplugin = array() * */ var $auto_settings = false; /* * enable this file for auto. Updates * this feature supports dedi 1.0 * */ var $auto_update = true; /* * simple set of the realname * sample: * dirname = /myplugin * root_name = myplugin * */ var $root_name = 'test'; /* * constructor */ function test_meta($call_files = false) { $this->dir_name = dirname(__FILE__); plugin_meta::plugin_init($call_files); } /* * extend functions */ } ?> mrstats/stat1.gif100604 1750 310 1455 10242366465 7500 GIF89a 3f3333f333ff3fffff3f3f̙3f3333f3333333333f3333333f3f33ff3f3f3f3333f3333333f3̙333333f333ff3ffffff3f33f3ff3f3f3ffff3fffffffffff3fffffff3fff̙ffff3fffff3f̙3333f33̙3ff3ffff̙f3f̙3f̙̙3f̙3f3333f333ff3fffff̙̙3̙f̙̙̙3f̙3f3f3333f333ff3fffff3f3f̙3f (((555CCCPPP]]]kkkxxx, H*\Ȱa€;mrstats/meta 40705 1750 310 0 10242366466 6602 5mrstats/meta/install.meta100777 1750 310 1665 10242407615 11230 #encode '{table_prefix}' with your Settings # Meneintrag ins backendmen hinzufgen INSERT INTO {table_prefix}backendmenu VALUES ('', 1, 0, 90, 'nav_mrstats', 'plugins/mrstats/index.php?is_frame_plugin=true', 'frame', '$perm->have_perm(\'area_plug_mrstats\')'); # Sprachstring fr Meneintrag INSERT INTO {table_prefix}values VALUES ('', 0, 0, 'lang', 'nav_mrstats', '', '', '', 'MR-Statistik', 0, NULL, NULL, 'txt', NULL, NULL, 0); # Access recht - Menpunkt unter Plugins-> dein Plugin wid angezeigt oder ausgeblendet INSERT INTO {table_prefix}values VALUES ('', 0, 0, 'user_perms', '{table_prefix}access', 'area_plug_mrstats', NULL, NULL, 'plug', 125, 'group_area_plug_mrstats', '', 'txt', NULL, NULL, 0); # Sprachstring fr Rechte (Haupteintrag) INSERT INTO {table_prefix}values VALUES ('', 0, 0, 'lang', 'group_area_plug_mrstats', '', '', '', 'Bereich Plugin / Darf MR-Statistik sehen', 0, NULL, NULL, 'txt', NULL, NULL, 0); mrstats/meta/uninstall.meta100777 1750 310 451 10242370710 11536 #encode '{table_prefix}' with your Settings # Meneintrag aus backendmen lschen DELETE FROM {table_prefix}backendmenu WHERE entry_langstring = 'nav_mrstats'; # Sprachstring fr Meneintrag lschen DELETE FROM {table_prefix}values WHERE key1 = 'nav_mrstats' AND value = 'MR-Statistik'; mrstats/meta/update.meta100777 1750 310 55 10242370710 10767 #encode '{table_prefix}' with your Settings mrstats/module 40705 1750 310 0 10242366467 7142 5mrstats/mrstats.dediplug100775 1750 310 1003 10242414400 11146 mrstats Tools 0.2 1 1116344261 1116344261 1 plug:c1da65ed41c55cd17c77794f5d8edc6c:67e932dd mrstats index.php mrstats/mrstats_meta.php100666 1750 310 24230 10242367223 11206 @Homepage http://www.der-dirigent.de about: general metafile access class for dediplugins how2use: set the dirname into the class name and constructor sample: dirname = /myplugin root_name = myplugin filename = 'myplugin_meta.php' classname = class myplugin_meta constructor = function myplugin_meta() ******************************************************************************/ class mrstats_meta { /* * public */ /* * vars */ // general plugin configuration! /* * enable functions for each client as a singel plugin * this feature supports sql-statements for each client */ var $multi_client = false; /* * enable auto load of plugin settings on DeDi startup * this feature supports dedi_values with group_named settings * sample: * dirname = /myplugin * group_name = myplugin * $cfg_myplugin = array() * */ var $auto_settings = false; /* * enable this file for auto. Updates * this feature supports dedi 1.0 * */ var $auto_update = true; /* * simple set of the realname * sample: * dirname = /myplugin * root_name = myplugin * */ var $root_name = 'mrstats'; // standart vars for local use var $cfg_client = ''; // containing the client vars var $cfg_dedi = ''; // containing the dedi vars var $is_unix = ''; // containing the OS identifer var $dedi_db = ''; // containing the db vars var $client = ''; // containing the client identifer var $perm = ''; // access 2 perm class var $lang = ''; // containing the lang identifer var $rep = ''; // access 2 repository class var $db = ''; // access 2 db class /* * constructor */ function mrstats_meta($call_files = false) { global $rep, $cfg_dedi, $db, $dedi_db, $cfg_client, $perm; $this->db = $db = new DB_dedi;; $this->rep = $rep; $this->perm = $perm; $this->lang = $this->perm->get_lang(); $this->client = $this->perm->get_client(); $this->dedi_db = $dedi_db; $this->is_unix = $this->check_os(); $this->cfg_dedi = $cfg_dedi; $this->cfg_client = $cfg_client; $this->_files = array( $this->_install => $this->_install, $this->_uninstall => $this->_uninstall, $this->_update => $this->_update, $this->_config => $this->_config, $this->_settings => $this->_settings, $this->_module => array( $this->_install => '3', $this->_uninstall => '5', $this->_update => '6', $this->_config => '7')); if ( $call_files === true ) $this->_call_files(); } /* * functions */ // general execute function install($order = '') { return $this->_what($this->_install, $order); } function uninstall($order = '') { return $this->_what($this->_uninstall, $order); } function update($order = '') { return $this->_what($this->_update, $order); } function config($order = '') { return $this->_what($this->_config, $order); } // general init settings function init_settings() { $order = $this->_settings; return $this->_init_settings($order); } // general get/set_vars function set($var, $val = '') { $this->$var = $val; return $this->get($var); } function get($var) { return $this->$var; } // general get file content function get_this($what, $order = '') { if ($order == '') $order = $this->_meta; return $this->_get($order, $what); } // general update file content function update_this($what, $string = '', $order = '') { if ($order == '') $order = $this->_meta; return $this->_update_file($order, $what, $string); } // some misc function version() { return $this->__version; } function multi_client() { return $this->multi_client; } function auto_settings() { return $this->auto_settings; } function check_os() { if (defined("PHP_OS") && strcmp(substr(PHP_OS,0,3),"WIN")) return false; elseif (strpos(getenv("OS"), "Win" ) >= 0) return false; return true; } /* * privat */ /* * vars */ var $__version = '1.2'; // version of this class var $__mode = array( // default mode set 'sql' => '1', 'php' => '2', 'xml' => '3', 'txt' => '4'); var $_uninstall = 'uninstall'; // varname of 'uninstall' script var $_install = 'install'; // varname of 'install' script var $_config = 'config'; // varname of 'config' script var $_update = 'update'; // varname of 'update' script var $_meta_ext = 'meta'; // varname of the metafile extension var $_xml_ext = 'dedimod'; // varname of the dedimodfile extension var $_settings = 'database'; // functionality of plugin settings (database = read settings from dB|settings = read settings from file) var $_module = 'module'; // functionality of module extraction var $_meta = 'meta'; // functionality of meta extraction var $_files = array(); // containing the additinal file information var $_modul_dir = '/module'; // varname of '/module' directory var $_meta_dir = '/meta'; // varname of '/meta' directory var $_dir = ''; // containing the name of local directory var $_xml = array(); // containing all xml Files /* * functions */ function _what($what, $order = '') { $return2 = true; if ($order == '') { $order = $this->_meta; $return2 = $this->_do($this->_module, $what); } if($return2) $return = $this->_do($order, $what); return $return; } function _call_files($dir = '', $mode=0777) { if ( $dir == '' ) $dir = $this->_meta_dir; $this->_dir = dirname(__FILE__) . $dir; if ( !is_dir( $this->_dir ) ) { if ($this->is_unix) { return ( $this->_call_files(dirname($this->_dir),$mode) and umask(000) and @mkdir( $this->_dir, $mode)); } else { return ( $this->_call_files(dirname($this->_dir),$mode) and @mkdir( $this->_dir, $mode)); } } else { $_dh = opendir ( $this->_dir ); while ( gettype ( $_file = readdir ( $_dh ) ) != 'boolean' ) { if ( is_readable ( $this->_dir."/$_file" ) ) { if ( ($_ext = substr ( strrchr( $_file, "." ), 1) ) == $this->_meta_ext) { $_name = str_replace ( '.'.$_ext,'', $_file ); $this->_files["$_name"] = array('file' => $_file, 'mode' => false); $_mode = strpos ($this->_get($this->_meta, $_name), '__mode['php'] : $this->__mode['sql']; $this->_files["$_name"]['mode'] = $_mode; } elseif ( ($_ext = substr ( strrchr( $_file, "." ), 1) ) == $this->_xml_ext) { $_name = str_replace ( '.'.$_ext,'', $_file ); $this->_files["$_name"] = array('file' => $_file, 'mode' => $this->__mode['xml'], 'name' => $_name); $this->_files[$this->_module]["$_name"] = $this->_files["$_name"]; $this->_xml[] = $this->_files["$_name"]; } } } } } function _do($order, $what) { $_dir = $order == $this->_meta ? $this->_meta_dir : $this->_modul_dir; $this->_call_files($_dir); if ($order == $this->_meta) { $_what = $this->_files["$what"]['mode']; $_source = $this->_get($order, $what); } elseif ($order == $this->_module) { $_what = $this->_files["$order"]["$what"]; $_source = $this->_get($order, 'all'); } switch ( $_what ) { case 1: return $this->rep->bulk_sql ($_source); break; case 2: return $this->rep->run_php ($_source); break; case 3: return $this->rep->bulk_mod_import($_source, 0); break; case 4: return $this->rep->print_txt ($_source); break; case 5: return $this->rep->uninstall_xml($_source); break; case 6: return $this->rep->update_xml ($_source); break; case 7: return true; break; } } function _get($order, $what = '') { $_dir = $order == $this->_meta ? $this->_meta_dir : $this->_modul_dir; if ($order == $this->_meta && $what != 'all') { return($this->rep->_file(dirname(__FILE__) . $_dir .'/'. $this->_files["$what"]['file'])); } elseif ($order == $this->_module && $what != 'all') { return($this->rep->_file(dirname(__FILE__) . $_dir .'/'. $this->_files["$what"]['file'])); } elseif ($order == $this->_module) { if (is_array($this->_xml)) foreach ($this->_xml as $_modul) { $_modul['xml'] = $this->rep->dedi_mod(($_modul['content'] = $this->rep->_file(dirname(__FILE__) . $_dir .'/'. $_modul['file']))); $_return[] = $_modul; } return $_return; } } function _update_file($order, $what, $string = '') { $_dir = $order == $this->_meta ? $this->_meta_dir : $this->_modul_dir; $this->_call_files($_dir); $_rebuild = false; $order_ext = '_'.$order.'ext'; if ( is_array($this->_files["$what"]) ) { $_file = $this->_files["$what"]['file']; } else { $_file = $this->_files["$what"].'.'.$this->$order_ext; $_rebuild = true; } if ( $string == '' ) { $return = $this->rep->_delete($this->_dir."/$_file"); $_rebuild = true; } else { $return = $this->rep->_write($this->_dir."/$_file", $string); } if ( $_rebuild === true ) $this->_call_files($_dir); return $return; } function _init_settings($order) { switch ($order) { case 'database': return $this->rep->_init_settings($this->root_name); break; case 'settings': return $this->get_this($order); break; } } } ?>
".$catname." -> ".$pagename."
".$hits." Seitenabrufe - klicken fr Details... ".$hits."