المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Full Release to add Rank Page in site


Yui
13-07-2013, 06:59 PM
Hello Silkroad4arab

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

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://im42.gulfup.com/fvFts.png

3-unique rank.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


http://im42.gulfup.com/qJ2Ck.png

Download link (http://www.mediafire.com/download/c41k7nxbr7bj115/Rank.rar)
Scan (https://www.virustotal.com/en/file/7...is/1373734441/)

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


Soon Donate Page

http://im42.gulfup.com/gzlsl.png

BomBom
13-07-2013, 10:21 PM
تمام

Yui
13-07-2013, 10:24 PM
تمام

Thanks
Notice : Add Dwonload link + scan

MyRȝturn
14-07-2013, 05:48 AM
تســـلمـ

Golden sro
14-07-2013, 07:36 AM
Good Jop

ღ♥ČrimeḾaster♥ღ
14-07-2013, 09:34 AM
تسلم ايدك :specool:

Mr.Viper
14-07-2013, 09:40 AM
تسلم يانجم :)

Mahmoud Rashwan
19-07-2013, 04:55 PM
تسلمـ فى تقدمـ مستمر ان شاءالله

Delaviga_
17-08-2013, 04:12 AM
ارجو الشرح وشكراا

elfr3on2010
17-08-2013, 04:24 PM
نسلم ايدك

Tammoz
18-08-2013, 08:24 PM
tammmmmmmmmmmmmmmmmm
:winksmiley02:

Last_Fiddler
23-08-2013, 11:21 PM
شكرا انتا بصراحه بتعمل شوغل عالى انا لسه راجع المنتدى بعد غياب طويل

هل ممكن تعملى شرح كيفية اعمل اسعار الايتم واضيف صورهم على الموقع ازاى

Mostafa Mosaad
24-08-2013, 03:15 PM
تسلمــ

[Slayer]
26-08-2013, 08:17 PM
في حاجة مش فاهمها اية دي اغير فيها حاجه ؟

$panel_db = "Panel"; // Panele أ–zel Db Name

nightmare200
29-08-2013, 08:28 PM
انا حططها في ملفات السايت ومشتغلتش ممكن اعرف من ايه ؟ وارجو انك تشغل لينك ملفات الموقع اللي انت رافعو

ScAry_MAN
29-08-2013, 09:50 PM
شغل عالى

ellemby20102010
30-08-2013, 11:37 AM
شكرا جاري التجربة

EXPLOSiVe
04-09-2013, 02:59 PM
يا جااااااااااااااااااامد

Tigger
13-05-2014, 11:13 AM
تسلمـ ايدكـ

Hamza FiGo
26-10-2014, 11:52 PM
Check this link something is missing i think

http://www.silkroad4arab.com/vb/showthread.php?t=570357 (http://www.silkroad4arab.com/vb/showthread.php?t=570357)

™Dev Microsoft™
03-11-2014, 04:58 AM
nice one Yui
:thumb_yello: