Zikula: A Flexible Open Source Content Management System
home | forum | contact us

Dizkus

Bottom
Resetting Site Statistics
  • Posted: 27.08.2003, 01:23
     
    rgasch
    rank:
    Professional Professional
    registered:
     January 2003
    Status:
    offline
    last visit:
    26.11.08
    Posts:
    568
    Hi,

    I doubt I'm the first guy to ask about this: does anybody know of an SQL script which will reset all PN site statistics? Seems like a useful thing when switching from development to a live site ...

    Greetings/Thanks
    --> R
  • Posted: 27.08.2003, 02:01
     
    rank:
    Moderator Moderator
    registered:
     March 2002
    Status:
    online
    Posts:
    7720
    Robert,

    The site stats are made of four tables stats_date, stats_hour, stats_month and stats_week -all with your DB prefix. I would use phpMyAdmin and then empty these tables. If your a command line type of person the mysql syntax to empty a table is TRUNCATE TABLE <tablename>

    -Mark</tablename>
  • Posted: 27.08.2003, 02:01
     
    Raleigh
    registered:
     June 2002
    Status:
    offline
    last visit:
    06.08.05
    Posts:
    572
    This is from the original SQL file that comes with .726

    Code

    # Table structure for table `nuke_counter`
    #

    DROP TABLE if EXISTS nuke_counter;
    CREATE TABLE nuke_counter (
      pn_type varchar(80) NOT null default '',
      pn_var varchar(80) NOT null default '',
      pn_count int(11) unsigned NOT null default '0'
    ) TYPE=MyISAM;

    #
    # Dumping data for table `nuke_counter`
    #

    INSERT INTO nuke_counter VALUES ('total', 'hits', 0);
    INSERT INTO nuke_counter VALUES ('browser', 'Lynx', 0);
    INSERT INTO nuke_counter VALUES ('browser', 'MSIE', 0);
    INSERT INTO nuke_counter VALUES ('browser', 'Opera', 0);
    INSERT INTO nuke_counter VALUES ('browser', 'Konqueror', 0);
    INSERT INTO nuke_counter VALUES ('browser', 'Netscape', 0);
    INSERT INTO nuke_counter VALUES ('browser', 'Bot', 0);
    INSERT INTO nuke_counter VALUES ('browser', 'Other', 0);
    INSERT INTO nuke_counter VALUES ('os', 'Windows', 0);
    INSERT INTO nuke_counter VALUES ('os', 'Linux', 0);
    INSERT INTO nuke_counter VALUES ('os', 'Mac', 0);
    INSERT INTO nuke_counter VALUES ('os', 'FreeBSD', 0);
    INSERT INTO nuke_counter VALUES ('os', 'SunOS', 0);
    INSERT INTO nuke_counter VALUES ('os', 'IRIX', 0);
    INSERT INTO nuke_counter VALUES ('os', 'BeOS', 0);
    INSERT INTO nuke_counter VALUES ('os', 'OS/2', 0);
    INSERT INTO nuke_counter VALUES ('os', 'AIX', 0);
    INSERT INTO nuke_counter VALUES ('os', 'Other', 0);
    # --------------------------------------------------------

    #
    # Table structure for table `nuke_stats_date`
    #

    DROP TABLE if EXISTS nuke_stats_date;
    CREATE TABLE nuke_stats_date (
      pn_date varchar(80) NOT null default '',
      pn_hits int(11) unsigned NOT null default '0'
    ) TYPE=MyISAM;

    #
    # Dumping data for table `nuke_stats_date`
    #

    INSERT INTO nuke_stats_date VALUES ('15062003', 0);
    # --------------------------------------------------------

    #
    # Table structure for table `nuke_stats_hour`
    #

    DROP TABLE if EXISTS nuke_stats_hour;
    CREATE TABLE nuke_stats_hour (
      pn_hour tinyint(2) unsigned NOT null default '0',
      pn_hits int(11) unsigned NOT null default '0'
    ) TYPE=MyISAM;

    #
    # Dumping data for table `nuke_stats_hour`
    #

    INSERT INTO nuke_stats_hour VALUES (0, 0);
    INSERT INTO nuke_stats_hour VALUES (1, 0);
    INSERT INTO nuke_stats_hour VALUES (2, 0);
    INSERT INTO nuke_stats_hour VALUES (3, 0);
    INSERT INTO nuke_stats_hour VALUES (4, 0);
    INSERT INTO nuke_stats_hour VALUES (5, 0);
    INSERT INTO nuke_stats_hour VALUES (6, 0);
    INSERT INTO nuke_stats_hour VALUES (7, 0);
    INSERT INTO nuke_stats_hour VALUES (8, 0);
    INSERT INTO nuke_stats_hour VALUES (9, 0);
    INSERT INTO nuke_stats_hour VALUES (10, 0);
    INSERT INTO nuke_stats_hour VALUES (11, 0);
    INSERT INTO nuke_stats_hour VALUES (12, 0);
    INSERT INTO nuke_stats_hour VALUES (13, 0);
    INSERT INTO nuke_stats_hour VALUES (14, 0);
    INSERT INTO nuke_stats_hour VALUES (15, 0);
    INSERT INTO nuke_stats_hour VALUES (16, 0);
    INSERT INTO nuke_stats_hour VALUES (17, 0);
    INSERT INTO nuke_stats_hour VALUES (18, 0);
    INSERT INTO nuke_stats_hour VALUES (19, 0);
    INSERT INTO nuke_stats_hour VALUES (20, 0);
    INSERT INTO nuke_stats_hour VALUES (21, 0);
    INSERT INTO nuke_stats_hour VALUES (22, 0);
    INSERT INTO nuke_stats_hour VALUES (23, 0);
    # --------------------------------------------------------

    #
    # Table structure for table `nuke_stats_month`
    #

    DROP TABLE if EXISTS nuke_stats_month;
    CREATE TABLE nuke_stats_month (
      pn_month tinyint(2) unsigned NOT null default '0',
      pn_hits int(11) unsigned NOT null default '0'
    ) TYPE=MyISAM;

    #
    # Dumping data for table `nuke_stats_month`
    #

    INSERT INTO nuke_stats_month VALUES (1, 0);
    INSERT INTO nuke_stats_month VALUES (2, 0);
    INSERT INTO nuke_stats_month VALUES (3, 0);
    INSERT INTO nuke_stats_month VALUES (4, 0);
    INSERT INTO nuke_stats_month VALUES (5, 0);
    INSERT INTO nuke_stats_month VALUES (6, 0);
    INSERT INTO nuke_stats_month VALUES (7, 0);
    INSERT INTO nuke_stats_month VALUES (8, 0);
    INSERT INTO nuke_stats_month VALUES (9, 0);
    INSERT INTO nuke_stats_month VALUES (10, 0);
    INSERT INTO nuke_stats_month VALUES (11, 0);
    INSERT INTO nuke_stats_month VALUES (12, 0);
    # --------------------------------------------------------

    #
    # Table structure for table `nuke_stats_week`
    #

    DROP TABLE if EXISTS nuke_stats_week;
    CREATE TABLE nuke_stats_week (
      pn_weekday tinyint(1) unsigned NOT null default '0',
      pn_hits int(11) unsigned NOT null default '0'
    ) TYPE=MyISAM;

    #
    # Dumping data for table `nuke_stats_week`
    #

    INSERT INTO nuke_stats_week VALUES (0, 0);
    INSERT INTO nuke_stats_week VALUES (1, 0);
    INSERT INTO nuke_stats_week VALUES (2, 0);
    INSERT INTO nuke_stats_week VALUES (3, 0);
    INSERT INTO nuke_stats_week VALUES (4, 0);
    INSERT INTO nuke_stats_week VALUES (5, 0);
    INSERT INTO nuke_stats_week VALUES (6, 0);
  • Posted: 27.08.2003, 02:03
     
    Raleigh
    registered:
     June 2002
    Status:
    offline
    last visit:
    06.08.05
    Posts:
    572
    Or what mark said... lol...
  • Posted: 27.08.2003, 04:50
     
    Infopro
    rank:
    Professional Professional
    registered:
     December 1969
    Status:
    offline
    last visit:
    17.06.04
    Posts:
    2122
    LOL. More than one way to skin a cat, err, dump the data. :)

    --
    Friends rock, bullshit walks
  • Posted: 27.08.2003, 11:27
     
    rank:
    Professional Professional
    registered:
     April 2002
    Status:
    offline
    last visit:
    24.11.08
    Posts:
    716
    Do not TRUNCATE the tables, but fill them with the zeros -- otherwise your stats won't work...
  • Posted: 27.08.2003, 13:17
     
    rgasch
    rank:
    Professional Professional
    registered:
     January 2003
    Status:
    offline
    last visit:
    26.11.08
    Posts:
    568
    Thanks for the quick and complete answer ....

    Greetings
    ---> R
  • Posted: 27.08.2003, 13:47
     
    kaffeeringe.de
    rank:
    Professional Professional
    registered:
     September 2002
    Status:
    offline
    last visit:
    19.11.08
    Posts:
    879
    @rgasch: Jetzt bin ich aber ein bißchen enttäuscht, daß Du die Lösung nicht schon bei uns in der FAQ gefunden hast: http://www.post-nuke.net/FAQ+inc-^myfaq-yes-id_cat-7.html#49

    icon_wink

    --
    best regards from Kiel, sailing city

    Steffen Voss

    Member of the PostNuke Steering Committee
    Read The Zikulan's Blog
  • Posted: 28.08.2003, 00:10
     
    rgasch
    rank:
    Professional Professional
    registered:
     January 2003
    Status:
    offline
    last visit:
    26.11.08
    Posts:
    568
    @ArschMitOhren: tut mir leid dass ich dich entta"uscht habe. Nach 9 Monaten intensiver PN-Beta"tigung mit zahllosen Website-Besuchen (ich spreche 5 Sprachen mehr oder weniger fliessend, habe mir also auch viele nicht-deutsche PN Sites reingezogen) wusste ich nicht mehr wo ich es gesehen hatte (und konnte es im Dschungel meiner Bookmarks auch nicht mehr finden) ...

    Notiz: vor dem Stellen einer blo"den Frage, erst die Deutsche FAQ lesen ... icon_smile

    Grus/Danke
    --> R
  • Posted: 28.08.2003, 16:19
     
    kaffeeringe.de
    rank:
    Professional Professional
    registered:
     September 2002
    Status:
    offline
    last visit:
    19.11.08
    Posts:
    879
    :wink: Wir geben uns echt Mühe solche Sachen zusammen zu tragen. Aber auf Deine Anfrage hier, hab ich den entsprechenden Handbuch-Eintrag mal auf den aktuellsten Stand gebracht :wink:

    --
    best regards from Kiel, sailing city

    Steffen Voss

    Member of the PostNuke Steering Committee
    Read The Zikulan's Blog

Extensions Moderation

Main Menu

Extensions Database

Documentation

Development

Login

Donate to Zikula