支付宝担保保支付for leadbbs 9.0+

楼主 suPer 于 2015-07-20 10:51:12
支付宝担保保支付for leadbbs 9.0+
[P]支付宝担保支付 for leadbbs 9.0 + [/P][P]安装办法：[/P][P]1.解压后将 alipaytrade 目录上传至论坛的app下面
2.class/alipay_con.asp中根据注释设置收款帐号及合作身份者ID和密钥
3.建议将充值页转至此页面(user/alipay/payment.asp文件)[/P][P][URL=http://www.leadbbs.com]www.leadbbs.com[/URL] 2015-07-20[/P][P]
[/P][P][upload=16203,2]alipaytrade.zip[/upload][/P][P]
[/P][P]附：支付宝担保交易个人申请[/P][P][URL=http://www.leadbbs.com/a/topic-201-2954419-1.html]http://www.leadbbs.com/a/topic-201-2954419-1.html[/URL][/P][P]
[/P][P]从实际使用效果看，异步更新订单状态，有可能需要等待一点时间，比如买家确认收货后，可能会需要等上0-5分钟左右[/P]
回复
1楼 weiwei202 于 2015-07-20 14:48:41
不错 试试 [EM283]
回复
2楼 suPer 于 2015-07-20 15:17:40
表有变动 一会补上
回复
3楼 suPer 于 2015-07-20 15:19:50
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LeadBBS_SellList](
 [ID] [bigint] IDENTITY(1,1) NOT NULL,
 [PID] [bigint] NOT NULL,
 [UserName] [varchar](20) NOT NULL,
 [PayPoints] [int] NOT NULL,
 [GetPoints] [int] NOT NULL,
 [SellTime] [bigint] NOT NULL,
 [PayFlag] [tinyint] NOT NULL,
 [UserID] [bigint] NOT NULL,
 [PID_TMP] [bigint] NOT NULL,
 [PAY_STAT] [varchar](50) NOT NULL,
 [PAY_MEMO] [varchar](255) NOT NULL,
 CONSTRAINT [PK_LeadBBS_SellList] PRIMARY KEY CLUSTERED
(
 [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_PAY_STAT] ON [dbo].[LeadBBS_SellList]
(
 [PAY_STAT] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_PayFlag] ON [dbo].[LeadBBS_SellList]
(
 [PayFlag] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_PID] ON [dbo].[LeadBBS_SellList]
(
 [PID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_PID_TMP] ON [dbo].[LeadBBS_SellList]
(
 [PID_TMP] ASC,
 [UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_SellTime] ON [dbo].[LeadBBS_SellList]
(
 [SellTime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_UserID] ON [dbo].[LeadBBS_SellList]
(
 [UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_UserNamePayFlag] ON [dbo].[LeadBBS_SellList]
(
 [UserID] ASC,
 [PayFlag] ASC,
 [ID] DESC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_UserSellTime] ON [dbo].[LeadBBS_SellList]
(
 [UserID] ASC,
 [PayFlag] ASC,
 [SellTime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'PID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'购买用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'付款金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'PayPoints'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'兑换财富点数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'GetPoints'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'SellTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0,未支付 1,完成支付' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'PayFlag'
GO
/****** Object:  Default [DF_LeadBBS_SellList_PID]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_PID]  DEFAULT (0) FOR [PID]
GO
/****** Object:  Default [DF_LeadBBS_SellList_UserName]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_UserName]  DEFAULT ('') FOR [UserName]
GO
/****** Object:  Default [DF_LeadBBS_SellList_PayPoints]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_PayPoints]  DEFAULT (0) FOR [PayPoints]
GO
/****** Object:  Default [DF_LeadBBS_SellList_GetPoints]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_GetPoints]  DEFAULT (0) FOR [GetPoints]
GO
/****** Object:  Default [DF_LeadBBS_SellList_SellTime]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_SellTime]  DEFAULT (0) FOR [SellTime]
GO
/****** Object:  Default [DF_LeadBBS_SellList_PayFlag]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_PayFlag]  DEFAULT (0) FOR [PayFlag]
GO
/****** Object:  Default [DF_LeadBBS_SellList_UserID]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_UserID]  DEFAULT ((0)) FOR [UserID]
GO
/****** Object:  Default [DF_LeadBBS_SellList_PID_TMP]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_PID_TMP]  DEFAULT ((0)) FOR [PID_TMP]
GO
/****** Object:  Default [DF_LeadBBS_SellList_PAY_STAT]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_PAY_STAT]  DEFAULT ('') FOR [PAY_STAT]
GO
/****** Object:  Default [DF_LeadBBS_SellList_PAY_MEMO]    Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD  CONSTRAINT [DF_LeadBBS_SellList_PAY_MEMO]  DEFAULT ('') FOR [PAY_MEMO]
GO
回复
4楼 51yd 于 2015-07-20 16:37:40
感谢！支持！
何时上商城插件？
回复
5楼 weiwei202 于 2015-07-28 14:14:19
调试错误，请回到请求来源地，重新发起请求。
 
错误代码 ILLEGAL_PARTNER_EXTERFACE
回复
12 　

电脑版 Page created in 0.0781 seconds with 3 queries.