• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook pagefor updates, or we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.)

Right way to add Unique rank page in site

Experienced Elementalist
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

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
adminsxza - Right way to add Unique rank page in site - RaGEZONE Forums


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

adminsxza - Right way to add Unique rank page in site - RaGEZONE Forums




PHP - Query SQL - (By : Yui4Host) i hope this Release help here


Soon Donate Page

adminsxza - Right way to add Unique rank page in site - RaGEZONE Forums

 
Last edited:
Extacy plýs !!!
Joined
Nov 27, 2007
Messages
356
Reaction score
46
SHA256: 746cba4de64cfa1d1ea2fa55726abf45630cce45de843cedd4b64fc25a650a41
File name: Rank.rar
Detection ratio: 1 / 47
Analysis date: 2013-07-13 16:54:01 UTC ( 0 minutes ago )




Looks clean :)

Thank you.


Works ... :)

but add more uniques to php :)
 
Last edited:
Experienced Elementalist
Joined
Jun 21, 2012
Messages
208
Reaction score
17
SHA256: 746cba4de64cfa1d1ea2fa55726abf45630cce45de843cedd4b64fc25a650a41
File name: Rank.rar
Detection ratio: 1 / 47
Analysis date: 2013-07-13 16:54:01 UTC ( 0 minutes ago )




Looks clean :)

Thank you.


Works ... :)

but add more uniques to php :)

thanks for scan :)
i will add all unique Soon
 
Newbie Spellweaver
Joined
Sep 17, 2013
Messages
8
Reaction score
0
I Make all Thing And now i have that unique rank page but when any one kill unique they not be writen! and im wait 24h and not write too! please any one here help me guyz
 
Newbie Spellweaver
Joined
Apr 27, 2014
Messages
15
Reaction score
0
Thx Yui I Will Add It To My Website But It Dont Work Auto. Please Help
 
Newbie Spellweaver
Joined
May 25, 2014
Messages
7
Reaction score
0
hello any body help about php how can I put it in my site
please some body help me
thank you
 
Back
Top