Problem with registering / SQL

[razorownz]

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

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

[g-force2k2]

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]

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]

Anyone else have any ideas ?

[g-force2k2]

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]

i found this but i suppose its not right

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

[g-force2k2]

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]

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

[g-force2k2]

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]

i only found this:

// insert custom user fields

its vB 2.3.4