Statistik geht nicht richtig!

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

⏪ vorheriges - nächstes ⏩

0 Mitglieder und 1 Gast betrachten dieses Thema.

Marty

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


FrankySZ

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

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

Danke hast mir geholfen
jtzt funzt es

Marty

wo -00- ?????
Jetzt stehen ausserdem schon in Tagen, die noch nicht waren, dass 1 zugriff wahr.

JensWagenknecht

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

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

Merkwürdig.
Aber was geht es mich an.

Jens

Marty

Ä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

Nicht nur Doppelt,bei dir sin sogar einige tage 3-fach.
Vieleicht kannst du sie ,die zuviel sind
einfach aus deiner datenbank rausschmeissen.

Andi

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

kannscht mir mal den genauen namen der Tab. geben?????

Marty


Excalibur100

Hallo Marty,

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

nuke_stats_date

Marty

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

Lösche die Tabelle nuke_stats_year und lege sie neu an:

 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

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

HAAALLLLOOOO, kann mir jemand helfen. Ich will schliesslich nicht jeden Tag von neuem die Tables löschen und neu machen,

tias

komisch, aber der fehler tritt auch bei euren statistiken auf.. da sind auch einige tage und monate doppelt und dreifach :(

DarkBoy

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 !