EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::GeorgeS's Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=674)
-   -   Updated Tool - EqItems Item Editor (https://www.eqemulator.org/forums/showthread.php?t=21442)

trevius 07-29-2008 04:01 AM

I got some new buttons started today. I should be able to finish them tomorrow as long as it doesn't get busy at work. I am using examples from T King UI look and EQ graphics to make them, so they should be just what you are looking for. I figure I will just give them the cool glossy look to make them stand out as buttons so that they don't blend into the background. I will also change the hue on them and make a separate set for pressed buttons.

I will make some cool radio buttons as well and some for minimize and closing the program.

I don't have paintshop pro, but I do have photoshop. So, I can't look at those PSP files, but I found another file that has the background for both the new edit and the main editor screen. Both of them look pretty good already, but I could maybe do a little bit more enhancing adjustments to them if you don't mind.

When looking through your background files, I see you have an alternative one that looks more like the actual EQ graphics with the blue background and gold trim. I could make an alternate set for those if you would want to check that out as well.

Not that the tool needs improvements in it's looks to make it work better, but since I am fairly good at it, I might as well contribute what I can.

One thing I was wondering is if you want me to keep the buttons in a BMP format, or if there was any other formats you could use to have them with transparent backgrounds? I can still make them rectangular and make them look like they are rounded corners, but if they can be transparent backgrounds, I could just leave the corners transparent.

trevius 07-30-2008 05:37 AM

The new editor seems to be working perfectly accept for 1 thing I have noticed so far. It is able to copy item lore from an existing item, but it will not save any changes to item lore descriptions. So, every time I copy an item, they all have the same lore description as the original item I copied and I can't change it with the new editor. Seems like you just need to add that to what gets saved.

GeorgeS 07-30-2008 10:26 AM

I am not sure vb can use transparent bitmaps de-nuovo without installing a ocx to load it in. I would try to use bmp if possible as that loads in fine.
Thanks for your work in making buttons and graphics.

I fixed the lore issue and the current version has the bug fix.

Thanks
GeorgeS

GeorgeS 08-08-2008 12:54 AM

Finally incorporated Trevius' buttons/skins. This was actually a big job due to the number of activeX controls which needed fixing.
Fixed a few minor things and updated the look to be a bit more eq-esque.

GeorgeS

Weldarr 08-19-2008 03:51 AM

The bard skill values for instrument mods are not working. I have to manually go in and edit them with the old edit feature to put in the correct numbers.

Numbers should be:
23: Wind
24: String
25: Brass
26: Percussion
50: Singing
51: All Instruments


Also, would it be possible to make the slots for an item checkable/uncheckable similiar to how you have class/race feature set up?

GeorgeS 08-19-2008 09:37 PM

Slots are going to be multiselect (i.e arms,legs,charm) now so that will make many people happy. The bad thing is this takes alot of code because it's not very common for multislot items. (I did check in PEQ db). So now it looks like it's working and that makes me and everyone happy!

Hopefully I will release it when I debug the last of the code. - about 70% done!

I'll look at the bard skills as well :)


GeorgeS

GeorgeS 08-19-2008 11:32 PM

Update - Finished the Slot multiselect for inventory and the ability to create items with multi slots work. You can hand type the data in since it's a text box, but use the dropdown box.

Fixed Bard skills

Changed the way the delete item was positioned and it's color - should make accidental deletes a thing of the past.


GeorgeS

Weldarr 08-28-2008 03:41 AM

Any chance of adding in a select box for the item type?

Frothel 08-30-2008 08:03 PM

Running Server for the first time
 
I have used several of the tools made by ya George, and they work great! However, this one particular program, the item maker, I cannot figure out how to make the items show up on my server. I have created two items just to test this out, and they show up in the database when I try to add them to vendors, and in the item creator, but, like I said, I cannot figure out how to get them to show up on the server. I have read all of the pages in this thread and still have not seen how to correct this on my end =) Any help would be greatly appreciated =)

GeorgeS 08-30-2008 11:23 PM

