PVP Server Tanıtımı - Knight Online, Metin2

Geri git   PVP Server Tanıtımı - Knight Online, Metin2 > PVP Server Paylaşım Forum > Web Dosyası Paylaşımları

Web Dosyası Paylaşımları KO Panel, PHP ve ASPX tabanlı panel, index ve web site taslak paylaşımları.

Yeni Konu aç  Cevapla
 
LinkBack Seçenekler Arama Stil
Alt 10 Nisan 2019, 03:15   #1
KO-DEVE.COM
 RoxiRox - ait Kullanıcı Resmi (Avatar)
 
Üyelik tarihi: 29 Mart 2019
Üye No: 1
Nerden: Zonguldak
Yaş: 28
Mesajlar: 162
Konular: 150
@RoxiRox
Cool PUS USKO v2 ORJINAL VE API SISTEMI



Merhaba arkadaşlar,

Pus şuan USKO'da kullanılan sistemi aynısıdır. Aspx tabanlı en büyük özelliği API Sistemi Sorunsuzdur. Source'si yoktur sadece pus dosyalarıdır. Lisans sistemi yoktur.Güle Güle Kullanın

İndirme Linki:
Gizli İçerik


Rar Pass: epvpserver.com

SQL Kodları:
HTML-Kodu:
-- --------------------------------------------------
-- Entity Designer DDL Script for SQL Server 2005, 2008, 2012 and Azure
-- --------------------------------------------------
-- Date Created: 07/03/2017 22:58:41
-- Generated from EDMX file: C:\Users\Serkan\Desktop\TestAp1i\PowerUpStore\Models\Model1.edmx
-- --------------------------------------------------

SET QUOTED_IDENTIFIER OFF;
GO
USE [KO_MAIN];
GO
IF SCHEMA_ID(N'dbo') IS NULL EXECUTE(N'CREATE SCHEMA [dbo]');
GO

-- --------------------------------------------------
-- Dropping existing FOREIGN KEY constraints
-- --------------------------------------------------


-- --------------------------------------------------
-- Dropping existing tables
-- --------------------------------------------------

IF OBJECT_ID(N'[dbo].[C_SERVER_INFO]', 'U') IS NOT NULL
    DROP TABLE [dbo].[C_SERVER_INFO];
GO
IF OBJECT_ID(N'[dbo].[PUS_BANNER]', 'U') IS NOT NULL
    DROP TABLE [dbo].[PUS_BANNER];
GO
IF OBJECT_ID(N'[dbo].[PUS_BASKET]', 'U') IS NOT NULL
    DROP TABLE [dbo].[PUS_BASKET];
GO
IF OBJECT_ID(N'[dbo].[PUS_BUYITEM]', 'U') IS NOT NULL
    DROP TABLE [dbo].[PUS_BUYITEM];
GO
IF OBJECT_ID(N'[dbo].[PUS_CASH]', 'U') IS NOT NULL
    DROP TABLE [dbo].[PUS_CASH];
GO
IF OBJECT_ID(N'[dbo].[PUS_ESN_CODE]', 'U') IS NOT NULL
    DROP TABLE [dbo].[PUS_ESN_CODE];
GO
IF OBJECT_ID(N'[dbo].[PUS_ITEMS]', 'U') IS NOT NULL
    DROP TABLE [dbo].[PUS_ITEMS];
GO
IF OBJECT_ID(N'[dbo].[PUS_LOG]', 'U') IS NOT NULL
    DROP TABLE [dbo].[PUS_LOG];
GO
IF OBJECT_ID(N'[dbo].[PUS_MENU]', 'U') IS NOT NULL
    DROP TABLE [dbo].[PUS_MENU];
GO
IF OBJECT_ID(N'[dbo].[PUS_SESSION]', 'U') IS NOT NULL
    DROP TABLE [dbo].[PUS_SESSION];
GO
IF OBJECT_ID(N'[dbo].[USERDATA]', 'U') IS NOT NULL
    DROP TABLE [dbo].[USERDATA];
GO
IF OBJECT_ID(N'[dbo].[WEB_ITEMMALL]', 'U') IS NOT NULL
    DROP TABLE [dbo].[WEB_ITEMMALL];
