Views: 2,762
New Zenner
I would like to view the entire stored counter history... where can I find these numbers?
Brad Smith, Serigraph Printer
https://www.RickRushArt.com
New Zenner
is in the database. easy to find as it has its own section.
New Zenner
I can't find it, could you be more specific as to its location?
Brad Smith, Serigraph Printer
https://www.RickRushArt.com
New Zenner
Bumping this... I'm trying to put together a report of the hits and views, I just need to know where to find where the numbers are stored.
Brad Smith, Serigraph Printer
https://www.RickRushArt.com
Sensei
In your database there's a table with a moderately intuitive name: "counter_history", which stores hit/session counts per day
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
I'm still learning, here. Can I access the table through the Admin page, or do I have to access the database by a remote SQL (like FTP?)?
Brad Smith, Serigraph Printer
https://www.RickRushArt.com
Sensei
No, you cannot use FTP. You would need to use a MySQL front-end tool like phpMyAdmin or write custom PHP code to access it.
Perhaps more important is the "why" behind your inquiry. What exactly are you wanting to do?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
I'm going to be recording the numbers onto a Line Chart in Word so that I can have some documentation of the growth trend. The Admin page records the last 7 days, but I read that it keeps the past year in its base... so I want to record all of those numbers.
Brad Smith, Serigraph Printer
https://www.RickRushArt.com
Sensei
Probably best to use phpMyAdmin (likely comes with your hosting control panel) to access the raw data.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
Why don't you use the Google Analytics Module?
Google Analytics can keep track of all your hits, which pages were viewed the most, what region people visited from, and tons of other cool stuff. For more information on what Google Anaylics can do check out their site.
Jaret
SalvationArmy.ca/store
New Zenner
BradSmith:
The Admin page records the last 7 days, but I read that it keeps the past year in its base... so I want to record all of those numbers.
Howdy all!
Read this looking for those past numbers myself and just did this to my page:
$counter_query = "select startdate, counter, session_counter from " . TABLE_COUNTER_HISTORY . " order by startdate DESC limit 10";
Change the "10" to "365" or however many dates you want displayed. Granted your page will be longer, sure... but at least you get the past year's worth of counter info easily.
You can also put it into an iFrame to keep the page short. Or, for that matter, a textarea box.
Good luck!
Jake
Tell staff why this post should be reviewed.