Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: How do I go about showing the "Last additions" section on my website's home page  (Read 3951 times)

0 Members and 1 Guest are viewing this topic.

Psythik

  • Coppermine newbie
  • Offline Offline
  • Posts: 6

The site I'm currently working on:
http://lost-frequency.com/

The gallery itself is located at:
http://lost-frequency.com/photos/

What I essentially want is that "Latest Pics" portion of the site on the home page to be functional.  I already have an idea on how to pull it off (making a copy of the photo gallery home page with just the "last additions" section, then embedding it on the home page), but if there's a plugin or an easier way to do this I'd rather go that route.

Suggestions?
Logged

lurkalot

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 931
  • +Tinyportal Support team.

Use CpmFetch 2.0 found attached to the bottom of this post, http://forum.coppermine-gallery.net/index.php/topic,35450.0.html

Then read this post about making it work with Coppermine 1.5.xx  http://forum.coppermine-gallery.net/index.php/topic,65412.0.html

It should do what you need.  ;)
Logged
Running SMF 2.0.15  / Tinyportal 1.6.4, bridged with Coppermine 1.6.06, plus cpmfetch 2.0.0

Psythik

  • Coppermine newbie
  • Offline Offline
  • Posts: 6

Thanks for the effort, but unfortunately download link is dead.  :-\
Logged

Psythik

  • Coppermine newbie
  • Offline Offline
  • Posts: 6

Nevermind, found the attachment in the thread.  Cheers!









By the way, where's the button to edit my posts?
Logged

Psythik

  • Coppermine newbie
  • Offline Offline
  • Posts: 6

Unfortunately it seems this plugin is way beyond my scope of understanding.  My knowledge of PHP is nonexistent; I'm scratching my head just trying to understand the documentation.  I tried to hack at it anyway by testing it on the bottom of the homepage, but instead of a working script I got tons of errors (see for yourself).  Looks like my original plan is gonna be much easier, if not a little Geocities-esque, if you know what I mean.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765

I got tons of errors (see for yourself)

Error message is
Quote
Unknown column 'p.owner_name' in 'field list'

SELECT p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb, u.user_lastvisit AS uUser_lastvisit,u.user_regdate AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS uUser_profile2,u.user_profile3 AS uUser_profile3,u.user_profile4 AS uUser_profile4,u.user_profile5 AS uUser_profile5,u.user_profile6 AS uUser_profile6, a.aid AS aAid, a.title AS aTitle, a.description AS aDescription, a.visibility as aVisibility, a.pos as aPos, a.category as aCategory, a.thumb as aThumb, a.keyword as aKeyword FROM cpg15x_pictures AS p LEFT JOIN cpg15x_users AS u ON p.owner_id = u.user_id LEFT JOIN cpg15x_albums AS a ON p.aid = a.aid LEFT JOIN cpg15x_categories AS c ON a.category = c.cid WHERE 1 AND p.approved='YES' AND ((a.visibility = 0 OR a.visibility IS NULL) AND (a.alb_password IS NULL OR a.alb_password = "")) AND ( a.category > 10000 ) ORDER BY rand(302716) LIMIT 4


See http://forum.coppermine-gallery.net/index.php/topic,65412.msg331160.html#msg331160
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.