Sorunsuz kutulu kutusuz sembol tabloları

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USER_KNIGHTS_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[USER_KNIGHTS_RANK]

GO



CREATE TABLE [dbo].[USER_KNIGHTS_RANK] (

	[shIndex] [smallint] NOT NULL ,

	[strName] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

	[strElmoUserID] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[strElmoKnightsName] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[nElmoLoyalty] [int] NULL ,

	[strKarusUserID] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[strKarusKnightsName] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[nKarusLoyalty] [int] NULL ,

	[nMoney] [int] NOT NULL 

) ON [PRIMARY]

GO





insert into [user_knights_rank] values ('1','Gold Knight          ','MrsKajuu             ','Remix™               ','18587','TheNewComboStyLee    ','KîñgšØfThèRévîvãL    ','20709','1000000');

insert into [user_knights_rank] values ('2','Silver Knight        ','KaJuu                ','Remix™               ','15830','Thief                ','FreeGun              ','15773','1000000');

insert into [user_knights_rank] values ('3','Silver Knight        ','SeHzaD3              ','Remix™               ','15493','MrsGuardNietzsche    ','OrJiNaL              ','12956','1000000');

insert into [user_knights_rank] values ('4','Silver Knight        ','DeepHoLe             ','Remix™               ','13787','ibofiko              ','AYYILDIZ             ','12876','1000000');

insert into [user_knights_rank] values ('5','Mirage Knight        ','366                  ','TheGodPoweR          ','12042','AnarChist            ','ATLANTIC             ','12081','1000000');

insert into [user_knights_rank] values ('6','Mirage Knight        ','DanqeR0              ','Remix™               ','11576','MADC0NY0UUUU         ','Cheeky               ','11724','1000000');

insert into [user_knights_rank] values ('7','Mirage Knight        ','HoooLiqaN            ','RéãLHøøLiqãNs        ','9489','Nietzsche            ','OrJiNaL              ','11481','1000000');

insert into [user_knights_rank] values ('8','Mirage Knight        ','ForbiddenLover       ','EskisehiR            ','9225','ImParthFindeR        ','FreeGun              ','10486','1000000');

insert into [user_knights_rank] values ('9','Mirage Knight        ','D2K                  ','RéãLHøøLiqãNs        ','9129','UsingDecroLest       ','UsingComéBackHousé   ','9810','1000000');

insert into [user_knights_rank] values ('10','Shadow Knight        ','StymphaLos           ','EskisehiR            ','8616','SancTuM              ','FreeGun              ','8848','1000000');

insert into [user_knights_rank] values ('11','Shadow Knight        ','AiSeEuTePego         ','Remix™               ','8000','UnforgivenFailed     ','FreeGun              ','8710','1000000');

insert into [user_knights_rank] values ('12','Shadow Knight        ','HooLiqaN             ','RéãLHøøLiqãNs        ','7391','Jr_styliest          ','4LegendS             ','8667','1000000');

insert into [user_knights_rank] values ('13','Shadow Knight        ','lDrowninqPooLl       ','RéãLHøøLiqãNs        ','7185','EzuqmuSand1n***      ','KîñgšØfThèRévîvãL    ','8654','1000000');

insert into [user_knights_rank] values ('14','Shadow Knight        ','IkiRyo               ','Remix™               ','7166','UsingThronLest       ','UsingComéBackHousé   ','8608','1000000');

insert into [user_knights_rank] values ('15','Shadow Knight        ','SorryForKilled       ','Remix™               ','6908','UsingTabangLest      ','UsingComéBackHousé   ','8281','1000000');

insert into [user_knights_rank] values ('16','Shadow Knight        ','HyperioN             ','TheGodPoweR          ','6685','lEdmondDantesl       ','UndefeatabLe         ','8200','1000000');

insert into [user_knights_rank] values ('17','Shadow Knight        ','Tompit               ','Remix™               ','6600','4IChirqeFz           ','AYYILDIZ             ','6669','1000000');

insert into [user_knights_rank] values ('18','Shadow Knight        ','Super3H              ','Remix™               ','6541','ExceIIentBreaker     ','OrJiNaL              ','6179','1000000');

