EQEmulator Forums - Eq Browser : Allakhazam Clone

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=593)

- - Eq Browser : Allakhazam Clone (https://www.eqemulator.org/forums/showthread.php?t=16772)

To put it short, despite me hating writing Perl for its syntax I am very quest-oriented. The fact is that the full power of Perl is rarely needed and I wanted to "specify" quests more visually and more concisely, at least for the 90% of the quests that do not really require complex processing (fetch, go talk to a guy, deliver an item, this sort of thing). As you can certainly understand, it is not meant to replace Perl as the "assembly" language of quests, but provide a simpler of writing basic quests.

I settled on the idea of writing quests as Wiki pages, with paragraphs for quest chapters, and visual clues about what you do (hand-in items, receive XP etc). Once the quest is written using pre-defined Macros (Templates) you fire up a parser that reads all that (Mediawiki export) and generates the Perl code. You are limited to the primitives provided but it is enough to write quite a few things.

I have completed the first draft of the parser and I will start a new thread about it soon. I just need to complete re-installing the EQEmu servers on my Linux box (sorting my mess if you prefer) and test it on a proper environment. The parser is written in Java for perfo^H^H^H^H^H ease of writing/debugging/prototyping :wink:

woul dit be possible to add a character/account management system to it? I added a minilogin reg script. and Cavedudes sexy char mover to it. I'd like to see something where users can login to it, maybe change things about their toons/options as well as a forum login/system or integration with ipb/vb

all in al VERY nice update bulle.

It is probably a question of point of view, but I would be happy to keep EQBrowser a "read-only" tool, at least regarding to the regular EQEmu DB tables used by the game. And if additional tables created just for the purpose of the browser get corrupted and have/can be reloaded without any harm , so much the better. In fact I run EQBrowser with a special MySQL user that has read-only access to all my EQEmu databases (I do not use the quest thingy at the moment).

I think it is very much possible to keep EQBrowser faithful to its name, a browser. We can complicate it as much as needed to handle more specific "requests", but keep it a browser and a portal to other places (PEQ Editor, Lucy, whatever else). The EQEmu database Google in a way.

Thanks to the Web philosophy, you can have a tool dedicated to searching and other tool(s) for doing more involved tasks. This is the reason I linked NPC pages to their Edit counterpart in PEQ Editor : use the power of the web, and delegate to much-better written, to the point tools. It is the opposite of monolithic applications and the reason that I like web apps, and that I dislike Web 2.0 in a way : because you tend to lose the power of the "link" in Web 2.0. You get one URL for your home page and that's it.

To answer your post now, having EQBrowser display info about players, their inventory etc why not. Having it display a player list or a list of characters who have so-and-so items, and forward you to a Magelo clone, even better. Having another icon send you to an Edit page on the web app you are going to write and passing it the character/PC info (ID), sure.

Just a sound sharing of responsibility : you take care of the editing, EQBrowser takes care of the searching, and we know how to interface both (and the many new unsuspected other apps people can write) cleanly. That way you can be the master of your hill, and share it with the others through well-known, SECURE, interfaces.

If I could give an advice to web developers around here, it would be : provide as much functionality as you can through direct links (with parameters). Think of each of your application pages as a whole, that can be accessed individually and provides a clear service. Avoid forcing people to "click-click" through many wizard-like pages to do what they want. It is good for advert-sponsored pages, but not for charitable utilities. This is the spirit of the web after all, how it started at least.

First bug I found : due to a typo in a variable name several fields are ignored by the Item search (Class, Race...). I have fixed it, will be in next version.

I definitely broke some stuff ;)

I can't wait to test that new version ! :)

For those using EQBrowser, if you want to make it publicly usable for your DB you might want to setup a special user for it. The reason is that EQBrowser in its current state is almost certainly susceptible to script injection (nothing coming from the client is escaped properly). Until this can be fixed in the PHP you can make sure EQBrowser can only have read-access to your tables, and that it is prevented access to a couple sensitive fields (password, ls_account and minilogin_ip in the account table).

Here is how I have defined my eqemuview user. You will want to replace the user-name, password and database name (here peqref) by your own :

Code:

create user 'eqemuview'@'%' identified by 'ZZZ';



grant select on peqref.aa_actions to 'eqemuview'@'%';

grant select on peqref.aa_effects to 'eqemuview'@'%';

grant select on peqref.aa_timers to 'eqemuview'@'%';

grant select on peqref.altadv_vars to 'eqemuview'@'%';

grant select on peqref.books to 'eqemuview'@'%';

grant select on peqref.botinventory to 'eqemuview'@'%';

grant select on peqref.botleader to 'eqemuview'@'%';

grant select on peqref.botsowners to 'eqemuview'@'%';

grant select on peqref.character_ to 'eqemuview'@'%';

grant select on peqref.character_backup to 'eqemuview'@'%';

grant select on peqref.class_skill to 'eqemuview'@'%';

grant select on peqref.commands to 'eqemuview'@'%';

grant select on peqref.doors to 'eqemuview'@'%';

grant select on peqref.eqbnews to 'eqemuview'@'%';

grant select on peqref.eventlog to 'eqemuview'@'%';

grant select on peqref.faction_list to 'eqemuview'@'%';

grant select on peqref.faction_values to 'eqemuview'@'%';

grant select on peqref.fear_hints to 'eqemuview'@'%';

grant select on peqref.fishing to 'eqemuview'@'%';

grant select on peqref.forage to 'eqemuview'@'%';

grant select on peqref.graveyard to 'eqemuview'@'%';

grant select on peqref.grid to 'eqemuview'@'%';

grant select on peqref.grid_entries to 'eqemuview'@'%';

grant select on peqref.ground_spawns to 'eqemuview'@'%';

grant select on peqref.guild_members to 'eqemuview'@'%';

grant select on peqref.guild_ranks to 'eqemuview'@'%';

grant select on peqref.guild_relations to 'eqemuview'@'%';

grant select on peqref.guilds to 'eqemuview'@'%';

grant select on peqref.hackers to 'eqemuview'@'%';

grant select on peqref.inventory to 'eqemuview'@'%';

grant select on peqref.items to 'eqemuview'@'%';

grant select on peqref.launcher to 'eqemuview'@'%';

grant select on peqref.launcher_zones to 'eqemuview'@'%';

grant select on peqref.lootdrop to 'eqemuview'@'%';

grant select on peqref.lootdrop_entries to 'eqemuview'@'%';

grant select on peqref.loottable to 'eqemuview'@'%';

grant select on peqref.loottable_entries to 'eqemuview'@'%';

grant select on peqref.merchantlist to 'eqemuview'@'%';

grant select on peqref.merchantlist_temp to 'eqemuview'@'%';

grant select on peqref.name_filter to 'eqemuview'@'%';

grant select on peqref.npc_faction to 'eqemuview'@'%';

grant select on peqref.npc_faction_entries to 'eqemuview'@'%';

grant select on peqref.npc_spells to 'eqemuview'@'%';

grant select on peqref.npc_spells_entries to 'eqemuview'@'%';

grant select on peqref.npc_types to 'eqemuview'@'%';

grant select on peqref.npc_types_metadata to 'eqemuview'@'%';

grant select on peqref.object to 'eqemuview'@'%';

grant select on peqref.object_contents to 'eqemuview'@'%';

grant select on peqref.peq_admin to 'eqemuview'@'%';

grant select on peqref.petitions to 'eqemuview'@'%';

grant select on peqref.pets to 'eqemuview'@'%';

grant select on peqref.player_corpses to 'eqemuview'@'%';

grant select on peqref.player_corpses_backup to 'eqemuview'@'%';

grant select on peqref.quest_globals to 'eqemuview'@'%';

grant select on peqref.races to 'eqemuview'@'%';

grant select on peqref.rule_sets to 'eqemuview'@'%';

grant select on peqref.rule_values to 'eqemuview'@'%';

grant select on peqref.sharedbank to 'eqemuview'@'%';

grant select on peqref.skill_caps to 'eqemuview'@'%';

grant select on peqref.spawn2 to 'eqemuview'@'%';

grant select on peqref.spawn_conditions to 'eqemuview'@'%';

grant select on peqref.spawn_events to 'eqemuview'@'%';

grant select on peqref.spawnentry to 'eqemuview'@'%';

grant select on peqref.spawngroup to 'eqemuview'@'%';

grant select on peqref.spells to 'eqemuview'@'%';

grant select on peqref.start_zones to 'eqemuview'@'%';

grant select on peqref.starting_items to 'eqemuview'@'%';

grant select on peqref.timers to 'eqemuview'@'%';

grant select on peqref.tradeskill_recipe to 'eqemuview'@'%';

grant select on peqref.tradeskill_recipe_entries to 'eqemuview'@'%';

grant select on peqref.traps to 'eqemuview'@'%';

grant select on peqref.tribute_levels to 'eqemuview'@'%';

grant select on peqref.tributes to 'eqemuview'@'%';

grant select on peqref.variables to 'eqemuview'@'%';

grant select on peqref.warehouse to 'eqemuview'@'%';

grant select on peqref.zone to 'eqemuview'@'%';

grant select on peqref.zone_flags to 'eqemuview'@'%';

grant select on peqref.zone_points to 'eqemuview'@'%';

grant select on peqref.zone_server to 'eqemuview'@'%';

