解决帝国 CMS7.5 升级到 8.0 后，使用图片模型的栏目新增编辑内容没法加载的问题

前段时间将之前所有的帝国 CMS7.5 的站点，全部批量升级至 8.0。升级完成后，登录系统后台测试基本上没有问题。

最近给一个站点新增内容，发现使用“图片系统数据表 (phome_ecms_photo)”的栏目，新增和编辑内容均无法加载内容。而使用“新闻系统数据表 (phome_ecms_news)”的栏目，则没有这个问题。

咨询豆包尝试解决问题，均是答非所问，都没有能解决问题。帝国论坛搜索搜索前人是否有同样问题。

于是，就有了下面的解决方案：图片模型的图片集 morepic，8.0 的代码跟 7.5 的不一样，安装一个 8.0 的系统，把 morepic 的代码拷贝到升级后的网站后台对应位置即可。

输入表单替换html代码：

<script>
function dopicadd()
{var i;
var str="";
var oldi=0;
var j=0;
oldi=parseInt(document.add.morepicnum.value);
for(i=1;i<=document.add.downmorepicnum.value;i++)
{
j=i+oldi;
str=str+"<tr><td width=7%><div align=center>"+j+"</div></td><td width=33%><div align=center><input name=msmallpic[] type=text size=28 id=msmallpic"+j+" ondblclick=SpOpenChFile(1,'msmallpic"+j+"')><br><input type=file name=msmallpfile[] size=15></div></td><td width=30%><div align=center><input name=mbigpic[] type=text size=28 id=mbigpic"+j+" ondblclick=SpOpenChFile(1,'mbigpic"+j+"')><br><input type=file name=mbigpfile[] size=15></div></td><td width=30%><div align=center><input name=mpicname[] type=text></div></td></tr>";
}
document.getElementById("addpicdown").innerHTML="<table width='100%' border=0 cellspacing=1 cellpadding=3>"+str+"</table>";
}
</script>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="25">
    图片地址前缀:
      <input name="mpicurl_qz" type="text" id="mpicurl_qz">&nbsp;&nbsp;
      <input type="checkbox" name="msavepic" value="1">远程保存&nbsp;<input type="checkbox" name="mcreatespic" value="1" onclick="if(this.checked){setmcreatespic.style.display='';}else{setmcreatespic.style.display='none';}">生成缩图
      <span id="setmcreatespic" style="display:none">：<input type=text name="mcreatespicwidth" size=4 value="<?=$public_r['spicwidth']?>">*<input type=text name="mcreatespicheight" size=4 value="<?=$public_r['spicheight']?>">(宽*高)</span>
<?php
if(TranmoreIsOpen())
{
?>
<input type="button" name="Submit" value="多选上传" onclick="window.open('ecmseditor/tranmore/tranmore.php?type=1&classid=<?=$classid?>&filepass=<?=$filepass?>&infoid=<?=$id?>&modtype=0&sinfo=1&ecmsdo=ecmstmmorepic&tranfrom=2<?=$ecms_hashur['ehref']?>&oldmorepicnum='+document.add.morepicnum.value,'ecmstmpage','width=700,height=550,scrollbars=yes');">
<?php
}
?>
 </td>
  </tr>
  <tr> 
    <td><table width="100%" border=0 align=center cellpadding=3 cellspacing=1>
  <tr bgcolor="#DBEAF5"> 
    <td width="7%"><div align=center>编号</div></td>
    <td width="33%"><div align=center>缩图 <font color="#666666">(双击选择)</font></div></td>
    <td width="30%"><div align=center>大图 <font color="#666666">(双击选择)</font></div></td>
    <td width="30%"><div align=center>图片说明</div></td>
  </tr>
</table></td>
  </tr>
  <tr> 
    <td id=defmorepicid>
    <?php
    if($ecmsfirstpost==1)
    {
    ?>
    <table width='100%' border=0 align=center cellpadding=3 cellspacing=1>
    <?php
    $morepicnum=3;
    for($mppathi=1;$mppathi<=$morepicnum;$mppathi++)
    {
    ?>
    <tr> 
        <td width='7%'><div align=center><?=$mppathi?></div></td>
        <td width='33%'><div align=center>
        <input name=msmallpic[] type=text id='msmallpic<?=$mppathi?>' size=28 ondblclick="SpOpenChFile(1,'msmallpic<?=$mppathi?>');">
        <br><input type=file name=msmallpfile[] size=15>
        </div></td>
        <td width='30%'><div align=center>
        <input name=mbigpic[] type=text id='mbigpic<?=$mppathi?>' size=28 ondblclick="SpOpenChFile(1,'mbigpic<?=$mppathi?>');">
        <br><input type=file name=mbigpfile[] size=15>
        </div></td>
        <td width='30%'><div align=center>
        <input name=mpicname[] type=text id='mpicname<?=$mppathi?>'>
        </div></td>
    </tr>
    <?php
    }
    ?>
    </table>
    <?php
    }
    else
    {
    $morepicpath="";
    $morepicnum=0;
    if($r['morepic'])
        {
            $r['morepic']=ehtmlspecialchars(stripSlashes($r['morepic']));
            //地址
            $j=0;
            $pd_record=explode("\r\n",$r['morepic']);
            for($i=0;$i<count($pd_record);$i++)
            {
            $j=$i+1;
                $pd_field=explode("::::::",$pd_record[$i]);
            $morepicpath.="<tr> 
    <td width='7%'><div align=center>".$j."</div></td>
    <td width='33%'><div align=center>
        <input name=msmallpic[] type=text value='".$pd_field[0]."' size=28 id=msmallpic".$j." ondblclick=\"SpOpenChFile(1,'msmallpic".$j."');\">
        <br><input type=file name=msmallpfile[] size=15>
      </div></td>
    <td width='30%'><div align=center>
        <input name=mbigpic[] type=text value='".$pd_field[1]."' size=28 id=mbigpic".$j." ondblclick=\"SpOpenChFile(1,'mbigpic".$j."');\">
        <br><input type=file name=mbigpfile[] size=15>
      </div></td>
    <td width='30%'><div align=center>
        <input name=mpicname[] type=text value='".$pd_field[2]."'><input type=hidden name=mpicid[] value=".$j."><input type=checkbox name=mdelpicid[] value=".$j.">删
      </div></td>
  </tr>";
            }
            $morepicnum=$j;
            $morepicpath="<table width='100%' border=0 cellspacing=1 cellpadding=3>".$morepicpath."</table>";
        }
    echo $morepicpath;
    }
    ?>
    </td>
  </tr>
  <tr> 
    <td height="25">地址扩展数量: <input name="morepicnum" type="hidden" id="morepicnum" value="<?=$morepicnum?>">
      <input name="downmorepicnum" type="text" value="1" size="6"> <input type="button" name="Submit5" value="输出地址" onclick="javascript:dopicadd();"></td>
  </tr>
  <tr> 
    <td id=addpicdown></td>
  </tr>
