Geek AutoLinker 4.02

[The Geek]

HowdA All,

Welcome to Geek Autolinker 4.0 from the makers of Geek Autolinker 2.0 and Tang - the stuff the people in space drink.

posts for version 4.0 start here (https://vborg.vbsupport.ru/showpost.php?p=651641)

What it does:
It allows you to specify key words to replace in posts with ANY FREAKING URL YOU COULD THINK OF. Thats right, you to can now have key words automatically url'ed to other areas of the world wide web.

Now in 4.0 you can create popups, track impressions and click-thrus, get statistics on them and specify more attributes of the links. The popups can now also use bbcode to create virtually any kind of popup you could imagine. You can limit categories of links to certain forums and also enable specific usergroups to toggle GALs on or off (by category).


This is a perfect gift for sponsors, click throughs, referal programs, definitions, instructions, birthdays and other celebrations.

Example:
If I define Bob as a keyword that I would like to automatically come up hyperlinked to bob.com all I have to do is say so (well, you put it into the admincp). Presto! As quick as that, everytime a user sees the word bob, bobs, bob! Bob bOb? etc... it comes up linked to bob.com

How much will bob love you?

If the url you want it to jump to is actually a thread on your site, you can use the nifty ignorethreadid option. Heres how that works:

If I have a thread entitled Reputation and how to use it, I can put the word reputation into the Geek AutoLinker with the URL pointing to the thread about reputation. Then everytime the word reputation appears in someones post, anyone can click on it to learn more. Since it would be stupid to have the thread Reputation and how to use it autolink to itself, I put the threadid in the ignorethreadid box. That way all matches for reputation are linked to that thread except for the reputation matches in the thread Reputation and how to use it.

Safe mode and dangerous mode.

There are now two modes of operation. Safe mode will autolink any match AS LONG AS IT HAS A SPACE BEFORE IT. That means that <br />bob or .Bob are not valid matches and wont be highlighted. The reason for this is to prevent the autolinker messing up URLs with matches in them (like www.bob.com (http://www.bob.com/)). Safe mode will most likely end up with fewer matches, but no messed up URLS.
Dangerous mode however could care less about your cute little spaces. It will link them regardless. That means more matches, but a slight increase that an existing url might break in a post.

Here are some examples in action.
Keyword: freak

Safe mode.
Freak out whenever freaks freak about on www.freak.com (http://www.freak.com/)
Dangerous mode:
Freak out whenever freaks freak about on www.<a href="www.freak.com">freak</a>.com

Other stuff:

Category management - allows you to override global settings
Limit - limit the number of replacements per link per post
Ordinal - organise the order replacments are made
Customize your own replacment code on a global, catergory, or individual level.
The installer is a prototype GISH installer that does the file edits for you. Please check the readme for details on how it works - its pretty cool).
Upgrading

Download, replace all existing files with new ones.
Run the gal4_install.php file (in your admincp)
Follow the upgrade path.
The system will ahve you manullay chage any files it can not find to update.
DEMO: http://www.thenailgeek.com/showthread.php?t=11011 (note the words MMA and PREP. If you follow to MMA you will notice that MMA isnt linked in the final article thanks to ignorethreadid)

Difficulty: Easy
File mods: 4 simple ones
Added queries: 0 or greater depending on your settings

Updated 10.5.05 - Major
Massive update in functionality

Updated 13.4.05 - Major
Massive update in functionality

Update 25.03.05 - oops!
Changed readme addition to functions_showthread.php Things look good now :)

Updates 25.05.05 to v.204 - sneaky bug
Thanks to Razz - I found 2 minor typos that end up causing people working in safemode to actually be working in danger mode! To upgrade, simply check out this post (https://vborg.vbsupport.ru/showpost.php?p=617293&postcount=155</p><p style=)

Updated 12.2.05 to v. 2.03 - ultra minor
Fixed a typo in readme. To upgrade, al you need to do is edit admincp/index,
do a search for
construct_nav_option($vbphrase['GAL_add_new'], 'GAL_admin.php?do=create');
and replace with
construct_nav_option($vbphrase['GAL_add_new'], 'GAL_admin.php?do=add');

Updated 11.2.05 - ultra minor
Fixed a typo in README (dont worry, it wasnt in the instructions)
Stopped phrase text spitting out during install. Some of the phrase is html so it looked confusing to new installers.
Removed reference to GAS3 settings in the install. This is because its the same installer. Just forgot to remove that line.
All in all, this was just a typo fix. There is no upgrade because there are no problems with the code.

Updated 10.2.05 - minor
Found a couple typos that affect safe mode.
Nothing major - just replace the GAL_admin.php file

Updated 10.2.05 - Major
Completely re-written.
See README for upgrade instructions.

Update 10.2.05 - minor
Updated include/geek_autolink.php as it was missing a table_prefix
To upgrade, download latest package and replace your geek_autolink file.


nJoy

[yoyoyoyo]

very cool- kinda like a wikipedia :)

[nexialys]

for your links related thing: https://vborg.vbsupport.ru/showthread.php?t=69077

[The Geek]

for your links related thing: https://vborg.vbsupport.ru/showthread.php?t=69077
Thanks nexialys, though I think that is a little different than the control I want.
I run a professional nail site (could you guess). If someone types in What is MMA? in a post, I want MMA to automatically link to a Geek Article on site. What I dont want is that article (or thread) to automatically highlight all instances of MMA which would simply refer back to itself (if you know what I mean!). Thats what the ignorethreadid is for ;)

[nexialys]

no, i was relating to the fact that if users quote a url in a thread that is related to another thread or forum in your board, it would display that thread or forum title, ... maybe this can be added as a feature on your system.

[noppid]

Have never found a way around this (maybe someone here can help). If you are replacing bob with www.bob.com and somone puts in a link to www.hithere.com/I_am_bob.html it will screw up their link.

When the user posts the word they want parsed, save it as...


$word = " " . $word . " ";


So when it's retrieved it's parsed as Space bob Space.

Maybe you tried that? Just a thought.

[KTBleeding]

Oohh, you know what would be cool TNG?

When creating an article in the Geek Article System, it will automatically add the article name/url into an auto linker system like this. That would be awesome. hah.

[The Geek]

in the Geek Article System, it will automatically add the article name/url into an auto linker system like this.

Theres an idea! Ill mull that one over for awhile.

noppid: The idea is that keywords are highlighted without them even knowing about it. Otherwise the previous suggestion would be the perfect hack.

Say you have eBay as a sponsor. Well, everytime eBay is mentioned- it will link it automatically.

Hope that makes sense.
I am mulling over adding a post field to disable it (like disabling smiles). That way if a user notices a link of theirs messed up (or knows ahead of time that it will get messed up) they can simply tick the 'do not autolink me'. Im only hesitant because I hate making DB changes to vB db's.

[noppid]

I phrased that wrong.

In the ACP code before the insert of $replace on action create, add the spaces at both ends of $replace. This way later when it's called to be looked for in a post to do a replacement, you are looking for Space bob Space instead of just bob which can be embedded in words.

"bob" can be found embedded in words.

" bob " is a stand alone bob.

[The Geek]

I phrased that wrong.

In the ACP code before the insert of $replace on action create, add the spaces at both ends of $replace. This way later when it's called to be looked for in a post to do a replacement, you are looking for Space bob Space instead of just bob which can be embedded in words.

"bob" can be found embedded in words.

" bob " is a stand alone bob.
ah... gotcha. I used to do that. It works... but the trade off is that the following doesnt get picked up with a trailing space:
bobs
bob.
bob!
bob?
etc...

The leading space is the best 2nd option. Where that fails is:
Bob at the start of a paragraph
or .Bob at the start of a sentence with no space (or other mark like ").

So, it is a bit of a trade off. If you want less likely to screw up links... add the spaces (I would add only one space). However in over 2 years of using this... I have only had about 3 screwed up links. Saying that... it could be more for sponsored links. Take eBay for example. You can autolink all ebays, however any user linking to www.ebay.com would have their link broken.

Maybe an option is in order!

What do you guys think? Option to turn on leading space? Personally, I would opt out of training space becasue of punctuation issues.

[noppid]

I see your point. Too much code would be a bad thing. Compromise is good.

Nice hack.

[Lionel]

Isnt it the same thing accomplished now with replacements variables?

[rex_b]

I'm getting errors b/c my prefixes are not default vb prefix, I have changed them. Could you make the hack work without having default named vb prefixed.

[trainer]

will this work without adding the geek article hack?

so every time bob is posted in a thread or has been posted in a thread it will link to whatever url we want?

[The Geek]

Isnt it the same thing accomplished now with replacements variables?
@Lionel: Nope

@Rex: Updated the geek_autolink file. It was missing a table_prefix. Could you please click install so you are notified of changes?

@trainer: Yup, will totally work without GAS3. And yes, everytime bob, ben or bertha (or whatever you want) appears in a post... it will link it to whatever url you want.

HTH's

[OrangeFlea]

So basically, the admin or the owner of the forum would have to input the individual URLs for all the corresponding words he/she wants hyperlinked? For example, on a video game message board, you could have words like "Mario" or "Halo" become actual links to Nintendo.com or Bungie.com?

I've seen this feature executed before and I was wondering if there was a master list available for Amazon.com keywords, to save me the trouble of manually hyperlinking every book title.

[The Geek]

So basically, the admin or the owner of the forum would have to input the individual URLs for all the corresponding words he/she wants hyperlinked? For example, on a video game message board, you could have words like "Mario" or "Halo" become actual links to Nintendo.com or Bungie.com?

I've seen this feature executed before and I was wondering if there was a master list available for Amazon.com keywords, to save me the trouble of manually hyperlinking every book title.
Thats correct.

I dont know of any master list, though it is quite a cool idea ;)
Doesnt Amazon use refererids? If that was the case, a master list might not work (unless you didnt care about thre refererid).

[OrangeFlea]

Another question, does the feature work in retrospect? Meaning, will it convert all targeted words even those made prior to the hack's installation, or will it only apply to subsequent entries?

[The Geek]

Another question, does the feature work in retrospect? Meaning, will it convert all targeted words even those made prior to the hack's installation, or will it only apply to subsequent entries?
It works on all posts regardless of if they were posted before or after the hack as the links are made at the time of viewing the thread (woo-hoo dynamic!). For instance, adding 'fred' in the sytem will instantly makes all occurences of fred in posts hyperlinked, Have a fall out with Fred and dont like him hyperlinked? Take fred out of the system and he wont appear hyperlinked anymore.

Cool eh?!

[Ghostsuit]

Really nice hack. I notice you say it add's one queries is that no matter how many links are checked?

[The Geek]

Really nice hack. I notice you say it add's one queries is that no matter how many links are checked?
Yeas ghostsuit. It pulls all of the replacements in one go and then does one replacementcall using an array of the data from the one pull

Thanks ;)

[OrangeFlea]

About using the amazon.com referall program in association with this hack...

I have an amazon.com search thing on my forum, and when members use it to look for a book or a product, naturally I get the credit for it. However, I've also noticed -- and I don't know if this is FACT -- that when members browse amazon.com after making the initial search, they're still browsing under the referral system, as long as they don't reload Amazon.com or close their browser. Based on this theory, wouldn't it make sense, when using your hack, to hyperlink words with the URLs that have your referall id in them?

Am I making any sense?

[ericgtr]

This works great! I like how you've avoided anything to do with functions_bbcodeparse :D Installed!

[The Geek]

About using the amazon.com referall program in association with this hack...

I have an amazon.com search thing on my forum, and when members use it to look for a book or a product, naturally I get the credit for it. However, I've also noticed -- and I don't know if this is FACT -- that when members browse amazon.com after making the initial search, they're still browsing under the referral system, as long as they don't reload Amazon.com or close their browser. Based on this theory, wouldn't it make sense, when using your hack, to hyperlink words with the URLs that have your referall id in them?

Am I making any sense?
Yup. Thats what I mean about a master listing. If there was a master listing of say Amazon book names with matching URL's (including a referal ID) then you would still have to edit them to put in YOUR referal ID.

