/**
* 获取指定群信息
* @UserFunction(method = GET)
* @CheckLogin
*/
function get_group(Integer $id)
{
    $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD);
    $user_id = getCurrentUserId();
    $group = $db->fetch('SELETE * FROM `group` WHERE `id` = ?', $id);
    $group['users'] = $db->fetchAll('SELECT a.`id`, a.`username`, a.`portrait` FROM `user` AS a INNER JOIN `group_user` AS b ON  b.user_id=a.id WHERE b.group_id = ?', $id);
    return $group;
}

function storeVideo($url, $embeded, $headline, $year)
{
    $db = getDB();
    $sql = "INSERT INTO video (url,embeded,headline,year,datum,userid) VALUES ('" . mysql_real_escape_string($url) . "','" . $embeded . "','" . mysql_real_escape_string($headline) . "'," . $year . ",now()," . getCurrentUserId() . ")";
    $result = mysql_query($sql);
    if (mysql_affected_rows() != 1 || $errorno != 0) {
        echo "<center class=\"error\">Eintrag fehlgeschlagen</center>";
    } else {
        echo "<center class=\"successful\">Eintrag erfolgreich</center>";
    }
}

<?php

require "login/login.php";
include 'monitor.inc';
$userId = getCurrentUserId();
$id = $_REQUEST['id'];
if ($id) {
    $folderId = getFolderIdFor($id, 'WPTJob');
} else {
    $folderId = $_REQUEST['folderId'];
}
if ($_REQUEST['active']) {
    $active = 1;
} else {
    $active = 0;
}
$label = $_REQUEST['label'];
$description = $_REQUEST['description'];
$location = $_REQUEST['location'];
$script = $_REQUEST['script'];
$alerts = $_REQUEST['alerts'];
// Extract host and location from $location field
$hostloc = explode(" ", $location);
$host = $hostloc[0];
$location = $hostloc[1];
$frequency = $_REQUEST['frequency'];
$maxDownloadAttempts = $_REQUEST['maxdownloadattempts'];
$numberOfRuns = $_REQUEST['numberofruns'];
$runToUserForAverage = $_REQUEST['runtouseforaverage'];
if ($runToUserForAverage > $numberOfRuns) {
    $smarty->assign('errorMessage', "Run to use for average must be equal to or less than number of runs.");

<?php

require "login/login.php";
include_once 'monitor.inc';
if (isset($_REQUEST['id'])) {
    $shareId = $_REQUEST['id'];
    $shareTable = Doctrine_Core::getTable('Share');
    $share = $shareTable->find($shareId);
} else {
    $share = new Share();
    $share['TheTableName'] = $_REQUEST['tableName'];
    $share['TableItemId'] = $_REQUEST['folderId'];
}
$userTable = Doctrine_Core::getTable('User');
$users = $userTable->findAll();
foreach ($users as $user) {
    if ($user['Id'] == getCurrentUserId()) {
        continue;
    }
    $u = $user['Id'];
    $userName[$u] = $user['Username'];
}
$folderTable = Doctrine_Core::getTable($share['TheTableName'] . 'Folder');
$folder = $folderTable->find($share['TableItemId']);
$smarty->assign('folderName', $folder['Label']);
if (!isset($userName)) {
    $userName = '';
}
$smarty->assign('userName', $userName);
$smarty->assign('share', $share);
$smarty->display('user/addShare.tpl');

/**
* 获取好友列表
* @UserFunction(method = GET|POST)
* @CheckLogin
*/
function get_friend()
{
    $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD);
    $friends = $db->fetchAll('SELECT A.`id`,`email`,`username`,`portrait`,`status` FROM `friend` INNER JOIN `user` AS A ON `friend_id`=A.`id` WHERE `user_id`=?;', getCurrentUserId());
    return $friends;
}

function select_rub($id_cde, $id_rubrique = 0)
{
    global $msg, $charset;
    global $select_rub;
    $cde = new actes($id_cde);
    if ($cde->statut >= STA_ACT_ARC) {
        //Commande archivée, facture non modifiable
        $lig_rub = $select_rub[1];
        if (!$id_rubrique) {
            $id_rubrique = 0;
            $lib_rub = '';
        } else {
            $rub = new rubriques($id_rubrique);
            $bud = new budgets($rub->num_budget);
            $lib_bud = $bud->libelle;
            $tab_rub = rubriques::listAncetres($id_rubrique, true);
            $lib_rub = $lib_bud . ':';
            foreach ($tab_rub as $value) {
                $lib_rub .= htmlentities($value[1], ENT_QUOTES, $charset);
                if ($value[0] != $id_rubrique) {
                    $lib_rub .= ":";
                }
            }
        }
        $lig_rub = str_replace('!!id_rub!!', $id_rubrique, $lig_rub);
        $lig_rub = str_replace('!!lib_rub!!', $lib_rub, $lig_rub);
    } else {
        //Commande non archivée, modification des rubriques possible
        if (!$id_rubrique) {
            //Pas de rubrique sélectionnée
            $lig_rub = $select_rub[0];
            $lig_rub = str_replace('!!id_rub!!', 0, $lig_rub);
            $lig_rub = str_replace('!!lib_rub!!', '', $lig_rub);
        } else {
            //Rubrique selectionnée
            $user_userid = getCurrentUserId();
            $rub = new rubriques($id_rubrique);
            $bud = new budgets($rub->num_budget);
            if (!rubriques::getAutorisations($id_rubrique, $user_userid)) {
                //L'utilisateur n'a pas de droits sur la rubrique
                $lig_rub = $select_rub[1];
            } else {
                //L'utilisateur à des droits sur la rubrique
                $lig_rub = $select_rub[0];
            }
            $lig_rub = str_replace('!!id_rub!!', $rub->id_rubrique, $lig_rub);
            $lib_bud = htmlentities($bud->libelle, ENT_QUOTES, $charset);
            $tab_rub = rubriques::listAncetres($id_rubrique, true);
            $lib_rub = $lib_bud . ':';
            foreach ($tab_rub as $value) {
                $lib_rub .= htmlentities($value[1], ENT_QUOTES, $charset);
                if ($value[0] != $id_rubrique) {
                    $lib_rub .= ":";
                }
            }
            $lig_rub = str_replace('!!lib_rub!!', $lib_rub, $lig_rub);
        }
    }
    return $lig_rub;
}

}
if (!isset($_SESSION['changeNoteFolderId'])) {
    $_SESSION['changeNoteFolderId'] = getRootFolderForUser($user_id, 'ChangeNote');
}
$folderId = $_SESSION['changeNoteFolderId'];
$smarty->assign('folderId', $_SESSION['changeNoteFolderId']);
$folderTree = getFolderTree($user_id, 'ChangeNote');
$smarty->assign('folderTree', $folderTree);
try {
    $q = Doctrine_Query::create()->from('ChangeNote c, c.ChangeNoteFolder f')->groupBy('c.Id');
    if ($folderId > -1 && hasPermission('ChangeNote', $folderId, PERMISSION_READ)) {
        $q->andWhere('c.ChangeNoteFolderId = ?', $folderId);
    } else {
        $q->andWhere('c.UserId = ?', $user_id)->orWhere('c.Public = ?', true);
    }
    $pager = new Doctrine_Pager($q, $changeNotesCurrentPage, $resultsPerPage);
    $result = $pager->execute();
    //  $changeNoteTable = Doctrine_Core::getTable('ChangeNote');
    //  $changeNotes = $changeNoteTable->findAll();
    $smarty->assign('result', $result);
} catch (Exception $e) {
    error_log("[WPTMonitor] Failed while Listing Change Notes: " . $e->getMessage());
}
unset($changeNotes);
$smarty->assign('userId', getCurrentUserId());
$shares = getFolderShares($user_id, 'ChangeNote');
$smarty->assign('shares', $shares);
$smarty->display('changenote/listChangeNotes.tpl');
?>
 

<?php

require "login/login.php";
include 'monitor.inc';
$folderId = $_REQUEST['folderId'];
if (!hasPermission('ChangeNote', $folderId, PERMISSION_UPDATE)) {
    echo "Invalid Permission";
    exit;
}
if (isset($_REQUEST['id'])) {
    $id = $_REQUEST['id'];
    $changeNoteTable = Doctrine_Core::getTable('ChangeNote');
    $changeNote = $changeNoteTable->find($id);
} else {
    $changeNote = new ChangeNote();
}
$folderTree = getFolderTree(getCurrentUserId(), 'ChangeNote');
$shares = getFolderShares(getCurrentUserId(), 'ChangeNote');
$smarty->assign('folderTree', $folderTree);
$smarty->assign('shares', $shares);
$smarty->assign('folderId', $folderId);
$smarty->assign('result', $changeNote);
$smarty->display('changenote/addChangeNote.tpl');

        krass unsachliche, rechtswidrige oder moralisch bedenkliche Beiträge sowie Beiträge, die dem Ansehen des Mediums schaden,
        zu löschen.
        Sie als Verfasser haften für sämtliche von Ihnen veröffentlichte Beiträge selbst und können dafür auch gerichtlich
        zur Verantwortung gezogen werden. Beachten Sie daher bitte, dass auch die freie Meinungsäußerung im Internet den Schranken
        des geltenden Rechts, insbesondere des Strafgesetzbuches (Üble Nachrede, Ehrenbeleidigung etc.) und des Verbotsgesetzes,
        unterliegt. Die Redaktion behält sich vor, strafrechtlich relevante Tatbestände gegebenenfalls den zuständigen Behörden
        zur Kenntnis zu bringen.
        Die Chatiquette und Netiquette sind zu akzeptieren und einzuhalten! 
        <br><br>
      </div>  

        <?php 
    $name = "";
    $email = "";
    if (1 == 2 && yisLoggedIn()) {
        $user = getFullUserByID(getCurrentUserId());
        $name = $user->getSpitznameOrVorname();
        $email = $user->getemail();
    }
    ?>

      
    <form name="gaestbook" method="post" action="<?php 
    echo $_SERVER["PHP_SELF"] . "?" . $QUERY_STRING;
    ?>
" onSubmit="return checkform()">
    <table align=center cellpadding="0" cellspacing="0" border="0">
      <tr>
        <td class="links"> Name: </td>
        <td> <input type="Text" name="name" value="<?php 
    echo $name;

<?php

chdir('..');
include_once 'monitor.inc';
include_once 'graph_functions.inc';
include_once 'firephp/0.3.2/fb.php';
include_once 'utils.inc';
include_once 'jash/functions.inc';
header('Content-Type: application/json');
header('Cache-Control: public', TRUE);
if ($_SESSION['ls_admin']) {
    ini_set('max_execution_time', 120);
}
$requestData = $_POST;
$response = array('status' => null, 'message' => null, 'results' => null);
if (null === ($userId = getCurrentUserId())) {
    $response['message'] = 'Not logged in.';
    $response['status'] = 401;
    echo json_encode($response);
    die;
}
session_write_close();
if (array_key_exists('action', $_GET) && $_GET['action'] == 'getMaxExecutionTime') {
    header("Expires: " . gmdate("D, d M Y H:i:s", time() + 60) . " GMT");
    header_remove("Pragma");
    $response['status'] = 200;
    $response['message'] = 'OK';
    $response['results'] = array('max_execution_time' => ini_get('max_execution_time'));
    echo json_encode($response);
    die;
}

include 'monitor.inc';
$folderId = $_REQUEST['tableItemId'];
$tableName = $_REQUEST['tableName'];
$shareId = $_REQUEST['id'];
if (!$_REQUEST['active']) {
    $active = false;
} else {
    $active = true;
}
try {
    if ($shareId) {
        $shareTable = Doctrine_Core::getTable('Share');
        $share = $shareTable->find($shareId);
    }
    if (!$share) {
        $share = new Share();
    }
    $share['Active'] = $active;
    $share['UserId'] = getCurrentUserId();
    $share['ShareWithUserId'] = $_REQUEST['shareWithUserId'];
    $share['TheTableName'] = $_REQUEST['tableName'];
    $share['TableItemId'] = $_REQUEST['tableItemId'];
    $share['Permissions'] = $_REQUEST['permissions'];
    $share->save();
} catch (Exception $e) {
    error_log("[WPTMonitor] Failed while updating share: " . $id . " message: " . $e->getMessage());
    echo $e->getMessage();
    exit;
}
header("Location: listShares.php?folderId=" . $folderId . "&folder=" . $folder . "&tableName=" . $tableName);
exit;

 function setTime(&$arrOutput = array(), $mode = '')
 {
     if (isset($arrOutput['name']) && $arrOutput['name'] != '') {
         $arrOutput['encode'] = replaceUnicode($arrOutput['name']);
     }
     if (isset($arrOutput['password']) && $arrOutput['password'] != '') {
         $arrOutput['password'] = md5($arrOutput['password']);
     }
     switch ($mode) {
         case MODE_ADD:
             $arrOutput['create_at'] = getCurrentDt();
             $arrOutput['create_by'] = getCurrentUserId();
             break;
         case MODE_EDIT:
             $arrOutput['update_at'] = getCurrentDt();
             $arrOutput['update_by'] = getCurrentUserId();
             break;
         case MODE_DELETE:
             $arrOutput['delete_at'] = getCurrentDt();
             $arrOutput['delete_by'] = getCurrentUserId();
             break;
     }
 }

 /**
  * getInsertUpdate
  *
  * @param type $arrData
  * @return boolean
  */
 public function getInsertUpdate($arrData = array())
 {
     $this->db->trans_start();
     if ($arrData['data']['order_by'] > 0) {
         $sql .= "\tUPDATE news \t";
         $sql .= "\tSET order_by = order_by + 1 \t";
         $sql .= "\twhere order_by >=  \t" . $arrData['data']['order_by'];
         $this->db->query($sql);
     } else {
         $arrData['data']['order_by'] = getMaxValue('order_by', 'news') + 1;
     }
     if (!isset($arrData['data']['id']) || $arrData['data']['id'] == '') {
         setTime($arrData['data'], MODE_ADD);
         if (!isset($arrData['data']['publish_at']) || $arrData['data']['publish_at'] == '') {
             $arrData['data']['publish_at'] = $arrData['data']['create_at'];
             if (isset($arrData['data']['status']) && $arrData['data']['status'] == 1) {
                 $arrData['data']['publish_by'] = getCurrentUserId();
             }
         }
         $this->db->insert('news', $arrData['data']);
     } else {
         setTime($arrData, MODE_EDIT);
         if (isset($arrData['data']['status']) && $arrData['data']['status'] == 1) {
             $arrData['data']['publish_by'] = getCurrentUserId();
         }
         $this->db->where('id', $arrData['data']['id']);
         $this->db->update('news', $arrData['data']);
     }
     if ($this->db->trans_complete()) {
         return true;
     }
 }

/**
* 获取某人用户资料
* @UserFunction(method = POST)
* @CheckLogin
*/
function update_profile(string $username)
{
    $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD);
    $db->exec('UPDATE `user` SET `username`= ?  WHERE `id` = ?', $username, getCurrentUserId());
}

?>

<?php 
function addVideo()
{
    if (isLoggedIn()) {
        if (hasCurrentUserRight("video")) {