If the items were just created, a restart of the server is required. Items are loaded in during server startup in a shared memory address.

GeorgeS

Frothel 08-31-2008 02:36 AM

That worked! Thank you very much! =)

GeorgeS 08-31-2008 02:58 PM

Quote:

Originally Posted by Weldarr (Post 154842)
Any chance of adding in a select box for the item type?

Actually a good idea and am on it now.

GeorgeS

GeorgeS 08-31-2008 04:04 PM

Newest release I've been working on for a few weeks now.

- 14.2.3 - Added ability to search for items dropped by zone. Goto advanced options, then select zone. Currently you need to type in the short zone name

Also added the drop down for itemtype as requested.

GeorgeS

Weldarr 09-02-2008 01:18 AM

Thanks George, You're the best!

trevius 09-02-2008 08:18 AM

That loot by zone search is pretty cool :)

Would it be possible to do a loot by mob search to find all in the loot table for a specific mob name?

Or, even better would be if there was some way to possibly view the stats of loot directly from the loot tables of the NPC Loot Editor Tool. Having thousands of drops makes it easy for some unbalanced drops to slip in where they shouldn't be. I am mainly concerned about boss and named loot tables, so it would be nice if I could check them 1 by 1 and actually see what the loot looks like without having to summon it in game or search for it on the web or in your item editor.

trevius 09-04-2008 04:31 AM

Just noticed there is no ammo slot setting in the new item editor window. The ammo slot is 21 which equates to 2097152. Right now, all ammo slot items just show slots "none" in the window.

Also, is there any way you can set the advanced search to be default to ALL/ALL for the class and slot and also the radio button?

GeorgeS 09-05-2008 12:06 AM

Thanks for the Ammo issue -

Everquest Item Editor and Character Inventory Editor
- 14.2.4 - Added Ammo slot to editor and fixed Bots and Bots' inventory equipping and saving. A few other minor fixes.

I will work on the npc&loot editor's item stat's view - that will take a while since I need to create a 'class' from the item editor code for that to work.

Also npc&loot editor will have character (all account/character/inventory tables) backup/save/restore as well as Angelox' feature request to have Bots saved and their associated tables restore.

GeorgeS

ChaosSlayer 09-07-2008 04:11 AM

few thigns still missing - on main screen in item display window - please add Endurance after Hp and mana, and also please Endruance regeneration

thanks =)

swish 09-10-2008 11:58 AM

ways to upgrade
 
The tools are perfect Georges! I just thought I would give some thoughts for upgrades just if anyone interested.

Aza77 built a really good tool back then. Was only used for hi's server and I had the chance to use it.

Few things in the items editor that I can remember of:

1) Item ID was dynamic. I mean, lets say you click on a bronze sword and it loads the sword when it's ID is 1345.
You can then edit it or either save it as ID 1345 which will overwrite, or save it as 1346 which will either overwrite what was in 1346 or just create it if its empty.
This options replaces buttons such as: 'copy item', 'create new item' and such.
Also, that's an easy way to create a 'great bronze sword' by just upgrading some of it's stats. Great way to create item without starting from blank fields.

Also that I can remember was a weapon ratio calculator. When you enter dmg/dly, it auto calculates the ratio right next to it.

I used the tool about a year ago so I don't remember much.
If you're up to it, I can think of more stuff.

In anyway, thanks for the wonderful tools, Georges!

Swish.

Kilralpine 09-10-2008 02:47 PM

Are your mirrors down George?? ive been trying all day to download your tools and it wont ever come up :-/

Jibbatwinkers 09-10-2008 06:13 PM

Item editor works great, thanks Georges

GeorgeS 09-11-2008 01:18 AM

DSL down
 
Sorry for the webpage going down. I was switching providers and all hell broke loose. Nothing worked and modem even broke. Went to Frys and bought a new Dlink modem and placed a call to figure out the DSL settings. So finally after 3 days, I can now get the the NET. Now the next thing is getting the LAN back up and registered with DynDNS so I can get server back online.

edit 9-16-08 All back for a few days now. See sig for new url

GeorgeS

ChaosSlayer 09-16-2008 10:13 PM

George, so how about adding Endurance and Endurance Regeneration to the main screen item info display?

to save space you could put:
Hp, Mana, Endur - on the same line
same goes for:
Hp regen, Mana Regen, Endur regen.

Thanks =)

GeorgeS 09-17-2008 12:30 AM

Sorry for the late response to your original post. I'm working on the item tool now and will add this in for the next release.

So, what's in store for the next release --

/1/ Ability to copy a toon from one account to another
/2/ Equip a toon from clothing presets from real people's toon data ~900 so far
/3/ Delete a toon from any account
/4/ Save a Toon's Equipment to a (text file) database and then ability
to use that for a Bot or another toon.



GeorgeS

ChaosSlayer 09-17-2008 01:25 AM

thank you George =)

ChaosSlayer 09-28-2008 09:10 PM

somethign else for main display window I thought of:

on the line where you list: Attack Delay for weapons, you may also want to list Range (will be usefull for viewing Arrows, Bows and throwing weapons)

GeorgeS 10-03-2008 11:34 PM

Everquest Item Editor and Character Inventory Editor
- 14.2.6 - Added feature to copy and paste toons to another account. Very easy and simply to use

This is a large update and took weeks to write. The toon copying is done but a few features will be added like dynamic name changing.

Also added range, endur, and endur_regen to display window now as requested.

GeorgeS

ChaosSlayer 10-04-2008 02:04 AM

Perfect =)

mplayer254 10-28-2008 08:27 AM

Amazing
 
GeorgeS, your tools are amazing, and this one in particular has been such a huge help. I have always wanted to be able to customize some things about EQ and your editors have been a godsend. The one thing I have not been able to do after watching these forums and using all the tools the community has come out with (Thank you Cavedude, your server pack is awesome) is being able to easily edit a book's text. I have looked all over the forums and wiki, and unless I am missing a thread somewhere this is all I have found:

http://www.eqemulator.net/forums/sho...highlight=book
Somewhat helpful, except that I am not familiar with SQL (which I am guessing is what he "went into" to make the book), so I have no idea how to do what the poster is describing.

http://www.eqemulator.net/forums/sho...highlight=book
Bit more helpful, was able to do what Dudeman did and edit an existing book but still not foolproof for someone like myself that doesn't know what he's doing.

Anyway, I also scanned the Wiki and found nothing more on how to actually create a custom book. My question for GeorgeS is, is there any possibility of adding the ability to modify book text to your item editor, or is there anyone out there that could write a short tutorial on how to do it? I am rebuilding my database to include some custom content and clean up a ton of quests, and plan on posting it once it is done and I learn hot to extract it. Anyway, sorry for the long winded post, and thank you all so much for the work you've done, it is incredible!

ChaosSlayer 10-28-2008 12:03 PM

Quote:

Originally Posted by mplayer254 (Post 159254)
GeorgeS, your tools are amazing, and this one in particular has been such a huge help. I have always wanted to be able to customize some things about EQ and your editors have been a godsend. The one thing I have not been able to do after watching these forums and using all the tools the community has come out with (Thank you Cavedude, your server pack is awesome) is being able to easily edit a book's text. I have looked all over the forums and wiki, and unless I am missing a thread somewhere this is all I have found:

http://www.eqemulator.net/forums/sho...highlight=book
Somewhat helpful, except that I am not familiar with SQL (which I am guessing is what he "went into" to make the book), so I have no idea how to do what the poster is describing.

http://www.eqemulator.net/forums/sho...highlight=book
Bit more helpful, was able to do what Dudeman did and edit an existing book but still not foolproof for someone like myself that doesn't know what he's doing.

