EQEmulator Forums

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)

hayward6 08-07-2014 10:06 AM

So here is how I have it setup now

Code:

drwxrwxrwx  3 root root  4096 Aug  5 07:32 www
Code:

drwxr-xr-x 11 eqemu eqemu 4096 Aug  7 09:38 phpeditor
Code:

drwxr-xr-x  3 eqemu eqemu    4096 Nov 25  2013 logs
And then there is nothing in the log folder because it cannot write.

Any type of edit gives me this error. I have also moved the log location around to directly into the peq/logs folder and I get the same result. For some reason php is not privileged...
Could not create /var/www/logs/sql_log_08-2014.sql! Make sure the logs directory is writeable by your webserver.

joligario 08-07-2014 11:47 AM

Ok, I think I'm understanding a little more with permissions. Apache is run as www-data on debian. Try these:
Code:

chown root:www-data /var/www
cd /var/www
chown -R www-data:www-data *
ls -al

EDIT: In fact, you would probably get away with just having www-data own the logs folder.

hayward6 08-07-2014 12:23 PM

I put in those changes but it didn't help. Would I need to restart anything for the changes to take hold?

Also, what port does this travel in on? I would like to be able to hit this editor remote.

hayward6 08-07-2014 12:26 PM

Sorry here is what we did.

Code:

eqemu@debian:/var/www$ ls -al
total 20
drwxrwxrwx  3 root    www-data 4096 Aug  5 07:32 .
drwxr-xr-x 13 root    root    4096 Aug  3 20:35 ..
-rw-r--r--  1 www-data www-data  177 Aug  3 20:01 index.html
-rw-r--r--  1 www-data www-data  20 Aug  3 20:04 info.php
drwxr-xr-x 11 www-data www-data 4096 Aug  7 09:38 phpeditor
eqemu@debian:/var/www$

Code:

eqemu@debian:/var/www/phpeditor$ ls -al
total 21976
drwxr-xr-x 11 www-data www-data    4096 Aug  7 09:38 .
drwxrwxrwx  3 root    www-data    4096 Aug  5 07:32 ..
drwxr-xr-x  3 www-data www-data    4096 Dec  7  2013 classes
-rw-r--r--  1 www-data www-data    2139 Aug  7 10:10 config.php
-rw-r--r--  1 www-data www-data    2130 Aug  5 09:05 config.php.dist
drwxr-xr-x  3 www-data www-data    4096 Aug 28  2013 css
-rw-r--r--  1 www-data www-data      716 Sep 27  2013 .htaccess
drwxr-xr-x  3 www-data www-data    4096 May  3 07:00 images
-rw-r--r--  1 www-data www-data    3515 Jul 23 07:00 index.php
drwxr-xr-x  3 www-data www-data    4096 Jul 23 07:00 lib
drwxr-xr-x  3 www-data www-data    4096 Nov 25  2013 logs
drwxr-xr-x  3 www-data www-data    4096 Jul 23 07:00 perl
-rw-r--r--  1 www-data www-data    1303 Dec  5  2013 README.txt
-rwxrwxrwx  1 www-data www-data 22436418 Aug  7 09:38 spells_us.txt
drwxr-xr-x  3 www-data www-data    4096 Jun 30  2013 sql
drwxr-xr-x  6 www-data www-data    4096 Jul 23 07:00 .svn
drwxr-xr-x 32 www-data www-data    4096 May  3 07:00 templates
eqemu@debian:/var/www/phpeditor$


joligario 08-07-2014 12:33 PM

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.

hayward6 08-07-2014 01:02 PM

Quote:

Originally Posted by joligario (Post 232651)
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 08-07-2014 01:58 PM

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

Shin Noir 08-08-2014 12:47 AM

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 08-08-2014 07:32 AM

Quote:

Originally Posted by Shin Noir (Post 232667)
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 08-24-2014 07:44 AM

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

Kingly_Krab 08-24-2014 09:04 AM

Quote:

Originally Posted by Digitala (Post 233224)
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 08-24-2014 09:11 AM

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 08-24-2014 09:24 AM

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 08-24-2014 09:27 AM

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

dimitrious 09-07-2014 02:39 PM

Hey guys, the editor is pretty amazing and I'm loving the easy-to-use nature of it all.

I am experiencing a problem with the spell copy function though. When I try and copy a spell I get the following error:

Quote:

