Here's a mod you can use to sort your masteries on your massdeck pages or group collections.
This can be used with the Show Mastered Cards Mod. (You replace the same line)
// Show all mastered decks from a defined group. // This uses the filler and pending field to define the groups. // $tcg = the name of the TCG as defined in the database; $worth = card worth; $massf = group name in the filler field; $massp = group name in the pending field. function show_massmasters($tcg, $worth = '', $massf = '', $massp = '') { $database = new Database; $sanitize = new Sanitize; $tcg = $sanitize->for_db($tcg); $tcginfo = $database->get_assoc("SELECT * FROM `tcgs` WHERE `name`='$tcg' LIMIT 1"); $tcgid = $tcginfo['id']; $cardsurl = $tcginfo['cardsurl']; $format = $tcginfo['format']; if ( $worth !== '' ) { $worth = intval($worth); } if ( $massf !== '' ) { $massf = $sanitize->for_db($massf); } if ( $massp !== '' ) { $massp = $sanitize->for_db($massp); } if ( $massf !== '' && $massp !== '' ) { if ( $worth !== '' ) { $result = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '1' AND `worth` = '$worth' AND `filler` = '$massf' AND `pending` = '$massp' ORDER BY `mastereddate`, `id`"); } else { $result = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '1' AND `filler` = '$massf' AND `pending` = '$massp' ORDER BY `mastereddate`, `id`"); } } else if ( $massf !== '' && $massp == '' ) { if ( $worth !== '' ) { $result = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '1' AND `worth` = '$worth' AND `filler` = '$massf' ORDER BY `mastereddate`, `id`"); } else { $result = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '1' AND `filler` = '$massf' ORDER BY `mastereddate`, `id`"); } } else if ( $massf == '' && $massp !== '' ) { if ( $worth !== '' ) { $result = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '1' AND `worth` = '$worth' AND `pending` = '$massp' ORDER BY `mastereddate`, `id`"); } else { $result = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '1' AND `pending` = '$massp' ORDER BY `mastereddate`, `id`"); } } else { $result = $database->query("SELECT * FROM `collecting` WHERE `tcg` = '$tcgid' AND `mastered` = '1' ORDER BY `mastereddate`, `id`"); } while ( $row = mysqli_fetch_assoc($result) ) { $mastered = date('F d, Y', strtotime($row['mastereddate'])); if ( $row['badge'] !== '' ) { echo '<img src="'.$tcginfo['cardsurl'].''.$row['badge'].'" alt="" title="Mastered '.$mastered.'" /> '; } else { echo ''.$row['deck'].' '; } } }
show_massmasters($tcg, $worth, $massf, $massp);
show_massmasters('Himitsu TCG', '', 'kurokonobasket'); echo '<br />'; /// just to separate the decks show_massmasters('Himitsu TCG', '', 'zeroescape');
Result:
show_massmasters('Himitsu TCG', '2', 'zeroescape');
Result:
show_massmasters('Himitsu TCG', '', '', 'boxset1');
Result:
show_massmasters('Himitsu TCG', '1', '', 'boxset1');
Result:
show_massmasters('Himitsu TCG', '2', 'zeroescape', 'boxset1');
Result: