Comment , Like , Dslike , System

[VsroHost]

Comment Like DsLike System
Lets Go

_AddnewChar -> (SRO_VT_SHARD -> Programmability -> Stored Procedures -> Right click on _AddnewChar and press on 'Modify')

-----------------------------------------------------------------------------        
	-- Facebook System        
	----------------------------------------------------------------------------- 	 
	 insert into _TimedJob ( [CharID],[Category],[JobID],[TimeToKeep],[Data1],[Data2] ,[Data3],[Data4],[Data5],[Data6],[Data7],[Data8],[Serial64],[JID])
      values (@NewCharID,0,50025,1495526072,0,1,0,0,0,0,0,0,72339069015696862,0)    
      insert _TimedJob ( [CharID],[Category],[JobID],[TimeToKeep],[Data1],[Data2] ,[Data3],[Data4],[Data5],[Data6],[Data7],[Data8],[Serial64],[JID])
      values (@NewCharID,0,50026,1495526072,0,1,0,0,0,0,0,0,72339069015696862,0) 
      insert _TimedJob ( [CharID],[Category],[JobID],[TimeToKeep],[Data1],[Data2] ,[Data3],[Data4],[Data5],[Data6],[Data7],[Data8],[Serial64],[JID])
      values (@NewCharID,0,50027,1495526072,0,1,0,0,0,0,0,0,72339069015696862,0)  
	-----------------------------------------------------------------------------

Create Table

USE [tes]
GO

