Thumbnail on Topic Listing

[vbgamer45]

Might need to do a manual install seems to be a bug with SMF's package parser.

[NeoXII]

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

Code Select Expand


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 Expand


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)


[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]

Can you attach the file? Are you using MySQL?

[NeoXII]

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

Ok I attach the file..

[vbgamer45]

Fixed file attached

[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]

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!

[vbgamer45]

Yeah look at the file that I fixed and compare it to see if you made any differences.

[The Goblin]

This Mod is exactly what I am looking for on my forum.     Its why I decided to stay with SMF 

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.

[The Goblin]

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 

Thanks Bunches 

[JulesW]

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

[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.

[samurai-lupin]

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

[vbgamer45]

Probably don't know the code to do it though.

[The Goblin]

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.