By_Hasan
Admin
Başarı Puanı
Canlılık:
    (125/125)
Deneyim:
 (127/127)
Tecrübe:
 (126/126)
 | Konu: İşinize Yariyacak Bazi Kodlar  Salı 16 Haz. 2009, 11:05 pm | |
| Charın İsmini Değiştirme - Kod:
-
EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKICHARADI,'YENICHARADI' Charın Irkını Değiştirme-(Irk Numaraları = 1 karus 2 human) - Kod:
-
EXEC ACCOUNT_NATION_CHANGE 'HESABINIDSI','IRKNUMARASI' Symbol Ve Clan Güncellemeleri.(Server Kapalıyken) - Kod:
-
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights 1440 pot ve abys bles silmek için ; - 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') ACİD POTLARI SİLMEK İÇİN; - Kod:
-
DELETE item
WHERE num = '389015000'
go
DELETE item
WHERE num = '389064000'
go
DELETE item
WHERE num = '910005000' CHARI FULL EDİT YAPMAK İÇİN - Kod:
-
update Userdata set strskill = 'ÿ'where struserid = 'Char N DB DEN BÜTÜN CHARLARI SİLMEK İÇİN - 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 DB YEDEKLEMEK İÇİN–(Bu Kodu Kopyalamadan Önce C: Klasöründe KODB Adlı Klasör Oluşturun Oraya DB’Yi Oraya Kopyalıyacak) - Kod:
-
set @location = N'c:\KoDB\Gokhantasci-'+replace(str(year(getdate()))+'-'+str(month(getdate()))+'-'+str(day(getdate())),' ', '')+'.bak'
BACKUP DATABASE [Kn_Online] TO DISK = @location WITH NOFORMAT, INIT, NAME = N'KO-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'Kn_Online' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'Kn_Online' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''Kn_Online'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = @location WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO DROPLARI 0 LAMAK İÇİN - 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' EXP ARTTİRMAK İÇİN - Kod:
-
update k_monster
set iexp = iexp*5 CHARIN STATLARINI FULL 255 YAPMAK İÇİN - Kod:
-
update Userdata set strskill = 'ÿ'where struserid = 'Char Nick' BİR CHARI GM YAPMAK İÇİN - Kod:
-
update userdata set Authority = '0'
where struserid = 'Karakter İsmi' GUARD TOWER DMG AYARI İÇİN-(Set FirstDamageyi 10000 yaparsanız kuleler 1-2 k vurur)
- Kod:
-
UPDATE MAGIC_TYPE3
SET FirstDamage = 1000
WHERE (iNum = 300139) HOLY WATER I DB DEN KALDIRMAK İÇİN - 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' MAGE SKİLERİNİ GÜCLENDİRMEK İÇİN
- Kod:
-
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 109551)
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 110551)
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 209551) USERLARIN NP LERINI 0 LAMAK İÇİN
- Kod:
-
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1 BANLANAN OYUNCULARIN NP LERINI 0 LAMAK İÇİN - Kod:
-
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255 OKCULARIN 32K DMG BUGU İÇİN - Kod:
-
update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5 TÜM CHARLARI MARADONA ATMAK İÇİN - Kod:
-
update Userdata set zone = '21' | |
|