/****** Object:  Table [dbo].[_Facebook]    Script Date: 09/05/2014 00:25:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_Facebook](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[CharID] [int] NULL,
	[AniChariD] [int] NULL,
	[Comment] [varchar](1000) NULL,
	[Likes] [varchar](15) NULL,
	[DisLike] [varchar](15) NULL,
	[CharName] [varchar](66) NULL,
	[AniCharName] [varchar](66) NULL,
 CONSTRAINT [PK__Facebook] 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

Ref Skill Group

1043	SKILL_FACEBOOK

Refskill

1	50025	1043	SKILL_LIKE	?:??? ?	SKILL_FACEBOOK	0	1	1	0	99999999	0	0	0	0	0	0	0	50025	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\ortai_like.ddj	SN_LIKE	xxx	SN_LIKE_TT_DESC	SN_SKILL_SN_LIKE_STUDY	0	0	3	1667396966	1851946342	1685418593	-1875767296	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	50026	1043	SKILL_DILIKE	?:??? ?	SKILL_FACEBOOK	0	1	1	0	99999999	0	0	0	0	0	0	0	50026	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\ortai_dislike.ddj	SN_DISLIKE	xxx	SN_DISLIKE_TT_DESC	SN_DISLIKE_STUDY	0	0	3	1667396966	1851946342	1685418593	-1875767296	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	50027	1043	SKILL_COMMENT	?:??? ?	SKILL_FACEBOOK	0	1	1	0	99999999	0	0	0	0	0	0	0	50027	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\ortai_comment.ddj	SN_COMMENT	xxx	SN_COMMENT_TT_DESC	SN_COMMENT_STUDY	0	0	3	1667396966	1851946342	1685418593	-1875767296	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Now Media

skilldata_35000enc

1	50025	1043	SKILL_LIKE	?:??? ?	SKILL_FACEBOOK	0	1	1	0	99999999	0	0	0	0	0	0	0	50025	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\ortai_like.ddj	SN_LIKE	xxx	SN_LIKE_TT_DESC	SN_SKILL_SN_LIKE_STUDY	0	0	3	1667396966	1851946342	1685418593	-1875767296	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	50026	1043	SKILL_DILIKE	?:??? ?	SKILL_FACEBOOK	0	1	1	0	99999999	0	0	0	0	0	0	0	50026	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\ortai_dislike.ddj	SN_DISLIKE	xxx	SN_DISLIKE_TT_DESC	SN_DISLIKE_STUDY	0	0	3	1667396966	1851946342	1685418593	-1875767296	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	50027	1043	SKILL_COMMENT	?:??? ?	SKILL_FACEBOOK	0	1	1	0	99999999	0	0	0	0	0	0	0	50027	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\ortai_comment.ddj	SN_COMMENT	xxx	SN_COMMENT_TT_DESC	SN_COMMENT_STUDY	0	0	3	1667396966	1851946342	1685418593	-1875767296	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

skilleffect

1	FACEBOOK	SKILL_LIKE	0	FALSE	1	DEFAULT	none	none	none	none	none	none	none	none	0	0,0,0,0	ONE	none	none	none	none	none	none	none	0	1	
1	FACEBOOK	SKILL_DILIKE	0	FALSE	1	DEFAULT	none	none	none	none	none	none	none	none	0	0,0,0,0	ONE	none	none	none	none	none	none	none	0	1
1	FACEBOOK	SKILL_COMMENT	0	FALSE	1	DEFAULT	none	none	none	none	none	none	none	none	0	0,0,0,0	ONE	none	none	none	none	none	none	none	0	1

textdata_equip&skill

1	SN_LIKE								Like
1	SN_DISLIKE								Dislike
1	SN_COMMENT								Comment
1	SN_LIKE_TT_DESC								You are able to like on this user by using message command U -- > Message -- > To: "Username" --> and then Write "Like" in the box then Send, the record will be saved in database.
1	SN_DISLIKE_TT_DESC								You are able to Dislike on this user by using message command U -- > Message -- > To: "Username" --> and then Write "DisLike" in the box then Send, the record will be saved in database.
1	SN_COMMENT_TT_DESC								You are able to Comment on this user by using message command U -- > Message -- > To: "Username" --> and then Write "Your Comment + Comment" in the box then Send, the record will be saved in database.
1	SN_SKILL_SN_LIKE_STUDY								You are able to like on this user by using message command U -- > Message -- > To: "Username" --> and then Write "Like" inside the box then Send, the record will be saved in database.
1	SN_DISLIKE_STUDY								You are able to Dislike on this user by using message command U -- > Message -- > To: "Username" --> and then Write "DisLike" inside the box then Send, the record will be saved in database.
1	SN_COMMENT_STUDY								You are able to Comment on this user by using message command U -- > Message -- > To: "Username" --> and then Write "Your Comment" the box then Send, the record will be saved in database.

Time To Download Media Files

http://files.fm/u/anckhge

Thanks You
Credit #Me

[​Exo]

Well i wonder if this was at the leaked Ortai database and you're just giving credits for yourself maybe not sure..
Which was stolen from Skalidor already so actually you stole a stolen idea xD

[Dallin¥]

Originally Posted by xExorcist

Well i wonder if this was at the leaked Ortai database and you're just giving credits for yourself maybe not sure..
Which was stolen from Skalidor already so actually you stole a stolen idea xD

and also he just forget the important part _memo part

[Albert Dev]

Originally Posted by M̷r̷.̷X̷

and also he just forget the important part _memo part

(Y)

check ur topic before release it :@

[Halpalicious]

I've always asked myself why and what you would use that Like and Dislike system for.

And yes of course, it is just the half release.

[Nen♥]

Originally Posted by xExorcist

Well i wonder if this was at the leaked Ortai database and you're just giving credits for yourself maybe not sure..
Which was stolen from Skalidor already so actually you stole a stolen idea xD

you're totally right in the Red Part he stole it from valthea.

Originally Posted by M̷r̷.̷X̷

and also he just forget the important part _memo part

the missed procedure from ortai db.

 Spoiler

DECLARE @TarID int = (Select CharID from _Char where CharName16 = @TargetCharName)
, @SendID int = (Select CharID from _Char where CharName16 = @SenderCharName)
DECLARE @Maxliks int = (select COUNT(Likes) from SRO_VT_ORTAI_S.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Likes = 'Like')
@MaxDis int = (select COUNT(DisLike) from SRO_VT_ORTAI_S.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and DisLike = 'Dislike')
@Maxcom int = (select COUNT(Comment) from SRO_VT_ORTAI_S.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Comment like '%Comment%')
IF @message like 'Like'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxliks < '1')
BEGIN
INSERT INTO SRO_VT_ORTAI_S.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,A niCharname) VALUES (@TarID @SendID,'None','Like','None' @TargetCharName @SenderCharName)
END
END
END
IF @message like 'DisLike'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @MaxDis < '1')
BEGIN
INSERT INTO SRO_VT_ORTAI_S.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,A niCharname) VALUES (@TarID @SendID,'None','None','Dislike' @TargetCharName @SenderCharName)
END
END
END
IF @message like '%Comment%'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxcom < '1')
BEGIN
INSERT INTO SRO_VT_ORTAI_S.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,A niCharname) VALUES (@TarID @SendID @message,'None','None' @TargetCharName @SenderCharName)
END
END
END

[​Exo]

Well the The _Memo Part is easy

[Eslam Galull]

You Gonna Fcked the Whole ( Silkroad ) System xS

[Snow*]

Originally Posted by its.soul

You Gonna Fcked the Whole ( Silkroad ) System xS

Yes Gonna Fcked The Whole System k?

[Andi_xBrainwash]

Originally Posted by Nen♥

you're totally right in the Red Part he stole it from valthea.



the missed procedure from ortai db.

 Spoiler

DECLARE @TarID int = (Select CharID from _Char where CharName16 = @TargetCharName)
, @SendID int = (Select CharID from _Char where CharName16 = @SenderCharName)
DECLARE @Maxliks int = (select COUNT(Likes) from SRO_VT_ORTAI_S.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Likes = 'Like')
@MaxDis int = (select COUNT(DisLike) from SRO_VT_ORTAI_S.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and DisLike = 'Dislike')
@Maxcom int = (select COUNT(Comment) from SRO_VT_ORTAI_S.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Comment like '%Comment%')
IF @message like 'Like'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxliks < '1')
BEGIN
INSERT INTO SRO_VT_ORTAI_S.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,A niCharname) VALUES (@TarID @SendID,'None','Like','None' @TargetCharName @SenderCharName)
END
END
END
IF @message like 'DisLike'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @MaxDis < '1')
BEGIN
INSERT INTO SRO_VT_ORTAI_S.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,A niCharname) VALUES (@TarID @SendID,'None','None','Dislike' @TargetCharName @SenderCharName)
END
END
END
IF @message like '%Comment%'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxcom < '1')
BEGIN
INSERT INTO SRO_VT_ORTAI_S.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,A niCharname) VALUES (@TarID @SendID @message,'None','None' @TargetCharName @SenderCharName)
END
END
END

Hey i have Add This ( Changed to my DB)

 Spoiler

DECLARE @TarID int = (Select CharID from _Char where CharName16 = @TargetCharName)
, @SendID int = (Select CharID from _Char where CharName16 = @SenderCharName)
DECLARE @Maxliks int = (select COUNT(Likes) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Likes = 'Like')
DECLARE @MaxDis int = (select COUNT(DisLike) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and DisLike = 'Dislike')
DECLARE @Maxcom int = (select COUNT(Comment) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Comment like '%Comment%')
IF @message like 'Like'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxliks < '1')
BEGIN
INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,A niCharname) VALUES (@TarID @SendID,'None','Like','None' @TargetCharName @SenderCharName)
END
END
END
IF @message like 'DisLike'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @MaxDis < '1')
BEGIN
INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,A niCharname) VALUES (@TarID @SendID,'None','None','Dislike' @TargetCharName @SenderCharName)
END
END
END
IF @message like '%Comment%'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxcom < '1')
BEGIN
INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,A niCharname) VALUES (@TarID @SendID @message,'None','None' @TargetCharName @SenderCharName)
END
END
END

and Get this Error

 Spoiler

Msg 102, Level 15, State 1, Procedure _Memo_Add, Line 70
Incorrect syntax near '@SendID'.
Msg 102, Level 15, State 1, Procedure _Memo_Add, Line 80
Incorrect syntax near '@SendID'.
Msg 102, Level 15, State 1, Procedure _Memo_Add, Line 90
Incorrect syntax near '@SendID'.

and i dont see a Button ingame :/

[ILowe]

good

[Bodaxgames]

best start and good system