Pet bug

[Sandile]

I have a problem on my server. When a hunter captures a pet the hunter lose the pet when on relogg. So... Something like each time the hunter loggs on he needs to catch hes new pet. The old pet can't be summoned or called and its not at the stable master.
Oh.. I got another problem with pets also (both hunter and warlock pets). When you summon them I think they get to the table npc_spawns because they get a spawn location atleast.
+Rep to the one that posts a solution.

[Lukas 45]

Dont know about the bug. But i know it will NOT come in npc_spawn, but in player_pets

[Sandile]

Oh ty. My Playerpets table is empty. Is there like a script or anything I need to do to get this to work?

[Sandile]

Ok I found whats wrong. When some1 captures a pet I see this in my arcemu-world.exe
Sql querry failed due to [columm count doesn't match value count at row 1], Querry : [INSERT INTO playerpets VALUES<'145','1','Firestarter','20038', and then it continiues with different numbers pretty long time.
In my playerpets I can only see 5 rows
Ownerguid, Petnumber, Name, Entry, Fields
So I think I need to change something so it inserts for only 4 fields then. But I dunno how to change things like this. +Rep if you help

[Sandile]

Please, do anyone have a solution to this?

[TheSpidey]

You need to apply a patch to your player pets table. Look for an SQL folder in the SVN of the flavor you're using, and apply patches from there.

[Sandile]

Im a total noob in this. Can you try to explain step by step what to do?
Im using AC-web repack ascent but I changed it to arcemu with Eastonich's guide.
This SVN isn't that like... a folder I created and then I took SVN checkout. Thats my SVN folder right?

[TheSpidey]

Well, since you checked out from the SVN, you should have the SQL folder in there. Just execute the .sql file that's related to playerpets in your mysql server (Using Navicat/SQLyog/HeidiSQL or even the basic sql CLI) and you should be fine.

[Sandile]

Ok I think I found something in a file called
Character_structure

I found this

-- ----------------------------
-- Table structure for 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,
`spellid` int4 UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`ownerguid`,`petnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


should I like... insert that in my Pet thing?

[Sandile]

And how do I insert it? shall I do Dump SQL file?

[Sandile]

And there was also another thing. When a hunter/warlock tame/summon a beast/demon they loses it when they logg out. And the beast/demon gets spawned there. I think they get added to the npc_spawn table.

Im in Desperate need of your help TheSpidey +Rep

[Lukas 45]

NO pets will get in npc_spawn. playerpets is the database to save the pets. And if that fail, it will NOT save the pets!

[Sandile]

Something is verry wrong with mine then. When I relogg with a pet active the pet is a enemy instead of allied.
I think its suposed to be over 100 rows in playerpets. I have like 15.
Can somebody send me the real one so I can insert at my server?

[Sandile]

And How do I change so pets doesn't go to npc_spawns?

[Lukas 45]

Its a thing there need to be changed in the .exe files or .dll