首页n格的问题整理与解决[最后更新:2007.11.05 JS调用附件]

习明兄！我照你10.11楼作了修改，我的四格图片是显示了但每次显示一个就不动了，也不更换，一直就是一个！请帮忙看一下！我的pic.php文件是这样的:

1. <?php
   
2. /*
   
3. design by Clement
   
4. */
   
5. 
   
6. //---设置---start
   
7. $shownums = 6;//演示个数,超过6则无法使用导航条.
   
8. $searchnums = 100;//搜索总数.
   
9. $cachelife = 1800;//按照自己的实际情况设置，默认为1800秒.
   
10. $orderby = 'dateline';//搜索顺序.按照日期搜索输入dateline.按照浏览次数输入downloads.随机搜索请输入rand.
    
11. $cachename = 'showpic';//缓存名.若与何插件冲突请修改,只要不冲突不会影响使用.
    
12. $searchfid = '';//搜索范围.不限制留空.请用逗号相隔,如'1,2,3'.
    
13. //---设置---end
    
14. 
    
15. 
    
16. if((@!include('forumdata/cache/cache_'.$cachename.'.php')) || $expiration < time() || $cacheshownums != $shownums || $cachesearchnums != $searchnums || $cachecachelife != $cachelife || $cacheorderby != $orderby || $cachecachename != $cachename || $cachesearchfid != $searchfid) {
    
17.         require_once './include/common.inc.php';
    
18.         $orderby = $orderby != 'rand' ? 'attach.'.$orderby : 'rand()';
    
19.         $fids = $searchfid ? 'AND '."t.fid IN ($searchfid)" : '';
    
20.         $data = array();
    
21. $query = $db->query("SELECT attach.aid, attach.thumb, attach.attachment, t.tid, t.fid, t.subject FROM {$tablepre}attachments attach LEFT JOIN {$tablepre}threads t ON t.displayorder>=0 AND t.tid=attach.tid WHERE attach.readperm='0' AND displayorder>='0' AND filetype='image/pjpeg' $fids GROUP BY attach.tid ORDER BY $orderby DESC LIMIT $searchnums");
    
22.         while ($pic = $db->fetch_array($query)) {
    
23.                 $data['pic'][$pic[aid]]['showpicpics'] = $attachurl.'/'.$pic['attachment'].($pic['thumb'] ? 'thumb.jpg' : "");
    
24.                 $data['pic'][$pic[aid]]['showpiclinks'] = "viewthread.php?tid=$pic[tid]";
    
25.                 $data['pic'][$pic[aid]]['showpictexts'] = str_replace('\'', '&nbsp;',$pic['subject']);
    
26.         }
    
27.         $data['expiration'] = $cachelife + time();
    
28.         $data['cacheshownums'] = $shownums;
    
29.         $data['cachesearchnums'] = $searchnums;
    
30.         $data['cachecachelife'] = $cachelife;
    
31.         $data['cacheorderby'] = $orderby;
    
32.         $data['cachecachename'] = $cachename;
    
33.         $data['cachesearchfid'] = $searchfid;
    
34.         require_once DISCUZ_ROOT.'./include/cache.func.php';
    
35.         writetocache($cachename, '', getcachevars($data));
    
36.         include(DISCUZ_ROOT.'./forumdata/cache/cache_'.$cachename.'.php');
    
37. }
    
38. 
    
39. shuffle($pic);
    
40. $i = 0;
    
41. $j = 0;
    
42. while ($j < $shownums && isset($pic[$i])) {
    
43.         if(is_readable($pic[$i]['showpicpics'])) {
    
44.                 $showpicpics .= $comma.$pic[$i]['showpicpics'];
    
45.                 $showpiclinks .= $comma.$pic[$i]['showpiclinks'];
    
46.                 $showpictexts .= $comma.$pic[$i]['showpictexts'];
    
47.                 $comma = '|';
    
48.                 $j++;
    
49.         }
    
50.         $i++;
    
51. }
    
52. ?>
    
53. <script language="JavaScript">
    
54. var focus_width=245
    
55. var focus_height=140
    
56. var text_height=20
    
57. var swf_height = focus_height+text_height
    
58. var pics = '<?=$showpicpics?>';
    
59. var links = '<?=$showpiclinks?>';
    
60. var texts = '<?=$showpictexts?>';
    
61. document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">');
    
62. document.write('<param name="allowScriptAccess" value="sameDomain"><param name="movie" value="images/pixviewer.swf"><param name="quality" value="high"><param name="bgcolor" value="#FFFFFF">');
    
63. document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
    
64. document.write('<param name="FlashVars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'">');
    
65. document.write('<embed src="images/pixviewer.swf" wmode="opaque" FlashVars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#FFFFFF" quality="high" width="'+ focus_width +'" height="'+ focus_height +'" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />');document.write('</object>');
    
66. </script>

复制代码

我的论论是http://www.whfoxconn.cn/forum/index.php

顶啊
支持支持支持支持

首页四格中怎么加入图片展示呢?

請問大大
我的論壇是安裝美化首頁六格
在更新0724補丁後發現無法開啟論壇的問題
問題好像是在於index.php
根據補丁前修改的語法要我們在index.php裡尋找
"$searchboxstatus = substr(sprintf('%03b', $qihoo_searchbox), -1, 1);"
然後再上面增加新的修改語法
可是在0724補丁的index.php卻只找到
"$searchboxstatus = $qihoo_searchbox & 1;"
就出現無法開啟論壇的問題,請問大大有辦法幫忙解決嗎..?
p.s忘記把錯誤訊息複製下來了....

没太明白 改了什么

先恢复一下 保证论坛的正常使用 最好是本地建一个模拟的论坛做测试 测试好再 传到服务器

Discuz! info: MySQL Query Error

User: 玧?
Time: 2007-8-20 11:25am
Script: /index.php

SQL: SELECT t.*, f.name FROM [Table]threads t, [Table]forums f WHERE t.fid<>'0' AND f.fid=t.fid AND f.fid NOT IN () AND t.displayorder>=0 ORDER BY t.dateline DESC LIMIT 0, 10
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND t.displayorder>=0 ORDER BY t.dateline DESC LIMIT 0, 10' at
Errno.: 1064

Similar error report has beed dispatched to administrator before.

原帖由 习明 于 2007-8-20 09:21 发表
先恢复一下 保证论坛的正常使用 最好是本地建一个模拟的论坛做测试 测试好再 传到服务器

已經把論壇復原回更新前的版本
不知道大大有沒有解決的辦法..?

一直找不齊建立論壇的軟體
所以無法於本機先做測試....@@"

顶起啊

http://www.myswpu.com
西南石油大学论坛招友情连接，有意这Q我！

后台没有设置不显示的版块，解决办法看顶楼。