Statistik geht nicht richtig!

Begonnen von Marty, 08 Juni 2002, 17:12:50

⏪ vorheriges - nächstes ⏩

0 Mitglieder und 1 Gast betrachten dieses Thema.

Drucken
Nach unten Seiten1 2 Alle
Benutzer-Aktionen

Marty

08 Juni 2002, 17:12:50
So sieht meine Statsdetail seite aus:

<i>
Der meistbesuchte Monat: ( Hits)
Der meistbesuchte Tag: ( Hits)<br>

Jahresstatistik

Jahr Seitenzugriffe
2002  
(16593)



Monatliche Statistik für 2002

Monat Seitenzugriffe



Tagesstatistik für Juni, 2002

Datum Seitenzugriffe



 :cry :cry :cry :cry :cry :cry :cry :cry :cry :cry :cry :cry :cry :cry :cry :cry :cry

sellplanet

#1
08 Juni 2002, 17:15:53
Stimmt bei mir auch!

FrankySZ

#2
08 Juni 2002, 17:25:38
Hi,
dazu gab es in dem letzten Update zum vkp extra ne updatesql.

Aber am schnellsten gehts wohl so:

Fuegt bitte ueber phpMyadmin die folgenden Daten in eure Datenbank ein.

ZitatDROP TABLE IF EXISTS nuke_stats_date;
CREATE TABLE nuke_stats_date (
  year smallint(6) NOT NULL default '0',
  month tinyint(4) NOT NULL default '0',
  date tinyint(4) NOT NULL default '0',
  hits bigint(20) NOT NULL default '0'
) TYPE=MyISAM;


INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 1, 31, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 2, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 3, 31, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 4, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 5, 31, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 6, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 7, 31, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 8, 31, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 9, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 10, 31, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 11, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 1, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 2, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 3, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 4, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 5, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 6, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 7, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 8, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 9, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 10, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 11, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 12, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 13, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 14, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 15, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 16, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 17, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 18, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 19, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 20, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 21, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 22, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 23, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 24, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 25, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 26, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 27, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 28, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 29, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 30, 1);
INSERT INTO nuke_stats_date (year, month, date, hits) VALUES (2002, 12, 31, 1);



DROP TABLE IF EXISTS nuke_stats_month;
CREATE TABLE nuke_stats_month (
  year smallint(6) NOT NULL default '0',
  month tinyint(4) NOT NULL default '0',
  hits bigint(20) NOT NULL default '0'
) TYPE=MyISAM;



INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 1, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 2, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 3, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 4, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 5, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 6, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 7, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 8, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 9, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 10, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 11, 1);
INSERT INTO nuke_stats_month (year, month, hits) VALUES (2002, 12, 1);


Dann sollte alles klappen.
greets Franky

soxin

#3
08 Juni 2002, 17:54:17
Mit einer -00- geht es meist besser! Für was gibts den liesmich.txt dateien oder wie die dinger immer heißen!  :cool:[Bearbeitet am: 8/6/2002 von soxin]

sellplanet

#4
08 Juni 2002, 17:59:54
Danke hast mir geholfen
jtzt funzt es

Marty

#5
09 Juni 2002, 13:10:39
wo -00- ?????
Jetzt stehen ausserdem schon in Tagen, die noch nicht waren, dass 1 zugriff wahr.

JensWagenknecht

#6
09 Juni 2002, 13:30:28
Ich nehme AWSTATS.
Ist allerdings kein Modul von PHPNuke.

Das Teil ist einfach Super.

Hier wies ich ebend nicht wie realistisch gezählt wird.  
Auch kann man die eigene IP nicht ausschließen. Ich schaue am Tag 100 mal nach und habe einen Super Zugriff.

Jens

hier kann man sich das Teil mal anschauen:

http://awstats.sourceforge.net/cgi-bin/awstats.pl

läuft halt nicht in PHPNuke, aber ich denke das der kleine Rahmen in einem Modul auch nichts wäre.

Jens

FrankySZ

#7
09 Juni 2002, 15:13:27
Hi Marty
 das -00-  ist nen smilie fuer ne Brille :)

Die Einereintraege lassen sich nicht vermeiden da sonst manche Datenbanken (providerabhaengig) nicht kapieren wo sie was eintragen sollen...
@Jens Da die Statistiken eh nur die Seitenzugriffe wiederspiegeln und nicht die tatsaechlich Besucherzahl (das macht bei uns der flashcounter) denke ich mal, dass nen Ausschluss der eigenen IP hier wohl nicht noetig ist....
greets Franky

JensWagenknecht

#8
09 Juni 2002, 16:09:17
Merkwürdig.
Aber was geht es mich an.

Jens

Marty

#9
13 Juni 2002, 13:42:47
Ähm. Schaut euch mal bitte meine Statistik seite an. Da sind tage doppelt usw. wie kann ich das beheben?

 http://www.taekwondoforum.de/modules.php?name=maaXStat2&op=Stats

Also wie gesagt sind einige Bugs drin. KANN MIR JEMAND HELFEN???

sellplanet

#10
13 Juni 2002, 13:58:07
Nicht nur Doppelt,bei dir sin sogar einige tage 3-fach.
Vieleicht kannst du sie ,die zuviel sind
einfach aus deiner datenbank rausschmeissen.

Andi

#11
13 Juni 2002, 14:23:41
Hi,

das Einfachste, du löschst alle Datensätze aus der Tabelle und fügst den Dump von Franky nochmal ein. Aber ohne die Drop-Table Befehle.

Fängt halt alles bei 0 an :(
schön´s Grüssle, Andi

Marty

#12
13 Juni 2002, 15:02:37
kannscht mir mal den genauen namen der Tab. geben?????

Marty

#13
16 Juni 2002, 12:18:57
Haaaaalllloooo

Excalibur100

#14
16 Juni 2002, 12:35:28
Hallo Marty,

also auf die Frage sollte man normalerweise nicht antworten, da es ja oben bei Franky schon drin steht:

nuke_stats_date

Marty

#15
16 Juni 2002, 21:20:58
Die Jahresstatistik siehjt abor leider noch so aus:

Jahr Seitenzugriffe
2002  
(18609)
2002  
(1331)
2002  
(1331)
2002  
(1331)
2002  
(1331)
2002  
(1331)
2002  
(1331)
2002  
(1331)
2002  
(1331)

Andi

#16
17 Juni 2002, 01:16:29
Lösche die Tabelle nuke_stats_year und lege sie neu an:

 
Code Auswählen
DROP TABLE IF EXISTS nuke_stats_year;
CREATE TABLE nuke_stats_year (
  year smallint(6) NOT NULL default '0',
  hits bigint(20) NOT NULL default '0'
) TYPE=MyISAM;
schön´s Grüssle, Andi

Marty

#17
17 Juni 2002, 22:40:21
So, nach den paar Tagen in denen es gefunzt hat, sind jetzt wieder einige Tage doppelt bzw. glaube auch dreifach. Kanns sein das da ein fehler im script is( hab nichts verändert!!!)

Marty

#18
18 Juni 2002, 23:37:15
HAAALLLLOOOO, kann mir jemand helfen. Ich will schliesslich nicht jeden Tag von neuem die Tables löschen und neu machen,

tias

#19
03 Juli 2002, 10:12:56
komisch, aber der fehler tritt auch bei euren statistiken auf.. da sind auch einige tage und monate doppelt und dreifach :(

DarkBoy

#20
03 Juli 2002, 14:51:34
HI
 das wissen wir leider und arbeiten bereits an einer neuen STATS :)  leider passiert das jedesmal  wenn sich nen sql server  verabschiedet dann  nach dem reset ist der fehler da !

Einen Ansatz warum haben wir leider nicht !
Drucken
Nach oben Seiten1 2 Alle
Benutzer-Aktionen