Missing titles for Topic Reply links

Newbie Joined: Nov 16, 2007 Posts: 17

Well i already tried 1 Razz

but its a bit of a pain in the ass, especially within larger threads where you have to search for the post that contains the 'offtopic' subject.

And with 'pull back' you mean, only use the original thread post subject for the title for every post? If so, yes that would be a better solution i think.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 952

this might help get you closer:

Code:

if ($p) {
   $p = intval($p);
   $sql = 'SELECT a.post_subject AS post_subject, a.post_id AS post_id, post_text, topic_id FROM ' . $prefix . '_bbposts_text a, '
      . $prefix . '_bbposts b WHERE a.post_id = b.post_id AND a.post_id=\'' . $p . '\'';
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   $asDTText['subject'] = $row['post_subject'];
   $asDTText['text'] = $row['post_text'];
   $sql = 'SELECT post_subject FROM ' . $prefix . '_bbposts_text a, ' . $prefix . '_bbposts b '
      . 'WHERE a.post_id = b.post_id AND b.topic_id = \'' . intval($row['topic_id']) . '\' '
      . 'ORDER BY a.post_id ASC LIMIT 1';
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   $asDTText['subject'] = $row['post_subject'];
   $newpagetitle = $asDTText['subject'] . $dt_sDelim . $asDTText['text'];

But, it is not returning exactly what you are wanting in terms of format. Just look at how I got rid of the "empty subject" code and added a bit more to the original SQL to pull in the original thread topic.

Newbie Joined: Nov 16, 2007 Posts: 17

Eya, sorry for the late reply Montego, hadnt got time to look at it.
I now applied it and it works perfectly, a big thnx for that Cool

Although i dont really understand those sql queries/code.

I did add in a new, how do you call this, global function(?) and 'steal' of the phpBB bull title Wink

$dt_bull = ' • ';

Just to seperate the domain title from everything in front of it, example;
Forums • website name or
Topic name - Forum section • website name

Site Admin/Owner Joined: Feb 12, 2005 Posts: 952

Wouldn't you have just done:

$dt_sDelim = ' • ';

?

Newbie Joined: Nov 16, 2007 Posts: 17

Yep could have done that but I use the ' - ' as well, im only using that 'bullit' to seperate the sitename from the rest, just as a little visual cue no SEO practise whatsoever Razz

Edit: And i couldnt find anything about the 'dynamic descriptions', cause you mentioned it was on nukeSEO somewhere, is there a discussion topic about it?

Site Admin/Owner Joined: Feb 12, 2005 Posts: 952

No, what I was saying is that it makes much more sense to do both dynamic page titles AND the dynamic meta tags at the same time and within the nukeSEO tool. Kguske agrees and intends on creating that in his next version. It has not been released yet... not even sure its status at the moment.

Newbie Joined: Nov 16, 2007 Posts: 17

Aah ke, thought it was in full development Wink

But will there be a combined version as with 'dynamic titles' or isnt that decided yet?

Site Admin/Owner Joined: Feb 12, 2005 Posts: 952

warren-the-ape wrote:

Aah ke, thought it was in full development Wink

But will there be a combined version as with 'dynamic titles' or isnt that decided yet?

That is exactly what I mean. Both of these great tools ( Laughing

) deal with HTML that is between the HEAD tags and also are for SEO purposes, so it just makes sense to me (and others - see the poll at nukeSEO.com).

Newbie Joined: Nov 16, 2007 Posts: 17

Hmm i cant find that poll on nukeSEO Sad

do you have a link?

Site Admin/Owner Joined: Feb 12, 2005 Posts: 952

Looks like he has taken down the block, but here is the survey:

http://nukeseo.com/modules.php?name=Surveys&op=results&pollID=4&mode=nested&order=0&thold=0

It wasn't this "skewed" by "More search engine submission options" when I looked at it last.

Newbie Joined: Nov 16, 2007 Posts: 17

thnx, heheheh indeed, its a pretty lost battle Laughing

Dont even know what i should expect from 'Additional search engines (submission, results)' ? (is that the sitemap stuff, im not into nukeseo's package at all).

Btw what metadata are you personally interested in? I can imagine that the 'description' -tag has your highest (and perhaps only) interest?

I think my next (personal) step on our forum would be to update/upgrade the semantics, adding a few various heading tags to the frontpage and forum and perhaps write a new 'site navigation' -block, replacing the standard junk for more appropriate semantic (ul/li) markup.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 952

I am specifically interested in dynamic page titles, meta keywords and meta description.

IMO, what is absolutely essential about nukeSEO, is the ability to dynamically generate a Google sitemap. Simply give the sitemap URL to Google's sitemap tool and it will pull the latest-and-greatest automatically even as your site's content evolves. It really helps with the crawling of your site.

Since I did ShortLinks, DynamicTitles and nukeSEO all at the same time, it is hard to tell exactly what pulled me up from 1 to 4 in PageRank but I was, for the longest time, in no-man's SEO land... There are things yet that I can do to help even further I feel, but those are to come...

Newbie Joined: Nov 16, 2007 Posts: 17

Well, "Content is King" as some wise folks say Razz

So it might as well be your content responsible for it instead of other improvements.
Although i do believe that dynamic titles and structured links help supporting that content Smile

I think i'll soon have a look at that sitemap add-on, and give it a go.

But wouldnt the 'meta keywords' be a bit useless? I mean most big search engines like google just ignore them, and i could also imagine that it would be hard to auto-generate keywords for a specific page?

Site Admin/Owner Joined: Feb 12, 2005 Posts: 952

warren-the-ape wrote:

But wouldnt the 'meta keywords' be a bit useless? I mean most big search engines like google just ignore them

Do you have specific references that I could review with proof of this? Thx.

Quote:

i could also imagine that it would be hard to auto-generate keywords for a specific page?

It can be done and a few folks have actually incorporated the concept into a form of shortlinks, but I would need to go back and dig up the references. (Can't remember if it was in these forums or Raven's where the thread was.)

Newbie Joined: Nov 16, 2007 Posts: 17

montego wrote:

Do you have specific references that I could review with proof of this? Thx.

Well perhaps i should have been more specific in saying that the use of meta-keywords are of very minimal (to none) effect on your rankings.

Especially when they dont reflect the keywords used in your page content (of course less of an issue when they are dynamically genereated Wink

).
I dont say you should leave them out but i do think they are of far less importance than the description tag, which has the big advantage that it has (or can have) a big effect on the click-through-rate (CTR) of a link.

Some (fun) reads;
- SEO "Don'ts": 20 Fatal Mistakes You Must Avoid To Succeed
- Top Ten Organic SEO Myths

A few other links;
- http://www.seologic.com/faq/meta-keywords.php
- http://searchenginewatch.com/showPage.html?page=2165061
- http://searchenginewatch.com/showPage.html?page=2167931
- http://www.highrankings.com/metakeyword.htm