Tagging System For Topics

[sharks]

It's been "a couple of weeks".

Waiting... waiting... waiting... Forever!

Such huge potential in this mod, poured down the drain.

[vbgamer45]

I have hired some help to work on this.
The issue here is really I have to find all the edits that the mod has made to normal SMF's files then package it up.

[InfoStrides]

Not sure still in development hopefully get something out in the a couple weeks

OK. Thanks.

[Anitr Fansub]

---->




how do I ?

I've tried. but I can not run

Code Select Expand

<script type="text/javascript">
function displayResult(browser)
{
document.getElementById("result").value=browser
}
</script>
<script type="text/javascript">
function divYap(){
var yeni = document.createElement("div");

yeni.innerHTML = document.getElementById("result").value

yeni.className = "ornekSinif";
return yeni;
}
function appendChild_ile_ekle() {
var div = document.getElementById("ornekDiv");
div.appendChild( divYap() );
}
</script>

<input type="radio" name="browser" onclick="displayResult(this.value)" value="Internet Explorer">Internet Explorer<br />
<input type="radio" name="browser" onclick="displayResult(this.value)" value="Firefox, ">Firefox<br />
<input type="radio" name="browser" onclick="displayResult(this.value)" value="Opera, ">Opera<br />
<input type="radio" name="browser" onclick="displayResult(this.value)" value="Google Chrome, ">Google Chrome<br />
<input type="radio" name="browser" onclick="displayResult(this.value)" value="Safari, ">Safari<br /><br />
<input  id="result" />

<input type="button" value="Tür Ekle" onClick="appendChild_ile_ekle()" />

<div  id="ornekDiv" style="padding:3px;">
</div>

Or...

Code Select Expand

<script type="text/javascript">
function displayResult(browser)
{
document.getElementById("result").value=browser
}
</script>
<input type="checkbox" name="browser" onclick="displayResult(this.value)" value="Internet Explorer">Internet Explorer<br />
<input type="checkbox" name="browser" onclick="displayResult(this.value)" value="Firefox, ">Firefox<br />
<input type="checkbox" name="browser" onclick="displayResult(this.value)" value="Opera, ">Opera<br />
<input type="checkbox" name="browser" onclick="displayResult(this.value)" value="Google Chrome, ">Google Chrome<br />
<input type="checkbox" name="browser" onclick="displayResult(this.value)" value="Safari, ">Safari<br /><br />
<td width="28%"  class="windowbg2" align="right"><span class="gen"><b>', $txt['smftags_tagtoadd'], '</b></span></td>
<td width="72%" class="windowbg2"><input type="text" id="result" name="tag" size="64" maxlength="100" /></td>
 </tr>

[vbgamer45]

Not sure what you are asking? The code above is not from the modification

[Anitr Fansub]

I managed to ^. ^

[pols1337]

Hi vbgamer,

I think I've accidentally installed the Tagging System package twice, so the tags appear twice.  See screenshot.  I've tried uninstalling and re-installing the package, but that doesn't work.  (When I uninstall, it completely removes the entire Tagging System package.  When I reinstall, it adds back the double tagging).  Can you help me fix this? 

[Ben_S]

Looking at using this as a base for my new redesign to feed the home page, i.e. topics are tagged and then with a few new ssi features can be pulled out as required, will require a fair bit of stripping down though to remove the tag list and cloud etc as the queries used for them could do with some optimisation. With 286,000 entries in smf_tag_logs, the tags action resulted in a query that ran for over 60 seconds before I killed it. Similar for clicking on a tag in a topic listing. Not a biggie for me as I will be removing those anyway as all I want it the ability to add tags to a topic and pull them out using ssi.php.

When I've added my ssi.php stuff I'll contribute it  back in case it is useful to anyone else.

[vbgamer45]

Do you know what the exact query was?
Here is  what I would do to speed it up

Code Select Expand


ALTER TABLE smf_tags_log add index ID_MEMBER (ID_MEMBER);

ALTER TABLE smf_tags_log add index ID_TOPIC (ID_TOPIC);


This will make those queries process extremely fast.

[Ben_S]

Still had it installed so queries below. Adding those indexes doesn't help, still takes over 200 seconds.

action=tags

SELECT DISTINCT l.ID_TOPIC, t.num_replies,t.num_views,m.id_member,
        m.poster_name,m.subject,m.id_topic,m.poster_time,
        t.id_board, g.tag, g.ID_TAG
         FROM (yabbse_tags_log as l, yabbse_boards AS b, yabbse_topics as t, yabbse_messages as m)
          LEFT JOIN yabbse_tags AS g ON (l.ID_TAG = g.ID_TAG)
         WHERE b.ID_BOARD = t.id_board AND l.ID_TOPIC = t.id_topic AND t.approved = 1 AND t.id_first_msg = m.id_msg AND 1=1 ORDER BY l.ID DESC LIMIT 20
         
"id";"select_type";"table";"type";"possible_keys";"key";"key_len";"ref";"rows";"Extra"
"1";"SIMPLE";"b";"index";"id_board";"id_board";"2";NULL;"29";"Using index; Using temporary; Using filesort"
"1";"SIMPLE";"t";"ref";"PRIMARY,firstMessage,ID_BOARD,approved,last_message_sticky,board_news";"board_news";"2";"rawk_forum.b.id_board";"2698";"Using where"
"1";"SIMPLE";"l";"ref";"ID_TOPIC";"ID_TOPIC";"3";"rawk_forum.t.id_topic";"1";""
"1";"SIMPLE";"g";"eq_ref";"PRIMARY";"PRIMARY";"3";"rawk_forum.l.id_tag";"1";""
"1";"SIMPLE";"m";"eq_ref";"PRIMARY";"PRIMARY";"4";"rawk_forum.t.id_first_msg";"1";""



?action=tags;tagid=1

SELECT count(*) as total
        FROM (yabbse_tags_log as l, yabbse_boards AS b, yabbse_topics as t, yabbse_messages as m)
       
        WHERE l.ID_TAG = 1 AND b.ID_BOARD = t.ID_BOARD AND l.ID_TOPIC = t.id_topic  AND t.approved = 1
        AND t.ID_FIRST_MSG = m.ID_MSG AND 1=1

"id";"select_type";"table";"type";"possible_keys";"key";"key_len";"ref";"rows";"Extra"
"1";"SIMPLE";"b";"index";"id_board";"id_board";"2";NULL;"29";"Using index"
"1";"SIMPLE";"t";"ref";"PRIMARY,firstMessage,ID_BOARD,approved,last_message_sticky,board_news";"board_news";"2";"rawk_forum.b.id_board";"2698";"Using where"
"1";"SIMPLE";"l";"ref";"ID_TOPIC";"ID_TOPIC";"3";"rawk_forum.t.id_topic";"1";"Using where"
"1";"SIMPLE";"m";"eq_ref";"PRIMARY";"PRIMARY";"4";"rawk_forum.t.id_first_msg";"1";"Using index"

[SMFHacks.com Team]

Hmm lets try an order change try this

Code Select Expand


SELECT DISTINCT l.ID_TOPIC, t.num_replies,t.num_views,m.id_member,
        m.poster_name,m.subject,m.id_topic,m.poster_time,
        t.id_board, g.tag, g.ID_TAG
         FROM (yabbse_tags_log as l, yabbse_boards AS b, yabbse_topics as t, yabbse_messages as m)
          LEFT JOIN yabbse_tags AS g ON (l.ID_TAG = g.ID_TAG)
         WHERE  l.ID_TOPIC = t.id_topic  AND t.id_first_msg = m.id_msg AND b.ID_BOARD = t.id_board AND t.approved = 1 AND 1=1 ORDER BY l.ID DESC LIMIT 20



Also one more index
ALTER TABLE smf_tags_log add index id_tag (id_tag);

[FrizzleFried]

Just checking up on this mod.  I have it installed and it's used quite a bit.  I've changed the "look" the entry and stats/cloud screen to match 2.0.2 headers etc... but there are a few things that I don't have the skill to do.... and I was wondering if they are on the "list" of improvements?

First off, some punctuation isn't parsing right and comes out as the code for said punctuation (comma, ampersand, more likely). 

Secondly,  this mod is SCREAMING for a javascript/some other way to enter the tag on the fly without having to load a separate page and/or reload the page... similar to Vbulletins tags...

Thanks!

[vbgamer45]

I have a developer assigned to work on this mod. Hopefully either end of this month or next month.

[abhi]

Hello,
The text Tags: not showing on new post pages. Please help me to make that showing vbgamer45

[SMFHacks.com Team]

Should be in your themes/default/languages/modifications.english.php

If you have a custom theme with a modifications.english.php it would need to be copied their too

And also to any modifications.*.php in your default theme languages folder.

[abhi]

Please give me the steps? Your reply so pro. I'm totally beginner

[abhi]

Me copied modifications.english.php to the using themes language folder but not showing. Still waiting for reply

[SMFHacks.com Team]

IF SMF 2.0 try to clear cache under forum maintenance.

[abhi]

IF SMF 2.0 try to clear cache under forum maintenance.

Not working! Cleared cache too

[abhi]

Using theme is Inferno Design By DzinerStudio