PHP Event::select方法代码示例

 function calendar($y = FALSE, $m = FALSE)
 {
     if (!$this->connected) {
         $this->layout = "layouts/public";
     }
     $this->load->library('calendar');
     $e = new Event();
     $y = $y ? $y : date('Y');
     $m = $m ? $m : date('m');
     $events = $e->select('DAY(start) AS day,events.id,title,description,cost')->where('MONTH(start)', $m)->where('YEAR(start)', $y)->include_related('category', array('color'))->get_iterated();
     $this->load->helper('text');
     $ul = array();
     foreach ($events as $e) {
         $ul[$e->day][] = '<span class="label" style="background:' . $e->category_color . ';">' . anchor('events/show/' . $e->id, ellipsize($e->title, 20, 1, '..'), 'id="' . $e->id . '" class="tip" data-toggle="modal" data-original-title="' . $e->title . '"') . '</span>';
     }
     $data = array();
     foreach ($ul as $day => $event) {
         $data[$day] = ul($event, array('class' => 'unstyled sortable'));
     }
     $this->data['calendar'] = $this->calendar->generate($y, $m, $data);
     $c = new Category();
     $this->data['categories'] = $c->get_iterated();
 }

if (!isset($member) || !isset($eventObj) || substr($_SERVER['PHP_SELF'], -strlen("manage.php")) != "manage.php") {
    include_once "../../../_setup.php";
    include_once "../../../classes/member.php";
    include_once "../../../classes/event.php";
    // Start Page
    $consoleObj = new ConsoleOption($mysqli);
    $cID = $consoleObj->findConsoleIDByName("Manage My Events");
    $consoleObj->select($cID);
    $consoleInfo = $consoleObj->get_info_filtered();
    $consoleTitle = $consoleInfo['pagetitle'];
    $member = new Member($mysqli);
    $member->select($_SESSION['btUsername']);
    $eventObj = new Event($mysqli);
    $memberInfo = $member->get_info();
    // Check Login
    if ($member->authorizeLogin($_SESSION['btPassword']) && $member->hasAccess($consoleObj) && $eventObj->select($_GET['eID']) && ($eventObj->memberHasAccess($memberInfo['member_id'], "eventpositions") || $memberInfo['rank_id'] == 1)) {
        $eventInfo = $eventObj->get_info_filtered();
    } else {
        exit;
    }
} else {
    $memberInfo = $member->get_info();
    $consoleObj->select($consoleObj->findConsoleIDByName("Manage My Events"));
    if (!$member->hasAccess($consoleObj) || !$eventObj->memberHasAccess($memberInfo['member_id'], "eventpositions")) {
        exit;
    }
}
echo "\n<table class='formTable' style='border-spacing: 0px; margin-top: 0px'>\n\t<tr><td colspan='5' class='dottedLine'></td></tr>\n";
$counter = 0;
$x = 1;
$eventObj->objEventPosition->setCategoryKeyValue($eventInfo['event_id']);

 */
include_once "../../../_setup.php";
include_once "../../../classes/member.php";
include_once "../../../classes/rank.php";
include_once "../../../classes/consoleoption.php";
include_once "../../../classes/event.php";
if (!isset($eventObj)) {
    $member = new Member($mysqli);
    $member->select($_SESSION['btUsername']);
    $memberInfo = $member->get_info_filtered();
    $objMember = new Member($mysqli);
    $eventObj = new Event($mysqli);
    $consoleObj = new ConsoleOption($mysqli);
    $eventID = $_POST['eID'];
}
if (!$eventObj->select($eventID)) {
    exit;
}
echo "<ul>";
$focusID = "";
$result = $mysqli->query("SELECT * FROM " . $dbprefix . "eventmessages WHERE event_id = '" . $eventID . "' ORDER BY dateposted DESC");
while ($row = $result->fetch_assoc()) {
    $objMember->select($row['member_id']);
    $memInfo = $objMember->get_info_filtered();
    if ($memInfo['profilepic'] == "") {
        $dispProfilePic = $MAIN_ROOT . "themes/" . $THEME . "/images/defaultprofile.png";
    } else {
        $dispProfilePic = $MAIN_ROOT . $memInfo['profilepic'];
    }
    $dispDeleteMessage = "";
    if ($eventObj->memberHasAccess($memberInfo['member_id'], "managemessages")) {

        exit;
    }
} else {
    $memberInfo = $member->get_info();
    $consoleObj->select($consoleObj->findConsoleIDByName("View Event Invitations"));
    if (!$member->hasAccess($consoleObj)) {
        exit;
    }
}
$result = $mysqli->query("SELECT em.* FROM " . $dbprefix . "events_members em, " . $dbprefix . "events e WHERE em.event_id = e.event_id AND em.hide = '0' AND em.member_id = '" . $memberInfo['member_id'] . "'");
if ($result->num_rows > 0) {
    echo "<table class='formTable' style='margin-top: 0px; border-spacing: 0px'>";
    $counter = 0;
    while ($row = $result->fetch_assoc()) {
        $row = filterArray($row);
        $eventObj->select($row['event_id']);
        $eventInfo = $eventObj->get_info_filtered();
        if ($member->select($row['invitedbymember_id'])) {
            $dispInvitedByLink = $member->getMemberLink();
        } elseif ($member->select($eventInfo['member_id'])) {
            $dispInvitedByLink = $member->getMemberLink();
        } else {
            $dispInvitedByLink = "<i>Unknown</i>";
        }
        if ($counter == 1) {
            $addCSS = " alternateBGColor";
            $counter = 0;
        } else {
            $addCSS = "";
            $counter = 1;
        }

         echo '</select><br><select name="headname">';
         foreach ($h->getHeads('vol') as $head) {
             // name of all event volunteers from the DB
             echo '<option>', $head['username'], '</option>';
         }
         // we set a hidden input eventvol to eventvol, so that we know we want to assign an event to volunteer
         echo '</select><br><input type="hidden" name="eventvol" value="eventvol"/><input type="submit" value="Assign" /></form>';
     }
     break;
 case 'eventcat':
     // case -> assign event to catagory
     if (isset($_POST['eventcat'])) {
         if (isset($_POST['eventname']) and isset($_POST['catname'])) {
             $e = new Event();
             $c = new Catagory();
             if ($e->select($_POST['eventname'])) {
                 if ($c->select($_POST['catname'])) {
                     echo $c->addEvent($e->getId());
                     // assigning the event to catagory
                 } else {
                     echo 'Catagory Does Not Exist';
                 }
             } else {
                 echo 'Event Does Not Exist';
             }
         } else {
             echo 'Please check your entries';
         }
     } else {
         // displaying the list of all events and heads
         $e = new Event();

 * Website: http://www.bluethrust.com
 *
 * License: http://www.bluethrust.com/license.php
 *
 */
include_once "../../../../_setup.php";
include_once "../../../../classes/member.php";
include_once "../../../../classes/event.php";
// Start Page
$consoleObj = new ConsoleOption($mysqli);
$cID = $consoleObj->findConsoleIDByName("View Event Invitations");
$consoleObj->select($cID);
$consoleInfo = $consoleObj->get_info_filtered();
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$eventObj = new Event($mysqli);
// Check Login
if ($member->authorizeLogin($_SESSION['btPassword']) && $member->hasAccess($consoleObj)) {
    $memberInfo = $member->get_info();
} else {
    exit;
}
if ($eventObj->objEventMember->select($_POST['emID']) && $eventObj->objEventMember->get_info("member_id") == $memberInfo['member_id']) {
    $eventMemberInfo = $eventObj->objEventMember->get_info_filtered();
    $eventObj->select($eventMemberInfo['event_id']);
    $eventInfo = $eventObj->get_info_filtered();
    if ($eventInfo['startdate'] <= time() && $eventMemberInfo['status'] == 1) {
        $eventObj->objEventMember->update(array("attendconfirm_member"), array("1"));
    }
    include "invitelist.php";
}

 */
include "../../../_setup.php";
include_once "../../../classes/member.php";
include_once "../../../classes/rank.php";
include_once "../../../classes/consoleoption.php";
include_once "../../../classes/event.php";
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$objMember = new Member($mysqli);
$eventObj = new Event($mysqli);
$consoleObj = new ConsoleOption($mysqli);
$cID = $consoleObj->findConsoleIDByName("Manage My Events");
$consoleObj->select($cID);
if ($member->authorizeLogin($_SESSION['btPassword']) && $eventObj->objEventMessage->select($_POST['messageID'])) {
    $eventID = $eventObj->objEventMessage->get_info("event_id");
    $eventObj->select($eventID);
    $eventInfo = $eventObj->get_info_filtered();
    $memberInfo = $member->get_info_filtered();
    if (trim($_POST['commentMessage']) != "" && $member->hasAccess($consoleObj) && ($eventObj->memberHasAccess($memberInfo['member_id'], "postmessages") || $memberInfo['rank_id'] == 1)) {
        $eventObj->objEventMessageComment->addNew(array("eventmessage_id", "member_id", "dateposted", "comment"), array($_POST['messageID'], $memberInfo['member_id'], time(), $_POST['commentMessage']));
    }
    if (in_array($memberInfo['member_id'], $eventObj->getInvitedMembers(true)) || $memberInfo['member_id'] == $eventInfo['member_id'] || $memberInfo['rank_id'] == 1) {
        $result = $mysqli->query("SELECT * FROM " . $dbprefix . "eventmessage_comment WHERE eventmessage_id = '" . $_POST['messageID'] . "' ORDER BY dateposted ASC");
        while ($row = $result->fetch_assoc()) {
            if ($objMember->select($row['member_id'])) {
                $memInfo = $objMember->get_info_filtered();
                if ($memInfo['profilepic'] == "") {
                    $dispProfilePic = $MAIN_ROOT . "themes/" . $THEME . "/images/defaultprofile.png";
                } else {
                    $dispProfilePic = $MAIN_ROOT . $memInfo['profilepic'];
                }

// Config File
$prevFolder = "../";
include $prevFolder . "_setup.php";
$consoleObj = new ConsoleOption($mysqli);
$eventObj = new Event($mysqli);
$member = new Member($mysqli);
$ipbanObj = new Basic($mysqli, "ipban", "ipaddress");
if ($ipbanObj->select($IP_ADDRESS, false)) {
    $ipbanInfo = $ipbanObj->get_info();
    if (time() < $ipbanInfo['exptime'] or $ipbanInfo['exptime'] == 0) {
        die("<script type='text/javascript'>window.location = '" . $MAIN_ROOT . "banned.php';</script>");
    } else {
        $ipbanObj->delete();
    }
}
if (!$eventObj->select($_GET['eID'])) {
    echo "\n\t\t<script type='text/javascript'>\n\t\t\twindow.location = '" . $MAIN_ROOT . "events';\n\t\t</script>\n\t";
    exit;
}
$eventInfo = $eventObj->get_info_filtered();
$eventPgMemberObj = new Member($mysqli);
$dispCreatorLink = "Unknown";
if ($eventPgMemberObj->select($eventInfo['member_id'])) {
    $dispCreatorLink = $eventPgMemberObj->getMemberLink();
}
$eventMemberProfilePic = $eventPgMemberObj->get_info_filtered("profilepic");
if ($eventMemberProfilePic == "") {
    $eventMemberProfilePic = $MAIN_ROOT . "themes/" . $THEME . "/images/defaultprofile.png";
} else {
    $eventMemberProfilePic = $MAIN_ROOT . $eventMemberProfilePic;
}

require '../config.php';
require '../classes/Database.php';
require '../classes/Event.php';
require '../classes/EventCategory.php';
require '../classes/Location.php';
$db = new Database(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);
$out = [];
if (isset($_GET['code'])) {
    $code = $_GET['code'];
    if (isset($_GET['type']) && $_GET['type'] == 'short') {
        $e = Event::selectShort($db, $code, FALSE);
        if ($e != NULL) {
            $out = $e;
        }
    } else {
        $e = Event::select($db, $code, FALSE);
        //print_r($e);
        if ($e != NULL) {
            $cat = EventCategory::select($db, $e[Event::EVENT_CAT_ID]);
            $e["cat_name"] = $category = $cat->getName();
            $locid = $e[Event::EVENT_LOCATIONID];
            $loc = Location::select($db, $locid);
            $location = isset($loc) ? $loc->getName() : "notset";
            $loc_type = isset($loc) ? $loc->getType() : "notset";
            $loc_lon = isset($loc) ? $loc->getLongitude() : "notset";
            $loc_latt = isset($loc) ? $loc->getLattitude() : "notset";
            $e['location_name'] = $location;
            $e['location_type'] = $loc_type;
            $e['location_lattitude'] = $loc_latt;
            $e['location_longitude'] = $loc_lon;
            $longdesc = $e[Event::EVENT_LONGDESC];

 * Website: http://www.bluethrust.com
 *
 * License: http://www.bluethrust.com/license.php
 *
 */
include "../../../_setup.php";
include_once "../../../classes/member.php";
include_once "../../../classes/rank.php";
include_once "../../../classes/consoleoption.php";
include_once "../../../classes/event.php";
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$eventObj = new Event($mysqli);
$consoleObj = new ConsoleOption($mysqli);
$cID = $consoleObj->findConsoleIDByName("Manage My Events");
$consoleObj->select($cID);
if ($member->authorizeLogin($_SESSION['btPassword']) && $eventObj->objEventPosition->select($_POST['posID'])) {
    $eventID = $eventObj->objEventPosition->get_info("event_id");
    $memberInfo = $member->get_info_filtered();
    $eventPositionInfo = $eventObj->objEventPosition->get_info_filtered();
    if ($memberInfo['rank_id'] == 1 || $member->hasAccess($consoleObj) && $eventObj->select($eventID) && ($eventObj->memberHasAccess($memberInfo['member_id'], "eventpositions") || $memberInfo['rank_id'] == 1)) {
        if ($_POST['confirmDelete'] == 1) {
            $eventObj->objEventPosition->delete();
            $mysqli->query("UPDATE " . $dbprefix . "events_members SET position_id = '0' WHERE position_id = '" . $eventPositionInfo['position_id'] . "'");
            $_GET['eID'] = $eventID;
            include "manageposition_main.php";
        } else {
            echo "\n\t\t\t\n\t\t\t\t<div id='confirmDeleteMessage' style='display: none'>\n\t\t\t\t\t<p class='main' align='center'>\n\t\t\t\t\t\tAre you sure you want to delete the position: <b>" . $eventPositionInfo['name'] . "</b>?<br><br>\n\t\t\t\t\t\tAll members with this position will lose this position once it is deleted.\n\t\t\t\t\t</p>\n\t\t\t\t</div>\n\t\t\t\n\t\t\t\t\n\t\t\t\t<script type='text/javascript'>\n\n\t\t\t\t\t\$(document).ready(function() {\n\t\t\t\t\t\n\t\t\t\t\t\t\$('#confirmDeleteMessage').dialog({\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\ttitle: 'Manage Event Positions - Confirm Delete',\n\t\t\t\t\t\t\tmodal: true,\n\t\t\t\t\t\t\tzIndex: 99999,\n\t\t\t\t\t\t\tshow: 'scale',\n\t\t\t\t\t\t\tresizable: false,\n\t\t\t\t\t\t\twidth: 450,\n\t\t\t\t\t\t\tbuttons: {\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t'Yes': function() {\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\$('#positionListDiv').fadeOut(250);\n\t\t\t\t\t\t\t\t\t\$('#loadingSpiral').show();\n\t\t\t\t\t\t\t\t\t\$.post('" . $MAIN_ROOT . "members/events/include/manageposition_delete.php', { posID: '" . $eventPositionInfo['position_id'] . "', confirmDelete: 1 }, function(data) {\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\$('#positionListDiv').html(data);\n\t\t\t\t\t\t\t\t\t\t\$('#positionListDiv').fadeIn(250);\n\t\t\t\t\t\t\t\t\t\t\$('#loadingSpiral').hide();\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t});\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\$(this).dialog('close');\n\t\t\t\t\t\t\t\t},\n\t\t\t\t\t\t\t\t'Cancel': function() {\n\t\t\t\t\t\t\t\t\t\$(this).dialog('close');\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t}\t\t\t\t\t\n\n\t\t\t\t\t\t});\n\t\t\t\t\t\n\t\t\t\t\t});\n\t\t\t\t\n\t\t\t\t</script>\n\t\t\t\n\t\t\t";
        }
    }
}

 * License: http://www.bluethrust.com/license.php
 *
 */
include "../../../_setup.php";
include_once "../../../classes/member.php";
include_once "../../../classes/event.php";
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$eventObj = new Event($mysqli);
$consoleObj = new ConsoleOption($mysqli);
$cID = $consoleObj->findConsoleIDByName("Manage My Events");
$consoleObj->select($cID);
if ($member->authorizeLogin($_SESSION['btPassword']) && $eventObj->objEventMember->select($_POST['eMemID'])) {
    $eventID = $eventObj->objEventMember->get_info("event_id");
    $memberInfo = $member->get_info_filtered();
    if ($eventObj->select($eventID) && $member->hasAccess($consoleObj) && ($eventObj->memberHasAccess($memberInfo['member_id'], "manageinvites") || $eventObj->memberHasAccess($memberInfo['member_id'], "attendenceconfirm") || $memberInfo['rank_id'] == 1)) {
        $eventInfo = $eventObj->get_info_filtered();
        $eventMemberInfo = $eventObj->objEventMember->get_info_filtered();
        $objInviteMember = new Member($mysqli);
        $objInviteMember->select($eventMemberInfo['member_id']);
        $inviteMemberInfo = $objInviteMember->get_info_filtered();
        $countErrors = 0;
        $dispError = "";
        if (isset($_POST['submit'])) {
            $arrColumns = array();
            $arrValues = array();
            if ($eventObj->memberHasAccess($memberInfo['member_id'], "mangeinvites")) {
                $arrColumns[] = "position_id";
                $arrValues[] = $_POST['updatePositionID'];
                $checkSelectPosition = $eventObj->objEventPosition->select($_POST['updatePositionID']);
                // Check Position ID

$cID = $consoleObj->findConsoleIDByName("Manage My Events");
$consoleObj->select($cID);
$consoleInfo = $consoleObj->get_info_filtered();
$consoleTitle = $consoleInfo['pagetitle'];
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$pID = strtolower($_GET['pID']);
$eID = $_GET['eID'];
// Check Login
$LOGIN_FAIL = true;
$blnShowPage = false;
if ($member->authorizeLogin($_SESSION['btPassword'])) {
    $LOGIN_FAIL = false;
    $memberInfo = $member->get_info_filtered();
    $eventObj = new Event($mysqli);
    if ($eventObj->select($eID)) {
        $arrMembers = $eventObj->getInvitedMembers(true);
        if (in_array($memberInfo['member_id'], $arrMembers) || $eventObj->get_info("member_id") == $memberInfo['member_id'] || $memberInfo['rank_id'] == 1) {
            $blnShowPage = true;
            $eventInfo = $eventObj->get_info_filtered();
        }
    }
}
if ($LOGIN_FAIL) {
    die("<script type='text/javascript'>window.location = '" . $MAIN_ROOT . "login.php';</script>");
}
$_SESSION['btEventID'] = "";
$prevFolder = "../../";
$PAGE_NAME = $consoleTitle . " - ";
$dispBreadCrumb = "<a href='" . $MAIN_ROOT . "'>Home</a> > <a href='" . $MAIN_ROOT . "members'>My Account</a> > " . $consoleTitle;
$EXTERNAL_JAVASCRIPT .= "\n<script type='text/javascript' src='" . $MAIN_ROOT . "members/js/console.js'></script>\n<script type='text/javascript' src='" . $MAIN_ROOT . "members/js/main.js'></script>\n";

<?php

include_once $CFG->dirroot . "/lib/classes/" . "application/Event.Class.php5";
$eventObj = new Event();
$GeneralObj->getRequestVars();
$section = 'Events';
$mode = $_REQUEST['mode'];
if ($mode == "Update") {
    $eventObj->select($iEventId);
    $eventObj->getAllVar();
    if ($dEventDateTime != "0000-00-00 00:00:00") {
        $iStarttime = date("H", strtotime($dEventDateTime));
        $iStartTimeMM = date("i", strtotime($dEventDateTime));
        $dEventDateTime = substr($dEventDateTime, 0, 10);
    }
    if ($iStarttime > 12) {
        $iStarttime = $iStarttime - 12;
        $SAMPM = "PM";
    } else {
        $SAMPM = "AM";
    }
    /*
    	 if($iEndTimeHH >12)
    	 { $iEndTimeHH=$iEndTimeHH-12;
    	$EAMPM="PM";
    	}
    	else
    	{ $EAMPM="AM";}
    */
} else {
    $mode = "Add";

 *
 * Author: Bluethrust Web Development
 * E-mail: support@bluethrust.com
 * Website: http://www.bluethrust.com
 *
 * License: http://www.bluethrust.com/license.php
 *
 */
include "../../../_setup.php";
include_once "../../../classes/member.php";
include_once "../../../classes/rank.php";
include_once "../../../classes/consoleoption.php";
include_once "../../../classes/event.php";
include_once "../../../classes/chatroom.php";
$member = new Member($mysqli);
$member->select($_SESSION['btUsername']);
$objMember = new Member($mysqli);
$eventObj = new Event($mysqli);
$eventChatObj = new ChatRoom($mysqli);
$consoleObj = new ConsoleOption($mysqli);
$cID = $consoleObj->findConsoleIDByName("Manage My Events");
$consoleObj->select($cID);
if ($member->authorizeLogin($_SESSION['btPassword']) && $eventChatObj->select($_POST['ecID'])) {
    $memberInfo = $member->get_info_filtered();
    $eventChatInfo = $eventChatObj->get_info_filtered();
    $eventObj->select($eventChatInfo['event_id']);
    if (in_array($memberInfo['member_id'], $eventObj->getInvitedMembers(true)) || $memberInfo['member_id'] == $eventInfo['member_id']) {
        $eventInfo = $eventObj->get_info_filtered();
        $eventID = $eventInfo['event_id'];
    }
}

<?php

require_once 'connection.php';
$session = new Session();
if (!$session->getLoggedin()) {
    header("Location: login.php");
}
$user = User::select($db, $session->getUsername());
if (!isset($_GET['eventcode']) && $session->getUsertype() == Session::USER_REGULAR || $session->getUsertype() == Session::USER_MANAGER && $user->getEventcode() != $_GET['eventcode']) {
    die("error!! No Access!!");
}
$eventcode = $_GET['eventcode'];
$event = Event::select($db, $eventcode);
$eventname = $event->getName();
$shortdesc = $event->getShort_desc();
$longdesc = $event->getLong_desc();
$tags = $event->getTags();
$contacts = $event->getContacts();
$prize = $event->getPrize();
$prtpnt = $event->getPrtpnt();
$timings = $event->getTimings();
$venue = $event->getLocation_id();
$venue = Location::select($db, $venue);
require './includes/metadetails.php';
?>
<body>
    <script type="text/javascript" src="js/markitup/jquery.markitup.js"></script>
    <script type="text/javascript" src="js/markitup/settings.js"></script>

    <?php 
require './includes/header.php';