vb.org Archive - Problem with registering / SQL

Page 1 of 2

Show 40 post(s) from this thread on one page

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

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

- - Problem with registering / SQL (https://vborg.vbsupport.ru/showthread.php?t=60853)

razorownz

01-28-2004 11:11 AM

Problem with registering / SQL

Im having this SQL problem when people are registering at my board.

http://www.vbulletin.com/forum/showt...ewpost&t=93643

g-force2k2

01-28-2004 11:16 AM

razorownz,

Open register.php and make sure that you did not code block the line:

PHP Code:


		
			
$userid=$DB_site->insert_id();

If that doesn't work try uploading an unhacked version register.php, because it's not using the $userid variable in the sql.

Cheers,
g-force2k2

razorownz

01-28-2004 11:34 AM

I cant even find that string, will it help if I let you see the register.php file ? Do you have msn / aol or icq ?

razorownz

01-28-2004 12:18 PM

Anyone else have any ideas ?

g-force2k2

01-28-2004 12:46 PM

Try finding this string, wasn't sure how vb3 formatted it in register.php

PHP Code:


		
			
        $userid = $DB_site->insert_id();

Regards,
g-force2k2

razorownz

01-28-2004 12:53 PM

i found this but i suppose its not right

$DB_site->query("UPDATE session SET userid=$userid WHERE sessionhash='".addslashes($session['dbsessionhash'])."'");

g-force2k2

01-28-2004 01:10 PM

Quote:

Originally Posted by razorownz

i found this but i suppose its not right

$DB_site->query("UPDATE session SET userid=$userid WHERE sessionhash='".addslashes($session['dbsessionhash'])."'");

Nope in the register.php you need the one line of code that I posted above. If you don't then thats why you're getting the errors that you are. You have to then edit the register.php or just upload an unhacked version. I'm not sure of what you editted in your register.php or if you even edited at all.

Regards,
g-force2k2

razorownz

01-28-2004 01:11 PM

ive just edited it with 1 hack, but where should that code be ? can i send u the file ?

g-force2k2

01-28-2004 01:15 PM

Open register.php

Find:

PHP Code:


		
			
        // Insert user text fields

Above It Add:

PHP Code:


		
			
        $userid = $DB_site->insert_id();

That should perhaps fix your problem.

Cheers,
g-force2k2

razorownz

01-28-2004 01:18 PM

i only found this:

// insert custom user fields

its vB 2.3.4

All times are GMT. The time now is 05:51 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01070 seconds Memory Usage 1,737KB 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 (4)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (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: