Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Enigma support?  (Read 6774 times)

0 Members and 1 Guest are viewing this topic.

yazzi

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Enigma support?
« on: December 28, 2003, 08:09:18 am »

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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Enigma support?
« Reply #1 on: December 28, 2003, 10:59:36 am »

we don't know, since none of the devs runs enigma afaik. Maybe you want to post this question on the proper yabbse thread...

GauGau
Logged

Zarsky

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 268
    • Zerr Family Website
Enigma support?
« Reply #2 on: December 29, 2003, 06:37:06 pm »

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.
Logged
Read the Online DOCs, FAQ, and SEARCH the board BEFORE posting questions for help.

Zarsky

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 268
    • Zerr Family Website
Enigma support?
« Reply #3 on: December 29, 2003, 09:06:28 pm »

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>");
}

?>
Logged
Read the Online DOCs, FAQ, and SEARCH the board BEFORE posting questions for help.

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Enigma support?
« Reply #4 on: December 29, 2003, 11:32:37 pm »

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
Logged

nameless

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 34
    • Skate, Snow, and Surf - SFboarders - Bringing San Francisco Bay Area boarders together.
Re: Enigma support?
« Reply #5 on: May 14, 2004, 04:40:20 am »

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:
Code: [Select]
// 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???

Code: [Select]
<?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'], 050);
$REMOTE_ADDR substr($HTTP_SERVER_VARS['REMOTE_ADDR'], 050);

/* 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 usergroupidmembergroup 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_idgroup_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_idgroup_nameVALUES ('$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 aidCONCAT('('realName') 'a.title) AS title " . "FROM {$CONFIG['TABLE_ALBUMS']} AS " . "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>");


?>
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Enigma support?
« Reply #6 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
Code: [Select]
// Set this to the location of your Settings file
require_once("../board/site/Settings.php");

GauGau
Logged

nameless

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 34
    • Skate, Snow, and Surf - SFboarders - Bringing San Francisco Bay Area boarders together.
Re: Enigma support?
« Reply #7 on: May 14, 2004, 04:45:41 pm »

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
Code: [Select]
// 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:

Code: [Select]
// Set this to the location of your Settings file
require_once("D:/board/site/Settings.php");

or a url?

Code: [Select]
// 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 :)

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Enigma support?
« Reply #8 on: May 14, 2004, 08:18:33 pm »

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
Logged

nameless

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 34
    • Skate, Snow, and Surf - SFboarders - Bringing San Francisco Bay Area boarders together.
Re: Enigma support?
« Reply #9 on: May 14, 2004, 08:28:32 pm »

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
Logged
Pages: [1]   Go Up
 

Page created in 0.036 seconds with 18 queries.