Can spellcheck use it own DB

[a_lunatic]

Was wondering if i can get spell check to use its own DB as it has made the forum DB from 789k to 13.6MB & every time it does back up its gona chew up storage space.

also that way if u have more that 1 forum can they all use the same DB for spell check

thx in advance if any1 can help

[Adrian Rea]

I think this would be an excellent idea to promote, if anyone knows how to do it. I am fairly sure I had discussion about this before with Okki, although we did not get a solution. Especially for sites with multiple languages.

I was also thinking I wonder if a central spellcheck db could be setup for sites of different domains and users. The db access can be tailored to reduce security risk even make it read only, but you would lose the add function.

A

A

[a_lunatic]

well i had had go at it myself mind u i was winging it all the way as i don't know what i am doing with this stuff & manage to get it to work with my live site & test site using the same DB.

anyway this is how i did it

create a DB for it

#-----[ OPEN ]------------------------------
#

....spellingspell_config.php

#
#-----[ FIND ]------------------------------------------

// ----------------------------------------------

// ----- Uncomment which ever line you need -----

// ----------------------------------------------

// $Spell_Config['DB_Type'] = 'PHPBB'; <--- comment this line

// $Spell_Config['DB_Type'] = 'Hivemail';

$Spell_Config['DB_Type'] = 'MySQL'; <---Uncomment this line

// $Spell_Config['DB_Type'] = 'PHPNuke';

// $Spell_Config['DB_Type'] = 'PSPELL';

// $Spell_Config['DB_Type'] = 'Invision';

// $Spell_Config['DB_Type'] = 'vBulletin';

// $Spell_Config['DB_Type'] = 'phpMail';



// ----------------------------------------------

// You only need to change only for Native MySQL

// support! Otherwise you are waisting your time

// as the other built in supported methods

// already sets these up.

// ----------------------------------------------

$Spell_Config["DB_Username"] = " your DB user name";

$Spell_Config["DB_Password"] = "your DB password";

$Spell_Config["DB_Database"] = "name of the DB you created a for it";

$Spell_Config["DB_Host"] = "localhost";

// ----------------------------------------------


Then u just go to the Admin Index, Forum Admin, Spellcheck & install new Dictionary & it should use the new DB if u got everything right

also will have to drop the phpbb_spelling_words from your forum DB or before u change anything Clear Existing Dictionary so its not so big.

if any1 wants to rewrite this in a better way go for it

[Adrian Rea]

Fantastic, Gold medal (if it holds )

Nice one lune <img>

A

[Okki]

Sorry to say A, but i already use it like that for almost a year <img>

[Adrian Rea]

Sorry, as I said earlier it was discussed with you, but I did not realise it was fuly functioning. We can make a KB then and all can know <img>

Thanks

A

[Okki]

Oops did not see that <img> Thanks

Yes, a KB would be nise, maybe i will give it a try?

[Adrian Rea]

Good man! <img> Thank you.


A