<?php
	/*
	** File: DELETE_ATTRIBUTE
	** Description: Removes an attribute
	** Version: $Revision: 1.6 $
	** Created: 04/21/1999
	** Author: Leon Atkinson
	** Email: leon@clearink.com
	** CVS Author: $Author: leon $
	** Last Revised: $Date: 1999/12/09 23:23:19 $
	**
	** Log : $Log: DELETE_ATTRIBUTE,v $
	** Log : Revision 1.6  1999/12/09 23:23:19  leon
	** Log : Changed ActionResults use so that it's an array instead of a
	** Log : continually-growing string.  Note the little function in standard_library
	** Log : for printing out all the action results.
	** Log :
	** Log : Revision 1.5  1999/11/09 22:21:13  leon
	** Log : More localization work.
	** Log :
	** Log : Revision 1.4  1999/08/18 22:31:48  leon
	** Log : Returning opening PHP tag to XML-friendly tag
	** Log :
	** Log : Revision 1.3  1999/07/28 19:27:12  leon
	** Log : Mass update based on code donation from a live project
	** Log :
	**
	** Copyright (c) 1999 Working Dogs.  All rights reserved.
	*/

	

		/* Make sure the user has admin rights. */
	if( !$UserInfo["Permission"]["Administrate"] )
	{
		print(L_DELETEATTR_DENIED . "<BR>\n");
	}
	else
	{
		//delete attribute
		$Query = "DELETE FROM attribute WHERE ID=" . intval($attribute);

		//execute query
		if(!mysql_query($Query, $DatabaseLink))
		{
			$ActionResults[] =  mysql_errno() . ": " . mysql_error();
		}

		//get list of variations for this attribute
		$Query = "SELECT ID FROM variation WHERE Attribute=" . intval($attribute);
		$DatabaseResult = mysql_query($Query, $DatabaseLink);
		$variation_list = "0";
		while($DatabaseRow = mysql_fetch_row($DatabaseResult))
		{
			$variation_list .= ", " . $DatabaseRow[0];
		}

		//delete sku_variation rows
		$Query = "DELETE FROM sku_variation ";
		$Query .= "WHERE Variation in ($variation_list)";

		//execute query
		if(!mysql_query($Query, $DatabaseLink))
		{
			$ActionResults[] =  mysql_errno() . ": " . mysql_error();
		}


		//delete variations
		$Query = "DELETE FROM variation WHERE Attribute=" . intval($attribute);

		//execute query
		if(!mysql_query($Query, $DatabaseLink))
		{
			$ActionResults[] =  mysql_errno() . ": " . mysql_error();
		}
		else
		{
			$ActionResults[] = L_DELETEATTR_SUCCESS;
		}
	}

?>
