Pricing (Scripts and Notes)

[woogerboy21]

Alright so after I dont know how long, btw did I mention how much I dislike lua's patterns , here is another script for the http://www.tcgplayers.com site. Currently this script only detects the "high" value of the card(s). I may work in either mid or low prices but for now this is it

[kristijanH]

How do I make other prices available? I copied the csv's and lua files to prices but when I try to update the prices nothing happens: I have TCG player, MTG Fanatic and ABU games.

[Goblin Hero]

Put .lua into Prices folder, restart the program, go to Price-Manage, select price, press update.

[kristijanH]

Looks like it's working. I just got inpatient. How long does it last to fully update? 10min? 30 min? More?

Edit: I use MA on 2 computers. Can I just copy the csv files so I don't have to download it twice?

[Goblin Hero]

long does it last to fully update?

Depends on your internet speed.

Edit: I use MA on 2 computers. Can I just copy the csv files so I don't have to download it twice?

Yes.

[woogerboy21]

Hey Goblin Hero, has anything changed in the 1.1.1 release in regards to the card names or card name formating in the database? The reason I ask is it looks like all the pricing scripts now fail to add a price to any card with a quotation mark in its name (such as angel's feather). It worked in previous versions and I know I haven't changed any code in any of the pricing scripts I have been working with.

[Goblin Hero]

has anything changed in the 1.1.1 release in regards to the card names or card name formating in the database?

Yes. Redownload update package again - I've made the fixes.

[rjp14]

Could anyone please do card pricing scripts for the following sites:

gamingetc.com
channelfireball.com
http://www.oldschoolgaming.net

This would be greatly appreciated as I find these sites to be some of the most price point competitive.

Thanks in advance

[woogerboy21]

Could anyone please do card pricing scripts for the following sites:

gamingetc.com
channelfireball.com
http://www.oldschoolgaming.net

This would be greatly appreciated as I find these sites to be some of the most price point competitive.

Thanks in advance

Looks like the HTML responses from those sites are parseable. If anyone else wants to pitch in feel free to. If not I will add it to the list of things to do. (sorry backed up at the moment with other priorities)

[woogerboy21]

Every time I work on a pricing script its like I have to relearn lua's pattern matching functionality (guess thats what happens when you dont typically use something.)

A recent online trade caused me to throw together a script for starcitygames. Attached is the (messy but functional) file. I have the groundwork laid out for the set structure but have not populated each set id to there database. It only has the M10 and beyond set's configured. If you want the rest feel free to populate it or wait till I get around to doing it.

Also I still am working on the other pricing script requests, I haven't forgot

[rjp14]

I updated two of the pricing scripts to grab the info for M11. I have attached them below.

[woogerboy21]

I updated two of the pricing scripts to grab the info for M11. I have attached them below.

Thanks. I had them updated locally just hadn't got around to posting them. Wouldn't happen to want to work on the starcitygames pricing script would you? Its functional just needs the structure updated to include all the url information for each set on there site. I got it working last night and posted it but moved on to the 3 sites you had requested. Which I have collecting data and identifying card names and prices. I'm having trouble getting the pattern matching working for the blocks of data that contains both name and price for those 3 sites for some reason. They all look like they use the same exact backend database / html format. I'll figure it out, just doesnt seem to be liking the patterns I thought would work.

[woogerboy21]

Alright Goblin Hero. I am stumped and could use some help from someone that might have more lua experience than I once again. I've been working on this pattern all day and just cant figure out why its not finding it. Here is the code:

Code: Select all

<tr id="product_40544" class="odd">
 
 
 
  <td valign="top">
   
      <a id="thumb40544" href="http://hive.crystalcommerce.com/photo/file/2018/344515/large/Act_of_Treason.jpg" class="highslide thumbnail" onclick="return hs.expand(this)"><img src="http://hive.crystalcommerce.com/photo/file/2018/344515/thumb/Act_of_Treason.jpg" title="Click to enlarge" /></a>
      <div class="highslide-caption product_controls" id="caption-for-thumb40544">
        Use arrow keys to navigate.<br />
        <a href="/catalog/magic_singles-core_sets-magic_2011_/act_of_treason/40544">View Details</a>
      </div>
   
  </td>
 
  <td width="100%" valign="top">
    <a href="/catalog/magic_singles-core_sets-magic_2011_/act_of_treason/40544">Act of Treason</a><br />
   
      <span style='font-size:84%'>
     
       
          <strong>Rarity</strong>: <a href='/catalog/magic_singles-core_sets-magic_2011_/280?filter[8]=U'>U</a>
          |
         
       
     
       
          <strong>Color</strong>: <a href='/catalog/magic_singles-core_sets-magic_2011_/280?filter[5]=Red'>Red</a>
         
       
     
      </span>
   
    <table class="invisible-table" width="100%">
     
       
          <tr id="variant_355212" class="variantRow">
            <td class="variantInfo" width="47%">Condition: English | Unplayed</td>
            <td align="right" width="13%">$0.03</td>
            <td align="right" width="10%">x 82</td>
            <td align="right" width="30%"><form action="/cart/add/40544?vid=355212" method="GET" onsubmit="new Ajax.Request('/cart/add/40544?vid=355212', {asynchronous:true, evalScripts:true, method:'get', parameters:Form.serialize(this)});return false;"><input id="item_40544_355212_qty" name="qty" size="1" tabindex="2" type="text" value="0" /><a href="#" onclick="add_amount_to_field($('item_40544_355212_qty'),1); return false"><img src="/images/icons/16x16/shadow/add.png" class="plus_button"></a><input class="add_to_cart catalog" name="commit" type="submit" value="Add to Cart" /></form></td>
          </tr>
       
     
    </table>
  </td>
</tr>


What pattern would you use to identify the name and price of from this block of html response? If I use single line patterns such as ">([%w,-:/' ]+)</a><br />" for the name it finds what I am looking for or ">$([\.%d]+)</td>" for the price it finds that as well but when I try and put them into a patter such as ">([%w,-:/' ]+)</a><br />->$([\.%d]+)</td>" it finds nothing.

[rjp14]

I'll see if I can't figure it out and update it.

[woogerboy21]

Alright I give up ... I f'n hate lua (or maybe its my lack of knowledge). So I read and read and read and read and I have a simple line of:

Code: Select all

<td align="right" width="13%">$0.04</td>


What do you think the pattern would be? I have no idea. It seems that when I try and break the % character in the string like the LUA documentation says all it does is crash the magic album applicatoin. Example: "[<%w =]+.right.[ %w=]+.%d%d%%" ... crash...

Or how about "<td align=.right. width=.13%%.>$0.04</td>" ... crash!

/ragequit!