Anyway, I also scanned the Wiki and found nothing more on how to actually create a custom book. My question for GeorgeS is, is there any possibility of adding the ability to modify book text to your item editor, or is there anyone out there that could write a short tutorial on how to do it? I am rebuilding my database to include some custom content and clean up a ton of quests, and plan on posting it once it is done and I learn hot to extract it. Anyway, sorry for the long winded post, and thank you all so much for the work you've done, it is incredible!

the book is an item. whats writen inside a book is stored in books.tbl table which corespand to the property of the field "book" in items table

so take any book in item editor and look at "book" field and you will see the short id name of the book text

then open mySQL browser. and simply open books table, find row with the same name and edit away like in notepad

trevius 10-28-2008 04:39 PM

This is getting off-topic for GeorgeS' Tools. But, here is the wiki page for the books table:

http://www.eqemulator.net/wiki/wikka...uDBSchemabooks

Try installing Navicat and looking at the table with it. It shouldn't be hard to figure out what to do by looking at the other examples. You will probably want to copy a book or 2 into Notepad so you can view them and/or edit them to create a new book's text.

mplayer254 10-29-2008 08:32 AM

Thanks all, I was able to get Navicat, find the Books Table and modify a few existing notes/books, but I was wondering if anyone has had this issue: when I create a new book in GeorgeS's item editor, I am unable to then find the shortname entered in the copy/edit screen for the new item in the Books table. If this is off topic, please feel free to move my post, I thought perhaps GeorgeS might have some insight on this so I posted it here. Chaosslayer and Trevius, thanks for the help!

mplayer254 10-29-2008 08:40 AM

Tried to just edit post but couldn't, I realized as soon as I went back into to Navicat that there was a big "+" button staring me in the face in the table view window :oops: Added the shortname field I wanted and am testing now on the server. Thanks for going easy on me after my first post!

spider661 02-07-2009 12:12 AM

i noticed in 292 they changed the aug slots in the item field name is this going to affect the editor im guessing it will are you planing on doing an update.. or is the source code up to date so i can make the change? also my npc editor has not worked for changing spawn timers seance they changed how spawns work is there going to be a fix soon? i have had to do all the changes in navicat and my other gms don't know how to do that lol

GeorgeS 02-08-2009 05:42 AM

I'm working on the changes.
Should'nt be more than a day or so to get it done


I'm trying to find the latest items.sql, can someone point me to the link please.


GeorgeS

spider661 02-08-2009 03:34 PM

sure
http://code.google.com/p/projecteqem...c=svn292&r=292

GeorgeS 02-10-2009 10:39 PM

As mentioned in another post,

Fixed the program to handle the latest schema

Everquest Item Editor and Character Inventory Editor
- 14.4.0 - Added support for items table SVN schema 292 i.e change all columns from `augslotxunk` to `augslotxvisible`


Finally, it's done, but please let me know if there are other issues.

Another source of crashes occur when a null is in a field when one cannot exist, and that will make the program crash. There is no fix for this. Make sure your tables are ok - especially if you update often. I rarely update the items table, except for the schema.

GeorgeS

gmraiford07 02-12-2009 02:43 PM

heh georges i also found out that when say i take 1 item and i decide to copy it 3 times to edit it the first and third copy work but the second when i go to edit pops up with an error saying you cannot edit an item that doesnt yet exist lol but i figured it was just something wrong with my item so i went into navicat to check it and everything was fine so tried again and same error but if i rename the item in navicat everything works it wasnt really a problem but just figured you might of wanted to know about it :)

ChaosSlayer 02-12-2009 03:24 PM

George, with the latest updates to DB schema your Spawn Editor no longer works - it requres that you remove the timeleft field from it.

Also, still trying hard to get your attention here:

http://www.eqemulator.net/forums/showthread.php?t=26667

thanks =)

GeorgeS 02-14-2009 02:29 AM

The spawn editor standalone is depreciated several months ago. It
is now incorporated into the NPC loot editor.

The item editor appears to work with the current schema ver 292.
I did find a bug in the copy routine, and it should be fixed now.

Please DL ver. 14.4.1

GeorgeS


All times are GMT -4. The time now is 05:33 PM.

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