In a nutshell, this hack will do exactly what you are trying to do. Everytime someone types in the joy of sex it will hyperlink it to the joy of sex at amazon.com with your referal id.

Hope that makse sense!

erictr-> Thanks man :)

[OrangeFlea]

Forgive me, my man. I forgot to congratulate you on this remarkable hack. It's a wonderful and helpful tool you've made and provided for us, Sir Geek. I'll be looking forward to seeing your future releases!

[The Geek]

congratulate you on this remarkable hack. It's a wonderful and helpful tool you've made and provided for us,

Anytime Sir Flea ;)

Just do me a favour and toggle the ol install switch if you use it :)
(I may have something cool on the way)

[Ghostsuit]

Installed. I have to say I'm finding far to many of your hacks jsut exactly what I need :D

[trainer]

will this hurt a larger site? slow it down?

[The Geek]

will this hurt a larger site? slow it down?
not really. I would say that it more depends on the #of replacements you had.
Obviously replacing 5 keywords is a lot faster than replacing 1000 keywords.

[The Geek]

I know everyones going to kill me... but I am just putting the finishing touches on an upgraded version that is substantially faster (not that this is slow by any means) and eliminates the query, include file,the array walks, and the inline replacments. I have re-coded it to build these up in the admincp when ammendments are made. It then stores it in the datastore.

I am also putting in the option to add an additional leading space to eliminate breaking existing URLs. The flip side to this is that the key word must have a space infront of it to be a match.

Ill post more when I have the update.

Give me an hour (PS- the upgrading process should be a snap so dont anyone get fidgety with me ;) )

[OrangeFlea]

I was wondering (hey, they don't call me flea for nothing...)

- Will the links open a new browser window or will they not? (Is there an option to change this?)

[Revan]

However sometimes the phrases will not appear until you edit one of the new phrases and save it (dont ask me why).<br />If after you have finished the installation, you dont see any phrases, search for phrase GAL_ ... edit it and then save it.
Or you could just run build_language(); after the phrase insert ;)

You see me not having install clicked because well I didn't install it :p
I just heard about this from a mate and checked out the install script.


//peace

[ericgtr]

I was wondering (hey, they don't call me flea for nothing...)

- Will the links open a new browser window or will they not? (Is there an option to change this?)
Yes, they open in a new window, it appears to act as if a link was simply posted in the thread. There is no configuration to keep it in the same window although you could probably add a _self somewhere if you wanted.

[The Geek]

I was wondering (hey, they don't call me flea for nothing...)

- Will the links open a new browser window or will they not? (Is there an option to change this?)
yup, Links open in new window.

Revan-> I do call build_language (several times for good measure ;) )

[Revan]

Yea so you do.
But you always rebuild the master language, and unless your phrases are meant to disappear after a vB upgrade, I would suggest you insert them in whatever language is default.
Calling build_language on the language you inserted the phrases in (or without an argument at all) WILL eliminate the need for such an "edit 'n' save", but if your script behaves otherwise then there's a bug :p

[The Geek]

Yea so you do.
But you always rebuild the master language, and unless your phrases are meant to disappear after a vB upgrade, I would suggest you insert them in whatever language is default.
Calling build_language on the language you inserted the phrases in (or without an argument at all) WILL eliminate the need for such an "edit 'n' save", but if your script behaves otherwise then there's a bug :p
ah right. I used to insert into languageid 0, then I was told to do -1.

What ID should I use and do I pass the ID along with the build_language()?

I would LOVE to sort this out. Its a serious butt pain!

(sorry for going off topic... Im just greedy :) )

[Revan]

Well for my RPG hack Im gonna just parse an XML file of phrases... I guess that imports into the default language.
I always call build_language() without arguments, because I quite frankly have no idea what language its inserting into (or I can't remember), and in an installer that runs 650+ queries already, whatever takes to rebuild all languages is neglible.

I spose there's a $vboptions for what language is the default, try pissin about in the acp for it.

//peace

[The Geek]

Updated package to 2.0.


Major release. Upgrade instructions in README (takes about 5 minutes). Loads of improvements (see first thread).

nJoy

[KTBleeding]

If I have a thread entitled Reputation and how to use it, I can put the word reputation into the Geek AutoLinker with the URL pointing to the thread about reputation. Then everytime the word reputation appears in someones post, anyone can click on it to learn more. Since it would be stupid to have the thread Reputation and how to use it autolink to itself, I put the threadid in the ignorethreadid box. That way all matches for reputation are linked to that thread except for the reputation matches in the thread Reputation and how to use it. That sounds awesome!! Once I get vBaGallery figured out, I'll give this install a whirl too.

[The Geek]

Well for my RPG hack Im gonna just parse an XML file of phrases... I guess that imports into the default language.
I always call build_language() without arguments, because I quite frankly have no idea what language its inserting into (or I can't remember), and in an installer that runs 650+ queries already, whatever takes to rebuild all languages is neglible.

I spose there's a $vboptions for what language is the default, try pissin about in the acp for it.


//peace
Thanks Revan - calling build_language() is the same as build_language(-1).

Still... cant seem to figure out why sometimes phrases install fine and sometimes they need the edit/save workaround. Wish it was better documented.

O well... not too big of a deal as its only occasional and if a user does run into the problem, there is a one off workaround.

Thanks for looking into it for me.

[OrangeFlea]

Sir Flea here again.

One more question: Does this marvelous tool highlight phrases? For example, if I want Catch 22 hyperlinked, will it do so as long as the words are adjacent to one another, or will it hyperlink all instances of "Catch" and "22" individually (I hope not!)?

[The Geek]

Sir Flea here again.

One more question: Does this marvelous tool highlight phrases? For example, if I want Catch 22 hyperlinked, will it do so as long as the words are adjacent to one another, or will it hyperlink all instances of "Catch" and "22" individually (I hope not!)?
Hey Flea:

It will link only Catch 22 if that is what it is set to replace.

[The Geek]

As an FYI - I just found a couple of minor typos in 2.0 GAL_admin.php file that may affect safe mode links (in rare situations). I updated the package to 2.01

To upgrade from 2.0, just replace your GAL_admin.php file with the new one.

[DrkFusion]

I just installed this, seem to have a little problem, I will get back to you with what is going on after a little digging around.

[The Geek]

I just installed this, seem to have a little problem, I will get back to you with what is going on after a little digging around.
O. Let me know. Im a little overbaked from all the recent hacking. hope I havent missed anything.

[xmitchx]

Another nice mod. Thank you :)

[rlamego]

Didn't know that you were the brains behind tang ;)
No, seriously, you hurt my feelings! You were keeping this beauty away from me =)

So, Sam, if this thing rocks as much as the comments show, why don't you make this one of the ultimate hacks several times requested but never delivered: vB Glossary?
Seems simple, just replace the link text field for a text area (or add instead of replace) and link the word to a popup window (or a neat mouseover effect) to display the text!

[The Geek]

Didn't know that you were the brains behind tang ;)
No, seriously, you hurt my feelings! You were keeping this beauty away from me =)

So, Sam, if this thing rocks as much as the comments show, why don't you make this one of the ultimate hacks several times requested but never delivered: vB Glossary?
Seems simple, just replace the link text field for a text area (or add instead of replace) and link the word to a popup window (or a neat mouseover effect) to display the text!
ooo. Is that a challenge? Sounds groovin to me.

Any links to any examples would be super.

Thanks guys.

[webrats]

im trying to make the links another color without changing the links everywhere

i see the class defined as DEF but can we add a <span> before the code on the showthread?

[The Geek]

im trying to make the links another color without changing the links everywhere

i see the class defined as DEF but can we add a <span> before the code on the showthread?
Sure webrats - but make the change in the GAL_admin.php file (in the rebuild function)as that is where all the Geek AutoLinker 2.0 changes are made. Then rebuild a viola.

I may look toward adding a setting to define the exact replacement.

Also - please click the install. Its the only charge for using the hack ;)


BTW: the links are formed on line 66 of your admincp and looks like this:

$links[]= "$leadingchar<a href='$result[link]' target='_blank' class='DEF' title='$result[description]'>$leadingstripper$1</a>

if you wanted to add a span, try this:

$links[]= "$leadingchar<SPAN><a href='$result[link]' target='_blank' class='DEF' title='$result[description]'>$leadingstripper$1</a></SPAN>

Thanks.

[The Geek]

updated package just to fix a couple of typos that were pointed out to me in the install (they dont actually affect the install though so there is no need to upgrade).

[OrangeFlea]

Sir Geek, 'tis I, Sir Flea.

Is there any way that we can input the words & and the associated links as a set or group? I've got over two hundred stored in an excel spreadsheet and inputing these one-by-one will be torture. Is there some way I can just paste and upload the two sets (words and links) to a file or something....lol

[tomshawk]

I like the concept.

This is actually a great idea but...

Before you ask, sorry I have not read through this entire thread yet, so if it has been asked and answered sorry.

Anyway...

I have a tech site, and I have alot of links already throughout the site.

I have links to http://www.transcsender.com for example

1) Now, if I add an autolink to transcender so as people type it, it autolinks. Does it go through past posts and set up links, if it does, what will it do to these pre-existing links I have?

2) When I am creating a link to another site, and the name of the site is in the autolinker, what will that do to the link I create?

Again, sorry if these questions have been answered, I'll read this thread more carefully tonight. but any help on these questions would be greatly appriciated.

Thank you

[OrangeFlea]

1) Now, if I add an autolink to transcender so as people type it, it autolinks. Does it go through past posts and set up links, if it does, what will it do to these pre-existing links I have?

I had asked this question before, and Geek informed me that the feature does, in fact, work in retrospect thus all corresponding words -- even those that predate the hack's installation -- will be hyperlinked.

[webrats]

is there a way to keep it from changing anything in [img] tags?

[The Geek]

is there a way to keep it from changing anything in [img] tags?
Use safe mode ;)

Tomshawk - safemode is the answer for what you need. There are slighlty fewer matches, but it prevents screwing up any other urls in posts.

[OrangeFlea]

Geek, will you be adding a feature that will allow users to input group keywords and their corresponding URLs?

[The Geek]

Geek, will you be adding a feature that will allow users to input group keywords and their corresponding URLs?
What do you mean by grouped key words. You mean vb, vbulletin, bb, cool all pointing to the same url?

[tomshawk]

I had asked this question before, and Geek informed me that the feature does, in fact, work in retrospect thus all corresponding words -- even those that predate the hack's installation -- will be hyperlinked.

Thanks OramgeFlea and the nail geek for answering my question ;)
I'll be installing this this weekend ;)

What do you mean by grouped key words. You mean vb, vbulletin, bb, cool all pointing to the same url?

what I think he means is there going to be an option in the future where users can add autolinks, or at least autolink suggestions. Actually I think that might be a good idea too ;)

I have another suggestion as well, The ability to add a description of the site in the autolink, and have it come up in a bubble when hovering over it.

Kind of like this http://www.computing.net/windows2003/wwwboard/forum/2751.html
Notice the word download in the message, it is highlighted in green. Hover your mouse over the word, and check out the bubble ;)

[Symbian.info]

Use install and the readme file, but did not really do the database ad, look:
Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM geek_autolink ORDER BY text asc
mysql error: Table 'mysite.geek_autolink' doesn't exist

mysql error number: 1146

Date: Saturday 12th of February 2005 03:19:59 PM
Script: http://www.mysite/forum/admincp/GAL_admin.php?do=rebuildspace
Referer: http://www.mysite/forum/admincp/GAL_admin.php?do=rebuild

How can I do it manual?

And you are talking about a include/geek_autolink.php
But there is not in the zip file! Only admincp/GAL_admin.php and admincp/GAL_install.php is the file not complet?

Thanks for any help!

EDIT: Ok did it manual (looking in the PHP file) and works now almost ok!
De safemod is not working :disappointed:
And if I press the Add new link in the admincp I get :
Thats a crummy text replacement and you know it!
But at Display it works the Add new. strange!


Wow very nice script, thanks!!

[OrangeFlea]

