vb.org Archive - Deluxe vB User login and access control on non vB pages

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Deluxe vB User login and access control on non vB pages (https://vborg.vbsupport.ru/showthread.php?t=108026)

Alright i downloaded this a few days ago so i should have every update made. I inserted the code into my index.php file, in the spot i want it, the username and password fields show up great, but just under the "Submit Query" button im getting this error

Fatal error: Call to a member function query_read() on a non-object in /home2/grastyz/public_html/login_inc.php on line 149

I dont know why, and i know nothing about coding, so any help would be much appreciated (I have VB 3.5.4 if that makes a difference)

somewhere else on these forums i found a suggestion to change $db-> to $vbulletin->db but that didnt work so i changed it back

Quote:

Originally Posted by delive

Hey, I'm still getting problems with the logging in, then it doesn't show me logged in. Sometimes, if I clear my cookies it will work. Then the next time I turn on my computer, or anyone elses for that matter, it won't work. The cookies setting in vb is set to /. I really dont understand why this keeps happening.

Another question, is there a way to decrease the loading times? I've gotten a couple comments that it takes a while for the page to load and it gets stuck when grabbing the users information after they logged in. Am I the only one that gets that?

Does anyone have any ideas?

Quote:

Originally Posted by delive

Another question, is there a way to decrease the loading times? I've gotten a couple comments that it takes a while for the page to load and it gets stuck when grabbing the users information after they logged in. Am I the only one that gets that?

Should be no noticeable difference in loading time from a normal page.

Is this page and your forums located on the same server?

Have you used the simple troubleshooting test page?
If so, did you still have the slow loads and random timeouts?

Quote:

Originally Posted by Grasty

Have you tried the test login script in the troubleshooting section yet?

Also, can you post your pages code here so I see if there is anything obvious.

Hey, we run our site on multiple servers, Meaning I would like to use this script, but instead of a server path. (Since the are broken up between servers) Is there a way to provide the ability for external server support to lock in and do everything?

I would assume its just a simple connect to the sql database and fetch the data.

Quote:

Originally Posted by Billspaintball

Have you tried the test login script in the troubleshooting section yet?

Also, can you post your pages code here so I see if there is anything obvious.

I just tried it and everything worked fine from the test page

I dont see what the difference is. But here is my code anyway

This is lines 144-159

PHP Code:


		
			
// +++++++++++++++++++++++++++++++++++++++++++++++++++
// we want do display stats either way so they go here
// +++++++++++++++++++++++++++++++++++++++++++++++++++

// get total number of threads and posts
$getstats = $db->query_read('SELECT threadcount, replycount FROM ' . TABLE_PREFIX . 'forum');
while ($forum = $db->fetch_array($getstats))
{
    $totthreads += $forum['threadcount'];
    $totposts += $forum['replycount'];
}
$totthreads = vb_number_format($totthreads);
$totposts = vb_number_format($totposts);

// display total threads and total posts - Uses vB phrases, but change if you like
echo"<br /> $vbphrase[threads]: $totthreads<br />$vbphrase[posts]: $totposts<br /> ";

That and i was wondering how to make it redirect right back to the home page, not to the forums, once you login

Hi. I know you aren't required to provide support for third party software and I don't expect you to but I was hoping you could help me out.

I'm using CMSMS (Content Management System Made Simple) and I'm trying to use your hack.

The CMS lets me define php tags to use in the template code so that's no problem. However, when I execute the chdir call, it gives me this:

Code:

Warning: array_keys() [function.array-keys]: The first argument should be an array in /includes/functions.php on line 3291



Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3291

I think it may be a naming conflict somewhere (between vB and the CMS) but I'm not sure how to proceed. Any ideas?

Line 3291 is foreach (array_keys($vbulletin->forumcache) AS $forumid) and I don't see how that conflicts with CMSMS...

I'd appreciate your input. Hope to hear a reply from you one way or the other. Thanks.

Edit: For reference, I set up a test.php page on my site (manually, not via the CMS) and it worked perfectly.

Quote:

Originally Posted by Billspaintball

The slow loads are just a minor issue. The real issue is the thing saying it logged in and returns to the main website without actually being logged in. Currently it won't do it at all, even after deleteing cookies.

Disregard my previous post, I solved the problem by putting the page into an iframe on the CMS template.

Great hack, thanks.

Any word on if my idea can work? We would love to use this on our site, which we run on a seperate server from the forums. Would love to be able to access usergroup permissions to setup usergroup page content on the site itself, but need to be able to do remote server access.

Quote:

Originally Posted by Mysticales

It might get it working if you change a couple of settings.
vB has cross site logins off by default as a security measure.

Have a look in the troubleshooting section here https://vborg.vbsupport.ru/showpost....49&postcount=2 to see what you can try.

Quote:

Originally Posted by Grasty

I just tried it and everything worked fine from the test page

I dont see what the difference is. But here is my code anyway

This is lines 144-159

I need to see more of the pages code than that.
You error may appear around there, but be caused elsewhere on the page.

Quote:

That and i was wondering how to make it redirect right back to the home page, not to the forums, once you login

It does redirect stright back to the page you logged in from.
The error on your page is probably stopping it fron doing that.

Yea I have the site www.qj.net which we have on a seperate server from the forums, which means the main site and the forums wont BE on the same host and ftp. So meaning, the main site would 1st need to call the data off the SQL tables I assume, then apply it.

I would assume all one needs to use is the command in a php page for.

Code:

<?php

mysql_connect('sql server', 'user', 'password');

?>

Would that be all thats needed? Then remove the chdir line from the codes calling it?

I mean what would you think? Cause its not a matter of cross site on same host, its about crossing onto a different host server with same domain ending.

Edit:

After more studies.. I wonder if somehow we can replace the local path settings with a remote SQL calling. (Which I know sadly requires a IP for the sql server which I dont know if thats really easy to setup with most hosts)

Code:

// connect

$cs = mssql_connect ( 'server_name:port', 'username', 'password' ) or die ( 'Can not connect to server' );



// select

mssql_select_db ( '[database_name]', $cs ) or die ( 'Can not select database' );



//query

$sql = "SELECT * FROM [TABLENAME]";

$r = mssql_query ( $sql, $cs ) or die ( 'Query Error' );



// loop the result



while ( $row = mssql_fetch_array ( $r ) )

{

        /* do stuff */

}

Would be a idea for the remote calling. Unless somehow... there is a way to do cross server calling easier for vB access and database checking?

PHP Code:


		
			
<?php
// Edit the lines below to show path to your forums
$forumpath = "http://grastyzone.net/forums";

// Set the maximum display size for the avatar
$maxw = 100; // Max thumbnail width
$maxh = 100; // Max thumbnail height

// ++++++++++++++++++++++++++++++++++
// Deluxe vB User login and access control on non vB pages
// Version 2.10 - June 4 2006
// By Bill  [email]bill@billspaintball.com[/email]
// ++++++++++++++++++++++++++++++++++


// ++++++++++++++++++++++++++++++++++
// You dont have to edit anything underneath here,
// but you can if you wish to style the login box
// to match the style of your site.
// ++++++++++++++++++++++++++++++++++



// We check if user is logged in
if ($vbulletin->userinfo['userid']!=0) {


// ++++++++++++++++++++++++++++++++++
// display avatar - resize if too big
// ++++++++++++++++++++++++++++++++++

$userid=$vbulletin->userinfo['userid'];
$file = $forumpath."/image.php?u=$userid";
list($width, $height, $type) = getimagesize($file);

if ( $width <= $maxw AND $height <= $maxh )// check width and height
   {// if width and height under size display unchanged
       echo "<img src=\"$file.$type\" align=\"center\" border=\"0\">";
   }
   else 
   {  
    if ($width > $maxw)//check if width is too wide
        { // if it is, resize
        $ratio = $width / $maxw; //work out resize ratio
        $newwidth = $maxw; // new width
        $newheight = ($height / $ratio); // new height at this resize
        }
        else
        {
        $newheight = $height; // if width is ok, set this cos we need it later
        $newwidth = $width; // if width was ok, set this cos we ned it later
        }
    If ($newheight <= $maxh )        
        {
        // if current height is ok, were done.
        } 
        
        else // either origional or resized height is too big
            if( $newheight >= $maxh )
            { // if resized height is still too big we resize it
            $ratio2 = $newheight / $maxh; //work out resize ratio
            $newheight = $maxh; // give $newheight a new value
            $newwidth = ($newwidth / $ratio2); // new width at this resize
            } // the value of $newwidth has just been changed
            else
            {// if were here then origional height is too big so we resize it
            $ratio2 = $newheight / $maxh; //work out resize ratio
            $newheight = $maxh; // give $newheight a new value
            $newwidth = ($newwidth / $ratio2); // new width at this resize
            }

        // now we can finally display resized pic
        echo "<img src=\"$file.$type\" border=\"0\" width = \"$newwidth\" height = \"$newheight\" align=\"center\">"; // display resized pic
   }
// +++++++++++++++++++++++  
// end avatar display code
// +++++++++++++++++++++++ 


// +++++++++++++++++++++++++++++++++++++++++
// As Logged in display welcome back message
// +++++++++++++++++++++++++++++++++++++++++
echo "Welcome Back, <b>";
echo $vbulletin->userinfo['username'];
echo " !</b><br>";

// As were logged in display logout link
echo "<a href=\"".$forumpath."login.php?$session[sessionurl]do=logout&amp;logouthash=$logouthash";
echo $vbulletin->userinfo['logouthash'];
echo "\">";
echo "<font size=\"1\" face=\"verdana\">Log Out</font></a><br>";

// Display last visit time and date
echo "You last visited: $pmbox[lastvisitdate] at $pmbox[lastvisittime]";
echo "<br>";

// Display PM Details and generate link to PM box
echo "<a href=\"".$forumpath."private.php?$session[sessionurl] \">Private Messages: </a> $vbphrase[unread_x_nav_compiled] $vbphrase[total_x_nav_compiled]";
echo "<br>";

} else { 



// ++++++++++++++++++++++++++++++++++++++++++
// If user is not logged in, we do this stuff
// ++++++++++++++++++++++++++++++++++++++++++

// Display text and link to register.
echo "
    You have to <a href=\"".$forumpath."/register.php?s=$session[sessionhash]\"
    target=\"_parent\"><b>register</b></a>  before you can post on our forums or use our advanced features.
    ";

// Display login boxes + button
// You can style this with html or CSS as normal if desired.
echo"
    <form action=\"".$forumpath."/login.php\" method=post onsubmit=md5hash(vb_login_password,vb_login_md5password,vb_login_md5password_utf)>
    <script type=text/javascript src=\"".$forumpath."/clientscript/vbulletin_md5.js\"></script>
    User Name:<br>
    <input name=vb_login_username type=text id=navbar_username size=10 />
            
    <br>Password:<br>
    <input name=vb_login_password type=password size=10 />
    </br>
        
    <label for=cb_cookieuser_navbar><input name=cookieuser type=checkbox id=cb_cookieuser_navbar value=1 checked=checked />
    Remember Me?<br /></label>
    
        
    <input type=submit title=$vbphrase[enter_username_to_login_or_register] value=\"Log In\" />
        
    <input type=hidden name=s value=$session[sessionhash] />
    <input type=hidden name=do value=login />        
    <input type=hidden name=vb_login_md5password />
    <input type=hidden name=vb_login_md5password_utf />

    </form>
";
// +++++++++++++++++++++++++++++++++++++++ 
// End of login box for non logged in user
// +++++++++++++++++++++++++++++++++++++++
}

// +++++++++++++++++++++++++++++++++++++++++++++++++++
// we want do display stats either way so they go here
// +++++++++++++++++++++++++++++++++++++++++++++++++++

// get total number of threads and posts
$getstats = $db->query_read('SELECT threadcount, replycount FROM ' . TABLE_PREFIX . 'forum');
while ($forum = $db->fetch_array($getstats))
{
    $totthreads += $forum['threadcount'];
    $totposts += $forum['replycount'];
}
$totthreads = vb_number_format($totthreads);
$totposts = vb_number_format($totposts);

// display total threads and total posts - Uses vB phrases, but change if you like
echo"<br /> $vbphrase[threads]: $totthreads<br />$vbphrase[posts]: $totposts<br /> ";

// Only display link and number of new posts if logged in
if ($vbulletin->userinfo['userid']!=0) {

// finds number of new posts
$newposts = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post AS post " . iif($vbulletin->options['threadmarking'], 'LEFT JOIN ' . TABLE_PREFIX . 'threadread AS threadread ON (threadread.threadid = post.threadid AND threadread.userid = ' . $vbulletin->userinfo['userid'] . ')') . " WHERE dateline >= " . $vbulletin->userinfo['lastvisit'] . iif($vbulletin->options['threadmarking'], ' AND dateline > IF(threadread.readtime IS NULL, ' . (TIMENOW - ($vbulletin->options['markinglimit'] * 86400)) . ', threadread.readtime)'));
$newposts = vb_number_format($newposts['count']);

echo"<a href=\"".$forumpath."search.php?$session[sessionurl]do=getnew\">$vbphrase[new_posts]</a>: $newposts<br />";}
//  end of number of new posts stuff
?>

here you go, i just now tried replacing the one i changed with the one you posted. and it still gave me the error, the only thing i changed on this one was the forum path

Thanks Bill - this is a great mod. Worked perfect :)

It would be great it it would also grab the total member count, and users online (members and guests). That would be even more perfect :)

Would love to see a screen shot of it in action

Quote:

Originally Posted by jdk10

Would love to see a screen shot of it in action

I know how you feel - I would have like some screenshots beforehand.... here is how it looks on my site (I've removed some stats from the second screen!)

Quick question -

I'm using

PHP Code:


		
			
if ($vbulletin->userinfo['usergroupid'] == '5' 

 or $vbulletin->userinfo['usergroupid'] == '7' 

)  {

right now to allow someone access to one area. What is the code that evaluates the users additional usergroups. Is it possible to check and see if they are part of an additional usergroup?

Quote:

Originally Posted by Mysticales

I would assume all one needs to use is the command in a php page for.

Code:

<?php

mysql_connect('sql server', 'user', 'password');

?>

Would that be all thats needed? Then remove the chdir line from the codes calling it?

No.
The user passwords for vB are encrypted when they are stored in the database so you cant authenticate just like that.

Quote:

Originally Posted by Grasty

here you go, i just now tried replacing the one i changed with the one you posted. and it still gave me the error, the only thing i changed on this one was the forum path

Sorry I should have been more clear, I ment the page that calls this include.
Thats were the problem will be.

Hi I keep ketting this error
Fatal error: Call to a member function on a non-object in /home/saiyanli/public_html/login_inc.php on line 150

Quote:

Originally Posted by Remonh

Hi I keep ketting this error
Fatal error: Call to a member function on a non-object in /home/saiyanli/public_html/login_inc.php on line 150

Try step 5 in the troubleshooting section first https://vborg.vbsupport.ru/showp...49&postcount=2
Let me know if that works.

PHP Code:


		
			
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Grastyzone.net</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body,td,th {
    color: #FFFFFF;
}
body {
    background-color: #000000;
    
}
.style1 {font-size: 12px}
.style2 {
    font-family: Watertank;
    font-size: 24px;
}
-->
</style></head>

<body>
  <table border="0" cellpadding="0" cellspacing="0" width="625">
    <tr>
      <td width="625" height="100" background="/images/banner.png">&nbsp;</td>
    </tr>
    <tr>
      <td width="650" height="10">
      <div align="left"><img src="images/spacer.png" width="625" height="10"></div></td>
    </tr>
    <tr>
      <td><table width="600" height="100"  border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td width="100"><div align="center"><a href="http://grastyzone.net/about.php"><img src="images/about.png" width="100" height="100" border="0"></a></div></td>
            <td width="100"><a href="http://grastyzone.net/cs.php"><img src="images/cs.png" width="100" height="100" border="0"></a></td>
            <td width="100"><a href="http://grastyzone.net/techcrew.php"><img src="images/techcrew.png" width="100" height="100" border="0"></a></td>
            <td width="100"><a href="http://grastyzone.net/comedy.php"><img src="images/comedy.png" width="100" height="100" border="0"></a></td>
            <td width="100"><a href="http://grastyzone.net/affiliations.php"><img src="images/affiliations.png" width="100" height="100" border="0" align="top"></a></td>
            <td width="100"><a href="http://grastyzone.net/contact.php"><img src="images/contact.png" width="100" height="100" border="0"></a></td>
          </tr>
        </table></td>
    </tr>
    <tr>
      <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="16%" valign="top"><table width="200"  border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="200" height="200"><?php 
    require_once('login_inc.php'); 
?> </td>
              </tr>
              <tr>
                <td>&nbsp;   </td>
              </tr>
              <tr>
                <td><img src="images/forums.png" width="100" height="40"></td>
              </tr>
              <tr>
                <td><img src="images/links.png" width="100" height="40"></td>
              </tr>
            </table></td>
            <td width="84%"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="2%"><img src="images/construction.png" width="100" height="100"></td>
                    <td width="98%"><span class="style2">Yes that is right, the site is under construction. The site will feature a variety of new changes soon so check back often </span></td>
                  </tr>
                </table></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
            </table></td>
          </tr>
        </table></td>
    </tr>
    <tr>
      <td><div align="center" class="style1">Chris Grasty (2006) Grastyzone.net </div></td>
    </tr>
</table>
</body>
</html>

Here you go, index.php

Ok, looks like you skipped the first half of part one of the instructions. :)

Change

PHP Code:


		
			
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Grastyzone.net</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">

<!--

body,td,th {

PHP Code:


		
			
<?php

chdir('/path/to/your/forums'); 

require_once('/path/to/your/forums/global.php');  

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Grastyzone.net</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">

<!--

body,td,th {

NOTE: You need to change line 2 and 3 to reflect your sites layout.

i didnt think i needed that because i wasnt restricting access to that page. That is the index page

And that fixed the error, but when i log in it still doesnt redirect back to where i logged in from, it goes to the forum home.

Nevermind, apparently sometimes it goes to the forum index, sometimes to where i logged in from.

Is there a way to make it go back to the home page (not forum home) on logout???? it doesnt do that for me

brilliant, just what i needed, /me clicks install

What is the code that evaluates the users additional usergroups. Is it possible to check and see if they are part of an additional usergroup?

What should i change
$vbulletin->userinfo['usergroupid'] == '5'
to?

Hey with this code. I could technically connect to my user profiles and pull "x" profile field from it to display in a page table of my site, right?

will this work on 3.6 forums?

I'm having some trouble, and it's probably due to my lack of knowledge...

Could you please provide instructions on how to use iframes to include this on non-PHP pages? My front end content engine is shtml based.

Quote:

Originally Posted by bandare

will this work on 3.6 forums?

Yes, I'm using it with 3.6 right now without any problems :).

Quote:

Originally Posted by Taco John

Sorry it only works with PHP.

*edit* Thanks for the GREAT mod Bill! but Ive suddenly got a problem. One of my workstations (WinXPpro, all windows updates, IE6 etc) is not being redirected back to the custom .php page I made. It's just going straight to the index.php for the forums. Although one of my other workstations (same specs) is being redirected. I cleared cookies etc but it's still not working. Ive made no major changes. Without me posting a bunch of my code here - any thoughts? Im certain my paths are correct etc because this was working before and still works on my other PC...

Thanks in advance!

Well I managed to fix this. on about line 154 there was this:
echo"<br />...
Which I changed to take out the /:
echo"</br>...
Would this have helped?

Well that seemes to work once - now I am not redirecting anymore. This is so frustrating...

*edit*
I have determined that my problem is this: I can log into my custom page (home.php) 1 time and get redirected back to that page after logging in. Subsequent logins (after clearing cookies etc) take me directly to the forums index.php page. I have no idea whats wrong. I made a new profile on my PC and logged into it so it was a fresh user. I then logged into my home.php which includes the basic require_once info etc and got redirected back to that page - the avatar displaying correctly etc. I logged out and cleared cookies and immediately logged back in and instead of being redirected I get the forum index.php page...
I have done all of the troubleshooting recommended by Bill and I KNOW my paths are correct. I just realized also that I was having the double // problem which I fixed in the login_inc.php. Ive also tried verifying there was no spyware on my PC (AdAware), no windows firewall turned on (WinXPpro), doing Windows Updates, I even tried Firefox (didnt work either), my VB cookie path has always been / and not /forums/ etc...

Im lost as to what to try next...

Quote:

Originally Posted by delive

I would also like to know a solution to this.

Quote:

Originally Posted by Grasty

I would also like to know a solution to this.

There have been a number of requests for this.
I havent had time yet to look at how vB handles secondary groups.
Its on the todo list, but no ETA as yet.

can you fix this code.. on my regular pages, i've got a redirect code in the form field that redirects to the usercp during login. i've tried using the same code in the login_inc.php file, but it doesn't seem to work:

<input name="url" type="hidden" value="/usercp.php" />

What error do you get?

What happens if you use the full url instead of just /usercp.php ?

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02020 seconds Memory Usage 1,967KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (6)bbcode_php_printable (16)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: