- 精华
- 阅读权限
- 120
- 好友
- 相册
- 分享
- 听众
- 收听
- 注册时间
- 2010-5-14
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
发表于 2024-3-13 15:33:10
|
显示全部楼层
- ALTER PROCEDURE [dbo].[givecash]
- [url=home.php?mod=space&uid=103850]@Cash[/url] INT,
- @UserID VARCHAR(20)
- AS
- SET NOCOUNT ON
- DECLARE [url=home.php?mod=space&uid=1372701]@USN[/url] INT
- DECLARE [url=home.php?mod=space&uid=210974]@NIKE[/url] VARCHAR(20)
- select @USN = '这里输入账号USN'
- select @nike = '这里输入游戏昵称'
- --select UserNo = @USN2 from TAccountMst where UserNo=@USN
- IF (select UserNo from TAccountMst where UserNo=@USN) IS NULL
- BEGIN
- INSERT INTO [TCashMst] VALUES (@USN, 'MICRO', @USN, @nike, @nike, 1, 0, 0, 0, 0, 0, 0, '0', '0', '0', 0, 0, '1990-10-10 00:00:00', 1, '0 ', '0 ', '0 ', '0 ', '2999-1-1 00:00:00', '2999-1-1 00:00:00', '0', '0', 0, '0', '2999-1-1 00:00:00', '2012-6-21 12:35:10', '0', '0', '0', '0', '0', '2999-1-1 00:00:00', '2999-1-1 00:00:00', '1/1/2999 12:00:00 AM', '0', 0, 'CF')
- INSERT INTO [TAccountMst] VALUES ('MICRO', @USN, @nike, @nike, 0, 0, 0, 0, .0000, 0, 0, 0, 0, 0, 0, 1, 0, '0', 0, 0, '0', 0, '0', '0', '0', '0', '1990-10-10 00:00:00', '2012-6-21 12:35:10', 0)
- END
- update TAccountMst set CashReal=CashReal+@Cash, TINCashReal=TINCashReal+@Cash where UserNo=@USN;
- update TCashMst set CashAmt=CashAmt+@Cash, RemainCashAmt=RemainCashAmt+@Cash where UserNo=@USN;
- RETURN
复制代码
CF1.0的CF点充值教程:
navicat打开MICROGAMESBILL_DB数据库-DBO-函数-givecash
右侧长长的代码删掉,粘贴上方的代码内容:
然后运行函数,@cash填充值cf点数量,@USERID和@USN和游戏昵称在最开始注册账户的那个数据库表里有
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有账号?注册
x
|