PHP get_program_updateの例

コード例 #1

ファイル: copy_event_instance.php プロジェクト: nchiapol/ecamp

 * (at your option) any later version.
 *
 * eCamp is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with eCamp.  If not, see <http://www.gnu.org/licenses/>.
 */
include 'inc/get_program_update.php';
$event_instance_id = mysql_real_escape_string($_REQUEST['event_instance_id']);
$time = mysql_real_escape_string($_REQUEST['time']);
$_camp->event_instance($event_instance_id) || die("error");
$query = "\tSELECT\n\t\t\t\t\tlength\n\t\t\t\tFROM\n\t\t\t\t\tevent_instance\n\t\t\t\tWHERE\n\t\t\t\t\tid = {$event_instance_id}";
$result = mysql_query($query);
$length = implode(mysql_fetch_row($result));
if ($length > 60) {
    $new_length = $length / 2;
    $query = "UPDATE event_instance SET length = {$new_length} WHERE id = {$event_instance_id}";
    mysql_query($query);
    $move = $new_length;
} else {
    $move = length;
}
$query = "\tINSERT INTO\n\t\t\t\t\tevent_instance\n\t\t\t\t(event_id, day_id, starttime, length, dleft, width)\t\n\t\t\t\t(\tSELECT\n\t\t\t\t\t\tevent_id,\n\t\t\t\t\t\tday_id,\n\t\t\t\t\t\t(starttime + {$move}) as starttime,\n\t\t\t\t\t\tlength,\n\t\t\t\t\t\tdleft,\n\t\t\t\t\t\twidth\n\t\t\t\t\tFROM\n\t\t\t\t\t\tevent_instance\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tid = {$event_instance_id}\n\t\t\t\t)";
mysql_query($query);
header("Content-type: application/json");
$ans = get_program_update($time);
echo json_encode($ans);
die;

コード例 #2

ファイル: load_gp_data.php プロジェクト: nchiapol/ecamp

<?php

/*
 * Copyright (C) 2010 Urban Suppiger, Pirmin Mattmann
 *
 * This file is part of eCamp.
 *
 * eCamp is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * eCamp is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with eCamp.  If not, see <http://www.gnu.org/licenses/>.
 */
include 'inc/get_program_update.php';
$time = mysql_real_escape_string($_REQUEST['time']);
$data = get_program_update($time);
header("Content-type: application/json");
echo json_encode($data);
die;