couple of questions pls?

Quote:

Originally Posted by gavsta Hello, does anybody know how double quest exp gold and gen? also does anybody know how to remove skill cards from drop group?

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

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

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

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

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 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!)  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 gavsta is there a way to change quest exp gen point etc to double on all like age of rappelz had?

UPDATE [Arcadia].[dbo].[QuestResource] 
SET [exp] = [exp] * 2
where (id >= 1005 and id <=10233 )
GO

UPDATE [Arcadia].[dbo].[QuestResource] 
SET [jp] = [jp] * 2
where (id >= 1005 and id <=10233 )
GO

UPDATE [Arcadia].[dbo].[QuestResource] 
SET [holicpoint] = [holicpoint] * 2
where (id >= 1005 and id <=10233 )
GO

UPDATE [Arcadia].[dbo].[QuestResource] 
SET [gold] = [gold] * 2
where (id >= 1005 and id <=10233 )
GO