François Keller 
Dev Team member
Gender: 
 France
Posts: 7369
aka Frantz
|
 |
« on: November 12, 2006, 02: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.0It 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 VersionVersion 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, 06: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
Gender:
France
Posts: 1319
aka "Lontano"
|
 |
« Reply #1 on: November 12, 2006, 03:21:34 pm » |
|
Nice, easy and useful! Good work Fratz!
Italian lang file attached
|
|
|
|
Logged
|
|
|
|
rphMedia
Contributor
Gender:
 United States
Posts: 509
***muvipix.com***
|
|
« Reply #2 on: November 12, 2006, 03: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.
|
|
|
|
|
Logged
|
|
|
|
François Keller
Dev Team member
Gender:
France
Posts: 7369
aka Frantz
|
|
« Reply #3 on: November 12, 2006, 03: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
Gender:
United States
Posts: 509
***muvipix.com***
|
|
« Reply #4 on: November 12, 2006, 03:42:43 pm » |
|
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 - 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) |
|
|
|
|
Logged
|
|
|
|
|
Nibbler
|
 |
« Reply #5 on: November 12, 2006, 03:59:20 pm » |
|
|
|
|
|
|
Logged
|
I don't care about what they say, I won't live or die that way.
|
|
|
rphMedia
Contributor
Gender:
United States
Posts: 509
***muvipix.com***
|
|
« Reply #6 on: November 12, 2006, 04:06:18 pm » |
|
That did it, thanks Nibbler. |
|
|
|
|
Logged
|
|
|
|
François Keller
Dev Team member
Gender:
France
Posts: 7369
aka Frantz
|
|
« Reply #7 on: November 12, 2006, 05: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.0demoSee stats_1_1.zip attached on the very first post |
|
|
|
« Last Edit: November 17, 2006, 06: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
Gender:
United States
Posts: 509
***muvipix.com***
|
|
« Reply #8 on: November 12, 2006, 05:50:46 pm » |
|
Works good out-of-the-box !!
|
|
|
|
|
Logged
|
|
|
|
Hein Traag
Dev Team member
Gender:
 Netherlands
Posts: 2153
A, B, Cpg
|
|
« Reply #9 on: November 18, 2006, 04:53:55 pm » |
|
Thanks Frantz! Dutch lang file attached  Cheers! Hein updated dutch.php - <dutch> Tekst klopt nu beter bij de statistiek </dutch> |
|
|
« Last Edit: November 19, 2006, 08:59:17 pm by Hein »
|
Logged
|
|
|
|
François Keller
Dev Team member
Gender:
France
Posts: 7369
aka Frantz
|
|
« Reply #10 on: November 18, 2006, 06: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 |
|
|
|
|
rphMedia
Contributor
Gender:
United States
Posts: 509
***muvipix.com***
|
|
« Reply #12 on: November 19, 2006, 07:21:42 pm » |
|
"25976 files in 294 albums and 37 categories with 13930 comments viewed 7348911 times"  I'm guessing that you have too many stats ! It's timing out. |
|
|
|
|
Logged
|
|
|
|
docgonzo
Coppermine novice
Posts: 30
|
|
« Reply #13 on: November 19, 2006, 07: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
Gender:
France
Posts: 7369
aka Frantz
|
|
« Reply #14 on: November 19, 2006, 07: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
Posts: 30
|
|
« Reply #15 on: November 19, 2006, 07: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
|
|
|
|
|
Nibbler
|
|
« Reply #16 on: November 19, 2006, 07:54:53 pm » |
|
|
|
|
|
|
Logged
|
I don't care about what they say, I won't live or die that way.
|
|
|
docgonzo
Coppermine novice
Posts: 30
|
|
« Reply #17 on: November 19, 2006, 08:01:32 pm » |
|
Tried those, but all i get is 'The selected album does not exist'
|
|
|
|
|
Logged
|
|
|
|
|
Nibbler
|
|
« Reply #18 on: November 19, 2006, 08: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
|
I don't care about what they say, I won't live or die that way.
|
|
|
Hein Traag
Dev Team member
Gender:
Netherlands
Posts: 2153
A, B, Cpg
|
|
« Reply #19 on: November 19, 2006, 08:57:54 pm » |
|
Frantz. Updated dutch.php a bit. Attached file to my previous post.
Cheers!
Hein
|
|
|
|
|
Logged
|
|
|
|
|
