[mod] Story tags and Story Tag Cloud

Is it possible to add the table prefixes on SQLing?

(Unsure as to where it gets affected in the files)

eta: Testing on my demo site.

variables.php gives the error "Parse error: syntax error, unexpected $end"

So:

	else {
$ft_output .=" Be the first to add a tag to this story ";
}
} // added
$ft_output .="<br />";

Works.

And

A fatal MySQL error was encountered.
Query: SELECT stories.*,stories.sid, author.username as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (vb_user as author, fanfiction_stories as stories) WHERE author.userid = stories.uid AND stories.validated > 0 AND stories.sid = 1 LIMIT 1
Error: (1146) Table 'accionu_demo.vb_user' doesn't exist

Appears when clicking on a tag. (adding it is fine, though)

I'm assuming this is because you have it with VB. 😛

Eta II:

To fix that ...

tags.php -> ~line 63

$taglink = dbquery("SELECT stories.*,stories.sid, author.penname as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (".TABLEPREFIX."fanfiction_authors as author, ".TABLEPREFIX."fanfiction_stories as stories) WHERE author.uid = stories.uid AND stories.validated > 0  AND stories.sid = ".$tagsid." LIMIT 1"); 

It was mainly trial and error ... but it works for me right now.

ACK!!  Totally missed the SQL queries.  Bad me...bad!!

I will get that corrected and uploaded.  Thanks for hunting down the bugs 🙂

For the variables.php edit I missed the final }.  Where you put it is fine, but it will do some unnecessary work as a result.  Put that } after the last line and it should work.  I will edit the post to get that updated.

I'm not good with the PHP so I decided to put it where Notepadd++ was giving me the +/-. 😛

I'm editing it to make it a touch semantic, then I'll show you and see if it's okay?

Script has been updated.  The query in tags.php is now correctly using definitions setup in queries.php, so it should work no matter if there is a bridge or not.

Let me know how this version works for you.

Brainstorming here for a moment.

I am wondering if the code that is currently executed in variables.php would be in a better spot by using the hook in viewstory.php.  This would put the execution at the end of the script so I can capture the story owner ID (so authors can delete tags from there stories).  I am going to have to play around with this a bit and see what works best.

Edit - Test has gone very well, so I will be adjusting the instructions to use the hook in viewstory.php.  New version should be up in a bit.

Updated to add a "Similar Tag" function when viewing an individual tag.  This uses one of the api's functions, weighing related tags based on number of objects that share the tags.  Higher weight increases the size of the tag.

There is a small bug that causes two warnings if there are no related tags.  I am working on this for the next version.

There is also a "Related Object" function that I am working to add to viewstory.php.  What it will do is allow us to generate a list of related stories based on shared tags and strength of the tags.  This will be grouped into a tpl variable to be included in viewstory.php output.

To upgrade from previous version just overwrite the files.

I am also putting together a very basic installer to run the sql queries.

Oh tags!! Wonderful, I've wanted to have tags for eFiction for ages. As soon as the weekend is arriving I'll be trying that one.

I am hoping to have an install script by then so you will not have to run MySQL queries by hand.

The next version is in testing on my site.  It fixes the related tag issue and adds a "Similar Story" tpl variable.  What this does is check for other stories that share the same tags as the one you are looking at and shows them in a list on the viewstory page.  The idea is to allow people to see stories that may also interest them.

And I thought I was the only person who looked at eFiction and said "We needs tags with this..."  🙂

I can already see that my users will love this. I certainly find tags very useful!!

Has the zip been updated with your latest fixes?

Just updated to latest version.

Fixed the warnings on stories with less than 2 tags
Added related story variable
Added tag cloud block that can be included on the index page.

I will get the instructions updated now. 

http://demo.accio.nu/efic/tags.php for semantic-ism. Though, I have yet to use the updated version.

I'm still in the midst of contemplating on whether my users may benefit with this or find it too bulky for our archive. 😛

I will be eventually adjusting the output to allow for easier skinning, just not there yet 🙂  Looks really good on your test site, I like how you set it all up.

Next version is mostly bug fixes.  I am testing it now and will have it posted tomorrow.

- Added member check to all forms.  They will no longer display unless the user is logged in.
- Form processing also checks for member login
- Inputs are now run through escapestring function to sanitize the inputs
- Cleaned up the code a bit, had 2 areas checking for the same things.
- Added ability for author to remove any tag from there story.
- Added basic install script to automate setup, no more running the SQL by hand.

Once I test it out I will post the code....probably tomorrow during my morning coffee 🙂

Edit:  It is morning, I have my French Vanilla coffee (Milk, 2 sugars, bit of cinnamon and chocolate flake) and the next version has been posted.  Not sure what other features to add...possible something for people to track the tags they added in there profile.  Suggestions are welcome 🙂

I am currently working on a panel for the user page.  It shows the tags that a user submitted.  It works but I am trying to figure out how to handle the skinning...so it may be a few days before I release it.