Overstock & Unnecessory Products Selling

"; exit; } } ##if($mode == "view"){ ## if($mem_sid != "" || $admin_sid != "") { ## } else { ## echo ""; ## exit; ## } ##} ?>

\n"; echo "

"; mysql_close($conn); exit; } else { echo ""; exit; } } if($mode == "write_insert" ){ if ($Theme=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } if ($Name=="") { echo " "; exit; } if ($Passwd=="") { echo " "; exit; } $query1 = "select Tot_No from $table order by Tot_No desc"; $result1 = mysql_query($query1,$conn); if(!$result1){ $Tot[0] = 0; } else { $Tot = mysql_fetch_row($result1); } $Tot_No=$Tot[0] + 1; } $dbresult = mysql_query("select Tot_No from $table order by Tot_No desc",$conn); $totalnumber = mysql_num_rows($dbresult); $dbresult1 = mysql_query("select Class_No from $table order by Class_No desc",$conn); if($mode == "write_insert"){ if (!$totalnumber) { $Tot_No=1; $Class_No=1; } else { $maxnumber = mysql_result($dbresult,0,"Tot_No"); $maxrefnum = mysql_result($dbresult1,0,"Class_No"); $Tot_No = $maxnumber + 1; $Class_No = $maxrefnum +1; } } if($mode == "write_insert") { $Date_buy="$Date_buy1/$Date_buy2/$Date_buy3"; $query2="INSERT INTO $table VALUES('$Tot_No','$Class_No','$ansnum','$mem_id','$Tel','$Fax','$Theme','$Name','$Email','$Contents','$Passwd','$Date_buy','0')"; $result2=mysql_query($query2,$conn); if(!$result2) { echo " "; } } if($mode == "fix_form") { if($admin_sid == "") { echo "

"; echo "

"; echo " \n"; echo " \n"; echo "

"; echo ""; echo ""; echo "

Modify

"; echo ""; echo ""; echo "

Password:

"; echo "

"; echo ""; echo "

"; echo "

"; echo ""; exit; } else { echo "

"; echo "

"; echo " \n"; echo " \n"; echo "

"; echo ""; echo ""; echo "

관리자 모드로 수정

"; echo ""; echo "

"; echo "

"; echo ""; echo "

"; echo "

"; echo ""; exit; } } if($mode == "fix_we") { if($admin_sid == "" ) { $query ="select Password from $table where Password='$passwd' and Tot_No='$No'"; $result= mysql_query($query,$conn); if(!$result) { echo "result error fix"; } $Outpasswd=mysql_result($result,0,'Password'); if($Outpasswd != $passwd || $Outpasswd == "") { echo ""; myql_close($conn); exit; } } $query1 = "select Tel,Fax,Theme,Name,E_mail,Contents,Password,Date_buy from $table where Tot_No='$No'"; $result1 = mysql_query($query1,$conn); $bbs_value = mysql_fetch_row($result1); $OutTel= $bbs_value[0]; $OutFax= $bbs_value[1]; $OutTheme = $bbs_value[2]; $OutName = $bbs_value[3]; $OutE_mail = $bbs_value[4]; $OutContents =$bbs_value[5]; $OutPasswd =$bbs_value[6]; $OutDate_buy=$bbs_value[7]; $OutDate_buy=explode("/",$OutDate_buy); mysql_free_result($result1); mysql_close($conn); echo ""; echo "

"; echo ""; exit; } if($mode == "fix_insert"){ if ($Theme=="") { echo " "; exit; } if ($Contents=="") { echo " "; exit; } if ($Name=="") { echo " "; exit; } if ($Passwd=="") { echo " "; exit; } $Date_buy="$Date_buy1/$Date_buy2/$Date_buy3"; $query2 = "update $table Set Tel='$Tel',Fax='$Fax',Theme='$Theme',Name='$Name',E_mail='$Email',Contents='$Contents',Password='$Passwd',Date_buy='$Date_buy' where Tot_No='$No'"; $result2 = mysql_query($query2,$conn); if(!$result2) { echo " "; exit; } } if($mode == "delete_form" ) { if($admin_id) { echo ""; echo "

"; echo " \n"; echo " \n"; echo "

"; echo ""; echo ""; echo "

정말로 삭제 하시겠습니까

"; echo ""; echo ""; echo "

"; echo "

"; echo ""; echo "

"; echo "

"; echo ""; exit; } else { echo ""; echo "

"; echo " \n"; echo " \n"; echo "

"; echo ""; echo ""; echo "

Delete

"; echo ""; echo ""; echo "

Password:

"; echo "

"; echo ""; echo "

"; echo "

