vb.org Archive - vb variables

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

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

- - vb variables (https://vborg.vbsupport.ru/showthread.php?t=172455)

Darry

03-08-2008 04:17 PM

vb variables

while we register at our forum at the same time i need to insert into another db username password and e-mail variables typed by user at forum register page

how can i do it?

PHP Code:


		
			
mysql_query("INSERT INTO users (username, password, email,) VALUES (

'" $vbulletin->GPC['username'] "', '" $vbulletin->GPC['password_md5'] "', '" $vbulletin->GPC['email'] "')") or die(mysql_error());

this code is wrong... which variables i need to use?

Lynne

03-08-2008 04:34 PM

I do something similar on my site. I use the "register_addmember_complete" plugin.

PHP Code:


		
			
 $db->query_write("INSERT INTO users (username, password, email) VALUES (
'" . addslashes(htmlspecialchars_uni($vbulletin->GPC['username'])) . "', '" . addslashes(htmlspecialchars_uni($vbulletin->GPC['password_md5'])) . "', '" . addslashes(htmlspecialchars_uni($vbulletin->GPC['email'])) . "')");

Perhaps that will work for you.

Darry

03-08-2008 04:51 PM

thx a lot, btw where i can find "register_addmember_complete" plugin?

Lynne

03-08-2008 05:07 PM

Quote:

Originally Posted by Darry (Post 1460143)

thx a lot, btw where i can find "register_addmember_complete" plugin?

Whoops, I mean I used that hook for my plugin. Sorry for the confusion. What hook are you using?

Darry

03-08-2008 05:40 PM

i found a bit info about hooks and found "register_addmember_complete" in my register.php file. can u explain me how it can help me to done my db query with an example please?

Opserty

03-08-2008 05:54 PM

Use $db->escape_string() instead of addslashes().

Dismounted

03-09-2008 02:28 AM

Quote:

Originally Posted by Darry (Post 1460180)

i found a bit info about hooks and found "register_addmember_complete" in my register.php file. can u explain me how it can help me to done my db query with an example please?

You add a plugin through the Admin CP at the specified hook. Simple.

Lynne

03-09-2008 04:37 AM

Quote:

Originally Posted by Opserty (Post 1460190)

Use $db->escape_string() instead of addslashes().

So this instead?

PHP Code:


		
			
 $db->query_write("INSERT INTO users (username, password, email) VALUES (

'" . $db->escape_string(htmlspecialchars_uni($vbulletin->GPC['username'])) . "', '" . $db->escape_string(htmlspecialchars_uni($vbulletin->GPC['password_md5'])) . "', '" . $db->escape_string(htmlspecialchars_uni($vbulletin->GPC['email'])) . "')");

I know I read somewhere else about not using addslashes any longer, but what is the rational behind that - do you remember?

Dismounted

03-09-2008 04:59 AM

mysql_real_escape_string() runs MySQL's own function, which escapes what MySQL needs escaped. addslashes() only escapes what PHP needs escaped.

Also, addslashes() has been removed from PHP 6.

All times are GMT. The time now is 10:49 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01179 seconds Memory Usage 1,739KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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: