normal drop from d1 to d11

[unlimited2311]

i need add drop normal items from d1 to d11 in normal acc like isro normal items and sox i know that anyone will say add it manual but i will take long time to end it so if anyone have any easy way or query help me .and tnx

[blapanda]

It is easy writing down a simply update query... So, stop waiting for someone else doing the job for you, since this will cost you time, for something which can be accomplished within few minutes.

[unlimited2311]

Originally Posted by blapanda

It is easy writing down a simply update query... So, stop waiting for someone else doing the job for you, since this will cost you time, for something which can be accomplished within few minutes.

really?
look if u mean add every item manual it will take long time and if there query end this i can't make it thats why i ask -_- don't ask to waste my time

[blapanda]

Duh... You seem to be someone acting like "I have no clue what I am doing here, wanna open a server, so you do the work for me". How about browsing some Microsoft websites regarding UPDATE Statements for MSSQL, instead of trashtalking here and wasting my time, instead?

How are you supposed to debug and handle your stuff in the future, hum?

[NoIdeaForAName]

Wait, monsters don't drop normal items from D1-D11 ?
So you want to implement something that's already enabled?
I don't get it.

Also, find the items ID :

PHP Code:

USE SRO_VT_SHARD
SELECT ID FROM _RefObjCommon WHERE CodeName128 LIKE 'ITEM_EU_SWORD_01' 


You can use the % sign to get multiple IDs at once.(For example ITEM_EU_SWORD_%)

After you get the ID enable the feature :

PHP Code:

UPDATE _RefDropItemAssign
SET SERVICE = 1
WHERE RefItemID BETWEEN AN ID and ANOTHER 


Replace AN ID, ANOTHER with a range of IDs.


Why did I say a range? Because some IDs they're consecutive meaning that you'll automatically enable from a range to another.

I hope I gave you an idea about what's going on.

If you find another faster method, use it.