projecteq / peqphpeditor Goto Github PK

Should have LDoN template and trap data on one page together (e.g. Merc Spells, Merc Merchant Templates)

Hi, I did a fresh installation of eqemulator on ubuntu, and installed PEQ Editor. Everything seems to work fine including the PEQ Editor, however, I received this error when I login to PEQ: "Your database schema (9164) does not match the current binary database version (9163). You may experience errors or inaccurate data if you continue."

Does anyone know how I can fix this error? Thanks.

This is a "perma" buff from an aura.

Player Event Logs has event data in JSON format. Should break those out into human-readable format

PEQ uses PVP points to award bug points. Need to add editor to handle those points. Character must be signed out of game otherwise their in-game values overwrite database entry at character save point.

Issue:
Currently there is no way to add pre-existing lootdrop tables to the loottable_entries of a global loottable. It only allows you to create new ones. This feature request is to provide the options for searching by name or entering an existing lootdrop ID

Discussion:
When we want to add a lootdrop to a loottable for a single NPC, we do the following:

1. Click the yellow + icon next to the label that reads, Lootdrops associated with this loottable:
   
2. Decide an option from one of the following:

• Search for a Lootdrop by Name
• Enter a Lootdrop ID
• Create a New Lootdrop
  .

For Global Loot, when we want to add a lootdrop to a loottable, we do the following:

1. Click the yellow + icon next to the label that reads, Lootdrops associated with this loottable:
   

2. It assumes "Create a New Lootdrop", and takes us straight to the template for "Add New Lootdrop".
   

Doing this, allows me to run a database query to add existing lootdrop tables:

INSERT INTO loottable_entries (loottable_id, lootdrop_id, multiplier, droplimit, mindrop, probability)
VALUES ('110562', '7638633', '1', '1', '0', '10');

using the peqphpeditor interface instead of switching to a SQL client.

I intend to work on this feature myself, but adding this issue here for transparency/feedback. Am I not considering a limitation in how global drops are supposed to work?

Change Level function while editing an NPC fails because it is missing the newer fields such as charmed stats.

rev2100
no forage skill for druid and ranger.
is this normal? for rev2100?

Original issue reported on code.google.com by [email protected] on 14 Apr 2012 at 8:58

The fix I threw together was:
field151 to no_partial_resist
field159 npc_no_los
field161 reflectable
field168 IsDiscipline
field175 numhitstype
field189 MinResist
field189 MaxResist
field194 ConeStartAngle
field195 ConeStopAngle
field197 not_extendable
field200 suspendable
field202 songcap
field208 rank
field211 CastRestriction
field213 NotOutofCombat
field214 NotInCombat

replace the left field with the right info inside file: trunk/lib/spellenums.php

Original issue reported on code.google.com by [email protected] on 5 Aug 2014 at 11:57

Counter Avoid Damage (44) should be an input field as it has multiple params rather than the 44,0 for all.. should be... 44,1,X for "All"

We are getting some zone crashes on the new binaries related to the character_pet_buffs table. Value out of range for caster_level (usually something high like 90+) and the only way to fix the crash is to delete the offending line. This has effected every class we've played from warriors and paladins (no pets) to magicians. The buffs are not cast by us nor are they spells we would cast as buffs on pets. It happens during the zoning process, injects a bunch of data into the pet buffs table, then crashes the zone. The zone will continue to crash until the buffs are deleted from the db. It seems to be random when/why it happens but it's happening often enough that it's not truly random.

log.txt

Spell Effect: Leap ID is 384 not 383.

Was trying to add a Leap effect to a spell via the PEQ Editor and found 383 not 
to work, on lucy's it has the ID of 384:
http://lucy.allakhazam.com/spell.html?id=13599&source=Live

Editing to 384 manually in the DB made leap work.

Original issue reported on code.google.com by [email protected] on 26 Feb 2013 at 9:22

Interface for adding pets is obscure and error prone. There isn't a way to correct invalid pet entries. There also needs to be a way to view existing pet entries not assigned to NPCs for view, edit, assign, and delete.

Need to identify new or additional options for assigning NPC IDs as we run out of numbers for global NPCs such as pets.

Formula behind the scenes doesn't make any sense.

    $total = (($chance/100) * ($lootdrop['probability']/100)) * 100;
    $chance_total += $chance;
    if($lootdrop['probability'] == 0)
      $chance = 0;
    if($lootdrop['probability'] > 0 && $lootdrop['probability'] < 100)
      $chance = $total;
    if($lootdrop['probability'] >= 100)
      $chance = $chance;

$chance_total not used, of course $chance = $chance, etc.

https://discord.com/channels/212663220849213441/1077318717035253781

What steps will reproduce the problem?
1. Setup nginx server
2. configure to serve peqphpeditor
3. navigator to page and try to log in

What is the expected output? What do you see instead?
I expect to be able to log in

What version of the product are you using? On what operating system?
Current, Centos 5.5, Nginx web server

Please provide any additional information below.
I am curious how to set this up on nginx to work. When I try to log in or hit 
any page for that matter, it just redirects me back to the login page. I dont 
think I have my location rules setup properly, but I could be wrong. Here is 
config:

server {
  listen 80;
  server_name **.*********.***;
  access_log /var/log/nginx/**.*********.***/access.log;
  error_log /var/log/nginx/**.*********.***/error.log;

  root /var/www/**.*********.***;
  index index.php;

  location / {
    try_files $uri $uri/ /index.php;
  }

  location ~ \.php$ {
    include /etc/nginx/fastcgi_params;
    fastcgi_pass 127.0.0.1:9900;
    fastcgi_index index.php;
    fastcgi_param SCRIPT_FILENAME /var/www/**.*********.***$fastcgi_script_name;
  }
}

I removed actual url for *. Any help? Thanks

Original issue reported on code.google.com by [email protected] on 29 Apr 2011 at 2:26

Hi, we have get some bad write on npc Special Abilities, so i have investigate and see all the time is rewrite.
Is just a problem on the last ^ separator need to be removed
just adding this line to check and remove it: if(SUBSTR($new_specialattks, -1) == '^'){$new_specialattks = SUBSTR($new_specialattks, 0, -1);}

Line 1282 npc.php file
// Check for special attacks change
$new_specialattks = '';
$flag = 0;
foreach ($specialattacks as $k=>$v) {
if (isset($_POST["$k"])) {
if(SUBSTR($_POST["$k"], -1) != '^' && $_POST["$k"] != ''){$_POST["$k"].= '^';}
$new_specialattks .= $_POST["$k"];
}
}
++ if(SUBSTR($new_specialattks, -1) == '^'){$new_specialattks = SUBSTR($new_specialattks, 0, -1);}

if ($special_abilities != $new_specialattks) {
$flag = 1;
}

I dont know where is from my background problem on badly rewrite. Gm see sometime white screen on save npc editor and also Internal error when specialattks is corrupted.
The only why is fix manually in the DB

Stable dump of PEQ PHP Editor as of 31 JAN 2015, version r466.

Original issue reported on code.google.com by [email protected] on 8 Feb 2015 at 3:00

Attachments:

• peqedit_r466_20150131.zip

When using the searchbar to select zones, we should have a version field vice duplicating zone entries for each version.

Before: https://discord.com/channels/212663220849213441/557677602706423982/1077327763746328670

After: https://discord.com/channels/212663220849213441/557677602706423982/1077328181259931778

To Fix 502 Bad Gateway return, need to update_spell() with php 7.2

line 251 in spells.php:
if($vars[$f] != stripslashes($_POST[$f]) and isset($_POST[$f])) { $fields .= "$f = "$_POST[$f]", "; }
to
if (isset($_POST[$f])) {
if($vars[$f] != stripslashes($_POST[$f])) { $fields .= "$f = "$_POST[$f]", "; }
}

We should add the ability for authorized users to enter raw queries.

I wrote a docker build of this awesome editor and a PEQ database container at https://github.com/nathanhicks/docker-peqphpeditor and was wondering if there was any interest in adding that to this repository or linking to it somehow? Thanks and I appreciate you posting this app!

There are only two roles you can assign: Admin and User. We should add more roles for flexibility in tool use.