DOL Merchant Inventory Builder

A forum for development and discussion on third party tools such as the Quest Designer

Moderator: Project Admin

DOL Merchant Inventory Builder

Postby tegstewart » Wed Mar 15, 2017 9:20 pm

After putting together the INSERT statements for one merchant by hand, I decided I never want to do that again. So I banged out this quick and dirty tool late last night to do it for me.

Put in the ItemListID, pick a page number, and enter your ItemTemplateIDs in the text boxes. When you're finished, hit generate and it will copy the statements to the clipboard and display them in a textbox so you can inspect them and copy them out if the clipboard copy fails. Click Next Page to increment the page number and empty the ItemTemplateIDs for the next batch.

https://sourceforge.net/projects/dolmer ... tory/files
tegstewart
Developer
 
Posts: 102
Joined: Sun Dec 13, 2009 11:46 pm

Re: DOL Merchant Inventory Builder

Postby HunabKu » Thu Mar 16, 2017 8:25 am

Thanks tegstewart.
Can you share the sources please ?
"C'est l'ignorance qui apporte le chaos, pas la connaissance."
Scarlett Johansson dans "Lucy" de Luc Besson
-------------------------------------------------------------------------------
"Ignorance brings chaos, not knowledge."
Scarlett Johansson on "Lucy" by Luc Besson
User avatar
HunabKu
Developer
 
Posts: 1905
Joined: Sat Jun 18, 2011 4:48 am

Re: DOL Merchant Inventory Builder

Postby Graveen » Thu Mar 16, 2017 8:43 am

Thank you !!

Do you had a look at CreatorSuite (previously ItemCreator) from Merec ? This is a consistent tool that allows you to create/update stuff for DOL.
This is exactly such a tool that i'd like to see being improved.

I'm not sure Merec released the sources publicly, honestly :D

edit: CS url link: http://www.dolserver.net/viewtopic.php?f=13&t=17029
Image
* pm me to contribute in Dawn of Light: code, database *
User avatar
Graveen
Project Leader
 
Posts: 12660
Joined: Fri Oct 19, 2007 9:22 pm
Location: France

Re: DOL Merchant Inventory Builder

Postby Graveen » Thu Mar 16, 2017 8:47 am

I'll try to see what tools are availables and make a quick point to see what maintains, what improve, what discard.
Image
* pm me to contribute in Dawn of Light: code, database *
User avatar
Graveen
Project Leader
 
Posts: 12660
Joined: Fri Oct 19, 2007 9:22 pm
Location: France

Re: DOL Merchant Inventory Builder

Postby HunabKu » Thu Mar 16, 2017 8:56 am

Yep really sad Merec publish MapCreator sources but not CreatorSuite.
"C'est l'ignorance qui apporte le chaos, pas la connaissance."
Scarlett Johansson dans "Lucy" de Luc Besson
-------------------------------------------------------------------------------
"Ignorance brings chaos, not knowledge."
Scarlett Johansson on "Lucy" by Luc Besson
User avatar
HunabKu
Developer
 
Posts: 1905
Joined: Sat Jun 18, 2011 4:48 am

Re: DOL Merchant Inventory Builder

Postby tegstewart » Thu Mar 16, 2017 8:37 pm

Thanks tegstewart.
Can you share the sources please ?
Honestly, it's like 3 hours work and incredibly sloppily coded, so I'm kind of embarassed by it.

I'll put the code up anyway.
tegstewart
Developer
 
Posts: 102
Joined: Sun Dec 13, 2009 11:46 pm

Re: DOL Merchant Inventory Builder

Postby tegstewart » Thu Mar 16, 2017 8:42 pm

Thank you !!

Do you had a look at CreatorSuite (previously ItemCreator) from Merec ? This is a consistent tool that allows you to create/update stuff for DOL.
This is exactly such a tool that i'd like to see being improved.

I'm not sure Merec released the sources publicly, honestly :D

edit: CS url link: http://www.dolserver.net/viewtopic.php?f=13&t=17029
I noticed it when I came on here to post this, and took a quick look. I haven't done much with it yet, though.

I'm really finicky about doing things in the db by hand and storing all the statements I used to do so. When I finish my DB changes, I want to wipe and redo the DB from scratch, run all the .sql files to add the changes, and then upload that so I know any mistakes I made during development don't end up in the final product.
tegstewart
Developer
 
Posts: 102
Joined: Sun Dec 13, 2009 11:46 pm


Return to “%s” Third Party Tools

Who is online

Users browsing this forum: No registered users and 1 guest