function fncdelete($template)
{
global $_CONF;
global $_TABLES;
global $LANG_DATABOX_ADMIN;
$pi_name = "databox";
$id = COM_applyFilter($_POST['id'], true);
$title = DB_getItem($_TABLES['DATABOX_base'], 'title', "id = " . $id);
$addition_def = DATABOX_getadditiondef();
//@@@@@
$additionfields = $_POST['afield'];
//@@@@@
// CHECK
$err = "";
if ($err != "") {
$page_title = $LANG_DATABOX_ADMIN['err'];
$retval .= DATABOX_siteHeader('DATABOX', '_admin', $page_title);
$retval .= COM_startBlock($LANG_DATABOX_ADMIN['err'], '', COM_getBlockTemplate('_msg_block', 'header'));
$retval .= $err;
$retval .= COM_endBlock(COM_getBlockTemplate('_msg_block', 'footer'));
$retval .= DATABOX_siteFooter('DATABOX', '_admin');
return $retval;
}
//
$rt = databox_deletedata($id);
$rt = fncsendmail('data_delete', $id, $title);
$cacheInstance = 'databox__' . $id . '__';
CACHE_remove_instance($cacheInstance);
//exit;// debug 用
$return_page = $_CONF['site_url'] . '/' . THIS_SCRIPT . '?msg=2';
if ($template != "") {
$return_page .= "&template=" . $template;
}
return COM_refresh($return_page);
}
function fncdatadeleteExec($action)
{
global $_TABLES;
global $LANG_DATABOX_ADMIN;
$fieldset = $_POST['fieldset'];
//if (is_array($fieldset)){
// $S = $fieldset;
//}else{
// if( !empty( $fieldset )) {
// $S = explode( ' ', $fieldset );
// }else {
// $S = array();
// }
//}
if ($fieldset == "") {
return;
}
if ($action == $LANG_DATABOX_ADMIN['delete1']) {
//DRAFT 下書データ
$arg = " AND draft_flag=1" . LB;
} else {
if ($action == $LANG_DATABOX_ADMIN['delete2']) {
//公開終了日を過ぎたデータ
$arg = " AND NOT (expired=0 OR expired > NOW())";
} else {
if ($action == $LANG_DATABOX_ADMIN['delete3']) {
//すべて
$arg = "";
} else {
return;
}
}
}
$rt = "";
$s = implode(", ", $fieldset);
$sql = "SELECT id FROM {$_TABLES['DATABOX_base']} ";
$sql .= " WHERE ";
$sql .= " fieldset_id IN (" . $s . ")";
$sql .= $arg;
$result = DB_query($sql);
$numrows = DB_numRows($result);
if ($numrows > 0) {
for ($i = 0; $i < $numrows; $i++) {
$A = DB_fetchArray($result);
$A = array_map('stripslashes', $A);
$dummy = databox_deletedata($A['id']);
}
}
return;
}
