Kayıt Ol
[-]
monetization_on Reklam Alanı
Reklam vermek istiyorum?

Vsro FİX Like,Unlike, Comment Sistemi.


view_headline Konu
25.03.2016, Saat: 11:14
#1
Coded By Promaker
Coded By Promaker
Konuları:
19
Yorumları:
287
Kayıt Tarihi:
07.02.2016
Rep Puanı:
42
verified_user Global Mod
Vsro FİX Like,Unlike, Comment Sistemi.
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

14.02.2017, Saat: 02:36
#2
serseri81
serseri81
Konuları:
20
Yorumları:
81
Kayıt Tarihi:
16.05.2016
Rep Puanı:
0
verified_user Usta Üye
RE: Vsro FİX Like,Unlike, Comment Sistemi.
Guzel Bır Paylasım Ama Sahsen Ben Pek Anlayamadım K.bakmayın Orenmek ıstıyorum Neye Yarıyor Bu sıstem ??
Cevapla
17.04.2017, Saat: 08:09
#3
avatarsro
avatarsro
Konuları:
0
Yorumları:
4
Kayıt Tarihi:
16.04.2017
Rep Puanı:
0
verified_user Acemi Üye
RE: Vsro FİX Like,Unlike, Comment Sistemi.
not working error
Cevapla


Konu ile Alakalı Benzer Konular
Konular Yazar Yorumlar Okunma Son Yorum
  Vsro Görev ile İtem Verme Server Edit 12 1,949 21.06.2017, Saat: 23:44
Son Yorum: _OrdeaL_
Wink Vsro Eu Açma metehan463 1 96 18.06.2017, Saat: 14:57
Son Yorum: GeneralRed
  vSro Patch Atma - Versiyon Ayarlama [VİDEOLU] HistoricaL 14 504 16.06.2017, Saat: 12:07
Son Yorum: karambole
Brick vSro 11DG Nova Drop Ayarlama GeneralRed 3 169 16.06.2017, Saat: 03:37
Son Yorum: GeneralRed

Hızlı Menü:



[-]
monetization_on Reklam (728x90)
Reklam Ver
Reklam vermek istiyorum?