The changes are sweet! Excellent work!

Guess what... New release.

Today, I ve added support for perl quests. This is a bit hard to configure and requires a little bit of Linux knowledge (should be easier under windows).

For each NPC that has a quest in a zone, you now have a link that points to that quest and allows the visitors to read it. It makes use of a perl parser that is ran when the page for the quest is displayed. The parser is able to do all the EVENT_SAY and EVENT_ITEM part if it's written without the use of plugin:: methods. It's limited to a simple syntax, but is able to understand a good amount of possibilities. Hard to be exhaustive. The parser runs the EVENT_SAY and EVENT_ITEM methods and puts the result in html files. They are displayed by eqbrowser right after.

To be more clear, the parser emulates what the player could do with the NPC and displays the results.

Technically, the result displayed may be surprising. For example, if in the quest perl file you test the second step of the quest before the first one, it will appear in that order in the web page...

There will be improvements soon, like the possibility to display a quest after choosing your class, race and level. Probably some fixes too in the parser...

http://eqemu.vilvert.fr/eqbrowser-0.5.tar.gz


You must give your webserver the rights to read the directory where your quests stand. This may be hard to fix under certain cases, make a copy of your quests somewhere else if it's easier. You can ask for help here or on my private forums (see sig).

Please report bugs and possible improvements.

one of the best tools imo :)
thanks for your work muuss

It's only a browser that uses existing data, nothing to compare in front of the skills and work needed to re-create a full emulator. Thanks anyway :)

Version 0.5.1 is done. If you plan to use quests in eqbrowser, this is an important update.

http://eqemu.vilvert.fr/eqbrowser-0.5.1.tar.gz

*** Quests ***

- Support added for client->GetCharacterFactionLevel. It returns an average value depending of the faction choosen for the quest, if no faction, it returns 99 which is a high indifferent faction.

- I ve added a choice at the top of the quest page that allows people to choose a class, a faction lvl with the npc and the lvl of the character when they display the quest. Try any of the velious quest armor npcs for the faction. Try Cain Darkmoore in West Freeport for the class.
snapshots :
http://eqemu.vilvert.fr/lhranc1.jpg
http://eqemu.vilvert.fr/lhranc2.jpg
http://eqemu.vilvert.fr/cain_darkmoore.jpg

- Spell casted by the npcs are displayed now, like bind affinity for the soulbinders.

- I took a long time to emulate the behaviour of the 2 plugins present in the PEQ quest pack. soulbinder_say and check_handin. Both work.

*** Other ***
- Fixed an issue with bags in zones items list. They were appearing as 1HS instead of bags.
- Inverted x and y in each loc, they match now the locs given by the ingame /loc command.
- Fixed a few spell effects and added duration and full results for dam and healings over time. Fixed attack and movement speeds


That's all for today even for the week. If some stuff is missing or needs to be tweaked, please report it.

Muuss

0.5.2 is out.

A few fixes, and several improvements :

- You can now export a spell list to a csv file, compatible with excel. This is a fast and easy way to create and print spell's list. Spells can be filtered by class, level, or even their name.

- I ve added a Strategy menu, for now, it only contains a script that allows a player to compare his weapons. Calculations are based on Emu's source code and Monkley Business's way of calculating weapon's efficiency. More script will be written later.

- Items that are used or rewarded in quests are added to a table when the quest is parsed. When the item is displayed later, information about the quest are given. (think to source includes/sql/quests.sql to create the table).

Download :
http://eqemu.vilvert.fr/eqbrowser-0.5.2.tar.gz


