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)

anyone got an idea for my problem?

Hi there, great hack which I have installed and got working. Really pleased and will probably donate but wondered if anyone has managed to resolve an issue mentioned in one of these postings.

Has anyone managed to edit the script to get it to validate to xhtml strict?

My web template is valid without the script but gets lots of validation errors once included in my site template.

I would appreciate if anyone has managed to do this and maybe it could be included??

i will donate and not to less, if someone can help me, its really urgent, my problem is on page 22 of this thread

thanks again, dave

dont understand that nobody can help me, even for money? maybe i will write the text with javascript and include this

I still seem to be plagued with this:

Fatal error: Call to a member function on a non-object in /home/pause/public_html/dev/modules/login_inc.php on line 169

error. The offending line is:

PHP Code:


		
			
// 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 />";



}

So i went and did a SQL query:

Quote:

SQL query: Documentation

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)')

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "post AS post " . iif($vbulletin->options['threadmarking'], '' at line 1

I have total posts commented out due to a similar problem - but don't need that feature anyway. However, the rest of the files works fine - avatar, pm's etc.

I am pretty sure i have all the correct includes and files/paths. So i can only assume there is either a problem in the query, or people are using different versions of SQL and in one of these MySQL updates, some function has been changed.

I am currently on MySQL version 4.1.21-standard.

Any ideas?

Quote:

Originally Posted by Muppettt (Post 1267575)

I still seem to be plagued with this:

Fatal error: Call to a member function on a non-object in /home/pause/public_html/dev/modules/login_inc.php on line 169

error. The offending line is:

PHP Code:


		
			
// 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 />";

}

So i went and did a SQL query:

I have total posts commented out due to a similar problem - but don't need that feature anyway. However, the rest of the files works fine - avatar, pm's etc.

I am pretty sure i have all the correct includes and files/paths. So i can only assume there is either a problem in the query, or people are using different versions of SQL and in one of these MySQL updates, some function has been changed.

I am currently on MySQL version 4.1.21-standard.

Any ideas?

If you actually used that query in phpmyadmin or a similar client then it wouldn't have worked as you're trying to use php in it. i.e. variables like $vbulletin etc wouldn't work in phpmyadmin nor would ' . TABLE_PREFIX . ' you'd need to replace that block of code with whatever your forum's prefix is in the database i.e. f_users would have a prefix of f_ so for this example: AS count FROM " . TABLE_PREFIX . "post would become AS count FROM f_post

Hope that helps in at least finding out what your issue is.

Hi again, does anyone know what if statement I could use to display a message on my site which has this hack installed for users with a post cont of zero?

Also is it possible to redirect to certain url or forums based upon usergroup or post count for members logging in at my website with this hack rather than logging in at my forums.

Works fine! Just one last important vital thing missing i believe, we have the total number of users online? not the users them selves but the total members online in numbers? like "30" and also a sep for guests?

Cheers!

A new bug... the avatar dosent change when its changed on the forum..

Can anyone tell me what I'm doing wrong, or if this is even possible. I'm trying to add the login on an .shtml page using php includes. Is this possible? Here's my php code placed in my shtml page:

PHP Code:


		
			
<?php include("/home/xxxmysite/public_html/forums/login_inc.php"); ?>

login_inc.php is in my forums root, and I created a test.php file with the code required in step 1 (with correct paths), also loaded my forums root. I've checked all the paths and they seem to be correct. Any advice is greatly appreciated.

Thank you

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01448 seconds Memory Usage 1,765KB 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 (3)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: