alikvp
Center Üyesi
- Katılım
- 28 Eyl 2023
- Mesajlar
- 20
- Tepkime puanı
- 0
- Puanları
- 1
- Yaş
- 35
- Konum
- Bolu
- Web sitesi
- www.trdeserver.com
Kod:
USE [SRO_VT_SHARD]
--Alikvp tarafından düzenlendi. Sadece Europe'leri 110Level'e maxlar
DECLARE @CharName varchar(255)
DECLARE @CharID INT
--Alikvp tarafından düzenlendi. Sadece Europe'leri 110Level'e maxlar
SET @CharName='Master__' --Alikvp tarafından düzenlendi. Sadece Europe'leri 110Level'e maxlar
--Alikvp tarafından düzenlendi. Sadece Europe'leri 110Level'e maxlar
SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName --Alikvp tarafından düzenlendi. Sadece Europe'leri 110Level'e maxlar
Declare @Irk int=(select RefObjID from _Char where CharID=@CharID)
--Alikvp tarafından düzenlendi. Sadece Europe'leri 110Level'e maxlar
UPDATE _CharSkillMastery SET Level = '120' WHERE CharID=@CharID and MasteryID <520 --Alikvp tarafından düzenlendi. Sadece Europe'leri1 110Level'e maxlar
--Alikvp tarafından düzenlendi. Sadece Europe'leri 110Level'e maxlar
IF(@Irk>3000)
BEGIN
delete from _CharSkill where CharID=@CharID
INSERT INTO _CharSkill VALUES (@CharID,1,1)
INSERT INTO _CharSkill VALUES (@CharID,8419,1)
INSERT INTO _CharSkill VALUES (@CharID,8420,1)
INSERT INTO _CharSkill VALUES (@CharID,8421,1)
INSERT INTO _CharSkill VALUES (@CharID,9354,1)
INSERT INTO _CharSkill VALUES (@CharID,9355,1)
INSERT INTO _CharSkill VALUES (@CharID,11162,1)
INSERT INTO _CharSkill VALUES (@CharID,10625,1)
INSERT INTO _CharSkill VALUES (@CharID,9944,1)
INSERT INTO _CharSkill VALUES (@CharID,11526,1)
INSERT INTO _CharSkill VALUES (@CharID,8438,1)
INSERT INTO _CharSkill VALUES (@CharID,8449,1)
INSERT INTO _CharSkill VALUES (@CharID,8467,1)
INSERT INTO _CharSkill VALUES (@CharID,8477,1)
INSERT INTO _CharSkill VALUES (@CharID,8499,1)
INSERT INTO _CharSkill VALUES (@CharID,8513,1)
INSERT INTO _CharSkill VALUES (@CharID,8524,1)
INSERT INTO _CharSkill VALUES (@CharID,8531,1)
INSERT INTO _CharSkill VALUES (@CharID,8545,1)
INSERT INTO _CharSkill VALUES (@CharID,8558,1)
INSERT INTO _CharSkill VALUES (@CharID,8572,1)
INSERT INTO _CharSkill VALUES (@CharID,8583,1)
INSERT INTO _CharSkill VALUES (@CharID,8597,1)
INSERT INTO _CharSkill VALUES (@CharID,8626,1)
INSERT INTO _CharSkill VALUES (@CharID,8647,1)
INSERT INTO _CharSkill VALUES (@CharID,8659,1)
INSERT INTO _CharSkill VALUES (@CharID,8669,1)
INSERT INTO _CharSkill VALUES (@CharID,8697,1)
INSERT INTO _CharSkill VALUES (@CharID,8710,1)
INSERT INTO _CharSkill VALUES (@CharID,8723,1)
INSERT INTO _CharSkill VALUES (@CharID,8752,1)
INSERT INTO _CharSkill VALUES (@CharID,8775,1)
INSERT INTO _CharSkill VALUES (@CharID,8812,1)
INSERT INTO _CharSkill VALUES (@CharID,8829,1)
INSERT INTO _CharSkill VALUES (@CharID,8881,1)
INSERT INTO _CharSkill VALUES (@CharID,8894,1)
INSERT INTO _CharSkill VALUES (@CharID,8904,1)
INSERT INTO _CharSkill VALUES (@CharID,8932,1)
INSERT INTO _CharSkill VALUES (@CharID,8961,1)
INSERT INTO _CharSkill VALUES (@CharID,8974,1)
INSERT INTO _CharSkill VALUES (@CharID,8997,1)
INSERT INTO _CharSkill VALUES (@CharID,9034,1)
INSERT INTO _CharSkill VALUES (@CharID,9042,1)
INSERT INTO _CharSkill VALUES (@CharID,9073,1)
INSERT INTO _CharSkill VALUES (@CharID,9102,1)
INSERT INTO _CharSkill VALUES (@CharID,9115,1)
INSERT INTO _CharSkill VALUES (@CharID,9125,1)
INSERT INTO _CharSkill VALUES (@CharID,9143,1)
INSERT INTO _CharSkill VALUES (@CharID,9172,1)
INSERT INTO _CharSkill VALUES (@CharID,9187,1)
INSERT INTO _CharSkill VALUES (@CharID,9212,1)
INSERT INTO _CharSkill VALUES (@CharID,9249,1)
INSERT INTO _CharSkill VALUES (@CharID,9262,1)
INSERT INTO _CharSkill VALUES (@CharID,9285,1)
INSERT INTO _CharSkill VALUES (@CharID,9322,1)
INSERT INTO _CharSkill VALUES (@CharID,9339,1)
INSERT INTO _CharSkill VALUES (@CharID,9364,1)
INSERT INTO _CharSkill VALUES (@CharID,9369,1)
INSERT INTO _CharSkill VALUES (@CharID,9373,1)
INSERT INTO _CharSkill VALUES (@CharID,9378,1)
INSERT INTO _CharSkill VALUES (@CharID,9382,1)
INSERT INTO _CharSkill VALUES (@CharID,9388,1)
INSERT INTO _CharSkill VALUES (@CharID,9392,1)
INSERT INTO _CharSkill VALUES (@CharID,9397,1)
INSERT INTO _CharSkill VALUES (@CharID,9400,1)
INSERT INTO _CharSkill VALUES (@CharID,9407,1)
INSERT INTO _CharSkill VALUES (@CharID,9411,1)
INSERT INTO _CharSkill VALUES (@CharID,9417,1)
INSERT INTO _CharSkill VALUES (@CharID,9421,1)
INSERT INTO _CharSkill VALUES (@CharID,9428,1)
INSERT INTO _CharSkill VALUES (@CharID,9430,1)
INSERT INTO _CharSkill VALUES (@CharID,9437,1)
INSERT INTO _CharSkill VALUES (@CharID,9438,1)
INSERT INTO _CharSkill VALUES (@CharID,9444,1)
INSERT INTO _CharSkill VALUES (@CharID,9449,1)
INSERT INTO _CharSkill VALUES (@CharID,9453,1)
INSERT INTO _CharSkill VALUES (@CharID,9454,1)
INSERT INTO _CharSkill VALUES (@CharID,9481,1)
INSERT INTO _CharSkill VALUES (@CharID,9489,1)
INSERT INTO _CharSkill VALUES (@CharID,9499,1)
INSERT INTO _CharSkill VALUES (@CharID,9516,1)
INSERT INTO _CharSkill VALUES (@CharID,9528,1)
INSERT INTO _CharSkill VALUES (@CharID,9544,1)
INSERT INTO _CharSkill VALUES (@CharID,9574,1)
INSERT INTO _CharSkill VALUES (@CharID,9587,1)
INSERT INTO _CharSkill VALUES (@CharID,9601,1)
INSERT INTO _CharSkill VALUES (@CharID,9612,1)
INSERT INTO _CharSkill VALUES (@CharID,9623,1)
INSERT INTO _CharSkill VALUES (@CharID,9631,1)
INSERT INTO _CharSkill VALUES (@CharID,9672,1)
INSERT INTO _CharSkill VALUES (@CharID,9686,1)
INSERT INTO _CharSkill VALUES (@CharID,9703,1)
INSERT INTO _CharSkill VALUES (@CharID,9714,1)
INSERT INTO _CharSkill VALUES (@CharID,9721,1)
INSERT INTO _CharSkill VALUES (@CharID,9736,1)
INSERT INTO _CharSkill VALUES (@CharID,9742,1)
INSERT INTO _CharSkill VALUES (@CharID,9770,1)
INSERT INTO _CharSkill VALUES (@CharID,9785,1)
INSERT INTO _CharSkill VALUES (@CharID,9798,1)
INSERT INTO _CharSkill VALUES (@CharID,9844,1)
INSERT INTO _CharSkill VALUES (@CharID,9868,1)
INSERT INTO _CharSkill VALUES (@CharID,9880,1)
INSERT INTO _CharSkill VALUES (@CharID,9897,1)
INSERT INTO _CharSkill VALUES (@CharID,9940,1)
INSERT INTO _CharSkill VALUES (@CharID,9951,1)
INSERT INTO _CharSkill VALUES (@CharID,9956,1)
INSERT INTO _CharSkill VALUES (@CharID,9965,1)
INSERT INTO _CharSkill VALUES (@CharID,9972,1)
INSERT INTO _CharSkill VALUES (@CharID,10001,1)
INSERT INTO _CharSkill VALUES (@CharID,10017,1)
INSERT INTO _CharSkill VALUES (@CharID,10030,1)
INSERT INTO _CharSkill VALUES (@CharID,10042,1)
INSERT INTO _CharSkill VALUES (@CharID,10047,1)
INSERT INTO _CharSkill VALUES (@CharID,10062,1)
INSERT INTO _CharSkill VALUES (@CharID,10070,1)
INSERT INTO _CharSkill VALUES (@CharID,10076,1)
INSERT INTO _CharSkill VALUES (@CharID,10078,1)
INSERT INTO _CharSkill VALUES (@CharID,10106,1)
INSERT INTO _CharSkill VALUES (@CharID,10122,1)
INSERT INTO _CharSkill VALUES (@CharID,10135,1)
INSERT INTO _CharSkill VALUES (@CharID,10162,1)
INSERT INTO _CharSkill VALUES (@CharID,10167,1)
INSERT INTO _CharSkill VALUES (@CharID,10182,1)
INSERT INTO _CharSkill VALUES (@CharID,10190,1)
INSERT INTO _CharSkill VALUES (@CharID,10201,1)
INSERT INTO _CharSkill VALUES (@CharID,10206,1)
INSERT INTO _CharSkill VALUES (@CharID,10234,1)
INSERT INTO _CharSkill VALUES (@CharID,10264,1)
INSERT INTO _CharSkill VALUES (@CharID,10280,1)
INSERT INTO _CharSkill VALUES (@CharID,10296,1)
INSERT INTO _CharSkill VALUES (@CharID,10307,1)
INSERT INTO _CharSkill VALUES (@CharID,10323,1)
INSERT INTO _CharSkill VALUES (@CharID,10415,1)
INSERT INTO _CharSkill VALUES (@CharID,10489,1)
INSERT INTO _CharSkill VALUES (@CharID,10493,1)
INSERT INTO _CharSkill VALUES (@CharID,10521,1)
INSERT INTO _CharSkill VALUES (@CharID,10537,1)
INSERT INTO _CharSkill VALUES (@CharID,10550,1)
INSERT INTO _CharSkill VALUES (@CharID,10562,1)
INSERT INTO _CharSkill VALUES (@CharID,10567,1)
INSERT INTO _CharSkill VALUES (@CharID,10582,1)
INSERT INTO _CharSkill VALUES (@CharID,10604,1)
INSERT INTO _CharSkill VALUES (@CharID,10621,1)
INSERT INTO _CharSkill VALUES (@CharID,10623,1)
INSERT INTO _CharSkill VALUES (@CharID,10652,1)
INSERT INTO _CharSkill VALUES (@CharID,10659,1)
INSERT INTO _CharSkill VALUES (@CharID,10687,1)
INSERT INTO _CharSkill VALUES (@CharID,10705,1)
INSERT INTO _CharSkill VALUES (@CharID,10733,1)
INSERT INTO _CharSkill VALUES (@CharID,10748,1)
INSERT INTO _CharSkill VALUES (@CharID,10774,1)
INSERT INTO _CharSkill VALUES (@CharID,10787,1)
INSERT INTO _CharSkill VALUES (@CharID,10807,1)
INSERT INTO _CharSkill VALUES (@CharID,10818,1)
INSERT INTO _CharSkill VALUES (@CharID,10831,1)
INSERT INTO _CharSkill VALUES (@CharID,10837,1)
INSERT INTO _CharSkill VALUES (@CharID,10847,1)
INSERT INTO _CharSkill VALUES (@CharID,10852,1)
INSERT INTO _CharSkill VALUES (@CharID,10861,1)
INSERT INTO _CharSkill VALUES (@CharID,10865,1)
INSERT INTO _CharSkill VALUES (@CharID,10873,1)
INSERT INTO _CharSkill VALUES (@CharID,10876,1)
INSERT INTO _CharSkill VALUES (@CharID,10904,1)
INSERT INTO _CharSkill VALUES (@CharID,10916,1)
INSERT INTO _CharSkill VALUES (@CharID,10944,1)
INSERT INTO _CharSkill VALUES (@CharID,10963,1)
INSERT INTO _CharSkill VALUES (@CharID,10972,1)
INSERT INTO _CharSkill VALUES (@CharID,10976,1)
INSERT INTO _CharSkill VALUES (@CharID,10987,1)
INSERT INTO _CharSkill VALUES (@CharID,10992,1)
INSERT INTO _CharSkill VALUES (@CharID,11002,1)
INSERT INTO _CharSkill VALUES (@CharID,11006,1)
INSERT INTO _CharSkill VALUES (@CharID,11011,1)
INSERT INTO _CharSkill VALUES (@CharID,11015,1)
INSERT INTO _CharSkill VALUES (@CharID,11042,1)
INSERT INTO _CharSkill VALUES (@CharID,11072,1)
INSERT INTO _CharSkill VALUES (@CharID,11086,1)
INSERT INTO _CharSkill VALUES (@CharID,11097,1)
INSERT INTO _CharSkill VALUES (@CharID,11108,1)
INSERT INTO _CharSkill VALUES (@CharID,11117,1)
INSERT INTO _CharSkill VALUES (@CharID,11128,1)
INSERT INTO _CharSkill VALUES (@CharID,11133,1)
INSERT INTO _CharSkill VALUES (@CharID,11143,1)
INSERT INTO _CharSkill VALUES (@CharID,11147,1)
INSERT INTO _CharSkill VALUES (@CharID,11154,1)
INSERT INTO _CharSkill VALUES (@CharID,11160,1)
INSERT INTO _CharSkill VALUES (@CharID,11189,1)
INSERT INTO _CharSkill VALUES (@CharID,11199,1)
INSERT INTO _CharSkill VALUES (@CharID,11210,1)
INSERT INTO _CharSkill VALUES (@CharID,11217,1)
INSERT INTO _CharSkill VALUES (@CharID,11245,1)
INSERT INTO _CharSkill VALUES (@CharID,11261,1)
INSERT INTO _CharSkill VALUES (@CharID,11284,1)
INSERT INTO _CharSkill VALUES (@CharID,11295,1)
INSERT INTO _CharSkill VALUES (@CharID,11300,1)
INSERT INTO _CharSkill VALUES (@CharID,11311,1)
INSERT INTO _CharSkill VALUES (@CharID,11321,1)
INSERT INTO _CharSkill VALUES (@CharID,11337,1)
INSERT INTO _CharSkill VALUES (@CharID,11340,1)
INSERT INTO _CharSkill VALUES (@CharID,11351,1)
INSERT INTO _CharSkill VALUES (@CharID,11356,1)
INSERT INTO _CharSkill VALUES (@CharID,11363,1)
INSERT INTO _CharSkill VALUES (@CharID,11366,1)
INSERT INTO _CharSkill VALUES (@CharID,11376,1)
INSERT INTO _CharSkill VALUES (@CharID,11380,1)
INSERT INTO _CharSkill VALUES (@CharID,11387,1)
INSERT INTO _CharSkill VALUES (@CharID,11389,1)
INSERT INTO _CharSkill VALUES (@CharID,11400,1)
INSERT INTO _CharSkill VALUES (@CharID,11432,1)
INSERT INTO _CharSkill VALUES (@CharID,11445,1)
INSERT INTO _CharSkill VALUES (@CharID,11464,1)
INSERT INTO _CharSkill VALUES (@CharID,11472,1)
INSERT INTO _CharSkill VALUES (@CharID,11480,1)
INSERT INTO _CharSkill VALUES (@CharID,11486,1)
INSERT INTO _CharSkill VALUES (@CharID,11492,1)
INSERT INTO _CharSkill VALUES (@CharID,11497,1)
INSERT INTO _CharSkill VALUES (@CharID,11503,1)
INSERT INTO _CharSkill VALUES (@CharID,11507,1)
INSERT INTO _CharSkill VALUES (@CharID,11513,1)
INSERT INTO _CharSkill VALUES (@CharID,11516,1)
INSERT INTO _CharSkill VALUES (@CharID,11522,1)
INSERT INTO _CharSkill VALUES (@CharID,11524,1)
INSERT INTO _CharSkill VALUES (@CharID,11553,1)
INSERT INTO _CharSkill VALUES (@CharID,11583,1)
INSERT INTO _CharSkill VALUES (@CharID,11599,1)
INSERT INTO _CharSkill VALUES (@CharID,11611,1)
INSERT INTO _CharSkill VALUES (@CharID,11620,1)
INSERT INTO _CharSkill VALUES (@CharID,11627,1)
INSERT INTO _CharSkill VALUES (@CharID,11632,1)
INSERT INTO _CharSkill VALUES (@CharID,11642,1)
INSERT INTO _CharSkill VALUES (@CharID,11648,1)
INSERT INTO _CharSkill VALUES (@CharID,11666,1)
INSERT INTO _CharSkill VALUES (@CharID,11684,1)
INSERT INTO _CharSkill VALUES (@CharID,11692,1)
INSERT INTO _CharSkill VALUES (@CharID,11702,1)
INSERT INTO _CharSkill VALUES (@CharID,11709,1)
INSERT INTO _CharSkill VALUES (@CharID,11719,1)
INSERT INTO _CharSkill VALUES (@CharID,11726,1)
INSERT INTO _CharSkill VALUES (@CharID,11742,1)
INSERT INTO _CharSkill VALUES (@CharID,11750,1)
INSERT INTO _CharSkill VALUES (@CharID,11766,1)
INSERT INTO _CharSkill VALUES (@CharID,11776,1)
INSERT INTO _CharSkill VALUES (@CharID,11782,1)
INSERT INTO _CharSkill VALUES (@CharID,11791,1)
INSERT INTO _CharSkill VALUES (@CharID,11795,1)
INSERT INTO _CharSkill VALUES (@CharID,11805,1)
INSERT INTO _CharSkill VALUES (@CharID,11809,1)
INSERT INTO _CharSkill VALUES (@CharID,11816,1)
INSERT INTO _CharSkill VALUES (@CharID,11818,1)
INSERT INTO _CharSkill VALUES (@CharID,11823,1)
INSERT INTO _CharSkill VALUES (@CharID,11830,1)
INSERT INTO _CharSkill VALUES (@CharID,11849,1)
INSERT INTO _CharSkill VALUES (@CharID,11867,1)
INSERT INTO _CharSkill VALUES (@CharID,11882,1)
INSERT INTO _CharSkill VALUES (@CharID,11893,1)
INSERT INTO _CharSkill VALUES (@CharID,11901,1)
INSERT INTO _CharSkill VALUES (@CharID,11913,1)
INSERT INTO _CharSkill VALUES (@CharID,11918,1)
INSERT INTO _CharSkill VALUES (@CharID,11929,1)
INSERT INTO _CharSkill VALUES (@CharID,11934,1)
INSERT INTO _CharSkill VALUES (@CharID,11943,1)
INSERT INTO _CharSkill VALUES (@CharID,11952,1)
INSERT INTO _CharSkill VALUES (@CharID,11961,1)
INSERT INTO _CharSkill VALUES (@CharID,11968,1)
INSERT INTO _CharSkill VALUES (@CharID,11978,1)
INSERT INTO _CharSkill VALUES (@CharID,11984,1)
INSERT INTO _CharSkill VALUES (@CharID,11993,1)
INSERT INTO _CharSkill VALUES (@CharID,11997,1)
INSERT INTO _CharSkill VALUES (@CharID,21225,1)
INSERT INTO _CharSkill VALUES (@CharID,30186,1)
INSERT INTO _CharSkill VALUES (@CharID,30193,1)
INSERT INTO _CharSkill VALUES (@CharID,30197,1)
INSERT INTO _CharSkill VALUES (@CharID,30215,1)
INSERT INTO _CharSkill VALUES (@CharID,30224,1)
INSERT INTO _CharSkill VALUES (@CharID,30243,1)
INSERT INTO _CharSkill VALUES (@CharID,30249,1)
END