[問題]簡易子版面v1.3

文章由 **a780411** » 2006-07-21 02:21

問題外掛：簡易子版面v1.0
參考連結：
http://phpbb-tw.net/phpbb/viewtopic.php?t=33019
網站位置：
http://forum.cksh.tp.edu.tw=>因為某些原因...所以進去後可能會看到的是沒有安裝子版面的檔案~~所以有可能看不到問題....SORRY
(如果背景是黑的就有安裝子版面...如果是phpbb預設的風格就沒有)

狀況描述：

安裝後右下角"前往......GO"的下拉選單是空白....

而我看到的錯誤訊息是找不到物件.....

但是我每個地方都丟sub_forum.js~~都一樣沒用

但其他地方、後台的選單都有出來......

查不出原因
希望有人能幫忙
感激不盡

問題如下：

有爬過文~~但那篇文章試過後無效@@~http://phpbb-tw.net/phpbb/viewtopic.php?t=33183

另外在問一下....後台如果要偏輯子版面要如何編輯??

因為我把某個版面設成子版面後~~就從後台消失了@@~

文章由 **a780411** » 2006-07-26 01:22

順便問一下...

設成子版面後，那個子版面是不是會從版面管理中消失??

因為我設個版為子板面後，想更改版面名稱~~卻發現不見了~~

請問這是正常嗎??

文章由 **心靈捕手** » 2006-07-27 23:31

a780411 寫:順便問一下...

設成子版面後，那個子版面是不是會從版面管理中消失??

因為我設個版為子板面後，想更改版面名稱~~卻發現不見了~~

請問這是正常嗎??

如果這種情況算是 '正常' 的話,
那麼您要怎麼做日後的設定呢?

建議您:
1. 若仍保有預設風格 (subSilver) 的話,
則請先行以預設風格來安裝外掛,
成功後, 再套用到其他風格使用.
2. 將下列檔案壓縮後, 貼出下載連結.
sub_forum.js
templates/YOUR_THEME/viewforum_body.tpl
templates/YOUR_THEME/jumpbox.tpl
admin/admin_forums.php

文章由 **a780411** » 2006-07-28 00:56

我這次重做時，

我是先掛我找到的風格後，兩邊一起改

也就是Sxxxx有改到的和DAJ_class有改到的東西是一樣的....

http://203.64.138.2/help.zip

麻煩您了，謝謝！

文章由 **心靈捕手** » 2006-07-28 09:29

a780411 寫:我這次重做時，

我是先掛我找到的風格後，兩邊一起改

也就是Sxxxx有改到的和DAJ_class有改到的東西是一樣的....

http://203.64.138.2/help.zip

麻煩您了，謝謝！

建議您:
1. 將風格檔 jumpbox.tpl 也轉碼 utf-8 後存檔.
2. admin/admin_forums.php 修改如下:
#
#-----[ FIND ]-----
#

代碼: 選擇全部

			$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, forum_sub, sort_sub, main_sub, prune_enable" . $field_sql . ")
				VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . $forum_sub . "," . $sort_sub . "," . $main_sub . "," . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";

#
#-----[ REPLACE WITH ]-----
#

代碼: 選擇全部

			$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, forum_sub, sort_sub, main_sub, prune_enable" . $field_sql . ")
				VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . $c . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . $forum_sub . "," . $sort_sub . "," . $main_sub . "," . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";

文章由 **a780411** » 2006-07-28 12:39

jumpbox的問題解決了...

原來只是編碼問題Orz...

感激....

但是後台還是看不到子版面@@~

文章由 **心靈捕手** » 2006-07-28 17:03

a780411 寫:jumpbox的問題解決了...

原來只是編碼問題Orz...

感激....

但是後台還是看不到子版面@@~

查看原外掛裝說明,...

我猜想:
也許, 根本的問題就是出在 '轉碼'.

建議您:
這個風格檔也必須轉 utf-8 碼.
templates/YOUR_THEME/admin/forum_admin_body.tpl

文章由 **a780411** » 2006-07-29 01:52

我轉過了...

可是還是一樣@@~

我覺得好像是admin/admin_forums.php的問題...

另外我把admin/admin_forums.php原本照說明應該

代碼: 選擇全部

# 
#--------[ FIND ]---------------- 
# 
	if( $total_forums = $db->sql_numrows($q_forums) ) 
	{ 
		$forum_rows = $db->sql_fetchrowset($q_forums); 
	} 

# 
#-----[ REPLACE WITH 替換 ]----------------------------------- 
# 
	while( $row = $db->sql_fetchrow($q_forums) )
	{
		if($row[forum_sub]>0)
		{
			$forum_sub2[$row['forum_sub']][]=$row;
		}
		else
		{
			$forum_rows[] = $row;
		}
	}
	$total_forums=count($forum_rows);

這段我改回取代前的樣子..

就看的到子版面...

但是看起來就像普通版面一樣....完全沒有任何分別

這樣是正常的樣子嗎??

文章由 **心靈捕手** » 2006-07-29 10:03

a780411 寫:我轉過了...

可是還是一樣@@~

我覺得好像是admin/admin_forums.php的問題...

另外我把admin/admin_forums.php原本照說明應該
代碼: 選擇全部
# 
#--------[ FIND ]---------------- 
# 
	if( $total_forums = $db->sql_numrows($q_forums) ) 
	{ 
		$forum_rows = $db->sql_fetchrowset($q_forums); 
	} 

# 
#-----[ REPLACE WITH 替換 ]----------------------------------- 
# 
	while( $row = $db->sql_fetchrow($q_forums) )
	{
		if($row[forum_sub]>0)
		{
			$forum_sub2[$row['forum_sub']][]=$row;
		}
		else
		{
			$forum_rows[] = $row;
		}
	}
	$total_forums=count($forum_rows);
這段我改回取代前的樣子..

就看的到子版面...

但是看起來就像普通版面一樣....完全沒有任何分別

這樣是正常的樣子嗎??

建議您:
將修改前, 後所得的情況, 貼圖說明.

文章由 **a780411** » 2006-07-29 15:02

這是

代碼: 選擇全部

   if( $total_forums = $db->sql_numrows($q_forums) ) 
   { 
      $forum_rows = $db->sql_fetchrowset($q_forums); 
   }

這是

代碼: 選擇全部

   while( $row = $db->sql_fetchrow($q_forums) ) 
   { 
      if($row[forum_sub]>0) 
      { 
         $forum_sub2[$row['forum_sub']][]=$row; 
      } 
      else 
      { 
         $forum_rows[] = $row; 
      } 
   } 
   $total_forums=count($forum_rows);

子版面就是那堆班版...

另外"母版面"(93、94)的位置在"子版面"(93_XXX_XXX、94_XXX_XXX)的上方是我調過的...

不然原本即使是"母版面"不一定會在"子版面"的上方...

麻煩您了！

文章由 **心靈捕手** » 2006-07-29 18:31

建議您:
重新檢視下列檔案的修改; 或者將其壓縮後, 貼出下載連結.
admin/admin_forums.php
templates/YOUR_THEME/admin/forum_admin_body.tpl

文章由 **a780411** » 2006-07-31 02:03

http://venus.cksh.tp.edu.tw/phpbb_tw/phpbb_tw_003.zip

麻煩您了！

因為今天白天時學校停電，所以現在才把檔案放上去...

文章由 **a780411** » 2006-07-31 02:52

另外我又發現個小問題= ="

例如：93是母版，位在"各班班級教室區"這個分區，在底下有93_XXX_XXX許多子版面

而我想修改母版面(93)的介紹，於是按編輯，不管有沒有修改，按更新

都會跳出"此版面有其他子版面相連,無法設定成子版面”

不管"分區"沒有更改(也就是"93")，或是更改成"各班班級教室區"

都會跑出來@@~

而且admin_forums.php裡我提過的那段程式碼，不管是有取代過或沒取代過都一樣...

我哪裡沒改好嗎@@~

文章由 **心靈捕手** » 2006-07-31 05:07

a780411 寫:http://venus.cksh.tp.edu.tw/phpbb_tw/phpbb_tw_003.zip

麻煩您了！

因為今天白天時學校停電，所以現在才把檔案放上去...

查看您貼的檔案, 大致上兩個檔案都得修正.

以下的修改, 提供您參考:
#
#-----[ OPEN ]-----
#
templates/YOUR_THEME/admin/forum_admin_body.tpl

#
#-----[ FIND ]-----
#

代碼: 選擇全部

	<!-- END forumrow -->
		<!-- BEGIN sub_forumrow -->
		<tr>
			<td class="row2"><table width="100%"><tr>
				<td>
					<script language="JavaScript">sub_line({catrow.forumrow.sub_forumrow.SUB_LINE});</script>
				</td>
				<td width="100%">
					<span class="gen"><fieldset ><a href="{catrow.forumrow.sub_forumrow.U_VIEWFORUM}" target="_new">{catrow.forumrow.sub_forumrow.FORUM_NAME}</a></span><br /><span class="gensmall">{catrow.forumrow.sub_forumrow.FORUM_DESC}</fieldset></span>
				</td>
			</tr></table></td>
			<td class="row1" align="center" valign="middle"><span class="gen">{catrow.forumrow.sub_forumrow.NUM_TOPICS}</span></td>
			<td class="row2" align="center" valign="middle"><span class="gen">{catrow.forumrow.sub_forumrow.NUM_POSTS}</span></td>
			<td class="row1" align="center" valign="middle"><span class="gen"><a href="{catrow.forumrow.sub_forumrow.U_FORUM_EDIT}">{L_EDIT}</a></span></td>
			<td class="row2" align="center" valign="middle"><span class="gen"><a href="{catrow.forumrow.sub_forumrow.U_FORUM_DELETE}">{L_DELETE}</a></span></td>
			<td class="row1" align="center" valign="middle"><span class="gen"><a href="{catrow.forumrow.sub_forumrow.U_FORUM_MOVE_UP}">{L_MOVE_UP}</a> <br /> <a href="{catrow.forumrow.sub_forumrow.U_FORUM_MOVE_DOWN}">{L_MOVE_DOWN}</a>{catrow.forumrow.sub_forumrow.FORUM_SUB}</span></td>
			<td class="row2" align="center" valign="middle"><span class="gen"><a href="{catrow.forumrow.sub_forumrow.U_FORUM_RESYNC}">{L_RESYNC}</a></span></td>
		</tr>
		<!-- END sub_forumrow -->

#
#-----[ REPLACE WITH ]-----
#

代碼: 選擇全部

		<!-- BEGIN sub_forumrow -->
		<tr>
			<td class="row2"><table width="100%"><tr>
				<td>
					<script language="JavaScript">sub_line({catrow.forumrow.sub_forumrow.SUB_LINE});</script>
				</td>
				<td width="100%">
					<span class="gen"><fieldset ><a href="{catrow.forumrow.sub_forumrow.U_VIEWFORUM}" target="_new">{catrow.forumrow.sub_forumrow.FORUM_NAME}</a></span><br /><span class="gensmall">{catrow.forumrow.sub_forumrow.FORUM_DESC}</fieldset></span>
				</td>
			</tr></table></td>
			<td class="row1" align="center" valign="middle"><span class="gen">{catrow.forumrow.sub_forumrow.NUM_TOPICS}</span></td>
			<td class="row2" align="center" valign="middle"><span class="gen">{catrow.forumrow.sub_forumrow.NUM_POSTS}</span></td>
			<td class="row1" align="center" valign="middle"><span class="gen"><a href="{catrow.forumrow.sub_forumrow.U_FORUM_EDIT}">{L_EDIT}</a></span></td>
			<td class="row2" align="center" valign="middle"><span class="gen"><a href="{catrow.forumrow.sub_forumrow.U_FORUM_DELETE}">{L_DELETE}</a></span></td>
			<td class="row1" align="center" valign="middle"><span class="gen"><a href="{catrow.forumrow.sub_forumrow.U_FORUM_MOVE_UP}">{L_MOVE_UP}</a> <br /> <a href="{catrow.forumrow.sub_forumrow.U_FORUM_MOVE_DOWN}">{L_MOVE_DOWN}</a>{catrow.forumrow.sub_forumrow.FORUM_SUB}</span></td>
			<td class="row2" align="center" valign="middle"><span class="gen"><a href="{catrow.forumrow.sub_forumrow.U_FORUM_RESYNC}">{L_RESYNC}</a></span></td>
		</tr>
		<!-- END sub_forumrow -->
	<!-- END forumrow -->

