Live stats plugin

Basti

Administrator
Staff member
Please explain what you want to do. the words "Live stats" and your "description" doesnt match up.

What you regard as "Live stats"?
 

cajkan

Active Member
About forums you should search for some API, because VL dont have forums you have to integrate thouse statistifcs.

Total Members - use this code: {$num_members}
Toplist reset time ( requires plugin ) : {$toplist_reset}
Script load time : {$execution_time}

<---------------------------------->
You can also load some Google Analytics statistics too, and you can use custom website tracking websites like statcounter
 

Basti

Administrator
Staff member
Ye execpt num members you will have to create plugin for that purpose.

And plugin you can only use if the forum shares the same database as visiolist. Then you simply query those tables and make a count.

VL same database as forum
Create this in the plugin directory

1) Folder named LiveStats
2) LiveStats/languages/english.php ( can be empty )
3) LiveStats/languages/index.htm ( empty )
4) LiveStats/index.htm ( empty )
5) LiveStats/info.php ( Look at a different plugin to see the contents, mostly plugin name, version and such )
6) LiveStats/global_start.php

6.1) In global_start.php query your forum post table by doing a count
Code:
list($TMPL['forum_posts']) = $DB->fetch("SELECT COUNT(*) FROM my_forum_post_table", __FILE__, __LINE__);
list($TMPL['forum_members']) = $DB->fetch("SELECT COUNT(*) FROM my_forum_member_table", __FILE__, __LINE__);
In the query change the tables names obviously

Now you can use in your template
Code:
{$forum_posts}
{$forum_members}

Both scripts not share same database
In that case you would need to do the mysql work on your forum script.
Make a simple php file which query out the stats, similar to what we did above. ( dont forget your mysql connection etc )
Then echo out the proper html + text
like
Code:
echo "
  Forum Posts {$forum_posts}<br />
  Forum members {$forum_members}
";
Or your forum provides a API like cajkan mentions. We cant know that

Once you got the php file working ( or the API ), you can include it into VL by using
Code:
{include "http://site.com/the_php_file_you_created.php"}
 
Top