</table>

投稿表单替换html代码：

<script>
function dopicadd()
{var i;
var str="";
var oldi=0;
var j=0;
oldi=parseInt(document.add.morepicnum.value);
for(i=1;i<=document.add.downmorepicnum.value;i++)
{
j=i+oldi;
str=str+"<tr><td width=7%><div align=center>"+j+"</div></td><td width=33%><div align=center><input name=msmallpic[] type=text size=28 id=msmallpic"+j+"></div></td><td width=30%><div align=center><input name=mbigpic[] type=text size=28 id=mbigpic"+j+"></div></td><td width=30%><div align=center><input name=mpicname[] type=text></div></td></tr>";
}
document.getElementById("addpicdown").innerHTML="<table width='100%' border=0 cellspacing=1 cellpadding=3>"+str+"</table>";
}
</script>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="25">
    图片地址前缀:
      <input name="mpicurl_qz" type="text" id="mpicurl_qz" size="32">
      &nbsp;</td>
  </tr>
  <tr> 
    <td><table width=100% border=0 align=center cellpadding=3 cellspacing=1>
  <tr bgcolor='#DBEAF5'> 
    <td width=7%><div align=center>编号</div></td>
    <td width=33%><div align=center>缩图</div></td>
    <td width=30%><div align=center>大图</div></td>
    <td width=30%><div align=center>图片说明</div></td>
  </tr>
</table></td>
  </tr>
  <tr> 
    <td id=defmorepicid> 
    <?php
    if($ecmsfirstpost==1)
    {
    ?>
    <table width='100%' border=0 align=center cellpadding=3 cellspacing=1>
    <?php
    $morepicnum=3;
    for($mppathi=1;$mppathi<=$morepicnum;$mppathi++)
    {
    ?>
    <tr> 
        <td width='7%'><div align=center><?=$mppathi?></div></td>
        <td width='33%'><div align=center>
        <input name=msmallpic[] type=text id=msmallpic[] size=28>
        </div></td>
        <td width='30%'><div align=center>
        <input name=mbigpic[] type=text id=mbigpic[] size=28>
        </div></td>
        <td width='30%'><div align=center>
        <input name=mpicname[] type=text id=mpicname[]>
        </div></td>
    </tr>
    <?php
    }
    ?>
    </table>
    <?php
    }
    else
    {
    $morepicpath="";
    $morepicnum=0;
    if($r['morepic'])
    {
        $r['morepic']=ehtmlspecialchars(stripSlashes($r['morepic']));
        //地址
        $j=0;
        $pd_record=explode("\r\n",$r['morepic']);
        for($i=0;$i<count($pd_record);$i++)
        {
            $j=$i+1;
            $pd_field=explode("::::::",$pd_record[$i]);
            $morepicpath.="<tr> 
    <td width='7%'><div align=center>".$j."</div></td>
    <td width='33%'><div align=center>
        <input name=msmallpic[] type=text value='".$pd_field[0]."' size=28>
      </div></td>
    <td width='30%'><div align=center>
        <input name=mbigpic[] type=text value='".$pd_field[1]."' size=28>
      </div></td>
    <td width='30%'><div align=center>
        <input name=mpicname[] type=text value='".$pd_field[2]."'><input type=hidden name=mpicid[] value=".$j."><input type=checkbox name=mdelpicid[] value=".$j.">删
      </div></td></tr>";
        }
        $morepicnum=$j;
        $morepicpath="<table width='100%' border=0 cellspacing=1 cellpadding=3>".$morepicpath."</table>";
    }
    echo $morepicpath;
    }
    ?>
    </td>
  </tr>
  <tr> 
    <td height="25">地址扩展数量: <input name="morepicnum" type="hidden" id="morepicnum" value="<?=$morepicnum?>">
      <input name="downmorepicnum" type="text" value="1" size="6"> <input type="button" name="Submit5" value="输出地址" onclick="javascript:dopicadd();"></td>
  </tr>
  <tr> 
    <td id=addpicdown></td>
  </tr>
</table>