/** * Fonction qui donne les droits redacteurs dans spip * * @param Object $object Object with data (->firstname, ->lastname, ->email and ->login) * @return int =0 if KO, >0 if OK */ function add_to_spip($object) { dol_syslog(get_class($this)."::add_to_spip"); if (defined("ADHERENT_USE_SPIP") && ADHERENT_USE_SPIP ==1 && defined('ADHERENT_SPIP_SERVEUR') && ADHERENT_SPIP_SERVEUR != '' && defined('ADHERENT_SPIP_USER') && ADHERENT_SPIP_USER != '' && defined('ADHERENT_SPIP_PASS') && ADHERENT_SPIP_PASS != '' && defined('ADHERENT_SPIP_DB') && ADHERENT_SPIP_DB != '' ) { require_once(DOL_DOCUMENT_ROOT."/core/lib/security2.lib.php"); $mdpass=dol_hash($object->pass); $htpass=crypt($object->pass,makesalt()); $query = "INSERT INTO spip_auteurs (nom, email, login, pass, htpass, alea_futur, statut) VALUES(\"".$object->firstname." ".$object->lastname."\",\"".$object->email."\",\"".$object->login."\",\"$mdpass\",\"$htpass\",FLOOR(32000*RAND()),\"1comite\")"; $mydb=getDoliDBInstance('mysql',ADHERENT_SPIP_SERVEUR,ADHERENT_SPIP_USER,ADHERENT_SPIP_PASS,ADHERENT_SPIP_DB,ADHERENT_SPIP_PORT); if (! $mydb->ok) { $this->error=$mydb->lasterror(); return 0; } $result = $mydb->query($query); if ($result) { $mydb->close(); return 1; } else { $this->error=$mydb->lasterror(); return 0; } } }
/** * Fonction qui donne les droits redacteurs dans spip * * @param Adherent $object Object with data (->firstname, ->lastname, ->email and ->login) * @return int =0 if KO, >0 if OK */ function add_to_spip($object) { dol_syslog(get_class($this) . "::add_to_spip"); if ($this->isSpipEnabled()) { if ($this->checkSpipConfig()) { $mydb = $this->connectSpip(); if ($mydb) { require_once DOL_DOCUMENT_ROOT . '/core/lib/security2.lib.php'; $mdpass = dol_hash($object->pass); $htpass = crypt($object->pass, makesalt()); $query = "INSERT INTO spip_auteurs (nom, email, login, pass, htpass, alea_futur, statut) VALUES(\"" . dolGetFirstLastname($object->firstname, $object->lastname) . "\",\"" . $object->email . "\",\"" . $object->login . "\",\"{$mdpass}\",\"{$htpass}\",FLOOR(32000*RAND()),\"1comite\")"; $result = $mydb->query($query); $mydb->close(); if ($result) { return 1; } else { $this->error = $mydb->lasterror(); } } else { $this->error = 'Failed to connect to SPIP'; } } else { $this->error = 'BadSPIPConfiguration'; } } else { $this->error = 'SPIPNotEnabled'; } return 0; }
/** * Fonction qui donne les droits redacteurs dans spip * @return int =0 si KO, >0 si OK */ function add_to_spip() { require_once DOL_DOCUMENT_ROOT . '/lib/security.lib.php'; dol_syslog(get_class($this) . "::add_to_spip"); if (defined("ADHERENT_USE_SPIP") && ADHERENT_USE_SPIP == 1 && defined('ADHERENT_SPIP_SERVEUR') && ADHERENT_SPIP_SERVEUR != '' && defined('ADHERENT_SPIP_USER') && ADHERENT_SPIP_USER != '' && defined('ADHERENT_SPIP_PASS') && ADHERENT_SPIP_PASS != '' && defined('ADHERENT_SPIP_DB') && ADHERENT_SPIP_DB != '') { $mdpass = md5($this->pass); $htpass = crypt($this->pass, makesalt()); $query = "INSERT INTO spip_auteurs (nom, email, login, pass, htpass, alea_futur, statut) VALUES(\"" . $this->prenom . " " . $this->nom . "\",\"" . $this->email . "\",\"" . $this->login . "\",\"{$mdpass}\",\"{$htpass}\",FLOOR(32000*RAND()),\"1comite\")"; // $mydb=new Db('mysql',ADHERENT_SPIP_SERVEUR,ADHERENT_SPIP_USER,ADHERENT_SPIP_PASS,ADHERENT_SPIP_DB); $mydb = new DoliDb('mysql', ADHERENT_SPIP_SERVEUR, ADHERENT_SPIP_USER, ADHERENT_SPIP_PASS, ADHERENT_SPIP_DB, ADHERENT_SPIP_PORT); $result = $mydb->query($query); if ($result) { $mydb->close(); return 1; } else { $this->error = $mydb->error(); return 0; } } }
} if (!isset($cotis)) { // par defaut les adherents doivent etre a jour de cotisation $cotis = 1; } $sql = "SELECT d.login, d.pass, d.datefin"; $sql .= " FROM " . MAIN_DB_PREFIX . "adherent as d "; $sql .= " WHERE d.statut = {$statut} "; if ($cotis == 1) { $sql .= " AND datefin > '" . $db->idate($now) . "'"; } $sql .= $db->order($sortfield, $sortorder); //$sql.=$db->plimit($conf->liste_limit, $offset); $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; print_barre_liste($langs->trans("HTPasswordExport"), $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', 0); print "<hr>\n"; while ($i < $num) { $objp = $db->fetch_object($result); $htpass = crypt($objp->pass, makesalt()); print $objp->login . ":" . $htpass . "<br>\n"; $i++; } print "<hr>\n"; } else { dol_print_error($db); } llxFooter(); $db->close();