public static function retirerServeur()
{
$query = "delete from rtorrent where hostname=" . \core\Mysqli::real_escape_string_html(HOST);
\core\Mysqli::query($query);
$res = \core\Mysqli::nombreDeLigneAffecte() == 1;
\core\Mysqli::close();
return $res;
}
public static function deleted($login, $mdp)
{
$query = "update utilisateur set motdepasse=" . \core\Mysqli::real_escape_string_html(sha1($mdp));
$query .= " where login=" . \core\Mysqli::real_escape_string_html($login);
\core\Mysqli::query($query);
$res = \core\Mysqli::nombreDeLigneAffecte() == 1;
\core\Mysqli::close();
return $res;
}
static function delete($id)
{
$query = "delete from film ";
$query .= "where id=" . \core\Mysqli::real_escape_string_html($id);
\core\Mysqli::query($query);
$res = \core\Mysqli::nombreDeLigneAffecte() > 1;
\core\Mysqli::close();
return $res;
}
public function delete()
{
if (!is_null($this->id)) {
$query = "delete from ticket ";
$query .= " where id=" . \core\Mysqli::real_escape_string_html($this->id);
\core\Mysqli::query($query);
$res = \core\Mysqli::nombreDeLigneAffecte() == 1;
\core\Mysqli::close();
return $res;
}
return false;
}
public function insert()
{
if (is_null($this->id) || is_null($this->label)) {
return false;
}
$query = "insert into genrefilm (id,label) values(";
$query .= \core\Mysqli::real_escape_string_html($this->id) . ",";
$query .= \core\Mysqli::real_escape_string_html($this->label) . ")";
\core\Mysqli::query($query);
$res = \core\Mysqli::nombreDeLigneAffecte() == 1;
\core\Mysqli::close();
return $res;
}
public static function insertTorrent($hashinfo, $data)
{
$query = "Insert into torrents values( NULL," . \core\Mysqli::real_escape_string($hashinfo) . ", 0,0,'0000-00-00 00:00:00','0',0,0)";
\core\Mysqli::query($query);
$res = \core\Mysqli::nombreDeLigneAffecte() == 1;
if ($res) {
$id = \core\Mysqli::getLastId();
$query = "Insert into torrents_files values( " . $id . "," . \core\Mysqli::real_escape_string($data) . ")";
\core\Mysqli::query($query);
$res &= \core\Mysqli::nombreDeLigneAffecte() == 1;
}
\core\Mysqli::close();
return $res ? $id : $res;
}
public function insert()
{
if (is_null($this->nomrtorrent) || is_null($this->login) || is_null($this->portscgi)) {
return false;
}
$query = "insert into rtorrents (nomrtorrent,login,portscgi) values(";
$query .= \core\Mysqli::real_escape_string_html($this->nomrtorrent) . ",";
$query .= \core\Mysqli::real_escape_string_html($this->login) . ",";
$query .= \core\Mysqli::real_escape_string_html($this->portscgi) . ")";
\core\Mysqli::query($query);
$res = \core\Mysqli::nombreDeLigneAffecte() == 1;
\core\Mysqli::close();
return $res;
}
public function setFini($resultat)
{
$resultat = json_encode($resultat);
$this->fini = true;
$this->resultat = $resultat;
$query = "update cronroot set ";
$query .= "fini=" . \core\Mysqli::real_escape_string_html($this->fini);
$query .= ", resultat=" . \core\Mysqli::real_escape_string_html($this->resultat);
$query .= " where id=" . \core\Mysqli::real_escape_string_html($this->id);
\core\Mysqli::query($query);
//echo $query;
$res = \core\Mysqli::nombreDeLigneAffecte() == 1;
\core\Mysqli::close();
return $res;
}
public static function supprimeUtilisateur($login)
{
$query = "delete from utilisateur ";
$query .= " where login=" . \core\Mysqli::real_escape_string_html($login);
\core\Mysqli::query($query);
$res = \core\Mysqli::nombreDeLigneAffecte() == 1;
\core\Mysqli::close();
return $res;
}
public function updateMediainfo($mediainfo)
{
$this->mediainfo = json_encode($mediainfo);
$query = "update torrentserie set ";
$query .= "mediainfo=" . \core\Mysqli::real_escape_string_html($this->mediainfo);
$query .= " where id=" . \core\Mysqli::real_escape_string_html($this->id);
\core\Mysqli::query($query);
//echo $query;
$res = \core\Mysqli::nombreDeLigneAffecte() == 1;
\core\Mysqli::close();
return $res;
}
