Looking for forum coder

Discussion in 'Programming' started by Im The ONE, Sep 14, 2008.

  1. #1
    I'm looking for someone who can alter phpbb's authentication system to use my custom script's user login table instead of phpbb one.

    In case you think you can do this with some other forum script (must be good one), you're welcome to PM me
     
    Im The ONE, Sep 14, 2008 IP
  2. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Does your auth scrupt use md5 hash ?
     
    Bohra, Sep 14, 2008 IP
  3. Im The ONE

    Im The ONE Peon

    Messages:
    800
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    the passwords in my table are one-way encrypted using sha1();
     
    Im The ONE, Sep 14, 2008 IP
  4. Im The ONE

    Im The ONE Peon

    Messages:
    800
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    Seeing the response here I decided to try it myself, Messing but phpbb's login system is hard but new user in phpbb database can be added manually.
    Here's the code I used:
    
    $forumdb = new Database("localhost", "asd", "asd", "forum");
    $forumdb->connect();
    
    		$sql = "INSERT INTO `phpbb_users` (";
    		$sql .= "`user_id`, `user_type`, `group_id`, `user_permissions`, `user_perm_from`, `user_ip`, `user_regdate`, `username`, `username_clean`, `user_password`, `user_passchg`, `user_pass_convert`, `user_email`, `user_email_hash`, `user_birthday`, `user_lastvisit`, `user_lastmark`, `user_lastpost_time`, `user_lastpage`, `user_last_confirm_key`, `user_last_search`, `user_warnings`, `user_last_warning`, `user_login_attempts`, `user_inactive_reason`, `user_inactive_time`, `user_posts`, `user_lang`, `user_timezone`, `user_dst`, `user_dateformat`, `user_style`, `user_rank`, `user_colour`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_message_rules`, `user_full_folder`, `user_emailtime`, `user_topic_show_days`, `user_topic_sortby_type`, `user_topic_sortby_dir`, `user_post_show_days`, `user_post_sortby_type`, `user_post_sortby_dir`, `user_notify`, `user_notify_pm`, `user_notify_type`, `user_allow_pm`, `user_allow_viewonline`, `user_allow_viewemail`, `user_allow_massemail`, `user_options`, `user_avatar`, `user_avatar_type`, `user_avatar_width`, `user_avatar_height`, `user_sig`, `user_sig_bbcode_uid`, `user_sig_bbcode_bitfield`, `user_from`, `user_icq`, `user_aim`, `user_yim`, `user_msnm`, `user_jabber`, `user_website`, `user_occ`, `user_interests`, `user_actkey`, `user_newpasswd`, `user_form_salt`";
    		$sql .= ")";
    		$sql .= "VALUES (";
    		$sql .= "NULL, '0', '2', '00000000006xv1ssxs\ni1cjyo000000\nqlc4pi000000\nzik0zi000000', '0', '" . $ip . "', '" . time () . "', '$username', '$username',";
    		$sql .= "'" . md5($password). "', '" . time () . "', '0', '$email',";
    		$sql .= " '0', '', '" . time () . "', '" . time () . "', '" . time () . "', '', '',";
    		$sql .= "'0', '0', '0', '0', '0', '0', '0',";
    		$sql .= "'en', '0.00', '0', 'D M d, Y g:i a', '1', '0',";
    		$sql .= "'', '0', '0', '0', '0', '-3', '0', '0', 't', 'd', '0', 't', 'a', '0', '1', '0', '1', '1', '1',";
    		$sql .= "'1', '895', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1a99da7f3160cc5c'";
    		$sql .= ")";
    		
    $forumdb->query($sql);
    
    PHP:
     
    Im The ONE, Sep 14, 2008 IP