|
|
|
 |
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
|
| Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself. |

05-13-2015, 09:47 AM
|
|
Fire Beetle
|
|
Join Date: May 2005
Posts: 9
|
|
I have a simple-minded question here. With the vwbotcharactermobs view listed at top, would you add it to my own database like this?
Code:
CREATE VIEW '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`
)
|
 |
|
 |

05-13-2015, 10:15 AM
|
|
Fire Beetle
|
|
Join Date: May 2005
Posts: 9
|
|
I found out where to add the view using HeidiSQL and inserted the view. I am able to summon a bot now, but this is the error I get now once it's spawned:
Code:
[MySQL Error] 1054: Unknown column 'caston_x' in 'field list
--Select spelld, CasterLevel, DurationForumla, TicRemaining, PoisonCounters,
DiseaseCounters, CurseCounters, CorruptionCounters, HitCount, MeleeRune, Dot_Rune, caston_x, Persistent, caston_y, caston_z, ExtraDiChance FROM
botbuffs WHERE botId = 1
[MySQL Error] 1054: Unknown Column 'caston_x' in 'field_list
--INSERT INTO botbuffs (BotId, SpellId, CasterLevel, DurationForumla, TicsRemaining,
PoisonCounters, DiseaseCounters, CurseCounters, CorruptionCounters, HitCount,
MeleeRune, MagicRune, Dot_Rune, caston_x, Persistent, caston_y, caston_z,
ExtraDiChance) VALUES (1,756,2,11,0,0,0,0,0,0,0,0,0,0,0,0,0);
I am able to invite the bot into my group, but when I try to send it to attack using #Bot Group Attack, it'll run up to the mob and then just run back.
|
 |
|
 |
| Thread Tools |
|
|
| Display Modes |
Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 11:36 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |