2 DB Queries for Prev/Next Thread Links ?

[Shadab]

I'm running vBSEO 3.2.0; in which theres this setting:

Replace 'Previous/Next Thread' redirect links?

Enable this option to replace the 'Next Thread' & 'Previous Thread' links with direct, Content Relevant links.
Note: This option adds two queries.

What's the status of this feature in 3.3.0 ?
Does enabling this setting still adds 2 queries in the latest version of vBSEO (ie, 3.3) ?


-Shadab.

[Michael Biddle]

3.3.0:

Replace 'Previous/Next Thread' redirect links?
Enable this option to replace the 'Next Thread' & 'Previous Thread' links with direct, Content Relevant links. Note: This option adds two queries.

[Shadab]

So, the function vbseo_get_next_thread() is called twice (fn($threadid, false) & fn($threadid, true)) to get the titles of the next and previous thread ?

Could this not be done with a single query ?

SELECT t.forumid, t.threadid, t.title, t.replycount, t.lastposter, t.lastpostid, t.lastpost
FROM thread AS t
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = t.threadid AND type = 'thread')
WHERE forumid = 33 AND visible = 1 AND open <> 10 AND deletionlog.primaryid IS NULL
ORDER BY ABS(lastpost + 0.0 - 1240574678)
LIMIT 1, 2
-------------------------------------------------------------------------
$thread[forumid] , $thread[lastpost]

[Oleg Ignatiuk]

Good idea, but this query will return 2 "next" queries in case if both of them are closer to "current" thread than "previous" one, i.e. it will not work consistently.