Tüm Query Anlyezer Kodları

Mesaj Sayısı : 62 Kayıt tarihi : 08/05/10

Char Tahttan Kalkmıyor Diyenler için Sql Scripti

Kod:
insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','1500 0','2','101','Dark Lunar')
insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','1500 0','2','0','BATTLE_ZONE???')
insert into [ZONE_INFO] Values ('1','201','free_0810.smd','15000','15000','15000' ,'2','0','Colony Zone')
update ZONE_INFO set ServerNo = '1'

Charı Gm Yapma Scripti

Kod:
update userdata set Authority = '0'
where struserid = 'Karakter ismi'

Charı Normal Char Yapma Scripti

Kod:
update userdata set Authority = '1'
where struserid = 'Karakter İsmi'

Charı Banlama Scripti

Kod:
update userdata set Authority = '255'
where struserid = 'Karakter İsmi'

AC Kıyafetleri DB'den Kaldırmak:

Kod:
Databaseden Item_Ext 13, 14, 15, 16 ve 17 Tablolarından :
41-50 Arasını => 41 Ve 50 Dahil
71-80 Arasını => 71 Ve 80 Dahil
541-550 Arasını => 541 Ve 550 Dahil
304-309 Arasını => 304 Ve 309 Dahil
313-318 Arasını => 313 Ve 318 Dahil
322-327 Arasını => 322 Ve 327 Dahil
331-336 Arasını => 331 Ve 336 Dahil
hepsini siLiniz!

NCS Aktif etmek için

Kod:
create procedure [NameChange]
(@oldname varchar(30),@newname varchar(30))
AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)
begin tran
Update account_char set strcharid1 = @newname where strcharid1 = @oldname
Update account_char set strcharid2 = @newname where strcharid2 = @oldname
Update account_char set strcharid3 = @newname where strcharid3 = @oldname
Update userdata set struserid = @newname Where struserid = @oldname
Update knights_user set struserid = @newname Where struserid = @oldname
Update knights set chief = @newname where chief = @oldname
Update knights set vicechief_1 = @newname where vicechief_1 = @oldname
Update knights set vicechief_2 = @newname where vicechief_2 = @oldname
Update knights set vicechief_3 = @newname where vicechief_3 = @oldname
commit tran

Account Bulma:

Kod:
declare @name varchar(21)
set @name = 'Karakter İsmi'

Kod:
SELECT * from ACCOUNT_CHAR
where strcharid1 = @name
or strcharid2 = @name
or strcharid3 = @name

Ban'lanan Üyelerin NP'lerini Sıfırlamak:

Kod:
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255

Unuqe itemlerin storedaki fıyatını arttırma

Kod:
update item_basic
SET iPriceSale = 2150000000
WHERE (bySellGroup = 0)

Full Character Edit:

Kod:
update userdata set Strong = '255',Sta = '255',Dex = '255',Intel = '255',Cha = '255', Level = '100',Loyalty = '100000000',Points = '255',Gold = '2100000000'
where struserid = 'Karakter İsmi'

Herkese 21 GB verme

Kod:
update userdata set gold = '2100000000'

İstediğiniz Account'un Item'lerini Silin:

Kod:
UPDATE warehouse
SET WareHouseData = ''
WHERE strAccountID = 'Hesap Adı'

CZ'deki Kuleleri Aktif Yapmak:

Kod:
6701 Guard tower 5301 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6701 0 0 0
6751 Guard tower 5401 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6751 0 0 0
9001 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9001 0 0 4
9002 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9002 0 0 4
9003 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9003 0 0 4
9004 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9004 0 0 4

Delos İçin

