AllaClone 2.0

[trevius]

Here is complete revamp of the Allakhazam Clone / EQBrowser tool originally made by Muuss and others over the years. This revamp adds many new features such as tooltips for items, multiple themes, updated item stats, spell info, pet info, tasks, etc. It no longer requires any custom SQL to be added to your database in order to use the tool. Just copy it to your public folder and edit the config.php file and it should work.

Akkadius and I spent the last couple of weeks working on this update.

Download Page:
http://code.google.com/p/projecteqemu/downloads/detail?name=AllaClone_2.zip&can=2&q=

Working Example:
http://69.168.254.243/AllaClone/index.php

Here are some notes I added to the included HISTORY.TXT file on what was changed:

Version 2.0 Rev2199 - 02/13/2012
- (Trevius/Akkadius) Revamped how almost all of the website works and looks.
- (Trevius/Akkadius) Added Tooltips for items.
- (Trevius/Akkadius) Revamped Pets page completely.
- (Akkadius) Revamped Recipe Search to match ZAM recipe search.
- (Akkadius) Revamped Spell Search completely to match ZAM spell search.
- (Akkadius) Added a Theme/Style changing window that allows viewer to choose from multiple themes.
- (Akkadius) Added a ZAM Search window option.
- (Akkadius) Added new item icons.
- (Akkadius) Added Class Monograms (animated class symbols).
- (Trevius) Added a toggle search fields button to items search.
- (Trevius) Added a Dark Blue theme.
- (Trevius) Reformatted the page layout to have side bars on both side.
- (Trevius) Revamped the item output to match Live format and to include all newer stat types.
- (Trevius) Removed the need to source tables for this tool. Spells data now comes from spells_new and race data was made into an array.
- (Trevius) Resolved many security issues in the code.
- (Trevius) Updated the race list through VoA expansion.
- (Trevius) Fixed various issues related to displaying item stats.
- (Trevius) Implemented Discovered Items and the option to display recently discovered items on the main page.
- (Trevius) Added many new options that can be toggled on or off in the config so admins can display exactly what they want.
- (Trevius/Akkadius) Fixed/Adjusted various other systems.

If there are any questions, let me know in this thread and I will try to answer them.

[provocating]

Awesome !!!!!!!!! I notice some things have been removed though :(

[Akkadius]

Here is complete revamp of the Allakhazam Clone / EQBrowser tool originally made by Muus and others over the years. This revamp adds many new features such as tooltips for items, multiple themes, updated item stats, spell info, pet info, tasks, etc. It no longer requires any custom SQL to be added to your database in order to use the tool. Just copy it to your public folder and edit the config.php file and it should work.

Akkadius and I spent the last couple of weeks working on this update.

Download Page:
http://code.google.com/p/projecteqemu/downloads/detail?name=AllaClone_2.zip&can=2&q=#makechanges

Working Example:
http://69.168.254.243/AllaClone/index.php

Here are some notes I added to the included HISTORY.TXT file on what was changed:



If there are any questions, let me know in this thread and I will try to answer them.

A little premature in my opinion as there are several things I wanted to do yet.

[trevius]

Updated the download file on the SVN again with fixes for a few things that Akkadius mentioned (directly to me) and a few more features.

Version 2.0.1 Rev2103 - 02/22/2012
- (Trevius) Added pagination to Discovered Items on the welcome page.
- (Trevius) Added Task Step Goal List Details.
- (Trevius) Added Tooltips to Zone Equipment lists.
- (Trevius) Corrected display positioning for multiple pages.

You can find the download here as usual:
http://code.google.com/p/projecteqemu/downloads/list

[Tabasco]

This is looking good, thanks for working on it. I had the old one working well enough, but this is much easier to set up and use.

Would it be possible to put this into its own svn branch for easier updating?

[trevius]

Yeah, I have thought about doing that. I think it would be the best option. I would just need to figure out the easiest way to allow updating to newer revisions without having it overwrite any normally modified files (config, custom CSS changes, welcome page message, etc).

I will probably need to check with the other devs as well to see if they think it could go on the EQEmu project in a branch or if it should go under a project of its own.

[sorvani]

If you are on the Melee damage page and try to use the main search you get a 404.

The requested URL /zam/strategy/fullsearch.php was not found on this server.

/zam is my directory.

[sorvani]

/zone.php?name=tipt

X and ( are bold in the succor point but nothing else.

[trevius]

Thanks for the reports. Both of those are now fixed on my server and will be included in the next version release.

[Harcourt]

Very nice, thanks for making this available.

[Talez]

minor thing in the zones by era list, under antonica it links to solrotower, it should be be soltemple

[trevius]

minor thing in the zones by era list, under antonica it links to solrotower, it should be be soltemple

Thanks for the report. I got that fixed and it will be in the next release. I didn't really go back through the lists of the existing zones by era lists previously. I only added the newer ones that didn't exist in it yet, which I think was everything after GoD.

[Akkadius]

Thanks for the report. I got that fixed and it will be in the next release. I didn't really go back through the lists of the existing zones by era lists previously. I only added the newer ones that didn't exist in it yet, which I think was everything after GoD.

Ok, I had decided today that I had enough time to go through this. Here are most of the changes I made today. There's quite a few so go check the site out:

http://69.168.254.243/AllaClone/index.php

Akkadius: Changed the header of each page to be slightly more attractive and less hugging the top
Akkadius: Adjusted the 'Zones by Era' title
Akkadius: Adjusted Item names to be under <h3>
Akkadius: Italicized item lore information
Akkadius: Removed wrapping from Storm Haven CSS Tooltips that caused expansion descriptions under 'Zones by Era' to not display correctly.
Akkadius: Replaced the filename zonelist.php into ZonesByEra.php and changed the menu link, this is to consolidate and remove the 18 separate individual pages
Akkadius: Eliminated 22 unnecessary PHP scripts inside of the folder /static that resulted each of the pages for 'Zones By Era', they are all underneath one page now
Akkadius: Added a frame to zones listed within 'Zones by Era' to have a description of the Era listed to the right, with the zones listed on the left
Akkadius: Brought the alignment of the 'Search' button in npcs.php to the center
Akkadius: Changed 'advnpcs.php' 'Search' button to conform with the rest of the buttons in the AllaClone
Akkadius: Added a class to the CSS sheet for 'menualla' which will display an appropriate background for each CSS stylesheet implemented. This was applied to spells.php, example here:
http://69.168.254.243/AllaClone/spell.php?id=4938, it now looks more balanced.
Akkadius: In 'spell.php', 'Items with THAT spell' was changed to 'Items with this effect:'
Akkadius: Changed toggle icon for the 'items.php' search function and removed (Toggle Search Fields) since it was a bit redundant and ugly
Akkadius: Added the menualla class around the search options under 'items.php' to make the page pop more
Akkadius: Changed CSS for Allakhazam Tooltips to color Anchor links Yellow instead
Akkadius: 'item.php', added menualla wrapper around the header
Akkadius: Added the actual weapon graphic to each item if the file is available, which most of them are.
Akkadius: Changed 'recipes.php' form buttons to conform to the rest of the AllaClone
Akkadius: Added menualla CSS style to the form for 'recipes.php'
Akkadius: Added menualla CSS style to the form for displaying any recipe (http://69.168.254.243/AllaClone/recipe.php?id=110)
Akkadius: Changed the verbiage on the searching of recipes
Akkadius: Cleaned up the searching on Advanced NPC search
Akkadius: Added menualla class to the Spells menu
Akkadius: Rounded out the Tooltips for everything, they now look really close to ZAM tooltips, but they function way better right Trevius!?
Akkadius: Adjusted Faction Search to look like the rest of the clone
Akkadius: Adjusted Melee Damage calculator to look like the rest of the clone, fixed the title, fixed some English in the results

[Akkadius]

Just added a new header to the Allakhazam style header. If Trevius wishes to use this on his he can.

[pheroux]

Woot! Thank you for this AllaClone!

[Akkadius]

This can be checked out here:

http://code.google.com/p/allaclone-eoc/source/checkout

EDIT: Just updated to R3

[Akkadius]

Also, here is a working example of the repository. Please post questions comments or concerns here:

http://akkadius.dyndns-server.com:8000/AllaClone/ZonesByEra.php

[initium]

Thanks for working on this. I had planned on trying to revamp this, and now I don't have to :) I'm getting a lot of errors with item searching. Here's what I've done:

1) Checked out latest revision (Rev2103 according to config.php)
2) edited dbhost, dbname, dbuser, dbpasswd, $root_url, and $eqemu_dir (Zone pages load fine, so I assume these are all ok)
3) From the homepage, I click on Item Search (takes me to items.php)
4) I enter "tunic" into name and click "Search"

