Akkadius and Trevius, at a glance this looks fantastic and will hopefully replace the tools I've been writing for myself! I'll give it a good workout over the next month or so and provide feedback.

Any preference on how you want to track feedback?

Added your Mysql instructions to the placeholder post.

As far as feedback, I've used the tool extensively myself and I kind of know what needs to be done, however it doesn't hurt to have more.

EoC has been getting used very much but no one has been really coming forth and saying anything about it. But I know who is using it based on IP requests :)

The tools we created in it help a lot for customization development, but the PEQ Editor still is very much used by myself, very easy to setup.

Make sure your MySQL connection isn't set up to use @% hostmasks. There was a pretty big exploit regarding that a few months back (that was patched in recent versions), and make sure you have a proper firewall installed for the MySQL server to prevent further exploits:

http://thehackernews.com/2012/06/cve...ous-mysql.html

EOC is the only tool I use now. There are a few things I cannot do here that I still do by hand in the db itself, but EOC is much easier.

Task editing seems a little buggy and updates to fields sometimes do not show up, but as long as I am paying attention and know which ones I have updated then no problems and the tasks work fine.

If I am mass tuning npcs in a zone then it is usually just easier to do that in Heidi or MySQL Command Center, but for tweaking individual npcs or loot tables I use EOC.

For some reason when editing spells if the spell is checked as uninteruptable, EOC's query fails on update:

Query failed:
UPDATE spells_new SET `uninterruptable` = "on" WHERE id=1617 - Incorrect integer value: 'on' for column 'uninterruptable' at row 1

Sounds like you're using the PEQ Editor - which is going to fight with database schematic differences as well.

I've had a few things bomb out in PEQ Editor as well but nothing too crazy.

I could probably look at upgrading that partition of EOC.

As far as mass zone NPC editing type stuff, I do a lot of that through queries myself, though I have had thoughts in my head about doing mass NPC editing through EOC but I've been busy with other things.

As far as the task updating 'bug' what that really is, is you haven't changed the activity type value. This isn't necessarily an issue with you as it is the task editor should default that field to something else initially because it only 'updates' when the field has been changed, this is simple to fix. EDIT: I fixed the bug, the first field that pops up initially is '--- Select Activity Type ---' which defaults to 0, whenever the field changes it will update accordingly

Here's a query for mass updating a zone. Could use this until it's available on the EOC.

EoC Changelog 9/29/2013

Been a while since I've pushed changes to this bad boy, but I sure use it all of the time, and many others have been using it as well.

• Vastly Improved Item search functionality, some things were completely hosed that I debugged
• Added another Item Edit 'View' called 'Full View', this resembles a full page editing interface similar to Georges Editor
• Fixed Music toggling for the Item Editor
• Revamped many visuals for the Item Editor to easily distinguish fields
• Added a feature where if any field is 'changed' the field will change to yellow to show that it has been changed until you save that item to the database, this helps with keeping track of what you've touched on the item
• Created Item Editor sub-tool called 'Auto Scaler' which is now in BETA, the first scaling ability I've added is the ability to scale stats based on a percentage per groupings, this will update the item instanteously once you feel your statistics are where you want them
• Added a link to the Icon Viewer on the main menu
• Added a link to Races Viewer in the main menu
• Added a link to the Weapons Viewer in the Main Menu

http://i.imgur.com/QSFuqpq.png
http://i.imgur.com/WqLaXnT.jpg

This is a late post but I am responding anyways.

The issue with spells was fixed a while ago.

Also with your comment regarding a NPC Editor, I just got done finishing making a Georges inspired NPC Editor you can find on the menu

I plan on adding more searchable filters, most important of all this tool is extremely responsive.

http://i.imgur.com/YPLKRy5.png

Here is a picture of me using it for some tests, you can do some serious damage with it and it is in its very early stages (BETA):

http://i.imgur.com/McwiF5y.png

This is awesome. Is there anyway you can include quest modification in this bad boy?

Actually, I'm working on it - It will require the server operator to setup FTP though. But it should be pretty slick. Also offering a central repository for people to post script snippets as well if they want to share them.

After tinkering around it for a bit, I can honestly say without a doubt this is one of the best item editors I've found out there, yes, Geroges is awesome, I won't deny that, but having to alt tab to find the items you want, and such was kind of a pain, and confusing. This has everything combined in it for items, and actually makes it WORTH the while DOING the items. I've only really used it for the Items, as that's all I wanted help with, and as I stated before, I love it, good job, Akka, good job whoever else helped make this. amazing work.

Good! Glad people are starting to realize how powerful of a tool it really is and should see it progress over time.

And as far as who has worked on the project, Trevius and I have off and on for a while.

This tool is amazing, it's so much faster @ item customizing that GeorgeS Tools or any other tool that i've used for that matter...

Great job guys, please keep up the wonderful work!!!

Thanks for the feedback! I've been getting a ton of use in the logs recently, thousands of web requests a day!

Hey Akkadius, just wanted to say I love this, solely due to the use of PHP over C#, C++, or Java, thus the ability to make it so dynamic and it be much more efficient and easier to use for the community. Keep up the good work, I hope see a lot more viewers in the Operations Center in the future!

This tool is awesome the only thing I suggest is if its possible could you arrange the zone drop down list in the npc editor to be arranged by the shortname of the zone instead of in numerical zone# order. For example I tried to find sebilis, typing "sebilis" or "old sebilis" in the drop down would bring me to other zones but not sebilis. Scrolling through each zone one by one is a pain, so I had to get the zone number elsewhere and then find it.

Makes sense.

Done

Highlight the selector and just start typing the zone shortname

http://i.imgur.com/jVcXtPz.png

can no longer connect. not sure why at this point...I haven't changed anything as far as I am aware...

Clear out your cookies, make sure you aren't using any sort of popup blockers.

ok, I figured it out...I lost my static ip...lol

fixed and back up :P
thanks

You don't lose your static IP, you lose your public DHCP IP :)

Would it be possible for something similar to this to be added to the EoC?

Click on X icon and it shows all the IDFILEs associated with that icon. (this example uses base peq icons -> idfiles)

(Mine is kinda noobish .. though :) )
Hovering the picture will give you the IDFILE (the ones with boxes have IDFILEs associated with them in the base PEQ database)

http://i.imgur.com/RUfmrTn.png


Used a script to pull 1933 Arrays from the databse..

icon -> (idfile, idfile) ect ect..


Not sure if you are taking requests but this would be really awesome to see on the EoC :)

oh ok, well i set up my static ip from my router guide again and it works now, *shrug* lol thanks akk!

Would be pretty simple to add. I will add it when I am working on things next.

Cgnat
 

Hi all, I just changed ISPs and didn't realize that the new one was using CGNAT, they had the info hidden pretty well but that's beside the point.
After looking around a bit I'm still in the dark as to how or if there is anything I can do about this. I'll find another ISP but in the interim I'm wondering if there is a work around?
Will a VPN get me past CGNAT? I'm working on a server but am a long way of making it public so the latency isn't really too much of an issue.
I can also use SQL commands and Georges tools but this seems like a much better option.

CGNAT shouldn't keep you from using this - they should be able to adjust your circuit to be able to support such things as needing to direct particular ports for traffic. That is something you need to take up with them.

They should be able to and can from what I understand but at this early stage it is a flat no from my contact with them. Willing to let me go as a customer rather than create a solution that I even said I would pay for. I'm guessing I'll be better off elsewhere anyway ;-)
I'll just research VPN and give it a shot.
It does pose a bigger question though, seems from my research that this is going to roll out pretty much everywhere soon under the guise that IPv4 is running out of IP numbers. This may be sort of true but there is other options to controlling us like this, and it looks like ISPs will use this to create another user charge. Only when everyone stands up to them will they buy the hardware for IPv6 and move on, you know how it goes, get everything out of the old hardware before you move to what is out there.

Managed to actually get this setup and working I tried to get AllaClone and PEQ PHPeditor working on my xampp server, but I couldn't manage to make either work right. From what I can see EOC is amazing this is going to make so many things much much easier and quicker. Anyway time for sleep for me, but I'll defiantly be messing around with this tomorrow a lot.

It's definitely incredibly convenient - I use it for several different DB's to manage and I don't have to install anything additional. My only cost of ownership is having to maintain it and develop new stuff :P

I've had a chance to look it over a bit more it's quite nice it's pretty straight forward from the looks of it. Great job and thanks a lot for making this tool and providing access to it for the community as well.

A few things, I think turned allow remote access OFF, any thing i can do to turn this on?

and B, when using a router do i still use the computers IP Address along with the :3306 at the end to log into this thing? or do i use my modens IP with :3306?

Rile - You use your public IP address - this tool is routing over the internet to get to your Mysql server. If you don't know where to find this - you can find it at whatsmyip.org

You will need port 3306 'Forwarded' to your internal machine on your network, however when typing your public in EoC - it is implied that you are using 3306 so you do not need to set it

Dont think..?
 

I dont think I set allow remote access when i installed this mysql, everything else now seems to be set in place.

When i attempt to log in it says it cant connect to server / DB

I know my DB name is peq, i know my user name, PW, only thing in question since im behind a router is; IP.Port...I know what my IP address is for the computer I put that in, along with port:3306, still fails to let me in with no idea whats really stopping me im currently stalled out :( Think it might be my modens IP address and not my computers IP address?

Any sugguestions?

As suggested in the first post, you will most likely need to create a custom user that can access your database table. Recommended installs have 'root' user connections prohibited from the outside world. You will need a user that can access the DB from the outside world such as mentioned in the first post. I also answered your questions regarding IP:Port on the edit on my post before

Glad you have found it useful. I've had many many folks using it lately.

Hm. Even when I've followed the posted information, still says Cannot connect to server! Connet connect to database "peq"!

Im using all the same information at the Login, as I entered when creating a duplicated User. Even deleted THAT user, and created a new User incase i missed something, and same overall result. bummed out this looks like alot of fun!

Are you forwarding ports at your router correctly?
Are you allowing 3306 through your Windows Firewall?
Are you sure you are using the same exact credentials you made in your user

When you make your user you need to make sure that you don't use the IP address of YOUR machine - because it is specifying what IP address the user will connect FROM if you wanted to restrict it, otherwise % means any host.

All of these things have to be set up correctly or it simply won't work. Once it does - you'll be really happy. :-D

I feel I have....followed it step by step. Its crazy its failed to really work lol. But upon install of mysql I did uncheck allow remote access. Or somewhere down the line where it asked me to allow it I did uncheck allow remote access and I think thats what the problem is.

I was asked this during the run your own server install and set up. I believe this box was unchecked during an install. Again I'm sorry about the noob question and problems. New to a lot of this but I'd like be become a part of all this. I see a lot fun interesting things other severs have done and I'd like to be part of this great community. So thank you for the help upto this point.

The part of the install that you check/uncheck is remote root access - which should be disabled.

You create a separate user for that function.

What type of scripting is the "Zone Tools" my Mozilla keep blocking it. :(

It does however work on my Internet Explorer (but I hate IE) and it is really awesome.. I just want to get it working on my Mozilla.