PVP SERVERLER FORUM
Would you like to react to this message? Create an account in a few clicks or log in to continue.
PVP SERVERLER FORUM

You are not connected. Please login or register

Beyaban DB v1 (Anti Cheats + Map + Patch) [Andream DB]

Go down  Message [Page 1 of 1]

***mahmut***

avatar
Admin
Admin

Database Özellikleri:


* Oto Üyelik
* Potlar sınırlı.
* Oto Master ( 60)
* Ally bugu Vb. yok.
* JAPKO & Korea İtemleri Ekli.
* CZ de Potcular Ekli.
* Eslant'ta potcular ekli.
* CZ de Ronark Moument Ekli.
* Stat bugu fix, relogda stat düzeliyor.
* Prize Fix, Ebenezer kapanma durumu yok.
* CZ Guard Towerleri 1000-2000 arası vuruyor.
* Delosa 1. Clanın Bayrağı Konuluyor Her Resette.
* Andream Guard Towerleri 1000-2000 arası vuruyor.
* Tüm karakterler eşit o fazla vuruyor, bu fazla vuruyor yok.
* Maradonda 2 Tane Banka var, Usko stil, Biri Human Biri Karus.
* Andream guard towerler eklidir, npcleri eklidir. (usko style)
* Andream ekli, emc ve lüfersonda giriş npcsi var, giriş (30-59)
* Oyun içi NCS aktif 1 adet NCS ile oyun içi ncs yapabiliyorsunuz.
* 30 lvl e kadar ezik charlar konuşamaz. (mute-küfür engellemek amaçlı)
* El morad & Lüfersonda Guard of Tower ekli savaşlarda ayrı bir zevk oluyor.
* GM'ler relogda edit, clanı bozulur, 21GB para verilir, 80 lvl olur, NP'si 100 e düşer.
* 100-500 NP alımı 58-80 lvl arasıdır (NPT engel)
* Andreamda [Andream] Quest ekli, 5 Stone of Paramun ve Stone of Brahman karşılığı Classa göre 8 silah veriliyor..
* Maradonda [Peddler] Hemes ekli name change var, valkyrie, gryphon, bahamut certificate götürüp set alabiliyorsunuz.
* EMC & Lüfersonda Exchange Manager ekli, 10k np karşılığı ncs, valkyrie, gryphon, bahamut certificate alabiliyorsunuz
* LwL Sınırı 59


Upgrade Oranı (İtem)

1 = 0
2 = 0
3 = 0
4 = 0
5 = 0
6 = 0
7 = 0
8 =
9 = %5
10 = %1


Upgrade Takı Oranları

1 = 0
2 =
3 = 
4 = %5
5 = %1


Güncelleme Kodları

--GRADE-SEMBOL RESETI
EXEC USER_KNIGHTS_RATING_UPDATE
EXEC UPDATE_PERSONAL_RANK
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights

--- TUM CLANLAR G1
update Knights set Points = '999999'



* Eğer open2 (Lunar War) sorun verirse aşağıdaki kodları kullanın.


Kullanım:


* Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.
* SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.
* Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.



Code:
--Beyaban Db v1
--Yapımcısı: Adil
--Bu Konu [url=http://pvpserverler.forumclan.com'da]http://pvpserverler.forumclan.com'da[/url] LionER Tarafından Upload Edilip,Yayımlanmıştır.

DELETE
FROM        K_NPC
WHERE    (strName = 'warder 1') OR
                  (strName = 'warder 2') OR
                  (strName = 'keeper')

DELETE
FROM        K_NPCPOS
WHERE    (ZoneID = 102) AND (NpcID = 21045) OR
                  (ZoneID = 102) AND (NpcID = 21041) OR
                  (ZoneID = 102) AND (NpcID = 21042) OR
                  (ZoneID = 102) AND (NpcID = 11041) OR
                  (ZoneID = 102) AND (NpcID = 11042) OR
                  (ZoneID = 102) AND (NpcID = 11047)

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 ( 21041, 'Keeper', 11610, 100, 130650179, 170450000, 2, 7, 11, 1, 1, 2, 0, 80, 0, 0, 215000, 0, 0, 15000, 375, 375, 8000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 2000, 21011, 0, 0, 1 );
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 ( 21042, 'Warder 1', 11610, 100, 130450179, 170450000, 2, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 6000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
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 ( 21045, 'Warder 2', 11610, 100, 130450179, 170450000, 2, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 6000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
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 ( 11041, 'Keeper', 21610, 100, 120310049, 170450000, 1, 7, 11, 1, 1, 2, 0, 80, 0, 0, 215000, 0, 0, 15000, 375, 375, 5000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 2000, 21011, 0, 0, 1 );
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 ( 11042, 'Warder 1', 21610, 100, 120710049, 170450000, 1, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 4000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
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 ( 11047, 'Warder 2', 21610, 100, 120710049, 170450000, 1, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 4000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 21045, 104, 1, 3, 0, 0, 807, 545, 810, 542, 794, 548, 814, 530, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 11047, 104, 1, 5, 0, 0, 176, 455, 178, 453, 167, 465, 188, 446, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 21041, 104, 1, 1, 98, 0, 947, 949, 949, 946, 944, 952, 952, 943, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 21042, 104, 1, 2, 0, 0, 554, 816, 557, 813, 541, 819, 560, 801, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 11041, 104, 1, 6, 99, 0, 73, 77, 76, 75, 64, 84, 82, 66, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 11042, 104, 1, 4, 0, 0, 450, 188, 453, 186, 444, 193, 461, 179, 1, 30, 0, 0, '' );


Download Linkini Görmek İçin Konuya Mesaj Atınız !

https://pvp-serverleri.forum.st

Back to top  Message [Page 1 of 1]

Permissions in this forum:
You cannot reply to topics in this forum