Kod:
insert into [K_WARPINFO] Values (21,316,'Delos','Delos Desert',5000,30,529,5,253,5)
insert into [K_WARPINFO] Values (21,416,'Delos','Delos Desert',5000,30,529,5,253,5)
insert into [K_WARPINFO] Values (30,321,'Moradon','Delos Zone',0,21,315,0,400,10)
insert into [K_WARPINFO] Values (30,301,'Moradon','Delos Zone',0,21,315,0,400,10)
insert into [K_OBJECTEVENT] Values (30,4030,1,0,5,30,1,650,0,650)
insert into [K_OBJECTEVENT] Values (30,4031,1,0,5,32,1,550,0,255)
insert into [EVENT] Values (30,2001,0,1,1,1,1,1,32,529,253,1,1)
insert into [EVENT] Values (30,2002,0,1,1,1,1,1,32,529,253,1,1)
insert into [ZONE_INFO] Values (2,30,'elmorad_1212.smd',15000,15000,15000,1,0,'wa r_a_ch')
insert into [ZONE_INFO] Values (2,32,'elmorad_1212.smd',15000,15000,15000,1,0,'du ngeon_b1_th')

Nation Transfer Scripti ( El Morad Olan Charı Karus yapmak için için )

Kod:
El Morad Olan Çarı Karus Yapma
[ exec nt1 'accountname' ]

Kod:
Karus Olan Charı El Morad yapmak için için
[ exec nt2 'accountname' ]

CZ'deki Kuleleri Aktif Yapmak:

Kod:
6701 Guard tower 5301 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6701 0 0 0
6751 Guard tower 5401 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6751 0 0 0
9001 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9001 0 0 4
9002 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9002 0 0 4
9003 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9003 0 0 4
9004 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9004 0 0 4

Karus Kadın Mage Yapımı

Kod:
1-) Usko(ROFD)'nun Item Dosyasını Kendi Serverimizin Item Dosyasıyla Değiştiriyoruz.
2-) Oyunda Bir Priest Açıyoruz.
3-) Enterprise Manager'den USERDATA Tablosunu Açıyoruz.
4-) Priestimizi Bulup Classını 109 Olarak Değiştiriyoruz...

Acid Potu Sunderastan Kaldırmak

Kod:
UPDATE ITEM SET SellingGroup = 0 Where Num = 389083000

1440 Pot ve Abyys Bless i silmek

Kod:
DELETE FROM ITEM
WHERE (Num = '379102000')
DELETE FROM ITEM
WHERE (Num = '379103000')
DELETE FROM ITEM
WHERE (Num = '379105000')
DELETE FROM ITEM
WHERE (Num = '379104000')
DELETE FROM ITEM
WHERE (Num = '379102000')
DELETE FROM ITEM
WHERE (Num = '379101000')

abyss holy waterları silme

Kod:
Delete from item
where num = '379101000'
delete from item
where num = '379102000'
delete from item
where num = '379103000'
delete from item
where num = '379108000'
delete from item
where num = '379113000'
delete from item
where num = '379098000'
delete from item
where num = '389015000'
delete from item
where num = '389064000'
delete from item
where num = '910005000'
delete from item
where num = '389083000'

Critical Atack Ayar

Kod:
Human Critical:
Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '108685'

Kod:
Orc Critical:
Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '208685'

Drop Sıfırlama

Kod:
update k_monster_item set iItem01 = '0'
update k_monster_item set iItem02 = '0'
update k_monster_item set iItem03 = '0'
update k_monster_item set iItem04 = '0'
update k_monster_item set iItem05 = '0'

Guard Tower Damage Ayarlama

Kod:
UPDATE MAGIC_TYPE3
SET FirstDamage = 1000(istediğiniz kadar yazabilirsiniz Damageyi)
WHERE (iNum = 300139)

Irk seçme ekranında kalıyorsa

Kod:
insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','1500 0','2','101','Dark Lunar')
insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','1500 0','2','0','BATTLE_ZONE???')
insert into [ZONE_INFO] Values ('1','201','free_0810.smd','15000','15000','15000' ,'2','0','Colony Zone')
update ZONE_INFO set ServerNo = '1'

Mage 72 Skili

Kod:
update magic_type1
set hit = '10000'
where inum like '110_72'
update magic_type1
set hit = '10000'
where inum like '210_72'

Mage skill edit(atack Arttırma)

Kod:
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 109551)

Kod:
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 110551)
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 209551)

NP sıfırlama

