Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 10-14-2003, 10:30 PM
kill_emma's Avatar
kill_emma kill_emma is offline
 
Join Date: Sep 2003
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How to connect to a vB database & sessions

Right, here's what i'm trying to do, i'm on vB3 Beta 7, and i'm trying to connect to the database and use the vB permisions and the whois online thinger, but i dont know how. Let me plug in this info right now, because i'm stupid and i'm running on localhost so this info is safe.
Server- localhost
Database- forums
Username- root
Password-
(I dont use a pass)

And yes you can discuss this because it's not vB3 hacking, you arent editing any vB files, just accessing them and the database. The only thing i'm editing is my index page on my root site :P.
Reply With Quote
  #2  
Old 10-15-2003, 03:59 PM
bradsears's Avatar
bradsears bradsears is offline
 
Join Date: Aug 2003
Location: Toronto
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm a junior vb hacker but I think the first thing you want to do is take a look at global.php

Then you can include it in your script and essentially you get access to some good functions and variables.

I've had no success using sessions after including vb3beta7 global.php (see my other thread) ... because I think vbulletin clears the session every time global.php runs.
Reply With Quote
  #3  
Old 10-15-2003, 04:05 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
<?

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

// your code here

?>
Reply With Quote
  #4  
Old 10-15-2003, 06:45 PM
kill_emma's Avatar
kill_emma kill_emma is offline
 
Join Date: Sep 2003
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
chdir('./forum'); 
require_once(
'./global.php'); 
$db mysql_connect ('localhost','root','');
mysql_select_db ('general',$db); 
i'm using that and it aint workin.
Reply With Quote
  #5  
Old 10-15-2003, 07:52 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Requiring global.php creates a database connection to you vBulletin database and creates the users session for you.
Reply With Quote
  #6  
Old 10-15-2003, 09:02 PM
kill_emma's Avatar
kill_emma kill_emma is offline
 
Join Date: Sep 2003
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok, so now i'm using:
PHP Code:
     <?php 
     chdir
('forum');
    require_once(
'./global.php'); 
                echo 
"members: $numbermembers<br>" .
     
"threads: $totalthreads<br>" .
     
"posts: $totalposts<br>" .
                 
"users online: $totalonline<br>";
     
?>
no workie, i get this error:
Quote:
Originally Posted by damn localhost
Warning: chdir(): No such file or directory (errno 2) in C:\network\Apache2\htdocs\index.php on line 51
line 51 of course being chdir('forum');
Reply With Quote
  #7  
Old 10-15-2003, 09:17 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PHP Code:
chdir('forum'); 
The above isn't valid, enter the full path to the forums directory and it will work. Note that the total threads posts etc won't be displayed even if it works.
Reply With Quote
  #8  
Old 10-15-2003, 09:19 PM
kill_emma's Avatar
kill_emma kill_emma is offline
 
Join Date: Sep 2003
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

why wont it work?
Reply With Quote
  #9  
Old 10-15-2003, 09:28 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Because you actually have to get the values to fill the variables, they aren't done automatically by requiring global.php.
Reply With Quote
  #10  
Old 10-16-2003, 06:09 PM
kill_emma's Avatar
kill_emma kill_emma is offline
 
Join Date: Sep 2003
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

how are they done if i may ask :P
Reply With Quote
Reply

Thread Tools
Display Modes

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 05:44 AM.


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.04554 seconds
  • Memory Usage 2,260KB
  • Queries Executed 13 (?)
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
  • (4)bbcode_php
  • (1)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_postinfo_query
  • fetch_postinfo
  • 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