Problem: The dictionary word list was getting added to my normal phpBB database. That's all fine and well, but I didn't like having an extra 10+ megs of data to back-up every time I did a full phpBB SQL database back-up. (Data that could easily be imported again from the dictionary word-list files, with just a few clicks.)
Solution: I made a separate 'dictionary' SQL database, and used phpSpell in "Native MySQL" mode with phpBB. (Following the somewhat confusing installation instructions, I got it working just fine.)
I added the english word list to the 'dictionary' database just fine, tested it with the spell-check feature in phpBB, all's well and good. I deleted the 'spelling_words' table from my phpBB SQL database, tested the spelling function in phpBB again to make sure it was now reading words from the new 'dictionary' database ... works great!
Conversion to new database is solved, and my original phpBB database is back to its manageable size.
NEW Problem: (somewhat minor, but important)
Realizing that spell_phpBB was originally getting my smilies code list from my original database, I copied over the 'smilies' table from my phpBB database to the new 'dictionary' database. Great, that's solved, but I can't get "spell_MySQL.php" to create the 'smilies" data needed from the new 'dictionary' database.
I've tried editing spell_config.php to include the variables needed being set properly (phpBB's settings to MySQL's settings, and importing the "Create_PHPBB_Smilies" code from the spell_phpbb.php file to spell_MySQL.php file ... but so far, no go. I get various variables or tables, or whatnot not being set properly (reported when I run spell_diags.php).
Is there a simple way to do what I'd like to do?? I'm no programmer, I'm just going on cues and clues from what I see in the existing code.
Summary: I'd like to use a separate database for the word list, but keep the other phpBB specific (i.e. smilies table query) functions intact.
Yes, I realize I could tediously edit that "$Spell_Config['Symbol_Tags'] =" line in my spell_config.php file, but I have over 150 new symbols, and each time I change them I'd have to tediously hand-edit that line. Each time my smilies data changes I'd like to just import the new 'smilies' table from my 'phpBB' database to the new 'dictionary' database. So much simpler.
(Great MOD by the way... THANKS!!!!)