function fncsendmail($m = "", $id = 0, $username = "", $email = "")
{
$pi_name = "userbox";
global $_CONF;
global $_TABLES;
global $LANG_USERBOX_MAIL;
global $LANG_USERBOX_ADMIN;
global $_USER;
global $_USERBOX_CONF;
global $LANG28;
$retval = '';
$site_name = $_CONF['site_name'];
$subject = $LANG_USERBOX_MAIL['subject_' . $m];
$message = $LANG_USERBOX_MAIL['message_' . $m];
if ($m === "data_delete") {
$msg .= $LANG28['2'] . ":" . $id . LB;
$msg .= $LANG28['3'] . ":" . $title . LB;
//URL
$url = $_CONF['site_url'] . "/userbox/profile.php";
$url = COM_buildUrl($url);
} else {
$sql = "SELECT ";
$sql .= " t1.*";
$sql .= " ,t2.uid";
$sql .= " ,t2.username";
$sql .= " ,t2.fullname";
$sql .= " ,t2.email";
$sql .= " FROM ";
$sql .= $_TABLES['USERBOX_base'] . " AS t1";
$sql .= "," . $_TABLES['users'] . " AS t2";
$sql .= " WHERE ";
$sql .= " t1.id = {$id}";
$sql .= " AND t1.id = t2.uid";
$result = DB_query($sql);
$numrows = DB_numRows($result);
if ($numrows > 0) {
$A = DB_fetchArray($result);
$A = array_map('stripslashes', $A);
$email = $A['email'];
//下書
if ($A['draft_flag'] == 1) {
$msg .= $LANG_USERBOX_ADMIN['draft'] . LB;
}
//コア
$msg .= $LANG28['2'] . ":" . $A['uid'] . LB;
$msg .= $LANG28['3'] . ":" . $A['username'] . LB;
$msg .= $LANG28['4'] . ":" . $A['fullname'] . LB;
//基本項目
$msg .= $LANG_USERBOX_ADMIN['page_title'] . ":" . $A['page_title'] . LB;
$msg .= $LANG_USERBOX_ADMIN['description'] . ":" . $A['description'] . LB;
$msg .= $LANG_USERBOX_ADMIN['hits'] . ":" . $A['hits'] . LB;
$msg .= $LANG_USERBOX_ADMIN['comments'] . ":" . $A['comments'] . LB;
$msg .= $LANG_USERBOX_ADMIN['meta_description'] . ":" . $A['meta_description'] . LB;
$msg .= $LANG_USERBOX_ADMIN['meta_keywords'] . ":" . $A['meta_keywords'] . LB;
$msg .= $LANG_USERBOX_ADMIN['commentcode'] . ":" . $A['commentcode'] . LB;
$msg .= $LANG_USERBOX_ADMIN['comment_expire'] . ":" . $A['comment_expire'] . LB;
// 準備中 $msg.= $LANG_USERBOX_ADMIN['language_id'].":".$A['language_id'].LB;
$msg .= $LANG_USERBOX_ADMIN['owner_id'] . ":" . $A['owner_id'] . LB;
$msg .= $LANG_USERBOX_ADMIN['group_id'] . ":" . $A['group_id'] . LB;
$msg .= $LANG_USERBOX_ADMIN['perm_owner'] . ":" . $A['perm_owner'] . LB;
$msg .= $LANG_USERBOX_ADMIN['perm_group'] . ":" . $A['perm_group'] . LB;
$msg .= $LANG_USERBOX_ADMIN['perm_members'] . ":" . $A['perm_members'] . LB;
$msg .= $LANG_USERBOX_ADMIN['perm_anon'] . ":" . $A['perm_anon'] . LB;
$msg .= $LANG_USERBOX_ADMIN['modified'] . ":" . $A['modified'] . LB;
$msg .= $LANG_USERBOX_ADMIN['created'] . ":" . $A['created'] . LB;
$msg .= $LANG_USERBOX_ADMIN['expired'] . ":" . $A['expired'] . LB;
$msg .= $LANG_USERBOX_ADMIN['released'] . ":" . $A['released'] . LB;
$msg .= $LANG_USERBOX_ADMIN['orderno'] . ":" . $A['orderno'] . LB;
$msg .= $LANG_USERBOX_ADMIN['trackbackcode'] . ":" . $A['trackbackcode'] . LB;
$msg .= $LANG_USERBOX_ADMIN['draft'] . ":" . $A['draft'] . LB;
$msg .= $LANG_USERBOX_ADMIN['udatetime'] . ":" . $A['udatetime'] . LB;
$msg .= $LANG_USERBOX_ADMIN['uuid'] . ":" . $A['uuid'] . LB;
//koko
//カテゴリ
$msg .= DATABOX_getcategoriesText($id, 0, $pi_name);
//追加項目
$group_id = stripslashes($A['group_id']);
$owner_id = stripslashes($A['owner_id']);
$chk_user = DATABOX_chkuser($group_id, $owner_id, "userbox.admin");
$addition_def = DATABOX_getadditiondef($pi_name);
$additionfields = DATABOX_getadditiondatas($id, $pi_name);
$msg .= DATABOX_getaddtionfieldsText($additionfields, $addition_def, $chk_user, $pi_name, $A['fieldset_id']);
//タイムスタンプ 更新ユーザ
$msg .= $LANG_USERBOX_ADMIN['udatetime'] . ":" . $A['udatetime'] . LB;
$msg .= $LANG_USERBOX_ADMIN['uuid'] . ":" . $A['uuid'] . LB;
//URL
$url = $_CONF['site_url'] . "/userbox/profile.php";
$url .= "?";
if ($_USERBOX_CONF['datacode']) {
$url .= "m=code";
$url .= "&code=" . $A['username'];
} else {
$url .= "m=id";
$url .= "&id=" . $A['id'];
}
$url = COM_buildUrl($url);
}
}
if ($_USERBOX_CONF['mail_to_draft'] == 0 and $A['draft_flag'] == 1) {
} else {
$message .= $msg . LB;
$message .= $url . LB;
$message .= $LANG_USERBOX_MAIL['sig'] . LB;
$mail_to = $_USERBOX_CONF['mail_to'];
//--- to user
if ($_USERBOX_CONF['mail_to_owner'] == 1) {
if (array_search($email, $mail_to) === false) {
$to = $email;
COM_mail($to, $subject, $message);
}
}
//--- to admin
if (!empty($mail_to)) {
$to = implode($mail_to, ",");
COM_mail($to, $subject, $message);
}
}
return $retval;
}
function fncsendmail($m = "", $id = 0, $title = "")
{
global $_CONF;
global $_TABLES;
global $LANG_DATABOX_MAIL;
global $LANG_DATABOX_ADMIN;
global $_USER;
global $_DATABOX_CONF;
$pi_name = "databox";
$retval = '';
$site_name = $_CONF['site_name'];
$subject = sprintf($LANG_DATABOX_MAIL['subject_' . $m], $_USER['username']);
$message = sprintf($LANG_DATABOX_MAIL['message_' . $m], $_USER['username'], $_USER['uid']);
if ($m === "data_delete") {
$msg = $LANG_DATABOX_ADMIN['id'] . ":" . $id . LB;
$msg .= $LANG_DATABOX_ADMIN['title'] . ":" . $title . LB;
//URL
$url = $_CONF['site_url'] . "/databox/data.php";
$url = COM_buildUrl($url);
$A['draft_flag'] = 0;
} else {
$sql = "SELECT ";
$sql .= " *";
$sql .= " FROM ";
$sql .= $_TABLES['DATABOX_base'];
$sql .= " WHERE ";
$sql .= " id = {$id}";
$result = DB_query($sql);
$numrows = DB_numRows($result);
if ($numrows > 0) {
$A = DB_fetchArray($result);
$A = array_map('stripslashes', $A);
//下書
if ($A['draft_flag'] == 1) {
$msg .= $LANG_DATABOX_ADMIN['draft'] . LB;
}
//基本項目
$msg .= $LANG_DATABOX_ADMIN['code'] . ":" . $A['code'] . LB;
$msg .= $LANG_DATABOX_ADMIN['title'] . ":" . $A['title'] . LB;
$msg .= $LANG_DATABOX_ADMIN['page_title'] . ":" . $A['page_title'] . LB;
$msg .= $LANG_DATABOX_ADMIN['description'] . ":" . $A['description'] . LB;
//カテゴリ
$msg .= DATABOX_getcategoriesText($id, 0, "DATABOX");
//追加項目
$group_id = stripslashes($A['group_id']);
$owner_id = stripslashes($A['owner_id']);
$chk_user = DATABOX_chkuser($group_id, $owner_id, "databox.admin");
$addition_def = DATABOX_getadditiondef();
$additionfields = DATABOX_getadditiondatas($id);
$msg .= DATABOX_getaddtionfieldsText($additionfields, $addition_def, $chk_user, $pi_name, $A['fieldset_id']);
//タイムスタンプ 更新ユーザ
$msg .= $LANG_DATABOX_ADMIN['udatetime'] . ":" . $A['udatetime'] . LB;
$msg .= $LANG_DATABOX_ADMIN['uuid'] . ":" . $A['uuid'] . LB;
//URL
$url = $_CONF['site_url'] . "/databox/data.php";
$url .= "?";
if ($_DATABOX_CONF['datacode']) {
$url .= "m=code";
$url .= "&code=" . $A['code'];
} else {
$url .= "m=id";
$url .= "&id=" . $A['id'];
}
$url = COM_buildUrl($url);
}
}
if ($_DATABOX_CONF['mail_to_draft'] == 0 and $A['draft_flag'] == 1) {
} else {
$message .= $msg . LB;
$message .= $url . LB;
$message .= $LANG_DATABOX_MAIL['sig'] . LB;
$mail_to = $_DATABOX_CONF['mail_to'];
//--- to owner
if ($_DATABOX_CONF['mail_to_owner'] == 1) {
$owner_email = DB_getItem($_TABLES['users'], "email", "uid=" . $A['owner_id']);
if (array_search($owner_email, $mail_to) === false) {
$to = $owner_email;
COM_mail($to, $subject, $message);
}
}
//--- mail_to
if (!empty($mail_to)) {
$to = implode($mail_to, ",");
COM_mail($to, $subject, $message);
}
}
return $retval;
}