Krassmus

<?php


class SemesterCourseSearch extends SQLSearch
{

    public function __construct()
    {
        $this->sql = $this->getSQL();
    }

Krassmus

X-Envelope-From: <educacao@correiapinto.sc.gov.br>
X-Envelope-To: <ras@fuhse.org>
X-Delivery-Time: 1542634760
X-UID: 41630
Return-Path: <educacao@correiapinto.sc.gov.br>
Authentication-Results: strato.com; dmarc=none header.from=correiapinto.sc.gov.br
Authentication-Results: strato.com; arc=none
Authentication-Results: strato.com; dkim=pass header.d=correiapinto.sc.gov.br
Authentication-Results: strato.com; dkim-adsp=pass header.from="educacao@correiapinto.sc.gov.br"
Authentication-Results: strato.com; spf=pass smtp.mailfrom="educacao@correiapinto.sc.gov.br"

Krassmus

:root {
    //Nur dieser Wert muss angepasst werden. Werte von 0 bis 360 sind erlaubt.
    --maincolor_h: 78; //original: 215
    
    
    --maincolor_s: 42%;
    --maincolor_l: 46%;
    
    --maincolor: ~"hsl(var(--maincolor_h), var(--maincolor_s), var(--maincolor_l))"; 
    --darkmaincolor: ~"hsl(var(--maincolor_h), var(--maincolor_s), 20%)";

Krassmus

SELECT auth_user_md5.*
FROM plugins
	INNER JOIN plugins_activated ON (plugins_activated.`pluginid` = plugins.`pluginid` AND state = 'on')
	INNER JOIN seminar_user ON (CONCAT('sem', seminar_user.Seminar_id) = plugins_activated.`poiid` AND seminar_user.status = 'dozent')
	INNER JOIN auth_user_md5 ON (auth_user_md5.user_id = seminar_user.user_id)
WHERE plugins.pluginclassname = 'LernmodulePlugin'
GROUP BY auth_user_md5.user_id

Krassmus

SELECT DISTINCT termine.range_id
                FROM themen_termine
                    LEFT JOIN themen ON (themen.issue_id = themen_termine.issue_id)
                    INNER JOIN termine ON (themen_termine.termin_id = termine.termin_id)
                WHERE themen.issue_id IS NULL

Krassmus

Select resources_assign.* 
FROM resources_assign 
LEFT JOIN termine ON (termine.termin_id = resources_assign.`assign_user_id`)
LEFT JOIN auth_user_md5 ON (auth_user_md5.user_id = resources_assign.`assign_user_id`)
WHERE auth_user_md5.user_id IS NULL
AND termine.termin_id IS NULL

Krassmus

jQuery(function($) {
    var a = $('#barTopMenu li#nav_community a');
    if (a.length === 0) {
        return;
    }
    
        
    var li = a.parent()
    // insert hidden badge
    , badge = $('<span id="online_badge">').appendTo(li).hide()

Krassmus

<?php
/**
 * QuickSearch.class.php
 *
 * @author		Rasmus Fuhse <fuhse@data-quest.de>, Suchi & Berg GmbH <info@data-quest.de>
 * @version		$Id:$
 */
// +---------------------------------------------------------------------------+
// This file is part of Stud.IP
// QuickSearch.class.php