vB Spell :: Spell Checker in WYSIWYG and Standard Modes

There's also a vB 3.5 version: https://vborg.vbsupport.ru/showthrea...threadid=92202

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: Many of you liked PungoSpell, but didn't like recompiling PHP for it. Many liked PHPSpell, but didn't like the lack of WYSIWYG support and browser compatibility. vB Spell solved both problems, I hope, by combining the best of each.

Features:
o Supports most recent versions of browsers. Tested on IE, Firefox, Mozilla/Netsacpe, Opera and Konqueror (Konqueror implies Safari, but please confirm Mac folks)
o Learn Feature uses cookies, so it won't increase the database size
o Admin panel options
o Skips quoted text and other tags (PHP, code, etc.)
o Usergroup permisisons
o Template based interface, and uses your default style.
o Link buttons (Thesarus and Lookup) with links to Merriam Webster's online thesarus and dictionary links with the suggestion for misspelled words.

Installation:
1. Download vbspell.zip and upload the files and run vbspell_install.php
2. Go to AdminCP > vBulletin Options > vB Spell and edit your usergroup permisisons.
3. For each template where you would like to add a vB Spell, do the following edits (Example: editpost, newreply, newthread, etc.)

Note: For those running PHP in cgi mode and get timeouts while installing the dictionary, you can download the file dictionary_sql_for_php_cgi.zip to import it to mysql through the mysql command line.

A. Find:

</head>

Add before:

<script src="vbspell.js"></script>

B. Find: (or anywhere in the body)

$navbar

Add after:

<form name="spell_form" id="spell_form" method="POST" target="spellWindow" action="vbspell.php">
        <input type="hidden" name="spell_formname" value="">
        <input type="hidden" name="spell_fieldname" value="">
        <input type="hidden" name="spellstring" value="">
        <input type="hidden" name="toolbar" value="">
</form>

C. Find the submit and preview buttons:

		<input type="submit" class="button" name="sbutton" value="$vbphrase[save_changes]" accesskey="s" tabindex="1" />
		<input type="submit" class="button" name="preview" value="$vbphrase[preview_changes]" accesskey="p" tabindex="1" />

Add below:

<if condition="$show['wysiwyg']">
        <input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', 'WYSIWYG_HTML', '2');">
<else />
        <input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', 'message', '1');">
</if>

Other templates:

Optional: Other Templates that contain edit boxes are:
USERCP_SHELL just add the first change (A) here in above the </head section. Required for pm_newpm and modifysignature.
editpost
Calendar Templates: calendar_edit
New Posting Templates: newreply, newthread
Modify User Options Templates: add the the first change (A) in USERCP_SHELL) and the rest (B and C) in modifysignature

Quick reply: . Put change (A) in showthread, above </head>. Then add change B to the beginning of showthread_quickreply. Then find

			<input type="submit" class="button" value="$vbphrase[go_advanced]" accesskey="x" title="(Alt + X)" name="preview" tabindex="3" id="qr_preview" onclick="this.form.clickedelm.value = this.value" />

Add after it:

<if condition="$WYSIWYG == 2">
        <input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', 'WYSIWYG_HTML', '2');">
<else />
        <input type="button" class="button" value="Spell Check" onClick="spellCheck('vbform', 'message', '1');">
</if>

History:

December 25, 2005: Security fix for cases where you allow HTML posts and they contain malicious code (Credit goes to Brendan Donahue for finding the issue and alerting TechGuy, and to TechGuy for alerting me to it)

November 2nd. 2005: Fixed a bug with slashes in text.

Oct 17, 2005: v0.9.5 Cecks for primnary and secondary group permission. Also fixed quoted words.

July 10, 2005: v0.9.4 Added an error if accessing vB Spell directly, like from who's online page.

July 10, 2005: v0.9.3 Fixed a problem with capitalized first letter of words, so chosing a suggested alternative would not alter capitalization.

July 10, 2005: v0.9.2 Fixed a browser bug, fixed an installer issue effecting some, and fixed handling of some special characters.

July 9, 2005: v0.9.1 Learned words in cookies are no longer case sensitive. Abbreviations are ignored and not spell checked.

July 8, 2005. initial release, v0.9

Please click Install if you have installed this mod.

[AtoZ]

PLEASE correct the spelling of thesaurus on the vbspell screen... It is showing as thesarus.

Edit: I discovered that this can be fixed in the "vbspell" template, but it would be nice to fix that since this is a spell checker.

Thanks for this mod - I hope it helps my members' spelling.

[AtoZ]

Is it okay to share my revised vbspell template? In addition to fixing the spelling error for Thesaurus, I made some other modifications. I found a way to add a description for what each button does when the user mouses over it. The description shows up in the status bar.

For example, here is the code for the "Change All" button:

<input type="button" class="button" name="changeall" value="Change All" onClick="replaceAll()" ONMOUSEOVER="window.status='Change all instances of this word.';return true;" ONMOUSEOUT="window.status='';return true;">

When the user mouses over it, the status bar text says "Change all instances of this word."

P.S. Great mod!

[zendiver]

This is the error I get trying to install this on a FRESH vBullentin 3.08
There seems to have been a slight problem with the Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.8:

Invalid SQL: REPLACE INTO vb3_vbspell VALUES('divines', 'TFNS')
mysql error: User 'xxxxxxx' has exceeded the 'max_questions' resource (current value: 50000)

mysql error number: 1226

Date: Wednesday 31st of August 2005 11:43:03 AM
Script: http://www.divingandfitness.com/foru...install&step=5
Referer: http://www.divingandfitness.com/foru...install&step=4

[tamarian]

Originally Posted by zendiver

Invalid SQL: REPLACE INTO vb3_vbspell VALUES('divines', 'TFNS')
mysql error: User xxxx has exceeded the 'max_questions' resource (current value: 50000)

mysql error number: 1226

This seems to be a limit set by your host on the number of queries your forum can run per hour. If this is a shared account, you'll probably need the host to install it for you, or adjust the limit.

P.S. You might want to edit your post to remove the username for the database.

[zendiver]

tamarian, thanks for the reply. I have checked with them, my hosting company, and they say that I don't have a limit. I have 4 domains with them and then was one is actually my testing site. I am going to completely delete EVERYTHING from this site, delete the database, do a fresh install of vBulletin and then try it again.

On my other sites, I have vBulletin, vbPortal, vbPhotoPost, a chat room, and quite a few other things installed and they all work without a glitch. *shrugs*

[tamarian]

Originally Posted by zendiver

tamarian, thanks for the reply. I have checked with them, my hosting company, and they say that I don't have a limit.

The error message clearly indicates that there is a limit. If your host does not have a limit, then someone by mistake may have setup MySQL. Check your mysql settings and user priviliges. If this error happens again, send a copy of the error to your host, so they can see the 50,000 limit.

[tamarian]

Originally Posted by AtoZ

Is it okay to share my revised vbspell template?

By all means, yes. Might include it on the next update

[zendiver]

Tamarian, I got a response from my hosting company and this what they had to say:

The database you are using is asking too many questions within one hour (50,000). If you have the .sql file and the database created, please provide the database name and location of the .sql file and we can manaully import it for you on the server.

With the install that you have provided, there wasn't a .sql file BUT there was an additional file: dictionary.sql that I downloaded also. Is this the one that I should send to them? If so, I am a bit concerned with the format as it doesn't have the prefix on it:
Example:

REPLACE INTO `vbspell` VALUES ('a', 'A');

Shouldn't that be:

REPLACE INTO `vb3_vbspell` VALUES ('a', 'A');

And lastly, if they import it in, then what do I do about the rest of the installation as it seems that I can't get past Step 5?

Thanks for your time.

[tamarian]

Originally Posted by zendiver

Tamarian, I got a response from my hosting company and this what they had to say:


With the install that you have provided, there wasn't a .sql file BUT there was an additional file: dictionary.sql that I downloaded also. Is this the one that I should send to them?

No, the first post states that file is for those in cgi mode, or those who want to import it without the install script.

The installation script comes with a dictionary text file IDCTIONARY.DIC

If so, I am a bit concerned with the format as it doesn't have the prefix on it:
Example:

REPLACE INTO `vbspell` VALUES ('a', 'A');

Shouldn't that be:

REPLACE INTO `vb3_vbspell` VALUES ('a', 'A');

The installation script does handle text prefixes. The one you're using is a streight mysql dump, and you don't need it if you run the install script.

If you use the dump instead, then just rename the table when your done through mysql client, or phpmyadmin.

And lastly, if they import it in, then what do I do about the rest of the installation as it seems that I can't get past Step 5?

If they import it, you don't need step 5, you're done.

[zendiver]

Ok, I can understand that, so this is what I plan to do.
Dump the dictionary.sql into my database.
Then, do I run the install program?