調(diào)用留言本標題的關鍵在于,前臺顯示的數(shù)據(jù)庫缺少標題字段,所以,只要向數(shù)據(jù)庫添加了標題字段,就方便調(diào)用了。
	參考借鑒了http://bbs.dedecms.com/read.php?tid=31033&keyword=%C1%F4%D1%D4%B1%BE,感謝gufei。
	修改LOOP標記完成感謝xiaoqi指導。
	步驟:
	1、用PHPMYADMIN登陸您的數(shù)據(jù)庫,找到DEDE數(shù)據(jù)庫中的"guestbook"表,增加一個"guesttitle"字段,設為"varchar",字段大小自定。
	>>>如果不想JS調(diào)用達到實時更新的目的,可以跳過步驟2和6,完成步驟3、4、5后直接使用loop循環(huán)標記:
	{dede:loop table=’dede_guestbook’ sort=’dtime’ row=’10′ if=’ischeck=1′}
	<a href="[field:phpurl/]/guestbook/index.php" >[field:guesttitle function="cn_substr('@me',30)"/]</a><br>
	{/dede:loop}
	2、在/plus/guestbook/下新建一個js.php文件,js.php內(nèi)容如下:
	<?php
	require_once(dirname(__FILE__)."/config.php");
	require_once(dirname(__FILE__)."/../../include/pub_datalist_dm.php");
	setcookie("GUEST_BOOK_MOVE",GetCurUrl(),time()+3600,"/");
	function GetIsCheck($ischeck,$id)
	{
	  if($ischeck==0) return "<br><a href=’edit.php?job=check&ID=$id’ style=’color:red’>[審核]</a>";
	  else return "";
	}
	if($userrank>0) $sql = "select * from dede_guestbook order by ID desc";
	else $sql = "select * from dede_guestbook where ischeck=1 order by ID desc";
	$dlist = new DataList();
	$dlist->Init();
	$dlist->pageSize =10;
	$dlist->SetParameter("gotopagerank",$gotopagerank);
	$dlist->SetSource($sql);
	$mylist = $dlist->GetDataList();
	while($row = $mylist->GetArray(‘dm’))
	{
	  $xingming=$row['uname'];
	  $neirong=strip_tags($row['guesttitle']);
	  $neirong=str_replace(" ","",$neirong);
	  $neirong=cn_substr($neirong,25);
	  $neirong=str_replace("
	","",$neirong);
	  $neirong=rawurldecode($neirong);
	  $link=$row['ID'];
	  echo "document.write("- <a href=’./plus/guestbook/index.php#$link’ target=’_blank’>$neirong</A><br>");";
	}
	$dlist->Close();
	?>
	3、在templetsplusguestbook.htm文件中加上命名錨記
	找到
	<?php
	$mylist = $dlist->GetDataList();
	while($row = $mylist->GetArray(‘dm’))
	{
	?>
在后邊加入
	CODE:
	<a name="<?echo $row['ID']?>"></a>
4、在/templets/plus/guestbook.htm中加入讀取留言本標題的代碼"<?php echo $row['guesttitle']?>"到您想要的位置。
	5、將savepost.php中的:
	$dsql = new DedeSql(false);
	$ip = GetIP();
	$dtime = strftime("%Y-%m-%d %H:%M:%S",mytime());
	$uname = trimMsg($uname);
	$email = trimMsg($email);
	$homepage = trimMsg($homepage);
	$homepage = eregi_replace("http://","",$homepage);
	$qq = trimMsg($qq);
	$msg = trimMsg($msg,1);
	$msg = cn_substr($msg,2000);
	if($msg==""||$uname==""){
	    showMsg("你的姓名和留言內(nèi)容不能為空!",-1);
	    exit();
	}
	$query = "INSERT INTO
	dede_guestbook(uname,email,homepage,qq,face,msg,ip,dtime,ischeck)
	VALUES (‘$uname’,'$email’,'$homepage’,'$qq’,'$img’,'$msg’,'$ip’,'$dtime’,'$needCheck’)";
	$dsql->SetQuery($query);
	$dsql->ExecuteNoneQuery();
	$dsql->Close();
	替換為(意在讀取標題到數(shù)據(jù)庫):
	$dsql = new DedeSql(false);
	$ip = GetIP();
	$dtime = strftime("%Y-%m-%d %H:%M:%S",mytime());
	$uname = trimMsg($uname);
	$email = trimMsg($email);
	$homepage = trimMsg($homepage);
	$homepage = eregi_replace("http://","",$homepage);
	$qq = trimMsg($qq);
	$guesttitle = trimMsg($guesttitle);
	$msg = trimMsg($msg,1);
	$msg = cn_substr($msg,2000);
	if($msg==""||$uname==""){
	    showMsg("你的姓名和留言內(nèi)容不能為空!",-1);
	    exit();
	}
	$query = "INSERT INTO
	dede_guestbook(uname,email,homepage,qq,face,guesttitle,msg,ip,dtime,ischeck)
	VALUES (‘$uname’,'$email’,'$homepage’,'$qq’,'$img’,'$guesttitle’,'$msg’,'$ip’,'$dtime’,'$needCheck’)";
	$dsql->SetQuery($query);
	$dsql->ExecuteNoneQuery();
	$dsql->Close();
6、在首頁需要調(diào)用留言本內(nèi)容的地方加入
	CODE:
	<script language="javascript" src="./plus/guestbook/js.php" ></script>
新聞熱點
疑難解答
圖片精選