jack89son的个人资料 - RAT

jack89son jack89son

关注数: 14 粉丝数: 43 发帖数: 4,215 关注贴吧数: 13

无敌吧永远繁荣我来赞

我来了大家好

【百度音乐】140520〓产品反馈〓无法打开软件系统IOS 7.1.1 环境: 联通3G 软件设置: 仅限WIFI下联网现象: 在以上设置下,无法打开百度音乐手机版,一直闪退. 关闭3G网络或者有WIFI或者关闭仅限WIFI下联网后,正常进去软件. 如果进入软件,然后更改设置至以上条件,百度音乐自动停止播放并退出

道友们，知道这是啥吗走起，马上升级啦

我胡汉三又回来了哈哈'开心

走吧走吧放弃了

走啦

手机终于又可以发帖子了原来自己没登录'可是百度也不给个提示

各位吧友,请注意.... 不要再在本吧发表关于日本的任何帖子和回复帖子, 请为本吧的和谐做出贡献. 本吧只是小说吧, 不希望大家因为这些事情搞的吧里乌烟瘴气的. 从此刻起,再发表任何关于日本的帖子,一律删除

我要礼物要礼物@JETPS

让我来自发发财啦

等更举手了

吧主，又话说版面整理整理啊，更新帖都这么乱，再说制定吧规啊

把贴吧客户端删除几天看看能不能适应

最近番茄更新早了晚上不熬夜了！喜闻乐见

最近不想看完美为啥吸引不了我

来开来睡一帖

太好了怎么没更新吧里

等更的举手

我刚才被全吧封禁了。。。好恐怖，幸亏我手机有验证，这是啥情况啊！

保存点东西 DECLARE @CurrentTime DATETIME, @CurrentMonth DATETIME, @CalculateMonth DATETIME, @BalanceAtLastTime INT = 0, @RowCount INT, @RetiredBy VARCHAR(20), @OnLineDateTime DATETIME, @IsUpdate BIT, @PointExpireMonth DATETIME, @WynnID DATETIME SET @CurrentTime = GETDATE() SELECT @OnLineDateTime = ItemName FROM [GlobalSetting] WHERE ItemCode = 'GLOBALSETTING_ONE_BUCKET_ONLINE_DATETIME' SET @CurrentMonth = DATEADD(MM,DATEDIFF(MM,0,@CurrentTime),0) -- If current month is the same as go live month,we needn't to run this sp, -- because the go live month will be calculate at the beginning of next month. IF @CurrentMonth = DATEADD(MM,DATEDIFF(MM,0,@OnLineDateTime),0) RETURN -- Calculate the begining of current month. SET @CalculateMonth = DATEADD(MM,-1,@CurrentMonth) SELECT @PointExpireMonth = [dbo].[GCM_fn_PointAging_GetPointEarnedMonth](@CalculateMonth) IF @CalculateMonth = DATEADD(MM,DATEDIFF(MM,0,@OnLineDateTime),0) BEGIN SET @IsUpdate = 1 SET @CalculateMonth = @OnLineDateTime SELECT @RowCount = COUNT(1) FROM PointExpireStatistic WHERE ModifiedOn > @OnLineDateTime END ELSE BEGIN SET @IsUpdate = 0 SELECT @RowCount = COUNT(1) FROM PointExpireStatistic WHERE PointEarnedMonth = @CalculateMonth END IF @RowCount > 0 RETURN -- Create temp table for void points earned which earned month is not same with void month. IF Object_id('tempdb..#PointsEarnedVoid') <> 0 BEGIN DROP TABLE #PointsEarnedVoid END CREATE TABLE #PointsEarnedVoid(WynnID NUMERIC(8,0), EarnedMonth DATETIME, PointsEarnedVoid INT) -- Create temp table for return points consume which return month is not same with consume month. IF Object_id('tempdb..#PointsReturn') <> 0 BEGIN DROP TABLE #PointsReturn END CREATE TABLE #PointsReturn(WynnID NUMERIC(8,0), PointsReturn INT) -- Create temp table for remain points earned void. IF Object_id('tempdb..#PointRemainNegativeAmount') <> 0 BEGIN DROP TABLE #PointRemainNegativeAmount END CREATE TABLE #PointRemainNegativeAmount(WynnID NUMERIC(8,0), NegativeAmount NUMERIC(18, 0)) -- Create temp table for normal consume in current month. IF Object_id('tempdb..#PointsConsume') <> 0 BEGIN DROP TABLE #PointsConsume END CREATE TABLE #PointsConsume(WynnID NUMERIC(8,0), PointsConsume NUMERIC(18, 0)) -- Create temp table for points normal earn in current month. IF Object_id('tempdb..#PointsEarn') <> 0 BEGIN DROP TABLE #PointsEarn END CREATE TABLE #PointsEarn(WynnID NUMERIC(8,0), PointsEarn NUMERIC(18, 0)) -- Create temp table for recording all the critical expire amount greater than consume amount. IF Object_id('tempdb..#TotalExpireAmount') <> 0 BEGIN DROP TABLE #TotalExpireAmount END CREATE TABLE #TotalExpireAmount(WynnID NUMERIC(8,0), PointEarnedMonth DATETIME, PointsConsume INT, ExpireAmount INT) -- Create temp table for recording the first record that critical expire amount greater than consume amount. IF Object_id('tempdb..#CriticalExpireAmount') <> 0 BEGIN DROP TABLE #CriticalExpireAmount END CREATE TABLE #CriticalExpireAmount(WynnID NUMERIC(8,0), PointEarnedMonth DATETIME, PointsConsume INT, ExpireAmount INT) -- Create temp table for recording the patron who have negative balance. IF Object_id('tempdb..#PatronWithNegativeBalance') <> 0 BEGIN DROP TABLE #PatronWithNegativeBalance END CREATE TABLE #PatronWithNegativeBalance(WynnID NUMERIC(8,0), PointAvailable INT) -- Store the points to be expired in current month. IF Object_id('tempdb..#PointsExpireOfCurrentMonth') <> 0 BEGIN DROP TABLE #PointsExpireOfCurrentMonth END CREATE TABLE #PointsExpireOfCurrentMonth(WynnID NUMERIC(8,0), PointExpireAmount INT) -- Get the points earned that void month is not same with earned month. INSERT INTO #PointsEarnedVoid SELECT * FROM GCM_fn_PointAging_GetPointEarnedVoid(@WynnID,@CalculateMonth,@CurrentMonth) -- Get the points return that void month is not same with issued month. INSERT INTO #PointsReturn SELECT * FROM GCM_fn_PointAging_GetPointReturn(@WynnID,@CalculateMonth,@CurrentMonth) -- Get the point consumed in current month. INSERT INTO #PointsConsume SELECT * FROM GCM_fn_PointAging_GetPointConsume(@WynnID,@CalculateMonth,@CurrentMonth) -- Calculate the points earned of current month. INSERT INTO #PointsEarn SELECT WynnID,SUM(PointsEarn) FROM ( SELECT WynnID,PointsEarn FROM GCM_fn_PointAging_GetPointEarn(@WynnID,@CalculateMonth,@CurrentMonth) UNION ALL SELECT WynnID,0 FROM #PointsConsume ) PointsEarn GROUP BY WynnID DECLARE @PointsEarnedVoid INT = 0, -- one player's points earned voided in current month. @RemainEarnedVoid INT = 0, @TotalRemainEarnedVoid INT = 0, @PointsEarnedMonth DATETIME, -- the month of points earned that voided in current month. @PointsReturn INT = 0, -- the points return in current month and issued in the current month before. @PointsConsume NUMERIC(18, 0) = 0, -- the points consumed in current month. @RemainConsume NUMERIC(18, 0) = 0, @PointsEarn NUMERIC(18, 0) = 0, -- the poins earned in current month. @RemainEarn NUMERIC(18, 0) = 0, -- the points to be expired of current month. @PointsExpireId BIGINT, @ExpireAmountDeductedMonth DATETIME, @TotalExpireAmount NUMERIC(18, 0) , @ExpireAmountAddedMonth DATETIME, @NegativeBalance INT = 0, @ActualPointsReturn INT = 0 DECLARE Cursor_PointsSpecialVoid CURSOR SCROLL DYNAMIC FOR SELECT DISTINCT WynnID FROM #PointsEarnedVoid UNION SELECT DISTINCT WynnID FROM #PointsReturn --begin cursor for sepical void such as void earn and void issue which the month of create time is not same as the month of modify time. OPEN Cursor_PointsSpecialVoid FETCH NEXT FROM Cursor_PointsSpecialVoid INTO @WynnID WHILE(@@FETCH_STATUS=0) BEGIN -- Get points earned voided that the void time is not same with earned time DECLARE Cursor_PointsEarnedVoid CURSOR SCROLL DYNAMIC FOR SELECT EarnedMonth,PointsEarnedVoid FROM #PointsEarnedVoid WHERE WynnID = @WynnID OPEN Cursor_PointsEarnedVoid FETCH NEXT FROM Cursor_PointsEarnedVoid INTO @PointsEarnedMonth,@PointsEarnedVoid WHILE(@@FETCH_STATUS=0) BEGIN UPDATE PointExpireStatistic SET PointEarnedAmount = PointEarnedAmount - @PointsEarnedVoid, ModifiedOn = @CurrentTime WHERE PointEarnedMonth = @PointsEarnedMonth AND WynnID = @WynnID; WITH FiltedExpireAmount AS ( SELECT PointEarnedMonth,PointExpireAmount FROM PointExpireStatistic WHERE WynnId = @WynnID AND PointEarnedMonth >= @PointsEarnedMonth AND IsExpire = 0 AND PointExpireAmount > 0 ) SELECT TOP 1 @ExpireAmountDeductedMonth = FEA1.PointEarnedMonth , @TotalExpireAmount = SUM(FEA2.PointExpireAmount) FROM FiltedExpireAmount FEA1 INNER JOIN FiltedExpireAmount FEA2 ON FEA1.PointEarnedMonth >= FEA2.PointEarnedMonth GROUP BY FEA1.PointEarnedMonth HAVING SUM(FEA2.PointExpireAmount) >= @PointsEarnedVoid ORDER BY FEA1.PointEarnedMonth IF @TotalExpireAmount IS NOT NULL AND @TotalExpireAmount <> 0 BEGIN SET @TotalExpireAmount = @TotalExpireAmount - @PointsEarnedVoid UPDATE PointExpireStatistic SET PointExpireAmount = CASE WHEN PointEarnedMonth < @ExpireAmountDeductedMonth THEN 0 ELSE @TotalExpireAmount END, ModifiedOn = @CurrentTime WHERE WynnID = @WynnID AND IsExpire = 0 AND PointEarnedMonth BETWEEN @PointsEarnedMonth AND @ExpireAmountDeductedMonth SET @RemainEarnedVoid = 0 END ELSE BEGIN SELECT @TotalExpireAmount = SUM(PointExpireAmount) FROM PointExpireStatistic WHERE WynnId = @WynnID AND PointEarnedMonth >= @PointsEarnedMonth AND IsExpire = 0 AND PointExpireAmount > 0 IF @TotalExpireAmount IS NOT NULL UPDATE PointExpireStatistic SET PointExpireAmount = 0, ModifiedOn = @CurrentTime WHERE WynnID = @WynnID AND PointEarnedMonth >= @PointsEarnedMonth AND IsExpire = 0 SET @RemainEarnedVoid = ABS(ISNULL(@TotalExpireAmount,0) - @PointsEarnedVoid) END SET @TotalRemainEarnedVoid = @TotalRemainEarnedVoid + @RemainEarnedVoid SET @TotalExpireAmount = NULL FETCH NEXT FROM Cursor_PointsEarnedVoid INTO @PointsEarnedMonth,@PointsEarnedVoid END CLOSE Cursor_PointsEarnedVoid DEALLOCATE Cursor_PointsEarnedVoid -- Get points return that the void time is not same with issued time SELECT @PointsReturn = ISNULL(PointsReturn,0) FROM #PointsReturn WHERE WynnID = @WynnID; -- Get over consume last month. SELECT TOP 1 @BalanceAtLastTime = OverConsumeAmount FROM PointExpireStatistic WHERE WynnID = @WynnID ORDER BY PointEarnedMonth DESC SET @NegativeBalance = @BalanceAtLastTime - @TotalRemainEarnedVoid IF @NegativeBalance < 0 AND @PointsReturn IS NOT NULL AND @PointsReturn > 0 BEGIN SET @ActualPointsReturn = @PointsReturn - ABS(@NegativeBalance) SET @NegativeBalance = @NegativeBalance + @PointsReturn IF @NegativeBalance > 0 SET @NegativeBalance = 0 END ELSE SET @ActualPointsReturn = @PointsReturn

【异世无冕邪皇】3g果然不如起点板板换地方把

终于回来了下午还得上班！一夜未眠

我好像要脱单了今个儿老百姓真啊真高兴

今后的周末简直太棒了可以不用在家了

终于第一了哈哈

妈蛋，真能吊胃口我想，我想个屁

看东哥的书为什么觉得好乱的样子完全想像不到

实体书上架了这几天没啥看得了

11级。真不容易签到这么久

置顶假更呵呵

爆我在听歌：春节序曲

挖槽，有人挖坟，中招了求封！

哎呀，我喜欢今日随手一点，发现只剩下40点经验就11级了，我的第二个十一级！我喜欢，连续签到302天，有木有！

【iPhone反馈】回复帖子老是出现未知错误百度贴吧客户端:5.6.1,7.1. 硬件设备:iPhone 4S. 网络环境:非WiFi环境.

有更新，哪位吧友去更新下可以置顶，童叟无欺哟

大家好新人求罩

二更都写在标题上我以为好多更新呢

小风风要发飙了我喜欢

今天更新预测纪宁练剑，可能会突破，或者创造出新招式，媲美世界境巅峰，或超越，出门碰见两个狗，试试剑招

我终于明白了起点的大神虽然水，但是很少断更，看三少，十年未断，成就现在网络文学第一人！

