Add pictures to dedecms backend column

The icon needs to be displayed when calling the column at the front desk. Let’s organize it:

Step one: "System->SQL Command Tool", insert sql statement

alter table dede_arctype add imgtype varchar(<span style="color: #800080;">100</span>)

Step 2: Enter the background management file directory (default: dede directory), find line 228 under "catelog_add.php", and replace the default one with the following (added "typeimg" to the SQL statement)

    <span style="color: #800080;">$in_query</span> = "<span style="color: #000000;">INSERT INTO `#@__arctype`(reid,topid,sortrank,typename,typedir,isdefault,defaultname,issend,channeltype,
    tempindex,templist,temparticle,modname,namerule,namerule2,
    ispart,corank,description,keywords,seotitle,moresite,siteurl,sitepath,ishidden,`cross`,`crossid`,`content`,`smalltypes`,`typeimg`)
    VALUES('</span><span style="color: #800080;">$reid</span>','<span style="color: #800080;">$topid</span>','<span style="color: #800080;">$sortrank</span>','<span style="color: #800080;">$typename</span>','<span style="color: #800080;">$typedir</span>','<span style="color: #800080;">$isdefault</span>','<span style="color: #800080;">$defaultname</span>','<span style="color: #800080;">$issend</span>','<span style="color: #800080;">$channeltype</span><span style="color: #000000;">',
    '</span><span style="color: #800080;">$tempindex</span>','<span style="color: #800080;">$templist</span>','<span style="color: #800080;">$temparticle</span>','default','<span style="color: #800080;">$namerule</span>','<span style="color: #800080;">$namerule2</span><span style="color: #000000;">',
    '</span><span style="color: #800080;">$ispart</span>','<span style="color: #800080;">$corank</span>','<span style="color: #800080;">$description</span>','<span style="color: #800080;">$keywords</span>','<span style="color: #800080;">$seotitle</span>','<span style="color: #800080;">$moresite</span>','<span style="color: #800080;">$siteurl</span>','<span style="color: #800080;">$sitepath</span>','<span style="color: #800080;">$ishidden</span>','<span style="color: #800080;">$cross</span>','<span style="color: #800080;">$crossid</span>','<span style="color: #800080;">$content</span>','<span style="color: #800080;">$smalltypes</span>','<span style="color: #800080;">$typeimg</span>')";

Step 3: Find line 36 under "catelog_edit.php" and replace the default with the following (added "typeimg" to the SQL statement)

    <span style="color: #800080;">$upquery</span> = "<span style="color: #000000;">UPDATE `#@__arctype` SET
     issend='</span><span style="color: #800080;">$issend</span><span style="color: #000000;">',
     sortrank='</span><span style="color: #800080;">$sortrank</span><span style="color: #000000;">',
     typename='</span><span style="color: #800080;">$typename</span><span style="color: #000000;">',
     typedir='</span><span style="color: #800080;">$typedir</span><span style="color: #000000;">',
     isdefault='</span><span style="color: #800080;">$isdefault</span><span style="color: #000000;">',
     defaultname='</span><span style="color: #800080;">$defaultname</span><span style="color: #000000;">',
     issend='</span><span style="color: #800080;">$issend</span><span style="color: #000000;">',
     ishidden='</span><span style="color: #800080;">$ishidden</span><span style="color: #000000;">',
     channeltype='</span><span style="color: #800080;">$channeltype</span><span style="color: #000000;">',
     tempindex='</span><span style="color: #800080;">$tempindex</span><span style="color: #000000;">',
     templist='</span><span style="color: #800080;">$templist</span><span style="color: #000000;">',
     temparticle='</span><span style="color: #800080;">$temparticle</span><span style="color: #000000;">',
     namerule='</span><span style="color: #800080;">$namerule</span><span style="color: #000000;">',
     namerule2='</span><span style="color: #800080;">$namerule2</span><span style="color: #000000;">',
     ispart='</span><span style="color: #800080;">$ispart</span><span style="color: #000000;">',
     corank='</span><span style="color: #800080;">$corank</span><span style="color: #000000;">',
     description='</span><span style="color: #800080;">$description</span><span style="color: #000000;">',
     keywords='</span><span style="color: #800080;">$keywords</span><span style="color: #000000;">',
     seotitle='</span><span style="color: #800080;">$seotitle</span><span style="color: #000000;">',
     moresite='</span><span style="color: #800080;">$moresite</span><span style="color: #000000;">',
     `cross`='</span><span style="color: #800080;">$cross</span><span style="color: #000000;">',
     `content`='</span><span style="color: #800080;">$content</span><span style="color: #000000;">',
     `crossid`='</span><span style="color: #800080;">$crossid</span><span style="color: #000000;">',
     `typeimg`='</span><span style="color: #800080;">$typeimg</span><span style="color: #000000;">',
     `smalltypes`='</span><span style="color: #800080;">$smalltypes</span><span style="color: #000000;">'
     </span><span style="color: #800080;">$uptopsql</span><span style="color: #000000;">
    WHERE id='</span><span style="color: #800080;">$id</span>' ";

Step 4: Enter the "catalog_add.htm and catalog_edit.htm" files under the background management file directory (default: dede directory)/templets/, and then add the following code:

<span style="color: #0000ff;"><</span><span style="color: #800000;">script </span><span style="color: #ff0000;">language</span><span style="color: #0000ff;">='javascript' </span><span style="color: #ff0000;">src</span><span style="color: #0000ff;">="js/main.js"</span><span style="color: #0000ff;">></</span><span style="color: #800000;">script</span><span style="color: #0000ff;">></span>

And add the following code where you want to place it:

            <span style="color: #0000ff;"><</span><span style="color: #800000;">tr</span><span style="color: #0000ff;">></span>
                <span style="color: #0000ff;"><</span><span style="color: #800000;">td </span><span style="color: #ff0000;">colspan</span><span style="color: #0000ff;">="2"</span><span style="color: #0000ff;">></span>
                    <span style="color: #0000ff;"><</span><span style="color: #800000;">table </span><span style="color: #ff0000;">width</span><span style="color: #0000ff;">="100%"</span><span style="color: #ff0000;"> border</span><span style="color: #0000ff;">="0"</span><span style="color: #ff0000;"> cellspacing</span><span style="color: #0000ff;">="0"</span><span style="color: #ff0000;"> cellpadding</span><span style="color: #0000ff;">="0"</span><span style="color: #ff0000;"> style</span><span style="color: #0000ff;">="margin-bottom:3px;"</span><span style="color: #0000ff;">></span>
                        <span style="color: #0000ff;"><</span><span style="color: #800000;">tbody</span><span style="color: #0000ff;">></span>
                            <span style="color: #0000ff;"><</span><span style="color: #800000;">tr</span><span style="color: #0000ff;">></span> 
                                <span style="color: #0000ff;"><</span><span style="color: #800000;">td </span><span style="color: #ff0000;">width</span><span style="color: #0000ff;">="90"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="bline"</span><span style="color: #ff0000;"> height</span><span style="color: #0000ff;">="24"</span><span style="color: #0000ff;">></span><span style="color: #ff0000;"> </span>imgmm：<span style="color: #0000ff;"></</span><span style="color: #800000;">td</span><span style="color: #0000ff;">></span>
                                <span style="color: #0000ff;"><</span><span style="color: #800000;">td </span><span style="color: #ff0000;">class</span><span style="color: #0000ff;">="bline"</span><span style="color: #0000ff;">></span>
                                    <span style="color: #0000ff;"><</span><span style="color: #800000;">input </span><span style="color: #ff0000;">type</span><span style="color: #0000ff;">="text"</span><span style="color: #ff0000;"> name</span><span style="color: #0000ff;">="typeimg"</span><span style="color: #ff0000;"> id</span><span style="color: #0000ff;">="imgmm"</span><span style="color: #ff0000;"> style</span><span style="color: #0000ff;">="width:300px"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="text"</span> <span style="color: #0000ff;">/></span> 
                                    <span style="color: #0000ff;"><</span><span style="color: #800000;">input </span><span style="color: #ff0000;">name</span><span style="color: #0000ff;">="imgmm_bt"</span><span style="color: #ff0000;"> type</span><span style="color: #0000ff;">="button"</span><span style="color: #ff0000;"> class</span><span style="color: #0000ff;">="inputbut"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="浏览..."</span><span style="color: #ff0000;"> onclick</span><span style="color: #0000ff;">="SelectImage('form1.imgmm','big')"</span> <span style="color: #0000ff;">/></span>
                                <span style="color: #0000ff;"></</span><span style="color: #800000;">td</span><span style="color: #0000ff;">></span>
                            <span style="color: #0000ff;"></</span><span style="color: #800000;">tr</span><span style="color: #0000ff;">></span>
                        <span style="color: #0000ff;"></</span><span style="color: #800000;">tbody</span><span style="color: #0000ff;">></span>
                    <span style="color: #0000ff;"></</span><span style="color: #800000;">table</span><span style="color: #0000ff;">></span>
                    <span style="color: #0000ff;"><</span><span style="color: #800000;">input </span><span style="color: #ff0000;">type</span><span style="color: #0000ff;">="hidden"</span><span style="color: #ff0000;"> name</span><span style="color: #0000ff;">="dede_addonfields"</span><span style="color: #ff0000;"> value</span><span style="color: #0000ff;">="imgmm,img"</span> <span style="color: #0000ff;">/></span>
                <span style="color: #0000ff;"></</span><span style="color: #800000;">td</span><span style="color: #0000ff;">></span>
            <span style="color: #0000ff;"></</span><span style="color: #800000;">tr</span><span style="color: #0000ff;">></span>

Step 5: Call the column channel tag call, so you need to change it. Enter the /include/taglib/channel.lib.php file, find line 78, and replace the following code with the default (add typeimg field query)

    <span style="color: #0000ff;">if</span>(<span style="color: #800080;">$type</span>=='top'<span style="color: #000000;">)
    {
        </span><span style="color: #800080;">$sql</span> = "<span style="color: #000000;">SELECT id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath,typeimg
          From `#@__arctype` WHERE reid=0 And ishidden<>1 order by sortrank asc limit 0, </span><span style="color: #800080;">$line</span> "<span style="color: #000000;">;
    }
    </span><span style="color: #0000ff;">else</span> <span style="color: #0000ff;">if</span>(<span style="color: #800080;">$type</span>=='son'<span style="color: #000000;">)
    {
        </span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$typeid</span>==0) <span style="color: #0000ff;">return</span> ''<span style="color: #000000;">;
        </span><span style="color: #800080;">$sql</span> = "<span style="color: #000000;">SELECT id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath,content,typeimg
          From `#@__arctype` WHERE reid='</span><span style="color: #800080;">$typeid</span>' And ishidden<>1 order by sortrank asc limit 0, <span style="color: #800080;">$line</span> "<span style="color: #000000;">;
    }
    </span><span style="color: #0000ff;">else</span> <span style="color: #0000ff;">if</span>(<span style="color: #800080;">$type</span>=='self'<span style="color: #000000;">)
    {
        </span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$reid</span>==0) <span style="color: #0000ff;">return</span> ''<span style="color: #000000;">;
        </span><span style="color: #800080;">$sql</span> = "<span style="color: #000000;">SELECT id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath,typeimg
            FROM `#@__arctype` WHERE reid='</span><span style="color: #800080;">$reid</span>' And ishidden<>1 order by sortrank asc limit 0, <span style="color: #800080;">$line</span> "<span style="color: #000000;">;
    }</span>

The last step: call it at the front desk

        {dede:channel type='self' typeid='15' row='8' currentstyle="<li><a href='~typelink~' class='thisclass'>~typename~</a> </li>"<span style="color: #000000;">} 
        </span><li><a href='[field:typelink/]'>[field:typename/]</a> <img src='[field:typeimg/]' /></li><span style="color: #000000;"> 
        {</span>/dede:channel}