|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...) |
11-10-2013, 08:28 PM
|
|
Sarnak
|
|
Join Date: Dec 2012
Location: Sunny California
Posts: 62
|
|
Problems with PEQ Editor
http://sourceforge.net/projects/peqeditor/
I downloaded the PEQ Editor from the above link but I'm having trouble getting it running. I installed WAMP which includes the two programs it's asking for plus MYSQL and I'm following the installation instructions but I hit a roadblock when it tells me to source schema.sql. I open MySQL (via wamp) and use the source command on (directory information)schema.sql and get the following error:
Quote:
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
|
Anybody know how to fix this? Or better, a simpler program with a .exe installer instead of convoluted instructions?
|
11-10-2013, 08:31 PM
|
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,595
|
|
Range is often messed up like this because it's a function, you need to have it like this `range`, that way it knows it isn't the function 'range'.
|
11-10-2013, 08:37 PM
|
|
Sarnak
|
|
Join Date: Dec 2012
Location: Sunny California
Posts: 62
|
|
Makes sense.
Now do I alter that? I'm not sure how to edit a .sql file other than to source it using MySQL.
|
11-10-2013, 08:38 PM
|
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,595
|
|
You can edit the file by right-clicking it and clicking 'Edit', it looks like the first row, then you turn it in to the second row.
You may want this: http://notepad-plus-plus.org/
It has syntax highlighting which is very helpful and would show you such an error almost immediately. |
11-10-2013, 09:01 PM
|
|
Sarnak
|
|
Join Date: Dec 2012
Location: Sunny California
Posts: 62
|
|
You just solved a whole bunch of my problems.
I did not know that sql files could be edited using NotePad++.
I've been struggling because I thought they could only be used with MySQL.
Thanks. I'm going to start poking around (cautiously) in it.
|
11-10-2013, 09:56 PM
|
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,595
|
|
You're welcome, hopefully you can pass it on in the future.
|
11-11-2013, 04:16 AM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Wow, I just saw the link TylerBarnes posted. That version is ancient, no way it will work with modern EQEmu.
|
11-11-2013, 05:25 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
The daily dump on Google is pulled from the SVN that joligario linked. SVN technically is more up to date because changes can be grabbed as soon as one of us commits it. The Google dump is only updated once a day, but for many folks it's an easy way to grab the editor. Since the DB and quests are posted there too, it's a one stop shop for PEQ.
|
11-11-2013, 05:47 AM
|
 |
Developer
|
|
Join Date: Dec 2012
Posts: 515
|
|
Ah didn't know that thank you 
The date on the SVN said 2012 didn't think it was updated in awhile heh |
11-11-2013, 11:44 AM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Oh, that's just the last download - I'll delete that. They are doing away with downloads next year anyway, which is one of the reasons why I went with the daily dump. The actual repo was just updated Nov 1 by Jog implementing the new tradeskill column.
|
11-11-2013, 06:12 PM
|
|
Sarnak
|
|
Join Date: Dec 2012
Location: Sunny California
Posts: 62
|
|
Wow that works much better! Thanks for pointing that out.
Is there a guide or list of what these values mean?
|
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 09:37 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
