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?
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?
6):WoW Junkie
use that Query on your database, it should work.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';
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.
Since I no longer fear getting banned, judging by what MMOwned has become, I'll start being honest now.
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.
you know what sky ive noticed that to +rep dark
ty all
I really appreciate it
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;
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:
Since I no longer fear getting banned, judging by what MMOwned has become, I'll start being honest now.
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;
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
ok sweet thanx
no problemo matey
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?
gimme your revision, db, and all that info
this is my first time making a server, so how would i find and be able to get all of that info for you??