Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2005, 05:37 PM
run.exe's Avatar
run.exe run.exe is offline
 
Join Date: Mar 2004
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default functions_legacy.php / enable_legacy()

How/where, exactly, can I enable legacy (pre v5.x.y) PHP functionality, please?

I checked in my functions_legacy.php file; however, enable_legacy() is already present/not commented out.

I need to debug/troubleshoot why my old (external) DB calls are not working, anymore, via PHP/vB (despite my inclusion of global.php).

Specifically, the following code does not appear to process/recognize the fact that the logged-in user is really logged in:

PHP Code:
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS'1);
define('THIS_SCRIPT''vborg_miscactions');

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array();

// pre-cache templates used by specific actions
$actiontemplates = array();
$self_dir getcwd();
chdir('../');
require_once(
'global.php');
chdir($self_dir);
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>External (non-vB) Database Browser</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="styles/styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style4 {color: #333333}
body {
background-color: #333333;
scrollbar-face-color: #F9F9F9;
scrollbar-highlight-color: #cccccc;
scrollbar-shadow-color: #F9F9F9;
scrollbar-3dlight-color: #F0F0F0;
scrollbar-arrow-color: #656060;
scrollbar-track-color: #FFFFFF;
scrollbar-darkshadow-color: #cccccc;
}
-->
</style>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

<? if($vbulletin->userinfo['userid'] == 0) { ?>
<table width="100%" height="100%" cellpadding="3" cellspacing="0" border="0">
<tr valign="middle"><td align="center">
<table width="618" height="30" border="0" cellpadding="3" cellspacing="0">
<tr>
<td colspan="2"width="612" height="27" align="center" bgcolor="#F0F0F0"><span class="section">External (non-vB) Database Browser</span></td>
</tr>
<tr bgcolor="#999999">
<td colspan="2" height="1"></td>
</tr>
<tr bgcolor="#FFFFFF">

<table width="618" height="20" border="0" cellpadding="3" cellspacing="0">
<tr bgcolor="#FFFFFF">
<td align="center"><span class="note">NOT LOGGED IN</span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center"><span class="text"><a href="http://www.500Ecstasy.com/forums/">log in</a></span></td>
</tr>
</table>
<tr>
<td colspan="2" align="left"><span class="text">&nbsp;</span></td>
</tr>
</table>
</td></tr>
</table>
<? } else { // is logged in ?>
<? if($vbulletin->userinfo['usergroupid'] == 6 || $vbulletin->userinfo['usergroupid'] == 8 || $vbulletin->userinfo['usergroupid'] == 9 || $vbulletin->userinfo['usergroupid'] == 10 || $vbulletin->userinfo['usergroupid'] == 11) { // is correct level user ?>
<?php
mysql_pconnect
("hostname""username""password") or die("Unable to connect to SQL server!");
mysql_select_db("database") or die("Unable to select database!");

if(
$_GET[perPage] > 25$_GET[perPage] = 25;
if(
$_GET[perPage] < 25$_GET[perPage] = 25;




Thank you,
Reply With Quote
  #2  
Old 11-19-2005, 05:43 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What is exactly not working?
I see you are using pconnect, i strongly advice against this, unless really needed.

I also don't see why you would need legacy functions?
Reply With Quote
  #3  
Old 11-19-2005, 06:04 PM
run.exe's Avatar
run.exe run.exe is offline
 
Join Date: Mar 2004
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarcoH64
What is exactly not working?
I see you are using pconnect, i strongly advice against this, unless really needed.

I also don't see why you would need legacy functions?
Thank you for your reply, Marco.

1) what is not working: connecting to external (non-vb) MySQL Databases and having vB userid/groupid/login status variables passed/read

http://www.500ecstasy.com/forums/LH/...e=0&perPage=25 yields the following error:



2) I have been using mysql_pconnect since the beginning; I tried mysql_connect without success, either...

3) legacy functions would (in theory) cause my broken PHP (see above) to work, in the interim, between now and the time it will take me to re-code



Thank you,
Reply With Quote
  #4  
Old 11-19-2005, 06:30 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just tried your code as a standalone script and it is working without an error.

I guess the userinfo error message in the top is part of your problem.

Do you have public phpinfo enabled?
Reply With Quote
  #5  
Old 11-19-2005, 07:17 PM
run.exe's Avatar
run.exe run.exe is offline
 
Join Date: Mar 2004
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarcoH64
Do you have public phpinfo enabled?
Yes, temporarily.

What do you see/suggest?
Reply With Quote
  #6  
Old 11-19-2005, 07:49 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You can disable phpinfo again.

I didn't see anything that could directly be causing this.

If you take the exact file you posted here (it is obvious not the real file, things like passwords edited out) and save it as test.php, and only put "}}?>" in the bottom, do you still get the userinfo..... message?

If yes, try replacing the shorthand php opening tags '<?' by long tags '<?php' and see if that make any difference.
Reply With Quote
  #7  
Old 11-19-2005, 07:52 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PS Why you keep opening and closing php:
PHP Code:
<? } else { // is logged in ?> 
<? if($vbulletin->userinfo['usergroupid'] == 6 || $vbulletin->userinfo['usergroupid'] == 8 || $vbulletin->userinfo['usergroupid'] == 9 || $vbulletin->userinfo['usergroupid'] == 10 || $vbulletin->userinfo['usergroupid'] == 11) { // is correct level user ?> 
<?php
Why not just:
PHP Code:
<?php } else { // is logged in 
if($vbulletin->userinfo['usergroupid'] == || $vbulletin->userinfo['usergroupid'] == || $vbulletin->userinfo['usergroupid'] == || $vbulletin->userinfo['usergroupid'] == 10 || $vbulletin->userinfo['usergroupid'] == 11) { // is correct level user
Reply With Quote
  #8  
Old 11-19-2005, 08:18 PM
run.exe's Avatar
run.exe run.exe is offline
 
Join Date: Mar 2004
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarcoH64
You can disable phpinfo again.

I didn't see anything that could directly be causing this.

If you take the exact file you posted here (it is obvious not the real file, things like passwords edited out) and save it as test.php, and only put "}}?>" in the bottom, do you still get the userinfo..... message?

If yes, try replacing the shorthand php opening tags '<?' by long tags '<?php' and see if that make any difference.

1) I added the string "}}?>" to my PHP file and saved it as "test.php"

2) I opened "test.php" in a browser and a white/blank page was displayed (in Firefox 1.0.7 & IE6)

3) I edited "test.php" and changed all shorthand php opening tags '<?' to long tags '<?php'

4) I reopened "test.php" in a browser and a white/blank page was displayed (in Firefox 1.0.7 & IE6) again

5) I editied my PHP usergroupid checking routine as specified, above, and repeated step #4; a white/blank page was displayed (in Firefox 1.0.7 & IE6) again
Reply With Quote
  #9  
Old 11-20-2005, 05:29 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

A white blank page is better then what you got before. Before it somehow echoed userinfo....., which was part of $vbulletin->userinfo...
Reply With Quote
  #10  
Old 11-20-2005, 06:20 PM
run.exe's Avatar
run.exe run.exe is offline
 
Join Date: Mar 2004
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you; what shall I do, next? I'm stumped...
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:21 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05238 seconds
  • Memory Usage 2,276KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete