Subversion Repositories svnkaklik

<?php

/*************************

  Coppermine Photo Gallery

  ************************

  Copyright (c) 2003-2005 Coppermine Dev Team

  v1.1 originaly written by Gregory DEMAR

  This program is free software; you can redistribute it and/or modify

  it under the terms of the GNU General Public License as published by

  the Free Software Foundation; either version 2 of the License, or

  (at your option) any later version.

  ********************************************

  Coppermine version: 1.3.3

  $Source: /cvsroot/coppermine/stable/bridge/woltlab21.inc.php,v $

  $Revision: 1.7 $

  $Author: gaugau $

  $Date: 2005/04/19 03:17:13 $

**********************************************/

// ------------------------------------------------------------------------- //

//  Woltlab Burning Board 2.1 Integration for Coppermine                     //

// ------------------------------------------------------------------------- //

//  Modify the values below according to your Board installation             //

// ------------------------------------------------------------------------- //

//  user contribution by sugar                                               //

// (see http://coppermine.sourceforge.net/oldboard/viewtopic.php?t=2547      //

//  for details)                                                             //

// ------------------------------------------------------------------------- //

// Updated by Mr. S                                                          //

// http://coppermine.sourceforge.net/board/index.php?topic=5559.0            //

// ------------------------------------------------------------------------- //

// In this example there are 2 subdirectories

// WBB: http://yoursite_name.com/wbb2/

// CPG: http://yoursite_name.com/cpg/

// Setup path to your Woltlab Board directory to change this

// The paths to your Woltlab Board directory

define('RELATIVE_WBB_PATH','../wbb2/');

define('WBB_WEB_PATH','/wbb2/');

// database configuration

require_once(RELATIVE_WBB_PATH."acp/lib/config.inc.php");

require_once(RELATIVE_WBB_PATH."acp/lib/options.inc.php");

define('WBB_DB_NAME',$sqldb);

define('WBB_BD_HOST',$sqlhost);

define('WBB_DB_USERNAME',$sqluser);

define('WBB_DB_PASSWORD',$sqlpassword);

// cookies configuration

define('WBB_COOKIE_HASH',$cookieprefix."cookiehash");

define('WBB_COOKIE_USERID',$cookieprefix."userid");

define('WBB_COOKIE_USERPW',$cookieprefix."userpassword");

// ------------------------------------------------------------------------- //

//  Nothing to edit below this line

// ------------------------------------------------------------------------- //

// Prefix and names for the database tables

define('WBB_TABLE_PREFIX','bb'.$n.'_');    // Leave empty, not supported by vBulletin 2.3

define('WBB_USER_TABLE', 'users');      // The members table

define('WBB_SESSION_TABLE', 'sessions');   // The sessions table

define('WBB_GROUP_TABLE', 'groups');   // The groups table

// Group definitions (default values used by the board)

define('WBB_GUEST_GROUP', 5);

define('WBB_MEMBERS_GROUP', 4);

define('WBB_ADMIN_GROUP', 1);

// Authenticate a user using cookies

function udb_authenticate()

{

   global $HTTP_COOKIE_VARS, $USER_DATA, $UDB_DB_LINK_ID, $UDB_DB_NAME_PREFIX, $CONFIG;

   global $HTTP_SERVER_VARS, $REMOTE_ADDR, $HTTP_X_FORWARDED_FOR;

   global $lang_errors;

   // For error checking

   $CONFIG['TABLE_USERS'] = '**ERROR**';

   // Permissions for a default group

   $default_group = array(

      'group_id' => WBB_GUEST_GROUP,

      'group_name' => 'Unknown',

      'has_admin_access' => 0,

      'can_see_all_albums' => 0,

      'can_send_ecards' => 0,

      'can_rate_pictures' => 0,

      'can_post_comments' => 0,

      'can_upload_pictures' => 0,

      'can_create_albums' => 0,

      'pub_upl_need_approval' => 1,

      'priv_upl_need_approval' => 1,

      'upload_form_config' => 0,

      'custom_user_upload' => 0,

      'num_file_upload' => 0,

      'num_URI_upload' => 0,

   );

   $REMOTE_ADDR=$_SERVER['REMOTE_ADDR'];

   $HTTP_X_FORWARDED_FOR=(isset($_SERVER['HTTP_X_FORWARDED_FOR'])) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : '';

   if($HTTP_X_FORWARDED_FOR!="") {

      if(preg_match("/^([0-9]+\.[0-9]+\.[0-9]+\.[0-9]+)/", $HTTP_X_FORWARDED_FOR, $ip_match)) {

         $private_ip_list = array("/^0\./", "/^127\.0\.0\.1/", "/^192\.168\..*/", "/^172\.16\..*/", "/^10..*/", "/^224..*/", "/^240..*/");

         $REMOTE_ADDR = preg_replace($private_ip_list, $REMOTE_ADDR, $ip_match[1]);

      }

   }

   $HTTP_USER_AGENT = substr($_SERVER['HTTP_USER_AGENT'], 0, 100);

   $REQUEST_URI = $_SERVER['REQUEST_URI'];

   if(!$REQUEST_URI) {

      if($_SERVER['PATH_INFO']) $REQUEST_URI = $_SERVER['PATH_INFO'];

      else $REQUEST_URI = $_SERVER['PHP_SELF'];

      if($_SERVER['QUERY_STRING']) $REQUEST_URI.="?".$_SERVER['QUERY_STRING'];

   }

   $REQUEST_URI = substr(basename($REQUEST_URI), 0, 250);

   if(!strstr($REQUEST_URI,".")) $REQUEST_URI="index.php";

   $REMOTE_ADDR=htmlspecialchars($REMOTE_ADDR);

   $HTTP_USER_AGENT=htmlspecialchars($HTTP_USER_AGENT);

   if ( is_array($_COOKIE) ) {

      $sessionhash = isset($_COOKIE[WBB_COOKIE_HASH]) ? $_COOKIE[WBB_COOKIE_HASH] : '';

      $bbuserid = isset($_COOKIE[WBB_COOKIE_USERID]) ? $_COOKIE[WBB_COOKIE_USERID] : 0;

      $bbpassword = isset($_COOKIE[WBB_COOKIE_USERPW]) ? $_COOKIE[WBB_COOKIE_USERPW] : '';

   }

   if ($bbuserid && $bbpassword) {

      // If userid and password exist in cookies we use them to login

       $sql =  "SELECT userid as user_id, username as user_name, useronlinegroupid as mgroup ".

            "FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE." ".

            "WHERE userid='".addslashes($bbuserid)."' AND password='".addslashes($bbpassword)."'";

   } elseif ($sessionhash) {

      // session hash exists

      // validate it:

      $sql =  "SELECT * ".

            "FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_SESSION_TABLE." ".

            "WHERE sessionhash = '".addslashes($sessionhash)."' ".

            " AND ipaddress = '".addslashes($REMOTE_ADDR)."' ".

            " AND useragent = '".addslashes($HTTP_USER_AGENT)."'";

      $result = db_query($sql, $UDB_DB_LINK_ID);

      if (mysql_num_rows($result)) {

          // session hash exists

         $session_data = mysql_fetch_array($result);

         mysql_free_result($result);

          $sql =  "SELECT userid as user_id, username as user_name, useronlinegroupid as mgroup ".

               "FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE." ".

               "WHERE userid='".$session_data['userid']."'";

         $result = db_query($sql, $UDB_DB_LINK_ID);

      } else {

          $sql =  "SELECT userid as user_id, username as user_name, useronlinegroupid as mgroup ".

               "FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE." ".

               "WHERE 0";

      }

   } else {

      $sql =  "SELECT userid as user_id, username as user_name, useronlinegroupid as mgroup ".

            "FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE." ".

            "WHERE 0";

   }

   $result = db_query($sql, $UDB_DB_LINK_ID);

   if (mysql_num_rows($result)){

      $USER_DATA = mysql_fetch_array($result);

      mysql_free_result($result);

       define('USER_ID', (int)$USER_DATA['user_id']);

       define('USER_NAME', $USER_DATA['user_name']);

      // Retrieve group information

      $sql = "SELECT * ".

            "FROM {$CONFIG['TABLE_USERGROUPS']} ".

            "WHERE group_id = '{$USER_DATA['mgroup']}'";

      $result = db_query($sql);

      if (mysql_num_rows($result)){

         $USER_DATA2 = mysql_fetch_array($result);

      } else {

         $USER_DATA2 = $default_group;

      }

      $USER_DATA = array_merge($USER_DATA, $USER_DATA2);

                $USER_DATA['has_admin_access']= ($USER_DATA['mgroup'] == WBB_ADMIN_GROUP);

                $USER_DATA['can_see_all_albums'] = $USER_DATA['has_admin_access'];

                $USER_DATA['groups'] = array($USER_DATA['group_id']);

       define('USER_GROUP', $USER_DATA['group_name']);

      define('USER_GROUP_SET', '('.$USER_DATA['group_id'].')');

       define('USER_IS_ADMIN', ($USER_DATA['mgroup'] == WBB_ADMIN_GROUP));

       define('USER_CAN_SEND_ECARDS', (int)$USER_DATA['can_send_ecards']);

       define('USER_CAN_RATE_PICTURES', (int)$USER_DATA['can_rate_pictures']);

       define('USER_CAN_POST_COMMENTS', (int)$USER_DATA['can_post_comments']);

       define('USER_CAN_UPLOAD_PICTURES', (int)$USER_DATA['can_upload_pictures']);

       define('USER_CAN_CREATE_ALBUMS', (int)$USER_DATA['can_create_albums']);

       define('USER_UPLOAD_FORM', (int)$USER_DATA['upload_form_config']);

       define('CUSTOMIZE_UPLOAD_FORM', (int)$USER_DATA['custom_user_upload']);

       define('NUM_FILE_BOXES', (int)$USER_DATA['num_file_upload']);

       define('NUM_URI_BOXES', (int)$USER_DATA['num_URI_upload']);

      mysql_free_result($result);

   } else {

       $result = db_query("SELECT * FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_id = ".WBB_GUEST_GROUP);

      if (!mysql_num_rows($result)) {

         $USER_DATA = $default_group;

      } else {

         $USER_DATA = mysql_fetch_array($result);

      }

            $USER_DATA['groups'] = array(WBB_GUEST_GROUP);

       define('USER_ID', 0);

       define('USER_NAME', 'Anonymous');

      define('USER_GROUP_SET', '('.WBB_GUEST_GROUP.')');

       define('USER_IS_ADMIN', 0);

       define('USER_CAN_SEND_ECARDS', (int)$USER_DATA['can_send_ecards']);

       define('USER_CAN_RATE_PICTURES', (int)$USER_DATA['can_rate_pictures']);

       define('USER_CAN_POST_COMMENTS', (int)$USER_DATA['can_post_comments']);

       define('USER_CAN_UPLOAD_PICTURES', (int)$USER_DATA['can_upload_pictures']);

       define('USER_CAN_CREATE_ALBUMS', 0);

       define('USER_UPLOAD_FORM', (int)$USER_DATA['upload_form_config']);

       define('CUSTOMIZE_UPLOAD_FORM', (int)$USER_DATA['custom_user_upload']);

       define('NUM_FILE_BOXES', (int)$USER_DATA['num_file_upload']);

       define('NUM_URI_BOXES', (int)$USER_DATA['num_URI_upload']);

      mysql_free_result($result);

   }

}

// Retrieve the name of a user

function udb_get_user_name($uid)

{

   global $UDB_DB_LINK_ID, $UDB_DB_NAME_PREFIX, $CONFIG;

   $sql = "SELECT username as user_name ".

         "FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE." ".

         "WHERE userid = '$uid'";

   $result = db_query($sql, $UDB_DB_LINK_ID);

   if (mysql_num_rows($result)) {

       $row = mysql_fetch_array($result);

      mysql_free_result($result);

      return $row['user_name'];

   } else {

      return '';

   }

}

// Retrieve the name of a user (Added to fix banning w/ bb integration - Nibbler)

function udb_get_user_id($username)

{

    global $UDB_DB_LINK_ID, $UDB_DB_NAME_PREFIX, $CONFIG;

    $username = addslashes($username);

       $sql = "SELECT userid as user_id ".

         "FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE." ".

         "WHERE username = '$username'";

    $result = db_query($sql, $UDB_DB_LINK_ID);

    if (mysql_num_rows($result)) {

        $row = mysql_fetch_array($result);

        mysql_free_result($result);

        return $row['user_id'];

    } else {

        return '';

    }

}

// Redirect

function udb_redirect($target)

{

    header('Location: http://' . $_SERVER['HTTP_HOST'] . WBB_WEB_PATH . $target);

    exit;

}

// Register

function udb_register_page()

{

   $target = 'register.php';

   udb_redirect($target);

}

// Login

function udb_login_page()

{

   $target = 'index.php';

   udb_redirect($target);

}

// Logout

function udb_logout_page()

{

   $target = 'logout.php';

   udb_redirect($target);

}

// Edit users

function udb_edit_users()

{

   $target = 'acp/users.php';

   udb_redirect($target);

}

// Get user information

function udb_get_user_infos($uid)

{

   global $CONFIG, $UDB_DB_NAME_PREFIX, $UDB_DB_LINK_ID;

   global $lang_register_php;

   $sql = "SELECT username as user_name, useronlinegroupid as mgroup, email as user_email, regdate as user_regdate, ".

         "homepage as user_website ".

         "FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE." ".

         "WHERE userid = '$uid'";

   $result = db_query($sql, $UDB_DB_LINK_ID);

   if(!mysql_num_rows($result)) cpg_die(ERROR, $lang_register_php['err_unk_user'], __FILE__, __LINE__);

   $user_data = mysql_fetch_array($result);

   mysql_free_result($result);

   $user_data['group_name'] = '';

   $user_data['user_occupation'] = '';

   $user_data['user_location'] = '';

   $user_data['user_interests'] = '';

   $sql =  "SELECT group_name ".

         "FROM {$CONFIG['TABLE_USERGROUPS']} ".

         "WHERE group_id = {$user_data['mgroup']} ";

   $result = db_query($sql);

   if(mysql_num_rows($result)){

      $row = mysql_fetch_array($result);

      $user_data['group_name'] = $row['group_name'];

   }

   mysql_free_result($result);

   return $user_data;

}

// Edit user profile

function udb_edit_profile($uid)

{

   $target = 'usercp.php';

   udb_redirect($target);

}

// Query used to list users

function udb_list_users_query(&$user_count)

{

   global $CONFIG, $FORBIDDEN_SET;

    if ($FORBIDDEN_SET != "") $forbidden = "AND $FORBIDDEN_SET";

   $sql =  "SELECT (category - ".FIRST_USER_CAT.") as user_id,".

         "      '???' as user_name,".

         "      COUNT(DISTINCT a.aid) as alb_count,".

         "      COUNT(DISTINCT pid) as pic_count,".

         "      MAX(pid) as thumb_pid ".

         "FROM {$CONFIG['TABLE_ALBUMS']} AS a ".

         "INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON p.aid = a.aid ".

         "WHERE approved = 'YES' AND category > ".FIRST_USER_CAT." ".

         "$forbidden ".

         "GROUP BY category ".

         "ORDER BY category ";

   $result = db_query($sql);

   $user_count = mysql_num_rows($result);

   return $result;

}

function udb_list_users_retrieve_data($result, $lower_limit, $count)

{

   global $CONFIG, $UDB_DB_NAME_PREFIX, $UDB_DB_LINK_ID;

   mysql_data_seek($result, $lower_limit);

   $rowset = array();

   $i=0;

   $user_id_set='';

   while (($row = mysql_fetch_array($result)) && ($i++ < $count)){

      $user_id_set .= $row['user_id'].',';

      $rowset[] = $row;

   }

   mysql_free_result($result);

   $user_id_set = '('.substr($user_id_set, 0, -1).')';

   $sql = "SELECT userid as user_id, username as user_name ".

         "FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE." ".

         "WHERE userid IN $user_id_set";

   $result = db_query($sql, $UDB_DB_LINK_ID);

   while ($row = mysql_fetch_array($result)){

      $name[$row['user_id']] = $row['user_name'];

   }

   for($i=0; $i<count($rowset); $i++){

      $rowset[$i]['user_name'] = empty($name[$rowset[$i]['user_id']]) ? '???' : $name[$rowset[$i]['user_id']];

   }

   return $rowset;

}

// Group table synchronisation

function udb_synchronize_groups()

{

   global $CONFIG, $UDB_DB_NAME_PREFIX, $UDB_DB_LINK_ID;

   $result = db_query("SELECT groupid, title FROM ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_GROUP_TABLE." WHERE 1", $UDB_DB_LINK_ID);

   while ($row = mysql_fetch_array($result)){

      $WBB_groups[$row['groupid']] = $row['title'];

   }

   mysql_free_result($result);

   $result=db_query("SELECT group_id, group_name FROM {$CONFIG['TABLE_USERGROUPS']} WHERE 1");

   while ($row = mysql_fetch_array($result)){

      $cpg_groups[$row['group_id']] = $row['group_name'];

   }

   mysql_free_result($result);

   // Scan Coppermine groups that need to be deleted

   foreach($cpg_groups as $c_group_id => $c_group_name){

      if ((!isset($WBB_groups[$c_group_id]))) {

            db_query("DELETE FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_id = '".$c_group_id."' LIMIT 1");

         unset($cpg_groups[$c_group_id]);

      }

   }

   // Scan Woltlab Board groups that need to be created inside Coppermine table

   foreach($WBB_groups as $i_group_id => $i_group_name){

      if ((!isset($cpg_groups[$i_group_id]))) {

         db_query("INSERT INTO {$CONFIG['TABLE_USERGROUPS']} (group_id, group_name) VALUES ('$i_group_id', '".addslashes($i_group_name)."')");

         $cpg_groups[$i_group_id] = $i_group_name;

      }

   }

   // Update Group names

   foreach($WBB_groups as $i_group_id => $i_group_name){

      if ($cpg_groups[$i_group_id] != $i_group_name) {

         db_query("UPDATE {$CONFIG['TABLE_USERGROUPS']} SET group_name = '".addslashes($i_group_name)."' WHERE group_id = '$i_group_id' LIMIT 1");

      }

   }

}

// Retrieve the album list used in gallery admin mode

function udb_get_admin_album_list()

{

   global $CONFIG, $UDB_DB_NAME_PREFIX, $UDB_DB_LINK_ID, $FORBIDDEN_SET;

   if (UDB_CAN_JOIN_TABLES) {

      $sql = "SELECT aid, CONCAT('(', username, ') ', a.title) AS title ".

            "FROM {$CONFIG['TABLE_ALBUMS']} AS a ".

            "INNER JOIN ".$UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE." AS u ON category = (".FIRST_USER_CAT." + userid) ".

            "ORDER BY title";

      return $sql;

   } else {

      $sql = "SELECT aid, IF(category > ".FIRST_USER_CAT.", CONCAT('* ', title), CONCAT(' ', title)) AS title ".

            "FROM {$CONFIG['TABLE_ALBUMS']} ".

            "ORDER BY title";

      return $sql;

   }

}

function udb_util_filloptions()

{

    global $albumtbl, $picturetbl, $categorytbl, $lang_util_php, $CONFIG, $UDB_DB_NAME_PREFIX, $UDB_DB_LINK_ID;

    $usertbl = $UDB_DB_NAME_PREFIX.WBB_TABLE_PREFIX.WBB_USER_TABLE;

    if (UDB_CAN_JOIN_TABLES) {

        $query = "SELECT aid, category, IF(username IS NOT NULL, CONCAT('(', username, ') ', a.title), CONCAT(' - ', a.title)) AS title " . "FROM $albumtbl AS a " . "LEFT JOIN $usertbl AS u ON category = (" . FIRST_USER_CAT . " + userid) " . "ORDER BY category, title";

        $result = db_query($query, $UDB_DB_LINK_ID);

        // $num=mysql_numrows($result);

        echo '<select size="1" name="albumid">';

        while ($row = mysql_fetch_array($result)) {

            $sql = "SELECT name FROM $categorytbl WHERE cid = " . $row["category"];

            $result2 = db_query($sql);

            $row2 = mysql_fetch_array($result2);

            print "<option value=\"" . $row["aid"] . "\">" . $row2["name"] . $row["title"] . "</option>\n";

        }

        print '</select> (3)';

        print '&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" value="'.$lang_util_php['submit_form'].'" class="submit" /> (4)';

        print '</form>';

    } else {

        // Query for list of public albums

        $public_albums = db_query("SELECT aid, title, category FROM {$CONFIG['TABLE_ALBUMS']} WHERE category < " . FIRST_USER_CAT . " ORDER BY title");

        if (mysql_num_rows($public_albums)) {

            $public_result = db_fetch_rowset($public_albums);

        } else {

            $public_result = array();

        }

        // Initialize $merged_array

        $merged_array = array();

        // Count the number of albums returned.

        $end = count($public_result);

        // Cylce through the User albums.

        for($i=0;$i<$end;$i++) {

            //Create a new array sow we may sort the final results.

            $merged_array[$i]['id'] = $public_result[$i]['aid'];

            $merged_array[$i]['album_name'] = $public_result[$i]['title'];

            // Query the database to get the category name.

            $vQuery = "SELECT name, parent FROM " . $CONFIG['TABLE_CATEGORIES'] . " WHERE cid='" . $public_result[$i]['category'] . "'";

            $vRes = mysql_query($vQuery);

            $vRes = mysql_fetch_array($vRes);

            if (isset($merged_array[$i]['username_category'])) {

                $merged_array[$i]['username_category'] = (($vRes['name']) ? '(' . $vRes['name'] . ') ' : '').$merged_array[$i]['username_category'];

            } else {

                $merged_array[$i]['username_category'] = (($vRes['name']) ? '(' . $vRes['name'] . ') ' : '');

            }

        }

        // We transpose and divide the matrix into columns to prepare it for use in array_multisort().

        foreach ($merged_array as $key => $row) {

           $aid[$key] = $row['id'];

           $title[$key] = $row['album_name'];

           $album_lineage[$key] = $row['username_category'];

        }

        // We sort all columns in descending order and plug in $album_menu at the end so it is sorted by the common key.

        array_multisort($album_lineage, SORT_ASC, $title, SORT_ASC, $aid, SORT_ASC, $merged_array);

        // Query for list of user albums

        $user_albums = db_query("SELECT aid, title, category FROM {$CONFIG['TABLE_ALBUMS']} WHERE category >= " . FIRST_USER_CAT . " ORDER BY aid");

        if (mysql_num_rows($user_albums)) {

            $user_albums_list = db_fetch_rowset($user_albums);

        } else {

            $user_albums_list = array();

        }

        // Query for list of user IDs and names

        $user_album_ids_and_names = db_query("SELECT (userid + ".FIRST_USER_CAT.") as id, CONCAT('(', username, ') ') as name FROM $usertbl ORDER BY name ASC",$UDB_DB_LINK_ID);

        if (mysql_num_rows($user_album_ids_and_names)) {

            $user_album_ids_and_names_list = db_fetch_rowset($user_album_ids_and_names);

        } else {

            $user_album_ids_and_names_list = array();

        }

        // Glue what we've got together.

        // Initialize $udb_i as a counter.

        if (count($merged_array)) {

            $udb_i = count($merged_array);

        } else {

            $udb_i = 0;

        }

        //Begin a set of nested loops to merge the various query results.

        foreach ($user_albums_list as $aq) {

            foreach ($user_album_ids_and_names_list as $uq) {

                if ($aq['category'] == $uq['id']) {

                    $merged_array[$udb_i]['id']= $aq['category'];

                    $merged_array[$udb_i]['album_name']= $aq['title'];

                    $merged_array[$udb_i]['username_category']= $uq['name'];

                    $udb_i++;

                }

            }

        }

        // The user albums and public albums have been merged into one list. Print the dropdown.

        echo '<select size="1" name="albumid">';

        foreach ($merged_array as $menu_item) {

            echo "<option value=\"" . $menu_item['id'] . "\">" . (isset($menu_item['username_category']) ? $menu_item['username_category'] : '') . $menu_item['album_name'] . "</option>\n";

        }

        // Close list, etc.

        print '</select> (3)';

        print '&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" value="'.$lang_util_php['submit_form'].'" class="submit" /> (4)';

        print '</form>';

    }

}

// ------------------------------------------------------------------------- //

// Define wheter we can join tables or not in SQL queries (same host & same db or user)

define('UDB_CAN_JOIN_TABLES', (WBB_BD_HOST == $CONFIG['dbserver'] && (WBB_DB_NAME == $CONFIG['dbname'] || WBB_DB_USERNAME == $CONFIG['dbuser'])));

// Connect to Woltlab Board Database if necessary

$UDB_DB_LINK_ID = 0;

$UDB_DB_NAME_PREFIX = WBB_DB_NAME ? '`'.WBB_DB_NAME.'`.' : '';

if (!UDB_CAN_JOIN_TABLES) {

   $UDB_DB_LINK_ID = @mysql_connect(WBB_BD_HOST, WBB_DB_USERNAME, WBB_DB_PASSWORD);

   if (!$UDB_DB_LINK_ID) die("<b>Coppermine critical error</b>:<br />Unable to connect to Woltlab Board database !<br /><br />MySQL said: <b>".mysql_error()."</b>");

}

?>