[Paylasim] Yararli Toplanmis Kod ve Programlar

[huntraser]

Topliyim dedim bugunlerde Bana kiziyosaniz soleyin :haha::haha::haha:

Aylik Np sifirlamak 1 kisinin :
update userdata set LoyaltyMonthly = '0'
where struserid = 'Char Nick'

Kill GM event yapmak GM e tiklamak.:

update userdata set authority = '9'
where struserid = 'Char Nick'

Np sifirlamak :
update userdata set Loyalty = '0'
where struserid = 'Char Nick'

Parasini sifirlamak
update userdata set Gold = '0'
where struserid = 'Char Nick'

Chari GM yapmak
update userdata set Authority = '0'
where struserid = 'Char Nick'

Chari Banlamak
update userdata set Authority = '255'
where struserid = 'Char Nick'

Chari Normal user yapmak
update userdata set Authority = '1'
where struserid = 'Char Nick'

Skill - Stat Editlemek :
update Userdata set Strong = '255'where struserid = 'Char Nick'
update Userdata set Sta = '255'where struserid = 'Char Nick'
update Userdata set Dex = '255'where struserid = 'Char Nick'
update Userdata set intel = '255'where struserid = 'Char Nick'
update Userdata set Cha = '255'where struserid = 'Char Nick'
update Userdata set strskill = '250'where struserid = 'Char Nick'

Acid Potion - Holy Water - Abys Blesing Kulanimi kapamak :
update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank = '1' where Num = '379104000'
update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank = '1' where Num = '389083000'
update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank = '1' where Num = '389010000'
update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank = '1' where Num = '910012000'
update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank = '1' where Num = '379101000'
update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank = '1' where Num = '379102000'
update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank = '1' where Num = '379103000'

Acid Potion - Holy Water - Abys blesing DB den Silmek :
Delete from item
where num = '379101000' 
delete from item
where num = '379102000' 
delete from item
where num = '379103000'
delete from item
where num = '389083000'

Sinirsiz Mana,Can Pot yapmak :
update magic set useitem='0' where useitem='389014000'
update magic set useitem='0' where useitem='389082000'

Tower Damage Ayarlamak: (Bu durumda 2-2.5k vuracaktir.)
UPDATE    MAGIC_TYPE3
SET              FirstDamage = - 20000
WHERE     (iNum = 300139)

Mage 72 Skil Damage Ayarlamak: (Bu durumda 1k ya yakin vurur)
update magic_type1
set hit = '1750'
where inum like '110_72'
update magic_type1
set hit = '1750'
where inum like '210_72'

Sorunsuz Duzgun Fix. NTS :
http://www.ko-cuce.com/prosedurler-kodlar/4862-paylasim-nts-full-fix.html

Gmler Icin Gereken Tum Kodlar :
http://www.ko-cuce.com/genel/4897-paylasim-gm-lerin-isine-yaricak-butun-kodlar.html

Tum Charlari Maradona Atmak :
update Userdata set zone = '21'

Drop 0 Lama :
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'

Ring Of Bash Eklemek :
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)

Critic Atagini artirmak : (Dex degeri yerine 100 ustu bi deger girin artar.)
Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '108685'
Update MAGIC_TYPE4 Set Dex = 'dexdegeri' WHERE iNum = '208685'

Stat Sifirlama Sorunu Cozum :
http://www.ko-cuce.com/prosedurler-kodlar/940-paylasim-stat-sifirlatma-sorununa-relogda-cozum.html

Tamamen Fixlenmis Karali Karesi Np simgeleri :
http://www.ko-cuce.com/prosedurler-kodlar/1807-paylasim-tamamiyle-fixlenmis-en-duzgun-kareli-ve-karesiz-np-simgesi.html

CZ tower calistirmak Dikkatimi cekti burda hp si 100k Kolayca kesilebilir.

Kod 3 te bulunan :
INSERT INTO K_NPC ( [sSid], [strName], [sPid], [sSize], [iWeapon1], [iWeapon2], [byGroup], [byActType], [byType], [byFamily], [byRank], [byTitle], [iSellingGroup], [sLevel], [iExp], [iLoyalty], [iHpPoint], [sMpPoint], [sAtk], [sAc], [sHitRate], [sEvadeRate], [sDamage], [sAttackDelay], [bySpeed1], [bySpeed2], [sStandtime], [iMagic1], [iMagic2], [iMagic3], [sFireR], [sColdR], [sLightningR], [sMagicR], [sDiseaseR], [sPoisonR], [sLightR], [sBulk], [byAttackRange], [bySearchRange], [byTracingRange], [iMoney], [sItem], [byDirectAttack], [byMagicAttack], [byMoneyType] ) VALUES ( 5400, 'Guard tower', 5401, 100, 0, 0, 1, 0, 62, 1, 1, 1, 0, 90, 0, 0, 100000, 0, 0, 15000, 497, 497, 0, 1500, 0, 0, 1000, 300139, 0, 0, 255, 255, 255, 255, 255, 255, 255, 200, 30, 35, 35, 0, 0, 1, 1, 0 );
INSERT INTO K_NPC ( [sSid], [strName], [sPid], [sSize], [iWeapon1], [iWeapon2], [byGroup], [byActType], [byType], [byFamily], [byRank], [byTitle], [iSellingGroup], [sLevel], [iExp], [iLoyalty], [iHpPoint], [sMpPoint], [sAtk], [sAc], [sHitRate], [sEvadeRate], [sDamage], [sAttackDelay], [bySpeed1], [bySpeed2], [sStandtime], [iMagic1], [iMagic2], [iMagic3], [sFireR], [sColdR], [sLightningR], [sMagicR], [sDiseaseR], [sPoisonR], [sLightR], [sBulk], [byAttackRange], [bySearchRange], [byTracingRange], [iMoney], [sItem], [byDirectAttack], [byMagicAttack], [byMoneyType] ) VALUES ( 5300, 'Guard tower', 5301, 100, 0, 0, 2, 0, 62, 1, 1, 1, 0, 90, 0, 0, [COLOR="Red"]100000[/COLOR], 0, 0, 15000, 497, 497, 0, 1500, 0, 0, 1000, 300139, 0, 0, 255, 255, 255, 255, 255, 255, 255, 200, 30, 35, 35, 0, 0, 1, 1, 0 );

