Connectdb.php

<?php

/**
 * 	This file is part of ncfilters by netz.coop eG.
 * 
 *  Ncfilters is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 * 
 *  Ncfilters is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *  
 *  You should have received a copy of the GNU General Public License
 *  along with Ncfilters.  If not, see <http://www.gnu.org/licenses/>.
 *  
 *  Diese Datei ist Teil von ncfilters by netz.coop eG.
 *  
 *  Ncfilters ist Freie Software: Sie können es unter den Bedingungen
 *  der GNU General Public License, wie von der Free Software Foundation,
 *  Version 3 der Lizenz oder (nach Ihrer Wahl) jeder späteren
 *  veröffentlichten Version, weiterverbreiten und/oder modifizieren.
 *  
 *  Ncfilters wird in der Hoffnung, dass es nützlich sein wird, aber
 *  OHNE JEDE GEWÄHRLEISTUNG, bereitgestellt; sogar ohne die implizite
 *  Gewährleistung der MARKTFÄHIGKEIT oder EIGNUNG FÜR EINEN BESTIMMTEN ZWECK.
 *  Siehe die GNU General Public License für weitere Details.
 *  
 *  Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
 *  Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
 * 
 */

/**
 * Description of Connectdb
 *
 * @author nc
 */
class Connectdb  extends SQLite3

{
	public function __construct()
    {
        $this->open(DBFILE);
    }
	
	/**
	 * Get Data for Firewall setup
	 * @return array()
	 */
	
	public function getpclistgroupsarray(){	
		$result = $this->query('SELECT * from pclist as p INNER JOIN groups as g ON p.group_id = g.group_id;');
		$ary_content = array();
		$i = 0;
		$key = null;
		while ($res = $result->fetchArray(SQLITE3_ASSOC)) {
			foreach ($res as $key => $value) {
				if (!isset($ary_content[$i][$key])){
					$ary_content[$i][$key] = null;	
					}
				$ary_content[$i][$key] .= $value;
			}
			$i++;
		}
		return $ary_content;
	}
	
	/**
	 * Get Data for hosts.open setup
	 * @return array()
	 */
	public function getdomaingroupsarray(){
		$result = $this->query('SELECT *  from domains;');
		$ary_content = array();
		$i = 0;
		while ($res = $result->fetchArray(SQLITE3_ASSOC)) {
			foreach ($res as $key => $value) {
				$ary_content[$i][$key] .= $value;
			}
			$i++;
		}
		return $ary_content;
	}
	

        public function getclosefwcronarray(){
                $result = $this->query('SELECT *  from close_fw_cron;');
                $ary_content = array();
                $i = 0;
		$key = null;
                while ($res = $result->fetchArray(SQLITE3_ASSOC)) {
                        foreach ($res as $key => $value) {
                                if (!isset($ary_content[$i][$key])){
					$ary_content[$i][$key] = null;
                        	        }

				$ary_content[$i][$key] .= $value;
                        }
                        $i++;
                }
                return $ary_content;
        }



	
	public function cleanstringfromspecial($string,$password){
		$string = str_replace(' ', '-', $string); // Replaces all spaces with hyphens.
		return preg_replace('/[^A-Za-z0-9\-]/', '', $string);
	}
	
	public function getUserpassword($name,$password){
		
		$login=false;
		$result = $this->query('SELECT * from nclistsuser');
		$ary_content = array();
		while ($res = $result->fetchArray(SQLITE3_ASSOC)) {
			if($res[0]['name'] === $string ){
				foreach ($res as $key => $value) {
					$ary_content[$key] .= $value;
				}
			}
			
		}
		
		$loginname=$ary_content['name'];
		$loginpasswordcrypt=$ary_content['password'];
		$gehashtes_passwort = crypt($password,$loginpasswordcrypt);
	
		if( $loginname && $loginpasswordcrypt === $gehashtes_passwort ){
//				echo '$gehashtes_passwort: '.$loginpasswordcrypt .' '.$gehashtes_passwort;
			$login = true;
		}
		
		
		return $login;
	}
	
	public function getgroupids(){
		$result = $this->query('SELECT *  from groups;');
		$ary_content = array();
		$i = 0;
		while ($res = $result->fetchArray(SQLITE3_ASSOC)) {
			$group_id=$res['group_id'];
			foreach ($res as $key => $value) {
				
				$ary_content[$group_id][$key] .= $value;
			}
			$i++;
		}
		return $ary_content;
	}
        
        public function getdomains(){
		$result = $this->query('SELECT url  FROM domains;');
		$ary_content = array();
		$h = 0;
		while ($res = $result->fetchArray(SQLITE3_ASSOC)) {
			foreach ($res as $key => $value) {
                                $ary_content[$h][$key] = '';
				$ary_content[$h][$key] .= $value;
			}
			$h++;
		}
		return $ary_content;
	}

        
        public function tinymce_html($array_url){
            $this->exec("DROP TABLE start_html");
            $this->exec("CREATE TABLE IF NOT EXISTS 'start_html' (id INTEGER PRIMARY KEY UNIQUE, url TEXT NOT NULL, title TEXT NOT NULL, description TEXT)");
            foreach($array_url as $key =>$url){
                $http_url = 'http://'.$url['url'];           
                $ch = curl_init();
                curl_setopt($ch, CURLOPT_HEADER, 0);
                curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
                curl_setopt($ch, CURLOPT_URL, $http_url);
                curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);

                $data = curl_exec($ch);
                $http_code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
                
                curl_close($ch);
                                
                $description = '';
                $keywords = '';
               
                //parsing begins here:
                $doc = new DOMDocument();
                @$doc->loadHTML($data);
                $nodes = $doc->getElementsByTagName('title');

                //get and display what you need:
                $title = $nodes->item(0)->nodeValue;

                $metas = $doc->getElementsByTagName('meta');
                for ($i = 0; $i < $metas->length; $i++) {
                   
                    $meta = $metas->item($i);
                    if($meta->getAttribute('name') == 'description') {
                        $description = $meta->getAttribute('content'); 
                        }                   
                    if($meta->getAttribute('name') == 'keywords') {
                        $keywords = $meta->getAttribute('content'); 
                        }
                    }
                    
               if ($http_code == 200){
                $this->exec("INSERT INTO 'start_html' (url, title, description) VALUES ( '$http_url', '$title', '$description')");
                //    $description
                    echo "Title: $title". "\n";
                    echo "Beschreibung: $description". "\n";
                    } 
               
                }

            }

            
            
        public function read_start_html(){
		$result = $this->query('SELECT url, title, description  FROM start_html;');
		$ary_content = array();
		$h = 0;
		while ($res = $result->fetchArray(SQLITE3_ASSOC)) {
			foreach ($res as $key => $value) {
                                $ary_content[$h][$key] = '';
				$ary_content[$h][$key] .= $value;
			}
			$h++;
		}
		return $ary_content;
            }
}