';
echo '";
echo '
'; // 헤더 끝
if($_GET['page'] == '') $_GET['page'] = 1;
if($_GET['set'] != "" and $_GET['mode'] == "iconic")
{
//set 읽기
$query = "select * from `xe_mtga_cards` where `code` = '".$_GET['set']."' and (`side` = 'a' or `side` is null) and `number` not like '%AA%'";
$_GET['color'] = strtoupper($_GET['color']);
if($_GET['color'] != "" and $_GET['color'] != "C" )
{
$query = $query." and (";
for($i=0;$i- ';
echo $nhtml;
echo "
';
echo '
'; //container
}
if($_GET['set'] != "" and $_GET['mode'] == "list")
{
$_GET['arg'] = 'ko';
echo '';
for($i=0;$i<$resultq->num_rows;$i++)
{
$temp = $resultq->fetch_assoc();
echo '
'; //row
echo '';
echo '
'; //col
}
echo '';
// 크롭디자인, 카드이름, 코드번호
echo '';
echo '
'; //
echo ''.$temp['code'].'-'.$temp['number'].'
'; echo '';
// leftbox
// 왼쪽 메뉴
echo "
"; // 스타일에 맞는 CSS 적용
echo '조건 필터 열기';
// 검색용 드롭다운 박스들 출력
//echo "
"; // end of leftbox
// midbox
echo "검색용 필터
"; /*echo '조건 필터 열기'; */ echo "";
// set
echo "
";
echo "";
$query = "select * from xe_mtga_card_sets where `is_online_only` = 'N' order by release_date DESC";
$resultset = $dbcs->query($query);
echo "";
echo "";
echo "
";
// rarity
echo "";
echo "";
echo "";
echo "
";
// color
echo "";
echo "";
echo "";
echo "
";
// ctype
echo "";
echo "";
echo "";
echo "
";
// porder
echo "";
echo "";
echo "";
echo "
";
// ln
echo "";
echo "";
echo "";
echo "
";
// 보기 형태
echo '필터 초기화';
echo "";
// 세트 리스트 출력 모드
$query = "select * from xe_mtga_cards
where xe_mtga_cards.`code` = '".strtoupper($_GET['set'])."' and xe_mtga_cards.`number` not like 'AA%' and (xe_mtga_cards.`side` = 'a' or xe_mtga_cards.`side` is null)
";
//필터옵션 - 기본 필터 가져오기
if($rarity != '') $query = $query." and xe_mtga_cards.`rarity` = '".$rarity."'";
if($color != "")
{
if($color == "C") $query = $query." and xe_mtga_cards.`colors` = '[]' or xe_mtga_cards.`colors` is null ";
else $query = $query." and xe_mtga_cards.`colors` like '%".$color."%' ";
}
if($ctype != "") $query = $query." and xe_mtga_cards.`types` like '%".$ctype."%' ";
//정렬옵션 통합 - 가격(높은, 낮은), 번호(오름, 내림)
switch($sort)
{
case 'high' :
$query = $query." order by xe_mtga_cards.`norm` DESC ";
break;
case 'low' :
$query = $query." order by xe_mtga_cards.`norm` ASC ";
break;
case 'fhigh' :
$query = $query." order by xe_mtga_cards.`form` DESC ";
break;
case 'flow' :
$query = $query." order by xe_mtga_cards.`form` ASC ";
break;
case 'asc' :
$query = $query." order by xe_mtga_cards.`number`*1 ASC";
break;
case 'desc' :
$query = $query." order by xe_mtga_cards.`number`*1 DESC";
break;
default :
echo $sort;
break;
}
$resultlist = $dbcs->query($query);
//echo $query;
//exit();
$totalpage = ceil($resultlist->num_rows / $ln);
// 페이지뷰
$query = $query." LIMIT ".(($_GET['page']-1) * $ln).", ".$ln;
$resultlist = $dbcs->query($query);
echo '
'; // end of row
}
else if($_GET['set'] != "" and $_GET['code'] != "")
{
// 데이터 값 획득
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`code` = '".$_GET['set']."' and xe_mtga_cards.`number` = '".$_GET['code']."' order by xe_mtga_cards.`type_k` DESC";
//if($_GET['set'] == "CMB1" and $_GET['code'] == "100") echo $query;
// 정렬시 참조용
// SELECT * FROM `xe_mtga_cards` WHERE `code` = 'ISD' ORDER BY length(`xe_mtga_cards`.`number`) ASC, `xe_mtga_cards`.`number` ASC
$result = $dbcs->query($query);
if($result->num_rows == 1)
{
// 카드 검색 내용 출력
$row = $result->fetch_assoc();
/*if($row['layout'] == "meld")
{
// 멜드카드 처리
// 3개 한번에 내보냅니다.
}
else
*/
{
echo "';
if($page != "1") echo '이전';
else echo '이전';
// 페이지 네이션
echo "
";
echo "- ";
echo "
- 첫 페이지 "; for($zi=-4;$zi<5;$zi++) { if($page + $zi != $page) { if($page + $zi > 0 and $page + $zi <= $totalpage) echo "
- ".($page+$zi)." "; } else { echo "
- ".($page+$zi)." "; } } echo "
- 끝 페이지 "; echo "
";
for($zx=0;$zx<$resultlist->num_rows;$zx++)
{
// 각 카드에 대해서
$templist = $resultlist->fetch_assoc();
$_GET['code'] = $templist['number'];
// 데이터 값 획득
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`code` = '".$_GET['set']."' and xe_mtga_cards.`number` = '".$_GET['code']."'";
//if($_GET['set'] == "CMB1" and $_GET['code'] == "100") echo $query;
// 정렬시 참조용
// SELECT * FROM `xe_mtga_cards` WHERE `code` = 'ISD' ORDER BY length(`xe_mtga_cards`.`number`) ASC, `xe_mtga_cards`.`number` ASC
$result = $dbcs->query($query);
if($result->num_rows == 1)
{
// 카드 검색 내용 출력
$row = $result->fetch_assoc();
/*if($row['layout'] == "meld")
{
// 멜드카드 처리
// 3개 한번에 내보냅니다.
}
else
*/
{
echo "
';
// end of row
}// end of list 출력
else if($_GET['set'] == "" and $_GET['code'] == "" and $_GET['search'] == "" and $_GET['mode'] == "")
{
echo "";
echo "
"; // cardcontainer
}// end of meld
} // end of if 자료 갯수 1개
else if($result->num_rows > 1) // 양면, 스플릿, 어드벤처
{
// 자료를 a, b 별도로 받고 구성합니다.
// $row에 뒷면인지 앞면인지 옆면인지 모를 카드 이름을 받았습니다.
// 메인 쿼리 자체는 a를 가리켜야 하고, 서브 쿼리가 b를 가리켜야 합니다.
// 카드 이미지는 layout 값에 따라 다른 방식으로 보여줍니다.
// layout - adventure, aftermath, flip, meld, normal, split, transform
$row = $result->fetch_assoc(); // 일단 한개 빼고
$rowb = array();
if($row['layout'] == 'adventure' or $row['layout'] == 'aftermath' or $row['layout'] == 'flip' or $row['layout'] == 'split' or $row['layout'] == 'transform' or $row['layout'] == 'modal_dfc')
{
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`code` = '".$_GET['set']."' and xe_mtga_cards.`number` = '".$_GET['code']."' and xe_mtga_cards.`side` = 'a'";
$result = $dbcs->query($query);
$row = $result->fetch_assoc();
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`code` = '".$_GET['set']."' and xe_mtga_cards.`number` = '".$_GET['code']."' and xe_mtga_cards.`side` = 'b'";
$result = $dbcs->query($query);
$rowb = $result->fetch_assoc();
}
//print_r($query);
//echo "";
echo '
"; // cardgrid
echo "'; // 사이즈 이펙트 처리 다르게
if($_GET['arg'] == "ko" and $row['name_k'] != "") echo '.')
';
else if($_GET['arg'] == "ko" and $row['name_k'] == "") echo '.')
';
else if($_GET['arg'] == "en") echo '';
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['name_k'] != "") echo '';
else echo '';
echo "
";
echo "";
echo ''; // 가격 관련
echo '
'; // end of cardinfoetc
echo ''; //세트로고, 세트명(약어), #카드번호, 희귀도
echo '
'; // end of cardmoreinfo
echo ''.$row["setname"].'
#'.$row['number'].' - '; switch($row['rarity']) { case "mythic" : echo 'Mythic Rare'; break; case "rare" : echo 'Rare'; break; case "uncommon" : echo 'Uncommon'; break; case "common" : echo 'Common'; break; default : } echo '
';
echo '#'.$row['number'].' - '; switch($row['rarity']) { case "mythic" : echo 'Mythic Rare'; break; case "rare" : echo 'Rare'; break; case "uncommon" : echo 'Uncommon'; break; case "common" : echo 'Common'; break; default : } echo '
';
echo '
';
echo '
'; // end of cardprice
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`name` = '".addslashes($row['name'])."' order by xe_mtga_card_sets.release_date DESC";
$resultx = $dbcs->query($query);
echo '| 분류 | NM | EX | VG | G |
| 일반 | '; for($i=0;$i < count($ckn);$i++) { if($ckn[$i]->ava == "OoS") echo ''.$ckn[$i]->price.' | '; else echo ''.$ckn[$i]->price.' | '; } } echo "||
| 포일 | '; for($i=0;$i < count($ckn);$i++) { if($ckn[$i]->ava == "OoS") echo ''.$ckn[$i]->price.' | '; else echo ''.$ckn[$i]->price.' | '; } } echo "
';
echo '';
if($resultx->num_rows < 6)
{
for($i=0;$i<$resultx->num_rows;$i++)
{
$rowset = $resultx->fetch_assoc();
//$ckn = ckprice($dbcs, $rowset['code'], $rowset['number'], 'normal');
echo '
';
echo '
'; // end of cardsets
echo '| ';
echo '';
if($rowset['name'] != "Plains" and $rowset['name'] != "Island" and $rowset['name'] != "Swamp" and $rowset['name'] != "Mountain" and $rowset['name'] != "Forest")
{
echo ' (등록수 : ';
$query = "select count(*) as count from ob_pddb where `set` = '".$rowset['code']."' and `code` = '".$rowset['number']."'";
$resultcount = $dbcs->query($query);
$rowcount = $resultcount->fetch_assoc();
echo $rowcount['count'];
echo ') ';
}
echo ''.$rowset['code'].'-'.$rowset['number'].' ';
echo ' |
| ';
echo '';
//if($rowset['name'] != "Plains" and $rowset['name'] != "Island" and $rowset['name'] != "Swamp" and $rowset['name'] != "Mountain" and $rowset['name'] != "Forest")
{
echo ' (등록수 : ';
$query = "select count(*) as count from ob_pddb where `set` = '".$rowset['code']."' and `code` = '".$rowset['number']."'";
$resultcount = $dbcs->query($query);
$rowcount = $resultcount->fetch_assoc();
echo $rowcount['count'];
echo ') ';
}
echo ''.$rowset['code'].'-'.$rowset['number'].' ';
echo ' |
| '; if($resultx->num_rows > 6) echo ''; echo ' |
| '; echo ''; // end of othersets echo ' |
';
echo '
'; // end of cardsellerinfo
echo ''; // 샵 수와 샵들 가격 나열
echo '
'; // end of cardshop
echo '제품 취급 온라인샵
'; echo '';
// d 등급 이상의 관리자만 띄우기
$query = "select * from ob_pddb inner join ob_userdb on ob_pddb.`pid` = ob_userdb.`poid` and ob_pddb.`set` = '".$_GET['set']."' and ob_pddb.`code` = '".$_GET['code']."' and ob_userdb.`service` > 'd' and ob_pddb.`del` = 'n' order by ob_pddb.`lastdate`";
$resultus = $dbcs->query($query);
if($resultus->num_rows == 0)
{
echo '';
for($i=0;$i<$resultus->num_rows;$i++)
{
$temp = $resultus->fetch_assoc();
if($temp['count'] != 0)
{
echo '
';
echo '
'; // end of list
echo '';
echo '
';
}
echo '- 취급 온라인샵이 없습니다. -
'; echo '| '; echo ''.pid2nickname($temp['pid']).""; echo ' | '; echo ''.lang2flag($temp['language']).stat2icon($temp['stat']);
if($temp['type'] == 'foil') echo " ";
echo ' | ';
echo '';
echo price2html($dbcs, $temp['ck'], $temp['type'],$temp['stat'],$temp['price'])."원 (보유 ".$temp['count']."장) "; if($_COOKIE['ob_id'] != $temp['pid'] and $temp['count'] != 0) { switch($temp['pid']) { case '1441741308' : echo '홈페이지에서 구매'; break; default : echo '장바구니 장 '; break; } } echo ' | ';
echo '
';
echo '
'; // end of carddatainfo
echo "';
if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['name_k']; echo " ".mtgsymbols($row['mana_cost']); echo " English";}
else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['name']; echo " ".mtgsymbols($row['mana_cost']);}
else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['name']; echo " ".mtgsymbols($row['mana_cost']); echo " 한국어판";}
else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['name']; echo " ".mtgsymbols($row['mana_cost']);}
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['name_k']; echo " ".mtgsymbols($row['mana_cost']); echo " English";}
else {echo $row['name']; echo " ".mtgsymbols($row['mana_cost']); }
echo '
';
echo '';
if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['type_k']; }
else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['type']; }
else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['type']; }
else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['type']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['type_k'];}
else {echo $row['type'];}
echo '
';
echo '';
$row['text_k'] = mtgsymbols(nl2br($row['text_k']));
$row['text'] = mtgsymbols(nl2br($row['text']));
if($_GET['arg'] == "ko" and $row['text_k'] != "") { echo $row['text_k'];}
else if($_GET['arg'] == "ko" and $row['text_k'] == "") { echo $row['text']; }
else if($_GET['arg'] == "en" and $row['text_k'] != "") {echo $row['text']; }
else if($_GET['arg'] == "en" and $row['text_k'] == "") { echo $row['text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['text_k'] != "") {echo $row['text_k']; }
else {echo $row['text']; }
echo '
';
echo '';
echo '';
$row['flavor_text_k'] = nl2br($row['flavor_text_k']);
$row['flavor_text'] = nl2br($row['flavor_text']);
if($_GET['arg'] == "ko" and $row['flavor_text_k'] != "") { echo $row['flavor_text_k'];}
else if($_GET['arg'] == "ko" and $row['flavor_text_k'] == "") { echo $row['flavor_text']; }
else if($_GET['arg'] == "en" and $row['flavor_text_k'] != "") {echo $row['flavor_text']; }
else if($_GET['arg'] == "en" and $row['flavor_text_k'] == "") { echo $row['flavor_text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['flavor_text_k'] != "") {echo $row['flavor_text_k']; }
else {echo $row['flavor_text']; }
echo '';
echo '
';
echo '';
if($row['power'] != "" and $row['toughness'] != "") echo $row['power']."/".$row['toughness'];
else if($row['loyalty'] != "")echo "충성도 : ".$row['loyalty'];
echo '
';
echo '';
echo 'Illustrated by '.$row['artist'];
echo '
';
echo '';
//echo $row['legalities'];
echo ''; //{"brawl":"Legal","commander":"Legal","duel":"Legal","future":"Legal","historic":"Legal","legacy":"Legal","modern":"Legal","pioneer":"Legal","standard":"Legal","vintage":"Legal"}
echo '
';
echo '
';
echo ''.$leg['standard'].' | ';
else if($leg['standard'] == "") echo 'Illegal | ';
else echo ''.$leg['standard'].' | ';
echo 'Standard | ';
if($pos % 2 == 0)
{
echo '
'.$leg['pioneer'].' | ';
else if($leg['pioneer'] == "") echo 'Illegal | ';
else echo ''.$leg['pioneer'].' | ';
echo 'Pioneer | ';
if($pos % 2 == 0)
{
echo '
'.$leg['modern'].' | ';
else if($leg['modern'] == "") echo 'Illegal | ';
else echo ''.$leg['modern'].' | ';
echo 'Modern | ';
if($pos % 2 == 0)
{
echo '
'.$leg['legacy'].' | ';
else if($leg['legacy'] == "") echo 'Illegal | ';
else echo ''.$leg['legacy'].' | ';
echo 'Legacy | ';
if($pos % 2 == 0)
{
echo '
'.$leg['vintage'].' | ';
else if($leg['vintage'] == "") echo 'Illegal | ';
else echo ''.$leg['vintage'].' | ';
echo 'Vintage | ';
if($pos % 2 == 0)
{
echo '
'.$leg['commander'].' | ';
else if($leg['commander'] == "") echo 'Illegal | ';
else echo ''.$leg['commander'].' | ';
echo 'Commander | ';
if($pos % 2 == 0)
{
echo '
'.$value.' | ';
else echo ''.$value.' | ';
echo ''.ucfirst($key).' | ';
if($pos % 2 == 0)
{
echo '|
";
echo "
";
// end of midbox
echo '";
echo "
"; // cardgrid
} // end of if 자료 갯수 2개
} // end of for
// 여기에 무한 넘기기 표시
/*
echo '
';
*/
if($page != "1") echo '이전';
else echo '이전';
// 페이지 네이션
echo "";
echo '
"; // cardcontainer
echo "'; // 사이즈 이펙트 처리 다르게
if($_GET['arg'] == "ko" and $row['name_k'] != "") echo '';
else if($_GET['arg'] == "ko" and $row['name_k'] == "") echo '';
else if($_GET['arg'] == "en") echo '';
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['name_k'] != "") echo '';
else echo '';
if($row['layout'] == 'transform' or $row['layout'] == 'modal_dfc')
{
echo '';
}
echo "
"; // end of cardboxinfo
echo "";
echo ''; // 가격 관련
echo '
'; // end of cardinfoetc
echo ''; //세트로고, 세트명(약어), #카드번호, 희귀도
echo '
'; // end of cardmoreinfo
echo ''.$row["setname"].'
#'.$row['number'].' - '; switch($row['rarity']) { case "mythic" : echo 'Mythic Rare'; break; case "rare" : echo 'Rare'; break; case "uncommon" : echo 'Uncommon'; break; case "common" : echo 'Common'; break; default : } echo '
';
echo '#'.$row['number'].' - '; switch($row['rarity']) { case "mythic" : echo 'Mythic Rare'; break; case "rare" : echo 'Rare'; break; case "uncommon" : echo 'Uncommon'; break; case "common" : echo 'Common'; break; default : } echo '
';
echo '
';
echo '
'; // end of cardprice
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`name` = '".addslashes($row['name'])."' order by xe_mtga_card_sets.release_date DESC";
$resultx = $dbcs->query($query);
echo '| 분류 | NM | EX | VG | G |
| 일반 | '; for($i=0;$i < count($ckn);$i++) { if($ckn[$i]->ava == "OoS") echo ''.$ckn[$i]->price.' | '; else echo ''.$ckn[$i]->price.' | '; } } echo "||
| 포일 | '; for($i=0;$i < count($ckn);$i++) { if($ckn[$i]->ava == "OoS") echo ''.$ckn[$i]->price.' | '; else echo ''.$ckn[$i]->price.' | '; } } echo "
';
echo '';
if($resultx->num_rows < 6)
{
for($i=0;$i<$resultx->num_rows;$i++)
{
$rowset = $resultx->fetch_assoc();
//$ckn = ckprice($dbcs, $rowset['code'], $rowset['number'], 'normal');
echo '
';
echo '
'; // end of cardsets
echo '| ';
echo '';
if($rowset['name'] != "Plains" and $rowset['name'] != "Island" and $rowset['name'] != "Swamp" and $rowset['name'] != "Mountain" and $rowset['name'] != "Forest")
{
echo ' (등록수 : ';
$query = "select count(*) as count from ob_pddb where `set` = '".$rowset['code']."' and `code` = '".$rowset['number']."'";
$resultcount = $dbcs->query($query);
$rowcount = $resultcount->fetch_assoc();
echo $rowcount['count'];
echo ') ';
}
echo ''.$rowset['code'].'-'.$rowset['number'].' ';
echo ' |
| ';
echo '';
if($rowset['name'] != "Plains" and $rowset['name'] != "Island" and $rowset['name'] != "Swamp" and $rowset['name'] != "Mountain" and $rowset['name'] != "Forest")
{
echo ' (등록수 : ';
$query = "select count(*) as count from ob_pddb where `set` = '".$rowset['code']."' and `code` = '".$rowset['number']."'";
$resultcount = $dbcs->query($query);
$rowcount = $resultcount->fetch_assoc();
echo $rowcount['count'];
echo ') ';
}
echo ''.$rowset['code'].'-'.$rowset['number'].' ';
echo ' |
| '; if($resultx->num_rows > 6) echo ''; echo ' |
| '; echo ''; // end of othersets echo ' |
';
echo '
'; // end of cardsellerinfo
echo ''; // 샵 수와 샵들 가격 나열
echo '
'; // end of cardshop
echo '제품 취급 온라인샵
'; echo '';
// d 등급 이상의 관리자만 띄우기
$query = "select * from ob_pddb inner join ob_userdb on ob_pddb.`pid` = ob_userdb.`poid` and ob_pddb.`set` = '".$_GET['set']."' and ob_pddb.`code` = '".$_GET['code']."' and ob_userdb.`service` > 'd' and ob_pddb.`del` = 'n' order by ob_pddb.`lastdate`";
$resultus = $dbcs->query($query);
if($resultus->num_rows == 0)
{
echo '';
for($i=0;$i<$resultus->num_rows;$i++)
{
$temp = $resultus->fetch_assoc();
if($temp['count'] != 0)
{
echo '
';
echo '
'; // end of list
echo '';
echo '
';
}
echo '- 취급 온라인샵이 없습니다. -
'; echo '| '; echo ''.pid2nickname($temp['pid']).""; echo ' | '; echo ''.lang2flag($temp['language']).stat2icon($temp['stat']);
if($temp['type'] == 'foil') echo "";
echo ' | ';
echo '';
echo price2html($dbcs,$temp['ck'], $temp['type'],$temp['stat'],$temp['price'])."원 (보유 ".$temp['count']."장) "; if($_COOKIE['ob_id'] != $temp['pid']) { switch($temp['pid']) { case '1441741308' : echo '홈페이지에서 구매'; break; default : echo '장바구니 장 '; break; } //echo '장바구니 장 '; } echo ' | ';
echo '
';
echo '
'; // end of carddatainfo
//echo "';
if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['name_k'].' // '.$rowb['name_k']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " English";} else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']);} else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " 한국어판";} else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']);} else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['name_k'].' // '.$rowb['name_k']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " English";} else {echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); } echo '
';
echo '".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " English";} else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']);} else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " 한국어판";} else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']);} else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['name_k'].' // '.$rowb['name_k']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " English";} else {echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); } echo '
전면 :
'; if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['type_k']; } else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['type']; } else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['type']; } else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['type']; } else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['type_k'];} else {echo $row['type'];} echo '
';
echo ''; if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['type_k']; } else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['type']; } else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['type']; } else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['type']; } else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['type_k'];} else {echo $row['type'];} echo '
';
$row['text_k'] = mtgsymbols(nl2br($row['text_k']));
$row['text'] = mtgsymbols(nl2br($row['text']));
if($_GET['arg'] == "ko" and $row['text_k'] != "") { echo $row['text_k'];}
else if($_GET['arg'] == "ko" and $row['text_k'] == "") { echo $row['text']; }
else if($_GET['arg'] == "en" and $row['text_k'] != "") {echo $row['text']; }
else if($_GET['arg'] == "en" and $row['text_k'] == "") { echo $row['text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['text_k'] != "") {echo $row['text_k']; }
else {echo $row['text']; }
echo '
';
echo '';
echo '';
$row['flavor_text_k'] = nl2br($row['flavor_text_k']);
$row['flavor_text'] = nl2br($row['flavor_text']);
if($_GET['arg'] == "ko" and $row['flavor_text_k'] != "") { echo $row['flavor_text_k'];}
else if($_GET['arg'] == "ko" and $row['flavor_text_k'] == "") { echo $row['flavor_text']; }
else if($_GET['arg'] == "en" and $row['flavor_text_k'] != "") {echo $row['flavor_text']; }
else if($_GET['arg'] == "en" and $row['flavor_text_k'] == "") { echo $row['flavor_text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['flavor_text_k'] != "") {echo $row['flavor_text_k']; }
else {echo $row['flavor_text']; }
echo '';
echo '
';
echo '';
if($row['power'] != "" and $row['toughness'] != "") echo $row['power']."/".$row['toughness'];
else if($row['loyalty'] != "")echo "충성도 : ".$row['loyalty'];
echo '
';
echo '후면 :
'; if($_GET['arg'] == "ko" and $rowb['type_k'] != "") { echo $rowb['type_k']; } else if($_GET['arg'] == "ko" and $rowb['type_k'] == "") { echo $rowb['type']; } else if($_GET['arg'] == "en" and $rowb['type_k'] != "") {echo $rowb['type']; } else if($_GET['arg'] == "en" and $rowb['type_k'] == "") { echo $rowb['type']; } else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $rowb['type_k'] != "") {echo $rowb['type_k'];} else {echo $rowb['type'];} echo '
';
echo ''; if($_GET['arg'] == "ko" and $rowb['type_k'] != "") { echo $rowb['type_k']; } else if($_GET['arg'] == "ko" and $rowb['type_k'] == "") { echo $rowb['type']; } else if($_GET['arg'] == "en" and $rowb['type_k'] != "") {echo $rowb['type']; } else if($_GET['arg'] == "en" and $rowb['type_k'] == "") { echo $rowb['type']; } else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $rowb['type_k'] != "") {echo $rowb['type_k'];} else {echo $rowb['type'];} echo '
';
$rowb['text_k'] = mtgsymbols(nl2br($rowb['text_k']));
$rowb['text'] = mtgsymbols(nl2br($rowb['text']));
if($_GET['arg'] == "ko" and $rowb['text_k'] != "") { echo $rowb['text_k'];}
else if($_GET['arg'] == "ko" and $rowb['text_k'] == "") { echo $rowb['text']; }
else if($_GET['arg'] == "en" and $rowb['text_k'] != "") {echo $rowb['text']; }
else if($_GET['arg'] == "en" and $rowb['text_k'] == "") { echo $rowb['text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $rowb['text_k'] != "") {echo $rowb['text_k']; }
else {echo $rowb['text']; }
echo '
';
echo '';
echo '';
$rowb['flavor_text_k'] = nl2br($rowb['flavor_text_k']);
$rowb['flavor_text'] = nl2br($rowb['flavor_text']);
if($_GET['arg'] == "ko" and $rowb['flavor_text_k'] != "") { echo $rowb['flavor_text_k'];}
else if($_GET['arg'] == "ko" and $rowb['flavor_text_k'] == "") { echo $rowb['flavor_text']; }
else if($_GET['arg'] == "en" and $rowb['flavor_text_k'] != "") {echo $rowb['flavor_text']; }
else if($_GET['arg'] == "en" and $rowb['flavor_text_k'] == "") { echo $rowb['flavor_text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $rowb['flavor_text_k'] != "") {echo $rowb['flavor_text_k']; }
else {echo $rowb['flavor_text']; }
echo '';
echo '
';
echo '';
if($rowb['power'] != "" and $rowb['toughness'] != "") echo $rowb['power']."/".$rowb['toughness'];
else if($rowb['loyalty'] != "")echo "충성도 : ".$rowb['loyalty'];
echo '
';
echo '';
echo 'Illustrated by '.$row['artist'];
echo '
';
echo '';
//echo $row['legalities'];
echo ''; //{"brawl":"Legal","commander":"Legal","duel":"Legal","future":"Legal","historic":"Legal","legacy":"Legal","modern":"Legal","pioneer":"Legal","standard":"Legal","vintage":"Legal"}
echo '
';
echo '
';
echo ''.$leg['standard'].' | ';
else if($leg['standard'] == "") echo 'Illegal | ';
else echo ''.$leg['standard'].' | ';
echo 'Standard | ';
if($pos % 2 == 0)
{
echo '
'.$leg['pioneer'].' | ';
else if($leg['pioneer'] == "") echo 'Illegal | ';
else echo ''.$leg['pioneer'].' | ';
echo 'Pioneer | ';
if($pos % 2 == 0)
{
echo '
'.$leg['modern'].' | ';
else if($leg['modern'] == "") echo 'Illegal | ';
else echo ''.$leg['modern'].' | ';
echo 'Modern | ';
if($pos % 2 == 0)
{
echo '
'.$leg['legacy'].' | ';
else if($leg['legacy'] == "") echo 'Illegal | ';
else echo ''.$leg['legacy'].' | ';
echo 'Legacy | ';
if($pos % 2 == 0)
{
echo '
'.$leg['vintage'].' | ';
else if($leg['vintage'] == "") echo 'Illegal | ';
else echo ''.$leg['vintage'].' | ';
echo 'Vintage | ';
if($pos % 2 == 0)
{
echo '
'.$leg['commander'].' | ';
else if($leg['commander'] == "") echo 'Illegal | ';
else echo ''.$leg['commander'].' | ';
echo 'Commander | ';
if($pos % 2 == 0)
{
echo '
'.$value.' | ';
else echo ''.$value.' | ';
echo ''.ucfirst($key).' | ';
if($pos % 2 == 0)
{
echo '|
- ";
echo "
- 첫 페이지 "; for($zi=-4;$zi<5;$zi++) { if($page + $zi != $page) { if($page + $zi > 0 and $page + $zi <= $totalpage) echo "
- ".($page+$zi)." "; } else { echo "
- ".($page+$zi)." "; } } echo "
- 끝 페이지 "; echo "
";
echo '
"; // row
*/
echo '
';
echo '
'; // end of searchbox
/*
echo '';
*/
/*
$query = "select * from ob_bcate where proj = 'ob' order by star DESC, id ASC";
$resultb = $dbcs->query($query);
echo '
';
for($i=0;$i<$resultb->num_rows;$i++)
{
$temp = $resultb->fetch_assoc();
// 카테고리의 최신글 가져오기 date(Ymd)
$tof = date('Y').'-'.date('m').'-'.date('d').' 00:00';
$tot = date('Y').'-'.date('m').'-'.date('d').' 23:59';
$query = "select * from ob_bcont where `catid` = ".$temp['id']." and `del` != 'y' and `date` >= '".$tof."' and `date` <= '".$tot."' order by id DESC";
$resultc = $dbcs->query($query);
echo '
"; // row
echo "';
echo '
'; // end of col
}
*/
// 지금 스탠다드에는....
/*
$panel = array('';
echo '
'; // end of card
echo '';
echo ''.replmtg($temp['name']); // 제목
if($resultc->num_rows>0) echo ''.$resultc->num_rows.'';
echo '';
echo '
'; // end of card-content
echo '';
// 최신글 5개까지 표시
$query = "select * from ob_bcont where `catid` = ".$temp['id']." and `del` != 'y' order by id DESC limit 0, 3";
$resultc = $dbcs->query($query);
echo '
'; // end of card-action
echo '';
for($j=0;$j<$resultc->num_rows;$j++)
{
$tempc = $resultc->fetch_assoc();
$query = "select count(id) from ob_breply where cid = ".$tempc['id']." and del != 'y'";
$resultre = $dbcs->query($query);
$tempre = $resultre->fetch_assoc();
echo '* '.$tempc['head'].'';
$profileimageurlthis = getprofileimg($tempc['pid']);
if($profileimageurlthis == "") $profileimageurlthis = "http://mtg-kr.com/favicon.png";
echo ' ('.$tempc['date'].') ['.$tempre['count(id)'].']
'.pid2nickname($tempc['pid']).'';
}
echo '
'; // end of collection
echo 'query($query);
// 왼쪽 전년도 세트, 오른쪽 당년도 세트, release_date 검사 (데탑 기준 2개씩, 모바일은 한개씩)
// 세트이름 한글(영문) - 세트로고 - 발매일
//
$temp = $result->fetch_assoc();
$start = substr($temp['release_date'], 0, 4);
echo "
";
}
echo "";
echo "지금 스탠다드에서는...";
$query = "select * from `ob_extrasetdata` where `set` = 'lastupdate'";
$resd = $dbcs->query($query);
$rest = $resd->fetch_assoc();
echo '
";
// $i=0은 먼저 처리
echo "
";
if($i%4 != 3)
{
//echo "지금 스탠다드에서는...";
$query = "select * from `ob_extrasetdata` where `set` = 'lastupdate'";
$resd = $dbcs->query($query);
$rest = $resd->fetch_assoc();
echo '
('.$rest['release_date'].' 갱신됨)';
echo "
";
// $i=0은 먼저 처리
echo "";
echo "
"; // col-sm-12
}
}
if($i%2 != 1) echo "".substr($temp['release_date'], 0, 4).". 4Q ~ ".(substr($temp['release_date'], 0, 4)+1).". 3Q
";
echo ".
";
//echo "";
echo $panel[0]." style='width:49%;float:left;margin-right:3px;'>";
echo '
"; // panel
for($i=1;$i<$result->num_rows or $i<8;$i++)
{
//4의 배수에서 div 닫고 새로
//2의 배수에서 div 닫고 새로
//mod로 panel div 적용
if($temp = $result->fetch_assoc())
{
if($i%4 ==0)
{
echo "';
echo '';
echo ' '.$temp['setname_k'];
echo '
';
echo '
'; // panel-heading
echo "';
echo ' '.$temp['setname_k'];
echo '
('.$temp['name'].')';
echo '
'.substr($temp['release_date'], 0, 4)."년 ".substr($temp['release_date'], 4, 2)."월 ".substr($temp['release_date'], 6, 2)."일 발매";
echo '
';
echo '";
echo "
"; // panel
}
else {
if($i%4 ==0) echo "".substr($temp['release_date'], 0, 4).". 4Q ~ ".(substr($temp['release_date'], 0, 4)+1).". 3Q
";
echo ".
";
$start = substr($temp['release_date'], 0, 4);
}
echo $panel[$i%4]." style='width:49%;float:left;margin-right:3px;'>";
echo '';
echo '';
echo ' '.$temp['setname_k'];
echo '
';
echo '
'; // panel-heading
echo "';
echo ' '.$temp['setname_k'];
echo '
('.$temp['name'].')';
echo '
'.substr($temp['release_date'], 0, 4)."년 ".substr($temp['release_date'], 4, 2)."월 ".substr($temp['release_date'], 6, 2)."일 발매";
echo '
';
echo ''; echo '
";
//if($i%2 ==0) echo "
"; // col-sm-6
if($i%4 ==3)
{
$priceng = $dbcs->query("select date from ob_ckadddb order by `date` DESC limit 0, 1");
$temp = $priceng->fetch_assoc();
echo '";
echo $panel[$i%4]." style='width:49%;float:left;margin-right:3px;'>";
echo '
"; // panel
}
//if($i%2 ==1) echo "';
echo '';
echo ' 제품명 미정
';
echo '
'; // panel-heading
echo "';
echo ' 제품명 미정
';
echo $year.'년 '.($i-4).'번째 확장팩 발매 예정
.';
echo '
';
echo '.
';
echo "".($start+2)."년 3분기까지 사용가능
";
echo "".($start+2)."년 3분기까지 유효
";
echo "";
echo "
"; // cardcontainer2
}// end of meld
} // end of if 자료 갯수 1개
else if($result->num_rows > 1) // 양면, 스플릿, 어드벤처
{
// 자료를 a, b 별도로 받고 구성합니다.
// $row에 뒷면인지 앞면인지 옆면인지 모를 카드 이름을 받았습니다.
// 메인 쿼리 자체는 a를 가리켜야 하고, 서브 쿼리가 b를 가리켜야 합니다.
// 카드 이미지는 layout 값에 따라 다른 방식으로 보여줍니다.
// layout - adventure, aftermath, flip, meld, normal, split, transform
$row = $result->fetch_assoc(); // 일단 한개 빼고
$rowb = array();
if($row['layout'] == 'adventure' or $row['layout'] == 'aftermath' or $row['layout'] == 'flip' or $row['layout'] == 'split' or $row['layout'] == 'transform' or $row['layout'] == 'modal_dfc')
{
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`code` = '".$_GET['set']."' and xe_mtga_cards.`number` = '".$_GET['code']."' and xe_mtga_cards.`side` = 'a' order by xe_mtga_cards.`type_k` DESC";
$result = $dbcs->query($query);
$row = $result->fetch_assoc();
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`code` = '".$_GET['set']."' and xe_mtga_cards.`number` = '".$_GET['code']."' and xe_mtga_cards.`side` = 'b' order by xe_mtga_cards.`type_k` DESC";
$result = $dbcs->query($query);
$rowb = $result->fetch_assoc();
}
//print_r($query);
echo "";
echo "
"; // cardcontainer
echo "";
echo '
"; // cardgrid
echo "'; // 사이즈 이펙트 처리 다르게
if($_GET['arg'] == "ko" and $row['name_k'] != "") echo '';
else if($_GET['arg'] == "ko" and $row['name_k'] == "") echo '';
else if($_GET['arg'] == "en") echo '';
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['name_k'] != "") echo '';
else echo '';
echo "
";
echo "";
echo ''; // 가격 관련
echo '
'; // end of cardinfoetc
echo ''; //세트로고, 세트명(약어), #카드번호, 희귀도
echo '
'; // end of cardmoreinfo
echo ''.$row["setname"].'
#'.$row['number'].' - '; switch($row['rarity']) { case "mythic" : echo 'Mythic Rare'; break; case "rare" : echo 'Rare'; break; case "uncommon" : echo 'Uncommon'; break; case "common" : echo 'Common'; break; default : } echo '
';
echo '#'.$row['number'].' - '; switch($row['rarity']) { case "mythic" : echo 'Mythic Rare'; break; case "rare" : echo 'Rare'; break; case "uncommon" : echo 'Uncommon'; break; case "common" : echo 'Common'; break; default : } echo '
';
echo '
';
echo '
'; // end of cardprice
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`name` = '".addslashes($row['name'])."' order by xe_mtga_card_sets.release_date DESC";
$resultx = $dbcs->query($query);
echo '| 분류 | NM | EX | VG | G |
| 일반 | '; for($i=0;$i < count($ckn);$i++) { if($ckn[$i]->ava == "OoS") echo ''.$ckn[$i]->price.' | '; else echo ''.$ckn[$i]->price.' | '; } } echo "||
| 포일 | '; for($i=0;$i < count($ckn);$i++) { if($ckn[$i]->ava == "OoS") echo ''.$ckn[$i]->price.' | '; else echo ''.$ckn[$i]->price.' | '; } } echo "
';
echo '';
if($resultx->num_rows < 6)
{
for($i=0;$i<$resultx->num_rows;$i++)
{
$rowset = $resultx->fetch_assoc();
//$ckn = ckprice($dbcs, $rowset['code'], $rowset['number'], 'normal');
echo '
';
echo '
'; // end of cardsets
echo '| ';
echo '';
if($rowset['name'] != "Plains" and $rowset['name'] != "Island" and $rowset['name'] != "Swamp" and $rowset['name'] != "Mountain" and $rowset['name'] != "Forest")
{
echo ' (등록수 : ';
$query = "select count(*) as count from ob_pddb where `set` = '".$rowset['code']."' and `code` = '".$rowset['number']."'";
$resultcount = $dbcs->query($query);
$rowcount = $resultcount->fetch_assoc();
echo $rowcount['count'];
echo ') ';
}
echo ''.$rowset['code'].'-'.$rowset['number'].' ';
echo ' |
| ';
echo '';
//if($rowset['name'] != "Plains" and $rowset['name'] != "Island" and $rowset['name'] != "Swamp" and $rowset['name'] != "Mountain" and $rowset['name'] != "Forest")
{
echo ' (등록수 : ';
$query = "select count(*) as count from ob_pddb where `set` = '".$rowset['code']."' and `code` = '".$rowset['number']."'";
$resultcount = $dbcs->query($query);
$rowcount = $resultcount->fetch_assoc();
echo $rowcount['count'];
echo ') ';
}
echo ''.$rowset['code'].'-'.$rowset['number'].' ';
echo ' |
| '; if($resultx->num_rows > 6) echo ''; echo ' |
| '; echo ''; // end of othersets echo ' |
';
echo '
'; // end of cardsellerinfo
echo ''; // 샵 수와 샵들 가격 나열
echo '
'; // end of cardshop
/*
echo '제품 취급 온라인샵
'; echo '';
// d 등급 이상의 관리자만 띄우기
$query = "select * from ob_pddb inner join ob_userdb on ob_pddb.`pid` = ob_userdb.`poid` and ob_pddb.`set` = '".$_GET['set']."' and ob_pddb.`code` = '".$_GET['code']."' and ob_userdb.`service` > 'd' and ob_pddb.`del` = 'n' order by ob_pddb.`lastdate`";
$resultus = $dbcs->query($query);
if($resultus->num_rows == 0)
{
echo '';
for($i=0;$i<$resultus->num_rows;$i++)
{
$temp = $resultus->fetch_assoc();
if($temp['count'] != 0)
{
echo '
';
echo '
'; // end of list
echo '';
echo '
';
}
echo '- 취급 온라인샵이 없습니다. -
'; echo '| '; echo ''.pid2nickname($temp['pid']).""; echo ' | '; echo ''.lang2flag($temp['language']).stat2icon($temp['stat']);
if($temp['type'] == 'foil') echo "";
echo ' | ';
echo '';
echo price2html($dbcs, $temp['ck'], $temp['type'],$temp['stat'],$temp['price'])."원 (보유 ".$temp['count']."장) "; if($_COOKIE['ob_id'] != $temp['pid'] and $temp['count'] != 0) { switch($temp['pid']) { case '1441741308' : echo '홈페이지에서 구매'; break; default : echo '장바구니 장 '; break; } //echo '장바구니 장 '; } echo ' | ';
echo '
'; //
echo '
';
*/
echo '오픈 바인더 유저 보유 내역 열기/닫기
'; echo ''; echo '';
echo '
'; // end of carddatainfo
echo "';
if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['name_k']; echo " ".mtgsymbols($row['mana_cost']); echo " English";}
else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['name']; echo " ".mtgsymbols($row['mana_cost']);}
else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['name']; echo " ".mtgsymbols($row['mana_cost']); echo " 한국어판";}
else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['name']; echo " ".mtgsymbols($row['mana_cost']);}
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['name_k']; echo " ".mtgsymbols($row['mana_cost']); echo " English";}
else {echo $row['name']; echo " ".mtgsymbols($row['mana_cost']); }
echo '
';
echo '';
if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['type_k']; }
else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['type']; }
else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['type']; }
else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['type']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['type_k'];}
else {echo $row['type'];}
echo '
';
echo '';
$row['text_k'] = mtgsymbols(nl2br($row['text_k']));
$row['text'] = mtgsymbols(nl2br($row['text']));
if($_GET['arg'] == "ko" and $row['text_k'] != "") { echo $row['text_k'];}
else if($_GET['arg'] == "ko" and $row['text_k'] == "") { echo $row['text']; }
else if($_GET['arg'] == "en" and $row['text_k'] != "") {echo $row['text']; }
else if($_GET['arg'] == "en" and $row['text_k'] == "") { echo $row['text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['text_k'] != "") {echo $row['text_k']; }
else {echo $row['text']; }
echo '
';
echo '';
echo '';
$row['flavor_text_k'] = nl2br($row['flavor_text_k']);
$row['flavor_text'] = nl2br($row['flavor_text']);
if($_GET['arg'] == "ko" and $row['flavor_text_k'] != "") { echo $row['flavor_text_k'];}
else if($_GET['arg'] == "ko" and $row['flavor_text_k'] == "") { echo $row['flavor_text']; }
else if($_GET['arg'] == "en" and $row['flavor_text_k'] != "") {echo $row['flavor_text']; }
else if($_GET['arg'] == "en" and $row['flavor_text_k'] == "") { echo $row['flavor_text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['flavor_text_k'] != "") {echo $row['flavor_text_k']; }
else {echo $row['flavor_text']; }
echo '';
echo '
';
echo '';
if($row['power'] != "" and $row['toughness'] != "") echo $row['power']."/".$row['toughness'];
else if($row['loyalty'] != "")echo "충성도 : ".$row['loyalty'];
echo '
';
echo '';
echo 'Illustrated by '.$row['artist'];
echo '
';
echo '';
//echo $row['legalities'];
echo ''; //{"brawl":"Legal","commander":"Legal","duel":"Legal","future":"Legal","historic":"Legal","legacy":"Legal","modern":"Legal","pioneer":"Legal","standard":"Legal","vintage":"Legal"}
echo '
';
echo '
';
echo ''.$leg['standard'].' | ';
else if($leg['standard'] == "") echo 'Illegal | ';
else echo ''.$leg['standard'].' | ';
echo 'Standard | ';
if($pos % 2 == 0)
{
echo '
'.$leg['pioneer'].' | ';
else if($leg['pioneer'] == "") echo 'Illegal | ';
else echo ''.$leg['pioneer'].' | ';
echo 'Pioneer | ';
if($pos % 2 == 0)
{
echo '
'.$leg['modern'].' | ';
else if($leg['modern'] == "") echo 'Illegal | ';
else echo ''.$leg['modern'].' | ';
echo 'Modern | ';
if($pos % 2 == 0)
{
echo '
'.$leg['legacy'].' | ';
else if($leg['legacy'] == "") echo 'Illegal | ';
else echo ''.$leg['legacy'].' | ';
echo 'Legacy | ';
if($pos % 2 == 0)
{
echo '
'.$leg['vintage'].' | ';
else if($leg['vintage'] == "") echo 'Illegal | ';
else echo ''.$leg['vintage'].' | ';
echo 'Vintage | ';
if($pos % 2 == 0)
{
echo '
'.$leg['commander'].' | ';
else if($leg['commander'] == "") echo 'Illegal | ';
else echo ''.$leg['commander'].' | ';
echo 'Commander | ';
if($pos % 2 == 0)
{
echo '
'.$value.' | ';
else echo ''.$value.' | ';
echo ''.ucfirst($key).' | ';
if($pos % 2 == 0)
{
echo '|
"; // 룰링 출력
echo "
";
echo ""; // 룰링 출력
echo "개더러 규칙 부연 설명 (영어만 지원됩니다.)";
echo '열기/닫기';
echo "
";
echo "';
}
echo "";
echo "
";
echo "
"; // cardgrid
} // end of if 자료 갯수 2개
else {
// 휴스턴 문제가 발생했다.
echo "";
echo '
"; // cardcontainer
echo "'; // 사이즈 이펙트 처리 다르게
if($_GET['arg'] == "ko" and $row['name_k'] != "") echo '';
else if($_GET['arg'] == "ko" and $row['name_k'] == "") echo '';
else if($_GET['arg'] == "en") echo '';
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['name_k'] != "") echo '';
else echo '';
if($row['layout'] == 'transform' or $row['layout'] == 'modal_dfc')
{
echo '';
}
echo "
"; // end of cardboxinfo
echo "";
echo ''; // 가격 관련
echo '
'; // end of cardinfoetc
echo ''; //세트로고, 세트명(약어), #카드번호, 희귀도
echo '
'; // end of cardmoreinfo
echo ''.$row["setname"].'
#'.$row['number'].' - '; switch($row['rarity']) { case "mythic" : echo 'Mythic Rare'; break; case "rare" : echo 'Rare'; break; case "uncommon" : echo 'Uncommon'; break; case "common" : echo 'Common'; break; default : } echo '
';
echo '#'.$row['number'].' - '; switch($row['rarity']) { case "mythic" : echo 'Mythic Rare'; break; case "rare" : echo 'Rare'; break; case "uncommon" : echo 'Uncommon'; break; case "common" : echo 'Common'; break; default : } echo '
';
echo '
';
echo '
'; // end of cardprice
$query = "select *, xe_mtga_cards.name as name, xe_mtga_cards.code as code, xe_mtga_cards.type as type, xe_mtga_card_sets.name as setname, xe_mtga_card_sets.code as setcode, xe_mtga_card_sets.type as settype from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and xe_mtga_cards.`name` = '".addslashes($row['name'])."' order by xe_mtga_card_sets.release_date DESC";
$resultx = $dbcs->query($query);
echo '| 분류 | NM | EX | VG | G |
| 일반 | '; for($i=0;$i < count($ckn);$i++) { if($ckn[$i]->ava == "OoS") echo ''.$ckn[$i]->price.' | '; else echo ''.$ckn[$i]->price.' | '; } } echo "||
| 포일 | '; for($i=0;$i < count($ckn);$i++) { if($ckn[$i]->ava == "OoS") echo ''.$ckn[$i]->price.' | '; else echo ''.$ckn[$i]->price.' | '; } } echo "
';
echo '';
if($resultx->num_rows < 6)
{
for($i=0;$i<$resultx->num_rows;$i++)
{
$rowset = $resultx->fetch_assoc();
//$ckn = ckprice($dbcs, $rowset['code'], $rowset['number'], 'normal');
echo '
';
echo '
'; // end of cardsets
echo '| ';
echo '';
if($rowset['name'] != "Plains" and $rowset['name'] != "Island" and $rowset['name'] != "Swamp" and $rowset['name'] != "Mountain" and $rowset['name'] != "Forest")
{
echo ' (등록수 : ';
$query = "select count(*) as count from ob_pddb where `set` = '".$rowset['code']."' and `code` = '".$rowset['number']."'";
$resultcount = $dbcs->query($query);
$rowcount = $resultcount->fetch_assoc();
echo $rowcount['count'];
echo ') ';
}
echo ''.$rowset['code'].'-'.$rowset['number'].' ';
echo ' |
| ';
echo '';
if($rowset['name'] != "Plains" and $rowset['name'] != "Island" and $rowset['name'] != "Swamp" and $rowset['name'] != "Mountain" and $rowset['name'] != "Forest")
{
echo ' (등록수 : ';
$query = "select count(*) as count from ob_pddb where `set` = '".$rowset['code']."' and `code` = '".$rowset['number']."'";
$resultcount = $dbcs->query($query);
$rowcount = $resultcount->fetch_assoc();
echo $rowcount['count'];
echo ') ';
}
echo ''.$rowset['code'].'-'.$rowset['number'].' ';
echo ' |
| '; if($resultx->num_rows > 6) echo ''; echo ' |
| '; echo ''; // end of othersets echo ' |
';
echo '
'; // end of cardsellerinfo
echo ''; // 샵 수와 샵들 가격 나열
echo '
'; // end of cardshop
/*
echo '제품 취급 온라인샵
'; echo '';
// d 등급 이상의 관리자만 띄우기
$query = "select * from ob_pddb inner join ob_userdb on ob_pddb.`pid` = ob_userdb.`poid` and ob_pddb.`set` = '".$_GET['set']."' and ob_pddb.`code` = '".$_GET['code']."' and ob_userdb.`service` > 'd' and ob_pddb.`del` = 'n' order by ob_pddb.`lastdate`";
$resultus = $dbcs->query($query);
if($resultus->num_rows == 0)
{
echo '';
for($i=0;$i<$resultus->num_rows;$i++)
{
$temp = $resultus->fetch_assoc();
if($temp['count'] != 0)
{
echo '
';
echo '
'; // end of list
echo '';
echo '
';
}
echo '- 취급 온라인샵이 없습니다. -
'; echo '| '; echo ''.pid2nickname($temp['pid']).""; echo ' | '; echo ''.lang2flag($temp['language']).stat2icon($temp['stat']);
if($temp['type'] == 'foil') echo "";
echo ' | ';
echo '';
echo price2html($dbcs,$temp['ck'], $temp['type'],$temp['stat'],$temp['price'])."원 (보유 ".$temp['count']."장) "; if($_COOKIE['ob_id'] != $temp['pid']) { switch($temp['pid']) { case '1441741308' : echo '홈페이지에서 구매'; break; default : echo '장바구니 장 '; break; } //echo '장바구니 장 '; } echo ' | ';
echo '
'; //
echo '
';
*/
echo '오픈 바인더 유저 보유 내역 열기/닫기
'; echo ''; echo '';
echo '
'; // end of carddatainfo
echo "';
if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['name_k'].' // '.$rowb['name_k']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " English";} else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']);} else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " 한국어판";} else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']);} else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['name_k'].' // '.$rowb['name_k']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " English";} else {echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); } echo '
';
echo '".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " English";} else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']);} else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " 한국어판";} else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']);} else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['name_k'].' // '.$rowb['name_k']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); echo " English";} else {echo $row['name'].' // '.$rowb['name']; echo "
".mtgsymbols($row['mana_cost'])." // ".mtgsymbols($rowb['mana_cost']); } echo '
전면 :
'; if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['type_k']; } else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['type']; } else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['type']; } else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['type']; } else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['type_k'];} else {echo $row['type'];} echo '
';
echo ''; if($_GET['arg'] == "ko" and $row['type_k'] != "") { echo $row['type_k']; } else if($_GET['arg'] == "ko" and $row['type_k'] == "") { echo $row['type']; } else if($_GET['arg'] == "en" and $row['type_k'] != "") {echo $row['type']; } else if($_GET['arg'] == "en" and $row['type_k'] == "") { echo $row['type']; } else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['type_k'] != "") {echo $row['type_k'];} else {echo $row['type'];} echo '
';
$row['text_k'] = mtgsymbols(nl2br($row['text_k']));
$row['text'] = mtgsymbols(nl2br($row['text']));
if($_GET['arg'] == "ko" and $row['text_k'] != "") { echo $row['text_k'];}
else if($_GET['arg'] == "ko" and $row['text_k'] == "") { echo $row['text']; }
else if($_GET['arg'] == "en" and $row['text_k'] != "") {echo $row['text']; }
else if($_GET['arg'] == "en" and $row['text_k'] == "") { echo $row['text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['text_k'] != "") {echo $row['text_k']; }
else {echo $row['text']; }
echo '
';
echo '';
echo '';
$row['flavor_text_k'] = nl2br($row['flavor_text_k']);
$row['flavor_text'] = nl2br($row['flavor_text']);
if($_GET['arg'] == "ko" and $row['flavor_text_k'] != "") { echo $row['flavor_text_k'];}
else if($_GET['arg'] == "ko" and $row['flavor_text_k'] == "") { echo $row['flavor_text']; }
else if($_GET['arg'] == "en" and $row['flavor_text_k'] != "") {echo $row['flavor_text']; }
else if($_GET['arg'] == "en" and $row['flavor_text_k'] == "") { echo $row['flavor_text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $row['flavor_text_k'] != "") {echo $row['flavor_text_k']; }
else {echo $row['flavor_text']; }
echo '';
echo '
';
echo '';
if($row['power'] != "" and $row['toughness'] != "") echo $row['power']."/".$row['toughness'];
else if($row['loyalty'] != "")echo "충성도 : ".$row['loyalty'];
echo '
';
echo '후면 :
'; if($_GET['arg'] == "ko" and $rowb['type_k'] != "") { echo $rowb['type_k']; } else if($_GET['arg'] == "ko" and $rowb['type_k'] == "") { echo $rowb['type']; } else if($_GET['arg'] == "en" and $rowb['type_k'] != "") {echo $rowb['type']; } else if($_GET['arg'] == "en" and $rowb['type_k'] == "") { echo $rowb['type']; } else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $rowb['type_k'] != "") {echo $rowb['type_k'];} else {echo $rowb['type'];} echo '
';
echo ''; if($_GET['arg'] == "ko" and $rowb['type_k'] != "") { echo $rowb['type_k']; } else if($_GET['arg'] == "ko" and $rowb['type_k'] == "") { echo $rowb['type']; } else if($_GET['arg'] == "en" and $rowb['type_k'] != "") {echo $rowb['type']; } else if($_GET['arg'] == "en" and $rowb['type_k'] == "") { echo $rowb['type']; } else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $rowb['type_k'] != "") {echo $rowb['type_k'];} else {echo $rowb['type'];} echo '
';
$rowb['text_k'] = mtgsymbols(nl2br($rowb['text_k']));
$rowb['text'] = mtgsymbols(nl2br($rowb['text']));
if($_GET['arg'] == "ko" and $rowb['text_k'] != "") { echo $rowb['text_k'];}
else if($_GET['arg'] == "ko" and $rowb['text_k'] == "") { echo $rowb['text']; }
else if($_GET['arg'] == "en" and $rowb['text_k'] != "") {echo $rowb['text']; }
else if($_GET['arg'] == "en" and $rowb['text_k'] == "") { echo $rowb['text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $rowb['text_k'] != "") {echo $rowb['text_k']; }
else {echo $rowb['text']; }
echo '
';
echo '';
echo '';
$rowb['flavor_text_k'] = nl2br($rowb['flavor_text_k']);
$rowb['flavor_text'] = nl2br($rowb['flavor_text']);
if($_GET['arg'] == "ko" and $rowb['flavor_text_k'] != "") { echo $rowb['flavor_text_k'];}
else if($_GET['arg'] == "ko" and $rowb['flavor_text_k'] == "") { echo $rowb['flavor_text']; }
else if($_GET['arg'] == "en" and $rowb['flavor_text_k'] != "") {echo $rowb['flavor_text']; }
else if($_GET['arg'] == "en" and $rowb['flavor_text_k'] == "") { echo $rowb['flavor_text']; }
else if($_GET['arg'] != "ko" and $_GET['arg'] != "en" and $rowb['flavor_text_k'] != "") {echo $rowb['flavor_text_k']; }
else {echo $rowb['flavor_text']; }
echo '';
echo '
';
echo '';
if($rowb['power'] != "" and $rowb['toughness'] != "") echo $rowb['power']."/".$rowb['toughness'];
else if($rowb['loyalty'] != "")echo "충성도 : ".$rowb['loyalty'];
echo '
';
echo '';
echo 'Illustrated by '.$row['artist'];
echo '
';
echo '';
//echo $row['legalities'];
echo ''; //{"brawl":"Legal","commander":"Legal","duel":"Legal","future":"Legal","historic":"Legal","legacy":"Legal","modern":"Legal","pioneer":"Legal","standard":"Legal","vintage":"Legal"}
echo '
';
echo '
';
echo ''.$leg['standard'].' | ';
else if($leg['standard'] == "") echo 'Illegal | ';
else echo ''.$leg['standard'].' | ';
echo 'Standard | ';
if($pos % 2 == 0)
{
echo '
'.$leg['pioneer'].' | ';
else if($leg['pioneer'] == "") echo 'Illegal | ';
else echo ''.$leg['pioneer'].' | ';
echo 'Pioneer | ';
if($pos % 2 == 0)
{
echo '
'.$leg['modern'].' | ';
else if($leg['modern'] == "") echo 'Illegal | ';
else echo ''.$leg['modern'].' | ';
echo 'Modern | ';
if($pos % 2 == 0)
{
echo '
'.$leg['legacy'].' | ';
else if($leg['legacy'] == "") echo 'Illegal | ';
else echo ''.$leg['legacy'].' | ';
echo 'Legacy | ';
if($pos % 2 == 0)
{
echo '
'.$leg['vintage'].' | ';
else if($leg['vintage'] == "") echo 'Illegal | ';
else echo ''.$leg['vintage'].' | ';
echo 'Vintage | ';
if($pos % 2 == 0)
{
echo '
'.$leg['commander'].' | ';
else if($leg['commander'] == "") echo 'Illegal | ';
else echo ''.$leg['commander'].' | ';
echo 'Commander | ';
if($pos % 2 == 0)
{
echo '
'.$value.' | ';
else echo ''.$value.' | ';
echo ''.ucfirst($key).' | ';
if($pos % 2 == 0)
{
echo '|
";
// 무엇인가 잘못된 것 같습니다. 메인으로 돌아가서 다시 시도해주세요.
echo '
';
echo '
';
}
// 공통 페이지 - 룰 텍스트 등
}
else if($_GET['search'] != "")
{
// 카드 이미지 나열
if(strlen($_GET['search']) < 3)
{
echo "";
exit();
}
$inname = addslashes(mysql_real_escape_string($inname));
//한글이든 영어든 정확한 이름이 있으면 던진다.
$query = "select * from xe_mtga_cards where fullname = '".$inname."' or fullname_k = '".$inname."' and is_online_only != 'Y' order by multiverse_id DESC";
//$query = "select * from xe_mtga_cards where name = '".$inname."' or name_k = '".$inname."' and (side is null or side = 'a' or (`layout` = 'meld' and `side` = 'b')) and is_online_only != 'Y' order by multiverse_id DESC";
$resultkname = $dbcs->query($query);
$rowtruename = $resultkname->fetch_assoc();
//if($resultkname->num_rows == 1) $inname = addslashes($rowtruename['name']);
// 검색해야할 검색어를 확보했으면, 이번엔 이름 중 탑 목록만 확보
//$query = "select * from (select * from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code`) as a group by a.name where (name like '%".$inname."%' or name_k like '%".$inname."%') and is_online_only != 'Y' order by multiverse_id DESC" ;
//$query = "select * from (select xe_mtga_cards.name, xe_mtga_cards.code, xe_mtga_cards.number from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and (xe_mtga_cards.name like '%".$inname."%' or xe_mtga_cards.name_k like '%".$inname."%') and xe_mtga_cards.is_online_only != 'Y') as a group by name";
$query = "select * from (select * from xe_mtga_cards where (fullname like '%".$inname."%' or fullname_k like '%".$inname."%') and is_online_only != 'Y' and (side is null or side = 'a' or (layout = 'meld' and side = 'b')) order by xe_mtga_cards.`lang` DESC ) as a group by a.fullname ";
//select * from (select * from xe_mtga_cards inner join xe_mtga_card_sets on xe_mtga_cards.`code` = xe_mtga_card_sets.`code` and (xe_mtga_cards.name like '%llanowar%' or xe_mtga_cards.name_k like '%llanowar%') and xe_mtga_cards.is_online_only != 'Y' order by field(xe_mtga_card_sets.type, 'expansion', 'core', 'masters')) as a group by a.name
//$query = "select * from (select * from xe_mtga_cards where (name like '%".$inname."%' or name_k like '%".$inname."%') and (side is null or side = 'a' or (`layout` = 'meld' and `side` = 'b')) and is_online_only != 'Y' order by multiverse_id DESC) as a group by a.name";
$resultk = $dbcs->query($query);
if($_GET['page'] == '') $page = 1;
else $page = $_GET['page'];
// 카드 리스팅하고 클릭 하게 셋업
//echo $resultk->num_rows;
if($resultk->num_rows == 1)
{
$query = "select * from xe_mtga_cards where (fullname like '%".$inname."%' or fullname_k like '%".$inname."%') and is_online_only != 'Y' and (side is null or side = 'a' or (layout = 'meld' and side = 'b')) order by xe_mtga_cards.`lang` DESC";
$resultk = $dbcs->query($query);
$rowcid = $resultk->fetch_assoc();
/*
$query = "select * from xe_mtga_cards inner join ob_pddb on xe_mtga_cards.code = ob_pddb.set and xe_mtga_cards.number = ob_pddb.code and xe_mtga_cards.name = '".$rowcid['name']."' and ob_pddb.pid = '1216027144'";
$resultx = $dbcs->query($query);
$rowx = $resultx->fetch_assoc();
*/
//if($resultx->num_rows == 0)
//{
echo "";
/*}
else
{
echo "";
}
*/
exit();
}
else if($resultk->num_rows > 1)
{
$ln = 12;
$totalpage = ceil($resultk->num_rows / $ln);
$totalcards = $resultk->num_rows;
$query = $query." LIMIT ".(($page-1) * $ln).", ".$ln;
$resultk = $dbcs->query($query);
echo "무엇인가 잘못된 것 같습니다. 메인으로 돌아가서 다시 시도해주세요.
'; echo ''; echo '";
echo '
';
echo '
';
echo "검색어 "'.$_GET['search'].'"에 대한 검색 결과는 '.$totalcards.' 종 입니다.
(전체 '.$totalpage.'페이지 중 '.$page.'페이지)
'; echo '";
echo "
";
// 나온 이름들을 다 붙여서 최신 Expansion, Core 정렬하고
for($i=0;$i<$resultk->num_rows;$i++)
{
$rowcid = $resultk->fetch_assoc();
/*
$stime = get_mtime();
$query = "select xe_mtga_cards.code as `set`, xe_mtga_cards.number as number, xe_mtga_cards.name as name, xe_mtga_cards.name_k as name_k from xe_mtga_cards inner join ob_pddb on xe_mtga_cards.code = ob_pddb.set and xe_mtga_cards.number = ob_pddb.code and xe_mtga_cards.name = '".addslashes($rowcid['name'])."' and ob_pddb.pid = '1216027144'";
$resultx = $dbcs->query($query);
$rowx = $resultx->fetch_assoc();
echo $i."번카드 사용시간 : ".(get_mtime() - $stime)."
"; */ if($resultx->num_rows != 0) { echo '';
echo '
"; // end of cardcontainer
echo ''; // end of page bar
}
else if($_GET['mode'] == 'board')
{
echo ""; */ if($resultx->num_rows != 0) { echo '
';
echo "";
if($rowx['name_k'] != "")
{
echo ';
}
else
{
echo '<img class = )
';
echo "
";
}
else
{
echo '';
echo "";
if($rowcid['name_k'] != "")
{
echo ';
}
else
{
echo '<img class = )
';
echo "
";
}
}
}
else {
// 결과값이 없음
echo '';
echo '";
echo '
'; // 헤더 끝
echo "";
echo '
'; // end of cardgrid
echo "';
echo '
";
//echo addslashes($inname)." ".strlen($inname)." ".$query;
}
echo '검색결과가 없습니다.
'; echo ''; echo "";
if($_GET['catid'] == "")
{
switch($_GET['id'])
{
case 'cate' :
// 오픈바인더 proj의 카테고리를 출력 및 나열
$query = "select * from ob_bcate where proj = 'ob' order by star DESC, id ASC";
$resultb = $dbcs->query($query);
for($i=0;$i<$resultb->num_rows;$i++)
{
$temp = $resultb->fetch_assoc();
// 카테고리의 최신글 가져오기 date(Ymd)
$tof = date('Y').'-'.date('m').'-'.date('d').' 00:00';
$tot = date('Y').'-'.date('m').'-'.date('d').' 23:59';
$query = "select * from ob_bcont where `catid` = ".$temp['id']." and `del` != 'y' and `date` >= '".$tof."' and `date` <= '".$tot."'";
$resultc = $dbcs->query($query);
echo '
';
echo '
'; // end of row
}
break;
case 'edit' :
// 글 수정하기
// 로그인 정보 확인 pid 비어 있으면 로그인 유도
// catid, cid, pid 검사
echo $_GET['catid']."의 ".$_GET['cid'];
break;
default :
// 페이지 구성
if($_GET['page'] != '') $page = $_GET['page'];
else $page = 1;
// id가 숫자이고, 숫자 카테고리의 글 리스팅
$query = "select * from ob_bcate where id = ".$_GET['id'];
$resultb = $dbcs->query($query);
$cat = $resultb->fetch_assoc();
$query = "select id, type, catid, head, pid, date from ob_bcont where catid = ".$_GET['id']." and del != 'y' order by type DESC, id DESC";
$resultt = $dbcs->query($query);
$totalpage = ceil($resultt->num_rows) / 20;
$query = "select id, type, catid, head, pid, date from ob_bcont where catid = ".$_GET['id']." and del != 'y' order by type DESC, id DESC Limit ".(($page-1)*20).", 20";
$resultt = $dbcs->query($query);
if($resultt->num_rows == 0)
{
// 글이 없습니다.
echo '';
echo '
'; // end of col
echo '';
echo '
'; // end of card
echo '';
echo ''.replmtg($temp['name']); // 제목
if($resultc->num_rows>0) echo ''.$resultc->num_rows.'';
echo '';
echo replmtg($temp['detail']);
echo '
'; // end of card-content
echo '';
// echo '';
echo '
'; // end of card-action
echo '게시판에 글이 없습니다.
'; echo ''; echo ''; } else { echo '';
echo '
';
echo '
';
echo '
';
echo ''.$cat['name'].''; // 제목
echo '
'; // end of card-content
echo '';
for($i=0;$i<$resultt->num_rows;$i++)
{
$temp = $resultt->fetch_assoc();
//print_r($temp);
echo ''; // div 쓰고 비율로 쪼개자.
if($temp['type'] == 1) echo "
| priority_high | "; else echo "
| ".$temp['id']." | "; echo '('.$temp['date'].') [댓글 : '.$tempre['count(id)'].'] |