Questnpcs don't work in tutorial or beyond.

[Tegila]

Ok after getting server up from the installer, and getting it to enter the world, my one housemate got on almost right away and was fine for a while but then he had an issue with the rat steak combine in tutorial that froze inventory etc so he logged.

After he left server and I tried to open the oven he was using it said someone was using it, but I was only one in the game. I left the zone for a while and when I came back all seemed good again.

Fastfwd a few hours and another housemate started the game. Was able to get 1 hail update in the hail quest in tutorial, but then all quest npcs stopped responding to her. I tried repopping zone, killing them off, forcing respawns etc, still wouldn't work. She relogged, same issue still. Eventually I got them to respond to me once so I thought it was all set.

It wasn't, she still couldn't get a response to either acquire or update any quests. Auto quests like the one gotten zoning to pok 1st time, can be acquired though and the tutorial baking quest that isn't really a quest, works fine with appropriate dialog. No response from quest npc if a quest entry would be acquired or updated.

. Tried zoning her to crescent reach to see if tutorial issue but same deal there. The quest worked for first housemate so not an error from install. My daughter then made an account and started a toon, but she too had same issue so not a bug on toon or account.

I know these quests are working on public emu servers, the one I performed was on peqtgc itself, so I don't think it's the newness of this tutorial and expansion, but it's possible. I should attempt getting NPC responses in fully supported expansions to see if it continues.

Failing that, where should I look to fix this? Could it be related to My problem enabling mercs or populating their merchants? I get error that the columns can't be found to update, but other mods to same tables have run fine.

Unrelated, but what is a usable command to respawns something that's been killed? I tried multiple spawn etc commands to try to repop a mobile barrel but no matter which is number o used I got an unnamed human guy level 1 with no xp or loot on kills. I know can specify every single aspect, but are there not presets to spawn anew for a mob like that? Any mob that always spawns in the given zone. Repopping the zone didnt work in this case probably because they're barrels, but i couldnt find them in any other type like container though they can be /opened as well as meleed. I had to try several commands to get quest npcs to respawns after I killed them trying to fix the issue started thread for, but they may have just respawned on their own regardless of command as it took a few minutes.

I ran into one command that said I wasn't flagged to use, but I was using GM level 250 so not sure why. It was something to reset all scripts and respawn mobs worldwide. Tried it hoping restarting the scripts might fix the npcs but couldnt run it.


Thanks for any help in advance.

[c0ncrete]

Looked at your zone logs?

[phantomghost]

To respawn, I don't think there is one. But you can look up the npc ID and dbspawn it.

As far as quests, you could try redownloading them. Quest files are stored inside the zones folder, maybe they are missing? I never had issues with pre-existing quests like that.

Not sure if there are any gm commands defaulted over 250, but I for some reason always flag myself 255. I have never used mercs, so not sure there.

[GRUMPY]

Quest files are stored inside the zones folder, maybe they are missing?

Quests are in the quests folder in the main eqemu server directory (folder). If you look at the
screenshot of my server folder (eqemu), all the server files are in there. Maps and quests,
plugins, etc., are in their own subfolders. I do my own compiling and manual installs, so I
have the option of naming the main server folder whatever I want, and put it wherever.
But I assume the "auto-installer" puts it in a default setup for all users ?

To enable mercs is quite simple. First, go into rule_values table in database. There is a rule in
there to enable them (set to "true"). Then you have to set all the merc merchant npc's class
to 71. They should work fine after that. Also, is your plugins folder populated ?

Not sure how your server files are all setup, but standard way is similiar to what you see below.

https://image.ibb.co/iMmsEn/server_folder.jpg

[phantomghost]

I thought the quest folder was populated with zone folders where you have the quest plugins?

So, if I want aediles thrall in pok instead of bazaar, I'd copy/paste his plugin from bazaar to poknowledge... And of course create aediles thrall in pok.

Cannot check but I just remember going into each zone I added a quest to specifically...

[GRUMPY]

Sorry phantom, all you said was "Quest files are stored inside the zones folder", but I wasn't reading that as you
intended (I think). You didn't mention the "zone folders" were in the "quests folder" Our lines were crossed, but
I will just drink more coffee :)

[Tegila]

well idk what did it but their quests and npc responses are working again, all i did was go to bed lol. however, and this was a one-time bug, one of my other housemates logged in with 10 inventory slots, played a while, went ot sell somthing in the 9th slot and was told it oculdnt find it, relogged and was back to 8 slots. I have no idea how these changes are even happening i havent done anything to the server itself since we started playing, only things i can do within game with gm commands
oh and im pretty sure i set my gm level to 255 just forgot when i was writing the post, sorryl.

[Uleat]

Don't play with GM on..and only then if you really feel the need to do things as a GM.

The GM flag allows the client to see the 2 additional unsupported slots available in RoF+ clients.

To reiterate, they are not supported and will 'eat' any items you put into them (EDIT) and cause probable inventory sync issues.


Try#repop forceto induce a zone-wide spawn timer reset.


The issue with the world object showing 'in-use' by another player when no one else is around could be a bug and we can look into that.

Report back if that issue comes up again.

[Tegila]

yeah it fixed itself after a while with no one in the zone at least.
good to know that playing as gm flags for 10 bags. i tempflagged the toon in question as a gm so he could #zone back to tutorial (still not sure why we can be in there past lvl 10, or is the cap 20? im in there as lvl 100 gm but..gm... or is there just no level cap in the emu? will have to be sure to use different accounts than my gm one for really playing since i assume turning my gm flag off from inside the game wont fix that bag issue once already in the game, but unless im jsut helping the other guys while they figure out the whole how to play aspect, im mostly on as gm to learn how to mod and/or build various parts of the game.

i managed to get zone to repop that way and some other commands but the npcs werent repopping with some of them, and it wasnt fixing the quest issue. but the quest issue fixed itself overnight for whatever reason. both accts affected had relogged etc and that hadnt worked, and the zone had been repopped (to try to fix if npc issue)

and the oven being in use i still dont know, but that also fixed after zone itself reset. i didnt try a repop force for that issue, but leaving the zone empty for a while im guessing is how it got fixed.

now i jsut have to get the mercs to turn on, find out if my xp mod actually took effect, and start making my todo list for later expacs. still dont know how to force a mob to spawn that is an exact duplicate of mob xyz from gm mode, but im sure ill figure it out in the coding. just not sure how to populate zones outside the game, and know where the mobs are going to spawn just using coordinates lol. learning curve :)

[Uleat]

#gm off
-and-
#gm onaffect the client instantly, regardless of account status.


I don't think #repop affects world objects, only actual npcs.


The level 10 limit is coded into the client enter world/zone processing code.

Some commands actually do check GM flag to bypass some rules, however.

[Tegila]

Quests are in the quests folder in the main eqemu server directory (folder). If you look at the
screenshot of my server folder (eqemu), all the server files are in there. Maps and quests,
plugins, etc., are in their own subfolders. I do my own compiling and manual installs, so I
have the option of naming the main server folder whatever I want, and put it wherever.
But I assume the "auto-installer" puts it in a default setup for all users ?

To enable mercs is quite simple. First, go into rule_values table in database. There is a rule in
there to enable them (set to "true"). Then you have to set all the merc merchant npc's class
to 71. They should work fine after that. Also, is your plugins folder populated ?

Not sure how your server files are all setup, but standard way is similiar to what you see below.


ok i am still having serious issues following anything talkign about the database, becasuse i cant FIND my database anywhere, and if i do a search for rule_values all i get i a 4 line text file that names it under data tables, and a bunch of dated notes and updates to said table...but not the table itself. I have no idea where to really start here, though once i figure that out i can figure the mods out within on my own.

having used the windows installer, i have almost exaclty whats in your ss there, but dont have templates, import or export, templates, update backups or updated templates. im assuming all those things are because i havent done any modding to the server so nothing but the standard has been isntalled.

i have top folder on drive is EQ, then i have EQEmuir(the server) eqemuserver which i made for a backup, Source, and SQL folders. SQL has 9 files, one is text readme the rest sql files.

...Nevermind what I was typing, but im leaving it to explain why i was having trouble... I finally found my database...it was nowhere near where i was looking (in my eq>server etc folders) but is instead under programfiles>mariadb>data>peq and that was my big hangup lol. now all the talk of database makes sooo much more sense :)

[GRUMPY]

There is various tools and/or utilities for managing and editing your server. Some are simply
individual preference, such as the Navicat and tools I use to edit the database, as well as
programs like Notepad++ to edit text files such as configs and quest scripts. There is item
and spell editors, as well as Akka's online EOC which can be tedious for some to get setup.
Gaining all the knowledge for setting up, running and custom editing a server is just like the
grind of progressing a toon, but that "grind" can be more time consuming than playing P99.

Below is a screenshot of how I keep the EQ related shortcuts on my desktop. I like to keep
things setup for easy one-click access, on the fly when I need it. Just my own preference.

Note - this is only 50 percent of my shortcuts organized for the purpose of this example.

https://image.ibb.co/hfmsX7/desktop.jpg

[Tegila]

Thanks grumpy. I've seen a lot of the tools floating around, but a lot I can't even figure out how to setup to see if I like it vs another, and I see a lot about georges tools, but I can't find them lol. EOC I know is pretty comprehensive but what I can tell it's not for Windows, just picking what to get started with is a little daunting at this point, but I wanna get going doing stuff too not take it slow lol. Like, I find most of the changes I want to make are in the same format, and trying to see if a way to get them all together on a machine without and of the software via notepad then just transfer and paste into mysql, that would be great. I'm gonna need something to mass edit mobs in zones, create and populate merchants, and quests/npcs as my aim is to fill out most of the missing stuff. Not the details so much as the big main stuff so it can be played to 100. The detailed stuff would take forever, thus why it's not done yet I know lol, but a lot is already there just needs tweaking or finishing.
I've never been much with coding etc, but with the basics , the rest will fall into place for me.

I don't want to make new stuff really aside a quest/NPC here and there, mostly mod what's there. I need to work on Windows, preferably not on the server directly, and I'd like to be able to do mass updates at once that can be prepped on another machine. What editors do you think would be best to work with for me to start? The attempt at manually building was first and only time I've ever even messed with github so not even familiar with getting stuff from there.

[GRUMPY]

Check out ALL the forums on this page - http://www.eqemulator.org/forums/index.php
You have to scroll down to see them all. One for George's Tools there as well

[Tegila]

yeah i saw the forum for his tools, but i didnt see where to get them in it, jsut talkign about whether it was working or not etc, unless it's not stickied or even on the first page.

the eoc forum was where i kept seeing that you had to run it on linux not windows, but if there is a way to run on windows without a linux vm, i'd be happy to use that just saw no mention of it.

the last post in kayotro forum is 7 years old, description of worldbuilding one says posting databases themselves, the PEQeditor might work for me but idk just how involved it is or isnt..so i will check that one out if i can, and theres a sticky about portable servers that might benefit my offline editing mission, but jsut in the 1 forum (3rd party tools) there are dozens discussed which is a little too many choices to start with...great for later though. Ill definitely be messing with shendares item editor IF i find stuff thats missing form the game, but so far everything ive looked for through the endgame RoF, is there just bags cap at 10slots and augslot21 is missing, so idk what id need to edit for items other than droprates, and i dont think thats part of this editor.

i guess im having same issue as Dremis couple years ago, but idk if he gave up or found his solution lol. at least his thread has goerges tools site linked..just everything's 2yrs old or more and idk how to get versions that work currently, or do these links go to current versions just the site itself hasnt been updated?

lol i guess this is what its like for someone that never played eq or ANY mmorpg before getting plopped in eq today with like a heroic character (lvl 85) and having to figure out the thousands of aa's, hundreds of spells, hundreds of zones, as well as how to just not get killed walking around lol. i'll figure it out, just i can get tied up for hours just investigating one aspect of something so having dozens of somethings to check out and compare...itd take me a month just to pick one to work with to start with lol. should i jsut grab georges tools off the georges tools site, and the peq editor, and figure them out and then move on? or arent they really the most beginner friendly? i konw they are very versatile but versatile often isnt best to learn on.

[GRUMPY]

That forum for George's Tools, it's linked inside one of his own started threads. I actually think it's
in his signature too. I do know it's there, you just have to open threads up and read them, especially
the "stickies"

[Tegila]

Yeah found the link in a thread asking same questions I am, but the sites last update was 2016, so thought it was likely anything on it no longer worked. Maybe the site hasn't updated but the target of the links have, I just don't know without downloading and trying. But I can't download except midnight to 5am, so rather not download til I know they're current.

That forum only has 3 posts from 2018 and 1 from 2017 rest are 2016 and before, so it looks from an outsider like it's more archive than anything.

[GRUMPY]

I use George's tools (last updated in Oct 2016). Works fine for the most part.
I don't use everything in the entire "suite" of tools, but npc editor mostly.

[Tegila]

Ok so it's more on a tool to tool or page to page basis if anything's broken. I just knew columns and things get changed then editor doesn't work til updated this or that, and wasn't sure just how much of that has occurred in that time. Will get it downloaded tonight and go from there. Thank you.

[GRUMPY]

