Page 2 of 2

Re: Additional Costs in Itemtemplate.

PostPosted: Thu Jun 07, 2012 1:54 pm
by Tolakram
Not interested in any name changes that would break the world. So we have price, what about adding AlternatePrice?

Re: Additional Costs in Itemtemplate.

PostPosted: Thu Jun 07, 2012 7:33 pm
by deathwish
Sorry i been away and not had time to reply,

An AlternatePrice would be perfect, i have noticed, all merchants sell all items, for Coins (Price) also noticed all merchants that use BP, GBP (Guild Bounty Points - not Great British Pounds :D) and Glass (Toa Quest) have the same exchange rate, but ones you haae the items, the sell rate is diffrerent and dont match the first rates, same with other merchants.

You could use a currency converter, but you need one for every type of merchant for buying and a different one for selling.

With the AlternatePrice, you would leave all merchant to sell on the normal Price, but you just can buy in different currencys depending on the merchant.

Re: Additional Costs in Itemtemplate.

PostPosted: Fri Jun 08, 2012 11:26 am
by Tolakram
Can you ever sell an item using alternate price? Can you get glass back if you sell and item to a glass merchant, or is it always a one way transaction when buying with an alternate currency?

Re: Additional Costs in Itemtemplate.

PostPosted: Fri Jun 08, 2012 11:48 am
by Roozzz
Can you ever sell an item using alternate price? Can you get glass back if you sell and item to a glass merchant, or is it always a one way transaction when buying with an alternate currency?
On live it is always an one way transaction afaik. I can see people wanting to do this differently on their own shard :)

Re: Additional Costs in Itemtemplate.

PostPosted: Fri Jun 08, 2012 3:52 pm
by deathwish
Yes, on live, everything sells for only coins, but the amounts you get back are different, the price of the items sometimes change too, for what they cost to what they sell for, eg, a item that cost 2 scales sells for 5g, where an item that cost 10 scales sells for 10g depending on the item

Re: Additional Costs in Itemtemplate.

PostPosted: Tue Jun 26, 2012 2:03 pm
by stephenxpimentel
our current system screws over selling 'token' items back to merchants anyways... for example..

an item that u buy from a merchant for 10 diamond seals will only sell back to a merchant for around 2 copper... because its the same column, and the merchant uses a formula based on the DB price of the item, which in this case is 10, which is read as 10 copper.

Re: Additional Costs in Itemtemplate.

PostPosted: Tue Jun 26, 2012 2:28 pm
by Graveen
and a currency table with each merchant and item will have a currency column, pointing to currency id ?
Code: Select all
id | Currency | Value | Sell ratio | Sell currency | Item Id_Nb
------------------------------------------------------------------------------
1 | Money | null | 0.5 | null | null <- normal items, selling for 50%
2 | BPs | null | null | null | null
3 | Seals | 1 | 10 | BPs | Seals_DF_1234 <-1 seal sold for 10 bps
4 | Aurulite | 1 | null | null | Aurulite_Shards
5 | Aurulite | 10 | null | null | Aurulite_Pack <- 1 pack = 10 aurulites
6 | Money | null | 1 | null | null <- crafed items, selling for buy value
Notes:
Money, BPs, RPs, CLs (xp ? mlxp ? clxp ? life/mana/endu max ? mana points ? stats points ?) must have hardcoded handlers, only relying on sell ratio / sell currency (yay, wishing to sell 10 BPs for 1 CL point ! - or 100 STR for 10plats)

/discuss

Re: Additional Costs in Itemtemplate.

PostPosted: Tue Jun 26, 2012 7:09 pm
by stephenxpimentel
i think only the bug with the current system should be fixed.

Add 1 additional column to Item Template -> UnitPrice.

UnitPrice will be used for seals, scales etc.
and the normal Price column will still be set to allow for the item to be sold to a merchant for its proper value.


I Do like the custimizibility that ur purposing tho graveen ;)

Re: Additional Costs in Itemtemplate.

PostPosted: Wed Jun 27, 2012 3:56 am
by Sand
Can you ever sell an item using alternate price? Can you get glass back if you sell and item to a glass merchant, or is it always a one way transaction when buying with an alternate currency?
On live it is always an one way transaction afaik. I can see people wanting to do this differently on their own shard :)
I was thinking the same. The problem we have is that items that you buy for the special currency do not sell for a proper price because there is only ONE price in the db for it.

I think the most logical way for this to work is to have sell price defined on the merchant and leave the item price in db be the selling price of the item in coin. However this is not how it is currently setup so think be a bigger change than simply adding an alternate price so we could store a sell and a buy price in the item table. The draw that I see is it puts onus on getting price right on the merchant so probably a little harder on shard gms to manage.