[Beta 1.5.4] Coppermine Photo Album - YabbSE Integration Bridge V 0.9.2

[babylonking]

ok this code will disallow guests from viewing the members gallery even if the members set their albums permissions to every body (public album).

Edit init.inc.php and add

if ($username == "Guest")
cpg_die(ERROR, 'You need to register to access this page', __FILE__, __LINE__);

Just before

?>

[arturoramos]

jack,

No it was an include path problem...as i suspected...I fixed it a crappy way...i have a few other problems I noticed already:

session check failure when loggin out.

Code Select Expand

An Error Has Occurred!

Session check failure. Please try again.


profile link does not load the yabbse profile page...nor does it load the gallery profile page.

"users" link in gallery does not load the member list or anything very useful

You can turn off this session check feature in YABB and have the login/logout work directly from the Coppermine buttons:

http://www.chezgreg.net/cpgboard/viewtopic.php?t=2032&start=24

[arturoramos]

The problem that I mentioned above with the session check failure, and other issues have been fixed in the bridge file.

The updated version 0.9.3 is available at:

http://www.ramosfamily.org/yabbse-cm-093-wip.zip

This version integrates the following changes:

1. Fixes the definition of web path to YaBB SE Board directory.
2. Adds integration of user language preference.
3. Fixes redirect urls for login, logout, edit users and edit user profile.
4. Adds session ID information to redirects to avoid session check failures.

The version also includes instructions on enabling SSI.php support so as to allow the use of SSI.php functions, such as the YaBB SE menu, in Coppermine templates.

[jack-uk]

Thanks to arturoramos for his work in this - I have had a lot less spare time than I thought I would have recently.

[Valconeye]

i get this error

Code Select Expand

Coppermine critical error:
Unable to connect to YaBB SE Board database !

MySQL said: Unknown MySQL Server Host 'YS_BD_HOST' (2)

[zarsky99]

works perfectly....thank you!!!!

[arturoramos]

i get this error

Code Select Expand

Coppermine critical error:
Unable to connect to YaBB SE Board database !

MySQL said: Unknown MySQL Server Host 'YS_BD_HOST' (2)

Have you changed the line in the yabbse.inc.php file that reads

Code Select Expand

require_once("/var/web/yabbse/Settings.php"); to point to your YaBB SE settings file?

[Valconeye]

yeah, it is
require_once("/home/warcraft/public_html/forums/Settings.php");

[Anguz]

is it possible to have the gallery with the forums if it's at another server under another domain?

cause I have the forums in a server with just enough bandwidth for the forums and have an account at another server with a lot of wasted bandwidth

[arturoramos]

yeah, it is
require_once("/home/warcraft/public_html/forums/Settings.php");

I think there is a typo in the script that is causing this problem!  Can you try this and see if it works:

Find the following code at the bottom of the script:

Code Select Expand

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


and change

Code Select Expand

YS_BD_HOST to

Code Select Expand

YS_DB_HOST

Can you also post your problem on the Coppermine forum?  There are more hackers there working on the bridge script who may be able to help if this doesn't work.  Anyhow, we can use your feedback and help in debugging the script.

[arturoramos]

is it possible to have the gallery with the forums if it's at another server under another domain?

cause I have the forums in a server with just enough bandwidth for the forums and have an account at another server with a lot of wasted bandwidth

No it is not.  The gallery needs to access the user tables from the forums database and it can only do so if they reside on the same server.

[Ben_S]

is it possible to have the gallery with the forums if it's at another server under another domain?

cause I have the forums in a server with just enough bandwidth for the forums and have an account at another server with a lot of wasted bandwidth

Havent looked at the mod, but you could try copying the settings.php to the server that the gallery is on, changing the mysql server host to the domain/ip of the server that the forum runs on and pointing the bridge to the settings.php you have created. Not looked at the mod so I have no idea if that will work, but its worth a go.

Oh you may need to set up the mysql server to accept connections from the server the gallery is on as usually its restricted to localhost.

[Anguz]

I see...

now that I read your reply, I'm thinking another thing could be done, maybe the gallery can be at the same server the forums are, so the db connections would be local, much faster and less trouble

the difference would be that the pictures could be saved at the other server... could this be done? can the script upload files or delete them if they're in a directory at another server? if it's via FTP, it probably can, if it's via HTTP I don't know...

[Ben_S]

Not looked at how coppermine works, but I doubt it supports ftp..

[Valconeye]

I have Changed yabb_bd_host to yabb_DB_host and i get this error

Code Select Expand

Fatal error: Call to undefined function: database_error() in /home/warcraft/public_html/forums/Sources/Load.php on line 141


Line 141 of load.php

Code Select Expand

$request = mysql_query("SELECT passwd, realName, emailAddress, websiteTitle, websiteUrl, signature, posts, memberGroup, ICQ, AIM, YIM, gender, personalText, avatar, dateRegistered, location, birthdate, timeFormat, timeOffset, hideEmail, ID_MEMBER, memberName, MSN, lngfile, skin FROM {$db_prefix}members WHERE ID_MEMBER='$username' LIMIT 1;") or database_error(__FILE__, __LINE__);