i tried the levels where the mage goes from zero then one then two then three then four and then five available pets. they all worked fine for me. It might be you found a bug in the sql that i'll have to look for past level 30 (where they get their fifth pet).

I also tried air five times in a row, got water every single time.

must be a spell out of alignment somewhere after level 30. i'll find it

Originally where I had deleted the 58-63 monster, earth and fire pets.....that has now been replaced when I sourced in that SQL so that should not be a factor correct ?

It could be on my part, a really stupid thing on my part. I will report back in 10 minutes. I would not worry about it till then.

Okay now that my retarded moment is out of the way. I blame it on lack of caffeine.

Monster = perfect
Earth = perfect
air = fire
fire = water
water = air

This is after the latest svn and sourcing the npc spells back in. I tried each pet 4 times to be sure.

Do no ask what I was doing before, it was a blond moment.

Inquiring minds want to know! :D

Okay fine.

While messing with the instance database earlier in the week I copied my EqEmulator virtual machine within ESXi to another copy, ran that copy with a different IP address, you know for test. My Heidi was still connected to that database, I did not notice since the address was just one number off. So essentially every SQL update I ran for the past 30 minutes was on that test database.

I've had times like that... "dammit, why is it still saying I haven't made those changes I just did..."

About the worst thing I did was one time doing a disk to disk backup and did the minor mistake of copying the backup on top of the original... right after having wiped clean the backup. :shock: I was proud of myself that day, I'll tell ya! ;)

I have always been overly cautious of copying backups or clients backups. I think it is part of my OCPD personality. I remember back when I used to do people upgrades using laplink. With laplink 3 you basically had the source on one side, the destination on the other. It was not overly obvious which was which. One of the guys I worked with copied a machine the wrong way, the big deal was it was an accountants laptop. You know one the the suitcase sized Compaq laptops, the kind where the keyboard snapped into the side of it. Well that just proved to me it was easy to do and working with someone else's data is begging lawsuit when you screw it up. I am vigilant on backups now, even my EqEmulator virtual machine gets a complete backup 7 days a week and another archive in a different place in case that machine catches fire or something crazy. I am not talking about the directory but the entire virtual machine.

Yeah, I have nightly backups for my servers as well. And I also work with customer's data so I am also very careful. The one time I did that, it was with my own data after entirely too little sleep, and it was a long time ago (> 20 years). Experience is what causes one to double and triple check things before letting it fly...

Yeah but you try to tell these young whippersnappers that.

ok, i think i've got it working correctly now. you'll need svn r591 and my latest Bot Spell Lists sourced in.