Hi sebi,

I've done what you have asked and found that the problem is in fact with the Deck Count column.
When i have not selected that one it works.

The steps i take to reproduce this issue (i can screencap this later today if wanted)

1. Open the website
extra (if not logged in -> log in)
2. Hover Card Database
3. Click Magic the Gathering
4. Click Columns
5. Enable Deck Count
6. Click Apply

No matter which other colums are enabled the content of them are all shifted towards the left as the content of Deck Count is missing and it fills up with the content of the next column...

*BUMP*
this is important!!!

I think it would be handy to program it in the feedback to make it possible to let you guys have the information.
Depending on the stats you get from the feedback about fake cards you can decide what could be the next step.
I'm pretty sure that if a user is on Deckbox with trading fake cards in mind the majority of his trades of higher priced cards will be fake and flagged and you will see this in the stats then.
I am sure that if a user really was not aware of the fake card it will be just a one time occurrence in the stats, at least this is what i think.
I would suggest that implementing the feature to report it in the feedback about the trade but not yet flagging will provide the development team after let's say 6 or 12 months with the information on how large this portion is on the website and if there is a need for programming it further.
If you see the scenario as I described above I would suggest to set the flag after several bad trades per trade amount (e.g. : 3 fake cards reported in 5 trades with cards higher then $50).

Regards,
YouryDW

Goodmorning (at least here),

as i wake up i saw that there was an update last night.
However there is a glitch which made it's way to the site i guess...

http://www.thinkapic.com/DeckBox/deckbox-types.png

As you can see on the picture above the column of the types is empty and filled up with the casting cast, which makes all the next columns wrong as well.

I also noticed that my previous bug report is not yet fixed neither and that one is kinda important as well (http://deckbox.org/forum/viewtopic.php?id=12429)

Greetings and keep up the good work sebi, btw PM me when you want to get in touch with a developer smile

5

(2 replies, posted in Site Discussion)

*bump*

This bug is still active!
Extra screenshots with more proof there is something going on!


Here you can see that the prices are not correctly ordered (if they would be correct)
http://thinkapic.com/DeckBox/deckbox4.png

Here you can see the price jump
http://thinkapic.com/DeckBox/deckbox5.png

6

(15 replies, posted in Site Discussion)

Ber wrote:
TyWooOneTime wrote:
Ber wrote:

It's actually sad it takes SOOO MUUCH time to implement already given data to the website. Not even to mention about ignoring my question.

Considering that the entire site is administrated by two people, mostly just Sebi, who take the time to deal with bad trading reports while providing the entire service for free, I'd imagine a little patience should be required.

Copy pasting the data takes 5 minutes. I was patient for 2 months already...

Also this fix will make this site more popular because it will be much easier to find people to trade with. smile

Copy pasting indeed takes only 5 minutes to do, however we don't know the database structure Sebi used in order to show the cities.
So i think it will be a bit more work then just 5 minutes.
However as TyWooOneTime said, there are some other issues Sebi has to look into (the weird price bug for example) and the fact that many, and i mean MANY people are complaining about the non-integration of the foil pricing (yet).
Aside that tcgplayer changed their API some time ago and they have to rewrite a bunch of code in order to completely use the new API as it was intented.
btw TyWooOneTime, do you know if they have an opening for a developer willing to help out?

Regards,

YouryDW

7

(8 replies, posted in Site Discussion)

I agree Gabrosin, therefor i state that warning that there are foils, promos etc going on in the trade will handle this issue while the pricing isn't 100% accurate.
I guess Sebi can do something with the provided code (when changed to PHP and if he coded object oriented, but i think that that won't be an issue...)
So hang in tight for the update which will come smile

As i follow my prices from day to day, i noticed that the maximum price of my collection went up $8,000.00 overnight, does anyone have an explanation for this?
I noticed that my average pricing went up with$ 200, so i guess there might be something going on with the pricing on tcgplayer or here (i found the last price bug also)
Either way, here are the last prices i collected:

Date                cards    Average        Maximum
18/08/2013 20:00    36355     $13 921,35      $34 683,85
19/08/2013 13:00    36355     $13 951,35      $36 070,18
20/08/2013 17:00    36355     $13 959,50      $36 115,82
21/08/2013 7:00    36355     $13 972,27      $36 691,94
22/08/2013 8:00    36355     $14 145,59      $44 694,82

Edited: I just checked my collection and i guess there is something wrong.
As you can see in these pictures there is a price jump, but not as high as listed on deckbox.

Notice that the price not correct in the list of prices as well (as they are sorted by price descending), so i wonder where that weird price came from...

Please check it out smile

PS: for interested buyers, i only keep track of the maximum prices cause they signal price changes a bit faster then average pricing does...

Price on deckbox
http://www.thinkapic.com/DeckBox/deckbox1-1.png
Price on TcgPlayer (by clicking on the price on deckbox)
http://www.thinkapic.com/DeckBox/deckbox1-2.png

Price on deckbox
http://www.thinkapic.com/DeckBox/deckbox2-1.png
Price on TcgPlayer (by clicking on the price on deckbox)
http://www.thinkapic.com/DeckBox/deckbox2-2.png

Price on deckbox
http://www.thinkapic.com/DeckBox/deckbox3-1.png
Price on TcgPlayer (by clicking on the price on deckbox)
http://www.thinkapic.com/DeckBox/deckbox3-2.png

9

(6 replies, posted in Site Discussion)

this would be nice to see indeed, you have my vote smile

10

(8 replies, posted in Site Discussion)

The reason why this has not been implemented yet has to do with the fact that they are not responsible for the prices which are listed here.
As the old (with old I mean the one used until 3 months ago) API didn't support using foil pricing they had to use what they could.
As there is no exact rule on how much a foil cost they did not include a fancy math-part to calculate it by hand card per card.
As the new API was released, i noticed that they had answered somewhere in a post here on the forum that they will implement it in the near future.
However as I am a developer myself, I know that doing this takes far more into consideration then just a little work!
As far as i can tell the team of developers here are doing a great job (as the site still is free, keep that in mind!).
There are some issues here and there, but hey, nobody keeps you from developing a site which has the features that you want to have!

Towards the sellers such as Kaskade I would recommend to ask a feature which informs both people in a trade that there are foils in the trade pool.
This feature is not that long to code and looks like this (in C#)

public bool FoilInTrade(List<Card> userOneCards, List<Card> userTwoCards)
{
    var foilsOne = (from card in userOneCards
        where card.Foil == true
        select card).ToList();
    var foilsTwo = (from card in userTwoCards
        where card.Foil == true
        select card).ToList();
    return (foilsOne.Count + foilsTwo.Count) > 0;
}

Anyway I would really suggest that you check out tcgplayer's API guide in order to know what exactly is possible and what not, because promo, textless and other stuff is impossible to use (for now).

Regards,

YouryDW

11

(4 replies, posted in Site Discussion)

Same here!

12

(3 replies, posted in Site Discussion)

As i remember from a previous post somewhere on this forum the API changed a bit in order to make sure that the prices listed on tcgplayer affliate websites to be trusted.
When one of the sellers on tcgplayer makes a typo for a example this will only be visible on tcgplayer, not on the affliates..
therefor the sync is done after a while, just to be sure that the shops on tcg have the time to fix any mistakes they've made.
This is as well on minimum as maximum prices smile

Thank you for fixing it smile

I've attached all the needed files for you to see the answer to your question!
Why don't you download it? (it states never been downloaded...)
the export has all three in them, i attached the export and a screenshot from the website showing the average...

they don't match...

neither does maximum or minimum...

*bump*

16

(7 replies, posted in Site Discussion)

In fact i checked my list too:

These are reporting as price $0.00

Jötun Owl Keeper
Super Secret Tech
Kongming, "Sleeping Dragon"
Nafs Asp
Our Market Research Shows That Players Like Really Long Card Names So We Made this Card to Have the Absolute Longest Card Name Ever Elemental
Ghazbán Ogre

and last but not least the complete Duel Decks: Elves vs Goblins

17

(7 replies, posted in Site Discussion)

That's a bug due to the fact that the special characters difficult are to send through the API i guess smile

18

(7 replies, posted in Site Discussion)

I'm already asking a double check on the prices for more then a month with no response on 3 posts (the last from last week with screenshots and everything...), i hope they'll start working on it soon cause it keeps me waiting and waiting to sell my complete collection sad

Hi,

I've already posted a topic for this, but as i still didn't had an answer i am going to post it again, but this time with the data in it, so you guys can see what is going on...
I am not planning to check card by card what is going on (as it are 36K+ cards)

As attachment i've added the export, as an excel with formulas in order to check the data of the export and a screenshot of the website so you can see what is going on...

I hope you guys can give me a reason for this or a solution smile

Thanks

20

(2 replies, posted in Site Discussion)

Bump

Can i have a reply on this please?

i've seen that the prices changed a bit, but yet they are still like 4000$ different ?

21

(2 replies, posted in Site Discussion)

As i exported my collection it shows up an average value of $12,734.6 and maximum of $30,163.63 and on your site it shows up average $16,616.31 and maximum $40,500.42

I guess there is something wrong...

I noticed a post a couple of days ago that the API changed and that there were problems with the prices which stayed static on the site, did you guys check the code for the export also?

Thanks for fixing this smile

22

(10 replies, posted in Site Discussion)

+1 for this idea too smile

23

(1 replies, posted in Site Discussion)

Please fix this asap, i needed like a whole day just to add like 100 basic lands...
ended up adding series by series and making backups between each one of them which is crazy sad

24

(1 replies, posted in Site Discussion)

Hi there,

i posted this on your facebook as well after your site came back from the death (indeed what odds are it to crash both drives in RAID1).

I noticed how your query's run when adding a card trough the page of the card itself...
however, from time to time it ends up in causing a problem.

I made a screencapture to make it as clear as possible (see at http://www.youtube.com/watch?v=oxLKpstMW_s) I couldn't get it attached

First you see me watching my inventory with 28.085 cards in it.
As i go to another tab in my browser i look up the Island card as i want to add one of Innistrad.

You see how much different ones I have and then see me add the card.

Then i go back to the inventory and you see the card-amount dropping down as your programming first deletes all island i had prior to the change and then re-adding them...

The problem is that it takes time like this. If i change something else during that time I end up with cards which are gone!!!

I had this like 3 time yesterday and gave up and started thinking what happened... (luckely i had an export i could use to get the ones back i already added)

Fact are these:

Your current situation:

POST happens -> SQL-Query to delete all of the lines possible (user - cardname [i think]) -> SQL-Query to add them one by one with a check on the amount and not adding when amount is zero


Worse that can happen: losing a lot of cards when adding a second one right after you added the one prior to it. (in my case it were 800 cards, ending up deleting them all to re-add them using a backup)

My recommendation:

POST happens -> SQL-Query one by one with a SELECT to count a 0 or 1 response -> on 1 do an UPDATE on amount bigger then zero otherwise DELETE // on 0 do an INSERT to add the card you didn't had yet


Worse that can happen: nothing...



PS: keep up the good work smile

With kind regards
Youry