|
You last visited: Today at 10:48
Advertisement
Comment , Like , Dslike , System
Discussion on Comment , Like , Dslike , System within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
09/13/2014, 00:01
|
#1
|
elite*gold: 20 
Join Date: May 2010
Posts: 503
Received Thanks: 69
|
Comment , Like , Dslike , System
Comment Like DsLike System
Lets Go
_AddnewChar -> (SRO_VT_SHARD -> Programmability -> Stored Procedures -> Right click on _AddnewChar and press on 'Modify')
Code:
-----------------------------------------------------------------------------
-- 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
Code:
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
Code:
1043 SKILL_FACEBOOK
Refskill
Code:
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
Code:
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
Code:
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
Code:
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
Code:
http://files.fm/u/anckhge
Thanks You
Credit #Me
|
|
|
|
09/13/2014, 01:47
|
#2
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
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
|
|
|
|
|
09/13/2014, 06:28
|
#3
|
elite*gold: 33
Join Date: Mar 2014
Posts: 472
Received Thanks: 862
|
Quote:
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
|
|
|
|
|
09/13/2014, 13:38
|
#4
|
elite*gold: 0
Join Date: Aug 2013
Posts: 127
Received Thanks: 32
|
Quote:
Originally Posted by M̷r̷.̷X̷
and also he just forget the important part _memo part
|
(Y) 
check ur topic before release it :@
|
|
|
|
|
09/13/2014, 13:54
|
#5
|
elite*gold: 0
Join Date: Oct 2013
Posts: 152
Received Thanks: 50
|
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.
|
|
|
|
|
09/13/2014, 16:11
|
#6
|
elite*gold: 26
Join Date: Aug 2014
Posts: 75
Received Thanks: 21
|
Quote:
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.
Quote:
Originally Posted by M̷r̷.̷X̷
and also he just forget the important part _memo part
|
the missed procedure from ortai db.
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
|
|
|
|
|
09/13/2014, 17:31
|
#7
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
Well the The _Memo Part is easy 
|
|
|
|
|
09/14/2014, 11:45
|
#8
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 524
|
You Gonna Fcked the Whole ( Silkroad ) System xS
|
|
|
|
|
09/14/2014, 14:05
|
#9
|
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,438
|
Quote:
Originally Posted by its.soul
You Gonna Fcked the Whole ( Silkroad ) System xS
|
Yes Gonna Fcked The Whole System k?
|
|
|
|
|
05/17/2015, 15:50
|
#10
|
elite*gold: 0
Join Date: Feb 2015
Posts: 166
Received Thanks: 42
|
Quote:
Originally Posted by Nen♥
you're totally right in the Red Part he stole it from valthea.
the missed procedure from ortai db.
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)
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
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 :/
|
|
|
|
|
05/25/2015, 19:20
|
#11
|
elite*gold: 0
Join Date: Mar 2012
Posts: 679
Received Thanks: 29
|
good
|
|
|
|
|
10/24/2023, 01:16
|
#12
|
elite*gold: 0
Join Date: Oct 2023
Posts: 4
Received Thanks: 0
|
best game ever : SIarity
best start and good system
|
|
|
|
All times are GMT +1. The time now is 10:50.
|
|