#
#-----[ OPEN ]-----
#
admin/admin_forums.php

#
#-----[ FIND ]-----
#

代碼: 選擇全部

			$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, forum_sub, sort_sub, main_sub, prune_enable" . $field_sql . ")
				VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . $forum_sub . "," . $sort_sub . "," . $main_sub . "," . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";

#
#-----[ REPLACE WITH ]-----
#

代碼: 選擇全部

			$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, forum_sub, sort_sub, main_sub, prune_enable" . $field_sql . ")
				VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . $c . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . $forum_sub . "," . $sort_sub . "," . $main_sub . "," . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";

#
#-----[ FIND ]-----
#

代碼: 選擇全部

			
//forum_sub start 
         $forum_set=$HTTP_POST_VARS[POST_CAT_URL]; 
         if(empty($forum_set)) 
         { 
            message_die(GENERAL_ERROR, "閮剖??航炊"); 
         } 
         else 
         { 
            $sql = "select count(forum_sub) as id from " . FORUMS_TABLE . " WHERE forum_sub = " . intval($HTTP_POST_VARS[POST_FORUM_URL]); 
            if( !$result = $db->sql_query($sql) ) 
            { 
               message_die(GENERAL_ERROR, "閮剖??航炊"); 
            } 
            $get_sub_Id = $db->sql_fetchrow($result); 
            if($get_sub_Id[id]>0) 
            { 
               message_die(GENERAL_ERROR, "甇斤??Ｘ??嗡?摮??Ｙ???⊥?閮剖????"); 
            } 
            $temp=split(",",$forum_set); 
            $c=intval($temp[0]); 
            $forum_sub=intval($temp[1]); 
            $HTTP_POST_VARS['forumname']=str_replace("<","",$HTTP_POST_VARS['forumname']); 
            $HTTP_POST_VARS['forumdesc']=str_replace("<","",$HTTP_POST_VARS['forumdesc']); 
            if(intval($HTTP_POST_VARS[POST_FORUM_URL])== $forum_sub) 
            { 
               $sort_sub=intval($temp[2]); 
               $sql = "UPDATE " . FORUMS_TABLE . " 
                     SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . " 
                     WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]); 
            }else 
            { 
               if(intval($temp[1])>0) 
               { 
                  $sort_sub=intval($temp[2])+1; 
               }else 
               { 
                  $sort_sub=intval($temp[2]); 
               } 
               $main_sub=intval($temp[3]); 
               
			$sql = "UPDATE " . FORUMS_TABLE . "
				SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . $c . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . ",forum_sub=".$forum_sub.",sort_sub=".$sort_sub.",main_sub=".$main_sub." 
				WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
			            } 
         } 
         if( !$result = $db->sql_query($sql) ) 
         { 
            message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql); 
         } 
//forum_sub end

#
#-----[ REPLACE WITH ]-----
#

代碼: 選擇全部

//forum_sub start
			$forum_set=$HTTP_POST_VARS[POST_CAT_URL];
			if(empty($forum_set))
			{
				message_die(GENERAL_ERROR, "閮剖??航炊");
			}
			else
			{
				$temp=split(",",$forum_set);
				$c=intval($temp[0]);
				$forum_sub=intval($temp[1]);
				$sort_sub=intval($temp[2]);
				$main_sub=intval($temp[3]);
				$forum_id=intval($HTTP_POST_VARS[POST_FORUM_URL]);
				$sub_array = array();
				$sub_id_array = array();
				if($main_sub==0)
				{
					$temp_main_id=$forum_sub;
				}else
				{
					$temp_main_id=$main_sub;
				}
				$sql = "select forum_sub from " . FORUMS_TABLE . " WHERE forum_id = ".$forum_sub." ";
				if( !$result = $db->sql_query($sql) )
				{
					message_die(GENERAL_ERROR, "Couldn't query forums table ", "", __LINE__, __FILE__, $sql);
				}
				$row = $db->sql_fetchrow($result);
				$get_forum_sub=$row["forum_sub"];

				$sql = "select forum_id,forum_sub from " . FORUMS_TABLE . " WHERE (main_sub = " . $temp_main_id." or forum_id=".$temp_main_id.") and sort_sub < ".$sort_sub." order by sort_sub desc";
				if( !$result = $db->sql_query($sql) )
				{
					message_die(GENERAL_ERROR, "Couldn't query forums table ", "", __LINE__, __FILE__, $sql);
				}
				while( $row = $db->sql_fetchrow($result) )
				{
					if($get_forum_sub == $row["forum_id"])
					{
						$sub_array[]=$row["forum_id"];
						$get_forum_sub = $row["forum_sub"];
					}
				}
				for($i=0;$i<count($sub_array);$i++)
				{
					if($sub_array[$i]==$forum_id)
					{
						message_die(GENERAL_ERROR, "甇斤??Ｘ??嗡?摮??Ｙ???⊥?閮剖????");
					}
				}
				$sql = "select forum_id from " . FORUMS_TABLE . " WHERE forum_sub = " . $forum_id." ";
				if( !$result = $db->sql_query($sql) )
				{
					message_die(GENERAL_ERROR, "Couldn't query forums table ", "", __LINE__, __FILE__, $sql);
				}
				while( $row = $db->sql_fetchrow($result) )
				{
					$sub_id_array[]=$row["forum_id"];
					forum_id_sub($row);
				}
				if($forum_id== $forum_sub)
				{
					$sort_sub=intval($temp[2]);
					$sql = "UPDATE " . FORUMS_TABLE . "
							SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
							WHERE forum_id = " . $forum_id;
				}else
				{
					if(intval($temp[1])>0)
					{
						$sort_sub=intval($temp[2])+1;
					}else
					{
						$sort_sub=intval($temp[2]);
					}
					$sql = "UPDATE " . FORUMS_TABLE . "
							SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . $c . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
							,forum_sub=".$forum_sub.",sort_sub=".$sort_sub.",main_sub=".$main_sub."
							WHERE forum_id = " . $forum_id;
					if( !$result = $db->sql_query($sql) )
					{
						message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
					}
					if(count($sub_id_array)>0)
					{
						$sort_sub=($sort_sub-intval($HTTP_POST_VARS["s_sort_sub"]));
						$sql = "UPDATE " . FORUMS_TABLE . "
								SET sort_sub=sort_sub+".$sort_sub.",main_sub=".$main_sub."
								WHERE forum_id in (".implode(', ',$sub_id_array).")" ;
					}
				}
			}
			if( !$result = $db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
			}

//forum_sub end

#
#-----[ FIND ]-----
#

代碼: 選擇全部

	if( $total_forums = $db->sql_numrows($q_forums) ) 
	{ 
		$forum_rows = $db->sql_fetchrowset($q_forums); 
	}

#
#-----[ REPLACE WITH ]-----
#

代碼: 選擇全部

	while( $row = $db->sql_fetchrow($q_forums) )
	{
		if($row[forum_sub]>0)
		{
			$forum_sub2[$row['forum_sub']][]=$row;
		}else
		{
			$forum_rows[] = $row;
		}
	}
	$total_forums=count($forum_rows);

#
#-----[ SAVE & CLOSE ]-----
#

ps.
您的 admin/admin_forums.php 在修改 $sql 時,
因為沒有加入其他外掛, 所以直接參考 (前面) 外掛安裝說明 (取代) 即可.

但是, 您卻參考了 (後頭) 我的補充說明?
因為當時寫這個說明時, 外掛的版本只有 1.1 或 1.2 (忘記了),
所以您若是參考該段寫法, 則必須要再做升級 1.1-> 1.2 或 1.2-> 1.3

文章由 **a780411** » 2006-07-31 10:37

現在是用PDA上網,所以不能試以上您給的意見,晚上回家再試XD

印象中我會這樣改是因為全區公告和子版面會衝到?(不知有沒記錯XD)

而我現有安裝匿稱外掛、全區公告、cash mod、檔案附加