vb.org Archive - Vbulletin database connection

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

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Vbulletin database connection (https://vborg.vbsupport.ru/showthread.php?t=284862)

Scanu

06-24-2012 06:28 PM

Vbulletin database connection

Hi, until now i never connected to the vbulletin database i know how to connect to mysql, that's the general code

PHP Code:


		
			
$connect = mysql_connect('server', 'username', 'password');

$db_selected = mysql_select_db('database');

mysql_close($connect);

There is a particular way to connect to the vbulletin database? Should i include config.php to get connect infos or there is a faster way?

I hope i made myself clear thanks in advance, Scanu.

kh99	06-24-2012 07:47 PM

If you're including global.php in the script (or if it's a plugin), then you can just use $vbulletin->db->query_read() (or one of the other query functions).

If you have a separate script and you don't want to include global.php, then I think I'd include config.php and use the config variables from there in mysql calls, like you posted above. You can look in includes/class_core.php, the class vB_Database code that starts around line 83, to see how vbulletin uses the config variables.

Edit: if this is for a mod you're planning to release, I think it's a much better idea to find a way to use the vb code so that you don't have to worry about the database configuration.

Scanu

06-24-2012 10:15 PM

mysql_query() = $vbulletin->db->query
mysql_fetch_row() = $vbulletin->db->fetch_row
mysql_fetch_assoc() = $vbulletin->db->fetch_assoc
mysql_fetch_object() = $vbulletin->db->fetch_object

Just like this?

kh99	06-24-2012 11:35 PM

Quote:

Originally Posted by Scanu (Post 2342639)

I think so - I'm not familiar with all of those. I believe the recommendation is to use query_read_slave() to read and query_write() if you're modifying the database. I guess you can use fetch_array() or fetch_row(), but most of the vbulletin code seems to use fetch_array() - maybe it's just convention.

Also, remember that if you use any strings that you're getting from the outside world in one of your queries, put it through escape_string() first.

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00894 seconds Memory Usage 1,720KB 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 (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: