PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[lanystvyl]

couldn't get this to run, winxp, php 5, Apache 2.2 - I don't get any errors in Apache, php or the log file. I just get the login screen over and over.

Note; i went through the setup for dummies and made all the changes to the ini files.
I noticed there aren't any server paths in the config.php, i didn't add any.

can I run php4 and php5 at the same time?
I'm no guru with php sorry to be a pain.

[joligario]

Originally Posted by lanystvyl

couldn't get this to run, winxp, php 5, Apache 2.2 - I don't get any errors in Apache, php or the log file. I just get the login screen over and over.

Note; i went through the setup for dummies and made all the changes to the ini files.
I noticed there aren't any server paths in the config.php, i didn't add any.

can I run php4 and php5 at the same time?
I'm no guru with php sorry to be a pain.

Do you have short tags on?

[sorvani]

Mine is running on
Apache/2.2.17 (Win32)
PHP/5.3.5

I installed a game server (MySQL and Perl) compiled etc.
Installed Apache
Installed PHP
Configured per the PEQ forums thread and it all worked fine for me.

[lanystvyl]

foind it in the php.ini there was c:/temp changed it and it works now.

[lanystvyl]

WoW freek'n cool man. you guys rock!

[Tabasco]

I put together a configuration script and a canned windows installer if anyone is interested. It's basically a server2go install with the editor already in htdocs. It opens in IE by default and the server terminates when the session closes. No permanent WAMP installation is necessary.

http://216.49.224.132/eq/autoconf.diff

http://216.49.224.132/eq/peq_s2g_install.exe

Install script is at:
http://216.49.224.132/eq/peqinstall.nsi

I've tested it in Windows XP but I don't know how it will behave in other versions of windows. The configuration script could be helpful for any OS.

[chortie]

works good on vista, but i am unable to edit, or create NPC's..
i started off by trying to create a armor and weapon mech, but got a error
so i tried to edit a already made merch, and got a error, tried to copy a merch and got a error. here the error
-----------

Query failed:
INSERT INTO merchantlist SET merchantid=346708, slot=1, item=5678, faction_required=-100, level_required=0, alt_currency_cost=0 - Unknown column 'faction_required' in 'field list'


Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\PEQ Database Editor\htdocs\classes\mysql.php:69) in C:\Program Files\PEQ Database Editor\htdocs\lib\merchant.php on line 56
--------

any ideas?

[lerxst2112]

Your database version isn't up to date. You need to update your server code and apply the required database updates.

At least this one, but you may be missing others as well.
trunk\EQEmuServer\utils\sql\svn\2004_charges_alt_c urrency.sql

[druid64]

I just installed the latest peqphoeditor from the svn r313 for peq rev2092 and I am getting errors on things. This is the error i see above the sections like npc spawns loot and items

Notice: Undefined variable: version in /peqphpeditor/lib/headbars.php on line 335

Notice: Undefined variable: version in /peqphpeditor/lib/headbars.php on line 340

While viewing an item I also get this this error right above the item box plus the 2 messages above

Notice: Undefined variable: errors in /peqphpeditor/templates/items/items.edit.tmpl.php on line 1

I can view the items but when i tryto save things I get a giant page of errors like

Notice: Undefined variable: version in /peqphpeditor/lib/headbars.php on line 335

Notice: Undefined variable: version in /peqphpeditor/lib/headbars.php on line 340

Notice: Undefined variable: name in /peqphpeditor/lib/items.php on line 362

Notice: Undefined variable: itemtype in /peqphpeditor/lib/items.php on line 363

Notice: Undefined variable: lore in /peqphpeditor/lib/items.php on line 364

Notice: Undefined variable: itemclass in /peqphpeditor/lib/items.php on line 365

Notice: Undefined variable: stackable in /peqphpeditor/lib/items.php on line 366

Notice: Undefined variable: stacksize in /peqphpeditor/lib/items.php on line 367

Notice: Undefined variable: maxcharges in /peqphpeditor/lib/items.php on line 368

php 5.3 and mysql 5.1 thanks

[joligario]

Looks like you have your php.ini error messaging set higher than you need. In your php.ini file, scroll down to the error handling and logging section and set your error reporting to this:

error_reporting = E_ALL & ~E_NOTICE

Not sure, but I think you may need to stop/start your httpd services after that change.

[druid64]

Duh.

That was exactly the issue. I had made an .htaccess file to debug a login I was working on and completely forgot about it. Editor is working perfectly now.

Thanks

[Niemand]

Hello, i ran into a, imo, strange problem while trying to setup this Editor.
It loads all fine until it gets to the Template part there something doesnt work for me.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>

  <head>
    <SCRIPT LANGUAGE="JavaScript">
      function gotosite(site) { if (site != "") { self.location=site; } }
    </SCRIPT>
    <SCRIPT LANGUAGE="JavaScript">
      function clearField(obj) { obj.value=""; }
    </SCRIPT>

<?if (isset($javascript)) echo $javascript;?>

    <title>PEQ Database Editor</title>

    <link rel="stylesheet" href="css/peq.css" type="text/css">
  </head>

  <body>
    <div id="container">
      <div id="header">
        <a href="index.php"><img src="images/peq_editor.gif" title="Home" border="0"></a>
      </div>
<?if (isset($headbar)) echo $headbar;?>

<?if (isset($searchbar)) echo $searchbar;?>
      <div id="content">
<?if(isset($breadcrumbs) && ($breadcrumbs != '')):?>
      <div class='page_title'><?=$breadcrumbs?></div>
<?endif;?>
<?=$body?>
      </div>
    </div>
  </body>
</html>

That's how my index.php looks like. All the php parts from the index.tmpl get just ignored i guess. I tried displaying errors etc. nothing. Everything seems to work fine so i ran into a dead end here. Any ideas ?

Niemand

[Niemand]

Couldn't find a Edit button, sorry.
This error was on my side, something went wrong when i setup apache, dunno what.

[MBroadway]

Hello, I use Xampp for my editor. everything worked fine until I had to delete Xampp and reinstall. I did everything the same as before after the new install, but I get errors now.

Strict Standards: Non-static method session::start() should not be called statically in C:\xampp\htdocs\peqedit\classes\session.php on line 104

Strict Standards: Non-static method session::logged_in() should not be called statically in C:\xampp\htdocs\peqedit\classes\session.php on line 135

Notice: Undefined variable: enable_guest_mode in C:\xampp\htdocs\peqedit\classes\session.php on line 138

Notice: Undefined variable: enable_user_login in C:\xampp\htdocs\peqedit\classes\session.php on line 139.

And I do not have the ability to log in. I get

Project Everquest Database Editing Interface


User logins are disabled.

Guest mode is disabled.


Any help would be great. thanks

[joligario]

Scroll up on this thread a few posts to find the error_reporting section to get rid of the strict standards and notices.

Modify your config.php to allow/disallow logins. Don't have just config.php? Rename your config.php.dist to config.php.