static function is_max($max = null) { $tuser = new CTableUser(); if($max === null) { $max = CTableConfiguration::get_value_by_element('USER_MAX_NUMBER'); } if($max <= 0) { return false; } return ($tuser->get_nb() >= $max); }
static function get_toolbar($options=array('add'=>'1','cancel'=>'1','send'=>'1')) { $toolbar = "<ul>"; if(!empty($options['send'])) { switch($options['send']) { case 1 : $toolbar .= "<li><a href='?a=5&expediteur=" . CTableUser::get_email_admin() . "'><img src='../img/quicksend.gif' /> Envoi rapide</a></li>"; break; case 2 : $toolbar .= "<li><img src='../img/quicksend.png' class='grise'/> Envoi rapide</li>"; break; } } if(!empty($options['add'])) { switch($options['add']) { case 1 : $toolbar .= "<li><a href='?a=4'><img src='../img/ajouter.gif' />Planifier un envoi groupé</a></li>"; break; case 2 : $toolbar .= "<li><img src='../img/ajouter.gif' class='grise'/>Planifier un envoi groupé</li>"; break; } } if(!empty($options['cancel'])) { switch($options['cancel']) { case 1 : $toolbar .= "<li><a href='?a=0'><img src='../img/annuler.gif' />Annuler</a></li>"; break; case 2 : $toolbar .= "<li><img src='../img/cancel.png' class='grise'/>Annuler</li>"; break; } } $toolbar .= "</ul>"; return $toolbar; }
static function page_protect($url_redirection='../src/login.php') { if(!CLogin::est_logue()) { CFunction::redirection($url_redirection); } else if(!CTableUser::is_admin($_SESSION['idmbr'])) { if(!in_array(basename($_SERVER['SCRIPT_NAME']), array('categorie.php', 'article.php', 'page.php', 'fichier.php', 'dossier.php', 'login.php', 'index.php', 'menu_semaine.php', 'image_menu.php'))) { CFunction::redirection('../src/index.php'); } } }
function load_all() { $ok = true; $imap_keys = CTableEmail::get_imapkeys(); $mails_users = CTableUser::get_array_email(); $nb_msg = $this->get_nb_msg(); $sql_0 = "INSERT INTO email(id, nom, text, expediteur, destinataire, date, imap) VALUES "; $sql_1 = ""; for($i=$nb_msg; $i>=1 ; $i--) { $info = $this->get_info($i); if(in_array($info['from'], $mails_users) && !in_array($info['message_id'], $imap_keys)) { $res = $this->load($i); $ok = $ok && $res; } } return $ok; }
<?php include("../inc/init.php"); if(!empty($_GET['message_number'])) $message_number = $_GET['message_number']; if(!empty($_GET['passe'])) $passe = $_GET['passe']; $imap = new CImap(CTableConfiguration::get_value_by_element('POP_SERVER'), CTableUser::get_email_admin(), $passe); if(@$imap->connect()) { $info = @$imap->get_info($message_number); $email_id = $imap->load($message_number); echo "Sauvegarde du message " . $message_number; ?> <script type="text/javascript"> $('first').insert({after:'<tr><td><a href="show_reception.php?id=<?php echo $email_id ?>" target="popup" onclick="popup(this.href, this.target, 800, 600);"><?php echo $email_id ?></a></td><td><?php echo CTableGroupe::get_href($info['from']) ?></td><td><?php echo utf8_encode($info['subject']) ?></td><td><?php echo CDate::date_switch(CDate::formate_date($info['date'])) ?></td><td align="center" class="info etat <?php echo 'etat_0'?>"><div class="bulle"><img src="../img/publish_x.png" alt="Non lu" /> Non lu<br /><a href="reception.php?a=2&id=<?php echo $email_id ?>&etat=1"><img src="../img/publish_g.png" alt="Lu" /> Lu</a><br /><a href="reception.php?a=2&id=<?php echo $email_id ?>&etat=2"><img src="../img/publish_u.png" alt="Archivé" /> Archivé</a></div></td></tr>'}); </script> <?php } else { echo "Echec de chargement du message " . $message_number; } ?> <a href="show_reception.php?id=<?php echo stripslashes($email['id']) ?>" target="popup" onclick="popup(this.href, this.target, '800', '600');"> <?php echo $email['id'] ?> </a>
$zColIdUser = '******'; $zTableGroupe = 'gr_groupe'; } $zStr = 'destinataire'; $zSqlText = "SELECT text FROM " . $zTableGroupe . " WHERE nom ='" . str_replace ("'", "''", $oEmail[$zStr]) . "'"; $zResSQLText = mysql_query($zSqlText); $zResUsers = mysql_fetch_array($zResSQLText); $zStr = 'text'; $toUsers = explode("|", $zResUsers[$zStr]); if (sizeof($toUsers) > 0) { foreach ($toUsers as $zUser) { // Par défaut l'adresse mail est à vérifier $mail_checked = 0; $email_to_check = ($zColIdUser == 'retour_email_id_user') ? CTableUser::get_element($zUser, "email") : CTableGrUser::get_element($zUser, "email"); // Vérification des adresses mails if(mailCheck($email_to_check)){ $zStr = 'id'; $zSql2 = "SELECT COUNT(*) AS COUNT FROM retour_email WHERE retour_email_id_email ='".$oEmail[$zStr]."' AND " . $zColIdUser . " ='".$zUser."'"; $zResSQL = mysql_query($zSql2); $oResult = mysql_fetch_array($zResSQL); $iNbRowMatch = $oResult['COUNT']; if ( (int)($iNbRowMatch) > 0 ) { $zSql3 = "UPDATE retour_email SET retour_email_statut = '1', retour_email_lien='0' WHERE retour_email_id_email ='".$oEmail[$zStr]."' AND " . $zColIdUser . " ='".$zUser."'"; mysql_query($zSql3); } else { $zSql3 = "INSERT INTO retour_email (retour_email_id_email, " . $zColIdUser . ", retour_email_statut, retour_email_lien) VALUES ('" . $oEmail[$zStr] . "', '" . $zUser . "', '1', '0')";
} $obj->update(); array_push($tab_user, $id_user); } else { $obj = new CTableUser(array( 'nom'=>CFunction::clean_user_input($nom), 'prenom'=>CFunction::clean_user_input($prenom), 'societe'=>CFunction::clean_user_input($societe), 'adresse'=>CFunction::clean_user_input($adresse), 'cp'=>CFunction::clean_user_input($cp), 'ville'=>CFunction::clean_user_input($ville), 'email'=>CFunction::clean_user_input($email), 'telephone'=>CFunction::clean_user_input($telephone), 'mobile'=>CFunction::clean_user_input($mobile), 'web'=>CFunction::clean_user_input($web), 'pays'=>CFunction::clean_user_input($code_pays), 'civilite'=>CFunction::clean_user_input($id_civilite), 'etat'=>1, 'login'=>$login, 'passe'=>$passe)); //pour limiter le nombre d'import if(CTableUser::is_max()) { //erreur de type nb max utilisateurs atteint $msginfo = "Impossible d'ajouter un nouvel utilisateur car le nombre maximum d'enregistrements autorisés est atteint : " . CTableConfiguration::get_value_by_element('MAX_NUMBER_USER'); $a = 0; break; }
<th><a href="?order=date">Date</a></th> <th><a href="?order=heure">Horaire</a></th> <th><a href="?order=type">Type</a></th> <th>Nom Utilisateur</th> <th><a href="?order=prenom">Prenom</a></th> <th>Pays</th> <th align="left"><a href="?order=telephone">Téléphone</a></th> <th align="left">Com.</th> <th><a href="?order=etat">Effectué</a></th> <th>Modif</th> <th title="suppr"> Suppr </th> </tr> <?php $i = 0; while ($rdv = mysql_fetch_array($r_rdv)) { $tuser = new CTableUser(array('id'=>$rdv['iduser'])); $user = $tuser->select_row(); ?> <tr> <td align="center"><a href="?a=5&id=<?php echo $rdv['id'] ?>"><?php echo $rdv['id'] ?></a></td> <td><?php echo $rdv['nom']; ?></td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($rdv['date'])) ?></td> <td align="center"><?php echo $rdv['heure'] ?></td> <td align="center"><?php echo $rdv['type']==0 ? "Téléphone" : ($rdv['type']==1 ? "Skype" : "Domicile") ?></td> <td align="center"><?php echo @$rdv['nomuser'] ?></td> <td align="center"><?php echo @$rdv['prenom'] ?></td> <td style="text-align: center;"><?php echo $user['pays']; ?></td> <td><?php echo @$rdv['telephone'] ?></td> <?php if($user['commentaire']) { ?>
<a href="envoi.php?a=2&id=<?php echo $email['id'] ?>&etat=2"><img src="../img/publish_u.png" alt="Archivé" /> Archivé</a> <?php } else { ?> <img src="../img/publish_u.png" alt="Archivé" /> Archivé <?php } ?> <br /> <?php if($email['etat'] != 3) { ?> <a href="envoi.php?a=2&id=<?php echo $email['id'] ?>&etat=3"><img src="../img/publish_q.png" alt="Fuile d'attente" /> File d'attente</a> <?php } else { ?> <img src="../img/publish_q.png" alt="File d'attente" /> File d'attente <?php } ?> </div></td> <td align="center"><?php if($email['etat'] == 0) { ?> <a href="envoi.php?id=<?php echo $email['id'] ?>&a=5">>></a> <?php } ?></td> <td align="center"><a href="envoi.php?id=<?php echo $email['id'] ?>&a=7">>></a></td> <td align="center"><?php echo CHtmlSession::get_delbutton($a, $email['id'], $id, CTableUser::is_admin($_SESSION['idmbr'])) ?></td> </tr> <?php } ?> </table> <?php } ?> <?php //---------------------------------------------------------------------------------------------- // AJOUT //---------------------------------------------------------------------------------------------- ?> <?php if($a == 4) { ?> <form id="form_ajout" method="post" action="envoi.php" enctype="multipart/form-data"> <p> <?php echo CForm::get_hidden(44) ?> </p> <fieldset> <legend>Formulaire d'ajout d'email</legend> <p>
/*--------------------------------------------------------------------- PROTECTION : permet de proteger la texte avec session ----------------------------------------------------------------------*/ CLogin::page_protect(); $a = $_REQUEST['a'] + 0; $id = (!empty($_REQUEST['id']))?$_REQUEST['id']:0; $bIsGrGrp = (!empty ($_REQUEST['isGr'])) ? $_REQUEST['isGr']: 0; $destinataire = (!empty($_REQUEST['id_groupe']))?trim($_REQUEST['id_groupe']):''; $id_texte = (!empty($_REQUEST['id_texte']))?$_REQUEST['id_texte']:0; $date = (!empty($_REQUEST['date']))?trim($_REQUEST['date']):''; $id_campagne = (!empty($_REQUEST['id_campagne']))? trim($_REQUEST['id_campagne']):''; $nom = (!empty($_REQUEST['nom']))?trim($_REQUEST['nom']):''; $expediteur = CTableUser::get_email_admin(); $periode = 0; $zDateNow = date("Ymd"); $zDateNowBar = date("Y/m/d"); $texte = CBdd::select_row('SELECT * FROM texte WHERE id = '.$id_texte); if($a == 44 || $a == 55) { $campagne = CTableEmail::checkDouble($id, $destinataire, $texte['nom'], $date); $sql = "SELECT date FROM email WHERE `date` > '".$date."' AND id_campagne = ".$id_campagne; $res = CBdd::select($sql); if(!preg_match('/(\d{4})-(\d{2})-(\d{2})/', $date)){ echo 'DATE_ERROR', ',', 0;
/*--------------------------------------------------------------------- IMPORTATIONS ----------------------------------------------------------------------*/ include_once("../inc/init.php"); /*--------------------------------------------------------------------- VARIABLES HTTP ----------------------------------------------------------------------*/ $idart = !empty($_GET['idart']) ? $_GET['idart'] : 0; /*-------------------------------------------------------------------- TRAITEMENTS ----------------------------------------------------------------------*/ echo CForm::get_option($idart, 'page', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND text LIKE \'%<!--GALERIE-->%\' AND idart = ' . $idart : ' idreda = ' . $_SESSION['idmbr'] . ' AND text LIKE \'%<!--GALERIE-->%\' AND idart = ' . $idart)); ?> <?php session_start(); /*--------------------------------------------------------------------- IMPORTATIONS ----------------------------------------------------------------------*/ include_once("../inc/init.php"); /*--------------------------------------------------------------------- VARIABLES HTTP ----------------------------------------------------------------------*/ $idart = !empty($_GET['idart']) ? $_GET['idart'] : 0; /*-------------------------------------------------------------------- TRAITEMENTS ----------------------------------------------------------------------*/ echo CForm::get_option($idart, 'page', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND text LIKE \'%<!--GALERIE-->%\' AND idart = ' . $idart : ' idreda = ' . $_SESSION['idmbr'] . ' AND text LIKE \'%<!--GALERIE-->%\' AND idart = ' . $idart)); ?>
<p> <label style="padding-right:0;">URL (http://)</label> <input id="url" name="url" type="text" value="<? if (($url_ok=='NULL') or ($url_ok=='')) echo 'communesgenevoises.ch'; else echo $url_rpl;?>" style="width:150px;padding-left:2px;color: #003399;font-family: sans-serif;font-size: 11px;"/> <? echo CHtml::get_msginfo($error_signe['url'])?> </p> <? // Centre ?> </div> <div class="floatleft margin-left"> <h2>Informations personnelles</h2> <p> <label>Secteur</label> <select name="nom_sec" onchange="load_secteur(document.forms['form_ajout'].elements['nom_sec'].options[document.forms['form_ajout'].elements['nom_sec'].selectedIndex].value, 'form_ajout');"> <option value="0" >Secteur</option> <? echo utf8_encode(CForm::get_option($nom_sec, 'secteur', 'id_sec', 'nom_sec', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr'])); ?> </select> <? echo CHtml::get_msginfo($error_signe['nom_cat'])?> </p> <p id="cat"> </p> <p> <label>Grouper dans</label> <select name="id_groupe" id="id_groupe"> <option value="0" >Choisir groupe</option> <? echo CForm::get_option($id_groupe, 'groupeUtilitaire', 'id', 'nom', ' etat = 1') ?> </select> <? echo CHtml::get_msginfo($error_signe['id_groupe'])?> </p> <p> <label>Résponsable </label>
<?php } ?> <?php //---------------------------------------------------------------------------------------------- // AJOUT //---------------------------------------------------------------------------------------------- ?> <?php if($a == 4) { ?> <form id="form_ajout" method="post" action="cat.php" enctype="multipart/form-data"> <p> <?php echo CForm::get_hidden(44) ?> </p> <fieldset> <legend>Formulaire d'ajout de menu </legend> <p id="menu"> <label>Secteur</label> <select name="idcat"> <?php echo CForm::get_option($idcat, 'secteur', 'id_sec', 'nom_sec', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr']); ?> </select> <?php echo CHtml::get_msginfo($error_signe['idcat'])?> </p> <p> <label>Titre </label> <input name="nom" type="text" value="<?php echo $nom ?>" /> <p> <input name="creer" type="submit" value="Ajouter >>"/> </p> </fieldset> </form> <?php } ?> <?php //----------------------------------------------------------------------------------------------
<label>Menu </label> <select name="idcat" onchange="update_select_art(document.forms['form_ajout'].elements['idcat'].options[document.forms['form_ajout'].elements['idcat'].selectedIndex].value, 'form_ajout');"> <option value="0">Choisir le menu</option> <?php echo CForm::get_option($idcat, 'categorie', 'id', 'nom', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr']); ?> </select> <?php echo CHtml::get_msginfo($error_signe['idcat'])?></p> <p> <label>Sous-menu </label> <select name="idart" id="idart" onchange="update_page(document.forms['form_ajout'].elements['idart'].options[document.forms['form_ajout'].elements['idart'].selectedIndex].value, 'form_ajout');"> <?php echo CForm::get_option($idart, 'article', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND idcat = ' . $idcat : ' idreda = ' . $_SESSION['idmbr'] . ' AND idcat = ' . $idcat)); ?> </select> </p> <p> <label>Page </label> <select name="idpage" id="idpage"> <?php echo CForm::get_option($idpage, 'page', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND idart = ' . $idart : ' idreda = ' . $_SESSION['idmbr'] . ' AND idart = ' . $idart)); ?> </select> <?php echo CHtml::get_msginfo($error_signe['page'])?></p> <p> <label>Date </label> <input id="dateevent" name="dateevent" type="text" value="<?php echo $dateevent ?>" /> <?php echo $error_signe['dateevent']?> </p> </div> <hr class="clearfloat" /> <!--<p> <label>Texte défilant</label> <input name="text" type="text" value="<?php echo $text?>" /> <?php echo CHtml::get_msginfo($error_signe['text'])?> </p> <p>
<?php //---------------------------------------------------------------------------------------------- // MODIF //---------------------------------------------------------------------------------------------- ?> <?php if($a == 5) { ?> <form id="form_modif" method="post" action="categorie.php" enctype="multipart/form-data"> <p> <?php echo CForm::get_hidden(55) ?> </p> <p> <?php echo CForm::get_hidden($id, 'id') ?> </p> <fieldset> <legend>Formulaire de modification de menu </legend> <p> <label>Titre </label> <input name="nom" type="text" value="<?php echo $nom?>" /> <?php echo CHtml::get_msginfo($error_signe['nom'])?> </p> <?php if(CTableUser::is_admin($_SESSION['idmbr'])) { ?> <p> <label>Rédacteur</label> <select name="idreda"> <?php echo CForm::get_option($idreda, 'user', 'id', 'login', ' type = 1 OR type = 2') ?> </select> <?php echo CHtml::get_msginfo($error_signe['idreda'])?> </p> <?php } ?> <p> <label>Membre</label> <select name="idlecteur"> <option value="all" <?php echo CForm::get_selected($idlecteur, 'all'); ?>>public</option> <option value="0" <?php echo CForm::get_selected($idlecteur, '0'); ?>>tous les membres</option> <?php echo CForm::get_option($idlecteur, 'user', 'id', 'login', ' type = 0 OR type = 3') ?> </select> <?php echo CHtml::get_msginfo($error_signe['idreda'])?> </p>
<p> <label>Relever les</label> <input name="nb_traitement" type="text" id="nb_traitement" value="<?php echo $nb_traitement ?>"/> derniers messages ( Par défaut et Maximum : <?php echo MAIL_MAX_RECEPT ?>) </p> <p> <input name="creer" type="submit" value="Relever >>"/> </p> </fieldset> </form> <?php } ?> <?php if($a==44) { for($i = $nb_msg; $i >= $nb_msg - $nb_traitement; $i--) { ?> <script type="text/javascript">$('over').innerHTML = "Accès au message <?php echo $i ?>";</script><?php $mails_users = CTableUser::get_array_email(); $imap_keys = CTableEmail::get_imapkeys(); $info = $imap->get_info($i); if(in_array($info['from'], $mails_users) && !in_array($info['message_id'], $imap_keys)) { ?> <script type="text/javascript"> $('over').innerHTML = "Demande de sauvegarde du message <?php echo $i ?>"; new Ajax.Updater('over', 'load_mail.php?passe=<?php echo $passe ?>&message_number=<?php echo $i ?>', {evalScripts:true}); </script><?php } else { ?> <script type="text/javascript">$('over').innerHTML = "Rien à faire pour le message <?php echo $i ?>";</script><?php } } $imap->close(); } ?> </div> </div>
<th align="left">Nom</th> <th>Emplacement</th> <th>Date d'ajout </th> <th>Modif</th> <th title="suppr"> Suppr </th> </tr> <?php $i = 0; foreach (CUserFile::sort($arr_urlrep) as $urlrep) { $info_file = CUserFile::get_info_file($urlrep); $file_name = $info_file['name']; $file_mtime= $info_file['mtime']; $file_type = $info_file['type']; $file_url = $info_file['url']; $file_base = $info_file['base']; $actif_btn = CTableUser::is_admin($_SESSION['idmbr'])?1:0; ?> <tr> <td><a href="fichier.php?a=66&url_base_fils=<?php echo $file_url ?>&url_base=<?php echo $file_base ?>"><?php echo $file_name ?></a></td> <td align="center"><?php echo $file_url ?></td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($file_mtime)) ?></td> <td align="center"><?php echo CHtml::get_editbutton($urlrep, $actif_btn) ?></td> <td align="center"><?php echo CHtml::get_delbutton($a, $urlrep, $id, $actif_btn) ?></td> </tr> <?php } ?> </table> <?php } ?> <?php //---------------------------------------------------------------------------------------------- // AJOUT //----------------------------------------------------------------------------------------------
<td align="center"> <?php echo CHtmlUser::get_etat_contact($user['id'], $user['etat_contact'], 0) ?> <!--<?php echo !$user['etat_contact'] ? "NC" : ($user['etat_contact'] == 1 ? "C" : ($user['etat_contact'] == 2 ? "NI" : "A")) ?>--> </td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($user['date'])) ?></td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($rdv['date'])) ?></td> <td align="center"><?php echo $rdv['heure'] ?></td> <td align="center"><?php echo $rdv['type']==0 ? "Téléphone" : ($rdv['type']==1 ? "Skype" : "Domicile") ?></td> <td align="center"><a href="gr_user.php?a=5&id=<?php echo $user['id'] ?>" target="_parent"><img src="../img/b_edit.png" alt="modifier, afficher" /></a></td> <td align="center"> <?php if($user['type']==2) { echo ' '; } else { echo CHtmlSession::get_delbutton($a, $user['id'], $id, CTableUser::is_admin($_SESSION['idmbr'])); } ?> </td> <td align="center"><a href="envoi.php?destinataire=<?php echo $user['email'] ?>&a=4" target="_parent">>></a></td> <td> <?php if($user['type']==2) { ?> <?php } else { ?> <input type="checkbox" name="ids[]" class="id_del" value="<?php echo $user['id'] ?>"/> <?php } ?>
<? //---------------------------------------------------------------------------------------------- // MODIF //---------------------------------------------------------------------------------------------- ?> <? if($a == 5) { ?> <form id="form_modif" method="post" action="departement.php" enctype="multipart/form-data"> <p> <? echo CForm::get_hidden(55) ?> </p> <p> <? echo CForm::get_hidden($id, 'id') ?> </p> <fieldset> <legend>Formulaire de modification de menu </legend> <p id="menu"> <label>Pays</label> <select name="pays"> <? echo CForm::get_option($pays, 'pays', 'code', 'nom', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr']); ?> </select> <? echo CHtml::get_msginfo($error_signe['pays'])?> </p> <p> <label>Titre </label> <input name="nom" type="text" value="<? echo $nom ?>" /> <? echo CHtml::get_msginfo($error_signe['nom'])?> </p> <p> <input name="creer" type="submit" value="Modifier >>"/> </p> </fieldset> </form> <? } ?> <!-- InstanceEndEditable --></div>
} ?> </td> <td align="center"><?php echo $user['pays'] ?></td> <td align="center"><?php echo date("d-m-20y", strtotime($user['date']));?></td> <td align="center"><?php echo CHtmlUser::get_etat_contact($user['id'], $user['etat_contact'], 0) ?></td> <td align="center">R<?php echo $user['relance']; ?></td> <td style="text-align: center;"><?php echo $opp_num[$user['idopportunite']]; ?></td> <?php if ($user['commentaire']) { ?> <td align="center" class="info"><div class="bulle"><?php echo nl2br($user['commentaire']) ?></div></td> <?php } else { ?> <td align="center"></td> <?php } ?> <td><?php echo (CTableUser::is_admin($_SESSION['idmbr']) && !CTableUser::is_admin($user['id'])) ? CHtmlSession::get_etat($user['id'], $user['etat'], $user['id']) : CHtml::get_etat($user['id'], $user['etat']) ?></td> <td align="center"><?php echo CHtmlSession::get_editbutton($user['id'], $user['id']) ?></td> <td align="center"><?php echo (CTableUser::is_admin($_SESSION['idmbr']) && !CTableUser::is_admin($user['id'])) ? CHtmlSession::get_delbutton($a, $user['id'], $id, $user['id']) : CHtml::get_delbutton($a, $user['id'], $id) ?></td> <td><a href="envoi.php?destinataire=<?php echo $user['email'] ?>&a=4&isGr=1">>></a></td> <td align="center"><?php if(CBdd::select_one("SELECT count(id) AS nb_reponse FROM reponse WHERE iduser = "******"../src/reponse.php?id=<?php echo $user['id'] ?>" target="popup" onclick="popup(this.href, this.target, '600', '500'); return false;"> >> </a> <?php } ?></td> <td align="center"><input class="caseacocher" name="tab_user[<?php echo $i ?>]" type="checkbox" id="contact[<?php echo $i ?>]" value="<?php echo $user['id'] ?>" checked /></td> </tr> <?php $i++; } ?> </table> <?php //---------------------------------------------------------------------------------------------- // GROUPE //---------------------------------------------------------------------------------------------- ?> <div class="floatright">
$liste_user_new = implode("|", $tab_user_new); $groupe = new CTableGroupe(array('id' => $id_groupe, 'text' => $liste_user_new)); $groupe->update(); $msginfo = "Enregistrement bien effectué"; break; case 8 : // Modifier etat contact if(!empty($_GET['id'])) $id = $_GET['id']; $use = new CTableUser(array('id' => $id)); $use->reverse_etat_contact(); break; case 9 : // Modifier opportunité if(!empty($_GET['id'])) $id = $_GET['id']; if(!empty($_GET['idopportunite'])) $idopportunite = $_GET['idopportunite']; $use = new CTableUser(array('id' => $id, 'idopportunite' => $idopportunite)); $use->update(); break; } function forceGetOrPost ($_zVarName, $_zDefault = '') { if (isset ($_GET[$_zVarName])) { return $_GET[$_zVarName]; } elseif (isset ($_POST[$_zVarName])) { return $_POST[$_zVarName]; } else { CSession::get($_zVarName, $_zDefault); }
function send_mail($destinataire, $sujet, $message, $expediteur, $arr_pj = array(), $headers='', $ct="text/html") { $nom = CTableUser::get_name_by_email($expediteur); $mail = new CNmail(); if(is_array($destinataire) && count($destinataire) > 1) { $destinataire = array_unique($destinataire); // Dédoublement des destinataires foreach($destinataire as $_dest) { if($_dest <> $expediteur) { // Evite que l'administrateur recoit 2 mail $mail->addTo($_dest); } } } else { $mail->addTo($destinataire); } $mail->setSubject($sujet); $mail->setFrom($expediteur, $nom); $mail->setTextBody($message); $mail->setHtmlBody($message); if(!empty($arr_pj[0])) { foreach($arr_pj as $url_file) { $mail->addAttachement($url_file); } } return $mail->send(); /* // instanciation de la classe $mail = new CMail(); // parametres $mail->to = $destinataire; $mail->subject = $sujet; $mail->body = $message; $mail->from = $expediteur; $mail->headers = $headers; $mail->type; // ouverture et lecture du fichier if(!empty($arr_pj[0])) { foreach($arr_pj as $url_file) { $file = file_get_contents($url_file); $mail->attach($file, basename($url_file)); } } // envoi du message return ($mail->send()); */ }
if(CBdd::insert($sql)) { $msginfo = $msgconfirm; /**/ if($iduser = CBdd::select_one("SELECT id FROM user WHERE email = '" . $expediteur . "'", "id")) { /*$sql = "UPDATE user SET nom = '" . htmlentities(addslashes($nom),ENT_COMPAT ,'UTF-8') . "', prenom = '" . htmlentities(addslashes($prenom),ENT_COMPAT ,'UTF-8') . "', ville = '', pays = '".$pays."', telephone = '' WHERE email = '" . htmlentities(addslashes($expediteur),ENT_COMPAT ,'UTF-8') . "'"; CBdd::update($sql);*/ } else { $login = CTableUser::create_login($nom); $passe = CFonction::get_password(); $sql1 = "INSERT INTO user(id, login, passe, nom, prenom, ville, pays, email, telephone) VALUES(NULL, '" . $login . "', '" . $passe . "', '" . htmlentities(addslashes($nom),ENT_COMPAT ,'UTF-8') . "', '" . htmlentities(addslashes($prenom),ENT_COMPAT ,'UTF-8') . "', '', '".$pays."', '" . htmlentities(addslashes($expediteur),ENT_COMPAT ,'UTF-8') . "', '')"; if(!CBdd::insert($sql1)) exit; } /**/ } else { $msginfo = $msgerreur; } }
static function is_admin($userid) { $usertype = CTableUser::get_usertype($userid); if($usertype == 2) $ok = true; else $ok = false; return $ok; }
<?php session_start(); /*--------------------------------------------------------------------- IMPORTATIONS ----------------------------------------------------------------------*/ include_once("../inc/init.php"); /*--------------------------------------------------------------------- VARIABLES HTTP ----------------------------------------------------------------------*/ $idcat = !empty($_GET['idcat']) ? $_GET['idcat'] : 0; $idart = 0; /*-------------------------------------------------------------------- TRAITEMENTS ----------------------------------------------------------------------*/ ?> <option value="0">Choisir le sous-menu</option> <?php echo CForm::get_option($idart, 'article_cat', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND idcat = ' . $idcat : ' idreda = ' . $_SESSION['idmbr'] . ' AND idcat = ' . $idcat)); ?>
function create_login($nom) { $login = ''; $id = null; do { list($usec, $sec) = explode(' ', microtime()); $init = (float) $sec + ((float) $usec * 100000); mt_srand($init); $rand = mt_rand(); $salt = strtolower(substr(md5($rand),0,5)); $login = CFunction::chaine_to_ascii($nom).'_'.$salt; $id = CTableUser::get_id($login); } while($id); return $login; }
<?php $oFCKeditor = new FCKeditor('text') ; $oFCKeditor->BasePath = '../plug/fckeditor/'; $oFCKeditor->Value = $text; $oFCKeditor->Height = '300'; $oFCKeditor->Width = '850'; $oFCKeditor->Config['EditorAreaCSS'] = ''; $oFCKeditor->ToolbarSet = 'Page'; $oFCKeditor->Create() ; ?> <?php echo CHtml::get_msginfo($error_signe['text'])?></p> <p> <label>Publier </label> <input type="radio" name="etat" value="0" <?php echo CForm::get_checked($etat,0) ?> <?php echo (CTableUser::is_admin($_SESSION['idmbr'])) ? "" : "disabled = 'disabled'" ?>/> non <input type="radio" name="etat" value="1" <?php echo CForm::get_checked($etat,1) ?> <?php echo (CTableUser::is_admin($_SESSION['idmbr'])) ? "" : "disabled = 'disabled'" ?>/> oui <?php echo $error_signe['etat']?></p> <p> <input name="creer" type="submit" value="Modifier >>"/> </p> </fieldset> </form> <?php } ?> <!-- InstanceEndEditable --></div> </div> <hr class="clearfloat" /> </div> </div> </body> <!-- InstanceEnd --></html>
$obj = new CTableGroupe(array('id'=>$_SESSION['id_groupe'])); $obj->delete_user($id); break; case 5 : // Modifier 1 break; case 6 : // Filtrer CSession::save($_GET); break; case 7 : if(!empty($_POST['ids'])) $ids = $_POST['ids']; if(is_array($ids)) { foreach($ids as $id) { $obj = new CTableUser(array('id'=>$id)); $obj->delete(); } } $a = 0; break; } /*------------------------------------------------------ A FAIRE DANS TOUS LES CAS --------------------------------------------------------*/ $filtre_etat_contact = CSession::get('filtre_etat_contact', $etat_contact); $filtre_date_debut = CDate::date_switch(CSession::get('filtre_date_debut')); $filtre_date_fin = CDate::date_switch(CSession::get('filtre_date_fin')); $filtre_id_groupe = CSession::get('filtre_id_groupe', $id_groupe);
//---------------------------------------------------------------------------------------------- ?> <?php if($a == 5) { ?> <form id="form_modif" method="post" action="article.php"> <p> <?php echo CForm::get_hidden(55) ?> </p> <p> <?php echo CForm::get_hidden($id, 'id') ?> </p> <fieldset> <legend>Formulaire de modification de sous-menu</legend> <p> <label>Titre </label> <input name="nom" type="text" value="<?php echo $nom?>" /> <?php echo CHtml::get_msginfo($error_signe['nom'])?></p> <p> <label>Menu </label> <select name="idcat"> <?php echo CForm::get_option($idcat, 'categorie', 'id', 'nom', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr']); ?> </select> <?php echo CHtml::get_msginfo($error_signe['idcat'])?> </p> <p> <label>Publier </label> <input type="radio" name="etat" value="0" <?php echo CForm::get_checked($etat,0) ?> />non <input type="radio" name="etat" value="1" <?php echo CForm::get_checked($etat,1) ?> />oui <?php echo $error_signe['etat']?></p> <p> <input name="creer" type="submit" value="Modifier >>"/> </p> </fieldset> </form> <?php } ?> <!-- InstanceEndEditable --></div> </div> <hr class="clearfloat" />
*/ include("../inc/init.php"); $id = isset($_REQUEST['a'])?$_REQUEST['a']:0; // Id de la table email $mail = isset($_REQUEST['m'])?$_REQUEST['m']:''; // Adresse mail $url = isset($_REQUEST['u'])?$_REQUEST['u']:''; // Lien dans le mail automatique if($id > 0) { $zQuery = "SELECT id_groupe, type_envoi FROM email WHERE id = " . $id; $tzData = mysql_fetch_assoc (mysql_query ($zQuery)); if ( ($tzData['type_envoi'] == TYPE_ENVOI_GROUPE) || ($tzData['type_envoi'] == TYPE_ENVOI_USER) ) { $zColIdUser = '******'; $zTableUser = '******'; $user_id = CTableUser::get_id_by_email($mail); } else { $zColIdUser = '******'; $zTableUser = '******'; $user_id = CTableGrUser::get_id_by_email($mail); } // Par précaution sur l'existence de l'utilisateur dans la base if ( $user_id != '' ){ $zSql2 = "SELECT COUNT(*) AS num FROM retour_email WHERE retour_email_id_email ='".$id."' AND " . $zColIdUser . " ='".$user_id."'"; $iNbRowMatch = CBdd::select_one($zSql2,'num'); if ((int)($iNbRowMatch) > 0) { $zSql3 = "UPDATE retour_email SET retour_email_statut='2', retour_email_lien='1' WHERE retour_email_id_email ='".$id."' AND " . $zColIdUser . " = ". $user_id; $resUpdate = CBdd::update($zSql3);