Here are the results:
Notice: Undefined variable: row in /home/eqemu/public_html/AllaClone/includes/functions.php on line 903

Notice: Undefined index: loreflag in /home/eqemu/public_html/AllaClone/includes/functions.php on line 919

Notice: Undefined variable: v in /home/eqemu/public_html/AllaClone/includes/functions.php on line 209

Notice: Undefined variable: res in /home/eqemu/public_html/AllaClone/includes/functions.php on line 209

Notice: Undefined variable: v in /home/eqemu/public_html/AllaClone/includes/functions.php on line 219

Notice: Undefined variable: res in /home/eqemu/public_html/AllaClone/includes/functions.php on line 219

Notice: Undefined variable: v in /home/eqemu/public_html/AllaClone/includes/functions.php on line 197

Notice: Undefined variable: Result in /home/eqemu/public_html/AllaClone/includes/functions.php on line 197

Warning: Missing argument 3 for GetItemStatsString(), called in /home/eqemu/public_html/AllaClone/includes/functions.php on line 1018 and defined in /home/eqemu/public_html/AllaClone/includes/functions.php on line 499
...

[chrsschb]

What do I set these to if the web server and the emu server are on different machines?

$includes_url=$root_url.'includes/';
$includes_dir=getcwd()."/includes/";
$eqemu_dir="/home/eqemu/server/";
$quests_dir=$eqemu_dir."quests/";
$quests_datas="/home/eqemu/server/quests/";
$maps_dir=getcwd()."/maps/";
$maps_url=$root_url."/maps/";
$npcs_dir=getcwd()."/npcs/";
$npcs_url=$root_url."/npcs/";
$icons_dir=getcwd()."/icons/";
$icons_url=$root_url."/icons/";
$images_url=$root_url."/images/";

Also getting a million of these errors trying to do an item search:

Warning: Missing argument 3 for GetItemStatsString(), called in /homepages/31/d168152119/htdocs/AllaClone/includes/functions.php on line 1008 and defined in /homepages/31/d168152119/htdocs/AllaClone/includes/functions.php on line 494

[provocating]

Thanks for working on this. I had planned on trying to revamp this, and now I don't have to :) I'm getting a lot of errors with item searching. Here's what I've done:

1) Checked out latest revision (Rev2103 according to config.php)
2) edited dbhost, dbname, dbuser, dbpasswd, $root_url, and $eqemu_dir (Zone pages load fine, so I assume these are all ok)
3) From the homepage, I click on Item Search (takes me to items.php)
4) I enter "tunic" into name and click "Search"

Here are the results:
Notice: Undefined variable: row in /home/eqemu/public_html/AllaClone/includes/functions.php on line 903

Notice: Undefined index: loreflag in /home/eqemu/public_html/AllaClone/includes/functions.php on line 919

Notice: Undefined variable: v in /home/eqemu/public_html/AllaClone/includes/functions.php on line 209

Notice: Undefined variable: res in /home/eqemu/public_html/AllaClone/includes/functions.php on line 209

Notice: Undefined variable: v in /home/eqemu/public_html/AllaClone/includes/functions.php on line 219

Notice: Undefined variable: res in /home/eqemu/public_html/AllaClone/includes/functions.php on line 219

Notice: Undefined variable: v in /home/eqemu/public_html/AllaClone/includes/functions.php on line 197

Notice: Undefined variable: Result in /home/eqemu/public_html/AllaClone/includes/functions.php on line 197

Warning: Missing argument 3 for GetItemStatsString(), called in /home/eqemu/public_html/AllaClone/includes/functions.php on line 1018 and defined in /home/eqemu/public_html/AllaClone/includes/functions.php on line 499
...

I could be wrong but it sounds like you have warnings turned on in your php.ini file.

[initium]

I could be wrong but it sounds like you have warnings turned on in your php.ini file.

You're exactly right. Thanks!

[provocating]

You're exactly right. Thanks!

It happens about once a year, when the planets are in the right position.

[chrsschb]

You're exactly right. Thanks!

Where can one find this php.ini file?

[provocating]

Depends on if you are running Windows or Linux, then what flavor of Linux.

[chrsschb]

My webserver is through 1and1, which I assume is Linux.

[provocating]

Your errors I think are going to be different from what the previous posters are. Yours are more than likely because you are indeed hosting the website on a different server than where the database is.

[chrsschb]

Maybe, which reverts back to my original question on linking the two when on different servers.

[Akkadius]

You can use an outside database, your warnings are related to the page warnings that are set on your web host side of things. The site that I have previewing this and the site Trevius has this running on are both in-house servers that I run in my DC.

[chrsschb]

You can use an outside database, your warnings are related to the page warnings that are set on your web host side of things. The site that I have previewing this and the site Trevius has this running on are both in-house servers that I run in my DC.

How do I change them / turn them off?

[provocating]

You will need to dig on the forums for 1and1 or call them on the phone. There may be an option on their control panel to turn off PHP warnings, we are turning them off via php.ini since we have shell access, you do not so you will need to contact 1and1.

[chrsschb]

You will need to dig on the forums for 1and1 or call them on the phone. There may be an option on their control panel to turn off PHP warnings, we are turning them off via php.ini since we have shell access, you do not so you will need to contact 1and1.

Still getting the errors.

http://downloads.overthetophosting.com/images/phpsettings.png

[provocating]

Possibly a PHP5 issue ?

I know some of these online host make you call your php files php5 for compatibility.

Like these guys are getting errors like this installing Mediawiki on 1and1, worth a shot to rename some of your files to see if it makes a difference.

http://www.mwusers.com/forums/showthread.php?2472-install-error-MediaWiki-at-1and1.fr

[initium]

Switching "Register Globals" on should cut out some of the errors, but not the ones related to having them on different servers

[chrsschb]

Possibly a PHP5 issue ?

I know some of these online host make you call your php files php5 for compatibility.

Like these guys are getting errors like this installing Mediawiki on 1and1, worth a shot to rename some of your files to see if it makes a difference.

http://www.mwusers.com/forums/showthread.php?2472-install-error-MediaWiki-at-1and1.fr

Crazy you mention it because I have a mediawiki site running just fine through the same host lol.

[chrsschb]

Switching "Register Globals" on should cut out some of the errors, but not the ones related to having them on different servers

That worked!


Now... does anyone know how to add the loot/item links my forum.

[initium]

