SMFHacks.com

Presales => Presales for Products => Topic started by: Sierra on July 26, 2015, 09:26:53 pm

Title: AEVA to SMF Gallery Pro
Post by: Sierra on July 26, 2015, 09:26:53 pm
Hi there!  And thank you so much for providing this forum for support of your products!!

We have a forum run by and for graphic designers.  As you might guess the gallery is of vital importance.

We have been using AEVA 1.4w for a couple of years without incident and have generally been happy with the functionality.  Recently we have become alarmed at the lack of support/upgrades and realize that we are living on borrowed time.  After much research it became obvious that SMF Gallery is head and shoulders above the others.

We are all-in for Gallery Pro and certainly more than willing to spend the money, but we are concerned about the conversion.  If we attempt it and something goes awry, is there help outside of posting on this forum and waiting for someone to wander by?

Thanks!
Title: Re: AEVA to SMF Gallery Pro
Post by: SMFHacks on July 26, 2015, 09:56:38 pm
The conversion process I staff we have a convertor for Aeva to that does the processing. If there are conversion issues we can help with the issues. Generally requires us to have an ftp account and admin account on the forum. For the most part though it is just install smf gallery pro then upload the convertor and run it.
Title: Re: AEVA to SMF Gallery Pro
Post by: Sierra on July 27, 2015, 03:15:56 pm
That almost sounds too good to be true!!!

I have no problem giving ftp and admin access.  Is it possible to schedule a time for you (or other knowledgeable person) to be standing by "just in case"?  I'm happy to pay for any services given.  Although I know SMF reasonably well as a user and site admin, I am not an experienced programmer and likely could not troubleshoot if something goes awry.

Last question before purchase - is there a demo of the gallery that I and my staff can look at?  I think it would calm a lot of jittery nerves if we could see the payoff!

Title: Re: AEVA to SMF Gallery Pro
Post by: SMFHacks on July 27, 2015, 03:17:58 pm
The time part depends. I only around some nights/weekends CST.
Client side demo can be found at http://www.smfhacks.com/demos/index.php?action=gallery
If you need an admin demo let me know.
Title: Re: AEVA to SMF Gallery Pro
Post by: Sierra on July 27, 2015, 07:01:04 pm
We can come to some sort of agreement as to when - and the slowest time for our forum is early Saturday afternoon so I am sure we can figure it out.

Yes, I would really like to see an admin demo if at all possible.  Rather than asking a lot of specific questions that require actual typing to answer ;), looking at all the knobs and buttons will tell me most of what I need to know.  Feel free to either email me at the address on my profile or PM me the particulars

Thank you SO much for patiently answering my questions.  It gives me so much confidence moving forward!
Title: Re: AEVA to SMF Gallery Pro
Post by: SMFHacks on July 27, 2015, 07:05:33 pm
Sent pm with admin demo.
Title: Re: AEVA to SMF Gallery Pro
Post by: Sierra on July 27, 2015, 07:57:10 pm
Excellent!  Looking here answered most of my questions - I just have a couple more about comments.

1.  Is there any place a list of recent comments is generated for the Gallery?

2.  We use Simple Portal.  We have no trouble putting most recent images in the portal.  Is there any way to create a php block with the most recent comments as well?
Title: Re: AEVA to SMF Gallery Pro
Post by: SMFHacks on July 27, 2015, 08:04:49 pm
1. Recent comments no. I have addon that adds I believe the last 5 to the boardindex though

2. I belive there is a built in block in Simple Portal if not we have some block code that can be used in a portal
Title: Re: AEVA to SMF Gallery Pro
Post by: davejo on November 03, 2015, 01:13:29 am
Excellent!  Looking here answered most of my questions - I just have a couple more about comments.

1.  Is there any place a list of recent comments is generated for the Gallery?

2.  We use Simple Portal.  We have no trouble putting most recent images in the portal.  Is there any way to create a php block with the most recent comments as well?


I know it's been a while but the code below will do what you want in Simple Portal. It will insert the last 5 comments from the gallery in a block on the portal page.

just create a php block and insert the code into it.

Code: [Select]
global $smcFunc, $scripturl, $txt;
$txt['gallerymod_guest'] = 'Guest';

$dbresult = $smcFunc['db_query']('', "
SELECT
p.ID_PICTURE, p.ID_CAT, p.USER_ID_CAT, p.title, c.ID_MEMBER, c.comment, c.date,
m.real_name, a.title catname, c.ID_COMMENT, u.title catname2
FROM ({db_prefix}gallery_comment AS c, {db_prefix}gallery_pic as p)
LEFT JOIN  {db_prefix}gallery_cat AS a ON (a.ID_CAT = p.ID_CAT)
LEFT JOIN  {db_prefix}gallery_usercat AS u ON (u.USER_ID_CAT = p.USER_ID_CAT)
LEFT JOIN {db_prefix}members AS m ON (c.ID_MEMBER = m.ID_MEMBER)
WHERE  c.ID_PICTURE = p.ID_PICTURE AND c.approved = 1 ORDER BY c.ID_COMMENT DESC LIMIT 10");

$context['gallery_comindex'] = array();
while($row = $smcFunc['db_fetch_assoc']($dbresult))
{
$context['gallery_comindex'][] = array(
'ID_PICTURE' => $row['ID_PICTURE'],
'ID_COMMENT' => $row['ID_COMMENT'],
'title' => $row['title'],
'ID_CAT' => $row['ID_CAT'],
'USER_ID_CAT' => $row['USER_ID_CAT'],
'ID_MEMBER' =>  $row['ID_MEMBER'],
'real_name' => $row['real_name'],
'catname' => $row['catname'],
'catname2' => $row['catname2'],
'comment' => $row['comment'],
'date' => timeformat($row['date']),
);

echo '<strong><a href="' . $scripturl . '?action=gallery;sa=view;id=' . $row['ID_PICTURE'] . '#c' . $row['ID_COMMENT'] . '">' . (strlen($row['comment']) > 50 ? $smcFunc['substr']($row['comment'], 0, 50)  . '...' : substr($row['comment'], 0, 50))  . '</a></strong> ', $txt['by'], ' ', ($row['real_name'] != '' ?  '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">' . $row['real_name'] . '</a>' : $txt['gallerymod_guest']);
echo '&nbsp;' . timeformat($row['date']);
echo '<br />';


}
$smcFunc['db_free_result']($dbresult);