Forum Home Enhancements - [AJAX] Top X - ALP Pro

[AJAX] Top X - ALP Pro

Features:

• Uses AJAX technology
• Ajax - Last Post preview
• Latest Posts
• Top Posters
• Newest Members
• Most Replied To Thread
• Most Viewed Thread
• Disallow Forum Settings
• Turn On/Off Date & Time
• Location Settigs
• Displayed Characters Settings
• easy Product installer/updater/uninstaller
• On/Off Top Poster
• On/Off Newest Members
• On/Off Popular Thread
• auto-refresh option
• New post icon On/Off

install

Go to your admin cp, then:
Plugin System -> Manage Products -> [Add/Import Product] -> Select 'product-alatestposts.xml' from your computer then press 'Import'


Modifications Info

Plugin : 3
Phrases : 36
Template : 6
Setting : 9


Latest Posts Setting

Go to your admin cp, then:
vBulletin Options -> [AJAX] Latest Posts ->



Versions:
v1.0 - 27 June 2007
-First release

v1.1 - 28 June 2007
- Characters problem fixed
- Disallow Forum Added
- alp_forumhome template deleded
- a Waiting Animated Change

v1.2 - 29 June 2007
- Added Thread Title Displayed Characters
- Added Usernames Displayed Characters
- Added Forums Displayed Characters
- Added Date & Time line
- Added Top Posters
- Added Newest Members
- On/Off Date & Time
- Added Location Settigs
- Navbar Bellow / Forums Above / Forums Below / Whois Online Below
- Updating Mod Picture

v1.3 - 29 June 2007
- Added Popular Thread Menu
- Added Most Replied To Thread
- Added Most Viewed Thread

v1.4 - 02 July 2007
- Added Turn Top Poster On/Off
- Added Turn Newest Members On/Off
- Added Turn Popular Thread On/Off

v1.5 - 04 July 2007
- Added auto-refresh option
- Buttons Change
- Small Change Template
- Forum Title Problem Fixed
- Added vBulletin 3.5.x version

v1.6 - 07 July 2007
- New post icon On/Off
- Ajax - Last Post preview "Click ▼",

[Quantnet]

Originally Posted by PoetJA-1975

Hmmmm - I didn't realize there were any problems....

the problem is with new post icon displayed as old so it's difficult to see any new post.

It's a shame that nobody can fix this....I have to remove it

[Quantnet]

Still no luck with the fix ?

[mcyates]

Where are the templates for this as I would like to remove the "Updating" bit that appear at the bottom.

[hiphopcem]

teşekkürler atakan hocam eline sağlık

[yucel9603]

teşekkür ederim

[Nikke]

Is there anyway I can install multiple instances of this? One for showing the latest news and one for the latest posts?

How would I do that?

[Nikke]

Also, is there anyway to not have it put the one with the latest comment on top? I would just want it to show the threads in the order they are written!

[daydie]

Heyyyyyy, will this smallen? to fix on a fixed template!

[Audentio]

I don't like the ajax refresh and stuff. I was looking for a mod like cybs top x except just for last x posts and stuff. But good work on the mod, very impressive.

[Lea Verou]

As I promised, here's how to fix the new/old post icon issue:

Open the plugin Alp Ajax Start
Find:

PHP Code:

$gthreads = $db->query_read("
    SELECT
        thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, forum.title as forum_title
        FROM " . TABLE_PREFIX . "thread AS thread
        LEFT JOIN  " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)
        LEFT JOIN " . TABLE_PREFIX . "forum as forum on (thread.forumid = forum.forumid)
        WHERE NOT ISNULL(thread.threadid)
        $excludedforums AND thread.visible = 1 ORDER BY lastpost DESC LIMIT 0, $alpmax"); 


replace with:

PHP Code:

$gthreads = $db->query_read("
    SELECT
        thread.threadid,
        thread.title,
        thread.lastpost,
        thread.forumid,
        thread.replycount,
        thread.lastposter,
        thread.dateline,
        IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
        thread.visible,
        user.username,
        user.userid,
        user.usergroupid,
        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
        forum.title as forum_title
        " . (($vbulletin->options['threadmarking'] AND $vbulletin->userinfo['userid']) ? ", threadread.readtime AS readtime" : "") . "
        FROM " . TABLE_PREFIX . "thread AS thread
        LEFT JOIN  " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)
        LEFT JOIN " . TABLE_PREFIX . "forum as forum ON (thread.forumid = forum.forumid)
        " . (($vbulletin->options['threadmarking'] AND $vbulletin->userinfo['userid']) ? " LEFT JOIN " . TABLE_PREFIX . "threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = " . $vbulletin->userinfo['userid'] . ")" : "") . "
        WHERE NOT ISNULL(thread.threadid)
        $excludedforums AND thread.visible = 1 ORDER BY lastpost DESC LIMIT 0, $alpmax"); 


Then find:

PHP Code:

    if ($getstats_thread[lastpost] > $vbulletin->userinfo['lastvisit'])
    {
        $gthread_newpost = 'new';
    }
    else
    {
        $gthread_newpost = 'old';
    } 


and replace with:

PHP Code:

    if ($gthread['lastpost'] <= $gthread['readtime'])
    {
        $gthread_newpost = 'old';
    }
    else
    {
        $gthread_newpost = 'new';
    } 


Do the same with the plugin Alp Load.

Notice: The code to find is from the previous version. I didn't upgrade to the latter as I didn't need the new features, so perhaps the code to find is a little different.

Btw I noticed another bug with this: If in a forum a user can only view own threads and not others' threads, the permission doesn't get applied to the new posts: He can view others' threads from that forum as well.