######################################################## ## Mod Title: Gallery - phpBB2 Integration ## Mod Version: 1.4.3 ## ## $Date: 2003/08/10 18:23:24 $ ## $Revision: 1.1.2.1 $ ## ## Author: Martin (WebSnail) < www.snailsource.com > ## Description: This MOD integrates Gallery 1.3.4_pl1 ## with the phpBB2 users and usergroups (ver 2.0.6) ## ## Installation Level: Medium ## Installation Time: 10-15 Minutes ## Files To Edit: overall_header.tmpl ## page_header.php ######################################################## EDIT PhpBB2 Files Instructions. Files to Edit: ============== - includes/page_header.php - includes/sessions.php - templates/subSilver/overall_header.tpl - templates/subSilver/admin/auth_ug_body.tpl - admin/admin_ug_auth.php - language/lang_english/lang_main.php # #-----[ OPEN includes/page_header.php]------------------------------------------ # #-----[ FIND ]------------------------------------------ # 'T_SPAN_CLASS2' => $theme['span_class2'], 'T_SPAN_CLASS3' => $theme['span_class3'], # #-----[ AFTER, ADD ]------------------------------------------ # 'GALLERY_CODE' => $gallery_body, #-----[ FIND ]------------------------------------------ # 'L_WHOSONLINE_MOD' => sprintf($lang['Mod_online_color'], '', ''), # #-----[ AFTER, ADD ]------------------------------------------ # 'L_GALLERY' => $lang['Gallery'], #-----[ FIND ]------------------------------------------ # 'U_GROUP_CP' => append_sid('groupcp.'.$phpEx), # #-----[ AFTER, ADD ]------------------------------------------ # 'U_GALLERY' => append_sid('modules.'.$phpEx.'?op=modload&name=gallery&file=index'), # #-----[ OPEN includes/sessions.php]------------------------------------------ # #-----[ FIND ]------------------------------------------ # $session_id = ( isset($HTTP_GET_VARS['sid']) ) ? $HTTP_GET_VARS['sid'] : ''; # #-----[ AFTER, ADD ]------------------------------------------ # // MOD if(!isset($HTTP_GET_VARS['sid'])) { $session_id = ( isset($HTTP_POST_VARS['sid']) ) ? $HTTP_POST_VARS['sid'] : ''; } // MOD end # --- [ REPEAT!! (2 copies of code to edit) ] ------------------------------------- # #-----[ OPEN templates/subSilver/overall_header.tpl]------------------------------------------ # #-----[ FIND ]------------------------------------------ # # #-----[ BEFORE, ADD ]------------------------------------------ # #-----[ FIND ]------------------------------------------ # {L_USERGROUPS} # #-----[ AFTER, ADD ]------------------------------------------ # ${L_GALLERY}$ {L_GALLERY} # #-----[ OPEN templates/xxx/admin/auth_ug_body.tpl]------------------------------------------ # # #-----[ FIND ]------------------------------------------ #

{USER_LEVEL}

{USER_GROUP_MEMBERSHIPS}

{GROUP_MEMBERSHIP}

# #-----[ REPLACE WITH ]------------------------------------------ #

{USER_LEVEL}

{USER_GALLERY_LEVEL}

{USER_GROUP_MEMBERSHIPS}

{USER_GALLERY_LEVEL}

{GROUP_MEMBERSHIP}

# #-----[ OPEN admin/admin_ug_auth.php]------------------------------------------ # #-----[ FIND ]------------------------------------------ # $params = array('mode' => 'mode', 'user_id' => POST_USERS_URL, 'group_id' => POST_GROUPS_URL, 'adv' => 'adv'); while( list($var, $param) = @each($params) ) { if ( !empty($HTTP_POST_VARS[$param]) || !empty($HTTP_GET_VARS[$param]) ) { $$var = ( !empty($HTTP_POST_VARS[$param]) ) ? $HTTP_POST_VARS[$param] : $HTTP_GET_VARS[$param]; } else { $$var = ""; } } # #-----[ REPLACE WITH ]------------------------------------------ # $params = array('mode' => 'mode', 'user_id' => POST_USERS_URL, 'group_id' => POST_GROUPS_URL, 'adv' => 'adv', 'gallerylevel' => 'gallerylevel'); while( list($var, $param) = @each($params) ) { if ( isset($HTTP_POST_VARS[$param]) || isset($HTTP_GET_VARS[$param]) ) { $$var = ( isset($HTTP_POST_VARS[$param]) ) ? $HTTP_POST_VARS[$param] : $HTTP_GET_VARS[$param]; } else { $$var = ""; } } #-----[ FIND ]------------------------------------------ # if ( $mode == 'user' ) { $t_username = $ug_info[0]['username']; $s_user_type = ( $is_admin ) ? '' : ''; } else { $t_groupname = $ug_info[0]['group_name']; } # #-----[ AFTER, ADD ]------------------------------------------ # // MOD Gallery Integration // Query the appropriate table database re: group or user permissions. if ( $mode == 'user' ) { // Check the Users record $sql = "SELECT user_gallery_perm FROM ". $table_prefix ."users WHERE user_id = $user_id"; } else { // Check Group $sql = "SELECT group_gallery_perm FROM ". $table_prefix ."groups WHERE group_id = $group_id"; } $result = $db->sql_query($sql); if (!$result) { message_die(GENERAL_MESSAGE, 'Could not access the Gallery Permission for User'); } $user_temp = $db->sql_fetchrow($result); if ($mode == 'user') { $gallery_perm = $user_temp['user_gallery_perm']; } else { $gallery_perm = $user_temp['group_gallery_perm']; } if (!$gallery_perm && $gallery_perm !='0') { message_die(GENERAL_MESSAGE, 'Gallery Permissions Unavailable (ERR: ug_auth)'); } $gallery_levels[0] = $lang['View']; $gallery_levels[1] = $lang['Auth_User']; $gallery_levels[2] = $lang['Auth_Admin']; $s_gallery_type = "\n"; // End MOD Gallery Integration # #-----[ FIND ]------------------------------------------ # if ( isset($HTTP_POST_VARS['submit']) && ( ( $mode == 'user' && $user_id ) || ( $mode == 'group' && $group_id ) ) ) { $user_level = ''; if ( $mode == 'user' ) { // // Get group_id for this user_id // $sql = "SELECT g.group_id, u.user_level FROM " . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u, " . GROUPS_TABLE . " g WHERE u.user_id = $user_id AND ug.user_id = u.user_id AND g.group_id = ug.group_id AND g.group_single_user = " . TRUE; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not select info from user/user_group table', '', __LINE__, __FILE__, $sql); } $row = $db->sql_fetchrow($result); $group_id = $row['group_id']; $user_level = $row['user_level']; $db->sql_freeresult($result); } # #-----[ AFTER, ADD ]------------------------------------------ # // // MOD Gallery // Carry out update request for Gallery if ( $mode == 'user' && ($gallerylevel || $gallerylevel == '0')) { $sql = "UPDATE ". USERS_TABLE ." SET user_gallery_perm = ". $gallerylevel ." WHERE user_id = $user_id"; } if ( $mode == 'group' && ($gallerylevel || $gallerylevel == '0')) { $sql = "UPDATE ". GROUPS_TABLE ." SET group_gallery_perm = ". $gallerylevel ." WHERE group_id = $group_id"; } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not update Gallery level', '', __LINE__, __FILE__, $sql); } // END Mod Gallery # #-----[ FIND ]------------------------------------------ # $template->assign_vars(array( 'USERNAME' => $t_username, 'USER_LEVEL' => $lang['User_Level'] . " : " . $s_user_type, 'USER_GROUP_MEMBERSHIPS' => $lang['Group_memberships'] . ' : ' . $t_usergroup_list) # #-----[ REPLACE WITH ]------------------------------------------ # $template->assign_vars(array( 'USERNAME' => $t_username, 'USER_LEVEL' => $lang['User_Level'] . " : " . $s_user_type, 'USER_GALLERY_LEVEL' => "Gallery Level : " . $s_gallery_type, 'USER_GROUP_MEMBERSHIPS' => $lang['Group_memberships'] . ' : ' . $t_usergroup_list) # #-----[ FIND ]------------------------------------------ # $template->assign_vars(array( 'USERNAME' => $t_groupname, 'GROUP_MEMBERSHIP' => $lang['Usergroup_members'] . ' : ' . $t_usergroup_list) ); # #-----[ REPLACE WITH ]------------------------------------------ # $template->assign_vars(array( 'USERNAME' => $t_groupname, 'USER_GALLERY_LEVEL' => "Gallery Level : " . $s_gallery_type, 'GROUP_MEMBERSHIP' => $lang['Usergroup_members'] . ' : ' . $t_usergroup_list) ); # #-----[ OPEN language/lang_english/lang_main.php ]------------------------------------------ # # #-----[ FIND ]------------------------------------------ # // // That's all Folks! // ------------------------------------------------- # #-----[ BEFORE, ADD ]------------------------------------------ # // Added Gallery Integration mod $lang['Gallery'] = "Gallery";