在线情况
楼主
  • 头像
  • 级别
  • 徽章
  • 职务总版主
  • 声望+14
  • 积分1530
  • 经验278129
  • 文章2378
  • 注册2003-06-14
支付宝担保保支付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]
LeadBBS 官方论坛(asp论坛)感谢您的参与
在线情况
2
  • 头像
  • 小笨的爸爸
  • 级别
  • 徽章
  • 职务总版主
  • 声望+59
  • 积分8215
  • 经验591271
  • 文章7601
  • 注册2006-03-24
不错 试试 [EM283]
LeadBBS 官方论坛(asp论坛)感谢您的参与
在线情况
3
  • 头像
  • 级别
  • 徽章
  • 职务总版主
  • 声望+14
  • 积分1530
  • 经验278129
  • 文章2378
  • 注册2003-06-14
表有变动 一会补上
LeadBBS 官方论坛(asp论坛)感谢您的参与
在线情况
4
  • 头像
  • 级别
  • 徽章
  • 职务总版主
  • 声望+14
  • 积分1530
  • 经验278129
  • 文章2378
  • 注册2003-06-14
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
此帖受到1次评价, 累计:积分+1
LeadBBS 官方论坛(asp论坛)感谢您的参与
在线情况
5
  • 头像
  • 级别
  • 徽章
  • 声望+13
  • 积分574
  • 经验362646
  • 文章523
  • 注册2005-11-15
感谢!支持!
何时上商城插件?
LeadBBS 官方论坛(asp论坛)感谢您的参与
在线情况
6
  • 头像
  • 小笨的爸爸
  • 级别
  • 徽章
  • 职务总版主
  • 声望+59
  • 积分8215
  • 经验591271
  • 文章7601
  • 注册2006-03-24
调试错误,请回到请求来源地,重新发起请求。
 
错误代码 ILLEGAL_PARTNER_EXTERFACE
LeadBBS 官方论坛(asp论坛)感谢您的参与
在线情况
7
  • 头像
  • 小笨的爸爸
  • 级别
  • 徽章
  • 职务总版主
  • 声望+59
  • 积分8215
  • 经验591271
  • 文章7601
  • 注册2006-03-24
没事了 测试的是旧的。。
LeadBBS 官方论坛(asp论坛)感谢您的参与
Page created in 0.0142 seconds with 4 queries.