Query for skill cards

can somebody send me the Query to disable skill cards from drops?

wtf, i gave you yesterday the query.

Quote:

Originally Posted by Raskim2000 Edit quest`s  Spoiler Exp  Spoiler Code: use arcadia update dbo.QuestResource set exp = 'insert_amount_here' where id = 'insert_quest_id_here' Jp  Spoiler Code: use arcadia update dbo.QuestResource set jp = 'insert_amount_here' where id = 'insert_quest_id_here' holic-point`s  Spoiler Code: use arcadia update dbo.QuestResource set holicpoint = 'insert_amount_here' where id = 'insert_quest_id_here' Gold  Spoiler Code: use arcadia update dbo.QuestResource set gold = 'insert_amount_here' where id = 'insert_quest_id_here' And im pretty sure, you use eGurgle`s droptable`s, so you just need to set the percantage to 0 where the skillcard`s are declared Or just use it (ONLY IF YOU USE eGurgle`s Table`s!) OVER HERE!  Spoiler Code: declare @j0 int, @j1 int, @j2 int, @all int set @j0 = -510000 set @j1 = -3000129 set @j2 = -3000130 set @all = -3000152 UPDATE Arcadia.dbo.MonsterResource SET drop_percentage_01 = 0, drop_min_count_01 = 1, drop_max_count_01 = 1, drop_min_level_01 = 1, drop_max_level_01 = 1 WHERE drop_item_id_01 = @j0 UPDATE Arcadia.dbo.MonsterResource SET drop_percentage_01 = 0, drop_min_count_01 = 1, drop_max_count_01 = 1, drop_min_level_01 = 1, drop_max_level_01 = 1 WHERE drop_item_id_01 = @j1 UPDATE Arcadia.dbo.MonsterResource SET drop_percentage_01 = 0, drop_min_count_01 = 1, drop_max_count_01 = 1, drop_min_level_01 = 1, drop_max_level_01 = 1 WHERE drop_item_id_01 = @j2 UPDATE Arcadia.dbo.MonsterResource SET drop_percentage_01 = 0, drop_min_count_01 = 1, drop_max_count_01 = 1, drop_min_level_01 = 1, drop_max_level_01 = 1 WHERE drop_item_id_01 = @all UPDATE Arcadia.dbo.DropGroupResource set drop_item_id_00 = @j0, drop_percentage_00 = 0, drop_min_count_00 = 1, drop_max_count_00 = 1, drop_item_id_01 = @j1, drop_percentage_01 = 0, drop_min_count_01 = 1, drop_max_count_01 = 1, drop_item_id_02 = @j2, drop_percentage_02 = 0, drop_min_count_02 = 1, drop_max_count_02 = 1 where id = @all --/*** View Results *** select id, model, monster_group, level, drop_item_id_01, drop_percentage_01 from Arcadia.dbo.MonsterResource where drop_item_id_01 = @j0 or drop_item_id_01 = @j1 or drop_item_id_01 = @j2 or drop_item_id_01 = @all order by level --*/

Quote:

Originally Posted by TheOnlyOneRaskim wtf, i gave you yesterday the query.

but will that remove all skill cards from drops?
Deque

:facepalm:

we try it on an other way. Do you use eGurgle`s droprule`s?

If yes, there are droprules for everything. 1 specific for skillcards and than champboss/boss. Just set all percentage`s to 0 where the skillcard`s are declared.

yes all cards removed with this from raskim.

The script above just remove skillcard`s from normal Mob`s. Boss Mob`s /Champ Boss Mob´s dropt them again, so he need to set the percentage`s of them, too.