The Problem: pre-auto upload mod, i got lazy and didn't upload badges right after i master, so if i display masteries as text, idk which badges i need to upload.
The Solution: find a way to yell @ myself to upload badges for decks that need it on the mastered.php page
Caveats: s/o to kriss for the idea of using multiple columns to show this. also in this scenario the "DON'T BE A LAZY DOYOUNG" is me yelling at myself to upload a badge you can change this to whatever you want (but doyoung is the laziest in nct 127)
in your mastered.php find this line as your starting point
query("SELECT * FROM `collecting` WHERE `tcg`='$id' AND `mastered` = '1' ORDER BY `count`,'mastereddate'");
while ( $row = mysqli_fetch_assoc($result) ) {
go ahead and replace that entire chunk until the second ?php is closed
<?php if ( !isset($_GET['deck']) || $_GET['deck'] === '' ) { ?>
<div style="column-count: 2">
<table>
<?php
$result = $database->query("SELECT * FROM `collecting` WHERE `tcg`='$id' AND `mastered` = '1' ORDER BY `count`,'mastereddate'");
while ( $row = mysqli_fetch_assoc($result) ) {
echo '<tr><td><a href="mastered.php?id='.$id.'&deck='.$row['id'].'">'.$row['deck'].'</a> </td>';
if ($row['badge'] =='') {
echo '<td>DONT BE A LAZY DOYOUNG</td></tr>';
}
else {
echo '</tr>';
}
}
?>
</table>
</div>