Text Replacement Links 1.1 (Updated!)

Text Replacement Links

====================
Author: Ken 'LiveWire' Iovino
Site: www.vBhacks.us
Version: 1.1
====================

Updates

• No longer will phrase the the link if the letters are being used. (Example) If google is one of my TextLinks, and a member post "I just got googlefied" It will not link it.
• Mass Amounts of Queries per post fixed. This bug fixed by Kentaurus
• No longer Case Sensitive. This bug fixed by nexialys

Huge Thanks
I have to give a huge thanks to the following members that have helped me get this hack where it is now. Xenon, Kentaurus, nexialys, Geographic2, and lewekleonek. Thank you guys very much!

What this does
This will allow you to specified any text you add to automatically turn into a link when your members post the word. For example, you go to the ACP and add the word 'google' to the list and then you add the 'url' to googles website, and anytime a member post the word google, it will automatically turn it into a link. See screenshots for example.


To do list...

• Time to install: 3-5 minutes
• Queries to run: 1
• File Mods: 2
  • /admincp/index.php
  • /includes/functions_bbcodeprase.php
• Templates to edit: 0
• Templates to add: 0
• New Phrases: 14

Please read carefully and make all the necessary changes as stated. This is will work if installed properly.
PLEASE REMEMBER TO BACKUP BEFORE YOU BEGIN! If you like this hack

Click It

Help & Support
Before asking for support Please make sure you have done all necessary changes! If you still need support please post a reply here.

Please post bugs and errors here. Hope you like, feedback welcomed.

Special Thanks and Credit to
-Xenon
-Kentaurus
-nexialys
-Geographic2
-lewekleonek

[Logikos]

UPDATES
Query Bug fixed by Kentaurus. First post updated.

[Logikos]

Originally Posted by nexialys

case-insensitive is explained in the preg_replace page...:

http://ca.php.net/manual/en/function.preg-replace.php

preg_replace ("/myWord/i", "myotherword", $thissentence);
...

and is quicker than str-replace in all situations...

... i never used the replacement thing in the templates, i find that really annoying,because it's template based, so filter all the output, not only the text you post.. annoying!

this one will be performing good!!!

Hey nex, the problem is i don't know how to add the / / i in there using variables. I tried"

PHP Code:

        $code = preg_replace("/" . $text . "/i", $replacetext, $code); 


But that doesn't work, anyone have any ideas?

[Logikos]

Another Update
Fixed the case sensitive bug. Zip updated. Please ignore post # 12.

@Lime Wire... always the same pattern with PHP:

stuff between "" are to be included without quotes: "$stuff" ...

[Blam Forumz]

[SQL]
CREATE TABLE textlink (
textlinkid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
text CHAR(250) NOT NULL DEFAULT '',
link VARCHAR(250) NOT NULL DEFAULT '',
adddef SMALLINT(3) NOT NULL DEFAULT '0',
textdef VARCHAR(250) NOT NULL DEFAULT '',
PRIMARY KEY (textlinkid)
[/SQL]

gives me this error:

Originally Posted by PHPMyAdmin and vBulletin ACP

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7

[Logikos]

Originally Posted by Blam Forumz

[SQL]
CREATE TABLE textlink (
textlinkid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
text CHAR(250) NOT NULL DEFAULT '',
link VARCHAR(250) NOT NULL DEFAULT '',
adddef SMALLINT(3) NOT NULL DEFAULT '0',
textdef VARCHAR(250) NOT NULL DEFAULT '',
PRIMARY KEY (textlinkid)
[/SQL]

gives me this error:

You didn't copy the whole query in the install file.

[sql]
CREATE TABLE textlink (
textlinkid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
text CHAR(250) NOT NULL DEFAULT '',
link VARCHAR(250) NOT NULL DEFAULT '',
adddef SMALLINT(3) NOT NULL DEFAULT '0',
textdef VARCHAR(250) NOT NULL DEFAULT '',
PRIMARY KEY (textlinkid)
)

[/sql]

[cnczone]

installed and does not work

[Logikos]

If you followed the instructions correcly then it should work.

[cnczone]

When I add a link I get a "could not find phase" xxxxx

[Logikos]

Means you just missing a phrase, but that won't let the hack not work. Add a textlink then post that text in your forums, it still should replace the text with the link. Also, what phrase did it say that it could not find?