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)

[aquariumpros]

Originally Posted by pewp

i did everything the way the directions said... uploaded all the vbspell and dictionary.dic to the forums home directory then installed the product and got this error:


then i uninstalled it and ran the sql query to create the vbspell table, but it still happened... any help?

This version is for vB 3.6.2---

Per your SQL error - you're running vB 3.5.4

Try to install the version for vB 3.5.4 and you might have better luck.

[pewp]

well that's what i thought too, but i read this part of the description...

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.

so i was under the assumption that it would work.

[aquariumpros]

I really don't know - as I was just browsing and saw the vB version at the top of the SQL error.

Did you run the x10 SQL Queries from the ALT file too?

[zetetic]

Sorry if this has been covered, but I've been through this thread and didn't find an answer. I'm getting ready to upgrade from vB 3.0.6 to vB 3.6.2, and I have Tamarian's spellcheck installed on 3.0.6. IIRC, the table in Tamarian's version is called spelling_words. Can I just rename it to vbspell and install this mod, or do I have to do anything else? TIA.

[r5e]

A bit late in my reply here, but thanks Baze22 - your code change works a treat, I now have working popups for the spell checker.

Finally, I can call this mod "working"!

I went back to revist this after leaving it not quite fixed for some time as I was motivated by the latest inbuilt spell checker in firefox 2. There is a problem in the code of vbulletin that prevents the inbuilt firefox spell checker from working, but there is an easy hack here, which apparently will be implemented in the next revision of vbulletin.

So, once everyone kicks their dirty old Internet Explorer habit (or MS catches up and copies more Firefox features into their new version), eventually, we won't need a hack for spell checking.

I like the little red underline I get as I type, which is far more familiar than having to click on a button to do spell checking, so I'll not be using this hack anymore (though my users still will for a while).

[r5e]

Sorry, I spoke too soon.
I use Firefox, but unfortunately most of my users still rely on IE, the lowest common denominator.
Seems that in IE, the window does pop up, but if you try to change a word by clicking in the "change to" box, no selection/typing is possible. I'd guess that some method used to bring focus onto that window interferes with the ability to select anything inside it.
Any other ideas? I might go and see if I can learn about these properties and their behaviour in IE.

[perfphysio]

Originally Posted by christianb

Does everyone having these popunder problems also use the advanced wysiwyg editor - or the standard editor? I've noted a lot of problems with the advanced and therefore don't use it - perhaps this might be a clue to the problem.

I use the advanced and have the problem

[a squared]

For me the problem has been solved. The latest version of FF has a built in spell check. And if you have ieSpell installed in your IE it works flawlessly. I don't see any point in installing the mod anymore there doesn't seem to be any direct support and the dictionaries available from ieSpell and FF are much more vast than what is available here.

[Codeman05]

I keep getting the following error

Database error in vBulletin 3.6.3:

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

MySQL Error : Table 'vb_forum.vbspell' doesn't exist
Error Number : 1146

It was working fine when I was running VB3.6.0, however I upgraded over the weekend and uninstalled and reinstalled the addon.

I'd prefer to use the alternate method since the installer dosen't appear to be adding the vbspell table to the database, however, I do not know how to get it to quit looking at the database.

Any help would be appreciated

[Masters]

freezes on product import at third 90%

Processing: 175395... (90%)
Processing: 175988... (90%)
Processing: 176676... (90%)