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