1. I don't know how many times this has been linked in this thread but I know the information is linked on this page.
You need to run the following script to make HV work when the Cash usable server is set to 0...
Now in order to fix the HV NPCs you need to change their value in dbo.NPCResource.
The Value you need to change is "spawn_type" which will originally be a "4" so it only spawns if it is a cash usable server.
Change the value to "0" and they will spawn like any other NPC.
Code:
use
Arcadia
UPDATE [Arcadia].[dbo].[NPCResource] SET[spawn_type] = 0 WHERE [contact_script] LIKE '%Secroute%'
2. I don't know, I don't cheat on the Job change quests. What I do know is the Job Change .lua file in the 7.4 server files was set to skip the master class quests because they were not functioning correctly.
Maybe you should take a look at the 7.4 .lua for answers.
3. dbo.MonsterResource each tamable monster type has a column filled out for taming_percentage.
You need to adjust this value for each appearance of that creature in the DB.
Something like this SQL...
Code:
Use Arcadia
-- Sala
UPDATE MonsterResource
SET taming_percentage = 0.250
WHERE monster_group = 3023
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 3023
go
UPDATE MonsterResource
SET taming_id = 1901
WHERE monster_group = 3023
go
-- Kenta
UPDATE MonsterResource
SET taming_percentage = 0.0200
WHERE monster_group = 5011
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 5011
go
UPDATE MonsterResource
SET taming_id = 1701
WHERE monster_group = 5011
go
-- Angel
UPDATE MonsterResource
SET taming_percentage = 0.0200
WHERE monster_group = 5021
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 5021
go
UPDATE MonsterResource
SET taming_id = 2001
WHERE monster_group = 5021
go
-- Wolf
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 103049
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 103049
go
UPDATE MonsterResource
SET taming_id = 2901
WHERE monster_group = 103049
go
-- windsong
UPDATE MonsterResource
SET taming_percentage = 0.0700
WHERE monster_group = 103022
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 103022
go
UPDATE MonsterResource
SET taming_id = 3301
WHERE monster_group = 103022
go
UPDATE MonsterResource
SET taming_percentage = 0.0700
WHERE monster_group = 103020
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 103020
go
UPDATE MonsterResource
SET taming_id = 3301
WHERE monster_group = 103020
go
-- eimus
UPDATE MonsterResource
SET taming_percentage = 0.0200
WHERE monster_group = 103091
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103091
go
UPDATE MonsterResource
SET taming_id = 3401
WHERE monster_group = 103091
go
UPDATE MonsterResource
SET taming_percentage = 0.0200
WHERE monster_group = 103092
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103092
go
UPDATE MonsterResource
SET taming_id = 3401
WHERE monster_group = 103092
go
-- octopus
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 103086
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 103086
go
UPDATE MonsterResource
SET taming_id = 3502
WHERE monster_group = 103086
go
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 103087
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 103087
go
UPDATE MonsterResource
SET taming_id = 3502
WHERE monster_group = 103087
go
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 103088
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 103088
go
UPDATE MonsterResource
SET taming_id = 3502
WHERE monster_group = 103088
go
-- Genie
UPDATE MonsterResource
SET taming_percentage = 0.0150
WHERE monster_group = 103106
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103106
go
UPDATE MonsterResource
SET taming_id = 3701
WHERE monster_group = 103106
go
UPDATE MonsterResource
SET taming_percentage = 0.0150
WHERE monster_group = 103107
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103107
go
UPDATE MonsterResource
SET taming_id = 3701
WHERE monster_group = 103107
go
UPDATE MonsterResource
SET taming_percentage = 0.0150
WHERE monster_group = 103108
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103108
go
UPDATE MonsterResource
SET taming_id = 3701
WHERE monster_group = 103108
go
-- ifrit
UPDATE MonsterResource
SET taming_percentage = 0.0150
WHERE monster_group = 103111
go
UPDATE MonsterResource
SET taming_exp_mod = 4.00
WHERE monster_group = 103111
go
UPDATE MonsterResource
SET taming_id = 3801
WHERE monster_group = 103111
go
-- Unicorn
UPDATE MonsterResource
SET taming_percentage = 0.0700
WHERE monster_group = 103125
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 103125
go
UPDATE MonsterResource
SET taming_id = 3901
WHERE monster_group = 103125
go
-- Nightmare
UPDATE MonsterResource
SET taming_percentage = 0.0700
WHERE monster_group = 103125
go
UPDATE MonsterResource
SET taming_exp_mod = 3.00
WHERE monster_group = 103125
go
UPDATE MonsterResource
SET taming_id = 4001
WHERE monster_group = 103125
go
-- Blue Pixie
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 1052
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 1052
go
UPDATE MonsterResource
SET taming_id = 1021
WHERE monster_group = 1052
go
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 1053
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 1053
go
UPDATE MonsterResource
SET taming_id = 1021
WHERE monster_group = 1053
go
-- Skelly
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 1032
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 1032
go
UPDATE MonsterResource
SET taming_id = 2401
WHERE monster_group = 1032
go
UPDATE MonsterResource
SET taming_percentage = 0.2500
WHERE monster_group = 1033
go
UPDATE MonsterResource
SET taming_exp_mod = 2.00
WHERE monster_group = 1033
go
UPDATE MonsterResource
SET taming_id = 2401
WHERE monster_group = 1033
go
-- other
UPDATE MonsterResource
SET taming_id = 3901
WHERE name_id = 83006
go
UPDATE MonsterResource
SET taming_id = 3901
WHERE name_id = 84005
go
UPDATE MonsterResource
SET taming_id = 3901
WHERE name_id = 85006
go
Use Arcadia
UPDATE MonsterResource
SET taming_id = 4001
WHERE name_id = 121002
go
UPDATE MonsterResource
SET taming_id = 4001
WHERE name_id = 120003
go
UPDATE MonsterResource
SET taming_id = 4001
WHERE name_id = 122001
You will need to include the 8.1 pets in this as well this code was pre 8.1