function destroy(){
$sql = "DELETE FROM feed_content WHERE feed_id = $this->id";
$res = sql_query($sql);
if(!$res){
return false; //Error unmapping content!
}
$sql1 = "SELECT field_id, screen_id FROM position WHERE feed_id = $this->id";
$res1 = sql_query($sql1);
if(!$res1){
return false; //Error grabbing positions/fields
}
$i=0;
while($row = sql_row_keyed($res1,$i)){
$field = new Field($row['field_id'],$row['screen_id']);
$field->delete_feed($this->id);
//$field->rebalance_scale();
$i++;
}
$sql = "DELETE FROM feed WHERE id = $this->id";
$res = sql_query($sql);
if(!$res){
return false; //Error with the final delete!!!
}
$notify = new Notification();
$notify->notify('feed', $this->id, 'user', $_SESSION['user']->id, 'delete');
//Then we just clear the variables
$this->id = '';
$this->name = '';
$this->description = '';
$this->group_id='';
$this->set = false;
return true;
}
