- Katılım
- 6 Mayıs 2022
- Mesajlar
- 45,967
Kod:
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');Kutusuz NP Sembol İçin Gerekli Kod
Kod:
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');Ve Ardından Bunu SQL ** Yapıştırıp F5 Yapmanız Gerekmektedir.
Kod:
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 = ''Yukarıdaki İşlemler Tablo Oluşturmak İçin
İnş. İşinize Yarar Kolay Gelsin.
Sorunsuz Kutulu ve Kutusuz Sembol Tabloları Nedir?
Knight Online özel sunucularında (pserver) oyun içi simgeleri doğru ve sorunsuz bir şekilde göstermek büyük önem taşır. Özellikle özel sunucu dosyaları üzerinde çalışırken, kutulu ve kutusuz sembol tabloları doğru yapılandırılmadığında, karakterlerin görünümü, ekipmanlar ve efektler bozuk görünebilir. Bu durum hem oyuncu deneyimini düşürür hem de sunucu kalitesini ciddi anlamda etkiler. Bu yazıda, Knight Online özel sunucularında kutulu ve kutusuz sembol tablolarının ne olduğunu, neden önemli olduğunu ve nasıl doğru yapılandırılacağını detaylı olarak ele alacağız.
Kutulu ve Kutusuz Sembol Tabloları Nedir?
Knight Online oyununda sembol tabloları, karakterlerin, silahların, zırhların ve diğer objelerin 3D modellerinde doğru şekilde doku (texture) ve efekt atamaları yapılmasını sağlar. Bu tablolar genellikle symboltable.xml, item.bin, mob.bin, npc.bin gibi dosyalarda tanımlanır. Bu dosyalar, oyun istemcisi (client) ve sunucu tarafında doğru çalışması için uyumlu olmalıdır. Kutulu sembol tabloları, bazı objelerin sınırlı bir kutu (box) içinde tanımlandığı, kutusuz olanlarsa daha geniş veya sınırsız tanımlamalara sahiptir. Doğru yapılandırılmazsa, karakterlerin bazı parçaları eksik ya da bozuk görünebilir.
Neden Sorunsuz Yapılandırma Önemlidir?
Knight Online özel sunucularında (pserver) oyunun görsel bütünlüğü, oyuncuların uzun süre kalmasını sağlar. Eğer sembol tabloları yanlışsa, örneğin bir chitin shell ekipmanı karakter üzerinde bozuk veya eksik gözüküyorsa, oyuncu bu sunucudan başka birine geçebilir. Ayrıca, Lycaon, Felankor gibi özel karakterlerin modellemeleri de bu tablolara bağlıdır. Yanlış yapılandırma, bu karakterlerin oyun içinde tuhaf veya korkutucu görünmesine sebep olabilir. Bu yüzden hem USKO, ROFD, iKO gibi popüler sistemlerde hem de yeni geliştirilen sunucularda bu yapılandırmaların doğruluğu kritik öneme sahiptir.
Teknik Yapılandırma Adımları
Öncelikle, sunucu dosyalarınızda (ko server files) bulunan item.bin ve symboltable.xml dosyalarının, istemci tarafındaki dosyalarla uyumlu olduğundan emin olunmalıdır. Eğer sunucu tarafında cap 83 destekleniyorsa, istemci de buna uygun olmalıdır. Aksi takdirde sembol tablosu eksik veya fazla veri tanımlayarak hatalara yol açabilir. KO Client Edit işlemlerinde, bu dosyaların doğru şekilde dönüştürülmesi gerekir. Özellikle Myko veya Usko tabanlı sunucularda, sembol tablosu dosyaları özel düzenlemelere ihtiyaç gösterebilir. KO Bot geliştiricileri de bu tablolara dikkat etmelidir, çünkü botlar oyun içindeki nesnelerle etkileşim kurarken bu sembolleri kullanır.
Yanlış Yapılandırmaların Sonuçları
Sembol tablolarının yanlış yapılandırılması, şu sorunlara yol açabilir:
- Ekipmanlar karakter üzerinde eksik veya bozuk gözükür.
- Silah ve zırhlarda doku atlamaları olur.
- NPC'ler ve moblar bozuk modellerle oyun içinde görünür.
- Oyun istemcisi çökme yaşayabilir.
- Sunucuya bağlanan oyuncular görsel hatalarla karşılaşır ve sunucudan ayrılır.
Sonuç
Knight Online özel sunucularında kutulu ve kutusuz sembol tablolarının doğru yapılandırılması, oyunun görsel bütünlüğü ve oyuncu memnuniyeti açısından kritik öneme sahiptir. Geliştiricilerin hem sunucu hem de istemci tarafında bu dosyaları dikkatle kontrol etmeleri ve test etmeleri gerekir. Knight Online Development sürecinde, bu yapılandırmaları doğru yapmak, profesyonel ve kaliteli bir sunucu ortamı sunmanın temel adımıdır. Knight Lobby olarak, özel sunucu geliştiricilerine yardımcı olacak kaynaklar ve destek sağlamaya devam ediyoruz.
What Are Seamless Boxed and Unboxed Symbol Tables?
In Knight Online private servers (pserver), displaying in-game symbols correctly and without errors is crucial. Especially while working on custom server files, incorrect configuration of boxed and unboxed symbol tables can cause character appearances, equipment, and effects to appear broken. This situation not only reduces player experience but also significantly affects server quality. In this article, we will detail what boxed and unboxed symbol tables are in Knight Online private servers, why they are important, and how to configure them properly.
What Are Boxed and Unboxed Symbol Tables?
Symbol tables in Knight Online ensure correct texture and effect mappings on 3D models of characters, weapons, armors, and other objects. These tables are typically defined in files like symboltable.xml, item.bin, mob.bin, npc.bin. These files must be compatible between the game client and server to function properly. Boxed symbol tables define certain objects within a limited box, whereas unboxed ones have broader or unlimited definitions. If incorrectly configured, parts of characters may appear missing or corrupted.
Why Is Seamless Configuration Important?
In Knight Online private servers (pserver), visual consistency ensures players stay longer. For instance, if symbol tables are wrong and an item like chitin shell appears broken or incomplete on the character, players might switch to another server. Additionally, special characters like Lycaon or Felankor rely on these tables. Incorrect configurations can cause these characters to look weird or scary in-game. Therefore, accuracy is critical in both popular systems like USKO, ROFD, iKO and newly developed servers.
Technical Configuration Steps
Firstly, ensure that item.bin and symboltable.xml files in your server files (ko server files) are compatible with client-side files. If your server supports cap 83, the client must match accordingly. Otherwise, the symbol table might define too little or too much data, causing errors. During KO Client Edit operations, these files must be converted correctly. Especially for Myko or Usko based servers, the symbol table files may require specific adjustments. KO Bot developers should also pay attention to these tables, since bots interact with in-game objects using these symbols.
Consequences of Incorrect Configurations
Incorrect symbol table configurations can lead to:
- Equipment appearing incomplete or broken on characters.
- Texture glitches on weapons and armors.
- NPCs and mobs appearing with broken models in-game.
- Game client crashes.
- Players encountering visual errors and leaving the server.
Conclusion
Correctly configuring boxed and unboxed symbol tables in Knight Online private servers is critical for visual integrity and player satisfaction. Developers must carefully check and test these files on both server and client sides during development. In Knight Online Development, proper configuration of these elements is a fundamental step toward providing a professional and high-quality server environment. At Knight Lobby, we continue to provide resources and support to assist private server developers.
