" width="">
$tntcmnft="tntcmnftisok";
include "../main/tntcmmn.html";?>
|
" width=""> |
" width=""> |
" class="lfttlsj">Home ");
echo("$ctgymenu_txt");?>
//start of image board basic
//dbquery factors
if($ctgL=="sE2Rwsfdr4"){ //sales **
$ctgymenu_txt="Sale";
$tblname=$abj_discount_items; //table name *****
}else if($ctgL=="JrtRw3qTdp7s"){ //seasonal **
$tblname=$abj_special_items; //table name *****
}
$bdbkimg_path="$img_path/img/main"; // board background image path *****
$hor_nb=4; //horigental number-image
if($view=="all"){
$ver_line_nb=4000; //vertical line number
}else{
$ver_line_nb=5; //vertical line number
}
$hor_nb1=$hor_nb-1;
$limit=$hor_nb*$ver_line_nb;
$limit_p=$hor_nb*5;
$gallery_img_path=$img_path.'/abat/itmimg/';
//order by *****
if($mbprcshw_yn=="C_BY" || $mbprcshw_yn=="C_BN" || $mbprcshw_yn == 'G'){
if(!$oDr || $oDr=="latest"){
$odrcri="order by id"; //order factor *****
$odrpro="desc"; //desc or asc *****
}else if($oDr=="oldest"){
$odrcri="order by id"; //order factor *****
$odrpro="asc"; //desc or asc *****
}else if($oDr=="id"){
$odrcri="order by prdt_id"; //order factor *****
$odrpro="desc"; //desc or asc *****
}else{
$odrcri="order by id"; //order factor *****
$odrpro="desc"; //desc or asc *****
}
}else{
$odrcri="order by id"; //order factor *****
$odrpro="desc"; //desc or asc *****
}
// basic query by page $ctgL_str & $ctgS_str *****
if($ctgL=="sE2Rwsfdr4"){ //sales **
$findwhr='where prdt_sales_yn=\'Y\''; //add where clause db query *****
}else if($ctgL=="JrtRw3qTdp7s"){ //seasonal **
$findwhr='where prdt_sales_yn=\'Y\' and spectgr_id='.$iDr.' and ctgr_1st=\''.$special_category1.'\' and ctgr_2nd=\''.$special_category2.'\''; //add where clause db query *****
}
//page manager ******
$ctgL_en=urlencode($ctgL);
$pgRmN='?ctgL='.$ctgL_en; //any page 1st factor
$addfactor='&oDr='.$oDr.'&iDr='.$iDr; //add more
$adOdrftr='';
//page detect
$psver=$_GET['psver'];
$pgn=$_GET['pgn'];
if(!$psver){
$psver=0;
}else{
$psver=$psver+0;
}
if(!$pgn){
$pgn=1;
}else{
//$pgn=$pgn+0;
$pgn=$pgn+0;
}
//156.. select * from abj_special_items where prdt_sales_yn='Y' and spectgr_id=7 and ctgr_1st='Seasonal Goods' and ctgr_2nd='Hot Items!' order by
//032814_b4_Modifying_HotItems.html
//$sql= "select * from $tblname $findwhr $odrcri $odrpro" ;
$sql= "select * from $tblname where prdt_sales_yn='Y' order by id desc" ; //_032814_HotItems.html
$boardqry_num=mysql_query($sql);
//echo "156.. $sql " ;
//admin.1513..select * from abj_special_items where prdt_sales_yn='Y' order by id desc
$board_numrows=mysql_num_rows($boardqry_num);
if(!$board_numrows){
}else{
if($psver || $pgn){
if($psver==0 || $psver%$limit==0){
if($psver >= $board_numrows || !is_int($psver)){
ob_end_clean(); // delete buffering
echo("");
exit;
}else{}
}else{
ob_end_clean(); // delete buffering
echo("");
exit;
}
$pgn_limitno=ceil($board_numrows/(10*$limit));
if($pgn >= 1 && $pgn <= $pgn_limitno){
if(!is_int($pgn)){
ob_end_clean(); // delete buffering
echo("");
exit;
}else{
}
}else{
ob_end_clean(); // delete buffering
echo("");
exit;
}
$psverchk=$psver/$limit;
if($psverchk >= ($pgn*10-10) && $psverchk < $pgn*10){
}else{
ob_end_clean(); // delete buffering
echo("");
exit;
}
}
}
$total_page_num=$board_numrows/$limit;
$total_page=ceil($total_page_num);
$aNo=$board_numrows-$psver;
//$boardqry=mysql_query("select * from $tblname $findwhr $odrcri $odrpro limit $psver,$limit");
//line 153
//$sql= "select * from $tblname where prdt_sales_yn='Y' order by id desc limit 0,20" ; // 050614
$sql= "select * from $tblname where prdt_sales_yn='Y' order by id desc limit $psver,$limit" ;
//$sql1= "select * from $tblname $findwhr $odrcri $odrpro limit $psver,$limit" ; //before 032814
$boardqry=mysql_query($sql);
//echo "$sql $sql1" ;
?>
|
|
All view | Page view ");?> |
|
| | ");
echo("Sorry, we don't have data. | ");
echo("");
}else{?>
//paging numbering
$passoverpage=$limit*10;
$nextpage=$pgn+1;
$befopage=$pgn-1;
$prevpassover=($befopage * $passoverpage)-$passoverpage;
$hanpassoverpage=$pgn*$passoverpage;
$newpassover=($nextpage * $passoverpage)-$passoverpage;
$nowpage=($pgn*10)-9;
$nowpageend=$pgn*10;
if($pgn==1) {
$okpage="yes";
}
if($okpage !== yes){
echo("<< prev");
echo("");
}else{
// echo "<< prev";
// echo("");
}
echo("|");
for( $i=$nowpage; $i<=$nowpageend; $i++) {
$nowpassover=$limit*($i-1);
if($board_numrows > $nowpassover) {
if($psver != $nowpassover ){
echo("$i");
echo("|");
}else{
echo("$i");
echo("|");
}
}
}
if($board_numrows > $hanpassoverpage) {
echo("");
echo("next >>");
}else{
// echo("");
// echo("next >>");
}?>
|
echo("Page ");
if($psver==0){
echo("1");
}else{
$hpage=$psver/$limit;
$hhppge=$hpage+1;
echo("$hhppge");
}
echo (" / $total_page | Total $board_numrows item(s).");?>
|
$aNo=0;
while($boardqrya_rslt=mysql_fetch_array($boardqry)){
$prdt_id=$boardqrya_rslt[prdt_id];
$prdt_item_qry=mysql_query("select * from $tinatouch_prdt_product where prdt_id='$prdt_id'");
$boardqry_rslt=mysql_fetch_array($prdt_item_qry);
$prdt_name=$boardqry_rslt[prdt_name];
if(strlen($prdt_name) > 16){
$prdt_name=substr($prdt_name,0,15);
$prdt_name=$prdt_name.'..';
}else{}
$prdt_dis_factor="";
$prdt_price=$boardqry_rslt[prdt_price1];
$prdt_dis_price=$boardqry_rslt[prdt_dis_price2];
if($prdt_dis_price>0 && $prdt_price > $prdt_dis_price){
$prdt_dis_factor="Y";
}
$prdt_size=$boardqry_rslt[prdt_size];
$prdt_subchk_qry=mysql_query("select * from $tinatouch_prdt_subitem where prdt_id='$boardqry_rslt[prdt_id]' order by id asc");
$prdt_subchk_numrows=mysql_num_rows($prdt_subchk_qry);
$prdt_sub_size_no=0;
if(!$prdt_subchk_numrows){}else{
for($i=0;$i<$prdt_subchk_numrows;$i++){
$sprdt_price=mysql_result($prdt_subchk_qry,$i,7);
$sprdt_dis_price=mysql_result($prdt_subchk_qry,$i,9);
$sprdt_size=mysql_result($prdt_subchk_qry,$i,5);
if($sprdt_price){
$prdt_sub_size_no++;
}
$prdt_size=$prdt_size.', '.$sprdt_size;
if($sprdt_dis_price >0 && $sprdt_dis_price < $sprdt_price){
$prdt_dis_factor="Y";
}}}
$prdt_number=$boardqry_rslt[prdt_id];
$prdt_price_unit=$boardqry_rslt[prdt_sales_unit1];
$img_name=$boardqry_rslt[img1_filename];
$item_number=$boardqry_rslt[id];
$item_prdtid=$boardqry_rslt[prdt_id];
$Vno=$aNo%$hor_nb;
if($Vno==0){?>
}?>
No.$prdt_number $prdt_name");?>
|
0){
//echo("$prdt_size");
echo("$$prdt_price / $prdt_price_unit");
}else{
if($prdt_dis_factor=="Y"){
echo("$$prdt_price /$prdt_price_unit $$prdt_dis_price /$prdt_price_unit");
}else{
echo("$$prdt_price /$prdt_price_unit");
}}
}else if($mbprcshw_yn=="P"){
echo("Check your status");
}else if($mbprcshw_yn=="W"){
echo("Check your status");
}else{
echo("Check your status");
}
}else{
echo("Sign in for Price");
}?>
|
|
|
|
}else{
echo "We have nothing in this series.";
}?>
|
}$aNo++;}?>
//paging numbering
$passoverpage=$limit*10;
$nextpage=$pgn+1;
$befopage=$pgn-1;
$prevpassover=($befopage * $passoverpage)-$passoverpage;
$hanpassoverpage=$pgn*$passoverpage;
$newpassover=($nextpage * $passoverpage)-$passoverpage;
$nowpage=($pgn*10)-9;
$nowpageend=$pgn*10;
if($pgn==1) {
$okpage="yes";
}
if($okpage !== yes){
echo("<< prev");
echo("");
}else{
// echo "<< prev";
// echo("");
}
echo("|");
for( $i=$nowpage; $i<=$nowpageend; $i++) {
$nowpassover=$limit*($i-1);
if($board_numrows > $nowpassover) {
if($psver != $nowpassover ){
echo("$i");
echo("|");
}else{
echo("$i");
echo("|");
}
}
}
if($board_numrows > $hanpassoverpage) {
echo("");
echo("next >>");
}else{
// echo("");
// echo("next >>");
}?>
|
}?>
//end of board?> |
|