Small problem with Naxxramas spawns.

[frosty901]

I really hate to have to ask this. but, well...Where can i find the Naxx spawns in my database? Lol cant find them in Creatures, or in Creature_template. I'm sure im overlooking something.
Heres why i need to find them...the frenzied, and Plagued Bats in naxx are tamable by hunters. These pets hit for 6k+ DMG and enable the hunters to solo any zone including bosses. This is ridiculous. I just want to edit the levels of these creatures to level 61 to make them untamable.
Hope this finds someone who knows what i'm talking about =)

[MentaL]

[Shozokui]

I need more info. What are you using?
you mentioned that you couldn't find them in creature_template, if it's not there. then it's not in the server. So I suggest looking again, douible checking the name

[frosty901]

mangos revision 3806
SDB 0.5.3 with all changesets up to 16

Yes I was thinking the same thing..if its not there in those 2 tables it shouldnt be in the server. But i see the mobs, they do respawn when killed, and they drop loot. I'm just not able to find any of them in there. I am surely overlooking some detail. I just re-checked my spellings, and this is strange but no entry is there under those names
I tried pla, plag, plagu, plague, plagued...as well as bat.
Also tried every variable of Frenzied.
All i got were other, nonrelated entries. Suppose i could dump the 2 tables to SQL files and you could take a look at them?
I feel really dumb, but damn this is giving me grey hair lol.

All the mobs are in-game just cant find them in the tables.


***EDIT***
OK, solved. I dumped the tables to SQL files to show you...but before i showed you i searched the files themselves..mobs are ALL there. I think this problem was related to Navicat not showing more than 1000 entries. per table.


I suggest everyone modify the levels for Frenzied Bat, and Plagued Bat to be level 61...this is a nasty pet for a player to have.
Ok point and laugh now =) i deserve it.


Btw Navicat > Tools > Options > Table > edit records per page. I use 10,000 per page now. ^^

[Shozokui]

Yeah, you were using a db handler weren't you.... I do it old school lol. Like I said, it has to be in the DB or it absolutely can't be there.

Glad to know that you fixed your problem, and be careful, forum rules state that you aren't supposed to edit your post

[kennythekid]

naxx is spawn in the newest sdb changeset

[frosty901]

Oh, i overlooked that in the Rules. A thousand apologies for editing my posts.
And thank you for pointing this out to me. =)