$this->dbobject->query("
		INSERT `deals_archive` 
		 SELECT * FROM 
		 `request_deals` 
		 WHERE `deal_id`=$this->deal_id");

		$this->dbobject->query("
		CREATE OR REPLACE VIEW 
		history_deals_user_id_{$this->user_id} AS 
		SELECT * FROM `request_deals` 
		WHERE `deal_id`=$this->deal_id");
		
		$this->dbobject->query("
		UPDATE `history_deals_user_id_{$this->user_id}` 
		SET `deal_date`='".date('Y-m-d')."' 
		WHERE `deal_id`=$this->deal_id");
		
		$this->dbobject->query("
		INSERT `deals_archive` 
		 SELECT * FROM 
		 `history_deals_user_id_{$this->user_id}` 
		 WHERE `deal_id`=$this->deal_id");
		 
		 $this->dbobject->query("
		 UPDATE `request_deals` 
		 SET `deal_points`='$this->deal_points',
		 	`deal_title`='$this->deal_title',
		 	`deal_category`='$this->deal_category',
		 	`deal_solve`='$this->deal_solve_options',
		 	`deal_content`='$this->deal_content',
		 	`update_me_on_mail`='$this->update_me_on_mail',
		 	`deal_note`='$this->deal_note',
		 	`deal_date`='".date('Y/m/d')."',
		 	`deal_status`='$this->deal_status'
		WHERE `deal_id`=$this->deal_id 	
		 ");