Page 1 of 2

Additional Costs in Itemtemplate.

PostPosted: Sun Jun 03, 2012 7:09 pm
by deathwish
Hi everyone,

Looking around on live daoc and dol servers, i have come to the conclusion that we need a second price added to Itemtemplates.
Primary Price to run the cost of Coins (copper, silver, gold) and the Secondary Price to run other costs(BP's, Seals, Scales).

What would the advantages of having a second price?
# We be able to merg items that have 2 versions on for normal merchants and one that use BP's and seals and save space in the database.
# Items that are sold by Bps and other tokens can then be sold to normal merchants and have the correct price returned in gold.

Has anyone got any opinion on this subject?

Dw - Terry

Re: Additional Costs in Itemtemplate.

PostPosted: Sun Jun 03, 2012 9:55 pm
by Graveen
hard to say. I generally dislike melting apple & pear, and i think instead a currency converter is more suitable *if needed*.
In fact i think same items on 2 currencies must be handled like different items.

Re: Additional Costs in Itemtemplate.

PostPosted: Mon Jun 04, 2012 10:18 am
by geshi
It would save a lot of time if it was just another column added to itemtemplate yeah :mrgreen:

Re: Additional Costs in Itemtemplate.

PostPosted: Mon Jun 04, 2012 11:44 am
by Tolakram
I also thing this should be done in the code, with an NPC that has the correct exchange rates.

Re: Additional Costs in Itemtemplate.

PostPosted: Mon Jun 04, 2012 12:18 pm
by Graveen
It would save a lot of time if it was just another column added to itemtemplate yeah :mrgreen:
Problem is, why not 5 more columns ? I can sell/buy to BP, DF seals x3 , aurulites, and why not selling for MLXP / XP or RPs ?

This 'll drive to a unmaintainable design.

Re: Additional Costs in Itemtemplate.

PostPosted: Mon Jun 04, 2012 1:45 pm
by Sand
I don't think an Exchange rate will work on this as I doubt conversion from coin price and other item prices are consistent and also don't think price should be added in itemtemplate.

I think this best be handled in the merchant itself. Isn't this the way DF gear is handled?

Graveen we wouldn't need 5 extra columns most likely because items are typically only puchasable by one type of other "currency" .

Re: Additional Costs in Itemtemplate.

PostPosted: Mon Jun 04, 2012 2:26 pm
by Graveen
Sure, but this is to point i don't think adding different currencies as item property is a good move.

Re: Additional Costs in Itemtemplate.

PostPosted: Mon Jun 04, 2012 2:44 pm
by baradien
i would says 2 columns one with the currency id like 1 is aurulites or 2 is df seals etc. the other one which value of the price but this column might be optional.

but yeah this is just my opinion ^^ agianst it or not ^^

Re: Additional Costs in Itemtemplate.

PostPosted: Wed Jun 06, 2012 12:44 am
by Blue
What happens if you sell DF bought weapons to normal merchants? I would suggest to have a money value and like seal value on an item. Some items even may have a BP value on top of it.

Re: Additional Costs in Itemtemplate.

PostPosted: Wed Jun 06, 2012 3:07 am
by Sand
Not sure what you mean Blue.

If you sell a DF bought weapon to any merchant you get coin back, not seals, as far as I remember, and a pitiful amount.

This is why you salvage and trinket the items.

Re: Additional Costs in Itemtemplate.

PostPosted: Wed Jun 06, 2012 8:56 am
by Dinberg
Thats exactly what hes getting at I think - you need two columns at least, one for the gold value of the item, the other for the seal value, as although you can buy the item in seals you sell it back in gold

Re: Additional Costs in Itemtemplate.

PostPosted: Wed Jun 06, 2012 1:14 pm
by Sand
Okay, I understand now where this is coming from.

Currently, we can buy items for special currency but when we do we define price in itemtemplae with what it cost in the special currency and then it would have problem selling for coin as it should.

However, I don't see how duplicate items helps that problem though so not sure why you think we would save database space on that account. Currently I see duplicate df items but do not t hink they are there for that purpose, seems like created new items instead of updating to quality changes.

I was thinking the price was set on the merchants that sell for special currency. That seems more logical place to put it to me though do see some issue with it, that makes it harder to keep price consistent if it is on multiple merchants but typically they are on one maybe 2 merchants or if common among realms it might be 3 times that, but usually different realms have somewhat different items.

As far as I know, you don't sell these items for the special currency, you only buy so seems to me merchant be the only place they be needed.

Re: Additional Costs in Itemtemplate.

PostPosted: Wed Jun 06, 2012 2:34 pm
by Tolakram
So it sounds like we need value and altvalue (alternate value)? What's the current value column name? Whatever it is it needs to stay the same and one additional column added for the alternate value. Seal seems to specific to me.

Re: Additional Costs in Itemtemplate.

PostPosted: Thu Jun 07, 2012 1:18 pm
by Blue
I would name the price column MoneyValue and the other column just AltValue. It then depends on which merchant this item is offered. If its offered on BP merchant AltValue will be the cost in BP and so on.

Re: Additional Costs in Itemtemplate.

PostPosted: Thu Jun 07, 2012 1:28 pm
by Sand
Current column is called Price.