So are you counting every record in that table or just each ip? Cause 23k for blizehs forum seems a tad high (according to my server stats he's only had ~1200 unique visitors and even that seems a little high)
That allows for all of the visitors we've had in the old hosting as well though, and back in the day it was a pretty popular site.
Is there anything particularly server killing in there? The fact it has to count every IP in the database each time it loads in particular sounds a little worrying, let me know if there's anything that needs disabling and I'll do so.
well here's the sql i use for the iphistory, so this is what the whole thing gives you:
SELECT count(LUM_IpHistory.IpHistoryID) AS iphistorys FROM `LUM_IpHistory` WHERE LUM_IpHistory.UserID = 0;
o, and i'll give a make a top 10 (ish) demo on my site to see what you think of it ;)
Does it blizeh? How long have you been using vanilla? That information wouldnt have been migrated from your old board software.
And yeah vincent, doesnt the iphistory table contain a lot of duplicate records? I've not looked at it myself.
If you've done a sql dump or migrated the database from one installation of vanilla to another, all the recorded user history travels along with it. Not really so much as "guests" or random visitors, but logins have their IPs recorded if the admin sets it, thus storing it. However, under vanilla, one of the routines while listing all the IPs used, quickly shows N number of times under that IP instead of spitting out a bunch of the same info.
ok guys, i've currently got this SQL, but i can't figure out how to count all the variables it gives... could anyone have any ideas?
SELECT IpHistoryID FROM `LUM_IpHistory` WHERE UserID = 0 GROUP BY RemoteIp
All of the comments and topics on the forum atm have been from Vanilla mate, we had a site using PunBB before ( gu.mypunbb.com ) which we never bothered migrating from, it was too much hassle requesting the free hosts give us our sql stuff imho.
But anyway,is there anyway in Vanilla to view the second highest posters etc?
ur, yea, the extension is just having a bit of a make-over coding-wise at the moment... i'm making it a bit better so it'll have a couple more functions than it does now, and it'll also be better set out, with separate panels
Noo sorry, it was a question unrelated to this extension really, I don't think a top 10 posters or w/e would be well suited to the left bar at all, just wondering if it would be possible to do using an advanced search.
oops, well, here's an sql statement to help you along ;)
SELECT LUM_User.Name AS name, (LUM_User.CountComments + LUM_User.CountDiscussions) AS posts FROM `LUM_User` ORDER BY (LUM_User.CountComments + LUM_User.CountDiscussions) DESC LIMIT 10;
Ah thanks, so if I do <?php SELECT LUM_User.Name AS name, (LUM_User.CountComments + LUM_User.CountDiscussions) AS posts FROM `LUM_User` ORDER BY (LUM_User.CountComments + LUM_User.CountDiscussions) DESC LIMIT 10; ?>
Then it'll just do a really simple page listing the users? Apologies for the dumb question, I'm not very up on PHP at all.
Nah you'd need to use:
<?php
$query = "SELECT LUM_User.Name AS name, (LUM_User.CountComments + LUM_User.CountDiscussions) AS posts FROM `LUM_User` ORDER BY (LUM_User.CountComments + LUM_User.CountDiscussions) DESC LIMIT 10";
$result = mysql_query($query);
while ($dataset = mysql_fetch_array($result)) {
echo $dataset['name']."<br>";
}
?>
(Not guaranteed to work and very rough but should do the job i think)
Comments
Is there anything particularly server killing in there? The fact it has to count every IP in the database each time it loads in particular sounds a little worrying, let me know if there's anything that needs disabling and I'll do so.
But anyway,is there anyway in Vanilla to view the second highest posters etc?
Then it'll just do a really simple page listing the users? Apologies for the dumb question, I'm not very up on PHP at all.