[Release] Shop Generator

Hey guys,
today im going to release my Silkroad Shop Generator which allows you to add custom items to shops with one click.

[Features]:
- Read shops from database (and also the items in shop)
- Create a new item and add it to the selected shop.
- Compile the item to .txt, too for the client.

[Picture]:

[Database connection]
http://i50.tinypic.com/20av24w.png

[Load shops from database]
http://i47.tinypic.com/2ni4587.png

[Query items in shop]
http://i50.tinypic.com/ztte20.png

[Validate item & import]
http://i45.tinypic.com/169mexd.png

New function 'Item list & search'
http://i48.tinypic.com/kedxn5.png

Info:
Clientfiles will be located under \output\????.txt.
-Database will be updated automaticly.

My program is a robot so it's stupid, allways check the database again!

Changelog:
1.03
{
+ Added item loading for Item PK2 name
+ Added "Change Price" for gold priced items (need to modify your client manually)
* Improved item validation
}
1.02
{
* Improved shop validating
+ Added auto complete for Item Description & Item Label
+ Added "Refresh List" to item list.
- Fixed refpackageitem.txt generation (Removed 1 tab-space)
* It will now ignore slots with service number '0'. -> Those can be used now, too.
}


DOWNLOAD:
1.03

Quote:

---

http://localhostr.com/dKzHNsZ9AklI

---

1.02

Quote:

---

http://lh.rs/0yal9bQETomU

---

1.01

Quote:

---

http://lh.rs/r4Ij4k8tcYgd

---

1.00

Quote:

---

SSG_1_00.zip | localhostr.com - share … anything

---

nice work ,now testing and I will give you feedback later

Try and feedback !

Thanks :)

Quote:

---

Originally Posted by torstmn

[Database connection]
http://i50.tinypic.com/20av24w.png

---

Make it simple ! Just one textbox, end-user will paste FULL connection string and press 'connect' :w00t:

i'll try it and nice!

Will try it! Awesome!
Posted via Mobile Device

Quote:

---

Originally Posted by myShinichi

Try and feedback !

Thanks :)



Make it simple ! Just one textbox, end-user will paste FULL connection string and press 'connect' :w00t:

---

OR simple config.ini or config.cfg whatever you can do

@CEZALAND, yeah I'll do this! - Thought about this allready but I was too lazy o.O

LOL~ Nice.


Um, I rebuilt the entire silkroad shop database + media side to follow indexing standards. This looks really nice, hopefully it works with my new designs.

Quote:

---

Originally Posted by myShinichi

Try and feedback !

Thanks :)



Make it simple ! Just one textbox, end-user will paste FULL connection string and press 'connect' :w00t:

---

Really? I don't think it can get any simpler than this, anything else is the same.

Quote:

---

Originally Posted by torstmn

Hey guys,
today im going to release my Silkroad Shop Generator which allows you to add custom items to shops with one click.

[Features]:
- Read shops from database (and also the items in shop)
- Create a new item and add it to the selected shop.
- Compile the item to .txt, too for the client.

[Picture]:

[Database connection]
http://i50.tinypic.com/20av24w.png

[Load shops from database]
http://i47.tinypic.com/2ni4587.png

[Query items in shop]
http://i50.tinypic.com/ztte20.png

[Validate item & import]
http://i45.tinypic.com/169mexd.png


Info:
Clientfiles will be located under \output\????.txt.
-Database will be updated automaticly.

My program is a robot so it's stupid, allways check the database again!




DOWNLOAD:
1.00

---

Big THX :love::love::love:

Have features add that textdata into media.pk2 directly ?

Lol, just import them -_-.

nice work broo thanks :D

Released 1.01:
+ Added import of database connection info by .dat file.

Download: SSG_1_01.zip - Localhostr

How to setup database connection:
Navigate to your SSG_1_01 folder and open the file "connection.dat" with any text editor.

Then replace the given strings with your info. The program will not save this file to prevent any kind of hacking blah blah.

Released v 1.02

Download: SSG_1_02.zip - Localhostr

* Improved shop validating
+ Added auto complete for Item Description & Item Label
+ Added "Refresh List" to item list.
- Fixed refpackageitem generation (Removed 1 tab-space)
* It will now ignore slots with service number '0'. -> Those can be used now, too.

btw , i see in pictures u cant change the Price ( Gold ) 1 - or im wrong?

A few suggestions,

create a data file with item, shop names. (can be obtained from Media) and display that instead of ITEM_% SHOP_% etc.
remove 'Shop' column, already know what shop we are in with the selection above, makes everything cluttered

here is a file with PACKAGEITEM \t Name formatted for every single item in the game. see if you can use

www.srodev.net/public/downloadsf/itemname.dat

It's impossible to create a item-data-file. Many user will add new stuff like 'HP-Potions XX-Large'. But in the next version there will be a item PK2 name validator (checks _RefObjCommon for the PK2 name).

Quote:

---

Originally Posted by torstmn

It's impossible to create a item-data-file. Many user will add new stuff like 'HP-Potions XX-Large'. But in the next version there will be a item PK2 name validator (checks _RefObjCommon for the PK2 name).

---

look at this pseudo code

Code:

---

string package_name_data, package_name_db, item_name;
vector<Items> item_data;
if (some loop) {
    package_name_data == loop;
    return item_name;
}

else return package_name_db;

---

You can easily store item data in a vector and iterate over it to check if package_name is in the vector, if it is then return matching item_name if it's not then return package_name in database.

Also sorting the data view in the table by slot from n -> n+ would be good too.

You don't need to show me how to code stuff. I'm no beginner (thanks anyway). I see that as suggestion, if I implement it -> my choice. I could load the _RefObjCommon and filter ITEM_ entries. But that would fu** up your RAM. Also I would need to implement a search function to get the correct item and for that I'm too lazy..

Released v 1.03:

Download:SSG_-1_03.rar - Localhostr

1.03
{
+ Added item loading for Item PK2 name
+ Added "Change Price" for gold priced items (need to modify your client manually)
* Improved item validation
}

good work

Thanks you Work Exelent!
Here the screenshot :D :thumbup1:Attachment 105247
!!

Link off? i cant enter..

It seems like 'localhostr' has a problem. If the link will be down until tomorrow I'll reupload the program.