Author Topic: Strange issue when moving Bot to new character (Read 2477 times)

Fjordmonkey · « **on:** September 26, 2010, 08:30:33 am »

Have had a very strange issue showing up after moving the bot to a new toon (From Shadowrelay to Crier). For some reason now, most people can only see a very limited set of commands in comparison to what they could when it was hosted as Shadowrelay (sr for short) ). For example, the !online-command, which was available to everyone, now only registers as useable for the admins/superadmins and Owner.

The only thing done to the bot is that it was moved from a toon called Shadowrelay to a toon named Crier in order to make it a little more understandable what it really was. No changes in the database- or bot-access lists has been changed.

Any tips on how to solve this?

Khalem · « **Reply #1 on:** September 26, 2010, 03:26:55 pm »

Your database table names (and all the bots settings, including userlists, access levels etc) are tied closely with the bots character name.
As such most of the tables belonging to the bot will be named botname_tablename. So when you change the name of the bot, without either changing the tablenames in the database to match the new name, or specify a table prefix in the MySQL config file matching the new name; You will in fact be starting with a completely clean slate and the bot will not know any of your old users aside from those hard coded in the bot config file.

Hope this clears things up a bit.

Fjordmonkey · « **Reply #2 on:** September 26, 2010, 10:40:42 pm »

Excellent. That clears things up marvellously, Khalem. Will see if I can change the tablenames without completely throwing a spanner into the works of the database.

Thanks!

Tsamoonia · « **Reply #3 on:** October 27, 2010, 08:29:25 pm »

For the noobs such as myself.. can you tell me exactly how to do this. im just trying to change the name of the bot and i did start with a clean slate. The info is still there if i switch it back to the original name. All i did was change the name in the mysgl.confg and bot.config ... It even had their alt info and everything but the bot had to recognize the players first before sharing info with them. Also things like raid info, autogratz, news or any kind of inputed info gets wiped clean. is there a way to prevent that from happening?

Yite · « **Reply #4 on:** October 28, 2010, 10:40:18 am »

In your conf/MySQL.conf there is the following section:

Code: [Select]

	/*
	Database table prefix
	The bot will use <botname> as prefix on default, you only need to change this entry if you
	want a different prefix or none at all, in which case you have to set it to an empty
	string ("").
	If you want a different or no prefix you will have to uncomment the line below by removing
	the // in front of it and set it to the wished value.
	you may also use <botname> as part of the string and it will be replaces with the botname in lowercase
	*/
	// $table_prefix = "";