[DEVPAYLAŞIM] Kendi NPC Kesme Derdine Son Verecek Prosedür..

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
--Emc & Lufer & Savas aLani NPCLeri
--Coded by Shady_Wen0M
--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..