Questnpcs don't work in tutorial or beyond.
 

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.

Looked at your zone logs?

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.

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

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...

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 :)

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.

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.


Tryto 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.

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 :)

affect 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.

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 :)

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

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.

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

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.

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"

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.

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.

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.

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

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

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

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.

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.

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.

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.

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.

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

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

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.

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?

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

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.

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...r-Data-Loading

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

Try running this query and see if it returns anything

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...balDefiant.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.

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.

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

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.

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