Integration Setup

If you have website with existing userbase, you can easily setup your shoutbox to use data from your userbase. With integration, only members logged in at your site can view and use your shoutbox.
Getting started

This section is meant for advanced users only.

To get the integration working, you simply need to pass two parameters via GET request, appended at the end of your shoutbox URL.

Example
...utmix.com/?myshoutmixname&name={name}&code={code}

The variables needed to be passed and their explanations are as follow:

{name}
Member name to be passed onto the shoutbox.
{code}
MD5 value of {name} + {unique code}, to verify that user is coming from your site.
{unique code}
The unique security code for your shoutbox is myuniquecode

An example of how the shoutbox would be called with the name tester:

Example
...com/?myshoutmixname&name=tester&code=32char.md5

... where 32char.md5 is MD5(testermyuniquecode).

After setup, be sure to set your access control to Integrated mode for this to work.

Access Control
PHP Function

If you're using PHP, you can add the following function to your script for quick integration. The function will produce correct parameters to be appended at the end of your shoutbox URL.

function shoutmix($name = '') { return htmlspecialchars( '&name='.rawurlencode($name) .'&code='.md5($name.'myuniquecode')); }

Then alter your shoutbox HTML codes by adding the following codes (after your shoutbox URL):

Example
...mix.com/?myshoutmixname<?=shoutmix($name);?>" width="...

Replace $name with the variable that holds the name of your member, as retrieved from the database.

It has come to our attention that your hosting account, specifically the database is causing the resources to be over-utilized.

We have disabled your database to return the server to normal usage. To re-enable your database, you will need to correct the following query:

SELECT t.*, p.post_time as last_post_time, p.poster_name as
last_poster_name, p.icon, p.post_id, p.uid FROM xoops_bb_topics t LEFT
JOIN xoops_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN
xoops_bb_reads_topic r ON r.read_item = t.topic_id WHERE p.post_time
> 0 AND (r.read_id IS NULL OR r.post_id < t.topic_last_post_id)
AND t.forum_id IN
(1,12,11,21,26,13,2,6,16,15,20,7,25,17,18,35,9,34,5,36,14,8,24,22,10,27)
AND t.approved = 1 AND p.approved = 1 ORDER BY p.post_time DESC LIMIT
0, 35

EXPLAIN:
id| select_type| table| type|
possible_keys| key| key_len| ref| rows|
Extra
1| SIMPLE| t| range|
forum_id,topic_last_post_id,approved| forum_id| 4| |
14007| Using where; Using temporary; Using filesort
1|
SIMPLE| p| eq_ref| PRIMARY,approved,post_time|
PRIMARY| 4| smxoops2.t.topic_last_post_id| 1|
Using where
1| SIMPLE| r| ALL| | |
| | 9038| Using where

This query examines
126595266 rows, which is unacceptable on this server.