I was just trying to install Gallery on an Enigma based site ( http://www.lunabyte.com ) which is portal software for YaBB SE. I got everything to install fine with the bridge script, but when I go to the index.php page I get a page telling me I'm banned.
Are the changes between Enigma and YaBB SE big enough where Coppermne won't work? If so, is there any easy fix to make it go?
You can take a peek here: http://www.silverdragonden.com/enigma and the gallery is here: http://www.silverdragonden.com/enigma/gallery
Any help is *greatly* appreciated.
-Y
we don't know, since none of the devs runs enigma afaik. Maybe you want to post this question on the proper yabbse thread (http://www.yabbse.org/community/index.php?thread=24525)...
GauGau
Actually...I am running Enigma with the older version of the bridge file from the original Yabbse thread. I have not tried to utilize the latest bridge file that shipped with coppermine 1.2.1, but I would bet there is a problem because of Enigma's new permission group ID system. I could be wrong though. I will look into this and get back with you all. Also try posting this at lunabyte.com and see if anyone over there can help. I know Michele had it working back during the alpha testing that I helped with.
OK....I have made a couple changes to the yabbse bridge file so that it works better with Enigma/LSP's yabbse based portal. I cannot reproduce the banning problems. Please test this, but be warned I used winmerge to basically compare the old version that I had working and made the following changes to make it more enigma freindly (noted in
BOLD):
Quote<?php
// ------------------------------------------------------------------------- //
// Coppermine Photo Gallery 1.2.1 //
// ------------------------------------------------------------------------- //
// Copyright (C) 2002,2003 Gregory DEMAR //
// http://www.chezgreg.net/coppermine/ //
// ------------------------------------------------------------------------- //
// Updated by the Coppermine Dev Team //
// (http://coppermine.sf.net/team/) //
// see /docs/credits.html for details //
// ------------------------------------------------------------------------- //
// 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. //
// ------------------------------------------------------------------------- //
// YaBB SE 1.5.4 Integration for Coppermine
// ------------------------------------------------------------------------- //
// Modify the value below according to your Board installation
// ------------------------------------------------------------------------- //
// Set this to the location of your Settings file
require_once("../yabbse/Settings.php");
// ------------------------------------------------------------------------- //
// Nothing to edit below this line
// ------------------------------------------------------------------------- //
// other includes
require_once("$sourcedir/Load.php");
require_once("$sourcedir/Security.php");
// database configuration
define('YS_DB_NAME', $db_name); // The name of the database used by the board
define('YS_DB_HOST', $db_server); // The name of the database server
define('YS_DB_USERNAME', $db_user); // The username to use to connect to the database
define('YS_DB_PASSWORD', $db_passwd); // The password to use to connect to the database
// The web path to your YaBB SE Board directory
// In this example http://yoursite_name.com/yabbse/
define('YS_WEB_PATH', "$boardurl/");
// The Name of the Cookie used for YaBBSE logon
define('YS_COOKIE_NAME', $cookiename);
// Prefix for the database tables
define('YS_TABLE_PREFIX', $db_prefix); // Table Prefix
// Names for the database tables
define('YS_USER_TABLE', 'members'); // The members table
define('YS_GROUP_TABLE', 'membergroups'); // The groups table
// Group definitions (default values used by the board)
define('YS_GMOD_GROUP', 5);
define('YS_BANNED_GROUP', 4);
define('YS_GUEST_GROUP', 3);
define('YS_MEMBERS_GROUP', 2);
define('YS_ADMIN_GROUP', 1);
define('CM_ADMIN_GROUP_NAME', 'Administrators');
define('CM_MEMBERS_GROUP_NAME', 'Registered');
define('CM_GUEST_GROUP_NAME', 'Anonymous');
define('CM_BANNED_GROUP_NAME', 'Banned');
define('CM_GMOD_GROUP_NAME', 'Global Moderators');
define('YS_PASSWD_SEED', 'ys');
function cm_banning()
{
global $txt, $settings, $username, $REMOTE_ADDR, $db_prefix;
// ALL TYPES OF BANNING AT ONCE (SpeedUpBoardIndex mod)
$remote_ip = $REMOTE_ADDR;
$ipparts = explode(".", $REMOTE_ADDR);
$registeredUserString = ($username != 'Guest' ? "OR (type='email' AND value='$settings[2]') OR (type='username' AND value='$username')" : '');
$request = mysql_query("SELECT value FROM {$db_prefix}banned WHERE (type='ip' AND (value='$remote_ip' OR value='$ipparts[0].$ipparts[1].$ipparts[2].*' OR value='$ipparts[0].$ipparts[1].*.*')) $registeredUserString;") or database_error(__FILE__, __LINE__);
if (mysql_num_rows($request) != 0) {
$registeredUserString2 = ($username != 'Guest' ? ',email' : '');
$registeredUserString3 = ($username != 'Guest' ? ",'$settings[2]'" : '');
$request = mysql_query("INSERT INTO {$db_prefix}log_banned (ip $registeredUserString2,logTime) VALUES ('$remote_ip' $registeredUserString3," . time() . ");") or database_error(__FILE__, __LINE__);
$username = "Guest";
cpg_die(ERROR, "You are BANNED, go away!", __FILE__, __LINE__);
return;
}
}
// 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, $HTTP_X_FORWARDED_FOR, $HTTP_PROXY_USER, $REMOTE_ADDR;
global $password, $username, $pwseed, $settings, $ID_MEMBER, $realname, $txt;
$pwseed = YS_PASSWD_SEED;
LoadCookie();
LoadUserSettings();
cm_banning();
// For error checking
$CONFIG['TABLE_USERS'] = '**ERROR**';
// Permissions for a default group
$default_group = array('group_id' => YS_GUEST_GROUP,
'group_name' => CM_GUEST_GROUP_NAME,
'has_admin_access' => 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,
);
// get first 50 chars
$HTTP_USER_AGENT = substr($HTTP_SERVER_VARS['HTTP_USER_AGENT'], 0, 50);
$REMOTE_ADDR = substr($HTTP_SERVER_VARS['REMOTE_ADDR'], 0, 50);
/* If the user is a guest, initialize all the critial user settings */
if ($username == '' || $username == 'Guest') {
$result = db_query("SELECT * FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_id = " . YS_GUEST_GROUP);
if (!mysql_num_rows($result)) {
$USER_DATA = $default_group;
} else {
$USER_DATA = mysql_fetch_array($result);
}
define('USER_ID', 0);
define('USER_NAME', 'Anonymous');
define('USER_GROUP_SET', '(' . YS_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);
mysql_free_result($result);
} else {
if ($settings[7] == 'Administrator' || $settings[7] == 'Global Moderator')
$cm_group_id = ($settings[7] == 'Administrator') ? YS_ADMIN_GROUP : YS_GMOD_GROUP;
if ($settings[7] == '') $cm_group_id = YS_MEMBERS_GROUP;
if (!$cm_group_id) {
$sql = "SELECT group_id " . "FROM {$CONFIG['TABLE_USERGROUPS']} " . "WHERE group_name = '" . $settings[7] . "'";
$result = db_query($sql);
if (mysql_num_rows($result)) {
$temp = mysql_fetch_array($result);
$cm_group_id = $temp[0];
} else {
$cm_group_id = YS_MEMBERS_GROUP;
}
}
// Retrieve group information
$sql = "SELECT * " . "FROM {$CONFIG['TABLE_USERGROUPS']} " . "WHERE group_id = '" . $cm_group_id . "'";
$result = db_query($sql);
if (mysql_num_rows($result)) {
$USER_DATA = mysql_fetch_array($result);
} else {
$USER_DATA = $default_group;
}
if (get_magic_quotes_gpc() == 0) {
$realname = mysql_escape_string($realname);
$USER_DATA['group_name'] = mysql_escape_string($USER_DATA['group_name']);
}
define('USER_ID', $ID_MEMBER);
define('USER_NAME', $realname);
define('YSE_USER_NAME', $username);
define('USER_GROUP', $USER_DATA['group_name']);
define('USER_GROUP_SET', '(' . $USER_DATA['group_id'] . ')');
define('USER_IS_ADMIN', ($settings[7] == 'Administrator'));
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']);
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 realName as user_name " . "FROM " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_USER_TABLE . " " . "WHERE ID_MEMBER = '$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 '';
}
}
// Redirect
function udb_redirect($target)
{
global $sesc;
if (function_exists('session_start')) {
session_start();
$sesc = session_id();
echo $sc;
}
else
$sc = '';
header('Location: '.YS_WEB_PATH.$target.';sesc='.$sesc);
exit;
}
// Register
function udb_register_page()
{
$target = 'index.php?action=register';
udb_redirect($target);
}
// Login
function udb_login_page()
{
$target = 'index.php?action=login';
udb_redirect($target);
}
// Logout
function udb_logout_page()
{
$target = 'index.php?action=logout';
udb_redirect($target);
}
// Edit users
function udb_edit_users()
{
$target = 'index.php?action=viewmembers';
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 realName as user_name, memberGroup as group_name, emailAddress as user_email, dateRegistered as user_regdate, " . "websiteURL as user_website " . "FROM " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_USER_TABLE . " " . "WHERE ID_MEMBER = '$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['mgroup'] = '';
$user_data['user_occupation'] = '';
$user_data['user_location'] = '';
$user_data['user_interests'] = '';
if ($user_data['group_name'] == 'Administrator') {
$user_data['mgroup'] = YS_ADMIN_GROUP;
} else if ($user_data['group_name'] == 'Global Moderator') {
$user_data['mgroup'] = YS_GMOD_GROUP;
} else if ($user_data['group_name'] == '') {
$user_data['mgroup'] = YS_MEMBERS_GROUP;
} else {
$sql = "SELECT ID_GROUP as mgroup " . "FROM " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_GROUP_TABLE . " " . "WHERE membergroup = '{$user_data['group_name']}' ";
$result = db_query($sql);
if (mysql_num_rows($result)) {
$row = mysql_fetch_array($result);
$user_data['mgroup'] = $row['mgroup'];
} else {
$user_data['mgroup'] = YS_MEMBERS_GROUP;
}
mysql_free_result($result);
}
return $user_data;
}
// Edit user profile
function udb_edit_profile($uid)
{
$user_data = udb_get_user_infos($uid);
$target = 'index.php?action=profile;user='.$user_data['membername'];
udb_redirect($target);
}
// Query used to list users
function udb_list_users_query(&$user_count)
{
global $CONFIG, $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_SET " . "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 ID_MEMBER as user_id, realName as user_name " . "FROM " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_USER_TABLE . " " . "WHERE ID_MEMBER 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 ID_GROUP as usergroupid, membergroup as title FROM " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_GROUP_TABLE . " WHERE grouptype=1", $UDB_DB_LINK_ID);
while ($row = mysql_fetch_array($result)) {
$YS_groups[$row['title']] = $row['usergroupid'];
}
mysql_free_result($result);
$YS_groups[CM_ADMIN_GROUP_NAME] = YS_ADMIN_GROUP;
$YS_groups[CM_MEMBERS_GROUP_NAME] = YS_MEMBERS_GROUP;
$YS_groups[CM_GUEST_GROUP_NAME] = YS_GUEST_GROUP;
$YS_groups[CM_BANNED_GROUP_NAME] = YS_BANNED_GROUP;
$YS_groups[CM_GMOD_GROUP_NAME] = YS_GMOD_GROUP;
$result = db_query("SELECT group_id, group_name FROM {$CONFIG['TABLE_USERGROUPS']} WHERE 1");
while ($row = mysql_fetch_array($result)) {
$cpg_groups[$row['group_name']] = $row['group_id'];
}
mysql_free_result($result);
// Scan Coppermine groups that need to be deleted
foreach($cpg_groups as $c_group_name => $c_group_id) {
if ((!isset($YS_groups[$c_group_name]))) {
db_query("DELETE FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_id = '" . $c_group_id . "' LIMIT 1");
unset($cpg_groups[$c_group_name]);
}
}
// Scan Board groups that need to be created inside Coppermine table
foreach($YS_groups as $i_group_name => $i_group_id) {
if ((!isset($cpg_groups[$i_group_name]))) {
db_query("INSERT INTO {$CONFIG['TABLE_USERGROUPS']} (group_id, group_name) VALUES ('$i_group_id', '" . addslashes($i_group_name) . "')");
$cpg_groups[$i_group_name] = $i_group_id;
}
}
// Update Group names -- Can't be done with YSE
// foreach($YS_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('(', realName, ') ', a.title) AS title " . "FROM {$CONFIG['TABLE_ALBUMS']} AS a " . "INNER JOIN " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_USER_TABLE . " AS u ON category = (" . FIRST_USER_CAT . " + ID_MEMBER) " . "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;
}
}
// ------------------------------------------------------------------------- //
// Define wheter we can join tables or not in SQL queries (same host & same db or user)
define('UDB_CAN_JOIN_TABLES', (YS_DB_HOST == $CONFIG['dbserver'] && (YS_DB_NAME == $CONFIG['dbname'] || YS_DB_USERNAME == $CONFIG['dbuser'])));
// Connect to YaBB SE Database if necessary
$UDB_DB_LINK_ID = 0;
$UDB_DB_NAME_PREFIX = YS_DB_NAME ? '`' . YS_DB_NAME . '`.' : '';
if (!UDB_CAN_JOIN_TABLES) {
$UDB_DB_LINK_ID = @mysql_connect(YS_BD_HOST, YS_DB_USERNAME, YS_DB_PASSWORD);
if (!$UDB_DB_LINK_ID) die("<b>Coppermine critical error</b>:<br />Unable to connect to YaBB SE Board database !<br /><br />MySQL said: <b>" . mysql_error() . "</b>");
}
?>
Thanks Mark,
@yazzi and everybody else running enigma: please test this on your enigma install and report back here - if it works we'll include it as separate bridge file with the next release and package it up as mod for the current release. Thanks!
GauGau
I am doing a fresh install of 1.2.1 on my IIS webserver with ImageMagick here at home before I upload on my host. I currently am running Enigma and I have the following error below.
Parse error: parse error, unexpected '[', expecting ']' in D:\board\site\gallery\bridge\yabbse.inc.php on line 280
Fatal error: Call to undefined function: loadcookie() in D:\board\site\gallery\bridge\yabbse.inc.php on line 93
I copied and pasted the bridge from above instead of using the one that is packaged with 1.2.1
BTW where it says: // Set this to the location of your Settings file
require_once("D:/board/site/Settings.php"); do I put the path on my server or the url???
<?php
// ------------------------------------------------------------------------- //
// Coppermine Photo Gallery 1.2.1 //
// ------------------------------------------------------------------------- //
// Copyright (C) 2002,2003 Gregory DEMAR //
// http://www.chezgreg.net/coppermine/ //
// ------------------------------------------------------------------------- //
// Updated by the Coppermine Dev Team //
// (http://coppermine.sf.net/team/) //
// see /docs/credits.html for details //
// ------------------------------------------------------------------------- //
// 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. //
// ------------------------------------------------------------------------- //
// YaBB SE 1.5.4 Integration for Coppermine
// ------------------------------------------------------------------------- //
// Modify the value below according to your Board installation
// ------------------------------------------------------------------------- //
// Set this to the location of your Settings file
require_once("D:/board/site/Settings.php");
// ------------------------------------------------------------------------- //
// Nothing to edit below this line
// ------------------------------------------------------------------------- //
// other includes
require_once("$sourcedir/Load.php");
require_once("$sourcedir/Security.php");
// database configuration
define('YS_DB_NAME', $db_name); // The name of the database used by the board
define('YS_DB_HOST', $db_server); // The name of the database server
define('YS_DB_USERNAME', $db_user); // The username to use to connect to the database
define('YS_DB_PASSWORD', $db_passwd); // The password to use to connect to the database
// The web path to your YaBB SE Board directory
// In this example http://yoursite_name.com/yabbse/
define('YS_WEB_PATH', "$boardurl/");
// The Name of the Cookie used for YaBBSE logon
define('YS_COOKIE_NAME', $cookiename);
// Prefix for the database tables
define('YS_TABLE_PREFIX', $db_prefix); // Table Prefix
// Names for the database tables
define('YS_USER_TABLE', 'members'); // The members table
define('YS_GROUP_TABLE', 'membergroups'); // The groups table
// Group definitions (default values used by the board)
define('YS_GMOD_GROUP', 5);
define('YS_BANNED_GROUP', 4);
define('YS_GUEST_GROUP', 3);
define('YS_MEMBERS_GROUP', 2);
define('YS_ADMIN_GROUP', 1);
define('CM_ADMIN_GROUP_NAME', 'Administrators');
define('CM_MEMBERS_GROUP_NAME', 'Registered');
define('CM_GUEST_GROUP_NAME', 'Anonymous');
define('CM_BANNED_GROUP_NAME', 'Banned');
define('CM_GMOD_GROUP_NAME', 'Global Moderators');
define('YS_PASSWD_SEED', 'ys');
function cm_banning()
{
global $txt, $settings, $username, $REMOTE_ADDR, $db_prefix;
// ALL TYPES OF BANNING AT ONCE (SpeedUpBoardIndex mod)
$remote_ip = $REMOTE_ADDR;
$ipparts = explode(".", $REMOTE_ADDR);
$registeredUserString = ($username != 'Guest' ? "OR (type='email' AND value='$settings[2]') OR (type='username' AND value='$username')" : '');
$request = mysql_query("SELECT value FROM {$db_prefix}banned WHERE (type='ip' AND (value='$remote_ip' OR value='$ipparts .$ipparts[1].$ipparts[2].*' OR value='$ipparts .$ipparts[1].*.*')) $registeredUserString;") or database_error(__FILE__, __LINE__);
if (mysql_num_rows($request) != 0) {
$registeredUserString2 = ($username != 'Guest' ? ',email' : '');
$registeredUserString3 = ($username != 'Guest' ? ",'$settings[2]'" : '');
$request = mysql_query("INSERT INTO {$db_prefix}log_banned (ip $registeredUserString2,logTime) VALUES ('$remote_ip' $registeredUserString3," . time() . ");") or database_error(__FILE__, __LINE__);
$username = "Guest";
cpg_die(ERROR, "You are BANNED, go away!", __FILE__, __LINE__);
return;
}
}
// 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, $HTTP_X_FORWARDED_FOR, $HTTP_PROXY_USER, $REMOTE_ADDR;
global $password, $username, $pwseed, $settings, $ID_MEMBER, $realname, $txt;
$pwseed = YS_PASSWD_SEED;
LoadCookie();
LoadUserSettings();
cm_banning();
// For error checking
$CONFIG['TABLE_USERS'] = '**ERROR**';
// Permissions for a default group
$default_group = array('group_id' => YS_GUEST_GROUP,
'group_name' => CM_GUEST_GROUP_NAME,
'has_admin_access' => 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,
);
// get first 50 chars
$HTTP_USER_AGENT = substr($HTTP_SERVER_VARS['HTTP_USER_AGENT'], 0, 50);
$REMOTE_ADDR = substr($HTTP_SERVER_VARS['REMOTE_ADDR'], 0, 50);
/* If the user is a guest, initialize all the critial user settings */
if ($username == '' || $username == 'Guest') {
$result = db_query("SELECT * FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_id = " . YS_GUEST_GROUP);
if (!mysql_num_rows($result)) {
$USER_DATA = $default_group;
} else {
$USER_DATA = mysql_fetch_array($result);
}
define('USER_ID', 0);
define('USER_NAME', 'Anonymous');
define('USER_GROUP_SET', '(' . YS_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);
mysql_free_result($result);
} else {
if ($settings[7] == 'Administrator' || $settings[7] == 'Global Moderator')
$cm_group_id = ($settings[7] == 'Administrator') ? YS_ADMIN_GROUP : YS_GMOD_GROUP;
if ($settings[7] == '') $cm_group_id = YS_MEMBERS_GROUP;
if (!$cm_group_id) {
$sql = "SELECT group_id " . "FROM {$CONFIG['TABLE_USERGROUPS']} " . "WHERE group_name = '" . $settings[7] . "'";
$result = db_query($sql);
if (mysql_num_rows($result)) {
$temp = mysql_fetch_array($result);
$cm_group_id = $temp ;
} else {
$cm_group_id = YS_MEMBERS_GROUP;
}
}
// Retrieve group information
$sql = "SELECT * " . "FROM {$CONFIG['TABLE_USERGROUPS']} " . "WHERE group_id = '" . $cm_group_id . "'";
$result = db_query($sql);
if (mysql_num_rows($result)) {
$USER_DATA = mysql_fetch_array($result);
} else {
$USER_DATA = $default_group;
}
if (get_magic_quotes_gpc() == 0) {
$realname = mysql_escape_string($realname);
$USER_DATA['group_name'] = mysql_escape_string($USER_DATA['group_name']);
}
define('USER_ID', $ID_MEMBER);
define('USER_NAME', $realname);
define('YSE_USER_NAME', $username);
define('USER_GROUP', $USER_DATA['group_name']);
define('USER_GROUP_SET', '(' . $USER_DATA['group_id'] . ')');
define('USER_IS_ADMIN', ($settings[7] == 'Administrator'));
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']);
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 realName as user_name " . "FROM " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_USER_TABLE . " " . "WHERE ID_MEMBER = '$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 '';
}
}
// Redirect
function udb_redirect($target)
{
global $sesc;
if (function_exists('session_start')) {
session_start();
$sesc = session_id();
echo $sc;
}
else
$sc = '';
header('Location: '.YS_WEB_PATH.$target.';sesc='.$sesc);
exit;
}
// Register
function udb_register_page()
{
$target = 'index.php?action=register';
udb_redirect($target);
}
// Login
function udb_login_page()
{
$target = 'index.php?action=login';
udb_redirect($target);
}
// Logout
function udb_logout_page()
{
$target = 'index.php?action=logout';
udb_redirect($target);
}
// Edit users
function udb_edit_users()
{
$target = 'index.php?action=viewmembers';
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 realName as user_name, memberGroup as group_name, emailAddress as user_email, dateRegistered as user_regdate, " . "websiteURL as user_website " . "FROM " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_USER_TABLE . " " . "WHERE ID_MEMBER = '$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['mgroup'] = '';
$user_data['user_occupation'] = '';
$user_data['user_location'] = '';
$user_data['user_interests'] = '';
if ($user_data['group_name'] == 'Administrator') {
$user_data['mgroup'] = YS_ADMIN_GROUP;
} else if ($user_data['group_name'] == 'Global Moderator') {
$user_data['mgroup'] = YS_GMOD_GROUP;
} else if ($user_data['group_name'] == '') {
$user_data['mgroup'] = YS_MEMBERS_GROUP;
} else {
$sql = "SELECT ID_GROUP as mgroup " . "FROM " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_GROUP_TABLE . " " . "WHERE membergroup = '{$user_data['group_name']}' ";
$result = db_query($sql);
if (mysql_num_rows($result)) {
$row = mysql_fetch_array($result);
$user_data['mgroup'] = $row['mgroup'];
} else {
$user_data['mgroup'] = YS_MEMBERS_GROUP;
}
mysql_free_result($result);
}
return $user_data;
}
// Edit user profile
function udb_edit_profile($uid)
{
$user_data = udb_get_user_infos($uid);
$target = 'index.php?action=profile;user='.$user_data['membername'];
udb_redirect($target);
}
// Query used to list users
function udb_list_users_query(&$user_count)
{
global $CONFIG, $FORBIDDEN_SET;
$sql = "SELECT (category - " . FIRST_USER_CAT . ") as 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 ID_GROUP as usergroupid, membergroup as title FROM " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_GROUP_TABLE . " WHERE grouptype=1", $UDB_DB_LINK_ID);
while ($row = mysql_fetch_array($result)) {
$YS_groups[$row['title']] = $row['usergroupid'];
}
mysql_free_result($result);
$YS_groups[CM_ADMIN_GROUP_NAME] = YS_ADMIN_GROUP;
$YS_groups[CM_MEMBERS_GROUP_NAME] = YS_MEMBERS_GROUP;
$YS_groups[CM_GUEST_GROUP_NAME] = YS_GUEST_GROUP;
$YS_groups[CM_BANNED_GROUP_NAME] = YS_BANNED_GROUP;
$YS_groups[CM_GMOD_GROUP_NAME] = YS_GMOD_GROUP;
$result = db_query("SELECT group_id, group_name FROM {$CONFIG['TABLE_USERGROUPS']} WHERE 1");
while ($row = mysql_fetch_array($result)) {
$cpg_groups[$row['group_name']] = $row['group_id'];
}
mysql_free_result($result);
// Scan Coppermine groups that need to be deleted
foreach($cpg_groups as $c_group_name => $c_group_id) {
if ((!isset($YS_groups[$c_group_name]))) {
db_query("DELETE FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_id = '" . $c_group_id . "' LIMIT 1");
unset($cpg_groups[$c_group_name]);
}
}
// Scan Board groups that need to be created inside Coppermine table
foreach($YS_groups as $i_group_name => $i_group_id) {
if ((!isset($cpg_groups[$i_group_name]))) {
db_query("INSERT INTO {$CONFIG['TABLE_USERGROUPS']} (group_id, group_name) VALUES ('$i_group_id', '" . addslashes($i_group_name) . "')");
$cpg_groups[$i_group_name] = $i_group_id;
}
}
// Update Group names -- Can't be done with YSE
// foreach($YS_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('(', realName, ') ', a.title) AS title " . "FROM {$CONFIG['TABLE_ALBUMS']} AS a " . "INNER JOIN " . $UDB_DB_NAME_PREFIX . YS_TABLE_PREFIX . YS_USER_TABLE . " AS u ON category = (" . FIRST_USER_CAT . " + ID_MEMBER) " . "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;
}
}
// ------------------------------------------------------------------------- //
// Define wheter we can join tables or not in SQL queries (same host & same db or user)
define('UDB_CAN_JOIN_TABLES', (YS_DB_HOST == $CONFIG['dbserver'] && (YS_DB_NAME == $CONFIG['dbname'] || YS_DB_USERNAME == $CONFIG['dbuser'])));
// Connect to YaBB SE Database if necessary
$UDB_DB_LINK_ID = 0;
$UDB_DB_NAME_PREFIX = YS_DB_NAME ? '`' . YS_DB_NAME . '`.' : '';
if (!UDB_CAN_JOIN_TABLES) {
$UDB_DB_LINK_ID = @mysql_connect(YS_BD_HOST, YS_DB_USERNAME, YS_DB_PASSWORD);
if (!$UDB_DB_LINK_ID) die("<b>Coppermine critical error</b>:<br />Unable to connect to YaBB SE Board database !<br /><br />MySQL said: <b>" . mysql_error() . "</b>");
}
?>
I don't know Enigma, can't tell for sure if the YaBB SE bridge file will work with it at all, but it's recommended to have a relative path instead of an absulte one, like this// Set this to the location of your Settings file
require_once("../board/site/Settings.php");
GauGau
Quote from: GauGau on May 14, 2004, 08:01:27 AM
I don't know Enigma, can't tell for sure if the YaBB SE bridge file will work with it at all, but it's recommended to have a relative path instead of an absulte one, like this// Set this to the location of your Settings file
require_once("../board/site/Settings.php");
GauGau
So would the correct path be using the url such as what I have now:
// Set this to the location of your Settings file
require_once("D:/board/site/Settings.php");or a url?
// Set this to the location of your Settings file
require_once("http://www.mydomain.com/board/site/Settings.php");Zarsky do you have any ideas? TIA :)
please read my answer once more, very carefully: I suggested using a relative path. I didn't say absolute path nor did I say URL... :-X
GauGau
My bad gaugau, too much on my mind :o and the answer was right in front of me. Hopefully I can get the bridge to work and you can add it to the next release of Coppermine