Hunter bug fixed

[ffdevill]

Ok so this is my first post so cut me a little slack

ok so a lot of emulators have this problem of the pet disappearing when the hunter logs out, and for some reason no one can seem to fix the problem.
well here is a step by step how to fix the problem.

1) copy this coding or if you would prefer you can download the sql file and just use the execute batch function all up to you
petfix.sql

-- ----------------------------
-- Table structure for playerpets
-- ----------------------------
DROP TABLE IF EXISTS `playerpets`;
CREATE TABLE `playerpets` (
`ownerguid` bigint(20) NOT NULL default '0',
`petnumber` int(11) NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`entry` int(10) unsigned NOT NULL default '0',
`fields` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
`xp` int(11) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '0',
`level` int(11) NOT NULL default '0',
`happiness` int(11) NOT NULL default '0',
`actionbar` varchar(200) NOT NULL default '',
`happinessupdate` int(11) NOT NULL default '0',
`summon` int(11) NOT NULL default '0',
`loyaltypts` int(11) NOT NULL,
`loyaltyupdate` int(11) NOT NULL,
`reset_time` int(10) unsigned NOT NULL default '0',
`reset_cost` int(10) NOT NULL default '0',
PRIMARY KEY (`ownerguid`,`petnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for playerpetspells
-- ----------------------------
DROP TABLE IF EXISTS `playerpetspells`;
CREATE TABLE `playerpetspells` (
`ownerguid` bigint(20) NOT NULL default '0',
`petnumber` int(4) NOT NULL default '0',
`spellid` int(4) NOT NULL default '0',
`flags` int(4) NOT NULL default '0',
KEY `a` (`ownerguid`),
KEY `b` (`petnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for playersummonspells
-- ----------------------------
DROP TABLE IF EXISTS `playersummonspells`;
CREATE TABLE `playersummonspells` (
`ownerguid` bigint(20) NOT NULL default '0',
`entryid` int(4) NOT NULL default '0',
`spellid` int(4) NOT NULL default '0',
KEY `a` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2) open up your data base editor

3) go to your database ie. ascent, arcemu, db,ect....

4) find and open new query

5) paste the info from step #1

6) execute query

7) restart your server

all done

hope this is helpfully to the community, any helpfully advice and or positive criticism is welcome 6):

[BrantX]

was going to give you some rep until i was reading

"
show some love [I MUST NEVER ASK FOR REP] thank you

"

that " i must never ask for rep " is a instant changer of the word. i want rep.

[volitle]

rofl at 2d hehe nice fix though cheers

[ffdevill]

I have only been active in this community for 2 weeks, and really appreciate the feedback thank you 6): p.s lol d2 that was great

[Bloodrazer1876]

sorry wrong area

[*Scripted*]

lol i made a new account and got out of leecher in 5 mins ofc releasing a repack and no +Rep for u

[ffdevil]

Like I said, was new, thanks though. All I really wanted was to give back to the community which helped so much. Glad its here. Thanks ALL.

[dinodad]

dffffffffffffffffffffffffff