/** * Fetch datas * */ public function fetch_datas() { global $dbh; if ($this->id) { $query = "select category_title, category_num_parent from docwatch_categories where id_category=" . $this->id; $result = pmb_mysql_query($query, $dbh); if ($row = pmb_mysql_fetch_object($result)) { $this->title = $row->category_title; $this->num_parent = $row->category_num_parent; } } else { $this->title = "Racine"; $this->num_parent = -1; } $query = "select id_watch from docwatch_watches where watch_num_category=" . $this->id; $result = pmb_mysql_query($query, $dbh); while ($row = pmb_mysql_fetch_object($result)) { $docwatch_watch = new docwatch_watch($row->id_watch); //Gestion des droits utilisateurs (on affiche uniquement les veilles paramétrées pour le current user) if (in_array(SESSuserid, $docwatch_watch->get_allowed_users())) { $this->watches[] = $docwatch_watch->get_informations(); } } $query = "select id_category from docwatch_categories where category_num_parent=" . $this->id; $result = pmb_mysql_query($query, $dbh); while ($row = pmb_mysql_fetch_object($result)) { $this->children[] = new docwatch_watches($row->id_category); } }