News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

SMF Gallery

Started by SMFHacks.com Team, September 16, 2006, 07:13:02 PM

Previous topic - Next topic

PoML

Norwegian translation.

Don't know where to add this (or the hack I did to make eventregistration mod to install) - but you are free to copy the Norwegian translation files enclosed as attachment.

vbgamer45

Thanks will include it in the release.
I am hoping one day the mod site will allow translations to be easily submitted.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

SMFHacks.com Team

Added Norwegian translation to the release.
Disclaimer: SMFHacks.com Team is not affiliated with the SMF Team or the SimpleMachines NPO.
SMFHacks.com -  Paid Modifications for SMF
Latest Mods:
Community Suite
Newsletter Pro SMF Gallery Pro SMF Classifieds SMF Store

justinbowser

Is there a way to convert a Coppermine Gallery into this?  I didn't want to read through 200+ threads!  ::)

vbgamer45

I made a basic convertor for coppermine for the pro edition of the gallery though.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

justinbowser

Tell me more about this.  I need to get our old gallery ported over into something we can use and this sounds perfect.

vbgamer45

I have done a handful of Coppermine conversions mainly many years ago.
The converter will import albums, pictures, and comments

It attempts to match the picture owner from coppermine with the SMF username/id

For demo of SMF Gallery Pro check out  https://www.smfhacks.com/demos/index.php?action=gallery if you need an admin demo let me know
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

justinbowser

OK, I have purchased and installed the Pro Gallery now I need help with converting/porting the old Coppermine data into the SMF Gallery.

vbgamer45

Quote from: justinbowser on October 31, 2020, 11:11:54 AM
OK, I have purchased and installed the Pro Gallery now I need help with converting/porting the old Coppermine data into the SMF Gallery.
I just replied to your post on smfhacks.com please continue the discussion there.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

justinbowser


Sir Osis of Liver

Working on this forum, he's using Gallery Pro 8.0.6.  Gallery was working, did a clean install, reinstalled mod, getting this error from main menu Gallery button -

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c24thsca_modelforum2.p.view' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /home/c24thsca/public_html/forum/Sources/Gallery2.php
Line: 668


All submenu links work.  Also have Gallery Pro SSI 3.0 installed.

Version Information:
Forum version: SMF 2.0.17 (more detailed)
Current SMF version: SMF 2.0.17
GD version: bundled (2.1.0 compatible)
Database server: MySQL
MySQL version: 5.7.32-cll-lve
PHP: 5.6.40
Server version: Apache
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

vbgamer45

In the smf_settings table set
smfhacks_sqlmode = 1

Or insert a field and set it to one
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Sir Osis of Liver

Will have to try it tomorrow, can't get to database.  Another crappy host. >:(
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Sir Osis of Liver

   smfhacks_sqlmode doesn't exist in smf_settings, this query gives me a duplicate primary error -



INSERT INTO `smf_settings` (`variable`, `value`) VALUES ('smfhacks_sqlmode', '1')


Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

vbgamer45

TRY

REPLACE INTO `smf_settings` (`variable`, `value`) VALUES ('smfhacks_sqlmode', '1')
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Sir Osis of Liver

Yep, that fixed it.  Thanks.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

DarkAngel612

smf 2.0.17 new installtiny portal 1.6.8PHP 7.3

I have this code that gives us an image in the side tiny portal block, at least it used to. can someone please tell me what to change to give us the image again.

///////////////////////////////////////////////////
// SMF Gallery Random Picture - ver. 1.8          //
////////////////////////////////////////////////////
//
// Developed by Thurnok
// Thurnok -AT- tinyportal .DOT. net
// November 30, 2006
//
// Updated 9/26/2008
// 1.8
//        - added display # of comments option
//
// Used in a TinyPortal phpblock or Article.
// This block displays random/most/least/newest/oldest picture(s) from
// the SMF Gallery mod along with other information
//
//////////////////////////////////////////////

global $scripturl, $db_prefix, $modSettings, $boardurl, $ID_MEMBER, $user_info, $context;

/*
****************************************
****************************************
***    !! Admin Config Section !!    ***
****************************************
****************************************
*/

//   *****   LAYOUT OPTIONS   *****
// how many pictures do you want to show?  0 = all!
$gal_numpics = 2;

// use random, or most recent pics?
// 0 = random, 1 = most recent, 2 = most viewed, 3 = most commented
$gal_showtype = 0;
// sort :: 0 = Descending, 1 = Ascending
$gal_sort = 0;

// enable profile pics display?
// 0 = disable, 1 = enable --- if enabled, and you are viewing a member profile, show pics from that member only
// other options still apply (showtype, sort order, etc)
$gal_profile = 1;

// only show pics from buddies?
// 0 = disable, 1 = enable --- if enabled, will only show pics posted by members in your buddy list
$gal_buddies = 0;

// use Normal Size Text, or Small Size Text? (0 = Normal Size, 1 = Small Size)
$gal_smalltext = 0;

// put pictures in how many columns?  (1 for left/right block, more for centerblock / article if you wish)
$gal_columns = 1;

// information display flags (0 = No, 1 = Yes)
// display picture title?
$gal_dispTitle = 1;
// display membername who posted pic?
$gal_dispMember = 1;
// display posted date?
$gal_dispDate = 0;
// display category the picture is in?
$gal_dispCategory = 1;
// display number of views?
$gal_dispViews = 0;
// display dimensions?
$gal_dispDimensions = 0;
// display filesize?
$gal_dispSize = 0;
// display picture description?
$gal_dispDescription = 0;
// display # comments
$gal_dispNumComments = 0;

//   *****   SECURITY CONFIGURATION   *****
// do not allow the following category numbers to be displayed
// example: $gal_disallowCats = "4,2,7" - don't show categories 2, 4, or 7
$gal_disallowCats = "";
// select only from the following cats - leave empty for all - NOTE:($gal_disallowCats overrides)
// example: $gal_allowCats = "1,3,4" - show only categories 1, 3, and 4
$gal_allowCats = "";
// Require the user has allowedTo('smfgallery_view') permission to view random pics thumbnails in block?
$gal_viewPermission = 1;

/*
****************************************
****************************************
***  !! END Admin Config Section !!  ***
****************************************
****************************************
*/

//###############################################
//###############################################
//   You shouldn't change anything below here
//###############################################
//###############################################

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

$gal_textclass = empty($gal_smalltext) ? "normaltext" : "smalltext";

// get this user's buddy list
$gal_buddylist = implode(",", $user_info['buddies']);

// prep for our switch routine
if (empty($gal_showtype))
    $gal_showtype = 0;

// sort text
if (empty($gal_sort)){
    $gal_sort_text = 'DESC';
} else {
    $gal_sort_text = '';
}

// are we viewing a member profile and $gal_profile is enabled?
if (!empty($gal_profile) && strtolower($context['current_action']) == "profile"){
    $gal_member = empty($_GET['u']) ? $ID_MEMBER : $_GET['u'];
}
// allow member to view random pic based on security settings
if (empty($gal_viewPermission) || allowedTo('smfgallery_view')){
    $gal_query = '
            SELECT
                thumbfilename,
                ID_PICTURE,
                ID_MEMBER,
                date,
                title,
                description,
                views,
                filesize,
                height,
                width,
                commenttotal,
                ID_CAT
            FROM '.$db_prefix.'gallery_pic
            WHERE approved = 1
            '.(empty($gal_member) ? (empty($gal_buddies) ? "" : (empty($gal_buddylist) ? "AND ID_MEMBER = NULL " : "AND ID_MEMBER in ($gal_buddylist)")) : "AND ID_MEMBER = $gal_member" ).'
            '.(empty($gal_disallowCats) ? "" : "    AND ID_CAT NOT IN ($gal_disallowCats)").'
            '.(empty($gal_allowCats) ? "" : "    AND ID_CAT IN ($gal_allowCats)").'
            GROUP BY thumbfilename ';

    switch ($gal_showtype){
        // most/least recent
        case 1:
            $gal_query .= '
                    ORDER BY date '.$gal_sort_text;
            break;

        // most/least viewed
        case 2:
            $gal_query .= '
                    ORDER BY views '.$gal_sort_text;
            break;

        // most/least commented
        case 3:
            $gal_query .= '
                    ORDER BY commenttotal '.$gal_sort_text;
            break;

        default:
            $gal_query .= '
                    ORDER BY rand() '.$gal_sort_text;
            break;
    }
    $gal_query .= (empty($_GET['gal_viewall']) && !empty($gal_numpics)) ? ' LIMIT '.$gal_numpics : '';
    $gal_result = mysql_query($gal_query);
    if (!$gal_result){
        // error retrieving information from database
        if (mysql_errno() == 1146){
            echo '<p />Error, no database found!<p />';
        } else {
            echo '<p />MySQL error:'.mysql_error().'<p />';
        }
    } else {
        echo "\n".'<table cellspacing="0" cellpadding="5" border="0" align="center" width="90%">'."\n";
   
        $gal_colcnt = 1;
        echo "    <tr>\n";
        while ($row = mysql_fetch_assoc($gal_result)){
            if ($gal_colcnt > $gal_columns){
                // close out the row and start a new row
                echo "    </tr>\n    <tr>\n".'        <td colspan="'.$gal_columns.'"><hr /></td>'."\n    </tr>\n    <tr>\n";
                // reset count to column 1
                $gal_colcnt = 1;
            }
            echo    '        <td class="'.$gal_textclass.'" align="center">'."\n";
            // display title if enabled, make edit link if viewing user is picture poster
            if (!empty($gal_dispTitle)){
                echo "            ".($ID_MEMBER == $row['ID_MEMBER'] ? ('<a href="'.$scripturl.'?action=gallery;sa=edit;id='.$row['ID_PICTURE'].'">'.$row['title'].'</a>') : $row['title'])."<br />\n";
            }
            // display the picture thumbnail and link it to gallery full picture
            echo    '            <a href="'.$scripturl.'?action=gallery;sa=view;id='.$row['ID_PICTURE'].'"><img src="'.$modSettings['gallery_url'].$row['thumbfilename'].'" /></a><br />'."\n";
            // display poster's name and posted date if enabled
            if (!empty($gal_dispMember) || !empty($gal_dispDate)){
                echo 'Posted';
                if (!empty($gal_dispMember)){
                    // display the membername who posted pic?  need to get name based on ID_MEMBER
                    $gal_tmp = mysql_fetch_assoc(mysql_query("SELECT memberName FROM ".$db_prefix."members WHERE ID_MEMBER = ".$row['ID_MEMBER']));
                    echo ' by <a href="'.$scripturl.'?action=profile;u='.$row['ID_MEMBER'].'">'.$gal_tmp['memberName'].'</a>';
                }
                if (!empty($gal_dispDate)){
                    // display the date it was posted
                    echo ' on '.date("d M Y", $row['date']);
                }
                echo "<br />\n";
            }
            // display category if enabled
            if (!empty($gal_dispCategory)){
                // get category name based on category id
                $gal_tmp = mysql_fetch_assoc(mysql_query("SELECT title FROM ".$db_prefix."gallery_cat WHERE ID_CAT = ".$row['ID_CAT']));
                echo '<br />in<br /><a href="'.$scripturl.'?action=gallery;cat='.$row['ID_CAT'].'">'.$gal_tmp['title']."</a><br /><br />\n";
            }
            // display number of views if enabled
            if (!empty($gal_dispViews)){
                echo "Viewed ".$row['views']." times<br />\n";
            }
            // display dimensions if enabled
            if (!empty($gal_dispDimensions)){
                echo $row['width']."w X ".$row['height']."h<br />\n";
            }
            // display filesize if enabled
            if (!empty($gal_dispSize)){
                echo $row['filesize']." bytes<br />\n";
            }
            // display description if enabled
            if (!empty($gal_dispDescription)){
                echo "<br />".$row['description']."<br />\n";
            }
            // display # of comments if enabled
            if (!empty($gal_dispNumComments)){
                echo '<br /><i><a href="'.$scripturl.'?action=gallery;sa=view;id='.$row['ID_PICTURE'].'">'.$row['commenttotal']."</a> comment(s)</i><br />\n";
            }
            echo    "        </td>\n";
            $gal_colcnt++;
        }
        mysql_free_result($gal_result);
        echo "    </tr>\n</table>\n";
        if (!empty($gal_member) && empty($_GET['gal_viewall']))
            echo '<br /><a href="'.$boardurl.'/index.php?action=profile;u='.$gal_member.';gal_viewall=1">View all pics from this member</a>';
        if (!empty($gal_buddies) && empty($_GET['gal_viewall'])){
            // build the link
            $gal_querystring = $context['TPortal']['querystring'];
            $gal_querystring .= empty($gal_querystring) ? 'gal_viewall=1' : ';gal_viewall=1';
            echo '<br /><a href="'.$boardurl.'/index.php?'.$gal_querystring.'">View all pics of buddies</a>';
        }
    }
} else {
    echo 'Sorry, you do not have permission to view pictures!';
}
Fantasy Attic ::  Fantasies Realm Market :: SMF 2.0+ with various mods and TinyPortal

vbgamer45

Did you check on TinyPortal if they have updated 2.0.x block? If not I will update and post there.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

DarkAngel612

Quote from: vbgamer45 on January 20, 2021, 09:50:31 PM
Did you check on TinyPortal if they have updated 2.0.x block? If not I will update and post there.

sorry about that, I didn't think of them at all. will go peek and ask.
Fantasy Attic ::  Fantasies Realm Market :: SMF 2.0+ with various mods and TinyPortal

Advertisement: