include "login.php";
include "conn.inc";
if ($_SESSION["userId"]){
if ($_SESSION["userLevel"] == 0) {
// delete contact
if ($_GET["del"]) {
$delID = $_GET["del"];
// delete contact
$sql="delete from wd_network where n_id = $delID";
$delRes = mysql_query($sql) or die ("Delete Error: ".mysql_error());
// delete functionlink
$sql2 = "delete from wd_functionlink where fl_nid = $delID";
$delRes2 = mysql_query($sql2) or die ("Delete FunctionLink Error: ".mysql_error());
}
// query contact
if ($_GET["query"]) {
$updID = $_GET["query"];
$sql="select * from wd_network where n_id = $updID LIMIT 1";
$updRes=mysql_query($sql) or die ("Query Error: ".mysql_error());
$urow = mysql_fetch_array($updRes);
$upMem = $urow["n_name"];
$upNumber = $urow["n_number"];
$upEmail = $urow["n_email"];
$upDesc = $urow["n_desc"];
}
// update contact details
if ($_GET["update"]){
// extract Vars
$memID = $_GET["update"];
$memName = $_POST["memName"];
$memNumber = $_POST["memNumber"];
$memEmail = $_POST["memEmail"];
$memDesc = $_POST["memDesc"];
// update current entry into wd_network table
$updateSQL = "update wd_network set n_name='$memName',n_number='$memNumber',n_email='$memEmail',n_desc='$memDesc' where n_id = $memID limit 1";
$updateResult = mysql_query($updateSQL) or die ("Error in updating contact: ". mysql_error());
// ** update functionlink table
// first delete all rows that are there for the contact
$sql = "delete from wd_functionlink where fl_nid = $memID";
$delRes = mysql_query($sql) or die ("Delete Error: ".mysql_error());
// now add posted values to the table
foreach($_POST as $key => $value){
if ($key <> "memName" && $key <> "memNumber" && $key <> "memEmail" && $key <> 'memDesc' && $key <> "submit") {
// echo $key.": ".$value."
";
$functionID = $value;
$linkRES = mysql_query("insert into wd_functionlink (fl_fid, fl_nid) values ($functionID,$memID)") or die ("Linking Error: ".mysql_error());
}
}
}
// add member
if ($_GET["add"]){
// extract Vars
$memName = $_POST["memName"];
$memNumber = $_POST["memNumber"];
$memEmail = $_POST["memEmail"];
$memDesc = $_POST["memDesc"];
// add current entry into wd_network table
$addID = "insert into wd_network ( n_name,n_number,n_email,n_desc) values ('$memName','$memNumber','$memEmail','$memDesc')";
$IDresult = mysql_query($addID) or die ("Error in adding contact: ". mysql_error());
$contactID = mysql_insert_id();
foreach($_POST as $key => $value){
if ($key <> "memName" && $key <> "memNumber" && $key <> "memEmail" && $key <> "memDesc" && $key <> "submit") {
// echo $key.": ".$value."
";
$functionID = $value;
$linkRES = mysql_query("insert into wd_functionlink (fl_fid, fl_nid) values ($functionID,$contactID)") or die ("Linking Error: ".mysql_error());
}
}
}
?>
War Dogs Motorcycle Club - Contact Add-View-Change
|
|
 |
 |
|
|
|
 |
WARDOGS-MC DATABASE Add-Change-View Contact Information MENU
$upage = $_SERVER["PHP_SELF"];
$subTxt = "ADD";
if ($updID) {
$act="$upage?update=$updID";
$subTxt = "UPDATE";
} else {
$act="$upage?add=1";
$subTxt = "ADD";
}
?>
|
|
|
Name |
Email |
Number |
Function(s) |
include "conn.inc";
$sqlSelect = "select * from wd_network order by n_name";
$selectRows = mysql_query($sqlSelect);
for ( $counter=0 ; ($row = mysql_fetch_array($selectRows)) ; $counter++)
{
($counter%2==0)?$bg="#ededed" :$bg="white" ;
$n_id = $row["n_id"];
$n_name = $row["n_name"];
$n_email = $row["n_email"];
if (strlen($n_email) == 0){ $n_email = "--"; }
$n_number = $row["n_number"];
if (strlen($n_number) == 0){ $n_number = "--"; }
// get functions
$fSQL = "select fl_fid from wd_functionlink where fl_nid = $n_id";
$fSEL = mysql_query($fSQL) or die ("Function Select Error: ".mysql_error());
$tmpList = "";
for ($f=0 ; $fROW = mysql_fetch_array($fSEL) ; $f++) {
$fl_fid = $fROW["fl_fid"];
$f2SEL = mysql_query("select f_function from wd_function where f_id = $fl_fid");
$f2RES = mysql_fetch_array($f2SEL);
$this_function = $f2RES["f_function"];
$tmpList .= $this_function.", ";
}
$FunctionList = substr($tmpList, 0, -2);
?>
 |
 |
|
|
|
|
}
?>
|
|
|
 |
 |
|
|
 |
 |
|
 |
 |
}else{
include "notauth.php";
}
}?>