LIST2801.php
3.57 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
124
125
126
127
128
129
130
131
132
<?PHP
//*****************************************************************************
//*
//* プログラム名：め〜るNiポン！V2
//* プログラムID：LIST2801.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;
}
//メールＩＮＦＯ2削除
$strSQL = "DELETE FROM mail_info2 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="localhost";
$database="post_kanri";
if( !$pg_con2=pg_connect("host=$hostname 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");
}
?>