SYC's Vendor Generator Beta Upgrade

[sycspysycspy]

Here's another release. for those people who are trying to create vendor. you can try this.

New features:

Added check box to the datagridview,you can choose items that you want to keep from the query result
All the items will be generated with the max amount(200 for ammo, arrow, thrown weapon etc)
Read the excel file to learn about how to query the ITEMS table


Hope my programme would help you. Enjoy!
:cool:
I am writing the programme for my own interest. So I do not expect reply or rep. Got any question you can pm me.


DOWNLOAD NOW! (http://filebeam.com/d198ade3d0eab47af4a7bbbd8f26157e)

http://img116.imageshack.us/img116/6288/sycvendorgenft7.th.jpg (http://img116.imageshack.us/my.php?image=sycvendorgenft7.jpg)

[zeal_aiz]

This seem really nice. What is it compatibility? ArcEmu, Aspire or other? Are u from Singapore?

[sycspysycspy]

Yes, I am from Singapore Polytechnic Diploma in IT year 3.
So far it work with arcemu, I am not sure with aspire, the database looks the same as arcemu though. I am sure that it can NOT work on mangos.

[zeal_aiz]

Nice to meet u. I'm from ur neighbour country, Malaysia:p I already take a look at ur code and application, it really good, i like the idea and concept. Except there is some error in table structure which not compatible with latest ArcEmu structure. Eg: vendor query miss one column which is extended_cost

U really should develop this tool and I can help too eventhough I'm not IT student like u (I'm engineering degree) but I learn basic programming. PM me if have a new version one so i can take a look and help a bit:D

Btw +rep. Everyone should try this. I can teach a little bit how to use it.

p/s: Added compile one which i fix a little bit (compatibility with ArcEmu, table info that i think important, icon, etc.)
HERE (http://filebeam.com/193f65b88461f939fa499ed95909495a)
Gonna added guide soon

[sycspysycspy]

I was quite disappointed for a time because nobody really understand me and wad I have done, but now even more because my laptop spoiled yesterday. It ruined my xmas mood!!!
-_- T_T
Thanks you Zeal_aiz, I am glad to meet u too. You "light up my hope" and I would continue and update the programme. lol

[zeal_aiz]

no prob bro:p who make u that way?? Keep up good work!! And Happy X-mas to u;)

Here a little guide i make myself, u can edit it later sycspy.

In box where quality>4 u can change it into diffrent variable.
Format: variable>value
If u want combine more variable to narrow down items u can do like this
variable1>value and variable2>value

Here the variable u can use:

class
subclass
quality
flags
inventorytype
allowableclass
allowablerace
itemlevel
requiredlevel
requiredskill
unique
dmg_min1
dmg_max1



Variable value:

class
0 - consumables
1 - containers
2 - weapons
3 - gems
4 - armor
6 - projectiles
7 - trade goods
9 - recipes
11 - quiver
12 - quest
13 - keys
15 - Miscellaneous
For example: If u want vendor sell weapon only put variable like below
class>2


subclass
[This is subclass for class 9=resipes]
0 - Books
1 - Leatherworking
2 - Tailoring
3 - Engineering
4 - Blacksmithing
5 - Cooking
6 - Alchemy
7 - First Aid
8 - Enchanting
9 - Fishing
10 - Jewelcrafting
ATTENTION Here is subclass of class above. Atm i only provide subclass for resipes only there is more subclass for
weapon, others.


quality
0 - Poor
1 - Common
2 - Uncommon
3 - Rare
4 - Epic
5 - Legendary
6 - Artifact
For example: If u want make Legendary items vendor put variable like this
quality>4


flags
Value Description Notes
1 Unknown Didn't find any items with this mask
2 Conjured item Warlock/Mage stones, water etc
3 Openable item Lockboxes, clams etc
4 Unknown Didn't find any items with this mask
5 Deprecated item ie 128, 16999, 18566, 21785, 21786 - sometimes contains non deprecated recipes
6 Totem Shaman totem tools
7 Spelltriggerer Items bearing a spell (Equip/Use/Proc etc)
8 Unknown Torch of Retribution
9 Wand These items would appear to do ranged magical damage
10 Wrap These items can wrap other items (wrapping paper)
11 Producer These items produce other items when right clicked (motes, enchanting essences, darkmoon cards...)
12 Multi loot Everyone in the group/raid can loot a copy of the item.
13 BG Item? Do any items still have this? --Jb55 02:19, 31 December 2006 (EST) )
14 Charter Guild charters
15 Readable item <Right Click to Read>
16 PvP item Item bought with Honor or Arena Points - also contains a lot of reputation rewards and random stuff like Egbert's Egg (?!)
17 Duration Item expires after a certain amount of time
18 Unknown
19 Prospectable Items a jewel crafter can prospect
20 Unique-Equipped Items you can only have one of equipped, but multiple in your inventory
21 Unknown
22 Unknown Bandages, Poisons + Most conjured items (not all)
23 Throwing Weapon Lowers durability on cast (also contains deprecated throwing weapons)
24 Unknown Shiny Red Apple
Not recommended uses this variable use if u really know what it is.


inventorytype
0 - None
1 - Head
2 - Neck
3 - Shoulders
4 - Shirt
5 - Vest
6 - Waist
7 - Legs
8 - Feet
9 - Wrist
10 - Hands
11 - Ring
12 - Trinket
13 - One hand
14 - Shield
15 - Bow
16 - Back
17 - Two hand
18 - Bag
19 - Tabbard
20 - Robe
21 - Main hand
22 - Off hand
23 - Held
24 - Ammo
25 - Thrown
26 - Ranged
27 - Ranged (Can't remember what)
28 - Relic
For example: If u want to make Shirt vendor put like this
inventorytype>4


itemlevel
Can be any value. 1-200 recommended


requiredlevel
Value 1-80. As maximum level in game is level 80. Required level to equiped item


unique
1 - Unique
0 - Not unique


dmg_min1
Can be any level. 1-200 recommended
can be use to make vendor like weapon 100+ so put variable like this dmg_min1>100


dmg_max1
Same as above



requiredskill [Coming soon]
allowableclass [Coming soon]
allowablerace [Coming soon]
More variable Coming soon...

[Kabukiblood]

Nice to meet u. I'm from ur neighbour country, Malaysia:p I already take a look at ur code and application, it really good, i like the idea and concept. Except there is some error in table structure which not compatible with latest ArcEmu structure. Eg: vendor query miss one column which is extended_cost

U really should develop this tool and I can help too eventhough I'm not IT student like u (I'm engineering degree) but I learn basic programming. PM me if have a new version one so i can take a look and help a bit:D

Btw +rep. Everyone should try this. I can teach a little bit how to use it.

p/s: Added compile one which i fix a little bit (compatibility with ArcEmu, table info that i think important, icon, etc.)
HERE (http://filebeam.com/193f65b88461f939fa499ed95909495a)
Gonna added guide soon

All I had to do was add in to creature_proto the mountdisplayid and the equip fields and bam in it works in Tso's latest repack.

[sycspysycspy]

You made a small mistake:

all the ">"(greater) should be replaced with "="(equal). I know my english such ass and I have not look that deep into the database because there are 30k + records there... Hum, to be honest i dont like document work, i finish a project(programming part) in 1 week then i need at least 2 week for the documents -_-... thank you for the document!