ATTN: all Dev. Team!!!!!

[Wistman]

WARNING This is a query NOT a fix

I am still having problems with the Register.php on my forum.

The problem appears to be when this script:

Code Select Expand

   $queryPasswdPart = crypt($member['passwrd1'],substr($member['passwrd1'],0,2));
    $memIP=$REMOTE_ADDR;
   $request = mysql_query("INSERT INTO {$db_prefix}members (memberName,realName,passwd,emailAddress,posts,personalText,avatar,dateRegistered,hideEmail,memberIP) VALUES ('$member[user]','$member[user]','$queryPasswdPart','$member[email]',0,'$txt[209]','blank.gif',$requesttime,'$hideemail','$memIP')");
is implimented, it would appear that the ID_MEMBER does not automatically increase in the members table when the above code is applied. Howevr once the new member is inserted manually into the table, all the member features work (login, profile, etc)

I was wondering if the following code might be better:

Code Select Expand

   $queryPasswdPart = crypt($member['passwrd1'],substr($member['passwrd1'],0,2));
    $memIP=$REMOTE_ADDR;
    $request = mysql_query("UPDATE {$db_prefix}members SET ID_MEMBER = ID_MEMBER + 1");
   $request = mysql_query("INSERT INTO {$db_prefix}members (memberName,realName,passwd,emailAddress,posts,personalText,avatar,dateRegistered,hideEmail,memberIP) VALUES ('$member[user]','$member[user]','$queryPasswdPart','$member[email]',0,'$txt[209]','blank.gif',$requesttime,'$hideemail','$memIP')");



[Jeff Lewis]

The field is set to auto increment, therefore it will automatically increment by one.  Also, by your suggestion you're adding an extra query when one isn't needed, you could just add that field increment in the query that already exists!

Besides, what exactly is your issue with registering?!?!

[Wistman]

The field is set to auto increment, therefore it will automatically increment by one.  Also, by your suggestion you're adding an extra query when one isn't needed, you could just add that field increment in the query that already exists!

That I did wonder about as well but I'm still learning the coding

Besides, what exactly is your issue with registering?!?!

The problem is that no registration is taking place on my board unless I do it manually. When a guest registers they are told they are sucessful but when they try to log in they are told that no id & password exist, (which is because no record has been entered for them).

Actually the code above is the only bit of Register.php that does not work

After checking the Register.php plus the members table, the only thing I can come up with is is the fact that the auto increment is not working.

[Jeff Lewis]

Send me a link to your board...I highly doubt it's NOT working

[Wistman]

<snipped>

[John R]

<snipped>

YUCK, and what type of a site is this?

[Hypocrite]

Didn't like that site a bit...

[Jeff Lewis]

Oh my....

Um, you're right though, registering doesn't work...

[Pegleg]

OMG, that's a pedophile site.....

[Greg Robson]

OMG - the pink... Nooooooooooooooooooooooooooooo!

* Greg passes out on the floor from the most overdone use of Pink.

[Mach8]

Greg, the design isn't the problem. It's the content.

I really think YaBB needs a user ignore function... I'm sorry Wistman but you're a pervert, I am totally opposed to what you do. How can you run a site that takes advantage of children? What's funny is you post it as if there is no problem with the site... you really do disgust me.

Please, can a moderator delete the link to the site at least?

[Hypocrite]

Greg, the design isn't the problem. It's the content.

I really think YaBB needs a user ignore function... I'm sorry Wistman but you're a pervert, I am totally opposed to what you do. How can you run a site that takes advantage of children? What's funny is you post it as if there is no problem with the site... you really do disgust me.

Please, can a moderator delete the link to the site at least?

I'll second that.

[Jeff Lewis]

I'll lock the thread as well...