qbuilder/user.TDA.inc.php

<?php

	#$this; // object reference 
	#$this->dbh; // initialized MySQL database handle 
	#$this->key; // primary key name 
	#$this->key_type; // primary key type 
	#$this->key_delim; // primary key deliminator 
	#$this->rec; // primary key value (update and delete only) 
	#$newvals; // associative array of new values (update and insert only) 
	#$oldvals; // associative array of old values (update and delete only) 
	#$changed; // array of keys with changed values

	require_once 'auth.php';
	global $adodb;
	$sql = "DELETE FROM qb_user_group ".
	" WHERE userid = '".$oldvals['userid']."' ";
	$rs = $adodb->Execute($sql);
	if (!$rs) echo $adodb->ErrorMsg();
	
	$sql = "DELETE FROM qb_user_right ".
	" WHERE userid = '".$oldvals['userid']."' ";
	$rs = $adodb->Execute($sql);
	if (!$rs) echo $adodb->ErrorMsg();
	
	$sql = "DELETE FROM qb_user_report ".
	" WHERE userid = '".$oldvals['userid']."' ";
	$rs = $adodb->Execute($sql);
	if (!$rs) echo $adodb->ErrorMsg();
	
	$sql = "DELETE FROM qb_user_view ".
	" WHERE userid = '".$oldvals['userid']."' ";
	$rs = $adodb->Execute($sql);
	if (!$rs) echo $adodb->ErrorMsg();

?>