---- 0.5.2 ----
- Added the possibility to dump spells into a CSV file (txt file, with comma separated columns, can be imported directly into Excel).
- Added a comparator for 2H and dual weilded 1H weapons efficiency.
- Added a link to the zone in the quest page, and added info that specifies that the NPC will return extra items if the player gave him some.
- Fixed the quests for NPCs whose names begin with a sharp (#).
- Added a variable in config.php that permits to hide Invisible Men in bestiaries.
- Added a table that contains a list of items handed or rewarded in the quests (populated when people browse the quests).
- Added quest::ChooseRandom, plugin::try_tome_handins & quest::unique_spawn to quests methods.
- Added spawned NPCs to parsed quests.
- Fixed recognition for (($itemcount{..} && $itemcount{..})==1) syntax.
- Added the chances to have the items droped by NPCs in item's page. (see config.php)
- Added lore name to item's page.
- Added the possibility to search for items thru their focus/worn/proc/clicky effects & mana/hp regeneration & weapon delay.
- Added sort order by class or race in zone bestiaries.
- Added a maximum level for mob droped items in item's search page.
- Fixed Cazic Thule in the Antonica's zones list.
- Item prices are now in points instead of money for the LDON merchants.

Sweet! This has to be my favorite tool that's available! Keep up the awesome work.

Thanks Cave)

Time has come for the next release : 0.5.3.
Download URL : http://eqemu.vilvert.fr/eqbrowser-0.5.3.tar.gz

