[Release]Unique Slayer System ,, grant title + write notice + reward

[_Joe]

This system has never been released before .. and as i know , haters are going to hate , thats usual ..
explaining of this system :

 Spoiler

When you kill a specific unique 10 times or however value you select ,, a notice will be written with your char name and which unique you killed and which title you have received .. It'll also reward u a title name .. And it'll reward you an item from your select .. as i know you should edit this and not reply with : 'error' or 'not working' .. and of course you should use auto notice writer

Tested on vsro only..
Here we go .
First .. create these 2 tables

 Spoiler

USE [SRO_VT_SHARDLOG]
GO


/****** Object: Table [dbo].[PlusNotice] Script Date: 14.06.2013 18:09:33 ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


SET ANSI_PADDING ON
GO


CREATE TABLE [dbo].[PlusNotice](
[Sent] [int] NOT NULL,
[Message] [varchar](300) NOT NULL,
[Date] [datetime] NOT NULL
) ON [PRIMARY]


GO


SET ANSI_PADDING OFF
GO


ALTER TABLE [dbo].[PlusNotice] ADD CONSTRAINT [DF_PlusNotice_Sent] DEFAULT ((0)) FOR [Sent]
GO


ALTER TABLE [dbo].[PlusNotice] ADD CONSTRAINT [DF_PlusNotice_Date] DEFAULT (getdate()) FOR [Date]
GO

 Spoiler

USE [SRO_VT_SHARDLOG]
GO

Object Table [dbo].[_Uniques] Script Date 9122014 54158 PM
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_Uniques](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[CharName] [varchar](255) NOT NULL,
[MonsterCodeName] [varchar](255) NULL,
[Time] [datetime] NULL,
CONSTRAINT [PK_UniqueKills] 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

Add this to _AddLogItem

 Spoiler

ELSE IF (@CharNameCountKERB >= '10')
begin
IF @hwan = '90'
begin
Update SRO_VT_SHARD.dbo._Char Set HwanLevel='91' where (CharName16 = @Charname)
insert into SRO_VT_SHARDLOG.dbo.PlusNotice ([Sent],[message],[date]) Values ('0','** Unique Slayer System** : '+@Charname+' has now recived ( Cerberus Slayer) title for killing Cerberus 10 times ',GETDATE())
delete from SRO_VT_SHARDLOG.dbo._Uniques where ((CharName = @Charname) and MonsterCodeName like 'MOB_EU_KERBEROS')
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_02',10,0
end
end

Press thanks if i helped .

[VsroHost]

delete from SRO_VT_SHARDLOG.dbo._Uniques where ((CharName = @Charname) and MonsterCodeName like :/ Fail again !

[Eslam Galull]

delete from SRO_VT_SHARDLOG.dbo._Uniques where ((CharName = @Charname) and MonsterCodeName like 'MOB_EU_KERBEROS')

>> SRO_VT_SHARDLOG.dbo.PlusNotice Missed Table Btw
>> SRO_VT_SHARDLOG.dbo._Uniques same as above ..

Would you Explain more xDDDD

Copy & Past ?

btw :-
+1 this **** didnt released before . you are right xDD

[Muhab*]

Originally Posted by _Joe

This system has never been released before .. and as i know , haters are going to hate , thats usual ..
explaining of this system :

 Spoiler

When you kill a specific unique 10 times or however value you select ,, a notice will be written with your char name and which unique you killed and which title you have received .. It'll also reward u a title name .. And it'll reward you an item from your select .. as i know you should edit this and not reply with : 'error' or 'not working' .. and of course you should use auto notice writer

Tested on vsro only..
Here we go .
Add this to _AddLogItem
Press thanks if i helped .

how you dared to post this ?
please write your address here i must send you a gift.

[Dallin¥]

WTF

[_Joe]

Originally Posted by its.soul

>> SRO_VT_SHARDLOG.dbo.PlusNotice Missed Table Btw
>> SRO_VT_SHARDLOG.dbo._Uniques same as above ..

Would you Explain more xDDDD

Copy & Past ?

btw :-
+1 this shit didnt released before . you are right xDD

done i have added these 2 tables .. sorry i was tired when i released this and i forgot many things

Originally Posted by Muhab Ashraf

how you dared to post this ?
please write your address here i must send you a gift.

at your mother's bed .. im waiting for your gift

Originally Posted by funkynagy

delete from SRO_VT_SHARDLOG.dbo._Uniques where ((CharName = @Charname) and MonsterCodeName like :/ Fail again !

done .. i have added _Uniques table

[​Exo]

You really started ******* me off..
FOR ***** SAKE stop posting others work.. it doesn't make you so pro..

[TrypticoN]

Just wrong, in so many aspects...

[[NoReason]]

Originally Posted by xExorcist

You really started ******* me off..
FOR ***** SAKE stop posting others work.. it doesn't make you so pro..

doesn't make sense

[Eroticus]

Originally Posted by xExorcist

You really started ******* me off..
FOR ***** SAKE stop posting others work.. it doesn't make you so pro..

Lol people stole from joymax their server files and it's "OK" but sharing another people work who stole another people work is not "OK" ...

[_Joe]

Originally Posted by M̷r̷.̷X̷

WTF

What's Wrong with you -_- say it's not working too :3

Originally Posted by xExorcist

You really started ******* me off..
FOR ***** SAKE stop posting others work.. it doesn't make you so pro..

dude.. if we didn't share good things / systems ! beginners will never learn and never step up .. If you are a beginner , how will you feel if you asked some one for help and he said 'pay' and you haven't money -_- . as i see .. you should pay to buy databases / server files / virtual private servers / dedicated servers / domains / protection / sooooo special systems ..

[Muhab*]

Originally Posted by _Joe

at your mother's bed .. im waiting for your gift

O.o you are not here lanet kedii...don't lie
are u saying that your ****** tables and _addlogitems lines able to record unique kills!! GTFO please

[Tommy.]

Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 46
Must declare the scalar variable "@CharNameCountKERB".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 48
Must declare the scalar variable "@hwan".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 50
Must declare the scalar variable "@Charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 51
Must declare the scalar variable "@Charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 52
Must declare the scalar variable "@Charname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 53
Must declare the scalar variable "@Charname".

While trying to add the addlogitem lines,

Any Solution?

[Syloxx]

Originally Posted by Eroticus

Lol people stole from joymax their server files and it's "OK" but sharing another people work who stole another people work is not "OK" ...

1st we didn't hacked it from Joymax its stolen from other company's who bought the rights to use.

2nd joymax didn't send the files via email so we had to work for it

joymax itself never hacked till now, just the database got leaked.

Originally Posted by Muhab Ashraf

O.o you are not here lanet kedii...don't lie
are u saying that your ****** tables and _addlogitems lines able to record unique kills!! GTFO please

blame other ppl SQL is mine job not yours

usally i would do the System better but no idea where to start here

[atooooon]

nice