Npc Nplerini Alma-Verme

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:
Kod:
CREATE PROCEDURE [npleri_ver]
AS
--Emc & Lufer & Savas aLani NPCLeri
--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

NpLeri aLan Prosedür..

Kod:
CREATE PROCEDURE [npleri_al]
--K_NPC Tabledeki NpcLerin Npsini aLır.
--Kullanım 'exec npleri_al'

AS
Begin
update K_NPC set iloyalty='0'
End
GO

Kullanımları İse Şöyledir

Npclere Nplerini Vermek İçin : exec npleri_ver

Npclerden Nplerini Almak İçin : exec npleri_al