Jørn Wildt

After about 2 years of labor intense sql queries by Photoshare (as I discovered in my server logs) my hosting provider finally deacivated my account. I had to deactivate Photoshare to get back online.

I would very much like to use the Photoshare again or transfer to mediashare if and when it supports the database based photos as Photoshare does. The labor intensive query probably comes from the Photoshare index where it retrieves all the albums, lack of pagination makes it load al the albums on 1 page. Has anyone figured out how to do pagination on Photoshare albums (not photos within albums, already done by Photoshare)

Query in question:

# Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 3260
SELECT nuke_photoshare_folders.ps_id,
nuke_photoshare_folders.ps_owner,
IF(LENGTH(nuke_users.pn_name) <> 0, nuke_users.pn_name, nuke_users.pn_uname),
UNIX_TIMESTAMP(nuke_photoshare_folders.ps_createddate),
UNIX_TIMESTAMP(nuke_photoshare_folders.ps_modifieddate),
nuke_photoshare_folders.ps_title,
nuke_photoshare_folders.ps_description,
nuke_photoshare_folders.ps_topic,
nuke_topics.pn_topicname,
nuke_topics.pn_topictext,
nuke_photoshare_folders.ps_template,
nuke_photoshare_folders.ps_hidepnframe,
nuke_photoshare_folders.ps_blockfromlist,
nuke_photoshare_folders.ps_parentfolder,
nuke_photoshare_folders.ps_viewkey,
nuke_photoshare_folders.ps_mainimage,
COUNT(DISTINCT nuke_photoshare_images.ps_id),
MIN(nuke_photoshare_images.ps_id)
, COUNT(DISTINCT subFolders.ps_id)
FROM nuke_photoshare_folders
LEFT JOIN nuke_photoshare_images ON nuke_photoshare_images.ps_parentfolder = 1
LEFT JOIN nuke_photoshare_folders as subFolders ON subFolders.ps_parentfolder = 1
LEFT JOIN nuke_topics ON nuke_photoshare_folders.ps_topic = nuke_topics.pn_topicid
LEFT JOIN nuke_users ON nuke_photoshare_folders.ps_owner = nuke_users.pn_uid
WHERE nuke_photoshare_folders.ps_id = 1
GROUP BY nuke_photoshare_images.ps_parentfolder

Or has anyone figured out how to extract the photos from the database and transfer them for use in Mediashare?

I am in fact right now working on the database storage for Mediashare :-)

Great, I hope it will be able to incorporate photoshare's photos too. Thanks!