phpBB.de

Code: Alles auswählen

3. THE 'db_accounts' FOLDER ****************************************************************

The 'db_accounts' folder contains an installation file that will modify your 
'includes/db.php' file and include a brief check to see if phpBBChatSpot is currently
being used by the user.  If so, then it will include the 'chatspot/chatspot_db.php' file
in your 'chatspot' directory, which allows you to specify different database accounts for
phpBBChatSpot to use (it will randomly select one each time from the list you give it).

The reason for the aforementioned is that some hosts impose a query quota upon their 
clients (say 50 000 queries within a given timespan).  Since chat refreshes by default
every 5 seconds, if there are a few users chatting the number of queries really adds up
quickly.  Although I have tried to make phpBBChatSpot as conservative as possible
with queries, there are still a number of queries involved with managing both a forum
session and a chat session, and of course sending and receiving messages and whatnot.
From what I can tell--at least, it's how my host works--the query quota is imposed upon
an individual database account, and not the database itself (or the client's actual
account).  This means that if you create multiple database accounts and provide them 
access to the same database, they each independently have their own quotas.  Thus, if 
phpBBChatSpot has one or more of its own accounts, even it it exceeds its quota the
forum's quota will remain independent from phpBBChatSpot's, thus the forum will be able
to continue functioning normally.

To install this additional mod you need to first add one or more database accounts to
your forum's database (your host will provide help with this).  Next, modify the
'chatspot_db.php' file in your 'chatspot' directory (it was copied there during the
initial installation) and uncomment a pair of database account lines:

                    $db_accounts[] = ''; // account name
                    $db_accounts[] = ''; // password

and insert the new account name in the first line, and the corresponding password
in the second line.

Finally, either use EasyMod to run the 'phpBBChatSpot_db_accounts.txt' file, or 
perform the instructions on your own.