elbattawy1st |
27-09-2016 05:45 PM |
رد: Hero System Scroll
اقتباس:
المشاركة الأصلية كتبت بواسطة mohamed9000
(المشاركة 5279934)
تسلم يا كبير بستنا المواضيع بتاعتك دايما xD
عايزين سيستم change title by msg و automatic events بقي :)
|
فى الخدمه يامعلم ^_^
قول اى ايفنت انت عاوزه و انا هعملو و انزلو هنا انشاء الله ^_^
اقتباس:
المشاركة الأصلية كتبت بواسطة X_Shadow
(المشاركة 5279937)
uf]عبده هو ينفع اخلى برنامج K Gurad هو لبى يكتب النوتس اصلى انا شغال بيه ولو ينفع ممكن تقولى الطريقة لو سمحت شكرا
|
تمام يامعلم بس انت شغال بجارد SuperMike مش Kgaurd
دا بروسيدور اعمل بدل الا عندك و notice هيشتغل انشاء الله تمام على Supermike
كود PHP:
USE [ELBATTAWY_SYSTEMS]
GO
/****** Object: StoredProcedure [dbo].[Hero_System] Script Date: 9/27/2016 5:34:24 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Abdelrhman Elbattawy
-- =============================================
ALTER procedure [dbo].[Hero_System]
@CharID int,
@Type int
as
/***************************************** Start System *****************************************/
----------- # Main Declares
Declare @CharName_Old varchar(64) ,@CharName_New varchar(64)
,@CharID_Old int ,@CheckHwanlevel int
,@HwanlevelOld int ,@HwanlevelHero int
,@HwanlevelcheckIn int ,@Hwanlevelcheckout int
----------- # Set Hwanlevel New (Title Hero) Change it what ever u want !!!!
Set @HwanlevelHero = '5'
----------- # Start (1) Type Of System ( **** Main Part **** )
IF @Type = '0'
Begin
----------- # Insert Hwanlevel New Char
Set @CheckHwanlevel = (Select Top 1 Hwanlevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID)
IF @CharID Not In (Select Top 1 CharID From [ELBATTAWY_SYSTEMS].[dbo].[OldTitles_Hero])
IF (@CheckHwanlevel != @HwanlevelHero)
Begin
Insert Into [ELBATTAWY_SYSTEMS].[dbo].[OldTitles_Hero] ([CharID],[OldHwan]) Values (@CharID,@CheckHwanlevel)
End
IF @CharID In (Select Top 1 CharID From [ELBATTAWY_SYSTEMS].[dbo].[OldTitles_Hero]) And (@CheckHwanlevel != @HwanlevelHero)
Begin
UPDATE [ELBATTAWY_SYSTEMS].[dbo].[OldTitles_Hero] Set OldHwan=@CheckHwanlevel where CharID = @CharID
End
------------ # Main Set Valuable
Set @CharName_Old = (Select Top 1 CharName16 From [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanlevelHero )
Set @CharID_Old = (Select Top 1 CharID From [SRO_VT_SHARD].[dbo].[_Char] Where HwanLevel = @HwanlevelHero)
Set @CharName_New = (Select Top 1 CharName16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID )
Set @HwanlevelOld = (Select Top 1 Oldhwan From [ELBATTAWY_SYSTEMS].[dbo].[OldTitles_Hero] Where CharID = @CharID_Old)
----------- # Notice In Server & Take Hwanlevel From Old Char
IF Not EXISTS (Select Top 1 CharID From [SRO_VT_SHARD].[dbo].[_Char] Where Hwanlevel = @HwanlevelHero )
Begin
insert into [SwaggerGuard].[dbo].[_Notice] ([message],[sent],[added]) Values ('** Attention** : ['+@CharName_New+'] Is Now The Hero Of TesT Server ',0,GETDATE())
Update [SRO_VT_SHARD].[dbo].[_Char] Set HwanLevel = @HwanlevelHero Where CharID = @CharID
End
IF EXISTS (Select Top 1 CharID From [SRO_VT_SHARD].[dbo].[_Char] Where Hwanlevel = @HwanlevelHero ) And (@CharName_New != @CharName_Old)
Begin
insert into [SwaggerGuard].[dbo].[_Notice] ([message],[sent],[added]) Values ('** Attention** : ['+@CharName_New+'] Take The Hero Of TesT Server From ['+@CharName_Old+'] ',0,GETDATE())
Update [SRO_VT_SHARD].[dbo].[_Char] Set HwanLevel = @HwanlevelHero Where CharID = @CharID
Update [SRO_VT_SHARD].[dbo].[_Char] Set HwanLevel = @HwanlevelOld Where CharID = @CharID_Old
End
IF EXISTS (Select Top 1 CharID From [SRO_VT_SHARD].[dbo].[_Char] Where Hwanlevel = @HwanlevelHero ) And (@CharName_New = @CharName_Old)
Begin
insert into [SwaggerGuard].[dbo].[_Notice] ([message],[sent],[added]) Values ('** Attention** : ['+@CharName_New+'] Still Have The Hero Of TesT Server',0,GETDATE())
End
End
---------- # End (1) Type of System
---------- # Start (2) Type of System ( **** Log in Part **** )
IF @Type = '1'
Begin
-------- # Main Declare
Set @CharName_New = (Select Top 1 CharName16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID )
-------- # Check Hwanlevel
Set @Hwanlevelcheckin = (Select Top 1 Hwanlevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID)
-------- # Notice In Server
IF @HwanlevelCheckIn = @HwanlevelHero
Begin
insert into [SwaggerGuard].[dbo].[_Notice] ([message],[sent],[added]) Values ('** Attention !!** : ['+@CharName_New+'] Have Title [The Hero Of Test Server] is Online',0,GETDATE())
End
End
---------- # End (2) Type of System
---------- # Start (3) Type of System ( **** Logout Part **** )
IF @Type = '2'
Begin
-------- # Main Declare
Set @CharName_New = (Select Top 1 CharName16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID )
-------- # Check Hwanlevel
Set @Hwanlevelcheckout = (Select Top 1 Hwanlevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID)
-------- # Notice In Server
IF @HwanlevelCheckout = @HwanlevelHero
Begin
insert into [SwaggerGuard].[dbo].[_Notice] ([message],[sent],[added]) Values ('** Attention !!** : ['+@CharName_New+'] Have Title [The Hero Of Test Server] is Offline',0,GETDATE())
End
End
---------- # End (3) Type of System
/***************************************** End System *****************************************/
|