X
xantos
Guest
Offline
Bu Kod +15'den +35'e kadar olan itemlerin hepsini +15'e sabitler. Bu kod bug olan serverlar içindir. Kodu kendinize göre düzenleyebilirsiniz.
Kod:
USE SRO_VT_SHARD
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '15', '15')WHERE OptLevel LIKE '15';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '16', '15')WHERE OptLevel LIKE '16';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '17', '15')WHERE OptLevel LIKE '17';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '18', '15')WHERE OptLevel LIKE '18';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '19', '15')WHERE OptLevel LIKE '19';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '20', '15')WHERE OptLevel LIKE '20';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '21', '15')WHERE OptLevel LIKE '21';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '22', '15')WHERE OptLevel LIKE '22';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '23', '15')WHERE OptLevel LIKE '23';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '24', '15')WHERE OptLevel LIKE '24';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '25', '15')WHERE OptLevel LIKE '25';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '26', '15')WHERE OptLevel LIKE '26';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '27', '15')WHERE OptLevel LIKE '27';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '28', '15')WHERE OptLevel LIKE '28';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '29', '15')WHERE OptLevel LIKE '29';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '30', '15')WHERE OptLevel LIKE '30';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '31', '15')WHERE OptLevel LIKE '31';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '32', '15')WHERE OptLevel LIKE '32';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '33', '15')WHERE OptLevel LIKE '33';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '34', '15')WHERE OptLevel LIKE '34';
UPDATE [dbo].[_Items]SET OptLevel = replace(OptLevel, '35', '15')WHERE OptLevel LIKE '35';