Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro
Author Message
ciph3r
Worker
Worker


Joined: Jun 01, 2005
Posts: 178

PostPosted: Sat Feb 10, 2007 11:50 pm Reply with quote

Is there a mod for phpbb to give us the ability to create subforums??

I searched the forums, but couldnt find a solid answer.
I am currently using Ravenuked 2.02.02 with the latest sentinel installed.
I think we are using phpbb2.0.15, but it says i should check nukescripts for 2.0.22 so i dont think that is completely up to date.

Could anyone point me in the right direction for what I need?
Thx in advance.
 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Sun Feb 11, 2007 10:25 am Reply with quote

Yes. Search Google for subforums mod phpbb2
 
View user's profile Send private message
technocrat
Life Cycles Becoming CPU Cycles


Joined: Jul 07, 2005
Posts: 511

PostPosted: Mon Feb 12, 2007 12:46 pm Reply with quote

Simple SubForum mod is what you want. It's easy and has been ported, at least to Evo.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! / Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message
ciph3r
PostPosted: Mon Feb 12, 2007 8:07 pm Reply with quote

How do I upgrade our phpbb to the latest version? Would it be one of these packages: Only registered users can see links on this board! Get registered or login! or is there a rnuke update?
 
FireATST
RavenNuke(tm) Development Team


Joined: Jun 12, 2004
Posts: 637
Location: Ohio

PostPosted: Mon Feb 12, 2007 8:13 pm Reply with quote

If your site is php-nuke you don't want to use phpbb.com packages that are not modded for nuke...I think nukescripts.net has the mods for phpbb if I remember correctly.
 
View user's profile Send private message Visit poster's website MSN Messenger ICQ Number
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Mon Feb 12, 2007 8:21 pm Reply with quote

Only registered users can see links on this board! Get registered or login! has all the upgrade scripts for BBToNuke

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Dawg
RavenNuke(tm) Development Team


Joined: Nov 07, 2003
Posts: 910

PostPosted: Mon Feb 12, 2007 9:03 pm Reply with quote

technocrat wrote:
Simple SubForum mod is what you want. It's easy and has been ported, at least to Evo.


Do you happen to know where that (Simple SubForum mod) dload is ? I rooted around your site and several others and did not see it.

Thank You for your help!

Dawg
 
View user's profile Send private message
FireATST
PostPosted: Mon Feb 12, 2007 9:53 pm Reply with quote

aahhh..thanks evaders...that is the one I was thinking of. Must be getting old, can't remember things as I used to....Smile
 
FatGiant
New Member
New Member


Joined: Jan 09, 2005
Posts: 13

PostPosted: Tue Feb 13, 2007 3:47 am Reply with quote

Quote:
http://www.nukeresources.com has all the upgrade scripts for BBToNuke


Hi, I was looking also for the upgrade to the phpBB, I had already seen those at nukeresources, but was uncertain if they were appliable to RavenNuke 2.02.02.

Just to be sure, and before I ruin anything, can anyone confirm that? If so, the version to look for will be bbtoNuke 2.22 for nuke 7.6 ?

Yes, I'm quite new at this Embarassed

Thankyou all in advance...

EDIT:

The more I search the more doubts I get Rolling Eyes

I went to nukeresources now, and I find 2 versions of bbtonuke 2.0.22, one of them for patched nuke. Now I dont know what to do.

And also, do I have to install first the bbtonuke 2.0.21 ? If yes, wich?

Sorry...

_________________
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message
technocrat
PostPosted: Tue Feb 13, 2007 10:31 am Reply with quote

The evo version can be found (you need to register first) Only registered users can see links on this board! Get registered or login!

It SHOULD work for any other nuke versions
 
ciph3r
PostPosted: Tue Feb 13, 2007 11:02 am Reply with quote

evaders99 wrote:
http://www.nukeresources.com has all the upgrade scripts for BBToNuke


Im having trouble finding the update package from 2.0.15 to 2.0.22. Is there something im missing?

Thx so much for your help fellaz.
 
Gremmie
Former Moderator in Good Standing


Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Tue Feb 13, 2007 11:19 am Reply with quote

You have to incrementally apply the updates to ratchet yourself up to the latest version.

_________________
Only registered users can see links on this board! Get registered or login! - An Event Calendar for PHP-Nuke
Only registered users can see links on this board! Get registered or login! - A Google Maps Nuke Module 
View user's profile Send private message
ciph3r
PostPosted: Tue Feb 13, 2007 12:31 pm Reply with quote

Only registered users can see links on this board! Get registered or login!

So thats what i need to start with correct?
 
technocrat
PostPosted: Wed Feb 14, 2007 10:20 am Reply with quote

yes
 
ciph3r
PostPosted: Wed Feb 14, 2007 11:11 pm Reply with quote

Theres no quicker way to update?
 
evaders99
PostPosted: Thu Feb 15, 2007 4:30 pm Reply with quote

Not at the moment.

If you are using RavenNuke, don't worry. BBToNuke 2.0.22 will be added to the next (soon to be) release.
 
ciph3r
PostPosted: Thu Feb 15, 2007 7:33 pm Reply with quote

awesome...well, im updated......and i checked out subforum....and it doesnt seem to be compatible with phpnuke??

Quote:
No, you can't. You are running a nuked port of phpBB. It is a modified version of phpBB. The files from ths site only work for the standard phpBB anyway.
The Simple Subforums MOD in this topic will not work on a nuked port without modification. You can try this, [BETA]Simple subforums For Phpnuke. There is no guarantee that this will work and there is no support for this version. You are on your own with trying to get this to work with Ravennuked.


Any ideas?
 
technocrat
PostPosted: Fri Feb 16, 2007 10:09 am Reply with quote

You need a ported version. If you get it from the URL I posted before, it should work.
 
ciph3r
PostPosted: Fri Feb 16, 2007 7:31 pm Reply with quote

So far so good, all seems to be working well. I am having one issue though. . .Once I move a forum to another forum (creating a subforum) the parent forum no longer works.

I moved America's Army, into the Members Discussion forum, and now when I click on Members Discussion its like the page is all screwed up.
 
ciph3r
PostPosted: Fri Feb 16, 2007 7:47 pm Reply with quote

I seem to have narrowed it down to the last part of the readme, where it states to do this:
If I do not make this change, it seems to work correctly. . .What is this?
Code:
#-----[ FIND ]------------------------------------------

#
   $template->assign_block_vars('switch_no_topics', array() );

}

#
#-----[ AFTER, ADD ]------------------------------------------
#

// Begin Simple Subforums MOD
switch(SQL_LAYER)
{
   case 'postgresql':
      $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
         FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
         WHERE p.post_id = f.forum_last_post_id
            AND u.user_id = p.poster_id 
            AND f.forum_parent = '{$forum_id}'
            UNION (
               SELECT f.*, NULL, NULL, NULL, NULL
               FROM " . FORUMS_TABLE . " f
               WHERE NOT EXISTS (
                  SELECT p.post_time
                  FROM " . POSTS_TABLE . " p
                  WHERE p.post_id = f.forum_last_post_id 
               )
            )
            ORDER BY cat_id, forum_order";
      break;

   case 'oracle':
      $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
         FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
         WHERE p.post_id = f.forum_last_post_id(+)
            AND u.user_id = p.poster_id(+)
            AND f.forum_parent = '{$forum_id}'
         ORDER BY f.cat_id, f.forum_order";
      break;

   default:
      $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
         FROM (( " . FORUMS_TABLE . " f
         LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
         LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
         WHERE f.forum_parent = '{$forum_id}'
         ORDER BY f.cat_id, f.forum_order";
      break;
}
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not query subforums information', '', __LINE__, __FILE__, $sql);
}

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

if ( ($total_forums = count($subforum_data)) > 0 )
{
   //
   // Find which forums are visible for this user
   //
   $is_auth_ary = array();
   $is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $subforum_data);

   $display_forums = false;
   for( $j = 0; $j < $total_forums; $j++ )
   {
      if ( $is_auth_ary[$subforum_data[$j]['forum_id']]['auth_view'] )
      {
         $display_forums = true;
      }
   }
   
   if( !$display_forums )
   {
      $total_forums = 0;
   }
}

if( $total_forums )
{
   $template->assign_var('HAS_SUBFORUMS', 1);
   $template->assign_block_vars('catrow', array(
      'CAT_ID'   => $forum_id,
      'CAT_DESC'   => $forum_row['forum_name'],
      'U_VIEWCAT' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL ."=$forum_id"),
      ));

   //
   // Obtain a list of topic ids which contain
   // posts made since user last visited
   //
   if ( $userdata['session_logged_in'] )
   {
      $sql = "SELECT t.forum_id, t.topic_id, p.post_time
         FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p
         WHERE p.post_id = t.topic_last_post_id
            AND p.post_time > " . $userdata['user_lastvisit'] . "
            AND t.topic_moved_id = 0";
      if ( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not query new topic information', '', __LINE__, __FILE__, $sql);
      }

      $new_topic_data = array();
      while( $topic_data = $db->sql_fetchrow($result) )
      {
         $new_topic_data[$topic_data['forum_id']][$topic_data['topic_id']] = $topic_data['post_time'];
      }
      $db->sql_freeresult($result);
   }
   //
   // Obtain list of moderators of each forum
   // First users, then groups ... broken into two queries
   //
   $subforum_moderators = array();
   $sql = "SELECT aa.forum_id, u.user_id, u.username
      FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g, " . USERS_TABLE . " u
      WHERE aa.auth_mod = " . TRUE . "
         AND g.group_single_user = 1
         AND ug.group_id = aa.group_id
         AND g.group_id = aa.group_id
         AND u.user_id = ug.user_id
      GROUP BY u.user_id, u.username, aa.forum_id
      ORDER BY aa.forum_id, u.user_id";
   if ( !($result = $db->sql_query($sql, false, true)) )
   {
      message_die(GENERAL_ERROR, 'Could not query forum moderator information', '', __LINE__, __FILE__, $sql);
   }

   while( $row = $db->sql_fetchrow($result) )
   {
      $subforum_moderators[$row['forum_id']][] = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $row['user_id']) . '">' . UsernameColor($row['username']) . '</a>';
   }
   $db->sql_freeresult($result);
   
   $sql = "SELECT aa.forum_id, g.group_id, g.group_name
      FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g
      WHERE aa.auth_mod = " . TRUE . "
         AND g.group_single_user = 0
         AND g.group_type <> " . GROUP_HIDDEN . "
         AND ug.group_id = aa.group_id
         AND g.group_id = aa.group_id
      GROUP BY g.group_id, g.group_name, aa.forum_id
      ORDER BY aa.forum_id, g.group_id";
   if ( !($result = $db->sql_query($sql, false, true)) )
   {
      message_die(GENERAL_ERROR, 'Could not query forum moderator information', '', __LINE__, __FILE__, $sql);
   }

   while( $row = $db->sql_fetchrow($result) )
   {
      $subforum_moderators[$row['forum_id']][] = '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=" . $row['group_id']) . '">' .    GroupColor($row['group_name']) . '</a>';
   }
   $db->sql_freeresult($result);

   // show subforums
   for( $j = 0; $j < $total_forums; $j++ )
   {
      $subforum_id = $subforum_data[$j]['forum_id'];

      if ( $is_auth_ary[$subforum_id]['auth_view'] )
      {
         $unread_topics = false;
         if ( $subforum_data[$j]['forum_status'] == FORUM_LOCKED )
         {
            $folder_image = $images['forum_locked'];
            $folder_alt = $lang['Forum_locked'];
         }
         else
         {
            if ( $userdata['session_logged_in'] )
            {
               if ( !empty($new_topic_data[$subforum_id]) )
               {
                  $subforum_last_post_time = 0;

                  while( list($check_topic_id, $check_post_time) = @each($new_topic_data[$subforum_id]) )
                  {
                     if ( empty($tracking_topics[$check_topic_id]) )
                     {
                        $unread_topics = true;
                        $subforum_last_post_time = max($check_post_time, $subforum_last_post_time);
                     }
                     else
                     {
                        if ( $tracking_topics[$check_topic_id] < $check_post_time )
                        {
                           $unread_topics = true;
                           $subforum_last_post_time = max($check_post_time, $subforum_last_post_time);
                        }
                     }
                  }
                  if ( !empty($tracking_forums[$subforum_id]) )
                  {
                     if ( $tracking_forums[$subforum_id] > $subforum_last_post_time )
                     {
                        $unread_topics = false;
                     }
                  }
                  if ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) )
                  {
                     if ( $HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all'] > $subforum_last_post_time )
                     {
                        $unread_topics = false;
                     }
                  }

               }
            }

            $folder_image = ( $unread_topics ) ? $images['forum_new'] : $images['forum'];
            $folder_alt = ( $unread_topics ) ? $lang['New_posts'] : $lang['No_new_posts'];
         }

         $posts = $subforum_data[$j]['forum_posts'];
         $topics = $subforum_data[$j]['forum_topics'];

         if ( $subforum_data[$j]['forum_last_post_id'] )
         {
            $last_post_time = create_date($board_config['default_dateformat'], $subforum_data[$j]['post_time'], $board_config['board_timezone']);

            $last_post = $last_post_time . '<br />';

            $last_post .= ( $subforum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($subforum_data[$j]['post_username'] != '' ) ? $subforum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . '='  . $subforum_data[$j]['user_id']) . '">' . UsernameColor($subforum_data[$j]['username']) . '</a> ';
                        
            $last_post .= '<a href="' . append_sid("viewtopic.$phpEx?"  . POST_POST_URL . '=' . $subforum_data[$j]['forum_last_post_id']) . '#' . $subforum_data[$j]['forum_last_post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '" /></a>';
         }
         else
         {
            $last_post = $lang['No_Posts'];
         }

         if ( count($subforum_moderators[$subforum_id]) > 0 )
         {
            $l_moderators = ( count($subforum_moderators[$subforum_id]) == 1 ) ? $lang['Moderator'] : $lang['Moderators'];
            $moderator_list = implode(', ', $subforum_moderators[$subforum_id]);
         }
         else
         {
            $l_moderators = '&nbsp;';
            $moderator_list = '';
         }

         $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
         $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

         $template->assign_block_vars('catrow.forumrow',   array(
            'ROW_COLOR' => '#' . $row_color,
            'ROW_CLASS' => $row_class,
            'FORUM_FOLDER_IMG' => $folder_image,
            'FORUM_NAME' => $subforum_data[$j]['forum_name'],
            'FORUM_DESC' => $subforum_data[$j]['forum_desc'],
            'POSTS' => $subforum_data[$j]['forum_posts'],
            'TOPICS' => $subforum_data[$j]['forum_topics'],
            'LAST_POST' => $last_post,
            'MODERATORS' => $moderator_list,
            'ID' => $subforum_data[$j]['forum_id'],
            'UNREAD' => intval($unread_topics),
            'LAST_POST_TIME' => $last_post_time,

            'L_MODERATOR' => $l_moderators,
            'L_FORUM_FOLDER_ALT' => $folder_alt,

            'U_VIEWFORUM' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$subforum_id"))
         );

      }
   }
}
// End Simple Subforums MOD
 
ciph3r
PostPosted: Sat Feb 17, 2007 2:21 pm Reply with quote

d***, seems to be working for the most part, but im not getting any support over at the site it seems. Im guessing because im not using evo.

All is working correctly, except i noticed that when I add that last edit to the viewforum.php file when I go to a parent forum its all glitched up.....but if I remove it, you can go to the parent forum, but cant see the subforums once your in it.

Any help would be greatly appriciated.
 
ciph3r
PostPosted: Sat Feb 17, 2007 3:15 pm Reply with quote

fixed, it was something different in the evo versions viewforum.php.

I used the code from the phpbb release of subforums in that last section i pasted above, and all is working perfectly.

Thx guys!!
 
ciph3r
PostPosted: Sun Sep 02, 2007 2:24 pm Reply with quote

Ok guys, sorry to bring back an old post. . . but I cant seem to get this mod to work in the new ravennuke. Anyone have any ideas?
 
ciph3r
PostPosted: Sun Sep 02, 2007 2:37 pm Reply with quote

I noticed this in the Readme:
Code:
$category_rows = array();

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


$db->sql_freeresult($result); is not in the modules/forums/index.php file in this new rnuke, would that have something to do with it?
 
Gremmie
PostPosted: Sun Sep 02, 2007 4:04 pm Reply with quote

No, I would not expect that to make a bit of difference.
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©