'.$post_title.'
'.PHP_EOL; $content.=''.$post_body.'
'.PHP_EOL;
$content.=''.PHP_EOL; $content.=''.$workshop_title.''.PHP_EOL; $content.=$workshop_restricted; $content.='
'.PHP_EOL; $content.=''. $workshop_visible. $workshop_resume .'
'.PHP_EOL;
$content.=''.PHP_EOL; if(is_array($level)) $content .= ' ' . $level['label'] . ' : ' . $level['name'] . ''. PHP_EOL; $content.='
'.PHP_EOL; if($GLOBALS['l21auth']->isWorkgroupUser($data[$i]['workshop_id'], $GLOBALS['sql_object'])) $content .= ''. _t('workshop', 'member') .'
';
$content.= ''._t('workshop', 'access_to').'';
$content.=''.PHP_EOL; } } } else { $content='
'._t('divers','nodata').'
'; } echo $content; } } /** * DisplayCalendar() * affichage du calendrier * @param $workshop_id * @param $nb * @return **/ if(!function_exists('DisplayCalendar')) { function DisplayCalendar($workshop_id) { $data=$GLOBALS['sql_object'] -> DBSelect(SQL_getoneListCalWorkshop($workshop_id, "ALL")); $content = ''.PHP_EOL; if($data!=0) { $datenow= strtotime("now"); $inter=1*24*3600; for($i=0; $i'.PHP_EOL;
$content.='';
$content.=''.PHP_EOL;
$content.='
'.PHP_EOL;
$content.=''.$workcal_title.'
'.PHP_EOL; $content.=''.PHP_EOL; $content.=''._t('statut','published_on') . ' ' .$workcal_date_crea.' '.PHP_EOL; $content.=_t('divers','by').' '.$workcal_author.''.PHP_EOL; $content.='
'.PHP_EOL; $content.=''.$workcal_resume.'
'.PHP_EOL;
$content.=$common_task.PHP_EOL;
$content.=''.PHP_EOL; } } else { $content.='
'._t('divers','nodata').'
'; } echo $content; } } /** * getAssociatedProjcts() * récupère les projets associés à un groupe de travail * @param $workshop_id * @param integer $title * @return **/ if(!function_exists('getAssociatedProjects')) { function getAssociatedProjects($workshop_id) { // getting associated projects $projects = $GLOBALS['sql_object'] -> DBSelect(SQL_getAssociatedProjects($workshop_id, array('P', 'PA'))); $content = ''; if(!$GLOBALS['l21auth']->isWorkgroupUser($workshop_id, $GLOBALS['sql_object'])) return false; if(isset($projects[0]['project_id'])) { $content = '';
$content .= ''._t('workshop', 'associated_projects').' :';
if(count($projects) > 1) $content .= '
';
}
return $content;
}
}
/**
* DisplayOneWorkshop()
* affichage du détail d'un groupe de travail
* @param $workshop_id
* @param integer $title
* @return
**/
if(!function_exists('DisplayOneWorkshop')) {
function DisplayOneWorkshop($workshop_id, $title=-1) {
$data=$GLOBALS['sql_object'] -> DBSelect(SQL_getoneCompleteWorkshop($workshop_id, array('P', 'PA')));
$content = ''.PHP_EOL;
if($data == 0) error_redirect();
$levels = $GLOBALS['sql_object']->DBSelect(SQL_getLevelsList());
$level = getLevelParent($levels, $data[0]['level_id'], 0);
$sep = ' / ';
if(count($data)!=1) exit;
else {
$link_self= array('rub'=> $GLOBALS['links'][U_L]['workgroup']['linkvalue'],'id'=>$workshop_id);
if(is_array($level)) {
$link_level = array('rub' => $GLOBALS['links'][U_L]['workgroup']['linkvalue'], 'filter' => $GLOBALS['filters'][U_L]['level']['linkvalue'], 'id' => $level['id'], 'name' => $level['name']);
}
$workshop_title=formatText($data[0]['workshop_denomination'], '2HTML');
$workshop_resume=formatText($data[0]['workshop_resume'], '2HTML');
//$workshop_comment=formatText(cutText($data[0]['workshop_comment'],150), '2HTML');
$workshop_level=formatText(cutText($data[0]['level_name'],50), '2HTML');
if($data[0]['workshop_restricted'] == 1) {
$workshop_restricted = ' ('._t('workshop', 'restricted').')'.PHP_EOL;
} else {
$workshop_restricted = "";
}
// marker visible to organizer and admin to mention workshop is not visible to others
if($data[0]['workshop_visible'] == 0 && $GLOBALS['l21auth']->isAuthenticated() && $GLOBALS['l21auth']->isWorkgroupOrganiser($GLOBALS['l21auth']->GetSessionElement('id'), $GLOBALS['sql_object'], $workshop_id)) {
$workshop_visible = ' '._t('workshop', 'visible').' : '._t('divers', 'no').''.PHP_EOL;
} else {
$workshop_visible = '';
}
if ($title<>-1) {
$content.='- ';
for($i=0; $i < count($projects); $i++) {
$link_project = array('rub' => $GLOBALS['links'][U_L]['project']['linkvalue'], 'id' => $projects[$i]['project_id'], 'name' => $projects[$i]['project_name']);
if(count($projects) > 1) $content .= '
- '; $content .= ' '. $projects[$i]['project_name'] . ''; if(count($projects) > 1) $content .= ' '; } if(count($projects) > 1) $content .= '
'; $content.=$workshop_title; $content.=$workshop_restricted; $content.='
'.PHP_EOL; } else{ $content.=''.PHP_EOL; $content.= formatted_permalink($link_self); $content.='
'.PHP_EOL; //$content.=''._t('workshop','det').'
'.PHP_EOL; $content.=''.$workshop_visible. $workshop_resume.'
'.PHP_EOL;
//$content.=''.$workshop_comment.'
'.PHP_EOL; if($GLOBALS['l21auth']->isWorkgroupUser($workshop_id, $GLOBALS['sql_object'])) $content .= ''. _t('workshop', 'member') .''; $content.=''.PHP_EOL; if(is_array($level)) $content .= $level['label'] . ' : ' . $level['name'] . '' . PHP_EOL; // $content .= _t('divers','sousthemeref').' : '.$workshop_level.PHP_EOL; $content.='
'.PHP_EOL; } } echo $content; } } if(!function_exists('DisplayWorkgroupSettings')) { function DisplayWorkgroupSettings($wg_id) { $content=''.PHP_EOL;
$content.='
';
echo $content;
}
}
/**
* getWorkgroupSettings()
* affichage du détail d'un groupe de travail
* @param $workshop_id
* @param integer $title
* @return
**/
if(!function_exists('getWorkgroupSettings')) {
function getWorkgroupSettings($wg_id) {
if(!$GLOBALS['l21auth']->isAuthenticated()) return false;
$exceptions = array();
$disabled_fields = array();
$user_id = $GLOBALS['l21auth']->GetSessionElement('id');
// get notification exceptions
$exc=$GLOBALS['sql_object'] -> DBSelect(SQL_getWGUserNotifyExceptionsSettings($user_id, $wg_id));
if(is_array($exc) && isset($exc[0]['exception'])) {
foreach($exc as $el) {
array_push($exceptions, $el['exception']);
}
}
// default mask
$dmask='checked="checked"';
// general config
if(ALERT_NEWTOPIC==2) {
$is_topicDisabled='';
} else {
$is_topicDisabled=' disabled="disabled"';
}
if(ALERT_NEWPOST==2) {
$is_postDisabled='';
} else {
$is_postDisabled=' disabled="disabled"';
}
if(ALERT_NEWFILE==2) {
$is_fileDisabled='';
} else {
$is_fileDisabled=' disabled="disabled"';
}
$content = "'._t('user','notification_settings').'
'.PHP_EOL; $content.=''._t('user','workgroups_notification').'
'.PHP_EOL; $content.=getWorkgroupSettings($wg_id); $content.='| ".str_replace(' - ', ' ', _t('user','notify_topic'))." | ";
// // $content .= "".str_replace(' - ', ' ',_t('user','notify_post'))." | ";
// // $content .= "".str_replace(' - ', ' ',_t('user','notify_file'))." | ";
// $content .= ""._t('user','notify_topic')." | "; // $content .= ""._t('user','notify_post')." | "; // $content .= ""._t('user','notify_file')." | "; // $content .= "
| "._t('user','notify_topic')." | "; $content .= "|||||
| "._t('user','notify_post')." | "; $content .= "|||||
| "._t('user','notify_file')." | "; $content .= "
| ".str_replace(' - ', ' ', _t('user','notify_topic'))." | ";
// $content .= "".str_replace(' - ', ' ',_t('user','notify_post'))." | ";
// $content .= "".str_replace(' - ', ' ',_t('user','notify_file'))." | ";
$content .= ""._t('user','notify_topic')." | "; $content .= ""._t('user','notify_post')." | "; $content .= ""._t('user','notify_file')." | "; $content .= "
'. _t('workshop', 'nb_members') .'
', $totalMembers); $content1=''.mb_ucfirst(_t('workshop','organizer')) .' ('. $cntOrganisers .') :
- ';
$content2='
- '.$name.' '; } elseif($data[$i]['jwu_user_right'] == "U") { $content2.=$sep_a.'
- '.$name.' '; } } $content1.='
'.mb_ucfirst(_t('workshop','user')) .' ('. $cntMembers .') :
- ';
$sep_u = $sep_a = '';
if($data!=0)
{
for($i=0; $i
'._t('workshop','no_user').'
'; } echo $content; } } /** * DisplayListReport() * affichage de la liste des rapports d'un groupe de travail * @param $workshop_id * @return **/ if(!function_exists('DisplayListReport')) { function DisplayListReport($workshop_id, $status = 'P') { $data=$GLOBALS['sql_object'] -> DBSelect(SQL_getWorkshopReportList($workshop_id, $status)); $content = ''.PHP_EOL; if(is_array($data)) { for($i=0; $i'._t('workshoprep', 'visible').' : '._t('divers', 'no').'
'.PHP_EOL; } else { $workrep_visible = ''; } if($flag) { $link_table= array('rub'=> $GLOBALS['links'][U_L]['report']['linkvalue'],'id'=>$data[$i]['workrep_id'], 'name'=>$data[$i]['workrep_title']); $workrep_title=formatText($data[$i]['workrep_title'], '2HTML'); $workrep_resume=formatText($data[$i]['workrep_resume'], '2HTML'); if(strlen($workrep_resume) > 1000) { $workrep_resume = cutText(formatText($data[$i]['workrep_resume'], '2HTML'), 500) . ''; } else { $workrep_resume=formatText($data[$i]['workrep_resume'], '2HTML'); } $workrep_date_publi=formatText($data[$i]['workrep_published_date_display'], '2HTML'); $content.=''.$workrep_title.'
'.PHP_EOL; $content.=$workrep_visible.PHP_EOL; $content.=''.$workrep_resume.'
'.PHP_EOL;
$content.=''._t('btn', 'read_more').'';
$content.=''._t('workshop','date_report').' : '.$workrep_date_publi.'
'.PHP_EOL; $content.=''.PHP_EOL; } } } else { $content.='
'._t('workshop','no_report').'
'; } echo $content; } } /** * DisplayListTopic() * affichage de la liste des discussions * @param $workshop_id * @param $debut * @return **/ if(!function_exists('DisplayListTopic')) { function DisplayListTopic($workshop_id, $debut) { if(!$GLOBALS['l21auth']->isWorkgroupUser($workshop_id, $GLOBALS['sql_object'])) return false; include_once('../class/class.workshop_com.php'); $workshop_com_object = new workshop_com; // messages read by current user $read_messages = $workshop_com_object->getReadMessages($GLOBALS['sql_object']); // print_r($read_messages); $r = $GLOBALS['sql_object'] -> DBSelect( SQL_getoneCompleteWorkshop($workshop_id)); $workshop_status = $r[0]['workshop_statut']; $result_workcom_list=$GLOBALS['sql_object'] -> DBSelect(SQL_getWorkcomList($workshop_id, $debut, SELECT_LIMIT)); $result_nb_com=$GLOBALS['sql_object'] -> DBSelect(SQL_getcountnbcom($workshop_id)); $bdd_nb_com=$result_nb_com[0]['num_rows']; // print_r($result_workcom_list); $table_link=array('rub' => $GLOBALS['links'][U_L]['topic-list']['linkvalue'],'id' => $workshop_id); echo $bdd_nb_com_display = "".$bdd_nb_com." "._t('workshop','nb_total_com')."
\n"; if($result_workcom_list!=0) { $content= "| ".mb_ucfirst(_t('workshop','com_subject'))." | ".PHP_EOL; // $content.= "".mb_ucfirst(_t('workshop','com_author'))." | ".PHP_EOL; $content.= "".mb_ucfirst(_t('workshop','com_nb_rep'))." | ".PHP_EOL; $content.= "".mb_ucfirst(_t('workshop','com_nb_views'))." | ".PHP_EOL; $content.= "".mb_ucfirst(_t('workshop','com_date_last'))." | ".PHP_EOL; $content.= "
| ";
$content.= "".$workcom_title."";
if ($result_workcom_list[$i]['user_validity'] == 'Y') $content .= " ". formatText(_t('workshop', 'com_by'), '2HTML')." ".$workcom_user." ";
else $content .= " ". formatText(_t('workshop', 'com_by'), '2HTML')." ".$workcom_user." ";
if(isset($lastread_link)) {
$content .= $lastread_link.PHP_EOL;
unset($lastread_link);
}
$content .=$locked;
$content .= " | ".PHP_EOL;
if (empty($result_workcom_det[0]['nb_rep'])) {
$content.= "0 | ".PHP_EOL; } else $content.= "".$result_workcom_det[0]['nb_rep']." | ".PHP_EOL; $content.= "".$result_workcom_list[$i]['workcom_viewed']." | ".PHP_EOL; $content.= "";
if(isset($link_last_msg)) {
if($res[0]['user_validity'] == 'Y') $content.= ''.$last_date_msg.' '.formatText(_t('workshop', 'com_by'), '2HTML').' '.$last_user.''; else $content.= ''.$last_date_msg.' '.formatText(_t('workshop', 'com_by'), '2HTML').' '.$last_user; unset($link_last_msg); } else { if($result_workcom_list[$i]['user_validity'] == 'Y') $content.= ''.$last_date_msg.' '.formatText(_t('workshop', 'com_by'), '2HTML').' '.$workcom_user.''; else $content.= ''.$last_date_msg.' s'.$res[0]['user_validity'].formatText(_t('workshop', 'com_by'), '2HTML').' '.$workcom_user; } $content.= " | ".PHP_EOL;
$content.= "
'._t('workshop','no_com').'
'.PHP_EOL; } if($workshop_status == 'P' ) DisplayUrlAddTopic($workshop_id); echo get_linkin_page($table_link, $bdd_nb_com, $debut); if(isset($_SESSION['message'])) { echo $_SESSION['message']; unset($_SESSION['message']); } echo $content; echo get_linkin_page($table_link, $bdd_nb_com, $debut); if($workshop_status == 'P') DisplayUrlAddTopic($workshop_id); } } /** * DisplayTopic() * affichage d'une discussion * @param $workshop_id * @param $topic_id * @param $debut * @param $flash * @param $post_id * @return **/ if(!function_exists('DisplayTopic')) { function DisplayTopic($workshop_id, $topic_id, $debut) { if(!$GLOBALS['l21auth']->isWorkgroupUser($workshop_id, $GLOBALS['sql_object'])) return false; // we increment Views counter in database include_once('../class/class.workshop_com.php'); $workshop_com_object = new workshop_com; $workshop_com_object->incrementViewsCounter($topic_id, $GLOBALS['sql_object']); $workshop_com_object->setReadMessages($workshop_id, $topic_id, $GLOBALS['sql_object']); $r = $GLOBALS['sql_object'] -> DBSelect( SQL_getoneCompleteWorkshop($workshop_id)); $workshop_status = $r[0]['workshop_statut']; $dataroot=$GLOBALS['sql_object'] -> DBSelect(SQL_getOnetopicWorkcom($workshop_id, $topic_id, $topic_id)); if(!is_array($dataroot)) error_redirect(); $topic_state=$dataroot[0]['workcom_statut']; $result_display=""; $data=$GLOBALS['sql_object'] -> DBSelect(SQL_getOnetopicWorkcom2($workshop_id, $topic_id, $debut, SELECT_LIMIT, -1)); $result_nb_com=$GLOBALS['sql_object'] -> DBSelect(SQL_getWorkcom_detList($topic_id)); if(empty($result_nb_com[0]['nb_rep'])) $bdd_nb_com = 0; else $bdd_nb_com=$result_nb_com[0]['nb_rep']; $table_link=array('rub' => $GLOBALS['links'][U_L]['topic']['linkvalue'],'id' => $topic_id, 'parentid' => $workshop_id, 'name' => $dataroot[0]['workcom_subject'] ); $post_title=formatText($dataroot[0]['workcom_subject'], '2HTML'); $post_body=formatText($dataroot[0]['workcom_body'], '2HTML'); $post_user=formatText(cutText($dataroot[0]['user_login'], 100, 1), '2HTML'); $current_user_id = base64_decode($_SESSION['userid']); $content= ''; echo "".$bdd_nb_com_display = $bdd_nb_com." "._t('workshop','nb_total_com_mes')."
".PHP_EOL; echo''._t('workshop','com_name').' : '.$post_title.'
'.PHP_EOL; echo get_linkin_page($table_link, $bdd_nb_com, $debut); echo ''.PHP_EOL; if ($debut==0) { $complete_uri = SITE_ROOT_URL . $dataroot[0]['profile_avatar']; if($dataroot[0]['profile_avatar'] == "") $user_profile_avatar='
!['.formatText($dataroot[0]['user_login'], '2HTML').']('.PUBLIC_THEME_URL.'/images/no_avatar.png){kind=avatar}
';
else $user_profile_avatar='';
else $user_profile_avatar=''._t('workshop','no_com_rep').'
'; } if(isset($_SESSION['message'])) { echo $_SESSION['message']; echo ''; } echo $content; if(isset($_SESSION['message'])) { echo $_SESSION['message']; unset($_SESSION['message']); } echo get_linkin_page($table_link, $bdd_nb_com, $debut); if($workshop_status == 'P' && $topic_state == "P") echo GetFormAddPost($workshop_id, $topic_id, '', $last_title); else echo $content=''._t('workshop','com_p_lock').'
'; } } /** * AddTopic * Ajout d'une discussion * @param $workshop_id * @param $debut * @param $body * @param $title * @param $confirm */ if(!function_exists('AddTopic')) { function AddTopic($workshop_id, $debut, $body, $title, $confirm_update) { $r = $GLOBALS['sql_object'] -> DBSelect( SQL_getoneCompleteWorkshop($workshop_id)); $workshop_status = $r[0]['workshop_statut']; if($workshop_status != 'P') ReloadIndex('public'); if(!$confirm_update) echo GetFormAddTopic($workshop_id); else { //test new value for this post in form $integrity=CheckComIntegrity($title, $body); if($integrity == 1) { $topic_id=AddPersistentPost($title, $body, '', $workshop_id); notifyUsersMsg(array('id' => $workshop_id,'user' => $_SESSION['userlogin'] ,'owner' => $_SESSION['userlogin'], 'action' => 'topic_alert', 'topic_subject' => formatText($title, '2FIELD'), 'topic_body' => strip_input($body))); $_SESSION['message'] = ''._t('workshop','confirm_add_com').'
'.PHP_EOL; $link = array('rub'=> $GLOBALS['links'][U_L]['topic-list']['linkvalue'],'id'=>$workshop_id, 'name' => $r[0]['workshop_denomination'], 'amp_no_conversion' =>1); header('Location: '.safe_redirect(HrefMaker($link))); } else { echo "".$integrity."
"; echo GetFormAddTopic($workshop_id, $body, $title); } } } } /** * AddPost * Ajout d'un Message * @param $workshop_id * @param $topic_id * @param $debut * @param $body * @param $title */ if(!function_exists('AddPost')) { function AddPost($workshop_id, $topic_id, $debut, $body, $title) { $r = $GLOBALS['sql_object'] -> DBSelect( SQL_getoneCompleteWorkshop($workshop_id)); $workshop_status = $r[0]['workshop_statut']; if($workshop_status != 'P') ReloadIndex('public'); $dataroot=$GLOBALS['sql_object'] -> DBSelect(SQL_getOnetopicWorkcom($workshop_id, $topic_id, $topic_id)); $topic_state=$dataroot[0]['workcom_statut']; if ($topic_state<>"P") DisplayTopic($workshop_id, $topic_id, $debut); else { $integrity=CheckComIntegrity($title, $body); if($integrity == 1) { $post_id=AddPersistentPost($title, $body, $topic_id, $workshop_id); $result_nb_com=$GLOBALS['sql_object'] -> DBSelect(SQL_getWorkcom_detList($topic_id)); $bdd_nb_com=$result_nb_com[0]['nb_rep']; $debut = ((int) (($bdd_nb_com-1) / SELECT_LIMIT)) * SELECT_LIMIT; notifyUsersMsg(array('action' => 'post_alert','user' => $_SESSION['userlogin'] ,'owner' => $_SESSION['userlogin'], 'topic_subject' => formatText($title, '2FIELD'), 'topic_body' => strip_input($body), 'tid' => $topic_id, 'parentid' => $workshop_id, 'id' => $post_id, 'debut' => $debut)); $_SESSION['message'] = ''._t('workshop','confirm_add_com').'
'.PHP_EOL; $link = array('rub'=> $GLOBALS['links'][U_L]['topic']['linkvalue'],'id'=>$topic_id,'parentid'=> $workshop_id, 'name' => $dataroot[0]['workcom_subject'], 'debut' => $debut, '#' => 'msg-'.$post_id, 'amp_no_conversion' =>1); // echo _debug(http_build_query ($link)); // echo ''.http_build_query ($link).'
'.PHP_EOL; header('Location: '.safe_redirect(HrefMaker($link))); } else { echo "".$integrity."
"; echo GetFormAddPost($workshop_id, $topic_id, $body, $title); } } } } /** * UpdatePost * Mise à jour d'un message * @param $workshop_id * @param $topic_id * @param $debut * @param $new_body * @param $new_title * @param $post_id * @param $confirm_update * @return void */ if(!function_exists('UpdatePost')) { function UpdatePost($workshop_id, $topic_id, $debut, $new_body, $new_title, $post_id, $confirm_update) { $data=$GLOBALS['sql_object'] -> DBSelect(SQL_getOnetopicWorkcom($workshop_id, $post_id, "root")); $old_title=formatText($data[0]['workcom_subject'], '2FIELD'); $old_body=formatText($data[0]['workcom_body'], '2FIELD'); $topic_state=$data[0]['workcom_statut']; if ($topic_state<>"P") DisplayTopic($workshop_id, $topic_id, $debut); else { //display old value for this post in form if(!$confirm_update) echo GetFormModPost($workshop_id, $topic_id, $post_id, $old_body, $old_title); else { //test new value for this post in form $integrity=CheckComIntegrity($new_title, $new_body); if($integrity == 1) { $r=ModPersistentPost($new_title, $new_body, $post_id, $workshop_id, $topic_id); echo ''.$r.'
'.PHP_EOL; //scroll jusque $post_id echo DisplayTopic($workshop_id, $topic_id, $debut); } else { echo "".$integrity."
"; echo GetFormModPost($workshop_id, $topic_id, $post_id, $old_body, $old_title); } } } } } /** * GetFormAddTopic() * formulaire d'ajout d'un Topic * @param $workshop_id * @param $subject_body * @param $subject_title * @return **/ if(!function_exists('GetFormAddTopic')) { function GetFormAddTopic($workshop_id, $body='', $title='') { IncludeLightRte(array('id'=> 'post-body')); $title = formatText($title, '2FIELD'); $body = formatText($body, '2FIELD'); $form=''._t('workshop','add_com').'
'.PHP_EOL; $form.=''.PHP_EOL; return $form; } } /** * GetFormModPost() * formulaire de modification d'un Post * @param $workshop_id * @param $topic_id * @param integer $post_id * @param $subject_body * @param $subject_title * @return **/ if(!function_exists('GetFormModPost')) { function GetFormModPost($workshop_id, $topic_id, $post_id, $body, $title) { IncludeLightRte(array('id'=> 'post-body')); $form=''._t('workshop','mod_com_mes').'
'.PHP_EOL; $form.=''.PHP_EOL; return $form; } } /** * GetFormAddPost() * formulaire d'ajout d'un Post * @param $workshop_id * @param $topic_id * @param $body * @param $title * @return **/ if(!function_exists('GetFormAddPost')) { function GetFormAddPost($workshop_id, $topic_id, $body='', $title=''){ IncludeLightRte(array('id'=> 'post-body')); $title = formatText($title, '2FIELD'); $body = formatText($body, '2FIELD'); $form='';
$form.='
';
return $form;
}
}
/**
* CheckComIntegrity()
* Vérification de l'intégrité des données
* @param $title
* @param $body
* @param $workshop_com_object
* @return
**/
if(!function_exists('CheckComIntegrity')) {
function CheckComIntegrity($title, $body){
$integrity=1;
if (strlen($title) < 3) $integrity=_t('workshop','com_no_subject');
if (strlen($body) < 10) $integrity=_t('workshop','com_no_body');
if(is_string($integrity)) return $integrity;
else return 1;
}
}
/**
* AddPersistentPost()
* Ajout dans la base d'un nouveau Post
* @param $title
* @param $body
* @param $topic_id
* @param $workshop_id
* @return
**/
if(!function_exists('AddPersistentPost')) {
function AddPersistentPost($title, $body, $topic_id, $workshop_id){
$r = $GLOBALS['sql_object'] -> DBSelect( SQL_getoneCompleteWorkshop($workshop_id));
$workshop_status = $r[0]['workshop_statut'];
if($workshop_status != 'P') ReloadIndex('public');
if(isset($_SESSION['authenticated'])) {
$user_id=base64_decode($_SESSION['userid']);
include_once('../class/class.workshop_com.php');
$workshop_com_object = new workshop_com;
$result=CheckComIntegrity($title, $body);
if ($result==1) {
$table = array();
$table[0] = $title;
$table[1] = $body;
$table[2] = $topic_id;
$table[3] = $user_id;
$table[4] = $workshop_id;
$result=$workshop_com_object->AddCom($table , $GLOBALS['sql_object']);
return $result;
}
else return $result;
} else return false;
}
}
/**
* ModPersistentPost()
* Modification dans la base d'un Post
* @param $title
* @param $body
* @param $mes_id
* @param $workshop_id
* @param $topic_id
* @return
**/
if(!function_exists('ModPersistentPost')) {
function ModPersistentPost($title, $body, $mes_id, $workshop_id, $topic_id){
$r = $GLOBALS['sql_object'] -> DBSelect( SQL_getoneCompleteWorkshop($workshop_id));
$workshop_status = $r[0]['workshop_statut'];
if($workshop_status != 'P') ReloadIndex('public');
if(isset($_SESSION['authenticated'])) {
$user_id=base64_decode($_SESSION['userid']);
if($GLOBALS['l21auth']->isWorkgroupUser($workshop_id, $GLOBALS['sql_object'])) {
$hasRights = true;
} else {
$hasRights = false;
}
include_once('../class/class.workshop_com.php');
$workshop_com_object = new workshop_com;
$result=CheckComIntegrity($title, $body);
if ($result==1) {
$table = array();
$table[0] = $title;
$table[1] = $body;
$result=$workshop_com_object->ModifyComUser($mes_id, $table , $user_id, $GLOBALS['sql_object'], $hasRights);
if (!is_string($result)) return _t('workshop','confirm_mod_com');
else return $result;
}
else return $result;
} else return false;
}
}
?>