My client who is running eFiction has purchased the chat software "Digichat" ( http://www.globalchat.com/chat-room-software-v5.html ). Digichat claims on its site that they have a feature called "single sign-on" which uses an existing MySQL database for login information. Unfortunately they don't provide any documentation for how to set this up because every user will have a different system set up for their database.
I know how badly eFiction plays with others in regards to databases and having other PHP running within it from my experience with cpmFetch and Coppermine Random & Recent Blocks. So I tried to see if the Digichat support people could provide some direction for setting up Digichat with its own database. They came back with some long and confusing details for attempting to set up Digichat to use eFiction's database. (exactly what I didn't want to have to deal with)
Here's a link to a txt of the email from Digichat support http://www.mediafire.com/?5yxxcld1zm8
It says "you'll need to figure out how eFiction has their PHP session set up" and "You'll also have to find out how they create their SQL database."
So I guess I'm looking for someone who can help me muddle through this Or if someone can let me know if its even possible? In the end with cpmFetch the author of that program had us doing all sorts of work arounds because eFiction kept closing the PHP session. I'd rather not deal with that again.
This thread is in the wrong forum. It's a mod so that's where it goes. Have you tried doing this yourself? You say eFiction doesn't play nicely, but I'm using the SMF bridge and it works fine. I glanced over your email and it looks like it would be pretty straightforward to me. All you really seem to need to know is what table and field efiction uses for userinfo.
I'm not very experienced with PHP myself so I wasn't completely sure of the details. I suppose I'll try and muddle through it.
(doesn't seem like a "mod" to me as I'm not modifying eFiction)
Yes, a bridge is a mod for argument's sake I believe.
I am rebuilding efiction! Join us on irc! #efiction at
So I have to create a bridge for this too?
i imagine so that the names in the chat client are the same for efiction that yes you do.
I am rebuilding efiction! Join us on irc! #efiction at
If anyone is interested in setting this up for me I'm willing to pay.
If you want to PM me can talk more about the details of setting up this bridge and payment.
It looks like, from the email you attached, that all you would need to do is include the eFiction session information into the parameters the script needs.
To be more specific you would need to alter to PHP script he is talking about that contains the lines like
document.write(" <PARAM NAME=Name VALUE=$SQL_Query_Returned_Name>");
This would be altered to use the eFiction configured session info. That info can be found in the get_session_variables.php file.
Without access to the code that is the best I can offer at the moment. I would offer to help but my plate is full right now, not much time until next year and then it does not look hopeful 🙁
Stupid work 🙁
Okay.
I'm still confused. I understand what you've said in general but I'm not sure.
The way the chat is displayed on the site is through javascript, which links to their site (where the chat is located I assume) and then has a bunch of document.write commands...
document.write(" <PARAM NAME=MenuItem1 VALUE=DigiChat>");
document.write(" <PARAM NAME=MenuLocation1 VALUE= http://www.digichat.com>");
document.write(" <PARAM NAME=MenuItem2 VALUE='DigiPosts BBS'>");
document.write(" <PARAM NAME=MenuLocation2 VALUE= http://www.digiposts.com>");
document.write(" <PARAM NAME=MenuItem3 VALUE='Hubz Instant Messenger'>");
document.write(" <PARAM NAME=MenuLocation3 VALUE= http://www.hubz.com>");
document.write(" <PARAM NAME=MenuItem4 VALUE='Enclave Community Suite'>");
document.write(" <PARAM NAME=MenuLocation4 VALUE= http://www.enclavesuite.com>");
document.write(" <PARAM NAME=MenuItem5 VALUE='Groopz E-Commerce'>");
document.write(" <PARAM NAME=MenuLocation5 VALUE= http://www.groopz.com>");document.write(" <PARAM NAME=siteID VALUE=xxxxx>");
document.write(" <PARAM NAME=background VALUE=FFFFFF>");
document.write(" <PARAM NAME=textcolor VALUE=000000>");
I'll see if I can dig up the session info from that file you mentioned. If this really is a simple matter of adding efiction's session info they have really confused me with their instructions. (And their demands of thousands of dollars to do the work).
EDIT:
okay so inside /includes/ there is "get_session_vars.php" but I'm not sure what is is from it that I need.
<?php
if(!defined("_CHARSET")) exit( );
// Get session variables from cookie data if not logged in.
// To bridge to another program replace (or add to) this information with the bridge to your other script. See examples in the includes/bridges/ folder.
if (!empty($_COOKIE[$sitekey."_useruid"])) {
$userdata = dbassoc(dbquery("SELECT ap.*, "._UIDFIELD." as uid, "._PENNAMEFIELD." as penname, "._EMAILFIELD." as email, "._PASSWORDFIELD." as password FROM "._AUTHORTABLE." LEFT JOIN ".$tableprefix."fanfiction_authorprefs as ap ON ap.uid = "._UIDFIELD." WHERE "._UIDFIELD." = '".$_COOKIE[$sitekey."_useruid"]."'"));
if($userdata && $userdata['level'] != -1 && $_COOKIE[$sitekey.'_salt'] == md5($userdata['email']+$userdata['password'])) {
$useruid = $userdata['uid'];
$userpenname = $userdata['penname'];
if(isset($_SESSION[$sitekey."_skin"])) $siteskin = $_SESSION[$sitekey."_skin"];
else if(isset($_GET['skin'])) {
$siteskin = $_GET['skin'];
$_SESSION[$sitekey."_skin"];
}
else if(!empty($userdata['userskin']) && is_dir(_BASEDIR."skins/".$userdata['userskin'])) $siteskin = $userdata['userskin'];
$level = $userdata['level'];
if($userdata['level'] > 0) $adminloggedin = 1;
else $adminloggedin = 0;
$loggedin = 1;
if(!isset($_SESSION[$sitekey."_agecontsent"])) $ageconsent = $userdata['ageconsent'];
else $ageconsent = $_SESSION[$sitekey."_agecontsent"];
}
}
?>
Any chance I can get some more help with this?
