friendsofredaxo / dsgvo Goto Github PK

PlugIn server konnte aus folgendem Grund nicht installiert werden:SQL error: Error while executing statement "INSERT IGNORE INTO `rex_dsgvo_project` (`domain`) VALUES ('default')"! SQLSTATE[42S02]: Base table or view not found: 1146 Table 'utebelser.rex_dsgvo_project' doesn't exist

<?php

    $McCookieConsent = new McCookieConsent;
    $McCookieConsent->setProperty("privacy_page_id",Redaxo Artikel ID zur Datenschutzseite);
    
    //ermöglicht eigene Daten mit zu loggen z.b. $_SERVER['HTTP_USER_AGENT']
    $McCookieConsent->setLogData("Key / Titel im log", "WERT");
    // -> Beispiel:
    $McCookieConsent->setLogData("HTTP_USER_AGENT",$_SERVER['HTTP_USER_AGENT']);
    
    //ermöglicht eigene Texte und Übersetzungen hinzuzufügen
    // de / en sind bereits definiert können aber ebenso überschrieben werden
    $McCookieConsent->setText("de",
        array(
            "message" => "Für eine uneingeschränkte Nutzung dieser Webseite werden Cookies benötigt. Einige dieser Cookies erfordern ausdrücklich Ihre Zustimmung. Bitte stimmen Sie der Verwendung zu, um alle Funktionen der Webseite nutzen zu können. Detaillierte Informationen finden Sie in unserer Datenschutzerklärung. An dieser Stelle können Sie diese Abfrage für die Speicherung von Cookies wieder reaktivieren.",
            "dismiss_text" => "Ablehnen",
            "allow_text" => "Akzeptieren",
            "privacy_link_text" => "Zur Datenschutzerklärung"
        )
    );
    
    // initialisiert das Objekt mit den Einstellungen
    // -> danach können die Funktion zur Ausgabe etc. genutzt werden
    $McCookieConsent->initialize();

?>

<?php
    // Gibt einen Button aus der je nach aktuellem Status die Cookies aktiviert oder deaktiviert
    echo $McCookieConsent->getCookiesUsageToggle("Cookies deaktivieren","Cookies aktivieren");
    
    // Gibt einen Button aus der das erneute Öffnen des Cookie Fensters ermöglicht
    echo $McCookieConsent->getRevokeButton("revoke");

    // Gibt das Cookie Fenster aus (Nur wenn in der aktuellen Session weder abgelehnt noch zugestimmt wurde)
    echo $McCookieConsent->getCookieUsageWindow();

    // Gibt die bei Zustimmung die relevanten Skripte aus
    echo $McCookieConsent->returnIfAccepted('<script>/* CONSENT RELEVANT */</script>');
    /* die Skripte können z.B. aus dem "Globale Einstellungen" AddOn direkt in der obigen Funktion ausgegeben werden */

    // Gibt diverse Informationen als JS console.log aus
    $McCookieConsent->debug();

?>

/* window */
#mc-cookie-consent-window{
    font-family: Verdana,helvetica, arial, sans-serif;
    color:#555;
    font-size: 1em;
    position: fixed;
    bottom:1em;
    right:1em;
    z-index:9999999999;
    width:450px;
    max-height:100vh;
    overflow-y:auto ;
    padding:2em;
    background:#ffffff;
    text-align: justify;
    -webkit-box-shadow: 0 0 3px rgba(0,0,0,0.3);
    -moz-box-shadow: 0 0 3px rgba(0,0,0,0.3);
    box-shadow: 0 0 3px rgba(0,0,0,0.3);
    animation-delay: 1s;
}

#mc-cookie-consent-window:after{
    content: "";
    clear: both;
}

#mc-cookie-consent-window p{font-size:0.7em;line-height: 1.8em;margin-bottom:2em;color:inherit;}
#mc-cookie-consent-window a{color:#f05f5d;white-space:nowrap;text-decoration: underline;}

#mc-cookie-consent-window button{
    cursor:pointer;
    font-family: Verdana,helvetica, arial, sans-serif;
    font-size:0.8em;
    padding:0.75em 0;
    display: block;
    float:left;
    width:50%;
    text-align: center;
    background:none;
    font-weight: bold;
    -webkit-appearance: none;
    -moz-appearance: none;
    appearance: none;
    -webkit-border-radius: 0px;
    -moz-border-radius: 0px;
    border-radius: 0px;
    -webkit-transition: 0.3s;
    -moz-transition: 0.3s;
    -ms-transition: 0.3s;
    -o-transition: 0.3s;
    transition: 0.3s;
}

#mc-cookie-consent-window button.dismiss{border:2px solid transparent;color:inherit;}
#mc-cookie-consent-window button.allow{border:2px solid #f05f5d;color:#f05f5d;}