To expand on tomshawk clarification, I thought it would be a good idea for users to somehow add files, containing large lists of keywords and the URLs for each, into the system so they don’t have to initially add them in manually. As it stands now, if I were running a music forum, and my ambition was to have practically every mentioned album hyperlinked, I’d have to collect the URLs first (which is fine), and then manually enter each one (and the album titles) into the system once they’re all collected. I don’t know if it’s practical in terms of building something like it, but I do know it’d be easier.

[The Geek]

Use install and the readme file, but did not really do the database ad, look:
Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM geek_autolink ORDER BY text asc
mysql error: Table 'mysite.geek_autolink' doesn't exist

mysql error number: 1146

Date: Saturday 12th of February 2005 03:19:59 PM
Script: http://www.mysite/forum/admincp/GAL_admin.php?do=rebuildspace
Referer: http://www.mysite/forum/admincp/GAL_admin.php?do=rebuild

How can I do it manual?

And you are talking about a include/geek_autolink.php
But there is not in the zip file! Only admincp/GAL_admin.php and admincp/GAL_install.php is the file not complet?

Thanks for any help!

EDIT: Ok did it manual (looking in the PHP file) and works now almost ok!
De safemod is not working :disappointed:
And if I press the Add new link in the admincp I get :
Thats a crummy text replacement and you know it!
But at Display it works the Add new. strange!


Wow very nice script, thanks!!
Hey Alex, it looks like you may have an older package. Pre 2.0, there was a fucntions_geek_autolink.php file. Since then the function is inline.

I also went through the code and there are TABL_PREFIX's for all calls so once again I suspect an older version.

I did however find a typo in the changes to your admincp/index.php file. I updated the readme and noted the changes in the first post (basically replace the GAL_admin.php?do=create with GAL_admin.php?do=add

Thanks for that!

[The Geek]

To expand on tomshawk clarification, I thought it would be a good idea for users to somehow add files, containing large lists of keywords and the URLs for each, into the system so they don?t have to initially add them in manually. As it stands now, if I were running a music forum, and my ambition was to have practically every mentioned album hyperlinked, I?d have to collect the URLs first (which is fine), and then manually enter each one (and the album titles) into the system once they?re all collected. I don?t know if it?s practical in terms of building something like it, but I do know it?d be easier.
Hey guys,

I know where you are coming from... but to be honest I am not planning on doing something like that (though it would be really easy to do). One reason why is that you would almost need a moderator ability otherwise a user could really mess up your boards big style.

I would rather do the yellow popup box mentioned eariler first - though to be honest I am not even planning on doing that for a little while. I am knee deep in doing some wicked additions to geek articles 3 that I want to focus on. Then I have already started work on geekbay ;)

[wirewolf]

First - Clicked Install, nice hack nail geek.
im trying to make the links another color without changing the links everywhere............................I did this to change the color of the GAL_autolink:
find in GAL_admin.php, line 66:
$links[]= "$leadingchar<a href='$result[link]' target='_blank' class='DEF' title='$result[description]'>$leadingstripper$1</a>";
Change to this:
$links[]= "$leadingchar<a href='$result[link]' target='_blank' class='DEF' title='$result[description]'><font color='#FF0000'>$leadingstripper$1</font></a>";I chose Red (#FF0000)(same color as used in search.php) but you can put in any color.
Here's an example from one of our posts (http://shipmodeling.net/vb_forum/showthread.php?p=1099&highlight=finish#post1099) (I used the word "Finish" as a test autolink to one of our members' Articles.) Another note on color choice, if you change the autolink color, make the color change in GAL_admin.php, then open up any autolink in adminCP and just hit "Save".
One other point on checking to see if a word you want to autolink is included in any url's in any of your existing posts. If you have a downloaded save of your database (YOU SHOULD!), open it up with a text editor and do a search for the words you want to autolink. If they show up inside any urls, you could change one of the words, leave out that certain word, or just use "Safemode". Of course that doesn't help with future posts. It would be nice if you could pick "I wanna play it safe" or "Na, I live life dangerously" for each specific word instead of globally. (Hint - nail geek!)
John

[The Geek]

First - Clicked Install, nice hack nail geek.
I did this to change the color of the GAL_autolink:
find in GAL_admin.php, line 66:

Change to this:
I chose Red (#FF0000)(same color as used in search.php) but you can put in any color.
Here's an example from one of our posts (http://shipmodeling.net/vb_forum/showthread.php?p=1099&highlight=finish#post1099) (I used the word "Finish" as a test autolink to one of our members' Articles.) Another note on color choice, if you change the autolink color, make the color change in GAL_admin.php, then open up any autolink in adminCP and just hit "Save".
One other point on checking to see if a word you want to autolink is included in any url's in any of your existing posts. If you have a downloaded save of your database (YOU SHOULD!), open it up with a text editor and do a search for the words you want to autolink. If they show up inside any urls, you could change one of the words, leave out that certain word, or just use "Safemode". Of course that doesn't help with future posts. It would be nice if you could pick "I wanna play it safe" or "Na, I live life dangerously" for each specific word instead of globally. (Hint - nail geek!)
John
Hey John,
I looked at doing it per word... but it seemed excessive as you never know if a word will appear in a link or not.

As for the colour choice, why not just alter the DEF css? The one included is just an example (the one I use).

[wirewolf]

Hi nail,
I looked at doing it per word... but it seemed excessive as you never know if a word will appear in a link or not.See what you mean. Nothings perfect. For example - my test word, 'Finish". In most of the posts, the context of the word 'finish' relates to the article I autolinked to "Finishing of Models". But I found a few where the context in some posts meant "Finish", as in "I just about to 'finish' my model" (as in "done with my model"). That's one area that computers haven't quite solved yet, the word and how it is used in a sentence.
As for the colour choice, why not just alter the DEF css?Thought of that, but the GAL_admin.php method allows for both options, ex: red for one, another color for the other.
John

[OrangeFlea]

Hey guys,

I know where you are coming from... but to be honest I am not planning on doing something like that (though it would be really easy to do). One reason why is that you would almost need a moderator ability otherwise a user could really mess up your boards big style.

I would rather do the yellow popup box mentioned eariler first - though to be honest I am not even planning on doing that for a little while. I am knee deep in doing some wicked additions to geek articles 3 that I want to focus on. Then I have already started work on geekbay ;)

Well, I shouldn't have said "users." I meant admins. Doesn't matter, I suppose, since you're too busy with other projects at the moment.

If anyone comes up with an idea to input multiple keywords and URLs at once (as opposed to one-by-one), I'm all ears.

[Symbian.info]

Hey Alex, it looks like you may have an older package. Pre 2.0, there was a fucntions_geek_autolink.php file. Since then the function is inline.
Nope I download it today!, but standing in the text above. But look wrong. Just wondering..


I also went through the code and there are TABL_PREFIX's for all calls so once again I suspect an older version.

See above. today download. But what is the databae SQL format? So that I can check if its really ok..


I did however find a typo in the changes to your admincp/index.php file. I updated the readme and noted the changes in the first post (basically replace the GAL_admin.php?do=create with GAL_admin.php?do=add

Ok that solve the add new one problem
Now the safe mode. I must have safe mode .. It looks bad now
Can I do the setting manual??

[The Geek]

Nope I download it today!, but standing in the text above. But look wrong. Just wondering..


See above. today download. But what is the databae SQL format? So that I can check if its really ok..


Ok that solve the add new one problem
Now the safe mode. I must have safe mode .. It looks bad now
Can I do the setting manual??
hmm.

The table SQL is in the install file.
For safe mode, just clikc settings->Safe mode, and the datastore is built in safe mode.

[Symbian.info]

hmm.

The table SQL is in the install file.
For safe mode, just clikc settings->Safe mode, and the datastore is built in safe mode.
not working. thats why I ask :squareeyed:
How can I do it manual.. What does it do?

[OrangeFlea]

In the demo, I noticed that the keywords had a funky looking underline. Does the hack do that this automatically?

[The Geek]

In the demo, I noticed that the keywords had a funky looking underline. Does the hack do that this automatically?
Flea: The dashed underline is from the CSS addition that was in the readme. Change it how you fancy.

Symbian: How is Safe mode not working? Is that when you get the SQL error? Edit your GAL_admin.php file and search for rebuild_datastore its there that the links are built dpending on your preference to safe or dangerous mode.

HTH's

[OrangeFlea]

I'm entering my keywords (half-way done!). I noticed that there is a character limit set for the titles. How do I modify the limit?

Basically, I can enter the keywords normally -- regardless of the number of characters -- but on the display, it will only show a portion of the title if it's more than 20 or so characters. Furthermore, it will only hyperlink the text up to that point, leaving the rest of the text un-linked

[The Geek]

I'm entering my keywords (half-way done!). I noticed that there is a character limit set for the titles. How do I modify the limit?

Basically, I can enter the keywords normally -- regardless of the number of characters -- but on the display, it will only show a portion of the title if it's more than 20 or so characters. Furthermore, it will only hyperlink the text up to that point, leaving the rest of the text un-linked
Edit the text column of geek_autolink using phpadmin or something similar.

[ryancooper]

Theres an idea! Ill mull that one over for awhile.

noppid: The idea is that keywords are highlighted without them even knowing about it. Otherwise the previous suggestion would be the perfect hack.

Say you have eBay as a sponsor. Well, everytime eBay is mentioned- it will link it automatically.

Hope that makes sense.
I am mulling over adding a post field to disable it (like disabling smiles). That way if a user notices a link of theirs messed up (or knows ahead of time that it will get messed up) they can simply tick the 'do not autolink me'. Im only hesitant because I hate making DB changes to vB db's.
Ok i am still poretty new with vb but couldn;t this be done with replacements?

[The Geek]

Ok i am still poretty new with vb but couldn;t this be done with replacements?
Hey ryan. Wish it could be, it would make life much easier.
The #1 problem with replacements is that it takes a word like bob but bobs bob's and it will take things like Bob and turn in into bob as it doesnt take the what it is replacing and merge it with a replacment value. In other words, while it may work for some mild instances, replacements are very very limiting for most situations.

HTH's

[FASherman]

Nicely done. Such a simple hack, but with a lot of benefit. Should be a hack of the month candidate.

[ryancooper]

Hey ryan. Wish it could be, it would make life much easier.
The #1 problem with replacements is that it takes a word like bob but bobs bob's and it will take things like Bob and turn in into bob as it doesnt take the what it is replacing and merge it with a replacment value. In other words, while it may work for some mild instances, replacements are very very limiting for most situations.

HTH's
AHHHHhhh I see. . .Well then in that case. GREAT HACK! ;)

[OrangeFlea]

Nicely done. Such a simple hack, but with a lot of benefit. Should be a hack of the month candidate.

It'll definitely get my vote. Just finished adding 800+ keywords and links. It was all worth it.

[NuclioN]

Installed...but most of the smileys are not working anymore.
--edit-- w wait... some had the url in it that whas geeked :) Working now.

[webrats]

i turned on safe mod but its still effecting if someone puts the word in a hyperlink

[-=Sniper=-]

just wondering sorry if its already been asked :)

what if the very first word in the post was the word you want to replace? since it has no space before the word it will not work? well I think not anyway.

[The Geek]

i turned on safe mod but its still effecting if someone puts the word in a hyperlink
webrats. Can you give me a hyperlink to see?

Sniper: It wont match it in safemode.

[-=Sniper=-]

thanks

just wondering would it not be better to look for "www." and "http"? if the word contains any of those chars then don't replace else replace?

also wondering would it be possible to run two instances of the hack? as I wanted to allow users to turn one instance off.

[The Geek]

thanks

just wondering would it not be better to look for "www." and "http"? if the word contains any of those chars then don't replace else replace?

also wondering would it be possible to run two instances of the hack? as I wanted to allow users to turn one instance off.
Hey sniper, because the www and http would require recursive checks that would be a nightmare performance wise to test. Just because there is a www in front of the word doesnt make it not valid. What would be really cool is to check for the existence of a <a but not a /a pattern. if that equaled true than it would mean you were sitting prettily in a link. Sadly that type of checking is VERY processor intensive. Another way of doing it is to extract all of the URLS, do the replacing and then put all the URLS back in. Once again though... this is pretty labour intensive.

