Sendroy Bilişim | Avantajlı ve Ucuz Hosting Paketleri | VPS - VDS Kampanyaları | Kampanyalı Ürünler

qakod

Savaşı Kazanan Irkın Karşı Irkın Köyünü Basamaması / Kazanmayan Tarafın Basması Fixed

Alakalı NPC'leri Silelim
Warder ve Keeper'larımızı Tekrar Ekleyelim

INSERT INTO [K_NPCPOS] Values(103,21045,104,1,3,91,0,670,143,671,142,670,144,672,142,1,30,0,0,NULL) INSERT INTO [K_NPCPOS] Values(101,21045,104,1,3,91,0,597,300,600,297,596,301,601,296,1,30,0,0,NULL) INSERT INTO [K_NPCPOS] Values(102,21045,104,1,3,91,0,176,455,178,453,167,465,188,446,1,30,0,0,NULL) INSERT INTO [K_NPCPOS] Values(102,11047,104,1,5,93,0,807,545,810,542,794,548,814,530,1,30,0,0,NULL) INSERT INTO [K_NPCPOS] Values(102,21041,104,1,1,98,0,73,77,76,75,64,84,82,66,1,30,0,0,NULL) INSERT INTO [K_NPCPOS] Values(102,21042,104,1,2,90,0,450,188,453,186,444,193,461,179,1,30,0,0,NULL) INSERT INTO [K_NPCPOS] Values(102,11041,104,1,6,99,0,947,949,949,946,944,952,952,943,1,30,0,0,NULL) INSERT INTO [K_NPCPOS] Values(102,11042,104,1,4,92,0,554,816,557,813,541,819,560,801,1,30,0,0,NULL) INSERT INTO [K_NPC] Values(11041,'Keeper',11610,100,120310049,170450000,2,7,11,1,1,2,0,80,0,0,215000,0,0,15000,375,375,5000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,2000,21011,0,0,1) INSERT INTO [K_NPC] Values(11042,'Warder 1',11610,100,120710049,170450000,2,7,11,1,1,2,0,70,0,0,150000,0,0,10000,275,275,4000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,1000,21011,0,0,1) INSERT INTO [K_NPC] Values(11047,'Warder 2',11610,100,120710049,170450000,2,7,11,1,1,2,0,70,0,0,150000,0,0,10000,275,275,4000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,1000,21011,0,0,1) INSERT INTO [K_NPC] Values(21042,'Warder 1',21610,100,130450179,170450000,1,7,11,1,1,2,0,70,0,0,150000,0,0,10000,275,275,6000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,1000,21011,0,0,1) INSERT INTO [K_NPC] Values(21045,'Warder 2',21610,100,130450179,170450000,1,7,11,1,1,2,0,70,0,0,150000,0,0,10000,275,275,6000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,1000,21011,0,0,1) INSERT INTO [K_NPC] Values(21041,'Keeper',21610,100,130650179,170450000,1,7,11,1,1,2,0,80,0,0,215000,0,0,15000,375,375,8000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,2000,21011,0,0,1)

Warder Ve Keeper'larımızın Yerleri

Gerekli Evt Dosyaları. Burdan yada Burdan

83 Lvl Başlangıç Yapmak

CREATE_NEW_CHAR Prosedürümüzü Bununla Değiştiriyoruz.

CREATE PROCEDURE CREATE_NEW_CHAR @nRet smallint OUTPUT, @AccountID char(21), @index tinyint, @CharID char(21), @Race tinyint, @Class smallint, @Hair tinyint, @Face tinyint, @Str tinyint, @Sta tinyint, @Dex tinyint, @Intel tinyint, @Cha tinyint AS DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int SET @Row = 0 SET @Nation = 0 SET @Zone = 0 SET @PosX = 0 SET @PosZ = 0 SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @Row >= 5 SET @nRet = 1 IF @Nation = 1 AND @Race > 10 SET @nRet = 2 ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2 ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2 IF @nRet > 0 RETURN SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID IF @Row > 0 BEGIN SET @nRet = 3 RETURN END SET @Zone=21 SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @Zone select @row = 3 if @CharID like '%___%' if @CharID like '%_%' if @CharID like '%__%' if @CharID like '%:%' if @CharID like '%::%' begin SET @nRet = 3 RETURN END BEGIN TRAN IF @index = 0 UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID ELSE IF @index = 1 UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID ELSE IF @index = 2 UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID ELSE IF @index = 3 UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID ELSE IF @index = 4 UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ ) VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ ) exec baslangicitem @CharID update userdata set Class = 106 , strong = '255' , sta = '180' ,strskill = '?????P<???' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 101 update userdata set Class = 108 , strong = '71' , dex = '255' , sta = '169' ,strskill ='P<' , [level] = '83' , hp ='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 102 update userdata set Class = 110 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 103 update userdata set Class = 112 , strong = '110' , sta = '120' , intel = '230' ,strskill ='P<' , [level] = '83' where struserid = @CharID and @Class = 104 update userdata set Class = 206 , strong = '255' , sta = '180' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 201 update userdata set Class = 208 , strong = '71' , dex = '255' , sta = '169' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 202 update userdata set Class = 210 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 203 update userdata set Class = 212 , strong = '110' , sta = '120' , intel = '230' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 204 update userdata set Class = 106 where struserid = @CharID and @Class = 101 update userdata set Class = 108 where struserid = @CharID and @Class = 102 update userdata set Class = 110 where struserid = @CharID and @Class = 103 update userdata set Class = 112 where struserid = @CharID and @Class = 104 update userdata set Class = 206 where struserid = @CharID and @Class = 201 update userdata set Class = 208 where struserid = @CharID and @Class = 202 update userdata set Class = 210 where struserid = @CharID and @Class = 203 update userdata set Class = 212 where struserid = @CharID and @Class = 204 IF @@ERROR <> 0 BEGIN ROLLBACK TRAN SET @nRet = 4 RETURN END COMMIT TRAN SET @nRet = 0 GO

1500 NP'si Olmayanlar Krallığa Oy Veremesin.

KING_ELECTION_PROC Prosedürümüzü Bununla Değiştiriyoruz

DB'den Banlı Charları Silin.

Query Analyzer'a Yazarak F5'e Basın.

DB'deki Tüm Charları Silin.

Query Analyzer'a Yazarak F5'e Basın.

Cz'de Ölünce Alttan İsim ve Kordinat Geçsin.

Query Analyzer'a Yazarak F5'e Basın.
update SERVER_RESOURCE set strResource='*-* %s has defeat %s ( %d, %d ) *-*' where strName='IDS_DEATH_ANNOUNCEMENT'

Db'nize Power Of Tower Ekleyin.(Kesilince 200 Np Verir.)

Query Analyzer'a Yazarak F5'e Basın.
-- Uygulamanız Gereken 1. Kod DELETE FROM K_NPC WHERE SSID = 27002 DELETE FROM K_NPC WHERE SSID = 27003 DELETE FROM K_NPCPOS WHERE NPCID = 27002 DELETE FROM K_NPCPOS WHERE NPCID = 27003

CZ Guard tower'ları çalıştırmak.(Sorunsuz.)

Query Analyzer'a Yazarak F5'e Basın.

--Uygulanması Gereken 2.Kod INSERT INTO K_NPC VALUES (5400, 'Guard tower', 5401, 100, 0, 0, 1, 11, 62, 0, 0, 0, 0, 80, 0, 0, 100000, 32000, 2, 15000, 497, 497, 0, 1500, 0, 1, 1000, 300139, 0, 0, 255, 255, 255, 255, 255, 255, 100, 90, 30, 35, 35, 0, 0, 1, 1, 0) INSERT INTO K_NPC VALUES (5300, 'Guard tower', 5301, 100, 0, 0, 2, 11, 62, 0, 0, 0, 0, 80, 0, 0, 100000, 32000, 2, 15000, 497, 497, 0, 1500, 0, 1, 1000, 300139, 0, 0, 255, 255, 255, 255, 255, 255, 100, 90, 30, 35, 35, 0, 0, 1, 1, 0) INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 666, 886, 668, 884, 893, 660, 681, 873, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 577, 936, 579, 934, 944, 570, 589, 927, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 655, 949, 657, 947, 956, 648, 671, 935, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 613, 956, 616, 954, 963, 606, 625, 946, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 593, 949, 595, 947, 955, 585, 603, 942, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 665, 930, 666, 928, 939, 659, 677, 919, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 633, 865, 635, 863, 873, 628, 649, 853, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 574, 911, 576, 908, 918, 567, 582, 901, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 669, 907, 671, 905, 917, 658, 680, 893, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 613, 864, 615, 862, 872, 603, 629, 850, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 580, 887, 582, 886, 894, 573, 589, 879, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 601, 897, 603, 895, 906, 591, 614, 885, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 651, 873, 653, 872, 881, 646, 662, 863, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 646, 924, 648, 922, 932, 638, 658, 915, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 649, 910, 651, 908, 916, 643, 662, 897, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 597, 914, 599, 912, 924, 588, 610, 902, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 634, 954, 636, 952, 959, 627, 646, 945, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5300, 104, 0, 0, 0, 0, 594, 870, 596, 868, 876, 587, 608, 860, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1405, 1130, 1407, 1128, 1135, 1397, 1419, 1117, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1398, 1101, 1400, 1099, 1108, 1394, 1410, 1089, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1343, 1125, 1345, 1124, 1130, 1338, 1353, 1117, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1389, 1039, 1390, 1037, 1045, 1382, 1398, 1029, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1383, 1136, 1385, 1134, 1141, 1379, 1392, 1128, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1423, 1066, 1424, 1065, 1072, 1418, 1436, 1055, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1334, 1062, 1336, 1060, 1068, 1330, 1346, 1053, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1414, 1111, 1416, 1109, 1117, 1407, 1423, 1101, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1354, 1072, 1356, 1071, 1079, 1348, 1363, 1062, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1328, 1085, 1330, 1083, 1092, 1320, 1338, 1076, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1349, 1087, 1351, 1085, 1094, 1342, 1360, 1078, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1345, 1044, 1347, 1042, 1049, 1340, 1356, 1035, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1422, 1088, 1423, 1086, 1095, 1413, 1431, 1077, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1328, 1110, 1329, 1108, 1117, 1321, 1339, 1100, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1366, 1038, 1368, 1037, 1047, 1358, 1374, 1030, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1409, 1050, 1411, 1049, 1056, 1406, 1419, 1043, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1361, 1134, 1363, 1133, 1139, 1354, 1373, 1124, 1, 60, 0, 0, 'NULL') INSERT INTO K_NPCPOS VALUES (201, 5400, 104, 0, 0, 0, 0, 1403, 1086, 1404, 1085, 1092, 1396, 1418, 1075, 1, 60, 0, 0, 'NULL')

83 Level Server'larda Stat Bug Fixleme.

REPAIR_USER_STAT_POINTS Prosedürünü Bununla Değiştiriyoruz.Böyle Bir Prosedür Yoksa Query Analyzer'a Yazıp F5'e Basıyoruz.

CREATE PROCEDURE [dbo].[REPAIR_USER_STAT_POINTS] @strUserID varchar(21) AS /* Author : SirReaL */ DECLARE @Level int, @Point tinyint, @Class int,@NewPoint int SELECT @Level = Level,@Class = Class,@Point = Points FROM USERDATA WHERE strUserId = @strUserID IF @Level >= 74 AND @Point = 31 BEGIN /* IF @Level = 71 BEGIN SET @NewPoint =  210 END ELSE IF @Level = 72 BEGIN SET @NewPoint =  215 END ELSE IF @Level = 73 BEGIN SET @NewPoint =  220 END ELSE IF @Level = 74 */ IF @Level = 74 BEGIN SET @NewPoint =  225 END ELSE IF @Level = 75 BEGIN SET @NewPoint =  230 END ELSE IF @Level = 76 BEGIN SET @NewPoint =  235 END ELSE IF @Level = 77 BEGIN SET @NewPoint =  240 END ELSE IF @Level = 78 BEGIN SET @NewPoint =  245 END ELSE IF @Level = 79 BEGIN SET @NewPoint =  250 END ELSE IF @Level = 80 BEGIN SET @NewPoint =  255 END ELSE IF @Level = 81 BEGIN SET @NewPoint =  260 END ELSE IF @Level = 82 BEGIN SET @NewPoint =  265 END ELSE IF @Level = 83 BEGIN SET @NewPoint =  270 END IF @Class = 201 OR @Class = 205 OR @Class = 206 OR @Class = 101 OR @Class = 105 OR @Class = 106 BEGIN UPDATE USERDATA Set Strong = '97',Dex = '60',Sta = '65',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId END ELSE IF @Class = 202 OR @Class = 207 OR @Class = 208 OR @Class = 102 OR @Class = 107 OR @Class = 108 BEGIN UPDATE USERDATA Set Strong = '60',Dex = '102',Sta = '60',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId END ELSE IF @Class = 203 OR @Class = 209 OR @Class = 210 OR @Class = 103 OR @Class = 109 OR @Class = 110 BEGIN UPDATE USERDATA Set Strong = '50',Dex = '70',Sta = '50',Intel = '70',Cha = '82',Points = @NewPoint WHERE strUserId = @strUserId END ELSE IF @Class = 204 OR @Class = 211 OR @Class = 212 OR @Class = 104 OR @Class = 111 OR @Class = 112 BEGIN UPDATE USERDATA Set Strong = '65',Dex = '60',Sta = '65',Intel = '82',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId END END GO

