<?php

	/*
	** File: ADD_FROM_WISHLIST
	** Description: add a sku from the wishlist, then remove from wishlist
	** Version: $Revision: 1.9 $
	** Created: 06/10/1999
	** Author: Leon Atkinson
	** Email: leon@clearink.com
	** CVS Author: $Author: leon $
	** Last Revised: $Date: 2000/01/03 21:22:25 $
	**
	** Log : $Log: ADD_FROM_WISHLIST,v $
	** Log : Revision 1.9  2000/01/03 21:22:25  leon
	** Log : Adding a bit of error checking
	** Log :
	** Log : Revision 1.8  1999/12/09 23:23:16  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.7  1999/11/09 21:47:10  leon
	** Log : More localization.
	** Log :
	** Log : Revision 1.6  1999/11/09 00:28:13  leon
	** Log : Changed use of notes column.  This column now stores an array of variation
	** Log : IDs in serialized form.  Names for attributes and variations are pulled
	** Log : from the database using two new functions in the attribute_functions
	** Log : include module.
	** Log :
	** Log : Revision 1.5  1999/08/18 22:31:44  leon
	** Log : Returning opening PHP tag to XML-friendly tag
	** Log :
	** Log : Revision 1.4  1999/07/28 19:27:11  leon
	** Log : Mass update based on code donation from a live project
	** Log :
	**
	** Copyright (c) 1999 Working Dogs.  All rights reserved.
	*/
	
	//clean input
	$input_ID = (integer)$input_ID;
	
	//user must be logged in
	if($UserInfo["ID"] > 0)
	{	
		//add to basket
		$Query = "INSERT INTO session_sku ";
		$Query .= "(Session, SKU, Quantity, Notes) ";
		$Query .= "SELECT '$sid', SKU, Quantity, Notes ";
		$Query .= "FROM user_sku ";
		$Query .= "WHERE ID = $input_ID ";
		$Query .= "AND User = " . $UserInfo["ID"] . " ";
		
		if(!mysql_query($Query, $DatabaseLink))
		{
			$ActionResults[] =  mysql_errno() . ": " . mysql_error();
			$ActionResults[] =  $Query;
		}
		else
		{
			$ActionResults[] =  L_ADDFROMWISHLIST_SUCCESS;

			//remove from wishlist
			$Query = "DELETE FROM user_sku ";
			$Query .= "WHERE ID = $input_ID ";
			$Query .= "AND User = " . $UserInfo["ID"] . " ";
			mysql_query($Query, $DatabaseLink);
		}
	}	
?>
