PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[Gigfel]

This is my "config.php" of the PEQ PHPEditor:

// Database Information:
$dbhost = 'localhost';
$dbuser = 'xxxx';
$dbpass = 'xxxx';
$db = 'everquest';
$mysql_class = 'mysqli'; // Use mysql or mysqli

/*  Limit zone lists to a specified expansion
 *  (i.e. setting $expansion_limit to 2 would cause only Classic and Kunark zones
 *  to appear in zone drop-down lists)
 *    1 = EQ Classic
 *    2 = Kunark
 *    3 = Velious
 *    4 = Luclin
 *    5 = Planes of Power
 *    6 = Legacy of Ykesha
 *    7 = Lost Dungeons of Norrath
 *    8 = Gates of Discord
 *    9 = Omens of War
 *    10 = Dragons of Norrath
 *    11 = Depths of Darkhollow
 *    12 = Prophecy of Ro
 *    13 = The Serpents Spine
 *    14 = The Buried Sea
 *    15 = Secrets of Faydwer
 *    16 = Seeds of Destruction
 *    17 = Underfoot
 *    18 = House of Thule 
 *    19 = Veil of Alaris
 *    20 = Rain of Fear
 *    99 = Other
 */
$expansion_limit = 20;

// How NPCs are listed. 1 = by NPCID (zoneidnumber*1000), 2 = By spawn2 entry
$npc_list = 1;

// Spawngroup list limit. Limits how many spawngroups are displayed as result of a Coord/NPC search. Specific NPC lists are not effected.
$spawngroup_limit = 150;

// Dont want to have to type the username and password every time you start the editor?
// Set the two variables below to the values you want to be in the form when you start it up.
// (default login: admin  pw: password)
$login = '';
$password = '';

// Log SQL queries:  1 = on, 0 = off
$logging = 1;

// $log_file = path to the file your sql logs will be saved in.
// If you want a single log file, uncomment next line and comment the two monthly log options.
//$log_file = "logs/sql_log.sql";

// Automatically create new logs monthly.
$filetime = date_default_timezone_set('Europe/Paris');
$log_file = "logs/sql_log_$filetime.sql";

// Log all MySQL queries (If disabled only write entries are logged - recommended.)
$log_all = 0;

// Log all MySQL queries that result in an error.
$log_error = 1;

// Enable or disable user logins.
$enable_user_login = 1;

// Enable or disable read only guest mode log in.
$enable_guest_mode = 0;

// Path for quests without trailing slash.
$quest_path = "/home/eqemu/quests"

The "access" -Logfile of the Apache says:

xxx.x.xxx.xxx - - [19/Jan/2015:19:09:43 +0100] "GET /eqeditor/index.php HTTP/1.1" 200 1704
xxx.x.xxx.xxx - - [19/Jan/2015:19:09:44 +0100] "GET /eqeditor/css/peq.css HTTP/1.1" 304 -
xxx.x.xxx.xxx - - [19/Jan/2015:19:09:44 +0100] "GET /eqeditor/images/peq_editor.gif HTTP/1.1" 304 -
xxx.x.xxx.xxx - - [19/Jan/2015:19:09:52 +0100] "POST /eqeditor/index.php?login HTTP/1.1" 302 -
xxx.x.xxx.xxx - - [19/Jan/2015:19:09:52 +0100] "GET /eqeditor/index.php HTTP/1.1" 200 1704

There is no Error in the "error" -Log of the Apache Server.
(Sorry i needed so long, but i got a phone call ...)

[Gigfel]

I have made a Alias to my private Domain to Access over the Internet the PEQ PHPEditor, because i would like to work from everywhere with this tool.

Alias /eqeditor "D:/Webserver/Domain/www.eqemulator.de"

But i get a 302 "Hijacking" -Error from it:

xxx.x.xxx.xxx - - [19/Jan/2015:19:09:52 +0100] "POST /eqeditor/index.php?login HTTP/1.1" 302

The Alias i have made on my PHPMyAdmin doesnt make such a Problem.
Anyone an Idea how i could correct it ?

P.S. I will research myself, but maybe someone had already the same Problem.

[Gigfel]

I had disabled the Cookie Session in the "php.ini" -File, thats why i couldnt log into PEQ PHPEditor.
The "hijacking" -Error 302, repoted by Apache itself, is only a side effect, which happens when the Editor hasnt found a available Session.
Then the Tool resets the Connection by using a "header(location: index.php)", which delivers by default the State 302.

Indicators for Coockie Session's are inactive:
1. You could access the Tool via Webbrowser
2. You could enter your Logindata
3. You dont get any Query-Log-Error in Logpath of the Tool
3. The Apache-Access-Log shows something like this:

xxx.x.xxx.xxx - - [20/Jan/2015:00:15:25 +0100] "POST /eqeditor/index.php?login HTTP/1.1" 302 -
xxx.x.xxx.xxx - - [20/Jan/2015:00:15:25 +0100] "GET /eqeditor/index.php HTTP/1.1" 200 1704

(The 2nd line shows the Reset of the Connection)

Edit:
Thanks to Joligario, whitout his hint i wouldnt have found the Problem that fast

[Ignishaut]

I would like to suggest updateing the readme to include setting the following in the php.ini

session.use_cookies=1
session.use_only_cookies=1

It those two tidbits had been in the readme, it would have saved me a few headaches.

(And yes I did search the boards but apparently I was not using the correct keywords to find anything meaningful.)

[joligario]

Actually, those are the default settings anyways (http://php.net/manual/en/session.configuration.php). As a side note, I have use_only_cookies set to 0 and it works fine.

[tendricvk]

having problem when I went to the page it said login disabled but I tried to login anyway now I just have a pic saying don't panic.... well I am panicking!!!

[joligario]

Check again. Does it say Guest Mode is disabled?

At the Don't Panic page, are there tabs along the top like NPCs, Tasks, Accounts, etc.?

What does it say in the url?

Did you follow the readme step by step?

[tendricvk]

I can't get to any other screen now but I remember it saying guest mode was disabled. I'll post a pic of it when I get to a pc

[tendricvk]

I followed readme im using xampp. as you can see there is no tabs

[NatedogEZ]

You need to go into your php.ini and turn on...

short_open_tag=On





If you havent already make sure to turn off showing errors as well.. unless you plan on fixing all of them. (the peq editor has a lot of warnings :p)


also in the php.ini turn off...

display_errors=Off

[tendricvk]

this is what I have

[joligario]

If that is what you have and you are showing us this, that means you don't understand that particular step and/or the file structure.

A semicolon is a comment in the php.ini file. So this is just showing you what the default, development, and production values are supposed to be. The actual declaration is about 50 lines farther down.

[tendricvk]

yep I goofed. thank you that fixed it

[Drg01]

Edit: Rebooted and fixed my own problem of not having tabs show up.

[Dremis]

I've followed all instructions I can find both here and on PEQ's site. I'm using Xampp
5.5.30 and I get:

Server error!

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.

If you think this is a server error, please contact the webmaster.

Error 500

localhost
Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.5.30

any ideas? should I post config files?