Comment , Like , Dslike , System

[Mohamed_Candy]

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