/* mediaquerries */
@media(max-width:768px){
    #mc-cookie-consent-window{
        right:0;
        bottom:0;
        left:0;
        width: 100vw;
    }
}

/* animation */
.animated.bounceIn {
    -webkit-animation-duration:0.75s;
    animation-duration:0.75s
}

@-webkit-keyframes bounceIn {
    0%,20%,40%,60%,80%,to {
        -webkit-animation-timing-function:cubic-bezier(.215,.61,.355,1);
        animation-timing-function:cubic-bezier(.215,.61,.355,1)
    }
    0% {
        opacity:0;
        -webkit-transform:scale3d(.3,.3,.3);
        transform:scale3d(.3,.3,.3)
    }
    20% {
        -webkit-transform:scale3d(1.1,1.1,1.1);
        transform:scale3d(1.1,1.1,1.1)
    }
    40% {
        -webkit-transform:scale3d(.9,.9,.9);
        transform:scale3d(.9,.9,.9)
    }
    60% {
        opacity:1;
        -webkit-transform:scale3d(1.03,1.03,1.03);
        transform:scale3d(1.03,1.03,1.03)
    }
    80% {
        -webkit-transform:scale3d(.97,.97,.97);
        transform:scale3d(.97,.97,.97)
    }
    to {
        opacity:1;
        -webkit-transform:scaleX(1);
        transform:scaleX(1)
    }
}
@keyframes bounceIn {
    0%,20%,40%,60%,80%,to {
        -webkit-animation-timing-function:cubic-bezier(.215,.61,.355,1);
        animation-timing-function:cubic-bezier(.215,.61,.355,1)
    }
    0% {
        opacity:0;
        -webkit-transform:scale3d(.3,.3,.3);
        transform:scale3d(.3,.3,.3)
    }
    20% {
        -webkit-transform:scale3d(1.1,1.1,1.1);
        transform:scale3d(1.1,1.1,1.1)
    }
    40% {
        -webkit-transform:scale3d(.9,.9,.9);
        transform:scale3d(.9,.9,.9)
    }
    60% {
        opacity:1;
        -webkit-transform:scale3d(1.03,1.03,1.03);
        transform:scale3d(1.03,1.03,1.03)
    }
    80% {
        -webkit-transform:scale3d(.97,.97,.97);
        transform:scale3d(.97,.97,.97)
    }
    to {
        opacity:1;
        -webkit-transform:scaleX(1);
        transform:scaleX(1)
    }
}
.bounceIn {
    -webkit-animation-name:bounceIn;
    animation-name:bounceIn
}
.animated {
    -webkit-animation-duration:1s;
    animation-duration:1s;
    -webkit-animation-fill-mode:both;
    animation-fill-mode:both
}

<?php

class McCookieConsent
{

    public function __construct()
    {
	    
	    if(session_status() == PHP_SESSION_NONE){
		    session_start();
		}
	    
	    $this->server = rex_server('SERVER_NAME','string','');
	    $this->mc_use_cookies_hash = md5('mc_use_cookies'.$this->server);
	    $this->mc_show_cookie_window_hash = md5('mc_show_cookie_window'.$this->server);
		
		//post action
		$this->post_action = NULL;
		
	    //privacy page
        $this->privacy_page_id = Null;
	    	    
        //array with changeable properties
        $this->public_properties_array = ["privacy_page_id","post_action"];

		//default text
		$this->text_array = array(		
			"de" => array(		
				"message" => "Für eine uneingeschränkte Nutzung dieser Webseite werden Cookies benötigt. Einige dieser Cookies erfordern ausdrücklich Ihre Zustimmung. Bitte stimmen Sie der Verwendung zu, um alle Funktionen der Webseite nutzen zu können. Detaillierte Informationen finden Sie in unserer Datenschutzerklärung. An dieser Stelle können Sie diese Abfrage für die Speicherung von Cookies wieder reaktivieren.",
				"dismiss_text" => "Ablehnen",
				"allow_text" => "Akzeptieren",
				"privacy_link_text" => "Zur Datenschutzerklärung"		
			),
			
			"en" => array(
				"message" => "For an unrestricted use of this website, cookies are required. Some of these cookies require your full consent. Please agree to the use of cookies in order to use all features of the website. You will get detailed information about the use of cookies on this website by clicking on “privacy statement”. At this point, you can reactivate your consent to the use of cookies.",
				"dismiss_text" => "dismiss",
				"allow_text" => "accept",
				"privacy_link_text" => "Privacy statement"	
			)
		);

    }
        
    public function initialize()
    {
		//if lang code isn't in text_array use "en" for $lang_code
		$current_lang_code = rex_clang::getCurrent()->getCode();
		$lang_code = (array_key_exists($current_lang_code, $this->text_array)) ? $current_lang_code : "en";

		//set all text porperties for $lang_code
        $this->message = $this->text_array[$lang_code]["message"];
        $this->dismiss_text = $this->text_array[$lang_code]["dismiss_text"];
        $this->allow_text = $this->text_array[$lang_code]["allow_text"];
        $this->privacy_link_text = $this->text_array[$lang_code]["privacy_link_text"];

        //dismissing or accepting cookies
        if(rex_post('mc_post_cookie_consent','string',NULL) != NULL) {

            $this->post_cookie_consent = rex_post('mc_post_cookie_consent','bool',NULL);

            $this->McVisitorLogger = new McVisitorLogger;
            $this->log_data_array["HTTP_HOST"] = $this->server;
            $this->log_data_array["Cookie Consent"] = ($this->post_cookie_consent === true) ? "accept" : "dismissed";
            $this->McVisitorLogger->setVisitorLogData($this->log_data_array);
            $this->McVisitorLogger->writeToDirectory("cookie_consent_log");

			//unsetting session vars
            rex_unset_session($this->mc_use_cookies_hash);
            rex_unset_session($this->mc_show_cookie_window_hash);
            
            //setting session vars
            rex_set_session($this->mc_use_cookies_hash, $this->post_cookie_consent); //cookie usage
            rex_set_session($this->mc_show_cookie_window_hash,0); //hide window

        }
       
        //revoking window
        if(rex_post('mc_post_cookie_revoke','string',NULL) != NULL) {

            rex_set_session($this->mc_show_cookie_window_hash,1);

        }

        //get needed session vars
        $this->use_cookies = rex_session($this->mc_use_cookies_hash,'bool',0);
        $this->show_window = rex_session($this->mc_show_cookie_window_hash,'bool',1);

    }
    
    private function setPostAction()
    {
	    
    }

    public function setProperty($name,$value)
    {
        //change only allowed public properties
        if(in_array($name,$this->public_properties_array)) {
            $this->$name = $value;
        }
    }
    
    public function setText($lang_code,$array)
    {
	    $this->text_array[$lang_code] = $array;
    }
    
    public function setLogData($key,$value)
    {
	    $this->log_data_array[$key] = $value;
    }

    public function getCookieUsageWindow()
    {

        if($this->show_window) {

			$post_action = ($this->post_action) ? $this->post_action : rex_getUrl("REX_ARTICLE_ID");
			$privacy_link = (is_numeric($this->privacy_page_id)) ? rex_getUrl($this->privacy_page_id) : $this->privacy_page_id ;
						
            $window =
                '<div id="mc-cookie-consent-window" class="animated bounceIn">
                    <form method="POST" action="'.$post_action.'" id="mc-cookie-consent-window-form">
                        <p>' . $this->message . ' <a href="'.$privacy_link.'">' . $this->privacy_link_text . '</a></p>
                        <button type="submit" name="mc_post_cookie_consent" value="0" tabindex="0" class="dismiss">' . $this->dismiss_text . '</button>
                        <button type="submit" name="mc_post_cookie_consent" value="1" tabindex="0" class="allow">' . $this->allow_text . '</button>
                    </form>
                </div>';

        } else {

            $window = NULL;

        }

        return $window;

    }

    public function returnIfAccepted($scripts)
    {
        if($this->use_cookies == 1){
            return "<!-- scripts enabled --> \n $scripts";
        } else {
	        return "<!-- scripts disabled -->";
        }
    }

    public function getCookiesUsageToggle($dismiss_text,$allow_text)
    {
	    $post_action = ($this->post_action) ? $this->post_action : rex_getUrl("REX_ARTICLE_ID");
        $button_dismiss = '<button type="submit" name="mc_post_cookie_consent" value="0" class="dismiss">'.$dismiss_text.'</button>';
        $button_allow = '<button type="submit" name="mc_post_cookie_consent" value="1" class="allow">'.$allow_text.'</button>';

        $toggle = '<form method="POST" action="'.$post_action.'">';
        $toggle .= ($this->use_cookies == 1) ? $button_dismiss : $button_allow;
        $toggle .= '</form>';

        return $toggle;
    }
    
    public function getRevokeButton($button_text)
    {
	    $post_action = ($this->post_action) ? $this->post_action : rex_getUrl("REX_ARTICLE_ID");    
	    $revoke = '<form method="POST" action="'.$post_action.'"><button type="submit" name="mc_post_cookie_revoke" value="1" class="revoke">'.$button_text.'</button></form>';
	    
	    return $revoke;
    }
    
    public function getLogDataString()
    {
	    if(rex_post('mc_post_cookie_consent','string',NULL) != NULL){
		    return $this->McVisitorLogger->getLogDataString();
	    } else {
		    return NULL;
	    }
	    
    }
    
    public function getCookieStatus()
    {
	    return $this->use_cookies;
    }
    
    public function debug()
    {
        echo 
        '<script>
        	console.log("#### McCookieConsent Debug ####");
        	console.log("Server: '.$this->server.'");
        	console.log("Cookie usage state: '.$this->use_cookies.' | Hash: '.$this->mc_use_cookies_hash.'");
        	console.log("Show window state: '.$this->show_window.' | Hash: '.$this->mc_show_cookie_window_hash.'");
        	console.log("SESSION ID: '.session_id().'");
        </script>';

    }

}

<?php

class McVisitorLogger
{

    public function __construct()
    {
        $this->directory = NULL;
    }

    public function writeToDirectory($directory)
    {
        //create directory with .htaccess if necessary
        if($directory && !rex_dir::isWritable($directory)){
            rex_dir::create($directory);
            $htaccess = fopen($directory."/.htaccess", "x");
            fwrite($htaccess, "deny from all");
            fclose($htaccess);
        }
        $log_file_name = "log_".date("d_m_Y",time());
        $log_file = fopen($directory."/$log_file_name.txt", "a");
        fwrite($log_file, $this->log_data_string.PHP_EOL);
        fclose($log_file);
    }

    public function setVisitorLogData($custom_data_array = NULL)
    {
        //custom
        if(is_array($custom_data_array)){
            foreach($custom_data_array as $key => $data){
                $custom_data_string_array[] = "$key: $data";
            }
            $custom_data_string = implode(" | ", $custom_data_string_array);
        } else {
            $custom_data_string = NULL;
        }

        //ip
        $remote_addr = (isset($_SERVER['REMOTE_ADDR']) && filter_var($_SERVER['REMOTE_ADDR'], FILTER_VALIDATE_IP)) ? "REMOTE_ADDR: ".$_SERVER['REMOTE_ADDR'] : "REMOTE_ADDR: invalid or undefined";
        $client_ip = (isset($_SERVER['HTTP_CLIENT_IP']) && filter_var($_SERVER['HTTP_CLIENT_IP'], FILTER_VALIDATE_IP)) ? "HTTP_CLIENT_IP: ".$_SERVER['HTTP_CLIENT_IP'] : "HTTP_CLIENT_IP: invalid or undefined";
        $x_forwarded_for = (isset($_SERVER['HTTP_X_FORWARDED_FOR']) && filter_var($_SERVER['HTTP_X_FORWARDED_FOR'], FILTER_VALIDATE_IP)) ? "HTTP_X_FORWARDED_FOR: ".$_SERVER['HTTP_X_FORWARDED_FOR'] : "HTTP_X_FORWARDED_FOR: invalid or undefined";

        //timestamp
        $time = time();
        $timestamp = date("d.m.Y",$time).' - '.date("H:i",$time).' Uhr';

        $this->log_data_array = array_filter([$remote_addr,$client_ip,$x_forwarded_for,$custom_data_string,$timestamp]);
        $this->log_data_string = implode(" | ", $this->log_data_array);

    }

    public function getLogDataString()
    {
        return $this->log_data_string;
    }

}

Notice: Undefined variable: tracking_content in /Users/joachimdoerr/Workingspace/utebelser/app/redaxo/src/addons/dsgvo/pages/dsgvo.setup.overview.php on line 33

Notice: Undefined variable: consent_content in /Users/joachimdoerr/Workingspace/utebelser/app/redaxo/src/addons/dsgvo/pages/dsgvo.setup.overview.php on line 58

Notice: Undefined variable: listName in /Users/joachimdoerr/Workingspace/utebelser/app/redaxo/src/addons/dsgvo/pages/dsgvo.setup.backup.php on line 16
Notice: Undefined variable: debug in /Users/joachimdoerr/Workingspace/utebelser/app/redaxo/src/addons/dsgvo/pages/dsgvo.setup.backup.php on line 16

Notice: Undefined variable: files in /Users/joachimdoerr/Workingspace/utebelser/app/redaxo/src/addons/dsgvo/pages/dsgvo.setup.phpmailer.php on line 56

Notice: Undefined variable: checkbox_pipe_title in /Users/joachimdoerr/Workingspace/utebelser/app/redaxo/src/addons/dsgvo/pages/dsgvo.setup.contactform.php on line 16
Notice: Undefined variable: checkbox_pipe in /Users/joachimdoerr/Workingspace/utebelser/app/redaxo/src/addons/dsgvo/pages/dsgvo.setup.contactform.php on line 18