PHP Spell Checker intergration into vBulletin

Not too sure if this is where its meant to go but if it should be moved please move it.

I have been trying to find a simple spell checker to work on my forums for a while -
Eventually i found this one http://www.master-technology.com/phpbb/ which was working with phpbb.
As i have no idea how to code anything - at all!!! I asked one of their support teams to help and they gave me the answers.
So I can't take any of the credit for it, and thank them for helping me out.
At present it doesn't support vbulletin but since talkin to them they are going to be doing so in the near future.

files to upload: 17
files to edit: 1
templates to edit: 1 (possibly 2)

Instructions:
See the attached text file

[Tropicalsuns]

I can't seem to get by this:

You must choose a Database Type in the Spell Configuration file.

I have database set to MySQL

/ ----- Uncomment which ever line you need -----
// ----------------------------------------------
// $Spell_Config["DB_Type"] = "PHPBB";
// $Spell_Config["DB_Type"] = "Hivemail";
$Spell_Config["DB_Type"] = "MySQL";
// $Spell_Config["DB_Type"] = "PHPNuke";

It does not form a spelling table in the database.

It just goes right to the "you must choose database"

Any Thoughts?

[Nathan_Anderson]

All,

Thanks to iggy123 for supporting this mod on this site. I have got Jelsoft to give me access for a week to clear up any confusion and answer some questions. If you want me to stay around longer you will have to let the reps at Jelsoft know that I am legit and worth keeping around. :-D

0. Make sure you upload everything from Common & from the MySQL directories to your "spelling" directory!

1. I noticed that there was some confusion about "learn" -- this does not modify anything on your server -- you don't have to worry about users adding "bad" words to your dictionary. :-) It only effects the user who learned the word. So If I learn "phpSpell" then when you spell check it still will come up wrong for you; since only I learned it.

2. If you have pspell/ispell installed/built in to your php; you can choose to use pspell rather than mysql as your dictionary source.
(This presumes you have pspell/ispell installed correctly and a dictionary for them installed correctly).

3. Most people won't have pspell installed; so as of this moment you will want to choose:

$Spell_Config["DB_Type"] = "MySQL";

remember you only want ONE "DB_Type" uncommented. Second you will need to make sure you change right below it:

  $Spell_Config["DB_Username"] = "...";
    $Spell_Config["DB_Password"] = "...";
    $Spell_Config["DB_Database"] = "...";
    $Spell_Config["D_Host"] = "localhost";

To what you have in your "config.php" file.

4. For those who would like more possible words to show up you have two options:

  $Spell_Config["Levenshtein_Distance"] = 3;

change this to a larger number -- it will product more words.
and/or this one.

  $Spell_Config["Off_By_One_Search"] = 0;

Change to 1 or 2. 1 = Checks only if no matches were found using the normal search. 2 = Always check this way also. This option is tremendously slower than the normal method. Which is why the default is typically set at 1 or 0.

5. Feel free to ask me anything about the spell checker and problems with it and I will attempt to help you out while I have access to here.

And finally I have added support for vBulletin in the next version of the spell checker. :-) You will set the DB_Type = "vBulletin" and everything else besides the template change will be handled for you. However I need someone who wants to test it to make sure I got it right. :-D I don't have access to vBulletin, so I am using what I found posted in another forum as the base to add the support. If someone want to help me get it fully supporting 2.x & 3.x let me know!

Nathan.

[iggy123]

Nathan - Thnx for this support you application is great and thnx for taking the time to come to the boards and explain.
I would love to help you more, but as I explained in my mail messages to you - and i think you will have found out - I am not very good at php..
If you need a "character reference" then let me know.

[msimplay]

excellent is all i can say :P
should have it as default in vbulletin

[snakes1100]

vb 2.3.0

1st install, no issues and seems to be working fine. Thanks Iggy

Added all the additions Intex posted also, except i went back to the bginput instead of bgclass.

[Overgrow]

Thanks! (consider it licked)

[TLCanna]

Took me about three hours, but it was well worth the time, my members are ecstatic.

The way the dictionary and mysql work is, the installation creates a new table in the forum database. And you have to have the dictionary file in the spelling directory in order for the installation to load the new table. All of which was omitted in the documentation. Or at least I didn't see that part.

Also the javascript has to be changed to recognize the form and textbox.

Use the MySQL native connection for the database type, and supply the password and databse info of your forum database.

On a scale of complexity, this is by far the hardest hack yet, but the most rewarding.

If anybody needs help, shoot me an email, and I will be glad to help.

Anna

[TLCanna]

07-08-03 at 04:09 PM Tropicalsuns said this in Post #41
I can't seem to get by this:

I have database set to MySQL

It does not form a spelling table in the database.

It just goes right to the "you must choose database"

Any Thoughts?

You forgot to add the dictionary file to the spelling directory. Do that, and you will be off to the races.

[TLCanna]

06-20-03 at 12:40 PM iggy123 said this in Post #20
To disable the learn function totaly do this:

In the spelling folder open your spelling.js (remember to back it up first...)

Online 404 (approx) find:

PHP Code:

    odoc.write("<input type='button' value='Learn' class='clbutton' 
onclick='this.blur();parent.Learn_Word("+The_Current_Word_ID+");'><br>"); 


and delete all of it

then still in spelling.js find online 473 (approx):

PHP Code:

function Learn_Word(Word_ID)
{
  Word = Bad_Words[Word_ID].Word;
  Cookie = Get_Cookie("SpellLearned");
  if (Cookie == null) Cookie = Word;
  else Cookie = Cookie + "," + Word;
  Set_Cookie("SpellLearned",Cookie);
  Ignore_All_Words(Word_ID);
} 


and delete that as well.

Save the spelling.js and the learn button is removed.

Why do you want to delete the learn button, It looks like to me that it only updates a cookie, and doesn't actually add any new records to the databse. Am I missing something?

[Parker Clack]

Nathan:

I love your script and I am using it on my site. I also have pspell installed on my server and I was wondering how I would go about changing the config file so that it uses pspell instead of MySQL. Also once I have it set up to use pspell can I delete the spelling_words table that was set up in my database?

I almost forgot. I have aspell enabled with my version of PHP and I was wondering if this can be set up to use aspell instead?

Thanks,
Parker