BAŞ BELASI KENDI NPC KESME FİXLEYEMEDİNİZMİ ŞİMDİ COK KOLAY GELSN KESINLERDE GORELEM BAKALIM:)

Evet ArkadaşLar Bu Prosedür Sayesinde UserLer Artık Kendi NpcLerini KesemeyecekLer..Prosedürü Şu MantıkLa KuLLanabiLirsiniz.. Savaştan Önce Restart Atıp.. NpcLerin NpcLerini Verin. Savaş Bitince Diğer Prosedürü UyguLayıp Tüm n.PLeri aLın..

NpLeri Veren Prosedür..


Kod:CREATE PROCEDURE [npleri_ver]
AS
--Kullanim 'exec npleri_ver'
Begin
update K_NPC set iloyalty='50' where ssid='26041'
update K_NPC set iloyalty='50' where ssid='14403'
update K_NPC set iloyalty='100' where ssid='22100'
update K_NPC set iloyalty='100' where ssid='22200'
update K_NPC set iloyalty='100' where ssid='22202'
update K_NPC set iloyalty='100' where ssid='22208'
update K_NPC set iloyalty='50' where ssid='21810'
update K_NPC set iloyalty='200' where ssid='22000'
update K_NPC set iloyalty='50' where ssid='24410'
update K_NPC set iloyalty='200' where ssid='21510'
update K_NPC set iloyalty='50' where ssid='24406'
update K_NPC set iloyalty='300' where ssid='14201'
update K_NPC set iloyalty='300' where ssid='24201'
update K_NPC set iloyalty='50' where ssid='14204'
update K_NPC set iloyalty='75' where ssid='21610'
update K_NPC set iloyalty='50' where ssid='24407'
update K_NPC set iloyalty='50' where ssid='24405'
update K_NPC set iloyalty='100' where ssid='24404'
update K_NPC set iloyalty='100' where ssid='14404'
update K_NPC set iloyalty='250' where ssid='24413'
update K_NPC set iloyalty='250' where ssid='14413'
update K_NPC set iloyalty='150' where ssid='24202'
update K_NPC set iloyalty='150' where ssid='14203'
update K_NPC set iloyalty='150' where ssid='24203'
update K_NPC set iloyalty='100' where ssid='24412'
update K_NPC set iloyalty='100' where ssid='14412'
update K_NPC set iloyalty='150' where ssid='14414'
update K_NPC set iloyalty='150' where ssid='24414'
update K_NPC set iloyalty='50' where ssid='16079'
update K_NPC set iloyalty='50' where ssid='16080'
update K_NPC set iloyalty='50' where ssid='14402'
update K_NPC set iloyalty='100' where ssid='12117'
update K_NPC set iloyalty='100' where ssid='12208'
update K_NPC set iloyalty='100' where ssid='12100'
update K_NPC set iloyalty='100' where ssid='12200'
update K_NPC set iloyalty='200' where ssid='11510'
update K_NPC set iloyalty='50' where ssid='16031'
update K_NPC set iloyalty='50' where ssid='14406'
update K_NPC set iloyalty='50' where ssid='11810'
update K_NPC set iloyalty='200' where ssid='12000'
update K_NPC set iloyalty='50' where ssid='14410'
update K_NPC set iloyalty='50' where ssid='14407'
update K_NPC set iloyalty='75' where ssid='11610'
update K_NPC set iloyalty='50' where ssid='14405'
update K_NPC set iloyalty='150' where ssid='14202'
update K_NPC set iloyalty='1000' where ssid='11042'
update K_NPC set iloyalty='1000' where ssid='21042'
update K_NPC set iloyalty='1000' where ssid='11047'
update K_NPC set iloyalty='1000' where ssid='21045'
update K_NPC set iloyalty='2000' where ssid='11041'
update K_NPC set iloyalty='2000' where ssid='21041'
update K_NPC set iloyalty='500' where ssid='26051'
update K_NPC set iloyalty='500' where ssid='26052'
update K_NPC set iloyalty='500' where ssid='26053'
update K_NPC set iloyalty='500' where ssid='26054'
update K_NPC set iloyalty='500' where ssid='26055'
update K_NPC set iloyalty='500' where ssid='26056'
update K_NPC set iloyalty='500' where ssid='26057'
update K_NPC set iloyalty='500' where ssid='16051'
update K_NPC set iloyalty='500' where ssid='16052'
update K_NPC set iloyalty='500' where ssid='16053'
update K_NPC set iloyalty='500' where ssid='16054'
update K_NPC set iloyalty='500' where ssid='16055'
update K_NPC set iloyalty='500' where ssid='16056'
update K_NPC set iloyalty='500' where ssid='16057'
End
GO
ve..
n.PLeri aLan Prosedür..
Kod:
CREATE PROCEDURE [npleri_al]
--K_NPC Tabledeki NpcLerin Npsini aLır.
--Coded by Shady_Wen0M
--Kullanım 'exec npleri_al'
AS
Begin
update K_NPC set iloyalty='0'
End
GO


Geçmiş oLsun..
Prosedür Tamamen Bana Aittir..aLıp KuLLanmak İsteyenLer Bir Teşekkür AtarLarsa MutLu oLurum (:
/Not:Prosedürü Kendinize Göre EditLeyebiLirsiniz..Bu Benim NpcLerim (:
KoLay GeLsin..