EQEmulator Forums - PEQ Database Editor 1.0 (for servers 0.6.4 and up)

Page 3 of 7

Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=593)

- - PEQ Database Editor 1.0 (for servers 0.6.4 and up) (https://www.eqemulator.org/forums/showthread.php?t=20073)

pfyon

10-17-2010 01:32 PM

Quote:

Originally Posted by cavedude (Post 193196)

Sorry about that, fixed in 204.

Still having the same issue.

I think it's happening in lib/items.php copy_item().

edit: Holy non auto line breaks, batman. The relevant bit is:

Code:

Unknown column 'unknown002' in 'field list'

in index.php?editor=items&id=1307&action=7

cavedude

10-17-2010 01:49 PM

Edit: Bah, my mistake I committed the wrong file.

pfyon

10-17-2010 02:00 PM

Aha, excellent, thanks CD!

Templus

11-08-2010 11:17 AM

Where do I get the latest revision? The link here is giving me rev178 and I'm having some issues =\

cavedude

11-08-2010 11:42 AM

At this point, you have to use a SVN client like TortoiseSVN to grab the newest revision. I'll see about getting it packed up and uploaded soon, though.

cylynex2

11-18-2010 12:02 AM

spells_us.txt

Is the spells_us exporter working or am I doing something wrong? It will create the file and get to about 6.1 megs then just die on a white screen, no error msg. Using rev 208.

Edit: NM, fixed my php.ini memory limit and it works now.

Expletus

12-29-2010 05:31 PM

Anyone have an updated installation guide for the newer version of apache and php? I try to follow the old setup but there are files which are no longer there and text that doesn't apply..

using:

httpd-2.2.17-win32-x86-no_ssl.msi
php-5.3.4-nts-win32-vc9-x86.msi
peqphpeditorRev211.zip

And yes, I'm completely newb.

Expletus

01-01-2011 04:23 PM

I still can't figure this out after reading through the information here and the PEQ boards.

joligario

01-01-2011 08:17 PM

Have you tried XAMPP? Very handy all-in-one program which is VERY easy to install.

Expletus

01-01-2011 08:21 PM

I wouldn't even know how to begin using it. I did use it to compile the eqemu source so it's installed..

joligario

01-01-2011 08:47 PM

I think you are talking about something totally different. XAMPP includes Apache, PHP, Perl, and MySQL.

http://www.apachefriends.org/en/xampp-windows.html

Expletus

01-01-2011 09:23 PM

Nope. I couldn't get the correct version of perl to work to compile without errors. I swapped in Xampp and it worked fine. I had no idea it would work for the editor. I just wouldn't know where to begin.

joligario

01-01-2011 09:40 PM

Yeah, you can just put the editor in your htdocs folder and set it up to work from there.

Expletus

01-01-2011 09:45 PM

Excuse me, but I am a little less computer savy than most. Is it possible you could break it into steps? I know it's asking a lot, but I would be very grateful.

joligario

01-01-2011 11:13 PM

For example: If you install xampp to c:\xampp , there will be a folder called htdocs within that folder. That will be your public html folder. Inside, you can create a folder (I named mine peqedit), and extract all the editor files. Modify your config.php file with the proper information. Source in the editor schema into your database (your admin username/password). Then, in your browser you can navigate to http://localhost/peqedit

Expletus

01-01-2011 11:36 PM

short tags for the win! Thank you very very much!

Fasthand

01-02-2011 08:54 PM

Sound like interesting but me and my bro give up after 3 days of trying to get the server to answer us somethign else then "It Worked!"

documentation is way pass date!

Expletus

01-03-2011 12:48 AM

In reference to the editor? Shoot me a PM and I'll walk you through the steps I did for it to work.

wolfwalkereci

01-08-2011 11:54 AM

Finally got it working. Had two errors come up for me. One was telling me something about authentication which after searching google I found this solution to:

Code:

SET PASSWORD FOR root@localhost = OLD_PASSWORD('mypass');

Then it would give me a error on line 90 of mysql.php in the classes folder.
So I just deleted the whole section listed here:

Code:

 // Deter UNION SQL Injection

if (stripos($value, 'union')) {

logSQL("SQL injection monitored by user at IP: '" . getIP() . "' using the query: '" . $value . "'.");

header ("Location: index.php");

exit;

}

I can login and hopefully have no more issues.
Note- I attempted to follow the walk through as close as I could, which included google searching and downloading the older apache and php.

lanystvyl

02-25-2011 12:13 PM

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.

sorvani

02-25-2011 12:41 PM

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.

joligario

02-25-2011 07:32 PM

Quote:

Originally Posted by lanystvyl (Post 197266)

Do you have short tags on?

lanystvyl

02-25-2011 07:56 PM

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

lanystvyl

02-25-2011 08:27 PM

WoW freek'n cool man. you guys rock!

Tabasco

09-23-2011 08:44 PM

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

09-28-2011 05:41 PM

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

09-28-2011 05:57 PM

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

01-18-2012 09:25 AM

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

Code:

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

Code:

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

Code:

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

01-18-2012 07:51 PM

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

01-18-2012 08:50 PM

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

02-15-2012 12:37 AM

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.

Code:

<!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

02-15-2012 05:32 AM

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

MBroadway

03-26-2012 12:36 AM

Error's

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

03-26-2012 06:00 AM

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.

wolfwalkereci

05-15-2012 01:35 AM

Was bored and wanted to update my localhost phpbb3 portal and needed php5 installed to do it.
Previously I used apache 2.0.55 and php 4.4.2

If you try this backup your old stuff. If you modify the windows path you need to restart the computer for change to take effect.

Took me a few minutes to figure it out but this is what I took notes on:

Using the following:

http://www.apachelounge.com/download/
*** you see a link for VC10 SP1 vcredist_x86.exe , that link is broken, head to microcraps website and just copy / paste vcredist_x86.exe in the search box at the top and install it if you need it. I installed the 64bit apache earlier to play with it and thus installed the VC10 dist for 64bit and have no issues with the x86 working for me. No install of VC10 on this machine ***
httpd-2.4.2-win32.zip
php5apache2_4.dll-php-5.4-win32.zip

http://windows.php.net/downloads/releases/archives/
php-5.4.0-Win32-VC9-x86.zip

Unziped apache to C:\apache24
Unziped php to C:\php5

Added C:\php5 to system path
php.ini uncomment extension=php_mysql.dll
php.ini set extension_dir = C:\php5\ext
php.ini set doc_root = "c:\web"
php.ini set error_reporting = E_ALL
php.ini adjusted other fields to personal settings

httpd.conf set ServerRoot "c:/Apache24"
httpd.conf set Listen 80
httpd.conf set LoadModule php5_module "c:/php5/php5apache2_4.dll"
AddHandler application/x-httpd-php .php
PHPIniDir "C:/php5"
httpd.conf set ServerName localhost:80
httpd.conf set DocumentRoot "C:/web"
httpd.conf set <Directory "c:/web">
httpd.conf set DirectoryIndex index.html index.html.var index.htm index.php
httpd.conf set ScriptAlias /php/ "c:/php5/"
AddType application/x-httpd-php .php
Action application/x-httpd-php "/php5/php.exe"

ISSUES: shitty ass error about old passwords. Something like "Connect Error (2000) mysqlnd cannot connect to MySQL 4.1+ using old authentication"

FIX:
http://stackoverflow.com/questions/1...authentication
Opened Navicat --> mysql --> Query --> New Query
SHOW VARIABLES LIKE 'old_passwords';

Quote:

(in the MySQL command line client, HeidiSQL or whatever frontend you like) whether the server is set to use the old password schema by default. If this returns old_passwords,Off you just happen to have old password entries in the users tables. The MySQL will use the old authentication routine for these accounts. But you can simply set a new password for the account and the new routine will be used.
You can check which routine will be used by taking a look at the mysql.users table (with an account that has access to that table)

SELECT `User`, `Host`, Length(`Password`) FROM mysql.user;

Quote:

This will return 16 for accounts with old passwords and 41 for accounts with new passwords (and 0 for accounts with no password at all, you might want to take care of those as well).
Either use the user managements tools of the MySQL front end (if there are any) or

SET PASSWORD FOR 'User'@'Host'=PASSWORD('yourpassword');
FLUSH Privileges

Quote:

(replace User and Host with the values you' got from the previous query). Then check the length of the password again. It should be 41 now and mysqlnd should be able to connect to the server.

Edit: Everyone has their own quirks doing the installs but I noticed that the magelo and allaclone tools actually work 100% for me now, when previously much of those tools refused to work at all.

Tabasco

11-14-2012 10:38 PM

This is a really simple update to edit procrates in items.
http://dungeoncrawl.us.to/procrate.diff.txt

joligario

11-15-2012 08:50 AM

Quote:

Originally Posted by Tabasco (Post 214347)

This is a really simple update to edit procrates in items.
http://dungeoncrawl.us.to/procrate.diff.txt

Added to the editor (in a slightly different location). Thanks!

blindaviator

12-29-2012 08:25 AM

I installed the editor yesterday and everything looked good until I tried to add a new faction.

Here is the error I get:

Code:

Query failed:

INSERT INTO faction_list SET id="501", name="Guardians_of_Knowledge", base="0", mod_c1="0", mod_c2="0", mod_c3="0", mod_c4="0", mod_c5="0", mod_c6="0", mod_c7="0", mod_c8="0", mod_c9="0", mod_c10="0", mod_c11="0", mod_c12="0", mod_c13="0", mod_c14="0", mod_c15="0", mod_c16="0", mod_r1="0", mod_r2="0", mod_r3="0", mod_r4="0", mod_r5="0", mod_r6="0", mod_r8="0", mod_r9="0", mod_r10="0", mod_r11="0", mod_r12="0", mod_r14="0", mod_r42="0", mod_r75="0", mod_r108="0", mod_r128="0", mod_r130="0", mod_r161="0", mod_r330="0", mod_r367="0", mod_r522="0", mod_d201="0", mod_d202="0", mod_d203="0", mod_d204="0", mod_d205="0", mod_d206="0", mod_d207="0", mod_d208="0", mod_d209="0", mod_d210="0", mod_d211="0", mod_d212="0", mod_d213="0", mod_d214="0", mod_d215="0", mod_d216="0", mod_d140="0" - Unknown column 'mod_c1' in 'field list'

I looked at the PHP code and then checked the database table for the columns it was trying to create/modify and they don't exist. Are those columns removed by design or am I missing something?
If they are removed by design then I will know not to use the faction part of the editor.

cavedude

12-29-2012 11:56 AM

Factions changed significantly, and the editor has only been partially converted on my local copy to accommodate that. It's on my list of things to get back to.

joligario

12-29-2012 12:00 PM

Oh, CD beat me to it.

All times are GMT -4. The time now is 04:12 AM.

Page 3 of 7

Show 40 post(s) from this thread on one page