Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1] 2 3   Go Down

Author Topic: Stats: Gallery statistics by date  (Read 67386 times)

0 Members and 1 Guest are viewing this topic.

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9097
  • aka Frantz
    • Ma galerie
Stats: Gallery statistics by date
« on: November 12, 2006, 03:03:00 pm »

Stats: Gallery statistics by date

This plugin is an adaptation from Nibblers Mod http://forum.coppermine-gallery.net/index.php?topic=34858.0

It add a new menu button for opening a statistic page.

INSTALL:
- unzip package to plugins folder and use plugin manager to install it



LANGUAGE:
english.php italian.php (thank's Lontano) and french.php are avaible in the package. Feel free to translate in your language

New Version
Version 1.1:
-Adding some others stats inspired by Pslawinsky's Mod http://forum.coppermine-gallery.net/index.php?topic=23945.0
-Adding dutch.php lang file (Thank's Hein)
-adding german.php lang file (Thank's M@rk)
-adding spanish.pgp lang file (Thank's Just_some_guy)
« Last Edit: October 02, 2007, 07:56:37 am by Frantz »
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

Davide Renda

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1427
  • aka "Lontano"
    • www.daviderenda.eu
Re: Stats: Gallery statistics by date
« Reply #1 on: November 12, 2006, 04:21:34 pm »

Nice, easy and useful! Good work Fratz!
Italian lang file attached

rphMedia

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 515
  • ***muvipix.com***
    • muvipix - Music | Video | Pictures
Re: Stats: Gallery statistics by date
« Reply #2 on: November 12, 2006, 04:26:01 pm »

Nice work, Frantz (I tried to + Karma and hit smite by accident - I'll be back).

I can toggle the year (2006), but if I try to open any month I get the error processing a database query (2 test sites).  I'll see if I can get more info.

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9097
  • aka Frantz
    • Ma galerie
Re: Stats: Gallery statistics by date
« Reply #3 on: November 12, 2006, 04:32:14 pm »

@lontano
Thank's for your contrib (it will be added in the pack)
@rphMedia
What is the error message ? I've no problem on my site (see here)
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

rphMedia

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 515
  • ***muvipix.com***
    • muvipix - Music | Video | Pictures
Re: Stats: Gallery statistics by date
« Reply #4 on: November 12, 2006, 04:42:43 pm »

Quote from: Frantz
I've no problem on my site (see here)

Ahh, but you do - not as severe.  Somewhere in your javascript (both IE & FF).

Here's the message I get -

Quote
While executing query "SELECT DAY(msg_date) AS period, COUNT(*) AS number
            FROM cpg146_comments
            WHERE YEAR(msg_date) = 2006
            AND MONTH(msg_date) = 10
            GROUP BY period
            ORDER BY period DESC" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '(msg_date) AS period, COUNT(*) AS number
            FROM cpg146_comme

Also -
...gallery/include/functions.inc.php - Line: 249 (this is an unmodified file)



Nibbler

  • Guest
Re: Stats: Gallery statistics by date
« Reply #5 on: November 12, 2006, 04:59:20 pm »

Logged

rphMedia

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 515
  • ***muvipix.com***
    • muvipix - Music | Video | Pictures

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9097
  • aka Frantz
    • Ma galerie
Re: Stats: Gallery statistics by date
« Reply #7 on: November 12, 2006, 06:16:42 pm »

@Nibbler
@rphMedia,
Ok I've correct the code (in version 1.1)

@ All, I've made a new version(1.1) of this plugin, adding some others stats inspired by Pslawinsky's code http://forum.coppermine-gallery.net/index.php?topic=23945.0
demo
See stats_1_1.zip attached on the very first post
« Last Edit: November 17, 2006, 07:27:16 am by Frantz »
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

rphMedia

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 515
  • ***muvipix.com***
    • muvipix - Music | Video | Pictures
Re: Stats: Gallery statistics by date
« Reply #8 on: November 12, 2006, 06:50:46 pm »

Works good out-of-the-box !!

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: Stats: Gallery statistics by date
« Reply #9 on: November 18, 2006, 05:53:55 pm »

Thanks Frantz!
Dutch lang file attached ;)

Cheers!
Hein

Quote
updated dutch.php - <dutch> Tekst klopt nu beter bij de statistiek </dutch>
« Last Edit: November 19, 2006, 09:59:17 pm by Hein »
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9097
  • aka Frantz
    • Ma galerie
Re: Stats: Gallery statistics by date
« Reply #10 on: November 18, 2006, 07:14:47 pm »

Thank's Hein,

Original pack updated in the first post with duch lang file
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

docgonzo

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 30
Re: Stats: Gallery statistics by date
« Reply #11 on: November 19, 2006, 06:11:56 pm »

I installed this plugin, but cannot get it to work...
It loads the page for about half a minute, and then displays a blank page.

Check http://www.docgonzo.com/index.php?file=stats/stats
Logged

rphMedia

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 515
  • ***muvipix.com***
    • muvipix - Music | Video | Pictures
Re: Stats: Gallery statistics by date
« Reply #12 on: November 19, 2006, 08:21:42 pm »

"25976 files in 294 albums and 37 categories with 13930 comments viewed 7348911 times"  :o

I'm guessing that you have too many stats !  It's timing out.

docgonzo

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 30
Re: Stats: Gallery statistics by date
« Reply #13 on: November 19, 2006, 08:45:35 pm »

lol, that could be it...
Although, when i use the stats mod that i found floating around, it does kinda work...
(think it was a mod for this plugin, have searched for the exact location, but can't seem to find it again, i'm talking about stats.zip)
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9097
  • aka Frantz
    • Ma galerie
Re: Stats: Gallery statistics by date
« Reply #14 on: November 19, 2006, 08:51:01 pm »

This plugin is a mix from two Mods, see links in the first post of this thread
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

docgonzo

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 30
Re: Stats: Gallery statistics by date
« Reply #15 on: November 19, 2006, 08:53:02 pm »

This plugin is a mix from two Mods, see links in the first post of this thread
I'm using stats1_1.zip atm
Logged

docgonzo

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 30
Re: Stats: Gallery statistics by date
« Reply #17 on: November 19, 2006, 09:01:32 pm »

Tried those, but all i get is 'The selected album does not exist'
Logged

Nibbler

  • Guest
Re: Stats: Gallery statistics by date
« Reply #18 on: November 19, 2006, 09:37:17 pm »

You cannot possibly get that message by using the code I posted, since the code does not contain the message in the first place.
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: Stats: Gallery statistics by date
« Reply #19 on: November 19, 2006, 09:57:54 pm »

Frantz. Updated dutch.php a bit. Attached file to my previous post.

Cheers!
Hein
Logged
Pages: [1] 2 3   Go Up
 

Page created in 0.023 seconds with 20 queries.