($database_connData, $connData);
$Result1 = mysql_query($deleteSQL, $connData) or die(mysql_error());
$deleteGoTo = "albumAdminMain.php";
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $deleteGoTo));
}
if ((isset($_POST['ap_id'])) && ($_POST['ap_id'] != "") && (isset($_POST['deletePhotos']))) {
$deleteSQL = sprintf("DELETE FROM albumphoto WHERE ap_id IN (%s)",
implode(",",$_POST['ap_id']));
mysql_select_db($database_connData, $connData);
//删除相关的图片
$query_RecDelPhoto = sprintf("SELECT * FROM albumphoto WHERE ap_id IN (%s)", implode(",", $_POST['ap_id']));
$RecDelPhoto = mysql_query($query_RecDelPhoto, $connData) or die(mysql_error());
$row_RecDelPhoto = mysql_fetch_assoc($RecDelPhoto);
$totalRows_RecDelPhoto = mysql_num_rows($RecDelPhoto);
do {
unlink("photos/".$row_RecDelPhoto['ap_picurl']);
} while ($row_RecDelPhoto = mysql_fetch_assoc($RecDelPhoto));
mysql_free_result($RecDelPhoto);
$Result1 = mysql_query($deleteSQL, $connData) or die(my
sql_error());
$deleteGoTo = "albumAdminFix.php?album_id=".$_POST['album_id'];
/*
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
*/
header(sprintf("Location: %s", $deleteGoTo));
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "addPhoto")) {
$insertSQL = sprintf("INSERT INTO albumphoto (album_id, ap_date, ap_width, ap_height, ap_picurl) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($_POST['album_id'], "int"),
GetSQLValueString($_POST['ap_date'], "date"),
GetSQLValueString($_POST['rePicW'], "text"),
GetSQLValueString($_POST['rePicH'], "text"),
GetSQLValueString($_POST['rePic'], "text"));
mysql_select_db($database_connData, $connData);
$Result1 = mysql_query($insertSQL, $connData) or die(mysql_error());
$insertGoTo = "albumAdminFix.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_connData, $connData);
$query_RecWebInfo = "SELECT * FROM
webconfiguration";
$RecWebInfo = mysql_query($query_RecWebInfo, $connData) or die(mysql_error());
$row_RecWebInfo = mysql_fetch_assoc($RecWebInfo);
$totalRows_RecWebInfo = mysql_num_rows($RecWebInfo);
$colname_RecAlbum = "-1";
if (isset($_GET['album_id'])) {
$colname_RecAlbum = (get_magic_quotes_gpc()) ? $_GET['album_id'] : addslashes($_GET['album_id']);
}
mysql_select_db($database_connData, $connData);
$query_RecAlbum = sprintf("SELECT * FROM albummain WHERE album_id = %s", GetSQLValueString($colname_RecAlbum, "int"));
$RecAlbum = mysql_query($query_RecAlbum, $connData) or die(mysql_error());
$row_RecAlbum = mysql_fetch_assoc($RecAlbum);
$totalRows_RecAlbum = mysql_num_rows($RecAlbum);
$colname_RecPhotos = "-1";
if (isset($_GET['album_id'])) {
$colname_RecPhotos = (get_magic_quotes_gpc()) ? $_GET['album_id'] : addslashes($_GET['album_id']);
}
mysql_select_db($database_connData, $connData);
$query_RecPhotos = sprintf("SELECT * FROM albumphoto WHERE album_id = %s ORDER BY ap_date DESC", GetSQLValueString($colname_RecPhotos, "int"));
$RecPhotos = mysql_query($query_RecPhotos, $connData) or die(mysql_error());
$row_RecPhotos = mysql_fetch_assoc($RecPhotos);
$totalRows_RecPhotos = mysql_num_rows($RecPhotos);
?><!DOCTYP