couple of questions pls?

[gavsta]

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

[Raskim2000]

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?

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!)

 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 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!)

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

is there a way to change quest exp gen point etc to double on all like age of rappelz had?

[Raskim2000]

Originally Posted by gavsta

is there a way to change quest exp gen point etc to double on all like age of rappelz had?

 Spoiler

Double Exp

 Spoiler

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

Double JP

 Spoiler

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

Double Gen Point

 Spoiler

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

Double Gold

 Spoiler

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