[TUT] How to customize drop table(s)

[misterd]

Hey folks. i recently quitted rappelz for a while, but i cant let you guys alone. here's something you might enjoy.

 Spoiler

use Arcadia

 --> change the red code numeric to search your desired ID.
DECLARE @id int = ( SELECT id FROM itemresource where id = '503001' ) 
 --> checking the identity of the item to determine the name of the id.
DECLARE @name_id int = ( SELECT name_id FROM itemresource where id = @id )
 --> checking the essentials of the id. 
SELECT id,type,class,rank,[level],socket,drop_type FROM itemresource where id = @id
 --> checking the identity of the stated item.
SELECT  value FROM stringresource where code = @name_id
--> multiple searches at once.
SELECT * from DropGroupResource where 
   (drop_item_id_00 = @id) 
or (drop_item_id_01 = @id) 
or (drop_item_id_02 = @id)
or (drop_item_id_03 = @id)
or (drop_item_id_04 = @id)
or (drop_item_id_05 = @id) 
or (drop_item_id_06 = @id)
or (drop_item_id_07 = @id)
or (drop_item_id_08 = @id)
or (drop_item_id_09 = @id)

--> Credits : misterd @ 2012

what does it do?

1. enter a desired ID of an item.
2. Press execute
3. Item name is displayed, and being checking in all dropgroups if exists.
4. happy editing!

[LeoMessi1899]

U Leave Our Community ?

[dpshark]

How to change it plz ?

[markusbab]

Originally Posted by dpshark

How to change it plz ?

"facepalm"

[dpshark]

abruti

[glandu2]

Originally Posted by dpshark

How to change it plz ?

use your keyboard and maybe that:

[ismokedrow]

Seriously how hard is it to read the structure of MonsterDropTable (Was a lot harder when we were trying to rebuild it /nudges-misterd) But on a serious note, id, sub id those are what I call linking-fields:

MonsterResource:
- Set Mobs Drop Table ID to 1001

MonsterDropTableResource:
- Create entry with id 1001 and sub_id 1002 (if only 9 items are needed set sub_id to 0) fill in the item id's and drop values/levels
- Create secondary entry with id 1002 (sub_id 1003 if you need a third entry)

You can continue this indefinitely or limit it to a single entry, seriously no brainer.

[c1ph3r]

Originally Posted by dpshark

Superbe soliarité...merci je me suis débrouillé seul .....putain d'amerloc de merde

this is a german/english speaking forum...
no need to flame around if there is something missing in your own brain...

Exercises to dpshark:

-learn SQL
-learn how to use the search button
-learn how to read and write english
-learn how to use this mysterious thing between your ears...

If this is too much for you...go to hell...it's not our job to do your fcking work