Dynamic Meta Tag Mod

Guardian2003 · Posted: Thu Oct 05, 2006 8:51 pm

I don't see the need for adding extra fields to core nuke tables.
As we are discussing module dependant meta and title data, all thats needed is one query in each module inde file to grab whatever is in the table based on the modules name.
This would make the retrieval of data from the database completely independant of the current core nuke tables.
In fact, it has already been done Wink

Misha · Posted: Thu Oct 05, 2006 9:06 pm

Absolutely Smile

Espesially if its done already.
It is just slightly different approach, compared to what dconnor asked for initially, and what he claims is working like a charm for him. His idea, as I understood it, was to have as many pages as possible with different set of titles and tags each, in order to get maximum possible google primary listings. With your approach, you get one unique set per module - which translates into 20-30 primary listings per site maximum. Much better than I still have now, though Sad

Dawg · Posted: Fri Oct 06, 2006 5:16 am

Guardian2003 wrote:

I don't see the need for adding extra fields to core nuke tables.

Not mucking with the Core Tables is a GOOD thing. Dyn Titles.....with set tags for each Mod would go a LONG LONG way for nuke.

I am kind of glad I have been so busy now. I am dieing to put this iunto service but I have been too busy to do it as of yet.

Guardian2003 are you going to release what you did?

Dawg

Guardian2003 · Posted: Fri Oct 06, 2006 8:34 am

I will be releasing a beta version as soon as I can find the time but it will be after the next release of Raven Nuke as I have to concentrate what time I have to QA testing that.

montego · Posted: Fri Oct 06, 2006 6:49 pm

Wow! You all have been BUSY! Took awhile to catch up. Man I love this community! So full of great ideas and collaboration. I personally appreciate all the ideas posted thus far, and look forward to what you have coming Mr. G. Laughing

Since I have jumped a bit into the SEO "foray" with the SEO-controversial TegoNuke(tm) ShortLinks (aka: GoogleTap or GT-NExtGEn), I was already thinking of trying to address this as well. Would love to see this all somehow get wrapped up into one neat nukeSEO package from

Only registered users can see links on this board!
Get registered or login to the forums!

Kguske, are you out their buddy? Wink

Misha · Posted: Fri Oct 06, 2006 7:01 pm

Dawg wrote:

Not mucking with the Core Tables is a GOOD thing.

Why is this?
I (on my current level of understanding PHP, MySQL, and Nuke) do not see much difference between adding fields to existing table and creating new table. And, from my database development experience (limited as it is), I do not see any point in keeping separate tables in this case, as the second one is really just extension of the first, and contains one row per one row, with the same index.
Sorry my ignorance Smile

montego · Posted: Fri Oct 06, 2006 7:13 pm

It is because then you have to find ALL of the relevent SQL throughout your PHP-Nuke installation which executes against the nuke_modules table and possibly change it.

For example, if you try and insert a row into nuke_modules and the column count isn't exactly right, mySQL is going to error that out. Depending upon how an UPDATE statement or SELECT statement is written/used, you may get a similar result or odd functional behaviour.

When someone else is providing updates to the "Core", such as with the Chatserv patches and RavenNuke, it is usually better to not customize (hack) the core tables as much as possible. We have probably hundreds of posts on these forums related to issues with upgrading/downgrading and other module add-ons having issues with RavenNuke 2.x because of the NSN Groups integration, which, BTW, modified three key core nuke tables!

There is the theoretical and then there is the practical. I will, at times, even de-normalize a data structure for performance reasons or even other reasons, while the "textbook" reaction might be "why would you ever want to do that"... at least from those who live in the theoretical world (not saying that is you, just making a point).

Misha · Posted: Fri Oct 06, 2006 8:12 pm

Aha!

I did suspect my understanding is limited Smile

Thanks, it makes much more sense now.

Guardian2003 · Posted: Fri Oct 06, 2006 9:28 pm

Quote:

look forward to what you have coming Mr. G.

Well it is nothing special but I'm tinkering with it as time allows and yes I agree wholeheartedly it would be very nice to have one all round 'SEO' package for users to enjoy or at least several modules that can work harmoniously together.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

I hear ya... We will integrate dynamic meta tags, titles and descriptions into nukeSEO very soon. Montego and I have had several discussions about this, and, with input from Guardian and others, we'll make sure it works with RN.