PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[hayward6]

Originally Posted by joligario

Standard http is on port 80.

Not sure why it wouldn't be able to write if it is the owner... Try doing a chmod 0770 on just the logs folder.

Sweet, no more logging into my home pc to try it out! Remote access is working

770 didn't help either...

[joligario]

I'm at a loss then. We must be missing something else.

[Shin Noir]

This is using my tutorial right?
You followed step 22? http://wiki.eqemulator.org/p?EQEmu_o...n_7_Virtualbox
I have it working with those steps, from start to end. I didn't need to chown the directory or anything., just chmod 777 (or 770 or whatever, 777 due to laziness and I never plan to forward port 80 so it's a LAN only accessible network spot).

TECHNICAL STUFF FOLLOWING
by default debian creates /var/www/ as the htdocs root default vhost entry.
This is set inside /etc/apache2/sites-available/default file.

files inside /var/www/ can be root and readable, since init.d for apache2 is ran as root and www-data (you can verify this by typing $ "ps aux | grep apache2" and note the left side for user executing the binaries.)

[hayward6]

Originally Posted by Shin Noir

This is using my tutorial right?
You followed step 22? http://wiki.eqemulator.org/p?EQEmu_o...n_7_Virtualbox
I have it working with those steps, from start to end. I didn't need to chown the directory or anything., just chmod 777 (or 770 or whatever, 777 due to laziness and I never plan to forward port 80 so it's a LAN only accessible network spot).

TECHNICAL STUFF FOLLOWING
by default debian creates /var/www/ as the htdocs root default vhost entry.
This is set inside /etc/apache2/sites-available/default file.

files inside /var/www/ can be root and readable, since init.d for apache2 is ran as root and www-data (you can verify this by typing $ "ps aux | grep apache2" and note the left side for user executing the binaries.)

Many of these steps have been changed since I set it up, and you have added a few commands, so I have only gone back and tried to adapt it. It's working fine, just not logging, which is ok with me... but I would like to figure it out...

I believe you have a couple steps out of place in the latest update. The sudo nano line is followed directly buy a mkdir command rather than what you will do in nano. Just confusing, but I get what you want done here.

22 - Set up PHPEditor (optional)
PHPEditor is a way to edit NPC's, spells, items, and many other aspects of the EQ database. It is recommended to set up for future editing, even if you use other tools along with it.

First, we need to inject the schema file for phpeditor
$ sudo mysql -u eq -p -h 127.0.0.1 eq < /var/www/phpeditor/sql/schema.sql
Go to a web browser, access http://10.0.0.111/phpeditor/
It should note database is not configured.
$ sudo cp /var/www/phpeditor/config.php.dist /var/www/phpeditor/config.php
$ sudo nano /var/www/phpeditor/config.php
$ sudo mkdir /var/www/phpeditor/logs
$ sudo chmod 777 /var/www/phpeditor/logs
change the dbhost, 127.0.0.1
dbuser change to eq
password change to root
db change to eq
Refresh web page, should show prompt
Log in as admin/password
$ sudo chmod 777 /var/www/phpeditor/spells_us.txt

[Digitala]

Hey!
Does the PEQ Editor work with Angelox Database?
Thx

[Kingly_Krab]

Originally Posted by Digitala

Hey!
Does the PEQ Editor work with Angelox Database?
Thx

No, because their tables have different column names and they have different table names as well.

[Digitala]

Ahh okey thx!
So what kinda editor works with Angelox?
Just setting things up with my friend atm and we are trying to find out what to use. Any information is useful.
Thank you =)

[wolfwalkereci]

If you compared their tables/columns to PEQ you could modify the editor to work. Not to knock on their DB but why use it over PEQ?

[Digitala]

We are going for the classic everquest, and from my understanding PEQ is missing a lot of that. Lavastorm CT etc.

[Kingly_Krab]

field191 and field192 were renamed, the Editor just hasn't caught up to that change yet:
https://github.com/EQEmu/Server/pull/184/files

[Hiing]

Our merchants have a strange bug, and i'm having a hard time finding a spot in the db editor that might be able to fix it.

If you sell an item with charges, they will immediately sellback that quanity in charges. Ie, you sell a 10 charge potion, they sell back 10 fully charged potions. You sell a 6 charge, they sell back 6, and so on. I've searched all over the editor and cant find anything, would that be something deeper? Any recomendations or anyone had the same issue?

[trevius]

Originally Posted by Hiing

Our merchants have a strange bug, and i'm having a hard time finding a spot in the db editor that might be able to fix it.

If you sell an item with charges, they will immediately sellback that quanity in charges. Ie, you sell a 10 charge potion, they sell back 10 fully charged potions. You sell a 6 charge, they sell back 6, and so on. I've searched all over the editor and cant find anything, would that be something deeper? Any recomendations or anyone had the same issue?

Do you mean that if you sell a potion that is fully or partially used, you can buy it back fully charged? I know that was an issue/bug/exploit years ago, but thought it had been fixed. If not, then the merchant tables need to save charges and load them properly or something most likely.

[Hiing]

That happens too but im not so concerned about the recharge.

The item itself is actually duplicated in the sellers window. So if its a ten charge item, then its duplicated 10 times. Each item with full charges.

[Gigfel]

Hello Everyone,

i am using a Apache 2.2.x with PHP 5.3.x and i am trying to run the PEQ PHPEditor 2014/10/11, which i have downloaded from this location:
https://drive.google.com/folderview?...p=sharing#list

I have configured my "php.ini" as it have been told in the "readme.txt":
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
short_open_tags = On

I can access the Editor over the Webbrowser and getting the "Login" -Screen.
If i log myself in, the php starts to work, connects the Database, finds my Account and identifies my Password as correct, but the Output i get is the "Login" -Screen again.
There are no "Error" - Messages or -Logfiles, which would give me a hint.

Maybe Someone has an Idea why i cant get it run correctly ?


Edit:
The ".htaccess" -Files set correctly and when i use wrong Logindata i get a Query-Error-Log.

[joligario]

What does your config file look like (omit passwords).

Check your logs directory, apache access/error logs, and php error log for any other hints.