version 0.5.3
- Added a detailled mob listing for zones, with spawn points, drops, and possibility to dump to CSV file or EQ map files.
- Fixed the url for NPCs snapshots (jpg files in /npcs directory, name is NPC's id).
- Added resist and resist adjustment to spells (ressource spells.sql and rerun import_spells.pl).
- Added support for quest::setnexthpevent, quest::set_zone_flag, quest::gmmove & quest::pause.
- Added support for entity_list->GetMobID(), npc->AddToHateList() & entity->CastToNPC() to quests.
- Fixed quests with no sub EVENT_ITEM {}.
- Added proc damage to the melee damage calculator.
- Added attack speed and average melee damage to NPCs (see config.php). Average melee damage reflects how much brut damages the mob does per round, if not accurate due to mitigation, tank level and avoidance, it permits to compare the mobs between em.
- Added "NPC by faction" in Bestiary's submenu.
- Added Primary faction and details about spells to npc's description.
- Removed the SQL update files for version 0.3 and under. Just source includes/sql/*sql files for a fresh install.
- Added details to items (stackable, fixed price...)
- Added the possibility to ignore certain zones (config.php).
- Added ground spawns support.

I've started to add a few npc pictures to the browser, based on PEQ database (mostly some dragons). Not many obviously.
If someone adds more of them, please post a /npcs directory archive. I can upload it to my own server to make it available for all, if needed.

The link isn't working for me. It downloads 'eqbrowser-0.5.3.tar.tar' so when i extract it theres another .tar file inside it. So it wont extract the second .tar file in there. Am i doing something wrong?

I downloaded it and it opened up just fine using WinRaR.

Looked up WinRaR and downloaded it. Worked perfectly, thank you

Obviously this thread is ancient.... but I just started playing around with this tool and wonder if anyone has it fully functional with the current version of the emu?

Anyone still have this? I'd like to host it to keep it alive in case someone wants to pick it up and work on it... please mail to gernblanATgmailDOTcom if you happen to have a copy of the last version.


Thanks!

Sent to you gernblan. Also from gmail so you should have it already most likely.

Got it! Thanks!

Ok hosted and here it will stay for a long time to come (unless someone updates it of course... if you DO, send it to me and I'll host your changes too!)

http://stash.buttwrenching.com/eqbrowser-0.5.3.tar.gz

I installed this neat tool this morning. Of course I encountered the register_variables quirk, that I fixed by putting the following in the config.php file as I did not want to change my system-wide php.ini :

import_request_variables("gp");

I also had to define the following in my config.php file otherwise I was getting errors :
$IgnoreZones=array();

Anyone else had this problem ?

Anyway, very neat tool. Chapeau Muuss, if you still read that ! And thank you gernblan for hosting it.

Improvements to EQBrowser
 

After discovering EQBrower I made quite a few improvements to it, which I would share with the community if there is interest.

From my understanding this tool is now "orphaned", and may be I could take charge of it for a bit. I tried to contact Muuss at the email mentioned in the README but got no reply. It would be nice to have this open-source.

In a nutshell here are the changes I did the last couple days. I probably broke other stuff doing it :D , but for the time being it suits my need. The most notable changes may be the icons (easy but useful) linking to the PEQ Editor. That way EQBrowser can be used for searching/browsing, and PEQ Editor for changes.

- (Bulle) code cosmetics change (privilege when working on an orphaned project).
- (Bulle) Indentation of the generated HTML code - first shot at XHTML compliance.
- (Bulle) Make the top part of the page (header) optional through a flag in config.php.
- (Bulle) Made "faction.php" and "factions.php" interoperate. If "faction.php" is passed an invalid faction it redirects to "factions.php". If "factions.php" finds one and only one faction it redirects to "faction.php" with the found faction.
- (Bulle) Made "faction.php" more Wiki-friendly : it accepts both an 'id' and 'name' parameter. If the 'id' parameter is non-empty it is used. Otherwise if the 'name' parameter is not empty it is used to query for the faction.
- (Bulle) Same remarks for "npc.php", "npcs.php", "item.php" and "items.php"
- (Bulle) Added icons in factions, NPCs and items to link to a PEQ Editor and Lucy when possible
- (Bulle) Diverted the place where NPC images are searched for. Now it links to a Mediawiki installation (which has to be installed) used to store the images. Allows for much easier image upload as no access to the server filesystem is needed
- (Bulle) Added two "generic" search fields in the menu bar, one for searching on the name, one on the ID. It looks for items, NPCs or factions
- (Bulle) Displayed the IDs of objects in many places, which makes life much easier for the world builder

I would so be interested in that once you get everything squared with Muuss!

Had a problem running 'perl import_spells.pl'

it would error out with 'cat' is not recognized as an internal or external command.... etc

after a little searching i found this:

cat -> perl -MExtUtils::Command -e cat

i replaced
@ids=`cat $spellfile`;
with
@ids=`perl -MExtUtils::Command -e cat $spellfile`;

and it ran fine. Hope it helps!

Bulle, I tried to contact Muuss about a year ago but had no luck.
It was the main reason that I rewote my Alakazam - emulator from scratch.

There was not much interest in it at the time (and I stopped playing with the emulator) so I pulled the software. If people are interested I can repost it (once I have checked it out for bugs).

The code is all open source so people are free to do what ever they like with it.

Comments are always more than welcome.

That smells of a full rewrite then... Not that I am too afraid of it. I am toying with a quest "helper" at the moment so I probably will not start that before a few weeks, but this tool in a web-based form definitely fits in how I plan to edit/browse the database.

The main question at the moment is do I stick to PHP (which I just discovered really = newbie), or do I just switch to Java/Tomcat as I am very familiar with that (like in, I use that everyday...), and the fact that Java is a full-fledged programming language.

I would surely like having a look and a try at what you wrote, ideas and possibly code are always nice to get.

Funny how life is. Right after posting my previous answer I received a response from Muss, that I copy here for those French-reading people out there :D

OK I will translate for the rest (most?) of you :

In short Muuss is fine with making what he has written GPL and opening it for other developers to change, and I thank him for his kindness. It can sure help putting together a solid web-based DB browsing tool.

I will try to make my latest changes available soon, for those who would like to try out some new capabilities. Hopefully this week-end. The "communication" between PEQ Editor and EQBrowser is something I would like to receive feedback on.

I am still interested in the work you did slowglass (was it the Al'Kabor Almanac ?). Combining all this material, there must be a way to do something nice.

Yes it was.

I'll try to have a version available on a web site by the end of Friday together with an example web site

I have not managed to set up a demo database yet but the code is available at http://www.slowglass.com/downloads/alkabor.tar.gz

No worries about the demo setup, I could have it up and running in like 20 minutes on my server (proof it is easy to setup). I had just one problem, which may lead to errors down the line : the tar.gz you provide contains a truncated TAR archive (I get an error when opening it with both 7-Zip and Linux tar command). Hopefully only some icons are missing. If you can upload a "better" TAR I'll gladly re-install it.

The way you show the query results is quite interesting. When I start working again on the browser I will have a look at that. You handle paging the results nicely. Although sometimes what I will like is just a brutal query returning 10.000 items and look into them with Firefox search (when running locally performance is hardly an issue). I guess both modes are useful to have. I also liked how everything regarding one item or NPC could fit into one page in the original EQBrowser (I have a 24 inch screen so I put it to good use). I hate Tabs with a passion ever since Windows introduced tham, and that was a long while ago !

I had an error when viewing a character, I don't know if it is "normal" at the moment.

Definitely a good tool with good ideas, I guess the truth for me is in between EQBrowser and the Almanach. Thank you for sharing it, it will certainly help.

I have updated the zip file.
I have also placed a demo site on the same box at http://www.slowglass.com/alkabor

I have not had time to look into the problem with the inventory page so I have enabled my Magelo clone on the demo site

Hi peeps !

EQBrowser 0.6.0
 

As promised (even if somewhat late, the latest week-ends have been busy) here is my updated version of EQBrowser, featuring quite a few improvements, and potentially a few things I have broken. As I plan to maintain/support this tool for the time being your bug reports/remarks are welcome.

I am still unsure on how to maintain this code, but I am thinking of making a Sourceforge project for it. Let's discuss the idea here.

In the meantime, have fun toying with this quite nice tool.

Link : http://dl.free.fr/jRrH6ILnp/eqbrowser-0.6.0.7z

Been waiting for someone to update this for a while. Since it seems mUUS has given you the goahead? Can we see a new version soon?

Just look above, the link is at the end of my last post.

I can;t edit my post so if a mod can merge this that would be awesome.


Thanks for the update. Few questions, This doesn;t HAVE to be run on the same machine as eqemu does it? I noticed the quests look for the eqemu directory. I have a test eqemu setup On my local machine, and this set up on my hosting, pointed towards the eq database on my local since it seems to require it.


Also Mirror:EQBrowser Mirror 6.0
Will update this mirror when I can

Edit.

So far the only bug I see is Spells, can;t seem to search. says *not found* when I search for clerics Healing

For spells, you have loaded the spells tables in your DB right ? I re-discovered this point in the README when making a fresh installation to try it out.

The quest functionality requires a copy of your quest directory to work. Basically it runs a script that parses the Perl files and populates tables with the result, ready for HTML rendering. Note that I have tried it on my PEQ quests directory (you can run it in "batch" mode) and it stalled on one file so it is probably not up-to-date anymore. And I do not plan to delve into this for the moment (it is quite intricate) so if you would like to fix it you are welcome :)

Awesome I completely forgot to source allspells.

it sucks not being able to edit the posts..

please merge...

When I run the pl after editing the paths inside it.

I look forward to watching this project progress.
I will be keeping my eye out for ideas to steal for the Almanac, that I will try to keep up todate.

I hope that we can both feed off each other and end up with two useful but different solutions.

meh cygwin gayed up on me, isnt installing perl right.

If you run parse-quests.pl to parse each quest 1by1 it works. That as you know is time consuming =/ the sh <-> .bat Progress is lamed up on my end. Kinda wish cygwin had decent perl support.

I was playing around with this for an hour and so far so good, I tested every function I could and nothing seems broken at all ;) The links are a very nice addition. The only things I was sad not to see was a link to the editor for tradeskill combines, and a link to Lucy for the spells. Other than that perfect so far! Thank you.

This is good news. The reason I did not put icons on spells and tradeskill is simple : I did not touch those pages at all, I was mostly concerned with NPCs, factions and items for a reason you will discover soon (I have a tool in the making for quest "configuration"). I can certainly put that on the wish-list for when I look at the other pages.

I wish I could have put links to other sites as well, like Allakhazam (eh), but the item numbers do not match for example (same applies to NPCs etc). Implementing that would require a mapping table, which would be nice to have, but a tad complicated to build even with some kind of robot.

That makes sense, not a big deal really I just felt the tradeskill and spell links would add a bit of completeness. Since spell IDs never change like items do, linking to Lucy wouldn't be a problem. The new tool sounds intriguing... Would it be used to help Allah-ize our quests in eqbrowser?

Allah and Lucy are one in the same, so there really isn't a need to link to Allah for items, since you already have them linked to Lucy. For everything else, oh yeah I thought of that. I once tried to download Allah... 3 days and 12GB later it still wasn't done so I gave up. The site is a massive bird nest of IDs. Linking NPCs and the like would be so difficult it would become impractical, so I wouldn't even worry about it.