Last Emulator Questions

[foamysquirl]

Ok here they are:

1) How do I change the loot that a mob drops?
2) Why does a vendor maintain things that I already removed from them when I restart the server?

Remember, every question that you answer is planting a seed for a future emulator expert

[SectorSeven]

1- creature_loot table
2-Because you have to remove them in your SQL database (vendors table)

Hope that helped

[foamysquirl]

this is wierd... It doesnt show all the vendors I have. I only shows up to the ID 900 or so. I set my custom vendor spawn numbers higher.

[SectorSeven]

No you go into your vendors table not your creature_spawns

[SectorSeven]

No you go into your vendors table not your creature_spawns

[Illidan1]

1 - Go into the Table " Creature_loot " and in there you will need to find the Row of the creature
you wont to add Additional loot to, or add a new row if it is for a Custom Npc.

2 - If you are referring to the Command " .npc vendorremoveitem <ID> " that dose not keep
them Removed from the Vendors Table in Database
You will need to Remove them in the Database via the table " Vendors "
Yet again, find the Creatures Spawn ID in the Rows of Vendor table
If you only see a few change the Filter to a higher amount or take of Filter
If Navicat change Pages, if HeidiSQL search if SQLyog, it sucks don't use it lol
And just add or Delete rows to take away and Add Items to your Npc

[foamysquirl]

Apparently I dont have a Creature_Loot, but a Creatureloot... dont know if this makes a difference, but it might. Also thanks for tellin me that I have to add a new vendor row for custom vendors, woulda never figured that out

[Illidan1]

" Creature_loot " and " Creatureloot " are the Same
I have a Custom Database that i made, so Different Tables

[foamysquirl]

so... I tried pressing ctrl + f to search the rows of the creatures + vendors. Didnt see my custom vendor or even some regular vendors for that matter. Are they sorted according to their display ID or their spawn ID?

[Illidan1]

Ok Ctrl + f don't work for Programs like this

What program are you useing?

HeidiSQL
Navicat
SQLyog

[foamysquirl]

navicat... hehe shoulda metioned that. What do you suggest I do?

[Steph]

Clear your WoW cache, sometimes it causes a problem.

[foamysquirl]

ok here is the situation. I want to edit the stats on the already existing drops in endgame dungeons. I also want to edit the stats on the bosses. I assume this has to be done through my database program, navicat. Please correct me if I'm wrong, or help me out.

[latruwski]

ok here is the situation. I want to edit the stats on the already existing drops in endgame dungeons. I also want to edit the stats on the bosses. I assume this has to be done through my database program, navicat. Please correct me if I'm wrong, or help me out.

in the creatureloot table find the ID of the boss/mob you want to edit the droprate from (entryid = creatureID from creature_names)
and find the itemID you wnt to edit the droprate of (itemID column in creatureloot) and change the droprate in the droprate columns "percentchance" and "heroicpercentchance"
mincount = minimum amount that can drop
maxcount = maximum amount that can drop
If you mean itemstats that you should do in items table...(itemstats like stamina, +crit chance, ...)

The stats of bosses is done in:
creature_names and creature_proto

(you can use ascent database editor for most of this)

grtz