Page 1 of 1
Can spellcheck use it own DB

Posted:
Tue May 16, 2006 11:02 pm
Author: 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

Posted:
Wed May 17, 2006 2:45 am
Author: 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
Re: Can spellcheck use it own DB

Posted:
Wed May 17, 2006 11:37 am
Author: 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

Posted:
Wed May 17, 2006 1:56 pm
Author: Adrian Rea
Fantastic, Gold medal (if it holds

)
Nice one lune <img>
A

Posted:
Wed May 17, 2006 3:43 pm
Author: Okki
Sorry to say A, but i already use it like that for almost a year <img>

Posted:
Thu May 18, 2006 1:09 am
Author: 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
Re: Can spellcheck use it own DB

Posted:
Thu May 18, 2006 1:28 am
Author: Okki
Oops did not see that <img> Thanks
Yes, a KB would be nise, maybe i will give it a try?

Posted:
Thu May 18, 2006 5:08 am
Author: Adrian Rea
Good man! <img> Thank you.
A