/** * Deletes all class-fields from the project with given id * * @param int $id the project-id * @return int the number of affected rows */ public function delete_by_project($id) { $db = FWS_Props::get()->db(); if (!PC_Utils::is_valid_project_id($id)) { FWS_Helper::def_error('intge0', 'id', $id); } $stmt = $db->get_prepared_statement('DELETE FROM ' . PC_TB_CLASS_FIELDS . ' WHERE project_id = :id'); $stmt->bind(':id', $id); $db->execute($stmt->get_statement()); return $db->get_affected_rows(); }
/** * Sets the project with given id to the current one * * @param int $id the project-id */ public function set_current($id) { if (!PC_Utils::is_valid_project_id($id)) { FWS_Helper::def_error('intge0', 'id', $id); } $db = FWS_Props::get()->db(); $db->update(PC_TB_PROJECTS, '', array('current' => 0)); $db->update(PC_TB_PROJECTS, 'WHERE id = ' . $id, array('current' => 1)); }