Problems with PEQ Editor

[TylerBarnes]

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:
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?

[Kingly_Krab]

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'.

[TylerBarnes]

Makes sense.
Now do I alter that? I'm not sure how to edit a .sql file other than to source it using MySQL.

[Kingly_Krab]

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.

http://img29.imageshack.us/img29/5126/k8lp.png

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.

[TylerBarnes]

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.

[Kingly_Krab]

You're welcome, hopefully you can pass it on in the future.

[joligario]

Recommend you get the official PEQ editor from http://code.google.com/p/peqphpeditor/

Always up-to-date.

[cavedude]

Wow, I just saw the link TylerBarnes posted. That version is ancient, no way it will work with modern EQEmu.

[NatedogEZ]

Recommend you get the official PEQ editor from http://code.google.com/p/peqphpeditor/

Always up-to-date.

That doesn't look like the up to date revision..

Pretty sure its found... here

https://drive.google.com/folderview?id=0B5FZHGN6aazfeThIMENvWTA2VDA&usp=sharing#list

[cavedude]

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.

[NatedogEZ]

Ah didn't know that thank you :)

The date on the SVN said 2012 didn't think it was updated in awhile heh

[cavedude]

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.

[TylerBarnes]

Wow that works much better! Thanks for pointing that out.
Is there a guide or list of what these values mean?