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;