抓新版比對~~文 寫:阿? 你沒收到我的PM阿QQ||
我在PM一次網址跟ID&PW給你
你幫我試試好嗎? 因為我現在是文章無法加入精華區
其他功能都正常!還有就是!因為我不知道你這個檔案ar_text.php
還會更新>___< 所以我就改了一堆我想要的Style...!
所以想問問可不可以手動更新(許功蓋編碼問題更新)
以上!歹勢...問題一堆...最近壓抑很久了>___<|| 隨時會爆炸!
沒有的就加進去~~
我肯定不是register_globals的問題~~
你一定改錯東西了~~
版主: 版主管理群

是喔!可是我的add_arc.php是用1.0.1更新版下去蓋的耶\rmessagebox 寫:抓新版比對~~文 寫:阿? 你沒收到我的PM阿QQ||
我在PM一次網址跟ID&PW給你
你幫我試試好嗎? 因為我現在是文章無法加入精華區
其他功能都正常!還有就是!因為我不知道你這個檔案ar_text.php
還會更新>___< 所以我就改了一堆我想要的Style...!
所以想問問可不可以手動更新(許功蓋編碼問題更新)
以上!歹勢...問題一堆...最近壓抑很久了>___<|| 隨時會爆炸!
沒有的就加進去~~
我肯定不是register_globals的問題~~
你一定改錯東西了~~
代碼: 選擇全部
<?
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/bbcode.'.$phpEx);
include($phpbb_root_path . 'includes/functions_validate.'.$phpEx);
include($phpbb_root_path . 'includes/functions_post.'.$phpEx);
if ($f){
}else{
if ($p_id){
$sql = "SELECT * FROM ".POSTS_TABLE." WHERE post_id = $p_id";
if( !($result = $db->sql_query($sql)) ){message_die(GENERAL_ERROR, 'ERROR02', '', __LINE__, __FILE__, $sql);}
$chk_my_f = $db->sql_fetchrow($result);
$f=$chk_my_f['forum_id'];
}
}
$userdata = session_pagestart($user_ip, $f);
init_userprefs($userdata);
$is_auth2 = array();
$is_auth2 = auth(AUTH_ALL, $f, $userdata, $forum_row);
if ( !$is_auth2['auth_mod'] ){
message_die(GENERAL_ERROR, '沒有管理版面的權利', '', __LINE__, __FILE__);
}
if (!$top_id){$top_id=0;}
if ($top_id < 0){$top_id=0;}
$sql = "SELECT * FROM ".POSTS_TABLE." WHERE post_id = $p_id";
if( !($result = $db->sql_query($sql)) ){message_die(GENERAL_ERROR, 'ERROR03', '', __LINE__, __FILE__, $sql);}
$chk_my_f = $db->sql_fetchrow($result);
$p_poster_id=$chk_my_f['poster_id'];
$post_time =$chk_my_f['post_time'];
if ($p_poster_id > 0){
$sql = "SELECT * FROM ".USERS_TABLE." WHERE user_id = $p_poster_id";
if( !($result = $db->sql_query($sql)) ){message_die(GENERAL_ERROR, 'ERROR04', '', __LINE__, __FILE__, $sql);}
$chk_my_f1 = $db->sql_fetchrow($result);
$post_username=$chk_my_f1['username'];
}else{
$post_username=$chk_my_f['post_username'];
}
$sql = "SELECT * FROM ".POSTS_TEXT_TABLE." WHERE post_id = $p_id";
if( !($result = $db->sql_query($sql)) ){message_die(GENERAL_ERROR, 'ERROR05', '', __LINE__, __FILE__, $sql);}
$chk_my_f = $db->sql_fetchrow($result);
$p_bbcode_uid=$chk_my_f['bbcode_uid'];
$p_post_subject=$chk_my_f['post_subject'];
$p_post_text=$chk_my_f['post_text'];
$p_text="作 者:".$post_username."
標 題:".$p_post_subject."
時 間:".date("Y-m-d H:i:s D",$post_time) ."
---------------------------------------------------
".$p_post_text;
$p_text1=bbencode_second_pass($p_text, $p_bbcode_uid);
$p_text2 = smilies_pass($p_text1);
$show_p_text=str_replace("
", "
<br />
", $p_text2);
if($mode=="add"){
$sql = "SELECT * FROM idea_archive WHERE top_id = $top_id Order By f_order DESC Limit 1";
$res=$db->sql_query($sql);
$row = $db->sql_fetchrow($res);
$new_order_id=($row['f_order'])+1;
$sql = "SELECT * FROM idea_archive Order By my_id DESC Limit 1";
$res=$db->sql_query($sql);
$row = $db->sql_fetchrow($res);
$new_my_id=($row['my_id'])+1;
$n_date=mktime();
$u_id=$userdata['user_id'];
$p_post_subject=$HTTP_POST_VARS['add_sub'];
$p_text=$HTTP_POST_VARS['add_text'];
$sql = "Insert idea_archive (f_id , my_id , top_id , f_order , style , sub , msg , bbcode_id , poster_id ,l_date)
Values ('$f','$new_my_id','$top_id','$new_order_id','1','$p_post_subject','$p_text','$p_bbcode_uid','$u_id','$n_date')";
$db->sql_query($sql);
$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
header($header_location . append_sid("viewtopic.$phpEx?p=".$p_id."#".$p_id, true));
exit;
}
$page_title = $lang['View_forum'] . ' - 版主管理 - 加入精華區' ;
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$sql = "SELECT * FROM idea_archive WHERE top_id = $top_id and f_id = $f Order By f_order ASC ";
if( !($result = $db->sql_query($sql)) ){message_die(GENERAL_ERROR, 'ERROR01', '', __LINE__, __FILE__);}
if ($top_id != 0){
$now_where = get_dir($top_id,$f);
}else{
$now_where="<a href=add_arc.php?p_id=".$p_id."&f=".$f."&top_id=".$top_id." class=mainmenu>精華區根目錄</a>";
}
echo "<table width=100% cellpadding=3 cellspacing=1 border=0 class=left_menu1>
<tr>
<td class=left_menu colspan=4><span class=gen>".$f_name." 精華區</td>
</tr>
<tr><td colspan=4 class=left_menu2><span class=mainmenu>現在位置 : $now_where</span></td></tr>
<tr>
<td class=left_menu2 width=20></td>
<td class=left_menu2><span class=mainmenu>分區 / 文章</td>
<td class=left_menu2 width=60><center><span class=mainmenu>整理者</td>
<td class=left_menu2 width=110><center><span class=mainmenu>整理時間</td>
</tr>";
\nif (mysql_num_rows($result) == 0 ){
echo "<tr><td colspan=4 class=left_menu2><center><span class=mainmenu><font color=ff0000>本分區裡面尚未有任何資料</span></td></tr>";
}else{
while( $row = $db->sql_fetchrow($result) )
{
if ($row['style'] == 0){
$icon="images/fo.gif";
$s_sub="<a href=add_arc.php?p_id=".$p_id."&f=".$f."&top_id=".$row['my_id']." class=mainmenu>".$row['sub']."</a>";
}else{
$icon="images/text.gif";
$s_sub="<span class=mainmenu>".$row['sub']."</span>";
}
$ch_id=$row['poster_id'];
$sql = "SELECT * FROM ".USERS_TABLE." WHERE user_id = '$ch_id' ";
$result1 = $db->sql_query($sql);
$row1 = $db->sql_fetchrow($result1);
$poster_id=$row1['username'];
$l_date=$row['l_date'];
$s_l_date=date("Y-n-j H:i",$l_date);
echo "<tr>
<td class=left_menu2 width=20><center><img src=".$icon."></td>
<td class=left_menu2>".$s_sub."</td>
<td class=left_menu2 width=60><center><a href=profile.php?mode=viewprofile&u=".$ch_id." class=mainmenu>".$poster_id."</a></td>
<td class=left_menu2 width=110><center><span class=mainmenu>".$s_l_date."</td>
</tr>";
}
}
echo "</table>";
echo "<table width=100 cellpadding=0 cellspacing=0 border=0><tr><td></td></tr></table>
<table width=100% cellpadding=3 cellspacing=1 border=0 class=left_menu1>
<form method=POST action=add_arc.php?mode=add&p_id=".$p_id."&top_id=".$top_id.">
<textarea rows=0 name=add_text cols=0 style="visibility:hidden;height:5;">".$p_text."</textarea>
<div style="visibility:hidden;"><input type=hidden name=add_sub value=".$p_post_subject."></div>
<tr><td class=left_menu><span class=gen>文章預覽
<input type=submit value=加入這個分區>
</td></tr><tr>
<td class=left_menu2><span class=mainmenu>";
echo $show_p_text;
echo "</td></tr></table>";
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
function del_all($id){
global $db;
$sql = "Delete From idea_archive WHERE my_id = $id ";
$db->sql_query($sql);
$sql = "SELECT * FROM idea_archive WHERE top_id = $id";
$result = $db->sql_query($sql);
while( $row = $db->sql_fetchrow($result) ){
$cc_id=$row['my_id'];
del_all($cc_id);
}
}
function get_dir($now_id,$f){
global $db;
global $p_id;
$now_where="";
$sql = "SELECT * FROM idea_archive WHERE my_id = $now_id";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
if (!$row['sub']){return "<a href=add_arc.php?p_id=".$p_id."&f=".$f."&top_id=0 class=mainmenu>精華區根目錄</a> > 無法找到該分區";}
$now_where=" > <a href=add_arc.php?p_id=".$p_id."&f=".$f."&top_id=".$now_id." class=mainmenu>".$row['sub']."</a>".$now_where;
if ($row['top_id'] != 0){
$now_where=get_dir($row['top_id'],$f).$now_where;
}else{
$now_where="<a href=add_arc.php?p_id=".$p_id."&f=".$f."&top_id=0 class=mainmenu>精華區根目錄</a>".$now_where;
}
return $now_where;
}
?>
?>代碼: 選擇全部
$sql = "SELECT * FROM idea_my_love WHERE f_id = $f";
$show_my_f="";
if( !($result = $db->sql_query($sql)) ){message_die(GENERAL_ERROR, 'ERROR', '', __LINE__, __FILE__, $sql);}
while( $row = $db->sql_fetchrow($result) )
{
echo "‧<a href=".$row['l_link']." class=mainmenu target=_blank>".$row['l_text']."</a><br>
";
}代碼: 選擇全部
while( $row = $db->sql_fetchrow($result) )代碼: 選擇全部
<tr>
<td width=150 valign=top height=100%>
<table border=1 width=150 cellspacing=0 cellpadding=0 class=forumline>
<tr><td width=150 class=row1><span class=gen>推薦連結</td></tr>
<tr><td class=row1>";
$sql = "SELECT * FROM idea_my_love WHERE f_id = $f";
$show_my_f="";
if( !($result = $db->sql_query($sql)) ){message_die(GENERAL_ERROR, 'ERROR', '', __LINE__, __FILE__, $sql);}
while( $row = $db->sql_fetchrow($result) )
{
echo "‧<a href=".$row['l_link']." class=mainmenu target=_blank>".$row['l_text']."</a><br>
";
}
echo "</td></tr>
</table>
</td>
<td width=100% valign=top>
<table border=0 width=100% cellspacing=1 cellpadding=0 class=forumline>
<tr>
<td class=row1 width=20></td>
<td class=row1 width=100%><span class=gen>分區 / 文章</td>
<td class=row1 width=100 nowrap=nowrap><center><span class=gen>整理者</td>
<td class=row1 width=120 nowrap=nowrap><center><span class=gen>整理時間</td>
</tr>";


包子兄~~如果我要在archvie.php 的 $my_body[13]內多一個{PUSHLINK}變數\r$chk_text = array(
"PUSHLINK" => "<a href=".$l_text." class=mainmenu target=_blank>".$l_link."</a><br>",
"SHOW_01" => "<img src=".$icon.">"
,"SHOW_02" => $s_sub
,"SHOW_03" => "<a href=profile.php?mode=viewprofile&u=".$ch_id." class=mainmenu>".$p_id."</a>"
,"SHOW_04" => $s_l_date
);
echo show_html($my_body[13],$chk_text);


這個要動到程式部分~design 寫:包子兄~~如果我要在archvie.php 的 $my_body[13]內多一個{PUSHLINK}變數\r$chk_text = array(
"PUSHLINK" => "<a href=".$l_text." class=mainmenu target=_blank>".$l_link."</a><br>",
"SHOW_01" => "<img src=".$icon.">"
,"SHOW_02" => $s_sub
,"SHOW_03" => "<a href=profile.php?mode=viewprofile&u=".$ch_id." class=mainmenu>".$p_id."</a>"
,"SHOW_04" => $s_l_date
);
echo show_html($my_body[13],$chk_text);
當作推薦連結用..我有改讓兩者都出現過,不過變成精華區只會出現"一行"不知道正確的程式碼要怎麼改![]()
![]()
資料庫不知道怎麼呼叫~@@
代碼: 選擇全部
呼叫SQL只需要用PHPBB已經寫好的函式
//sql 命令
$sql = "SELECT * FROM 表單名稱";
//送出要求 $res為MYSQL回傳值\r
$res=$db->sql_query($sql);
//將回傳值分析成陣列~
while( $row = $db->sql_fetchrow($res) )
{
echo $ow['表格名稱'];
}代碼: 選擇全部
if ($mo_ok){
$chk_text = array("MENU" => $mo_ok);
[color=red]$show_my_menu_01 [/color]= show_html($my_body[9],$chk_text);
}
if ($show_my_f){
$chk_text = array("MENU" => $show_my_f);
[color=red]$show_my_menu_02 [/color]= show_html($my_body[10],$chk_text);
}代碼: 選擇全部
$chk_text = array(
"SHOW_MY_LINK" => $show_my_menu_02
);
echo show_html($my_body[文件範本],$chk_text);