I run in danger mode and have done for 2 years. I could count of the one hand how many links have been messed up in almost 100,000 posts. Still... you have the power of choice to be dangerous or safe (safe mode is slighlty slower as well as there is an extra call to remove insertions to account for spaces).

As far as running 2 versions. This is totally possible however it would require you to make a copy of the install file, change every instance of a setting in use from GAL_* to GAL2_*
You would then have to duplicate the replacements (though this could be optomized with an array merge).
I guess I am saying that yes... it could be done. But it would be a small pain. The good thing is that since the code is so small, it wouldnt require too much work.

Let me know if you attempt it :)

[webrats]

<a href="http://forums.webrats.com/showthread.php?t=24406" target="_blank">http://forums.webrats.com/showthread.php?t=24406</a>

u may have to register to see it im not sure

[webrats]

http://forums.webrats.com/showthread.php?t=24406

u may have to register to see it im not sure


im clicking the safe mod button in admincp do i have to do anything else? i rebuilt the language files as well

is there sql command i can run to force it?

[Kihon Kata]

I have to say this is one of the best hacks I have ever seen! I just installed it right here (http://www.MakeupTalk.com/forums) on a hacked up vB 3.0.6 forum. Your install script rocked and couldn't have worked any easier! Thanks!

One problem, it doesn't work! LOL :laugh: . Seems like everything is working just fine inside the ACP. I did havetoeditone phrase then save it to be able to see them in thephrasessection.Then I added one word called "reviews". All ofMODS andadmins on theboard frequently use that word and reference toanothersection of oursite and this seemed like the answer! Wi++++ worked! Canyou assist meon a heavily hacked board? I selected SAFE BTW

I did try using http://www. and just /reviews/index.php etc and still nothing.

THanks

[FASherman]

I have to say this is one of the best hacks I have ever seen! I just installed it right here (http://www.MakeupTalk.com/forums) on a hacked up vB 3.0.6 forum. Your install script rocked and couldn't have worked any easier! Thanks!

One problem, it doesn't work! LOL :laugh: . Seems like everything is working just fine inside the ACP. I did havetoeditone phrase then save it to be able to see them in thephrasessection.Then I added one word called "reviews". All ofMODS andadmins on theboard frequently use that word and reference toanothersection of oursite and this seemed like the answer! Wi++++ worked! Canyou assist meon a heavily hacked board? I selected SAFE BTW

I did try using http://www. and just /reviews/index.php etc and still nothing.

THanks

I also installed on a heavily hacked forum and it works just fine. Must be a user error.

[Kihon Kata]

Oh man this install was simpler than most. I am still hoping one can lend a hand....


I also installed on a heavily hacked forum and it works just fine. Must be a user error.

[Kihon Kata]

NM, I fixed it, my ++++ UP lol

left out one line of the code!



I also installed on a heavily hacked forum and it works just fine. Must be a user error.

[The Geek]

http://forums.webrats.com/showthread.php?t=24406

u may have to register to see it im not sure
Rat - can you PM me test account details?

Can all who install do their bit to save humanity and click the install button? ;)

[Symbian.info]

Symbian: How is Safe mode not working? Is that when you get the SQL error? Edit your GAL_admin.php file and search for rebuild_datastore its there that the links are built dpending on your preference to safe or dangerous mode.


Nope still not working! No SQL error, after the setting I get: done. Built with space (and a lot of loving)

But nothing has change :(

Do you have the SQL query for me, so that I can change it manual in the SQL database?
We use a lot of URL's in the forum and they are now all bad.. And not working anymore..

Thanks..

[The Geek]

Nope still not working! No SQL error, after the setting I get: done. Built with space (and a lot of loving)

But nothing has change :(

Do you have the SQL query for me, so that I can change it manual in the SQL database?
We use a lot of URL's in the forum and they are now all bad.. And not working anymore..

Thanks..
The Datastore is what houses the replacement array.

Can you PM me a test login and the URL of a page with a messed up link? It would be helpful if the account had admin access (though you can restirct the access to everything else).

Ill sort it for you ;)

[Kihon Kata]

**CLicks install**

I was going to click it, but was testing it first.

One issue I am having is this:
I was linking the word MakeupTalk to http://www.makeuptalk.com (http://www.makeuptalk.comso)that each instance of MakeupTalk is parsed with thathyperlink. BUTsince the word is part of the link, I think thismessed things up.

Also, what about phrases? As in the words review center , it didnt like that either.

Any ideas?



@Lionel: Nope

@Rex: Updated the geek_autolink file. It was missing atable_prefix.Could you please click install so you are notified ofchanges?

@trainer: Yup, will totally work without GAS3. And yes, everytimebob,ben or bertha (or whatever you want) appears in a post... it willlinkit to whatever url you want.

HTH's

[The Geek]

**CLicks install**

I was going to click it, but was testing it first.

One issue I am having is this:
I was linking the word MakeupTalk to http://www.makeuptalk.com (http://www.makeuptalk.comso)that each instance of MakeupTalk is parsed with thathyperlink. BUTsince the word is part of the link, I think thismessed things up.

Also, what about phrases? As in the words review center , it didnt like that either.

Any ideas?
It only parses message text. It shouldnt be parsing anything that would require phrases.

Are you using safemode?
I am looking into an issue with symbian where when viewing the thread, existing urls are getting relinked (in safemode) but viewing the post as a single post it comes up fine.
I kind of suspect that the issue could be centered around caching of the post... but am not sure yet. I hope to have a final solution this afternoon.

[Kihon Kata]

Yes the site has it's php in safe mode. My host feels this shouldbe better due to some expliots in php. So, with that said, am I SOL?


It only parses message text. It shouldnt be parsing anything that would require phrases.

Are you using safemode?
I am looking into an issue withsymbian where when viewing the thread, existing urls are gettingrelinked (in safemode) but viewing the post as a single post it comesup fine.
I kind of suspect that the issue could be centered around caching ofthe post... but am not sure yet. I hope to have a final solution thisafternoon.

[The Geek]

Yes the site has it's php in safe mode. My host feels this shouldbe better due to some expliots in php. So, with that said, am I SOL?
Sorry. I meant running the hack in safe mode. (Geek Autlinker Settings)->safemode ;)

[Kihon Kata]

Play it safe? Yep I have selected this one



Sorry. I meant running the hack in safe mode. (Geek Autlinker Settings)->safemode ;)

[The Geek]

Found the bug causing the problems with safemode. Essentially it wasnt letting you build in safemode because of this.

Until I get a few minutes to update the package... do this:

in GAL_admin.php replace

if ($leadingspace=-1){


with this:


if ($leadingspace==-1){


Gotta love those =='s ;)

Then click settings and chose Safe. Then you will actually be safe :)

[Kihon Kata]

Oh awesome! Let me fix this and try it

Will report back asap


Found the bug causing the problems with safemode.Essentially it wasnt letting you build in safemode because of this.

Until I get a few minutes to update the package... do this:

in GAL_admin.php replace

if ($leadingspace=-1){


with this:


if ($leadingspace==-1){


Gotta love those =='s ;)

Then click settings and chose Safe. Then you will actually be safe :)

[-=Sniper=-]

that makes it work! thanks dude :)

[Kihon Kata]

Ahhhh, when I made this change it removed only SOME OF MY LINKS. I hit safe too

Some of the ones I added before are working and some aren't now. I evendeleted some and then readded them and they don't work anymore

Do I have recompile something?




Oh awesome! Let me fix this and try it

Will report back asap

[Symbian.info]

Found the bug causing the problems with safemode. Essentially it wasnt letting you build in safemode because of this.

Awesome it works now! I was a good geinny pig :laugh:
Thanks for all the work! I am very happy now :smoke:

[Kihon Kata]

Ok, not working for me. This is what I did

I added the = like you had said inside GAL_admin.php. What this did wasremove half of my links LOL. I know....half?? But it really did. If Iremove the = and then hit SAFEMODE, it recompiles itright back to whereit was working with some words

Are there more instance of if ($leadingspace=-1){ other than just the ONE I found?

Found the bug causing the problems withsafemode.Essentially it wasnt letting you build in safemode because ofthis.

Until I get a few minutes to update the package... do this:

in GAL_admin.php replace

if ($leadingspace=-1){


with this:


if ($leadingspace==-1){


Gotta love those =='s ;)

Then click settings and chose Safe. Then you will actually be safe :)

[The Geek]

if ($leadingspace=-1){

there should only be 1 line like that and it needs to be changed to

if ($leadingspace==-1){

[Kihon Kata]

See the attachment

Litterally, if I edit the php file to be the exact code in the attachtext file, and then upload it. Then go into the ACP, hit "Safe mode" itremoves half my links thatare there working BEFORE I edit/upload. I have duplicated process this 5 times.

What am I doing wrong?




if ($leadingspace=-1){

there should only be 1 line like that and it needs to be changed to

if ($leadingspace==-1){

[The Geek]

See the attachment

Litterally, if I edit the php file to be the exact code in the attachtext file, and then upload it. Then go into the ACP, hit "Safe mode" itremoves half my links thatare there working BEFORE I edit/upload. I have duplicated process this 5 times.

What am I doing wrong?
I assume these are links that were put in bu the GAL system? If so it is because in safe mode, there will only be a match for a word if the word has a space in front of it.
Before you made the file edit, it was working in dangerous mode (even though you chose safe) which meant it couldnt give a poo about the space in front.
Safemode=fewer links, but less chance of URL screw up
Dangerous=More links, but greater risk of flub up

Hope this makes sense.

[Kihon Kata]

Yep it makes sense
Yes I am talking about the links thru the GAL sys.

EG Word usage: reviews (linked to http://www.makeuptalk.com/reviews)
This works FINE before I uploaded the modded file.

But why does it REMOVE links when I hit safe mode? I start a new thread with one word in it reviews with no spaces etc. Could this be that it's in the beginning of the sentence?

Hmm seems strange...but ok, let me fool with dangerous mode now...




I assume these are links that were put in bu the GALsystem? If so it is because in safe mode, there will only be a matchfor a word if the word has a space in front of it.
Before you made the file edit, it was working in dangerous mode (eventhough you chose safe) which meant it couldnt give a poo about thespace in front.
Safemode=fewer links, but less chance of URL screw up
Dangerous=More links, but greater risk of flub up

Hope this makes sense.

[Kihon Kata]

BYW, when I added a two word combo as review center I get this: reviews (http://www.makeuptalk.com/%3Ca%20href=)' target='_blank' class='DEF' title=''>review center



I assume these are links that were put in bu the GALsystem? If so it is because in safe mode, there will only be a matchfor a word if the word has a space in front of it.
Before you made the file edit, it was working in dangerous mode (eventhough you chose safe) which meant it couldnt give a poo about thespace in front.
Safemode=fewer links, but less chance of URL screw up
Dangerous=More links, but greater risk of flub up

Hope this makes sense.

[The Geek]

Yep it makes sense
Yes I am talking about the links thru the GAL sys.

EG Word usage: reviews (linked to http://www.makeuptalk.com/reviews)
This works FINE before I uploaded the modded file.

But why does it REMOVE links when I hit safe mode? I start a new thread with one word in it reviews with no spaces etc. Could this be that it's in the beginning of the sentence?

Hmm seems strange...but ok, let me fool with dangerous mode now...
Yea... no space if it is the first word.

However, you could try this workaround (havent done it myself but it would make sense:

in functions_showtherad.php replace:

if ($gal_autotext){

$post['message']=preg_replace($gal_autotext,$gal_autolink,$post['message']);

if ($gal_setting['leading_space']==1){
$post['message']=preg_replace("<!--GAL_REMOVAL--> ","",$post['message']);
}
}


with:


if ($gal_autotext){
$post['message']=' ' . $post['message'];
$post['message']=preg_replace($gal_autotext,$gal_autolink,$post['message']);

if ($gal_setting['leading_space']==1){
$post['message']=preg_replace("<!--GAL_REMOVAL--> ","",$post['message']);
}
$post['message']=trim($post['message']);
}


That would put a space before the message, replace... then trim the extra space back out.

Like I said - havent done it here but it should work.

[OrangeFlea]

I've noticed that single-word entries supercede multi-word entries. For example, when I input "Toyota" and "Toyota Celica," the hack will only hyperlink "Toyota" in those instances where "Toyota" is part of a multi-word keyword. Like this...

Toyota
Toyota Celica
Toyota Landcruiser

Celica and Landcruiser are left out, even if I did input them in as part of the phrase.

[The Geek]

I've noticed that single-word entries supercede multi-word entries. For example, when I input "Toyota" and "Toyota Celica," the hack will only hyperlink "Toyota" in those instances where "Toyota" is part of a multi-word keyword. Like this...

Toyota
Toyota Celica
Toyota Landcruiser

Celica and Landcruiser are left out, even if I did input them in as part of the phrase.
huh. Maybe an 'ordinal' value is needed. As a fix, you can try this:

In GAL_admin.php replace

$results=$DB_site->query("SELECT * FROM " . TABLE_PREFIX . "geek_autolink ORDER BY text asc");


with


$results=$DB_site->query("SELECT * FROM " . TABLE_PREFIX . "geek_autolink ORDER BY id asc");


This should cause the text to replace in the order it was put into the system. Ill look toward adding an ordinal column.

[Kihon Kata]

BYW, YOUR REPLY here FIXED this:

when I added a two word combo as review center I get this: reviews (http://www.makeuptalk.com/%3Ca%20href=)' target='_blank' class='DEF' title=''>review center

Dangerous Selected!



huh. Maybe an 'ordinal' value is needed. As a fix, you can try this:

In GAL_admin.php replace

$results=$DB_site->query("SELECT * FROM " . TABLE_PREFIX . "geek_autolink ORDER BY text asc");


with


$results=$DB_site->query("SELECT * FROM " . TABLE_PREFIX . "geek_autolink ORDER BY id asc");


This should cause the text to replace in the order it was put into the system. Ill look toward adding an ordinal column.

[The Geek]

Thats because it linked review, then linked review center.
If you were in safemode, only review would ever get linked. In dangerous mode, IF review was replaced first then review center would mess it up.

Hope this makes sense!

[Kihon Kata]

Little bit deep for me, BUT nevertheless, seems to be working

Look here at this post (http://www.makeuptalk.com/forums/showthread.php?postid=39017#post39017) for an example of it working right. This is a nice hack



Thats because it linked review, then linked review center.
Ifyou were in safemode, only review would ever get linked. In dangerousmode, IF review was replaced first then review center would mess it up.

Hope this makes sense!

[Symbian.info]

h
with

$results=$DB_site->query("SELECT * FROM " . TABLE_PREFIX . "geek_autolink ORDER BY id asc");


Great that works. Thanks again!!

[slix]

Hey Mr. Geek, I have been looking for this feature for a while. So I am well chuffed with it. Ta! I clicked install for you.

A couple of questions....

1. Is there a way to change the style of links produced from this mod from the default link style? I would like to make them bold :)

2. If I add a the same keyword twice, and put a different link with each one, will it randomize between the 2 link destinations?

3. Does it only work wioth single words, or will it work with phrases to? For example, "bob music".


Just a couple of suggestions....

1. It might be better if the admin could enter one URL, and a list of keywords & phrases (seperated by commers) to trigger that link.

2. Forgot it.... dam! :smoke:

[The Geek]

Hey Mr. Geek, I have been looking for this feature for a while. So I am well chuffed with it. Ta! I clicked install for you.

A couple of questions....

1. Is there a way to change the style of links produced from this mod from the default link style? I would like to make them bold :)

2. If I add a the same keyword twice, and put a different link with each one, will it randomize between the 2 link destinations?

3. Does it only work wioth single words, or will it work with phrases to? For example, "bob music".


Just a couple of suggestions....

1. It might be better if the admin could enter one URL, and a list of keywords & phrases (seperated by commers) to trigger that link.

2. Forgot it.... dam! :smoke:
Hey Slix,

Glad it helps.
1. To change the look of the links - try changing the DEFS CSS markup that came with the file. Otherwise, you will need to edit your GAL_admin.php file as that is where links are made

2. It wont randomize (think that would drive users ape poop ;) ). The replacement is a first come first server basis.

3. Works with whatever phrase you want, no matter how many spaces it contains (Though there is a limit on the phrase character length but that escapes me right now!)

I like your suggestion. Ill look into it when I revisit this hack (when I am done with GAS3)

Toodles

[Kihon Kata]

Slix! This is one of the most USEFUL hacks I have seen yet! We love it on our board here (http://www.makeuptalk.com/forums/)

I was a little tricky to get it to work and the installation script is well written KUDOS!!!

lata


Hey Mr. Geek, I have been looking for this feature for awhile. So I am well chuffed with it. Ta! I clicked install for you.

A couple of questions....

1. Is there a way to change the style of links produced from this modfrom the default link style? I would like to make them bold :)

2. If I add a the same keyword twice, and put a different link with each one, will it randomize between the 2 link destinations?

3. Does it only work wioth single words, or will it work with phrases to? For example, "bob music".


Just a couple of suggestions....

1. It might be better if the admin could enter one URL, and a list ofkeywords & phrases (seperated by commers) to trigger that link.

2. Forgot it.... dam! :smoke:

[MajorFm.com]

will this work with vb 3.0.3 ?

[The Geek]

will this work with vb 3.0.3 ?
should do. In fact, It whoudl work with really any 3x version.

[The Geek]

Working fine with the latest vb3 of the week (3.07). Had to reinstall phrases though (one click ordeal with the installer ;) )

nJoy

[MajorFm.com]

perfect! i remember actually requesting this some time ago... its now here... thanks geek!

*click install*

[Kihon Kata]

Hi Geek, got a little issue. Running your Autolinker and I LOVE IT!! But, here is the scenario:

Running dangerous on a vB 3.0.6 (will be .7 soon)

I have set up these links:



the word reviews and review center set to autolink to http://www.makeuptalk.com/reviews/ and this works GREAT everywhere on the board (love this!!)
when I try do a regular hyperlink to ANY word but the HYPERLINK(not the word) contains the word reviews, it shows a bad link

E.G.: Trisha's Notepad (http://www.makeuptalk.com/reviews/showEditor.php?usernm=Trisha)(look at the hyperlink)
this is the CORRECT hyperlink but theautolinker displays this link: http://www.makeuptalk.com/%3Ca%20href='http://www.makeuptalk.com/reviews/'%20target='_blank'%20class='DEF'%20title=''%3Erev iews%3C/a%3E/showEditor.php?usernm=Trisha

Any help will be appreciated!


Working finewith the latest vb3 of the week(3.07).Hadtoreinstall phrases though(one click ordeal with theinstaller ;) )

nJoy

[The Geek]

Thats the danger part of using Dangerous mode ;)
If you are using dangerous mode, GAL will link the word wherever it finds it (in this case a URL). THough it is still rare, the only way around it is to use Safe mode. It will find slightly fewer links, but at least it wont mess up your URLs.

HTH's

[Kihon Kata]

Yeah it links it everysingle time

Is there a workaround for us?


Thats the danger part of using Dangerous mode ;)
Ifyou are using dangerous mode, GAL will link the word wherever it findsit (in this case a URL). THough it is still rare, the only way aroundit is to use Safe mode. It will find slightly fewer links, but at leastit wont mess up your URLs.

HTH's

[KTBleeding]

Is there a workaround for us?Using safe mode. ;)

[Kihon Kata]

Boo hoo

maybe GEEK can help me more with this...as he rocks w/ support





Using safe mode. ;)

[The Geek]

Boo hoo

maybe GEEK can help me more with this...as he rocks w/ support
KTBleedings right-> you need to run GAL in safemode to prevent messing up the link.

[Kihon Kata]

nah this did not work that well....still messed up the links


KTBleedings right-> you need to run GAL in safemode to prevent messing up the link.

[The Geek]

nah this did not work that well....still messed up the links
What version are you running?

[Kihon Kata]

2.03

Just installed this a week ago



What version are you running?

[venomx]

I dont see why this cant be used like the ban word optiion in the admin area...

[slix]

Hey Slix,

Glad it helps.
1. To change the look of the links - try changing the DEFS CSS markup that came with the file. Otherwise, you will need to edit your GAL_admin.php file as that is where links are made

2. It wont randomize (think that would drive users ape poop ;) ). The replacement is a first come first server basis.

3. Works with whatever phrase you want, no matter how many spaces it contains (Though there is a limit on the phrase character length but that escapes me right now!)

I like your suggestion. Ill look into it when I revisit this hack (when I am done with GAS3)

Toodles

Re: 1. DEFS css that came with what file? Am I missing a file? :pirate:

Re: 3. Cool, very cool - has the max character length come back to you yet?

Hey this is a great hack. I first saw keyword links like this in an asp forum on a financial site, and I loved the idea, and hoped someone would bring it to vB3, and you have!

There is one major problem I am having with it at the moment though, and that is that all my forum goers hate it! Some think that they must have picked up some spyware which is inserting feyword links in every thing they read or write, and some think that our site has been hacked into by some marketing crazed cracker!

That financial site where I first saw this keyword advertising in forums, had a little javascript mouseover window, that pops up when you put your pointer over the link, and it explains that it's a sponsored link. How would I do that? Or where in the code would I insert the mouseover?

I have to give this hack 10/10, 'cos it's exactly what I have been wanting ever since I first saw the concept. Oh, and it's sooo quick and easy to install, and it works great on a busy forum. Just gotta make my members like it too. :cheeky:

[The Geek]

Thanks for the kind words!

Re: Re:1. Damn. I am busted. I think I left the definition out of the 2.0 package and no one noticed! Here it is until I get a chance to get to the readme:

put this in your 'additional CSS properties' box of your style:

/* defs */
a.DEF:link { text-decoration: none;border-bottom: 1px dotted #016798; color : #016798; padding-bottom: 0px }
a.DEF:visited { text-decoration: none; border-bottom: 1px dotted #016798; color : #016798; padding-bottom: 0px }
a.DEF:hover { text-decoration: underline ;border-bottom: 0px dotted #F8BF24; color : #016798; padding-bottom: 0px }


Customize it to whatever you want.

re:re 2: 25 characters. If you want more, just edit the geek_autolink table

Glad you like the hack. When I am done with my current project, I will start to look into doing the mouseover popups too.

Think the secret to getting your users to like it is to make it as unobtrusive as possible and dont autolink every other word ;)

nJoy

[TCB]

Wow! This hack is wonderfull! It's soooo easy to install and work with. Thank you so much :D

Is it possible to exclude (ignore) a whole forum, instead of filling in all forumthread ID's?

[The Geek]

Wow! This hack is wonderfull! It's soooo easy to install and work with. Thank you so much :D

Is it possible to exclude (ignore) a whole forum, instead of filling in all forumthread ID's?
nope, just threadid's. Mostl likely wouldnt be too hard of a modification though.

[rrr]

sounds like a cool hack that I may be installing. Could you show an example of this in action where you don't have to login? Your example seems to link to a Premium area of your site.

Feature Suggestion:

A cool feature/option for this hack would be if when you typed in bob, the script used a redirect link, like: yoursite.com/forum/autolink.php?l=1

So if you wanted bob to link to bob.com, you would enter that in the AdminCP, and it would create the redirect link that would actually be used in the forum.

Where this would be useful, would be to track how many people are actually clicking on the link (useful to let advertisers know how many clicks they are getting).

It would also be useful to hide or shorten long affiliate links. Sometimes, people are less likely to click a link if they think it is an affiliate link, and the redirect would make it so that if you had a really long link or one with special characters, it would still turn out to just be a simple autolink.php?l=1 link in the forum.

Not all users of the hack would want this feature activated, so maybe it could be something optional?

Either way, great hack!

[venomx]

rrr I agree but then also I am using it to link to my other sites, if they are they way you want then Google and the other engines might not register that its a link to my site...

[rrr]

rrr I agree but then also I am using it to link to my other sites, if they are they way you want then Google and the other engines might not register that its a link to my site...

Exactly. Which is why I suggested it be made as an "option" :)

That way, if you're not using the links for search engine ranking, then you can use the tracking code (if there ever was one written).

If you are using it for search engine ranking, then you can turn the tracking off (in my ideal version of this hack :) )

[slix]

Feature Suggestion:

A cool feature/option for this hack would be if when you typed in bob, the script used a redirect link, like: yoursite.com/forum/autolink.php?l=1

So if you wanted bob to link to bob.com, you would enter that in the AdminCP, and it would create the redirect link that would actually be used in the forum.

Where this would be useful, would be to track how many people are actually clicking on the link (useful to let advertisers know how many clicks they are getting).

It would also be useful to hide or shorten long affiliate links. Sometimes, people are less likely to click a link if they think it is an affiliate link, and the redirect would make it so that if you had a really long link or one with special characters, it would still turn out to just be a simple autolink.php?l=1 link in the forum.

Not all users of the hack would want this feature activated, so maybe it could be something optional?

Either way, great hack!

I use a separate tracker, one that I use for tracking to and from many sites. I don't think this is a feature that should be built into the autolinker hack, because to get a good level of click tracking and monitoring, you need a dedicated script that would dwarf the autolinker hack!

I would suggest you invest in a dedicated tracking script. I have mine on a dedicated domain that is nice and short, and created a subdomain called "a" to replace www with something shorter. On the end of that goes a short tracking number. The funny thing is, google and inktomi often pick my tracking links up, and list the actual tracking link it's self rather than the target. That's prety cool, because I can track hits direct from search engines, and send SE traffic straight to my advertisers. That's fluke though. If I tried to do that, I would surely fail!

[rrr]

I use a separate tracker, one that I use for tracking to and from many sites. I don't think this is a feature that should be built into the autolinker hack, because to get a good level of click tracking and monitoring, you need a dedicated script that would dwarf the autolinker hack!

Interesting point. However for someone needing just simple tracking, I think it would be a nice feature to add into the script.

I have used several tracking scripts, and all of them would be overkill for what I'm describing.

One other benefit that an inscript tracker would have is that the link URL would be from the same domain as the forum. I think users would trust a link more (since they don't know where it's going) if it appears to just be a regular forum link, rather than a link that is from some other domain they aren't familiar with.

[The Geek]

hey rrr thanks for pointing out that the demo went to a blocked area. I just set permissions for articles and tutorials and forgot abou you guys checking it out... I better set them back :)

on to your suggestion. Personally, I think it is a great suggestion however I wouldnt have time to do a catch/referal script right now.

Why not use something like vBa links directory or scan here for a hack that does something similar (there are a few). Then make any autolinks you create simply refer to that redirect page (most link directories will use a refer page that tracks clicks).

Going off to sort my permissions ;)

[memobug]

This looks like quite a fun hack. I have a suggestion for users that they might be able to use to make a buck or two.

Offer to sell (actually to rent) words and phrases on your forums. You sell the word for say a dollar a month. So, for example, if you are running a makeup forum like I saw earlier, you could sell words like lipstick or foundation.

The longer phrases could pre-empt the shorter ones, so if somebody bought "skin moisturizer" it would take precedence over the person who bought "moisturizer" if the phrase "skin moisturizer" were actually used.

A more sophisticated hack could allow people to bid on adwords like google.

Each user has a total budget (that he can charge up with paypal or something) and he has a list of words with their associated links for each, and a daily budget for each, and a bid amount he is willing to pay - his bid for that word.

The user who offers the most for a specific word or phrase owns that offered the most for a word would own the link associated and every time one of his words gets clicked on, his budget gets depleted by that amount until his total budget or his daily budget ran out, or somebody outbid him on the word.

Now you might not even have to auction the actual words, but simply an adspace that appears right after the post that contains the word.

Regards,

Matt

[rrr]

Why not use something like vBa links directory or scan here for a hack that does something similar (there are a few). Then make any autolinks you create simply refer to that redirect page (most link directories will use a refer page that tracks clicks).

Now that's an interesting idea. I think I may go that route (it'll give me a directory for my forums, and a link tracking script).

I've got to get out of this box more often.

[rrr]

The instructions say to find in admincp/index.php :


// *************************************************
if (can_administer('canadminstyles'))


But my admincp/index.php looks like:


// *************************************************

$printhr = false;
if (can_administer('canadminstyles'))
{


And your code wants $printhr = true.

Do I put your code in between the $printhr line and the if (can_administer line? Or do I replace the $printhr=false line as well?

[Razz]

This is also breaking up urls for me in safe mode, is there a workaround yet?

[The Geek]

rrr - put it above the $printhr = false; line then.

Razz- Everytime someone brings this up - it turns out that it isnt in safe mode. There may be an occasional issue with the settings being built - but I havent seen it yet! Try this:

In your functions_showthread.php file, comment out the following line:



$post['message']=preg_replace("<!--GAL_REMOVAL--> ","",$post['message']);



So it looks like this:



//$post['message']=preg_replace("<!--GAL_REMOVAL--> ","",$post['message']);



Then rebuild your settings in safe mode and go to a page with mesed up URL. If it is still mesed up view the source and search for <--GAL_REMOVAL--> If it isnt there, it means the settings were not built right.

HTH's

[Razz]

Hi Nail Geek,

I didn't notice if this had been covered yet but the settings are incorrect for most due to an error in step 3.2 of the install with a typo on gal_settings (gel_settings)

Also in functions_showthread:

if ($gal_setting['leading_space']==1)

should be

if ($gal_settings['leading_space']==1)

[Razz]

Ok I have applied both those fixes now and checked that $gal_settings['leading_space'] definately equals 1 when safe mode is enabled, however it still doesn't work properly with urls.

Example:

I added google and http://www.google.com into settings to be replaced as a test.

the post consisted of www.google.com

it attempts to replace the google in that url and therefore breaks the url even though the leading space option is properly set and being retrieved correctly.

[venomx]

confirmed.. I put amazon to point to my amazon link. If I type www.amazon.com it messed up the link, but amazon.com and amazon are ok...

[MajorFm.com]

Im running safe mode but it still seems to mess up urls... i been round and round this thread and upgraded twice!

cant work it out...

example: http://www.majorfm.com/forum/showthread.php?p=32086&posted=1#post32086

[Razz]

One thing worth noting, if your running PHP 4.3.10 or 5.0.3 and suffer with the unserialize slowdown then you can still use this hack but i would also reccomend (highly) the hack to store the datastore in the filesystem, due to the extra unserialize calls used in the autolinker.

Info here: https://vborg.vbsupport.ru/showthread.php?t=75032

[The Geek]

Sweet! THanks Razz... I fixed the gal_setting typos mentioned in your earlier post and I found the sneaky little bug that was causing the datastore to be built in danger mode even when you were actually choosing safe mode.

To upgrade, replace the gal_admin file with the one included in the 2.04 package. Also, edit your functions_showthread.php file and replace:

if ($gal_setting['leading_space']==1){

with

if ($gal_settings['leading_space']==1){


Should work now :)

[MajorFm.com]

i did that fix but still get the same problem...

http://www.majorfm.com/forum/showthread.php?p=32195&posted=1#post32195

[RichieBoy67]

I would like this for my site but have all the bugs been fixed yet??

--

[The Geek]

i did that fix but still get the same problem...

http://www.majorfm.com/forum/showthread.php?p=32195&posted=1#post32195
Have you rebuilt in safe mode after replacing your gal_admin.php and applying the fix to functions_showthread.php? I have tested here and it seems fine.

If so - edit the rebuild_datastore function in your gal_admin.php in there you will find some echo commands commented out. Uncomment them, rebuild in safe mode and then PM me the results.

Thanks

[greenhybrid]

I'm confused. You make the changes and then what do you have to do?

[The Geek]

I'm confused. You make the changes and then what do you have to do?
in your admincp, click the settings option in your Geek AutoLinker category. Then click safemode.

HTH's!

[The Geek]

Hey Richie - As far as I know; its working fine. There have been some instances where useres operating the hack in safemode have been having problems with existing links with matching keywords - however I am pretty confident its been sorted. Wosre case scenario - if it hasnt been sorted, you may potentaill have a rare occuance of a URL going wiggy if it contains a keyword (though chances are pretty rare). I am still waiting to hear back from anyone on the latest changes. They work on my side of things.

HTH's

[The Geek]

just twiddled things about and am now 100% positive its fine. I changed a line in the functions_show thread from

$post['message']=preg_replace("<!--GAL_REMOVAL--> ","",$post['message']);

to

$post['message']=preg_replace("(<!--GAL_REMOVAL--> )","",$post['message']);


Results in safemode can be seen here: http://www.thenailgeek.com/showthread.php?t=12462

Note that onycholysis and prep are keywords (the manual URLs in the post example are ficticious but show that they dont get screwed up by the autolinker)

[venomx]

I did the changes and upload. Then did the setting part. All seems fine here..

www.amazon.com reg VB link
amazon.com not linked.
amazon linked to my affiliate link :)

[Razz]

Sweet! THanks Razz... I fixed the gal_setting typos mentioned in your earlier post and I found the sneaky little bug that was causing the datastore to be built in danger mode even when you were actually choosing safe mode.

You missed one, just downloaded 2.05 and you still have this in instructions:


// === GEEK AUTOLINK step 3.2 ===
'gal_text', 'gal_links', 'gal_ignores','gel_settings',
// === /GEEK AUTOLINK ===


:p

[Razz]

Also looks like you left some debugging text in when submitting/editing autolinks ?

It does work for me now though :)

[Razz]

Two small things you could implement:

Each time I add an autolink I have to click on safe mode to get it to work, perhaps have it automatically do this?

How about the ability to add an alt tag to it for more details?

[rrr]

How about the ability to add an alt tag to it for more details?

Yes, the ability to add a title tag would be a great addition.

[The Geek]

Yes, the ability to add a title tag would be a great addition.
It already has that feature - I just forgot to wire it in.
When I get back I will do. Thanks ;)

[jcr]

First of all.. Thanks a million!! :D My advertisers love this!

There are two things I'd very much like to see in a next version.

1) The ability to add a title text
2) How long it should be auto-linked

[RichieBoy67]

Thanks for the reply Geek! That is a rare occurance these days for me... I am going to install this right now and thanks for this!! Should be a big help for my site!!

-

[RichieBoy67]

I did the install but when I try to use it I am getting

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM geek_autolink ORDER BY text asc
mysql error: Table 'talkandmore_net.geek_autolink' doesn't exist

mysql error number: 1146

Date: Saturday 26th of February 2005 03:14:38 PM

[RichieBoy67]

can someone tell me what qeurries I have to make?? I'm not very good at mysql so I am having a hard time figuring out how to make these querries manually. For some reason I don't think the installer did the querries..

Thanks

I checked and rechecked and followed directions exactly. I do not know why this is happening... I am getting this when I click on view.

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT id, text, link, ignorethread FROM geek_autolink ORDER BY text asc
mysql error: Table 'talkandmore_net.geek_autolink' doesn't exist

mysql error number: 1146




This is what I get when I try to go into safemode
Invalid SQL: SELECT * FROM geek_autolink ORDER BY text asc
mysql error: Table 'talkandmore_net.geek_autolink' doesn't exist




I think all I need to do is add the 'talkandmore_net.geek_autolink' table but I do not know how... Can someone please tell me the querrie for this. I know it's very simple..


--

[Blam Forumz]

Once again, brilliant hack Geek :D

[OrangeFlea]

One problem...

I have the thing on danger mode, and when people type out keywords in certain fonts or italics, the hyperlinks don't show. What's up with that?

[ryandu]

Hi GEEK,

because in most of the URL, for example http://amazon or http://www.amazon.com

the word "amazon" either start with a "/" or with a "." , so can do like this any "amazon" start with "/" or with "." , we don't link, then all other "amazon" will be linked.

this way, it will be perfect and won't mess up URLs.

can we do this?
thanks

[Symbian.info]

Hi GEEK,

because in most of the URL, for example http://amazon or http://www.amazon.com

the word "amazon" either start with a "/" or with a "." , so can do like this any "amazon" start with "/" or with "." , we don't link, then all other "amazon" will be linked.

