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)

[bbcentral]

I just did a test on my 3.6.0 test server, and it failed.
It got to 97%, then:

Fatal error: Maximum execution time of 30 seconds exceeded in MY_SITE_ROOT\forum\admincp\plugin.php(1924) : eval()'d code on line 24

I am trying again using Replicators' version above.
I've imported the product XML, this time it worked.
Importing the SQL files using phpMyAdmin...
Full SQL is too large (I have an 8MB upload limit).
Trying with Split SQL...
I strongly recommend deleting the ZIP files after you import each one.
This way you don't lose track of which one you are up to, and don't get duplicate records.
Part 1 and 2 worked, part 3 isn't working.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO vbspell VALUES ('dacryon', 'TKRYN')' at line 1

Seems to be something to do with importing zip files. I'll import the SQL file instead.
Still doesn't work. I had to resave the file in DOS format for it to import correctly. Seems part 1 and 2 are DOS format SQL files, the rest are UTF-8, and I can't import them unless I resave them in DOS format.
All files imported, vbspell has 192,917 rows of data.
Just made a post, the spellcheck button appears now. It corrected both words I spelt wrong, however when you click the spellcheck button the new window opens as a pop-under. I'm using Firefox on XP.

Apart from that, all working! Thanks to both of you for doing such a great job, now I get to try doing it on my live forum!

[jrofosho]

I get this error when i click the "Check Spelling" icon:

Warning: main(./includes/searchwords.php): failed to open stream: No such file or directory in /vbspell.php on line 40

Fatal error: main(): Failed opening required './includes/searchwords.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/range/public_html/vbspell.php on line 40

[bbcentral]

That's a weird one jrofosho.
I know this is obvious, but does that searchwords.php file definitely exist in the includes folder?
It's part of vBulletin.

[bashy]

Hi

Just installed on 3.6 and install went 100% ok
Using it is different though, Window is behind browser and the window aint right please see image

Any ideas please....

Before anyone says out.....yes, its me, the one with all the hacks installed...
Look he's at it again....lol

[bbcentral]

Bashy, I guess any problems you're having are because of another mod
I've only got a few installed and it works with them. I think you've got some template editing to do :P
wow, I'm stunned! If I tried to install that many hacks, I'd get beaten up by my members

[bashy]

The issue in the image is the portal i use m8....

I would not have a clue how not to get the portal to show up in the popup

Oh well, looks like this aint for me

[cynix2]

Originally Posted by jrofosho

I get this error when i click the "Check Spelling" icon:

Warning: main(./includes/searchwords.php): failed to open stream: No such file or directory in /vbspell.php on line 40

Fatal error: main(): Failed opening required './includes/searchwords.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/range/public_html/vbspell.php on line 40

searchwords.php comes with vB, you might want to re download the vB package from vbulletin.com and then upload the file to the includes folder

Originally Posted by bashy

Hi

Just installed on 3.6 and install went 100% ok
Using it is different though, Window is behind browser and the window aint right please see image

Any ideas please....

Before anyone says out.....yes, its me, the one with all the hacks installed...
Look he's at it again....lol

can you send me the plugins your portal uses?

[cynix2]

Originally Posted by Replicators

I redone the way this mod handles the dictionary. Instead of drawing from the dictionary, it will use sql files instead. This is for only the people that get "Exceeded Max Questions" when importing the product. If it imports fine, DO NOT use this!

There was some changes done to the product file aswell as the vbspell.php, as i took out the use of table prefix and instead use just vbspell as a DB table.

@cynix2 - If i was wrong for doing this, pm me, and i will remove this. It is just another way of doing it, and i did give you full credit for it.

no it's cool, glad you made the changes, i'll include it as a download
the only thing i dont really like is the table prefix being missing, but it's not a big deal

[deegan]

I uploaded both the upload folder, and the dictionary zip, now I am at a loss for what to do next, as I don't see vbspell in my list on vb options?

[cynix2]

first off dont upload the upload folder, open the folder and upload what's inside
secondly dont upload the dictionary zip, unzip it and upload what's inside (assuming you're doing the regular install, if not you'll need to import the sql files)

then import the product file to vB's product manager