Adding Images to Boardindex

[Fizzy]

Hi guys,

I was looking for a way to add a gif at the start of each Board Description.
I couldn't find anything to do what I wanted but got inpiration from a Mod Request for Category clickable icons.

This isn't a mod, by a long stretch of the imagination, this is just a "Me sharing how I stumbled through and came up with a solution" type thing.

OK, Open MySQL tables, edit "Boards" table and add a field called "boardpic"
In that field add image urls.

Then, open BoardIndex in your editor and locate

Code Select Expand


      SELECT DISTINCT c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.description, b.moderators, b.numPosts, b.numTopics, c.memberGroups, m.posterName, m.posterTime, m.subject, t.ID_TOPIC, t.numReplies, IFNULL(mem.realName, m.posterName) AS realName, IFNULL(lb.logTime, 0) AS boardTime, IFNULL(lmr.logTime, 0) AS markReadTime, IFNULL(mem.ID_MEMBER, -1) AS ID_MEMBER


add

Code Select Expand


b.boardpic

so you then should have something like

Code Select Expand


      SELECT DISTINCT c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.description, b.boardpic, b.moderators, b.numPosts, b.numTopics, c.memberGroups, m.posterName, m.posterTime, m.subject, t.ID_TOPIC, t.numReplies, IFNULL(mem.realName, m.posterName) AS realName, IFNULL(lb.logTime, 0) AS boardTime, IFNULL(lmr.logTime, 0) AS markReadTime, IFNULL(mem.ID_MEMBER, -1) AS ID_MEMBER


locate

Code Select Expand


<a name="b' . $row_board['ID_BOARD'] . '"></a>
<font size="2"><b><a href="' . $scripturl . '?board=' . $row_board['ID_BOARD'] . '">


And immediately insert

Code Select Expand


<img src="' . $row_board['boardpic'] . '" alt="" border="0">'.


so you should have something like

Code Select Expand


                     <a name="b' . $row_board['ID_BOARD'] . '"></a>
                     <font size="2"><b><a href="' . $scripturl . '?board=' . $row_board['ID_BOARD'] . '"><img src="' . $row_board['boardpic'] . '" alt="" border="0">'. $row_board['boardName'] . '</a></b><br />
                     ' . $row_board['description'] . '</font>' . $showmods . '
                  </td>


Works a treat for me, but as I say, this is not a mod as I can't help with any tweaks or bugs. This is just me on a learning curve and sharing what I have found/stunmbled across

If it helps anybody else then that's cool with me

[than]

Hi, i´m from spain. Can i see any example of this?

Sorry for my english.

thanks.

[Fizzy]

Hi 'than'

Nothing wrong with your English there mate, it's a heck of a lot better than my Spanish

An example? Sure ....



I guess you could use just about any images that you want as long as the fit inside the boardindex table parameters

[Nemesis]

Or when you make the descripiton of the board you could use html to add the image there.  

[than]

Hi, thank´s for the example Fizzy and thank´s for the realy good tip Nemesis.

Bye

[Spaceman-Spiff]

Fizzy, u should add [Code] in front of your Subject
for more info, pls read -> http://www.yabbse.org/community/index.php?board=158;action=display;threadid=11961