insert into [user_knights_rank] values ('19','Shadow Knight        ','TheRebellious        ','Remix™               ','6235','PASA                 ','ATLANTIC             ','6175','1000000');

insert into [user_knights_rank] values ('20','Shadow Knight        ','JacManiuS            ','BleedUmmieMooth      ','5947','WeezeR               ','NULL','6069','1000000');

insert into [user_knights_rank] values ('21','Shadow Knight        ','BurakYilmaz          ','NationalTeam         ','5930','H4PP3R               ','ATLANTIC             ','5590','1000000');

insert into [user_knights_rank] values ('22','Shadow Knight        ','4TacH                ','TheGodPoweR          ','5839','ExcellentAsassian    ','OrJiNaL              ','5412','1000000');

insert into [user_knights_rank] values ('23','Shadow Knight        ','Str0ngChild          ','LifeStone            ','5836','qRice                ','OrcChampionS         ','4898','1000000');

insert into [user_knights_rank] values ('24','Shadow Knight        ','Lethaeus             ','NULL','5830','lEdmondGoKaNl        ','UndefeatabLe         ','4894','1000000');

insert into [user_knights_rank] values ('25','Shadow Knight        ','IDayLWaLkeRI         ','TheGodPoweR          ','5512','HarDPLayer           ','WhoWantToFLyWithUs   ','4883','1000000');

insert into [user_knights_rank] values ('26','Mist Knight          ','BaZaR0V              ','Remix™               ','5334','Cry                  ','4LegendS             ','4831','1000000');

insert into [user_knights_rank] values ('27','Mist Knight          ','BogazinSerinSulari   ','BEYKOZ               ','5099','BirResimKalsinBizden ','NULL','4814','1000000');

insert into [user_knights_rank] values ('28','Mist Knight          ','JavieReL             ','NULL','5036','SystemError          ','OrcChampionS         ','4800','1000000');

insert into [user_knights_rank] values ('29','Mist Knight          ','MrBaroo              ','BEYKOZ               ','4941','4Spawn               ','ATLANTIC             ','4770','1000000');

insert into [user_knights_rank] values ('30','Mist Knight          ','Theseus              ','NULL','4807','Winner               ','NULL','4751','1000000');

insert into [user_knights_rank] values ('31','Mist Knight          ','NightBoss            ','Remix™               ','4695','UsingFreeLest        ','UsingComéBackHousé   ','4511','1000000');

insert into [user_knights_rank] values ('32','Mist Knight          ','Lucky_Pearl          ','Remix™               ','4693','lEdmondQw4yKel       ','UndefeatabLe         ','4463','1000000');

insert into [user_knights_rank] values ('33','Mist Knight          ','ReBeLLiouS           ','˜GréavéPorTérS˜      ','4691','TheRion              ','4LegendS             ','4378','1000000');

insert into [user_knights_rank] values ('34','Mist Knight          ','BasicFruttaR         ','NULL','4683','KafaNereyeBiz0raya   ','MahallemPA           ','4243','1000000');

insert into [user_knights_rank] values ('35','Mist Knight          ','ByComboMach1ne       ','RévîsîøN             ','4416','K4S1RG4              ','TSK™                 ','3991','1000000');

insert into [user_knights_rank] values ('36','Mist Knight          ','NoBodyYourRepLaCesLe ','RéãLHøøLiqãNs        ','4411','EKOOOOOOOOOOOOOOOOO  ','4LegendS             ','3960','1000000');

insert into [user_knights_rank] values ('37','Mist Knight          ','ARAGAN               ','Remix™               ','4274','LyRio                ','NULL','3883','1000000');

insert into [user_knights_rank] values ('38','Mist Knight          ','LuoMajian            ','ThinkAbl€            ','4174','BLackEgoo            ','•ßéyâzSâyfâ•         ','3871','1000000');

insert into [user_knights_rank] values ('39','Mist Knight          ',';ChemShid_           ','IronPunch            ','4064','4PornContRoL         ','RESPECT              ','3853','1000000');

insert into [user_knights_rank] values ('40','Mist Knight          ','ElaniapoLis          ','NULL','4036','IWhereDontSunShine   ','WhoWantToFLyWithUs   ','3844','1000000');

insert into [user_knights_rank] values ('41','Mist Knight          ','TheChristina         ','Remix™               ','3983','Blue                 ','NULL','3687','1000000');

insert into [user_knights_rank] values ('42','Mist Knight          ','OC:DalmaBanaxD       ','0rospuCocukLari      ','3911','lEdmondSAm3TCaN      ','UndefeatabLe         ','3639','1000000');

insert into [user_knights_rank] values ('43','Mist Knight          ','deviantART           ','NULL','3800','_4CHarLessPriesT     ','ImSorryNobodyStopMe  ','3547','1000000');

insert into [user_knights_rank] values ('44','Mist Knight          ','Jypn0                ','GériDöndükAyiqOl     ','3736','RequemForADream      ','EGYPT                ','3455','1000000');

insert into [user_knights_rank] values ('45','Training Knight      ','OC:ComeAndSee        ','0rospuCocukLari      ','3689','IWIRodRiqez          ','4LegendS             ','3384','1000000');

insert into [user_knights_rank] values ('46','Training Knight      ','HelalOlsun           ','NULL','3642','lEdmondQuel          ','UndefeatabLe         ','3363','1000000');

insert into [user_knights_rank] values ('47','Training Knight      ','CREEEPY              ','RéãLHøøLiqãNs        ','3515','NowamBalgamGibi      ','4LegendS             ','3330','1000000');

insert into [user_knights_rank] values ('48','Training Knight      ','Pasha                ','MiracLe              ','3504','lEdmondJuvenl        ','NULL','3270','1000000');

insert into [user_knights_rank] values ('49','Training Knight      ','CaptainGaziTurk      ','•CãptãínFâmíLy•      ','3468','BGA                  ','AYYILDIZ             ','3268','1000000');

insert into [user_knights_rank] values ('50','Training Knight      ','_SoIHaveToLookAtCutS ','MuaH                 ','3460','NativeBank           ','EnémyForcéss         ','3217','1000000');

insert into [user_knights_rank] values ('51','Training Knight      ','IFAUST_DeJaVu        ','RéãLHøøLiqãNs        ','3432','WeUsDeLy             ','NULL','3109','1000000');

insert into [user_knights_rank] values ('52','Training Knight      ','XacKerR              ','Remix™               ','3392','nAsh                 ','FreeGun              ','3049','1000000');

insert into [user_knights_rank] values ('53','Training Knight      ','ImJheWeyRoN          ','LifeStone            ','3245','lEdmondHomel         ','NULL','3040','1000000');

insert into [user_knights_rank] values ('54','Training Knight      ','Stephan              ','TheGodPoweR          ','3232','ImPossible           ','NULL','3012','1000000');

insert into [user_knights_rank] values ('55','Training Knight      ','XDSag0               ','BEYKOZ               ','3197','c0ch0N               ','4LegendS             ','2925','1000000');

insert into [user_knights_rank] values ('56','Training Knight      ','MinorMachine         ','SerGecTiMechaNiC     ','3181','JackSparroW          ','AusSwictz            ','2884','1000000');

insert into [user_knights_rank] values ('57','Training Knight      ','YuKSeKSaDaKaT        ','NULL','3180','HudavendigaR         ','ImSorryNobodyStopMe  ','2878','1000000');

insert into [user_knights_rank] values ('58','Training Knight      ','4execPoxi0nS         ','EfkarLiyiz_Usda™     ','3170','JuBa                 ','OrcChampionS         ','2861','1000000');

insert into [user_knights_rank] values ('59','Training Knight      ','xSanderv4n           ','Remix™               ','3141','lEdmondWrinkLesl     ','UndefeatabLe         ','2813','1000000');

insert into [user_knights_rank] values ('60','Training Knight      ','TimeIsBadKeepYourAss ','NULL','2978','Phantaso             ','4LegendS             ','2791','1000000');

insert into [user_knights_rank] values ('61','Training Knight      ','Shoppiee             ','IronPunch            ','2943','WeUsTertip           ','NULL','2718','1000000');

insert into [user_knights_rank] values ('62','Training Knight      ','DieFORme             ','RéãLHøøLiqãNs        ','2925','Terlik               ','NULL','2644','1000000');

