MyBB Community Forums

(2010-01-24, 06:31 PM)Maechlis Wrote: [ -> ]2) Tags appear in the cloud multiple times depending on their order in the tag sequences of threads. For example, if I tag Thread 1 with aaaa, bbbb, and Thread 2 with bbbb, cccc, the tag cloud will display bbbb twice, with the first bbbb referring to Thread 1 and the second - to Thread 2.
(I suppose this was the same with v0.7 also)

3) The tag cloud footer still reads "v 0.7" instead of "v 0.8"

2) It shouldn't !! I fixed this problem ... Can I see link to your forum?
3) you haven't copied langs or you copied it into bad folder or you didn't delete old langs.

Turkish Plugins
Download
[attachment=17149]
Turkish By bomfile
Zip password:www.mybbdestek.com
http://forum.mybbdestek.com/Konu-basit-e...dece-md-de
Thanks.

3) I once again deactivated and activated, and the footer updated. So this is not an issue now, anyway.

But far more interesting is 2). It turns out that it is not precisely the order of tags that causes them to become duplicated

I tried various combinations of actions with tags and found that a tag becomes duplicated only under the following conditions:

I) A tag (say, tagx) exists in some thread(s). This tag is contained as "tagx" in tag_name of stcp.

IIa) We take another existing thread with some tags imposed and delete all of them by either pressing [X] or pressing (Delete all tags). Then we assign a new series of tags to this thread, of which tagx is the first.

OR

IIb) We take another existing thread with no tags imposed and assign a new series of tags to this thread, of which tagx is the first.

In both cases tagx is entered into tag_name as "-tagx" (why this happens, I do not know), and thus tagx appears in tag_name twice: as "tagx" and as "-tagx", and hence it becomes duplicated in the cloud.

If tagx is not the first tag in the new sequence of tags, or if the previous sequence of tags was deleted by keyboard actions (not by clicking the hyperlinks), or if not all of the previous tags were deleted - then tagx does not become duplicated.

Unfortunately, I cannot give you the link to my forum (at present), because it runs in the test mode at the domain closed for public access. However, I can provide any info needed, and screenshots, if necessary. But the sequence above you may easily reproduce by yourself. Hope this helps.

Sadly, I'm not experienced in PHP & SQL , so I cannot provide insight into the code, only observations on phpmyadmin & forum behavior.

Thaks for advices, hmm its strange bug, I'll try to fix it - Thank you very much again !

(2010-01-26, 08:01 PM)dared Wrote: [ -> ]

dared Wrote:here is a tut for making tags as known pages couse tag pages still unknown xD
http://community.mybboard.net/thread-55762-page-1.html

Viewing Tags



http://forum.mybbdestek.com/Konu-basit-e...de?page=23

(2010-01-27, 07:48 AM)ozanakkaya Wrote: [ -> ]

(2010-01-26, 08:01 PM)dared Wrote: [ -> ]

dared Wrote:here is a tut for making tags as known pages couse tag pages still unknown xD
http://community.mybboard.net/thread-55762-page-1.html

Viewing Tags



http://forum.mybbdestek.com/Konu-basit-e...de?page=23

Thanks, Ozan Akkaya.

---

@ Watt ,

If you have too many messages in the forum
Add tags all threads, when we run the option,
- Site server is slow, and can not complete the task. Ends with the SQL error.
- I tried a few large DB forum, and I got the same result.

Queries fragmentation, may be better. To send a query such as Part ..

---

I'm thinking about using mysql indexes (fulltext) to optymalize plugin.

also dont forget about the installation routine.
large boards deletes and add tags every update xD
or
check the pm folder for suggs. xD

How to update plugin without deleting all tags:
Change it in both files (one you have on server [this old version of plugin] and new one [download from this thread])
Your update should look like that:

You download new version -> You change old and new version of plugin (what you should change you have got below) -> You deactivate OLD version of plugin (in ACP) - this version wtich you edited with my advices below -> You send new version of plugin to your FTP - this version wtich you edited with my advices below -> You activate NEW version of plugin -> Well done (any problems - write here)

Sorry for half-english, but I do not have time to write something better.

---

Find inc/plugin/stcp.php

	/* ADDING TABLE */		
	if($db->field_exists("tag", "threads"))
	{
		$db->query("ALTER TABLE `".TABLE_PREFIX."threads` DROP `tag`;");
	}
		
	$db->query("ALTER TABLE `".TABLE_PREFIX."threads` ADD `tag` TEXT NOT NULL;");

replace it with

	/* ADDING TABLE */		
	/*if($db->field_exists("tag", "threads"))
	{
		$db->query("ALTER TABLE `".TABLE_PREFIX."threads` DROP `tag`;");
	}
		
	$db->query("ALTER TABLE `".TABLE_PREFIX."threads` ADD `tag` TEXT NOT NULL;");*/

(Line about 200-300)

	$db->query("DROP TABLE ".TABLE_PREFIX."stcp");

and replace it with

	//$db->query("DROP TABLE ".TABLE_PREFIX."stcp");

(It is line abuot 300-400)

$db->query("ALTER TABLE `".TABLE_PREFIX."threads` DROP `tag`;");

replace it with

//$db->query("ALTER TABLE `".TABLE_PREFIX."threads` DROP `tag`;");

(Line about 350-450)

It will prevent from deleting tags.