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-06-2014 12:43 PM

Quote:

Originally Posted by joligario (Post 232582)

EDIT: How about give me an ls -al from your editor directory.

It's a little more broken than it was because I had to redo the database and source, but the log issue is still there... I don't know why that spells file is there...

Code:

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


hayward6 08-06-2014 12:55 PM

I was able to get it working by turning off sql logging, so that is where the problem is...

joligario 08-06-2014 01:03 PM

I wonder if the problem may be that root owns your parent directory (www). Only guessing at this point.

What is inside your logs folder? Can I get an ls -al from there?

hayward6 08-06-2014 01:24 PM

There is nothing inside the logs folder and I had to create that folder myself. I may be wrong but I believe that www folder was part of the debain deployment, so maybe that is the problem. I could change ownership of it... Let me try that.

hayward6 08-06-2014 01:26 PM

Oh sorry ls-la... yeah it looks like this...

Code:

eqemu@debian:/var/www/phpeditor/logs$ ls -la
total 12
drwxr-xr-x  3 eqemu eqemu 4096 Nov 25  2013 .
drwxr-xr-x 11 eqemu eqemu 4096 Aug  5 09:06 ..
drwxr-xr-x  6 eqemu eqemu 4096 Jul 23 07:00 .svn
eqemu@debian:/var/www/phpeditor/logs$


hayward6 08-06-2014 01:35 PM

That didn't help :( I would run it with logs off, but it seems that the commands don't execute unless the log is written.

Code:

eqemu@debian:/var$ ls -la
total 52
drwxr-xr-x 13 root  root  4096 Aug  3 20:35 .
drwxr-xr-x 23 root  root  4096 Aug  5 09:23 ..
drwxr-xr-x  2 root  root  4096 Aug  5 06:25 backups
drwxr-xr-x 10 root  root  4096 Aug  6 07:15 cache
drwxr-xr-x 31 root  root  4096 Aug  3 20:08 lib
drwxrwsr-x  2 root  staff 4096 Jun 11 17:07 local
lrwxrwxrwx  1 root  root    9 Aug  3 19:46 lock -> /run/lock
drwxr-xr-x  9 root  root  4096 Aug  6 06:25 log
drwxrwsr-x  2 root  mail  4096 Aug  6 13:00 mail
drwxr-xr-x  2 root  root  4096 Aug  3 19:46 opt
lrwxrwxrwx  1 root  root    4 Aug  3 19:46 run -> /run
drwxr-xr-x  5 root  root  4096 Aug  3 19:51 spool
drwxrwxrwt  2 root  root  4096 Aug  3 20:35 tmp
drwx------  3 root  bin  4096 Aug  5 20:29 webmin
drwxr-xr-x  3 eqemu eqemu 4096 Aug  5 07:32 www
eqemu@debian:/var$


joligario 08-06-2014 01:48 PM

Quote:

Originally Posted by hayward6 (Post 232587)
... I may be wrong but I believe that www folder was part of the debain deployment...

I also assumed that as it didn't look user specific. Don't forget to put it back!

hayward6 08-06-2014 01:53 PM

Quote:

Originally Posted by joligario (Post 232590)
I also assumed that as it didn't look user specific. Don't forget to put it back!

Yeah I restored it. The only think in there is the phpeditor though.

joligario 08-06-2014 05:31 PM

I just created a debian 7 VM and the default for that folder is owned by root and the chmod is initially set low. I recommend setting /var/www back to root:root with a chmod of 0777. Then, any folders inside can be 0755 while the files are 0644 and should be owned by (in your case) eqemu:eqemu. See if that works.

hayward6 08-07-2014 09:53 AM

Quote:

Originally Posted by joligario (Post 232598)
I just created a debian 7 VM and the default for that folder is owned by root and the chmod is initially set low. I recommend setting /var/www back to root:root with a chmod of 0777. Then, any folders inside can be 0755 while the files are 0644 and should be owned by (in your case) eqemu:eqemu. See if that works.

I don't understand how to do what you are saying... I can set the permissions on folders and files, but the file its writing doesn't exist, and seems to be created each time a new change is made while having the time and date in the file name... I do have the editor working now but I get an error everytime I commit a change.

I changed www back to 777. You're saying that phpeditor should be 755, so I will try that.

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)

Kingly_Krab 09-07-2014 04:04 PM

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

joligario 09-07-2014 05:06 PM

This is fixed in the editor source now. Not all new fields are supported yet, though.

Gigfel 01-19-2015 01:57 PM

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 01-19-2015 02:03 PM

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.

