function rearrange($idart) { // CBdd::update('CALL rearrange_galerie('.$idart.');'); $iKey = 1 ; $oRes = CBdd::select('SELECT id FROM galerie WHERE idart = ' . $idart . ' ORDER BY rang') ; while ($tiItems = mysql_fetch_assoc($oRes)) { CBdd::execute("UPDATE galerie SET rang = " . $iKey . " WHERE id=" . $tiItems['id']) ; $iKey++ ; } }
function sql($sqlfile){ $ok = true; $file = file_get_contents($sqlfile); // $file = ereg_replace("#;[^'a-zA-Z0-9\"]+#", ";///", $file); $arr_req = explode("///", $file); foreach($arr_req as $req) { if(trim($req)) { if(!ereg('DROP|ALTER|INSERT',$req)) $this->nb_elts ++; $out = CBdd::execute($req); $ok = $ok && $out; } } return $ok; }
function reverse_etat_contact() { $sql = "UPDATE entreprise SET etatcontact_ent=abs(etatcontact_ent-1) WHERE id_ent = " . $this->table['id']; $res = CBdd::execute($sql); return $res; }
function down_rang() { $nom_table=$this->table['tablename']; if ($this->table['tablename'] == 'cat') $id=$this->table['id_cat']; else if ($this->table['tablename'] == 'commune') $id=$this->table['id_com']; else if ($this->table['tablename'] == 'secteur') $id=$this->table['id_sec']; else if ($this->table['tablename'] == 'commune') $id=$this->table['id_com']; else if ($this->table['tablename'] == 'entreprise') $id=$this->table['id_ent']; else $id=$this->table['id']; $sql='select rang from '.$nom_table.' where id='.$id.''; $rang = CBdd::select_one($sql, 'rang'); $rang_plus=$rang+1; $sql2='UPDATE '.$nom_table.' SET rang = IF(rang='.$rang.','.$rang_plus.','.$rang.') WHERE rang IN ('.$rang.','.$rang_plus.')'; $res = CBdd::execute($sql2); return $res; }
/** * Diminuer dans le rang * */ public function downRang() { $toTables = $this->__getById() ; if ($toTables[$this->zRangColone] >= 1) { // --- l'enregistrement inferieur $zWhere = ($this->zParentColone) ? $this->zParentColone . " = " . $toTables[$this->zParentColone] : "" ; $zWhere .= ($zWhere) ? " AND " : "" ; $zWhere .= $this->zRangColone . " > " . $toTables[$this->zRangColone] ; $zSql = "SELECT id, " . $this->zRangColone . " FROM " . $this->zTableName . " WHERE " . $zWhere . " ORDER BY " . $this->zRangColone . " ASC LIMIT 1" ; $toPermutRangs = CBdd::select_row($zSql) ; // --- permutation if (isset($toPermutRangs['id'])) { $zSql = "UPDATE " . $this->zTableName . " SET " . $this->zRangColone . " = " . $toPermutRangs[$this->zRangColone] . " WHERE id = " . $this->iId . " ; " ; CBdd::execute($zSql) ; $zSql = "UPDATE " . $this->zTableName . " SET " . $this->zRangColone . " = " . $toTables[$this->zRangColone] . " WHERE id = " . $toPermutRangs['id'] . " ; " ; CBdd::execute($zSql) ; } } return true; }
// 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']; $a = 0; $_SESSION['confirme']='ok'; $_SESSION['id']=$id; break; case 6 : // Filtrer if(!empty($_GET['idcat'])) $idcat = $_GET['idcat']; $_SESSION['idcat'] = $idcat;
$tgroupe->update(); for ($i=0; $i<$text2 and $text2!=0; $i++){ if ($tab[$i]!=''){ $Zsql = "SELECT * FROM entreprise WHERE commune_alias=".$tab[$i]; $commune = CBdd::select_one($Zsql,'commune_alias'); //echo 'commune'.$commune; array_push($tab_user, $commune); $tab_user_old = CTableGroupeCommune::get_array_id_user($id); $tab_user_new = array_unique(array_merge($tab_user_old, $tab_user)); if($tab_user_new) $liste_user_new = implode("|", $tab_user_new); $groupe = new CTableGroupeCommune(array('id'=>$id, 'text'=>$liste_user_new)); $groupe->update(); if(!$commune) CBdd::execute("DELETE FROM commune WHERE id_com = " . $tab[$i]); } else $not=1; } if ($not!=1) $msginfo = "groupe bien vidé"; $a = 0; break; case 5555://confirmer // RECUPERATION VARIABLE $id = $_GET['id']; $_SESSION['confirme']='ok'; $_SESSION['id']= $id ;
function down_rang() { $sql = " call downrang('" . $this->table['tablename'] . "', " . $this->table['id'] . ")"; $res = CBdd::execute($sql); return $res; }
// 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 groupeUtilitaire WHERE id = " . $id1; $text = CBdd::select_one($sql1,'text'); // Owen 01/2011 suppression contact à partir 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 entreprise WHERE id_ent = " . $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']; $a = 0; $_SESSION['confirme']='ok'; $_SESSION['id']=$id; break; case 6 : // Filtrer if(!empty($_GET['idcat'])) $idcat = $_GET['idcat']; $_SESSION['idcat'] = $idcat;
function reverse_etat_contact() { $sql = "UPDATE user SET etat_contact=abs(etat_contact-1) WHERE id = " . $this->table['id']; $res = CBdd::execute($sql); return $res; }