Icy Phoenix

     
 

Home » Forum » phpBB Mods And Styles » Archived phpBB Topics (Styles, Mods, Support)

The time now is Mon 28 Apr, 2025 12:57 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Enable KB mode Download Topic Printable Version Email to a Friend View next topic

FAP CUSTOMIZATION - Restricting Personal Galleries From Being Displayed


This forum is locked: you cannot post, reply or edit topics.  This topic is locked: you cannot edit posts or make replies.  		Page 1 of 1
 
 
Offline newguy78 
 
avatar
Joined: March 2007
Posts: 14

 
 
Reply with quote Download Post 
Post FAP CUSTOMIZATION - Restricting Personal Galleries From Being Displayed 
 
Hello, I am using the photo outside pics mod but I'm noticing that personal gallery pics are showing up, but I do not want them to.  At one point of time, I was using the smartor portal with kooky's photo album block, which allowed you to restrict personal gallery pics from being displayed.  Does anyone know how I can achieve this?  Below I have attached the code to the photo album outside pics mod.  Thank you

Code: [Download] [Hide] [Select]
<?

if(!defined('IN_PHPBB'))
{
    define('IN_PHPBB', true);
    $phpbb_root_path = './phpbb/'; //set your path
    $album_root_path = $phpbb_root_path . 'album_mod/';
    include($phpbb_root_path . 'extension.inc');
    include($phpbb_root_path . 'common.'.$phpEx);
}
else
{
    $album_root_path = $phpbb_root_path . 'album_mod/';
}


$language = $board_config['default_lang'];

if ( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_album_main.'.$phpEx) )
{
    $language = 'english'; // set your default language
}

include($phpbb_root_path . 'language/lang_' . $language . '/lang_album_main.' . $phpEx);


print "<table align=center>";
print "<tr><th align='center' colspan='3'>". $lang['Random_Pics'] ."</th></tr>";
print "<tr>";

for ($i=0;$i<4;$i++) //set number of pictures for the displayed line
{
    while ($cat['cat_view_level'] != '-1')
    {
        $sql = "SELECT pic_id, pic_desc, pic_cat_id FROM ". ALBUM_TABLE ." ORDER BY RAND() LIMIT 1";
        $result = $db->sql_query($sql) or die ("SQL Error");
        $row = $db->sql_fetchrow($result);
        $sql = "SELECT * FROM ". ALBUM_CAT_TABLE ." WHERE cat_id = '". $row['pic_cat_id'] ."'";
        $result = $db->sql_query($sql) or die ("SQL Error");
        $cat = $db->sql_fetchrow($result);
    }
    $cat['cat_view_level'] = '0';
    print "<td valign='top'><table><tr><td align='center'>" . $row['pic_title'] . "<br /></td></tr><tr><td align='center'><a href='". append_sid($phpbb_root_path ."album_showpage.". $phpEx ."?pic_id=" . $row['pic_id']) ."'><img width='95' height='85' alt='" . $row['pic_desc'] . "' src='". $phpbb_root_path ."album_thumbnail.". $phpEx ."?pic_id=" . $row['pic_id'] . "' class="ima_bottom"></a></td></tr></table></td>";
}

print "</tr>";
print "</table>";

print "<table align=center>";

print "<tr>";

for ($i=0;$i<4;$i++) //set number of pictures for the displayed line
{
    while ($cat['cat_view_level'] != '-1')
    {
        $sql = "SELECT pic_id, pic_desc, pic_cat_id FROM ". ALBUM_TABLE ." ORDER BY RAND() LIMIT 1";
        $result = $db->sql_query($sql) or die ("SQL Error");
        $row = $db->sql_fetchrow($result);
        $sql = "SELECT * FROM ". ALBUM_CAT_TABLE ." WHERE cat_id = '". $row['pic_cat_id'] ."'";
        $result = $db->sql_query($sql) or die ("SQL Error");
        $cat = $db->sql_fetchrow($result);
    }
    $cat['cat_view_level'] = '0';
    print "<td valign='top'><table><tr><td align='center'>" . $row['pic_title'] . "<br /></td></tr><tr><td align='center'><a href='". append_sid($phpbb_root_path ."album_showpage.". $phpEx ."?pic_id=" . $row['pic_id']) ."'><img width='95' height='85' alt='" . $row['pic_desc'] . "' src='". $phpbb_root_path ."album_thumbnail.". $phpEx ."?pic_id=" . $row['pic_id'] . "' class="ima_bottom"></a></td></tr></table></td>";
}

print "</tr>";
print "</table>";
?>

 



 
#1  Sat 08 Sep, 2007 14:20
newguy78Send private message  
Back to topPage bottom
Sponsors
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Offline lefty74 Male
Contributor
avatar
Joined: January 2007
Posts: 137

 
 
Reply with quote Download Post 
Post Re: Restricting Personal Galleries From Being Displayed 
 
i just looked at mine and i have

find
    $cat['cat_view_level'] = '0';

replace with
    $cat['cat_view_level'] = '1';
 



 
#2  Sat 08 Sep, 2007 23:35
lefty74Send private message  
Back to topPage bottom
Offline newguy78 
 
avatar
Joined: March 2007
Posts: 14

 
 
Reply with quote Download Post 
Post Re: Restricting Personal Galleries From Being Displayed 
 
Thanks for the reply, looks like the personal galleries pics are still showing up.
 



 
#3  Tue 11 Sep, 2007 21:04
newguy78Send private message  
Back to topPage bottom
Offline Artie Male
VIP
avatar
Joined: January 2007
Posts: 833
Location: usa.png Lone Star State
 
 
Reply with quote Download Post 
Post Re: Restricting Personal Galleries From Being Displayed 
 
I don't make any guarantees, but this may work

FIND
Code: [Download] [Hide] [Select]
for ($i=0;$i<4;$i++) //set number of pictures for the displayed line
{
    while ($cat['cat_view_level'] != '-1')
    {echo $cat['cat_view_level'].' CVL';
        $sql = "SELECT pic_id, pic_desc, pic_cat_id FROM ". ALBUM_TABLE ." ORDER BY RAND() LIMIT 1";
        $result = $db->sql_query($sql) or die ("SQL Error");
        $row = $db->sql_fetchrow($result);
        $sql = "SELECT * FROM ". ALBUM_CAT_TABLE ." WHERE cat_id = '". $row['pic_cat_id'] ."'";
        $result = $db->sql_query($sql) or die ("SQL Error");
        $cat = $db->sql_fetchrow($result);
    }
    $cat['cat_view_level'] = '0';
    print "<td valign='top'><table><tr><td align='center'>" . $row['pic_title'] . "<br /></td></tr><tr><td align='center'><a href='". append_sid($phpbb_root_path ."album_showpage.". $phpEx ."?pic_id=" . $row['pic_id']) ."'><img width='95' height='85' alt='" . $row['pic_desc'] . "' src='". $phpbb_root_path ."album_thumbnail.". $phpEx ."?pic_id=" . $row['pic_id'] . "' class="ima_bottom"></a></td></tr></table></td>";
}

REPLACE WITH
Code: [Download] [Hide] [Select]
$limit_sql = 4; //set number of pictures for the displayed line

$sql = "SELECT c.*, p.*
                FROM " . ALBUM_CAT_TABLE . " AS c
                LEFT JOIN " . ALBUM_TABLE . " AS p ON c.cat_id = p.pic_cat_id
                WHERE c.cat_user_id = 0 AND c.cat_view_level = -1 AND ( p.pic_approval = 1 OR c.cat_approval = 0 )
                ORDER BY RAND() LIMIT $limit_sql";

        $result = $db->sql_query($sql) or die ("SQL Error");

    while( $row = $db->sql_fetchrow($result) )
        {
            $randrow[] = $row;
        }

  for ($i=0;$i<$limit_sql;$i++)
    {  
       print "<td valign='top'><table><tr><td align='center'>" . $randrow[$i]['pic_title'] . "<br /></td></tr><tr><td align='center'><a href='". append_sid($phpbb_root_path ."album_showpage.". $phpEx ."?pic_id=" . $randrow[$i]['pic_id']) ."'><img width='95' height='85' alt='" . $randrow[$i]['pic_desc'] . "' src='". $phpbb_root_path ."album_thumbnail.". $phpEx ."?pic_id=" . $randrow[$i]['pic_id'] . "' class="ima_bottom"></a></td></tr></table></td>";
    }    

 



 
#4  Wed 12 Sep, 2007 02:43
ArtieSend private message  
Back to topPage bottom
Offline newguy78 
 
avatar
Joined: March 2007
Posts: 14

 
 
Reply with quote Download Post 
Post Re: Restricting Personal Galleries From Being Displayed 
 
Thank you, I will try your code tomorrow.
 



 
#5  Sat 15 Sep, 2007 06:46
newguy78Send private message  
Back to topPage bottom
Offline newguy78 
 
avatar
Joined: March 2007
Posts: 14

 
 
Reply with quote Download Post 
Post Re: Restricting Personal Galleries From Being Displayed 
 
Hey, I applied your code, and I noticed that the personal gallery pics don't appear.  The only problem is there is a pic description on top the thumbnail, and since I have this code repeated twice (so that I have two rows of 4 pics each) both rows display the same pics instead of them all being random.  I have a testing site at www.mysite.a1forums.com/index5.php if you need to see what I'm talking about.  Do you know how I can make all the photos random like before, with restricting the personal gallery pics? Also, sometimes if you refresh the screen it will show a broken thumb which leads to a pic that doesn't exist.
 



 
#6  Mon 17 Sep, 2007 17:20
newguy78Send private message  
Back to topPage bottom
Offline Artie Male
VIP
avatar
Joined: January 2007
Posts: 833
Location: usa.png Lone Star State
 
 
Reply with quote Download Post 
Post Re: Restricting Personal Galleries From Being Displayed 
 
If you don't want the pic title to display just remove this

Code: [Download] [Hide] [Select]
<tr><td align='center'>" . $randrow[$i]['pic_title'] . "<br /></td></tr>


Hmmm, don't know what's causing the empty thumbnail.

When I get some free time, I'll try to come up with something that will do what you want.
 



 
#7  Wed 19 Sep, 2007 17:49
ArtieSend private message  
Back to topPage bottom
Offline Artie Male
VIP
avatar
Joined: January 2007
Posts: 833
Location: usa.png Lone Star State
 
 
Reply with quote Download Post 
Post Re: Restricting Personal Galleries From Being Displayed 
 
Give this a try ....


Code: [Download] [Hide] [Select]
if(!defined('IN_PHPBB'))
{
    define('IN_PHPBB', true);
    $phpbb_root_path = './forum/'; //set your path
    $album_root_path = $phpbb_root_path . 'album_mod/';
    include($phpbb_root_path . 'extension.inc');
    include($phpbb_root_path . 'common.'.$phpEx);
}
else
{
    $album_root_path = $phpbb_root_path . 'album_mod/';
}


$language = $board_config['default_lang'];

if ( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_album_main.'.$phpEx) )
{
    $language = 'english'; // set your default language
}

include($phpbb_root_path . 'language/lang_' . $language . '/lang_album_main.' . $phpEx);

//total number of pictures for display is 8 (2 rows of 4)

    $sql = "SELECT p.*
                  FROM ". ALBUM_TABLE ." AS p
                    LEFT JOIN ". ALBUM_CAT_TABLE ." AS c ON p.pic_cat_id = c.cat_id
                  WHERE c.cat_user_id = 0 AND c.cat_view_level = -1 AND ( p.pic_approval = 1 OR c.cat_approval = 0 )
                   GROUP BY p.pic_id
                  ORDER BY RAND()
                  LIMIT 8";

        if( !($result = $db->sql_query($sql)) )
        {
            message_die(GENERAL_ERROR, 'Could not query rand pics information', '', __LINE__, __FILE__, $sql);
        }

   while( $row = $db->sql_fetchrow($result) )
        {
            $randrow[] = $row;
        }

echo '<div align="center">
      <table cellpadding="4" cellspacing="0" border="0">
        <tr>
            <th colspan="4">' . $lang['Random_Pics'] . '</th>
        </tr>
        <tr>';  

  for ($i = 0; $i < 8 ; $i++)
  {
    if ($i == 4){ echo '</tr><tr><td>&nbsp;</td></tr><tr>'; }

    echo '<td><div align="center"><a href="' . append_sid($phpbb_root_path ."album_showpage.". $phpEx ."?pic_id=" . $randrow[$i]['pic_id']) . '">
         <img src="'. $phpbb_root_path ."album_thumbnail.". $phpEx ."?pic_id=" . $randrow[$i]['pic_id'] .'"  border="0" alt="'. $randrow[$i]['pic_desc'] .'" width="95" height="85" class="ima_bottom">
         </a></div></td>';
  
  }
  
echo '</tr></table></div>';

 



 
#8  Wed 19 Sep, 2007 19:52
ArtieSend private message  
Back to topPage bottom
Offline newguy78 
 
avatar
Joined: March 2007
Posts: 14

 
 
Reply with quote Download Post 
Post Re: Restricting Personal Galleries From Being Displayed 
 
Thank you so very much, I believe your code worked    I've refreshed at least 10 times, and don't see any personal gallery pics.  Thank you again!
 



 
#9  Sat 22 Sep, 2007 17:40
newguy78Send private message  
Back to topPage bottom
Offline Artie Male
VIP
avatar
Joined: January 2007
Posts: 833
Location: usa.png Lone Star State
 
 
Reply with quote Download Post 
Post Re: Restricting Personal Galleries From Being Displayed 
 
You're very welcome  
 



 
#10  Mon 24 Sep, 2007 02:50
ArtieSend private message  
Back to topPage bottom
This forum is locked: you cannot post, reply or edit topics.  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML

Home » Forum » phpBB Mods And Styles » Archived phpBB Topics (Styles, Mods, Support)

The time now is Mon 28 Apr, 2025 12:57 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Enable KB mode Download Topic Printable Version Email to a Friend View next topic




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

  

 
 Powered by Icy Phoenix based on phpBB
Lo-Fi Version - Privacy Policy - Cookie Policy
Generation Time: 0.1606s (PHP: 12% SQL: 88%)
SQL queries: 13 - Debug Off - GZIP Enabled
Design by Luca Libralato 
  cron