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)

[cynix2]

new version with a ton of product installer updates
upgrading to new versions no longer required you to re import the dictionary

[scdurwood]

Any help on the issue of the pop-up being hidden?

[kylek]

Just uninstalled and re-installed and it is still doing the same thing, pop up window disappears under other windows, and no words are being shown for suggested words.

[Jim O]

Originally Posted by kylek

Just uninstalled and re-installed and it is still doing the same thing, pop up window disappears under other windows, and no words are being shown for suggested words.

I had the same thing happen for the words. Turned out that even though it appeared to install the dictionary 100%, the vbspell table in the db was empty. I used the "alt" dictionary which contains 10 SQL files and inserted the data with phpMyAdmin and it is working. Can't help you with the pop-under problem. It's working as a pop-up in Firefox and IE 6 for me.

[kylek]

Originally Posted by Jim O

I had the same thing happen for the words. Turned out that even though it appeared to install the dictionary 100%, the vbspell table in the db was empty. I used the "alt" dictionary which contains 10 SQL files and inserted the data with phpMyAdmin and it is working. Can't help you with the pop-under problem. It's working as a pop-up in Firefox and IE 6 for me.

Thanks very much Jim O!!

After your post I checked and my vbspell table was empty, imported the files and now works like it should.

Pop up window works in IE 7 beta now, just in Firefox it hides, have to look if there is a setting I am missing in Firefox.

Thanks again.

[Erwin]

Something's wrong with the XML product.

All you need to do to use the default DICTIONARY.DIC way of install is to run this query:

PHP Code:

CREATE TABLE vbspell (word varchar(30) NOT NULL, sound varchar(10) NOT NULL, UNIQUE KEY word (word), KEY sound (sound)); 


Then in the XML product file, delete this bit:

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

and the normal install procedure should work.

Also, the php files should have this changed from:

PHP Code:

<?

to

PHP Code:

<?php

For it to work with PHP 5.x.x.

Also, the popup hides behind other windows for some reason.

Works well otherwise.

[jgommel]

Okay I've fully tested the newest version of vB Spell and confirmed that it does not work with Photopost v5.31 or Reviewpost v3.31. As long as this plugin is enabled, you do not get the message box (like the one I'm typing in right now) I've tested this on both a Mac (Safari and Firefox) and a PC using (IE and Firefox).

With the plugin turned on, it works great on all platforms mentioned above. I really hope this can be fixed so that it works with both Photopost and Reviewpost. I have both of these products installed on two of my websites.
N.E.O.S.M.U.T. Paintball and F/Stopmedia Photography

If the developer needs me to test a build later (if he/she decides to fix this issue), please feel free to contact be via PM. I'm eagerly awaiting a fix. Great Job so far!!!!

Thanks!

[King Kovifor]

Originally Posted by Erwin

Something's wrong with the XML product.

All you need to do to use the default DICTIONARY.DIC way of install is to run this query:

PHP Code:

CREATE TABLE vbspell (word varchar(30) NOT NULL, sound varchar(10) NOT NULL, UNIQUE KEY word (word), KEY sound (sound)); 


Then in the XML product file, delete this bit:



and the normal install procedure should work.

Also, the php files should have this changed from:

PHP Code:

<?

to

PHP Code:

<?php

For it to work with PHP 5.x.x.

Also, the popup hides behind other windows for some reason.

Works well otherwise.

Is that for me?

[mholtum]

Originally Posted by cynix2

the screenshots have a picture of the editor with a spell check button in the top right corner, it's not a submit button anymore

Yea, but when I click it nothing happens..

[Masters]

Fatal error: Maximum execution time of 30 seconds exceeded in \forum\includes\class_core.php on line 354

How do I fix this problem?