Advertisement:

Author Topic: Thumbnail on Topic Listing  (Read 179947 times)

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,226
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #180 on: October 28, 2009, 07:42:12 PM »
Might need to do a manual install seems to be a bug with SMF's package parser.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline NeoXII

  • Semi-Newbie
  • *
  • Posts: 52
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #181 on: October 28, 2009, 07:58:57 PM »
Hi,
great mod but on SMF 2.0 RC1.2 in MessageIndex.php I can't find this code:

LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)
LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)

But this:

LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)
LEFT JOIN {db_prefix}members AS mav ON (mav.id_member = ml.id_member)

If I try to replace with this, I have blank page:

LEFT JOIN {db_prefix}attachments AS big ON (big.id_msg = mf.id_msg AND big.attachment_type = 0)
LEFT JOIN {db_prefix}attachments AS thn ON (thn.id_attach = big.id_thumb)
LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)
LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)

Thank You very much!! :)

Hi Vbgamer45,
yes I think so but I have problem above...

Thank You!

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,226
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #182 on: October 28, 2009, 08:08:26 PM »
Change
Code: [Select]
LEFT JOIN {db_prefix}attachments AS big ON (big.id_msg = mf.id_msg AND big.attachment_type = 0)
LEFT JOIN {db_prefix}attachments AS thn ON (thn.id_attach = big.id_thumb)
LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)
LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)
To
Code: [Select]
LEFT JOIN {db_prefix}attachments AS big ON (big.id_msg = mf.id_msg AND big.attachment_type = 0)
LEFT JOIN {db_prefix}attachments AS thn ON (thn.id_attach = big.id_thumb)
LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)
LEFT JOIN {db_prefix}members AS mav ON (mav.id_member = ml.id_member)
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline NeoXII

  • Semi-Newbie
  • *
  • Posts: 52
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #183 on: October 28, 2009, 08:57:13 PM »
ok...

this is the error message after your tips...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN smf_messages AS ml ON (ml.id_msg = t.id_last_msg)
INNER JOIN smf_' at line 17
File: /MessageIndex.php
Riga: 428

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,226
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #184 on: October 28, 2009, 08:59:02 PM »
Can you attach the file? Are you using MySQL?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline NeoXII

  • Semi-Newbie
  • *
  • Posts: 52
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #185 on: October 28, 2009, 09:02:07 PM »
Yes I have mysql on my server.....
In Smf 1.1.10 your mod work perfectly!

Ok I attach the file..

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,226
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #186 on: October 28, 2009, 09:20:21 PM »
Fixed file attached
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline samurai-lupin

  • Full Member
  • ***
  • Posts: 522
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #187 on: October 29, 2009, 09:09:32 AM »
Hello, can this mod also be adjusted so it will display a thumbnail on the new posts / replies index page?

Offline NeoXII

  • Semi-Newbie
  • *
  • Posts: 52
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #188 on: October 29, 2009, 02:59:20 PM »
Ok Vgamer45, now mod work perfect!!
   
Thanks for your help... ;)

How can I do to have not only the first attached on Thumbnail but also other attached in Topic?
My curiosity is because I have a forum of Computer Graphics.
Users open work in progress and it would be interesting to have a preview of the work...

Thank you... excuse me if my english is not very good.  :)

Offline JulesW

  • Jr. Member
  • **
  • Posts: 132
  • Gender: Male
  • We should have shotguns for this kind of deal!
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #189 on: October 29, 2009, 03:04:14 PM »
Quote
Change
Code: [Select]
LEFT JOIN {db_prefix}attachments AS big ON (big.id_msg = mf.id_msg AND big.attachment_type = 0)
LEFT JOIN {db_prefix}attachments AS thn ON (thn.id_attach = big.id_thumb)
LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)
LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)
To
Code: [Select]
LEFT JOIN {db_prefix}attachments AS big ON (big.id_msg = mf.id_msg AND big.attachment_type = 0)
LEFT JOIN {db_prefix}attachments AS thn ON (thn.id_attach = big.id_thumb)
LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)
LEFT JOIN {db_prefix}members AS mav ON (mav.id_member = ml.id_member)

Strange, that's what I did as well... must have made a mistake somewhere.

A well, glad you got it sorted!
And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,226
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #190 on: October 29, 2009, 07:28:59 PM »
Yeah look at the file that I fixed and compare it to see if you made any differences.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline The Goblin

  • Semi-Newbie
  • *
  • Posts: 30
  • Gender: Female
  • Grrrrr...
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #191 on: October 30, 2009, 09:50:02 AM »
This Mod is exactly what I am looking for on my forum.   :D  Its why I decided to stay with SMF  ;D

Im using SMF 2.0 RC1.2

I uploaded it and it installed with no errors but Im not sure where to go to turn on the option (from reading this thread, it looks like you turn something on).

Anyway, not sure what I need to do or where to go in the Admin section.

Thanks

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,226
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #192 on: October 30, 2009, 12:30:43 PM »
There is no settings in the admin panel.

If you are using a custom theme it will require an edit to a file in the custom theme.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline The Goblin

  • Semi-Newbie
  • *
  • Posts: 30
  • Gender: Female
  • Grrrrr...
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #193 on: October 30, 2009, 12:59:35 PM »
There is no settings in the admin panel.

If you are using a custom theme it will require an edit to a file in the custom theme.

Ok, ummmmm what file would I edit and exactly what do I need to edit?  Or where do I find the information to edit.

Im computer illiterate most of the time  :P

Thanks Bunches  :D

Offline JulesW

  • Jr. Member
  • **
  • Posts: 132
  • Gender: Male
  • We should have shotguns for this kind of deal!
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #194 on: October 30, 2009, 01:34:00 PM »
Quote
Ok, ummmmm what file would I edit and exactly what do I need to edit?  Or where do I find the information to edit.

you can use a package parser to check which files you need to edit, you can also parse the installation instructions at the download site of the mod
And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17

Offline NeoXII

  • Semi-Newbie
  • *
  • Posts: 52
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #195 on: November 04, 2009, 05:57:41 PM »
How can I modify your code to see the last attachments in topic?
Complicated?

Thank You  :)

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,226
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #196 on: November 04, 2009, 07:53:09 PM »
Little bit you can check out the install instructions and try to modify it except going to be hard to figure out what the last attachment is probably another sql query is needed. or if you can get the last attachment id somehow.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline samurai-lupin

  • Full Member
  • ***
  • Posts: 522
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #197 on: November 05, 2009, 02:13:49 PM »
Hello, can this mod also be adjusted so it will display a thumbnail on the new posts / replies index page?

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,226
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #198 on: November 05, 2009, 08:07:44 PM »
Probably don't know the code to do it though.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline The Goblin

  • Semi-Newbie
  • *
  • Posts: 30
  • Gender: Female
  • Grrrrr...
Re: Thumbnail on Topic Listing (SMF 2 Support Added!)
« Reply #199 on: November 10, 2009, 12:31:42 PM »
Quote
Ok, ummmmm what file would I edit and exactly what do I need to edit?  Or where do I find the information to edit.

you can use a package parser to check which files you need to edit, you can also parse the installation instructions at the download site of the mod

I just tried opening the parse instructions for RC1.2 and they said it wasnt compatible and wont show the instructions for manual install.

Not sure what to do now.