网站地图 设为首页 加入收藏
 
红月私服中心 下载中心 发布红月 技术资料 发布家族 游戏IP生成   开区服务  
红月私服自由军团存储汉化之战争时间修改(二)
文章作者:管理员 文章来源:红月私服中心-Www.hy45.Net 更新时间:2012/2/28 8:40:49 

@FromArmyName+'自由军司令官 '+@FromArmyCommander+'
'+@ToArmyName+'自由军宣战.
战争时间:
开始: '+convert(varchar,@WarBegin, 120)+'
结束: '+convert(varchar,@WarEnd, 120)+'
战争地点是 '+@ToArmyName+'自由军所拥有的 '+@ShopOwner+'.'
                     end
                     else if @WarKind1=6 or @WarKind2=6
                     begin
                            set @MailContent=
@FromArmyName+'自由军司令官 '+@FromArmyCommander+'
'+@ToArmyName+'自由军宣战.
战争时间:
开始: '+convert(varchar,@WarBegin, 120)+'
结束: '+convert(varchar,@WarEnd, 120)+'
战争地点是 '+@ToArmyName+'拥有的秘密基地.'
                     end
 
 
                     if @IsAlliance1=1
                     begin
 
                            DECLARE ArmyMemberList CURSOR
                            FOR
                                   SELECT RegularSoldier FROM tblArmyMemberList1 WHERE ArmyID in (SELECT ArmyID FROM tblArmyAllianceList1 WHERE AllianceID=@AllianceID1)
      
                            OPEN ArmyMemberList
 
                            FETCH FROM ArmyMemberList INTO @GameID
                            WHILE @@FETCH_STATUS =0
                            BEGIN
                                   EXEC RMS_SENDMAIL @Recipient=@GameID,@Sender='自由军管理员',@Title='宣战公告',@Line=6,@MailContent=@MailContent,@Item=''
                                   FETCH FROM ArmyMemberList INTO @GameID
                            END
                            CLOSE ArmyMemberList
                            DEALLOCATE ArmyMemberList
                     end
                     else
                     begin
 
                            DECLARE ArmyMemberList CURSOR
                            FOR
                                   SELECT RegularSoldier FROM tblArmyMemberList1 WHERE ArmyID=@ArmyID1

                                  OPEN ArmyMemberList
 
                            FETCH FROM ArmyMemberList INTO @GameID
                            WHILE @@FETCH_STATUS =0
                            BEGIN
                                   EXEC RMS_SENDMAIL @Recipient=@GameID,@Sender='自由军管理员',@Title='宣战公告',@Line=6,@MailContent=@MailContent,@Item=''
                                   FETCH FROM ArmyMemberList INTO @GameID
                            END
                            CLOSE ArmyMemberList
                            DEALLOCATE ArmyMemberList
                     end
 
                     if @IsAlliance2=1
                     begin
                            DECLARE ArmyMemberList CURSOR
                            FOR
                                   SELECT RegularSoldier FROM tblArmyMemberList1 WHERE ArmyID in (SELECT ArmyID FROM tblArmyAllianceList1 WHERE AllianceID=@AllianceID2)
      
                            OPEN ArmyMemberList
 
                            FETCH FROM ArmyMemberList INTO @GameID
                            WHILE @@FETCH_STATUS =0
                            BEGIN
                                   EXEC RMS_SENDMAIL @Recipient=@GameID,@Sender='自由军管理员',@Title='宣战公告',@Line=6,@MailContent=@MailContent,@Item=''
                                   FETCH FROM ArmyMemberList INTO @GameID
                            END
                            CLOSE ArmyMemberList
                            DEALLOCATE ArmyMemberList
                     end
                     else
                     begin
 
                            DECLARE ArmyMemberList CURSOR
                            FOR
                                   SELECT RegularSoldier FROM tblArmyMemberList1 WHERE ArmyID=@ArmyID2
      
                            OPEN ArmyMemberList
 
                            FETCH FROM ArmyMemberList INTO @GameID
                            WHILE @@FETCH_STATUS =0
                            BEGIN
                                   EXEC RMS_SENDMAIL @Recipient=@GameID,@Sender='自由军管理员',@Title='宣战公告',@Line=6,@MailContent=@MailContent,@Item=''
                                   FETCH FROM ArmyMemberList INTO @GameID
                            END
                            CLOSE ArmyMemberList
                            DEALLOCATE ArmyMemberList
                     end
 
                     if @IsAlliance1=1
                     begin
                            DECLARE ArmyCommanderList CURSOR
                            FOR
                                   SELECT Commander FROM tblArmyList1 WHERE ID in  (SELECT ArmyID FROM tblArmyAllianceList1 WHERE AllianceID=@AllianceID1)
      
                            OPEN ArmyCommanderList
      
                            FETCH FROM ArmyCommanderList INTO @GameID
                            WHILE @@FETCH_STATUS =0
                            BEGIN
                                   EXEC RMS_SENDMAIL @Recipient=@GameID,@Sender='自由军管理员',@Title='宣战公告',@Line=6,@MailContent=@MailContent,@Item=''
                                   FETCH FROM ArmyCommanderList INTO @GameID
                            END
                            CLOSE ArmyCommanderList
                            DEALLOCATE ArmyCommanderList
                     end
                     else
                     begin
                            DECLARE ArmyCommanderList CURSOR
                            FOR
                                   SELECT Commander FROM tblArmyList1 WHERE ID=@ArmyID1
      
                            OPEN ArmyCommanderList
      
                            FETCH FROM ArmyCommanderList INTO @GameID
                            WHILE @@FETCH_STATUS =0
                            BEGIN
                                   EXEC RMS_SENDMAIL @Recipient=@GameID,@Sender='自由军管理员',@Title='宣战公告',@Line=6,@MailContent=@MailContent,@Item=''
                                   FETCH FROM ArmyCommanderList INTO @GameID
                            END
                            CLOSE ArmyCommanderList
                            DEALLOCATE ArmyCommanderList
                     end
 
                     if @IsAlliance2=1
                     begin
                            DECLARE ArmyCommanderList CURSOR
                            FOR
                                   SELECT Commander FROM tblArmyList1 WHERE ID in  (SELECT ArmyID FROM tblArmyAllianceList1 WHERE AllianceID=@AllianceID2)
      
                            OPEN ArmyCommanderList
      
                            FETCH FROM ArmyCommanderList INTO @GameID
                            WHILE @@FETCH_STATUS =0
                            BEGIN
                                   EXEC RMS_SENDMAIL @Recipient=@GameID,@Sender='自由军管理员',@Title='宣战公告',@Line=6,@MailContent=@MailContent,@Item=''
                                   FETCH FROM ArmyCommanderList INTO @GameID
                            END
                            CLOSE ArmyCommanderList
                            DEALLOCATE ArmyCommanderList
                     end
                     else
                     begin
                            DECLARE ArmyCommanderList CURSOR
                            FOR
                                   SELECT Commander FROM tblArmyList1 WHERE ID=@ArmyID2
      
                            OPEN ArmyCommanderList
      
                            FETCH FROM ArmyCommanderList INTO @GameID
                            WHILE @@FETCH_STATUS =0
                            BEGIN
                                   EXEC RMS_SENDMAIL @Recipient=@GameID,@Sender='自由军管理员',@Title='宣战公告',@Line=6,@MailContent=@MailContent,@Item=''
                                   FETCH FROM ArmyCommanderList INTO @GameID
                            END
                            CLOSE ArmyCommanderList
                            DEALLOCATE ArmyCommanderList
                     end
 
              end
       end
 
commit transaction RMS_ARMY_DECLAREWAR


GO

浏览次数:388
最新文章
· 2003系统任务栏显示桌面图标不见了处理办法...
· 修改红月私服某特定怪属性...
· 红月管理工具使用的配置...
· 教你怎么1个怪1级(去除10%限制)...
· 红月游戏帐号注册之二...
· 红月游戏帐号注册之三...
· 红月游戏帐号注册之一...
· 红月私服带杀人次数排行榜...
· 带防盗码生化排行...
· 出身完成任务一级发针存储过程...
热门文章
· 红月技能点属性上限...
· 3.8C红月私服限制部分外挂的方法...
· 调皮外挂不能正常使用...
· 红月私服角色之说...
· 升华原版升级代码...
· 红月私服自由军团存储汉化之自由军解散原因...
· 红月B2战争规则...
· 红月NPC各地点坐标...
· 红月服务器如何做到冲卡的...
· 红月外挂不能使用新解决办法...
关于我们 开区服务 网站帮助 全部私服
 
CopyRight @2010 hy45.net, Inc. All Rights Reserved  

备案登记号:苏ICP备11017169号-1