Show Thread Enhancements - Yilmaz - Similar Threads vB5

Tested with vBulletin Version 5.7.0 and PHP Version 8.1.11

========================================
Description:
========================================

This plugin automatically adds Similar Threads as blocks of the first post of each Thread, based on Thread tags.



17,12,2020 Fixed database error

22.02.2021 Icon width and height bug fixed

15.10.2022 Fixed some bugs I found

Important
It takes similar Threads from the tags of other Threads.

Therefore, if there are no tags, Similar Threads block will not appear.

It will only show up if a similar taglet is added.

If you install this Automatic Topic Tagger product, there will be no threads left without tags.

Mark as installed = get support.

========================================
How to install:
========================================
Upload the content of "Yilmaz - Similar Threads vB5" to your root.
that's all it.
enjoy..
-----
If you installed this mod and/or you want get support, please "Mark as Installed".
-----

========================================
How to uninstall:
========================================
1. Remove the package "yilmazsimilarthreads" that located in /core/packages/
2. Go to "Manage Products" in the admincp and delete the product named "Yilmaz - Similar Threads vB5"

How to update:
========================================
After uploading files
-Import XML file (as product) through AdminCP: Plugin System > Manage Products > [Add/Import Product]
OR import the XML file from your server

./core/packages/yilmazsimilarthreads/xml/product_yilmazsimilarthreads.xml

[yilmaz]

Originally Posted by DamasGate

I have a question please:
Is it possible to display it in the first post of all the topic pages (Multi-page topics)?


Thank you

You want it to show in the first message of page 2

I have to try, if I get a positive result, an option is added.

[DamasGate]

Originally Posted by yilmaz

You want it to show in the first message of page 2

I have to try, if I get a positive result, an option is added.

Yes, that's what I mean.


It would be great if you could do that for both hacks Similar Threads vB5 + Automatic Topic Tagger.



It is very good SEO for these links to appear on first post of all topic pages.

I greatly appreciate your efforts.


Thank you

[yilmaz]

22.02.2021 Icon width and height bug fixed

[tahir436]

Hi Yilmaz

After installation mine is shown like this:


Also see this post for reference

https://labkushai.com/forum/politica...d-sabir-shakir

[yilmaz]

Originally Posted by yilmaz

22.02.2021 Icon width and height bug fixed

Originally Posted by tahir436

Hi Yilmaz

After installation mine is shown like this:


Also see this post for reference

https://labkushai.com/forum/politica...d-sabir-shakir

Yes, I also noticed.
I stated that I have updated it in the above message, if you just install it again and update it, the problem will go away.

[tahir436]

Originally Posted by yilmaz

Yes, I also noticed.
I stated that I have updated it in the above message, if you just install it again and update it, the problem will go away.

OK its working after updates. Thanks for your support

[milforum]

It works fine for me, but I now and then get database errors. One example below:

Database error in vBulletin 5.6.4:

Invalid SQL:
SELECT tagnode.nodeid as tagnodeid, node.iconid, node.prefixid, node.nodeid as nodeidsi, node.title as konubasligi, node.lastcontentid, node.parentid, node.textcount, node.totalcount, icon.iconpath, icon.title as icontitle, closure.parent as forumidesi, closure.depth, forum.title as forumtitle, node.authorname
FROM tag AS tag
LEFT JOIN tagnode AS tagnode ON (tagnode.tagid = tag.tagid)
LEFT JOIN node AS node ON (node.nodeid = tagnode.nodeid)
LEFT JOIN closure AS closure ON (closure.child = node.nodeid)
LEFT JOIN node AS forum ON (forum.nodeid = closure.parent)
LEFT JOIN user AS user ON (user.userid = node.lastauthorid)
LEFT JOIN icon AS icon ON (icon.iconid = node.iconid)
WHERE ()
AND closure.depth = 1
AND node.title !=''
AND node.inlist = 1
AND tagnode.nodeid != '15615'
AND tagnode.nodeid = node.starter
GROUP BY tagnode.nodeid
ORDER BY tagnode.nodeid DESC
LIMIT 10;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND closure.depth = 1
AND node.title !=''
AND node.inlist = 1
AND tagnod...' at line 9
Error Number : 1064
Request Date : Sunday, February 28th 2021 @ 08:22:04 PM
Error Date : Sunday, February 28th 2021 @ 08:22:04 PM
Script : https://xxx.yyy/node/15615
Referrer :
IP Address : 99999999999
Username : <i>Gjest</i>
Classname : vB_Database_MySQLi
MySQL Version :


Stack Trace:
#0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1214
#1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
#2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 583
#3 vB_Database->query_read() called in [path]/packages/yilmazsimilarthreads/api/template.php on line 69
#4 YilmazSimilarThreads_Api_Template::fetchBulk() called in phar://[path]/vb/vb.phar/api/wrapper.php on line 223
#5 vB_Api_Wrapper->__call() called in /home/xxxxx/public_html/includes/api/interface/collapsed.php on line 105
#6 Api_Interface_Collapsed->callApi() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 224
#7 vB5_Template_Cache->fetchTemplate() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 110
#8 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#9 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#10 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#11 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#12 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#13 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#14 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#15 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#16 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#17 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/template/cache.php on line 134
#18 vB5_Template_Cache->replacePlaceholders() called in /home/xxxxx/public_html/includes/vb5/template.php on line 421
#19 vB5_Template->render() called in /home/xxxxx/public_html/includes/vb5/frontend/controller/page.php on line 275
#20 vB5_Frontend_Controller_Page->index() called in /home/xxxxx/public_html/index.php on line 75

[yilmaz]

Tested with vBulletin Version 5.6.7 and PHP Version 8.0.16

[Aristide]

Installed on vB 5.7.1.
Works well with some threads and fails to work with others. I entered a debug mode and got the following (when it had failed to work):

Debug: Error
syntax error, unexpected 's' (T_STRING)
occurred in file xxxx/includes/vb5/template.php(404) : eval()'d code on line 31
Trace
Function render in file xxxx/includes/vb5/template/cache.php line 137
Function replacePlaceholders in file xxxx/includes/vb5/template.php line 426
Function render in file xxxx/includes/vb5/template/cache.php line 137
Function replacePlaceholders in file xxxx/includes/vb5/template.php line 426
Function render in file xxxx/includes/vb5/template/cache.php line 137
Function replacePlaceholders in file xxxx/includes/vb5/template.php line 426
Function render in file xxxx/includes/vb5/template/cache.php line 137
Function replacePlaceholders in file xxxx/includes/vb5/template.php line 426
Function render in file xxxx/includes/vb5/template/cache.php line 137
Function replacePlaceholders in file xxxx/includes/vb5/template.php line 426
Function render in file xxxx/includes/vb5/template/cache.php line 137
Function replacePlaceholders in file xxxx/includes/vb5/template.php line 426
Function render in file xxxx/includes/vb5/frontend/controller/page.php line 275
Function index in file xxxx/index.php line 70

[Aristide]

It works on vB 5.7.1 if there is no apostrophe in the titles of the similar threads/topics to be displayed by the mod. But, if there is an apostrophe in the title of one of those topics to be displayed by the mod, you get a error message. The mod needs a way to handle apostrophes in the titles of the similar threads/topics that it detects.