View Single Post
  #1  
Old 06-07-2009, 03:50 PM
hennanra hennanra is offline
 
Join Date: Nov 2005
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Delete users and their threads/posts extra

I want to completely delete (not ban) an array of users (submitted by a checkboxs form) from the database, ie. deleting the users and automatically delete all their associated data eg. threads, posts ...

I've tried this code from 'user.php' but it only deletes users in the 'user' table not their associated data in other tables:

Code:
if(isset($_REQUEST['do']) && $_REQUEST['do'] == 'doDelete')
{
	$vbulletin->input->clean_array_gpc('p', array('userid' => TYPE_ARRAY));
	$user_ids = $vbulletin->GPC['userid'];
	// check user is not set in the $undeletable users string
	$nodelete = explode(',', $vbulletin->config['SpecialUsers']['undeletableusers']);
	foreach($user_ids as $user_id)
	{
		if (!in_array($user_id, $nodelete))
		{
			$info = fetch_userinfo($user_id);
			if ($info['userid'] == $user_id)
			{
				//delete user
				$userdm =& datamanager_init('User', $vbulletin, ERRTYPE_CP);
				$userdm->set_existing($info);
				$userdm->delete();
				unset($userdm);
			}
		}
	}
	//
	print_cp_message('<center>Successfully deleted selected user(s)!</center>', NULL, 0, NULL);
	//
}
Any help would be appreciated.

Thank you.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01154 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete