private void UpdateUserForumPHP() { DataKartDataContext dk = new DataKartDataContext(); try { Usuario[] us = (from p in dk.Usuarios where p.Ativo == true select p).ToArray(); foreach (Usuario u in us) { //Verificar se exsite no forum bool exiteForum = (from f in dk.phpbb_users where f.user_email == u.Email || f.username == u.Email select f).Count() > 0; if (exiteForum == false) { //Efetuar o cadastro no Forum phpbb_user phpu = new phpbb_user() { user_type = 1, group_id = 2, user_permissions = "", user_perm_from = 0, user_ip = "", user_regdate = 1396623164, username = "", username_clean = "", user_password = EncryptMd5(u.Senha), user_passchg = 1396623164, user_pass_convert = 0, user_email = "", user_email_hash = EncryptCrc32(u.Email + u.Email.Length.ToString()), user_birthday = "", user_lastvisit = 0, user_lastmark = 1396623164, user_lastpost_time = 0, user_lastpage = "", user_last_confirm_key = "", user_last_search = 0, user_warnings = 0, user_last_warning = 0, user_login_attempts = 0, user_inactive_reason = 1, user_inactive_time = 1396623164, user_posts = 0, user_lang = "pt_br", user_timezone = -3, user_dst = 1, user_dateformat = "D M d, Y h:i", user_style = 2, user_rank = 0, user_colour = "", user_new_privmsg = 0, user_unread_privmsg = 0, user_last_privmsg = 0, user_message_rules = 0, user_full_folder = -3, user_emailtime = 0, user_topic_show_days = 0, user_topic_sortby_type = "t", user_topic_sortby_dir = "d", user_post_show_days = 0, user_post_sortby_type = "t", user_post_sortby_dir = "a", user_notify = 0, user_notify_pm = 1, user_notify_type = 0, user_allow_pm = 1, user_allow_viewonline = 1, user_allow_viewemail = 1, user_allow_massemail = 1, user_options = 230271, user_avatar = "", user_avatar_type = 0, user_avatar_width = 0, user_avatar_height = 0, 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 = Tools.UniqueKey.GetUniqueKey(8), //"8XC9FRJ9", user_newpasswd = "", user_form_salt = Tools.UniqueKey.GetUniqueKey(16, false, false), //"52567f871eccdc80", user_new = 1, user_reminded = 0, user_reminded_time = 0 }; phpu.username = u.Email; phpu.username_clean = u.Email; phpu.user_email = u.Email; phpu.user_password = EncryptMd5(u.Senha); dk.phpbb_users.InsertOnSubmit(phpu); dk.SubmitChanges(); dk.phpbb_user_groups.InsertOnSubmit(new phpbb_user_group() { user_id = phpu.user_id, group_id = 2, group_leader = 0, user_pending = 0 }); dk.SubmitChanges(); dk.phpbb_user_groups.InsertOnSubmit(new phpbb_user_group() { user_id = phpu.user_id, group_id = 7, group_leader = 0, user_pending = 0 }); dk.SubmitChanges(); } } } finally { if (dk != null) { dk.Dispose(); } } }