id = $id+0; $this->fetch_datas(); } // end of member function __construct /** * Fetch datas * */ public function fetch_datas(){ global $dbh; $this->title = ""; $this->last_date = "0000-00-00 00:00:00"; $this->num_category = 0; $this->allowed_users = array(); $this->owner = 0; $this->ttl = 0; $this->desc = ""; $this->logo_url = ""; $this->parameters = array(); $this->watch_rss_link = ""; $this->watch_rss_lang = ""; $this->watch_rss_copyright = ""; $this->watch_rss_editor = ""; $this->watch_rss_webmaster = ""; $this->watch_rss_image_title = ""; $this->watch_rss_image_website = ""; $this->boolean_expression = ""; if($this->id){ //Query $query = "select * from docwatch_watches where id_watch = '".$this->id."'"; $result=pmb_mysql_query($query, $dbh); if (pmb_mysql_num_rows($result)) { $row = pmb_mysql_fetch_object($result); $this->title = $row->watch_title; $this->last_date = $row->watch_last_date; $this->num_category = $row->watch_num_category; $this->allowed_users = explode(",",$row->watch_allowed_users); $this->owner = $row->watch_owner; $this->ttl = $row->watch_ttl; $this->desc = $row->watch_desc; $this->logo_url = $row->watch_logo_url; $this->record_default_status = $row->watch_record_default_status; $this->record_default_type = $row->watch_record_default_type; $this->article_default_content_type = $row->watch_article_default_content_type; $this->article_default_parent = $row->watch_article_default_parent; $this->article_default_publication_status = $row->watch_article_default_publication_status; $this->section_default_content_type = $row->watch_section_default_content_type; $this->section_default_parent = $row->watch_section_default_parent; $this->section_default_publication_status = $row->watch_section_default_publication_status; $this->watch_rss_link = $row->watch_rss_link; $this->watch_rss_lang = $row->watch_rss_lang; $this->watch_rss_copyright = $row->watch_rss_copyright; $this->watch_rss_editor = $row->watch_rss_editor; $this->watch_rss_webmaster = $row->watch_rss_webmaster; $this->watch_rss_image_title = $row->watch_rss_image_title; $this->watch_rss_image_website = $row->watch_rss_image_website; $this->boolean_expression = $row->watch_boolean_expression; $query = "select id_datasource, datasource_type from docwatch_datasources where datasource_num_watch = ".$this->id; $result = pmb_mysql_query($query,$dbh); if($result && pmb_mysql_num_rows($result)){ $this->datasources = array(); while ($row=pmb_mysql_fetch_object($result)) { $this->datasources[$row->id_datasource+0] = $row->datasource_type; } } } } } /** * Renvoie le formulaire * */ public function get_form(){ return $form; } /** * Set les propriétés de l'instance depuis le formulaire * * @return void * @access public */ public function set_from_form() { global $datasources_choice; global $docwatch_watch_title; global $docwatch_watch_owner; global $docwatch_watch_allowed_users; global $docwatch_watch_num_category; global $docwatch_watch_ttl; global $docwatch_watch_desc; global $docwatch_watch_logo_url; global $docwatch_watch_watch_rss_link; global $docwatch_watch_watch_rss_lang; global $docwatch_watch_watch_rss_copyright; global $docwatch_watch_watch_rss_editor; global $docwatch_watch_watch_rss_webmaster; global $docwatch_watch_watch_rss_image_title; global $docwatch_watch_watch_rss_image_website; global $docwatch_watch_boolean_expression; if (is_array($datasources_choice) && count($datasources_choice)) { foreach ($datasources_choice as $datasource_choice) { $this->parameters['datasources'][] = $datasource_choice; } } $this->title = strip_tags(stripslashes($docwatch_watch_title)); $this->owner = $docwatch_watch_owner; $this->allowed_users = $docwatch_watch_allowed_users; $this->num_category = $docwatch_watch_num_category; $this->ttl = $docwatch_watch_ttl; $this->desc = $docwatch_watch_desc; $this->logo_url = $docwatch_watch_logo_url; $this->watch_rss_link = $docwatch_watch_watch_rss_link; $this->watch_rss_lang = $docwatch_watch_watch_rss_lang; $this->watch_rss_copyright = $docwatch_watch_watch_rss_copyright; $this->watch_rss_editor = $docwatch_watch_watch_rss_editor; $this->watch_rss_webmaster = $docwatch_watch_watch_rss_webmaster; $this->watch_rss_image_title = $docwatch_watch_watch_rss_image_title; $this->watch_rss_image_website = $docwatch_watch_watch_rss_image_website; $this->boolean_expression = stripslashes($docwatch_watch_boolean_expression); } // end of member function set_from_form /** * Sauvegarde des propriétés * * @return void * @access public */ public function save(){ global $dbh; if($this->id){ $query = "update docwatch_watches set "; $clause = " where id_watch = ".$this->id; }else{ $query = "insert into docwatch_watches set "; $clause= ""; } $query.= " watch_title = '".addslashes($this->title)."', watch_owner = '".$this->owner."', watch_allowed_users = '".implode(",", $this->allowed_users)."', watch_num_category = '".$this->num_category."', watch_last_date = now(), watch_ttl = '".$this->ttl."', watch_desc = '".addslashes($this->desc)."', watch_logo_url = '".$this->logo_url."', watch_record_default_type = '".addslashes($this->record_default_type)."', watch_record_default_status = '".$this->record_default_status."', watch_article_default_parent = '".$this->article_default_parent."', watch_article_default_content_type = '".$this->article_default_content_type."', watch_article_default_publication_status = '".$this->article_default_publication_status."', watch_section_default_parent = '".$this->section_default_parent."', watch_section_default_content_type = '".$this->section_default_content_type."', watch_section_default_publication_status = '".$this->section_default_publication_status."', watch_rss_link = '".addslashes($this->watch_rss_link)."', watch_rss_lang = '".addslashes($this->watch_rss_lang)."', watch_rss_copyright = '".addslashes($this->watch_rss_copyright)."', watch_rss_editor = '".addslashes($this->watch_rss_editor)."', watch_rss_webmaster = '".addslashes($this->watch_rss_webmaster)."', watch_rss_image_title = '".addslashes($this->watch_rss_image_title)."', watch_rss_image_website = '".addslashes($this->watch_rss_image_website)."', watch_boolean_expression = '".addslashes($this->boolean_expression)."' ".$clause; $result = pmb_mysql_query($query,$dbh); if($result){ if(!$this->id){ $this->id = pmb_mysql_insert_id($dbh); } if($this->parameters['datasources']){ foreach ($this->parameters['datasources'] as $key=>$datasource_type) { if (in_array($datasource_type, $this->datasources)) { $datasource_id = array_search($datasource_type,$this->datasources); } else { $datasource_id = 0; } $datasource = new $datasource_type($datasource_id); $datasource->set_num_watch($this->id); $result = $datasource->save(); if($result){ $this->datasources[$datasource->get_id()] = $datasource_type; } } } return true; } return false; } /** * Méthode de suppression */ public function delete(){ global $dbh; global $msg; if($this->id && $this->check_rights()){ //on commence par éliminer les sources de données et sélecteurs associés... $query = "select id_datasource from docwatch_datasources where datasource_num_watch = ".$this->id; $result = pmb_mysql_query($query,$dbh); if(pmb_mysql_num_rows($result)){ while($row = pmb_mysql_fetch_object($result)){ $query = "select id_selector from docwatch_selectors where selector_num_datasource = ".$row->id_datasource; $sel_result = pmb_mysql_query($query,$dbh); if(pmb_mysql_num_rows($sel_result)){ while($sel_row = pmb_mysql_fetch_object($sel_result)){ $query = "delete from docwatch_selectors where selector_num_datasource = ".$row->id_datasource; pmb_mysql_query($query,$dbh); } } $query = "delete from docwatch_datasources where datasource_num_watch = ".$this->id; pmb_mysql_query($query,$dbh); } } //il faut ensuite éliminer les items.. $query = "select id_item from docwatch_items where item_num_watch = ".$this->id; $result = pmb_mysql_query($query,$dbh); if($result){ while($row = pmb_mysql_fetch_object($result)){ $docwatch_item = new docwatch_item($row->id_item); $docwatch_item->delete(); } } $query = "delete from docwatch_watches where id_watch = ".$this->id; $result = pmb_mysql_query($query,$dbh); if($result){ return true; }else{ $this->error = $msg['dsi_docwatch_watch_error_database']; return false; } }else{ $this->error = $msg['dsi_docwatch_watch_error_dont_exist']; } } /** * Récupération des données de la source... */ public function get_datas(){ } /** * Retourne les sources de données associées * */ public function get_datasources() { if(!count($this->datasources_objects)) { foreach($this->datasources as $id => $classe){ $this->datasources_objects[] = new $classe($id); } //TODO: checkifisuptodate } } public function get_items() { return $this->items; } /** * Renvoie le nombre d'items collectés * * @return int * @access public */ public function fill_items( ) { } // end of member function fill_items /** * * * @param int item_id Identifiant de l'item à  supprimer * @return bool * @access public */ public function del_item( $item_id ) { } // end of member function del_item /** * Suppression des items périmés de sources supprimées */ protected function del_outdated_of_datasource_removed() { global $dbh; $query = "select id_item from docwatch_items left join docwatch_datasources on item_num_datasource=id_datasource where date_add(item_added_date, INTERVAL ".$this->ttl." hour) < now() and id_datasource is null and item_status = 2 and item_num_watch = '".$this->id."'"; $result = pmb_mysql_query($query, $dbh); if (pmb_mysql_num_rows($result)) { while($row = pmb_mysql_fetch_object($result)){ $item = new docwatch_item($row->id_item); $item->delete(); } } return true; } /** * * * @return bool * @access public */ public function del_outdated( ) { global $dbh; $query = "select id_item from docwatch_items where date_add(item_added_date, INTERVAL ".$this->ttl." hour) < now() and item_num_watch = '".$this->id."'"; $result = pmb_mysql_query($query, $dbh); if (pmb_mysql_num_rows($result)) { while($row = pmb_mysql_fetch_object($result)){ $item = new docwatch_item($row->id_item); $item->mark_as_deleted(); } return true; } return false; } // end of member function del_outdated /** * del_outdated + fill_items * * @return bool * @access public */ public function sync() { if($this->check_rights()){ $this->datasources_synced = array(); $this->del_outdated(); $this->del_outdated_of_datasource_removed(); $this->get_datasources(); foreach($this->datasources_objects as $datasource){ if(!$datasource->get_is_up_to_date()){ //TODO: Do update (with get new items) //la methode sync va appeler les mises a jour des items dans la datasource $datasource->sync($this->owner); $this->datasources_synced[] = array('id'=>$datasource->get_id(), 'last_date'=>$datasource->get_last_date(), 'formated_last_date'=>$datasource->get_formated_last_date()); } } $this->update_last_date(); } } // end of member function sync public function update_last_date(){ global $dbh; $this->set_last_date(date("Y-m-d H:i:s")); $query = "update docwatch_watches set watch_last_date = '".$this->last_date."' where id_watch = '".$this->id."'"; if(!pmb_mysql_query($query, $dbh)){ return false; } return true; } public function get_id() { return $this->id; } public function set_id($id) { $this->id = $id+0; } public function get_title() { return $this->title; } public function set_title($title) { $this->title = $title; } public function get_last_date() { return $this->last_date; } public function set_last_date($last_date) { $this->last_date = $last_date; } public function get_owner() { return $this->owner; } public function set_owner($owner) { $this->owner = $owner+0; } public function get_allowed_users() { return $this->allowed_users; } public function set_allowed_users($allowed_users) { foreach ($allowed_users as $key => $value){ $allowed_users[$key] = $value+0; } $this->allowed_users = $allowed_users; } public function get_num_category() { return $this->num_category; } public function set_num_category($num_category) { $this->num_category = $num_category+0; } public function set_items($items) { $this->items = $items; } public function get_ttl() { return $this->ttl; } public function set_ttl($ttl) { $this->ttl = $ttl+0; } public function get_desc() { return $this->desc; } public function set_desc($desc) { $this->desc = $desc; } public function get_logo_url() { return $this->logo_url; } public function set_logo_url($logo_url) { $this->logo_url = $logo_url; } public function get_record_default_type() { return $this->record_default_type; } public function set_record_default_type($record_default_type) { $this->record_default_type = $record_default_type; } public function get_record_default_status() { return $this->record_default_status; } public function set_record_default_status($record_default_status) { $this->record_default_status = $record_default_status+0; } public function get_article_default_parent() { return $this->article_default_parent; } public function set_article_default_parent($article_default_parent) { $this->article_default_parent = $article_default_parent+0; } public function get_article_default_content_type() { return $this->article_default_content_type; } public function set_article_default_content_type($article_default_content_type) { $this->article_default_content_type = $article_default_content_type+0; } public function get_article_default_publication_status() { return $this->article_default_publication_status; } public function set_article_default_publication_status($article_default_publication_status) { $this->article_default_publication_status = $article_default_publication_status+0; } public function get_section_default_parent() { return $this->section_default_parent; } public function set_section_default_parent($section_default_parent) { $this->section_default_parent = $section_default_parent+0; } public function get_section_default_content_type() { return $this->section_default_content_type; } public function set_section_default_content_type($section_default_content_type) { $this->section_default_content_type = $section_default_content_type+0; } public function get_section_default_publication_status() { return $this->section_default_publication_status; } public function set_section_default_publication_status($section_default_publication_status) { $this->section_default_publication_status = $section_default_publication_status+0; } public function get_watch_rss_link() { return $this->watch_rss_link; } public function set_watch_rss_link($watch_rss_link) { $this->watch_rss_link = $watch_rss_link; } public function get_watch_rss_lang() { return $this->watch_rss_lang; } public function set_watch_rss_lang($watch_rss_lang) { $this->watch_rss_lang = $watch_rss_lang; } public function get_watch_rss_copyright() { return $this->watch_rss_copyright; } public function set_watch_rss_copyright($watch_rss_copyright) { $this->watch_rss_copyright = $watch_rss_copyright; } public function get_watch_rss_editor() { return $this->watch_rss_editor; } public function set_watch_rss_editor($watch_rss_editor) { $this->watch_rss_editor = $watch_rss_editor; } public function get_watch_rss_webmaster() { return $this->watch_rss_webmaster; } public function set_watch_rss_webmaster($watch_rss_webmaster) { $this->watch_rss_webmaster = $watch_rss_webmaster; } public function get_watch_rss_image_title() { return $this->watch_rss_image_title; } public function set_watch_rss_image_title($watch_rss_image_title) { $this->watch_rss_image_title = $watch_rss_image_title; } public function get_watch_rss_image_website() { return $this->watch_rss_image_website; } public function set_watch_rss_image_website($watch_rss_image_website) { $this->watch_rss_image_website = $watch_rss_image_website; } public function get_boolean_expression() { return $this->boolean_expression; } public function set_boolean_expression($boolean_expression) { $this->boolean_expression = $boolean_expression; } public function get_informations(){ global $dbh, $pmb_opac_url; $datas = new stdClass(); $datas->id = $this->id; $datas->type = "watch"; $datas->title = $this->title; $datas->num_category = $this->num_category; $datas->owner = $this->owner; $datas->ttl = $this->ttl; $datas->desc = $this->desc; $datas->logo_url = $this->logo_url; $datas->last_date = $this->last_date; $datas->formated_last_date = date("c",strtotime($this->last_date)); $datas->record_default_type = $this->record_default_type; $datas->record_default_status = $this->record_default_status; $datas->article_default_parent = $this->article_default_parent; $datas->article_default_content_type = $this->article_default_content_type; $datas->article_default_publication_status = $this->article_default_publication_status; $datas->section_default_parent = $this->section_default_parent; $datas->section_default_content_type = $this->section_default_content_type; $datas->section_default_publication_status = $this->section_default_publication_status; $datas->watch_rss_link = $this->watch_rss_link; $datas->watch_rss_lang = $this->watch_rss_lang; $datas->watch_rss_copyright = $this->watch_rss_copyright; $datas->watch_rss_editor = $this->watch_rss_editor; $datas->watch_rss_webmaster = $this->watch_rss_webmaster; $datas->watch_rss_image_title = $this->watch_rss_image_title; $datas->watch_rss_image_website = $this->watch_rss_image_website; $datas->boolean_expression = $this->boolean_expression; $datas->opac_link = $pmb_opac_url.'docwatch.php?id='.$this->id; $datas->allowed_users = $this->allowed_users; $datas->sources = array(); $query = "select id_datasource, datasource_title from docwatch_datasources where datasource_num_watch = ".$this->id; $result = pmb_mysql_query($query,$dbh); if($result && pmb_mysql_num_rows($result)){ while ($row=pmb_mysql_fetch_object($result)) { $datas->sources[] = array("id"=>1*$row->id_datasource, "title"=>$row->datasource_title, "type"=>"source"); } } $datas->nb_sources = 0; if (count($datas->sources)) { $datas->nb_sources = count($datas->sources); } return $datas; } public function get_normalized_watch(){ global $dbh; global $pmb_opac_url; $categories = array(); if ($this->num_category) { $query = "select id_category, category_title from docwatch_categories where id_category = ".$this->num_category; $result = pmb_mysql_query($query,$dbh); if($result && pmb_mysql_num_rows($result)){ while ($row=pmb_mysql_fetch_object($result)) { $categories = array("id"=>$row->id_category, "title"=>$row->category_title); } } } $items = array(); if($this->items){ foreach($this->items as $item){ $items[] = $item->get_normalized_item(); } } return array( 'id' => $this->id, 'title' => $this->title, 'desc' => $this->desc, 'logo_url' => $this->logo_url, 'last_date' => $this->last_date, 'rss_link' => $pmb_opac_url."docwatch?id=".$this->get_id(), 'watch_rss_link' => $this->watch_rss_link, 'watch_rss_lang' => $this->watch_rss_lang, 'watch_rss_copyright' => $this->watch_rss_copyright, 'watch_rss_editor' => $this->watch_rss_editor, 'watch_rss_webmaster' => $this->watch_rss_webmaster, 'watch_rss_image_title' => $this->watch_rss_image_title, 'watch_rss_image_website' => $this->watch_rss_image_website, 'boolean_expression' => $this->boolean_expression, 'category' => $categories, 'items' => $items ); } public function get_normalized_datasources(){ $this->get_datasources(); $array_datasources_normalized = array(); $array_retour = array(); foreach($this->datasources_objects as $datasource){ $array_datasources_normalized[] = $datasource->get_normalized_datasource(); } $array_retour["sources"] = $array_datasources_normalized; $array_retour["watch_id"] = $this->id; return $array_retour; } public function get_normalized_items(){ $array_items_normalized = array(); $array_retour = array(); if($this->items){ foreach($this->items as $item){ $array_items_normalized[] = $item->get_normalized_item(); } } $array_retour["items"] = $array_items_normalized; $array_retour["watch_id"] = $this->id; return $array_retour; } public function fetch_items($interesting_only=false){ global $dbh; if($this->check_rights()){ $query = "select id_item from docwatch_items where item_num_watch = ".$this->id." "; if($interesting_only){ $query.= " and item_interesting= 1"; } $result = pmb_mysql_query($query,$dbh); if(pmb_mysql_num_rows($result)){ while($row = pmb_mysql_fetch_object($result)){ if(!$this->items){ $this->items = array(); } if(!$this->items[$row->id_item]){ $this->items[$row->id_item] = new docwatch_item($row->id_item); } } } } } public static function get_available_datasources(){ global $msg; return array( array( 'class' => 'docwatch_datasource_articles', 'label'=>$msg['dsi_docwatch_datasource_articles'] ), array( 'class' => 'docwatch_datasource_sections', 'label'=>$msg['dsi_docwatch_datasource_sections'] ), array( 'class' => 'docwatch_datasource_notices', 'label'=>$msg['dsi_docwatch_datasource_notices'] ), array( 'class' => 'docwatch_datasource_notices_rss', 'label'=>$msg['dsi_docwatch_datasource_notices_rss'] ), array( 'class' => 'docwatch_datasource_rss', 'label'=>$msg['dsi_docwatch_datasource_rss'] ), array( 'class' => 'docwatch_datasource_external_sources', 'label'=>$msg['dsi_docwatch_datasource_external_sources'] ), array( 'class' => 'docwatch_datasource_monitoring_website', 'label'=>$msg['dsi_docwatch_datasource_monitoring_website'] ) ); } /** * Renvoie une structure XML au format RSS * */ public function get_xmlrss(){ global $charset, $pmb_bdd_version; if (!$this->id) return; $xmlrss = " ".htmlspecialchars ($this->watch_rss_link,ENT_QUOTES, $charset)." ".htmlspecialchars ($this->desc,ENT_QUOTES, $charset)." ".htmlspecialchars ($this->watch_rss_lang,ENT_QUOTES, $charset)." ".htmlspecialchars ($this->watch_rss_copyright,ENT_QUOTES, $charset)." ".htmlspecialchars ($this->watch_rss_editor,ENT_QUOTES, $charset)." ".htmlspecialchars ($this->watch_rss_webmaster,ENT_QUOTES, $charset)." PMB Version ".$pmb_bdd_version." ".addslashes(date("D, d M Y H:i:s O",strtotime($this->last_date)))." ".$this->ttl." \n"; if ($this->logo_url || $this->watch_rss_image_title || $this->watch_rss_image_website) { $xmlrss .= " ".htmlspecialchars ($this->logo_url,ENT_QUOTES, $charset)." ".htmlspecialchars ($this->watch_rss_image_website,ENT_QUOTES, $charset)." "; } $xmlrss .= " !!items!! "; $xmlrss = str_replace("!!items!!", $this->get_items_xmlrss(), $xmlrss); if($charset=='utf-8') { $xmlrss = preg_replace('/[\x00-\x08\x10\x0B\x0C\x0E-\x19\x7F]'. '|[\x00-\x7F][\x80-\xBF]+'. '|([\xC0\xC1]|[\xF0-\xFF])[\x80-\xBF]*'. '|[\xC2-\xDF]((?![\x80-\xBF])|[\x80-\xBF]{2,})'. '|[\xE0-\xEF](([\x80-\xBF](?![\x80-\xBF]))|(?![\x80-\xBF]{2})|[\x80-\xBF]{3,})/S', '', $xmlrss ); } else { $xmlrss = preg_replace('/[\x00-\x08\x10\x0B\x0C\x0E-\x19\x7F]/S', '', $xmlrss ); } return $xmlrss; } function get_items_xmlrss() { global $charset; $items_xmlrss = ""; if (is_array($this->items) && count($this->items)) { foreach ($this->items as $item) { if ($item->get_interesting()) { if ($item->get_logo_url() != "") { $image = ""; } else { $image = ""; } $publication_date=""; if($item->get_publication_date())$publication_date=date("D, d M Y H:i:s O",strtotime($item->get_publication_date())); $items_xmlrss .= " ".$publication_date." ".htmlspecialchars ($item->get_url(),ENT_QUOTES, $charset)." ".htmlspecialchars(strip_tags($image.$item->get_summary(),"

"),ENT_QUOTES, $charset)." "; $descriptors = $item->get_descriptors(); if (is_array($descriptors) && count($descriptors)) { foreach ($descriptors as $descriptor) { $items_xmlrss .= " ".htmlspecialchars ($descriptor,ENT_QUOTES, $charset).""; } } $items_xmlrss .= " "; } } } return $items_xmlrss; } public function get_synced_datasources(){ return $this->datasources_synced; } public static function get_format_data_structure(){ global $msg; $datas = array( array( 'var' => "id", 'desc'=> $msg['cms_module_watch_datasource_desc_id'] ), array( 'var' => "title", 'desc' => $msg['cms_module_watch_datasource_desc_title'] ), array( 'var' => "desc", 'desc' => $msg['cms_module_watch_datasource_desc_desc'] ), array( 'var' => "logo_url", 'desc' => $msg['cms_module_watch_datasource_desc_logo_url'] ), array( 'var' => "last_date", 'desc' => $msg['cms_module_watch_datasource_desc_last_date'] ), array( 'var' => "rss_link", 'desc' => $msg['cms_module_watch_datasource_desc_rss_link'] ), array( 'var' => "category", 'desc' => $msg['cms_module_watch_datasource_desc_category'], 'children' => array( array( 'var' => "category.id", 'desc' => $msg['cms_module_watch_datasource_desc_category_id'] ), array( 'var' => "category.title", 'desc' => $msg['cms_module_watch_datasource_desc_category_title'] ) ) ), array( 'var' => "items", 'desc' => $msg['cms_module_watch_datasource_desc_items'], 'children' => docwatch_root::prefix_var_tree(docwatch_item::get_format_data_structure(), "items[i]") ) ); return $datas; } /** * Méthode appellée après le fetch_datas * @return true if user have rights, false otherwise */ public function check_rights(){ if(in_array(SESSuserid, $this->allowed_users)){ return true; } return false; } public static function check_watch_rights($watch_id){ global $dbh; if($watch_id){ $query = "select watch_allowed_users from docwatch_watches where id_watch = '".$watch_id."'"; $result = pmb_mysql_query($query, $dbh); if(pmb_mysql_num_rows($result)){ $row = pmb_mysql_fetch_object($result); $tab_users = explode(",",$row->watch_allowed_users); } if(in_array(SESSuserid, $tab_users)){ return true; } return false; }else{ return true; } } public function get_error(){ return $this->error; } } // end of docwatch_watch