|
|
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/q1.jpg) |
|
![](/forums/images/Darkness/misc/q1-1.jpg) |
![](/forums/images/Darkness/misc/q4.jpg) |
|
![](/forums/images/Darkness/misc/q4-1.jpg) |
![](/forums/images/Darkness/misc/a1.jpg) |
|
![](/forums/images/Darkness/misc/a1-1.jpg) |
|
EQEmu Operations Center Web development tools |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
07-04-2013, 06:35 PM
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,589
|
|
Here's a query for mass updating a zone. Could use this until it's available on the EOC.
Code:
UPDATE npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID INNER JOIN spawn2
ON spawnentry.spawngroupID = spawn2.spawngroupID SET npc_types.stuff = otherstuff WHERE spawn2.zone = 'ZONENAME';
|
![](/forums/images/Darkness/misc/a4.gif) |
|
![](/forums/images/Darkness/misc/a6.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
09-29-2013, 05:44 AM
|
![Akkadius's Avatar](image.php?s=8fb0e0115ffcd12143be894fa6a9034f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
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/WqLaXnT.jpg)
|
![](/forums/images/Darkness/misc/a1.gif) |
|
![](/forums/images/Darkness/misc/a3.gif) |
![](/forums/images/Darkness/misc/a4.gif) |
|
![](/forums/images/Darkness/misc/a6.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-01-2013, 05:50 AM
|
![Akkadius's Avatar](image.php?s=8fb0e0115ffcd12143be894fa6a9034f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by Raghnar
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
|
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.
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)
|
![](/forums/images/Darkness/misc/a1.gif) |
|
![](/forums/images/Darkness/misc/a3.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-04-2013, 01:08 AM
|
Fire Beetle
|
|
Join Date: Oct 2013
Location: United States
Posts: 17
|
|
This is awesome. Is there anyway you can include quest modification in this bad boy?
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-04-2013, 02:05 AM
|
![Akkadius's Avatar](image.php?s=8fb0e0115ffcd12143be894fa6a9034f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by Stabones
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-04-2013, 03:44 AM
|
Discordant
|
|
Join Date: Apr 2013
Posts: 426
|
|
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.
__________________
I am the All Mighty Mittens!
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-04-2013, 04:42 AM
|
![Akkadius's Avatar](image.php?s=8fb0e0115ffcd12143be894fa6a9034f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by Nerdgasm
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-04-2013, 08:39 AM
|
Fire Beetle
|
|
Join Date: Aug 2013
Posts: 5
|
|
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!!!
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-07-2013, 10:20 PM
|
![Akkadius's Avatar](image.php?s=8fb0e0115ffcd12143be894fa6a9034f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by Aumdaydar1
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!
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-07-2013, 10:44 PM
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,589
|
|
Quote:
Originally Posted by Akkadius
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!
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-11-2013, 03:01 PM
|
Hill Giant
|
|
Join Date: Aug 2012
Posts: 205
|
|
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-11-2013, 05:21 PM
|
![Akkadius's Avatar](image.php?s=8fb0e0115ffcd12143be894fa6a9034f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by Furniture
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)
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-13-2013, 10:37 PM
|
Hill Giant
|
|
Join Date: Oct 2011
Posts: 132
|
|
can no longer connect. not sure why at this point...I haven't changed anything as far as I am aware...
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-13-2013, 10:48 PM
|
![Akkadius's Avatar](image.php?s=8fb0e0115ffcd12143be894fa6a9034f&u=100179&dateline=1673514719) |
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by kimura
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
10-13-2013, 11:44 PM
|
Hill Giant
|
|
Join Date: Oct 2011
Posts: 132
|
|
ok, I figured it out...I lost my static ip...lol
fixed and back up :P
thanks
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 01:56 AM.
|
|
![](/forums/images/Darkness/misc/s1.jpg) |
|
![](/forums/images/Darkness/misc/s1-1.jpg) |
|
|
|
![](/forums/images/Darkness/misc/z1.jpg) |
|
![](/forums/images/Darkness/misc/z1-1.jpg) |
|
![](/forums/images/Darkness/misc/side3.jpg) |