Skip to main content
Merhaba, Ziyaretçi!

Bizi ziyaret ettiğiniz için teşekkür ederiz!

Sitemizden daha iyi yararlanabilmek için "Giriş" yapmalı ya da "Kayıt" olmalısınız ;)

("vSro Forum - vSro Rehberi" ayrıcalıktır!)

vSro Forum - vSro Rehberi ve Paylaşımları
f8 filter
Sun World
Raymond

Konuyu Oyla:
  • Derecelendirme: 0/5 - 0 oy
  • 1
  • 2
  • 3
  • 4
  • 5

Vsro FİX Like,Unlike, Comment Sistemi.
Vsro FİX Like,Unlike, Comment Sistemi.
#1
Son Düzenleme: 25.03.2016, Saat: 20:06, Düzenleyen: PurePower.
Bu sistem tamamen editorlerimizin bakış açısına göre kullanabilecekleri bir sistemdir.
Kimine cok değersiz, kimine ise muhtesem fikirler sunabilir.
Çalışma mantığı şu şekildedir;
Karakterler özel mesaj kısmına Kullanıcı adı Like Mesaj kısmına Like yazdıklarında DB'deki _Facebook tablosuna kayıt yapar.
Buna göre sistemi geliştirmek sizlere kalmış.
Sistem FİX çalışmaktadır. Bütün forumlardan tek tek alıp düzenleyip sizlerle paylasıyorum Smile

SRO_VT_SHARD > Programability > Stored Prosedür > Addmemo prosedürünü açın ve as dan sonra yapıştırın:  
Alıntı: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_SHARD.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Likes = 'Like')
,@MaxDis int = (select COUNT(DisLike) from SRO_VT_SHARD.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and DisLike = 'Dislike')
,@Maxcom int = (select COUNT(Comment) from SRO_VT_SHARD.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_SHARD.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_SHARD.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_SHARD.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID,@SendID,@Message,'None','None',@TargetCharName,@SenderCharName)
                END   
                 END  
                  END 
     
    DECLARE @SI1D int = (SELECT charid FROM _Char where CharName16 = @SenderCharName)

SRO_VT_SHARD > Programability > Stored Prosedür > Addnewchar Prosedurü:

Kod:
_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)  
   -----------------------------------------------------------------------------

Facebook Tablosu oluşturma:

Kod:
USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_Facebook]    Script Date: 23.03.2016 08:58:33 ******/
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,
    [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

RefSkill:
Kod:
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

RefSkillGroup:
Kod:
1043    SKILL_FACEBOOK

Media
IDlerini RefSkille göre ayarlayın.
SkillDataEnc35000:

Kod:
1    37158    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    37159    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    37160    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

SkillEfect:
Kod:
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

TextDate_equip&skill:

Kod:
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.

indir


Cevapla
RE: Vsro FİX Like,Unlike, Comment Sistemi.
#2
Guzel Bır Paylasım Ama Sahsen Ben Pek Anlayamadım K.bakmayın Orenmek ıstıyorum Neye Yarıyor Bu sıstem ??
Cevapla
RE: Vsro FİX Like,Unlike, Comment Sistemi.
#3
not working error
Cevapla


Konu ile Alakalı Benzer Konular
Konular Yazar Yorumlar Okunma Son Yorum
  CS-Go Rank Sistemi VsroEdit 6 756 19.11.2017, Saat: 03:20
Son Yorum: Silkroad
  Model Switcher Sistemi VsroEdit 5 625 16.11.2017, Saat: 23:18
Son Yorum: sonerefe
  Vsro Npc Taşıma Server Edit 10 2,145 19.10.2017, Saat: 11:58
Son Yorum: BURAKSERIT - Killa
  Vsro Script Crypter samuray12 1 323 13.10.2017, Saat: 02:36
Son Yorum: BURAKSERIT - Killa

Hızlı Menü:


Konuyu Okuyanlar: 1 Ziyaretçi