test content
Logo
What is the Arc Client?
Install Arc
Tradehouse Search Dysfunction
oktlryk
Member Posts: 149 Arc User
The tradehouse has a flaw in the search function. For instance when searching for something with 2 words, after the first word the search expects everything to be an exact match: If for instance you would search for Staff of Flowers, 'Staff Flowers' may not work, or Elite Neverwinter Companion Pack, 'Elite Companion' may not find it.
And the other flaw in the search is that sometimes you have to click the corresponding sub category to get a hit, for instance when searching for shimmerweave cloth you will have to click on the professions category for the search to work instead of working at the top level.
And finally I think it takes into account white space and commas as well - thanks for the time!
And the other flaw in the search is that sometimes you have to click the corresponding sub category to get a hit, for instance when searching for shimmerweave cloth you will have to click on the professions category for the search to work instead of working at the top level.
And finally I think it takes into account white space and commas as well - thanks for the time!
0
Comments
Basically,
select * from AH where name match '*{the string you provided}*' and {other conditions};
Search for "shimmerweave cloth" would work in top level (without selecting Profession) if you are not in 'Advanced search'.
Click 'hide advanced search' and search for 'shimmerweave cloth'. You may need to exit AH and come back.
Many people say the better search was a webpage version called the Gateway, but it was shutdown. My wife tells me the old Gateway web search not only allowed for better searching options, you could make your purchase (buy/sell) and not bother to log into the 3D game at that time.
It would probably be out of their current skill set and budget to make a mobile phone app, to replace the old Gateway webpage.
PSN Zen AD Exchange - Forecasting Spreadsheet
rainers pocket wiki
Xael De Armadeon: DC
Xane De Armadeon: CW
Zen De Armadeon: OP
Zohar De Armadeon: TR
Chrion De Armadeon: SW
Gosti Big Belly: GWF
Barney McRustbucket: GF
Lt. Thackeray: HR
Lucius De Armadeon: BD
Member of Casual Dailies - XBox
For example, staff of flowers might be "f fl", the new feywild sylph companion is "ld sy", and the new mount is "ld st". The legendary celestial stags are "al st". Sometimes you need a longer string if two parts of the name are important (like "ing stone, rank 5").
It's surprising how short a string you can get away with for an almost unique result.
For a long time I searched for "al ar", but they were very expensive!
Works for me
What I wrote is a rough idea of how they would construct the SQL statement within the game to access the database to retrieve AH result set. I have no idea what their database schema would be.