Query for skill cards

[gavsta]

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

[TheOnlyOneRaskim]

wtf, i gave you yesterday the query.

Originally Posted by Raskim2000

Edit quest`s

 Spoiler

Exp

 Spoiler

use arcadia
update dbo.QuestResource 
set exp = 'insert_amount_here'
where id = 'insert_quest_id_here'

Jp

 Spoiler

use arcadia
update dbo.QuestResource 
set jp = 'insert_amount_here'
where id = 'insert_quest_id_here'

holic-point`s

 Spoiler

use arcadia
update dbo.QuestResource 
set holicpoint = 'insert_amount_here'
where id = 'insert_quest_id_here'

Gold

 Spoiler

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

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
--*/

[gavsta]

Originally Posted by TheOnlyOneRaskim

wtf, i gave you yesterday the query.

but will that remove all skill cards from drops?
Deque

 Spoiler

(12 row(s) affected)

(990 row(s) affected)

(0 row(s) affected)

(1841 row(s) affected)

(1 row(s) affected)

(2843 row(s) affected)

[TheOnlyOneRaskim]

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.

[falkenman]

yes all cards removed with this from raskim.

[TheOnlyOneRaskim]

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.