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"

[tiendunn732]

hi guys is it possible to actually set up and popularise your own chat website or chat messenger and to use yahoo server or google server or aol or jabber or any other messenger service....so tht we cud make money thru ads?....something like meebo...but i dont know if it exactly does tht...