New Posting Features - vB Spell

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 me permission to release a 3.6.x version with updates.
This version should work with both 3.5.x and 3.6.x series.

Features:

• Supports most recent versions of browsers. Tested on IE, Firefox, Mozilla/Netsacpe, Opera and Konqueror (Konqueror implies Safari, but please confirm Mac folks).
• 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-reg.zip.
  • Upload DICTIONARY.DIC to your forum home directory.
  Alternate Install
  • Unzip dictionary-alt.zip.
  • Import the SQL files to your database.
• Import product-spellvb.xml.
• Go to AdminCP > vBulletin Options > vB Spell and edit your usergroup permisisons.
• Template changes are now automatic. [accept for quickedit]

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-spellvb.xml.

To manually force the quickedit template to work with this mod:
postbit_quickedit
Find

		<if condition="is_browser('ie')">
			<td><img src="$stylevar[imgdir_editor]/separator.gif" width="6" height="20" alt="" /></td>
			<td><div class="imagebutton" id="{$editorid}_cmd_spelling"><img src="$stylevar[imgdir_editor]/spelling.gif" width="21" height="20" alt="$vbphrase[check_spelling]" /></div></td>
		</if>

Replace with

		<td><img src="$stylevar[imgdir_editor]/separator.gif" width="6" height="20" alt="" /></td>
		<td><div class="imagebutton" id="{$editorid}_cmd_spelling(null)"><img onclick="spellCheck('3', '$editorid', '2');" src="$stylevar[imgdir_editor]/spelling.gif" width="21" height="20" alt="$vbphrase[check_spelling]" /></div></td>

History:
0.10.x NyNe versions
v0.10.3b - 06/22/07:
Compensated for an issue brought up in this post.
v0.10.3 - 06/22/07:
Added a check to the product installer so it would not remove the vbspell table after just having created it.
Added $vboptions[bburl] to all template code that asks for files (this *might* fix the PhotoPost issues - no promises).
v0.10.2b - 08/26/06:
Fixed error in product installer (removed table prefix).
Changed all <? to <?php for php5 compatibility.
v0.10.2a - 08/26/06:
Removed alt product installer.
Product installer included now checks for dictionary file, if dictionary file is not found it continues installing.
Product installer no longer drops dictionary table before installing.
v0.10.2 - 08/22/06:
vbspell template is now XHTML 1.0 Transitional.
Fixed a version check for vbspell template (made compatible with 3.5.x).
vB Spell window should now open on top of other windows.
Removed table prefix for vbspell sql table (product installer includes code to remove old tables).
Included alternate installation method (Credit goes to Replicators for the SQL Install method).
v0.10.1 - 08/21/06:
Beta release for 3.6.x series.
Switched to product/plugin based installer.

0.9.x tamarian versions
v0.9.12 - 12/25/05:
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).
v0.9.11 - 11/02/05:
Fixes a bug with slashes in text.
v0.9.10 - 10/17/05:
Check for primary and secondary group for permission.
Bug fix for quoted words.
v0.9.9 - 09/13/05:
Bugfix for JS on IE with RC3.
v0.9.8 - 07/15/05:
Bugfix for JS code mismatch with template.
v0.9.7 - 07/14/05:
Initial release for vB 3.5 beta-4.

NOTE: The above section says NyNe versions, because I go by the name NyNe everywhere accept here.

Scrrenshots: (from tamarian's 3.0.7, but it's identical)

[B3y0nd]

This is a mod that I would love to have on my boards, but it STILL seems to have major issues. Too bad.

I'll keep checkin' in from time to time to see if it ever becomes a reliable hack.

[bada_bing]

Originally Posted by bada_bing

Ok getting a bit peeed off here.. I am trying to install this hack and I have tried to import the plugin using method 1 by uploading the dictinary file then installing the plugin and I got an error. Then I imported the dictinary files into the database then imported the plugin and still get the same error.. What is going on here is the error.
Fatal error: Maximum execution time of 60 seconds exceeded in c:\domains\mysite.com\wwwroot\forums\includes\clas s_core.php on line 363

Can someone help me PLEASE.. .Author where are you man?

[bada_bing]

Boy for this to be a 3.6.0 hack the support sucks!!! Can someone assist on getting around the errors im having

[bada_bing]

Never mind got it working.. For anyone else having problems running the plugin, I would right off the bat import the dictonary queries manually then run the plugin. VERY IMPORTANT & NOT DOCUMENTED. If you manually run the database queries you MUST remove the DOCTONARY file you originally uploaded to the Forums directory so that the plugin does not detect this file and try to run the queries again..

[lazserus]

I've followed the instructions and installed this mod but I am not seeing a vBSpell option in my AdminCP, nor does it show on my forums.

1. I've imported the xml file using vBulletin's "Add Products" option.
2. I've uploaded the vbspell files.
3. I've uploaded the DICTIONARY.DIC file

I received no errors when importing this mod, yet it does not show anywhere on my forums. Any suggestions?

[Knightmane]

I am a little leery to install this hack, but I wanted to mention that Mozilla Seamonkey Suite version 1.1 has a built in spell checking dictionary that checks your spelling as you type in posting fields. You can even add words to the browser's dictionary... this is very handy for getting around words that are used in TV shows that simply do not appear in the dictionary (i.e. zords, etc.)

[melbo]

Originally Posted by zetetic

The regular install is much easier. Only use the alternate if the regular fails.


As of today (version 0.10.2b), the XML file has not been updated.

Before you attempt to install this product, you should open the product-spellvb.xml file and...

find:

// Create vB Spell Table
$db->query_write("CREATE TABLE IF NOT EXISTS vbspell (
  word varchar(30) NOT NULL,
  sound varchar(10) NOT NULL,
  UNIQUE KEY word (word),
  KEY sound (sound)
) TYPE=MyISAM");

// Remove Old vB Spell Table
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "vbspell");

and replace with:

// Remove Old vB Spell Table
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "vbspell");

// Create vB Spell Table
$db->query_write("CREATE TABLE IF NOT EXISTS vbspell (
  word varchar(30) NOT NULL,
  sound varchar(10) NOT NULL,
  UNIQUE KEY word (word),
  KEY sound (sound)
) TYPE=MyISAM");

Otherwise it will drop the vbspell table right after it creates it, before importing the dictionary!

That should be bumped to the first post in this thread. After a few pages, we new installers try all the junk that is reccomended post by post. Was just about to toss this laptop out the sunroof when I read this one. THanks!!!

[parabat]

Is it at all possible to select your language of choice, dictionary you want to spell check with?
My board has multiple languages and it would be ideal if the users could select the dictionary of choice when they doing the spell check.
Is that possible, or do I have to integrate the various language dictionaries into one??

-PB

[valdet]

Before we try this , can anyone please confirm that this spellchecker works on 3.6.5 and it won't crash your database..

[perfphysio]

Originally Posted by valdet

Before we try this , can anyone please confirm that this spellchecker works on 3.6.5 and it won't crash your database..

Works on my 3.6.5 fine