Sitemap

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
jmulvey
Posts: 6
Joined: Mon Oct 25, 2010 3:43 pm
Location: Durham, UK

Sitemap

Post by jmulvey »

Is it possible for me to reconfigure the Sitemap option.

Instead of it loading the Letters and Question which means that the question "How do I upload and Assignment?" goes under the sitemap under H", I would like to reconfigure it to take the first letter in the "Keyword" option.
Is this possible as I think this would be much more useful than me renaming my questions "Assignments - How do I upload?" just to get it to go under the "A" listing.

Thank you very much
J
Last edited by jmulvey on Fri Oct 29, 2010 5:23 pm, edited 1 time in total.
jmulvey
Posts: 6
Joined: Mon Oct 25, 2010 3:43 pm
Location: Durham, UK

Re: Sitemap

Post by jmulvey »

Thank you - I have worked it out but just in case anyone else wants to do this I edited the inc/sitemap.php file:

Code: Select all

                    AND
                        SUBSTRING(fd.keywords, 1, 1) = '%s'
                    AND
                        fd.lang = '%s'
                    AND
                        fd.active = 'yes'
                    AND
                        %s
                     order by keywords",
My only hope is that I haven't messed anything else up with this change but all seems to be OK :D
Thorsten
Posts: 15815
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Sitemap

Post by Thorsten »

Hi,

that's the correct way. :-)

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
jmulvey
Posts: 6
Joined: Mon Oct 25, 2010 3:43 pm
Location: Durham, UK

Re: Sitemap

Post by jmulvey »

Just another question please.

I've been asked to see if I can get the question to appear under several alphametical entries in the sitemap. So for instance "How to I upload a Turnitin Assignment?" I would like to go under T and A. I have this now working on the 1st letter of the 1st keyword but in the substring I could have multiple keywords. Is there a way to get it to rotate through the substring entries? A long shot I know but it would be useful.

Thanks you very much again :D
Thorsten
Posts: 15815
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Sitemap

Post by Thorsten »

Hi,

this isn't possible and it will be hard to implement by one single query because I see the problem to decide the characters to choose for the sitemap.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply