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.
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.
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....
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!
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...
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.
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
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?
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.
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.
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.
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.
0
dragoness10Member, NW M9 PlaytestPosts: 780Arc 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.
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.
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
buzzardsbaitMember, NW M9 PlaytestPosts: 49Arc 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
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.
Comments
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.
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....
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!
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.
No more need to buy tons when you only need 5...
I like it
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-
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.
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.
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 )
"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
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:
New features? This thread is about an incomplete feature.
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
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
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.
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