Screenshots from George's Tools. In the second example, I brought up all NPC's in Oasis.
I clicked on Arthikus, then brought up the spawn editor, which indicates he's actually
on an assigned spawn table.
In the 3rd example, I brought up all "fabled" in the database. But when you click on one,
and try to run the name in spawn editor, only to get "No spawns found", means that
npc is not on a spawn table. It would have to be created before setting a timer.

EDIT: Just thought of something important to add. NPC's can also be set to spawn by
a quest script, so they wouldn't be on a spawn table. BUT, there is 127 "Fabled" in the
current database and the quest scripts would be spawning NPC's by their ID, not name.

https://image.ibb.co/eqE54n/G_Tools_1.png

https://image.ibb.co/hYvCjn/G_Tools_2.png

https://image.ibb.co/bzdF4n/G_Tools_3.png

[Tegila]

great thank you grumpy. if that all still works and i can get my db hooked to it right it should be perfect for the simple stuff like spawnrates and whatnot. probably can copy n paste similar npc (liek a merchant) to create a new one(thinking of putting defiants on a merchant rather than messing with loot ttables since they dont seem to drop on my server and after first liek 20 levels where theyre pretty good aside from twink gear, theyre bottomline gear for each level range that youd want to work up from from there so shoudl be easily available, in the content we will be using most at least.

will definitely get that set up tonight so i can see how much i have to otherwise search for ways to do. thank you

[GRUMPY]

You should take a peek through all the menu's when you open up the editor in tool's.
There is even a feature to change the respawn time on all mobs in a specific spawn
group ID in a zone. The loot editor is pretty good, but sometimes can be a little shaky
when using it. When doing loot edits, I use the "save" button a lot, but you can also
use "find item" to search for, and add to a mob when editing that NPC's loot.

Even though the PEQ team is constantly updating the database, I am actually suprised
that some people are looking for defiant on mobs. I remember a while back, the defiant
was dropping everywhere, but for my preferences, I was deleting it all.
Somebody, at one point, had come up with a cleanup tool that presented a menu with
options to get rid of a few undesired things on a mass edit. It was on these forums,
somewhere. I also remember, fabled mobs were popping up all over the place, at one
time, and I had to get rid of them all, for my own preferences, haha

[GRUMPY]

Have you been to this main wiki page ? http://wiki.eqemulator.org/i?M=Wiki
It has tons of info on there ranging from working with AA's, NPC's, quests, etc.

[Tegila]

apparently those were things enough people didnt like so they got shut off by default in the db, or so ti appears. not a single defiant item has dropped on my server so far. fabled idk til i find them in db because I havent really killed in zones that would have them, yet.

[GRUMPY]

Not sure if you seen that link I posted above, it can be very helpful.

Not sure if you're aware, in the quests folder, where all the zone named subfolders
are, there is also a folder called "global". Any NPC script in there, (by it's exact name),
will function for any NPC with that name serverwide. For example, Priest_of_Discord.
That comes in real handy, so you don't have to put a seperate script in each zone
folder for NPC's with the same name. a_rodent would be another example.
Also in that folder is subfolders for items and spells to run something globally.

[Tegila]

hm well i jsut did a search on my peq:items for elaborate defiant and nothing came up at all. ill try crude defiant because it's lower level, but endgame raidgear from RoF is in there, id think elaborate defiant would be.

running defiant breastplate instead so itll return any levels present. all i need is 1 result ot get the item numbers as they should all be consecutive. i dont know if ill put on an npc or put in global loot, whichever is easier actually, but merchant would be better for inventories.

i have been to that wiki page a lot, but usually i end up with more questions lol.

I coudlnt get georges tools to work, but i did get heidisql linked to my server so that is helping, thus how i'm doing the search for defiant. I have no idea using that how to put mobs on a spawn table (for the fableds) but i can fix things like merc timers etc. Was hoping georges would work but the only 1 ocx would register. idk if im putting the ocx on the wrong computer, or the wrong directory on this one, or what. did as admin across the board.

Fix (on ocx) the problem was that i put it in a different partition, thus driveletter, and i could not cd to that in command prompt to register them so i had to move it to my windows partition. i HATE putting things there but its tiny and i have a copy. Now the loot editor opened for me..but it said error connecting first, so idk. maybe its working maybe not lol.

[GRUMPY]

Defiant is all in there. If you use the item search in George's Tools, it will show it all for you.
I know, myself, I have noticed most items right up to HoT are in there, but never looked past
that (yet) I've always been a fan of the LoY era, but I'm working on fully custom project that
won't rely on any particular expansion or era at all.
If you are in-game with GM, just type #fi (or #finditem) itemname. If it's in the database, it
will show up.

[phantomghost]

This is the eq cleanup tool link:

http://www.eqemulator.org/forums/showthread.php?t=40357

Manual deletion. You need to look up defiant types. Then there's other ones without defiant in name that I always forget.

http://www.eqemulator.org/forums/showthread.php?t=38958

http://www.eqemulator.org/forums/showthread.php?t=36932

INNER JOIN lootdrop_entries le ON i.id = le.item_id*
WHERE i.name like "Crude defiant%"


Change the WHERE clause to find the other types and just remove the rows all at once

[Tegila]

Phantom- tryingvto put them back in not remove them. Theyre not dropping whatsoever and the pok vendors for the related items were missing so i decided to put it all on a vendor instead of putting on world drop tables.

Yeah I got it all working with georges tools I just gotta figure out how to apply changes to the server., and learn best tools for best jobs. Found the adept and combatant fear vendors were disabled (I'm guessing via the # before name, or that's just to mark them) but I want to both enable them, add stuff, and duplicate them and make a twin with slight name change with the related armor itself on them. When duplicating it doesn't assign a new merchant number though so that's gotta be remedied, then the name change, and adding of items. I got that all done but don't know how to apply it, and I assume I'll have to adjust spawn locs of the new npcs so they're not inside the old. I did hit save but hotfix and respawning the zone didn't produce any of the vendors disabled or new. Still figuring it all out.

spawngroup, you had it in the ss's already jsut gotta figure out how to add. sorry for questions.

so got the original venders up, but the new ones didnt show. getting there lol. learning curve ha

[GRUMPY]

After running shared_memory, I often found I had to zone out (leave zone empty/reset), before changes
took effect. (or restart server) It's all a pita.

[Uleat]

Crude thru Elegant are in the items table.

Only Crude thru Ornate were set up to be active in loot tables..but, a recent change to loot may have changed that?

[Tegila]

so, im trying to turn back on some merchants and create 2 new ones which started as copies of the 2 disabled ones. i found column spawnlimit was 0 so i set that to 1, i removed teh # at start of their names, and i changed qglobal from 0 to 1 bc the other npcs i KNOW are up have that settings, but im not 100% sure on those. i then hit save loot, because thats the only save or apply button i can find. Did i do that right and i should jsut go restart the server? or did i do it wrong and no point in restarting server yet?

edit: this is in npc editor. the merchant editor still wont show my 2 newly created dudes so idk what i did and didnt actually save at this point

[Tegila]

Crude thru Elegant are in the items table.

Only Crude thru Ornate were set up to be active in loot tables..but, a recent change to loot may have changed that?

its possible no oen saw any yet bc they were too low level for crude+, but i like the idea of putting on merchant isntead of filling bags with duplicate loot. just gotta get the merchants to pop.

[GRUMPY]

This one of the "new" wiki's that's being worked on (I think).
This link shows what's needed to be done after server changes.
https://github.com/EQEmu/Server/wiki/Server-Data-Loading

[Tegila]

got merchants up, my first new one populated inventory just fine. the second one wont even though did exact same thing...however he has more stuff, is there a limit to vender inventory items, and if you go over that will it bug out? hes only showing a cloth cap for sale lol

i need to stop askign new questions in the same thread, but at same time fewer threads. scatterbrain.

yeah im lost lol. got a 3rd new vender ot pop, all his stuff's correct, but i tried to remove his stuff from another and its still there, and remove it from the one thats not showing anything but its still showing in merchant editor and the merchant inventory in game only has cloth cap..i.e. not updating. i dont get why im doing the same thing and its working right for most but not for some. bleh

[Uleat]

Try running this query and see if it returns anythingSELECT * FROM `lootdrop` WHERE `name` LIKE 'GLB-%';

[Uleat]

If you want defiant armor to drop as normal loot, you probably need to run this optional sql script: https://github.com/EQEmu/Server/blob/master/utils/sql/git/optional/2018_02_11_GlobalDefiant.sql


In addition, I have a personal script adapted from that to add 'Accoutrements' as drops - since I don't believe we have those set up just yet.

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50300 AND 50319;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Crude-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Crude-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50300, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50301, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50302, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50303, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50304, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50305, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50306, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50307, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50308, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50309, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50310, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50311, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50312, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50313, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50314, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50315, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50316, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50317, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50318, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50319, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Crude-Accoutrement', loottable_id=@loottable_id, max_level=15;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50320 AND 50339;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Simple-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Simple-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50320, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50321, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50322, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50323, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50324, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50325, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50326, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50327, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50328, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50329, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50330, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50331, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50332, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50333, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50334, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50335, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50336, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50337, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50338, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50339, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Simple-Accoutrement', loottable_id=@loottable_id, min_level=14, max_level=25;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50340 AND 50359;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Rough-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Rough-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50340, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50341, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50342, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50343, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50344, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50345, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50346, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50347, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50348, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50349, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50350, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50351, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50352, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50353, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50354, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50355, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50356, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50357, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50358, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50359, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Rough-Accoutrement', loottable_id=@loottable_id, min_level=24, max_level=36;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50360 AND 50379;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Ornate-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Ornate-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50360, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50361, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50362, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50363, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50364, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50365, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50366, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50367, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50368, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50369, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50370, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50371, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50372, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50373, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50374, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50375, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50376, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50377, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50378, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50379, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Ornate-Accoutrement', loottable_id=@loottable_id, min_level=35, max_level=47;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50380 AND 50399;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Flawed-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Flawed-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50380, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50381, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50382, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50383, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50384, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50385, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50386, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50387, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50388, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50389, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50390, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50391, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50392, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50393, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50394, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50395, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50396, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50397, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50398, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50399, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Flawed-Accoutrement', loottable_id=@loottable_id, enabled=0, min_level=44, max_level=55;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50401 AND 50420;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Intricate-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Intricate-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50401, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50402, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50403, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50404, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50405, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50406, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50407, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50408, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50409, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50410, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50411, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50412, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50413, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50414, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50415, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50416, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50417, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50418, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50419, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50420, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Intricate-Accoutrement', loottable_id=@loottable_id, enabled=0, min_level=54, max_level=65;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50422 AND 50441;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Elaborate-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Elaborate-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50422, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50423, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50424, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50425, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50426, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50427, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50428, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50429, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50430, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50431, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50432, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50433, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50434, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50435, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50436, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50437, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50438, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50439, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50440, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50441, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Elaborate-Accoutrement', loottable_id=@loottable_id, enabled=0, min_level=64, max_level=75;

DELETE FROM lootdrop_entries WHERE item_id BETWEEN 50443 AND 50462;

SELECT @loottable_id := MAX(id) + 1 FROM loottable;
INSERT INTO loottable SET id=@loottable_id, name="GLB-Elegant-Accoutrement", mincash="0", maxcash="0", avgcoin="0";
SELECT @lootdrop_id := MAX(id) + 1 FROM lootdrop;
INSERT INTO lootdrop SET id=@lootdrop_id, name="GLB-Elegant-Accoutrement-Drop";
INSERT INTO loottable_entries SET loottable_id=@loottable_id, lootdrop_id=@lootdrop_id, droplimit='0', mindrop='1', multiplier='1', probability='2';
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50443, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50444, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50445, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50446, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50447, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50448, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50449, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50450, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50451, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50452, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50453, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50454, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50455, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50456, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50457, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50458, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50459, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50460, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50461, equip_item=1, item_charges=1, multiplier=1, chance=1;
INSERT INTO lootdrop_entries SET lootdrop_id=@lootdrop_id, item_id=50462, equip_item=1, item_charges=1, multiplier=1, chance=1;

INSERT INTO global_loot SET description='GLB-Elegant-Accoutrement', loottable_id=@loottable_id, enabled=0, min_level=74, max_level=86;

[Tegila]

Accoutrements. You mean the combatant and adept stuff? I'm using their vendors to get the defiant (and terrorinfused since extravagant armor both sucks and is no trade no price pita) Dont think they ever did drop on live but if gonna have defiant drop why put the accessories on vendors. Should be all 1 or other imo

And thx for the link. I did a million searches looking for how but e everything was how not to lol.

Also, I got vendors to all populate now, just have to zone out, reloadstatic pok, hotfix, zone in, repop force, and all done. Lol, not sure it's ALL necessary but it works without restart. I'll slowly figure this all out and then I'll be glued to it updating the newer zones to jive with live...well live circa rof2, not live now. Modern Nostalgia. Huge change in game since rof2 either bc of daybreak or just too much gear inflation.

[Uleat]

Yeah, that 'Accoutrements' script is definitely non-live like..but, I play solo when I do play and prefer to hunt for that stuffs :)

[Tegila]

i jsut went thorugh and worked this out to adjust the prices of all my defiant etc stuff, im jsut wondering if i did it right (i popped in terror infused for all classes bc extravagant consigned sucks and more things to alter, and the disadvantage to terror infused is it's all/all thus not very wel lspecialized even into archetype, but then i left the extravagant side pieces in and put no weapons, to make it less a gimme) i have the stuff already on merchant but prices were all over the place i saw.

'use peq'

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Defiant%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Defiant%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Defiant%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Defiant%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Defiant%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Defiant%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Defiant%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Defiant%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Terror Infused%';

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Adept%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Adept%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Adept%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Adept%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Adept%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Adept%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Adept%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Adept%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Extravagant Adept%';

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Combatant%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Combatant%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Combatant%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Combatant%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Combatant%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Combatant%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Combatant%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Combatant%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Extravagant Combatant%';

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Summoner%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Summoner%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Summoner%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Summoner%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Summoner%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Summoner%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Summoner%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Summoner%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Extravagant Summoner%';

if that looks right, awesome. if not ill see if i can modify what you put up. i didnt read through it, i found another thread detailing putting up new merchants without an editor. but, this being first code im putting together with just the pieces, not substitution from a copy n paste job, and it affects a lot of stuff, id like a second opinion before i put it through to the db

edit: looking at that and the stats i think ill lower the extravagant stuff some, its nowhere near the stats of terror of course. i mostly tripled and rounded up to next round 5 somethign number after the first 3 tiers, i thought tripling 7 to 21 was both a little steep (at the early part of that gear) and messy for my end pricing goals lol edit2: yeah went up on the terror to 20k and down on extravagant to 10k, thats still steep for the extravagant, but this isnt a server where everyone is giving it away, and i think im going to remove it all from teh drop table, so that its not a luck thing to get, but a work thing (farm the plat on a mostly empty server) for the level etc.

that means i need to use the script linked before to remove what defiants might be active in loottables too now, or would i jsut do somethign like

DELETE * FROM `lootdrop` WHERE `name` LIKE 'GLB-%';

being that the items are still on teh items table of course, would that work? or wrong wording?

Edit PRICE not cost lol

[Tegila]

along those same lines and joining with the fabled discussion elsewehre, would this work for enabling the fableds taht at least have loottables and are spawned normally and setting their spawnrate to 3% (for yearround availability)?


UPDATE spawn2 SET enabled = 1 WHERE npc_types.name LIKE '%Fabled%';
UPDATE spawnentry SET chance = 3 WHERE npc_types.name LIKE '%Fabled%' AND spawngroupid > 1;

[GRUMPY]

What you're looking at doing is not that simple. It's not just a matter of "enabling" the fabled mobs,
first they have to be added to the spawn tables. All those NPC's you see in the npc_types table,
they exist in the database, but in the case of some, like "fabled", they need to be added to
the spawn table BEFORE you can set the enabled value.(and other values within the spawn tables
that you created. There is mass queries that can be made to do the job, but every NPC in that
database has it's own unique npcID (number), so writing that whole query would take some time to
include ALL npc's with the name "fabled" and their assigned npcID.

[Tegila]

What you're looking at doing is not that simple. It's not just a matter of "enabling" the fabled mobs,
first they have to be added to the spawn tables. All those NPC's you see in the npc_types table,
they exist in the database, but in the case of some, like "fabled", they need to be added to
the spawn table BEFORE you can set the enabled value.(and other values within the spawn tables
that you created. There is mass queries that can be made to do the job, but every NPC in that
database has it's own unique npcID (number), so writing that whole query would take some time to
include ALL npc's with the name "fabled" and their assigned npcID.

thats why i was just turning on the ones that were in spawn2 in the first place and assuming if they dont get turned on they have no loottable or are scripted, though some in spawn2 have no loottable anyway im seeing, but not many.


im going through manually atm and writing down the ids of all the ones that actually have fabled loot on them, not jsut loottables (many have no fabled items in their loottables) but that'll be a lot more lines to enable, though prevents fabled mobs with no fabled loot lol.

im not expecting to run the "enabled = 1" line and every fabled in the database magically has a loottable and is fully populated in the spawn tables, i was just looking to turn on the ones that are already in the spawn tables. And I have....the most worthwhile group/solo-able ones (big raid ones are not completed or really even relevant to me atm) are present, like all the swarm-pet weapons and whatnot. might be 1 or 2 missing, i gotta dig into that but they appear to be all there.

a lot of the others i'm going to have to populate their loottables with their actual fabled items before i even bother

i am seeing the AND spawngroupid > 1 is completely pointless, but i didnt watn to jsut assume in that case. i know to be in spawn2 they must have a spawngroupid, but i wasnt sure when i wrote that if the qualifier was needed for spawnentry. however, the line to set their spawnrate is definitely not going to work without then subtracting 3 from its nonfabled version or some junk mob which would have to be in same line i would think because Math, but how to take a value in the table and add three... * + 3 ?. i may just want to do that one by hand. do a SELECT to pull up similar to that script, then with the npcid's alter 1 by 1. i may just leave the spawn chance alone for those with spawn groups, unless i find theyre too high.

So if wanting to write that it would be

UPDATE spawnentry SET chance = * - 3 WHERE npc_types.name NOT LIKE '%Fabled%';
UPDATE spawnentry SET chance = 3 WHERE npc_types.name LIKE '%Fabled%';


being that the subtraction has to be before the addition, if it even matters, if that syntax would even remotely work ( would it be '* - 3' or `* - 3` or..i have no idea, and having it find a mob with same name as the fabled but without the_fabled...i dont think that can be done without some serious convolutedness. so, i could jsut run the second line there after subtracting 3 from nonfableds but thats kinda pointless. I could just do a query for the spawnentries then find the next rarest spawn and go from there, but al lthat is just silly. most if not all the fableds that DO have spawns set up, are already set at 5. that's good enough for me, but i can edit those easier in goerges if need be. but i do need to create all the rest of them, and put the right loot on the ones that dont even have loot and THEN their spawns, and finally add all the oens that arent even in teh db - thats the seriously tedium lol.

[c0ncrete]

It's probably best if you work out a way to do it programatically and to log your changes so you can easily revert with granular control. I'm slowly putting together something for similar reasons myself. I'll be looking for any item not currently obtainable via drops, tradeskills, quests, etc and will be giving them a small chance at dropping globally via script instead of global loot tables.

use Modern::Perl;

# custom modules
use EQEmu::Database;
use EQEmu::Util 'debug';
no warnings 'EQEmu::Database::empty';
my $dbh = EQEmu::Database->new;

# logging
use FileHandle;
my $log = FileHandle->new("> test_SQL.out");
$log->autoflush(1);

# variables
my $sql = ''; # for queries
my $res = (); # for results

# get all item ids and names
$sql = 'SELECT id, Name FROM items';
my $all_items = {
map {
$_->{id},
$_->{Name}
} @{$dbh->Query($sql)}
};

while (my ($itemID, $itemName) = each $all_items) {

# look for lootdrop entries for current item
$sql = "SELECT lootdrop_id FROM lootdrop_entries WHERE lootdrop_entries.item_id = $itemID";
$res = $dbh->Query($sql);

# no lootdrop entry found
unless ($res) {
say $log "INFO: no lootdrop entry found for $itemID [ $itemName ]";
# TODO: check tradeskill yields (parse output from another query)
# TODO: check quest rewards (parse scripts for summoning of itemID)
next;
}

# lootdrop entry found
say $log "INFO: ".@$res." lootdrop entries found for $itemID [ $itemName ]";
# TODO: validate lootdrop entry
# TODO: validate loottable entry
# TODO: validate spawn, etc
}

[Tegila]

is there some modifier to merchant prices that's like 20x? been looking but cant find, however my 2pp stuff is 41+ pp and the 20k stuff has more digits than it can handle and goes negative lol
i know faction and charisma..but not 20x the price.

the merchant price update worked great otherwise. but 2000cp is not 41pp in any way shape or form


I am building the spawntables for those with actual fabled loot already there, 1 at a time but it's quick the way i have my list set up. the stuff that alreayd had spawntables i activated and got 1/3 of the rest already done. but thats still only about half of what's in the database, and thats about 1/3 of what's on Live so.. 1 step at a time. half the fableds in this list ive never even heard of, but im not oldschool eq, i started during TBS

[GRUMPY]

is there some modifier to merchant prices

Tegila - did you not see my reply to this post here ??

http://www.eqemulator.org/forums/showthread.php?p=258086#post258086

You're all over these boards with questions, you might want keep track of your posts.

[Tegila]

no i hadnt seen that particular response when i made that post. i'd figured out how to mass change the first line, then i found the modifier later and fixed without coming back here, just took a loooot of squinting lol.

i had been checking all the diff threads (also why i dont like starting new for each question) but id missed that one when i asked here. but i hadnt really asked for code there either, but a way to use tools like georges or shendares to do mass changes, so i didnt think it'd be relevant codewise and didnt look.