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

vbgamer45 · « **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.

NeoXII · « **Reply #181 on:** October 28, 2009, 07:58:57 PM »

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 · « **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)

NeoXII · « **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

vbgamer45 · « **Reply #184 on:** October 28, 2009, 08:59:02 PM »

Can you attach the file? Are you using MySQL?

NeoXII · « **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..

vbgamer45 · « **Reply #186 on:** October 28, 2009, 09:20:21 PM »

Fixed file attached

samurai-lupin · « **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?

NeoXII · « **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.

JulesW · « **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!

vbgamer45 · « **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.

The Goblin · « **Reply #191 on:** October 30, 2009, 09:50:02 AM »

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 · « **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.

The Goblin · « **Reply #193 on:** October 30, 2009, 12:59:35 PM »

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

Thanks Bunches

JulesW · « **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

NeoXII · « **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

vbgamer45 · « **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.

samurai-lupin · « **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?

vbgamer45 · « **Reply #198 on:** November 05, 2009, 08:07:44 PM »

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

The Goblin · « **Reply #199 on:** November 10, 2009, 12:31:42 PM »

Quote from: JulesW 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

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.

News:

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