projecteq / peqphpeditor Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/peqphpeditor
Automatically exported from code.google.com/p/peqphpeditor
There are only two roles you can assign: Admin and User. We should add more roles for flexibility in tool use.
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.
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.
Player Event Logs has event data in JSON format. Should break those out into human-readable format
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:
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!
This is a "perma" buff from an aura.
Change Level function while editing an NPC fails because it is missing the newer fields such as charmed stats.
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.
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
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:
For Global Loot, when we want to add a lootdrop to a loottable, we do the following:
Click the yellow + icon next to the label that reads, Lootdrops associated with this loottable:
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?
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
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.
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
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
Need to identify new or additional options for assigning NPC IDs as we run out of numbers for global NPCs such as pets.
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.
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.
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
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
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"
Should have LDoN template and trap data on one page together (e.g. Merc Spells, Merc Merchant Templates)
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.