View Single Post
  #3  
Old 09-19-2018, 08:32 PM
irongut_av's Avatar
irongut_av
Fire Beetle
 
Join Date: Sep 2018
Posts: 20
Default

I use an event (in HeidiSQL, right click your eqemu database, select Create New->Event). It runs every 4 hours in MySQL, which appends a value onto a bot name if that name exists on the character_data table. This would probably work better as a trigger for the character_data table, but I've got no experience working with those.


Code:
BEGIN
	update bot_data 
		inner join character_data on bot_data.name = character_data.name
		set bot_data.name = CONCAT(bot_data.name, "A");
END
I also had to enable the global event scheduler in MySQL using root:

Code:
SET GLOBAL event_scheduler = ON;

Make sure you set a start time and don't have it expire, so it runs each time period you choose. This isn't a perfect fix, but will rename bots in the DB.
Reply With Quote