static function send($destinataire) { $expediteur = CBdd::select_one("SELECT email FROM user WHERE type = 2", "email"); $id_texte = CConfiguration::get_valeur('WELCOME_TEXT_ID'); $sql_texte_select = "SELECT * FROM texte WHERE id = " . $id_texte; $texte = CBdd::select_row($sql_texte_select); $sql_user = "******" . $destinataire . "'"; $user = CBdd::select_row($sql_user); $message = str_replace('$NOM', $user['nom'], $texte['text']); $message = str_replace('$PRENOM', $user['prenom'], $message); //echo $message; $sujet = $texte['nom']; $sql_unicite_message = "SELECT id FROM email WHERE destinataire = '" . addslashes($destinataire) . "' AND nom = '" . addslashes($sujet) . "'"; // echo $sql_unicite_message; if(CBdd::select_one($sql_unicite_message, 'id')) { return 1; } $sql_email_insert = "INSERT INTO email(expediteur, destinataire, nom, text, etat) VALUES ('" . addslashes($expediteur) . "', '" . addslashes($destinataire) . "', '" . addslashes($sujet) . "', '" . addslashes($message) . "', '2')"; CBdd::insert($sql_email_insert); return CMail::send_mail($destinataire, CFonction::force_stripslashes($sujet), CFonction::force_stripslashes($message), $expediteur, array(), 'Bcc: ' . $expediteur); }
static function get_nbr_fic_of_grp($igrp) { $zSql = " "; $zSql .= " SELECT COUNT(*) AS nbrfic FROM moul_gpficmail "; $zSql .= " WHERE grp = " . $igrp ; $inbf = CBdd::select_one($zSql,'nbrfic'); return $inbf; }
static function get_elm($iIdGpMl) { $zSql = " "; $zSql .= " SELECT nom FROM moul_groupes "; $zSql .= " WHERE id = " . $iIdGpMl; $zNom = CBdd::select_one($zSql,'nom'); return $zNom; }
static function get_option($selectedvalue, $idconfiguration) { $option = ""; $sql = "SELECT choix FROM configuration WHERE id = " . $idconfiguration; $result = CBdd::select_one($sql, "choix"); $choix_possible = explode('|', $result); foreach($choix_possible as $valeur) { $selected = CForm::get_selected($selectedvalue, $valeur); $option = $option . "<option value='" . $valeur . "'" . $selected . ">" . $valeur . "</option>\n"; } return $option; }
static function get_iEmail($zFic = '', $zmail=''){ $zSql = " SELECT COUNT(*) AS emv FROM moul_tables WHERE 1=1 "; if($zFic){ $zSql .=" AND mlt_iListId = '" . $zFic . "'"; } if($zmail){ $zSql .=" AND mlt_zMail = '" . $zmail . "'"; } $iRes = CBdd::select_one($zSql,'emv'); return $iRes; }
public static function test_ficgrpmail_in_campagne($iType=0,$iId=0){ $zSql = " "; $zSql .= " SELECT id_groupe FROM campagne "; if($iType == 2){ $zSql .= " INNER JOIN email ON ( email.id_campagne = campagne.id ) "; $zSql .= " INNER JOIN moul_groupes ON ( moul_groupes.id = email.id_groupe) "; $zSql .= " WHERE email.id_groupe = " . $iId . " AND email.type_groupe = " . $iType; $oRes = CBdd::select_one($zSql,'id_groupe'); if($oRes) return 1; else return 0; } }
static function get_down($tablename, $id, $actif=0) { if($actif) { $sql = "select isendrang_" . $tablename . "(" . $id . ") as ok"; $res = CBdd::select_one($sql, 'ok'); $ret = ($res!=1) ? "<a href=?id=$id&a=1><img src='../img/downarrow.png' alt='down' /></a>" : ""; } else { $sql = "select isendrang_" . $tablename . "(" . $id . ") as ok"; $res = CBdd::select_one($sql, 'ok'); $ret = ($res!=1) ? "<img src='../img/downarrow.png' alt='down' class='grise'/>" : ""; } return $ret; }
function delete_user($md5_id) { $sql = "SELECT email FROM user WHERE md5(id) = '".$md5_id."'"; $user_email = CBdd::select_one($sql, 'email'); $sql = "SELECT * FROM email WHERE destinataire LIKE '%".$email."%'"; $result = CBdd::select($sql); $count = mysql_num_rows($result); if(count($count)) { while($email = mysql_fetch_array($result, MYSQL_ASSOC)) { $destinataire = $email['destinataire']; $destinataire = str_replace($user_email, '', $destinataire); $destinataire = str_replace(array(',,', ';;', ';'), ",", $destinataire); $email['destinataire'] = trim($destinataire, ','); if(empty($destinataire)) { $_email = new CTableEmail(array('id'=>$email['id'])); $_email->delete(); } else { //unset($email[id]); $email['text'] = CFunction::addslashes($email['text']); if(empty($email['id_campagne'])) { $email['id_campagne'] = 0; } if(empty($email['id_groupe'])) { $email['id_groupe'] = 0; } $_email = new CTableEmail($email); $_email->update(); } } } $sql = "DELETE FROM user WHERE md5(id) = '" . $md5_id . "'"; return CBdd::delete($sql); }
static function select_user($cible) { $sql = "SELECT text FROM groupe WHERE id = '" . $cible . "' OR nom = '" . $cible. "'"; $liste_id_user = CBdd::select_one($sql, "text"); $where = ($liste_id_user) ? "id=" . str_replace("|", " OR id=", $liste_id_user) : " id = '-1'"; $sql = "SELECT * FROM user WHERE " . $where; $res = CBdd::select($sql); return $res; }
function recupnomCom($table, $recherche, $condition, $conditionVal ) { $Zsql = "SELECT ".$recherche." FROM ".$table." WHERE ".$condition."='".$conditionVal."'"; $res = CBdd::select_one($Zsql, $recherche); return $res; }
static function get_element($cible, $element_name = "nom") { $sql = "SELECT " . $element_name . " FROM entreprise WHERE id_ent = '" . $cible . "' OR mail_ent = '" . $cible . "' OR nom = '" . $cible . "' OR prenom = '" . $cible . "'"; $element = CBdd::select_one($sql, $element_name); return $element; }
if(!empty($_GET['id_texte'])) $id_texte = trim($_GET['id_texte']); if(!empty($_GET['pj'])) $pj = trim($_GET['pj']); if(!empty($_GET['date'])) $date = trim($_GET['date']); break; case 44 : // Ajouter 2 if(!empty($_POST['destinataire'])) $destinataire = trim($_POST['destinataire']); if(!empty($_POST['id_texte'])) $id_texte = trim($_POST['id_texte']); if(!empty($_POST['pj'])) $pj = trim($_POST['pj']); if(!empty($_POST['date'])) $date = trim($_POST['date']); $liste_email = CTableGroupe::get_liste_email($destinataire); $sql = "SELECT id FROM groupe WHERE nom = '" . $destinataire. "'"; $_id_groupe = CBdd::select_one($sql, "id"); $is_email = CMail::is_email($liste_email); if (!$is_email) { $error_type = 1; $error_signe['destinataire'] = "*"; } if (!CMail::is_email($expediteur)) { $error_type = 2; $error_signe['expediteur'] = "*"; } if (empty($id_texte)) { $error_type = 3; $error_signe['id_texte'] = "*";
<th align="left"><a href="?order=urlCommune">Url</a></th> <th><a href="?order=date_com">Date d'ajout</a></th> <th>Modif</th> <th title="suppr"> Suppr </th> <th><input name="select" type="checkbox" id="select" onclick="reverse_check()" value="" /></th> </tr><?php $i = 0; if ($requetCcom){ while ($listeCom = mysql_fetch_assoc($requetCcom)) { //----------- Owen recuperation nom pays pour commune $sqlNomCat = "select pays FROM departement WHERE id_dep='".$listeCom['departement']."'"; $id_pays = CBdd::select_one($sqlNomCat, 'pays'); $Zsql = "SELECT nom FROM pays WHERE id_pays=".$id_pays; $nom_pays = CBdd::select_one($Zsql, 'nom'); ?> <tr> <td><a href="?a=5&id=<?php echo $listeCom['id_com'] ?>"><?php echo $listeCom['id_com'] ?></a></td> <td><?php echo utf8_encode($listeCom['nom_com']) ?></td> <td><?php echo $listeCom['CP'] ?></td> <td><?php echo $nom_pays ?></td> <td><?php echo $listeCom['urlCommune'] ?></td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($listeCom['date_com'])) ?></td> <td align="center"><a href="commune.php?a=5&id=<?php echo $listeCom['id_com'] ?>" target="_parent"><img src="../img/b_edit.png" alt="modifier, afficher" /></a></td> <td align="center"><?php echo CHtmlSession::get_delbutton($a, $listeCom['id_com'], $id, $listeCom['idreda']) ?></td> <td align="center"><input type="checkbox" name="ids[]" class="id_del" value="<?php echo $listeCom['id_com'] ?>"/></td> </tr> <?php $i++;
?> <table style="width: 500px; margin-left: 1px;" border="1" cellpadding="0" cellspacing="0"> <tr align="center"> <th align="left"><a href="?order=id_dep">id</a></th> <th align="left"><a href="?order=nom">Departemenent</a></th> <th align="left"><a href="?order=pays">pays</a></th> <th>Modif</th> <th title="suppr"> Suppr </th> </tr> <? $i = 0; if($requetPays){ while ($pays = mysql_fetch_array($requetPays)) { $Zsql = "SELECT nom FROM pays WHERE id_pays='".$pays['pays']."'"; $nom = CBdd::select_one($Zsql, 'nom'); //$idcom_=CBdd::select_one($sql_idcom, 'idcom'); ?> <tr> <td><a href="?a=5&id=<? echo $pays['id_dep'] ?>"><? echo utf8_decode($pays['id_dep']) ?></a></td> <td><? echo ucfirst(strtolower(trim($pays['nom']))) ?></td> <td><? echo $nom; ?></td> <td align="center"><? echo CHtml::get_editbutton($pays['id_dep'], $pays['idreda'], $pays['idreda']) ?></td> <td align="center"><? echo CHtmlSession::get_delbutton($a, $pays['id_dep'], $id, $pays['idreda']) ?></td> </tr> <? } ?> </table> <? } }
break; case 555 : // Vider if(!empty($_GET['id'])) $id = $_GET['id']; $tgroupe= new CTableGroupe(array('id'=>$id, 'text'=>'')); $_group = $tgroupe->select_row(); // Owen 01/2011 pour echaper au session de suppression $_SESSION['id']=x; // $nom = $_group['nom']; $id1= $_group['id']; $etat = $_group ['etat']; $sql1 = "SELECT text FROM groupe WHERE id = " . $id1; $text = CBdd::select_one($sql1,'text'); // Owen 01/2011 suppression contact �artir de vider groupe $text1=str_replace("|",",",$text); $tab = explode(",",$text1); $text2=count($tab); for ($i=0; $i<$text2 and $text2!=0; $i++){ if ($tab[$i]!='') CBdd::execute("DELETE FROM user WHERE id = " . $tab[$i]); else $not=1; } $tgroupe->update(); if ($not!=1) $msginfo = "groupe bien vidé"; $a = 0; break; case 5555://confirmer if(!empty($_GET['id'])) $id = $_GET['id'];
<th align="left">Catégorie</th> <th><a href="?order=date_motcle">Date d'ajout</a></th> <th>Modif</th> <th title="suppr"> Suppr </th> </tr> <?php $i = 0; while ($listeCat = mysql_fetch_array($requetCat)) { //----------- Owen recuperation nom secteur pour categorie $sqlNomCat='select nom_sec FROM secteur WHERE id_sec='.$listeCat['cat_motcle']; $secteur=CBdd::select_one($sqlNomCat, 'nom_sec'); // SELECTION CATEGORIE $zsql = "SELECT nom_cat FROM cat where id_cat=".$listeCat['cat_motcle']; $nomCat = CBdd::select_one($zsql, 'nom_cat'); ?> <tr> <td><a href="?a=5&id=<?php echo $listeCat['id_mocle'] ?>"><?php echo $listeCat['id_motcle'] ?></a></td> <td><?php echo $listeCat['nom_motcle'] ?></td> <td><?php echo $nomCat ?></td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($listeCat['date_motcle'])) ?></td> <td align="center"><?php echo CHtmlSession::get_editbutton($listeCat['id_motcle'], $listeCat['idreda']) ?></td> <td align="center"><?php echo CHtmlSession::get_delbutton($a, $listeCat['id_motcle'], $id, $listeCat['idreda']) ?></td> </tr> <?php } ?> </table> <?php } ?> <?php //----------------------------------------------------------------------------------------------
} if($test == 0){ // --- On on le ckeck if(mailCheck($toItm1['mtp_zMail'])){ $date = date("Y-m-d H:i:s"); $zSql = " INSERT INTO moul_tables (mlt_id,mlt_zMail,mlt_iListId,mlt_zDateCreation) " ; $zSql .= " VALUES('','" . $toItm1['mtp_zMail'] . "','" . $toItm1['mtp_iListId'] . "','" . $date . "') " ; CBdd::insert($zSql) ; // Insertion de l'adresse mail dans contact avec comme login, passe et nom le nom du compte $exp_mail = explode('@',$toItm1['mtp_zMail']); // Les adresses valides venant de la Moulinette a pour opportunité : contactmail $zSql = " SELECT id FROM opportunite WHERE nom = 'contactmail'" ; $id_opp = CBdd::select_one($zSql,'id') ; // La civilité par défaut : 1 => Monsieur $zSql = " INSERT INTO user (login,passe,civilite,nom,email,etat_contact,idopportunite,date) " ; $zSql .= " VALUES('" . $exp_mail[0] . "','" . $exp_mail[0] . "','1','" . $exp_mail[0] . "','" . $toItm1['mtp_zMail'] . "','1','" . $id_opp ."','" . $date . "') " ; print ($zSql); CBdd::insert($zSql); } // --- On met à jour le statut du mail pour dire qu'on l'a traité $zSql = " UPDATE moul_tables_tmp SET mtp_iEtat = 2 "; $zSql .= " WHERE mtp_iEtat = 1 AND mtp_id = ".$toItm1['mtp_id']; CBdd::update($zSql); }
function get_nb() { $sql = "SELECT count(id) AS nb FROM " . $this->table['tablename']; $nb = CBdd::select_one($sql, 'nb'); return $nb; }
</div> </fieldset> </form> <form id="modif_envoi" method="post" action="envoi-campagne.php"> <!-- Cadre contextuelle --> <div id="cadre-envoi"> <?php if($nb_envoi > 0) { $campagne = new CTableCampagne(array('id'=>$id)); $envoi = $campagne->get_envoi_1(); $sql = "SELECT DATE_FORMAT(date, '%Y/%m/%d') AS min_range FROM email WHERE date < '".$envoi['date']."' AND id_campagne = ".$envoi['id_campagne']." ORDER BY date DESC LIMIT 0, 1"; $left = CBdd::select_one($sql, 'min_range'); $sql = "SELECT DATE_FORMAT(date, '%Y/%m/%d') AS max_range FROM email WHERE date > '".$envoi['date']."' AND id_campagne = ".$envoi['id_campagne']." ORDER BY date ASC LIMIT 0, 1"; $right = CBdd::select_one($sql, 'max_range'); ?> <fieldset> <legend>Modifier Envoi 1</legend> <p> <label>Type Groupe</label> <span style="font-size:12px">Groupe</span> <input type="radio" id="groupe" name="isGr" value="0" <?php if ($envoi['type_envoi'] == 0) echo 'checked="checked"'; ?> onclick="javascript:location.href='<?= URL_RACINE; ?>adminpanther/src/campagne.php?id=<?php echo $id ?>&a=5&isGr=0'" /> <span style="font-size:12px">Groupe GR</span> <input type="radio" id="groupe_gr" name="isGr" value="1" <?php if ($envoi['type_envoi'] == 1) echo 'checked="checked"'; ?> onclick="javascript:location.href='<?= URL_RACINE; ?>adminpanther/src/campagne.php?id=<?php echo $id ?>&a=5&isGr=1'" /> </p> <p> <label>Nom Groupe</label> <select name="id_groupe"> <?php if ( $envoi['type_envoi'] == 0 ){ echo CForm::get_option($envoi['id_groupe'], 'groupe') ;
static function get_idrdv_of_user($iduser) { return CBdd::select_one("SELECT id FROM rdvContact WHERE iduser="******" LIMIT 1", "id"); }
static function login_ok($login, $passe, $critere = '') { $sql = "SELECT id FROM user WHERE login = '******' AND passe = '" . $passe . "'" . $critere; $id = CBdd::select_one($sql, "id"); if ($id != "") return $id; else return ''; }
function get_id_element_parent($id_sousmenu) { $col = "id" . substr($this->table_parent, 0, 3); $sql = "SELECT id" . substr($this->table_parent, 0, 3) . " FROM " . $this->table . " WHERE id = " . $id_sousmenu; $res = CBdd::select_one($sql, $col); return $res; }
<th align="left"><a href="?order=txt">Textes</a></th> <th align="left"><a href="?order=pj">Pieces-jointes</a></th> <th><a href="?order=date">Date d'ajout</a></th> <th>Publié</th> <th>Modif</th> <th title="suppr"> Suppr </th> </tr> <?php $i = 0; while ($opportunite = mysql_fetch_array($r_opportunite)) { $xzsql = "SELECT nom from texte where id=".$opportunite['texId']; //print_r($xzsql); $text = CBdd::select_one($xzsql,'nom'); $xzsql = "SELECT piece from hbpiecesjointes where id=".$opportunite['pieId']; //print_r($xzsql); $piece= CBdd::select_one($xzsql,'piece'); ?> <tr> <td><a href="?a=5&id=<?=$opportunite['id'] ?>"><?=$opportunite['id'] ?></a></td> <td><?=utf8_encode ($opportunite['nom']); ?></td> <td><?=$text ; ?></td> <td><?=str_replace('../../userfiles/pieces_jointes/', '',$piece); ?></td> <td align="center"><?=CDate::date_switch(CDate::formate_date($opportunite['date'])) ?></td> <td align="center"><?=CHtml::get_etat($opportunite['id'], $opportunite['etat'], $opportunite['id']); ?></td> <td align="center"><?=CHtmlSession::get_editbutton($opportunite['id'], $opportunite['id']) ?></td> <td align="center"><?=CHtml::get_delbutton($a, $opportunite['id'], $id, $opportunite['id']) ?></td> </tr> <?php } ?> </table> <?php } ?>
static function get_element_by_id($id) { $sql = "SELECT nom FROM opportunite WHERE id = " . $id; $res = CBdd::select_one($sql, "nom"); return $res; }
static function get_valeur($nom) { $sql = "SELECT valeur FROM configuration WHERE nom = '" . $nom . "'"; $valeur = CBdd::select_one($sql, 'valeur'); return $valeur; }
function exist() { $sql = 'SELECT id FROM filtre WHERE (REPLACE(text, " ", "") = "' . stripslashes(str_replace(" ", "", $this->table['text'])) . '" OR REPLACE(nom, " ", "") = "' . stripslashes(str_replace(" ", "", $this->table['nom'])) . '") AND nomtable = "' . $this->table['nomtable'] . '"'; $res = CBdd::select_one($sql, "id"); return $res; }
<?php echo utf8_encode($nomCat); ?> </div> </td> <td align="center"><?php if ($user['dateajout_ent'] != "00-00-0000") echo CDate::date_switch($user['dateajout_ent']) ?></td> <td align="center"><?php echo CHtmlUser::get_etat_contact($user['id_ent'], $user['etat_contact'], 0) ?></td> <td style="text-align: center;"> <?php echo $opp_num[$user['idopportunite']]; ?> </td> <td align="center"><a href="contact.php?a=5&id=<?php echo $user['id_ent'] ?>" target="_parent"><img src="../img/b_edit.png" alt="modifier, afficher" /></a></td> <td align="center"><?php echo CHtmlSession::get_delbutton($a, $user['id_ent'], $id, $user['id_ent']) ?></td> <td><a href="envoi.php?destinataire=<?php echo $user['email'] ?>&a=4" target="_parent">>></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_ent'] ?>" target="popup" onclick="popup(this.href, this.target, '600', '500'); return false;"> >> </a> <?php } ?></td> <td><input type="checkbox" name="ids[]" class="id_del" value="<?php echo $user['id_ent'] ?>"/></td> </tr> <?php $i++; } } ?> </table> <p> <?php echo CForm::get_hidden(7); ?> </p> <p> <input type="hidden" name="id_groupe" value="<?php echo $_SESSION['id_groupe']; ?>"/> </p> </form>
function get_nom($id) { $sql = "SELECT nom FROM pays WHERE id = '" . $id . "'"; $res = CBdd::select_one($sql, "nom"); return $res; }
break; } $tart= new CTableArticle(array('nom'=>CFunction::addslashes($nom), 'etat'=>$etat, 'idcat'=>$idcat)); $tart->insert(); $msginfo = "sous-menu bien ajouté"; $a = 0; break; case 5 : // Modifier 1 if(!empty($_GET['id'])) $id = $_GET['id']; $tart= new CTableArticle(array('id'=>$id)); $art = $tart->select_row(); $nom = $art ['nom']; $etat = $art ['etat']; $idcat = $art ['idcat']; $idreda = CBdd::select_one("SELECT idreda FROM article_cat WHERE id = ".$id, 'idreda'); if(!CLogin::protect_action($idreda)) { $a = 0; $msginfo = 'Action non autorisée'; } break; case 55 : // Modifier 2 if(!empty($_POST['id'])) $id = $_POST['id']; if(!empty($_POST['nom'])) $nom = trim($_POST['nom']); if(!empty($_POST['etat'])) $etat = $_POST['etat']; if(!empty($_POST['idcat'])) $idcat = $_POST['idcat']; if ($nom=="") {
CBdd::update("UPDATE page SET etat=0 WHERE text LIKE '%<!--FAQ-->%'"); } break; case 3 : // Supprimer FAQ if(!empty($_GET['id'])) $id = $_GET['id']; break; case 33 : // Supprimer FAQ if(!empty($_GET['id'])) $id = $_GET['id']; $faq = new CTableFaq(array('id'=>$id)); $faq->delete(); // D財ctiver la page FAQ si aucune question n'est plus activ狊 $num_active = CBdd::select_one('SELECT COUNT(id) as active FROM faqs WHERE etat=1', 'active'); if($num_active==0) { CBdd::update("UPDATE page SET etat=0 WHERE text LIKE '%<!--FAQ-->%'"); } break; case 4 : // Ajouter 1 if(!empty($_POST['question'])) $question = trim($_POST['question']); if(!empty($_POST['reponse'])) $reponse = trim($_POST['reponse']); if(!empty($_POST['etat'])) $etat = $_POST['etat']; break; case 44 : // Ajouter 2 if(!empty($_POST['question'])) $question = trim($_POST['question']);