pet problems how can i fix?

[godofwar]

any ideas on how to fix a problem where i can tame pets, but when i log off the pet is gone when i log back in?

[Airwavez]

ALTER TABLE `playerpets` DROP COLUMN `loyalty`;
ALTER TABLE `playerpets` ADD COLUMN `happiness` int(11) NOT NULL default '0';
ALTER TABLE `playerpets` ADD COLUMN `happinessupdate` int(11) NOT NULL default '0';
ALTER TABLE `playerpets` ADD COLUMN `loyaltypts` int(11) NOT NULL default '0';
ALTER TABLE `playerpets` ADD COLUMN `loyaltyupdate` int(11) NOT NULL default '0';
ALTER TABLE `playerpets` ORDER BY ownerguid, petnumber, name, entryid, data, xp, active, level, happiness, actionbar, happinessupdate, summon, autocastspell, loyaltypts, loyaltyupdate;
UPDATE `playerpets` SET `happiness` = '0';
UPDATE `playerpets` SET `happinessupdate` = '0';
UPDATE `playerpets` SET `loyaltypts` = '0';
UPDATE `playerpets` SET `loyaltyupdate` = '0';

use that Query on your database, it should work.

[slyfox101]

Y'know what Dark, I've seen you around the forums and you seem to know your stuff, and you help people a lot, so I'm just going to give you a free reputation point. I'm extremely bored, and I think you should get one for helping so many people without getting anything in return.

[ScottyBoy]

i too have been having this same issue but i dont understand what it means by the owner guide and so on and so forth so any translation help would be great, thank you for your time.

[Deathdamian]

you know what sky ive noticed that to +rep dark

[Airwavez]

ty all

I really appreciate it

[ScottyBoy]

i need a little more explanation on this part ALTER TABLE `playerpets` ORDER BY ownerguid, petnumber, name, entryid, data, xp, active, level, happiness, actionbar, happinessupdate, summon, autocastspell, loyaltypts, loyaltyupdate;

[slyfox101]

What the...

Who is Sky?

Ontopic: What exactly don't you understand about it...?

To use it: Execute it as a query.

What is it: It's just an update to your database compiled by someone who knows MySQL. MySQL is a coding language, along with MmSQL. Although there are thousands of coding languages. :l2p:

[ScottyBoy]

i dont know what to add in each of the following catagories `playerpets` ownerguid, petnumber, name, entryid, data, xp, active, level, happiness, actionbar, happinessupdate, summon, autocastspell, loyaltypts, loyaltyupdate;

[Airwavez]

Heres what you do:


Open up navicat or w/e you use

Click on your database

now you should see an option that says Query

now click that


then you should find a button that says "New Query"
click it

copy the query code i posted above.

Click run

PRESTO!
your done

[ScottyBoy]

ok sweet thanx

[Airwavez]

no problemo matey

[ScottyBoy]

i tried to do that yet i still cant keep my pet after i log out is there maby something else i need to do?

[Airwavez]

gimme your revision, db, and all that info

[ScottyBoy]

this is my first time making a server, so how would i find and be able to get all of that info for you??