include("../include/global_var.inc"); include("$incrp/album_session.php"); include("$incrp/var_db.php"); $getId = ""; $getTitle = ""; $getDate = ""; $getLocation = ""; $getDesc = ""; $getEquip = ""; $link = mysql_connect($db_host, $db_user, $db_pw) or die ("can't connect"); if (isset($HTTP_POST_VARS["frmAction"]) && $HTTP_POST_VARS["frmAction"] == "sent") { $event_id = $HTTP_POST_VARS["event_id"]; $date_created = date("Y-m-d H:i:s"); $event_date = $HTTP_POST_VARS["event_date"]; $event_title = $HTTP_POST_VARS["event_title"]; $event_loc = $HTTP_POST_VARS["event_loc"]; $event_desc = $HTTP_POST_VARS["event_desc"]; $photo_equip = $HTTP_POST_VARS["photo_equip"]; if ($usr_id == "") { $err_msg = "you are not logged in."; } else { if (empty($event_id)) { $usrDirQuery = "select user_dir from album.album_user where id = $usr_id"; $usrDirRs = mysql_query($usrDirQuery, $link); $usrDirRow = mysql_fetch_row($usrDirRs); $usrDir = "/album" . $usrDirRow[0] . "/images"; $event_insert = "insert into album.album_event values(0, $usr_id, '$event_date', '$event_title', '$usrDir', '$event_loc', '$event_desc', '$photo_equip', '$date_created')"; //$newEventId = mysql_insert_id($link); //$event_dir = $usrDir . "/$newEventId"; } else { $event_insert = "update album.album_event set event_date = '$event_date', event_title = '$event_title', event_location ='$event_loc', description ='$event_desc', equipment = '$photo_equip' where id = $event_id"; } $status = mysql_query($event_insert, $link); if ($status) { $retStr = "Yeah! Save successful."; } else { $retStr = "Save was unsuccessful. Please try again. email kathy if you continue to have problems."; } } } elseif (isset($HTTP_GET_VARS["eid"])) { $getId = $HTTP_GET_VARS["eid"]; $getQuery = "select id, user_id, DATE_FORMAT(event_date, '%m/%d/%Y') event_date, event_title, event_location, description, equipment from album.album_event where id = $getId and user_id = $usr_id"; $getRs = mysql_query($getQuery, $link); $getRows = mysql_fetch_array($getRs); $getId = $getRows["id"]; $getLocation = $getRows["event_location"]; $getTitle = $getRows["event_title"]; $getDate = $getRows["event_date"]; $getDesc = $getRows["description"]; $getEquip = $getRows["equipment"]; } elseif ($usr_id == "") { header("Location: /user/login.php"); } mysql_close($link); $pgeTitle = "Add Event"; $pgeKeywords = "online photo album add event"; $pgeContent = "Online photo album: Add Event"; $pgeJavascript = " "; $pgeContent = "
| ";
if (isset($err_msg) && $err_msg != "") {
$pgeContent .= " $err_msg "; } if (isset($retStr)) { $pgeContent .= " $retStr "; } $pgeContent .= " |