Kod:
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1

BANLANAN OYUNCULARIN NPlerini SİLMEK İÇİN

Kod:
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255

Okcu 32 K bugu

Kod:
update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5

Oto Master

Kod:
/****** Object: Stored Procedure dbo.LOAD_USER_DATA Script Date: 6/6/2006 6:03:33 PM ******/
/****** ??: ?? ???? dbo.LOAD_USER_DATA ???? ??: 2002-11-14 ?? 11:18:04 ******/
-- modifed by bluemansiiz 2008.05.09
-- 2004.04.22 ????LoyaltyMonthly) ?? arycoat
CREATE PROCEDURE LOAD_USER_DATA
@AccountID char(21),
@id char(21),
@nRet smallint OUTPUT
AS
-- inserted by samma 2003.07.10
DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21)
DECLARE @True smallint
SET @charid1 = null
SET @charid2 = null
SET @charid3 = null
SET @True = 0
SET @nRet = 0
/*
DECLARE @nPlayGameUserCount TINYINT
SET @nPlayGameUserCount = 0
SELECT @nPlayGameUserCount = COUNT(*) FROM [192.168.178.30].[knight_Account].[dbo].[CURRENTUSER] WHERE strAccountID = @AccountID
IF @nPlayGameUserCount > 0
BEGIN
SET @nRet = 0
RETURN
END
*/
SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @id = @charid1 or @id = @charid2 or @id = @charid3
SET @True = 1
IF @True = 0
BEGIN
SET @nRet = 0
RETURN
END
-- inserted by samma 2003.07.10
DECLARE @class char(21)
set @class = (select class from userdata where struserid = @id)
if @class = 105
begin
update userdata set class = 106 where struserid = @id
end
if @class = 107
begin
update userdata set class = 108 where struserid = @id
end
if @class = 109
begin
update userdata set class = 110 where struserid = @id
end
if @class = 111
begin
update userdata set class = 112 where struserid = @id
end
if @class = 205
begin
update userdata set class = 206 where struserid = @id
end
if @class = 207
begin
update userdata set class = 208 where struserid = @id
end
if @class = 209
begin
update userdata set class = 210 where struserid = @id
end
if @class = 211
begin
update userdata set class = 212 where struserid = @id
end
SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,
Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
FROM USERDATA WHERE strUserId = @id
SET @nRet = @@RowCount
exec rundupecheck2 @id
if @id='Shlt' or @id ='DammKengKar'
BEGIN
INSERT INTO USER_LOG_KOR (strcharID, byType, updateTime) VALUES (@id, 1, getdate() )
END
RETURN
GO

Oto Grade

Kod:
Object Stored Procedure dbo.RANK_KNIGHTS Script Date 662006 60332 PM

Kod:
?? ?? ???? dbo.RANK_KNIGHTS ???? ?? 2002-11-14 ?? 111804
-- Created by bluemansiiz 2008.5.12
Edit by bluemansiiz
CREATE PROCEDURE RANK_KNIGHTS
AS
exec rank_knights
SET NOCOUNT ON
DECLARE @KnightsIndex smallint
DECLARE @SumLoyalty int
DECLARE job1 CURSOR FOR
SELECT IDNum FROM KNIGHTS
OPEN job1
FETCH NEXT FROM job1
INTO @KnightsIndex
WHILE @@fetch_status = 0
BEGIN
if @SumLoyalty is null
begin
SET @SumLoyalty = 0
end
SELECT @SumLoyalty=Sum(Loyalty) FROM USERDATA WHERE Knights = @KnightsIndex and City 255
IF @SumLoyalty 0
UPDATE KNIGHTS SET Points = @SumLoyalty WHERE IDNum = @KnightsIndex
FETCH NEXT FROM job1
INTO @KnightsIndex
END
CLOSE job1
DEALLOCATE job1
SET NOCOUNT OFF
-- ranking
UPDATE KNIGHTS SET Ranking=0 WHERE Ranking0
-- ranking procedure call
EXEC KNIGHTS_RATING_UPDATE
DECLARE @Knights_1 smallint
DECLARE @Knights_2 smallint
DECLARE @Knights_3 smallint
DECLARE @Knights_4 smallint
DECLARE @Knights_5 smallint
SELECT @Knights_1 = shIndex FROM KNIGHTS_RATING WHERE nRank=1
SELECT @Knights_2 = shIndex FROM KNIGHTS_RATING WHERE nRank=2
SELECT @Knights_3 = shIndex FROM KNIGHTS_RATING WHERE nRank=3
SELECT @Knights_4 = shIndex FROM KNIGHTS_RATING WHERE nRank=4
SELECT @Knights_5 = shIndex FROM KNIGHTS_RATING WHERE nRank=5
UPDATE KNIGHTS SET Ranking=1 WHERE IDNum=@Knights_1
UPDATE KNIGHTS SET Ranking=2 WHERE IDNum=@Knights_2
UPDATE KNIGHTS SET Ranking=3 WHERE IDNum=@Knights_3
UPDATE KNIGHTS SET Ranking=4 WHERE IDNum=@Knights_4
UPDATE KNIGHTS SET Ranking=5 WHERE IDNum=@Knights_5
GO

Oto Üyelik

Kod:
CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
delete from currentuser where straccountid = @AccountID
---Coded By Bluemansiiz---
declare @cnt BigInt
declare @nDays smallint
select @nRet = count(straccountid) from tb_user where straccountid = @AccountID

Kod:
if @nRet = 0
begin
insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6')
end
select @cnt = count(straccountid) from currentuser
select @nDays = count(nDays) from PREMIUM_SERVICE where straccountid = @AccountID
if @cnt > 40 and @nDays = '0'
begin
set @nRet = 0
end
if @cnt > 40 and @nDays = null
begin
set @nRet = 0
end
DECLARE @Nation tinyint
SET @Nation = 0
-- tid login method by samma 2004.02.24
DECLARE @pwd varchar(13)
SET @pwd = null
SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END
ELSE IF @pwd @Password
BEGIN
SET @nRet = 0
RETURN
END
SELECT @Nation = bNation FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = @Nation+1
RETURN
END
GO

Premium yazan Yerin Yerine İsteğini yaz

[code]

/permanent yaz ebenezer e enterle isteğini yaz

[code]

Acid Potu Sunderastan Kaldırmak

Kod:
UPDATE ITEM SET SellingGroup = 0 Where Num = 389083000

90/1 Yapma

Kod:
update LEVEL_UP set Exp = '1'

Bütün İtemlerin Ağılık İstememesi

Kod:
update ITEM set Weight = '0'

Npc + larını Belirleme Ordaki 199009 sonunda 9 +9 oluo 7 yaparsanız +7 olur...

Kod:
update K_NPC set iSellingGroup = '199009'
where strName = 'Npc İsmi'

NCS SCripti

Kod:
Exec NameChange 'EskiIsim', 'YeniIsim'

TB_Userdan Kısa Acc silme

Kod:
delete from tb_user where straccountid = 'char ismi'

Magicden Kısa Skill Silmesi ......

Kod:
delete from magic where magicnum = 'skill kodu'

Sadece Server I. Karus ve I.El moya [D] sembol ekleme

Kod:
CREATE PROCEDURE np_icon
AS
DECLARE
--This script has been made by BERKİN GÜLER in 12.09.2007
--Bu script BERKİN GÜLER tarafından 12.09.2007 tarihinde yapılmıştır
@berkin varchar(100),
@cigdm varchar(100),
@i int
BEGIN TRANSACTION
SELECT @berkin=strUserID FROM USERDATA WHERE Nation = '1' ORDER BY Loyalty
UPDATE USERDATA SET strUserID = '[D]' + @berkin WHERE strUserID = @berkin
SELECT @cigdm=strUserID FROM USERDATA WHERE Nation = '2' ORDER BY Loyalty
UPDATE USERDATA SET strUserID = '[D]' + @cigdm WHERE strUserID = @cigdm
IF @@error0
begin
rollback transaction
print 'Hata oluştu!'
end
else
begin
print 'ICON EKLEME ISLEMI BASARILI.'
print @berkin + 've' + @cigdm + ',' + '[D]' + @berkin + 've' + '[D]' + @cigdm + 'olarak degistirildi!'
end
COMMIT TRANSACTION
GO

