|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...) |
|
|
|
02-05-2012, 03:20 PM
|
Fire Beetle
|
|
Join Date: Jan 2012
Posts: 27
|
|
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
|
|
|
|
Thread Tools |
|
Display Modes |
Threaded Mode
|
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 06:55 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|