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

全新安装首页多格调用（图片缩略图+最新最热+日志）修正版 FOR DZ5.5首页无法打开，出再下面错误！！

Discuz! info: MySQL Query Error

User: okxing
Time: 2007-8-6 10:39pm
Script: /index.php

SQL: SELECT t.itemid,t.uid,t.username,t.type,t.subject,t.dateline,t.lastpost,t.viewnum,t.replynum,t.folder, f.name FROM supe_spaceitems t, supe_categories f WHERE f.catid=t.catid AND t.catid NOT IN(1,2,3,4,5,6,7,8,9) AND folder=1 ORDER BY dateline DESC LIMIT 0, 10
Error: Table 'bbs.supe_spaceitems' doesn't exist
Errno: 1146

Similar error report has beed dispatched to administrator before.

但卸掉相关操作，论坛正常！

[ 本帖最后由 okxing 于 2007-8-6 22:47 编辑 ]

和ss有关 请确认是否安装了ss且在和dz使用同一数据库

大哥，你好！
我安装的是：https://discuz.dismall.com/thread-688748-16-5.html  首页四格。
我想自己设置首页四格图片，不想调用。。不知道怎么修改？
按照 插件主人的方法安装的。 没有更改过任何文件。~~~~
我的 pic.php 是这样的
<?php
//---设置---start
$shownums = 6;//演示个数,超过6则无法使用导航条.
$searchnums = 100;//搜索总数.
$cachelife = 1800;//按照自己的实际情况设置，默认为1800秒.
$orderby = 'rand';//搜索顺序.按照日期搜索输入dateline.按照浏览次数输入downloads.随机搜索请输入rand.
$cachename = 'showpic';//缓存名.若与何插件冲突请修改,只要不冲突不会影响使用.
$searchfid = '';//搜索范围.不限制留空.请用逗号相隔,如'1,2,3'.
//---设置---end


if((@!include('forumdata/cache/cache_'.$cachename.'.php')) || $expiration < time() || $cacheshownums != $shownums || $cachesearchnums != $searchnums || $cachecachelife != $cachelife || $cacheorderby != $orderby || $cachecachename != $cachename || $cachesearchfid != $searchfid) {
        require_once './include/common.inc.php';
        $orderby = $orderby != 'rand' ? 'attach.'.$orderby : 'rand()';
        $fids = $searchfid ? 'AND '."t.fid IN ($searchfid)" : '';
        $data = array();
        $query = $db->query("SELECT attach.aid, 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");
        while ($pic = $db->fetch_array($query)) {
                $data['pic'][$pic[aid]]['showpicpics'] = $attachurl.'/'.$pic['attachment'];
                $data['pic'][$pic[aid]]['showpiclinks'] = "viewthread.php?tid=$pic[tid]";
                $data['pic'][$pic[aid]]['showpictexts'] = str_replace('\'', '&nbsp;',$pic['subject']);
        }
        $data['expiration'] = $cachelife + time();
        $data['cacheshownums'] = $shownums;
        $data['cachesearchnums'] = $searchnums;
        $data['cachecachelife'] = $cachelife;
        $data['cacheorderby'] = $orderby;
        $data['cachecachename'] = $cachename;
        $data['cachesearchfid'] = $searchfid;
        require_once DISCUZ_ROOT.'./include/cache.func.php';
        writetocache($cachename, '', getcachevars($data));
        include(DISCUZ_ROOT.'./forumdata/cache/cache_'.$cachename.'.php');
}

shuffle($pic);
$i = 0;
$j = 0;
while ($j < $shownums && isset($pic[$i])) {
        if(is_readable($pic[$i]['showpicpics'])) {
                $showpicpics .= $comma.$pic[$i]['showpicpics'];
                $showpiclinks .= $comma.$pic[$i]['showpiclinks'];
                $showpictexts .= $comma.$pic[$i]['showpictexts'];
                $comma = '|';
                $j++;
        }
        $i++;
}
?>
<script language="JavaScript">
var focus_width=300
var focus_height=174
var text_height=20
var swf_height = focus_height+text_height
var pics = '<?=$showpicpics?>';
var links = '<?=$showpiclinks?>';
var texts = '<?=$showpictexts?>';
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 +'">');
document.write('<param name="allowScriptAccess" value="sameDomain"><param name="movie" value="images/pixviewer.swf"><param name="quality" value="high"><param name="bgcolor" value="#FFFFFF">');
document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
document.write('<param name="FlashVars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'">');
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>');
</script>

删除<script language="JavaScript">之前的内容
修改：
var pics = '<?=$showpicpics?>';
var links = '<?=$showpiclinks?>';
var texts = '<?=$showpictexts?>';
为：
var pics="图片URL1|图片URL2|图片URL3|图片URL4";
var links="链接URL1|链接URL2|链接URL3|链接URL4";
var texts="文字1|文字2|文字3|文字4";
其中的内容按需要填写 不过要换图片和文字就需要再次编辑文件

不调用指定某版面的图片 把AND f.fid NOT IN (*)
该放在哪里呢？

谢谢

前一页 或首贴里找

原帖由 stheng123 于 2007-8-5 08:38 PM 发表
此帖已解决问题！感谢刁明解答。使用方法如下：

请怎么卸载？·····

没有数据库升级的直接删除添加代码和文件即可.

带有数据库升级的,一般都有卸载代码.

我使用了这个不带后台的四格之后，为什么出现这样的问题？



有一半文字正常，有一半不正常？


原贴地址：https://discuz.dismall.com/viewth ... =22&extra=#zoom
也没有像搂主所说的那样用记事本修改，模版文件都是用DW修改的

[ 本帖最后由 龟兹热线 于 2007-8-10 20:12 编辑 ]