| MahMoudMeDo |
15-03-2016 03:09 PM |
Right way to add Unique rank page in site
http://www8.0zz0.com/2016/03/15/14/984618066.png
ازيكم يا رجالة
انا جايب لكم System مش عارف اذا كان اتعمل قبل كده ولا لا
بس انا دورت علية قبل ما اعمل الموضوع ملقتهوش
قولت اعمل بيه موضوع يمكن يفيد حد
Today will add too add Full Release Unique ranking page in your site
1-unique rank .sql
2-unique rank .program
3-unique rank.PHP
********************
1-Query to add table [dbo]. [Uniqueranking] in your 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
http://www8.0zz0.com/2016/03/15/14/374310687.png
Link Download
Here[SPOILER="http://www.mediafire.com/download/c41k7nxbr7bj115/Rank.rar"][/SPOILER]
********************
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
وي كده خلاصنا وي يا راب الموضع يعجبكو :soccer_h4h::soccer_h4h:
|
