include "login.php";
include "conn.inc";
if ($_SESSION["userId"]){
if ($_SESSION["userLevel"] == 0) {
// delete contact
if ($_GET["del"]) {
$delID = $_GET["del"];
// delete event
$sql="delete from wd_event where e_id = $delID";
$delRes=mysql_query($sql) or die ("Delete Error: ".mysql_error());
}
// query contact
if ($_GET["query"]) {
$updID = $_GET["query"];
$sql="select * from wd_event where e_id = $updID LIMIT 1";
$updRes=mysql_query($sql) or die ("Query Error: ".mysql_error());
$urow = mysql_fetch_array($updRes);
$upEvent = $urow["e_name"];
$upDate = $urow["e_date"];
$upTime = $urow["e_time"];
$upContact = $urow["e_contact"];
$upNumber = $urow["e_number"];
$upAddr = $urow["e_addr1"];
$upCity = $urow["e_city"];
$upState = $urow["e_state"];
$upZip = $urow["e_zip"];
$upDesc = $urow["e_desc"];
}
// update contact details
if ($_GET["update"]){
// extract Vars
$eventID = $_GET["update"];
$Event = $_POST["eventName"];
$Date = $_POST["eventDate"];
$Time = $_POST["eventTime"];
$Contact = $_POST["eventContact"];
$Number = $_POST["eventNumber"];
$Addr = $_POST["eventAddr"];
$City = $_POST["eventCity"];
$State = $_POST["eventState"];
$Zip = $_POST["eventZip"];
$Desc = $_POST["eventDesc"];
// update current entry into wd_network table
$updateSQL = "update wd_event set e_name='$Event', e_date='$Date', e_time='$Time', e_contact='$Contact', e_number='$Number', e_addr1='$Addr', e_city='$City', e_state='$State', e_zip='$Zip', e_desc='$Desc' where e_id = $eventID limit 1";
$updateResult = mysql_query($updateSQL) or die ("Error in updating contact: ". mysql_error());
}
// add member
if ($_GET["add"]){
// extract Vars
$eventName = $_POST["eventName"];
$eventDate = $_POST["eventDate"];
$eventTime = $_POST["eventTime"];
$eventContact = $_POST["eventContact"];
$eventNumber = $_POST["eventNumber"];
$eventAddr = $_POST["eventAddr"];
$eventCity = $_POST["eventCity"];
$eventState = $_POST["eventState"];
$eventZip = $_POST["eventZip"];
$eventDesc = $_POST["eventDesc"];
// add current entry into wd_user table
$addID = "insert into wd_event ( e_name,e_date,e_time,e_contact,e_number,e_addr1,e_city,e_state,e_zip,e_desc) values ('$eventName','$eventDate','$eventTime','$eventContact','$eventNumber','$eventAddr','$eventCity','$eventState','$eventZip','$eventDesc')";
$IDresult = mysql_query($addID) or die ("Error in adding contact: ". mysql_error());
$contactID = mysql_insert_id();
}
?>
War Dogs Motorcycle Club - Event Add-View-Change
|
|
 |
 |
|
|
|
 |
WARDOGS-MC DATABASE Add-Change-View Event Information MENU
$upage = $_SERVER["PHP_SELF"];
$subTxt = "ADD";
if ($updID) {
$act="$upage?update=$updID";
$subTxt = "UPDATE";
} else {
$act="$upage?add=1";
$subTxt = "ADD";
}
?>
|
|
|
Event |
Date |
Time |
Contact |
Number |
Address |
City |
State |
Zip |
include "conn.inc";
$sqlSelect = "select * from wd_event order by e_date";
$selectRows = mysql_query($sqlSelect);
for ( $counter=0 ; ($row = mysql_fetch_array($selectRows)) ; $counter++)
{
($counter%2==0)?$bg="#ededed" :$bg="white" ;
$e_id = $row["e_id"];
$e_name = $row["e_name"];
if (strlen($e_name) == 0){ $e_name = "--"; }
$e_date = $row["e_date"];
if (strlen($e_date) == 0){ $e_date = "--"; }
$e_time = $row["e_time"];
if (strlen($e_time) == 0){ $e_time = "--"; }
$e_contact = $row["e_contact"];
if (strlen($e_contact) == 0){ $e_contact = "--"; }
$e_number = $row["e_number"];
if (strlen($e_number) == 0){ $e_number = "--"; }
$e_addr = $row["e_addr1"];
if (strlen($e_addr) == 0){ $e_addr = "--"; }
$e_city = $row["e_city"];
if (strlen($e_city) == 0){ $e_city = "--"; }
$e_state = $row["e_state"];
if (strlen($e_state) == 0){ $e_state = "--"; }
$e_zip = $row["e_zip"];
if (strlen($e_zip) == 0){ $e_zip = "--"; }
$e_desc = $row["e_desc"];
if (strlen($e_desc) == 0){ $e_desc = "--"; }
?>
 |
 |
|
|
|
|
|
|
|
|
|
|
}
?>
|
|
|
 |
 |
|
|
 |
 |
|
 |
 |
}else{
include "notauth.php";
}
}?>