Page 1 of 10

[ABD] Advanced Similar Topics 1.2.5 (AJAX support)&phpBBSeo

Posted: Sat Oct 25, 2008 2:13 pm
by Porutchik
Modification Name: Advanced Similar Topics

Modification Description: This mod carries out search of similar topics under the name at creation of a new topics. Displays a table with similar threads at the bottom of the name of the topic.
Adds a table at the bottom of a thread and displays other threads that are similar in topic.
Includes AJAX support.

You can control searchs similar topics from Administration Control Panel -> .MODs-> Similar Topics -> Settings.

This mod is full compatible with the phpBB SEO Ultimate SEO URL (Advanced/Mixed/Simple) by dcz.

This MOD shows only those topics, which have in their titles words included into the title of being watched topic, without morphological and semantic features.
The development of searching similar topics with a glance of the mentioned features is a very linguistic-oriented and it is very hard to implement it on php/mysql/oracle/etc., especially for different languages — each one has its own features, and it's impossible for one developer to take all of them into consideration.

Modification Version: 1.2.5 (or view the *link removed* Installation Instructions for version number). For the release history, please view the *link removed* Installation Instructions.

Screenshots: *link removed* Result of search of similar topics in posting form:
*removed link to "dead" image


Demo URL: none

Modification Download: *link removed* Main Download. Registration required. This MOD is forbidden to spread to other sites.

Translate.
If you would like to translate this Mod into normal English or another language, please send me an email or PM or post it In this topic.

Feature Requests.
All ideas from all people are welcome.

*link removed* Support page on Russian

If you like this MOD, please consider a small donation. Thank you!

Re: [BETA] Search Similar Topics Before Posting

Posted: Sat Oct 25, 2008 3:09 pm
by DoYouSpeakWak
Very nice and diffrent from Primes Subject check. http://www.phpbb.com/community/viewtopi ... &start=135

What are the overall difrences besides how the information is displeyed ?

Re: [BETA] Search Similar Topics Before Posting

Posted: Sat Oct 25, 2008 3:19 pm
by easygo
Not a bad idea! Thanks for offering, Porutchik. :)

So here is something, I would change after a first run down the code ::

Code: Select all

$count_similar = count($similar_topics);
if ( $count_similar > 0 )
to

Code: Select all

$count_similar = sizeof($similar_topics);
if( $count_similar)
and this

Code: Select all

				'U_LAST_POST'			=> $similar_topic_url . '&p=' . $similar['topic_last_post_id'] . '#p' . $similar['topic_last_post_id'],
would either goes (right before the assign block) to

Code: Select all

$similar_post_url	= append_sid("{$phpbb_root_path}viewtopic.$phpEx", "p={$similar['topic_last_post_id']}");
as well as just as a replacement to

Code: Select all

				'U_LAST_POST'			=> $similar_post_url . '#p' . $similar['topic_last_post_id'],
OR

Code: Select all

				'U_LAST_POST'			=> $similar_topic_url . '#p' . $similar['topic_last_post_id'],

Hope its fair enough...what do you think about it?

Re: [BETA] Search Similar Topics Before Posting

Posted: Sat Oct 25, 2008 3:52 pm
by Porutchik
easygo, thanks.
I'll take into account in the following version.

DoYouSpeakWak.
This mod more simple.

Re: [BETA] Advanced Similar Topics

Posted: Tue Oct 28, 2008 4:45 pm
by Porutchik
Version 1.0.2
+ Mod is renamed into Advanced Similar Topics.
+ Adds a table at the bottom of a thread and displays other threads that are similar in topic.
+ ACP control added (look at the ACP/General/Board configuration).
+ added includes/similar_topics.php.
+ Large change code.
+ root/language/en/mods/similar_topics.php renamed into root/language/en/mods/info_acp_similar_topics.php
- root/posting_similar_topics.php files removed.

See first post for download link.

Re: [BETA] Advanced Similar Topics

Posted: Wed Oct 29, 2008 9:17 am
by Porutchik
[fixed] bug for IE and Firefox in styles/SimilarTopicSearchFunction.js
Mod updated.

Re: [BETA] Advanced Similar Topics

Posted: Wed Nov 05, 2008 3:29 am
by zamri
I got error when I modified my table phpbb_topics:
ERROR 1005: Can't create table './phpbb/#sql-1121_3a583.frm' (errno: 140)

my mysql ver is 4.0.21. The table is of type MyISAM.

What should i do? Any workaround?

Re: [BETA] Advanced Similar Topics

Posted: Wed Nov 05, 2008 4:21 am
by Porutchik

Re: [BETA] Advanced Similar Topics

Posted: Tue Nov 18, 2008 4:33 pm
by Porutchik
Added:
Add-on for Simple phpBB3 SEO mod Rewrite.
You can find at folder contrib.

Re: [BETA] Advanced Similar Topics

Posted: Tue Nov 18, 2008 5:53 pm
by shahinavthal
I think you have missed out on the instruction for adding the MOD into the Board Configuration :)

Added it on my Board..

Works well :)

Re: [BETA] Advanced Similar Topics

Posted: Tue Nov 18, 2008 7:04 pm
by Peter77sx
Very nice, good to see you work this with phpbb3. :)

Re: [BETA] Advanced Similar Topics

Posted: Tue Nov 18, 2008 10:13 pm
by eman80
Thank u for this Mod.

It is very nice mod.

can I request if u can add a feature to control in number of words in the topic title to appear in the similar topics.

e.g : we have three topics
1 - history book has released
2 - read this history book
3 - Manteq is a nice book

if we choose 2 words or more, topics (1 and 2 in the e.g) will appear in the similar topics.

can u add this?

Thanks again.

Regards :)

Eman

Re: [BETA] Advanced Similar Topics

Posted: Wed Nov 19, 2008 6:07 am
by Porutchik
shahinavthal wrote:I think you have missed out on the instruction for adding the MOD into the Board Configuration
I also think so. :D I'll corrected this later.
can I request if you can add a feature to control in number of words in the topic title to appear in the similar topics.
I'll consider it.

Re: [BETA] Advanced Similar Topics

Posted: Wed Nov 19, 2008 3:14 pm
by ttuu
When I run in phpmyadmin the command:

Code: Select all

ALTER TABLE `phpbb_topics` ADD FULLTEXT (`topic_title`);
i get thus error:

Code: Select all

The used table type doesn't support FULLTEXT indexes

Re: [BETA] Advanced Similar Topics

Posted: Wed Nov 19, 2008 4:40 pm
by Porutchik
ttuu.. Try to it:

Code: Select all

ALTER TABLE `phpbb_topics` ENGINE = MYISAM;
ALTER TABLE `phpbb_topics` ADD FULLTEXT (`topic_title`);
-------
Mod is updated to 1.0.3
[+] - control in number of words in the topic title to appear in the similar topics (for viewtopic and posting form)
[+] - control in minimum relevance in the topic title to appear in the similar topics.

The instructions for update you can find at folder contrib.
See first post for download link.