Topic: SMF Gallery Block problem and help request

[fotografo74]

Hi,
i'm Antonio from Rome, Italy...sorry for my poor english.
I'm testing SMF 2RC1 + SimplePortal 2.1.1...great combination! Thanks!
Also i have SMF Gallery Pro installed.
It's possible display 4 pics from Gallery ? ( now only one )
I changed LIMIT 1 to LIMIT 4 in SPortal2.php

Code: [Select]

$dbresult = $smcFunc['db_query']('', "
SELECT p.id_picture
FROM {$db_prefix}gallery_pic as p
ORDER BY id_picture DESC
LIMIT 4");
but not works!
Help me please, it's important, now only EzPortal works ok with recent images from SMF Gallery, but SimplePortal is better for me.
Thanks !
antonio

[fotografo74]

:-(
Help please... :-)

[[SiNaN]]

Try these codes in a PHP block:

Code: [Select]

global $smcFunc, $context, $modSettings, $scripturl;
global $sourcedir, $txt, $settings, $boardurl, $galurl;
static $mod, $GD_Installed;

$limit = 4;
$type = 1
$direction = 0;

if (!isset($mod))
{
if (file_exists($sourcedir . '/Gallery2.php'))
$mod = 'smf_gallery';
}

if (empty($mod))
{
echo '
', $txt['error_sp_no_gallery_found'];
return;
}
elseif ($mod == 'smf_gallery')
{
loadLanguage('Gallery', sp_languageSelect('Gallery'));

if (!isset($GD_Installed))
$GD_Installed = function_exists('imagecreate');

if (empty($modSettings['gallery_url']))
$modSettings['gallery_url'] = $boardurl . '/gallery/';

$request = $smcFunc['db_query']('','
SELECT
p.id_picture, p.commenttotal, p.filesize, p.views, p.thumbfilename,
p.filename, p.height, p.width, p.title, p.id_member, m.member_name,
m.real_name, p.date, p.description
FROM {db_prefix}gallery_pic AS p
LEFT JOIN {db_prefix}members AS m ON (m.id_member = p.id_member)
WHERE p.approved = {int:is_approved}
ORDER BY {raw:type}
LIMIT {int:limit}',
array(
'is_approved' => 1,
'type' => $type ? 'RAND()' : 'p.id_picture DESC',
'limit' => $limit,
)
);
$items = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
$items[] = array(
'id' => $row['id_picture'],
'title' => $row['title'],
'views' => $row['views'],
'poster_id' => $row['id_member'],
'poster_name' => $row['real_name'],
'poster_link' => empty($row['id_member']) ? $txt['gallery_guest'] : '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>',
'thumbfilename' => $row['thumbfilename'],
'filename' => $row['filename'],
'src' => $modSettings['gallery_url'] . ($GD_Installed ? $row['thumbfilename'] : $row['filename'] . '" width="120'),
);
}
$smcFunc['db_free_result']($request);
}

if (empty($items))
{
echo '
', $txt['error_sp_no_pictures_found'];
return;
}

echo '
<table style="margin: 0 auto;">', $direction ? '
<tr>' : '';

foreach ($items as $item)
{
  echo !$direction ? '
<tr>' : '', '
<td>
<div class="smalltext">';

if ($mod == 'smf_gallery')
{
echo '
<a href="', $scripturl, '?action=gallery;sa=view;id=', $item['id'], '">', $item['title'], '</a><br />
<a href="', $scripturl, '?action=gallery;sa=view;id=', $item['id'], '"><img src="', $item['src'], '" alt="" /></a><br />
', $txt['gallery_text_views'], $item['views'], '<br />
', $txt['gallery_text_by'], ' ', $item['poster_link'], '<br />';
}

echo '
</div>
</td>', !$direction ? '
</tr>' : '';
}

echo $direction ? '
</tr>' : '', '
</table>';
This is a default feature in 2.2, which is being tested currently.

[fotografo74]

Try these codes in a PHP block:

Code: [Select]

global $smcFunc, $context, $modSettings, $scripturl;
global $sourcedir, $txt, $settings, $boardurl, $galurl;
static $mod, $GD_Installed;

$limit = 4;
$type = 1
$direction = 0;

if (!isset($mod))
{
if (file_exists($sourcedir . '/Gallery2.php'))
$mod = 'smf_gallery';
}

if (empty($mod))
{
echo '
', $txt['error_sp_no_gallery_found'];
return;
}
elseif ($mod == 'smf_gallery')
{
loadLanguage('Gallery', sp_languageSelect('Gallery'));

if (!isset($GD_Installed))
$GD_Installed = function_exists('imagecreate');

if (empty($modSettings['gallery_url']))
$modSettings['gallery_url'] = $boardurl . '/gallery/';

$request = $smcFunc['db_query']('','
SELECT
p.id_picture, p.commenttotal, p.filesize, p.views, p.thumbfilename,
p.filename, p.height, p.width, p.title, p.id_member, m.member_name,
m.real_name, p.date, p.description
FROM {db_prefix}gallery_pic AS p
LEFT JOIN {db_prefix}members AS m ON (m.id_member = p.id_member)
WHERE p.approved = {int:is_approved}
ORDER BY {raw:type}
LIMIT {int:limit}',
array(
'is_approved' => 1,
'type' => $type ? 'RAND()' : 'p.id_picture DESC',
'limit' => $limit,
)
);
$items = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
$items[] = array(
'id' => $row['id_picture'],
'title' => $row['title'],
'views' => $row['views'],
'poster_id' => $row['id_member'],
'poster_name' => $row['real_name'],
'poster_link' => empty($row['id_member']) ? $txt['gallery_guest'] : '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>',
'thumbfilename' => $row['thumbfilename'],
'filename' => $row['filename'],
'src' => $modSettings['gallery_url'] . ($GD_Installed ? $row['thumbfilename'] : $row['filename'] . '" width="120'),
);
}
$smcFunc['db_free_result']($request);
}

if (empty($items))
{
echo '
', $txt['error_sp_no_pictures_found'];
return;
}

echo '
<table style="margin: 0 auto;">', $direction ? '
<tr>' : '';

foreach ($items as $item)
{
  echo !$direction ? '
<tr>' : '', '
<td>
<div class="smalltext">';

if ($mod == 'smf_gallery')
{
echo '
<a href="', $scripturl, '?action=gallery;sa=view;id=', $item['id'], '">', $item['title'], '</a><br />
<a href="', $scripturl, '?action=gallery;sa=view;id=', $item['id'], '"><img src="', $item['src'], '" alt="" /></a><br />
', $txt['gallery_text_views'], $item['views'], '<br />
', $txt['gallery_text_by'], ' ', $item['poster_link'], '<br />';
}

echo '
</div>
</td>', !$direction ? '
</tr>' : '';
}

echo $direction ? '
</tr>' : '', '
</table>';
This is a default feature in 2.2, which is being tested currently.

Thanks for help!
I take sintax error PHP...   
I modifies '/Gallery2.php' to '/Gallery.php' ...in Sources i have Gallery.php...but always sintax errore PHP
Antonio

[[SiNaN]]

Sorry.

Find:

Code: [Select]

   $type = 1
Replace:

Code: [Select]

   $type = 1;
in the codes above.

[fotografo74]

Sorry.

Find:

Code: [Select]

   $type = 1
Replace:

Code: [Select]

   $type = 1;
in the codes above.

Thanks Blue Dream, it works!!! :-)
I would shows Horizontally, not vertically....it's possible ? ( i put in top block )
Antonio

[[SiNaN]]

Find:

$direction = 0;

Replace:

$direction = 1;

[fotografo74]

Find:

$direction = 0;

Replace:

$direction = 1;

Thanks Blue Dream !
Great support :-)
Antonio