Eq Browser : Allakhazam Clone
 

Hi there,

I always enjoyed exploring EQ thru allkahazam's website. So i made a clone of allakhazam for EqEmu. That clone isn't fully finished, but there's yet a few things that work ok. It works with any 6.0 database and should also work with 5.7 (tested it, seems ok).

It requires a webserver supporting PHP and Mysql. The best choice under linux is Apache+PHP+Mysql, under Windows... easyphp for private use, perhaps , dunno really :)

After downloading the archive (eqbrowser.tar.gz), open the README.TXT file and follow the instructions, its not hard to install, just don't forget to source the needed sql files. The provided SQL files add 2 tables, races and spells, and don't modify in any way the EQEmulator tables.

The website where you can download it is : http://eqemu.vilvert.net/downloads.php

There's no forum on that website ATM, i m working on it. If you have some things to comment or add, please do it here, or by mail (email address on the website). Any addition, bug fixes are welcome !


A few snapshots :

http://eqemu.vilvert.net/upload/chardok.gif
http://eqemu.vilvert.net/upload/item.gif
http://eqemu.vilvert.net/upload/faction.gif
http://eqemu.vilvert.net/upload/npc.gif
http://eqemu.vilvert.net/upload/recipe.gif
http://eqemu.vilvert.net/upload/zones.gif

This sounds like an awesome tool. Can you provide a link to a working example or screenshots of what it looks like? Thanks!

try that link : ------------
This is temp, i ll post some snapshots asap ! (12 hours at work yet, can't wait to be back home !)

edit : removed the link, i added the snapshots !

This is SOOOO cool. I love the idea of allowing people to see "under the hood" so to speak. Very nice job.

Ya, that's a pretty neat idea. My editor is basically the same thing in guest mode. But allakhazam is a friendly and usually familar interface for people :)

nice work

Hi muss, could i know what should i to do for run u tool on WIN-XP, u said that i must download easyphp, but easyphp only works on apache? then i also need to set a apache server for run this tool? i would like only use u tool without set a server or any other thing.. is it possible?

And u eq-browser like allakhazam looks very nice, u did a great work, thx for share it with the community.

In fact, easyphp is apache+mysql+php.
It's enough by itself. You only need the database, no need to install eqemu server.

- install easyphp
- create a database named eq for example
- source a database package in it, like PEQ for example
- install the browser into the easyphp html tree (read the README.TXT for instructions)

And it should run.

Updated, added pets stats and corrected a few things.

Very NICE! I'm sending this to my webserver right now! Thanks a lot Muuss! :D

Any suggestion on things i could add or modify ? :)

error
 

not sure what the problem is cause i dont know crap but anyone know why by this?:

Aren't you using IIS ?
i don't know much about it, but i doubt it suppots php by default...

yeah im using IIS but i still cant get this to work what am i supposed to use? ive coppied and done all the steps it told me to 5 times......

I know absolutely nothing about IIS, i think it doesn't support PHP scripts. You need a php module, or something that makes IIS able to execute PHP if it doesn't yet.
the first test you could do is to create a file named test.php and containing :
<?php
print "that test is working";
?>

Place it into your html tree then try to view it with your browser. If you see ONLY 'that test is working', it means that your IIS supports PHP, if not, for example, you can read everything, from <?php to ?>, well, go back to what i wrote at the beginning of the post, you need to add something to IIS to make it working with PHP. I m sorry i can't help you more than this.

I use IIS and php works just fine. All I need to do to get php working is install php, then make sure IIS knows how to handle a .php document and it works.

Would you describe what you need to do to make it to work for 1Boppoom1, plz? like which file you need to modify to add php support, and how ?

Between 2 rants, updated to 0.2.1

Version 0.2.1
- (Muuss) Added an option to reduce the items research to sold or droped items.
- (Muuss) Added an option to reduce the items research to items with a stat higher or lower than the specified value.
- (Muuss) Added the possibility to display chances of droping of each item in the npc display page (see config.php).
- (Muuss) Added item type to zones equipment list.
- (Muuss) Added required level to items research and items display.
- (Muuss) Added display of surrounding spawngroups in the spawngroups display page. (see config.php for range)
- (Muuss) Added the possibility to remove sold items from zones equipments lists. (see config.php)
- (Muuss) Added the possibility to remove drop lists from merchant npcs. (see config.php)
- (Muuss) Modified the NPC page to display spells and drops in columns.
- (Muuss) Corrected a few bugs.

Updated to 0.3.
This is a major update, you can personnalize the header and the welcome page and items has been seriously revamped. Roughly everything about them is now displayed. I also added the option to use News so server admins can keep the players alerted of DB changes or whatever else they want.

- (Muuss) Added personnalization facilities, see README.TXT.
- (Muuss) Added optional News support, see config.php and source includes/sql/news.sql into your database.
- (Muuss) Remade NPC spell's list, it now correctly works.
- (Muuss) Added support for additional modifiers to items display.
- (Muuss) Added items price support to npc and item display.
- (Muuss) Added deity restrictions to items research and display.
- (Muuss) Merchants won't appear anymore in items droper's list (see config.php)
- (Muuss) Totally revamped items display page.
- (Muuss) Added Mainhand/Offhand efficiency to weapons display.
- (Muuss) Added Spell effects parameter to spell research.
- (Muuss) Completed the README file.

Download from the link in my sig.

Forgot to add in the README.TXT file that you MUST use the last items dump or you'll only obtain nodrop items with the search item's form.

no variables being defined
 