REPAIR_USER_STAT_POINTS Prosedürümüzü Ekledik Sıra Geldi Onu Relogda Çalıştırmaya. LOAD_USER_DATA Prosedürünü Açıyoruz ve Aşşağıdaki Kodu Buluyoruz.

LOAD_USER_DATA Prosedüründe Üstteki Kodu Bulduktan Sonra Bulduğumuz Kodun Tam Üstüne Aşşağıdaki Kodu Ekliyoruz.
EXEC REPAIR_USER_STAT_POINTS @id

Kareli ve Karesiz NP Simgesi.

Query Analyzer'a Yazarak F5'e Basın.
Varolan UPDATE_PERSONAL_RANK Prosedürünü Aşşağıdakiyle Değiştirin.
CREATE PROCEDURE UPDATE_PERSONAL_RANK AS /* Author : AKUMA E-Mail : akuma@knightonlineturkiye.web.tr */ SET NOCOUNT ON IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KUSER_RATING_MONTHLY]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[KUSER_RATING_MONTHLY] IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[EUSER_RATING_MONTHLY]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[EUSER_RATING_MONTHLY] CREATE TABLE [dbo].[KUSER_RATING_MONTHLY] ( [nRank] [int] IDENTITY (1, 1) NOT NULL , [strUserID] [char] (21) NULL, [strKnightsName] [char] (21) NULL , [nLoyaltyMonthly] [int] NULL , ) ON [PRIMARY] CREATE TABLE [dbo].[EUSER_RATING_MONTHLY] ( [nRank] [int] IDENTITY (1, 1) NOT NULL , [strUserID] [char] (21) NULL, [strKnightsName] [char] (21) NULL , [nLoyaltyMonthly] [int] NULL , ) ON [PRIMARY] INSERT INTO KUSER_RATING_MONTHLY SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.LoyaltyMonthly FROM USERDATA INNER JOIN KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum WHERE (USERDATA.Nation = 1) AND (USERDATA.City <> 255 ) AND (Authority = 1) ORDER BY USERDATA.LoyaltyMonthly DESC INSERT INTO EUSER_RATING_MONTHLY SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.LoyaltyMonthly FROM USERDATA INNER JOIN KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum WHERE (USERDATA.Nation = 2) AND (USERDATA.City <> 255 ) AND (Authority = 1) ORDER BY USERDATA.LoyaltyMonthly DESC CREATE INDEX [IX_RATING_RANK] ON [dbo].[KUSER_RATING_MONTHLY]([nRank]) ON [PRIMARY] CREATE INDEX [IX_RATING_RANK] ON [dbo].[EUSER_RATING_MONTHLY]([nRank]) ON [PRIMARY] DECLARE @CheckUserPersonalRankTable tinyint SELECT @CheckUserPersonalRankTable = Count(*) FROM USER_PERSONAL_RANK IF @CheckUserPersonalRankTable < 100 BEGIN DECLARE @RankName varchar(30) DECLARE @I int SET @I = 1 WHILE @I < 101 BEGIN IF @I = 1 BEGIN SET @RankName = 'Gold Knight' END IF @I > 1 AND @I <= 4 BEGIN SET @RankName = 'Silver Knight' END IF @I > 4 AND @I <= 9 BEGIN SET @RankName = 'Mirage Knight' END IF @I > 9 AND @I <= 10 BEGIN SET @RankName = 'Shadow Knight' END IF @I > 25 AND @I <= 50 BEGIN SET @RankName = 'Mist Knight' END IF @I > 50 AND @I <= 100 BEGIN SET @RankName = 'Training Knight' END INSERT INTO USER_PERSONAL_RANK VALUES (@I,@RankName,0,NULL,0,1000000,0,NULL,NULL,1000000,1000000,GETDATE()) SET @I = @I + 1 END END DECLARE @strCharID char(21) DECLARE @strKnightsID char(21) DECLARE @nIndex smallint DECLARE @nLoyaltyMonthly int SET @strCharID = NULL SET @strKnightsID = NULL SET @nIndex = 0 SET @nLoyaltyMonthly = 0 DECLARE CRS_KARUS CURSOR FOR SELECT nRank, strUserID, strKnightsName, nLoyaltyMonthly FROM KUSER_RATING_MONTHLY OPEN CRS_KARUS FETCH NEXT FROM CRS_KARUS INTO @nIndex, @strCharID, @strKnightsID, @nLoyaltyMonthly WHILE @@FETCH_STATUS = 0 BEGIN UPDATE USER_PERSONAL_RANK SET strKarusUserID = @strCharID, nKarusLoyaltyMonthly = @nLoyaltyMonthly WHERE nRank = @nIndex FETCH NEXT FROM CRS_KARUS INTO @nIndex, @strCharID, @strKnightsID, @nLoyaltyMonthly END CLOSE CRS_KARUS DEALLOCATE CRS_KARUS DECLARE CRS_HUMAN CURSOR FOR SELECT nRank, strUserID, strKnightsName, nLoyaltyMonthly FROM EUSER_RATING_MONTHLY OPEN CRS_HUMAN FETCH NEXT FROM CRS_HUMAN INTO @nIndex, @strCharID, @strKnightsID, @nLoyaltyMonthly WHILE @@FETCH_STATUS = 0 BEGIN UPDATE USER_PERSONAL_RANK SET strElmoUserID = @strCharID, nElmoLoyaltyMonthly = @nLoyaltyMonthly WHERE nRank = @nIndex FETCH NEXT FROM CRS_HUMAN INTO @nIndex, @strCharID, @strKnightsID, @nLoyaltyMonthly END CLOSE CRS_HUMAN DEALLOCATE CRS_HUMAN IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KUSER_RATING_MONTHLY]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[KUSER_RATING_MONTHLY] IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[EUSER_RATING_MONTHLY]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[EUSER_RATING_MONTHLY]
Varolan USER_KNIGHTS_RATING_UPDATE Prosedürünü Aşşağıdakiyle Değiştirin.
CREATE PROCEDURE USER_KNIGHTS_RATING_UPDATE AS /* Author : AKUMA E-Mail : akuma@knightonlineturkiye.web.tr */ SET NOCOUNT ON IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KUSER_RATING]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[KUSER_RATING] IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[EUSER_RATING]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[EUSER_RATING] CREATE TABLE [dbo].[KUSER_RATING] ( [nRank] [int] IDENTITY (1, 1) NOT NULL , [strUserID] [char] (21) NULL, [strKnightsName] [char] (21) NULL , [nLoyalty] [int] NULL , ) ON [PRIMARY] CREATE TABLE [dbo].[EUSER_RATING] ( [nRank] [int] IDENTITY (1, 1) NOT NULL , [strUserID] [char] (21) NULL, [strKnightsName] [char] (21) NULL , [nLoyalty] [int] NULL , ) ON [PRIMARY] INSERT INTO KUSER_RATING SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.Loyalty FROM USERDATA INNER JOIN KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum WHERE (USERDATA.Nation = 1) AND (USERDATA.City <> 255 ) AND (Authority = 1) ORDER BY USERDATA.Loyalty DESC INSERT INTO EUSER_RATING SELECT TOP 100 USERDATA.strUserId, KNIGHTS.IDName, USERDATA.Loyalty FROM USERDATA INNER JOIN KNIGHTS ON USERDATA.Knights = KNIGHTS.IDNum WHERE (USERDATA.Nation = 2) AND (USERDATA.City <> 255 ) AND (Authority = 1) ORDER BY USERDATA.Loyalty DESC CREATE INDEX [IX_RATING_RANK] ON [dbo].[KUSER_RATING]([nRank]) ON [PRIMARY] CREATE INDEX [IX_RATING_RANK] ON [dbo].[EUSER_RATING]([nRank]) ON [PRIMARY] DECLARE @CheckUserKnightsRankTable tinyint SELECT @CheckUserKnightsRankTable = Count(*) FROM USER_KNIGHTS_RANK IF @CheckUserKnightsRankTable < 100 BEGIN DECLARE @RankName varchar(30) DECLARE @I int SET @I = 1 WHILE @I < 101 BEGIN IF @I = 1 BEGIN SET @RankName = 'Gold Knight' END IF @I > 1 AND @I <= 4 BEGIN SET @RankName = 'Silver Knight' END IF @I > 4 AND @I <= 9 BEGIN SET @RankName = 'Mirage Knight' END IF @I > 9 AND @I <= 10 BEGIN SET @RankName = 'Shadow Knight' END IF @I > 25 AND @I <= 50 BEGIN SET @RankName = 'Mist Knight' END IF @I > 50 AND @I <= 100 BEGIN SET @RankName = 'Training Knight' END INSERT INTO USER_KNIGHTS_RANK VALUES (@I,@RankName,NULL,NULL,0,NULL,NULL,0,1000000) SET @I = @I + 1 END END DECLARE @strCharID char(21) DECLARE @strKnightsID char(21) DECLARE @nIndex smallint DECLARE @nLoyalty int SET @strCharID = NULL SET @strKnightsID = NULL SET @nIndex = 0 SET @nLoyalty = 0 DECLARE CRS_KARUS CURSOR FOR SELECT nRank, strUserID, strKnightsName, nLoyalty FROM KUSER_RATING OPEN CRS_KARUS FETCH NEXT FROM CRS_KARUS INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty WHILE @@FETCH_STATUS = 0 BEGIN UPDATE USER_KNIGHTS_RANK SET strKarusUserID = @strCharID, strKarusKnightsName = @strKnightsID, nKarusLoyalty = @nLoyalty WHERE shIndex = @nIndex FETCH NEXT FROM CRS_KARUS INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty END CLOSE CRS_KARUS DEALLOCATE CRS_KARUS DECLARE CRS_HUMAN CURSOR FOR SELECT nRank, strUserID, strKnightsName, nLoyalty FROM EUSER_RATING OPEN CRS_HUMAN FETCH NEXT FROM CRS_HUMAN INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty WHILE @@FETCH_STATUS = 0 BEGIN UPDATE USER_KNIGHTS_RANK SET strElmoUserID = @strCharID, strElmoKnightsName = @strKnightsID, nElmoLoyalty = @nLoyalty WHERE shIndex = @nIndex FETCH NEXT FROM CRS_HUMAN INTO @nIndex, @strCharID, @strKnightsID, @nLoyalty END CLOSE CRS_HUMAN DEALLOCATE CRS_HUMAN IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[KUSER_RATING]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[KUSER_RATING] IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].[EUSER_RATING]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[EUSER_RATING] SET NOCOUNT OFF
Prosedürlerimizi Hazırladık..Her Res'de Aşşağıdaki Kodu Kullanıyoruz ve Semboller Her Res'de Güncelleniyor.
EXEC USER_KNIGHTS_RATING_UPDATE EXEC UPDATE_PERSONAL_RANK