30 Görewini İmha etmek

Kod:
delete from K_NPCPOS where NpcID = '21044'

50 Görewini İmha Etmek

Kod:
delete from K_NPCPOS where NpcID = '16051'
delete from K_NPCPOS where NpcID = '16052'
delete from K_NPCPOS where NpcID = '16053'
delete from K_NPCPOS where NpcID = '16054'
delete from K_NPCPOS where NpcID = '16055'
delete from K_NPCPOS where NpcID = '16056'
delete from K_NPCPOS where NpcID = '16057'

+10 ve +9 İtemleri Silme

Kod:
DELETE from ITEM
WHERE strName LIKE '%+9%'
DELETE from ITEM
WHERE strName LIKE '%+10%'

Databasenizdeki tüm çarları silmek isterseniz buyrun

Kod:
truncate table account_char
truncate table currentuser
truncate table deleted_userdata
truncate table knights
truncate table knights_rating
truncate table knights_user
truncate table tb_user
truncate table userdata
truncate table warehouse

Exp'i 50'ye katlamak isteyenler için (50 yazan yere istediğinizi yazabilirsiniz )

Kod:
UPDATE K_MONSTER
SET iexp = iexp*50

çarınıza daha sağlam çar yapmak için yani

Ring Of Bash Eklemek için . Yapmanız gerekenler. '' Alıntıdır . ''

İlk önce itemimizi Db'mize ekliyoruz.

Kod:
INSERT INTO [ITEM] Values (999999990,' Ring OF Bash',91 ,10, 0, 0 ,350, 100 ,0 ,1 ,15000, 1200, 0, 2000, 0 ,0 ,0 ,1, 99 ,0 ,0 ,0 ,0, 0, 0, 0 ,0 ,5 ,0 ,0 ,50 ,50 ,50 ,50 ,50 ,50 ,255 ,255 ,255 ,255 ,255 ,255 ,255 ,255 ,0 ,150 ,75 ,75 ,75 ,75 ,75 ,75 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000)

Bu kodu yazdıktan sonra db'mize eklemiş oluyoruz. Bunun drobu yada bu item görünmüyor . Bu itemi ancak İnvertory editlemeyle takabiliyoruz.

İnvertory editlemeyi anlatmaya zamanım yok daha sonra onuda ya***am resimli ayrıntılı ve pratik yöntemle anlatıcam .

Eğer bilen varsa invertory editlemesini onlar için alın item

Kod:
999999990

Mesela uprate ayarlarını zor yapmak istiyorum diyenler . Yani +7 - +8

biraz zor olsun ama +9-+10 imkansız olsun . Diyenler varsa bu kodla yapabilirsiniz. Buyrun

Kod:
UPDATE ITEM_UPGRADE
SET nGenRate = 10000
WHERE (nReqItem1 = 379021000) AND (nGenRate = 7000)
UPDATE ITEM_UPGRADE
SET nGenRate = 10000
WHERE (nReqItem1 = 379021000) AND (nGenRate = 6000)
UPDATE ITEM_UPGRADE
SET nGenRate = 10000
WHERE (nReqItem1 = 379021000) AND (nGenRate = 3000)
UPDATE ITEM_UPGRADE
SET nGenRate = 10000
WHERE (nReqItem1 = 379021000) AND (nGenRate = 500)
UPDATE ITEM_UPGRADE
SET nGenRate = 30
WHERE (nReqItem1 = 379021000) AND (nGenRate = 200)
UPDATE ITEM_UPGRADE
SET nGenRate = 20
WHERE (nReqItem1 = 379021000) AND (nGenRate = 100)
UPDATE ITEM_UPGRADE
SET nGenRate = 10
WHERE (nReqItem1 = 379021000) AND (nGenRate = 0)