|
\n"; // div that goes around the calendar grid and the eventlist/key
print " \n";
print " " . mysql_error() . " Please notify support."; return; } print "An Event has been added to the database successfully."; return; } function edit() { $id = isset($_REQUEST["id"]) ? intval($_REQUEST["id"]) : 0; $sql = "select * from calendar where id={$id} limit 1"; $res = mysql_query($sql); $row = mysql_fetch_assoc($res); $values = array(); $values["id"] = $row["id"]; $values["userid"] = $row["userid"]; $values["title"] = $row["title"]; $values["venue"] = $row["venue"]; $values["price"] = $row["price"]; $values["type"] = $row["event_type"]; $values["received"] = $row["received"]; $values["flier"] = $row["flier"]; $values["location"] = $row["location"]; $values["description"] = $row["description"]; $this->displayform("update", $values); return; } function update() { $id = isset($_REQUEST["id"]) ? intval($_REQUEST["id"]) : 0; $title = isset($_REQUEST["title"]) ? $_REQUEST["title"] : ""; $location = isset($_REQUEST["location"]) ? $_REQUEST["location"] : ""; $desc = isset($_REQUEST["description"]) ? $_REQUEST["description"] : ""; $venue = isset($_REQUEST["venue"]) ? $_REQUEST["venue"] : ""; $price = isset($_REQUEST["price"]) ? $_REQUEST["price"] : 0; $type = isset($_REQUEST["type"]) ? $_REQUEST["type"] : ""; $month = isset($_REQUEST["month"]) ? intval($_REQUEST["month"]) : 0; $date = isset($_REQUEST["date"]) ? intval($_REQUEST["date"]) : 0; $year = isset($_REQUEST["year"]) ? intval($_REQUEST["year"]) : 0; if (is_uploaded_file($_FILES["flier"]["tmp_name"])) { $uploadfile = FLIERUPLOADDIR . basename($_FILES["flier"]["name"]); if (!is_dir(FLIERUPLOADDIR)) { mkdir(FLIERUPLOADDIR); } if (!move_uploaded_file($_FILES["flier"]["tmp_name"], $uploadfile)) { print "I'm sorry, there was a problem with the upload of your flier image. Please try again. Thanks!"; return; } $sql = "update calendar set flier='{$uploadfile}' where id={$id}"; $res = mysql_query($sql); } $sql = "update calendar set location='{$location}', description='{$desc}', title='{$title}', venue='{$venue}', price='{$price}', event_type='{$type}', received='{$year}-{$month}-{$date}' where id={$id}"; $res = mysql_query($sql); if ($res == false) { print "There was an error updating the event record: "; print mysql_error(); return; } print "An event was updated successfully"; return; } function summary() { $sql = "select * from calendar order by received desc"; $res = mysql_query($sql); if (mysql_num_rows($res) > 0) { print "
";
print " ";
print "";
print "Title: " . $row["title"] . " ";
print "";
}
function main()
{
$mode = isset($_REQUEST["mode"]) ? $_REQUEST["mode"] : "";
switch ($mode)
{
case "add":
$this->add();
break;
case "insert":
$this->insert();
break;
case "edit":
$this->edit();
break;
case "update":
$this->update();
break;
case "delete":
$this->delete();
break;
case "view":
$this->view();
break;
case "summary":
$this->summary();
break;
case "view":
$this->view();
break;
default:
$this->showgrid();
break;
}
}
}
$e = new events();
$e->main();
/* user config variables */
$max_items = 5; /* max number of news items to show */
function displayNews($all = 0) {
/* bring in two variables
* $db is our database connection
* $max_items is the maximum number
* of news items we want to display */
global $db, $max_items;
$level = isset($_SESSION["user_level"]) ? intval($_SESSION["user_level"]) : 0;
/* query for news items */
if ($all == 0) {
/* this query is for up to $max_items */
$query = "SELECT id,title,newstext," .
"DATE_FORMAT(postdate, '%Y-%m-%d') as date " .
"FROM news ORDER BY postdate DESC LIMIT $max_items";
} else {
/* this query will get all news */
$query = "SELECT id,title,newstext," .
"DATE_FORMAT(postdate, '%Y-%m-%d') as date " .
"FROM news ORDER BY postdate DESC";
}
$result = mysql_query ($query) or die("index.php: " . mysql_error());
while ($row = mysql_fetch_assoc ($result))
{
/* display news in a simple table */
echo ""; print "Date: " . strftime("%Y-%m-%d", $row["receivedepoch"]) . " "; print "Price: " . $row["price"] . " "; print "Location: " . $row["location"] . " "; print "Description: " . $row["description"] . " "; print "  ";
print "
\n"; } /* if we aren't displaying all news, * then give a link to do so */ if ($all == 0) { echo "View all news\n"; } } function displayOneItem($id) { global $db; /* query for item */ $query = "SELECT * FROM news WHERE id=$id"; $result = mysql_query ($query); /* if we get no results back, error out */ if (mysql_num_rows ($result) == 0) { echo "Bad news id\n"; return; } $row = mysql_fetch_assoc($result); echo "
\n"; } /* this is where the script decides what do do */ $action = isset($_GET["action"]) ? $_GET["action"] : ""; echo " |
|
||||||||||||||||||||||||||
 |
|
||||||||||||||||||||||||||
 |
|
||||||||||||||||||||||||||
 |
|
||||||||||||||||||||||||||
 |
 |
|
|||||||||||||||||||||||||
 |
 |
|
|||||||||||||||||||||||||
 |
 |
|
|||||||||||||||||||||||||
 |
 |
|
|||||||||||||||||||||||||
 |
|
||||||||||||||||||||||||||