GO
IF OBJECT_ID(N'[KO_MAINModelStoreContainer].[ACCOUNT_CHAR]', 'U') IS NOT NULL
    DROP TABLE [KO_MAINModelStoreContainer].[ACCOUNT_CHAR];
GO
IF OBJECT_ID(N'[KO_MAINModelStoreContainer].[TB_USER]', 'U') IS NOT NULL
    DROP TABLE [KO_MAINModelStoreContainer].[TB_USER];
GO

-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------

-- Creating table 'PUS_BANNER'
CREATE TABLE [dbo].[PUS_BANNER] (
    [ID] int IDENTITY(1,1) NOT NULL,
    [BannerImage] varchar(500)  NOT NULL
);
GO

-- Creating table 'PUS_BASKET'
CREATE TABLE [dbo].[PUS_BASKET] (
    [basket_id] int IDENTITY(1,1) NOT NULL,
    [baket_sessionid] varchar(250)  NOT NULL,
    [ItemID] int  NOT NULL,
    [ItemCount] smallint  NOT NULL,
    [InDate] datetime  NOT NULL
);
GO

-- Creating table 'PUS_BUYITEM'
CREATE TABLE [dbo].[PUS_BUYITEM] (
    [ID] int IDENTITY(1,1) NOT NULL,
    [ItemID] int  NOT NULL,
    [sCount] smallint  NOT NULL,
    [strNote] varchar(350)  NOT NULL,
    [bComplate] tinyint  NOT NULL
);
GO

-- Creating table 'PUS_CASH'
CREATE TABLE [dbo].[PUS_CASH] (
    [cashid] int IDENTITY(1,1) NOT NULL,
    [Total] int  NOT NULL,
    [Cash] int  NOT NULL,
    [Aciklama] varchar(150)  NOT NULL,
    [PID] int  NOT NULL
);
GO

-- Creating table 'PUS_ESN_CODE'
CREATE TABLE [dbo].[PUS_ESN_CODE] (
    [id] int IDENTITY(1,1) NOT NULL,
    [Serial1] varchar(4)  NOT NULL,
    [Serial2] varchar(4)  NOT NULL,
    [Serial3] varchar(4)  NOT NULL,
    [Serial4] varchar(4)  NOT NULL,
    [ByUsed] int  NOT NULL,
    [CashPoint] int  NOT NULL,
    [BonusCashPoint] int  NOT NULL
);
GO

-- Creating table 'PUS_ITEMS'
CREATE TABLE [dbo].[PUS_ITEMS] (
    [ID] int IDENTITY(1,1) NOT NULL,
    [ItemID] int  NOT NULL,
    [strItemName] varchar(150)  NULL,
    [strItemTitle] varchar(1000)  NULL,
    [Price] int  NULL,
    [DcPrice] int  NULL,
    [Image] varchar(150)  NULL,
    [SendType] int  NULL,
    [ItemType] int  NULL,
    [BuyCount] int  NOT NULL,
    [BannerImage] varchar(150)  NULL,
    [strItemDesc] varchar(1000)  NOT NULL,
    [ExpirationTime] int  NOT NULL
);
GO

-- Creating table 'PUS_LOG'
CREATE TABLE [dbo].[PUS_LOG] (
    [ID] int IDENTITY(1,1) NOT NULL,
    [Progress_Type] tinyint  NULL,
    [Session_ID] varchar(350)  NOT NULL,
    [Old_CashPoint] int  NULL,
    [Old_BonusCash] int  NULL,
    [New_CashPoint] int  NULL,
    [New_BonusCashPoint] int  NULL,
    [Item_ID] int  NULL,
    [Progress_Result] int  NULL,
    [Progress_Date] datetime  NOT NULL
);
GO

-- Creating table 'PUS_MENU'
CREATE TABLE [dbo].[PUS_MENU] (
    [id] int  NOT NULL,
    [strID] varchar(50)  NULL,
    [strMenuType] varchar(50)  NULL
);
GO

-- Creating table 'PUS_SESSION'
CREATE TABLE [dbo].[PUS_SESSION] (
    [strAccountID] varchar(50)  NULL,
    [strUserID] varchar(50)  NULL,
    [strClass] varchar(50)  NULL,
    [strLevel] varchar(50)  NULL,
    [strParam] varchar(350)  NULL,
    [strData] datetime  NULL,
    [id] int IDENTITY(1,1) NOT NULL
);
GO

-- Creating table 'C_SERVER_INFO'
CREATE TABLE [dbo].[C_SERVER_INFO] (
    [nServerIndex] int  NOT NULL,
    [nServerIp] varchar(50)  NULL,
    [strServerName] varchar(50)  NULL
);
GO

-- Creating table 'USERDATA'
CREATE TABLE [dbo].[USERDATA] (
    [strUserID] char(21)  NOT NULL,
    [Nation] tinyint  NOT NULL,
    [Race] tinyint  NOT NULL,
    [Class] smallint  NOT NULL,
    [HairRGB] int  NOT NULL,
    [Rank] tinyint  NOT NULL,
    [Title] tinyint  NOT NULL,
    [Level] tinyint  NOT NULL,
    [Exp] bigint  NOT NULL,
    [Loyalty] int  NOT NULL,
    [Face] tinyint  NOT NULL,
    [City] tinyint  NOT NULL,
    [Knights] smallint  NOT NULL,
    [Fame] tinyint  NOT NULL,
    [Hp] smallint  NOT NULL,
    [Mp] smallint  NOT NULL,
    [Sp] smallint  NOT NULL,
    [Strong] tinyint  NOT NULL,
    [Sta] tinyint  NOT NULL,
    [Dex] tinyint  NOT NULL,
    [Intel] tinyint  NOT NULL,
    [Cha] tinyint  NOT NULL,
    [Authority] tinyint  NOT NULL,
    [Points] smallint  NOT NULL,
    [Gold] int  NOT NULL,
    [Zone] tinyint  NOT NULL,
    [Bind] smallint  NULL,
    [PX] int  NOT NULL,
    [PZ] int  NOT NULL,
    [PY] int  NOT NULL,
    [dwTime] int  NOT NULL,
    [strSkill] varchar(10)  NULL,
    [strItem] binary(592)  NULL,
    [strSerial] binary(592)  NULL,
    [strUserSeal] binary(269)  NULL,
    [strItemTime] binary(296)  NULL,
    [sQuestCount] smallint  NOT NULL,
    [strQuest] binary(3888)  NULL,
    [sQuestDataCount] smallint  NOT NULL,
    [strQuestData] binary(1296)  NULL,
    [MannerPoint] int  NOT NULL,
    [LoyaltyMonthly] int  NOT NULL,
    [iSavedCONT] int  NOT NULL,
    [dtCreateTime] datetime  NOT NULL,
    [dtUpdateTime] datetime  NULL,
    [CSWFreeLoyaltyUpdateTime] datetime  NULL,
    [strMemo] char(21)  NULL,
    [sGenieTime] smallint  NOT NULL,
    [strGenieOptions] char(100)  NULL
);
GO

-- Creating table 'ACCOUNT_CHAR'
CREATE TABLE [dbo].[ACCOUNT_CHAR] (
    [strAccountID] char(21)  NOT NULL,
    [bNation] tinyint  NOT NULL,
    [bCharNum] tinyint  NOT NULL,
    [strCharID1] char(21)  NULL,
    [strCharID2] char(21)  NULL,
    [strCharID3] char(21)  NULL,
    [strCharID4] char(21)  NULL
);
GO