grant select on peqref.zone_state_dump to 'eqemuview'@'%';

grant select on peqref.zoneserver_auth to 'eqemuview'@'%';

grant select (id, name, charname, sharedplat, status, gmspeed, revoked, hideme, rulesflag) on peqref.account to 'eqemuview'@'%';

That's a lot of grants, but to prevent access to a part of the account table you have to grant the privileges on a table per table basis. This is how SQL works.

The Downloads Dont work.. Wtf.... Please send me a PM on here. and if you could send me a Instant message over Windows Live Messenger.. Im always on there..

~bdrumm~

in quests/quest.pm, change sub ChooseRandom to :

Code:

sub ChooseRandom {

  my $item=0;

  foreach $item (@_) { main::add_received($item); }

  return $_[int(rand($#_)+1)];

}

This will add all the items returned by ChooseRandom to the database.

Not to complain or anything :grin:, but the links to the latest EQbrowser lead to a French website which I do not understand at all. From what I can tell it is an antivirus site? lol. Anyway I've clicked all over and filled out forms hoping the next page would be to the actual download but I'm not seeing it. Is there a direct link somewhere that will automatically start the download when I click the link?

I loved the previous versions of the EQ browser very much and, recently returning to the boards here I'm stoked to find out about all of the recent updates!

Thanks,
Koshoji

Yes, very interesting looking. If needed I can host the files on my website (no ads or popups or anything!).

Here is google translation of the site.

http://translate.google.com/translat...-8&sl=fr&tl=en

Link is right on top right.

Excellent! Thanks very much bayk :)

Just thought I would comment that it works perfectly with the current build of eqemu on the CVS. I installed it a sec ago with a db backup from our server if you wanna check out what it can do and how it looks. I have not set this up at all besides the basics but it does work fine.

Shows all zones, NPC, what they drop, factions, stats, everything. I like it.

http://baneoflife.com/banebrowser/

Not able to edit my post anymore, sorry for double posting :( I put it on our web server for anyone wanting the file. I will leave it there for as long as the site is up.

http://www.baneoflife.com/emufiles/eqb.rar

I've been using this for a few months and have made some changes to suit me, but there are a few things that don't work properly. Unfortunately, I don't quite remember what exactly. Of course I also might not have been working with the latest version when I downloaded it too. It's a VERY useful tool though, and I have enjoyed messing around with it. I had to tweak the item search page and had to add a max level field but most of it was just to make me happy, not really a functionality issue. There are a couple dozen quests that the quest parser doesn't like though so if you want to use the quest portion of it you'll likely have to tweak them.

I havent messed with it too much since installing, but I noticed the item search function is borked somehow, If I search for 1hs It gives me items that aren't even weps. Still a nice tool though, I like it, and it's so easy to install.

I also installed the old magelo clone script this morning if anyone wants to check it out or needs a link to download it let me know. It appears to work correctly also.

baneoflife.com/magelo

Quote:

Originally Posted by paaco (Post 160543)

Yeah, I seem to recall this now. It's pretty easy to fix IIRC. It has to do with the building of the query, it has something out of place in the php.

EDIT: If you want I'll send the php files I changed when I installed it.

That would be great, shoot them to me at paaco1981@gmail.com when you have spare time if you don't mind. Thanks Andrew :)

Let me start of by saying this is an amazing piece of software. Thanks to all that have contributed to it.
I was just curious if anyone knew what became of the NPC image collection, was an attempt ever made to work on it? It would be an awesome addition to peqbrowser.
Thanks all.

If anyone is still having trouble with the item search function throwing up items you wouldn't expect as mentioned above, it can be easily fixed by capitalising $query on lines 89 - 96 of items.php so that it looks like this:

PHP Code:


		
			
 if($iclass > 0)    { $Query.=" $s ($tbitems.classes & $iclass) ";    $s="AND"; }

  if($ideity > 0)    { $Query.=" $s ($tbitems.deity   & $ideity) ";    $s="AND"; }

  if($irace > 0)     { $Query.=" $s ($tbitems.races   & $irace) ";     $s="AND"; }

  if($itype >= 0)    { $Query.=" $s ($tbitems.itemtype=$itype) ";      $s="AND"; }

  if($islot > 0)     { $Query.=" $s ($tbitems.slots   & $islot) ";     $s="AND"; }

  if($iaugslot > 0)  { $Query.=" $s ($tbitems.augtype=$iaugslot) ";    $s="AND"; }

  if($ireqlevel > 0) { $Query.=" $s ($tbitems.reqlevel<=$ireqlevel) "; $s="AND"; }

  if(!($inodrop))    { $Query.=" $s ($tbitems.nodrop=1)";              $s="AND"; }

Hope this helps someone :)

I am thinking about reviving my 'Zam clone, called "Alkabor's Almanac" because a friend of mine has restarted a EQEmu server. However I am not sure weather to do this as a personal project just for those who play on his server or a general project. I have released previous versions of this web server, but had no interest.

So to save my self the hassle I will initially be developing it just for the small group of us.

However if enough people are interested then I will put the work into productising it and release it.

A publicly viewable version is available at http://www.slowglass.com/Alkabor/

Slowglass

Quote:

Originally Posted by slowglass (Post 168751)

Nice work!

A little late maybe, but I've tried the version you linked to today and find it really useful. I would sure use it if you made it available for the public!

Anyone got a copy of this ?

i'm looking for a working version of EQ Alla. is there anyone that has it for the current SVN of EQEMU? i've used search, and I can't get to projecteq.net. any help would be appreciated.

PEQ wouldn't help you anyway, we don't host these files either :)

If you want to wait until this evening I can put a gzipped version of mine. I fixed most of the errors for the one that was available and added a couple of things but it works pretty well.

thanx andrew, I would appreciate that.

Check the downloads section of the SVN

thankx again andrew, gonna check it out now.

Quote:

Originally Posted by slowglass (Post 168751)

Wow nice! I would love to use that for my server, please do consider releasing it.

http://www.visualwin.com/ shows you how to set up php, perl, and many other things as well, including mysql. There is a graphical walk through for IIS under windows server 2003 also. A handy page for beginners with screenshots. I hope this helps people out.

I am really getting into modifying mine. I have mine modified to show our bots and the bot inventory now. One thing I have been working on and is taking forever is getting the NPC jpeg's in there. Has anyone done this already ? I would hate to reinvent the wheel if someone has already done this. Basically the program looks for a jpg with the item id of the mob. I am slowly doing this but there is a hell of a lot of mobs in the game. Anyone got there zipped up ?

What happened to this project? There's mention of a sourceforge desired. Did one ever get set up? Or could a google code repo be set up? I wouldn't mind helping out on this either, but the few and far between releases makes it a bit more difficult to follow and/or hand off to new developers.

Just figured I'd poke my head in and see if there was interest in it still. I suppose I could try to open a google code repo if everyone has quit on this. It seems a shame to do my own modifications and not share them back.

-ork

It's in the downloads section of the projecteqemu svn. We could put it in the tools svn and let folks contribute. Let me see if I can get it set up in the next couple of days.

I'd be up for helping. Maybe in SVN under utils/eqbrowser/ or something would work well. I would think we need to add some of the GPL licensing text since we got a go-ahead from muuss to do so. I'd suggest we keep it generic, but feature complete, to the trunk eqemu code base. That way people should have a really great starting point if they start heavily modifying their server. What does it take to get svn commit access?

-ork

Quote:

Originally Posted by provocating (Post 181439)

Actually I have been doing that.

I have been messing around with a minilogin server and raiding with 71 bots, doing VT non-stop (thanks truncate table respawn_times!) to gear up the bots to take on the POP encounters. However managing gear has become quite the chore using the ingame commands. I thought maybe someone had created a bot plugin for magelo but I couldnt find one...so yesterday I threw one together.

Now a disclaimer...this is nothing more than a redunkulous fast hack of the already existing, amazing magelo clone re-write by the mq team. I didnt want to touch any of their files so this could truly bolt on to anyone's server that used stock PEQ database. You should update their files to create the proper links if you want this to flow on your site, but it works without changing anything...it just can't be accessed directly from the UI. This may also be a fail for public servers that care about permissions and who can see what in their profiles. I do not worry about this since I run minilogin so adjustments may be necessary to follow the rules. This is strictly a "function trumps form" release.

I will mainly use this to manage gear and focus effects, so I did not add in bot AAs to stats. I am not even sure stats calculate correctly, however I trust they do since I use the stat and item classes from the existing code.

Extract this file into your magelo root folder.

Usage is:

http://localhost/magelo/botList.php?char=Govtcheeze

Clicking on "Bot Name" or "Class" will sort by that heading. No filtering.

Let me know if you have any questions / comments / issues.

http://207.56.82.187/eqemu/magelo.zip

Edit: I will be attempting to build a SOD item examine window to replace the "classic" examine window the current magelo clone uses.

One thing I overlooked was bots with the same name...it now checks for owner ID as well as bot name. If anyone happened to grab the version before this post, grab the new file. I didnt find any other issues with it...so far :)

Quote:

Originally Posted by govtcheeze (Post 190636)

I added your additions, pretty cool. I had to edit the original menu and add a button to link your stuff in. Pretty cool when I was done though. Now I need to do some modding to the Alla clone, I have plenty of errors from where the DB changed a while back.