Show First image in userbrowselistings

[bowers01 +]

Hi,
Can someone please point me in the right direction for showing the first image in userbrowselistings, i assume i have to add something in here

$sSQL = "SELECT id,title,section,price,display,hitcount,dateadded,expiration,orderID,oType,oStatus,oProductID FROM ".PREFIX."listings LEFT JOIN ".PREFIX."orders ON orderID=oID WHERE owner = ".$userid." ". $where ." ORDER BY dateadded DESC";

But i am not sure on what to add?
Thanks for the help,
Nick

[seymourjames +]

Can you not add code like this into the table to mimic what showlistings.tpl does as it is looping on results.


<td class="{cycle values="row1,row2" advance=false}"><img src="{$smarty.const.URL}/thumbs/small_{$entry.image|escape:"url"}" border="0" width="100" height="86" /></td>

I have not tried it. It may need some modification.

[bowers01 +]

Hi,
Thanks for the reply but no, looking in the debug console no pictures are there.
I did try your suggestion just then but it just shows the image as this http://localhost/thumbs/small_

Cheers,
Nick

[Mike-N-Tosh +]

I certainly hope you have a backup while your messing with the Listings core file.

I'm assuming your posted code is the initial query for the function getListingsForMember. If it were me, I would just loop through the rows and use the $row['id'] to call the built in function getListingSingleImage and assign the image to the row. Don't forget to then assign it to the template later in the code.

Also, make sure you document any changes you make in comments within the file.

[bowers01 +]

Originally Posted by Mike-N-Tosh

If it were me, I would just loop through the rows and use the $row['id'] to call the built in function getListingSingleImage and assign the image to the row. Don't forget to then assign it to the template later in the code.

I didnt know that existed, i will have a crack at it when i get a chance.
Thanks for the reply.

[bowers01 +]

i spent about a hour trying to get this working, then found this
https://www.68classifieds.com/forums...stings-v4.html
all done in 2min.
Thanks for the help

[seymourjames +]

Did say it will probably need an edit but glad you got it resolved. It is a nice addition actually. I personally would submit it as a feature enhancement. In my sites i actually have a reference number as a key to each listing. I put this in the first column and make it pop the listing so people can see what they are. This works really well when people have similar listings in their account.