inc/base.php (dcc202f) - webinterface.git

base.php

<?php
/*
This file belongs to the Webinterface of schokokeks.org Hosting

Written by schokokeks.org Hosting, namely
  Bernd Wurst <bernd@schokokeks.org>
  Hanno Böck <hanno@schokokeks.org>

This code is published under a 0BSD license.

Nevertheless, in case you use a significant part of this code, we ask (but not require, see the license) that you keep the authors' names in place and return your changes to the public. We would be especially happy if you tell us what you're going to do with this code.
*/

require_once('class/database.php');
require_once('inc/debug.php');

function config($key, $localonly = false)
{
    global $config;

if ($key == "modules") {
        // Stelle sicher, dass das "index"-Modul immer aktiv ist!
        if (! in_array("index", $config['modules'])) {
            $config['modules'][] = "index";
        }
        // Stelle sicher, dass das "about"-Modul immer aktiv ist!
        if (! in_array("about", $config['modules'])) {
            $config['modules'][] = "about";
        }
    }

if ($key == 'modules' && isset($_SESSION['restrict_modules'])) {
        $modules = [];
        foreach ($config['modules'] as $mod) {
            if (in_array($mod, $_SESSION['restrict_modules'])) {
                $modules[] = $mod;
            }
        }
        return $modules;
    }

if (array_key_exists($key, $config)) {
        return $config[$key];
    }

if ($localonly) {
        return null;
    }

/* read configuration from database */
    $result = db_query("SELECT `key`, value FROM misc.config");

while ($object = $result->fetch()) {
        if (!array_key_exists($object['key'], $config)) {
            $config[$object['key']]=$object['value'];
        }
    }
    // Sonst wird das Passwort des webadmin-Users mit ausgegeben
    $debug_config = $config;
    unset($debug_config['db_pass']);
    DEBUG($debug_config);
    if (array_key_exists($key, $config)) {
        return $config[$key];
    } else {
        logger(LOG_ERR, "inc/base", "config", "Request to read nonexistant config option »{$key}«.");
    }
    return null;
}

function get_server_by_id($id)
{
    $id = (int) $id;
    $result = db_query("SELECT hostname FROM system.servers WHERE id=?", [$id]);
    $ret = $result->fetch();
    return $ret['hostname'];
}

function my_server_id()
{
    $uid = (int) $_SESSION['userinfo']['uid'];
    $result = db_query("SELECT server FROM system.useraccounts WHERE uid=?", [$uid]);
    $r = $result->fetch();
    DEBUG($r);
    return $r['server'];
}

function additional_servers()
{
    $uid = (int) $_SESSION['userinfo']['uid'];
    $result = db_query("SELECT server FROM system.user_server WHERE uid=?", [$uid]);
    $servers = [];
    while ($s = $result->fetch()) {
        $servers[] = $s['server'];
    }
    DEBUG($servers);
    return $servers;
}

function server_names()
{
    $result = db_query("SELECT id, hostname FROM system.servers");
    $servers = [];
    while ($s = $result->fetch()) {
        $servers[$s['id']] = $s['hostname'];
    }
    DEBUG($servers);
    return $servers;
}

function maybe_null($value)
{
    if (! $value) {
        return null;
    }

if (strlen((string) $value) > 0) {
        return (string) $value;
    } else {
        return null;
    }
}

#define('LOG_ERR', 3);
#define('LOG_WARNING', 4);
#define('LOG_INFO', 6);

function logger($severity, $scriptname, $scope, $message)
{
    if (config('logging') < $severity) {
        DEBUG("NOT LOGGING $scriptname:$scope:$message");
        return;
    }

DEBUG("LOGGING $scriptname:$scope:$message");
    $user = null;
    if (array_key_exists("role", $_SESSION)) {
        if ($_SESSION['role'] & ROLE_SYSTEMUSER) {
            $user = $_SESSION['userinfo']['username'];
        } elseif ($_SESSION['role'] & ROLE_CUSTOMER) {
            $user = $_SESSION['customerinfo']['customerno'];
        }
    }

$args = [":user" => $user,
                ":remote" => $_SERVER['REMOTE_ADDR'],
                ":scriptname" => $scriptname,
                ":scope" => $scope,
                ":message" => $message, ];

db_query("INSERT INTO misc.scriptlog (remote, user,scriptname,scope,message) VALUES (:remote, :user, :scriptname, :scope, :message)", $args);
}

function count_failed_logins()
{
    if (config('logging') < LOG_WARNING) {
        DEBUG("logging is disabled, no brute force check possible");
        return;
    }
    $result = db_query("SELECT count(*) AS num FROM misc.scriptlog WHERE user IS NULL AND scriptname='session/start' AND scope='login' AND message LIKE 'wrong user data%' AND remote=:remote AND `timestamp` > NOW() - INTERVAL 10 MINUTE", [":remote" => $_SERVER['REMOTE_ADDR']]);
    $data = $result->fetch();
    DEBUG('seen '.$data['num'].' failed logins from this address within 10 minutes');
    return $data['num'];
}

function html_header($arg)
{
    global $html_header;
    $html_header .= $arg;
}

function title($arg)
{
    global $title;
    $title = $arg;
}

function headline($arg)
{
    global $headline;
    $headline = $arg;
}

function output($arg)
{
    global $output;
    $output .= $arg;
}

function random_string($len)
{
    $s = str_replace('+', '.', base64_encode(random_bytes(ceil($len*3/4))));
    return substr($s, 0, $len);
}

function check_form_token($form_id, $formtoken = null)
{
    if ($formtoken == null && isset($_REQUEST['formtoken'])) {
        $formtoken = $_REQUEST['formtoken'];
    }
    $sessid = session_id();
    if ($sessid == "") {
        DEBUG("Uh? Session not running? Wtf?");
        system_failure("Internal error! (Session not running)");
    }

if (! isset($_SESSION['session_token'])) {
        $_SESSION['session_token'] = random_string(10);
    }
    $correct_formtoken = hash('sha256', $sessid.$form_id.$_SESSION['session_token']);

if (! ($formtoken == $correct_formtoken)) {
        system_failure("Possible cross-site-request-forgery!");
    }
}

function have_module($modname)
{
    return in_array($modname, config('modules'));
}

function beta_notice()
{
    output('<div class="beta"><h4>Achtung: Testbetrieb</h4><p>Diese Funktion ist im Testbetrieb. Bei Fehlfunktionen, Unklarheiten oder Verbesserungsvorschlägen bitten wir um kurze Nachricht an <a href="mailto:root@schokokeks.org">root@schokokeks.org</a></p></div>');
}

function addnew($file, $label, $querystring = '', $attribs = '')
{
    output('<p class="addnew">'.internal_link($file, $label, $querystring, $attribs).'</p>');
}

function html_form($form_id, $scriptname, $querystring, $content)
{
    $querystring = encode_querystring($querystring);
    $ret = '';
    $ret .= '<form id="'.$form_id.'" action="'.$scriptname.$querystring.'" method="post">'."\n";
    $ret .= '<p style="display: none;"><input type="hidden" name="formtoken" value="'.generate_form_token($form_id).'" /></p>'."\n";
    $ret .= $content;
    $ret .= '</form>';
    return $ret;
}

function html_datepicker($nameprefix, $timestamp)
{
    $valid_days = [ 1 =>  1,  2 =>  2,  3 =>  3,  4 =>  4,  5 =>  5,
                       6 =>  6,  7 =>  7,  8 =>  8,  9 =>  9, 10 => 10,
                      11 => 11, 12 => 12, 13 => 13, 14 => 14, 15 => 15,
                      16 => 16, 17 => 17, 18 => 18, 19 => 19, 20 => 20,
                      21 => 21, 22 => 22, 23 => 23, 24 => 24, 25 => 25,
                      26 => 26, 27 => 27, 28 => 28, 29 => 29, 30 => 30,
                      31 => 31, ];
    $valid_months = [ 1 =>  1,  2 =>  2,  3 =>  3,  4 =>  4,  5 =>  5,
                         6 =>  6,  7 =>  7,  8 =>  8,  9 =>  9, 10 => 10,
                        11 => 11, 12 => 12, ];
    $current_year = (int) date('Y');
    $valid_years = [$current_year => $current_year,
                       $current_year+1 => $current_year+1,
                       $current_year+2 => $current_year+2,
                       $current_year+3 => $current_year+3,
                       $current_year+4 => $current_year+4, ];

$selected_day = date('d', $timestamp);
    $selected_month = date('m', $timestamp);
    $selected_year = date('Y', $timestamp);
    $ret = '';
    $ret .= html_select($nameprefix.'_day', $valid_days, $selected_day, 'style="text-align: right;"').". ";
    $ret .= html_select($nameprefix.'_month', $valid_months, $selected_month, 'style="text-align: right;"').". ";
    $ret .= html_select($nameprefix.'_year', $valid_years, $selected_year);
    return $ret;
}

function send_mail($address, $subject, $body)
{
    if (strstr($subject, "\n") !== false) {
        die("Zeilenumbruch im subject!");
    }
    $header = "From: ".config('company_name')." Web Administration <".config('adminmail').">\r\nCc: ".config('adminmail')."\r\nContent-Type: text/plain; charset=\"utf-8\"\r\nContent-Transfer-Encoding: quoted-printable\r\nX-schokokeks-org-message: webinterface";
    $subject = mb_encode_mimeheader($subject, "utf-8", "Q");
    $body = quoted_printable_encode($body);
    mail($address, $subject, $body, $header);
}

webinterface.git

Change license from CC0 to 0BSD, all contributors agreed