Recommend
7 
 Thumb up
 Hide
25 Posts

BoardGameGeek» Forums » BoardGameGeek Related » BGG General

Subject: New Trade Manager Is Up rss

Your Tags: Add tags
Popular Tags: trade [+] news [+] [View All]
Scott Alden
United States
Dallas
Texas
flag msg tools
admin
badge
Aldie's Full of Love!
Avatar
mbmbmb
Much thanks to Ava Jarvis aka BilboAtBagEnd for her help in getting me to do some optimization on the trade manager query code.

Ava had 1 very nice query - which found a bug in the mysql optimizer, so we broke it into 3 queries. I think you will find it much faster now. I think I can make it even faster with some caching, but that needs a bit more work.

Thanks Ava!

Trade on!
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Needle
Australia
NSW
flag msg tools
mbmbmbmbmb
Hi-Is Custom Search working. I just did a Match in My Collection and Search my Country only and it came up with 7 blank pages.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Richard Pardoe
United States
flag msg tools
badge
Avatar
Aldie wrote:
I think I can make it even faster with some caching, but that needs a bit more work.


Another thanks to Ava also. Looking forward to the caching as it seems that the queries are "rerun" as I page through the results.

PS - Custom Search working for me.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Ed Sherman
United States
Colorado Springs
Colorado
flag msg tools
badge
Avatar
mbmb
nnf1 wrote:
Hi-Is Custom Search working. I just did a Match in My Collection and Search my Country only and it came up with 7 blank pages.


I had the same thing, but when I just clicked on the country, it worked fine. (Actually, it was a LOT faster than it used to be!)

Thanks for getting this going again! Now everyone, get going and offer me trades! I've got some good stuff! laugh
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Scott Alden
United States
Dallas
Texas
flag msg tools
admin
badge
Aldie's Full of Love!
Avatar
mbmbmb
nnf1 wrote:
Hi-Is Custom Search working. I just did a Match in My Collection and Search my Country only and it came up with 7 blank pages.


This should be working now too.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Scott Alden
United States
Dallas
Texas
flag msg tools
admin
badge
Aldie's Full of Love!
Avatar
mbmbmb
RPardoe wrote:
Aldie wrote:
I think I can make it even faster with some caching, but that needs a bit more work.


Another thanks to Ava also. Looking forward to the caching as it seems that the queries are "rerun" as I page through the results.

PS - Custom Search working for me.


I could put in a quick cache out, but I know a lot of people like to tweak and get instant feedback.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Brian Morris
United States
Raytown
Missouri
flag msg tools
2nd, 6th and 7th Wisconsin, 19th Indiana, 24th Michigan
badge
24th Michigan Monument Gettysburg Pa
Avatar
mbmbmbmbmb
Huzzah! One of BGG's best features. Glad to see it back and thanks!
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
James Perry
United States
Spring Hill
Tennessee
flag msg tools
badge
Ex-Term-In-Ate
Avatar
mbmbmbmbmb
One problem I see, and this was a problem before:

When I do "direct matches", I get some hits that appear to not want anything I have for trade. That means the result set has something that I want, but nothing that they want.


For instance I get this:


User You Want They Want Action
(gamegarage)
Scott Lewis Go Away Monster!: Two [Propose]
United States copies, one for trade. [Wants (96)]
New Mexico Bang! High Noon: [Trades (94)]
Trade Rating:24


Not a big deal, but it isn't a direct match (unless they are giving away the games.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Jeffrey D Myers
United States
Albuquerque
New Mexico
flag msg tools
"Always rely upon a happy mind alone." Geshe Chekhawa.
badge
Avatar
mbmbmbmbmb
Scott's a fine fellow, so you never know!

Anyway, thanks Aldie and Ava for working on this!
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Sterling Babcock
United States
Longmont
Colorado
flag msg tools
admin
Winkles is here to help!
badge
Please let me know how I can help you.
Avatar
mbmbmbmbmb
Many thanks to you and Ava for getting this running again!
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Dave Hollinsworth
United States
Cranston
Rhode Island
flag msg tools
badge
Avatar
mbmbmbmbmb
Regai wrote:
One problem I see, and this was a problem before:

When I do "direct matches", I get some hits that appear to not want anything I have for trade. That means the result set has something that I want, but nothing that they want.


I know what causes this. It occurs when you have a game listed as both For Trade and Wanted. In your case, it's Bang! High Noon. I have Netrunner set that way, and it also makes Direct Matches show a blank when I run it, either with the old or the new trade manager.

Something for the Bug Report forum, if right here isn't sufficient....
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Randy Cox
United States
Clemson
South Carolina
flag msg tools
designer
1024x768 works just fine - Don't Wide the Site!
badge
Missing old BGG
Avatar
mbmbmbmbmb
So, is there a way to see users who have games you want (from your want list) and who want games you own. There are plenty of games I'd consider trading, but I wouldn't dare put them up on the official trade block. For one thing, it would take forever to do that and for another, I'd get way, way too many trade requests.

But being able to find people who have what I want and want what I have (even if not listed as up for trade) would be quite useful indeed.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Mark Crane
United States
Orem
Utah
flag msg tools
badge
Avatar
mbmbmbmbmb
It looks like you have also removed users who haven't logged in recently from the trade result set. That is awesome!
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Rich S.
United States
North Hollywood
California
flag msg tools
badge
Well, this is just silly.
Avatar
mbmbmbmbmb
craniac wrote:
It looks like you have also removed users who haven't logged in recently from the trade result set. That is awesome!
I just did a search that brought up a result from a guy who last logged in on 12/10/05...
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Mark Crane
United States
Orem
Utah
flag msg tools
badge
Avatar
mbmbmbmbmb
Never Mind!
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Richard Pardoe
United States
flag msg tools
badge
Avatar
Randy Cox wrote:
So, is there a way to see users who have games you want (from your want list) and who want games you own.


This is one of the best features of Custom Search. Under the Your Trades - select the box that states Match any in my collections

To narrow down the results, I usually only select a few choice wants from the Your Wants list as I am usually investigating possibilities around a couple of games.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Bryan Johnson
United States
Salem
Massachusetts
flag msg tools
designer
badge
Avatar
mbmbmbmbmb
I met Ava at the Gathering of Friends in April 2006. She's a great gal and a great gamer. I really enjoyed getting to know her and playing some games with her. Nice job Ava!

thumbsup

 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Bob
United States
Utah
flag msg tools
badge
Yes, that's a Japanese CTR ring shield cut in half...
Avatar
mbmbmbmbmb
I love trading!
Thanks for speeding things up!
Bob
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
M. Shanmugasundaram
United States
Sunnyvale
California
flag msg tools
badge
mbmbmbmbmb
Squeeky sparkly speedy clean search.

Awesome job.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Randy Cox
United States
Clemson
South Carolina
flag msg tools
designer
1024x768 works just fine - Don't Wide the Site!
badge
Missing old BGG
Avatar
mbmbmbmbmb
RPardoe wrote:
Randy Cox wrote:
So, is there a way to see users who have games you want (from your want list) and who want games you own.


This is one of the best features of Custom Search. Under the Your Trades - select the box that states Match any in my collections

To narrow down the results, I usually only select a few choice wants from the Your Wants list as I am usually investigating possibilities around a couple of games.

Thanks, that does exactly what I was looking for. Now all I have to do is go locate a bunch of games I have and see if others are willing to trade.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Gilad Yarnitzky
Israel
Reut
flag msg tools
designer
badge
Avatar
mbmbmbmbmb
Will it be possible to view the trades by user name and not by game name? This way I can find easily people that offer more then one game wanted by me. I think it can make life easier
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Michelle Zentis
United Kingdom
London
flag msg tools
badge
Avatar
mbmbmbmbmb
Yay, Ava and Aldie are co-heroes of my day!
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Ava Jarvis
United States
Bainbridge Island
Washington
flag msg tools
badge
Avatar
mbmbmbmbmb
I'm glad the trade manager is back up and that people are happy!

I helped out a bit---Aldie did the hard work.

caravan Trade on! caravan
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Front Page | Welcome | Contact | Privacy Policy | Terms of Service | Advertise | Support BGG | Feeds RSS
Geekdo, BoardGameGeek, the Geekdo logo, and the BoardGameGeek logo are trademarks of BoardGameGeek, LLC.