insert into [user_knights_rank] values ('63','Training Knight      ','StronqStarR          ','DexteR               ','2914','RiskYourLife         ','NULL','2588','1000000');

insert into [user_knights_rank] values ('64','Training Knight      ','CaptainB3rK          ','•CãptãínFâmíLy•      ','2892','KinqShadoW_          ','NULL','2585','1000000');

insert into [user_knights_rank] values ('65','Training Knight      ','GirayKacar           ','NationalTeam         ','2867','IEdmondExpansionI    ','UndefeatabLe         ','2520','1000000');

insert into [user_knights_rank] values ('66','Training Knight      ','ILawienRose          ','Remix™               ','2866','WeUsHeartLoca_       ','OcGokhan             ','2461','1000000');

insert into [user_knights_rank] values ('67','Training Knight      ','Sky                  ','Remix™               ','2841','UnstapLess           ','TraiLerS             ','2455','1000000');

insert into [user_knights_rank] values ('68','Training Knight      ','QnLyRadierGummi      ','LifeStone            ','2811','ShowTime             ','NULL','2453','1000000');

insert into [user_knights_rank] values ('69','Training Knight      ','OC:VurucU            ','0rospuCocukLari      ','2751','4RedTubE             ','KromoZomKarDésLéR    ','2437','1000000');

insert into [user_knights_rank] values ('70','Training Knight      ','WannaRock            ','ToLiveToKill         ','2740','Ayakkabi             ','NULL','2429','1000000');

insert into [user_knights_rank] values ('71','Training Knight      ','Homes1ck             ','ExtraOrdinary        ','2722','WeUsScheyTan         ','NULL','2390','1000000');

insert into [user_knights_rank] values ('72','Training Knight      ','ImLeTHeSuNSHiNe      ','LifeStone            ','2721','4KeezMovies          ','RESPECT              ','2377','1000000');

insert into [user_knights_rank] values ('73','Training Knight      ','QnLyLeTHeSuNSHiNe    ','LifeStone            ','2718','EagleIsAlone         ','AusSwictz            ','2371','1000000');

insert into [user_knights_rank] values ('74','Training Knight      ','IamGaTTaR_           ','NULL','2658','ice23                ','4LegendS             ','2204','1000000');

insert into [user_knights_rank] values ('75','Training Knight      ','CaptainCukulata      ','•CãptãínFâmíLy•      ','2601','FireHq               ','4LegendS             ','2184','1000000');

insert into [user_knights_rank] values ('76','Training Knight      ','Prof                 ','TheGodPoweR          ','2526','TheLosTAnGeL         ','KromoZomKarDésLéR    ','2160','1000000');

insert into [user_knights_rank] values ('77','Training Knight      ','Super2H              ','Remix™               ','2509','X_Jeavito            ','EGYPT                ','2107','1000000');

insert into [user_knights_rank] values ('78','Training Knight      ','BOSS                 ','NULL','2505','_JuBa                ','NULL','2082','1000000');

insert into [user_knights_rank] values ('79','Training Knight      ','CaptainlxHerKuLxl    ','•CãptãínFâmíLy•      ','2497','ICokmuSaglamNe       ','NULL','2070','1000000');

insert into [user_knights_rank] values ('80','Training Knight      ','LeqenDProKinQ        ','LeqenDs              ','2445','::_BROWN_::          ','NULL','2034','1000000');

insert into [user_knights_rank] values ('81','Training Knight      ','KalpSizPic10         ','GeNeRalS™            ','2411','lEdmondReadLyl       ','UndefeatabLe         ','2011','1000000');

insert into [user_knights_rank] values ('82','Training Knight      ','QnLyFLeaNCE          ','LifeStone            ','2404','FuckPussy            ','NULL','1982','1000000');

insert into [user_knights_rank] values ('83','Training Knight      ','LOSTTSOL             ','RéãLHøøLiqãNs        ','2360','4BrazzeRs            ','RESPECT              ','1956','1000000');

insert into [user_knights_rank] values ('84','Training Knight      ','DoNumDakiKoBra       ','TheBesT              ','2353','Coexistence          ','NULL','1932','1000000');

