Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools
Reload this Page EQ Browser /Allakhazam

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2012, 03:20 PM
pheroux
Fire Beetle
  
Join Date: Jan 2012
Posts: 27
Default EQ Browser /Allakhazam
Hi,

I am trying to setup EQ Browser /Allakhazam for my server.

I'm following the steps in the readme but I get the below error on step 4 source spells.sql?

ERROR
Code:
mysql> source spells.sql
Query OK, 0 rows affected, 1 warning (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
 for the right syntax to use near 'range int(11) NOT NULL default '0',
  aoerange int(11) NOT NULL default '0',
  m' at line 7
README.TXT

Code:
INSTALL

** The easy part :
1- Rename includes/config.php.dist to includes/config.php
2- Edit and configure includes/config.php

** The hard part :
3- Go to the includes/sql directory
4- Source races.sql and spells.sql to your eq database
5- Source news.sql if you want to enable News support (see includes/config.php)
6- Source quests.sql if you want to display quests in the browser (0.5.2+)
if you have Perl::DBI
7- Copy spells_us.txt from your Everquest client directory to the includes/sql directory
8- Edit and run "perl import_spells.pl", this will extract the spells from spells_us.txt and source 
them to your the table you created 2 steps before
9- If you don't have perl::DBI, source allspells.sql
SPELLS.SQL

Code:
#- MySQL dump 8.22
#-
#- Host: localhost    Database: eqclassic
#--------------------------------------------------------
#- Server version	4.0.18

#-
#- Table structure for table 'spells'
#-
DROP TABLE IF EXISTS spells;
CREATE TABLE spells (
  spellid int(11) NOT NULL default '0',
  name varchar(64) NOT NULL default '',
  castonyou varchar(120) NOT NULL default '',
  castonother varchar(120) NOT NULL default '',
  fading varchar(120) NOT NULL default '',
  range int(11) NOT NULL default '0',
  aoerange int(11) NOT NULL default '0',
  mana int(11) NOT NULL default '0',
  casttime int(11) NOT NULL default '0',
  recoverytime int(11) NOT NULL default '0',
  recasttime int(11) NOT NULL default '0',
  buffformula int(11) NOT NULL default '0',
  buffduration int(11) NOT NULL default '0',
  aoeduration int(11) NOT NULL default '0',
  targettype int(11) NOT NULL default '0',
  petname varchar(32) NOT NULL default '',
  resist int(11) NOT NULL default '0',
  resist_adjust int(11) NOT NULL default '0',
  skill int(11) NOT NULL default '0',
  buff1 int(11) NOT NULL default '0',
  buff1val int(11) NOT NULL default '0',
  buff2 int(11) NOT NULL default '0',
  buff2val int(11) NOT NULL default '0',
  buff3 int(11) NOT NULL default '0',
  buff3val int(11) NOT NULL default '0',
  buff4 int(11) NOT NULL default '0',
  buff4val int(11) NOT NULL default '0',
  buff5 int(11) NOT NULL default '0',
  buff5val int(11) NOT NULL default '0',
  buff6 int(11) NOT NULL default '0',
  buff6val int(11) NOT NULL default '0',
  buff7 int(11) NOT NULL default '0',
  buff7val int(11) NOT NULL default '0',
  buff8 int(11) NOT NULL default '0',
  buff8val int(11) NOT NULL default '0',
  buff9 int(11) NOT NULL default '0',
  buff9val int(11) NOT NULL default '0',
  buff10 int(11) NOT NULL default '0',
  buff10val int(11) NOT NULL default '0',
  buff11 int(11) NOT NULL default '0',
  buff11val int(11) NOT NULL default '0',
  buff12 int(11) NOT NULL default '0',
  buff12val int(11) NOT NULL default '0',
  buff1form int(11) NOT NULL default '0',
  buff2form int(11) NOT NULL default '0',
  buff3form int(11) NOT NULL default '0',
  buff4form int(11) NOT NULL default '0',
  buff5form int(11) NOT NULL default '0',
  buff6form int(11) NOT NULL default '0',
  buff7form int(11) NOT NULL default '0',
  buff8form int(11) NOT NULL default '0',
  buff9form int(11) NOT NULL default '0',
  buff10form int(11) NOT NULL default '0',
  buff11form int(11) NOT NULL default '0',
  buff12form int(11) NOT NULL default '0',
  buff1max int(11) NOT NULL default '0',
  buff2max int(11) NOT NULL default '0',
  buff3max int(11) NOT NULL default '0',
  buff4max int(11) NOT NULL default '0',
  buff5max int(11) NOT NULL default '0',
  buff6max int(11) NOT NULL default '0',
  buff7max int(11) NOT NULL default '0',
  buff8max int(11) NOT NULL default '0',
  buff9max int(11) NOT NULL default '0',
  buff10max int(11) NOT NULL default '0',
  buff11max int(11) NOT NULL default '0',
  buff12max int(11) NOT NULL default '0',
  level1 int(4) NOT NULL default '0',
  level2 int(4) NOT NULL default '0',
  level3 int(4) NOT NULL default '0',
  level4 int(4) NOT NULL default '0',
  level5 int(4) NOT NULL default '0',
  level6 int(4) NOT NULL default '0',
  level7 int(4) NOT NULL default '0',
  level8 int(4) NOT NULL default '0',
  level9 int(4) NOT NULL default '0',
  level10 int(4) NOT NULL default '0',
  level11 int(4) NOT NULL default '0',
  level12 int(4) NOT NULL default '0',
  level13 int(4) NOT NULL default '0',
  level14 int(4) NOT NULL default '0',
  level15 int(4) NOT NULL default '0',
  level16 int(4) NOT NULL default '0',
  regent1_id int(11) NOT NULL default '0',
  regent1_count int(11) NOT NULL default '0',
  regent2_id int(11) NOT NULL default '0',
  regent2_count int(11) NOT NULL default '0',
  regent3_id int(11) NOT NULL default '0',
  regent3_count int(11) NOT NULL default '0',
  regent4_id int(11) NOT NULL default '0',
  regent4_count int(11) NOT NULL default '0',
  timeofday int(11) NOT NULL default '0',
  UNIQUE KEY spellid (spellid)
) TYPE=MyISAM;
Thank you,

Phil
Reply With Quote
  #2  
Old 02-05-2012, 03:23 PM
provocating's Avatar
provocating
Demi-God
  
Join Date: Nov 2007
Posts: 2,175
Default
How are you sourcing it, from the command line or PHPMyAdmin ?

You might try installing HeidiSQL and running from a query window. But forwarning the EQ Browser / Alla tool you are trying to install has not been updated in a long time, and even after it is installed you will have to clean up a lot of problems. The database structure has changed a lot.
Reply With Quote
  #3  
Old 02-05-2012, 03:42 PM
Derision
Developer
  
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default
'range' became a reserved word in MySQL 5.1. You need to edit spells.sql and enclose it in backticks, like this:
Code:
CREATE TABLE spells (
  spellid int(11) NOT NULL default '0',
  name varchar(64) NOT NULL default '',
  castonyou varchar(120) NOT NULL default '',
  castonother varchar(120) NOT NULL default '',
  fading varchar(120) NOT NULL default '',
  `range` int(11) NOT NULL default '0',
  aoerange int(11) NOT NULL default '0',
  mana int(11) NOT NULL default '0',
  casttime int(11) NOT NULL default '0',
  recoverytime int(11) NOT NULL default '0',
  recasttime int(11) NOT NULL default '0',
  buffformula int(11) NOT NULL default '0',
  buffduration int(11) NOT NULL default '0',
  aoeduration int(11) NOT NULL default '0',
  targettype int(11) NOT NULL default '0',
  petname varchar(32) NOT NULL default '',
  resist int(11) NOT NULL default '0',
  resist_adjust int(11) NOT NULL default '0',
  skill int(11) NOT NULL default '0',
  buff1 int(11) NOT NULL default '0',
  buff1val int(11) NOT NULL default '0',
  buff2 int(11) NOT NULL default '0',
  buff2val int(11) NOT NULL default '0',
  buff3 int(11) NOT NULL default '0',
  buff3val int(11) NOT NULL default '0',
  buff4 int(11) NOT NULL default '0',
  buff4val int(11) NOT NULL default '0',
  buff5 int(11) NOT NULL default '0',
  buff5val int(11) NOT NULL default '0',
  buff6 int(11) NOT NULL default '0',
  buff6val int(11) NOT NULL default '0',
  buff7 int(11) NOT NULL default '0',
  buff7val int(11) NOT NULL default '0',
  buff8 int(11) NOT NULL default '0',
  buff8val int(11) NOT NULL default '0',
  buff9 int(11) NOT NULL default '0',
  buff9val int(11) NOT NULL default '0',
  buff10 int(11) NOT NULL default '0',
  buff10val int(11) NOT NULL default '0',
  buff11 int(11) NOT NULL default '0',
  buff11val int(11) NOT NULL default '0',
  buff12 int(11) NOT NULL default '0',
  buff12val int(11) NOT NULL default '0',
  buff1form int(11) NOT NULL default '0',
  buff2form int(11) NOT NULL default '0',
  buff3form int(11) NOT NULL default '0',
  buff4form int(11) NOT NULL default '0',
  buff5form int(11) NOT NULL default '0',
  buff6form int(11) NOT NULL default '0',
  buff7form int(11) NOT NULL default '0',
  buff8form int(11) NOT NULL default '0',
  buff9form int(11) NOT NULL default '0',
  buff10form int(11) NOT NULL default '0',
  buff11form int(11) NOT NULL default '0',
  buff12form int(11) NOT NULL default '0',
  buff1max int(11) NOT NULL default '0',
  buff2max int(11) NOT NULL default '0',
  buff3max int(11) NOT NULL default '0',
  buff4max int(11) NOT NULL default '0',
  buff5max int(11) NOT NULL default '0',
  buff6max int(11) NOT NULL default '0',
  buff7max int(11) NOT NULL default '0',
  buff8max int(11) NOT NULL default '0',
  buff9max int(11) NOT NULL default '0',
  buff10max int(11) NOT NULL default '0',
  buff11max int(11) NOT NULL default '0',
  buff12max int(11) NOT NULL default '0',
  level1 int(4) NOT NULL default '0',
  level2 int(4) NOT NULL default '0',
  level3 int(4) NOT NULL default '0',
  level4 int(4) NOT NULL default '0',
  level5 int(4) NOT NULL default '0',
  level6 int(4) NOT NULL default '0',
  level7 int(4) NOT NULL default '0',
  level8 int(4) NOT NULL default '0',
  level9 int(4) NOT NULL default '0',
  level10 int(4) NOT NULL default '0',
  level11 int(4) NOT NULL default '0',
  level12 int(4) NOT NULL default '0',
  level13 int(4) NOT NULL default '0',
  level14 int(4) NOT NULL default '0',
  level15 int(4) NOT NULL default '0',
  level16 int(4) NOT NULL default '0',
  regent1_id int(11) NOT NULL default '0',
  regent1_count int(11) NOT NULL default '0',
  regent2_id int(11) NOT NULL default '0',
  regent2_count int(11) NOT NULL default '0',
  regent3_id int(11) NOT NULL default '0',
  regent3_count int(11) NOT NULL default '0',
  regent4_id int(11) NOT NULL default '0',
  regent4_count int(11) NOT NULL default '0',
  timeofday int(11) NOT NULL default '0',
  UNIQUE KEY spellid (spellid)
) TYPE=MyISAM;
so MySQL knows not to try and interpret it as a MySQL keyword.
Reply With Quote
  #4  
Old 02-05-2012, 03:45 PM
provocating's Avatar
provocating
Demi-God
  
Join Date: Nov 2007
Posts: 2,175
Default
Yeah the reserve them, and they may never use them....but they reserve them anyway. Same thing happens to me in MS SQL.
Reply With Quote
  #5  
Old 02-05-2012, 06:42 PM
iRFNA
Fire Beetle
  
Join Date: Dec 2009
Posts: 23
Default
Hey, awhile back I made a query to grab stuff from PEQ's (or any EQ db I guess) spells_new table and shove it into spells so that browser thing can use them, since I couldn't get the spells_us.txt importer thing to work. Probably would have been easier to rewrite the PHP, but eh. Might come in useful for you.

Quote:
insert into spells (spellid, name, castonyou, castonother, fading, `range`, aoerange, mana, casttime, recoverytime, recasttime, buffformula, buffduration, aoeduration, targettype, resist, resist_adjust, skill, buff1, buff2, buff3, buff4, buff5, buff6, buff7, buff8, buff9, buff10, buff11, buff12, buff1val, buff2val, buff3val, buff4val, buff5val, buff6val, buff7val, buff8val, buff9val, buff10val, buff11val, buff12val, buff1form, buff2form, buff3form, buff4form, buff5form, buff6form, buff7form, buff8form, buff9form, buff10form, buff11form, buff12form, buff1max, buff2max, buff3max, buff4max, buff5max, buff6max, buff7max, buff8max, buff9max, buff10max, buff11max, buff12max, level1, level2, level3, level4, level5, level6, level7, level8, level9, level10, level11, level12, level13, level14, level15, level16, regent1_id, regent2_id, regent3_id, regent4_id, regent1_count, regent2_count, regent3_count, regent4_count, timeofday)
select spells_new.id, spells_new.name, spells_new.cast_on_you, spells_new.cast_on_other, spells_new.spell_fades, spells_new.`range`, spells_new.aoerange, spells_new.mana, spells_new.cast_time, spells_new.recovery_time, spells_new.recast_time, spells_new.buffdurationformula, spells_new.buffduration, spells_new.AEDuration, spells_new.targettype, spells_new.resisttype, spells_new.ResistDiff, spells_new.skill, spells_new.effectid1, spells_new.effectid2, spells_new.effectid3, spells_new.effectid4, spells_new.effectid5, spells_new.effectid6, spells_new.effectid7, spells_new.effectid8, spells_new.effectid9, spells_new.effectid10, spells_new.effectid11, spells_new.effectid12, spells_new.effect_base_value1, spells_new.effect_base_value2, spells_new.effect_base_value3, spells_new.effect_base_value4, spells_new.effect_base_value5, spells_new.effect_base_value6, spells_new.effect_base_value7, spells_new.effect_base_value8, spells_new.effect_base_value9, spells_new.effect_base_value10, spells_new.effect_base_value11, spells_new.effect_base_value12, spells_new.formula1, spells_new.formula2, spells_new.formula3, spells_new.formula4, spells_new.formula5, spells_new.formula6, spells_new.formula7, spells_new.formula8, spells_new.formula9, spells_new.formula10, spells_new.formula11, spells_new.formula12, spells_new.max1, spells_new.max2, spells_new.max3, spells_new.max4, spells_new.max5, spells_new.max6, spells_new.max7, spells_new.max8, spells_new.max9, spells_new.max10, spells_new.max11, spells_new.max12, spells_new.classes1, spells_new.classes2, spells_new.classes3, spells_new.classes4, spells_new.classes5, spells_new.classes6, spells_new.classes7, spells_new.classes8, spells_new.classes9, spells_new.classes10, spells_new.classes11, spells_new.classes12, spells_new.classes13, spells_new.classes14, spells_new.classes15, spells_new.classes16, spells_new.components1, spells_new.components2, spells_new.components3, spells_new.components4, spells_new.component_counts1, spells_new.component_counts2, spells_new.component_counts3, spells_new.component_counts4, spells_new.TimeOfDay
from spells_new;

update spells, spells_new set spells.petname = spells_new.teleport_zone where spells.spellid = spells_new.id and exists (select * from pets where pets.type = spells_new.teleport_zone);
And sorry for table breaking, dear god that is a long query.
Last edited by trevius; 02-06-2012 at 05:02 AM..
Reply With Quote
  #6  
Old 02-06-2012, 05:08 AM
trevius's Avatar
trevius
Developer
  
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default
Akkadius and I have been doing some work on the AllaClone/EQBrowser tool lately. It is looking pretty good, but there is still a lot of cleanup and such to go. Once we feel it is good enough, I will package it all up and update the download on the SVN with a newer version. Here is what it looks like so far on a test box:

http://69.168.254.243/AllaClone/index.php

We plan to add as many options as possible so it will be really flexible. I also want to add the option to not require the extra EQBrowser tables to be used. With the spells_new table, that removes the need to use the EQBrowser's spells table. I have already changed the tool to use the spells_new table, but the code for spells still needs good amount of cleanup. Really, I think the tool could use a complete rewrite, but we just don't have the time for that and it should be pretty nice even without a full rewrite.

Hopefully it won't be long before it is ready to share with everyone. We have been cranking away on a lot of issues and adding new enhancements (such as listing tasks for zones).
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #7  
Old 02-06-2012, 09:53 AM
pheroux
Fire Beetle
  
Join Date: Jan 2012
Posts: 27
Default
Looks awesome! I can't wait to try it
Reply With Quote
  #8  
Old 02-06-2012, 10:32 AM
provocating's Avatar
provocating
Demi-God
  
Join Date: Nov 2007
Posts: 2,175
Default
I have modified and kept mine up to date, but one thing I never liked and would like to redo is the search.
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 08:40 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3