View Single Post
  #13  
Old 05-29-2015, 02:41 PM
Nightrider84's Avatar
Nightrider84
Discordant
 
Join Date: Aug 2010
Location: Colorado
Posts: 410
Default

I can confirm that it works now. to save a few minutes of trouble heres the same thing nibiuno posted but made it easier to copy and paste it

You need to edit two tables for bots on the latest RoF2 code.

table botbuffs:
add a column dot_rune after MagicRune as an INT

vwbotcharactermobs:

select _utf8'C'
AS `mobtype`,`c`.`id`
AS `id`,`c`.`name`
AS `name`,`c`.`class`
AS `class`,`c`.`level`
AS `level`,`c`.`last_login`
AS `timelaston`,`c`.`zone_id`
AS `zoneid`
from `character_data` `c`
union all
select _utf8'B'
AS `mobtype`,`b`.`BotID`
AS `id`,`b`.`Name`
AS `name`,`b`.`Class`
AS `class`,`b`.`BotLevel`
AS `level`,0
AS `timelaston`,0
AS `zoneid`
from `bots` `b`

Thanks again nibiuno saved me some time.
Reply With Quote