New Posting Features - vB Spell :: Spell Checker in WYSIWYG and Standard Modes

What this does: vB Spell allows you to install a dictionary (English dictionary included) into your MysQL database, and provide a spell checking window that works in both of vB's editor modes, standard and WYSIWYG.

Background: This mod was originally developed by tamarian for vB 3.5.x. With the release of 3.6.x the installer stopped working for fresh installs and the template changes were considerably out of date, tamarian gave cynix2 permission to release a 3.6.x version with updates. I have now carried it over to 3.7.x and will support it to the best of my ability.
This version should work with 3.5.x, 3.6.x, and 3.7.x series.

Features:

• Supports most recent versions of browsers. Firefox, Mozilla/Netsacpe, Opera and Konqueror (Konqueror implies Safari, but please confirm Mac folks). Currently does NOT work in IE 7, if anybody can look through the code and know of a way to fix the mod to work in IE, then please send me a pm.
• Learn Feature uses cookies, so it won't increase the database size.
• Admin panel options.
• Spell Check button appears anywhere there is a WYSIWYG Enhanced or Standard Editor Toolbar [includes quickreply but not quickedit].
• Skips quoted text and other tags (PHP, code, etc.).
• Usergroup permisisons.
• Template based interface, and uses your default style.
• Link buttons (Thesarus and Lookup) with links to Merriam Webster's online thesarus and dictionary links with the suggestion for misspelled words.

Installation:

• Unzip main package.
• Upload the contents of the 'upload' folder to your forum home directory.
  Regular Install:
  • Unzip Dictionary.zip.
  • Upload DICTIONARY.DIC to your forum home directory.
  Alternate Install
  • Unzip Manual-SQL.zip or Split-SQL.zip.
  • Import the SQL files to your database.
• Import product-vbspell37.xml.
• Go to AdminCP > vBulletin Options > vB Spell and edit your usergroup permisisons.
• Template changes are now automatic. [need tms]

Q: What is the Alternate Install method for?
A: If you are having problems with the Regular Install (such as your dictionary import freezes at x%) then you should consider using the Alternate Install. If neither of these methods work for you then there might be an issue with your server host.

Upgrading:

• Unzip main package.
• Upload the contents of the 'upload' folder to your forum home directory.
• Import product-vbspell37.xml.

To make template editing less tedious i have made use of Andreas Template Modification System found here. If you install tms before applying this mod, all template edits will be done for you. If you do not want tms installed, then i have supplied easier to understand template editing instructions inside the mod zip file.

IMPORTANT: If you decide to use tms and have the templates be automatically installed, then you need to go into your styles and save the following templates.

editpost, newreply, newthread, album_pictureview, calendar_edit, visitormessage_editor, socialgroups_editor, USERCP_SHELL, SHOWTHREAD, postbit_quickedit, pm_newpm, picturecomment_form, and modifysignature

Just go into the templates and save it without making any changes for each skin. TMS will not edit any unmodified templates, so if any of them templates are already red, then they are already modified and you don't need to save them.

HISTORY:
1.1 - Added use of TMS to make template modification easier.
1.2 - Added tehtide's fix from here
1.3 - Made some changes in the product, and made manual template instructions a little less tedious, but there is no easy way of doing it unfortunantly. You will need to redo the template edits that go above </head>.

[tehtide]

I got it to work by doing the following:

In the "vB Spell Template Changes" plugin change

<form name="spell_form" id="spell_form" method="POST" target="spellWindow" action="$vboptions[bburl]/vbspell.php">

to

<form name="spell_form" id="spell_form" method="POST" target="spellWindow" action="vbspell.php">

[Megatr0n]

Originally Posted by tehtide

I got it to work by doing the following:

In the "vB Spell Template Changes" plugin change

<form name="spell_form" id="spell_form" method="POST" target="spellWindow" action="$vboptions[bburl]/vbspell.php">

to

<form name="spell_form" id="spell_form" method="POST" target="spellWindow" action="vbspell.php">

What error were you getting before?

[Replicators]

I'm gonna need all of your help into making this mod work at 100%, as i am not the most knowledgeable at coding and such.

The only issue i see now is fixing it for IE as it will not work for internet explorer at this time.

[Scandal]

I think that this spell check system is increase the server's load when the dictionary file is big.

With english dictionary it works fine.
I try to re-install it with a greek dictionary* (7mb - when I import it to db the table was 14mb)...
The system accepts the dictionary and works ok on spelling BUT it want a lot of time and cpu usage to spelling!
eg, for 1 word needs 35sec (!!!) - for 15 lines of text needs 220+ seconds (!!! ) and the cpu usage on those secs was 90-100% (I run mysql and apache on my PC for tests).

Is there any way to fix this problem?
why it is so server intensive with this dic?


*i think that the dictionary file is ok... it is a text file with a lot of words, one below the other, without spaces (also, the words recognized ok from the vbspell on "suggestions" etc )

Thanks!!

Sorry for my bad english,


-peter

[Scandal]

hmm
I saw that the table "sound" has no data when i install greek dictionary...
I think that the metaphone algorithm doesn't support greek

I'll try to import data on table "sound" with the words of greek dictionary WITHOUT vowels... :erm:




-petros

[Digital Jedi]

I've run into a error, at least, in IE. The Spell Checker doesn't open and I get a 'spell_formname' is null or not an object error message in Quick Reply and in New Reply and 'document.forms[...].message' is null or not an object error message in the Visitor Reply form. Is this as simple as just having done the template edits wrong?

[bairy]

I get the same error in IE7. I'm gonna see if I can work it out.

Edit: Had a quick look. It seems that this line:
h_spellform.spell_formname.value = formName;

confuses IE. It works in Firefox but IE7 doesn't recognise "spell_formname" as part of the form object.

I'm afraid someone with more knowledge of javascript OO will have to have a look.

Also Replicators I found a bug, don't know if it's just my board. Within a thread if you click edit on any of the posts then the spell check button, it will check the text in the quickreply at the bottom. I'm guessing there's a mix up over the id of the textarea it should be reading.

[PoetJA-1975]

I actually like editing templates manually - It makes me feel like I'm actually doing something LOL - But I tell ya - these template edit instructions for vBSpell is one of the tedious set of instructions I've EVER seen... It'd be nice for you to at least order the instructions so that you're not coming back 3 or 4 times to edit the same template... Also may want to make clear that in some templates you will be making the same edit anywhere from 1 - 4 times LOL

At anyrate - Thanx very much for the sharing REPLICATORS. It would be wonderful to have spell check especially for a Forum like JPiC which specializes in the sharing of literature & poetry. I have an issue though - It's odd really - I've done the template edits - followed the instructions to the letter = none of the Spell Check buttons work when clicked.

Suggestions & Support appreciated

Jacquii.

[Megatr0n]

Has this hack worked for anyone?

[PoetJA-1975]

Actually - it doesn't seem compatible with Opera 9.5
In FF 3 - I'm getting a database error when creating thread. Quick Edit & edit seems to work well - Haven't tested in IE and I don't expect that I will.

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT word FROM vbspell WHERE word = 'haha';

MySQL Error : Table '#####_forums.vbspell' doesn't exist
Error Number : 1146
Request Date : Tuesday, July 15th 2008 @ 01:15:40 PM
Error Date : Tuesday, July 15th 2008 @ 01:15:43 PM
Script : http://jpicforum.info/vbspell.php
Referrer : http://jpicforum.info/newthread.php?do=newthread&f=34
IP Address : #####
Username : MsJacquiiC
Classname : vB_Database
MySQL Version : 4.1.20-log

Any ideas how to remedy the database error?

Jacquii.