Esempio n. 1
0
function DisplayHousebyID($id)
{
    $myquery = "Select * FROM Houses Where ID = '{$id}'";
    $MyRows = GetResult($myquery);
    if (count($MyRows) == 0) {
        echo "<h1>House ID Invalid</h1>";
    }
    foreach ($MyRows as $row) {
        DisplayHousePage($id, $row["Address"], $row["HouseDesc"], $row["Beds"], $row["Toilets"], $row["Garages"], $row["Image"]);
    }
}
Esempio n. 2
0
function PrintHouseList($query)
{
    echo "<div id='PopList'>\n\t\t\t\t<h1> House Results </h1>\n\t\t\t\t<div class='HouseList'>";
    $MyRows = GetResult($query);
    if (count($MyRows) == 0) {
        echo "<h1>No Houses Match Search Criteria</h1>";
    }
    foreach ($MyRows as $row) {
        $myHouse = new House($row);
        PrintHouse($myHouse);
    }
    echo "</div></div></body></HTML>";
}
Esempio n. 3
0
 public function CheckStudent($realname, $sex, $classid, $classmate)
 {
     $class_arr = M('User')->field('user.id,user.realname,user.sex,user.username')->table('user user,alumnus alumnus')->where('alumnus.user_id = `user`.id AND class_id=%d', $classid)->select();
     // 处理用户名
     $realname = trim($realname);
     $classmate = trim($classmate);
     // 查找存在情况
     $find_user = false;
     $find_classmate = false;
     $backup_user = null;
     // 防止出现同名用户抢占性别不确定用户的情况
     $res_arr = array('userid' => -1);
     if ($sex != 1 && $sex != 2) {
         return GetResult(false, '性别数据有误');
     }
     foreach ($class_arr as $key => $value) {
         // 查找姓名
         if ($value['realname'] == $realname) {
             if ($value['username'] != null) {
                 continue;
             }
             $find_user = true;
             $this->where('id=%d', $value['id'])->setField('sex', $sex);
             $res_arr['userid'] = $value['id'];
             continue;
         }
         // 查找同学
         if ($value['realname'] == $classmate) {
             $find_classmate = true;
         }
     }
     if ($find_user) {
         if ($find_classmate) {
             // 完成验证
             $res_arr['status'] = true;
         } else {
             // 找不到同学
             $res_arr['status'] = false;
             $res_arr['info'] = '该班级没有该姓名的同学';
         }
     } else {
         // 找不到姓名
         $res_arr['status'] = false;
         $res_arr['info'] = '对不起,该班级未注册成员中不存在您';
     }
     return $res_arr;
 }
Esempio n. 4
0
 public function ClassChange()
 {
     if (IS_POST) {
         $data = array('id' => I('id'), 'classname' => I('name'), 'headmaster' => I('headmaster'), 'attendandate_id' => I('attendandate'));
         // 判断是否存在空字段
         if (CheckFieldNotNull($data) == false) {
             echo GetResult(false, '有字段为空');
             return;
         }
         // 入库
         $id = D('Class')->ChangeClass($data);
         if ($id > 0) {
             echo GetResult();
         } else {
             echo GetResult(false, '操作失败,数据未修改或系统繁忙');
         }
     }
 }
Esempio n. 5
0
 public function CreateActivity($title, $content, $classid, $aid, $options = array())
 {
     $data = array('activitytitle' => $title, 'activitycontent' => $content, 'user_id' => session('id'), 'class_id' => $classid, 'checkidetifier' => C('ACTIVITY_CHECK_DEFAULT'));
     trace($data);
     if (CheckFieldNotNull($data) == false) {
         return GetResult(false, '存在未填字段');
     }
     $data = array_merge($data, $options);
     if ($aid == -1) {
         $id = $this->add($data);
     } else {
         $this->where('id=%d', $aid)->save($data);
         $id = $aid;
     }
     if ($id > 0) {
         return GetResult(true, '操作成功', array('id' => $id));
     } else {
         return GetResult(false);
     }
 }
Esempio n. 6
0
function GetBookings($Username)
{
    $select = "Select * from Bookings Where UserID = '{$Username}'";
    return GetResult($select);
}
 * | # m h d M W
 * |   0,10,20,30,40,50 * * * * www-data /usr/bin/php5 -f /home/www/evegate/cron/cron_messages_forward.php
 * |
 * |
 */
include 'include/db.php';
include 'include/api_calls.php';
include 'include/config.php';
function SendMail($to1, $from, $subject, $message, $charset = "utf-8")
{
    $headers = 'MIME-Version: 1.0' . "\r\n";
    $headers .= 'Content-type: text/html; charset=' . $charset . "\r\n";
    $headers .= 'From: ' . $from . "\r\n";
    mail($to1, $subject, $message, $headers);
}
$api_keys_array = GetResult("SELECT * FROM api_keys WHERE key_id>0 and forward_mail>'' ");
foreach ($api_keys_array as $single_key) {
    $keyID = $single_key["key_id"];
    $vCode = $single_key["v_code"];
    $forwardmail = $single_key["forward_mail"];
    $filters = unserialize($single_key['filters']);
    //get api user
    $url = 'https://api.eveonline.com/account/APIKeyInfo.xml.aspx?keyID=' . $keyID . '&vCode=' . $vCode;
    $xml_object = simplexml_load_string(file_get_contents($url));
    $xml_array = object2array($xml_object);
    $characterID = $xml_array["result"]["key"]["rowset"]["row"]["@attributes"]["characterID"];
    $characterNAME = getUserNameByID($characterID);
    //get mail headers
    $maildata = "https://api.eveonline.com/char/MailMessages.xml.aspx?characterID={$characterID}&keyID={$keyID}&vCode={$vCode}";
    $xml_object2 = simplexml_load_string(file_get_contents($maildata));
    $xml_array2 = object2array($xml_object2);
Esempio n. 8
0
function GetUsers()
{
    $SelectQuery = "Select * From Users";
    return GetResult($SelectQuery);
}