I have a working Apache / php / mysql webserver. But when I try to use the EQBrowser 0.3 web site on it. I get a ton of Variables that are not defined.
My config.php file is set up correctly.. but for some reason - no variables.

Anyone have a quick fix for me to try?

I saw this in the readme I downloaded it yesterday and it worked fine for me.

The files into that directory are needed for eqbrowser. You can remove them once everything is running fine and till next update.

REQUIRED : races.sql -> creates the races table.
REQUIRED : spells.sql -> creates the spells table.
OPTIONAL : news.sql -> creates the eqbnews table. Only required if you $EnableNews is at TRUE in config.php

I must need to clerify
 

No not that data in the Database is missing it is not registering the PHP variable for the website.. like...

Undefined Variable: ShowCharacters in menu.php on line 22

Undefined Variable: ShowCharacters in headers.php on line 5


And a few others

Anyone else.. have some help for me?

icon
 

Curious if you could release the tool to extract the icons?

I noticed there are ones missing in the included icons.

bUri

Your links on that page are broken because when I click on them it just brings me to the same page and then I am at a stand still again looking at the same download links. I tried all three of them and it will not let me download anything. Just want to use it thanks :)

undefinded variables
 

This might help with the undefinded vars errors. As of php 4.2.0 the php.ini setting for register_globals was set to off, this helps prevent the ingecting of data etc...

basically, open your php.ini and change the register_globals = off to on, this should correct some of the undefinded errors your getting.

I wouldn't recomend this on a "Live" site, but internal site should be ok.

for more infomation on register_globals, visit http://us3.php.net/manual/en/ini.cor...gister-globals

:)
vRandom

Due to popular demand and before people to start to commit suicides, here comes a 6.5 version of eqbrowser.

http://eqemu.vilvert.fr/eqbrowser_0.4.tar.gz

Please read all this topic before starting to install, and don't forget to source the included sql files (includes/sql/*sql).

This is fully compatible with PEQ luclin DB. Be aware that due to DB changes, the pet part won't work on a custom DB. Edit includes/constantes.php in that case (good luck).

Muuss

Please : stop sending nude women to my home, this becomes embarrassing :D

Nice news :)

But i don't send nude women, you don't receive nude mens ? :p :p :p

OMG, I just understood why my wife is so tired these days !

WB again Muuss, glad to see old projects made current!!

Please forgive a small mistake I made with 0.4 release, concerning item prices and shopkeepers.

If you yet downloaded 0.4, download it again, and just uncompress it over your previous install (config file won't be splashed, save your template files if you made some).

--- SMALL TIP for people who wanna test eqbrowser without creating new tables in their EQEmu database ---

- Create a database named eqbrowser (or anything else).
- Source the eqbrowser sql files (includes/sql/*.sql) into that DB, source also the spells (from allspells.sql or from import_spells.pl)
- Edit includes/constantes.php and modify the following variables to :
$tbspells="eqbrowser.spells";
$tbnews="eqbrowser.news";
$tbraces="eqbrowser.races";

If you have several EQEmu databases, prefer this option, it will save you some time.

This may be a little late but I had this tutorial sitting around that I wrote sometime ago about how to install PHP 4 on IIS 5.1 (version shipped with windows XP Pro) You can view the tutorial at http://portfolio.sesmar.net/tutorials/php4.php

I hope this helps for setting up PHP on IIS.

I have been unable to get eqbrowser to work, on both Winblows and Linux. Whenever I try to do anything at all (eg search) it always takes me back to the list of zones and how many mobs are in each (which is correct, so it is communicating with my db) Do you have any suggestions?

Two things I did notice, by default the configs point to your server I think and you left your root password in ;)

Dude, thank you for your warning :)
Edit your php.ini, and put "Register_globals" at ON, it should fix your problem.

I had the same problem it's a php.ini config problem.
check your globals.

Thanks guys! It works great.

I've just finished to rework all the spell part of eqbrowser. Spell description matches now Lucy's (word for word, or almost).

This is a major improvement, spells are now fully described and understandable. I've also included a new allspells.sql file that contains the 9/13/2006 spells.

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

If you encounter some spells with incorrect or incomplete descriptions, please report them here so i can't fix the source code. Be aware that lucy's AC calculation bonuses from spells doesn't match the result from the browser, I know that, it ll remain that way unless someones explains me exactly how they make their calculation (took mine from eqemu's source code).

Muuss

Well the way I see it, the spell calculations in the browser should resemble EQEmu, and not Lucy. While the end goal is a total Live clone, we aren't there yet and so all of the killer 3rd party apps like yours should reflect that.

Not wrong :)

For those of you who like updates...

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

I've added a chart of the zones levels, that looks like allakhazam's zones level. Zones arent sorted cause that page is dynamic and sorting all that stuff is an heavy CPU work. I ll perhaps add the sort with an option to unvalidate it.

Also added haste in items search.

Updated again : (0.4.3)

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

Be aware that you need to update 'spells' table. This may be done by running includes/sql/update-0.4_0.4.3.sql, then running import_spells.pl (edit it before).
You can also remove the table then source allspells.sql (which is uptodate to 9/13).

- Added a pet description page.
- Added special attacks to pets and npcs pages.
- Sorted zones by level in the zone levels list (can be unvalidated from config file if it eats to much CPU on your server).
- Fixed a bug with items with small prices (less than 1 plat).
- Fixed a display bug in zone levels page that was showing the first zone from the DB after each level row.
- Added a new variable in config file that allows to configure the max number of items/recipes returned by the search engines.

TODO:
Complete races, spell descriptions.
Improve tradeskills
Add quests (big job)
Follow suggestions...