[TUT]Make normal item drop in Quest

[Pokky]

Well, as the title:
1. Look at the npc.xml, and take the npc u want to drop item. Scroll down, and u will see something like this ( this is Goblin King 's )

<DROP table="b2" />

2. Open droptable.xml, then looking for that name. In this case, you will look for name="b2"

<DROPSET id="32" name="b2">
	<ITEMSET QL="0">
		<ITEM id="600302"		rate="0.90"		rent_period="168" />
	</ITEMSET>
	<ITEMSET QL="1">
		<ITEM id="600302"		rate="0.90"		rent_period="168" />
	</ITEMSET>
	<ITEMSET QL="2">
	  <ITEM id="200009"	rate="0.3" />
	  <ITEM id="200038"	rate="0.6" />
	  <ITEM id="600302"		rate="0.35"		rent_period="168" />
	</ITEMSET>
	<ITEMSET QL="3">
		<ITEM id="600302"		rate="0.90"		rent_period="168" />
	</ITEMSET>
	<ITEMSET QL="4">
		<ITEM id="600302"		rate="0.90"		rent_period="168" />
	</ITEMSET>
	<ITEMSET QL="5">
		<ITEM id="600302"		rate="0.90"		rent_period="168" />
	</ITEMSET>
</DROPSET>

Yes, this is the item id will drop by that NPC . Just change the Item Id by the Id u want. Someone said that if u change the Item ID, the item wont drop, but i changed and it worked. Maybe the rent_period made it work ;)?
3. Well, after u change the droptable.xml, u will received the item when u killed that NPC, but that item wont appear in ur item list after u finish this Quest. Dont worry, just go to MSSMSE ( Microsoft SQL Server Management Studio Express ), and open the items table. Guess what? That item is really inserted, but some Stored Procedures are wrong. The Item ID is updated as the CID, and the CID is updated as the Item ID, and that make ur item wont appear.
I didnt find out what Stored Procedures are wrong, so i make a trigger

USE [GunzDB]
GO
/****** Object:  Trigger [dbo].[ItemUpdate]    Script Date: 01/01/2002 14:09:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER TRIGGER [dbo].[ItemUpdate] 
   ON  [dbo].[Items] 
   AFTER update,insert
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    update Items
set CID=ItemID, ItemID=CID, RentPeriodRemainder=169
where RentPeriodRemainder=168

END

The Default RentPeriodRemainder is 168 ( in droptable.xml ).
I tried with the Goblin King, and it work for me. If u cant make it, just ask, dont blame me plz.

[MentaL]

[NIRVANAdylan]

Sweet tutorial, I think alot of people have been waiting for this.

[SpadeZ[905]]

what db is this for? BrGunZ or IGUNZ

[Kingston]

IGunz.

[xqr9176]

I have no the table of ItemUpdate

[Kingston]

Ur sposed to make one.

[splitsecond]

hi..i cant make quset can someone help me this is wat i did..

open server.ini

change the server mode to "test"

save it and u have quset server

but it dosnt work???
plz help me

[wesman2232]

1. dont bump an old thread like you did in the main GunZ section.
2. I answered in the other one.