ProBoards Statistics on Main Website

Okay. Don't create a new column for average, though.

I hope this thing is huge.

I like it. I might use it when I remake my main site, but I have to find a stable host that is free, I can't afford to pay anylonger...

I have so many coding projects going on (my money hack with PHP, SUCKED, I deleted it)...so it'll take a while...

Edit, yep I might do that... ;D

No one ever needs to input anything or change any variables.

You put the stats.js external script on your ProBoards and the stats2.php on your main site. I didn't create a stats2.php tutorial.

But it would be something like this:
<script src="http://www.YourDomain.com/stats2.php?user=YOUR_PROBOARDS_ID" type="text/javascript">
/*
ProBoards Statistics (C) GAMEchief, a.k.a. SegaDragon
This notice may not be removed for any reason.
http://www.gamingmedley.com
YOUR COPYRIGHT NOTICE HERE
*/
</script>
<script type="text/javascript">
<!--

document.write("We have "+stats['members']+" Members who have posted "+stats['posts']+" posts in "+stats['topics']+" topics.");

//-->
</script>

Just change "YOUR_PROBOARDS_ID".
If your URL is:
http://support.proboards.com
You would use
stats2.php?user=support

I don't know if I'll be able to put this in the database though. It would be something like:

Default Features:
Last Post By, Last Post By URL, Member Count, Post Count, Topic Count, etc.

Choose a Version:
cr0w's Host:
<script src="cr0ws Host">blah</script>
+Features+
Average Posts Per Topic, Average Topics Per Forum, Average Forums Per Category, Category Count, Forum Count

GAMEchief's Host:
blah
+Features+
Nothing

---

Maybe. I guess I need to have it in the PBSupport database to prevent it from being stolen... as often.

---

And a note to anyone planning on modding this:
If you want to code a "History" IP Logger, that would be great. There's one major flaw in this, which allows anyone with JavaScript knowledge to change your stats. If no one can figure this one out, I'll be happy to tell them when I know more about what I'm going to be doing with this script.
A history could fix this with global banning. It would be a history that would be output like so:

- you would ban the IP 007.007.007 from accessing stats2.php on all ProBoards that use your host.

I want to have IP log in v1.1, as well as Category Count and Forum Count.

But, ya. This would be quite the complex code to have in the database. :S

Thanks. I've had the idea in my head for a while. I'm surprised not more people combine PHP and MySQL with ProBoards. This is my fourth script with PHP and ProBoards. Third with MySQL, PHP, and ProBoards.

But about the database, I only want the completed versions to go in the database; not the open-source. Like if cr0w adds a History and Category Count, etc., he can give me the link to his host, and I'll edit the topic in the database adding

cr0w's Host/Version:
Code For Your ProBoard
Code For Your Main Site
Features of cr0w's Host/Version

I haven't tested it together, but I've tested stats.js and stats2.php separately. I think cr0w has tested it, though... It definately shouldn't have taken twenty minutes, though.

EDIT:
AH! I bet you didn't install the table.

<?php
// CONNECT TO THE DATABASE HERE
mysql_query("create table statistics (".
"pid tinytext not null default '',".
"lastUpdatedBy mediumtext not null default '',".
"lastUpdatedByUrl mediumtext not null default '',".
"lastUpdatedTopic tinytext not null default '',".
"lastUpdatedTopicUrl tinytext not null default '',".
"members mediumint not null,".
"newestMember tinytext not null default '',".
"newestMemberUrl tinytext not null default '',".
"posts mediumint not null,".
"topics mediumint not null,".
"lastused int not null)") or die(mysql_error());
mysql_close();
?>

You probably should use tinyblob for lastUpdatedTopic. I haven't tested to see if ProBoards includes trailing spaces.

Looks interesting.

I might adapt the php to asp.net for my uses. Credit will still be given to you for this js and original concept.