Welcome to Yserbius.Org! Join our Ultima Online Private Server and have some old school fun.

Wow, it's amazing

Tiger

Active Members
#22
I think I found a stable version, but the Hunters Pets don't work now... Using 3726 with Rev6...

Collecting some code to Try tonight.


Code:
UPDATE `creature_template` SET `ScriptName` = '' WHERE `spell1` = 0 and `spell2` = 0 and `spell3` = 0 and `spell4` = 0 and `ScriptName` = 'generic_creature';
UPDATE `creature_template` SET `ScriptName` = 'generic_creature' WHERE `ScriptName` = '' AND `spell1` > 0 OR `spell2` > 0 OR `spell3` > 0 OR `spell4` > 0;
And maybe...

Code:
DROP TABLE IF EXISTS `character_pet`;
CREATE TABLE `character_pet` (
`id` int(11) unsigned NOT NULL default '0',
`entry` int(11) unsigned NOT NULL default '0',
`owner` int(11) unsigned NOT NULL default '0',
`modelid` int(11) unsigned default '0',
`level` int(11) unsigned NOT NULL default '1',
`exp` int(11) unsigned NOT NULL default '0',
`nextlvlexp` int(11) unsigned NOT NULL default '100',
`spell1` int(11) unsigned NOT NULL default '0',
`spell2` int(11) unsigned NOT NULL default '0',
`spell3` int(11) unsigned NOT NULL default '0',
`spell4` int(11) unsigned NOT NULL default '0',
`action` int(11) unsigned NOT NULL default '0',
`fealty` int(11) unsigned NOT NULL default '0',
`loyalty` int(11) unsigned NOT NULL default '1',
`trainpoint` int(11) unsigned NOT NULL default '0',
`name` varchar(100) default 'Pet',
`renamed` tinyint(1) unsigned NOT NULL default '0',
`slot` int(11) unsigned NOT NULL default '0',
`curhealth` int(11) unsigned NOT NULL default '1',
`curmana` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `owner` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';

--
-- Dumping data for table `character_pet`
--

LOCK TABLES `character_pet` WRITE;
/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
UNLOCK TABLES;
I hope this works or I'm goina be really pissed....
 

Siddhartha

Active Members
#23
I think mine is pretty stable. 3725...I have the pets up and going. I think I even put the sql code aside. I'm not home, I'm in Denver so I can't post it tho.
 

Tiger

Active Members
#25
Thanks Sidd... I've been real busy here, so I havn't had time to mess around with it... Plus, my Navicat time ran out, so I gotta figure something else out... lol
 

Tiger

Active Members
#27
Sidd, do you have a new version of all the files, or can you send me your best working versions of WoW? Going to see if my wife will play with me....
 

Siddhartha

Active Members
#28
I'll try to zip it up real quick and get it somewhere that you can down load it. I haven't updated for quite some time and it has been treating me real good. It's up right now if you want to drop in with your wife. I'll start icq.

you have an account already tiger tiger. I can make another if you let me know what you want.
 

Tiger

Active Members
#30
Thanks Sidd, I still have to install and Patch WoW on both her and I's laptops.... So am not ready to play, but I am pulling this down now, thank you...
 

Siddhartha

Active Members
#31
Good Luck. Y'all are welcome to come on mine if you wish. It's usually me and the kids playing. What I uploaded is for version 2.0.12 Burning Crusades of WoW, not 2.1. I've been happy enough with this so I haven't messed with updating the server so 2.1 can be used. Let me know and I'll get you the ip sometime.
 

Tiger

Active Members
#32
Sure, will do man....

So the Core is 2.1 then? Or was that the Core too? BTW, I downloaded it, thanks!

Still trying to convince the wife.... ;-)
 

Siddhartha

Active Members
#33
No, the core is for 2.0.12 NOT 2.1. I don't know if that mangos version would run 2.1 or not. I got tired of constantly updating so I just got this one working good and have let it be for now. Stop in and bring your wife on mine, that might help convince.
 
Top