anyone with knowledge of efiction

[Methen]

I am sorry to have to be asking this question here I have tried over efiction.org and have been totally ignore ignored.

My Problem is I want to bridge efiction with my  smf 2.04 and Iam having trouble understanding one small part its the part where the instructions says to

Edit queries.php to point to your SMF tables and directory.

I know how to edit php files but I have no ideal as to just what you are suppose to edit  enclosed is a copy of the queries file.

[palofdru]

I am sorry to have to be asking this question here I have tried over efiction.org and have been totally ignore ignored.

My Problem is I want to bridge efiction with my  smf 2.04 and Iam having trouble understanding one small part its the part where the instructions says to

Edit queries.php to point to your SMF tables and directory.

I know how to edit php files but I have no ideal as to just what you are suppose to edit  enclosed is a copy of the queries file.

Assuming you already have SMF installed and running, open up your SETTINGS.PHP file
and look for the following,,
SETTINGS.php (smf)

Code Select Expand


########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = '/homepages/blahblahblah2/htdocs/SMF' ; # The absolute path to the forum's folder.

where it says $boarddir copy the path inside to

// The table prefix for SMF
$db_prefix = "smf_";

// The RELATIVE path to your SMF install from your eFiction install. 
// The example given is an SMF and eFiction install as sibling folders.
define("PATHTOSMF", "../smf/");

Note: This message is awaiting approval by a moderator.

[Methen]

Ok I did that ( ithink I did it right)
Now I get the following error when I go to the efiction to make the other changes


Warning: require_once(PATHTOSMFSSI.php) [function.require-once]: failed to open stream: No such file or directory in /home/allbridg/public_html/XXXX.com/Storys/includes/get_session_vars.php on line 23

Fatal error: require_once() [function.require]: Failed opening required 'PATHTOSMFSSI.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/allbridg/public_html/XXXX.com/Storys/includes/get_session_vars.php on line 23


XXX.com for Privacy reasons

[palofdru]

  Note: this post will not display until it's been approved by a mooderator.

Ok I did that ( ithink I did it right)
Now I get the following error when I go to the efiction to make the other changes


Warning: require_once(PATHTOSMFSSI.php) [function.require-once]: failed to open stream: No such file or directory in /home/allbridg/public_html/XXXX.com/Storys/includes/get_session_vars.php on line 23

Fatal error: require_once() [function.require]: Failed opening required 'PATHTOSMFSSI.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/allbridg/public_html/XXXX.com/Storys/includes/get_session_vars.php on line 23


XXX.com for Privacy reasons

no... I think you messed it up somehow.
It's trying to include a file called  PATHTOSMFSSI.PHP which is totally wrong...

However I do see from the example in your query.php THAT THE PATH TO SMF HAS A SLASH "/" AT THE END!

make sure yours does too!


it should look like...

define("PATHTOSMF", ".'/home/allbridg/public_html/XXXX.com/Storys/smf/');

*assuming the folder for SMF is called "smf" AND it is a subdirectory of the "Storys" folder.

Remember all these path items are CASE SENSITIVE!

[Kindred]

I think you mean:

define("PATHTOSMF", "/home/allbridg/public_html/XXXX.com/Storys/smf/");
Assuming SMF is installed in stories/smf on your site


Nope... that won't work...   

The eFiction does not want a PATH!   it wants a relative URL

i.e.  smf is installed in site.com, efiction is installed in site.com/efic, then the "path" is "../"
if they are in sister directories...
i.e.  smf is installed in site.com/forum, efiction is installed in site.com/efic, then the "path" is "../forum"

[Methen]

The way my site is installed is the following each is in its own indpendent folder
with the exception of x7 chat which is in the forum folder.


cgi-bin
forum + chat   which contains smf script
gallery   which contains the coppermine script
Storys   which contain the efiction script
ftpquota
htaccess

So is my problem in the  queries file or the get_session_vars file as I have been trying to edit the get_session_vars with no luck.

I do have x7 chat in the forum folder which i am trying to intergrate but am also having problems
but that is required to intergrate.

[Kindred]

see my response over on the efiction support forums.

Also, I do not believe that the current deisgn will work with smf 2.0, since I can not get it to work, even with the correct settings in efiction/includes/queries.php and the correct code updated in smf/sources/querystring.php

[Methen]

Go back to efiction a responce was given to your post to indicate it still might be possible.

[palofdru]

  Note: this post will not display until it's been approved by a moderator.

I think you mean:

define("PATHTOSMF", "/home/allbridg/public_html/XXXX.com/Storys/smf/");
Assuming SMF is installed in stories/smf on your site


Nope... that won't work...   

The eFiction does not want a PATH!   it wants a relative URL

i.e.  smf is installed in site.com, efiction is installed in site.com/efic, then the "path" is "../"
if they are in sister directories...
i.e.  smf is installed in site.com/forum, efiction is installed in site.com/efic, then the "path" is "../forum"

^eh?

what you gave is not a URL relative or otherwise! lol

And if a relative path can be used, then an absolute path will work just as well too

I have it working just fine, thanks.

I think he must have something else messed up somewhere

Methen - if you are still interested, post your queries.php again

[Kindred]

yes... what I gave is a relative url.

By using the absolute PATH (my original statement, above), when I set it up, it tried to go to
http://www.site.com/Stories/home/allbridg/public_html/XXXX.com/Storys/smf/index.php?action=login2.

by using the relative URL/path, (../smf) it goes to
http://www.site.com/smf/index.php?action=login2

however, even if it was using the absolute path correctly...   YOUR absolute path has an error in it.

[palofdru]

we definitely have to nail down verbiage here.

URL vs PATH

For the sake of discussion: URL is accessible via http://url
whereas path refers to local path folders?

I'm still somewhat convinced that he has some values messed up somewhere....at this point, w/o actually LOOKING at his actual entries -or him being more explicit, we may just be wasting time here.

[Methen]

I think I may be pasting it in the wrong place please show me just where you are suppose to  paste it at.

Oh and what are you suppose to do with the index file that comes with the smf bridge the instructions don't say one way or the other?

Code Select Expand


<?php

// The table prefix for SMF
$db_prefix = "smf_";

// The RELATIVE path to your SMF install from your eFiction install.  
// The example given is an SMF and eFiction install as sibling folders.
define("PATHTOSMF", "../smf/");

$db_connection = $dbconnect;

// Default query strings used throughout the script.  You may need to alter these to bridge to other scripts or databases.

define ("_UIDFIELD", "author.ID_MEMBER");  // Do not change the aliasing (the "author." part)!
define ("_PENNAMEFIELD", "author.realName");  // Do not change the aliasing (the "author." part)!
define ("_EMAILFIELD", "author.emailAddress");  // Do not change the aliasing (the "author." part)!
define ("_PASSWORDFIELD", "author.passwd"); //  Do not change the aliasing (the "author." part)!
define ("_AUTHORTABLE", $db_prefix."members as author"); // Do not change the aliasing (the "as author" part)!

define ("_STORYQUERY",  "SELECT stories.*, "._PENNAMEFIELD." as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM ("._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_stories as stories) WHERE "._UIDFIELD." = stories.uid AND stories.validated > 0 ");
define ("_STORYCOUNT", "SELECT count(sid) FROM ".TABLEPREFIX."fanfiction_stories as stories WHERE validated > 0");
define ("_SERIESQUERY", "SELECT series.*, "._PENNAMEFIELD." as penname FROM "._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_series as series WHERE "._UIDFIELD." = series.uid ");
define ("_SERIESCOUNT", "SELECT COUNT(seriesid) FROM ".TABLEPREFIX."fanfiction_series as series ");
define ("_MEMBERLIST", "SELECT count( stories.sid ) as stories, "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs AS ap ON "._UIDFIELD." = ap.uid LEFT JOIN ".TABLEPREFIX."fanfiction_stories AS stories ON stories.validated > 0 AND (FIND_IN_SET("._UIDFIELD.", stories.coauthors) > 0 OR stories.uid = "._UIDFIELD.") ");
define ("_MEMBERCOUNT", "SELECT COUNT(DISTINCT "._UIDFIELD.") FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_stories as stories ON stories.validated > 0 AND (FIND_IN_SET("._UIDFIELD.", stories.coauthors) > 0 OR stories.uid = "._UIDFIELD.")  LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs as ap ON "._UIDFIELD." = ap.uid");
?>



[Kindred]

Yes, URL versus path...

However, under most circumstances, a relative url will look the same as a relative path.
In this case, if I put in an absolute PATH, it screws up.
If I put in an absolute URL, it also screws up...

it must be relative (url or path) to the efiction installation.


Methen,
As I said over on eFiction, SMF 2.0 changed the database field names...

(also, please use the CODE BBC tags when you paste code)

Code Select Expand


<?php

// The table prefix for SMF
$db_prefix = "smf_";

// The RELATIVE path to your SMF install from your eFiction install.  
// The example given is an SMF and eFiction install as sibling folders.
define("PATHTOSMF", "../smf/");

$db_connection = $dbconnect;

// Default query strings used throughout the script.  You may need to alter these to bridge to other scripts or databases.

define ("_UIDFIELD", "author.id_member");  // Do not change the aliasing (the "author." part)!
define ("_PENNAMEFIELD", "author.real_name");  // Do not change the aliasing (the "author." part)!
define ("_EMAILFIELD", "author.email_adress");  // Do not change the aliasing (the "author." part)!
define ("_PASSWORDFIELD", "author.passwd"); //  Do not change the aliasing (the "author." part)!
define ("_AUTHORTABLE", $db_prefix."members as author"); // Do not change the aliasing (the "as author" part)!

define ("_STORYQUERY",  "SELECT stories.*, "._PENNAMEFIELD." as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM ("._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_stories as stories) WHERE "._UIDFIELD." = stories.uid AND stories.validated > 0 ");
define ("_STORYCOUNT", "SELECT count(sid) FROM ".TABLEPREFIX."fanfiction_stories as stories WHERE validated > 0");
define ("_SERIESQUERY", "SELECT series.*, "._PENNAMEFIELD." as penname FROM "._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_series as series WHERE "._UIDFIELD." = series.uid ");
define ("_SERIESCOUNT", "SELECT COUNT(seriesid) FROM ".TABLEPREFIX."fanfiction_series as series ");
define ("_MEMBERLIST", "SELECT count( stories.sid ) as stories, "._PENNAMEFIELD." as penname, "._UIDFIELD." as uid FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs AS ap ON "._UIDFIELD." = ap.uid LEFT JOIN ".TABLEPREFIX."fanfiction_stories AS stories ON stories.validated > 0 AND (FIND_IN_SET("._UIDFIELD.", stories.coauthors) > 0 OR stories.uid = "._UIDFIELD.") ");
define ("_MEMBERCOUNT", "SELECT COUNT(DISTINCT "._UIDFIELD.") FROM "._AUTHORTABLE." LEFT JOIN ".TABLEPREFIX."fanfiction_stories as stories ON stories.validated > 0 AND (FIND_IN_SET("._UIDFIELD.", stories.coauthors) > 0 OR stories.uid = "._UIDFIELD.")  LEFT JOIN ".TABLEPREFIX."fanfiction_authorprefs as ap ON "._UIDFIELD." = ap.uid");
?>



[Methen]

Ok do  I paste the path here?  define("PATHTOSMF", "../smf/"); right where is says pathtosmf 
as far as bbc codes I know nothing about them  never used them.

update

Would it look something like this ?


define("http://mysite.com/forum/", "../smf/");

[Methen]

Ok I change the code in the querystring like you had over efiction

then I did this to the queries file: the results were the same no difference

define("", "../smf/");

this http://mysite.com/Forum was in there  with the url  tags but it is not showing right above this for some reason



dang it why is everything comeing out in url format?!!!!

[Kindred]

NO.....

define("PATHTOSMF", "../forum/");

[Methen]

I thought you said it had to be a url to me a url is Http://  and added url bcc tags

ok I took that out a put in define("PATHTOSMF", "../forum/");

and got this


Notice: Undefined index: db_query in /home/allbridg/public_html/mysite.com/forum/Sources/Load.php on line 144

Fatal error: Function name must be a string in /home/allbridg/public_html/mysite.com/forum/Sources/Load.php on line 144

[Kindred]

well, what's on line 144 of your load.php?
What other mods do you have installed?
Does your forum work WITHOUT efiction?

Did you make the other changes to queries.php?

URL?

[palofdru]

  Note: this post will not display until it's been approved by a moderator.

I thought you said it had to be a url to me a url is Http://  and added url bcc tags

ok I took that out a put in define("PATHTOSMF", "../forum/");

and got this


Notice: Undefined index: db_query in /home/allbridg/public_html/mysite.com/forum/Sources/Load.php on line 144

Fatal error: Function name must be a string in /home/allbridg/public_html/mysite.com/forum/Sources/Load.php on line 144

It's clear you have a typo somewhere - lets take this up via PM, or MSN

[Methen]

The forum is working fine
I had x7 chat installed and intergrated  but it didnt work and I just took that out and deleted  the tables in it
as far as the querys file all I did was paste in define("PATHTOSMF", "../forum/"); nothing more

asfar as what is on line 144  word processor does not show line numbers
so I have no ideal what is on line 144 IAm trying to find a php viewer that will tell me