FUDforum: How To » which files/files

Home » FUDforum » How To » which files/files

Show: Today's Messages :: Polls :: Message Navigator

which files/files [message #11691]

Mon, 14 July 2003 02:16

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma: 0

Senior Member

which files/fields would be involved if I wanted to import some new users from an outside source?

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

Report message to a moderator

Re: which files/files [message #11692 is a reply to message #11691]

Mon, 14 July 2003 02:23

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

users_reg.inc.t and possibly register.php.t. The latter mostly to see how the functions & methods inside users_reg.inc.t work.

FUDforum Core Developer

Report message to a moderator

Re: which files/files [message #11748 is a reply to message #11691]

Wed, 16 July 2003 14:13

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma: 0

Senior Member

if I want to create a user in the user table ( fud25_users ) without using Fudforum, what are the absolute minimum required fields to populate? Some of the field data is obvious - name, email, password. But what about the data of some of the other "required" fields?

And the password. Does it use the md5 thing???

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

Report message to a moderator

Re: which files/files [message #11754 is a reply to message #11748]

Wed, 16 July 2003 14:54

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Take a look at fud_users.sql table defenition file, all of the fields that are indexed (or unique, especially unique) need to have their values filled in.

Oh yeah, the password is the md5 hash of the actual password, the actual password is not stored in db for security reasons.

FUDforum Core Developer

[Updated on: Wed, 16 July 2003 14:55]

Report message to a moderator

Re: which files/files [message #11757 is a reply to message #11754]

Wed, 16 July 2003 17:09

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma: 0

Senior Member

thnks for the info.

so if I did an INSERT using the following values, that would be enough to get it created for the user who could later update the info??

Key name        Unique  Field           Value
PRIMARY         YES
login           YES     login           LoginName
email           YES     email           myemail(at)yahoo(dot)com
alias           YES     alias           LoginName
reset_key       NO      reset_key       0
last_visit      NO      last_visit      0
conf_key        NO      conf_key        0
referer_id      NO      referer_id      0
avatar_approved NO      avatar_approved No
acc_status      NO      acc_status      A

                NO      passwd          md5(actual_password)

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

Report message to a moderator

Re: which files/files [message #11760 is a reply to message #11757]

Wed, 16 July 2003 17:25

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Looks correct, except that 'No' should've been 'NO'.

FUDforum Core Developer

Report message to a moderator

Re: which files/files [message #11761 is a reply to message #11760]

Wed, 16 July 2003 17:31

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma: 0

Senior Member

yes, you are correct. Sharp eye...!

Now, they will automatically be added when they register for another piece of software I have.

But I want to manually approve them before they can use the forum. Kinda like when they would normally register with FUDforum and then have to respond to an email before they can actually use the forum. Kinda like registered but not approved to use the forum.

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

Report message to a moderator

Re: which files/files [message #11762 is a reply to message #11761]

Wed, 16 July 2003 17:43

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Well, FUDforum already has this functionality, simply set the acc_status field to 'P' instead of 'A'. And then any new accounts will need to be approved by the administrator before they become active. When logged in as an admin you'll have an indicator saying that you have X many accounts pending confirmation if there are any such accounts.

FUDforum Core Developer

Report message to a moderator

Re: which files/files [message #11764 is a reply to message #11762]

Wed, 16 July 2003 17:55

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma: 0

Senior Member

thanks. that will work...I thought it was probably that field!

yes, I know FUDforum has this functionality and it works as intended. However, what I am doing is using a hopping cart to get a paid subscription. To use the shopping cart, the user needs to register. It is during that registrarion process that during the adding the user to the shopping cart software, that I will add the user to Fudforum.

Hadn't decided which way to go.

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

Report message to a moderator

Re: which files/files [message #11793 is a reply to message #11762]

Thu, 17 July 2003 16:52

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma: 0

Senior Member

prottoss wrote on Wed, 16 July 2003 13:43

what about the following:

  $date02 = time();
  $q  = "INSERT INTO fud25_users SET
    login            = '$f[account_username]',
    alias            = '$f[account_username]',
    passwd           = 'md5($f[account_password])',
    name             = '$f[account_name]'
    email            = '$f[account_email]',
    displayemail     = 'Y',
    notify           = 'N',
    notify_method    = 'EMAIL',
    ignore_admin     = 'N',
    email_messages   = 'Y',
    pm_messages      = 'Y',
    avatar           = '0',
    avatar_location  = 'YES',
    avatar_approved  = 'NO',
    gender           = 'UNSPECIFIED',
    icq              = 'YES',
    aim              = 'YES',
    yahoo            = 'YES',
    msnm             = 'YES',
    jabber           = 'YES',
    affero           = 'YES',
    append_sig       = 'Y',
    show_sigs        = 'Y',
    show_avatars     = 'Y',
    post_ppg         = '0',
    time_zone        = 'America/New_York',
    bday             = '0',
    invisible_mode   = 'N',
    blocked          = 'N',
    email_conf       = 'N',
    conf_key         = '0',
    user_image       = 'YES',
    theme            = '0',
    coppa            = 'Y',
    posted_msg_count = '0',
    last_visit       = '0',
    referer_id       = '0',
    last_read        = '0',
    custom_status    = 'YES',
    sig              = 'YES',
    default_view     = 'tree',
    joindate         = '$date02',
    acc_status       = 'P',
    is_mod           = 'N',
    level_id         = '0',
    reset_key        = '0',
    u_last_post_id   = '0',
    home_page        = 'YES',
    bio              = 'YES',
    cat_collapse_status = 'YES',
    custom_color     = 'YES',
    buddy_list       = 'YES',
    ignore_list      = 'YES',
    group_leader_list = 'YES'";
  $db->query($q);

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

Report message to a moderator