function set_jury($nazov)
{
if ($link = db_connect()) {
$sql = "UPDATE organisators as o SET validated = '1' WHERE o.user_id='" . $nazov . "'";
// echo "sql = $sql <br>";
$result = mysqli_query($link, $sql);
// vykonaj dopyt
if ($result) {
// dopyt sa podarilo vykonať
echoMessage('m-acc-validated');
} else {
// dopyt sa NEpodarilo vykonať!
echoError('err-acc-validation');
}
mysqli_close($link);
} else {
// NEpodarilo sa spojiť s databázovým serverom!
echoError('err-db-connection-fail');
}
}
function set_date($contextid, $start_dat, $end_dat)
{
if ($link = db_connect()) {
$sql = "UPDATE assignments as a SET begin = '" . $start_dat . "' , end='" . $end_dat . "' WHERE a.context_id='" . $contextid . "'";
// echo "sql = $sql <br>";
$result = mysqli_query($link, $sql);
// vykonaj dopyt
if ($result) {
// dopyt sa podarilo vykonať
echoMessage('m-date-changed');
} else {
// dopyt sa NEpodarilo vykonať!
echoError('err-date-changing');
}
mysqli_close($link);
} else {
// NEpodarilo sa spojiť s databázovým serverom!
echoError('err-db-connection-fail');
}
}
function fieldPlays($method, $target, $payload)
{
switch ($method) {
case "GET":
checkNULL($target, 'device');
checkDevice($target, 'has_device');
$result = dbSelect('devices', 'devicetime', "tag='" . $target . "'");
$response = $result->fetch_assoc();
httpResponse($response, 200);
break;
case "POST":
checkNULL($target, 'room');
checkRoom($target, 'has_room');
checkNULL($payload['user'], 'user');
checkOnline($payload['user']);
dbUpdate('devices', "command='" . $payload['cmd'] . "', timestamp='" . $payload['ts'] . "'", "location='" . $target . "'");
echoSuccess("set_play");
break;
case "PUT":
checkNULL($target, 'device');
checkDevice($target, 'has_device');
dbUpdate('devices', "devicetime='" . $payload['dt'] . "'", "tag='" . $target . "'");
$result = dbSelect('devices', 'command, timestamp', "tag='" . $target . "'");
$response = $result->fetch_assoc();
httpResponse($response, 200);
dbUpdate('devices', "command=''", "tag='" . $target . "'");
break;
case "DELETE":
checkNULL($target, 'room');
checkRoom($target, 'has_room');
dbUpdate('devices', "command='', timestamp=''", "location='" . $target . "'");
echoSuccess("reset_play");
break;
default:
echoError('Invalid Method');
break;
}
}
}
if (isset($args['updatefeeds'])) {
updateFeeds();
}
if (isset($args['addfeed'])) {
if (isset($args[$indexCounter])) {
addFeed($args[$indexCounter++]);
} else {
echoError($argv);
}
}
if (isset($args['addtorrent'])) {
if (isset($args[$indexCounter]) && isset($args[$indexCounter + 1])) {
addTorrent($args[$indexCounter++], $args[$indexCounter++]);
} else {
echoError($argv);
}
}
exit(0);
/*
* From: http://pwfisher.com/nucleus/index.php?itemid=45
*/
function parseArgs($argv)
{
array_shift($argv);
$o = array();
foreach ($argv as $a) {
if (substr($a, 0, 2) == '--') {
$eq = strpos($a, '=');
if ($eq !== false) {
$o[substr($a, 2, $eq - 2)] = substr($a, $eq + 1);
public function deleteAttachments1($conn, $prilohy, $kde)
{
foreach ($prilohy as $value) {
$pole = explode(";", $value);
$sql = "SELECT * FROM " . $pole[0] . "s WHERE " . $pole[0] . "_id='" . $pole[1] . "'";
$result = mysqli_query($conn, $sql);
if ($result) {
if ($pole[0] != "video") {
$attachment = mysqli_fetch_array($result);
$ext = pathinfo($attachment['original_name'], PATHINFO_EXTENSION);
}
$sql = "DELETE FROM " . $pole[0] . "s WHERE " . $pole[0] . "_id='" . $pole[1] . "'";
$result = mysqli_query($conn, $sql);
if ($result) {
if ($pole[0] != "video") {
if ($pole[0] == "image") {
if (unlink($kde . $pole[0] . "s/big/" . $pole[1] . "." . $ext) && unlink($kde . $pole[0] . "s/small/" . $pole[1] . "." . $ext)) {
echoMessage("m-attachment-deleted");
} else {
echoError("err-attachment-deletion");
}
} else {
if (unlink($kde . $pole[0] . "s/" . $pole[1] . "." . $ext)) {
echoMessage("m-attachment-deleted");
} else {
echoError("err-attachment-deletion");
}
}
}
} else {
echoMessage("m-attachment-deleted");
}
} else {
echoError("err-attachment-db-deletion", mysqli_error($conn));
}
}
/*else {
echoError("err-attachment-not-in-db");
}
}*/
}
echo $udaje["description"];
}
?>
</textarea></td>
</tr>
<tr>
<td><input type="radio" checked name="liga" value=1<?php
if (isset($udaje['sk_league']) && $udaje["sk_league"] == 1) {
echo ' checked';
}
?>
><span data-trans-key="edit-team-form"></span></td>
<td><input type="radio" name="liga" value=0<?php
if (isset($udaje['sk_league']) && $udaje["sk_league"] == 0) {
echo ' checked';
}
?>
><span data-trans-key="edit-team-form"></span></td>
</tr>
<tr>
<td><input type="submit" name="save" data-trans-key="edit-team-form"></td>
</tr>
</table>
</form>
<?php
echoMessage($edit->GetMessage());
$err = $val->GetErrorMessage();
echoError(!empty($err) ? $err : $edit->GetErrorMessage());
page_footer();
function delete_assignment($id)
{
if ($link = db_connect()) {
$sql = "SELECT context_id, text_id_name, text_id_description FROM assignments WHERE context_id = " . $id;
$result = mysqli_query($link, $sql);
if ($result && mysqli_num_rows($result) != 0) {
$assignment = mysqli_fetch_array($result);
$sql = "DELETE FROM texts WHERE text_id = " . $assignment['text_id_name'] . " OR text_id = " . $assignment['text_id_description'];
if (!mysqli_query($link, $sql)) {
echoError('err-assignment-deleting');
return;
}
$sql = "DELETE FROM videos WHERE context_id = " . $assignment['context_id'];
if (!mysqli_query($link, $sql)) {
echoError('err-assignment-deleting');
return;
}
$sql = "DELETE FROM images WHERE context_id = " . $assignment['context_id'];
if (!mysqli_query($link, $sql)) {
echoError('err-assignment-deleting');
return;
}
$sql = "DELETE FROM programs WHERE context_id = " . $assignment['context_id'];
if (!mysqli_query($link, $sql)) {
echoError('err-assignment-deleting');
return;
}
$sql = "DELETE FROM assignments WHERE context_id = " . $assignment['context_id'];
if (!mysqli_query($link, $sql)) {
echoError('err-assignment-deleting');
return;
}
if (!deleteDir(dirname(__FILE__) . "/../attachments/assignments/" . $assignment['context_id'])) {
echoError('err-assignment-deleting');
return;
}
echoMessage('m-assignment-deleted');
} else {
echoError('err-assignment-deleting');
}
} else {
echoError('err-db-connection-fail');
}
}
function echoSession($sessionid)
{
global $db;
$session = pg_fetch_object(pg_query($db, "SELECT * FROM \"usersession\" WHERE id = " . $sessionid));
if (is_object($session)) {
$qrcodefile = QRCODE_PATH . $session->tabletid . ".png";
if (!is_file($qrcodefile)) {
shell_exec("qrencode -o \"" . $qrcodefile . "\" -s 25 \"" . $session->tabletid . "\"");
}
echo '
<session>
<id>' . $session->id . '</id>
<tabletid>' . $session->tabletid . '</tabletid>
<qrcodepath><![CDATA[' . substr($qrcodefile, strlen(ROOT_PATH)) . ']]></qrcodepath>
<qrcodeurl><![CDATA[http://' . $_SERVER['HTTP_HOST'] . substr($qrcodefile, strlen(ROOT_PATH)) . ']]></qrcodeurl>';
if ($session->userid > 0) {
echo '
<userid>' . $session->userid . '</userid>';
}
echo '
<startedat>' . $session->startedat . '</startedat>';
if ($session->committedat != '') {
echo '
<committedat>' . $session->committedat . '</committedat>';
}
if ($session->sentat != '') {
echo '
<sentat>' . $session->sentat . '</sentat>';
}
if ($session->finishedat != '') {
echo '
<finishedat>' . $session->finishedat . '</finishedat>';
}
echo '
<languageid>' . $session->languageid . '</languageid>';
$gestures = pg_query($db, "SELECT sg.gestureid, sg.sequence, sg.collectedat, sg.committed,\n g.themeid, g.iconsmallpath, g.co2impact, gt.txt AS name FROM sessiongestures sg\n LEFT JOIN usersession s ON s.id = sg.sessionid\n LEFT JOIN gesture g ON g.id = sg.gestureid\n LEFT JOIN gesturetext gt ON gt.id = sg.gestureid AND\n gt.languageid = s.languageid AND\n gt.contenttype = 'name'\n WHERE sg.sessionid = " . $session->id . "\n ORDER BY sequence");
if (pg_num_rows($gestures) > 0) {
echo '
<gestures>';
while (is_object($gesture = pg_fetch_object($gestures))) {
echo '
<gesture>
<gestureid>' . $gesture->gestureid . '</gestureid>
<sequence>' . $gesture->sequence . '</sequence>
<collectedat>' . $gesture->collectedat . '</collectedat>
<committed>' . ($gesture->committed == "t" ? "1" : "0") . '</committed>
<themeid>' . $gesture->themeid . '</themeid>
<iconsmallpath><![CDATA[' . $gesture->iconsmallpath . ']]></iconsmallpath>
<iconsmallurl><![CDATA[http://' . $_SERVER['HTTP_HOST'] . $gesture->iconsmallpath . ']]></iconsmallurl>
<co2impact>' . $gesture->co2impact . '</co2impact>
<name><![CDATA[' . $gesture->name . ']]></name>
</gesture>';
}
echo '
</gestures>';
}
$messages = pg_query($db, "SELECT sm.gestureid, sm.sequence, sm.collectedat, sm.sent,\n g.themeid, g.iconsmallpath, g.co2impact, gt.txt AS name FROM sessionmessages sm\n LEFT JOIN usersession s ON s.id = sm.sessionid\n LEFT JOIN gesture g ON g.id = sm.gestureid\n LEFT JOIN gesturetext gt ON gt.id = sm.gestureid AND\n gt.languageid = s.languageid AND\n gt.contenttype = 'name'\n WHERE sm.sessionid = " . $session->id . "\n ORDER BY sequence");
if (pg_num_rows($messages) > 0) {
echo '
<messages>';
while (is_object($gesture = pg_fetch_object($messages))) {
echo '
<gesture>
<gestureid>' . $gesture->gestureid . '</gestureid>
<sequence>' . $gesture->sequence . '</sequence>
<collectedat>' . $gesture->collectedat . '</collectedat>
<sent>' . ($gesture->sent == "t" ? "1" : "0") . '</sent>
<themeid>' . $gesture->themeid . '</themeid>
<iconsmallpath><![CDATA[' . $gesture->iconsmallpath . ']]></iconsmallpath>
<iconsmallurl><![CDATA[http://' . $_SERVER['HTTP_HOST'] . $gesture->iconsmallpath . ']]></iconsmallurl>
<co2impact>' . $gesture->co2impact . '</co2impact>
<name><![CDATA[' . $gesture->name . ']]></name>
</gesture>';
}
echo '
</messages>';
}
echo '
</session>';
} else {
echoError(11, $sessionid);
}
}
echo ' checked';
}
?>
><span data-trans-key="reg-form"></span></td>
</tr>
<tr>
<td><input type="submit" name="registrovat" data-trans-key="reg-form"></td>
</tr>
</table>
</form>
<script>
$("[name=type]").change(function (){
var disabled = $("[name=type]:checked").val() == 1;
$("#uname").attr("disabled", disabled);
$("#os").attr("disabled", disabled);
$("[name=liga]").attr("disabled", disabled);
});
$(document).ready(function(){
$("[name=type]").change();
});
</script>
<?php
echoMessage($reg->GetMessage());
$err = $val->GetErrorMessage();
echoError(!empty($err) ? $err : $reg->GetErrorMessage());
page_footer();
?>
function checkSVNUrl($svn_url = "")
{
if (empty($svn_url) || $svn_url == 'https://svn1.intra.sina.com.cn/netdev/support/trunk/' || $svn_url == 'https://svn1.intra.sina.com.cn/netdev/support/trunk') {
echoError("此项目暂未做过配置, 请登陆http://admin.alarm.mix.sina.com.cn 修改项目配置\n");
}
}
/**
* check table entry
*
* This function is being used to check whether a record exists in a table or not against provided primary KEY of the table.
* It will return total number of rows found against provided tblField and value.
*
* @param $queryTbl name of the table to be queried
* @param $fieldValue value of the field to look for
* @param $tblField table field, by default its ID
* @param $qry_options QRY OPTIONS, by default empty
*
*
*/
public function checkTableEntry($queryTbl, $fieldValue, $tblField = "ID", $qry_options = "")
{
//---- check if database table exists or not
if (!($check = $this->checkTable($queryTbl))) {
echoError("Invalid table name ''" . $queryTbl . "'' requested|" . __FUNCTION__ . "|" . __LINE__ . "|" . get_parent_class($this) . "|");
exit;
}
//---- run qry and return number of rows
$sql = "SELECT " . $tblField . " FROM " . $queryTbl . " WHERE " . $tblField . " = '" . $fieldValue . "' " . $qry_options;
$result = $this->CR->db->runSQL($sql);
return $result->num_rows;
}
} else {
if ($link = db_connect()) {
$sql = "SELECT * FROM assignments a, contexts c, organisators o WHERE c.user_id = o.user_id AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.context_id = a.context_id AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.context_id = " . $_POST["id"] . " AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.user_id = " . $_SESSION["loggedUser"]->getId() . " ";
$result = mysqli_query($link, $sql);
if ($result && mysqli_num_rows($result) != 0 || isUserTypeLogged("Administrator")) {
?>
<meta http-equiv="refresh" content="0;url=addAssignment.php?id=<?php
echo $_POST["id"];
?>
"><?php
} else {
echoError('err-edit-assignment-rights');
}
mysqli_close($link);
} else {
echoError('err-db-connection-fail');
}
}
}
}
}
}
if (isUserTypeLogged("Administrator") || isUserTypeLogged("Jury")) {
prehlad_zadani(false);
?>
<br>
<form action="addAssignment.php">
<input type="submit" data-trans-key="new-assignment">
</form>
<br>
<?php
function setVisualizationState()
{
global $db;
$on = isset($_REQUEST["on"]) ? (bool) $_REQUEST["on"] : false;
$userid = isset($_REQUEST["userid"]) ? (int) $_REQUEST["userid"] : 0;
// <!-- setVisualizationState(on='.$on.', userid='.$userid.')-->';
if ($on) {
if ($userid == 0) {
echoError(2);
return;
}
if (setVisualizationActiveDB($userid) == 0) {
echoError(20);
return;
}
} else {
pg_query($db, "UPDATE exhibitionstate SET visualizationuserid = NULL");
}
$exhibitionstate = getExhibitionState();
if (is_object($exhibitionstate)) {
echo '
<visualizationstate>';
if ($exhibitionstate->visualizationuserid > 0) {
echo '
<on>1</on>
<userid>' . $exhibitionstate->visualizationuserid . '</userid>
</visualizationstate>';
} else {
echo '
<on>0</on>
</visualizationstate>';
}
}
}
/**
* Delete theme action
*/
public function actionDelete()
{
// Check Access
checkAccessThrowException('op_theme_delete');
if (isset($_GET['id']) && ($model = Theme::model()->findByPk($_GET['id']))) {
alog(at("Deleted Theme '{name}'.", array('{name}' => $model->name)));
// Make sure its not default
if ($model->dirname == getParam('default_theme')) {
if (isAjax()) {
echoError(at('You can not delete the default theme.'));
} else {
echoError(at('You can not delete the default theme.'));
}
}
// Make sure its not public
if ($model->is_active) {
if (isAjax()) {
echoError(at('You can not delete an active theme.'));
} else {
echoError(at('You can not delete an active theme.'));
}
}
$model->delete();
fok(at('Theme Deleted.'));
$this->redirect(array('themes/index'));
} else {
$this->redirect(array('themes/index'));
}
}
