pragmaMx Support Forum

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

Stimmt bei mir auch!

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.

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]

Danke hast mir geholfen
jtzt funzt es

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

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

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....

Merkwürdig.
Aber was geht es mich an.

Jens

Ä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???

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

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 :(

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

Haaaaalllloooo

Hallo Marty,

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

nuke_stats_date

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)

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;


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!!!)

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

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

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 !