"; echo ""; exit; } } if($mode == "delete"){ if(!$admin_id){ $query = "select Password from $table where Password='$del_passwd' and Tot_No='$No'"; $result = mysql_query($query,$conn); $Outpasswd=mysql_result($result,0,'Password'); if($Outpasswd != $del_passwd || $Outpasswd == "") { echo " "; myql_close($conn); exit; } else { $query2 ="delete from $table where ToT_No='$No'"; $result2 = mysql_query($query2,$conn); if(!$result2) { echo "erro result2"; } } } else { $query2 ="delete from $table where ToT_No='$No'"; $result2 = mysql_query($query2,$conn); } } if($mode == "view"){ ## if($mem_sid != "" || $admin_sid != "") { $query1 = "select Tel,Fax,Theme,Name,E_mail,Contents,Date_buy,Contact_No from $table where Tot_No='$No'"; $result1 = mysql_query($query1,$conn); $bbs_view = mysql_fetch_row($result1); $OutTel = $bbs_view[0]; $OutFax = $bbs_view[1]; $OutTheme=$bbs_view[2]; $OutName = $bbs_view[3]; $OutE_mail = $bbs_view[4]; $OutContents = ereg_replace("\n","
",$bbs_view[5]); $OutDate_buy = $bbs_view[6]; $OutCN = $bbs_view[7]; mysql_free_result($result1); $OutCN = $OutCN+1; $query2 = "update $table Set Contact_No='$OutCN' where Tot_No='$No'"; $result2 = mysql_query($query2,$conn); if($postcolor == "" || $postfont == "") { $postcolor="white"; $postfont="black"; } echo ""; echo "
"; echo ""; echo "

"; echo ""; echo "

Buying Details.

"; echo ""; echo "

"; echo ""; echo" "; echo""; echo"

Title

$OutTheme

"; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo"

Registrant	: $OutName
Email	: $OutE_mail
Tel	: $OutTel
Fax	: $OutFax
Validity	: $OutDate_buy
Request	$OutContents

"; echo"

"; echo "

"; echo ""; echo "

"; echo ""; mysql_close($conn); exit; ## } else { ## echo ""; ## exit; ##} } ########### 한 페이지당 출력할 게시물의 수 $num_per_page ="$list"; ########### 게시물 출력목록 하단에 링크를 걸 페이지의 개수 $page_per_block = 10; ########## 데이터베이스에 연결한다. ########### if(!$page) { $page = 1; } ########## 전체게시물의 총 개수를 각각 구한다. ########## if(!eregi("[^[:space:]]+",$key)) { $query = "SELECT count(Tot_No) FROM $table"; } else { $encoded_key = urlencode($key); $query = "SELECT count(Tot_No) FROM $table WHERE $keyfield='$key'"; } $result = mysql_query($query,$conn); if (!$result) { echo ("QUERY_ERROR"); exit; } $total_record = mysql_result($result,0,0); ########## 현재의 페이지에서 출력할 게시물의 범위를 결정한다. ########## if(!$total_record) { $first = 1; $last = 0; } else { $first = $num_per_page*($page-1); $last = $num_per_page*$page; $IsNext = $total_record - $last; if($IsNext > 0) { $last -= 1; } else { $last = $total_record - 1; } } ########## 전체 페이지수를 계산한다. ########## $total_page = ceil($total_record/$num_per_page); ?>

&keyfield=&key=">

&person=y">

border="0" align="center" cellspacing="0" cellpadding="0">

You can list your unnecessory products or overstock here.
You can make a direct deal with the buyer. You can purchase the items at a low price and fell free from the burden of the overstock. Please don't miss the win-win opportunity for buyers of sellers.

We hope that you do your duties as a member since this deal is done under the responsibility of each of parties.

border=0 CELLSPACING=0 CELLPADDING=0>

> "); ########## 회원 정보 ########## echo(" "); echo ""; } else { echo "$my_name"; } echo ""; echo ""; echo ""; echo ""; echo""; } } else { echo ""; } echo("

size="-1">Num	size="-1">Registrant	size=-1>Title	size=-1>Validity	size=-1> Tel	size=-1> Count
$my_num	"; if($my_email !=""){ echo "$my_name	$my_theme	"; echo "$my_date	"; echo "$my_tel	"; echo "$my_Contact_No
"; echo "No Data..."; echo "

"); ?> border="0" cellspacing="0" cellpadding="0" align="center">

1) { $my_page = $first_page; echo("[이전 ${page_per_block}개]"); } ########## 현재의 페이지 블럭범위내에서 각 페이지로 바로 이동할 수 있는 하이퍼링크를 출력한다. ########## for($direct_page = $first_page+1; $direct_page <= $last_page; $direct_page++) { if($page == $direct_page) { echo("[$direct_page]"); } else { echo("[$direct_page]"); } } ########## 다음페이지블록에 대한 페이지 링크 ########## if($block < $total_block) { $my_page = $last_page+1; echo("[다음 ${page_per_block}개]"); } ?>

border="0" cellspacing="0" cellpadding="0" align="center"> "); } else { echo(""); } ?>

1) { $page_num = $page - 1; echo("

"); } else { echo(""); } ########## 게시물이 다음페이지에도 존재할 경우 다음페이지로 가는 링크를 활성화시킨다. ########## if ($IsNext > 0) { $page_num = $page + 1; echo("