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)

[Tabasco]

So which version is best to use with 3.6.4?

Regular Install:

* Unzip dictionary-reg.zip.
* Upload DICTIONARY.DIC to your forum home directory.

or

Alternate Install

* Unzip dictionary-alt.zip.
* Import the SQL files to your database.

Has the XML template or the MySQL issue been fixed? or do I need to follow change instructions?

Thanks

[HAVOK USA]

Installed without problems - set permissions - the icon shows in the post box, when I press it, nothing happens (no pop up box)

I have pop ups cleared for the website. Any ideas? I's love to use this hack.

[NeoGTavern]

Okay I go it installed and it is catching misspelled words, however it will offer no suggestions. When I click on the "suggestions" box I get the error

Line: 397
Char: 1
Error: Object does not support this property or method
Code:0

I am using vB 3.6.4

[zetetic]

Originally Posted by Tabasco

So which version is best to use with 3.6.4?
Regular Install:
or
Alternate Install

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

Has the XML template or the MySQL issue been fixed? or do I need to follow change instructions?

Thanks

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!

[Big Kahuna]

I had everything set up and was one click away from installing product -- and then read all of this.

I've got very cold feet now and won't do it.

I have MKPortal, Photopostphp, Photopost Classifieds, and a large forum. I can't afford the problems.

That said -- what irritates me is that Vbulletin doesn't have a spell check integrated in the product. I have one Vbulletin board at www.moparstyle.com and two FREE SMF forums at www.oldhippie.com and www.forums.diamondbackengines.com -- and amazingly, the free forums have a INCLUDED spell check that you can either use or disable. I've paid five years of dues at vBulletin after buying a perpetual license and don't have that benefit.

I'd spell check this post -- but there isn't one installed here lol

[Ski-Whiz]

Is it me, but in the product you tell it to create "vbspell" tables, and you next tell it to remove the old "vbspell" tables?

PHP Code:

// 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"); 


They are the same tables. I was wondering why I first got an error saying this table was already there.. So I removed it. Then when it installed, it never created it. Also the alternate way didn't install for me either at the time, as those SQL files insert data into the table it removed.

Not a biggie. I have it working now. Just a heads up.

[Ski-Whiz]

^^^^^^Never mind, I see this was already notice..

[Goat Boy]

Originally Posted by Pyrix

Sure,

Go to Plugin Manager in your admin control panel and edit the plugin 'vB Spell Template Changes'.

Add the following line at the very top before anything else:

if ( VB3_INTEGRATION != "on" ) {

and the following after the very last line:

}

Because the VB3_INTEGRATION variable should be defined when the WYSIWIG editor is being called from photopost, it'll fail that condition and the code to include the spell check won't be called.

You won't get spell check in the gallery, but you can still use it in the forums without messing up the gallery.

Works for me anyway

Ollie

I did this mod and Photopost Reply works but in the forums I get a Pop Up message about ieSpell is a spell checking tool for Internet Explorer and gives me a link to download it now?


Any Idea how to overcome that?
I am running 3.6.4

[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

[Replicators]

Originally Posted by Ski-Whiz

Is it me, but in the product you tell it to create "vbspell" tables, and you next tell it to remove the old "vbspell" tables?

PHP Code:

// 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"); 


They are the same tables. I was wondering why I first got an error saying this table was already there.. So I removed it. Then when it installed, it never created it. Also the alternate way didn't install for me either at the time, as those SQL files insert data into the table it removed.

Not a biggie. I have it working now. Just a heads up.

ROFL, i don't know who made this error, whether it was me or cynix2. What it was meant to do, was removed the old table, then create the new one, instead it went opposite!