ExtraStats Plugin 2.0.0 Released

Version 2.0.0 is now available in the plugin area. Cost $45.

If you are upgrading:

When upgrading from version 1.x please overwrite your templates as they have changed and there is one extra. After this, you can modify both the graphs and the list as much as you want - I will really try not to alter the code that they use!

Note that to call the graphs, the order of the variables has changed so you will need to update any tags that you have used within your site.

There is quite a lot of changing to the structure of the plugin's tables going on in this upgrade. If you have any problems please get in touch. In particular, I am aware that there may be a problem adding the foreign key relation - if it has not worked in your upgrade it will only show up as a problem when you try to print the lists of top links - there is an easy fix.



Please see this thread for a discussion of version 1 of this plugin:

http://www.gossamer-threads.com/...i?post=221261#221261

Features

• Available statistics for printing
  • daily hits or monthly hits
  • for each link in your database or for all links
  • include all hits or unique hits. Unique hits are now daily uniques - i.e. a hit is only counted as unique if that person has not clicked on the link within the last 24 hours.
• Print graphs as shown above
  • all links or a particular link
  • all hits or unique hits
  • daily or monthly
  • set the month and year
• List of the tops links
  • daily or monthly
  • sort by all hits or unique hits
  • all links tags available so you can display the list as you want.

Hi,

after upgrading the plugin doesn't work right anymore:

A fatal error has occured:

Can't call method "fetchrow_array" on an undefined value at /var/www/cgi-bin/shop/admin/Plugins/ExtraStats.pm line 174.

Please enable debugging in setup for more details. OK

GT::SQL::error = Failed to execute query: 'SELECT SUM(Hits) FROM links_ESMonthly WHERE ( Month = ? AND Year = ? ) ' Reason: Unknown column 'Hits' in 'field list'
DBI::errstr = Unknown column 'Hits' in 'field list'



I didn't try to install the plugin from the beginning (delete old clicktrack-datas in ESDaily & ESMonthly).


very fancy is, that sometimes it works! and sometimes i get the error above!


Any ideas how to fix the problem ?

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

Well, you shouldn't have any code that has the field Hits in it as I deleted it from all the files (I hope).

Are you running under mod_perl?

yes i do (mod-perl).



and it's very odd. sometimes the pages work and sometimes i get the error.

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

Can you just try restarting httpd - and see whether that fixes it?
The UK High Street

yeah, now it seems to work!



maybe there was something strange in my RAM.

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

Excellent!

I love this plugin!

How can I alter the colors of the graphs? Can I alter some of the top list outputs as well?

Michael Carpenter

Adult DVD Links
Adult Detective

In the graphs templates you'll see:

<td valign="bottom" align="center" width="30" background="<%build_images_url%>/default/graph_mid.gif" rowspan="6">

This is the background of the graph. You could copy this graphic to graph_mid2.gif for example, change the colours, put it in the correct folder and change the line above to

<td valign="bottom" align="center" width="30" background="<%build_images_url%>/default/graph_mid2.gif" rowspan="6">

Similarly, for the bars of the graph, the relevant line in the file is directly below the one above:

<img height= ...... src="<%build_images_url%>/default/graph_pixel_wide.gif" width="15" border="0">

Note that the images that the graphs are using at the moment are also used by your review graphs so if you change the images without renaming them, they will also be changed in your review graphs.

Edit (forgot about the second question!): Both the top lists use the es_link_list.html template. You can change this to include any of the tags from the Links table.


(Glad you like the plugin)

Laura.
The UK High Street

Just uploaded a new version (2.0.4) which checks that links are validated before displaying them in the top lists.

Laura.
The UK High Street

You should restart your mod_perl server any time you change any .pm file (i.e. by updating a plugin). This is because mod_perl caches and keeps in memory your .pm files so that they never need to be recompiled. What happened was you were still using your old .pm file, with new templates/new config.

Hope that explains things,

Alex
--
Gossamer Threads Inc.

hi alex,

thank you very much for your explanation.

the thing is pretty clear now for me.

.... and good luck with the community-plugin !

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

Version 2.0.5 is now in the download area.

This version adds another menu item in the admin area so that you can view the daily top list in admin for any day and any size of list.

Laura.
The UK High Street

Latest version - 2.0.6.

This has an updated sort order in the lists so that the monthly and daily lists show the same values on the first day of the month (just noticed that in my top lists I had several sites with the same number of hits which were sorted differently in the two lists).

Laura.
The UK High Street