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:):confused:
normal drop from d1 to d11
12/02/2016 01:23
unlimited2311#1
12/02/2016 02:44
blapanda#2
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.
12/02/2016 07:03
unlimited2311#3
really?Quote:
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.
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
12/02/2016 08:50
blapanda#4
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?
How are you supposed to debug and handle your stuff in the future, hum?
12/02/2016 10:13
NoIdeaForAName#5
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 :
You can use the % sign to get multiple IDs at once.(For example ITEM_EU_SWORD_%)
After you get the ID enable the feature :
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.
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'
After you get the ID enable the feature :
PHP Code:
UPDATE _RefDropItemAssign
SET SERVICE = 1
WHERE RefItemID BETWEEN AN ID and ANOTHER
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.