Pet bug

[Sandile]

ok. How do I change this?

[Lukas 45]

idk. I dont know how to complicate thing servers

[Sandile]

Ok, does anyone have a idea?

[mindchasm]

The problem I was having was the hunter pets would go free when the hunter logged out. Watching the world executable window gave the database error.

I am running aremu and whydb. I deleted the playerpets table under the logon database and ran the posted sql. I just saved it with a text document and gave it an .sql extension.

I am using navicat for administration and right clicked the logon table and selected execute sql. It will rebuild the table with the required fields missing.


The sql change will also fix the stable master.

[Sandile]

Ty, but its just that. I don't know what all the row's are suposed to be? its over 100 rows and I have no idea what they shall be named.
Could you just like... send me that sql file?

[mindchasm]

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




Just copy this text file into notepad and name it fixplayerpets.sql.

[Sandile]

Yes I have already done that, that didn't work.
There are suposed to be like atleast over 50 rows.

[Sandile]

Oh, and by the way. Is there any way to make so the warlock pets starts with their spells at the begining?
I mean.. I know there is a way but can someone tell me how?

I can show you a picture of my error message if someone can describe how I can insert images.

[Sandile]

I don't got any choice to pick execute sql when I right click the logon table. I used execute batch file and I think that did the same. But its still not working. Can anyone help?
It whould be good if you could tell me in steps. As I am not so good in things like these.

[Sounddead]

You just need to apply the SQL patches that come along with your emulator (As Spidey said)

Take that file you have, delete the table in your Database named 'playerpets' and execute the new one.

[Sandile]

Thats exactly what I did. I deleted my old playerpets table and I executed a new one. This one didn't work either . I havent updated to this shit I compiled tho. So I still have a "non-compiled" arcemu. Because I didn't never move my files. I just followed eastonch guide and Ive had this error all the time. Should I need to upgrade to my compiled patch before I execute this .sql?
And when I take my compiled arcemu then I will lose my old db right? so I will lose all custom stuffs also?