test content
What is the Arc Client?
Install Arc

Suggestion for AH: Price per Item

hercules125hercules125 Member Posts: 427 Arc User
edited April 2015 in PvE Discussion
Suggestion 1:
Currently, the sorting on the AH is marginally working, and it's difficult to find items cheapest to most expensive.
It would be nice if they would add new sortable "Price per Unit" columns for both buyout and current bid.

Suggestion 2:
While some people may find it useful to buy large stacks of enhancements/consumables, i usually only need either 1 or a very small handful. Allow the seller to specify if they will allow partial sales to occur, then allow me as the buyer to buy only X out of how many are in the stack.
Post edited by hercules125 on

Comments

  • angryspriteangrysprite Member Posts: 4,982 Arc User
    edited March 2014
    When sorting by price (buyout or bid) all items are sorted by Unit Price. This is why sometimes a stack of 10 for 1000AD will show as less expensive than a single item selling for 125AD.

    Sorting works flawlessly in-game, I concur that on Gateway it can be a little wonky, but generally works well. If you want to know the actual price per unit in a stack, open your calculator app (as every computer has one) and simply divide the price by the stack count: Stack of 10 for 1000AD ... 1000/10=100.

    Granted: it would be neat if the auction house displayed per-item prices. But that would be a lot of work for the Devs and I'd rather they keep working on bug-fixes and new content and easy-to-add features, rather than little things like this. :)
  • mconosrepmconosrep Member Posts: 0 Arc User
    edited March 2014
    Granted: it would be neat if the auction house displayed per-item prices. But that would be a lot of work for the Devs and I'd rather they keep working on bug-fixes and new content and easy-to-add features, rather than little things like this. :)

    This is actually one of the EASIEST to program quality of life improvements. After all
    f you want to know the actual price per unit in a stack, open your calculator app (as every computer has one) and simply divide the price by the stack count: Stack of 10 for 1000AD ... 1000/10=100.

    can be trivially done by a computer too. :)

    So comparatively easy to imperilment, and a nice quality of life improvement seems to be a win-win to me....
  • angryspriteangrysprite Member Posts: 4,982 Arc User
    edited March 2014
    mconosrep wrote: »
    This is actually one of the EASIEST to program quality of life improvements. After all can be trivially done by a computer too. :)

    Precisely. Such as the calculator that came with your computer. That's a freebie. However, paying a Developer to do it costs a lot of money, time and resources. So: it's your company, do you spend the money to implement this kind of feature that is so simple for your customer to do for themselves, or do you steer that resource (your Developer) toward more meaningful return on investment?

    Just playing devil's advocate on this, you decide. :)

    Of course: if the developer is sent in there to do something of more significant value and implementing this kind of feature is along the way with minimal impact on the Devs time, then most certainly do it!
  • wingedkagoutiwingedkagouti Member Posts: 275 Arc User
    edited March 2014
    mconosrep wrote: »
    This is actually one of the EASIEST to program quality of life improvements. After all



    can be trivially done by a computer too. :)

    So comparatively easy to imperilment, and a nice quality of life improvement seems to be a win-win to me....
    The calculation is simple to do, adding a column in the UI may be less simple. There's no guarantee that it's just "insert new column in table, add header, add calculation", it is likely to involve a lot of other things as well.

    Then again, if you've actually seen the code and know just what to do...
  • mconosrepmconosrep Member Posts: 0 Arc User
    edited March 2014
    The calculation is simple to do, adding a column in the UI may be less simple. There's no guarantee that it's just "insert new column in table, add header, add calculation", it is likely to involve a lot of other things as well.

    Then again, if you've actually seen the code and know just what to do...

    Of course, by the same argument unless you've actually seen the code and know that there is a special reason why this is difficult...

    The calculation is trivial and adding another column to the AH is simply reusing the same functionality that they already have.
  • js3bjs3b Member Posts: 368 Arc User
    edited April 2014
    I think this would bring a new dimenssion to ''pack selling item'' no more need to put it cheaper because we sell a tons of them..

    No more need to buy tons when you only need 5...
    I like it :)
    Founder back a week ago, already pissed by cryptic ''no roll back'' decision


  • ryugasiriusryugasirius Member Posts: 996 Arc User
    edited April 2014
    Granted: it would be neat if the auction house displayed per-item prices. But that would be a lot of work for the Devs and I'd rather they keep working on bug-fixes and new content and easy-to-add features, rather than little things like this. :)

    NOW: select item_name, quantity, seller_name, some_function(expiry_time), bid_amount, buyout_price
    from some_tables_with_AH_stuff where <filters>

    MODIFIED: select item_name, quantity, seller_name, some_function(expiry_time), bid_amount, buyout_price, buyout_price/quantity
    from some_tables_with_AH_stuff where <filters>

    That's probably the biggest part of the "hard work" required, if they did their code right :P
  • angryspriteangrysprite Member Posts: 4,982 Arc User
    edited April 2014
    NOW: select item_name, quantity, seller_name, some_function(expiry_time), bid_amount, buyout_price
    from some_tables_with_AH_stuff where <filters>

    MODIFIED: select item_name, quantity, seller_name, some_function(expiry_time), bid_amount, buyout_price, buyout_price/quantity
    from some_tables_with_AH_stuff where <filters>

    That's probably the biggest part of the "hard work" required, if they did their code right :P

    I could be mistaken, but that doesn't look like C+ or C++ or C# or even VideualBasic, COBOL, Fortran, Basic, Logo or any other low-level programming code. Rather, it looks like some kind of Excel spreadsheet or database sorting filter. Are you sure it is what you think it is? ;)

    In order to help the Devs, you first need to figure out which language the Neverwinter Devs are using, possibly one of the languages from this list: http://en.wikipedia.org/wiki/List_of_programming_languages

    Then, you'd need to offer the existing implementation of the language along with your simple modification that will then implement this oh-so-important feature. I look forward to your (or anyones) result here.

    -Muahahahah-
  • ryugasiriusryugasirius Member Posts: 996 Arc User
    edited April 2014
    I could be mistaken, but that doesn't look like C+ or C++ or C# or even VideualBasic, COBOL, Fortran, Basic, Logo or any other low-level programming code. Rather, it looks like some kind of Excel spreadsheet or database sorting filter. Are you sure it is what you think it is? ;)

    It's simply SQL. Whatever the language they use, I suppose there is a function that populates a table in the UI using the results of a database query (stored in a database procedure). Adding a single column to the query would be no big deal, whatever DBMS they use.
  • angryspriteangrysprite Member Posts: 4,982 Arc User
    edited April 2014
    It's simply SQL. Whatever the language they use, I suppose there is a function that populates a table in the UI using the results of a database query (stored in a database procedure). Adding a single column to the query would be no big deal, whatever DBMS they use.

    Understood. That would pull up the results, BUT, there is low-level code to write the game client, where the additional column needs to be added, else what good is the data if it cannot be displayed? That, or only available at the Gateway PHP web site. This is my point: it's not in the fetching of the data (that is simple, I agree) - it's in programming the game client to present that data. :)
  • ryugasiriusryugasirius Member Posts: 996 Arc User
    edited April 2014
    Understood. That would pull up the results, BUT, there is low-level code to write the game client, where the additional column needs to be added, else what good is the data if it cannot be displayed? That, or only available at the Gateway PHP web site. This is my point: it's not in the fetching of the data (that is simple, I agree) - it's in programming the game client to present that data. :)

    If they had to write code to micro-manage every single column of data it would be a very bad design for a UI (but that would also explain why they didn't do so already).

    I'm no expert (several years passed since I coded anything), but if I had to show tables in a game client (or whatever else), i'd absolutely want to have a procedure that fills the available space depending on the actual data passed to it. 3 columns of data? Stretch it all the way. 5 columns? tighten it up a bit. 20 columns? it would be pretty illegible, but, hey, i can handle it.

    Considering some games (namely WoW) have very versatile APIs for players to design their own pieces of interface, having hard-coded UI in 2014 seems a terrible idea.
  • dragoness10dragoness10 Member, NW M9 Playtest Posts: 780 Arc User
    edited April 2014
    SQL - SQUIRREL! SQUIRREL ! : runs in circles then falls over:

    The easier request here might be to ask players to please list by stacks of ten, or twenty etc.

    It seems somewhat player LAZY to insist the game is modified rather than use the computer's calculator. I'm on the Devs side on this. They can spend time doing more useful features. (HEY! How about that neck slot item for fashion clothes? : shifty look: Tangent... http://nw-forum.perfectworld.com/showthread.php?645541-Suggestion-Neck-Slot-for-Fashion-Items )
    " I tried to figure out the enigma that was you, and then I realized mastering Wild Magic was easier." - Old Wizard in Waterdeep

    "Why is it dragons only use ketchup? I'd like a little wasabi please. Us silvers like a variety of condiments."

    "Don't call them foolish mortals. One, they don't learn from it. Two, It just ticks them off." - An Ancient Red Dragon
  • ryugasiriusryugasirius Member Posts: 996 Arc User
    edited April 2014
    It seems somewhat player LAZY to insist the game is modified rather than use the computer's calculator.

    Constantly switching to desktop just to do something that should have been done when they first designed the AH? :P

    Add an ingame calculator then (as in Eve Online)! Or better:

    1) Fire whoever designed the AH & Mail interface
    2) Borrow the UI personnel from CCP/Eve Online
    3) ???
    4) PROFIT!!

    :cool:
  • wingedkagoutiwingedkagouti Member Posts: 275 Arc User
    edited April 2014
    Considering some games (namely WoW) have very versatile APIs for players to design their own pieces of interface, having hard-coded UI in 2014 seems a terrible idea.
    On the other hand, it is faster, easier and cheaper to both create and troubleshoot since you know exactly how it's supposed to behave. At least if it's documented. Then again, an undocumented piece of modular software can be a nightmare to work with.
  • masizin777masizin777 Member Posts: 181 Arc User
    edited April 2014
    I agree, this would also fix people buying out all cheap stackable items and selling the in bulk for higher rates.
  • ohforf14ohforf14 Member Posts: 2 Arc User
    edited April 2014
    They can spend time doing more useful features.

    New features? This thread is about an incomplete feature.
  • punsher25punsher25 Member Posts: 1 Arc User
    edited April 2015
    The AH is absolutely bugged.I cant sort my bids by remaining time.Why?Fix this,please
  • jadence80jadence80 Member, Neverwinter Beta Users Posts: 5 Arc User
    edited April 2015
    Suggestion 1:
    Currently, the sorting on the AH is marginally working, and it's difficult to find items cheapest to most expensive.
    It would be nice if they would add new sortable "Price per Unit" columns for both buyout and current bid.

    Suggestion 2:
    While some people may find it useful to buy large stacks of enhancements/consumables, i usually only need either 1 or a very small handful. Allow the seller to specify if they will allow partial sales to occur, then allow me as the buyer to buy only X out of how many are in the stack.


    I have to agree with angrysprite on this one! This is your problem with Neverwinter? The AH already does a good job of displaying in unit cost order, it is not the DEVs job to aid in bad math skills of the player. Now if the AH was one of the major issues with Neverwinter (which it is by far not one of those), it would be to make the search bar more capable of partial searching items rather than exact names of items. LOL
  • edited April 2015
    This content has been removed.
  • buzzardsbaitbuzzardsbait Member, NW M9 Playtest Posts: 49 Arc User
    edited April 2015
    According to their careers page for job openings:

    Lead Programmer
    Location: Redwood City, CA
    Department: Product
    Description

    Responsibilities & Job Duties:

    Developing new systems in both common and esoteric areas from AI, graphics, physics and path finding to network engineering, server configuration and database programming.

    Building a game from the beginning to launch to live operations

    Make tactical decisions for the game, such as engine choice

    Hiring a full team of top notch engineers

    Collaborating with innovative art and design teams.

    Desired Experience:

    The ability to communicate clearly and concisely.

    Experience in managing and hiring a game programming team.

    Experience shipping multiple PC or Console titles. Experience in MMORPG’s is a plus.

    Extremely proficient in C, C++ or C# programming and debugging.

    Knowledge of JSON

    In-depth knowledge of and experience with games.

    A love for video games

    4-year degree required (or equivalent experience in relevant field)
    Database Administrator
    Location: Redwood City, CA
    Department: Engineering
    Description

    Responsibilities & Job Duties:

    • The DBA role is largely responsible for providing operational database services to Perfect World Entertainment, Inc. The primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents, reviewing service related reports (e.g., database backups, maintenance, monitoring, etc.) on a daily basis to ensure service related issues are identified and resolved within established time, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems.

    • Collaborate and work directly with finance, data mining, and development teams for reporting (EU and Shanghai/Beijing)

    • Install, configure, and administer database servers; maintenance and tuning of mission-critical SQL (mysql/mssql) databases, create reports (game statistics, finance...) based on requirements from related departments; assist with administration of 3rd party games database related functionality including documentation

    • Solid knowledge of scalable schema design principals and provide assistance to development/design teams, and recommend best practices both in code and database design including creation of Stored Procedures and Indexing

    • Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements

    • Experience in updating MySQL and MSSQL instances in a high volume environment 100M+ rows

    • Knowledge support of scripts in Perl/PHP/Python and/or Shell/Bash

    • Optimize and allocate physical data storage for database systems and work with development teams on data sizing based on efficient use of multi-core systems

    • Administer database backups and ensure disaster recovery and data retention protocols (backup, monitoring, security, installation)

    • Provide 24/7 support for critical production situations



    Requirements:

    • Bachelor's Degree in Computer Science/Information Systems or equivalent work experience

    • 5+ Years DBA experience in development or production capacity

    • 5+ Years experience designing, developing, tuning, optimizing, deploying and updating MySQL/MSSQL/MariaDB instances in a high volume environment with critical 100% uptime requirements (clustered and unclustered)

    • Experience in Replication (Master to Master, Master to Slaves)

    • MSSQL 2005+ & MySQL 5.x experience required (InnoDB and MyISAM, and other engines)

    • Scripting language knowledge of perl/php

    • 3+ years of experience with Linux/Windows administration

    • Strong analytical skills

    • Help maintain 24/7 production systems
  • healaryhealary Member Posts: 600 Arc User
    edited April 2015
    When sorting by price (buyout or bid) all items are sorted by Unit Price. This is why sometimes a stack of 10 for 1000AD will show as less expensive than a single item selling for 125AD.

    Sorting works flawlessly in-game, I concur that on Gateway it can be a little wonky, but generally works well. If you want to know the actual price per unit in a stack, open your calculator app (as every computer has one) and simply divide the price by the stack count: Stack of 10 for 1000AD ... 1000/10=100.

    Granted: it would be neat if the auction house displayed per-item prices. But that would be a lot of work for the Devs and I'd rather they keep working on bug-fixes and new content and easy-to-add features, rather than little things like this. :)

    Totally not true. First, sorting is far from flawless. A lot of players who sell 9000 stacks of the same items always stay on top of the first page even when other players sell the exact same items for a lower price. Second, it is extremely easy to add an unit price column.
  • lewstelamon01lewstelamon01 Member Posts: 7,415 Arc User
    edited April 2015
    Back to bed, Vilithrax....
    ROLL TIDE ROLL

    Great Weapon Fighter: Because when is today not a good day to die?

    PC and PS4 player. Proud Guildmaster for PS4 Team Fencebane. Rank 5 Officer for PC Team Fencebane. Visit us at http://fencebane.shivtr.com
This discussion has been closed.