Results 1 to 8 of 8

Thread: Most prolific authors

  1. #1
    Join Date
    Jan 2004
    Location
    Miami
    Posts
    1,040

    Default Most prolific authors

    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.

  2. #2

    Default Re: Most prolific authors

    thanks - where do I upload it? to the vbadvanced or dyna modules?
    Last edited by gorp; 10-11-2007 at 07:48 PM.

  3. #3
    Join Date
    Jan 2004
    Location
    Miami
    Posts
    1,040

    Default Re: Most prolific authors

    you need to upload it in the vba_dyna_modules folder

  4. #4

    Default Re: Most prolific authors

    thanks much

  5. #5
    Join Date
    Mar 2004
    Location
    A galaxy far, far away...
    Posts
    6,609

    Default Re: Most prolific authors

    Thanks, Lionel.

  6. #6
    Join Date
    Jan 2004
    Location
    Inside my Head
    Posts
    10

    Default Re: Most prolific authors

    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

    Code:
    Database error in vBulletin 3.6.8:
    
    Invalid SQL:
    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
    ... / GFXstyles
    a certain amount of common sense is necessary to survive in this world !
    insanity leaves you no restrictions !

  7. #7
    Join Date
    Jan 2004
    Location
    Miami
    Posts
    1,040

    Default Re: Most prolific authors

    change new_adv_dyna_entries to your table name

  8. #8
    Join Date
    Jan 2004
    Location
    Inside my Head
    Posts
    10

    Default Re: Most prolific authors

    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 .
    ... / GFXstyles
    a certain amount of common sense is necessary to survive in this world !
    insanity leaves you no restrictions !

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •