Query SQL Database.

[BinaryBrother]

I own BinaryBrother Dot com and I've been wanting to do something for quite a while now, but my limitation in PHP prohibits me... and just because I own a domain doesn't mean I know the first thing about anything... lol.

 

I have 'Nexus' & 'SMF' installed on my site, and I'm in the middle of transferring all my information from one server to another, and I'm about done, now I'm waiting on my Domain to propagate the new name-servers. I'm also a member of the 'AutoIt' forums, and we hate to see people come in without any information wanting something done FOR them, and that's not what I'm trying to do here, I've researched PHP quite a bit, and can actually carry out basic functions... but I just can't truly grasp PHP as I have 'AutoIt', C# and a few others, as I 'am' a developer... Just not so much a PHP 'Developer' at that... 

 

I want to allow people to sign-up for Nexus accounts for free, and that is already built into Nexus. You can find more information about Nexus here http://iwonderdesigns.com/index.php?s=nexus , for those of you who haven't heard of it, like me about 20 minutes prior to this post. My problem is, I want to only allow sign-up to those who already have forum accounts. I don't really want to link the SQL Databases because there is a whole line of permission granting that I'm just not ready for. I was thinking about integrating a PHP Sign-in page that would force the user to sign-in with the forum account, before they could register an account. If I could link the fact that the user is currently logged in, to the fact that a 'Forum' user is trying to register, I could have the PHP Script allow sign-up anyway. I don't have any code to show that I've even got started, but then again I'm not asking anyone to build it for me, I'm just looking for 'ideas' and maybe even a few PHP Functions thrown at me, so that I may get started...

 

Thank you guys so very much!

 

P.S. If my Domain being in my first post causes a problem, a Mod can remove it immediately without me getting offended... I Just wanted something to prove I'm not coming here for a hand-out...

[Mchl]

Do you know how sessions work in PHP?

[BinaryBrother]

Not really, but I do know I set the SMF up to be Session driven.  ???

I done a quick Google and I'm reading up on it now.

 

Maybe I could...

Set this on the Forum...

<?php
session_start(); 
$_SESSION['member'] = true;
?>

 

Then call it from Nexus, but I'm sure SMF already sets a session of some sort, so maybe I could call to see if that session exists?

 

I'll be back in a sec with some more example ideas to see if they are plausible...

 

[Mchl]

Well... you'll almost certainly will find it useful.

[BinaryBrother]

SMF Has all sorts of documentation regarding EXACTLY what I need... I just had to search for SessionID in regard to SMF, and boom... Thanks Mchl!

 

But please don't close this post just yet, as I'm not sure I can figure all this out, so I'll be back in a few mins to either acknowledge I need another push, or that I've solved it!

 

Thanks guys!

[BinaryBrother]

[30-Jan-2009 19:48:54] PHP Fatal error:  shDocumentUploadServer::__construct() [<a href='shdocumentuploadserver.--construct'>shdocumentuploadserver.--construct</a>]: The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "iwApplication" of the object you are trying to operate on was loaded _before_ unserialize() gets called or provide a __autoload() function to load the class definition  in /home/binary/public_html/nexus/include/engine/shDocumentUploadServer.class.php on line 16

 

Original Index.php (Nexus) -Works... but anyone can register

<?php
define ('IWONDER_INTERNAL_SCRIPT', 'nexus');
define ('IWONDER_LIB_SOURCE_FILE', __FILE__);
define ('IWONDER_LIBRARY_REL_PATH', 'include/engine/core/');
require_once ('include/nexus.inc.php');
app()->showPage ('shMainPage');
?>

 

Modified Index.php (Nexus) - If your not logged in, displays 'Sorry', works... But once you log in to the forums and visit it, it throws that ugly error... Above.

 

<?php require_once("/home/binary/public_html/SSI.php"); ?> 
<?php
if ($context['user']['is_guest'])
{
   echo 'Sorry, please login to the forum first.';
}
else
{
define ('IWONDER_INTERNAL_SCRIPT', 'nexus');
define ('IWONDER_LIB_SOURCE_FILE', __FILE__);
define ('IWONDER_LIBRARY_REL_PATH', 'include/engine/core/');
require_once ('include/nexus.inc.php');
app()->showPage ('shMainPage');
}
?>

 

I'm trying to see why "shDocumentUploadServer.class.php" is throwing that error...

[Mchl]

I think that it might have something to do with __autoload() function. Maybe it is declared in SSI.php, and then nexus tries to redeclare it? This should throw different error though...

 

I guess you should go to shDocumentUploadServer.class.php to line 16 and see what's going on there

[BinaryBrother]

I can't find any examples on Google of how to use Session Information better... Would it be possible to add this to my forums...

<?php
session_start(); 
$_SESSION['gottabeamember'] = 1;
?>

 

And then This on my Nexus?

 

<?php
session_start();  
if(isset($_SESSION['gottabeamember']))
    echo 'Carry out PHP functions here...';
else
    echo 'Sorry bub... GottaBeAMember... ';
?>

 

 

[Mchl]

Should be. Although you might want to check, if the session is not started somewhere else.

 

I've never actually done any work on bridging two scripts, so I'm just shooting wild here

[BinaryBrother]

Nexus apparently had some strings or variables that were conflicting with the Nexus login, I think I might force login on a page, and on success integrate a hidden IFrame... Highly insecure I know... but It will keep most of the codgers out... lol

 

Still working on a solution, I'll post back with more news so that maybe others can find this...