this way, it will be perfect and won't mess up URLs.

can we do this?
thanks
I have the same problem! all URLs with //3lib.co.uk get messed up becuase of the / in the front and not www.
So can you change that?

[venomx]

If you install the new fix and set it to safe mode this will work right. I have it running like that on my site and its fine. :)

[The Geek]

One problem...

I have the thing on danger mode, and when people type out keywords in certain fonts or italics, the hyperlinks don't show. What's up with that?
That is because the word doesnt have a space infront of it. That is the switch-off with safe mode. It wont screw up existing links but it will not link words that do not have a space infront of them.
this
equates to
<strong>this</strong>
And therefore it has no space.

HTH's

[zachlee]

how could I integrate this (GAL) into my CMPS index page, so that it would link the words, when I type them in my news.

I also noticed on my install (3.0.7) that the install.php did not create the tables in mysql. Shouldnt be too much of a deal, for anyone having phpmyadmin or webmin, etc.

[The Geek]

how could I integrate this (GAL) into my CMPS index page, so that it would link the words, when I type them in my news.

I also noticed on my install (3.0.7) that the install.php did not create the tables in mysql. Shouldnt be too much of a deal, for anyone having phpmyadmin or webmin, etc.
Hey Zachlee. Thanks for the heads up though I have no clue why it wouldnt create the table on 3.07
I wonder if something else was up?

As far as the CMPS thing - it wouldnt really be too hard. You just need to find where the post text is parsed and put the function_showthread code there. In fact, I thought it already used functions_showthread to parse bbcode - however its hard to say as I am on the road and away from all my code right now.

[zachlee]

fyi:

fedoracore3, php 4.3.10, MySQL 3.23.58, vb3.0.7

I have a identical box I use for testing, and this evening, I achieved the same result. The install page niether confirms or errors. Not sure what the magic touch is, but creating the tables manually isnt a hardship by any means. :)

Thanks again for a amazing utility!!

I will take a look at the templates more this weekend as to integrate the CMPS index page, with GAL.

[Mek]

Installer doesn't appear to be working for 3.0.7, will give it a try again once that is sorted out.

[The Geek]

Installer doesn't appear to be working for 3.0.7, will give it a try again once that is sorted out.
Can you give me an idea as to why the installer isnt working? The installer only inserts phrases and creates a table - neither function requires anything from a specific vb version.

Thanks!

[zachlee]

Can you give me an idea as to why the installer isnt working? The installer only inserts phrases and creates a table - neither function requires anything from a specific vb version.

Thanks!


When I installed GAL, I recieved a database error, which is why I knew the install script hadnt created the necessary tables. If you create the tables manually, GAL works perfectctly. Error follows:


Database error in vBulletin 3.0.7:

Invalid SQL: SELECT * FROM fbf_geek_autolink ORDER BY text asc
mysql error: Table 'football.fbf_geek_autolink' doesn't exist

mysql error number: 1146

[The Geek]

Thats a trip. It means the table didnt installed (which was mentioned earlier). Wonder why the table isnt getting created?!?

[OrangeFlea]

I've noticed that I have to frequently put the system on danger mode in order to hyperlink the proper texts. Usually when I see a keyword in a post, I wonder why it wasn't made into a link, so I go back to my admincp and click on danger mode again, then it works fine.

[greenhybrid]

Is there any way to make it so that if you have the term "test1" and the term "test1 test2," the longer one will be linked? As I own an automobile-related website, I have used the links for Accord, Accord Hybrid, Honda Accord Hybrid, etc., but only Accord will be linked if someone types Honda Accord Hybrid.

Thanks.

[The Geek]

Is there any way to make it so that if you have the term "test1" and the term "test1 test2," the longer one will be linked? As I own an automobile-related website, I have used the links for Accord, Accord Hybrid, Honda Accord Hybrid, etc., but only Accord will be linked if someone types Honda Accord Hybrid.

Thanks.
greenhybrid: Make sure the longer is in the system first.
The order that they are put in is the order they are matched.

Flea: Sorry flea - are you saying that new entries seem to be in safe mode? Im not quite getting you ;)

[Mek]

When I installed GAL, I recieved a database error, which is why I knew the install script hadnt created the necessary tables. If you create the tables manually, GAL works perfectctly. Error follows:


Database error in vBulletin 3.0.7:

Invalid SQL: SELECT * FROM fbf_geek_autolink ORDER BY text asc
mysql error: Table 'football.fbf_geek_autolink' doesn't exist

mysql error number: 1146


Likely the same error/problem I am getting, will give it a try with the database created manually.

[zachlee]

Likely the same error/problem I am getting, will give it a try with the database created manually.

It has been working (flawlessly I might add) *knocks on wood* since I manually created the tables.

[zachlee]

As far as the CMPS thing - it wouldnt really be too hard. You just need to find where the post text is parsed and put the function_showthread code there. In fact, I thought it already used functions_showthread to parse bbcode - however its hard to say as I am on the road and away from all my code right now.

Geek,

I still have been unable to incorporate GAL into my CMPS index.

www.football-forums.com

When you have a moment (no hurry at all) could you take a peek, and see what I would need to add. I am having no luck at all, and at this point I dont want to break anything.

Thanks!
-Zach

[OrangeFlea]

Sorry flea - are you saying that new entries seem to be in safe mode? Im not quite getting you

I should have been clear. Sometimes when I'm browsing the forum I notice that certain words or phrases aren't hyperlinked, and I know for sure that I added them into the keyword library. I go into admincp and confirm, and when I put the hack in "danger mode" again the words and phrases I noted earlier are fixed (hyperlinked). It's as if the thing goes to "safe mode" all by itself or something, and I have to regularly put it back to its "danger mode."

[The Geek]

I should have been clear. Sometimes when I'm browsing the forum I notice that certain words or phrases aren't hyperlinked, and I know for sure that I added them into the keyword library. I go into admincp and confirm, and when I put the hack in "danger mode" again the words and phrases I noted earlier are fixed (hyperlinked). It's as if the thing goes to "safe mode" all by itself or something, and I have to regularly put it back to its "danger mode."
hmmm. Thats odd. Ill look into that.

[zachlee]

Geek,

another general question... Is there anything that can block where the URL is going to (in the status bar). So that all links will display in the status bar...

"Link opens in new window, outside of [insert website name here]"

Instead of the basic url information.

Thanks Again!!

[greenhybrid]

greenhybrid: Make sure the longer is in the system first.
The order that they are put in is the order they are matched.

That doesn't seem to have worked. I tried long-to-short, and then backwards. In both instances, only the shortest would be linked.

[greenhybrid]