-- Creating table 'TB_USER'
CREATE TABLE [dbo].[TB_USER] (
    [ID] int IDENTITY(1,1) NOT NULL,
    [strAccountID] varchar(21)  NOT NULL,
    [strPasswd] varchar(28)  NULL,
    [strSealPasswd] char(8)  NOT NULL,
    [strClientIP] char(15)  NULL,
    [bPremiumType] tinyint  NOT NULL,
    [dtPremiumTime] datetime  NULL,
    [sHours] smallint  NOT NULL,
    [dtCreateTime] datetime  NULL,
    [CashPoint] int  NULL,
     varchar(50)  NULL,
    [SecurityAnswer] varchar(50)  NULL,
    [SecurityQuestion] varchar(50)  NULL,
    [strAuthority] tinyint  NULL,
    [UserName] varchar(50)  NULL,
    [UserSurname] varchar(50)  NULL,
    [BonusCashPoint] int  NULL,
    [Privatekey] varchar(350)  NULL,
    [Referencekey] varchar(350)  NULL,
    [GiveReferenceVal] bit  NOT NULL,
    [KraftAdmin] int  NULL,
    [strPremiumData] binary(350)  NOT NULL,
    [strPhoneNumber] char(10)  NULL,
    [Access] varchar(50)  NULL
);
GO

-- Creating table 'WEB_ITEMMALL'
CREATE TABLE [dbo].[WEB_ITEMMALL] (
    [ID] int IDENTITY(1,1) NOT NULL,
    [strAccountID] char(21)  NOT NULL,
    [strCharID] char(21)  NOT NULL,
    [ServerNo] smallint  NOT NULL,
    [ItemID] int  NOT NULL,
    [ItemCount] smallint  NOT NULL,
    [BuyTime] datetime  NOT NULL,
    [img_file_name] varchar(50)  NULL,
    [strItemName] varchar(100)  NULL,
    [price] int  NULL,
    [pay_type] int  NULL,
    [itemtime] int  NOT NULL
);
GO

-- --------------------------------------------------
-- Creating all PRIMARY KEY constraints
-- --------------------------------------------------

-- Creating primary key on [ID] in table 'PUS_BANNER'
ALTER TABLE [dbo].[PUS_BANNER]
ADD CONSTRAINT [PK_PUS_BANNER]
    PRIMARY KEY CLUSTERED ([ID] ASC);
GO

-- Creating primary key on [basket_id] in table 'PUS_BASKET'
ALTER TABLE [dbo].[PUS_BASKET]
ADD CONSTRAINT [PK_PUS_BASKET]
    PRIMARY KEY CLUSTERED ([basket_id] ASC);
GO

-- Creating primary key on [ID] in table 'PUS_BUYITEM'
ALTER TABLE [dbo].[PUS_BUYITEM]
ADD CONSTRAINT [PK_PUS_BUYITEM]
    PRIMARY KEY CLUSTERED ([ID] ASC);
GO

-- Creating primary key on [cashid] in table 'PUS_CASH'
ALTER TABLE [dbo].[PUS_CASH]
ADD CONSTRAINT [PK_PUS_CASH]
    PRIMARY KEY CLUSTERED ([cashid] ASC);
GO

-- Creating primary key on [id] in table 'PUS_ESN_CODE'
ALTER TABLE [dbo].[PUS_ESN_CODE]
ADD CONSTRAINT [PK_PUS_ESN_CODE]
    PRIMARY KEY CLUSTERED ([id] ASC);
GO

-- Creating primary key on [ID], [ItemID], [BuyCount] in table 'PUS_ITEMS'
ALTER TABLE [dbo].[PUS_ITEMS]
ADD CONSTRAINT [PK_PUS_ITEMS]
    PRIMARY KEY CLUSTERED ([ID], [ItemID], [BuyCount] ASC);
GO

-- Creating primary key on [ID] in table 'PUS_LOG'
ALTER TABLE [dbo].[PUS_LOG]
ADD CONSTRAINT [PK_PUS_LOG]
    PRIMARY KEY CLUSTERED ([ID] ASC);
GO

-- Creating primary key on [id] in table 'PUS_MENU'
ALTER TABLE [dbo].[PUS_MENU]
ADD CONSTRAINT [PK_PUS_MENU]
    PRIMARY KEY CLUSTERED ([id] ASC);
GO

-- Creating primary key on [id] in table 'PUS_SESSION'
ALTER TABLE [dbo].[PUS_SESSION]
ADD CONSTRAINT [PK_PUS_SESSION]
    PRIMARY KEY CLUSTERED ([id] ASC);
GO

