Question about dede5.7 calling discuzx2.5 pasting sub-images dedede5.7 calling discuzx2.5 pasting sub-images HTMLcode {dede: looptable = & quot; pre_forum_thread & quot; fid = & quot; 2. question about dede 5.7 calling discuz x2.5 to post a sub-image
Dede 5.7 calls discuz x2.5 to post sub-images
HTML code
{dede:loop table="pre_forum_thread" fid="2″sort="tid" row="10"}{/dede:loop}
This successful code calls the post of the specified ID2 section, but the cover image of the post is not called successfully, and the alt of the image is called (alt = "[field: subject/]").
------ Solution --------------------
The pre_forum_thread table has no image path.
{Dede: SQL = "SELECT 'cdb _ attachments '. 'aid ', 'cdb _ attachments '. 'attachment', 'cdb _ threads '. 'tid', 'cdb _ threads '. 'fid', 'cdb _ threads '. 'subobject' FROM 'cdb _ attachments 'left JOIN 'cdb _ threads'
ON 'cdb _ threads '. 'tid' = 'cdb _ attachments '. 'tid' WHERE 'cdb _ attachments '. 'readperm' = '0' AND 'displayorder'> = '0' AND 'filetype' = 'image/pjpeg 'group by tid LIMIT 0, 1 "}
{/Dede: SQL} refer
