PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[victurus]

I am still receiving these errors when attempting to run the index.php.



I have changed the error_reporting, restarted services, restarted comp.
This solution does not seem to be working.

If i ignore all those errors and go to the login box and type in admin/password, it gives me another page with about 40 errors.

Any help would be appreciated.

[joligario]

Based on the above, I assume you must not have changed the error_reporting correctly (or possibly even the right file). Did you get the proper php.ini file and uncomment (remove ';')? I recommend: error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT

[victurus]

Sweet, I am using wamp.. and those tricky bastages put 3 different .ini files with the same stuff in each. Then they hid the correct one! lol, thanks for the assistance.

[victurus]

OK, so now that it is letting me login, once I login to it, it just sits at this page and does nothing.


And I am receiving no error logs on any of my services.

[joligario]

Set your short open tags to "on" in php.ini

[victurus]

Awesome, thanks for the help man!

[Gregk]

Up and working. Thank you to everyone.

[Kingmen30264]

I am interested in using this, but every time I go to load index.php in Firefox, Chrome, or whichever browser, it asks me if I want to download the file that I am opening.

Any help? I followed the instructions on the README.txt file.

Thanks,
Kingmen

[wolfwalkereci]

You install php and apache or wamp or some other web server?

[Kingmen30264]

Originally Posted by wolfwalkereci

You install php and apache or wamp or some other web server?

I followed the instructions and installed Apache (httpd-2.0.64-win32-x86-openssl.0.9.8.o.msi ) and PHP ( php-5.3.21-nts-Win32-VC9-x86.msi ).

It told me to edit my php.ini file to allow short_open_tag = on, and I did that... I sourced the install directory and then made that change to it.

On Apache it tells me to install the Apache HTTP server, and I did that. I have a little icon running (on startup) that I can load at anytime.

It told me to "Source schema.sql (in the ditor's /sql directory) into your database." I took this as "Run the sql query so it shows in your database", and so that is what I did. The result of this was a table called "peq_admin" which shows the columns (id, login, password, administrator).

Next it tells me to unzip the files in peq_editor into a public html directory... For this I just have them unzipped in a folder on my desktop. I did not really understand what it meant by "public html directory".

Then it tells me to rename config.php.dist as config.php and then edit it based on my needs, so I put in my DB name, username, and password, along with the IP address for it (local machine address [same network]). (There was already a file called config.php in the zipped file that I got, along with another one called config.php.dist.)

I have done everything that it has asked, and I am thinking the issue lies with the "public html directory". Once I have an understanding of that, then all should be working the way it was intended.

Thanks,
Kingmen

[joligario]

Originally Posted by Kingmen30264

... I am thinking the issue lies with the "public html directory"...

That is correct. When you install apache, there should have been a folder created called "htdocs" somewhere in your folder hierarchy whether it be in apache or web or whatever you used during installation. Anything under that folder will appear as the base for your localhost url. For example: htdocs/index.html will translate to http://localhost/index.html in your web browser. When you create an editor folder, it will be something like htdocs/peqedit/ will translate to http://localhost/peqedit/.

[Kingmen30264]

Originally Posted by joligario

That is correct. When you install apache, there should have been a folder created called "htdocs" somewhere in your folder hierarchy whether it be in apache or web or whatever you used during installation. Anything under that folder will appear as the base for your localhost url. For example: htdocs/index.html will translate to http://localhost/index.html in your web browser. When you create an editor folder, it will be something like htdocs/peqedit/ will translate to http://localhost/peqedit/.

Alright, I got that done, and now that I understand that, I am wondering one thing. Am I supposed to only put the index.php file into c:\Program Files\Apache Group\Apache2\htdocs alone, or am I supposed to put the entire folder in there? Or am I supposed to just make a shortcut to the index.php file?

If I put just the index.php file into the folder, this is what I see:



If I put the entire phpeditor folder into the htdocs folder, then this is what I see:



I used /localhost/peqphpeditor/index.php because if I didn't, then I would end up with the same thing as I did when I did the shortcut below.

If I make a shortcut to the index.php file, then this is what I see:




Is there something else that I can do to maybe get it to work?


Thanks
Kingmen

[c0ncrete]

first, get this to work in the directory you are trying to use. if it doesn't work, something is wrong with your apache/php installation or configuration and it has nothing to do with the editor.

index.php

<?php

phpinfo();

?>

http://php.net/manual/en/install.windows.php

[Kingmen30264]

index.php

<?php

phpinfo();

?>

I did that, and all I keep seeing is the what is written in the php file in the browser. When I do /localhost/index.html.en it loads and shows me a page from apache that says "This page is here because the site administrator has changed the configuration...." So I am guessing that means that my apache is working?

if it doesn't work, something is wrong with your apache/php installation or configuration and it has nothing to do with the editor.

When I installed PHP, it asked me what I wanted it to install under the extensions and I told it to install what was defaulted out, expect for the first one which was PHP and in the tree it was "associate all *.php files with php" which I told it to install that as well.

Then it asked me what kind of server did I want to install, IIS FastCGI, CGI, or No server, in which I selected CGI as IIS FastCGI told me to go to some server config and change some values and I didn't know where it was talking about.
After that, I just installed the rest of the program as normal following the prompts and when it was done, it closed.

I am still confused with the last line of the instructions, "Open up index.php in your web browser"... Does this mean for me to click on Index.php and load it like that, or am I supposed to click File>Open>Index.php, or do I simply add only the index.php in apache2/htdocs directory, or do I add the entire folder, and source it from there by entering /localhost/peqedit/index.php?

Here is what my index.php looks like:

#!C:/php/php.exe
<?php

phpinfo();

?>

$current_revision = "r358";

require_once("config.php");
require_once("lib/logging.php");
require_once("classes/mysql.php");
require_once("classes/template.php");
require_once("classes/session.php");
require_once("lib/common.php");
require_once("lib/data.php");

$editor = (isset($_GET['editor']) ? $_GET['editor'] : '');
$action = (isset($_GET['action']) ? $_GET['action'] : 0);
$npcid = (isset($_GET['npcid']) ? $_GET['npcid'] : null);
$z = (isset($_GET['z']) ? $_GET['z'] : '');
$zoneid = (isset($_GET['zoneid']) ? $_GET['zoneid'] : '');
$fid = (isset($_GET['fid']) ? $_GET['fid'] : '');
$tskid = (isset($_GET['tskid']) ? $_GET['tskid'] : '');
$ts = (isset($_GET['ts']) ? $_GET['ts'] : '');
$rec = (isset($_GET['rec']) ? intval($_GET['rec']) : '0');
$spellset = (isset($_GET['spellset']) ? $_GET['spellset'] : '');
$playerid = (isset($_GET['playerid']) ? $_GET['playerid'] : null);
$acctid = (isset($_GET['acctid']) ? $_GET['acctid'] : null);
$guildid = (isset($_GET['guildid']) ? $_GET['guildid'] : null);
$aaid = (isset($_GET['aaid']) ? $_GET['aaid'] : null);

$searchbar = '';
$body = '';
$javascript = '';
$breadcrumbs = '';
$headbar = '';

require_once('lib/headbars.php');
require_once('lib/breadcrumbs.php');

if (isset($_GET['admin'])) {
  if (session::is_admin()) {
    require_once('lib/admin.php');
  }
}

switch ($editor) {
  case '':
    $body = new Template("templates/intro.tmpl.php");
    $body->set('current_revision', $current_revision);
    break;
  case 'loot':
    require_once('lib/loot.php');
    break;
  case 'npc':
    require_once('lib/npc.php');
    break;
  case 'spawn':
    require_once('lib/spawn.php');
    break;
  case 'merchant':
    require_once('lib/merchant.php');
    break;
  case 'faction':
    require_once('lib/faction.php');
    break;
  case 'spellset':
    require_once('lib/spellset.php');
    break;
  case 'tradeskill':
    require_once('lib/tradeskill.php');
    break;
  case 'zone':
    require_once('lib/zone.php');
    break;
  case 'misc':
    require_once('lib/misc.php');
    break;
  case 'server':
    require_once('lib/server.php');
    break;
  case 'adventures':
    require_once('lib/adventures.php');
    break;
  case 'tasks':
    require_once('lib/tasks.php');
    break;
  case 'items':
    require_once('lib/items.php');
    break;
  case 'player':
    require_once('lib/player.php');
    break;
  case 'spells':
    require_once('lib/spellenums.php');
    require_once('lib/spells.php');
    break;
  case 'spellops':
    require_once('lib/spellops.php');
    break;
  case 'account':
    require_once('lib/account.php');
    break;
  case 'guild':
    require_once('lib/guild.php');
    break;
  case 'mail':
    require_once('lib/mail.php');
    break;
  case 'aa':
    require_once('lib/aa.php');
    break;
  case 'qglobal':
    require_once('lib/qglobal.php');
    break;
  case 'util':
    require_once('lib/util.php');
    break;
  case 'altcur':
    require_once('lib/altcur.php');
    break;
  case 'quest':
    require_once('lib/quest.php');
    break;
}

$tmpl->set('javascript', $javascript);
$tmpl->set('headbar', $headbar);
$tmpl->set('searchbar', $searchbar);
$tmpl->set('breadcrumbs', $breadcrumbs);
$tmpl->set('body', $body);

echo $tmpl->fetch('templates/index.tmpl.php');

?>

And here is what my Config.php looks like:

<?php

// Database Information:
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '********';
$db = 'peq';

/*  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("m-Y");
$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 = 0;

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

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

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

?>

I am not sure how to tell if the PHP program is installed properly.

I am kind of curious as to why it keeps showing the lines of code when I do /localhost/index.php


Thanks,
Kingmen

[c0ncrete]

it's because apache isn't configured correctly to execute/handle the contents of the php file, and instead is providing them as plain text files.

also, you only want to open the file via a network address through apache, not using file->open.

again, don't worry about getting the database editor to work until you get a simple php document like the one with phpinfo in it to be correctly translated by apache. otherwise, you'll just end up confusing yourself further.

you're likely missing something like this

#
LoadModule php5_module "c:/php/php5apache2.dll"
AddHandler application/x-httpd-php .php

# configure the path to php.ini
PHPIniDir "C:/php"

found @ http://php.net/manual/en/install.windows.apache2.php