Gigfel 01-19-2015 02:42 PM

This is my "config.php" of the PEQ PHPEditor:

Code:

// Database Information:
$dbhost = 'localhost';
$dbuser = 'xxxx';
$dbpass = 'xxxx';
$db = 'everquest';
$mysql_class = 'mysqli'; // Use mysql or mysqli

/*  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_default_timezone_set('Europe/Paris');
$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 = 1;

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

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

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

The "access" -Logfile of the Apache says:

Code:

xxx.x.xxx.xxx - - [19/Jan/2015:19:09:43 +0100] "GET /eqeditor/index.php HTTP/1.1" 200 1704
xxx.x.xxx.xxx - - [19/Jan/2015:19:09:44 +0100] "GET /eqeditor/css/peq.css HTTP/1.1" 304 -
xxx.x.xxx.xxx - - [19/Jan/2015:19:09:44 +0100] "GET /eqeditor/images/peq_editor.gif HTTP/1.1" 304 -
xxx.x.xxx.xxx - - [19/Jan/2015:19:09:52 +0100] "POST /eqeditor/index.php?login HTTP/1.1" 302 -
xxx.x.xxx.xxx - - [19/Jan/2015:19:09:52 +0100] "GET /eqeditor/index.php HTTP/1.1" 200 1704

There is no Error in the "error" -Log of the Apache Server.
(Sorry i needed so long, but i got a phone call ...)

Gigfel 01-19-2015 03:26 PM

I have made a Alias to my private Domain to Access over the Internet the PEQ PHPEditor, because i would like to work from everywhere with this tool.

Code:

Alias /eqeditor "D:/Webserver/Domain/www.eqemulator.de"
But i get a 302 "Hijacking" -Error from it:

Code:

xxx.x.xxx.xxx - - [19/Jan/2015:19:09:52 +0100] "POST /eqeditor/index.php?login HTTP/1.1" 302
The Alias i have made on my PHPMyAdmin doesnt make such a Problem.
Anyone an Idea how i could correct it ?

P.S. I will research myself, but maybe someone had already the same Problem.

Gigfel 01-19-2015 07:47 PM

The Error is between the Ears ...
 
I had disabled the Cookie Session in the "php.ini" -File, thats why i couldnt log into PEQ PHPEditor.
The "hijacking" -Error 302, repoted by Apache itself, is only a side effect, which happens when the Editor hasnt found a available Session.
Then the Tool resets the Connection by using a "header(location: index.php)", which delivers by default the State 302.

Indicators for Coockie Session's are inactive:
1. You could access the Tool via Webbrowser
2. You could enter your Logindata
3. You dont get any Query-Log-Error in Logpath of the Tool
3. The Apache-Access-Log shows something like this:

Code:

xxx.x.xxx.xxx - - [20/Jan/2015:00:15:25 +0100] "POST /eqeditor/index.php?login HTTP/1.1" 302 -
xxx.x.xxx.xxx - - [20/Jan/2015:00:15:25 +0100] "GET /eqeditor/index.php HTTP/1.1" 200 1704

(The 2nd line shows the Reset of the Connection)

Edit:
Thanks to Joligario, whitout his hint i wouldnt have found the Problem that fast :D

Hiing 02-18-2015 01:55 PM

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 02-18-2015 02:32 PM

Quote:

Originally Posted by Hiing (Post 237992)
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 02-18-2015 05:25 PM

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.

Ignishaut 06-18-2015 03:57 PM

Suggested readme update
 
I would like to suggest updateing the readme to include setting the following in the php.ini

Code:

session.use_cookies=1
session.use_only_cookies=1

It those two tidbits had been in the readme, it would have saved me a few headaches.

(And yes I did search the boards but apparently I was not using the correct keywords to find anything meaningful.)

joligario 06-18-2015 07:55 PM

Actually, those are the default settings anyways (http://php.net/manual/en/session.configuration.php). As a side note, I have use_only_cookies set to 0 and it works fine.

tendricvk 07-03-2015 01:49 AM

having problem when I went to the page it said login disabled but I tried to login anyway now I just have a pic saying don't panic.... well I am panicking!!!

joligario 07-03-2015 07:13 AM

Check again. Does it say Guest Mode is disabled?

At the Don't Panic page, are there tabs along the top like NPCs, Tasks, Accounts, etc.?

What does it say in the url?

Did you follow the readme step by step?

tendricvk 07-03-2015 11:23 AM

I can't get to any other screen now but I remember it saying guest mode was disabled. I'll post a pic of it when I get to a pc


All times are GMT -4. The time now is 05:27 AM.

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