PDA

View Full Version : EQ Browser /Allakhazam


pheroux
02-05-2012, 03:20 PM
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
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

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

#- 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

provocating
02-05-2012, 03:23 PM
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.

Derision
02-05-2012, 03:42 PM
'range' became a reserved word in MySQL 5.1. You need to edit spells.sql and enclose it in backticks, like this:

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.

provocating
02-05-2012, 03:45 PM
Yeah the reserve them, and they may never use them....but they reserve them anyway. Same thing happens to me in MS SQL.

iRFNA
02-05-2012, 06:42 PM
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.

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.

trevius
02-06-2012, 05:08 AM
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).

pheroux
02-06-2012, 09:53 AM
Looks awesome! I can't wait to try it :)

provocating
02-06-2012, 10:32 AM
I have modified and kept mine up to date, but one thing I never liked and would like to redo is the search.