Pets poofing?

[Shiny151]

I run a private Windows EQEmu server with all the latest server files and database; I noticed since my last upgrade that you have to recast your pet when you log in? Was this change intentional or am I missing a setting in my database?

Thanks - Shiny

[Shiny151]

Ahh I figured it out. I needed these tables:


CREATE TABLE `character_pet_info` (
`char_id` int NOT NULL,
`pet` int NOT NULL,
`petname` varchar(64) NOT NULL default '',
`petpower` int NOT NULL default 0,
`spell_id` int NOT NULL default 0,
`hp` int NOT NULL default 0,
`mana` int NOT NULL default 0,
PRIMARY KEY (`char_id`, `pet`)
) ENGINE=InnoDB;

CREATE TABLE `character_pet_buffs` (
`char_id` int NOT NULL,
`pet` int NOT NULL,
`slot` int NOT NULL,
`spell_id` int NOT NULL,
`caster_level` tinyint NOT NULL default 0,
`castername` varchar(64) NOT NULL default '',
`ticsremaining` int NOT NULL default 0,
`counters` int NOT NULL default 0,
`numhits` int NOT NULL default 0,
`rune` int NOT NULL default 0,
PRIMARY KEY (`char_id`, `pet`, `slot`)
) ENGINE=InnoDB;

CREATE TABLE `character_pet_inventory` (
`char_id` int NOT NULL,
`pet` int NOT NULL,
`slot` int NOT NULL,
`item_id` int NOT NULL,
PRIMARY KEY (`char_id`, `pet`, `slot`)
) ENGINE=InnoDB;