I've no problem on my site (see here)
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
See http://forum.coppermine-gallery.net/index.php?topic=34858.msg172530#msg172530 in the original thread.
updated dutch.php - <dutch> Tekst klopt nu beter bij de statistiek </dutch>
This plugin is a mix from two Mods, see links in the first post of this threadI'm using stats1_1.zip atm
Updated dutch.php a bit. Attached file to my previous post.Added in the original pack
Is it possible to enhance the plugin to included how many visitors there were per day including where they came from (IP or country flags etc..) ?Not sure, i must look if the data's are stored in the database.
...
FROM {$cpg_udb->usertable}
...
$result = cpg_db_query($sql, $cpg_udb->link_id);/plugins/stats/include/init.inc.php
* Notice line 20: Undefined variable: CONFIGif (file_exists("plugins/stats/lang/{$CONFIG['lang']}.php")) {
ist it possible to hide the link in the menu for guest and members and show it only for admins.Yes, in codebase.php change
function stats_page_start()
{
global $template_sys_menu, $template_sys_menu_spacer, $template_sys_menu_button, $sys_menu_buttons;
global $CONFIG, $lang_plugin_stats;
require ('plugins/stats/include/init.inc.php');
stats_add_admin_button('index.php?file=stats/stats',$lang_plugin_stats['menu_link'],$lang_plugin_stats['menu_link'],$lang_plugin_stats['menu_link']);
}tofunction stats_page_start()
{
global $template_sys_menu, $template_sys_menu_spacer, $template_sys_menu_button, $sys_menu_buttons;
global $CONFIG, $lang_plugin_stats;
require ('plugins/stats/include/init.inc.php');
if (USER_IS_ADMIN){
stats_add_admin_button('index.php?file=stats/stats',$lang_plugin_stats['menu_link'],$lang_plugin_stats['menu_link'],$lang_plugin_stats['menu_link']);
}
}