Support » Plugins » WP-Advanced-Stats 1.0.0 Beta Tester/Programmers Needed

  • This is the beta of the WP-Advanced-Stats plugin for WordPress. If you have some PHP/mySQL please test it out and anyone who wants to write there own viewer or suggest a change or help out in anyway leave and comment and you can email me at jpiasetz@noontide.ca.

    How far from release is this?

    • It needs to be test on other wp installs
    • It needs a completed viewer (somebodies, anybodies)

    Download

    Install Recorder

    1. Download the plugin and put it in your plugins directory.
    2. Activate the plugin.

    FAQ

    • When is a viewer coming out? I’m writing one as fast as I can and hopefully some other people take up the cause and start writing there own (if you do email me your site and I’ll link back to you).
    • What happened to the stats? WP-Advanced-Stats is now being released in two parts, WP-Advanced-Stats-Recorder which records all the data and WP-Advanced-Stats-Viewer which parses, evaluates and displays the data.
    • Why did WP-Advanced-Stats get broken up into two parts? Well there are a bunch of reasons I broke it up.
      • Easier to Update I can now update either the Recorder or the viewer depending on what changes.
      • Community Being broken up allows other people to use the recording engine for there own stats. The database keeps track of pretty much all the important session variables. You can query it to get country, time, os, browser, predictions of hits, hits and about a million other things. The more people using it to find out cool stats the happy everyone will be.
      • Server Load If you have a huge user load the recorder takes very little time on it’s own and you can hopefully (please make difference viewers everyone) find a different viewer that doesn’t display very many statistics.
Viewing 15 replies - 1 through 15 (of 46 total)
  • Put your functions in a class or uniquely name at least with like a prefix. It conflicts with “WP-ContactForm” due to the getip function.

    I also suggest a more unique default table name on the off chance that someone else wants to use that table name. Perhaps avdstats or astats.

    I’d also like to see it test to see if the user is logged in and if so, record their userid. That way any stats displayer could sort out me (a level 10) or even all logged in users.

    Besides that, while it’s simple, your plugin looks good. 🙂

    Alright I:

    • Renamed all functions to be more unique.
    • Turned Username into a tinytext so as to fit the maximum comment_author length.
    • Renamed database to $advanced_stats_table_name

    Count-My-Clicks (using WP-Advanced-Stats-Recorder)

    My clicks now works with Advanced-Stats, it just changes the url to the one there going to.

    There is now also a viewer up

    I also suggest a more unique default table name on the off chance that someone else wants to use that table name. Perhaps avdstats or astats.

    I’m just curious … Can you please elaborate a little on this? Why would you choose a name that somebody else might want to choose, presumably (you mean) in the future? Huh?

    I changed the name so as not to overlap but it was a discriptive simple name. It was just stats lol.

    WordPress database error: [Table ‘web303_wordpress.adstats’ doesn’t exist]
    SELECT count(DISTINCT username) as users, count(ip) as hits, count(DISTINCT ip) as vistors, count(DISTINCT referer) as referers, count(DISTINCT user_agent) as user_agent FROM adstats

    That’s what I’m getting under Dashboard > Advanced Stats after activating both recorder and viewer. How can I repair this?

    I am getting the same SQL error.

    I have noticed that when I activated the plugin, it did not create the SQL tables.

    What is the SQL query I need to run?

    Thanks.

    Try download the new version of the viewer http://blog.noontide.ca/?file=wp-advanced-stats-viewer.phps Is there an error on your main blog page? If there isn’t the problem is limited to the viewer. piginzen are you sure it didn’t create it with the wordpress table prefix?

    you are right… it did create the table with the wp_ prefix…

    but the view still will not work:

    WordPress database error: [Table ‘wrdp1.adstats’ doesn’t exist]
    SELECT count(DISTINCT username) as users, count(ip) as hits, count(DISTINCT ip) as vistors, count(DISTINCT referer) as referers, count(DISTINCT user_agent) as user_agent FROM adstats

    etc…

    It’s still the same. The table has been created, but it’s actually named ‘wp_adstats’ and the plugin is looking for ‘wordpress_adstats’…

    @piginzen: writing at the same time ;]
    edit: I guess it created the table but without the prefix… and that’s the problem.

    I will try and change it.

    Thanks Lipa

    I actually changed it to simply “adstats” without any prefix and it’s working better… However I am still getting this error:

    Daily Stats

    WordPress database 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 ‘(time) AS date FROM adstats GROUP BY DATE(time) ORDER BY time A]
    SELECT count(DISTINCT username) as users, count(ip) as hits, count(DISTINCT ip) as vistors, count(DISTINCT referer) as referers, count(DISTINCT user_agent) as browsers, date(time) AS date FROM adstats GROUP BY DATE(time) ORDER BY time ASC

    Warning: Invalid argument supplied for foreach() in /home/public_html/wp-content/plugins/WP-Advanced-Stats-Viewer.php on line 63
    Users Online Hits Vistors Referers Browsers Date

    let’s just wait for the fix… I’m no php guru either :] hopefully J2000_ca will come out with the fix soon…

Viewing 15 replies - 1 through 15 (of 46 total)
  • The topic ‘WP-Advanced-Stats 1.0.0 Beta Tester/Programmers Needed’ is closed to new replies.