I've been working on the quests a little bit. In particular parse_quests scripts. I know that's still on the to-do list, so I figured I'd post what I've run into so far. (When I mention changes I've made, these are just on my server of course)

These subroutines have no entry in the relevant pm files:
quest::npcsize
quest:npcrace
quest::buryplayercorpse
quest::npctexture
quest::SetRunning

(I just made empy subroutines for all those for now, but I wasn't sure if that was the best way to do it)

In file parse_quest.inc - old form item turn ins have a bug. Here's the relevant section:


# Now, we give the npc some items
# Old form, item1 to item4, starting at the if and ending at the {
for (my $i=0; $i<$#content; $i++) {
if ($content[$i]=~/item[1234]\s*==/) {
EvalItemOld($content[$i]);
do {
$i++;
if ($content[$i]=~/item[1234] ==/) { EvalItemOld($content[$i]); }
} while (!($content[$i]=~/{/));
give_old();
}
}

I actually had a few issues with this section. The first was the most important:
1) There are a few quests that cause the "do" loop to never end. This happens when there's no "{" after the line with item[1234]. This happens with several quests in qeynos:
Mespha_Tevalian
Renic_Losaren
Gahlith_Wrannstad
Kinloc_Flamepaw

I wasn't sure about the intent of the "do" loop, so I wasn't sure how best to fix it. My suspicion is that this could be fixed by changing '{' to '}', but again I wasn't sure, so I just made an innocuous change to the quests. I've just added an:
else {} after the appropriate "If" in the quest files for now

2) in the "do" loop the space in the regex should probably be replaced with \s*

3) item[1234]\s*== seems like too blunt of a check. I don't know the quest system well enough to be certain, but as far as I can tell ParseFile hasn't even checked to see if it's in an EVENT_ITEM (at the very least I'd think it would make sense to check for \$item[1234]\s*

Thanks again for working on this

[Akkadius]

I've been working on the quests a little bit. In particular parse_quests scripts. I know that's still on the to-do list, so I figured I'd post what I've run into so far. (When I mention changes I've made, these are just on my server of course)

These subroutines have no entry in the relevant pm files:
quest::npcsize
quest:npcrace
quest::buryplayercorpse
quest::npctexture
quest::SetRunning

(I just made empy subroutines for all those for now, but I wasn't sure if that was the best way to do it)

In file parse_quest.inc - old form item turn ins have a bug. Here's the relevant section:


# Now, we give the npc some items
# Old form, item1 to item4, starting at the if and ending at the {
for (my $i=0; $i<$#content; $i++) {
if ($content[$i]=~/item[1234]\s*==/) {
EvalItemOld($content[$i]);
do {
$i++;
if ($content[$i]=~/item[1234] ==/) { EvalItemOld($content[$i]); }
} while (!($content[$i]=~/{/));
give_old();
}
}

I actually had a few issues with this section. The first was the most important:
1) There are a few quests that cause the "do" loop to never end. This happens when there's no "{" after the line with item[1234]. This happens with several quests in qeynos:
Mespha_Tevalian
Renic_Losaren
Gahlith_Wrannstad
Kinloc_Flamepaw

I wasn't sure about the intent of the "do" loop, so I wasn't sure how best to fix it. My suspicion is that this could be fixed by changing '{' to '}', but again I wasn't sure, so I just made an innocuous change to the quests. I've just added an:
else {} after the appropriate "If" in the quest files for now

2) in the "do" loop the space in the regex should probably be replaced with \s*

3) item[1234]\s*== seems like too blunt of a check. I don't know the quest system well enough to be certain, but as far as I can tell ParseFile hasn't even checked to see if it's in an EVENT_ITEM (at the very least I'd think it would make sense to check for \$item[1234]\s*

Thanks again for working on this

That'd be sweet if you could get quest dialogues working. Trevius and I are working on a big web project that we'll also reveal in due time :)

[chrsschb]

Alright 2 things: How do I turn on discovered items?

Second, my Dark Blue theme is not working. When selected the theme does not change.

[provocating]

Alright 2 things: How do I turn on discovered items?

Second, my Dark Blue theme is not working. When selected the theme does not change.

Discovered items is in the config file.

True changing it to this.

$DiscoveredItemsOnly=TRUE;

Also Trevius, if you are listening. I noticed there is a wiki options boolean. Is this going to be integrated into Mediawiki or some other wiki program? One thing people have asked for is a way to be able to make comments on NPC's and such, like they can on Allakhazam's also the option for them to be able to add a jpg for NPC's that do not have an image.

[provocating]

Also, I just noticed this was left out of the config file, at least I could not find it anywhere.

$peqeditor_url="";

etc...$peqeditor_url="http://dragonsofmist.dyndns.org/edit/";

[chrsschb]

Discovered items is in the config file.

True changing it to this.

$DiscoveredItemsOnly=TRUE;

Sweet thanks. I must have misread that description to mean something else.

[Akkadius]

That worked!


Now... does anyone know how to add the loot/item links my forum.

Add this to the config.php anywhere, this will get rolled out in the default config in the next SVN submission.

// PHP Debugging
$DebugMode = FALSE;

if($DebugMode){
error_reporting(E_ALL);
ini_set('display_errors', '1');
}
else{
error_reporting(0);
}

[Akkadius]

Discovered items is in the config file.

True changing it to this.

$DiscoveredItemsOnly=TRUE;

Also Trevius, if you are listening. I noticed there is a wiki options boolean. Is this going to be integrated into Mediawiki or some other wiki program? One thing people have asked for is a way to be able to make comments on NPC's and such, like they can on Allakhazam's also the option for them to be able to add a jpg for NPC's that do not have an image.

The Wiki boolean was something that Trevius was looking at simply appending Wiki stuff to but would have been a very manual adaption to the Allakhazam.

As far as making comments to NPC's and items, we can make that happen but probably won't be touched considering what we're working on right now, but we can fix crucial things in the meantime. I'll let you know.

[trevius]

Yeah, eventually it would be nice to be able to allow players to add a pic and information about any page. With the wiki thing, I was thinking of a simple solution where it would just generate a wiki link for every item/npc/whatever page you might go to that is unique by name, type and/or ID. Basically, there would be a link at the top of the allaclone that would point to a unique wiki page. You could click that link and initially it would be an empty/new wiki page, but if someone populates it, it would have useful information for the next person that clicks it. From there, pics and notes could be posted. If we can figure it out, it would be cool to be able to pull information directly from those pages to display right in the related clone page along with the link to the wiki to edit it.

There have been a few changes to the allaclone that aren't on the SVN yet, but we will probably wait until our new project is a bit further along before doing the next update as it will be related/included with the clone.

[Akkadius]

Yeah, eventually it would be nice to be able to allow players to add a pic and information about any page. With the wiki thing, I was thinking of a simple solution where it would just generate a wiki link for every item/npc/whatever page you might go to that is unique by name, type and/or ID. Basically, there would be a link at the top of the allaclone that would point to a unique wiki page. You could click that link and initially it would be an empty/new wiki page, but if someone populates it, it would have useful information for the next person that clicks it. From there, pics and notes could be posted. If we can figure it out, it would be cool to be able to pull information directly from those pages to display right in the related clone page along with the link to the wiki to edit it.

There have been a few changes to the allaclone that aren't on the SVN yet, but we will probably wait until our new project is a bit further along before doing the next update as it will be related/included with the clone.

It's not so much a question of IF rather than when we can do it haha.

And yes this new project is really really cool. ;)

[provocating]

The "really cool" comment is making me patiently impatient Akkadius :)

[Caryatis]

Thank god Trevius is involved then otherwise all we would get are monthly updates about how much has been done :)

(USER WAS BANNED FOR THIS POST)