Orda kirmiziyla yazilmis 100000 leri degistirin ole koyun Towerlarin HP sini ayarliyabilirsiniz. Orjinal 1m Hp dir.
http://www.ko-cuce.com/prosedurler-kodlar/116-paylasim-human-towerlari-calistirmak-damage-ayarlamak.html

Tum Item Kodlar:
http://www.ko-cuce.com/prosedurler-kodlar/886-tum-item-kodlari.html


LVL kontrollu ardream:
http://www.ko-cuce.com/prosedurler-kodlar/2683-paylasim-level-ve-class-kontrollu-andream-2.html

OTO GRADE:

/****** Object:  Stored Procedure dbo.RANK_KNIGHTS    Script Date: 6/6/2006 6:03:32 PM ******/


/******  ??: ?? ???? dbo.RANK_KNIGHTS    ????  ??: 2002-11-14 ?? 11:18:04 ******/
-- Created by sungyong 2002.10.14

/** Edit by webmsn */

CREATE PROCEDURE RANK_KNIGHTS
AS

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 Ranking>0

-- 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 MASTER:

-- OTO MASTER START
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
-- OTO MASTER END

TUM DB YI TEMIZLEMEK:
http://www.ko-cuce.com/prosedurler-kodlar/3554-server-0lama-kodu.html

Archery 35k bug cozum:

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

PROGRAMLAR:


Atilla user editor:
http://www.ko-cuce.com/programlar/4351-atilla-user-editor.html

Avci invetory Editor: (eline saglik super olmus kardes)
http://www.ko-cuce.com/programlar/3711-avci-inventory-editor.html

Denediklerimden En duzgun olani Drop Editor:
http://www.ko-cuce.com/programlar/1209-paylasim-drop-editor-kesinlikle-tavsiye-ederim.html

Database yedekleyemeyenler icin Yedekleme programi:
http://www.ko-cuce.com/programlar/4274-yedekcibasi-v1-0-kolay-veritabani-yedegi-alin.html

Trayhoper drop editor:
http://www.ko-cuce.com/programlar/1864-trayhoper-drop-editor-alaninda-en-iyisi-kolaylikta-olay.html

En duzgun Maradon-Luferson-EMC Map editor:
http://www.ko-cuce.com/programlar/2500-paylasim-luferson-emc-moradon-map-editor-saglam-linkler.html

Benim gibi ram sorunu olanlar icin Forumda olan Program:
http://www.ko-cuce.com/programlar/1324-server-processer-trayhoper-server-kesintilerine-son.html

 

[•ReBorNOFDeviL•]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Erim
Sağol

Maho

 

[huntraser]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Aha ha ha

 

[selcuk165]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

sağol kardeş

 

[storm]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Kill GM event yapmak GM e tiklamak.:

update userdata set authority = '9'
where struserid = 'Char Nick'

bişi dicem bunu yaptım gm normal userden farksız oluyor kod kullanamıyor fakat üzerine tıklanıyor bi ark. da 250 demişti ondada gm görünmüo her kodu kullanamıyor ve muteli sorun dbdenmidir yoksa ekstra prosedürmü gerekli

 

[_WurucU_]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

tşkler hepsı bı arada guzel olmuş

 

[EmreOzcan]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Tesekkürler...

 

[CaRLoSuLo]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

saoL hepsi veriLdi ama sen derleyip toparlamışın bi arada vermişin eline sağLık

 

[ozzani]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

teşekkürler

 

[LidyaAdmin]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Teşekkürler Paylaşım İçin.

 

[Maxis]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

SaooLL '''

 

[BLaDeOfMaStEr]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Teşekkürler

 

[be187]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Güzel olmuş, sağol.

 

[Metehan]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Tesekkurler

 

[ßyRealing]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Teşekkürler

 

[themhaso]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

çok saol güzel paylaşım

 

[marvell]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

eline saglık

 

[:SHaDoW:]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

Yararlı bilgile

 

[qrknrmk11]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

paylasım ıcın ty

 

[4Lord:]

Cevap: [Paylasim] Yararli Toplanmis Kod ve Programlar

teşekkkürler..