$hostname_dymenu_conn = "localhost";
$database_dymenu_conn = "cttlee";
$username_dymenu_conn = "cttlee";
$password_dymenu_conn = "cttlee";
$dymenu_conn = mysql_pconnect($hostname_dymenu_conn, $username_dymenu_conn, $password_dymenu_conn) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_query("SET NAMES utf8");
?>
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']) . '&cttlee=male';
}
else {
$editFormAction .= "?cttlee=male";
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1") && isset($_GET['cttlee'])) {
$insertSQL = sprintf("INSERT INTO records (Name, Zip) VALUES (%s, %s)",
GetSQLValueString($_POST['name'], "text"),
GetSQLValueString($_POST['zip'], "text"));
//mysql_select_db($database_dymenu_conn, $dymenu_conn);
//$Result1 = mysql_query($insertSQL, $dymenu_conn) or die(mysql_error());
$insertGoTo = "dymenu.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_dymenu_conn, $dymenu_conn);
$query_rs_county = "SELECT * FROM county ORDER BY cID ASC";
$rs_county = mysql_query($query_rs_county, $dymenu_conn) or die(mysql_error());
$row_rs_county = mysql_fetch_assoc($rs_county);
$totalRows_rs_county = mysql_num_rows($rs_county);
$colname_rs_town = "-1";
if (isset($_POST['county'])) {
$colname_rs_town = $_POST['county'];
}
mysql_select_db($database_dymenu_conn, $dymenu_conn);
$query_rs_town = sprintf("SELECT * FROM town WHERE tCounty = %s", GetSQLValueString($colname_rs_town, "text"));
$rs_town = mysql_query($query_rs_town, $dymenu_conn) or die(mysql_error());
$row_rs_town = mysql_fetch_assoc($rs_town);
$totalRows_rs_town = mysql_num_rows($rs_town);
$colname_rs_zip = "-1";
if (isset($_POST['town'])) {
$colname_rs_zip = $_POST['town'];
}
mysql_select_db($database_dymenu_conn, $dymenu_conn);
$query_rs_zip = sprintf("SELECT * FROM zip WHERE zTown = %s", GetSQLValueString($colname_rs_zip, "text"));
$rs_zip = mysql_query($query_rs_zip, $dymenu_conn) or die(mysql_error());
$row_rs_zip = mysql_fetch_assoc($rs_zip);
$totalRows_rs_zip = mysql_num_rows($rs_zip);
?>
?⊥?憿峕?隞?/title><br />
<script type="text/javascript"><br />
<!--<br />
function MM_findObj(n, d) { //v4.01<br />
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {<br />
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}<br />
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];<br />
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);<br />
if(!x && d.getElementById) x=d.getElementById(n); return x;<br />
}<br />
function flevSubmitForm() { // v1.1<br />
// Copyright 2002, Marja Ribbers-de Vroed, FlevOOware (www.flevooware.nl/dreamweaver/)<br />
var sF = arguments[0], oF = MM_findObj(sF), sA = (arguments.length > 1) ? arguments[1] : ""; <br />
if (oF) {if (sA != "") {oF.action = sA;} oF.submit(); document.MM_returnValue = false;}<br />
}<br />
//--><br />
</script><br />
</head><br />
<br />
<body><br />
<form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>"><br />
<table width="350" border="1" align="center" cellpadding="1" cellspacing="1"><br />
<tr><br />
<td width="80">憪枏?</td><br />
<td width="207"><input name="name" type="text" id="name" value="<?php echo $_POST['name']; ?>" /></td><br />
</tr><br />
<tr><br />
<td>?菟??�??/td><br />
<td><select name="county" id="county" onchange="flevSubmitForm('form1','dymenu.php');return document.MM_returnValue"><br />
<?php<br />
do { <br />
?><br />
<option value="<?php echo $row_rs_county['cID']?>"<?php if (!(strcmp($row_rs_county['cID'], $_POST['county']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rs_county['cName']?></option><br />
<?php<br />
} while ($row_rs_county = mysql_fetch_assoc($rs_county));<br />
$rows = mysql_num_rows($rs_county);<br />
if($rows > 0) {<br />
mysql_data_seek($rs_county, 0);<br />
$row_rs_county = mysql_fetch_assoc($rs_county);<br />
}<br />
?><br />
</select><br />
<select name="town" id="town" onchange="flevSubmitForm('form1','dymenu.php');return document.MM_returnValue"><br />
<?php<br />
do { <br />
?><br />
<option value="<?php echo $row_rs_town['tID']?>"<?php if (!(strcmp($row_rs_town['tID'], $_POST['town']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rs_town['tName']?></option><br />
<?php<br />
} while ($row_rs_town = mysql_fetch_assoc($rs_town));<br />
$rows = mysql_num_rows($rs_town);<br />
if($rows > 0) {<br />
mysql_data_seek($rs_town, 0);<br />
$row_rs_town = mysql_fetch_assoc($rs_town);<br />
}<br />
?><br />
</select><br />
<select name="zip" id="zip"><br />
<?php<br />
do { <br />
?><br />
<option value="<?php echo $row_rs_zip['zCode']?>"<?php if (!(strcmp($row_rs_zip['zCode'], $_POST['zip']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rs_zip['zName']?></option><br />
<?php<br />
} while ($row_rs_zip = mysql_fetch_assoc($rs_zip));<br />
$rows = mysql_num_rows($rs_zip);<br />
if($rows > 0) {<br />
mysql_data_seek($rs_zip, 0);<br />
$row_rs_zip = mysql_fetch_assoc($rs_zip);<br />
}<br />
?><br />
</select></td><br />
</tr><br />
<tr><br />
<td colspan="2" align="right"><input type="submit" name="button" id="button" value="?�枂" /></td><br />
</tr><br />
</table><br />
<input type="hidden" name="MM_insert" value="form1" /><br />
</form><br />
</body><br />
</html><br />
<?php<br />
mysql_free_result($rs_county);<br />
<br />
mysql_free_result($rs_town);<br />
<br />
mysql_free_result($rs_zip);<br />
?><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
county這個資料表有:cID,cName<br />
<br />
town資料表有:tID,tCounty,tName<br />
<br />
zip這資料表有:zID,zTown,zName,zCode <br />
<br></div><tr><td align="right"> </td></tr>
</td></tr></table></center><br>
<br><hr size=1> 共 2 人回應 選擇頁數 <a href=j2h-380-0.html>【第1 頁】 </a>
<p>
<center><form method=post action=reply_post.php?id=380 onSubmit="return(check())" name="form1">
<script language="javascript">
form1.j2h.value="";
form1.j2h5.value="";
function check() {
var str_pattern=/^.{2,34}$/;
if(form1.j2h.value.length < 2) { alert("請輸入姓名 !!"); return(false); }
if(form1.j2h.value.match(/[12~#$<%^┐＊∼§☆°+★~￣▽￣．≠ˇㄟ@=♂×,.0Oｏ├﹏☆〃'"\﹋\&*\/\\@!]/)){alert("請正確填寫姓名,請勿使用任何符號或敷衍字\n如果繼續張貼將會被列為黑名單"); return false}
var die = ["白痴","白ㄔ","白爛","花癡","喜憨","媽的","哩娘","那ㄇ爛","白目","北七","屌屁","濫遊戲","嘴賤","屌屁","智障","他媽的","廢渣","廢物","機掰","雞掰","靠北","嫩啦","有種來談判","有種出來說","爛片","無三小路用","濫到爆","肉腳","靠邀","殺小","吃屎","阿拉斯加","靠背","電愛","破麻","幹你","幹妳","幹林","幹李","幹幹幹","機掰","幹過了","不給上","給虧嘛","欠人插","啥小","欠幹","屁事","醜到爆","難看死","搞在一起","鬼一樣","長的醜","都很濫","靠你媽","瞎了狗眼","你他媽","死怪物","醜八怪","虎人","智障","嗆聲","幹架","白吃","修幹","去死","敗類","度濫","人渣","插我","雞八","靠杯","啟智","靠逼","狗屌","狗幹","幹砲","吃大便","打奶砲","打手槍","打泡","攬較","嫩逼","人妖","娘砲","下賤","低能兒","好娘","馬ㄉ","弱智","低能","智缺","死一死","攬叫","吃大便","啥鳥","拎北","開始幹她","機八","他媽ㄉ","腦殘","想幹他","別丟臉","爛死了","想嘗試愛愛","幹死妳","想做愛","賤炮","孬種","俗辣","沙小","白木","智帳","臭嘴","孬種","想愛愛","教我","想練","跳舞","不會","地板","不爽","只會","風車","我","妳","他","你","就","請問","這","樣","堆","的","想學","看","不","下","去","了","小蛙","沒","一起","上帝","勃起","j2h","JXH","專砲腦狗","懶趴","笑話","練舞","一個","臭基基","笑死","糙哩","每天","打槍","<"];
for(var i=0;i < die.length;i++)
if(form1.j2h.value.toLowerCase().replace(/ /gi, "").indexOf(die[i])!=-1) {
alert("名稱中含有疑似不雅或是被禁止使用的名稱或敷衍字,\n請移除此 '"+ die[i] +"' 文字,請正確填寫名稱,\n如果繼續張貼將會被列為黑名單");
return(false);}
if(form1.j2h5.value.length < 5) { location="index.php"; return(false); }
if(form1.j2h5.value.match(/[ㄅㄆㄇㄈㄉㄊㄋㄌㄍㄎㄏㄐㄑㄒㄓㄔㄕㄖㄗㄘㄙㄧㄨㄩㄚㄛㄜㄝㄞㄟㄠㄡㄢㄣㄤㄥㄦ]/)){alert("留言請勿使用任何注音文或是火星文\n如果繼續張貼將會被列為黑名單"); return false}
var jstop2 = ["求歌名","什麼歌","音樂叫什麼","歌名"];
for(var i=0;i < jstop2.length;i++)
if(form1.j2h5.value.toLowerCase().replace(/ /gi, "").indexOf(jstop2[i])!=-1) {
alert("J2H為分享平台,嚴禁張貼求檔求歌名主題\n如果繼續張貼將會被列為黑名單");
location="http://www.j2h.tw/";
return(false); }
var jstop = [".exe","yahoo.com","kimo.com","wretch.cc","tinyurl.com","@","<script"];
for(var i=0;i < jstop.length;i++)
if(form1.j2h5.value.toLowerCase().replace(/ /gi, "").indexOf(jstop[i])!=-1) {
alert("留言內容中含有被禁止張貼的網址,\n請移除此 '"+ jstop[i] +"' 網址,\n如果是要張貼影片請用'連結網址方式',\n請先至新手討論區那邊學習或測試,那有相關教學\n如果繼續張貼將會被列為黑名單");
return(false); }
var spam = ["白痴","白癡","白爛","孬種","俗辣","三八","長的醜","白ㄔ","沙小","白木","智帳","北爛","花癡","喜憨","媽的","馬的","哩娘","那ㄇ爛","白目","北七","屌屁","濫遊戲","嘴賤","屌屁","智障","他媽的","廢渣","廢物","機掰","雞掰","靠北","嫩啦","有種來談判","有種出來說","爛片","無三小路用","濫到爆","肉腳","靠邀","殺小","吃屎","阿拉斯加","靠背","電愛","破麻","幹你","幹妳","幹林","幹李","幹幹幹","機掰","幹過了","不給上","給虧嘛","欠人插","啥小","欠幹","屁事","醜到爆","難看死","搞在一起","鬼一樣","長的醜","都很濫","靠你媽","瞎了狗眼","你他媽","死怪物","醜八怪","虎人","智障","嗆聲","幹架","白吃","修幹","去死","敗類","度濫","人渣","插我","雞八","靠杯","啟智","靠逼","狗屌","狗幹","幹砲","吃大便","打奶砲","打手槍","打泡","攬較","嫩逼","人妖","娘砲","下賤","低能兒","好娘","馬ㄉ","弱智","低能","智缺","死一死","攬叫","吃大便","啥鳥","拎北","開始幹她","機八","他媽ㄉ","腦殘","想幹他","別丟臉","爛死了","想嘗試愛愛","幹死妳","靠爸","賤胚","賤炮","臭嘴","屁話","不要臉","白幕","爛人","嫩B","靠腰","砲友","招人","八千下","狼牙","基掰","糙你","<iframe"];
for(var i=0;i < spam.length;i++)
if(form1.j2h5.value.toLowerCase().replace(/ /gi, "").indexOf(spam[i])!=-1) {
alert("留言內容中含有疑似不雅的文字或是被禁止的文字,\n請移除不雅 '"+ spam[i] +"' 的文字,\n請禮貌已對請勿有任何辱罵批評、挑釁、人身攻擊等字眼,\n以免被列為黑名單");
return(false); }
var dirty = ["客源網","寄給我","傳給我","............","____/洗/ ","999999","1樓","location.replace","私服","嘴砲","嘴炮","嘴泡","炮文","嘴巴最強","砲你","炮你","泡你"];
for(var i=0;i < dirty.length;i++)
if(form1.j2h5.value.replace(/ /gi, "").indexOf(dirty[i])!=-1) {
location="index.php";
return(false); }
var dirty = ["lovergirlever.com","live173.com?","money.tw","[/url]","tww633","汽車借錢","機車借錢","當舖","你找我找他","u-mao","love5955.com","wscs191010","pp2.idv.tw","ppt.cc","is.gd","weebly.com","茶坊","dd93751","EM.crew.tw ","yodidi.com","wagn886","yhoosec","sallyas1990","xolove525","xolove521","yudidi.com","vions.net","qiqi7789","大和賞","xolove","現金消費","llxllx111","不轉帳","不刷卡","bule88088","love_520ve","baydu520","phoebe15840","ck077","goo.gl","在家兼職","now.to","網路專兼職","電腦操作網路宣傳","九十天免費試用","HBEE","mikehang63","ftp.cc","xiaodie91","staiwan.com","abc173.com","blogspot.com","fashion3c.url.tw","ligsystem.com","twmis.net","neopets.com","so-ya4","無碼","情色網","av808.com","hjchung.tw","slime.com.tw","vovo2000.com","Hung-Ya.com","lookm.com","hisyy.com","msi-team.com","homework123.com","twcam.com","qoo.av-city","arx.myweb.hinet.net","sogood.why.to","a href","dvd888.com","neopets.com","kan120.com","x-adam.com","hung-ya.com","gigicry.com","msi.168.lv","dy8.com","2sextv.com","嘗鮮專線","現金收費","kelly_shop","批發切貨","zxcvb001cm","moneymine.net","成人貼圖","兼職做援","全套服務","哥哥約愛","weilon.no-ip.com","[/url]","[url=","top20free.com","breaki77ing","c329646","xyz22.com","snow258.com","love5955.com","5280344","qwe3300923","nini9595","besttuboonline.com","srvo.idv","eyny.com","besttuboonline.com","his_funky_style","dancerhiphop","coolgo.com","libb.co","xin-yuan.tw","27756599","567pan.com","boy4628241","fashion3c","0938009789","besttuboonline.com","yuonuom.com","weebly.com","tw9m.com","蜻蜓飛舞","yunupload.net","jolin578","0909873168","live173.com","美女視訊",".com","http"];
for(var i=0;i < dirty.length;i++)
if(form1.j2h5.value.replace(/ /gi, "").indexOf(dirty[i])!=-1) {
location="http://www.j2h.tw/bbs/bombersuper.php";
return(false);
}
if(form1.j2h4.value!='' && form1.j2h10.value=='') { alert("請務必選擇正確連結檔案！"); return(false); }
var dirty = ["http://www.wretch.cc/album/","http://www.wretch.cc/blog/",".exe","yahoo.com","C:","care-you","j2h.tw",".html",".htm","@","www.soo-easy.com/shaonv.mp3"];
for(var i=0;i < dirty.length;i++)
if(form1.j2h4.value.indexOf(dirty[i])!=-1) {
alert("連結網址方式錯誤,\n新手討論區有相關教學請至那邊學習或測試,\n以免被版主列為黑名單");
location="http://www.j2h.tw/bbs/bbs14/j2h.php?id=3378";
return(false);
}
return(true);
}
</script>
<table width="90%" height=65 border="1" cellpadding=1 cellspacing=0 bordercolorlight=#346783 bordercolordark=#FFFFFF bgcolor="#F0F9FF">
<tr align="center">
<input type="hidden" name="username" value="">
<td width="14%" ALIGN="left" VALIGN="TOP" NOWRAP>姓名：</td>
<td align="left" colspan=3><input NAME="j2h" MAXLENGTH="16" SIZE="60" value=''>
</td>
</tr>
<tr align="center">
<td ALIGN="left" VALIGN="TOP" NOWRAP>佈告內容：</td>
<td align="left" colspan=3> <textarea name="j2h5" ROWS="15" COLS="80" ></textarea>
</td>
</tr>
<tr align="center">
<td ALIGN="RIGHT" VALIGN="TOP" NOWRAP colspan="4"> <p align="center"><br> <input type=submit value='確定發言' onClick="this.disable=true;">
</td></tr></table></form>
</center></body></html> |