insert into [user_knights_rank] values ('85','Training Knight      ','QnLyJiggaBunny       ','NULL','2300','CaRiSMaTr            ','ImSorryNobodyStopMe  ','1879','1000000');

insert into [user_knights_rank] values ('86','Training Knight      ','MarshallBruceMaMy    ','BEYKOZ               ','2297','KafaNereyeBizORaya   ','MahallemPA           ','1869','1000000');

insert into [user_knights_rank] values ('87','Training Knight      ','LegendaryLord        ','Remix™               ','2273','::_WHiTE_::          ','NULL','1856','1000000');

insert into [user_knights_rank] values ('88','Training Knight      ','ImGuard_             ','NULL','2244','ProM**iCc            ','M**icNecmiler        ','1848','1000000');

insert into [user_knights_rank] values ('89','Training Knight      ','IamMALKOCOGLU        ','NULL','2236','WeUs3HarFLi          ','OcGokhan             ','1824','1000000');

insert into [user_knights_rank] values ('90','Training Knight      ','Champi               ','SoSorry              ','2230','BegMeForMercy        ','Randy™               ','1814','1000000');

insert into [user_knights_rank] values ('91','Training Knight      ','TheCycLone           ','NULL','2225','WeUsMuRaT            ','NULL','1798','1000000');

insert into [user_knights_rank] values ('92','Training Knight      ','CaptainStrongDangr   ','•CãptãínFâmíLy•      ','2107','c0nd0m               ','NULL','1793','1000000');

insert into [user_knights_rank] values ('93','Training Knight      ','ByOptimistiC         ','MuaH                 ','2105','4RoadRunner          ','EGYPT                ','1765','1000000');

insert into [user_knights_rank] values ('94','Training Knight      ','SirWhoCares          ','ToLiveToKill         ','2097','lEdmondGuard         ','NULL','1732','1000000');

insert into [user_knights_rank] values ('95','Training Knight      ','QnLyShinobi          ','LifeStone            ','2034','MordeKaiser          ','NULL','1732','1000000');

insert into [user_knights_rank] values ('96','Training Knight      ','Lanfranchi           ','ExtraOrdinary        ','1975','_4CHarLessT0SUN      ','AlwaySFeeL           ','1682','1000000');

insert into [user_knights_rank] values ('97','Training Knight      ','Shempazeeeee         ','NULL','1970','WhyPhichWhy          ','NULL','1676','1000000');

insert into [user_knights_rank] values ('98','Training Knight      ','StaBil_xD            ','ToLiveToKill         ','1946','lEdmondDusmaNGotuNe  ','NULL','1657','1000000');

insert into [user_knights_rank] values ('99','Training Knight      ','AnanZaa              ','ArmyOfBrothers       ','1920','IIUzKII              ','Cheeky               ','1656','1000000');

insert into [user_knights_rank] values ('100','Training Knight      ','aRoMaTiC             ','K1ssMyPoPo           ','1915','CampKillYourself     ','NULL','1645','1000000');

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USER_PERSONAL_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[USER_PERSONAL_RANK]

GO



