LIST1801.php
3.37 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<?PHP
//*****************************************************************************
//*
//* プログラム名：め〜るNiポン！V2
//* プログラムID：LIST1801.php
//* 機能 ：配信情報（削除）
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include("./include/jcode.phps");
include("./include/session_start.inc");
include("./include/SessionChk.inc");
include("./include/dbcon.inc");
//メール件数選択
$strSQL = "SELECT * FROM mail_info WHERE mail_id = '" . $_POST["mail_id"] . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
$intDataCount = pg_numrows($objRecSet);
//後日配信確認
$strSQL = "SELECT reserva_flg FROM Mail_data WHERE mail_id = '" . $_POST["mail_id"] . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
$reserva_flg = pg_result($objRecSet,0,"reserva_flg");
$strSQL = "DELETE FROM mail_data WHERE mail_data.mail_id = '" . $_POST["mail_id"] . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
//アラームデータ削除
$strSQL = "DELETE FROM alarm_data WHERE alarm_data.mail_id = '" . $_POST["mail_id"] . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
//メールＩＮＦＯ削除
$strSQL = "DELETE FROM mail_info WHERE mail_info.mail_id = '" . $_POST["mail_id"] . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
//メール回答情報削除
$strSQL = "DELETE FROM answer_data WHERE answer_data.mail_id = '" . $_POST["mail_id"] . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
//既読・未読自動配信情報削除
$strSQL = "DELETE FROM kidok_data WHERE kidok_data.mail_id = '" . $_POST["mail_id"] . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
//配信機種情報削除
$strSQL = "DELETE FROM mail_send_tbl WHERE mail_send_tbl.mail_id = '" . $_POST["mail_id"] . "'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
//メールポイント復元
if($reserva_flg==1){
$hostname="172.31.16.254";
$database="post_kanri";
if( !$pg_con2=pg_connect("host=$hostname port=5434 dbname=$database user=pgsqladmin password=pgsqladmin") ) {
print "Error : connect to ${hostname}<br>";
exit;
}
$strSQL = "SELECT use_point,max_point " .
"FROM point_tbl " .
"WHERE user_id = '".$PHP_POST_SYAIN_ID."'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
$use_point = pg_result($objRecSet,0,"use_point");
$max_point = pg_result($objRecSet,0,"max_point");
if($max_point < 1000){
$use_point = $use_point + $intDataCount;
$max_point = $max_point - $intDataCount;
$strSQL = "Update point_tbl Set use_point=".$use_point." ,max_point=".$max_point." where user_id='".$PHP_POST_SYAIN_ID."'";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(DELETE)");
exit;
}
}
}
if($backFlg!=1){
header("Location:LIST0000.php");
}else{
header("Location:LIST0000.php");
}
?>