Requiring User in Add.php

[esm]

I want those who add a listing also be signed up as a user. I have added a field called username to the idx_link table. Then during the add listing process, I want to compare the email address and the user name in the idx_users table to the information being submitted thru add.php to make sure the email address and user name will be the same. They have to be in idx_users table first but I am not requiring the user to logged in at this point. But I will probably make that requirement shortly.

In the ProcessFormAddUrl() function of add.php just before the line if(empty($error_msg)) { , I added the following:

// mod to look for user name and email
$conn = ConnectDB();
$query = "select username, email from idx_users where email = '$email'";
$result = $conn->Execute($query);
if($result) {
$u_email = $result->Fields("email");
$u_username = $result->Fields("username");
}
if($u_email != $email) $error_msg = $msg["10101a"];
if($u_username != $username) $error_msg = $msg["10101b"];

Just a few lines above that, make the folllowing change:

  // vars template
// mod for $username
  global $error_msg, $password, $link_id, $title, $url, $description, $contact_name, 
$email, $bid, $category, $add_cat1, $add_cat2, $keywords, $username ;

NOTE: the global line should be just one line. I made it two lines for the forum because I hate to scroll to the right on the screen.

Finally, in the msg.php file in the /themes/default folder, add the following after $msg["10107"] about line 467

// mod for user name
$msg["10101a"] = "Email does not match the email in the user file";
$msg["10101b"] = "Username does not match username in the user file";

[esm]

I also wanted to prevent duplicate email addresses in the user file.

Open up users.class.php and make the following changes

  function Register($username,$email,$password) {
  
    $username = strtolower($username);
// mod for requiring username / email
    $email = strtolower($email);

    // check for existing user
    
// mod for requiring username / email
//    $query = "select username from $this->table_name where username='$username'";
    $query = "select username, email from $this->table_name where username='$username' or email='$email'";

if you want to, make the following change in msg.php

$msg["10078"] = "Username or Email already exists";

[lordkinjo]

How is this working out... I have had users place a listing and then sign up for a user account...they get confused because now they have a user id #, a username and 2 different passwords... I think that if this will work it will solve a lot of future problems with login mistakes...

Let me know

Lordkinjo

[esm]

seems to be ok.

I just need to insert the username and password into the add form so that the info is automatically there.

If I figure it out, I'll post it here.

[pip]

Originally posted by esm
seems to be ok.

I just need to insert the username and password into the add form so that the info is automatically there.

If I figure it out, I'll post it here.

Have you figured it out?

[esm]

in the add_form.html, add the following at the top just after rows that deal with "Add your site"

<tr class="tbl_normal">
  <td valign=top>username<input type=hidden name=username value="<%username%>"></td>
  <td><%username%></td>
</tr>
<tr class="tbl_normal">
  <td>Email</td>
  <td><%email%><input type=hidden name=email value="<%email%>"></td>
</tr>

[pip]

What about modify.html? Do I need to replace <input name=email value="<%email%>"> with just <%email%> as well to prevent it from being changed?

[pip]

Originally posted by esm
in the add_form.html, add the following at the top just after rows that deal with "Add your site"

<tr class="tbl_normal">
  <td valign=top>username<input type=hidden name=username value="<%username%>"></td>
  <td><%username%></td>
</tr>
<tr class="tbl_normal">
  <td>Email</td>
  <td><%email%><input type=hidden name=email value="<%email%>"></td>
</tr>

With these added, I assume that I don't have to enter Email and Username in the form? Because they don't propagate in the add.html form.

[esm]

there is no add.html file

since the user is logged in, the Email and Username will display on the screen.

[pip]

add_form.html is what I was referring to.

I tried your code, I logged in but the <%username%> and <%email%> don't propagate. They just remain empty.