function create($sitemap_name = '') { if(!$sitemap_name) $sitemap_name = SS_ADMIN_TO_USERFILE . "/sitemap.xml"; if(empty($sitemap_name)) $sitemap_name = "sitemap_" . $rep_name . ".xml"; $changefreq = array('daily', 'weekly', 'monthly'); $priority = array('0.1', '0.5', '1.0'); $tab_archive = array(); rsort($tab_archive); $xml = simplexml_load_file(SS_ADMIN_TO_USERFILE . '/google/sitemap_base.xml'); //scan bdd $sql = "SELECT * FROM page WHERE etat = 1"; $res = CBdd::select($sql); while($page = mysql_fetch_array($res)) { $url = $xml->addChild('url'); $url->addChild('loc', CUrl::get_urlsite() . "/" . CFunction::formate_chaine(utf8_decode($page['nom']), '-') . "_p" . $page['id']. ".html"); $url->addChild('lastmod', CDate::formate_date($page['date'])); $url->addChild('changefreq', $changefreq[rand(0, 2)]); $url->addChild('priority', $priority[rand(0, 2)]); } $html = $xml->asXML(); file_put_contents($sitemap_name, $html); }
function export($separator = ',') { $id_groupe = $this->table['id']; $nom_groupe = self::get_element($id_groupe); $nom_csv = CFunction::formate_chaine($nom_groupe) . ".csv"; header("Content-Type: application/csv-tab-delimited-table"); header("Content-disposition: filename=" . $nom_csv); $resQuery = CBdd::select("SELECT civilite, nom, prenom, societe, adresse, cp, ville, pays, email, telephone, mobile, web FROM user WHERE id IN (" . implode(",", self::get_array_id_user($id_groupe)) . ")"); if ($resQuery) { // titre des colonnes $fields = mysql_num_fields($resQuery); $i = 0; $field_name = ''; while ($i < $fields) { $field_name .= '"' . mysql_field_name($resQuery, $i).'"'.$separator; $i++; } $field_name = trim($field_name, $separator); echo $field_name . "\r\n"; // donn�es de la table while ($arrSelect = mysql_fetch_array($resQuery, MYSQL_ASSOC)) { $data = ''; foreach($arrSelect as $key=>$elem) { if($key == "civilite") { $elem = CTableCivilite::get_name($elem); } elseif ($key == "pays") { $elem = CTablePays::get_name($elem); } $data .= '"' . html_entity_decode($elem) . '"'.$separator; } $data = trim($data, $separator); echo $data . "\r\n"; } return 1; } else { return 0; } }
function upload_file($file, $url_rep="", $unzip=FALSE) { $error_type = 0; $file_name = ""; if(!empty($file['name'])) { $file_name = $file['name']; $file_tmp = $file['tmp_name']; $tab = explode(".",$file_name); $file_ext = strtolower($tab[1]); $file_name_noext=$tab[0]; } if($file_name == ""){ return 0; } $nom_file = CFunction::formate_chaine($file_name_noext) . "." . $file_ext; $url_file = self::addendslash($url_rep) . $nom_file; if(is_file($url_file)) return 0; @move_uploaded_file($file_tmp, $url_file); $ret = $url_file; if($unzip) { self::unzip($url_file, $url_rep); } return $ret ; }
$msginfo = ""; $error_type = 0; $url_dest = "../userfiles/image/reference"; $msginfo = ""; $error_signe = array('file'=>""); $value = ""; $name = ""; /*-------------------------------------------------------------------- TRAITEMENTS ----------------------------------------------------------------------*/ if(!empty($_POST['upload'])) { // upload $name = $_FILES['file']['name']; if(!CUserFile::upload_file($_FILES['file'], $url_dest)) { $error_signe['file'] = "*"; $msginfo = " Echec"; } else { $name = CFunction::formate_chaine($name, "_"); $name[strlen($name)-4] = '.'; ?> <script type='text/javascript'>insertOption('<?php echo $name ?>', 'img')</script> <?php } } ?> <form action="" method="post" enctype="multipart/form-data" name="form_upload"> <input type="file" name="file" /><input name="upload" type="submit" value="upload" /><?php echo CHtml::get_msginfo($msginfo) ?> </form> </body> </html>
function export($separator = ',') { $id_groupe = $this->table['id']; $nom_groupe = self::get_element($id_groupe); $nom_csv = CFunction::formate_chaine($nom_groupe) . ".csv"; header("Content-Type: application/csv-tab-delimited-table"); header("Content-disposition: filename=" . $nom_csv); $resQuery = CBdd::select("SELECT nom_ent, categorie_ent, resp_ent, tel_ent, fax_ent, mail_ent, web_ent, descr_ent, rue_adr, cp_adr, actif_ent, dateajout_ent, datecontact_ent, idopportunite, cmtr_ent, paiement_abo, paiement_pre, fin_abo, debut_abo, ent, url, montant_v, montant_pre, type, commune_alias, etatcontact_ent, date_contact FROM entreprise WHERE id_ent IN (" . implode(",", self::get_array_id_user($id_groupe)) . ")"); if ($resQuery) { // titre des colonnes $fields = mysql_num_fields($resQuery); $i = 0; $field_name = ''; while ($i < $fields) { $field_name .= '"' . mysql_field_name($resQuery, $i).'"'.$separator; $i++; } $field_name = trim($field_name, $separator); echo $field_name . "\r\n"; // donn�es de la table while ($arrSelect = mysql_fetch_array($resQuery, MYSQL_ASSOC)) { $data = ''; foreach($arrSelect as $key=>$elem) { if($key == "civilite") { $elem = CTableCivilite::get_name($elem); } elseif ($key == "pays") { $elem = CTablePays::get_name($elem); } $data .= '"' . html_entity_decode($elem) . '"'.$separator; } $data = trim($data, $separator); echo $data . "\r\n"; } return 1; } else { return 0; } }