- Joined
- Jun 21, 2012
- Messages
- 208
- Reaction score
- 17
Hello Ragezone
Today will add Full Release too add Unique ranking page in your site
1-unique rank .sql
2-unique rank .programl
3-unique rank.PHP
Today will add Full Release too add Unique ranking page in your site
1-unique rank .sql
2-unique rank .programl
3-unique rank.PHP
1-Query to add table [dbo].[UniqueRanking]in you data
PHP:
USE [SRO_VT_SHARD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UniqueRanking](
[CharName] [text] NOT NULL,
[Score] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_Score] DEFAULT ((0)),
[MOB_JUPITER_THE_EARTH1] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_THE_EARTH1] DEFAULT ((0)),
[MOB_RM_TAHOMET] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_RM_TAHOMET] DEFAULT ((0)),
[MOB_KK_ISYUTARU] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_KK_ISYUTARU] DEFAULT ((0)),
[MOB_CH_TIGERWOMAN] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_CH_TIGERWOMAN] DEFAULT ((0)),
[MOB_AM_IVY_L3] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_AM_IVY_L3] DEFAULT ((0)),
[MOB_EU_KERBEROS] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_EU_KERBEROS] DEFAULT ((0)),
[MOB_AM_IVY] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_AM_IVY] DEFAULT ((0)),
[MOB_OA_URUCHI_L3] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_OA_URUCHI_L3] DEFAULT ((0)),
[MOB_OA_URUCHI] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_OA_URUCHI] DEFAULT ((0)),
[MOB_JUPITER_JUPITER] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_JUPITER] DEFAULT ((0)),
[MOB_JUPITER_YUNO] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_YUNO] DEFAULT ((0)),
[MOB_TK_BONELORD] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_TK_BONELORD] DEFAULT ((0)),
[MOB_RM_TAHOMET_L3] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_RM_TAHOMET_L3] DEFAULT ((0)),
[MOB_EV_WINTER_WHITEKNIGHT_20] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_20] DEFAULT ((0)),
[MOB_JUPITER_BABILION] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_BABILION] DEFAULT ((0)),
[MOB_JUPITER_DARK_DOG] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_DARK_DOG] DEFAULT ((0)),
[MOB_FW_MUJIGI_120] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_120] DEFAULT ((0)),
[MOB_EU_KERBEROS_L3] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_EU_KERBEROS_L3] DEFAULT ((0)),
[MOB_CH_TIGERWOMAN_L3] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_CH_TIGERWOMAN_L3] DEFAULT ((0)),
[MOB_KK_ISYUTARU_L3] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_KK_ISYUTARU_L3] DEFAULT ((0)),
[MOB_TK_BONELORD_L3] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_TK_BONELORD_L3] DEFAULT ((0)),
[MOB_FW_MUJIGI_135] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_135] DEFAULT ((0)),
[MOB_TQ_BLACKSNAKE_L3] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_TQ_BLACKSNAKE_L3] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_140] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_140] DEFAULT ((0)),
[MOB_FW_TAESE_045] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_045] DEFAULT ((0)),
[MOB_FW_TAESE_120] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_120] DEFAULT ((0)),
[MOB_FW_TAESE_110] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_110] DEFAULT ((0)),
[MOB_EV_WINTER_PRINCESS_100] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_PRINCESS_100] DEFAULT ((0)),
[MOB_FW_TAESE_001] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_001] DEFAULT ((0)),
[MOB_SD_NEITH] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_SD_NEITH] DEFAULT ((0)),
[MOB_SD_ISIS] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_SD_ISIS] DEFAULT ((0)),
[MOB_TQ_WHITESNAKE] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_TQ_WHITESNAKE] DEFAULT ((0)),
[MOB_FW_TAESE_135] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_135] DEFAULT ((0)),
[MOB_SD_SELKIS] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_SD_SELKIS] DEFAULT ((0)),
[MOB_EV_WINTER_WHITEKNIGHT_100] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_100] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_040] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_040] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_120] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_120] DEFAULT ((0)),
[MOB_FW_TAESE_130] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_130] DEFAULT ((0)),
[MOB_FW_TAESE_040] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_040] DEFAULT ((0)),
[MOB_FW_TAESE_140] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_140] DEFAULT ((0)),
[MOB_FW_TAESE_020] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_020] DEFAULT ((0)),
[MOB_RM_SPIRITS_CLON] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS_CLON] DEFAULT ((0)),
[MOB_EV_WINTER_WHITEKNIGHT_80] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_80] DEFAULT ((0)),
[MOB_FW_TAESE_111] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_111] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_020] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_020] DEFAULT ((0)),
[MOB_FW_TAESE_005] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_005] DEFAULT ((0)),
[MOB_FW_MUJIGI_130] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_130] DEFAULT ((0)),
[MOB_FW_TAESE_003] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_003] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_100] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_100] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_108] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_108] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_109] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_109] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_104] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_104] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_105] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_105] DEFAULT ((0)),
[MOB_FW_TAESE_010] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_010] DEFAULT ((0)),
[MOB_FW_MUJIGI_010] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_010] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_130] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_130] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_041] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_041] DEFAULT ((0)),
[MOB_EV_WINTER_PRINCESS_20] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_PRINCESS_20] DEFAULT ((0)),
[MOB_FW_TAESE_041] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_041] DEFAULT ((0)),
[MOB_FW_HYEONGCHEON_103] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_103] DEFAULT ((0)),
[MOB_FW_TAESE_065] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_065] DEFAULT ((0)),
[MOB_FW_TAESE_077] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_077] DEFAULT ((0)),
[MOB_FW_TAESE_102] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_102] DEFAULT ((0)),
[MOB_FW_TAESE_103] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_103] DEFAULT ((0)),
[MOB_FW_TAESE_100] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_100] DEFAULT ((0)),
[MOB_FW_MUJIGI_005] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_005] DEFAULT ((0)),
[MOB_FW_TAESE_105] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_105] DEFAULT ((0)),
[MOB_FW_TAESE_080] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_080] DEFAULT ((0)),
[MOB_RM_SPIRITS_CLON3] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS_CLON3] DEFAULT ((0)),
[MOB_RM_SPIRITS_CLON2] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS_CLON2] DEFAULT ((0)),
[MOB_RM_SPIRITS] [int] NOT NULL CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
2-unique rank .program to record all unique killer
3-unique rank.PHP
PHP:
// Mssql config
$sqlname = "WA7D-PC\SQLEXPRESS"; // Sql Name
$sqlid = "sa"; // Db User
$sqlpass = "2558231a"; // Db Password
$acc_db = "SRO_VT_ACCOUNT"; // Acc Db Name
$shard_db = "SRO_VT_SHARD"; // Shard Db Name
$panel_db = "Panel"; // Panele Özel Db Name
$baglan = @mssql_connect($sqlname, $sqlid, $sqlpass) or die("Panel Suan Bakimdadir.1.");
$mlkbaglan = @mssql_select_db($acc_db, $baglan) or die("Panel Suan Bakimdadir.2.");
// Mssql config
You must be registered to see links
You must be registered to see links
PHP - Query SQL - (By : Yui4Host) i hope this Release help here
Soon Donate Page
Last edited: