| JanGanSRO |
03-05-2013 10:52 AM |
عودة JanGanSRO ~~ Unique Killer like rev6 & Unique Killer Rank
السلام عليكم
انا بقالى كتير معملتش اى مواضيع هنا
النهاردة جايبلكم برنامج
لقاتل اليونيكات و تتسجل فى نفس اللحظة
و
رانك اليونيك و دى بتتحسب بالنقط
اولا قبل اى حاجة
البرنامج دة بيشتغل مع قواعد البيانات
و نا لسه مشغلتهوش على الموقع عندى
معنى كلامى
ان البرنامج دة حاليا حيفيدك فى انك تعرف الرانك من خلال الجى ام فقط
لان الجى ام هو الوحيد الى حقدر يدخل على قواعد البيانات و يشوف البيانات اللى فيها
و ان شاء الله
لما حعمل الصفحات الخاصه بيهم على الموقع بحيث ان البيانات اللى متسجله فى الجداول
تظهر على الموقع
حبقى ارفعهالكم هى كمان
نبدأ
----
http://www11.0zz0.com/2013/05/03/07/284543663.png
دى ملفات البرنامج
نبدأ من اول ملف على اليمين
Unique_Config
http://www11.0zz0.com/2013/05/03/07/809112601.png
هنا حتحط بيانات اللى مطلوبه منك
اسم سيرفر قواعد البيانات
يوزر نيم قواعد البيانات
باسوورد قواعد البيانات
اسم قاعده البيانات sro_vt_shard
----------------------
الملف التانى
install.sql
دة استعلام فى قواعد البيانات لازم تعملو فى قواعد البيانات بتاعتك
بينشىء الجدول الخاص
بتسجيل الى قتل اليونيك فى نفس اللحظةو هو دة المسئول عن بيانات اللاعبين اللى بيموتو اليونكات زى موقع ريف 6 كدة
--------------------------
الملف الثالث
unique score
خليه زى ما هو كدة
----------------------
الملف الرابع
و هو البرنامج نفسو و دة بتشغلو مع ملفات السيرفر زى ما بتشغل اى برنامج من برامج فتح السيرفر
http://www11.0zz0.com/2013/05/03/07/591865687.png
حتفتح البرنامج كدة زى ما هو
حتعدل على البيانات اللى على الشمال
و فوق حتلاقى اختيارات
اظبط الاختيارات زى ما انا عامل كدة بالظبط
حتعمل فولدر بالاسم دة evalog و تحطو فى السيرفر فايلز فى نفس المسار دة كدة
serverfiles/evalog/
و متنساش تنفذ الاوامر دى فى قواعد البيانات
نفذ الامر دة علشان يعمل الجدول الخاص بالرانك اللى مربوط بالبرنامج
كود PHP:
USE [SHARD_HEAVY_TO]
GO
/****** Object: Table [dbo].[UniqueRanking] Script Date: 08/28/2014 13:17:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[UniqueRanking](
[CharName] [varchar](128) NOT NULL,
[Score] [int] NOT NULL,
[MOB_JUPITER_THE_EARTH1] [int] NOT NULL,
[MOB_RM_TAHOMET] [int] NOT NULL,
[MOB_KK_ISYUTARU] [int] NOT NULL,
[MOB_CH_TIGERWOMAN] [int] NOT NULL,
[MOB_AM_IVY_L3] [int] NOT NULL,
[MOB_EU_KERBEROS] [int] NOT NULL,
[MOB_AM_IVY] [int] NOT NULL,
[MOB_OA_URUCHI_L3] [int] NOT NULL,
[MOB_OA_URUCHI] [int] NOT NULL,
[MOB_JUPITER_JUPITER] [int] NOT NULL,
[MOB_JUPITER_YUNO] [int] NOT NULL,
[MOB_TK_BONELORD] [int] NOT NULL,
[MOB_RM_TAHOMET_L3] [int] NOT NULL,
[MOB_EV_WINTER_WHITEKNIGHT_20] [int] NOT NULL,
[MOB_JUPITER_BABILION] [int] NOT NULL,
[MOB_JUPITER_DARK_DOG] [int] NOT NULL,
[MOB_FW_MUJIGI_120] [int] NOT NULL,
[MOB_EU_KERBEROS_L3] [int] NOT NULL,
[MOB_CH_TIGERWOMAN_L3] [int] NOT NULL,
[MOB_KK_ISYUTARU_L3] [int] NOT NULL,
[MOB_TK_BONELORD_L3] [int] NOT NULL,
[MOB_FW_MUJIGI_135] [int] NOT NULL,
[MOB_TQ_BLACKSNAKE_L3] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_140] [int] NOT NULL,
[MOB_FW_TAESE_045] [int] NOT NULL,
[MOB_FW_TAESE_120] [int] NOT NULL,
[MOB_FW_TAESE_110] [int] NOT NULL,
[MOB_EV_WINTER_PRINCESS_100] [int] NOT NULL,
[MOB_FW_TAESE_001] [int] NOT NULL,
[MOB_SD_NEITH] [int] NOT NULL,
[MOB_SD_ISIS] [int] NOT NULL,
[MOB_TQ_WHITESNAKE] [int] NOT NULL,
[MOB_FW_TAESE_135] [int] NOT NULL,
[MOB_SD_SELKIS] [int] NOT NULL,
[MOB_EV_WINTER_WHITEKNIGHT_100] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_040] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_120] [int] NOT NULL,
[MOB_FW_TAESE_130] [int] NOT NULL,
[MOB_FW_TAESE_040] [int] NOT NULL,
[MOB_FW_TAESE_140] [int] NOT NULL,
[MOB_FW_TAESE_020] [int] NOT NULL,
[MOB_RM_SPIRITS_CLON] [int] NOT NULL,
[MOB_EV_WINTER_WHITEKNIGHT_80] [int] NOT NULL,
[MOB_FW_TAESE_111] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_020] [int] NOT NULL,
[MOB_FW_TAESE_005] [int] NOT NULL,
[MOB_FW_MUJIGI_130] [int] NOT NULL,
[MOB_FW_TAESE_003] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_100] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_108] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_109] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_104] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_105] [int] NOT NULL,
[MOB_FW_TAESE_010] [int] NOT NULL,
[MOB_FW_MUJIGI_010] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_130] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_041] [int] NOT NULL,
[MOB_EV_WINTER_PRINCESS_20] [int] NOT NULL,
[MOB_FW_TAESE_041] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_103] [int] NOT NULL,
[MOB_FW_TAESE_065] [int] NOT NULL,
[MOB_FW_TAESE_077] [int] NOT NULL,
[MOB_FW_TAESE_102] [int] NOT NULL,
[MOB_FW_TAESE_103] [int] NOT NULL,
[MOB_FW_TAESE_100] [int] NOT NULL,
[MOB_FW_MUJIGI_005] [int] NOT NULL,
[MOB_FW_TAESE_105] [int] NOT NULL,
[MOB_FW_TAESE_080] [int] NOT NULL,
[MOB_RM_SPIRITS_CLON3] [int] NOT NULL,
[MOB_RM_SPIRITS_CLON2] [int] NOT NULL,
[MOB_RM_SPIRITS] [int] NOT NULL,
[MOB_CREDDY_VOLKOFF] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA4] [int] NOT NULL,
[MOB_ARABIA_GIANT_DEMON] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA5] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA2] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA1] [int] NOT NULL,
[MOB_ARABIA_KIDEMONAS] [int] NOT NULL,
[MOB_CREDDY_WOLVERINE] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_001] [int] NOT NULL,
[MOB_FW_MUJIGI_001] [int] NOT NULL,
[MOB_RM_BONEROC] [int] NOT NULL,
[MOB_ARABIA_VENEFICA_DEMON] [int] NOT NULL,
[MOB_RM_ROC] [int] NOT NULL,
[MOB_ARABIA_THIEF_BOSS] [int] NOT NULL,
[MOB_MAG_1ROC] [int] NOT NULL,
[MOB_GOD_GHOST_UNDINE_B1] [int] NOT NULL,
[MOB_FW_MUJIGI_050] [int] NOT NULL,
[MOB_SD_HAROERIS] [int] NOT NULL,
[MOB_ARABIA_MUSTAFA3] [int] NOT NULL,
[MOB_PHY_2ROC] [int] NOT NULL,
[MOB_SD_ANUBIS] [int] NOT NULL,
[MOB_SD_SETH] [int] NOT NULL,
[MOB_JUPITER_BAAL] [int] NOT NULL,
[MOB_EV_WINTER_PRINCESS_90] [int] NOT NULL,
[MOB_EV_WINTER_WHITEKNIGHT_90] [int] NOT NULL,
[MOB_AM_IVY_L2] [int] NOT NULL,
[MOB_NEW_UNIQUE_INT] [int] NOT NULL,
[MOB_NEW_UNIQUE_STR] [int] NOT NULL,
[MOB_ARABIA_MAD_GENERAL] [int] NOT NULL,
[MOB_CH_TIGERWOMAN_L2] [int] NOT NULL,
[MOB_ARABIA_LAUNATUNE] [int] NOT NULL,
[MOB_FW_MUJIGI_020] [int] NOT NULL,
[MOB_FW_MUJIGI_025] [int] NOT NULL,
[MOB_FW_MUJIGI_015] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_010] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_050] [int] NOT NULL,
[MOB_FW_MUJIGI_040] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_030] [int] NOT NULL,
[MOB_FW_MUJIGI_030] [int] NOT NULL,
[MOB_CH_MANGNYANG_EVIL] [int] NOT NULL,
[MOB_GOD_GHOST_UNDINE_B4] [int] NOT NULL,
[MOB_JOB_TAMPLE] [int] NOT NULL,
[MOB_ARABIA_GARDEN1] [int] NOT NULL,
[MOB_ARABIA_GARDEN2] [int] NOT NULL,
[MOB_ARABIA_GARDEN3] [int] NOT NULL,
[MOB_ARABIA_GEENIE] [int] NOT NULL,
[MOB_FW_HYEONGCHEON_015] [int] NOT NULL,
[MOB_FW_MUJIGI_002] [int] NOT NULL,
[MOB_RM_TAHOMET_L2] [int] NOT NULL,
[MOB_PHY_1ANUPIS] [int] NOT NULL,
[MOB_PHY_1ISIS] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_Score] DEFAULT ((0)) FOR [Score]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_THE_EARTH1] DEFAULT ((0)) FOR [MOB_JUPITER_THE_EARTH1]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_TAHOMET] DEFAULT ((0)) FOR [MOB_RM_TAHOMET]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_KK_ISYUTARU] DEFAULT ((0)) FOR [MOB_KK_ISYUTARU]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CH_TIGERWOMAN] DEFAULT ((0)) FOR [MOB_CH_TIGERWOMAN]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_AM_IVY_L3] DEFAULT ((0)) FOR [MOB_AM_IVY_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EU_KERBEROS] DEFAULT ((0)) FOR [MOB_EU_KERBEROS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_AM_IVY] DEFAULT ((0)) FOR [MOB_AM_IVY]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_OA_URUCHI_L3] DEFAULT ((0)) FOR [MOB_OA_URUCHI_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_OA_URUCHI] DEFAULT ((0)) FOR [MOB_OA_URUCHI]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_JUPITER] DEFAULT ((0)) FOR [MOB_JUPITER_JUPITER]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_YUNO] DEFAULT ((0)) FOR [MOB_JUPITER_YUNO]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_TK_BONELORD] DEFAULT ((0)) FOR [MOB_TK_BONELORD]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_TAHOMET_L3] DEFAULT ((0)) FOR [MOB_RM_TAHOMET_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_20] DEFAULT ((0)) FOR [MOB_EV_WINTER_WHITEKNIGHT_20]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_BABILION] DEFAULT ((0)) FOR [MOB_JUPITER_BABILION]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_DARK_DOG] DEFAULT ((0)) FOR [MOB_JUPITER_DARK_DOG]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_120] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_120]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EU_KERBEROS_L3] DEFAULT ((0)) FOR [MOB_EU_KERBEROS_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CH_TIGERWOMAN_L3] DEFAULT ((0)) FOR [MOB_CH_TIGERWOMAN_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_KK_ISYUTARU_L3] DEFAULT ((0)) FOR [MOB_KK_ISYUTARU_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_TK_BONELORD_L3] DEFAULT ((0)) FOR [MOB_TK_BONELORD_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_135] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_135]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_TQ_BLACKSNAKE_L3] DEFAULT ((0)) FOR [MOB_TQ_BLACKSNAKE_L3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_140] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_140]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_045] DEFAULT ((0)) FOR [MOB_FW_TAESE_045]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_120] DEFAULT ((0)) FOR [MOB_FW_TAESE_120]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_110] DEFAULT ((0)) FOR [MOB_FW_TAESE_110]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_PRINCESS_100] DEFAULT ((0)) FOR [MOB_EV_WINTER_PRINCESS_100]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_001] DEFAULT ((0)) FOR [MOB_FW_TAESE_001]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_NEITH] DEFAULT ((0)) FOR [MOB_SD_NEITH]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_ISIS] DEFAULT ((0)) FOR [MOB_SD_ISIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_TQ_WHITESNAKE] DEFAULT ((0)) FOR [MOB_TQ_WHITESNAKE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_135] DEFAULT ((0)) FOR [MOB_FW_TAESE_135]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_SELKIS] DEFAULT ((0)) FOR [MOB_SD_SELKIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_100] DEFAULT ((0)) FOR [MOB_EV_WINTER_WHITEKNIGHT_100]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_040] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_040]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_120] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_120]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_130] DEFAULT ((0)) FOR [MOB_FW_TAESE_130]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_040] DEFAULT ((0)) FOR [MOB_FW_TAESE_040]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_140] DEFAULT ((0)) FOR [MOB_FW_TAESE_140]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_020] DEFAULT ((0)) FOR [MOB_FW_TAESE_020]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS_CLON] DEFAULT ((0)) FOR [MOB_RM_SPIRITS_CLON]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_80] DEFAULT ((0)) FOR [MOB_EV_WINTER_WHITEKNIGHT_80]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_111] DEFAULT ((0)) FOR [MOB_FW_TAESE_111]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_020] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_020]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_005] DEFAULT ((0)) FOR [MOB_FW_TAESE_005]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_130] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_130]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_003] DEFAULT ((0)) FOR [MOB_FW_TAESE_003]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_100] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_100]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_108] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_108]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_109] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_109]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_104] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_104]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_105] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_105]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_010] DEFAULT ((0)) FOR [MOB_FW_TAESE_010]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_010] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_010]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_130] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_130]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_041] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_041]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_PRINCESS_20] DEFAULT ((0)) FOR [MOB_EV_WINTER_PRINCESS_20]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_041] DEFAULT ((0)) FOR [MOB_FW_TAESE_041]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_103] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_103]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_065] DEFAULT ((0)) FOR [MOB_FW_TAESE_065]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_077] DEFAULT ((0)) FOR [MOB_FW_TAESE_077]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_102] DEFAULT ((0)) FOR [MOB_FW_TAESE_102]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_103] DEFAULT ((0)) FOR [MOB_FW_TAESE_103]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_100] DEFAULT ((0)) FOR [MOB_FW_TAESE_100]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_005] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_005]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_105] DEFAULT ((0)) FOR [MOB_FW_TAESE_105]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_TAESE_080] DEFAULT ((0)) FOR [MOB_FW_TAESE_080]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS_CLON3] DEFAULT ((0)) FOR [MOB_RM_SPIRITS_CLON3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS_CLON2] DEFAULT ((0)) FOR [MOB_RM_SPIRITS_CLON2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_SPIRITS] DEFAULT ((0)) FOR [MOB_RM_SPIRITS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CREDDY_VOLKOFF] DEFAULT ((0)) FOR [MOB_CREDDY_VOLKOFF]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA4] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA4]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GIANT_DEMON] DEFAULT ((0)) FOR [MOB_ARABIA_GIANT_DEMON]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA5] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA5]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA2] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA1] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA1]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_KIDEMONAS] DEFAULT ((0)) FOR [MOB_ARABIA_KIDEMONAS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CREDDY_WOLVERINE] DEFAULT ((0)) FOR [MOB_CREDDY_WOLVERINE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_001] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_001]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_001] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_001]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_BONEROC] DEFAULT ((0)) FOR [MOB_RM_BONEROC]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_VENEFICA_DEMON] DEFAULT ((0)) FOR [MOB_ARABIA_VENEFICA_DEMON]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_ROC] DEFAULT ((0)) FOR [MOB_RM_ROC]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_THIEF_BOSS] DEFAULT ((0)) FOR [MOB_ARABIA_THIEF_BOSS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_MAG_1ROC] DEFAULT ((0)) FOR [MOB_MAG_1ROC]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_GOD_GHOST_UNDINE_B1] DEFAULT ((0)) FOR [MOB_GOD_GHOST_UNDINE_B1]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_050] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_050]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_HAROERIS] DEFAULT ((0)) FOR [MOB_SD_HAROERIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MUSTAFA3] DEFAULT ((0)) FOR [MOB_ARABIA_MUSTAFA3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_PHY_2ROC] DEFAULT ((0)) FOR [MOB_PHY_2ROC]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_ANUBIS] DEFAULT ((0)) FOR [MOB_SD_ANUBIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_SD_SETH] DEFAULT ((0)) FOR [MOB_SD_SETH]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JUPITER_BAAL] DEFAULT ((0)) FOR [MOB_JUPITER_BAAL]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_PRINCESS_90] DEFAULT ((0)) FOR [MOB_EV_WINTER_PRINCESS_90]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_EV_WINTER_WHITEKNIGHT_90] DEFAULT ((0)) FOR [MOB_EV_WINTER_WHITEKNIGHT_90]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_AM_IVY_L2] DEFAULT ((0)) FOR [MOB_AM_IVY_L2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_NEW_UNIQUE_INT] DEFAULT ((0)) FOR [MOB_NEW_UNIQUE_INT]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_NEW_UNIQUE_STR] DEFAULT ((0)) FOR [MOB_NEW_UNIQUE_STR]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_MAD_GENERAL] DEFAULT ((0)) FOR [MOB_ARABIA_MAD_GENERAL]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CH_TIGERWOMAN_L2] DEFAULT ((0)) FOR [MOB_CH_TIGERWOMAN_L2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_LAUNATUNE] DEFAULT ((0)) FOR [MOB_ARABIA_LAUNATUNE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_020] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_020]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_025] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_025]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_015] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_015]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_010] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_010]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_050] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_050]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_040] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_040]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_030] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_030]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_030] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_030]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_CH_MANGNYANG_EVIL] DEFAULT ((0)) FOR [MOB_CH_MANGNYANG_EVIL]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_GOD_GHOST_UNDINE_B4] DEFAULT ((0)) FOR [MOB_GOD_GHOST_UNDINE_B4]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_JOB_TAMPLE] DEFAULT ((0)) FOR [MOB_JOB_TAMPLE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GARDEN1] DEFAULT ((0)) FOR [MOB_ARABIA_GARDEN1]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GARDEN2] DEFAULT ((0)) FOR [MOB_ARABIA_GARDEN2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GARDEN3] DEFAULT ((0)) FOR [MOB_ARABIA_GARDEN3]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_ARABIA_GEENIE] DEFAULT ((0)) FOR [MOB_ARABIA_GEENIE]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_HYEONGCHEON_015] DEFAULT ((0)) FOR [MOB_FW_HYEONGCHEON_015]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_FW_MUJIGI_002] DEFAULT ((0)) FOR [MOB_FW_MUJIGI_002]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_RM_TAHOMET_L2] DEFAULT ((0)) FOR [MOB_RM_TAHOMET_L2]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_PHY_1ANUPIS] DEFAULT ((0)) FOR [MOB_PHY_1ANUPIS]
GO
ALTER TABLE [dbo].[UniqueRanking] ADD CONSTRAINT [DF_UniqueRanking_MOB_PHY_1ISIS] DEFAULT ((0)) FOR [MOB_PHY_1ISIS]
GO
و الامر دة كمان
كود PHP:
USE [SHARD_HEAVY_TO]
GO
/****** Object: Table [dbo].[UniqueKills] Script Date: 08/28/2014 13:24:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[UniqueKills](
[CharName16] [varchar](20) NOT NULL,
[Monster] [varchar](50) NOT NULL,
[Timestamp] [varchar](12) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
---------------------------------------
انتهى
------------------------------------
وقت التحميل بقى :)
من هنا
|
