[Help] Making Normal Items drop in Quest

[gReGiTh]

I was trying to make equippable weapons that dropped during Quest. It doesn't seem possible though.

So I figured I could make an SQL trigger for the LGKiez DB that does the following:

When a specific quest item is in a players inventory, let's say itemid 1234, that item is replaced by an equipable weapon with itemid 9999

Can someone please help me with this? I have no idea how to create an SQL trigger.

[MentaL]

[RepublicOfAstra]

I'm not sure about SQL trigger, but I'm almost sure you can just edit droptable.xml for your quest drops with no SQL needed.

[deathtilldusk]

yes but the item id's in there are different from zitem and shop

[gReGiTh]

I'm not sure about SQL trigger, but I'm almost sure you can just edit droptable.xml for your quest drops with no SQL needed.

If you change the itemid of a drop in droptable.xml to the itemid of a nonquest item, it will not drop.
Also, I tried adding a normal item to zquestitem.xml, it showed up as a quest bible ingame.

I think that maybe I can add a new itemtype for quest items, and give that itemtype the attributes of a weapon.. But I don't know where quest item types are defined..

[RepublicOfAstra]

I know there's a way to do it, since some quests drop low-level element equips.

[gReGiTh]

I know there's a way to do it, since some quests drop low-level element equips.

Well if you figure it out please let me know.. cause I've been obsessing over it for a couple hours now with no success.

[gReGiTh]

Regarding the SQL method of changing quest items to normal items, apparently I didn't need to make a trigger afterall. It's obvious I am a noob with SQL. Anyway, I figured out how to make a query that will suit my needs.

UPDATE  Items
SET ItemID=('25')
WHERE ItemID=('200001')

Simple enough. =]

The only problem is, how do I make this query execute automatically on a schedule? As in every 5 minutes or so.

I was thinking maybe I could add it to one of the stored procedures, suchas dbo.spUpdateCharInfoData. Problem is, I don't know the proper syntax to add the above Query to one of the Stored Procedures.

If I could do that (add the query to a stored procedure that exucutes at the end of every match or so), then I could just replace the name of the quest item being replaced with the name of the item I'm replacing it with, and it would seem as if a player was simply picking up the final item during the quest.

If it has to be scheduled to execute every minute or 5 minutes or so, I could change the quest item being replaced into one of those little gifts, and change the description to something like, "This gift is wrapped really well.. it's gonna take you like 5 minutes to open it.. :P".

[RepublicOfAstra]

Eh, I'm still trying to find a way. I KNOW it's possible, since Goblin King's old drop was elements and and NAGunz, the bosses drop hats and swords and rockets.

[Rotana]

The items that Na Gunz give are premium items with and RentPeriode, maybe when you use an Itemid thats for premium with an RentPeriode it will work i think,

The Runnable and the matchserver can read it from the xml's

[gReGiTh]

... Doesn't anybody know how to schedule a query to execute every 5 minutes or so?

[Rotana]

You can let an other procedure execute the new one. Then it only runs if its needed

[gReGiTh]

You can let an other procedure execute the new one. Then it only runs if its needed

Ok... how might I do that?

[Rotana]

Put this in before the end

EXEC [dbo].[NAME OF PROCEDURE HERE]

When you put it in the procedure of SelectCharItem it will be runned everytime if an user goes to equipment.

[gReGiTh]

Put this in before the end


When you put it in the procedure of SelectCharItem it will be runned everytime if an user goes to equipment.

Thanks. I'll try that.

[gReGiTh]

Thanks. I'll try that.

Err, how to I save the following as a stored procedure?

UPDATE Items
SET ItemID=('25')
WHERE ItemID=('200001')

[Rotana]

Use this to make an procedure that will update the items

GO
CREATE PROCEDURE spQuestItemUpdater
AS
BEGIN
UPDATE Items
Set Itemid = 25 WHERE Itemid = 525
Set Itemid = 27 WHERE Itemid = 526
Set Itemid = 28 WHERE Itemid = 527
END

change the item number to the numbers you want

[Rotana]

But one problem, the Quest items are not in the Table items

[gReGiTh]

But one problem, the Quest items are not in the Table items

Hmm.. you're right. Please don't tell me quest items are stored in the questiteminfo column of the character table... -.-

Btw, I appreciate your help alot.

[Rotana]

The quest items are stored in that tabe yes,

I just notce that, when i made that small procedure for and test it at mine database. I will look for something else, maybe i will find something

[Linear88]

It isn't called by MatchServer. So thats a custom procedure?

[Rotana]

An other point,

I just tried the xml files of ijji, but when i create a game with goblin king, Thats one of the scenario's where you get an reward, The server crash at loading of the game.

And i can't read the DMP file that the server made.

So i think its very hard to realise normale items as dropitems in gunz.

[RepublicOfAstra]

If you just plop the ijji files in your server, it'll crash regardless of what scenario it is. It would take some tweaking.

[gReGiTh]

Damn.. I'm determined to figure this out.

The values in under the questiteminfo column seem to be encoded in some weird way. I'm gonna mess with those values a bit, maybe I can make some sense of it.. doubt it though.

Edit.. no, definately can't make any sense of this crap..

Some values:

[CODE]

[Nekroido]

I suggest u all download and install Magic Translator.

It can translate korean, so we can read hints in XML-files. ;)

[gReGiTh]

Bump.