EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Pets poofing? (https://www.eqemulator.org/forums/showthread.php?t=34616)

Shiny151 12-13-2011 11:53 AM
Pets poofing?
 
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 12-21-2011 07:28 PM
Ahh I figured it out. I needed these tables:

Code:
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;


All times are GMT -4. The time now is 09:52 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.