count($_bb)) { // $_cpg is below $_bb $npath = ''; foreach($_bb as $key=>$path) { if ($path == $_cpg[$key]) continue; $npath.=$_cpg[$key].'/'; } $npath.=implode('/', array_slice($_cpg, $key+1)); } elseif (count($_bb) > count($_cpg)) { // $_bb is below $cpg $npath = ''; foreach($_cpg as $key=>$path) { if ($path == $_bb[$key]) continue; $npath.='../'; } $npath.=str_repeat('../', count($_bb) - ($key+1)); } else { // both on same level $npath = ''; foreach($_cpg as $key=>$path) { if ($path == $_bb[$key]) continue; $npath.='../'.$_cpg[$key]; } } return $npath; } class phpbb3_udb extends core_udb { function phpbb3_udb() { global $BRIDGE; if (!USE_BRIDGEMGR) { // the vars that are used when bridgemgr is disabled // URL of your punbb $this->boardurl = 'http://localhost/'; // local path to your punbb config file require_once('../config.php'); } else { // the vars from the bridgemgr $this->boardurl = $BRIDGE['full_forum_url']; require_once($BRIDGE['relative_path_to_config_file'] . 'config.php'); $this->use_post_based_groups = $BRIDGE['use_post_based_groups']; } $this->multigroups = 1; // Database connection settings $this->db = array( 'name' => $dbname, 'host' => $dbhost ? $dbhost : 'localhost', 'user' => $dbuser, 'password' => $dbpasswd, 'prefix' =>$table_prefix ); // Board table names $this->table = array( 'users' => 'users', 'groups' => 'groups', 'sessions' => 'sessions', 'usergroups' => 'user_group', 'sessionskeys' => 'sessions_keys' ); // Derived full table names $this->usertable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['users']; $this->groupstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups']; $this->sessionstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['sessions']; $this->usergroupstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['usergroups']; $this->sessionskeystable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['sessionskeys']; // Table field names $this->field = array( 'username' => 'username', // name of 'username' field in users table 'user_id' => 'user_id', // name of 'id' field in users table 'password' => 'user_password', // name of 'password' field in users table 'email' => 'user_email', // name of 'email' field in users table 'regdate' => 'user_regdate', // name of 'registered' field in users table 'active' => 'user_active', // is user account active? 'lastvisit' => 'user_lastvisit', // name of 'location' field in users table 'location' => 'user_from', // name of 'location' field in users table 'website' => 'user_website', // name of 'website' field in users table 'usertbl_group_id' => 'group_id', // name of 'group id' field in users table 'grouptbl_group_id' => 'group_id', // name of 'group id' field in groups table 'grouptbl_group_name' => 'group_name' // name of 'group name' field in groups table ); // Pages to redirect to $this->page = array( 'register' => '/ucp.php?mode=register', 'editusers' => '/memberlist.php', 'edituserprofile' => "/profile.php?mode=viewprofile&u=", ); // Group ids - admin and guest only. $this->admingroups = array(2); $this->guestgroup = 3; // Use a special function to collect groups for cpg groups table $this->group_overrride = 1; // get path for redirection $this->redirect_url = relative_paths(basename($_SERVER['PHP_SELF']), $BRIDGE['relative_path_to_config_file'].'config.php'); // Cookie settings - used in following functions only $this->cookie_name = $BRIDGE['cookie_prefix']; // Connect to db $this->connect(); } function collect_groups() { $sql ="SELECT * FROM {$this->groupstable} WHERE group_single_user = 0"; $result = cpg_db_query($sql, $this->link_id); $udb_groups = array(102 =>'Administrators', 2=> 'Registered', 3=>'Guests', 4=> 'Banned'); while ($row = mysql_fetch_assoc($result)) { $udb_groups[$row[$this->field['grouptbl_group_id']]+100] = utf_ucfirst(utf_strtolower($row[$this->field['grouptbl_group_name']])); } return $udb_groups; } // definition of how to extract id, name, group from a session cookie function session_extraction() { if (isset($_COOKIE[$this->cookie_name . '_sid'])) { $this->sid = addslashes($_COOKIE[$this->cookie_name . '_sid']); $sql = "SELECT u.{$this->field['user_id']} AS user_id, u.{$this->field['password']} AS password, u.user_type FROM {$this->usertable} AS u, {$this->sessionstable} AS s WHERE u.{$this->field['user_id']}=s.session_user_id AND s.session_id = '{$this->sid}' AND u.user_id > 0"; $result = cpg_db_query($sql, $this->link_id); if (mysql_num_rows($result)){ $row = mysql_fetch_array($result); if ($row['user_id'] != 1) { $this->userlevel = $row['user_level']; return $row; } else { return false; } } else { return false; } } } // Get groups of which user is member function get_groups($row) { global $_COOKIE, $BRIDGE; $data = array(); $user_id = $_COOKIE[$this->cookie_name.'_u']; $sql = "SELECT * FROM {$this->usergroupstable} WHERE user_id = $user_id and group_id = ".$BRIDGE['admin_group']; $result = cpg_db_query($sql, $this->link_id); if (mysql_fetch_row($result)) { $data[0] = 1; } else { $data[0] = 2; } return $data; } // definition of how to extract an id and password hash from a cookie function cookie_extraction() { $id = 0; $pass = ''; if (isset($_COOKIE[$this->cookie_name.'_data'])){ $sessiondata = unserialize($_COOKIE[$this->cookie_name.'_data']); $cookieid = $sessiondata['userid'] > 1 ? intval($sessiondata['userid']) : 0; $cookiepass = (isset($sessiondata['autologinid'])) ? addslashes($sessiondata['autologinid']) : ''; if (!$cookiepass) return false; $sql = "SELECT u.user_id, u.user_password, u.user_level ". "FROM {$this->sessionskeystable} AS s ". " INNER JOIN {$this->usertable} AS u ". " ON s.user_id = u.user_id ". "WHERE u.user_id = '$cookieid' ". " AND u.user_inactive_reason != 0 ". " AND s.key_id = MD5('$cookiepass')"; $result = cpg_db_query($sql, $this->link_id); list($id, $pass, $this->userlevel) = mysql_fetch_row($result); $this->sid = 0; } return ($id) ? array($id, $pass) : false; } // definition of actions required to convert a password from user database form to cookie form function udb_hash_db($password) { return $password; // unused } function login_page() { $this->redirect("ucp.php?mode=login&redirect={$this->redirect_url}"); } function logout_page() { $this->redirect("/ucp.php?mode=logout&sid={$this->sid}&redirect={$this->redirect_url}"); } function view_users() {} function view_profile() {} function get_users($options = array()) { global $CONFIG; // Copy UDB fields and config variables (just to make it easier to read) $f =& $this->field; $C =& $CONFIG; // Sort codes - global this in usermgr.php in 1.5 $sort_codes = array('name_a' => 'user_name ASC', 'name_d' => 'user_name DESC', 'group_a' => 'group_name ASC', 'group_d' => 'group_name DESC', 'reg_a' => 'user_regdate ASC', 'reg_d' => 'user_regdate DESC', 'pic_a' => 'pic_count ASC', 'pic_d' => 'pic_count DESC', 'disku_a' => 'disk_usage ASC', 'disku_d' => 'disk_usage DESC', 'lv_a' => 'user_lastvisit ASC', 'lv_d' => 'user_lastvisit DESC', ); $sql = "SELECT group_id, group_name, group_quota FROM {$C['TABLE_USERGROUPS']}"; $result = cpg_db_query($sql); $groups = $quotas = array(); while ($row = mysql_fetch_assoc($result)) { $groups[$row['group_id']] = $row['group_name']; $quotas[$row['group_id']] = $row['group_quota']; } if (in_array($options['sort'], array('group_a', 'group_d', 'pic_a', 'pic_d', 'disku_a', 'disku_d'))){ $sort = ''; list($this->sortfield, $this->sortdir) = explode(' ', $sort_codes[$options['sort']]); $this->adv_sort = true; } else { $sort = "ORDER BY " . $sort_codes[$options['sort']]; $this->adv_sort = false; } // Build WHERE clause, if this is a username search if ($options['search']) { $options['search'] = 'AND u.'.$f['username'].' LIKE "'.$options['search'].'" '; } // Main array to hold our user data $userlist = array(); // These sorting methods need the cpg pics table, do that first if (in_array($options['sort'], array('pic_a', 'pic_d', 'disku_a', 'disku_d'))){ $sql = "SELECT owner_id, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage FROM {$C['TABLE_PICTURES']} WHERE owner_id <> 0 GROUP BY owner_id ORDER BY {$sort_codes[$options['sort']]} LIMIT {$options['lower_limit']}, {$options['users_per_page']}"; $result = cpg_db_query($sql); // If no records, return empty value if (!mysql_num_rows($result)) { return array(); } while ($row = mysql_fetch_assoc($result)) $userlist[$row['owner_id']] = $row; mysql_free_result($result); $user_list_string = implode(', ', array_keys($userlist)); $sql = "SELECT u.{$f['user_id']} as user_id, u.user_level, {$f['username']} as user_name, {$f['email']} as user_email, {$f['regdate']} as user_regdate, {$f['lastvisit']} as user_lastvisit ". "FROM {$this->usertable} AS u ". "WHERE u.{$f['user_id']} IN ($user_list_string) GROUP BY u.{$f['user_id']}"; $result = cpg_db_query($sql, $this->link_id); // If no records, return empty value if (!mysql_num_rows($result)) { return array(); } while ($row = mysql_fetch_assoc($result)) $userlist[$row['user_id']] = array_merge($userlist[$row['user_id']], $row); mysql_free_result($result); } else { $sql = "SELECT u.{$f['user_id']} as user_id, u.user_level, {$f['username']} as user_name, {$f['email']} as user_email, {$f['regdate']} as user_regdate, {$f['lastvisit']} as user_lastvisit, 0 as pic_count ". "FROM {$this->usertable} AS u ". "WHERE u.{$f['user_id']} > 0 " . $options['search']. "GROUP BY u.{$f['user_id']} " . $sort . " LIMIT {$options['lower_limit']}, {$options['users_per_page']}"; $result = cpg_db_query($sql, $this->link_id); // If no records, return empty value if (!mysql_num_rows($result)) { return array(); } while ($row = mysql_fetch_assoc($result)) $userlist[$row['user_id']] = $row; mysql_free_result($result); $user_list_string = implode(', ', array_keys($userlist)); $sql = "SELECT owner_id, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage FROM {$C['TABLE_PICTURES']} WHERE owner_id IN ($user_list_string) GROUP BY owner_id"; $result = cpg_db_query($sql); while ($owner = mysql_fetch_assoc($result)) $userlist[$owner['owner_id']] = array_merge($userlist[$owner['owner_id']], $owner); } foreach ($userlist as $uid => $user){ $grps = array(); if ($this->use_post_based_groups){ $sql = "SELECT ug.{$this->field['usertbl_group_id']}+100 AS group_id FROM {$this->usertable} AS u, {$this->usergroupstable} AS ug, {$this->groupstable} as g WHERE u.{$this->field['user_id']}=ug.{$this->field['user_id']} AND u.{$this->field['user_id']}='$uid' AND g.{$this->field['grouptbl_group_id']} = ug.{$this->field['grouptbl_group_id']} AND group_single_user = 0"; $result = cpg_db_query($sql, $this->link_id); while ($row2 = mysql_fetch_array($result)) { $grps[] = $row2['group_id']; } if ($user['user_level'] == 1 || in_array($row[$this->field['usertbl_group_id']] , $this->admingroups)) array_unshift($grps, 102); if ($user['user_level'] == 0 || $user['user_level'] == 2) array_unshift($grps, 2); } else { $grps[0] = ($user['user_level'] == 1 || in_array($row[$this->field['usertbl_group_id']] , $this->admingroups)) ? 1 : 2; } $groupnames = $q = array(); foreach ($grps as $gid){ $groupnames[] = $groups[$gid]; $q[] = $quotas[$gid]; } sort($groupnames); $userlist[$uid]['group_name'] = implode('
' ,$groupnames); $userlist[$uid]['group_quota'] = max($q); } foreach ($userlist as $uid => $user) if (!isset($user['user_name'])) unset($userlist[$uid]); if ($this->adv_sort) usort($userlist, array('core_udb', 'adv_sort')); return $userlist; } } // and go ! $cpg_udb = new phpbb3_udb; ?>