[Secrets]

>nothing to be done here

http://fuuu.us/395.png

[Caryatis2]

I know you are unfamiliar with the concept of friendly banter Secrets but Im sure if you asked Akkadius, he will say he had a good chuckle over it. Sometimes guys act like guys.

PS Its more like a suspension since it expires on 24th.

[Akkadius]

I know you are unfamiliar with the concept of friendly banter Secrets but Im sure if you asked Akkadius, he will say he had a good chuckle over it. Sometimes guys act like guys.

PS Its more like a suspension since it expires on 24th.

I'm totally guilty of life pulling me away from any possibility of getting anything done here. Though, this is a bit different what we're doing. I'm sure in the next week or so we'll post something. Already has made tons of progress.

[Secrets]

I'm totally guilty of life pulling me away from any possibility of getting anything done here. Though, this is a bit different what we're doing. I'm sure in the next week or so we'll post something. Already has made tons of progress.

200% progress

[sorvani]

Already has made tons of progress.
U.S. or Metric?

[chrsschb]

So does anyone know how to pull tooltips from this database as opposed to the REAL Allakhazam database? Would like to be able to link my custom / modified items.

[Akkadius]

So does anyone know how to pull tooltips from this database as opposed to the REAL Allakhazam database? Would like to be able to link my custom / modified items.

They don't pull the same way Allakhazam's do, our's work better performance wise but don't load dynamically which is on the agenda.

[trevius]

They load dynamically now :)

http://stormhavenserver.com/forums/viewtopic.php?t=2368

Working on getting all of the old item links replaces with the new ones that load dynamically. I think that will let all item links work throughout the whole tool without special code.

[chrsschb]

They load dynamically now :)

http://stormhavenserver.com/forums/viewtopic.php?t=2368

Working on getting all of the old item links replaces with the new ones that load dynamically. I think that will let all item links work throughout the whole tool without special code.

I like! When will we be able to use that?

[trevius]

I also added tooltips for spells tonight as well with the new dynamic loading system. You can see them at the same link to my forums that I posted above.

It is much easier to deal with tooltips this way.

Hopefully, it won't be long before we can get the SVN updated with a new revision. I think we are waiting until our new tool is more functional before doing so, though. There is still a ways to go on that, but these new tooltips should help a bit.

There are still a few issues to work out like how they can load off of the screen partially at first, but I think we can resolve that. I also need to find a better way to have it load the css file for the tooltips other than having a hard coded url in the script.

Also, for anyone that wants to use the new tooltips on their forums or other parts of their website, it does require a bit of extra setup. Basically, you have to add 1 script link at the bottom of whatever page you want to use them in. Here is a page that explains how to setup the ZAM version, which is almost identical steps to how ours is set up:

http://www.zam.com/wiki/tooltips

The only difference is that the file name and url for the script will be something more like this:

<script type="text/javascript" src="http://http://69.168.254.243/AllaClone/jquery/eqemutooltip.js"></script>

Hah, I guess those html tags on the forums have terrible colors, so here it is in code tags:
<script type="text/javascript" src="http://http://69.168.254.243/AllaClone/jquery/eqemutooltip.js"></script>

[provocating]

I like it.

I see many uses of that script even in other places.

[chrsschb]

Alright I added the code to my site, I was using the ZAM one already.

However the links aren't working. There are two .js files inside of my jquery folder, jquery.js and linktooltip.js, neither one works.

I'm tried using my actual domain for my alla clone (alla.blahblah.com) and I've tried using a root domain (www.blahblah.com/allaclone) with the allaclone folder added to it. Neither or those worked either.

[trevius]

Well, the dynamic tooltip stuff isn't released yet. It still needs a couple of minor changes. For one thing, it currently looks for an IP address in the URL instead of a domain name. I just need to figure out a good work-around for parsing out the URL and getting the correct information that is required so it can work for any site. If ZAM tooltips work on your site, then these already should as well if you use the IP of your server instead of the domain name when you create the link to the item.

Of course, you will still need the rest of the files that are used by the tooltips from the AllaClone if you want them to work against your own server's items. For example, the javascript actually references a page that builds the tooltip as a js function from another page. Here is an example:

Item:
http://69.168.254.243/AllaClone/includes/tooltip.php?id=1001&type=item

Spell:
http://69.168.254.243/AllaClone/includes/tooltip.php?id=11&type=spell


BTW, I had to do a lot of searching through ZAM tooltip stuff to get the dynamic tooltips working. I am guessing they noticed me directly hitting their tooltip url like the one I linked above, which probably isn't normally accessed directly. Literally 2 days later, the ZAM tooltip javascript was rewritten a bit and obfuscated lol. Not only that, but they had also updated the EQ item tooltips to show an icon. Since it has been the old way for years, I can only assume that I triggered them to make that change. I imagine they saw our server hitting theirs and maybe saw our tooltips (which I think look better) and figured it was time to update theirs. I also noticed that they set their tooltips to load above the cursor instead of below. This is probably because they had a bug that caused tooltips to load in the wrong position until the mouse was moved if they were partially off of the screen. I figured out the fix, so ours still loads from the bottom, just without the bug.

[Caryatis]

This thread is alot like Christianity, there is a death(ban), rebirth(unban) and huge disappointment(no updates).

[Akkadius]

This thread is alot like Christianity, there is a death(ban), rebirth(unban) and huge disappointment(no updates).

Yeah I know right? There need to be some updates going on in this thread! :D

[trevius]

Yeah I know right? There need to be some updates going on in this thread! :D

Yeah, I am sure there would be more updates if I wasn't so easily distracted or busy with RL stuff most of the time :P Been working on the VoA/Live client a bit and will be doing some more work on the AllaClone pretty soon. Though, I am not sure when the new stuff will be ready for a news update as there are quite a few things that need to be worked on. We may be able to have a couple of the new parts ready, but ultimately there are a lot of parts to work on that haven't even been started yet.

[Tabasco]

The sneak peaks I've seen are very promising, and I've been working on a counterpart to it all.
It's still in the proof-of-concept stage, but you can mess around with it.

http://dungeoncrawl.us.to/eq/mapvis/?zone=dawnshroud

For initial testing I'm just dumping the map files that azone2 produces. They still need chunked up according to the map's octree so we can get some culling performance boosts, but on a reasonably modern machine and browser it's perfectly usable as-is.
I've tested it in chrome and firefox, but chrome has the best performance.

[Akkadius]

The sneak peaks I've seen are very promising, and I've been working on a counterpart to it all.
It's still in the proof-of-concept stage, but you can mess around with it.

http://dungeoncrawl.us.to/eq/mapvis/?zone=dawnshroud

For initial testing I'm just dumping the map files that azone2 produces. They still need chunked up according to the map's octree so we can get some culling performance boosts, but on a reasonably modern machine and browser it's perfectly usable as-is.
I've tested it in chrome and firefox, but chrome has the best performance.

I will just add to this by saying how awesome this is already and what Tabasco and I have conceptually spoke about it to be.

The idea was to be able to edit spawns and grids through either a 2d or 3d editor so you could quickly make adjustments instead of constantly waiting to see the output of your result. Creating a zone can become quite tedious really quick if you are doing the whole thing or even just mapping out a few grids for a few different NPC's.

We also spoke about being able to simply edit zone lines or possibly even object or door placement. How awesome would that be?

Looks like Tabasco already has NPC selection and spawns working straight to the database. I loaded up Everfrost where the igloo and several path conjunction comes together:

http://i.imgur.com/kVGEg.png

------------------------------------


EOC - EQEmu Operations Center