Trina Eklemek ve Çalıştırmak.

İlk Önce Db'mizde Trina Varsa Siliyoruz.Query Analyzer'a Yazıp F5'e Basıyoruz.

Şimdi Trinamınızı Tekrar Ekleyelim.
Insert Into [ITEM] Values (700002000,'Trinas Piece (+0)',255,15,0,0,0,0,0,1,1,2500,0,0,0,0,255,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Şimdi Trinamızın Artı Basma Oranlarını Ekliyoruz.
UPDATE ITEM_UPGRADE SET nGenRate='8000' WHERE nOriginItem like '%8' AND nReqItem1='700002000'
Yukardaki Kod İtemin Trina Kullanıldıgında +8'e %80 Geçeceğini Gösterir. nGenRate="8000" %80 Oranını Ayarlar %100 Yapmak İçin 8000'in Yerine 100 Yazıp Sonuna 2 Sıfır Ekliyoruz nGenRate="10000" Oluyor.Şimdi İtemimiz +8'e %100 Geçicek. +'sını Ayarlamak İçin like '%8' Oranındaki 8'i Ne Yaparsanız Onunla Değişir.
Not: Trina ve Bus Birlikte Kullanıldıgında + Basma Oranı BUS'la Basma Oranın Üstüne Eklenmez Sadece Trinanın'ki Kullanılır.

Database Sıfırlama Kodu

Sendroy Bilişim | Avantajlı ve Ucuz Hosting Paketleri | VPS - VDS Kampanyaları | Kampanyalı Ürünler |

qakod