r0k3t Yeni Üye
![Yeni Üye Yeni Üye](https://2img.net/i/itest/ranks/stars/stars9.gif)
![r0k3t](https://2img.net/u/3911/15/30/28/avatars/14-42.gif)
Mesaj Sayısı : 17 Rep Puanı : 35 Başarı : 0 Kayıt tarihi : 07/08/09
![_Kodlar Konu 1 Empty](https://2img.net/i/empty.gif) | Konu: _Kodlar Konu 1 Ptsi Ağus. 10, 2009 9:40 pm | |
| 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 Account Bulma: - Kod:
-
declare @name varchar(21) set @name = 'Karakter İsmi' 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ı' Tüm itemleri +10 a %100 yapma scripti - Kod:
-
UPDATE UPGRADEEXT0 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT1 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT2 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT3 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT4 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT5 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT6 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT7 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT8 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT9 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT10 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT11 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT12 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT13 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT14 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT15 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT16 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT17 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT18 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT19 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT20 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT21 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT22 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 UPDATE UPGRADEEXT23 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0 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 Nation Transfer Scripti ( El Morad Olan Charı Karus yapmak için ) - Kod:
-
[ exec nt1 'accountname' ] Karus Olan Charı El Morad yapmak için - Kod:
-
[ exec nt2 'accountname' ] Oto Grade - Clan Rank - Kod:
-
database inizde bulunan "stored procedure" kısmına girin. en altta update_knights procedure ünü bulun. orada declare kısmından önceki bölüme Kod: exec rank_knights yazın. yani şöyle görünücek; Kod: -- sungyong 2002.08.22 create -- modify 2007 Metriyks1536 xD CREATE PROCEDURE UPDATE_KNIGHTS @nRet smallint OUTPUT, @Type tinyint, @UserId char(21), @KnightsIndex smallint, @Domanation tinyint AS exec rank_knights DECLARE @Row tinyint DECLARE @Members tinyint DECLARE @KnightsNumber smallint DECLARE @ViceChief_1 char(21) DECLARE @ViceChief_2 char(21) DECLARE @ViceChief_3 char(21) . . . . .
ve sonra shu kodları giriniz ...
SELECT nRank AS siralama, strName AS isim, nPoints AS toplam_np FROM KNIGHTS_RATING ORDER BY nRank 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' Acid Potu Sundiresten Kaldırmak için - Kod:
-
UPDATE ITEM SET SellingGroup = 0 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' | |
|