最近怎么这么多拜吧的? 大家都是兼职了?

本吧吧规，请更新的进来看下本吧吧规：延迟更新一个小时！特此声明

这里是大神求关注

总是有种赶脚…… 更新好慢

恭喜贼大进来保持一天一更，很好，坚持下去坚持啊，每天都有的看，心情多么美好

世界和平作者快更

天天凑热闹

回魔都了... 又要开始上班了，蛋疼

春节来临，祝各位吧友新春快乐，万事如意祝大家在新的一年中工作顺利，万事如意，赶紧结婚，马上到！

要毁喽，六天不更新这是什么节奏

马上回家了

我觉得我要渡劫了来吧

ha

来来来,接力,更新帖中抠出来的发图不发种，菊花万人捅, 捅完还不算, 往里灌蒜瓣灌完还没晚，塞满红辣椒塞满哪能行，多少伴点醋灌醋不算多，芥末往里搁芥末怎么够，还得加大料大料不能少，往他嘴里倒大料倒完聊继续加辣椒

今天第一次第一次在起点上看完了更新, 说实在的,还不如贴吧,起点上的字体让人看着蛋疼,不知道盛大都是一堆什么程序员,能不能换个模式,破字体,看着真蛋疼

我要升级升级

求助攻啊啊啊还有45点经验，有木有！

联通号码发生短信能获得500M流量发送沃4G到10010。真的,不骗人

我觉得，回家之后就回不来了，这火车票太TM的难抢了看见了，输入之后就没有了

首页 1 2 下一页