SQL Capabilities?
mike.hobo - June 16, 2008 - 06:55
I am trying to create a module maybe, or just a page. And I'm wondering what my reach is with SQL.
What I want to do is create a graphs, that will change daily. It will take the # of hits a node gets each day, and then turns that into static content or something. Then the next day it does the same thing. So it would create a linear graph. And then maybe to take it further.
And then just show the hits for the day. (by subtracting out all previous day hits.)
I'm not too good with SQL, or logical thinking at that, but I'm just looking for assistance in writing up a new page or something.
you might want to check out
you might want to check out the webalizer module - but its for 5.x
http://drupal.org/project/webalizer
i also came across this blogpost on integrating statcounter (a 3rd party service) into drupal
http://therning.org/niklas/node/8
you might also want to try Google Analytics - you can easily integrate it by cutting and pasting Analytics code into a drupal block.
Thanks for the response, but
Thanks for the response, but I don't know if this is quite right. What I'm trying to achieve is to be able to show the data to the node authors. So they can get insights into their nodes stats.