View Full Version : Most prolific authors
09-11-2007, 03:23 AM
This very simple module will display a linked list of your top 3 active authors. I kept it very simple, no avatars etc... It's actually a CMPS module which work with dynamics.
You need to edit the template and adjust to your site.
Because it can be used with the multiple instances, you need to edit the php and hardcode the table: change new_adv_dyna_entries to your table name
you can see it in action in my homepage (CMPS) or the blogs page Both page at top right. (http://www.haitiwebs.com/forums/blogs/)
thanks - where do I upload it? to the vbadvanced or dyna modules?
10-11-2007, 05:37 PM
you need to upload it in the vba_dyna_modules folder
10-25-2007, 10:08 PM
Thanks, Lionel. :)
am getting a error installing this : there is a table prefix for the forum "vbb363" .
tryed but .. . no luck finding how to add it .
have the table : vbb363adv_dyna_entries, file is : new_363adv_dyna_entries
thanks in advance :)
Database error in vBulletin 3.6.8:
SELECT COUNT(*) AS entries, e.userid as userid, u.username as username FROM new_adv_dyna_entries e
LEFT JOIN vbb363user as u on (e.userid=u.userid)
GROUP BY userid order by entries desc LIMIT 5;
MySQL Error : Table 'tvvn_mvietvbb.new_adv_dyna_entries' doesn't exist
Error Number : 1146
Date : Thursday, November 15th 2007 @ 08:50:47 AM
Script : http://tvvn.org/dynamics/index.php
Referrer : http://tvvn.org/dynamics/newentry.php?c=0
IP Address : ######
Username : ####
Classname : vb_database
11-15-2007, 12:24 PM
change new_adv_dyna_entries to your table name
thanks - realized that - slapped myself upside the head -
and also needed to add the table prefix .
FROM vbb363adv_dyna_entries e
works great - thanks you much .
vBulletin® v3.8.7, Copyright ©2000-2013, vBulletin Solutions, Inc.