2015 Sorunsuz Power UP STORE (SQL + FİLES)

'Kurallara Aykırı Konular' forumunda APLaceFormyHeaD tarafından 17 Temmuz 2015 tarihinde açılan konu

  1. APLaceFormyHeaD

    APLaceFormyHeaD New Member

    [​IMG]



    [​IMG]



    [​IMG]











    [HIDE]Merhabalar arşivimde mevcuttu sorunsuz çalışır ESN Tablosu mevcut değil uyarlarsanız sorunsuz çalışır.





    DOWNLOAD LINK : http://trlink.in/9624





    SQL CODE



    Kod:
    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_PUS_ITEMLERI_PUS_ITEMLERI_PAKET]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
    
    ALTER TABLE [dbo].[PUS_ITEMLERI] DROP CONSTRAINT FK_PUS_ITEMLERI_PUS_ITEMLERI_PAKET
    
    GO
    
    
    
    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PUS_CASH]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
    drop table [dbo].[PUS_CASH]
    
    GO
    
    
    
    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PUS_ITEMLERI]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
    drop table [dbo].[PUS_ITEMLERI]
    
    GO
    
    
    
    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PUS_ITEMLERI_PAKET]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
    drop table [dbo].[PUS_ITEMLERI_PAKET]
    
    GO
    
    
    
    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PUS_PAYPAL_LOG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
    drop table [dbo].[PUS_PAYPAL_LOG]
    
    GO
    
    
    
    CREATE TABLE [dbo].[PUS_CASH] (
    
        [cashid] [int] IDENTITY (1, 1) NOT NULL ,
    
        [Total] [int] NOT NULL ,
    
        [Cash] [int] NOT NULL ,
    
        [Aciklama] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    
        [PID] [int] NOT NULL
    
    ) ON [PRIMARY]
    
    GO
    
    
    
    CREATE TABLE [dbo].[PUS_ITEMLERI] (
    
        [id] [int] IDENTITY (1, 1) NOT NULL ,
    
        [PID] [int] NULL ,
    
        [ExtraItem] [bit] NOT NULL ,
    
        [ItemIsmi] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [ItemResmi] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [itemkodu] [int] NOT NULL ,
    
        [adet] [int] NOT NULL ,
    
        [ucret] [int] NULL ,
    
        [type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [alindi] [int] NOT NULL ,
    
        [aciklama] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [islev] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [sure] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [kullanim] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [kosul] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [reqtitle] [tinyint] NOT NULL ,
    
        [ItemVer] [bit] NOT NULL ,
    
        [KomutCalistir] [bit] NOT NULL ,
    
        [Komut] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    
    ) ON [PRIMARY]
    
    GO
    
    
    
    CREATE TABLE [dbo].[PUS_ITEMLERI_PAKET] (
    
        [PID] [int] IDENTITY (1, 1) NOT NULL ,
    
        [PItem1] [int] NOT NULL ,
    
        [Adet1] [int] NOT NULL ,
    
        [PItem2] [int] NOT NULL ,
    
        [Adet2] [int] NOT NULL ,
    
        [PItem3] [int] NOT NULL ,
    
        [Adet3] [int] NOT NULL ,
    
        [PItem4] [int] NOT NULL ,
    
        [Adet4] [int] NOT NULL ,
    
        [PItem5] [int] NOT NULL ,
    
        [Adet5] [int] NOT NULL
    
    ) ON [PRIMARY]
    
    GO
    
    
    
    CREATE TABLE [dbo].[PUS_PAYPAL_LOG] (
    
        [strAccountID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [strUserID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [token] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [cashID] [int] NULL ,
    
        [eskiCash] [int] NULL ,
    
        [yeniCash] [int] NULL ,
    
        [tutar] [int] NULL
    
    ) ON [PRIMARY]
    
    GO
    
    
    
    ALTER TABLE [dbo].[PUS_CASH] WITH NOCHECK ADD
    
        CONSTRAINT [PK_PUS_CASH] PRIMARY KEY  CLUSTERED
    
        (
    
            [cashid]
    
        )  ON [PRIMARY]
    
    GO
    
    
    
    ALTER TABLE [dbo].[PUS_ITEMLERI] WITH NOCHECK ADD
    
        CONSTRAINT [PK_PUS_ITEMLERI] PRIMARY KEY  CLUSTERED
    
        (
    
            [id]
    
        )  ON [PRIMARY]
    
    GO
    
    
    
    ALTER TABLE [dbo].[PUS_ITEMLERI_PAKET] WITH NOCHECK ADD
    
        CONSTRAINT [PK_PUS_ITEMLERI_PAKET] PRIMARY KEY  CLUSTERED
    
        (
    
            [PID]
    
        )  ON [PRIMARY]
    
    GO
    
    
    
    ALTER TABLE [dbo].[PUS_CASH] ADD
    
        CONSTRAINT [DF_PUS_CASH_Total] DEFAULT (0) FOR [Total],
    
        CONSTRAINT [DF_PUS_CASH_Cash] DEFAULT (0) FOR [Cash],
    
        CONSTRAINT [DF_PUS_CASH_PID] DEFAULT (0) FOR [PID]
    
    GO
    
    
    
    ALTER TABLE [dbo].[PUS_ITEMLERI] ADD
    
        CONSTRAINT [DF_PUS_ITEMLERI_ExtraItem] DEFAULT (0) FOR [ExtraItem],
    
        CONSTRAINT [DF_PUS_ITEMLERI_adet] DEFAULT (1) FOR [adet],
    
        CONSTRAINT [DF_PUS_ITEMLERI_alindi] DEFAULT (0) FOR [alindi],
    
        CONSTRAINT [DF_PUS_ITEMLERI_reqtitle] DEFAULT (0) FOR [reqtitle],
    
        CONSTRAINT [DF_PUS_ITEMLERI_ItemVer] DEFAULT (1) FOR [ItemVer],
    
        CONSTRAINT [DF_PUS_ITEMLERI_KomutCalistir] DEFAULT (0) FOR [KomutCalistir]
    
    GO
    
    
    
    ALTER TABLE [dbo].[PUS_ITEMLERI_PAKET] ADD
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item1] DEFAULT (0) FOR [PItem1],
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet1] DEFAULT (0) FOR [Adet1],
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item2] DEFAULT (0) FOR [PItem2],
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet2] DEFAULT (0) FOR [Adet2],
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item3] DEFAULT (0) FOR [PItem3],
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet3] DEFAULT (0) FOR [Adet3],
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item4] DEFAULT (0) FOR [PItem4],
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet5] DEFAULT (0) FOR [Adet4],
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Item5] DEFAULT (0) FOR [PItem5],
    
        CONSTRAINT [DF_PUS_ITEMLERI_PAKET_Adet5_1] DEFAULT (0) FOR [Adet5]
    
    GO
    
    
    
    ALTER TABLE [dbo].[PUS_ITEMLERI] ADD
    
        CONSTRAINT [FK_PUS_ITEMLERI_PUS_ITEMLERI_PAKET] FOREIGN KEY
    
        (
    
            [PID]
    
        ) REFERENCES [dbo].[PUS_ITEMLERI_PAKET] (
    
            [PID]
    
        )
    
    GO
    
    
    
    
    
    
    
    
    
    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WEB_ITEMMALL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
    drop table [dbo].[WEB_ITEMMALL]
    
    GO
    
    
    
    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WEB_ITEMMALL_LOG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
    
    drop table [dbo].[WEB_ITEMMALL_LOG]
    
    GO
    
    
    
    CREATE TABLE [dbo].[WEB_ITEMMALL] (
    
        [strAccountID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    
        [strCharID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    
        [ServerNo] [smallint] NOT NULL ,
    
        [ItemID] [int] NOT NULL ,
    
        [ItemCount] [smallint] NOT NULL ,
    
        [BuyTime] [smalldatetime] NOT NULL ,
    
        [img_file_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [strItemName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [price] [int] NULL ,
    
        [pay_type] [int] NULL
    
    ) ON [PRIMARY]
    
    GO
    
    
    
    CREATE TABLE [dbo].[WEB_ITEMMALL_LOG] (
    
        [strAccountID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    
        [strCharID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    
        [ServerNo] [smallint] NOT NULL ,
    
        [ItemID] [int] NOT NULL ,
    
        [ItemCount] [smallint] NOT NULL ,
    
        [BuyTime] [smalldatetime] NOT NULL ,
    
        [img_file_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [strItemName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    
        [price] [int] NULL ,
    
        [pay_type] [int] NULL
    
    ) ON [PRIMARY]
    
    GO
    
    
    
    
    
    


    TB USER EKLENECEK



    Kod:
    ALTER TABLE TB_USER
    
    ADD CashPoint int,
    
    Sepet varchar(250),
    
    PusAdmin tinyint not null default 0
    [/HIDE]​



    rar pass : kfsamet
     
  2. KertenKelebek

    KertenKelebek New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    teşekkürlerrr
     
  3. Kutsal

    Kutsal New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    deneyelim
     
  4. lejoner21

    lejoner21 New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    saol bakalım
     
  5. CrueeL

    CrueeL New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    Teşekkürler
     
  6. KirHaR

    KirHaR New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    bakalim neymiş şimdiden teşekürler
     
  7. yawruaslan

    yawruaslan New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    teşekkürler
     
  8. hoobstank

    hoobstank New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    teşekkürler
     
  9. Cripton

    Cripton New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    sağol akdeş
     
  10. Sefa1992

    Sefa1992 New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    asdasdasdsa
     
  11. hyuga1299

    hyuga1299 New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    paylaşılan avcı pus bu ne fark var bu dosyalarda ?
     
  12. ProGameRs

    ProGameRs New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    Çok teşekkürler.
     
  13. wanted585

    wanted585 New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    ++++++++++++++++++++++++
     
  14. badginga5

    badginga5 New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    Teşekkürler
     
  15. huber98741

    huber98741 New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    teşekkürler
     
  16. APLaceFormyHeaD

    APLaceFormyHeaD New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)





    dosyalar derlenmiş olup itemlere açıklama eklenmiş gayet stabil çalışıyor açık yok kendi kullandığım pus
     
  17. CHROME

    CHROME New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    Teşekkürler.
     
  18. POWER

    POWER New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    teşekkürler
     
  19. sunucumweb

    sunucumweb New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    teşekkürler bakalim
     
  20. HomekoGame

    HomekoGame New Member

    Cevap: 2015 Sorunsuz Power UP STORE (SQL + FİLES)



    wwwwwwwwwwwwwwwwwwwww
     

Bu Sayfayı Paylaş