To keep people from constantly hanging on to 'Ok what is going on here? What are we waiting on?' here is a few teasers from an editor I have been working on. Any of the stuff Trevius is working on he will have to show himself, sounds like he has been a little distracted with VoA client stuff at this time.

This whole 'secret' is an intuitive editor that we want tailored towards custom development and to take down development time down by fractions by what you would spend doing things through traditional tools available right now. Even though we've been blessed with all of the tools created thus far, between Trevius' and I's perspective custom development can be tedious and the process deserves some intuitive tools to speed up the process.

To start, one of the first things I started working on was an item editor. This item editor interfaces directly with the AllaClone and if you are logged in as an administrator, an 'edit' option will appear next to your item so you can start editing the item right in a very fast and 'under construction' intuitive interface.

What I hope to achieve with this:

A way to automatically scale an item by solo, group, raid definitions that are pre-built into your EOC database (We will be throwing these together)
A way to randomize statistical fields within a range for speed of customization
A way to visually see icons and edit them very swiftly
To edit weapon graphics very quickly and have an on-demand viewer that integrates with the editor and other parts of EOC
A way to resolve some of the issues that you have with traditional item editing
Making intuitive graphical visuals to reference certain field types
Creating ultimate functionality and speed for creating items and leaving more time for development in other areas
To also wrap this interface in a EverQuest feel to also fuel your development endeavours


First you start with you search criteria that is the same thing that you see here:http://69.168.254.244/eoc/AllaClone/items.php?iname=&iclass=0&irace=0&islot=0&istat1=hp&istat1comp=%3E%3D&istat1value=1000&istat2=&istat2comp=%3E%3D&istat2value=&iresists=&iresistscomp=%3E%3D&iresistsvalue=&iheroics=&iheroicscomp=%3E%3D&iheroicsvalue=&imod=&imodcomp=%3E%3D&imodvalue=&itype=-1&iaugslot=0&ieffect=&iminlevel=0&ireqlevel=0&iavailability=0&iavaillevel=0&ideity=0&isearch=Search

You will then see something similar to this:

http://i.imgur.com/kOCH2.png (Linked due to image limitation)

You select your item and you are brought into a very quick interface to edit your item:

http://i.imgur.com/690yS.jpg

http://i.imgur.com/cXOES.jpg

http://i.imgur.com/hURVa.jpg

I have other field translations that I need to do yet before I just link it and let people go away on it. I also want to make sure Trevius is ready to start letting people tool around with it before I start linking stuff, he is working on some cool stuff as well.

As you can tell, all of this is web-based and you require no special software to access this other than a decent browser (Not IE *cough).

This will be setup completely with user based access permissions and action based logs to hold developers to accountability and to see what is being done from a user perspective.

To jump back to the item editor, whenever you hit save a very quick Save will confirm your item creation or save by also generating a query that you can paste to someone else to also import it into their database for off-site editing.

REPLACE INTO items (`Name`, `lore`, `id`, `minstatus`, `artifactflag`, `fvnodrop`, `icon`, `idfile`, `itemclass`, `itemtype`,
`loregroup`, `magic`, `material`, `nodrop`, `norent`, `pendingloreflag`, `tradeskills`, `classes`, `races`, `reclevel`, `recskill`, `reqlevel`,
`size`, `slots`, `weight`, `attuneable`, `nopet`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `expendablearrow`,
`bagsize`, `bagslots`, `bagtype`, `bagwr`, `price`, `ldonprice`, `ldontheme`, `ldonsold`, `sellrate`, `favor`, `guildfavor`, `pointtype`,
`ldonsellbackrate`, `deity`, `light`, `updated`, `comment`, `serialized`, `verified`, `serialization`, `source`, `evolvinglevel`, `created`,
`scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `scrollname`, `astr`, `heroic_str`, `adex`, `heroic_dex`, `asta`, `heroic_sta`,
`aagi`, `heroic_agi`, `acha`, `heroic_cha`, `awis`, `heroic_wis`, `aint`, `heroic_int`, `cr`, `heroic_cr`, `fr`, `heroic_fr`, `dr`, `heroic_dr`,
`mr`, `heroic_mr`, `pr`, `heroic_pr`, `svcorruption`, `heroic_svcorrup`, `accuracy`, `avoidance`, `dotshielding`, `shielding`, `spellshield`,
`strikethrough`, `stunresist`, `dsmitigation`, `healamt`, `clairvoyance`, `attack`, `combateffects`, `damageshield`, `endur`, `hp`, `regen`,
`mana`, `manaregen`, `enduranceregen`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `extradmgskill`,
`extradmgamt`, `damage`, `delay`, `elemdmgtype`, `elemdmgamt`, `haste`, `range`, `spelldmg`, `backstabdmg`, `augrestrict`,
`augslot1type`, `augslot1visible`, `augslot2type`, `augslot2visible`, `augslot3type`, `augslot3visible`, `augslot4type`, `augslot4visible`,
`augslot5type`, `augslot5visible`, `augtype`, `augdistiller`, `augslot1unk2`, `augslot2unk2`, `augslot3unk2`, `augslot4unk2`,
`augslot5unk2`, `casttime`, `casttime_`, `clicktype`, `clicklevel2`, `focuseffect`, `clicklevel`, `maxcharges`, `procrate`, `clickeffect`,
`recastdelay`, `recasttype`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`,
`focustype`, `focuslevel2`, `focuslevel`, `clickname`, `procname`, `wornname`, `focusname`, `bardeffect`, `bardeffecttype`,
`factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `bardtype`,
`bardvalue`, `book`, `charmfile`, `charmfileid`, `color`, `filename`, `skillmodtype`, `skillmodvalue`, `summonedflag`, `UNK012`, `UNK013`,
`benefitflag`, `UNK054`, `UNK059`, `booktype`, `UNK123`, `UNK124`, `UNK127`, `UNK134`, `UNK137`, `UNK142`, `UNK147`, `UNK152`,
`UNK157`, `UNK033`) VALUES ('Al\'Kabor\'s Pestle', 'Oversized grinding power for really tough jobs', '122463', '0', '0', '0', '3109', 'IT11685', '0',
'3', '-1', '1', '0', '1', '1', '0', '0', '16841', '65515', '90', '0', '87', '2', '24576', '11', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '6743',
'6743', '0', '70', '0', '3', '2011-12-17 08:41:58', '', '0000-00-00 00:00:00', '2011-06-27 21:18:57', '', '13THFLOOR', '0', '2011-01-23 11:06:01',
'-1', '0', '0', '0', '', '50', '0', '30', '0', '42', '0', '13', '0', '18', '0', '21', '0', '15', '0', '26', '0', '33', '0', '28', '0', '46', '0', '41', '0', '23', '0', '5', '5', '3', '3', '4',
'5', '3', '3', '21', '38', '60', '6', '3', '1926', '2004', '2', '1926', '3', '0', '0', '0', '0', '25', '0', '0', '102', '24', '0', '0', '0', '0', '11', '0', '0', '8', '1', '0', '1', '0',
'1', '0', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '-1', '0', '0', '17854', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '', '', '', '', '-1',
'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '4278190080', '', '-1', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0');

[Akkadius]

Here's another snippet:

http://i.imgur.com/Z3tRm.jpg

I'd like to hear some thoughts as I will most likely need help getting a library of information for this tool as I would like to get images of all of the races in EverQuest so it can be provided in an NPC editor as well.

It wouldn't be very hard to get quick reference tools to look up Races and their numbers with a visual mosaic of NPC races and things like that will cut down development time in half if not more depending on the monotonous task.

For the NPC editor I want to be able to build definitions for NPC's so you can scale a group of selected NPC's in a zone by solo, group, raid and/or by level and intuitively change their fields with graphical references like you see in the item editor.

(I'm just spewing at the mouth at this point)

What I also wanted to build for the NPC editor was a way to flexibly build templates for NPC's. So if you wanted to build a scaling template for a zone, you could go in your NPC template and build scaling definitions based on a zone and it will scale based on the level of the NPC.

It has also gone through my mind to build templates for NPC's say if you wanted to make a Merchant NPC or a Raid NPC, you would save the fields that are commonly associated with that NPC such as special attacks that you have set before, appearances, size and things of that nature so that you do not have to spend time performing redundant tasks of the past.

----------------

As I am still working on the item editor, I will follow up with an actual live demo here shortly. My schedule is quite packed and yesterday is the first day in a few weeks that I have had to even look at it. It won't take very long to finish it up and Trevius and I can discuss getting it out to the SVN that we have built for the AllaClone and start developing onto it as we go along.

This is not to step on any other editor but provide an interface tailored towards custom development and cutting development tasks down by fractions of the typical time it takes to do anything.

I'm missing quite a few things but maybe this will at least fill everyone in on what we've been working towards.

If anyone has any questions or thoughts please fire away.

Thanks,
~Akkadius

[wolfwalkereci]

This is looking pretty cool and I am excited by this post of yours.
Cant wait for it to be ready for public consumption.

[chrsschb]

http://www.seriousbirdhunting.com/wp-content/uploads/2011/03/Homer_drool.jpg

[Akkadius]

Here are a few links of some items for those who want to tool around with this and get a feel with what is done so far.

Keep in mind that there is an entire interface that precedes this window that is not going to be revealed quite yet, I've opened up the Item editor so it requires no authentication.

Also keep in mind that the layout is definitely not final and I'm still working on adding small editors to individual fields, I have about a dozen or so more to go for spell effect selection, scroll selection, augmentation distillers, augmentation types, slots, races as well as a few others I'm missing right now.

I will also be rearranging the way some fields lay out for ease of visual navigation by grouping 'like' fields. The entire form is dynamically generated so I have to do a little bit to work around that and still keep it flexible.

Things to be added:


Toggling music and sound effects (easy)
Automatic scaling of an entire item based on definitions
Modular editing, this means that only fields and sections relevant to the item you are editing will show. For example, in the menu that preceds this interface, if you wanted to create a new item it will ask you what item type you would like to produce (Tradeskill, Quest Item, Bag, Weapon, Jewelery etc.), only fields relevant to that item type will show in the editor to reduce the overwhelming aspect of how large the editor is


http://69.168.254.244/eoc/AllaClone/eoc/extitems.php?EditItem=121351
http://69.168.254.244/eoc/AllaClone/eoc/extitems.php?EditItem=129097
http://69.168.254.244/eoc/AllaClone/eoc/extitems.php?EditItem=122260
http://69.168.254.244/eoc/AllaClone/eoc/extitems.php?EditItem=111866

Let me know if you have questions. Also, do not be afraid to break anything, this is completely tied to an irrelevant test database comprised of one of PEQ's most recent DB dumps.

[xinu]

Very nice i really like what you have done so far. When i first heard the music first thing that popped into my mind was Ultima Online :-D

[Akkadius]

Got quite a few things done tonight. One of these things include child window handling for spell searches.

Here is a very visual spell search and selector that automatically updates the 'View' fields with the tooltip information on mouse over to view the spell information:

Check out the live tool here as shown in previous post:

http://69.168.254.244/eoc/AllaClone/eoc/extitems.php?EditItem=122463

http://i.imgur.com/Nmw8Z.png

Class selection was also added as well as grabbing a free item ID from the items table. We'll see how much more I can get done tonight.

[chrsschb]

Any updates to AllaClone or the new editor?

Would still like to get the AC update that let's me use lootlinks and I still can't get the blue theme to work =/

[Tabasco]

I did some work with the quest parser and should have a more functional script as well as fresher pre-made quest includes.

I mostly just added the missing functions and methods as I found them but some of the quests require formatting changes. That diff is here: http://dungeoncrawl.us.to/quests.diff.txt

The allaclone modifications for quests are here:
http://dungeoncrawl.us.to/allaquests.tar.gz

[Akkadius]

Just so people know. I've picked work back up on this. I intended on people being able to use it remotely without having to install it.

Yes, this will require you to enter in DB info which will be done on the fly.

Should see something sometime soon that is usable.

I will start by having the Item editor publicly usable, will be a centralized hosted solution for now.

[rhyotte]

I almost can not believe I will not be required to use Windows to make edits! Oh, it says Apple Quicktime required. I don't suppose there is a more OS neutral solution? I would very much love to dump windows once and for all. I just do not care for the direction windows is going.

In other news Valve seems to be making a big push into linux, perhaps putting together something that is Ubuntu friendly for Client and Server sides could become workable at some point?

Really love what you guys are doing, this is going to make customizing so much easier.

Sincerely thank all of you!
P.S. Ubuntu would not personally be my first linux choice, I prefer Fedora or CentOS depending. I only said Ubuntu because there seems to be so much momentum building behind it at the moment.

[Akkadius]

To keep people in the loop, got some things done. Cleaned up a lot of descriptions and made a lot of other background changes to start making it able to be pointed towards another users database. You will be able to define your server information, create users and give them permissions particular to your server. I want make it so that you can store that info and use the AllaClone all based on what you have stored. It will be designed so that it will ask you about creating a user that can read only on all of the informational tables.

As EoC was intended to have many more tools available that are interconnected, visual, easy to use and that cut down development time any way possible. Trevius and I got hit by the D3 bug quite a while ago in the middle of this, but I quit some time ago and he just had another kid.

To see the item editor itself and play with it, here is a link:

http://69.168.254.244/AllaClone/eoc/extitems.php?EditItem=111821

Immediate Roadmap:

Automatic Item Scaling (AJAX Method)
Finish up editor tools for races
Finish up diety selector
Aug Type Distiller Selector
Aug Type selector
Min-Max function on Type 2 stats
Min-Max on Type 3
Icon 'Type' selector, so you can select say 'Helm' or 'Sword' and it will prepopulate icon to more easily select icons
Weapon Graphic Type Selector (Similar to above)
Faction selectors
Change the layout a bit


General Roadmap:
- Currently, I don't really like the layout. It should be tabular and the fields should be bigger and easier to see given it is tabular. But people should be used to the layout as it is right now. I'm going to get this functional so it can start being usable and then knock out some other tools. Though the majority of this was done in a few weekends a few months ago, it was still a pretty massive undertaking compared to say a weenie Task Editor.

http://i.imgur.com/XEsLL.png
http://i.imgur.com/QrcGV.png

[Wisperin]

I did some work with the quest parser and should have a more functional script as well as fresher pre-made quest includes.

I mostly just added the missing functions and methods as I found them but some of the quests require formatting changes. That diff is here: http://dungeoncrawl.us.to/quests.diff.txt

The allaclone modifications for quests are here:
http://dungeoncrawl.us.to/allaquests.tar.gz

I know I'm missing something simple with this. I've been trying for a couple of days to figure it out with no luck. I've got it working to the point where it will list the NPC quests within a zone but when i try to view the quest I just get a blank white page. Anyone have any tips?

[Warking]

The EoC is exactly what I am looking for to help customize my server. Will there be a download release anytime?

[trevius]

Well, soon is a relative term, but I am sure we will have something ready at some point. Both Akka and I have been pretty busy IRL lately, so work has slowed down considerably. I have recently started working on EOC again and am currently making good progress on the tasks tool, but it still has a ways to go before being completed. The good part is that I am working out some solid systems that should be usable for the rest of the tools we make for it, so once tasks are done the rest should be a bit quicker.

There is definitely no kind of ETA at this point. Even on the tools that have been worked on, there is plenty left to do. And, there are a lot of tools that need to be added such as NPC editing, tradeskill editing, etc.

I will have to see what Akkadius thinks about giving out a generic username and password for our EOC dev box so people can check in on the progress so far. We have a basic login system created for it, so the tools require authentication. Once logged in, you would be able to see the tools we have enabled so far and play around with them.

[Akkadius]

If people want, there's no reason why I can't be given Mysql information in a PM and then hard-code it to a login in the meantime. You Mysql connection needs to be view-able from the outside world.

Just keep in mind you'd be using it on a completely BETA basis and only the item editor is really functional at this point.

[Tdayin]

Hello all, I have started altering the alla clone to suit my specific needs. It can be seen here http://tdayinsrealm.herobo.com/index.php, needless to say a lot of it does not work on this host, i am still trying to figure out the best way to upload the database. It is a free host so it has a lot of restrictions. All the links work including the guild related ones like listing guilds, members and guild bank contents. You can create accounts from here as well and it even has a small forum for items, zones, trade-skill pages, npc's and guilds. All of the "new" features can but turned on or off with the config.php and just as soon as I figure out how to source a database that is very large into a connection that only allows 5mb, it will be a working copy. I started writing this for my offline server and decided to share what I have made so far. All credit goes to the guys that have made the alla clone in the past, my hat is off you you guys. please let me know what you think or if you can even use any of this in what you are working on now.

Thanks,
Tdayin

[Tdayin]

I threw this up on a different host, everything should work now. There are still a few things that don't work properly and again this is due to the host, I had to manually source the whole database by copy pasting the sql. I missed a few things I am sure. I have to go to work now so I will work on it when I get home.

http://tdayin.p.ht/

[Tabasco]

How are things going with this? I notice the editor demo link is no longer available.

If there's work to be done, pm me an svn link. I'm also curious about how you would like to license your images. I know a lot of work went into capturing them, but they could be really useful in a lot of places.

[Akkadius]

How are things going with this? I notice the editor demo link is no longer available.

If there's work to be done, pm me an svn link. I'm also curious about how you would like to license your images. I know a lot of work went into capturing them, but they could be really useful in a lot of places.

Get in coders and I can show you a link, I need to finish something up before releasing it. Been so damn busy and that is no joke.

[Kingmen30264]

I got a question about this. I wasn't entirely sure where this should have been posted, but here is my question.

I have my Apache Server running with PHP as well. However, when I load the page using either /localhost/AllaClone , 10.0.0.158/AllaClone , 127.0.0.1/AllaClone, etc, the only page that seems to be popping up is the Parent Directory listing the entirety of the folders' contents.

I really love the way snippets relay the intensity of the program/webpage and would love to get it working for my database as well.

Thanks for any future responses,
~Kingmen

[trevius]

Sounds like what happens when PHP (and/or maybe Apache) isn't installed or running. Since you said they are, I am not sure what the problem is offhand. Are you running it on Windows or Linux?

[Kingmen30264]

Sounds like what happens when PHP (and/or maybe Apache) isn't installed or running. Since you said they are, I am not sure what the problem is offhand. Are you running it on Windows or Linux?

Windows 7 Oracle VM VirtualBox

Just to be sure that PHP is running, how would I check that? Through Services?

Apache is running as I can see the monitor program in my tray.

Thanks,
~Kingmen

[Kingmen30264]

I got it.

What I did was I installed the entire package onto my Ubuntu VM and then just I just changed the config options to reflect my EQ VM and allowed permissions for anyone on my network (only) to access the AllaClone.

Here is a Screenshot of it working. I will just need to edit the following files with HTML code and make it look purty lol.

http://i215.photobucket.com/albums/cc160/kingmen30264/WorkingAllaClone.jpg
http://i215.photobucket.com/albums/cc160/kingmen30264/WorkingAllaClone.jpg

For some reason it will show up properly for my Ubuntu but for my Windows VM, it is not showing the proper background. Something I will have to figure out myself, but I just wanted to post that I got this working.

Thanks for the response Trevius.

[Kingmen30264]

I have it up and running just fine. I even solved the issue of the white background (I had to replace all of http://mysite.com/blahblah to my ip), but when I am trying to figure out how to set the date on the News Page, it shows 1101300277 which translates to November 24, 2004. If I put 02242013 it says it is January 26, 1970.

How do I know what number to put for the date?

~Kingmen

[trevius]

I don't think we messed with the news page, but that number you are referring to is a unix timestamp. You can do the conversions for that here:

http://www.unixtimestamp.com/index.php

[MisifuWiki]

where i can download this nice thing ??

[Rhodan]

Is this still current? When I go to download from the repo it says it's depricated. Maybe there's a new spot for downloading?

[Rhodan]

Well I had a look and its more than obvious this version has been abandoned. The demo page has a working version so perhaps it's just the link that points at an old version but I can't see any mention of SVN or GIT sources so I'm assuming it has gone private.

I have most of it working after replacing PHP_SELF with '' (forms) or actual page names (for hrefs) since PHP_SELF has been removed from PHP.

Changing a few field names got several more parts working.

Adding extra definitions in constantes.php to make them current fixed most of the rest.

On more error for pets was fixed by changing the "ac" index name to "AC"

I'm stuck on show zones by level (zoneslevels.php I think it's called). An array is created something like this:

zones = array();
zones[$cpt][$lvl]=0;
zones[$spt]["npcs"]=0;

Then later on values are assigned which generates unknown index errors. I have a feeling PHP doesn't like this kind of array declaration any more. Have to read up on PHP a bunch... Haven't played with it since PHP3 really.

[Akkadius]

Well I had a look and its more than obvious this version has been abandoned. The demo page has a working version so perhaps it's just the link that points at an old version but I can't see any mention of SVN or GIT sources so I'm assuming it has gone private.

I have most of it working after replacing PHP_SELF with '' (forms) or actual page names (for hrefs) since PHP_SELF has been removed from PHP.

Changing a few field names got several more parts working.

Adding extra definitions in constantes.php to make them current fixed most of the rest.

On more error for pets was fixed by changing the "ac" index name to "AC"

I'm stuck on show zones by level (zoneslevels.php I think it's called). An array is created something like this:

zones = array();
zones[$cpt][$lvl]=0;
zones[$spt]["npcs"]=0;

Then later on values are assigned which generates unknown index errors. I have a feeling PHP doesn't like this kind of array declaration any more. Have to read up on PHP a bunch... Haven't played with it since PHP3 really.

Trevius and I were working on this.

I will have to dig up what is going on with what and see if I can get you a recent link and possibly see about other details.

[Rhodan]

Well here's what I did to get the majority of the pages working. Still errors left over, particularly in zones by level which I haven't figured out at all.


Changes to AllaClone2

advnpcs.php
replace action=$PHP_SELF with action=''

config.php
add $MaxFactionsReturned=50;

constantes.php

add $cfgversion="" around line 5. Cant find anyplace that sets cfgversion anyway.
add $dbskills[74]='FRENZY';
$dbskills[98]='UNKNOWN'; lots of test only spells with odd numbers in the db
Change

Replace entire spell targets list - its easier than editing
// spell targets
$dbspelltargets=array();
$dbspelltargets[0]="Rag'Zhezum Special";
$dbspelltargets[1]="Line of Sight";
$dbspelltargets[2]="";
$dbspelltargets[3]="Group V1";
$dbspelltargets[4]="Point Blank Area of effect";
$dbspelltargets[5]="Single target";
$dbspelltargets[6]="Self only";
$dbspelltargets[8]="Targetted Area of effect";
$dbspelltargets[9]="Animal";
$dbspelltargets[10]="Undead only";
$dbspelltargets[11]="Summoned beings";
$dbspelltargets[13]="Life Tap";
$dbspelltargets[14]="Caster's pet";
$dbspelltargets[15]="Target's corpse";
$dbspelltargets[16]="Plant";
$dbspelltargets[17]="Giant";
$dbspelltargets[18]="Dragon";
$dbspelltargets[20]="Targetted Area of Effect Life Tap";
$dbspelltargets[24]="Area of effect on undeads";
$dbspelltargets[25]="Area of Effect Summoned";
$dbspelltargets[32]="Area of Effect Caster";
$dbspelltargets[33]="NPC Hate List";
$dbspelltargets[34]="Dungeon Object";
$dbspelltargets[35]="Muramite";
$dbspelltargets[36]="Area - PC Only";
$dbspelltargets[37]="Area - NPC Only";
$dbspelltargets[38]="Summoned Pet";
$dbspelltargets[39]="Group No Pets";
$dbspelltargets[40]="Area of Effect PC V2";
$dbspelltargets[41]="Group V2";
$dbspelltargets[42]="Self (Directional)";
$dbspelltargets[43]="Group with Pets";
$dbspelltargets[44]="Beam";

item.php
line 34 change
$name=$ItemRow["name"]; to
$name=$ItemRow["Name"];

items.php
search and replace iavailevel with iavaillevel

line 74 change
action='".$PHP_SELF."' to
action=''

faction.php

for people not using peqeditor
replace
print " <a href='".$peqeditor_url."index.php?editor=faction&amp;fid=".$id."'><img src='".$images_url."/peq_faction.png' align='right'/></a>\n";
with
if (isset($peqeditor_url)) {
print " <a href='".$peqeditor_url."index.php?editor=faction&amp;fid=".$id."'><img src='".$images_url."/peq_faction.png' align='right'/></a>\n";
}


factions.php
search and replace
<form method='GET' action='".$PHP_SELF."'>\n";
<form method='GET' action=''>\n";

functions.php

not all arguments supplied for function PrintQueryResults() so make the last three optional by
supplying a value yourself, start at $ExtraField
$NameAttribute, $ExtraField="", $ExtraFieldDescription="", $ExtraSkill="")

v$ and $res not defined errors, add $v=$res=""; in getslots(), getclasses() and gettraces()
before loop starts. Also change $Result to $res in getslots() for consistency

in function Price($price)
change
$res=""; to
$res=$p=$g=$s=$sep="";

loreflag replaced by loregroup and values now range -1 - 1 with 0 being not lore so change
if($item["loreflag"] == 1) { $html_string .= "$v LORE ITEM"; $v = " "; } to
if($item["loregroup"] != 0) { $html_string .= "$v LORE ITEM"; $v = " "; }

change
function GetItemStatsString($name,$stat,$stat2,$stat2color) { to
function GetItemStatsString($name,$stat,$stat2=0,$stat2colo r=0) {
This makes the last two arguments optional with defaults of 0
in BuildItemStats()
change
global $dbitypes, $dam2h, $dbbagtypes, $dbskills, $icons_url, $tbspells, $dbiaugrestrict, $dbiracenames;
global $dbitypes, $dam2h, $dbbagtypes, $dbskills, $icons_url, $tbspells, $dbiaugrestrict, $dbiracenames, $dbelements, $dbbodytypes;
and
$html_string .= GetItemStatsString("Haste",$item["haste"."%"]); to
$html_string .= GetItemStatsString("Haste",$item["haste"]);

npc.php
wrap peqeditor_url stuff in isset thus:
if (isset($peqeditor_url)) {
print "<a href='".$peqeditor_url."index.php?editor=npc&amp;npcid=".$id."'><img src='".$images_url."/peq_npc.png' align='right'/></a>";
print "<a href='".$peqeditor_url."index.php?editor=merchant&amp;npcid=".$id."'><img src='".$images_url."/peq_merchant.png' align='right'/></a>";
}

npcs.php
replace action='".$PHP_SELF."'
with action=''

pets.php
replace href=$PHP_SELF
with href=pets.php

replace $row["ac"]
with $row["AC"]

recipies.php

replace action=$PHP_SELF
with action=''

spawngroup.php
search and replace
a href=$PHP_SELF?
with
a href=spawngroup.php?
spell.php
change
$dbspellresists[$spell["resist"]]
$dbspellresists[$spell["resisttype"]]

zone.php
search and replace "minimum_level" with "min_level"
search and replace href=$PHP_SELF with href=zone.php

[jcarmony]

Any update on this? I tried the above, still get lots of errors. Is it possible to get ver 2.0 Rev 2099?

[Akkadius]

Any update on this? I tried the above, still get lots of errors. Is it possible to get ver 2.0 Rev 2099?

I'm working on several large projects. No ETA yet but I have this on my list.

[Shin Noir]

I'm making a tool list, some questions I'm not fully sure:
Is this opensource? If so, where at?
I see a link to PEQ's SVN to download on first topic, is that the latest download copy?
Is there a website dedicated to this tool?

Thanks!

[Greyhelm]

Figured out the errors in npc.php at lines 95 and 96.

Using IIs 8.5/Mysql 5.6.21/PHP5.5.19

Base directory C:/intepub/wwwroot/
peqphpeditor C:/inetpub/wwwroot/phpeditor/
allaclone C:/inetpub/wwwroot/allaclone/

Add to config.php
$peqeditor_url="http://localhost/phpeditor/";

if this is way late in the game apologies I am learning php while playing around with these tools. Cheers

[Greyhelm]

add $cfgversion="" around line 5. Cant find anyplace that sets cfgversion anyway.

Config.php sets this on line 5. $cfgversion='2.0.1 - Rev2103';

Now I cannot find anything that fills constantes.php line 3 $version=""; so I changed it to query my PEQ database db_version.version and chaged cfgversion to my database version to not throw the error.

[blindaviator]

If anyone is still interested in Allaclone I have been cleaning up the latest version I could find (v2.0.1 - Rev2103) and I have managed to get everything but the Zones by Level working so far (at least I haven't found any issues I missed yet).

I pieced together the changes posted by Rhodan and a lot of tedious bug fixes I could find. I updated all the SQL queries to use the latest MYSQLI instead of the old, phased out, MYSQL (requires MySql v5+)...

I will keep working on it and try to get the Zones by Level working. It keeps giving me a "Undefined offset" error for all the zones that will need to be cleaned up.

If anyone is interested in it let me know and I can send it to you...

[Akkadius]

http://peqtgc.com/EQEmuAllakhazam/?a=recipes&

https://github.com/Akkadius/EQEmuAllakhazamClone

I started doing a clean up myself and got a ton done, when I moved I never picked it back up

[blindaviator]

http://peqtgc.com/EQEmuAllakhazam/?a=recipes&

https://github.com/Akkadius/EQEmuAllakhazamClone

I started doing a clean up myself and got a ton done, when I moved I never picked it back up

Thanks I like a lot of the improvements you have in that version...

Anything you can remember on it that needs updating or improved??

[Toony]

Sorry for necro'ing but, I've got this updated version installed and everything but the "Zones by Level" link seems functional. Is there something special I need to do to get Zones by Level working?