Martin A. Posted November 14, 2010 Share Posted November 14, 2010 Just click the button "Continue regardless?" :) the error means you already have the database columns required for this application. Possibly from a 2.3 installation. Link to comment Share on other sites More sharing options...
Elanor Posted November 14, 2010 Share Posted November 14, 2010 These columns are not deleted after deleting a previous version? I would have thought so...didn't check before installing the new version though. I'll continue then regardless of the dbase errors. If new errors occur I will report them here. Thanks for the respons Elanor Link to comment Share on other sites More sharing options...
Martin A. Posted November 14, 2010 Share Posted November 14, 2010 Tables and columns are only dropped from the database if you allow it to during uninstallation. Link to comment Share on other sites More sharing options...
Elanor Posted November 20, 2010 Share Posted November 20, 2010 I've installed MIM1.1.6 now I've chosen 0 for the setting Time Between notifications. According to this setting, notification will be sent just once. Members however, complain that they receive this notification every night, when the schedule runs. Since that can be annoying I think this rather pushes people away than convince them to come and visit my board again. When I look at the logs, it send out max 500 mails every night. I can view the number of mails that were sent, but I cannot check how many times the same addresses are sent. MIM runs on my board for 6 days now, and I've only activated the notification for inactivity. I haven't started moving and deleting them at this point and I'm reluctant to do so, without having solved the above. Could you advice? Thanks Elanor Link to comment Share on other sites More sharing options...
Martin A. Posted November 20, 2010 Share Posted November 20, 2010 Can you run that task in debug mode once, and show me the SQL query it generates? Link to comment Share on other sites More sharing options...
Elanor Posted November 21, 2010 Share Posted November 21, 2010 Query: SELECT * FROM ibf_members WHERE last_activity <= 1261839657 AND member_group_id IN (3,14) LIMIT 0,250 Member info says: [inactive_notified] => 1 [inactive_lastNotified] => 1290214822 [inactive_oldGroup] => 0 [inactive_moved] => 0 and a few lines below that: [inactive_last_notified_formated] => Never Curious to what the issue is here. Thanks for looking into this. Elanor Link to comment Share on other sites More sharing options...
Martin A. Posted November 22, 2010 Share Posted November 22, 2010 Query: SELECT * FROM ibf_members WHERE last_activity <= 1261839657 AND member_group_id IN (3,14) LIMIT 0,250 Member info says: [inactive_notified] => 1 [inactive_lastNotified] => 1290214822 [inactive_oldGroup] => 0 [inactive_moved] => 0 and a few lines below that: [inactive_last_notified_formated] => Never Curious to what the issue is here. Thanks for looking into this. Elanor That, and several other things have been fixed in :) Link to comment Share on other sites More sharing options...
AlexJ Posted November 24, 2010 Share Posted November 24, 2010 Re installing again! Thanks m4rtin! Link to comment Share on other sites More sharing options...
Jimbotron Posted November 27, 2010 Share Posted November 27, 2010 I need some help with this app since I cannot figure out how to get it to do what I want. The first problem, which showed up after upgrading to 1.1.7 is this: After installing the update, I have fields showing up twice for no reason under Move Inactive Members settings. The important problem is that it is not moving only whom I specify. I tried setting it up so that it would move members who are in the Newcomers group to Inactive Members if they had zero post and if they had not logged in for 365 days. Instead, it just moves people who have not logged in for a year, and ignores the fact that they have posted. That's not so bad, since moving inactive members to an inactive group is fine, regardless of whether they have posted or not. The problem really comes when I choose to delete inactive members. I have triied totoset it up to delete members in the Inactive Members Group who have zero post and have not logged in for a year. Again, it ignores that they have posted and deletes members based on their inactivity. It does this whether I tell it to base it's action on Last Activity or Last Post, and have "Number of posts to get deleted?" set to zero ("Delete after how many days of inactivity?" is set to 365). Why is it doing this, and how do I get it to delete ONLY members who have been away for 365 days and have not had one post in the forums? Link to comment Share on other sites More sharing options...
()Achilles() Posted November 27, 2010 Share Posted November 27, 2010 I just have one question, WHAT IF, a member starts becoming ACTIVE again after you move them to the inactive group? Would that be automatic or (?). :) Link to comment Share on other sites More sharing options...
Martin A. Posted November 27, 2010 Share Posted November 27, 2010 I need some help with this app since I cannot figure out how to get it to do what I want. The first problem, which showed up after upgrading to 1.1.7 is this: [IMG] [/IMG] After installing the update, I have fields showing up twice for no reason under Move Inactive Members settings. The important problem is that it is not moving only whom I specify. I tried setting it up so that it would move members who are in the Newcomers group to Inactive Members if they had zero post and if they had not logged in for 365 days. Instead, it just moves people who have not logged in for a year, and ignores the fact that they have posted. That's not so bad, since moving inactive members to an inactive group is fine, regardless of whether they have posted or not. The problem really comes when I choose to delete inactive members. I have triied totoset it up to delete members in the Inactive Members Group who have zero post and have not logged in for a year. Again, it ignores that they have posted and deletes members based on their inactivity. It does this whether I tell it to base it's action on Last Activity or Last Post, and have "Number of posts to get deleted?" set to zero ("Delete after how many days of inactivity?" is set to 365). Why is it doing this, and how do I get it to delete ONLY members who have been away for 365 days and have not had one post in the forums? The reason you have duplicate settings is that IPS for some unknown reason disallowed the use of hyphens (-) in settings keys from v3.1.3, meaning I had to change the key for all settings I edited for this version. I'm building a new version right now that should take care of that. Just want to check out your other issues before I release it. For both of these, can you run the tasks in debug mode, and post the SQL query that you get? I just have one question, WHAT IF, a member starts becoming ACTIVE again after you move them to the inactive group? Would that be automatic or (?). :) Yes. This is either done the moment the member returns, or when making a post. Link to comment Share on other sites More sharing options...
()Achilles() Posted November 27, 2010 Share Posted November 27, 2010 Yes. This is either done the moment the member returns, or when making a post. Great, so I don't have to configure anything. They'll be automatically be transferred back to the original group, 'members', when they become active again, that's pretty great! Great great Mod. :] EDIT: Pardon me if I didn't read the MOD's instructions first before asking. :) I just noticed the note about being moved back when I'm installing. /no1. Link to comment Share on other sites More sharing options...
Jimbotron Posted November 27, 2010 Share Posted November 27, 2010 Here we go. Move Inactive Members:Query: SELECT * FROM ibf_members WHERE ( last_post <= 1275315626 OR last_post IS NULL) AND joined <= 1288275626 AND member_group_id IN (3) LIMIT 0,250 Found 2 inactive users Array ( [10974] => Array ( [member_id] => 10974 [name] => gh0sst [member_group_id] => 3 [email] => sorinciortan@gmail.com [joined] => 1288243531 [ip_address] => 81.181.70.10 [posts] => 0 [title] => [allow_admin_mails] => 1 [time_offset] => -5 [hide_email] => 1 [email_pm] => 0 [email_full] => [skin] => [warn_level] => [warn_lastwarn] => 0 [language] => 1 [last_post] => [restrict_post] => 0 [view_sigs] => 1 [view_img] => 1 [view_avs] => 1 [view_pop] => 1 [bday_day] => 0 [bday_month] => 0 [bday_year] => 0 [msg_count_new] => 0 [msg_count_total] => 0 [msg_count_reset] => 0 [msg_show_notification] => 1 [misc] => [last_visit] => 1288243531 [last_activity] => 1288243558 [dst_in_use] => 0 [view_prefs] => -1&-1 [coppa_user] => 0 [mod_posts] => 0 [auto_track] => 0 [temp_ban] => 0 [sub_end] => 0 [login_anonymous] => 0&1 [ignored_users] => a:0:{} [mgroup_others] => [org_perm_id] => [member_login_key] => 0273f7f6080c50acc2ac0b71b082750e [member_login_key_expire] => 1288848331 [subs_pkg_chosen] => 0 [has_blog] => [members_editor_choice] => std [members_auto_dst] => 0 [members_display_name] => gh0sst [members_seo_name] => gh0sst [members_created_remote] => 0 [members_cache] => [members_disable_pm] => 0 [hp] => 30 [maxhp] => 30 [str] => 30 [maxstr] => 30 [exp] => 0 [next_lvl] => 30 [level] => 1 [frags] => 0 [attack_ban] => 0 [money] => 0 [inventory] => [gu_affil] => 0 [gu_rank] => 0 [gu_title] => [arcade_ban] => 0 [times_played] => 0 [is_arcade_mod] => 0 [fav_games] => [user_sort] => 0 [user_order] => 0 [user_g_pp] => 0 [user_s_pp] => 0 [def_g_cat] => 0 [game_skin] => 0 [arcade_mod_privs] => [m_ds_total_transfer] => [m_ds_posts_lastday] => [moneyupdate] => 0 [use_dshoutbox] => 1 [dshoutbox_mod] => 0 [dshout_limit] => 0 [dshouts_today] => [dshouts_alltime] => 0 [dshout_saveload] => 1 [dshout_bwbypass] => 0 [dshout_editown] => 1 [dshout_deleteown] => 0 [last_shout_time] => 0 [sb_showavatars] => D [sb_showshouttime] => D [sb_defaultcolor] => D [sb_refresh] => D [sb_showsmiliest] => D [sb_showtdshouters] => D [sb_showtpshouters] => D [sb_shoutboxtype] => D [sb_topic_id] => 0 [weather_code] => [weather_mode] => list [members_profile_views] => 11 [members_l_display_name] => gh0sst [members_l_username] => gh0sst [failed_logins] => [failed_login_count] => 0 [has_gallery] => 0 [user_u_columns] => 1 [arcade_sngsess] => 0 [arcade_sngact] => 0 [arcade_columnsol] => 0 [arcade_sng_wins] => 0 [arcade_postcount] => 0 [user_arcade_ng] => 0 [user_arcade_pg] => 0 [user_arcade_rg] => 0 [user_arcade_nwch] => 0 [user_arcade_ltsc] => 0 [jackpots_won] => 0 [jackpots_points] => 0 [arcade_won] => 0 [arcade_activity] => 0 [arcade_activitywon] => 0 [arcade_spent] => 0 [arcade_downloads] => 0 [arcade_colamount] => 0 [user_r_pp] => 0 [arcade_gtype] => 0 [arcade_sess_gid] => 1 [arcade_sess_start] => 0 [arcade_b_challenges] => [arcade_usepm] => 0 [arcade_challenge_banned] => 0 [arcade_challengeid] => 0 [arcade_challenge] => 0 [arcade_u_cha] => 2 [arcade_session] => 0 [arcade_time_spent] => 0 [suicides] => 0 [attack_quit] => 0 [attack_pm] => 0 [attack_expire] => absolute [attacker] => 0 [attacked] => 0 [attacker_success] => 0 [attacked_success] => 0 [clone_protect] => 1 [atk_kills] => 0 [atk_deaths] => 0 [banksm_deposit] => 100 [banksm_points] => 100 [banksm_day_deposit] => 0 [banksm_day_withdraw] => 0 [bank_banned] => 0 [bank_using_bank] => 0 [bank_last_deposit] => 0 [bank_last_withdraw] => 0 [ibspeak_isbanned] => 0 [icon_ol] => 0 [gow_score] => 0 [gow_date] => 0 [arcade_points] => 100 [gname] => [gow_wins] => 0 [gow_points] => 0 [msg_msg_id] => 0 [msg_from_id] => 0 [can_create_tourney] => 1 [arcade_sess_gow] => 0 [arcade_lastplay] => 0 [arcade_highscores] => 0 [arcade_twon] => 0 [arcade_chwon] => 0 [user_columns_nocollapse] => 0 [arcade_skin] => 1 [arcade_posts] => 0 [converted_points] => 0 [arcade_pass] => 0 [arcade_pass_time] => 0 [arcade_pass_type] => 0 [arcade_pass_percent] => 100 [casino_ban] => 0 [c_times_played] => 0 [casinototal] => 0 [p_closes] => 0 [p_cwins] => 0 [game_check] => 0 [moneystarted] => 0 [cwallet] => 20 [casino_sess_gid] => 0 [casino_sess_start] => 0 [casino_session] => 0 [sb_ignored] => [members_pass_hash] => 0eb7ad8b15b3587635b7dbca403bfcc4 [members_pass_salt] => h72H4 [member_banned] => 0 [identity_url] => [member_uploader] => default [members_bitoptions] => 0 [fb_uid] => 0 [fb_emailhash] => [fb_lastsync] => 0 [members_day_posts] => 0,0 [live_id] => [gallery_perms] => 1:1:1 [links] => 0 [l_links_pp] => 0 [l_comments_pp] => 0 [l_watch_submit] => [l_watch_reply] => [l_noti_type] => [inactive_notified] => 0 [inactive_lastNotified] => 0 [inactive_oldGroup] => 0 [inactive_moved] => 0 [chat_banned] => 0 [twitter_id] => [twitter_token] => [twitter_secret] => [notification_cnt] => 0 [tc_lastsync] => 0 [fb_session] => [fb_token] => [ips_mobile_token] => [ban_reason] => [new_group] => 42 ) [10975] => Array ( [member_id] => 10975 [name] => cybertron [member_group_id] => 3 [email] => umer_saghir@hotmail.com [joined] => 1288247688 [ip_address] => 195.229.235.43 [posts] => 0 [title] => [allow_admin_mails] => 1 [time_offset] => -5 [hide_email] => 1 [email_pm] => 0 [email_full] => [skin] => [warn_level] => [warn_lastwarn] => 0 [language] => 1 [last_post] => [restrict_post] => 0 [view_sigs] => 1 [view_img] => 1 [view_avs] => 1 [view_pop] => 1 [bday_day] => 0 [bday_month] => 0 [bday_year] => 0 [msg_count_new] => 0 [msg_count_total] => 0 [msg_count_reset] => 0 [msg_show_notification] => 1 [misc] => [last_visit] => 1288247688 [last_activity] => 1288248542 [dst_in_use] => 0 [view_prefs] => -1&-1 [coppa_user] => 0 [mod_posts] => 0 [auto_track] => 0 [temp_ban] => 0 [sub_end] => 0 [login_anonymous] => 0&1 [ignored_users] => a:0:{} [mgroup_others] => [org_perm_id] => [member_login_key] => 818fc7ee30e0976a0e0ac4120e3d286f [member_login_key_expire] => 1288853357 [subs_pkg_chosen] => 0 [has_blog] => [members_editor_choice] => std [members_auto_dst] => 0 [members_display_name] => cybertron [members_seo_name] => cybertron [members_created_remote] => 0 [members_cache] => [members_disable_pm] => 0 [hp] => 30 [maxhp] => 30 [str] => 30 [maxstr] => 30 [exp] => 0 [next_lvl] => 30 [level] => 1 [frags] => 0 [attack_ban] => 0 [money] => 0 [inventory] => [gu_affil] => 0 [gu_rank] => 0 [gu_title] => [arcade_ban] => 0 [times_played] => 0 [is_arcade_mod] => 0 [fav_games] => [user_sort] => 0 [user_order] => 0 [user_g_pp] => 0 [user_s_pp] => 0 [def_g_cat] => 0 [game_skin] => 0 [arcade_mod_privs] => [m_ds_total_transfer] => [m_ds_posts_lastday] => [moneyupdate] => 0 [use_dshoutbox] => 1 [dshoutbox_mod] => 0 [dshout_limit] => 0 [dshouts_today] => [dshouts_alltime] => 0 [dshout_saveload] => 1 [dshout_bwbypass] => 0 [dshout_editown] => 1 [dshout_deleteown] => 0 [last_shout_time] => 0 [sb_showavatars] => D [sb_showshouttime] => D [sb_defaultcolor] => D [sb_refresh] => D [sb_showsmiliest] => D [sb_showtdshouters] => D [sb_showtpshouters] => D [sb_shoutboxtype] => D [sb_topic_id] => 0 [weather_code] => [weather_mode] => list [members_profile_views] => 10 [members_l_display_name] => cybertron [members_l_username] => cybertron [failed_logins] => [failed_login_count] => 0 [has_gallery] => 0 [user_u_columns] => 1 [arcade_sngsess] => 0 [arcade_sngact] => 0 [arcade_columnsol] => 0 [arcade_sng_wins] => 0 [arcade_postcount] => 0 [user_arcade_ng] => 0 [user_arcade_pg] => 0 [user_arcade_rg] => 0 [user_arcade_nwch] => 0 [user_arcade_ltsc] => 0 [jackpots_won] => 0 [jackpots_points] => 0 [arcade_won] => 0 [arcade_activity] => 0 [arcade_activitywon] => 0 [arcade_spent] => 0 [arcade_downloads] => 0 [arcade_colamount] => 0 [user_r_pp] => 0 [arcade_gtype] => 0 [arcade_sess_gid] => 1 [arcade_sess_start] => 0 [arcade_b_challenges] => [arcade_usepm] => 0 [arcade_challenge_banned] => 0 [arcade_challengeid] => 0 [arcade_challenge] => 0 [arcade_u_cha] => 2 [arcade_session] => 0 [arcade_time_spent] => 0 [suicides] => 0 [attack_quit] => 0 [attack_pm] => 0 [attack_expire] => absolute [attacker] => 0 [attacked] => 0 [attacker_success] => 0 [attacked_success] => 0 [clone_protect] => 1 [atk_kills] => 0 [atk_deaths] => 0 [banksm_deposit] => 100 [banksm_points] => 100 [banksm_day_deposit] => 0 [banksm_day_withdraw] => 0 [bank_banned] => 0 [bank_using_bank] => 0 [bank_last_deposit] => 0 [bank_last_withdraw] => 0 [ibspeak_isbanned] => 0 [icon_ol] => 0 [gow_score] => 0 [gow_date] => 0 [arcade_points] => 100 [gname] => [gow_wins] => 0 [gow_points] => 0 [msg_msg_id] => 0 [msg_from_id] => 0 [can_create_tourney] => 1 [arcade_sess_gow] => 0 [arcade_lastplay] => 0 [arcade_highscores] => 0 [arcade_twon] => 0 [arcade_chwon] => 0 [user_columns_nocollapse] => 0 [arcade_skin] => 1 [arcade_posts] => 0 [converted_points] => 0 [arcade_pass] => 0 [arcade_pass_time] => 0 [arcade_pass_type] => 0 [arcade_pass_percent] => 100 [casino_ban] => 0 [c_times_played] => 0 [casinototal] => 0 [p_closes] => 0 [p_cwins] => 0 [game_check] => 0 [moneystarted] => 0 [cwallet] => 20 [casino_sess_gid] => 0 [casino_sess_start] => 0 [casino_session] => 0 [sb_ignored] => [members_pass_hash] => 86aefdfda72d890d4fb11714dde973c2 [members_pass_salt] => +#VZa [member_banned] => 0 [identity_url] => [member_uploader] => default [members_bitoptions] => 0 [fb_uid] => 0 [fb_emailhash] => [fb_lastsync] => 0 [members_day_posts] => 0,0 [live_id] => [gallery_perms] => 1:1:1 [links] => 0 [l_links_pp] => 0 [l_comments_pp] => 0 [l_watch_submit] => [l_watch_reply] => [l_noti_type] => [inactive_notified] => 0 [inactive_lastNotified] => 0 [inactive_oldGroup] => 0 [inactive_moved] => 0 [chat_banned] => 0 [twitter_id] => [twitter_token] => [twitter_secret] => [notification_cnt] => 0 [tc_lastsync] => 0 [fb_session] => [fb_token] => [ips_mobile_token] => [ban_reason] => [new_group] => 42 ) ) Delete Inactive Members: Query: SELECT * FROM ibf_members WHERE posts <= 0 AND ( last_post <= 1259331884 OR last_post IS NULL ) AND joined <= 1288275884 AND member_group_id IN (42) LIMIT 0,2 Found 2 inactive users Array ( [10452] => Array ( [member_id] => 10452 [name] => jds5799 [member_group_id] => Inactive Members(ID: 42] [email] => jonas.d.stewart@gmail.com [joined] => 15 May 2010 - 08:45 AM [ip_address] => 58.146.52.3 [posts] => 0 [title] => [allow_admin_mails] => 1 [time_offset] => 9 [hide_email] => 1 [email_pm] => 1 [email_full] => [skin] => [warn_level] => [warn_lastwarn] => 0 [language] => 1 [last_post] => -- [restrict_post] => 0 [view_sigs] => 1 [view_img] => 1 [view_avs] => 1 [view_pop] => 1 [bday_day] => [bday_month] => [bday_year] => [msg_count_new] => 0 [msg_count_total] => 0 [msg_count_reset] => 0 [msg_show_notification] => 0 [misc] => [last_visit] => 1273931132 [last_activity] => 15 May 2010 - 08:46 AM [dst_in_use] => 0 [view_prefs] => -1&-1 [coppa_user] => 0 [mod_posts] => 0 [auto_track] => immediate [temp_ban] => 0 [sub_end] => 0 [login_anonymous] => 0&1 [ignored_users] => a:0:{} [mgroup_others] => [org_perm_id] => [member_login_key] => 42368526b16c4ac8bfe0edc8532dfc98 [member_login_key_expire] => 1274535932 [subs_pkg_chosen] => 0 [has_blog] => [members_editor_choice] => std [members_auto_dst] => 0 [members_display_name] => Chumka [members_seo_name] => chumka [members_created_remote] => 0 [members_cache] => [members_disable_pm] => 0 [hp] => 30 [maxhp] => 30 [str] => 30 [maxstr] => 30 [exp] => 0 [next_lvl] => 30 [level] => 1 [frags] => 0 [attack_ban] => 0 [money] => 0 [inventory] => [gu_affil] => 0 [gu_rank] => 0 [gu_title] => [arcade_ban] => 0 [times_played] => 0 [is_arcade_mod] => 0 [fav_games] => [user_sort] => 0 [user_order] => 0 [user_g_pp] => 0 [user_s_pp] => 0 [def_g_cat] => 0 [game_skin] => 0 [arcade_mod_privs] => [m_ds_total_transfer] => [m_ds_posts_lastday] => [moneyupdate] => 0 [use_dshoutbox] => 1 [dshoutbox_mod] => 0 [dshout_limit] => 0 [dshouts_today] => [dshouts_alltime] => 0 [dshout_saveload] => 1 [dshout_bwbypass] => 0 [dshout_editown] => 1 [dshout_deleteown] => 0 [last_shout_time] => 0 [sb_showavatars] => D [sb_showshouttime] => D [sb_defaultcolor] => D [sb_refresh] => D [sb_showsmiliest] => D [sb_showtdshouters] => D [sb_showtpshouters] => D [sb_shoutboxtype] => D [sb_topic_id] => 0 [weather_code] => [weather_mode] => list [members_profile_views] => 42 [members_l_display_name] => chumka [members_l_username] => jds5799 [failed_logins] => [failed_login_count] => 0 [has_gallery] => 0 [user_u_columns] => 1 [arcade_sngsess] => 0 [arcade_sngact] => 0 [arcade_columnsol] => 0 [arcade_sng_wins] => 0 [arcade_postcount] => 0 [user_arcade_ng] => 0 [user_arcade_pg] => 0 [user_arcade_rg] => 0 [user_arcade_nwch] => 0 [user_arcade_ltsc] => 0 [jackpots_won] => 0 [jackpots_points] => 0 [arcade_won] => 0 [arcade_activity] => 0 [arcade_activitywon] => 0 [arcade_spent] => 0 [arcade_downloads] => 0 [arcade_colamount] => 0 [user_r_pp] => 0 [arcade_gtype] => 0 [arcade_sess_gid] => 1 [arcade_sess_start] => 0 [arcade_b_challenges] => [arcade_usepm] => 0 [arcade_challenge_banned] => 0 [arcade_challengeid] => 0 [arcade_challenge] => 0 [arcade_u_cha] => 2 [arcade_session] => 0 [arcade_time_spent] => 0 [suicides] => 0 [attack_quit] => 0 [attack_pm] => 0 [attack_expire] => absolute [attacker] => 0 [attacked] => 0 [attacker_success] => 0 [attacked_success] => 0 [clone_protect] => 1 [atk_kills] => 0 [atk_deaths] => 0 [banksm_deposit] => 100 [banksm_points] => 100 [banksm_day_deposit] => 0 [banksm_day_withdraw] => 0 [bank_banned] => 0 [bank_using_bank] => 0 [bank_last_deposit] => 0 [bank_last_withdraw] => 0 [ibspeak_isbanned] => 0 [icon_ol] => 0 [gow_score] => 0 [gow_date] => 0 [arcade_points] => 100 [gname] => [gow_wins] => 0 [gow_points] => 0 [msg_msg_id] => 0 [msg_from_id] => 0 [can_create_tourney] => 1 [arcade_sess_gow] => 0 [arcade_lastplay] => 0 [arcade_highscores] => 0 [arcade_twon] => 0 [arcade_chwon] => 0 [user_columns_nocollapse] => 0 [arcade_skin] => 1 [arcade_posts] => 0 [converted_points] => 0 [arcade_pass] => 0 [arcade_pass_time] => 0 [arcade_pass_type] => 0 [arcade_pass_percent] => 100 [casino_ban] => 0 [c_times_played] => 0 [casinototal] => 0 [p_closes] => 0 [p_cwins] => 0 [game_check] => 0 [moneystarted] => 0 [cwallet] => 20 [casino_sess_gid] => 0 [casino_sess_start] => 0 [casino_session] => 0 [sb_ignored] => [members_pass_hash] => 899d346660c73cb9e67360c8fb47c153 [members_pass_salt] => |:vJQ [member_banned] => 0 [identity_url] => [member_uploader] => default [members_bitoptions] => 0 [fb_uid] => 0 [fb_emailhash] => [fb_lastsync] => 0 [members_day_posts] => 0,0 [live_id] => [gallery_perms] => 1:1:1 [links] => 0 [l_links_pp] => 0 [l_comments_pp] => 0 [l_watch_submit] => [l_watch_reply] => [l_noti_type] => [inactive_notified] => 0 [inactive_lastNotified] => 0 [inactive_oldGroup] => 3 [inactive_moved] => 1290831402 [chat_banned] => 0 [twitter_id] => [twitter_token] => [twitter_secret] => [notification_cnt] => 0 [tc_lastsync] => 0 [fb_session] => [fb_token] => [ips_mobile_token] => [ban_reason] => ) [10409] => Array ( [member_id] => 10409 [name] => hmg7900 [member_group_id] => Inactive Members(ID: 42] [email] => hmg7900@yahoo.com [joined] => 25 April 2010 - 10:22 PM [ip_address] => 99.160.3.116 [posts] => 0 [title] => [allow_admin_mails] => 1 [time_offset] => -6 [hide_email] => 1 [email_pm] => 1 [email_full] => [skin] => [warn_level] => [warn_lastwarn] => 0 [language] => 1 [last_post] => -- [restrict_post] => 0 [view_sigs] => 1 [view_img] => 1 [view_avs] => 1 [view_pop] => 1 [bday_day] => [bday_month] => [bday_year] => [msg_count_new] => 0 [msg_count_total] => 0 [msg_count_reset] => 0 [msg_show_notification] => 0 [misc] => [last_visit] => 1272257973 [last_activity] => 26 April 2010 - 11:08 AM [dst_in_use] => 0 [view_prefs] => -1&-1 [coppa_user] => 0 [mod_posts] => 0 [auto_track] => immediate [temp_ban] => 0 [sub_end] => 0 [login_anonymous] => 0&1 [ignored_users] => a:0:{} [mgroup_others] => [org_perm_id] => [member_login_key] => 4ab17737d9443053083e845210a390ff [member_login_key_expire] => 1272859197 [subs_pkg_chosen] => 0 [has_blog] => [members_editor_choice] => std [members_auto_dst] => 0 [members_display_name] => hmg7900 [members_seo_name] => hmg7900 [members_created_remote] => 0 [members_cache] => [members_disable_pm] => 0 [hp] => 30 [maxhp] => 30 [str] => 30 [maxstr] => 30 [exp] => 0 [next_lvl] => 30 [level] => 1 [frags] => 0 [attack_ban] => 0 [money] => 0 [inventory] => [gu_affil] => 0 [gu_rank] => 0 [gu_title] => [arcade_ban] => 0 [times_played] => 0 [is_arcade_mod] => 0 [fav_games] => [user_sort] => 0 [user_order] => 0 [user_g_pp] => 0 [user_s_pp] => 0 [def_g_cat] => 0 [game_skin] => 0 [arcade_mod_privs] => [m_ds_total_transfer] => [m_ds_posts_lastday] => [moneyupdate] => 0 [use_dshoutbox] => 1 [dshoutbox_mod] => 0 [dshout_limit] => 0 [dshouts_today] => [dshouts_alltime] => 0 [dshout_saveload] => 1 [dshout_bwbypass] => 0 [dshout_editown] => 1 [dshout_deleteown] => 0 [last_shout_time] => 0 [sb_showavatars] => D [sb_showshouttime] => D [sb_defaultcolor] => D [sb_refresh] => D [sb_showsmiliest] => D [sb_showtdshouters] => D [sb_showtpshouters] => D [sb_shoutboxtype] => D [sb_topic_id] => 0 [weather_code] => [weather_mode] => list [members_profile_views] => 51 [members_l_display_name] => hmg7900 [members_l_username] => hmg7900 [failed_logins] => [failed_login_count] => 0 [has_gallery] => 0 [user_u_columns] => 1 [arcade_sngsess] => 0 [arcade_sngact] => 0 [arcade_columnsol] => 0 [arcade_sng_wins] => 0 [arcade_postcount] => 0 [user_arcade_ng] => 0 [user_arcade_pg] => 0 [user_arcade_rg] => 0 [user_arcade_nwch] => 0 [user_arcade_ltsc] => 0 [jackpots_won] => 0 [jackpots_points] => 0 [arcade_won] => 0 [arcade_activity] => 0 [arcade_activitywon] => 0 [arcade_spent] => 0 [arcade_downloads] => 0 [arcade_colamount] => 0 [user_r_pp] => 0 [arcade_gtype] => 0 [arcade_sess_gid] => 1 [arcade_sess_start] => 0 [arcade_b_challenges] => [arcade_usepm] => 0 [arcade_challenge_banned] => 0 [arcade_challengeid] => 0 [arcade_challenge] => 0 [arcade_u_cha] => 2 [arcade_session] => 0 [arcade_time_spent] => 0 [suicides] => 0 [attack_quit] => 0 [attack_pm] => 0 [attack_expire] => absolute [attacker] => 0 [attacked] => 0 [attacker_success] => 0 [attacked_success] => 0 [clone_protect] => 1 [atk_kills] => 0 [atk_deaths] => 0 [banksm_deposit] => 100 [banksm_points] => 100 [banksm_day_deposit] => 0 [banksm_day_withdraw] => 0 [bank_banned] => 0 [bank_using_bank] => 0 [bank_last_deposit] => 0 [bank_last_withdraw] => 0 [ibspeak_isbanned] => 0 [icon_ol] => 0 [gow_score] => 0 [gow_date] => 0 [arcade_points] => 100 [gname] => [gow_wins] => 0 [gow_points] => 0 [msg_msg_id] => 0 [msg_from_id] => 0 [can_create_tourney] => 1 [arcade_sess_gow] => 0 [arcade_lastplay] => 0 [arcade_highscores] => 0 [arcade_twon] => 0 [arcade_chwon] => 0 [user_columns_nocollapse] => 0 [arcade_skin] => 1 [arcade_posts] => 0 [converted_points] => 0 [arcade_pass] => 0 [arcade_pass_time] => 0 [arcade_pass_type] => 0 [arcade_pass_percent] => 100 [casino_ban] => 0 [c_times_played] => 0 [casinototal] => 0 [p_closes] => 0 [p_cwins] => 0 [game_check] => 0 [moneystarted] => 0 [cwallet] => 20 [casino_sess_gid] => 0 [casino_sess_start] => 0 [casino_session] => 0 [sb_ignored] => [members_pass_hash] => c9e02b7becbe493a61b4fede90429074 [members_pass_salt] => >@"a3 [member_banned] => 0 [identity_url] => [member_uploader] => default [members_bitoptions] => 0 [fb_uid] => 0 [fb_emailhash] => [fb_lastsync] => 0 [members_day_posts] => 0,0 [live_id] => [gallery_perms] => 1:1:1 [links] => 0 [l_links_pp] => 0 [l_comments_pp] => 0 [l_watch_submit] => [l_watch_reply] => [l_noti_type] => [inactive_notified] => 0 [inactive_lastNotified] => 0 [inactive_oldGroup] => 3 [inactive_moved] => 1290831402 [chat_banned] => 0 [twitter_id] => [twitter_token] => [twitter_secret] => [notification_cnt] => 0 [tc_lastsync] => 0 [fb_session] => [fb_token] => [ips_mobile_token] => [ban_reason] => ) ) Andd incase it matters I am being hosted by Dreamhost. Link to comment Share on other sites More sharing options...
Martin A. Posted November 27, 2010 Share Posted November 27, 2010 The first issue will be fixed in the next version. The second one (Delete inactive) seems to be correct. As you can see in the MySQL query "WHERE posts <= 0 AND ( last_post <= 1259331884 OR last_post IS NULL ) AND joined <= 1288275884 AND member_group_id IN (42)". '<=' means 'Less than, or equal to', and it only fetched members with 0 posts in that debug result. Link to comment Share on other sites More sharing options...
Jimbotron Posted November 28, 2010 Share Posted November 28, 2010 I only set the debug to fetch two users. It has deleted members who have posted before. But now it just deletes people with zero. So I guess it is working correctly :) Link to comment Share on other sites More sharing options...
AlexJ Posted December 2, 2010 Share Posted December 2, 2010 m4rtin any ETA for version 1.8 or 1.7 works fine? Should I proceed with 1.7? Link to comment Share on other sites More sharing options...
Martin A. Posted December 2, 2010 Share Posted December 2, 2010 The only known issue in v1.1.7 is the duplicate settings in "Move Inactive Members". Link to comment Share on other sites More sharing options...
AlexJ Posted December 2, 2010 Share Posted December 2, 2010 The only known issue in v1.1.7 is the duplicate settings in "Move Inactive Members". Just to confirm, I need to set both settings in order to make it work correctly? or just first one or last one? Thank you! Link to comment Share on other sites More sharing options...
Martin A. Posted December 4, 2010 Share Posted December 4, 2010 Just to confirm, I need to set both settings in order to make it work correctly? or just first one or last one? Thank you! Set both of them. Link to comment Share on other sites More sharing options...
AlexJ Posted December 21, 2010 Share Posted December 21, 2010 Getting below errors while installing: Link to comment Share on other sites More sharing options...
Martin A. Posted December 21, 2010 Share Posted December 21, 2010 If you've previously uninstalled this, database changes aren't removed from the database, and you'll therefor see these "duplicate column name" errors. Just ignore those, as you already have them. Link to comment Share on other sites More sharing options...
Ocean West Posted December 24, 2010 Share Posted December 24, 2010 Can you move members WITHOUT any notification? Link to comment Share on other sites More sharing options...
Martin A. Posted December 26, 2010 Share Posted December 26, 2010 Can you move members WITHOUT any notification? No, not yet, first time anyone's suggested that. I'll add to the next version. "Like" this in the IPS Marketplace, and you'll get a notification when a new version is up :) Link to comment Share on other sites More sharing options...
Ocean West Posted December 27, 2010 Share Posted December 27, 2010 Thank's for the info Martin - so if I manually move people to the inactive member group (do a search for the same criteria) then turn this on will it move people from the inactive members group? when they log in again? Or does this have to be enabled and do all the heavy lifting in both directions? Thanks Link to comment Share on other sites More sharing options...
Martin A. Posted December 27, 2010 Share Posted December 27, 2010 Thank's for the info Martin - so if I manually move people to the inactive member group (do a search for the same criteria) then turn this on will it move people from the inactive members group? when they log in again? Or does this have to be enabled and do all the heavy lifting in both directions? Thanks The task has to take care of the moving both ways. It needs to store the members previous group in the database for use when it moves the member back. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.