-- Creating primary key on [nServerIndex] in table 'C_SERVER_INFO'
ALTER TABLE [dbo].[C_SERVER_INFO]
ADD CONSTRAINT [PK_C_SERVER_INFO]
    PRIMARY KEY CLUSTERED ([nServerIndex] ASC);
GO

-- Creating primary key on [strUserID] in table 'USERDATA'
ALTER TABLE [dbo].[USERDATA]
ADD CONSTRAINT [PK_USERDATA]
    PRIMARY KEY CLUSTERED ([strUserID] ASC);
GO

-- Creating primary key on [strAccountID], [bNation], [bCharNum] in table 'ACCOUNT_CHAR'
ALTER TABLE [dbo].[ACCOUNT_CHAR]
ADD CONSTRAINT [PK_ACCOUNT_CHAR]
    PRIMARY KEY CLUSTERED ([strAccountID], [bNation], [bCharNum] ASC);
GO

-- Creating primary key on [ID], [strAccountID], [strSealPasswd], [bPremiumType], [sHours], [GiveReferenceVal], [strPremiumData] in table 'TB_USER'
ALTER TABLE [dbo].[TB_USER]
ADD CONSTRAINT [PK_TB_USER]
    PRIMARY KEY CLUSTERED ([ID], [strAccountID], [strSealPasswd], [bPremiumType], [sHours], [GiveReferenceVal], [strPremiumData] ASC);
GO

-- Creating primary key on [ID] in table 'WEB_ITEMMALL'
ALTER TABLE [dbo].[WEB_ITEMMALL]
ADD CONSTRAINT [PK_WEB_ITEMMALL]
    PRIMARY KEY CLUSTERED ([ID] ASC);
GO

-- --------------------------------------------------
-- Creating all FOREIGN KEY constraints
-- --------------------------------------------------

-- --------------------------------------------------
-- Script has ended
-- --------------------------------------------------


__________________

RoxiRox isimli Üye şimdilik offline konumundadır  
Alıntı ile Cevapla
Alt 10 Ekim 2020, 00:41   #2
Yeni Deve Üye
 Metin22 - ait Kullanıcı Resmi (Avatar)
 
Üyelik tarihi: 10 Ekim 2020
Üye No: 198
Nerden: Ankara
Yaş: 40
Mesajlar: 9
Konular: 0
@Metin22
Standart

tesekkurler

Metin22 isimli Üye şimdilik offline konumundadır  
Alıntı ile Cevapla
Cevapla

Tag Ekle
api, orjinal, pus, sistemi, usko


Konuyu Toplam 1 Üye okuyor. (0 Kayıtlı üye ve 1 Misafir)
 
Seçenekler Arama
Stil

Yetkileriniz
Sizin Yeni Konu Acma Yetkiniz var yok
You may not post replies
You may not post attachments
You may not edit your posts

BB code is Açık
Smileler Açık
[IMG] Kodları Açık
HTML-KodlarıKapalı
Trackbacks are Açık
Pingbacks are Açık
Refbacks are Açık


Forum Site Hakkında
vBulletin® tarafından desteklenmektedir Versiyon 3.8.9
Telif hakkı ©2000 - 2019, Jelsoft Enterprises Ltd.

Sitemizdeki içerikler kopyalanmaya karşı DMCA ile korunmaktadır. DMCA.com Protection Status
İçerik sağlayıcı paylaşım sitelerinden biri olan ko-deve.com Forum Adresimizde T.C.K 20.ci Madde ve 5651 Sayılı Kanun'un 4.cü maddesinin (2).ci fıkrasına göre TÜM ÜYELERİMİZ yaptıkları paylaşımlardan sorumludur. ko-deve.com hakkında yapılacak tüm hukuksal Şikayetler için iletisim@ko-deve.com Mail adresimiz üzerinden iletişime geçilmesi halinde ilgili kanunlar ve yönetmelikler çerçevesinde en geç 1 (Bir) Hafta içerisinde ko-deve.com yönetimi olarak tarafımızdan gereken işlemler yapılacak ve Avukatımız size dönüş yapacaktır.
© 2018 RoxiRox ( by ko-deve.com 2018/2019 )