[SQL] Stored Procedure for TitleUpdating Automatic

[royalblade]

heya guys,

this was made a looooooong time ago when we wanted to make title giving automatic on devias. however, it was never used cuz of lazyness.
Just found it again and thought i´d release it. This is to be executed each time a new uniquelog is added.

It works like this
gets the first charname that killed the MOB "Devias".
If you kill devias for the first time u get the title Devias Slayer #1
for the second time Devias Slayer #2
etc.
Meaning u will have to create multiple titles. however, the system itself is rpetty cool

have fun.
For support add me on skype:akasch93

PHP Code:

USE [SRO_VT_ROYAL]
GO
/****** Object:  StoredProcedure [dbo].[_RoyalAutoTitleUpdater]    Script Date: 04/25/2013 17:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[_RoyalAutoTitleUpdater]
as
declare @newhwan int
declare @Charname varchar (30)

Update _Char Set HwanLevel = '0' where HwanLevel = '10'

Set @Charname = ( Select top 1 Charname from SRO_VT_ACCOUNT.dbo.Evangelion_uniques
order by SRO_VT_ACCOUNT.dbo.Evangelion_uniques.time desc)

set @newhwan = ((select COUNT(Mobname) from SRO_VT_ACCOUNT.dbo.Evangelion_uniques
where charname = @Charname and Mobname = 'MOB_GOD_FLAME_COWKING_B4')+100) -- +100 based on xxx normal title being hwanlvl 10

Update SRO_VT_SHARD.dbo._Char set SRO_VT_SHARD.dbo._Char.HwanLevel = 
@newhwan where CharName16 = 
@Charname AND (select top 1 Mobname from SRO_VT_ACCOUNT.dbo.Evangelion_uniques) = 'MOB_GOD_FLAME_COWKING_B4' 


[PortalDark]

#approved

[pushipu]

Very interesting, thx for share.

[spider560]

thanx

[ILowe]

Msg 208, Level 16, State 6, Procedure _RoyalAutoTitleUpdater, Line 14
Invalid object name 'dbo._RoyalAutoTitleUpdater'.

[FL0wshY]

Originally Posted by ILowe

Msg 208, Level 16, State 6, Procedure _RoyalAutoTitleUpdater, Line 14
Invalid object name 'dbo._RoyalAutoTitleUpdater'.

Try this.

USE [SRO_VT_ROYAL] 
GO 
/****** Object:  StoredProcedure [dbo].[_RoyalAutoTitleUpdater]    Script Date: 04/25/2013 17:58:40 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE PROCEDURE [dbo].[_RoyalAutoTitleUpdater] 
as 
declare @newhwan int 
declare @Charname varchar (30) 

Update _Char Set HwanLevel = '0' where HwanLevel = '10' 

Set @Charname = ( Select top 1 Charname from SRO_VT_ACCOUNT.dbo.Evangelion_uniques 
order by SRO_VT_ACCOUNT.dbo.Evangelion_uniques.time desc) 

set @newhwan = ((select COUNT(Mobname) from SRO_VT_ACCOUNT.dbo.Evangelion_uniques 
where charname = @Charname and Mobname = 'MOB_GOD_FLAME_COWKING_B4')+100) -- +100 based on *** normal title being hwanlvl 10 

Update SRO_VT_SHARD.dbo._Char set SRO_VT_SHARD.dbo._Char.HwanLevel =  
@newhwan where CharName16 =  
@Charname AND (select top 1 Mobname from SRO_VT_ACCOUNT.dbo.Evangelion_uniques) = 'MOB_GOD_FLAME_COWKING_B4'

[A new hope]

Originally Posted by ILowe

Msg 208, Level 16, State 6, Procedure _RoyalAutoTitleUpdater, Line 14
Invalid object name 'dbo._RoyalAutoTitleUpdater'.

you need to create, not alter.

[egystorm]

ThX

[PlayPVP]

I feel something wrong with this procedure,

"Update _Char Set HwanLevel = '0' where HwanLevel = '10' "

WTF is that? Can someone understand good about sql tell us if this procedure is right or no?

[◄:●:►SanToS◄:●:►]

Originally Posted by royalblade

heya guys,

this was made a looooooong time ago when we wanted to make title giving automatic on devias. however, it was never used cuz of lazyness.
Just found it again and thought i´d release it. This is to be executed each time a new uniquelog is added.

It works like this
gets the first charname that killed the MOB "Devias".
If you kill devias for the first time u get the title Devias Slayer #1
for the second time Devias Slayer #2
etc.
Meaning u will have to create multiple titles. however, the system itself is rpetty cool

have fun.
For support add me on skype:akasch93

PHP Code:

USE [SRO_VT_ROYAL]
GO
/****** Object:  StoredProcedure [dbo].[_RoyalAutoTitleUpdater]    Script Date: 04/25/2013 17:58:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[_RoyalAutoTitleUpdater]
as
declare @newhwan int
declare @Charname varchar (30)

Update _Char Set HwanLevel = '0' where HwanLevel = '10'

Set @Charname = ( Select top 1 Charname from SRO_VT_ACCOUNT.dbo.Evangelion_uniques
order by SRO_VT_ACCOUNT.[COLOR="SandyBrown"]dbo.Evangelion_uniques.time[/COLOR] desc)

set @newhwan = ((select COUNT(Mobname) from SRO_VT_ACCOUNT.dbo.Evangelion_uniques
where charname = @Charname and Mobname = 'MOB_GOD_FLAME_COWKING_B4')+100) -- +100 based on xxx normal title being hwanlvl 10

Update SRO_VT_SHARD.dbo._Char set SRO_VT_SHARD.dbo._Char.HwanLevel = 
@newhwan where CharName16 = 
@Charname AND (select top 1 Mobname from SRO_VT_ACCOUNT[COLOR="Red"].dbo.Evangelion_uniques[/COLOR]) = 'MOB_GOD_FLAME_COWKING_B4' 


.dbo.Evangelion_uniques
is that missing table name ?

[Ninja_Stylez]

USE [SRO_VT_ACCOUNT] 
GO 

/****** Object:  Table [dbo].[Evangelion_uniques]    Script Date: 09/13/2012 23:17:30 ******/ 
SET ANSI_NULLS ON 
GO 

SET QUOTED_IDENTIFIER ON 
GO 

SET ANSI_PADDING ON 
GO 

CREATE TABLE [dbo].[Evangelion_uniques]( 
    [ID] [int] IDENTITY(1,1) NOT NULL, 
    [CharName] [varchar](20) NOT NULL, 
    [MobName] [varchar](50) NOT NULL, 
    [time] [varchar](100) NOT NULL, 
 CONSTRAINT [PK_Evangelion_uniques] PRIMARY KEY CLUSTERED  
( 
    [ID] ASC 
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY] 
) ON [PRIMARY] 

GO 

SET ANSI_PADDING OFF 
GO

Trololo... but you need evangelion gameserver in order to make this tabela nd bla bla to work

[Hurricane*]

Hey, You can edit this query for me ? I need make this query when a player kill like more than 50 unique get a title for example : Unique Hunter
example:
when you kill 50 Unique get Unique Hunter
when you kill 100 unique get Unique King
when you kill 150 unique get Unique Boss
but i need make it for all uniques not only one unique !