MOAR CODE and also trades?!

[adurotum]

Sup Pairings!

Ten rolling through again with another batch of code for those using websites to host their cards. I have them held in a folder here, but I'll also link each set of instructions below in case you're looking for something specific! I've also updated some of the code I linked before, so if you installed any code earlier, I would recommend re-installing them and re-reading the guides to make sure you've got the most up-to-date version.

Displaying ships on your collecting page I THINK I added in selecting your ship type and fixed a spacing issue since the last time I posted this code.

Displaying all 60 cards in an OT3 on your collecting page New code, I think! Handy for OT3 collectors who want to see all the cards they need for an OT3 at once.

Displaying ships on your mastery page I literally finished this one just this morning, and unfortunately I don't have a good number of ot3s/repeated mastered decks to properly test this one out. So! If you have repeated mastered decks and/or OT3s mastered, I'd really appreciate it if you gave me feedback on this code and whether or not it runs properly. as another note to mod-types, please ignore the mastery pairing for the ot3, I needed something to test out the display and didn't have any ot3s mastered yet 8( The cards displayed here don't add to my card count and I'll take down this example ot3 in a week.)

EDIT: If you were interested in having quotes displayed with your masteries/collecting decks, I drafted up two mini guides on how to alter your code to allow for quotes.

You can see examples of almost all the code on my site! If any of the code or my guides don't make sense/break your site horribly at any point, feel free to contact me through this post and I'll help clear things up. And because this is the trading comm and all, I am always open to trades! I'm especially looking for any gangsta decks (heels, tags, pallmall) so I can have a for-real ot3 mastery and lucky dog decks (luckydog x5, maddog, smuggle, assault) for... reasons...

Coding-wise, I'm going to take a little break in order to catch up on graphics and other things, but I'll be tackling mass decks next. If there's any other code you'd be interested in having, I'm open to suggestions! Thanks for your time o7

Comments

[adurotum]

whoop OKAY I think I have one working! Just real quickly, was there a preferred displaying format you had (alternating vs one deck a row) or would you like access to both?

[fakejapanese]

I usually use alternating! 'u'

[adurotum]

Awesome, okay.

In your func.php file, go all the way to the bottom where you see ?> and stuck this chunk of code before it.

// Show a pair of collecting decks with alternating images $decknumber = name of a collecting deck. function show_collectingsamepair($tcg, $decknumber1 = '', $decknumber2 = '', $shiptype = '', $breakpoint = '', $quote = '') { $database = new Database; $sanitize = new Sanitize; $tcg = $sanitize->for_db($tcg); if ( $shiptype == '' ) { $shiptype = '/'; } if ( $breakpoint == '' ) { $breakpoint = 5; } $tcginfo = $database->get_assoc("SELECT * FROM `tcgs` WHERE `name`='$tcg' LIMIT 1"); $tcgid = $tcginfo['id']; $cardsurl = $tcginfo['cardsurl']; $format = $tcginfo['format']; if ( $decknumber1 !== '' ) { $decknumber1 = $sanitize->for_db($decknumber1); } if ( $decknumber2 !== '' ) { $decknumber2 = $sanitize->for_db($decknumber2); } if ( $decknumber1 !== '' and $decknumber2 !== '' ) { $result1 = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '0' AND `id` = '$decknumber1' ORDER BY `sort`, `worth`"); $result2 = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '0' AND `id` = '$decknumber2' ORDER BY `sort`, `worth`"); } else { $result = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '0' ORDER BY `sort`, `worth`, `deck`"); } while ( ($row1 = mysql_fetch_assoc($result1)) && ($row2 = mysql_fetch_assoc($result2)) ) { $cards1 = explode(',',$row1['cards']); $cards2 = explode(',',$row2['cards']); array_walk($cards1, 'trim_value'); array_walk($cards2, 'trim_value'); if ( $row1['cards'] == '' and $row2['cards'] == '' ) { $count = 0; } else if ( $row1['cards'] == '' ) { $count = count($cards2); } else if ( $row2['cards'] == '' ) { $count = count($cards1); } else { $count = (count($cards1) + count($cards2)); } ?> <br /> <h2><?php echo $row1['deck']; ?> <?php echo $shiptype; ?> <?php echo $row2['deck']; ?> (<?php echo $count; ?>/<?php echo $row1['count']+$row2['count']; ?>)</h2> <?php echo $quote; ?> <p align="center"> <?php $breakcounter = 0; for ( $i = 1; $i <= $row1['count']; $i++ ) { $number = $i; if ( $number < 10 ) { $number = "0$number"; } $card1 = "".$row1['deck']."$number"; $card2 = "".$row2['deck']."$number"; $pending1 = $database->num_rows("SELECT * FROM `trades` WHERE `tcg`='$tcgid' AND `receiving` LIKE '%$card1%'"); $pending2 = $database->num_rows("SELECT * FROM `trades` WHERE `tcg`='$tcgid' AND `receiving` LIKE '%$card2%'"); if ( in_array($card1, $cards1) ) echo '<img src="'.$tcginfo['cardsurl'].''.$card1.'.'.$tcginfo['format'].'" alt="" title="'.$card1.'" />'; else if ( $pending1 > 0 ) { echo '<img src="'.$tcginfo['cardsurl'].''.$row1['pending'].'.'.$tcginfo['format'].'" alt="" title="'.$card1.'" />'; } else { echo '<img src="'.$tcginfo['cardsurl'].''.$row1['filler'].'.'.$tcginfo['format'].'" alt="" />'; } $breakcounter++; if ( $row1['puzzle'] == 0 ) { echo ' '; } if ( $breakpoint !== '0' && $breakcounter % $breakpoint == 0 ) { echo '<br />'; } if ( in_array($card2, $cards2) ) echo '<img src="'.$tcginfo['cardsurl'].''.$card2.'.'.$tcginfo['format'].'" alt="" title="'.$card2.'" />'; else if ( $pending2 > 0 ) { echo '<img src="'.$tcginfo['cardsurl'].''.$row2['pending'].'.'.$tcginfo['format'].'" alt="" title="'.$card2.'" />'; } else { echo '<img src="'.$tcginfo['cardsurl'].''.$row2['filler'].'.'.$tcginfo['format'].'" alt="" />'; } $breakcounter++; if ( $row2['puzzle'] == 0 ) { echo ' '; } if ( $breakpoint !== '0' && $breakcounter % $breakpoint == 0 ) { echo '<br />'; } } ?> </p> <?php } }

Once you have that in, save and head over to your pairings.php file. You'll also want to pop open easytcg, because you'll need to refer to numbers on your collecting page.

The code you'll be using to display same-deck pairings is this:
<?php show_collectingsamepair('Pairings','120','119','/','5',"<h3>the ship of fabulous hair</h3>"); ?>

You should be familiar with everything in there if you've used the other code except for the '120' and '119', these numbers are the way to identify which deck in your collecting section to use. To get these numbers, go into your >>View Collecting in easytcg and scroll to the decks you want to add. If you hover over the red x next to the deck name, somewhere on your screen (I think it differs depending on your browser), you'll see a preview for where this x takes you/does in the form of a URL. It'll look something like:

http://adurotum.needtakehave.com/etcg/collecting.php?id=3&action=delete&cat=121

You can also just right click the x and hit Copy Link then paste the link somewhere else. Anyway, that last number at the end of the url, in this case the 121, is the unique identifying number for this deck. It'll always be different from the number of any other deck (as far as I've seen, anyway), even though they have the same name. All you have to do is pull these two numbers and stick them into your code and you should have the results you want!

If any of this is unclear, or something goes horribly wrong, feel free to comment back!

[portaling]

I'm getting a really weird "Parse error: syntax error, unexpected '>' in /home/needtake_aaron/public_html/portaling/func.php on line 1349" error. I've tried correcting it on my own but I can't quite figure it out. I was wondering if you could solve it?

[adurotum]

SORRY THIS IS SO LATE sob

What's the line of code on 1349?