Additional Costs in Itemtemplate.

A place where you can talk about anything Dawn of Light or DAOC related

Moderators: Support Team, Project Admin

Re: Additional Costs in Itemtemplate.

Postby Tolakram » Thu Jun 07, 2012 1:54 pm

Not interested in any name changes that would break the world. So we have price, what about adding AlternatePrice?
- Mark
User avatar
Tolakram
Storm / Storm-D2 Admin
 
Posts: 8776
Joined: Tue Jun 13, 2006 1:49 am
Location: Kentucky, USA

Re: Additional Costs in Itemtemplate.

Postby deathwish » Thu Jun 07, 2012 7:33 pm

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.
- Terry - terryammon
User avatar
deathwish
Database Team
 
Posts: 482
Joined: Sun Jul 05, 2009 10:15 pm
Location: England / Essex

Re: Additional Costs in Itemtemplate.

Postby Tolakram » Fri Jun 08, 2012 11:26 am

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?
- Mark
User avatar
Tolakram
Storm / Storm-D2 Admin
 
Posts: 8776
Joined: Tue Jun 13, 2006 1:49 am
Location: Kentucky, USA

Re: Additional Costs in Itemtemplate.

Postby Roozzz » Fri Jun 08, 2012 11:48 am

Tolakram wrote: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 :)
Quidquid latine dictum sit, altum videtur
Roozzz
Database Team
 
Posts: 1943
Joined: Wed Dec 06, 2006 11:00 am

Re: Additional Costs in Itemtemplate.

Postby deathwish » Fri Jun 08, 2012 3:52 pm

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
- Terry - terryammon
User avatar
deathwish
Database Team
 
Posts: 482
Joined: Sun Jul 05, 2009 10:15 pm
Location: England / Essex

Re: Additional Costs in Itemtemplate.

Postby stephenxpimentel » Tue Jun 26, 2012 2:03 pm

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.
Lets have some fun.
stephenxpimentel
Contributor
 
Posts: 1294
Joined: Wed Sep 19, 2007 5:09 pm

Re: Additional Costs in Itemtemplate.

Postby Graveen » Tue Jun 26, 2012 2:28 pm

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
Image
* pm me to contribute in Dawn of Light: code, database *
User avatar
Graveen
Project Leader
 
Posts: 11872
Joined: Fri Oct 19, 2007 9:22 pm
Location: France

Re: Additional Costs in Itemtemplate.

Postby stephenxpimentel » Tue Jun 26, 2012 7:09 pm

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 ;)
Lets have some fun.
stephenxpimentel
Contributor
 
Posts: 1294
Joined: Wed Sep 19, 2007 5:09 pm

Re: Additional Costs in Itemtemplate.

Postby Sand » Wed Jun 27, 2012 3:56 am

Roozzz wrote:
Tolakram wrote: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.
Sand
Server Team
 
Posts: 1349
Joined: Sat May 17, 2008 2:05 am

Previous

Return to General

Who is online

Users browsing this forum: No registered users and 1 guest