adiyosb4by
Mesaj Sayısı : 62 Kayıt tarihi : 08/05/10
![Tüm Query Anlyezer Kodları Empty](https://2img.net/i/empty.gif) | Konu: Tüm Query Anlyezer Kodları C.tesi Mayıs 08, 2010 11:12 pm | |
| 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)
| |
|