QQ群监控自动发邮件软件使用教程（含免费软件）

-- ====2023-11-17 18:35:37.3535==== -- 2023-11-17 18:35:37.3686 SELECT * FROM [t_Config_DB]; -- 2023-11-17 18:35:37.3886 -- Transaction Begin CREATE TABLE IF NOT EXISTS [t_MailType] ( [ObjectDBID] INTEGER PRIMARY KEY AUTOINCREMENT, [Name] VARCHAR, [Smtp] VARCHAR, [SSL] BOOLEAN, [Port] INTEGER); INSERT INTO [t_MailType]([ObjectDBID],[Name],[Smtp],[SSL],[Port]) VALUES ( Null, '网易企业邮箱', 'smtp.ym.163.com', 'False', 25 ); INSERT INTO [t_MailType]([ObjectDBID],[Name],[Smtp],[SSL],[Port]) VALUES ( Null, '163.com', 'smtp.163.com', 'False', 25 ); INSERT INTO [t_MailType]([ObjectDBID],[Name],[Smtp],[SSL],[Port]) VALUES ( Null, 'sina.com', 'smtp.sina.com', 'False', 25 ); INSERT INTO [t_MailType]([ObjectDBID],[Name],[Smtp],[SSL],[Port]) VALUES ( Null, 'sohu.com', 'smtp.sohu.com', 'False', 25 ); INSERT INTO [t_MailType]([ObjectDBID],[Name],[Smtp],[SSL],[Port]) VALUES ( Null, 'gmail.com', 'smtp.gmail.com', 'True', 465 ); INSERT INTO [t_MailType]([ObjectDBID],[Name],[Smtp],[SSL],[Port]) VALUES ( Null, 'hotmail.com', 'smtp.live.com', 'False', 25 ); INSERT INTO [t_MailType]([ObjectDBID],[Name],[Smtp],[SSL],[Port]) VALUES ( Null, '126.com', 'smtp.126.com', 'False', 25 ); INSERT INTO [t_MailType]([ObjectDBID],[Name],[Smtp],[SSL],[Port]) VALUES ( Null, 'qq.com', 'smtp.qq.com', 'True', 587 ); INSERT INTO [t_MailType]([ObjectDBID],[Name],[Smtp],[SSL],[Port]) VALUES ( Null, '21cn.com', 'smtp.21cn.com', 'False', 25 ); CREATE TABLE IF NOT EXISTS [t_SenderInfo] ( [MailType] INTEGER NOT NULL REFERENCES t_MailType(ObjectDBID) ON DELETE CASCADE ON UPDATE CASCADE, [Account] VARCHAR, [Password] VARCHAR, [SuccessCount] VARCHAR, [FailCount] VARCHAR, [ObjectDBID] INTEGER PRIMARY KEY AUTOINCREMENT); CREATE TABLE IF NOT EXISTS [t_Receiver] ( [QQAccount] VARCHAR, [NickName] VARCHAR, [GroupNumber] VARCHAR, [AddTime] VARCHAR, [SendCount] INTEGER, [LastSendTime] DATETIME, [ObjectDBID] INTEGER PRIMARY KEY AUTOINCREMENT); CREATE TABLE IF NOT EXISTS [t_Cls_Content] ( [ObjectDBID] INTEGER PRIMARY KEY AUTOINCREMENT, [Title_] VARCHAR, [Content_] VARCHAR, [PicEncrypt] BOOLEAN, [ContentEncrypt] BOOLEAN, [FilePath] VARCHAR); ;CREATE TABLE IF NOT EXISTS [t_Config_DB] ( [ObjectDBID] INTEGER PRIMARY KEY AUTOINCREMENT, [Created] BOOLEAN, [LogLeave] INTEGER); -- Transaction End -- 2023-11-17 18:35:37.3886 select count (*) as num from [t_Receiver]; -- 2023-11-17 18:35:37.4035 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 18:58:13.9207 INSERT INTO [t_SenderInfo]([MailType],[Account],[Password],[SuccessCount],[FailCount],[ObjectDBID]) VALUES ( 2, '[email protected]', 'JFQURSFBRAVZJXEU', Null, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 18:58:13.9207 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 19:05:28.9883 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '2465036022', '恋人', '725677771', '2023/11/17 19:03:27', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 19:05:30.0354 select count (*) as num from [t_Receiver]; -- 2023-11-17 19:05:30.0413 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 19:06:33.9353 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '2871168915', '您有预算我有量', '920440967', '2023/11/17 19:04:22', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 19:06:35.9847 select count (*) as num from [t_Receiver]; -- 2023-11-17 19:06:35.9847 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 19:12:34.3973 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '56098813', 'A.殷先生', '725677771', '2023/11/17 19:11:04', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 19:12:35.7997 select count (*) as num from [t_Receiver]; -- 2023-11-17 19:12:35.8021 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 19:30:12.8252 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '1077610990', '签名✅️美女的心乱₇₈糟', '821508562', '2023/11/17 19:27:44', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 19:30:13.3259 select count (*) as num from [t_Receiver]; -- 2023-11-17 19:30:13.3285 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 19:34:06.4626 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '784111446', '请加1351615608此号不加人', '924171379', '2023/11/17 19:33:06', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 19:34:08.3669 select count (*) as num from [t_Receiver]; -- 2023-11-17 19:34:08.3704 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 20:10:17.3516 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '259728027', '等', '227952427', '2023/11/17 20:09:58', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 20:10:18.7300 select count (*) as num from [t_Receiver]; -- 2023-11-17 20:10:18.7340 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 20:15:02.3168 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '369599572', '年轻不拽，世界怎么精彩', '740305822', '2023/11/17 20:12:09', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 20:15:02.9413 select count (*) as num from [t_Receiver]; -- 2023-11-17 20:15:02.9439 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 20:48:50.6083 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '737305783', 'Yáhinma', '612496574', '2023/11/17 20:47:37', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 20:48:51.5456 select count (*) as num from [t_Receiver]; -- 2023-11-17 20:48:51.5495 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 21:02:53.5274 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '365190786', '订单问题联系网页客服', '725677771', '2023/11/17 21:00:37', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 21:02:55.6411 select count (*) as num from [t_Receiver]; -- 2023-11-17 21:02:55.6447 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 21:30:36.6459 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '2665209264', '呆呆', '874435998', '2023/11/17 21:29:49', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 21:30:37.6144 select count (*) as num from [t_Receiver]; -- 2023-11-17 21:30:37.6199 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 21:35:58.9797 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSendTime],[ObjectDBID]) VALUES ( '2259808897', 'Fog.', '413320923', '2023/11/17 21:33:04', 0, Null, Null ); SELECT last_insert_rowid() AS InsertID; -- 2023-11-17 21:35:59.8120 select count (*) as num from [t_Receiver]; -- 2023-11-17 21:35:59.8171 select count (*) as num from [t_SenderInfo]; -- 2023-11-17 21:43:18.7352 INSERT INTO [t_Receiver]([QQAccount],[NickName],[GroupNumber],[AddTime],[SendCount],[LastSe