Hi,

I thought I already posted this, but must have made a mistake

Anyway, althought I've had GT products since 1998, I still have trouble editing and modifying them (my fault completely!). Basically I'm looking for some help with LinksSQL 2.0.5.

I want Links to check each search_term against a special list of keywords. If there is a match then "A" happens, if not then "B" happens. The list of special keywords will be made by me and probably just uploaded as a text file or whatever you suggest.

I'm sure this is easy enough for "oldies" like Pugdog and Eliot!

Regards,

JeffB.

Anyone got any ideas - I thought it would be fairly simple

Hello, Jeff.

The logic you would have to apply is the following:

1) Create a table that stores the "special keywords". Call the table something like Links_SearchTerms with the following attributes:



2) Create a global that uses the following SQL Statement:



In this global, return the total number of matches. $query is the var for the keywords entered.

There are quite a few examples of creating globals in this forum and some are linked in the Resources section.

3) Then in your search templates, you can reference the global and set up some conditional statements.

Like:


========================================
Buh Bye!

Cheers,
Me

In your search results template you can put:

<%if query eq "keyword"%>
.. do this
<%else%>
.. do this
<%endif%>

That does an exact match. If you want to do something more complicated, you would need to use a global. Add:

keyword_case =>


You could then put <%keyword_case%> in your search_results template.

Cheers,

Alex
--
Gossamer Threads Inc.

Alex (and Eliot)

Thanks for your solutions. Alex: Your solution looks great, but I would like it to check a file of "special" keywords, rather than a list within the global.

What do I need to alter in your code above to do this?

Thanks

JeffB.

any further ideas?

JeffB
GT customer for 6 years (and counting!)

I could really do with this kind of modification. The framework is above but I need more specific instructions. Any help would be great

JeffB
GT customer for 6 years (and counting!)

What format is the file in? Would an array loop not be better?

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Hi,

Thanks for your reply. It doesn't really matter what kind of file the list of keywords is in. The reason why I didn't like Alex's suggestion above is because we might have over 500 keywords and that would make a very large array within the global.

Here is an overview of what I need...

1. User searches for a celebrity, i.e. Cameron Diaz

2. Links checks the keyword ("Cameron Diaz") against a list of celebrity names. These names will represent all the celebrities we have forums for. If there is a match between our list and the user's keyword, then Links will display "Visit our Cameron Diaz forum" otherwise it will just display "Visit our Fan's Forum".

I hope this makes things clearer. I'm sure that this can't be very hard?

JeffB

JeffB
GT customer for 6 years (and counting!)

>>
The reason why I didn't like Alex's suggestion above is because we might have over 500 keywords and that would make a very large array within the global.
<<

How about listing the words in a file and reading the file.

Yeah, exactly what I was thinking Paul. Maybe something like;


No guaranteing it will work. The file format needs to be something like;

keyword::some html or whatever here (use whatever divider you want, and then use the split() command to cut it up).

Hope that helps.

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Well that won't work because you aren't going to get past the first line of the file before it returns....and you'll have an open filehandle.

Any further ideas on this? Do you think I should re-post this question in the Mods & Customizations forum? I could really do with a solution to this as it's been a couple of months since I first asked about it. Any further ideas on would be great!

JeffB
GT customer for 6 years (and counting!)

You could either create a new table and select the words from it, or upload them in a text file - depending on the number of words/searches will depend on which option you should choose.

Nice avatar Paul

I will probably have around 500 terms, so which one do you suggest? Also, can you give me some pointers on the code I need to use? I'll send you an Amazon gift voucher if you can help me

JeffB
GT customer for 6 years (and counting!)

Hi,
Please tell me what you want to display when match the term or not match.
I suggest that plugin hook in the search function should be sufficient.

Regards,

Beck

If someone searches for a celebrity and their name appears in my special list then I want links to say "Click here to view "Celebrity Name" photo gallery" otherwise if there is no match it should return "View photo galleries".

JeffB
GT customer for 6 years (and counting!)

Hopeful bump

Anyone?

JeffB
GT customer for 6 years (and counting!)