[Release] Normal JobWar Event System.

[Rackish]

i know it's old system and not automatic too.. but it can help you if you want to add this in your server ^^ ... it's easy

-Let's Go...

-You have first to add this Table in your [DB] as you want..

 Spoiler

USE [SRO_VT_RACKISH]
GO

/****** Object: Table [dbo].[JobWar_Event] Script Date: 28/12/2016 00:00:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[JobWar_Event](
[CharID] [int] NOT NULL,
[Kills] [int] NULL,
[CharName] [varchar](64) NULL,
[Date] [date] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

---------------------
USE [SRO_VT_RACKISH]
GO

/****** Object: Table [dbo].[GM_Online] Script Date: 28/12/2016 00:00:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[GM_Online](
[CharID] [int] NOT NULL,
[Charname] [varchar](64) NOT NULL,
[Status] [varchar](20) NOT NULL,
[Date] [datetime] NOT NULL,
[Minutes] [bigint] NULL,
[stillOnline@] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


-----------------
USE [SRO_VT_RACKISH]
GO

/****** Object: Table [dbo].[Job_Service] Script Date: 28/12/2016 00:00:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Job_Service](
[Service] [int] NULL
) ON [PRIMARY]

GO

INSERT INTO dbo.Job_Service (Service) values (0)

GO
-----------------

-then you have too add this Code in your DB ==> Procedures ==> SRO_VT_SHARD.._Memo_Add

 Spoiler

-------------------------------Coded By Rackish-------------------------------
If (@TargetCharName like 'Rackish' and @SenderCharName in (select CharName from SRO_VT_RACKISH.dbo.GM_Online) and @Message = 'Job:ON')
begin
Declare @GMKillsON varchar(512)
Set @GMKillsON = '[JobWar Event] Start By '+@SenderCharName+' in [Donwhang South] please put your job suite and go kill [50] players'
insert into SRO_VT_SYSTEM..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',@GMKillsON,Getdate())
update SRO_VT_RACKISH.dbo.Job_Service
set Service = '1'
End
If (@TargetCharName like 'Rackish' and @SenderCharName in(select CharName from SRO_VT_RACKISH.dbo.GM_Online) and @Message = 'Job:OFF')
begin
update SRO_VT_RACKISH.dbo.Job_Service set Service = '0'
update SRO_VT_RACKISH.dbo.JobWar_Event set Kills = '0'
Declare @GMKillsOFF varchar(512)
Set @GMKillsOFF = '[JobWar Event] Ended By '+@SenderCharName+' in Donwhang south good luck next time'
insert into SRO_VT_SYSTEM..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',@GMKillsOFF,Getdate())
End
-------------------------------Coded By Rackish-------------------------------

like this pic:

 Spoiler

-Last thing you will add this in SRO_VT_SHARDLOG.._AddLogChar

 Spoiler

-------------------------------Coded By Rackish-------------------------------
Declare @Loginfo varchar(512)
Declare @Charname_Log varchar(150)
Set @Charname_Log = (select CharName16 from SRO_VT_SHARD.._Char where CharID = @CharID)

If (@CharID in (select CharID from SRO_VT_SHARD.._User with (nolock) where UserJID in (select JID from SRO_VT_ACCOUNT..TB_User with (nolock) where sec_content = 1)) )
BEGIN
If not exists (select CharID from SRO_VT_RACKISH..GM_Online where CharID = @CharID)
begin
Insert Into SRO_VT_RACKISH..GM_Online (CharID, Charname, [Status], [Date], [Minutes], [StillOnline@])
Values (@CharID, @Charname_Log, 'Online', GETDATE(), 0, GETDATE() );
End
End

If (@EventID = 6)
Begin
Update SRO_VT_RACKISH..GM_Online set [Status] = 'Offline', [stillOnline@] = GetDate(), [Minutes] = [Minutes] + (Datediff(Minute,[Date],GETDATE() ) )
Where CharID = @CharID
End

If (@EventID = 4)
BEGIN
Update SRO_VT_RACKISH..GM_Online Set [Status] = 'Online', [Date] = GETDATE(), [StillOnline@] = GETDATE()
where CharID = @CharID
End
-------------------------------Coded By Rackish-------------------------------
Declare @Job_Charname varchar(64) = (Select CharName16 from SRO_VT_SHARD.._Char where CharID = @CharID);
Declare @Job_Kills int = (Select top 1 kills from SRO_VT_RACKISH..JobWar_Event);
Declare @Job_Service int = (Select top 1 Service from SRO_VT_RACKISH..Job_Service where Service = '1');
Declare @Jop_Top int = (Select top 1 CharID from SRO_VT_RACKISH..JobWar_Event where Kills >='70');
Declare @Job_CN varchar(64) = (Select top 1 CharName from SRO_VT_RACKISH..JobWar_Event where Kills = '70');
Declare @USERID_JOB_EVENT varchar(64)= (Select StrUserID from SRO_VT_ACCOUNT..TB_User inner join SRO_VT_SHARD.._User
On SRO_VT_SHARD.._User.UserJID = SRO_VT_ACCOUNT..TB_User.JID where SRO_VT_SHARD.._User.CharID = @Jop_Top)


If (@EventID = '19' and @strPos like '%(0x6599)%' and @Job_Service = '1' )
begin
If exists (select * from SRO_VT_RACKISH..JobWar_Event where CharID = @CharID)
begin
Update SRO_VT_RACKISH..JobWar_Event Set Kills = Kills+1 where CharID = @CharID
End
ELSE Insert Into SRO_VT_RACKISH..JobWar_Event (charid,Kills,CharName,Date) values (@charid,1,@Job_Charname,GETDATE())
End
-------------------------------Coded By Rackish-------------------------------
Declare @Death_Name Varchar(64);
Declare @Req_Level int
Declare @Death_CID int
SET @Death_Name = (select LEFT((Select Substring(@Desc, PATINDEX('%(%',@Desc) + 1, LEN(@Desc)))
, CHARINDEX(')', (Select Substring(@Desc, PATINDEX('%(%',@Desc) + 1, LEN(@Desc)))) - 1) WHERE
CHARINDEX(')',(Select Substring(@Desc, PATINDEX('%(%',@Desc) + 1, LEN(@Desc)))) > 0)
SET @Death_CID = (SELECT CharID FROM SRO_VT_SHARD.._Char where CharName16 = @Death_Name)
SET @Req_Level = (SELECT CurLevel FROM SRO_VT_SHARD.._Char where CharID = @Death_CID)
Declare @Kills int = (Select Kills from SRO_VT_RACKISH..JobWar_Event where CharID = @CharID )
Declare @Job_CN1 varchar(64) = (Select top 1 CharName from SRO_VT_RACKISH..JobWar_Event where Kills >= '50')
Declare @Job_TOP1 int = (Select top 1 CharID from SRO_VT_RACKISH..JobWar_Event where Kills >= '50')
Declare @USERID_JOB_EVENT1 varchar(64)= (Select StrUserID from SRO_VT_ACCOUNT..TB_User inner join SRO_VT_SHARD.._User
On SRO_VT_SHARD.._User.UserJID = SRO_VT_ACCOUNT..TB_User.JID where SRO_VT_SHARD.._User.CharID = @Job_TOP1)
-------------------------------Coded By Rackish-------------------------------
Declare @Rackish_1 int;
SET @Rackish_1 = (Select top 1 Kills from SRO_VT_RACKISH..JobWar_Event order by Kills desc )
Declare @CN_NAME_1 varchar(64) = (Select top 1 CharName from SRO_VT_RACKISH..JobWar_Event where Kills = '10' );

If (@EventID = '19' and @Rackish_1 = '10')
begin
Declare @Rackish_job_1 varchar(200)
SET @Rackish_job_1 = '[JobWar Top] Player:'+@CN_NAME_1+' has Killed 10 in JobWar from [50].'
insert into SRO_VT_SYSTEM..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',@Rackish_job_1,Getdate())
End

Declare @CN_NAME_2 varchar(64) = (Select top 1 CharName from SRO_VT_RACKISH..JobWar_Event where Kills = '20' );
If (@EventID = '19' and @Rackish_1 = '20')
begin
Declare @Rackish_job_2 varchar(200)
SET @Rackish_job_2 = '[JobWar Top] Player:'+@CN_NAME_2+' has Killed 20 in JobWar from [50].'
insert into SRO_VT_SYSTEM..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',@Rackish_job_2,Getdate())
End

Declare @CN_NAME_3 varchar(64) = (Select top 1 CharName from SRO_VT_RACKISH..JobWar_Event where Kills = '40' );
If (@EventID = '19' and @Rackish_1 = '40')
begin
Declare @Rackish_job_3 varchar(200)
SET @Rackish_job_3 = '[JobWar Top] Player:'+@CN_NAME_3+' has Killed 40 in JobWar from [50].'
insert into SRO_VT_SYSTEM..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',@Rackish_job_3,Getdate())
End

Declare @CN_NAME_4 varchar(64) = (Select top 1 CharName from SRO_VT_RACKISH..JobWar_Event where Kills = '48' );
If (@EventID = '19' and @Rackish_1 = '48')
begin
Declare @Rackish_job_4 varchar(200)
SET @Rackish_job_4 = '[JobWar Top] Player:'+@CN_NAME_4+' has Killed 48 in JobWar from [50].'
insert into SRO_VT_SYSTEM..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',@Rackish_job_4,Getdate())
End

Declare @CN_NAME_5 varchar(64) = (Select top 1 CharName from SRO_VT_RACKISH..JobWar_Event where Kills >= '50' );
If (@EventID = '19' and @Rackish_1 >= '50')
begin
Declare @Rackish_job_5 varchar(200)
SET @Rackish_job_5 = '[JobWar Top] Event ended Player: ['+@CN_NAME_5+']'+'is the winner with [50] JobWar kills in Donwhang South Reward: [bla bla bla].'
insert into SRO_VT_SYSTEM..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',@Rackish_job_5,Getdate())

Declare @USERID_2_TOP varchar(64);
SET @USERID_2_TOP = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join SRO_VT_SHARD.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)

EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_2_TOP, @PkgID = NULL, @NumSilk = 0, @Price = 0 -- If you want to add 'silk'
Exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN1] @codename = 'ITEM_ETC_SD_TOKEN_04' ,@data = 50 ,@charname = @Job_CN1,@opt_level = 0 -- If you want add 'Items or etc'
update SRO_VT_RACKISH..JobWar_Event set Kills = '0'
update SRO_VT_RACKISH..Job_Service set Service = '0'
End
-------------------------------Coded By Rackish-------------------------------

-Test Pic:

JobWar System

-Download Files:
-Pass:Rackish

[elmagico321]

you will have to edit " insert into SRO_VT_SYSTEM..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',@Rackish_job_5,Getdate()) " to any kind of notice program .
like this without having the iLegend tool it won't send notices

[pushipu]

Wondering why some text files in download link was blocked by Chrome as malicious....

[B1Q]

Originally Posted by pushipu

Wondering why some text files in download link was blocked by Chrome as malicious....

these are not text file :3

maybe the rar has exes or smth idk i didn't download it

[Rackish]

Originally Posted by elmagico321

you will have to edit " insert into SRO_VT_SYSTEM..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',@Rackish_job_5,Getdate()) " to any kind of notice program .
like this without having the iLegend tool it won't send notices

he can edit it bro ^_^

[AqRa]

Ty bro..

[Damitsu]

Good job

[mohamedosha]

Link not Work

[midoxevi71]

lin not work can upload again

[Tripple2]

have link ?

[denise456]

where link?

[AligatorSniper]

link please?
ty !

[Ntrey]

Link

[Empire1453]

interesting system

[denise456]

Link?