News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Thumbnail on Topic Listing

Started by SMFHacks.com Team, April 04, 2008, 01:05:48 PM

Previous topic - Next topic

vbgamer45

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

NeoXII

Quote from: NeoXII on October 26, 2009, 07:31:52 AM
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!

vbgamer45

Change

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

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

NeoXII

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

vbgamer45

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

NeoXII

Yes I have mysql on my server.....
In Smf 1.1.10 your mod work perfectly!

Ok I attach the file..

vbgamer45

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

samurai-lupin

Hello, can this mod also be adjusted so it will display a thumbnail on the new posts / replies index page?

NeoXII

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.  :)

JulesW

QuoteChange
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

vbgamer45

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

The Goblin

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

vbgamer45

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

The Goblin

Quote from: vbgamer45 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.

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

JulesW

QuoteOk, 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

NeoXII

How can I modify your code to see the last attachments in topic?
Complicated?

Thank You  :)

vbgamer45

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

samurai-lupin

Hello, can this mod also be adjusted so it will display a thumbnail on the new posts / replies index page?

vbgamer45

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

The Goblin

Quote from: JulesW on October 30, 2009, 01:34:00 PM
QuoteOk, 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.

Advertisement: