I didn't even realize this until one of my members emailed me. It seems my "Top Posters" box on my index page isn't updating. For example, my own post total shows 3286, but my actual post numbers is 4060. But its not just me. Anyone on the list is reflecting much lower numbers than they actually have and it just does not seem to be updating. I have looked at the control panel and don't see anything that would account for this. Any ideas?<br /><br />Thanks in advance,<br />Basil<br /> British Car Forum

Hmmmm ok well in the topposterspal.php put a ss after the <br /><br /> LIMIT 0,$topposters<br />and before the<br /> ";<br /><br />that WILL throw an error and ALSO give you the sql query that is giving the error.. copy/past that sql so I can take a look... then remove the ss so it doesn't throw the error..

I notice this too, but found that this is ok. Take a closer look to the IIP Control Panel. You see that top x poster for y time. And this is the trick <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> Set time to 5 days and see only the top x poster for the last 5 days. <br /> <br />Then watch for the excluded boards for this box. This will not counted too. <br /> <br />As far as I know this box work correct if you have this settings in mind. I set it for top 5 in 7 days and change the title of the box to let the people know thats only for the last 7 days.

I have no excluded boards and on the "How Many Days Back" question I have it set to 0, which is supposed to show all days! (total posts in other words).<br /><br />Basil

If I set it to 0 days I noticed a difference too. But I guess its correct. The IIP seems to count the online postings. Threads itself display the number of all postings ever made by this user. If you purge old postings this counter in threads will not adjusted but the IIP box count less postings. <br /><br />This is the only thing that made sense to me but maybe there is a bug too in it <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Without seeing the query I can;t diagnose it.. can one of ya with this issue let me know the FULL query as I described above?

Zarzal you are correct as I have xperienced this as well as I have one particular forum set to "clean" itself every 90 days unless I "keep" certain threads. Deleted threads are still maintained in the threads post count but not the IIP post count.

well the difference is in the way the queries are setup..<br /><br />topposterspal.php uses<br /><br /> SELECT COUNT(*) as total,t1.B_PosterId,t2.U_Username<br /> FROM {$config['tbprefix']}Posts AS t1,<br /> {$config['tbprefix']}Users AS t2 <br /> WHERE t1.B_PosterId = t2.U_Number<br /> AND t2.U_Number > 1<br /> $dayssearchlimit<br /> $limit<br /> GROUP BY B_PosterId ORDER BY total DESC<br /> LIMIT 0,$topposters<br /><br />and always has <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />showflat.php for instance gets its value from<br /><br />$query = "<br /> SELECT t1.B_Number,t2.U_Username,t1.B_Posted,t1.B_IP,t1.B_Subject,t1.B_Body,t1.B_File,t1.B_Status,t1.B_Approved,t2.U_Picture,t1.B_Reged,t2.U_Title,t2.U_Color,t1.B_Icon,t1.B_Poll,t1.B_Parent,t2.U_Status,t2.U_Signature,t1.B_LastEdit,t1.B_LastEditBy,t2.U_Location,t2.U_TotalPosts,t2.U_Registered,t2.U_Rating,t2.U_Rates,t2.U_RealRating,t2.U_PicWidth,t2.U_PicHeight,t2.U_Number,t1.B_FileCounter,t1.B_AnonName,t1.B_ParentUser,t2.U_Birthday,t2.U_ShowBday,t1.B_AddSig<br /> FROM {$config['tbprefix']}Posts AS t1,<br /> {$config['tbprefix']}Users AS t2<br /> WHERE t1.B_Main = $current<br /> AND t1.B_PosterId = t2.U_Number<br /> $Viewable<br /> ORDER BY B_Number<br /> $Limit<br />";<br /><br />IF those two are throwing different things you need to do some TROUBLESHOOTING and look at why.... <img src="http://www.ubbdev.com/forum/images/graemlins/grin.gif" alt="" />