Welcome, Guest. Please Login or Register.
May 04, 2024, 07:35:38 PM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  Development  |  Completed mods  |  [DONE 1.4.0] Show Attachments in MessageIndex « previous next »
Pages: 1 [2] Reply Ignore Print
Author Topic: [DONE 1.4.0] Show Attachments in MessageIndex  (Read 8721 times)
Mach8
Sweetie
Beta Tester
YaBB God
*****
Posts: 1218


ICQ - 339855961
Re:[DONE 1.4.0] Show Attachments in MessageIndex
« Reply #15 on: October 01, 2002, 07:53:10 PM »
Reply with quote

I just tested the mod on a fresh install of 1.4.1, and it worked fine.
Logged
Big P
Mod Team
YaBB God
*****
Posts: 1462


"Back in '68, I don't like you, The End."

ICQ - 76064555pierceward@hotmail.com WWW
Re:[DONE 1.4.0] Show Attachments in MessageIndex
« Reply #16 on: October 02, 2002, 08:46:25 PM »
Reply with quote

Quote from: Mach8 on October 01, 2002, 07:53:10 PMI just tested the mod on a fresh install of 1.4.1, and it worked fine.
Thanks.

Then all I can say is learn how to use boardmod rowanjl.  ;)
Logged

PHPNews has been released!!! Download it now!!!
losthai
Noobie
*
Posts: 10


Your llama is next!

Re:[DONE 1.4.0] Show Attachments in MessageIndex
« Reply #17 on: January 17, 2003, 06:39:28 AM »
Reply with quote

I also had a good result on a manual mod in 1.4.1 -- thanks for a nice mod!

Now, any way it could put a paperclip next to attachmented posts under "Recent Posts"?

[Hey, sometimes when you ask for the moon and stars, you get one or both of them...]
Logged
Big P
Mod Team
YaBB God
*****
Posts: 1462


"Back in '68, I don't like you, The End."

ICQ - 76064555pierceward@hotmail.com WWW
Re:[DONE 1.4.0] Show Attachments in MessageIndex
« Reply #18 on: January 18, 2003, 04:56:37 PM »
Reply with quote

It's not really in demand is it? But, if I do decide to do it, I'll be doing it for 1.5.* not 1.4.1
Logged

PHPNews has been released!!! Download it now!!!
hedging
Noobie
*
Posts: 30


Thank u guyz for such great forum system

WWW
Re:[done 1.4.0] Show Attachments in MessageIndex
« Reply #19 on: December 02, 2003, 11:45:47 PM »
Reply with quote

Sorry, I dont speak english well but ill try to explain...

Now i try to install this mod manualy to 1.5.4
It works but not for all topics with attachs.
It works only on topics where attachs on first page.
The problem is to have this mod works with attachs on every page of topic.

here piece of my code


   if (count($topics))
   {
      $result = mysql_query("
         SELECT t.ID_LAST_MSG, t.ID_TOPIC, t.numReplies, t.locked, m.posterName, m.attachmentFilename, m.attachmentSize, m.ID_MEMBER, IFNULL(mem.realName, m.posterName) AS posterDisplayName, t.numViews, m.posterTime, m.modifiedTime, t.ID_FIRST_MSG, t.isSticky, t.ID_POLL, m2.posterName as mname, m2.attachmentSize as attachs, m2.ID_MEMBER as mid, IFNULL(mem2.realName, m2.posterName) AS firstPosterDisplayName, m2.subject as msub, m2.icon as micon, IFNULL(lt.logTime, 0) AS isRead, IFNULL(lmr.logTime, 0) AS isMarkedRead
         FROM {$db_prefix}topics as t, {$db_prefix}messages as m, {$db_prefix}messages as m2
            LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER=m.ID_MEMBER)
            LEFT JOIN {$db_prefix}members AS mem2 ON (mem2.ID_MEMBER=m2.ID_MEMBER)
            LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC=t.ID_TOPIC AND lt.ID_MEMBER=$ID_MEMBER)
            LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD=$currentboard AND lmr.ID_MEMBER=$ID_MEMBER)
         WHERE t.ID_TOPIC IN (" . implode(',', $topics) . ")
            AND m.ID_MSG=t.ID_LAST_MSG
            AND m2.ID_MSG=t.ID_FIRST_MSG
       ORDER BY $stickyOrder $ordrsql") or database_error(__FILE__, __LINE__);

      // Begin printing the message index for current board.
      while ($row = mysql_fetch_assoc($result))
      {
         if ($row['ID_POLL'] != '-1' && $modSettings['pollMode'] == 0)
            continue;
         $lastposter = $row['posterName'];
         $lastPosterID = $row['ID_MEMBER'];
         $mdate = $row['posterTime'];
         $mname = $row['mname'];


         if ($row['attachmentFilename']!='') {$VBattach=1;} else
         $VBattach=0;
         
         $VBnamea=count($row['attachmentFilename']);

         $attachs = $row['attachs']+$row['attachmentSize'];


as you see i try this $row['attachs']+$row['attachmentSize'] because every part of this shows only part of attachs. But this isnt solved the problem. Can you help me please?
Logged

Mikhail
Pages: 1 [2] Reply Ignore Print 
YaBB SE Community  |  Development  |  Completed mods  |  [DONE 1.4.0] Show Attachments in MessageIndex « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.022 seconds with 19 queries.