static function insert_grp($grp,$nbfic,$inbml,$etat=1) { $date = date("Y-m-d H:i:s"); $zSql = " INSERT INTO moul_groupes (id,nom,fichiers,mails,date_creation,etat) "; $zSql .= " VALUES ('','" . $grp . "','" . $nbfic . "','" . $inbml . "','" . $date . "','" . $etat . "') "; CBdd::insert($zSql); }
static function insert($gp,$zfic) { $date = date("Y-m-d H:i:s"); $zSql = " INSERT INTO moul_gpficmail (idgf,grp,fic,dateCreation) "; $zSql .= " VALUES ('','" . $gp . "','" . $zfic . "',' " . $date . "') "; CBdd::insert($zSql); }
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); }
function insert() { $insert = ''; $values = ''; $where = ''; $date = (@$this->table['date']) ? $this->table['date'] : date("Y-m-d H:i:s"); if(!empty($this->table['idcat'])) { $where = " where idcat = " . $this->table['idcat']; } else if (!empty($this->table['idart'])) { $where = " where idart = " . $this->table['idart']; } else if (!empty($this->table['idgal'])) { $where = " where idgal = " . $this->table['idgal']; } else if (!empty($this->table['id_page'])) { $where = " where id_page = " . $this->table['id_page']; } $arr_key = array_keys($this->table); foreach($arr_key as $key) { if($key != 'tablename' && $key != 'rang' && $key != 'date') { $insert = $insert . "," . $key; $values = $values . ",'" . @$this->table[$key] . "'"; } } $table_list = array('categorie', 'article', 'page', 'pdf', 'reference', 'image', 'galerie', 'video', 'faqs', 'question'); if(in_array($this->table['tablename'], $table_list)) { $sql1 = "select max(rang)+1 as nextrang from " . $this->table['tablename'] . $where; $nextrang = CBdd::select_one($sql1, 'nextrang'); $nextrang = $nextrang?$nextrang:1; $insert = $insert . ",rang" ; $values = $values . ",'".$nextrang."'"; } $insert = $insert . ",date"; $values = $values . ",'" . $date . "'"; $insert = substr($insert, 1); $values = substr($values, 1); $sql2 = "INSERT INTO " . $this->table['tablename'] . " (" . $insert . ") VALUES (" . $values . ")"; if(!self::exist()) { $out = CBdd::insert($sql2); $this->table['id'] = $out; return $out; } return false; }
function load($message_number) { $sql_0 = "INSERT INTO email(id, nom, text, expediteur, destinataire, date, imap) VALUES "; $sql_1 = ""; $info = $this->get_info($message_number); $sql_1 = "(null, '". addslashes($info['subject']) . "', '" . addslashes($this->get_text($message_number)) . "', '". $info['from'] . "', '". $info['to'] . "', '". $this->formate_date($info['date']) . "', '". $info['message_id'] . "'),"; $sql = $sql_1 ? trim($sql_0 . $sql_1, ",") : ""; if($sql) { return CBdd::insert($sql); } else { return false; } }
break; } $image = CUserFile::upload_file($files, SS_ADMIN_TO_USERFILE.'/'.$url_dest, $unzip); $line='tmp/'; $position = strpos($image,$line); $depart=$position+4; $image_ = substr($image, $depart, 50); $img = CTraitementGestPhoto::traitFicchier($image); $vignette = CTraitementGestPhoto::traitVign($image); unlink($image); $maxRang = CBdd::select_one("SELECT MAX(rang) as rangMax FROM image" ,"rangMax") ; $iRang = ($maxRang>0) ? $maxRang +1 : 1 ; $img = substr($img,6) ; $vignette = substr($vignette,6) ; $sqlInsert = "INSERT INTO entreprise (image_ent) VALUES ('$vignette')" ; CBdd::insert($sqlInsert) ; } } // FIN TRAITMENT IMAGE if ($date_contact!='0000-00-00 00:00:00') $date = $date_contact; else $date = date("Y-m-d"); // TEST ERREUR SECTEUR CAT ET PAYS COMM OBLIGATOIRE if ($nom_sec == 0) { $error_type5 = 5; $error_signe['nom_sec'] = "*"; } if ($nom_cat == 0) {
function insert2($table, $condition) { $Zsql = "INSERT INTO ".$table." SET ".$condition; $res = CBdd::insert($Zsql); return $res; }
$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); } } // } ?>
$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); } else { $zSql3 = "INSERT INTO retour_email (retour_email_id_email, " . $zColIdUser . ", retour_email_statut, retour_email_lien) VALUES ('".$id."', '".$user_id."', '2', '1')"; $resInsert = CBdd::insert($zSql3); } } // Redirection vers le lien cliqué par le Client header('Location:'.$url); } else { echo 'Lien non trouvé'; } ?>
<?php header('Content-Type: text/html; charset=ISO-8859-1'); include("../inc/init.php"); $motcle = $_POST['type']; $idcat = $_POST['type2']; $Zsql = "INSERT INTO motcle (nom_motcle, cat_motcle) VALUES ( '". htmlentities(addslashes($motcle),ENT_COMPAT ,'UTF-8') . "', " .$idcat. ")"; CBdd::insert($Zsql); $Zsql = "SELECT nom_motcle, id_motcle FROM motcle WHERE cat_motcle=".$idcat; //print_r($Zsql); $requetMot = CBdd::select($Zsql); if ($requetMot){ $i = 0; while ($listeMot = mysql_fetch_array($requetMot)) { $i++; // TRAITEMENT SUPPRESSION // //else $sql = 'DELETE FROM '.$this->table['tablename'].' WHERE (id = '.$this->table['id'].')'; //CBdd::delete($sql); if (($_GET['p']==7) && ($listeMot['id_motcle'] == $_GET['idm'])) { $Zsql = "DELETE FROM motcle WHERE id_motcle =".$listeMot['id_motcle']; CBdd::delete($Zsql); $listeMot['id_motcle']='vide'; } if ($listeMot['id_motcle']!='vide'){ ?> <li class="clear" <? if ($i == 1) echo 'style="border-top:1px solid #e4b097";'; ?> > <span><? echo $listeMot['nom_motcle']?></span> <a href="<? if (($_GET['s']==7) && ($listeMot['id_motcle'] == $_GET['idm'])) echo '?id='.$idcat.'&idm='.$listeMot['id_motcle'].'&a=5&s=7&p=7'; else echo '?id='.$idcat.'&idm='.$listeMot['id_motcle'].'&a=5&s=7' ?>" title="Supprimer" style="width:15px; text-align:center;padding-right:7px"><? if (($_GET['s']=='7') && ($listeMot['id_motcle'] == $_GET['idm'])) echo 'OK?'; else echo '<img src=\'../img/delete.png\' alt=\'delete\' />'; ?></a> </li>
break; case 4 : // --- Ajout affichage $toPieces['id'] = $id ; $toPieces['piece'] = $piece ; $toPieces['etat'] = $etat ; break; case 44 : // --- Ajout traitement $_SESSION['url_base_fils'] = $url_dest; $piece = CFile::upload_file($_FILES['piece'], $url_dest, $unzip, true) ; $toInfos = CFile::get_info_file($piece) ; if (isset($toInfos['size']) && $toInfos['size'] < 10000000) { $sql = "INSERT INTO hbpiecesjointes (id,piece,etat) VALUES ('','" . $piece . "','" . $etat . "')" ; CBdd::insert($sql); $msginfo = "Pieces jointes bien ajoutés" ; $a = 0 ; } else { $msginfo = "La pièce jointe a dépassé 10Mo" ; $a = 4 ; } break; case 5 : // --- Modification affichage $sql = "SELECT * FROM hbpiecesjointes WHERE id = " . $id ; $toPieces = CBdd::select_row($sql); break;
if($valid == 1) { if ($bIsGrGrp == 0){ $obj = new CTableGroupe(array('id'=>$destinataire)); $groupe = $obj->select_row(); } else{ $obj = new CTableGrGroupe(array('id'=>$destinataire)); $groupe = $obj->select_row(); } $zSql = " "; $zSql .= " INSERT INTO email (id,nom,id_groupe,type_envoi,destinataire,expediteur,id_text,id_campagne,text,pj,imap,type,periode,date) " ; $zSql .= " VALUES ('',\"".CFunction::addslashes($texte['nom'])."\",\"".$destinataire."\",\"".$bIsGrGrp."\",\"".$groupe['nom']."\",\"".$expediteur."\"" ; $zSql .= " ,".$texte['id'].",".$id_campagne.",\"".CFunction::addslashes($texte['text'])."\",'','','campagne',0,'".$date."')"; $result = CBdd::insert($zSql); if(!$result) { echo 'INSERT_ERROR, 0'; } else { echo 'Enregistrement réussi'; } } else{ echo 'Cette date est déja passée ou prise'; } break; case 5: // AFFICHAGE POUR MODIFICATION $t_envoi = new CTableEmail(array('id'=>$id));
static function insert($id,$nom,$fic,$date) { $zSql = " INSERT INTO moul_groupes_tmp (tmp_id,tmp_grp,tmp_fic,tmp_date) "; $zSql .= " VALUES (" . $id . "," . $nom . "," . $fic . ",'" . $date . "') "; CBdd::insert($zSql); }
if (!CCaptcha::testCode($_REQUEST['code'])) { echo 'NOT_SECURE'; exit(0); } /*--------------------------------------------------------------------- RECUPERATION ----------------------------------------------------------------------*/ $id_page = !empty($_REQUEST['id_page']) ? $_REQUEST['id_page'] : ""; /*--------------------------------------------------------------------- TRAITEMENTS ----------------------------------------------------------------------*/ $sql1 = "SELECT * FROM question WHERE etat = 1 ORDER BY id"; $res = CBdd::select($sql1); $sql2 = ""; $first= true; $date = date("Y-m-d H:m:s"); while($question = mysql_fetch_array($res)) { $reponse = $_REQUEST['q'.$question['id']]; if($first) $sql2 .= "INSERT INTO reponse(nom, question, date) VALUES" ; else $sql2 .= ","; $sql2 .= "('" . addslashes(trim($reponse)) . "', '" . addslashes(trim($question['nom'])) . "', '" . $date . "')" ; $first = false; } CBdd::insert($sql2); echo "../../inscription/src/formulaire.php?cle=inscription-en-ligne&p=".$id_page."&date=".$date; ?>
static function insert($mail,$file) { $date = date("Y-m-d H:i:s"); $zSql = " INSERT INTO moul_tables_tmp (mtp_id,mtp_iListId,mtp_zMail,mtp_iEtat,mtp_zDateCreation) VALUES('','" . $file . "','" . $mail . "','0','".$date."') "; CBdd::insert($zSql); }
$sql3 = "UPDATE reponse SET iduser = "******" WHERE iduser = 1 AND date = '" . $date . "'"; CBdd::update($sql3); CUserGroupe::insert($iduser, $id_groupe); } else { $login = CFonction::formate_chaine($nom, ''); $passe = CFonction::get_password(); $sql1 = "INSERT INTO user(id, login, passe, nom, prenom, pays, email, telephone) VALUES(NULL, '" . $login . "', '" . $passe . "', '" . addslashes($nom) . "', '" . addslashes($prenom) . "', '" . htmlentities(addslashes($pays),ENT_COMPAT ,'UTF-8') . "', '" . htmlentities(addslashes($expediteur),ENT_COMPAT ,'UTF-8') . "', '" . htmlentities(addslashes($telephone),ENT_COMPAT ,'UTF-8') . "')"; if(!CBdd::insert($sql1)) exit; $iduser = mysql_insert_id(); // Commune $idcom = CCom::recupnomCom('commune', 'id_com', 'nom_com', $ville); if ($idcom) CBdd::update("UPDATE user SET commune_alias=".$idcom." WHERE id=".$iduser.""); else { // Estexiste $where = "nom_comD = '".$ville."', pays ='".$pays."',id_user ='******'"; $idcom = CCom::recupnomCom('communeD', 'id_user', 'id_user', $iduser); if ($idcom) CCom::updatecom2('communeD', $where, 'id_user', $iduser); else CCom::insert('communeD', $where); } $sql3 = "UPDATE reponse SET iduser = "******" WHERE iduser = 1 AND date = '" . $date . "'"; CBdd::update($sql3);
static function insert($name,$zFIc) { $date = date("Y-m-d H:i:s"); $zSql = " INSERT INTO moul_listes (id,nom,fichier,dateajout,etat) VALUES ('','" . $name . "','" . $zFIc . "','" . $date . "','') "; CBdd::insert($zSql); }