Query failed:
INSERT INTO spells_new (name, player_1, teleport_zone, you_cast, other_casts, cast_on_you, cast_on_other, spell_fades, `range`, aoerange, pushback, pushup, cast_time, recovery_time, recast_time, buffdurationformula, buffduration, AEDuration, mana, effect_base_value1, effect_base_value2, effect_base_value3, effect_base_value4, effect_base_value5, effect_base_value6, effect_base_value7, effect_base_value8, effect_base_value9, effect_base_value10, effect_base_value11, effect_base_value12, effect_limit_value1, effect_limit_value2, effect_limit_value3, effect_limit_value4, effect_limit_value5, effect_limit_value6, effect_limit_value7, effect_limit_value8, effect_limit_value9, effect_limit_value10, effect_limit_value11, effect_limit_value12, max1, max2, max3, max4, max5, max6, max7, max8, max9, max10, max11, max12, icon, memicon, components1, components2, components3, components4, component_counts1, component_counts2, component_counts3, component_counts4, NoexpendReagent1, NoexpendReagent2, NoexpendReagent3, NoexpendReagent4, formula1, formula2, formula3, formula4, formula5, formula6, formula7, formula8, formula9, formula10, formula11, formula12, LightType, goodEffect, Activated, resisttype, effectid1, effectid2, effectid3, effectid4, effectid5, effectid6, effectid7, effectid8, effectid9, effectid10, effectid11, effectid12, targettype, basediff, skill, zonetype, EnvironmentType, TimeOfDay, classes1, classes2, classes3, classes4, classes5, classes6, classes7, classes8, classes9, classes10, classes11, classes12, classes13, classes14, classes15, classes16, CastingAnim, TargetAnim, TravelType, SpellAffectIndex, field124, field125, deities1, deities2, deities3, deities4, deities5, deities6, deities7, deities8, deities9, deities10, deities11, deities12, deities13, deities14, deities15, deities16, field142, field143, new_icon, spellanim, uninterruptable, ResistDiff, dot_stacking_exempt, deleteable, RecourseLink, no_partial_resist, field152, field153, short_buff_box, descnum, typedescnum, effectdescnum, field158, npc_no_los, field160, reflectable, bonushate, field163, field164, field165, EndurCost, EndurTimerIndex, IsDiscipline, field169, field170, field171, field172, HateAdded, EndurUpkeep, numhitstype, numhits, pvpresistbase, pvpresistcalc, pvpresistcap, spell_category, field181, field182, field183, field184, can_mgb, nodispell, npc_category, npc_usefulness, MinResist, MaxResist, field191, field192, nimbuseffect, ConeStartAngle, ConeStopAngle, field196, not_extendable, field198, field199, suspendable, field201, songcap, field203, field204, field205, field206, spellgroup, rank, field209, field210, CastRestriction, allowrest, NotOutofCombat, NotInCombat, field215, field216, field217, field218, maxtargets, field220, field221, field222, field223, persistdeath, id) SELECT name, player_1, teleport_zone, you_cast, other_casts, cast_on_you, cast_on_other, spell_fades, `range`, aoerange, pushback, pushup, cast_time, recovery_time, recast_time, buffdurationformula, buffduration, AEDuration, mana, effect_base_value1, effect_base_value2, effect_base_value3, effect_base_value4, effect_base_value5, effect_base_value6, effect_base_value7, effect_base_value8, effect_base_value9, effect_base_value10, effect_base_value11, effect_base_value12, effect_limit_value1, effect_limit_value2, effect_limit_value3, effect_limit_value4, effect_limit_value5, effect_limit_value6, effect_limit_value7, effect_limit_value8, effect_limit_value9, effect_limit_value10, effect_limit_value11, effect_limit_value12, max1, max2, max3, max4, max5, max6, max7, max8, max9, max10, max11, max12, icon, memicon, components1, components2, components3, components4, component_counts1, component_counts2, component_counts3, component_counts4, NoexpendReagent1, NoexpendReagent2, NoexpendReagent3, NoexpendReagent4, formula1, formula2, formula3, formula4, formula5, formula6, formula7, formula8, formula9, formula10, formula11, formula12, LightType, goodEffect, Activated, resisttype, effectid1, effectid2, effectid3, effectid4, effectid5, effectid6, effectid7, effectid8, effectid9, effectid10, effectid11, effectid12, targettype, basediff, skill, zonetype, EnvironmentType, TimeOfDay, classes1, classes2, classes3, classes4, classes5, classes6, classes7, classes8, classes9, classes10, classes11, classes12, classes13, classes14, classes15, classes16, CastingAnim, TargetAnim, TravelType, SpellAffectIndex, field124, field125, deities1, deities2, deities3, deities4, deities5, deities6, deities7, deities8, deities9, deities10, deities11, deities12, deities13, deities14, deities15, deities16, field142, field143, new_icon, spellanim, uninterruptable, ResistDiff, dot_stacking_exempt, deleteable, RecourseLink, no_partial_resist, field152, field153, short_buff_box, descnum, typedescnum, effectdescnum, field158, npc_no_los, field160, reflectable, bonushate, field163, field164, field165, EndurCost, EndurTimerIndex, IsDiscipline, field169, field170, field171, field172, HateAdded, EndurUpkeep, numhitstype, numhits, pvpresistbase, pvpresistcalc, pvpresistcap, spell_category, field181, field182, field183, field184, can_mgb, nodispell, npc_category, npc_usefulness, MinResist, MaxResist, field191, field192, nimbuseffect, ConeStartAngle, ConeStopAngle, field196, not_extendable, field198, field199, suspendable, field201, songcap, field203, field204, field205, field206, spellgroup, rank, field209, field210, CastRestriction, allowrest, NotOutofCombat, NotInCombat, field215, field216, field217, field218, maxtargets, field220, field221, field222, field223, persistdeath, 33000 AS id FROM spells_new WHERE id = '2160' - Unknown column 'field191' in 'field list'
I assume there's something wrong with my spells_new but I'm unsure how to go about fixing this. This is a recent setup (two days ago)


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

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.