CREATE TABLE [dbo].[USER_PERSONAL_RANK] (

	[nRank] [smallint] NOT NULL ,

	[strPosition] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

	[nElmoUP] [smallint] NOT NULL ,

	[strElmoUserID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[nElmoLoyaltyMonthly] [int] NULL ,

	[nElmoCheck] [int] NOT NULL ,

	[nKarusUP] [smallint] NOT NULL ,

	[strKarusUserID] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[nKarusLoyaltyMonthly] [int] NULL ,

	[nKarusCheck] [int] NOT NULL ,

	[nSalary] [int] NOT NULL ,

	[UpdateDate] [smalldatetime] NOT NULL 

) ON [PRIMARY]

GO



insert into [user_personal_rank] values ('1','Gold Knight          ','0','MrsKajuu             ','18487','1000000','3','TheNewComboStyLee    ','20109','1000000','1000000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('2','Silver Knight        ','2','KaJuu                ','15730','700000','-1','Thief                ','15173','700000','700000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('3','Silver Knight        ','0','SeHzaD3              ','15443','700000','0','MrsGuardNietzsche    ','12856','700000','700000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('4','Silver Knight        ','2','DeepHoLe             ','13187','700000','3','ibofiko              ','12326','700000','700000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('5','Mirage Knight        ','-3','366                  ','11525','500000','-3','MADC0NY0UUUU         ','11674','500000','500000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('6','Mirage Knight        ','-1','DanqeR0              ','11112','500000','2','AnarChist            ','11531','500000','500000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('7','Mirage Knight        ','7','HoooLiqaN            ','8889','500000','-1','Nietzsche            ','10881','500000','500000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('8','Mirage Knight        ','4','ForbiddenLover       ','8700','500000','-3','ImParthFindeR        ','9886','500000','500000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('9','Mirage Knight        ','4','D2K                  ','8647','500000','16','UsingDecroLest       ','9260','500000','500000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('10','Shadow Knight        ','101','StymphaLos           ','8366','300000','0','SancTuM              ','8748','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('11','Shadow Knight        ','-2','AiSeEuTePego         ','7450','300000','26','Jr_styliest          ','8597','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('12','Shadow Knight        ','-4','IkiRyo               ','7066','300000','30','UsingThronLest       ','8558','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('13','Shadow Knight        ','5','HooLiqaN             ','6791','300000','27','EzuqmuSand1n***      ','8554','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('14','Shadow Knight        ','28','lDrowninqPooLl       ','6585','300000','-2','UnforgivenFailed     ','8110','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('15','Shadow Knight        ','25','HyperioN             ','6585','300000','37','UsingTabangLest      ','7707','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('16','Shadow Knight        ','-9','Super3H              ','6455','300000','-7','lEdmondDantesl       ','7650','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('17','Shadow Knight        ','62','SorryForKilled       ','6308','300000','4','4IChirqeFz           ','6069','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('18','Shadow Knight        ','79','Tompit               ','6050','300000','33','WeezeR               ','5619','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('19','Shadow Knight        ','5','Lethaeus             ','5730','300000','-4','ExceIIentBreaker     ','5579','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('20','Shadow Knight        ','-9','TheRebellious        ','5635','300000','3','PASA                 ','5575','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('21','Shadow Knight        ','-5','IDayLWaLkeRI         ','5412','300000','43','H4PP3R               ','5501','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('22','Shadow Knight        ','-2','BurakYilmaz          ','5391','300000','-5','ExcellentAsassian    ','4812','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('23','Shadow Knight        ','-8','JacManiuS            ','5383','300000','-3','SystemError          ','4583','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('24','Shadow Knight        ','101','BaZaR0V              ','5284','300000','4','qRice                ','4448','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('25','Shadow Knight        ','-8','4TacH                ','5272','300000','-14','HarDPLayer           ','4447','300000','300000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('26','Mist Knight          ','-16','Str0ngChild          ','5236','200000','39','UsingFreeLest        ','4411','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('27','Mist Knight          ','-8','BogazinSerinSulari   ','4999','200000','53','BirResimKalsinBizden ','4356','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('28','Mist Knight          ','71','JavieReL             ','4959','200000','4','lEdmondGoKaNl        ','4294','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('29','Mist Knight          ','-7','MrBaroo              ','4841','200000','-15','4Spawn               ','4234','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('30','Mist Knight          ','-5','Theseus              ','4707','200000','-12','Cry                  ','4231','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('31','Mist Knight          ','19','BasicFruttaR         ','4583','200000','-5','Winner               ','4159','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('32','Mist Knight          ','0','Lucky_Pearl          ','4275','200000','-10','KafaNereyeBiz0raya   ','4157','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('33','Mist Knight          ','60','ReBeLLiouS           ','4191','200000','12','lEdmondQw4yKel       ','3863','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('34','Mist Knight          ','101','NoBodyYourRepLaCesLe ','4174','200000','101','EKOOOOOOOOOOOOOOOOO  ','3860','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('35','Mist Knight          ','101','NightBoss            ','4095','200000','-19','LyRio                ','3783','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('36','Mist Knight          ','-10','ByComboMach1ne       ','3816','200000','101','TheRion              ','3778','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('37','Mist Knight          ','2','ARAGAN               ','3724','200000','-18','IWhereDontSunShine   ','3772','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('38','Mist Knight          ','-9',';ChemShid_           ','3644','200000','-9','BLackEgoo            ','3544','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('39','Mist Knight          ','5','Jypn0                ','3636','200000','18','K4S1RG4              ','3441','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('40','Mist Knight          ','-3','LuoMajian            ','3574','200000','-9','lEdmondQuel          ','3263','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('41','Mist Knight          ','-20','ElaniapoLis          ','3486','200000','-17','4PornContRoL         ','3253','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('42','Mist Knight          ','56','CREEEPY              ','3415','200000','-8','Blue                 ','3237','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('43','Mist Knight          ','-20','Pasha                ','3404','200000','1','BGA                  ','3218','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('44','Mist Knight          ','-1','TheChristina         ','3383','200000','26','RequemForADream      ','3197','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('45','Mist Knight          ','101','IFAUST_DeJaVu        ','3382','200000','-18','_4CHarLessPriesT     ','3112','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('46','Mist Knight          ','101','OC:DalmaBanaxD       ','3361','200000','37','lEdmondSAm3TCaN      ','3039','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('47','Mist Knight          ','19','XacKerR              ','3360','200000','16','nAsh                 ','2999','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('48','Mist Knight          ','-12','deviantART           ','3200','200000','28','ImPossible           ','2912','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('49','Mist Knight          ','8','XDSag0               ','3097','200000','101','NowamBalgamGibi      ','2850','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('50','Mist Knight          ','34','OC:ComeAndSee        ','3089','200000','11','IWIRodRiqez          ','2799','200000','200000','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('51','Training Knight      ','35','4execPoxi0nS         ','3070','0','-13','NativeBank           ','2731','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('52','Training Knight      ','-25','xSanderv4n           ','3062','0','30','lEdmondWrinkLesl     ','2713','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('53','Training Knight      ','-25','HelalOlsun           ','3042','0','-23','lEdmondJuvenl        ','2670','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('54','Training Knight      ','101','_SoIHaveToLookAtCutS ','2871','0','-21','WeUsDeLy             ','2509','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('55','Training Knight      ','-25','CaptainGaziTurk      ','2868','0','-20','lEdmondHomel         ','2440','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('56','Training Knight      ','101','Stephan              ','2854','0','6','IEdmondExpansionI    ','2420','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('57','Training Knight      ','101','Shoppiee             ','2854','0','-21','WeUsHeartLoca_       ','2361','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('58','Training Knight      ','101','DieFORme             ','2825','0','101','c0ch0N               ','2327','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('59','Training Knight      ','-28','CaptainB3rK          ','2792','0','-20','JuBa                 ','2296','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('60','Training Knight      ','0','ILawienRose          ','2766','0','-17','JackSparroW          ','2284','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('61','Training Knight      ','-28','ImJheWeyRoN          ','2677','0','101','HudavendigaR         ','2278','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('62','Training Knight      ','-27','IamGaTTaR_           ','2608','0','101','Phantaso             ','2191','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('63','Training Knight      ','-29','YuKSeKSaDaKaT        ','2598','0','-22','WeUsTertip           ','2118','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('64','Training Knight      ','101','MinorMachine         ','2581','0','101','Terlik               ','2072','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('65','Training Knight      ','-27','CaptainCukulata      ','2501','0','101','RiskYourLife         ','1988','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('66','Training Knight      ','101','Prof                 ','2462','0','-17','KinqShadoW_          ','1985','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('67','Training Knight      ','-9','Super2H              ','2423','0','101','ICokmuSaglamNe       ','1970','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('68','Training Knight      ','-27','CaptainlxHerKuLxl    ','2397','0','101','ShowTime             ','1931','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('69','Training Knight      ','9','TimeIsBadKeepYourAss ','2378','0','101','lEdmondReadLyl       ','1911','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('70','Training Knight      ','1','StronqStarR          ','2314','0','-22','EagleIsAlone         ','1906','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('71','Training Knight      ','101','LOSTTSOL             ','2305','0','-18','4RedTubE             ','1887','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('72','Training Knight      ','101','GirayKacar           ','2267','0','-26','FuckPussy            ','1882','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('73','Training Knight      ','101','Sky                  ','2252','0','-5','UnstapLess           ','1855','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('74','Training Knight      ','-29','QnLyRadierGummi      ','2211','0','-27','WeUsScheyTan         ','1840','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('75','Training Knight      ','101','OC:VurucU            ','2201','0','101','Ayakkabi             ','1829','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('76','Training Knight      ','-30','ImGuard_             ','2194','0','101','X_Jeavito            ','1780','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('77','Training Knight      ','-10','LegendaryLord        ','2173','0','-27','4KeezMovies          ','1777','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('78','Training Knight      ','-31','ImLeTHeSuNSHiNe      ','2153','0','-23','KafaNereyeBizORaya   ','1769','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('79','Training Knight      ','101','WannaRock            ','2140','0','-23','WeUs3HarFLi          ','1724','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('80','Training Knight      ','101','Champi               ','2130','0','101','4RoadRunner          ','1715','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('81','Training Knight      ','101','Homes1ck             ','2122','0','101','ice23                ','1704','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('82','Training Knight      ','-34','QnLyLeTHeSuNSHiNe    ','2118','0','-28','_4CHarLessT0SUN      ','1660','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('83','Training Knight      ','-34','CaptainStrongDangr   ','2057','0','-25','FireHq               ','1584','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('84','Training Knight      ','-22','LeqenDProKinQ        ','2045','0','101','TheLosTAnGeL         ','1560','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('85','Training Knight      ','101','SirWhoCares          ','1999','0','-26','lEdmondDusmaNGotuNe  ','1557','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('86','Training Knight      ','-35','QnLyShinobi          ','1934','0','-26','_JuBa                ','1532','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('87','Training Knight      ','101','BOSS                 ','1905','0','101','::_BROWN_::          ','1520','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('88','Training Knight      ','101','KalpSizPic10         ','1902','0','101','AzAp                 ','1512','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('89','Training Knight      ','-26','Shempazeeeee         ','1870','0','101','::_WHiTE_::          ','1392','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('90','Training Knight      ','-38','aRoMaTiC             ','1815','0','-23','4BrazzeRs            ','1356','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('91','Training Knight      ','-38','QnLyFLeaNCE          ','1804','0','-25','ProM**iCc            ','1348','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('92','Training Knight      ','-38','KiracI               ','1794','0','-6','Coexistence          ','1332','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('93','Training Knight      ','101','DoNumDakiKoBra       ','1753','0','-24','WeUsSpeeDyGonZaLeS   ','1297','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('94','Training Knight      ','101','LancelotPriest       ','1749','0','101','CaRiSMaTr            ','1285','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('95','Training Knight      ','-39','MarshallBruceMaMy    ','1747','0','101','TSK:lUnstoppablel    ','1267','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('96','Training Knight      ','-41','QnLyJiggaBunny       ','1720','0','101','TSK:********         ','1221','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('97','Training Knight      ','-9','TheCycLone           ','1675','0','101','BegMeForMercy        ','1214','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('98','Training Knight      ','101','IamMALKOCOGLU        ','1661','0','-23','IIUzKII              ','1206','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('99','Training Knight      ','-19','IChristmaS           ','1645','0','-28','WeUsMuRaT            ','1198','0','0','2012-01-26 23:28:00');

insert into [user_personal_rank] values ('100','Training Knight      ','-41','CaptainJustPlay      ','1632','0','-28','WeUsLAZREYIZ         ','1198','0','0','2012-01-26 23:28:00');

update USER_KNIGHTS_RANK set strelmouserid = ''

update USER_KNIGHTS_RANK set strelmoknightsname = ''

update USER_KNIGHTS_RANK set nelmoloyalty = ''

update USER_KNIGHTS_RANK set strkarususerid = ''

update USER_KNIGHTS_RANK set strkarusknightsname = ''

update USER_KNIGHTS_RANK set strelmouserid = ''

update USER_KNIGHTS_RANK set nkarusloyalty = ''



update user_personal_rank set strelmouserid = ''

update user_personal_rank set nElmoLoyaltyMonthly = ''

update user_personal_rank set nelmocheck = ''

update user_personal_rank set strkarususerid = ''

update user_personal_rank set nkarusLoyaltyMonthly = ''

update user_personal_rank set Nkaruscheck = ''