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)

[badham]

Originally Posted by Erwin

Do you know why the window minimizes straight away when it opens?

Yeah....<a target "vbspell" href=.........in front of the vbspell index command (example)should keep the window on top......My intall with 00.10.2b did not install the database either...and mine was a fresh install.......I had to create the vbspell database and then I loaded the alt dic in the database......works fine as far as the spell check now...........but it the window does minimize...I" am gonna play with the file and see if I can alter that.

badham

[o0Hubba0o]

Originally Posted by AyeCapn

I don't appear to have a spell check button anywhere...

Did you look here? It tends to elude people, I was looking for the button that used to be next to the preview when I first installed it, then did a search of this thread and found out where it is.

[jw00dy]

I had to uninstall this due to it messing up the reply/comments stuff in Photopost Pro. anyone know of a fix? I'd LOVE to use this.

[brvheart]

I installed with no issues.....if I click the spell check buttong while no text is in the box.....it pops up...if I have typed and then press spell check I get the following:

Database error in vBulletin 3.6.0:

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

MySQL Error : Table 'mmaworld.vbspell' doesn't exist
Error Number : 1146
Date : Friday, September 1st 2006 @ 09:25:45 AM
Script : http://www.mmaworld.org/vbspell.php
Referrer : http://www.mmaworld.org/newthread.php?do=newthread&f=18
IP Address :
Username :
Classname : vb_database

[badham]

Originally Posted by brvheart

I installed with no issues.....if I click the spell check buttong while no text is in the box.....it pops up...if I have typed and then press spell check I get the following:

PHP Code:

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


run this qerry and then querry in the the alt dictionary both via phpmyadmin. The problem is that the product does not create the table in alot of cases...if you will not remove anything, just run the create table script via SQL and then querry in the 10 sets of dictionary querries via SQL it will work like a charm

badham

[Pyrix]

For some reason the product's install code drops the vbspell table as soon as it's created it, unless you have a table prefix!

$db->hide_errors();
// 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");

I can only assume the coder was asleep when he wrote it

The product file needs to be editted and reattached here. The above code would work well if it was...

$db->hide_errors();

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

This way the table is cleared, but a new one is created! Previously it would create a new table, then delete it straight away so your dictionary words had nowhere to go?!?!?!?

Bizarre

Ollie

[Pyrix]

Originally Posted by jw00dy

I had to uninstall this due to it messing up the reply/comments stuff in Photopost Pro. anyone know of a fix? I'd LOVE to use this.

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

[brvheart]

Originally Posted by badham

PHP Code:

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


run this qerry and then querry in the the alt dictionary both via phpmyadmin. The problem is that the product does not create the table in alot of cases...if you will not remove anything, just run the create table script via SQL and then querry in the 10 sets of dictionary querries via SQL it will work like a charm

badham

ok thanks....I am sorry for the ignorance on this....but I do not know how to run that query....can I do it via admin panel? Again sorry...this is nothing that I have done before....

[brvheart]

I got the first one...but do not know where or how to do this:

and then querry in the the alt dictionary both via phpmyadmin

sorry

[badham]

Originally Posted by brvheart

ok thanks....I am sorry for the ignorance on this....but I do not know how to run that query....can I do it via admin panel? Again sorry...this is nothing that I have done before....

Yes...go to ADMINCP>>Maintance>run SQL querry You can copy and paste the above code and the run the querry....it will ask you if you are sure...click continue. What you have done is made a table in your database called vbspell....now you can unzip the dictonary alt download. you will find 10 txt notepads...open one, copy it and the paste it in the run sql querry section and click run.....do this one at a time for all 10 and you will be good to go. It is easier if you use phpmyadmin...but since you are not familiar with it....this will work......you can also edit the prdouct file as noted above......but this may be safer in your case.

badham