|  |  | 
 
  |  |  |  |  
  |  |  |  |  
  |  |  |  |  
  |  |  |  |  
  |  | 
	
		
   
   
      | Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...) |  
	
	
		
	
	
	| 
			
			 
			
				05-14-2013, 07:11 PM
			
			
			
		 |  
	| 
		
			
			| Sarnak |  | 
					Join Date: Sep 2007 
						Posts: 33
					      |  |  
	| 
 where i can download this nice thing ?? |  
	
		
	
	
	| 
			
			 
			
				05-10-2014, 09:33 AM
			
			
			
		 |  
	| 
		
			
			| Hill Giant |  | 
					Join Date: Oct 2006 
						Posts: 179
					      |  |  
	| 
 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? |  
	
		
	
	
 
  |  |  |  |  
	| 
			
			 
			
				05-15-2014, 05:22 PM
			
			
			
		 |  
	| 
		
			
			| Hill Giant |  | 
					Join Date: Oct 2006 
						Posts: 179
					      |  |  
	| 
				  
 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.
 
			
			
			
			
				  |  
 
  |  |  |  |  
	
		
	
	
 
  |  |  |  |  
	| 
			
			 
			
				05-15-2014, 05:30 PM
			
			
			
		 |  
	| 
		
			|  | Administrator |  | 
					Join Date: Feb 2009 Location: MN 
						Posts: 2,072
					      |  |  
	| 
				  
 
	Quote: 
	
		| 
					Originally Posted by 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.
 |  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.
			
			
			
			
				  |  
 
  |  |  |  |  
	
		
	
	
 
  |  |  |  |  
	| 
			
			 
			
				05-16-2014, 02:39 PM
			
			
			
		 |  
	| 
		
			
			| Hill Giant |  | 
					Join Date: Oct 2006 
						Posts: 179
					      |  |  
	| 
				  
 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. 
	Code: 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&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&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,$stat2color=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&npcid=".$id."'><img src='".$images_url."/peq_npc.png' align='right'/></a>";
		print "<a href='".$peqeditor_url."index.php?editor=merchant&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
			
			
			
			
				  |  
 
  |  |  |  |  
	
		
	
	
	| 
			
			 
			
				07-14-2014, 07:16 PM
			
			
			
		 |  
	| 
		
			
			| Fire Beetle |  | 
					Join Date: Apr 2013 
						Posts: 7
					      |  |  
	| 
 Any update on this? I tried the above, still get lots of errors. Is it possible to get ver 2.0 Rev 2099? |  
	
		
	
	
	| 
			
			 
			
				07-14-2014, 10:23 PM
			
			
			
		 |  
	| 
		
			|  | Administrator |  | 
					Join Date: Feb 2009 Location: MN 
						Posts: 2,072
					      |  |  
	| 
 
	Quote: 
	
		| 
					Originally Posted by jcarmony  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. |  
	
		
	
	
	| 
			
			 
			
				08-14-2014, 06:35 PM
			
			
			
		 |  
	| 
		
			|  | Legendary Member |  | 
					Join Date: Apr 2002 Location: Seattle, WA 
						Posts: 506
					      |  |  
	| 
 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!
 |  
	
		
	
	
	| 
			
			 
			
				01-15-2015, 05:37 AM
			
			
			
		 |  
	| 
		
			|  | Sarnak |  | 
					Join Date: Jul 2009 Location: East Coast 
						Posts: 35
					      |  |  
	| 
				 Allaclone 2.0 x-link to peqphpedtor 
 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 
 
	Code: $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 |  
	
		
	
	
	| 
			
			 
			
				01-15-2015, 05:44 AM
			
			
			
		 |  
	| 
		
			|  | Sarnak |  | 
					Join Date: Jul 2009 Location: East Coast 
						Posts: 35
					      |  |  
	| 
 
	Quote: 
	
		| 
					Originally Posted by Rhodan   around line 5. Cant find anyplace that sets cfgversion anyway. |  Config.php sets this on line 5.  
	Code:  $cfgversion='2.0.1 - Rev2103'; Now I cannot find anything that fills constantes.php line 3   so I changed it to query my PEQ database  db_version.version and chaged cfgversion to my database version to not throw the error. |  
	
		
	
	
	| 
			
			 
			
				08-02-2017, 10:03 AM
			
			
			
		 |  
	| 
		
			
			| Sarnak |  | 
					Join Date: Jul 2010 
						Posts: 61
					      |  |  
	| 
 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...
 |  
	
		
	
	
	| 
			
			 
			
				08-02-2017, 04:23 PM
			
			
			
		 |  
	| 
		
			
			| Sarnak |  | 
					Join Date: Jul 2010 
						Posts: 61
					      |  |  
	| 
 
	Quote: 
	
		| 
					Originally Posted by Akkadius   |  Thanks I like a lot of the improvements you have in that version...
 
Anything you can remember on it that needs updating or improved?? |  
	
		
	
	
	| 
			
			 
			
				08-07-2019, 06:46 PM
			
			
			
		 |  
	| 
		
			|  | Sarnak |  | 
					Join Date: Jul 2009 Location: USA 
						Posts: 89
					      |  |  
	| 
 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? |  
	
		
	
	
	
	
	| 
	|  Posting Rules |  
	| 
		
		You may not post new threads You may not post replies You may not post attachments You may not edit your posts 
 HTML code is Off 
 |  |  |  All times are GMT -4. The time now is 05:39 AM.
 
 |  |  
    |  |  |  |  
    |  |  |  |  
     |  |  |  |  
 |  |