Okay, I was able to do it by sorting by id asc in the mysql query. It creates nested links, but still works fine. On the flip side, I had to take out my title='Learn more about $result[text]' because it was interfering :(

[T3MEDIA]

Hey Alex, it looks like you may have an older package. Pre 2.0, there was a fucntions_geek_autolink.php file. Since then the function is inline.

I also went through the code and there are TABL_PREFIX's for all calls so once again I suspect an older version.

I did however find a typo in the changes to your admincp/index.php file. I updated the readme and noted the changes in the first post (basically replace the GAL_admin.php?do=create with GAL_admin.php?do=add

Thanks for that!can you belive from a install today I got the same error.

[T3MEDIA]

CRAP! why wouldnt you guys post the db info here? I went thru all the pages.
not one.

I have no idea why people on vb do stuff like "yeah I got it to work thanks"
and dont put what they had to do to get it right. AND I dont mean "yeah I just had to mod my db schema"

freakin guys man.

Geek bro the installer gave me the same db error on a install on today's date.

[zachlee]

CRAP! why wouldnt you guys post the db info here? I went thru all the pages.
not one.

Are you refering to the problem, of the geek_autolink tables not being created when running the install.php? The following:

'CREATE TABLE IF NOT EXISTS `' . TABLE_PREFIX . 'geek_autolink` (
`id` int(11) NOT NULL auto_increment,
`text` varchar(25) NOT NULL default \'\',
`link` varchar(250) NOT NULL default \'\',
`ignorethread` int(11) NOT NULL default \'0\',
PRIMARY KEY (`id`)

Can be found in the install.php file. Using phpmyadmin or webmin (or any mysql utility) to create those tables with the information provided (in install.php) and GAL will work perfectly.

[The Geek]

Hey guys. I am not sure what the problem is. It looks like there is no table created during the install.
I have just tested this about 50 ways with a new 3.07 and not had a problem so I am wondering if maybe it has to do with mysql and support for the create table if not exists? Not sure so I removed the test anyway. DB errors are shut off so it wont bomb out if there is a table or not.

Anyway... like I said the only thing I could think of?!?

[jcr]

I upgraded to the lates version, but now the safe-mode does not work at all?

See this post for exactly what I mean ( well it should, but does not )

http://www.bareprat.com/showpost.php?p=232129&postcount=8

The above does not work at all,

But this:
http://www.bareprat.com/showthread.php?p=232129#post232129

Shows you exactly what i mean..

[zachlee]

Is it possiable to us a JS command with GAL?

ie,

onmouseover="window.status='Football-Forums.com Affiliate';

If so, how/where would I place it, to make it work.

[The Geek]

JCR - hey man - I totaly missed your post - sorry about that. Can you try rebuiling in dager mode for me and ill check the link again. There are snippets of the HTML that looks odd.

Zachlee - yea you can - you can find the html in the GAL_admin.php file (under redbuild_datastore)

[agiacosa]

Hi,

I have a situation where I need to provide auto links to the following:

rotala macranda
rotala rotundifolia
rotala wallichii

Is it possible to have the system link each one to a different link or is it going to link all three to the same link? Do I need to put it into some sort of order?

[The Geek]

Hi,

I have a situation where I need to provide auto links to the following:

rotala macranda
rotala rotundifolia
rotala wallichii

Is it possible to have the system link each one to a different link or is it going to link all three to the same link? Do I need to put it into some sort of order?
each link can be seperate and wont cause a problem as each keyword is different.

however if you had rotala as a keyword too, then you would want that last as it will replace all the others first, then the single rotala.

If that makes sense ;)

[Lionel]

I have an idea for mass auto-linking, using vbalinks and geekarticles (I use for biographies etc...)

1-we alter table links add new field gal_linked.

2-we do a query, select title, url where gal_linked=0

3-we get the result in a new editable page where we can alter title, and a checkmark to select it.

4-and on submit, we update auto link with those values while setting gal_linked = 1 in links table

same thing for Articles.

Sound simple, right?

I don't know how to do it!!! But I know it should be less than 5 minutes.

[Lizard King]

I have an idea for mass auto-linking, using vbalinks and geekarticles (I use for biographies etc...)

1-we alter table links add new field gal_linked.

2-we do a query, select title, url where gal_linked=0

3-we get the result in a new editable page where we can alter title, and a checkmark to select it.

4-and on submit, we update auto link with those values while setting gal_linked = 1 in links table

same thing for Articles.

Sound simple, right?

I don't know how to do it!!! But I know it should be less than 5 minutes.
Maybe it might be possible to search this query for some forums thread name . Instead of writing one by one this might be way easier to use and it will give vbulletin'e complete new face.

[memobug]

TNG, Three questions before I try installing this, please:

1. could you explain this statement on the README in the context of now having safe mode, is it still true?
Can really mess up some hyperlinks. For example, if a post has www.bob.com/my_bestlink.html (http://www.bob.com/my_bestlink.html) and you have bestlink as an autolink... it will mess up the original hyperlink.
Curernlty I have no way to prevent this apart from prayers. Interestingly, it happens very seldom.

2. Does this actually alter the post text or does it simply modify the output as it is being displayed? That is if it turns out to be a problem can we just uninstall the hack without worrying that the data have been linked?

3. What does someone who edits a thread that contains autolinks see in the editor? ANSWER - It's fine it the autolink doesn't show in the editor!

Thanks a lot.

Matt

[memobug]

Note on installation

Step 4.1 says // *************************************************
if (can_administer('canadminstyles'))



but in vb3.07 I have

// *************************************************

$printhr = false;
if (can_administer('canadminstyles'))

I put the the insertion before the comment bit.


2. Also - the CSS for the autolinks is still missing in the download.

3. Any idea why the sequence

, keyword
. keyword

(that is comma-space-keyword or period-space-keyword) doesn't autolink the keyword?

Regards,

Matt

[trainer]

will these both link

name and Name - will this hack treat these as the same? even with the first letter capitalized?

[memobug]

will these both link

name and Name - will this hack treat these as the same? even with the first letter capitalized?I believe so - I haven't seen any case sensitivity in any of my links yet.

Regards,

Matt

[The Geek]

Matts right - it will link them regardless of case. name Name nAme NAME names name. name NAme! are all the same to the system

[Tom1234]

The CSS for the autolinks is still missing in the download.

[Tom1234]

How about adding an option of only linking a phrase once per post or once per thread rather than every occurrence so it's not so annoying to members?

One problem... in safe mode, if you search on the phrase, it won't get linked because of the <span class="highlight"> tag that surrounds it. What would be a good way to avoid that problem - insert a space before and after the highlighted word in the highlighting code so the HTML would come out as

<span class="highlight"> PHRASE </span>

which would then get autolinked?

[TheFocusElf]

tag -- to be installed tomorrow night -- geek autolinker 2.0

[The Geek]

interesting idea - ill hve to play about with that one. As far as linking once per post... ill have a play with that as well.

[Tom1234]

Geek,

You still have the "gel" typo in the README:

3.2 BELOW ADD

// === GEEK AUTOLINK step 3.2 ===
'gal_text', 'gal_links', 'gal_ignores','gel_settings',
// === /GEEK AUTOLINK ===

[The Geek]

Geek,

You still have the "gel" typo in the README:

3.2 BELOW ADD

// === GEEK AUTOLINK step 3.2 ===
'gal_text', 'gal_links', 'gal_ignores','gel_settings',
// === /GEEK AUTOLINK ===
thanks - ill look at rolling up to another release this week

[Lizard King]

If i move the geet auto link menu to modcp will my mods also be avaible to add links ? Cause it is a pain in the ass to add bunch of links by myself :rolleyes:

[The Geek]

If i move the geet auto link menu to modcp will my mods also be avaible to add links ? Cause it is a pain in the ass to add bunch of links by myself :rolleyes:
havent tried it - but should work in theory ;)

[Tom1234]

greenhybrid: Make sure the longer is in the system first.
The order that they are put in is the order they are matched.


Is there a better way to do this rather than requiring the longer match phrase (e.g. Toyota Celica) be entered before the shorter one (e.g. Toyota)? Maybe you can sort them internally first by length and then by alphabetic?

[The Geek]

Is there a better way to do this rather than requiring the longer match phrase (e.g. Toyota Celica) be entered before the shorter one (e.g. Toyota)? Maybe you can sort them internally first by length and then by alphabetic?
currently - no there isnt. Ill add an ordinal column in a future release though.

[memobug]

Ill add an ordinal column in a future release though.

1. That would be helpful. I found that I'd added so many links that being able to organize them by categories would be helpful (movies, games, etc) I would probably be using that ordinal column for that purpose, so it would help

2. How about adding a TITLE text field to the link so a tooltip shows up when you hover on it?

Thanks for this great hack!

Matt

[The Geek]

1. That would be helpful. I found that I'd added so many links that being able to organize them by categories would be helpful (movies, games, etc) I would probably be using that ordinal column for that purpose, so it would help

2. How about adding a TITLE text field to the link so a tooltip shows up when you hover on it?

Thanks for this great hack!

Matt
Yea - its actually already there - I just forgot to tie it into the admincp!

Ill look into the categories option too

[Tom1234]

I notice that the text to match on can only be 25 characters since that is its size in the DB. Is it OK to just change that VARCHAR(25) to a larger number in the DB without breaking anything else?

[The Geek]

sure - wouldnt cause any problems being longer. I dont think there is a check on the textbox size before update/insertion.

[Tom1234]

The autolinker was working perfectly, but then began displaying incomplete link code in the message posts rather than using the proper link syntax. I do not have an example since I immediately rebuilt the list and fixed it, but the only things I can think of that changed was that I deleted one autolinker entry (which was the first time I had done that) and later a re-start of the httpd daemon. Any clues as to how things could have been corrupted with the autolinker text replacement? I'm not familiar with the "datastore" and how that maintains state through an httpd restart. My suspicion is the entry deletion however. I'm using "safe mode" here if that matters.

[The Geek]

hmmm. got me. Every time you make a chage - it rebuilds the datastore. THe datastore is simply just a serialized version of an array of built links. this saves an extra query to the db and save looping through and rebuilding at run time.

The only thing I can think of is that it rebuilt it in danger mode instead of safe mode.

[Lizard King]

Geek for the next version is there a way to add some forum id's to settings so that whenever a new thread will be open in that forum the thread name will be auto linked ?
it might be really good for movie - book forums .

[The Geek]

Geek for the next version is there a way to add some forum id's to settings so that whenever a new thread will be open in that forum the thread name will be auto linked ?
it might be really good for movie - book forums .
Hey Mert - I think that could be a little bit of a nightmare. Maybe as an addon or something. GAS uses a new file that ties into this that could be used as the basis for something like this.

[Hooper]

I'm having the same database error I'm reading about in here. Anyone know how to resolve it with vb3.07?

Thanks

[The Geek]

I'm having the same database error I'm reading about in here. Anyone know how to resolve it with vb3.07?

Thanks
You mean the table creation at installation? here is the command to create the table. Just run this in a sql window:

'CREATE TABLE geek_autolink (
`id` int(11) NOT NULL auto_increment,
`text` varchar(25) NOT NULL default '',
`link` varchar(250) NOT NULL default '',
`ignorethread` int(11) NOT NULL default '0',
PRIMARY KEY (`id`);


HTH's

[Hooper]

You mean the table creation at installation? here is the command to create the table. Just run this in a sql window:

'CREATE TABLE geek_autolink (
`id` int(11) NOT NULL auto_increment,
`text` varchar(25) NOT NULL default '',
`link` varchar(250) NOT NULL default '',
`ignorethread` int(11) NOT NULL default '0',
PRIMARY KEY (`id`);


HTH's


I get an error running that as well... :=(
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ''CREATE TABLE geek_autolink (
`id` int(11) NOT NULL auto_increme' at line 1

[konstance]

There seems to be a parenthesis missing at the end of the statement:

CREATE TABLE geek_autolink (
`id` int(11) NOT NULL auto_increment,
`text` varchar(25) NOT NULL default '',
`link` varchar(250) NOT NULL default '',
`ignorethread` int(11) NOT NULL default '0',
PRIMARY KEY (`id`));

[007]

What this is missing is an option to enter text for "STATUS BAR DISPLAY!"

Let's put some basic javascript to work and hide those affiliate codes in the links! :)

I have searched the files inside and out with no luck whatsoever on any ideas for doing this.. I can't find where links are made..

[The Geek]

What this is missing is an option to enter text for "STATUS BAR DISPLAY!"

Let's put some basic javascript to work and hide those affiliate codes in the links! :)

I have searched the files inside and out with no luck whatsoever on any ideas for doing this.. I can't find where links are made..
currently, links are made in the admincp.
However that is about to change. I have a new version I am working on the upgrade script for right now.
If you want to slide me the js ill see if I can work it into the next release.

The new version features:
Description field (for the url 'title' attribute). Was in there, just didnt draw up the interface for some dumb reason
Ordinal field. So you can specify the order of replacement instead of the 'first come first served' option.
Installer. This is the thing that is taking so freaking long. I am adapting my GISH installer for this hack. Eventually all of my hacks will feature my installer that auto edits files for you (if you want that is).
Limit option. Someone was asking for the option to limit a match to once per post. Thats in there now.

I think thats about it besides a few other tweaks and fixes.

Beta testers for the installer/upgrader can PM me if they want to give it a whirl. Should be ready by tomorrow if I get time to finish it up.

[konstance]

I have a little problem with the comments under the article. When I set "Show preview of comments only on the last page" to No, the comments do not appear at all. There is a word "Comments" under the article, but no comments themselves. Any Ideas why that would happen?

You can check out the test page here: (currently that option is set to No)

http://www.digital-tutors.com/forums/forumdisplay.php?f=107

Thanks in advance for any help

[The Geek]

I have a little problem with the comments under the article. When I set "Show preview of comments only on the last page" to No, the comments do not appear at all. There is a word "Comments" under the article, but no comments themselves. Any Ideas why that would happen?

You can check out the test page here: (currently that option is set to No)

http://www.digital-tutors.com/forums/forumdisplay.php?f=107

Thanks in advance for any help
check the number of comments to preview (and post the response in the GAS thread as this thread is for the Geek Auto Linker ;) )

[konstance]

ooops, sorry about that. I was wondering why I couldn't find my post in the GAS forum! ha.

[zachlee]

What this is missing is an option to enter text for "STATUS BAR DISPLAY!"

Let's put some basic javascript to work and hide those affiliate codes in the links! :)

I have searched the files inside and out with no luck whatsoever on any ideas for doing this.. I can't find where links are made..


I tried looking at the code as well to implement this, but came up short. I would LOVE to be able to hide affiliate links.

[memobug]

I tried looking at the code as well to implement this, but came up short. I would LOVE to be able to hide affiliate links.

If your goal is to hide affiliate URLs you can use tinyurls (http://www.tinyurl.com/) (free) or set up your own referrer program that will actually count clickthrus. Maybe you can find a free one of those, but these guys are pretty good:

http://www.cgiscript.net/cgi-script/csNews/csNews.cgi?database=cgi%2edb&command=viewone&id=70

Regards,

Matt

[007]

That reminds me of something that would be sweet. What if the auto linker counted clicks? That would be awesome!

[The Geek]

I will add the status bar js to the next release. As far as the click throughs - this has been mentioned before - but really isnt in the scope for this. Saying that... its a cinch to do. Maybe I will throw that into the next release as well.

[fly]

Has a timeout feature been asked or addressed in this thread? I can't seem to find it if it has. I'd like the links to stop working, say after 30 days...

[The Geek]

Has a timeout feature been asked or addressed in this thread? I can't seem to find it if it has. I'd like the links to stop working, say after 30 days...
Hey Fly.
This feature has not been asked for. May be interesting to have - but that would require and additional field (expiry) and a cron job to rebuild the datastore.
Not overly difficult, but it wont make it into the next release if thats cool.

[mekro]

Hi

I have installed this on my yugioh site, however i have noticed a problem and that is i would like to link card names that are used in posts to link to the actual cards in the card database, i setup 2 test links however found a problem:

If i set it up to recognize the word: exodia it links to it fine, however if i try to set it up to regonize: "exodia the forbidden one" it does not link it in the post, is there a way to make it do so?

Thanks
Kirk

[fly]

Hey Fly.
This feature has not been asked for. May be interesting to have - but that would require and additional field (expiry) and a cron job to rebuild the datastore.
Not overly difficult, but it wont make it into the next release if thats cool.
Thats cool. Thanks man. I need a bunch of stuff to expire, like usergroups, for other stuff. So your code will really help, as I am unable to write my own code. :pirate: Thanks man!

[The Geek]

Hi

I have installed this on my yugioh site, however i have noticed a problem and that is i would like to link card names that are used in posts to link to the actual cards in the card database, i setup 2 test links however found a problem:

If i set it up to recognize the word: exodia it links to it fine, however if i try to set it up to regonize: "exodia the forbidden one" it does not link it in the post, is there a way to make it do so?

Thanks
Kirk
Hey Kirk - the replacements are made in a first come first serve bassis. If you edit those 2 links and do the longer one first, it will link it.
That or wait until next version (any day now) as that will allow you to specify the order of replacement.

HTH's

[The Geek]

The RC1 of GAL 3.00 has been released over here (https://vborg.vbsupport.ru/showthread.php?t=79627).

[Yehuda]

hi,

I installed the hack and it works great. Only one problem...after instalation, it changed the behaviour of my admin CP.

when I click on an option (on the left hand side), it opens on a new window as opposed to opening on the same page (on the right hand side).

How can I fix this?