Advanced search  

News:

cpg1.5.46 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter recently discovered vulnerabilities. It is important that all users who run version cpg1.5.44 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 59488 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.033 seconds with 21 queries.