no subject

;; i'm going to cry my wife beats me that's why i'm still trying ;;

<?php include('header.php'); ?>

<?php define('VALID_INC', TRUE); include 'func.php'; ?>

<?php } elseif ( isset($_GET['mastereda']) && isset($_GET['masteredb']) && isset($_GET['masteredc']) && $_GET['mastereda'] !== '' && $_GET['masteredb'] !== '' && $_GET['masteredc'] !== '' ) {
    define('VALID_INC', TRUE); include '/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/func.php';
    include('/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/header.php');

$database = new Database;
    $deckid1 = intval($_GET['mastereda']); 
    $deckid2 = intval($_GET['masteredb']);
    $deckid3 = intval($_GET['masteredc']);
    $deckid4 = intval($_GET['masteredd']);
    $deckid5 = intval($_GET['masterede']);
    $deckid6 = intval($_GET['masteredf']);
    $shiptype = intval($_GET['shiptype']);
    $breakpoint = intval($_GET['breakpoint']);
    
    if ( $shiptype == 1 ) { $shiptype = '/'; }
    else if ( $shiptype == 2 ) { $shiptype = '-'; }
    else { $shiptype = '/'; }
    
    $tcginfo = $database->get_assoc("SELECT * FROM `tcgs` WHERE `name`='Pairings' LIMIT 1");

if ( ($database->num_rows("SELECT * FROM `collecting` WHERE `id`='$deckid1' AND `tcg`='".$tcginfo['id']."' LIMIT 1") > 0) && ($database->num_rows("SELECT * FROM `collecting` WHERE `id`='$deckid2' AND `tcg`='".$tcginfo['id']."' LIMIT 1") > 0) ) {

$deckinfo1 = $database->get_assoc("SELECT * FROM `collecting` WHERE `id`='$deckid1' AND `tcg`='".$tcginfo['id']."' LIMIT 1"); 
        $cards1 = explode(',',$deckinfo1['cards']);  
        array_walk($cards1, 'trim_value'); 
        
        $deckinfo2 = $database->get_assoc("SELECT * FROM `collecting` WHERE `id`='$deckid2' AND `tcg`='".$tcginfo['id']."' LIMIT 1"); 
        $cards2 = explode(',',$deckinfo2['cards']);  
        array_walk($cards2, 'trim_value'); 
        
        $deckinfo3 = $database->get_assoc("SELECT * FROM `collecting` WHERE `id`='$deckid3' AND `tcg`='".$tcginfo['id']."' LIMIT 1"); 
        $cards3 = explode(',',$deckinfo3['cards']);  
        array_walk($cards3, 'trim_value');
        
        $deckinfo4 = $database->get_assoc("SELECT * FROM `collecting` WHERE `id`='$deckid4' AND `tcg`='".$tcginfo['id']."' LIMIT 1"); 
        $cards4 = explode(',',$deckinfo4['cards']);  
        array_walk($cards4, 'trim_value');
        
        $deckinfo5 = $database->get_assoc("SELECT * FROM `collecting` WHERE `id`='$deckid5' AND `tcg`='".$tcginfo['id']."' LIMIT 1"); 
        $cards5 = explode(',',$deckinfo5['cards']);  
        array_walk($cards5, 'trim_value');
        
        $deckinfo6 = $database->get_assoc("SELECT * FROM `collecting` WHERE `id`='$deckid6' AND `tcg`='".$tcginfo['id']."' LIMIT 1"); 
        $cards6 = explode(',',$deckinfo6['cards']);  
        array_walk($cards6, 'trim_value');

$count = count($cards1 + $cards2 + $cards3 + $cards4 + $cards5 + $cards6);

echo '<h1>mastered</h1>'; 
        echo '<p align="center">'; 
        echo '<img src="'.$tcginfo['cardsurl'].''.$deckinfo1['badge'].'" alt="" title="Mastered '.$mastered.'" /> <img src="'.$tcginfo['cardsurl'].''.$deckinfo3['badge'].'" alt="" title="Mastered '.$mastered.'" /> <img src="'.$tcginfo['cardsurl'].''.$deckinfo5['badge'].'" alt="" title="Mastered '.$mastered.'" /><br>';
        echo '<img src="'.$tcginfo['cardsurl'].''.$deckinfo6['badge'].'" alt="" title="Mastered '.$mastered.'" /><br>';
        echo '<strong>'.$deckinfo1['deck'].' '.$shiptype.' '.$deckinfo2['deck'].' '.$shiptype.' '.$deckinfo6['deck'].'</strong> - <em>'.date('F d, Y',strtotime($deckinfo2['mastereddate'])).'</em><br /><br>';

$breakpoint = 10;
        for ( $i = 1; $i <= $deckinfo1['count']; $i++ ) {
            $number = $i;
            if ( $number < 10 ) { $number = "0$number"; }
            $card1 = "".$deckinfo1['deck']."$number";                    
            echo '<img src="'.$tcginfo['cardsurl'].''.$card1.'.'.$tcginfo['format'].'" alt="" title="'.$card1.'" /> ';
            if ( $i == $breakpoint ) { echo '<br />'; }
        }
        for ( $i = 1; $i <= $deckinfo2['count']; $i++ ) {
            $number = $i;
            if ( $number < 10 ) { $number = "0$number"; }
            $card2 = "".$deckinfo2['deck']."$number";                
            echo '<img src="'.$tcginfo['cardsurl'].''.$card2.'.'.$tcginfo['format'].'" alt="" title="'.$card2.'" /> ';
            if ( $i == $breakpoint ) { echo '<br />'; }
        }
        for ( $i = 1; $i <= $deckinfo3['count']; $i++ ) {
            $number = $i;
            if ( $number < 10 ) { $number = "0$number"; }
            $card3 = "".$deckinfo3['deck']."$number";                
            echo '<img src="'.$tcginfo['cardsurl'].''.$card3.'.'.$tcginfo['format'].'" alt="" title="'.$card3.'" /> ';
            if ( $i == $breakpoint ) { echo '<br />'; }
        }
        for ( $i = 1; $i <= $deckinfo4['count']; $i++ ) {
            $number = $i;
            if ( $number < 10 ) { $number = "0$number"; }
            $card4 = "".$deckinfo4['deck']."$number";            
            echo '<img src="'.$tcginfo['cardsurl'].''.$card4.'.'.$tcginfo['format'].'" alt="" title="'.$card4.'" /> ';
            if ( $i == $breakpoint ) { echo '<br />'; }
        }
        for ( $i = 1; $i <= $deckinfo5['count']; $i++ ) {
            $number = $i;
            if ( $number < 10 ) { $number = "0$number"; }
            $card5 = "".$deckinfo5['deck']."$number";        
            echo '<img src="'.$tcginfo['cardsurl'].''.$card5.'.'.$tcginfo['format'].'" alt="" title="'.$card5.'" /> ';
            if ( $i == $breakpoint ) { echo '<br />'; }
        }
        for ( $i = 1; $i <= $deckinfo6['count']; $i++ ) {
            $number = $i;
            if ( $number < 10 ) { $number = "0$number"; }
            $card6 = "".$deckinfo6['deck']."$number";                    
            echo '<img src="'.$tcginfo['cardsurl'].''.$card6.'.'.$tcginfo['format'].'" alt="" title="'.$card6.'" /> ';
            if ( $i == $breakpoint ) { echo '<br />'; }
        }
        echo '</p>'; 
    } 
    include('/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/footer.php');
?>
<?php } elseif ( isset($_GET['mastereda']) && isset($_GET['masteredb']) && $_GET['mastereda'] !== '' && $_GET['masteredb'] !== '' ) {
    define('VALID_INC', TRUE); include '/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/func.php';
    include('/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/header.php');

$database = new Database;
    $deckid1 = intval($_GET['mastereda']); 
    $deckid2 = intval($_GET['masteredb']);
    $shiptype = intval($_GET['shiptype']);
    $breakpoint = intval($_GET['breakpoint']);
    
    if ( $shiptype == 1 ) { $shiptype = '/'; }
    else if ( $shiptype == 2 ) { $shiptype = '-'; }
    else { $shiptype = '/'; }
    
    $tcginfo = $database->get_assoc("SELECT * FROM `tcgs` WHERE `name`='Pairings' LIMIT 1");

$count = count($cards1 + $cards2);

echo '<h1>mastered</h1>'; 
        echo '<p align="center">'; 
        echo '<img src="'.$tcginfo['cardsurl'].''.$deckinfo1['badge'].'" alt="" title="Mastered '.$mastered.'" /><br>';
        echo '<strong>'.$deckinfo1['deck'].' '.$shiptype.' '.$deckinfo2['deck'].'</strong> - <em>'.date('F d, Y',strtotime($deckinfo1['mastereddate'])).'</em><br /><br>';

$breakcounter = 0;
        for ( $i = 1; $i <= $deckinfo1['count']; $i++ ) { 
            $number = $i;

if ( $number < 10 ) { $number = "0$number"; } 
            $card1 = "".$deckinfo1['deck']."$number";
            $card2 = "".$deckinfo2['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 />'; }

}

echo '</p>';

} 
    include('/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/footer.php');
?>
<?php } elseif ( isset($_GET['mastered']) && $_GET['mastered'] !== '' ) {
    define('VALID_INC', TRUE); include '/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/func.php';
    include('/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/header.php');

$database = new Database;
    $deckid = intval($_GET['mastered']); 
    
    $tcginfo = $database->get_assoc("SELECT * FROM `tcgs` WHERE `name`='Pairings' LIMIT 1");

if ( $database->num_rows("SELECT * FROM `collecting` WHERE `id`='$deckid' AND `tcg`='".$tcginfo['id']."' LIMIT 1") > 0 ) {

$deckinfo = $database->get_assoc("SELECT * FROM `collecting` WHERE `id`='$deckid' AND `tcg`='".$tcginfo['id']."' LIMIT 1"); 
        $cards = explode(',',$deckinfo['cards']);  
        array_walk($cards, 'trim_value');

$count = count($cards);

echo '<h1>mastered</h1>'; 
        echo '<p align="center">'; 
        echo '<strong>'.$deckinfo['deck'].'</strong> - <em>'.date('F d, Y',strtotime($deckinfo['mastereddate'])).'</em><br />';

for ( $i = 1; $i <= $deckinfo['count']; $i++ ) { 
            $number = $i;

if ( $number < 10 ) { $number = "0$number"; } 
            $card = "".$deckinfo['deck']."$number"; 
            $pending = $database->num_rows("SELECT * FROM `trades` WHERE `tcg`='$id' AND `receiving` LIKE '%$card%'");

if ( in_array($card, $cards) ) echo '<img src="'.$tcginfo['cardsurl'].''.$card.'.'.$tcginfo['format'].'" alt="" />';
            else if ( $pending > 0 ) { echo '<img src="'.$tcginfo['cardsurl'].''.$deckinfo['pending'].'.'.$tcginfo['format'].'" alt="" />'; }
            else { echo '<img src="'.$tcginfo['cardsurl'].''.$deckinfo['filler'].'.'.$tcginfo['format'].'" alt="" />'; }

if ( $deckinfo['puzzle'] == 0 ) { echo ' '; } 
            if ( $deckinfo['break'] !== '0' && $i % $deckinfo['break'] == 0 ) { echo '<br />'; }

}

echo '</p>';

} 
    include('/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/footer.php');
?>

<h1>mastered</h1>

<?php show_masteredpair('pairings','4','5','officer','inspector','/','5'); ?>

<?php include('/home3/mauboxn1/public_html/rainpuddles.net/tcg/pairings/footer.php'); ?>

(115 comments)

no subject

Post a comment in response: