vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   New Posting Features - vB Spell (https://vborg.vbsupport.ru/showthread.php?t=124578)

badham 09-01-2006 12:32 AM

Quote:

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 09-01-2006 12:34 AM

Quote:

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.

https://vborg.vbsupport.ru/

jw00dy 09-01-2006 07:02 AM

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 09-01-2006 12:35 PM

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:

Quote:

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 09-01-2006 01:23 PM

Quote:

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(30NOT NULLsound varchar(10NOT NULLUNIQUE 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 09-01-2006 02:09 PM

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!

Code:

$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...

Code:

$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 :p

Ollie

Pyrix 09-01-2006 02:18 PM

Quote:

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:

Code:

if ( VB3_INTEGRATION != "on" ) {
and the following after the very last line:

Code:

}
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 09-01-2006 02:18 PM

Quote:

Originally Posted by badham
PHP Code:

CREATE TABLE vbspell (word varchar(30NOT NULLsound varchar(10NOT NULLUNIQUE 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 09-01-2006 02:31 PM

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

Quote:

and then querry in the the alt dictionary both via phpmyadmin

sorry :(

badham 09-01-2006 04:05 PM

Quote:

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


All times are GMT. The time now is 03:53 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01349 seconds
  • Memory Usage 1,760KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (2)bbcode_php_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete