Ultimate sql generator question.

[Vitrex]

Hello, all i would like to as this community since this would be release for ED, so lets talk on topic.
I worked a bit before on upgraded version of sql generator for TC , mine sql generator can create X copies of tier with calculated stats for all 8/8 (main armor pieces) based on the first one entered and multiplier, with class colors name, (custom colors) sockets and all this stuff. i have done formulas for private server balanced items (255 or 80 or whatever) for class items, all you need to fill in is Level role (healer, dps, tank) and material plate cloth leather mail and you will get all balanced and calculated stats for that level. So i would like to ask does this community needs that kind of release ? or not. if yes i'll continue my work and will update code to newest TC.
So now who don't get the idea :

• you select amount of tiers to make.
• set all data like sockets, bonding, display, material and etc.
• set multiplier
• select stats types and enter values.
• you get sql code for your entered amount of tiers with calculated stats based on your entered and multiplier

• You enter character level for that items
• role
• item material
• you get sql code based on your role and item material

• Same goes to weapons

• Same as multiple tier maker goes for weapons and jewelery (Soon).

 

[Kaev]

I think this is a very nice idea, but i would remove the custom colors from the items, or at least make a checkbox so everyone can choose if they want custom colors or not.
And what would be nice is: The user shouldn't decide which stats the armor has, he should decide for which role it is (tank, heal, melee, range, caster). And everytime you generate a new item, the stats will be randomized for this role. This will make sets more unique and this way all the items won't have the same stats.
I'm looking forward to your generator.

 

[Vitrex]

About colors, yes you already can select from drop down menu one of custom, or check box (class colors) or class names and etc.

So about that stats generator, yes now it's demo only to display stats based on your settings(Role,level,material) so you gave better idea to convert that tool to item generator where you write level,role,material ,item type and you got your item, heh. thanks


So now a bit more about system, it will be portable .exe program which you can download. all stats and formulas can be "upgraded" by multiplier
So i have few screens of it.

There is also wiki page idea started but not finished same as changelog.
And since i see more and more people using older tc revs, i think there must be some version select.
So if i will get some more positive feedback about idea i will make it working , i just wanna be sure that people will use that

 

[Jiinx]

Very nice, I took have thought about and tinkered with something similar regarding stats (never anything like a program, just how to calculate).

I'm curious, how to you determine the value to multiple by in the "multiply by x" field?

 

[Vitrex]

Very nice, I took have thought about and tinkered with something similar regarding stats (never anything like a program, just how to calculate).

I'm curious, how to you determine the value to multiple by in the "multiply by x" field?

sorry don't understand your question.
Thanks for feedback.

 

[Jiinx]

In your second screenshot, it says multiple values by x. I assume x is the variable provided in the input field, but what is being multiplied?

 

[Vitrex]

Stats. For people who wanna use crazy values but still wanna have some balance.
and for multiple tiers its just a smart loop which takes multiplier from input ant * x it for every copy in proccess you gain tier2 > tier 1 by x % if you generate 10tiers with multiplier 1.15 you will get tier 1 stats < tier 2< tier 3 by 15 % allso there is option to not affect your sellected stats.

 

[Vitrex]

since there no replies anymore, and i wanna a bit "bump" this thread, i can tell i started to work on that platform. already done single armor and weapon generators
with integrated download system, after you press generate you get .sql file with your code, something like in wow-v . so if anyone interested more you can contact me since i can't advertise website on this forum, that against the rules. thanks for some feedback it's cool.

EDIT 1
Forgot to mention that thinking about online .CSV editor. in other words DBC editor tool. don't know how thing will go but have idea how convert this idea to reality.

 

[Tommy]

since there no replies anymore, and i wanna a bit "bump" this thread, i can tell i started to work on that platform. already done single armor and weapon generators
with integrated download system, after you press generate you get .sql file with your code, something like in wow-v . so if anyone interested more you can contact me since i can't advertise website on this forum, that against the rules. thanks for some feedback it's cool.

EDIT 1
Forgot to mention that thinking about online .CSV editor. in other words DBC editor tool. don't know how thing will go but have idea how convert this idea to reality.

Links are allowed as long as they are in

 bbcode and aren't wrapped in URL tags & if the link(s) are relevant to your discussion. Censored sites aren't allowed, period. Lastly, do not wrap url bbcode around images. Ignoring this rule will result in a warning or permanent ban.[/QUOTE]

[CODE]
http://yoursite.com

You can post your website as long as it follows the rules. Seems like a lot of people are getting confused over this particular rule. Sites like Google for example does not have to be in CODE bbcode and can be wrapped in the URL tag. ^.^

 

[Vitrex]

Well still confused, since it can be something like "advertise" from my side...
since this project will be public , but emudevs users will get some "bonuses" there.

 

[Hyperion]

Well still confused, since it can be something like "advertise" from my side...
since this project will be public , but emudevs users will get some "bonuses" there.

The only reason we ask for people to wrap their personal links in bbcode is so they aren't clickable.