[RELEASE] Comment Like DsLike System

[CallM3B1tch]

Hello there....
i saw alot of members asking about Comment / Like / DsLike System
so i would help ya guys in this system .

Lets Start .

-----------------------------------------------------------------------------        
    -- 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

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.

-----------------------
Download Link :


Regards .

[deadlyman13]

Keep going .

[Mythshadow]

Good job

[hellme20]

Keep Going

[CallM3B1tch]

Originally Posted by deadlyman13

Keep going .

Thanks Brah

Originally Posted by hellme20

Keep Going

Thanks .

Originally Posted by Mythshadow

Good job

Thanks Brutha

[dangermetal]

keep it up

[CallM3B1tch]

Originally Posted by dangermetal

keep it up

Thanks .

[Dallin¥]

why most of those community peoples just copied the stuff without even know whats that even doing and also you just forget the important _Memo_Add part

[bestprem]

Huh where is _memoAdd

[VsroHost]

Copy Past :3 Credit Candy1337

Originally Posted by MaDenGo

He only missing this procedure

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

 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,AniCharname) 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,AniCharname) 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,AniCharname) VALUES (@TarID @SendID @message,'None','None' @TargetCharName @SenderCharName)
                END   
                 END  
                  END

Thanks if helped

[AnTaKa25]

Add SkillGruop !!!!!!
But ThX

[Lepus-O]

Originally Posted by AnTaKa25

Add SkillGruop !!!!!!
But ThX

you can make it by yourself

[*-S.1T]

I think its useless system but any way Thanks.

[fxreklam]

Good job

[spinal2]

no work