How to add same chat bot to different room

[Roger]

Q: I've many rooms, and I want to add the same chat bot(maybe 60 pieces of message) to about 100 room, how can I make it?

A: First you need use mysql to store your chat data, you can accord another instruction Storing Chat data in MySQL DB (I), then follow my step below:

1. login mysql, use the comand to use database "flashchat":
use flashchat;

2. You can find a table called "room", the chat bot just stores in one column of room, which is "xml_data"
If you need all the new room has the same chat bot as the first one, example the first room is "Default", room_id=1, you may create a new room called "Test", room_id=12.

3. Go back to the command line of mysql, then you'll find you get a new line in room "room_id=12", now you can copy the data in "Default" to this new room, follow the command below:

update room A,(select xml_data as MA from room where room_id=1) B set A.xml_data=B.MA where A.room_id=12;

4. Restart your chat to make it valid.

Now you can login to admin panel, then find the new room "Test" has the same chat bot as room "Default"

[aaronblack]

You mean like adding a spam bot to a chat room that posts messages ??