Some fix-queries ppl could be interested in (including one fix I wrote in any of my threads xD):
Circus-Monster-Animation-Fix (not even fixed on retail yet, lazy GalaLab..):
Code:
use Arcadia
UPDATE [dbo].[MonsterMotionSet]
SET casting_1 = 21143 where character_id = 103235
UPDATE [dbo].[MonsterMotionSet]
SET casting_2 = 21144 where character_id = 103235
UPDATE [dbo].[MonsterMotionSet]
SET casting_3 = 21145 where character_id = 103235
GO
UPDATE [dbo].[MonsterMotionSet]
SET casting_1 = 21156 where character_id = 103236
UPDATE [dbo].[MonsterMotionSet]
SET casting_2 = 21157 where character_id = 103236
UPDATE [dbo].[MonsterMotionSet]
SET casting_3 = 21158 where character_id = 103236
GO
UPDATE [dbo].[MonsterMotionSet]
SET casting_1 = 21167 where character_id = 103237
UPDATE [dbo].[MonsterMotionSet]
SET casting_2 = 21168 where character_id = 103237
UPDATE [dbo].[MonsterMotionSet]
SET casting_3 = 21169 where character_id = 103237
GO
UPDATE [dbo].[MonsterMotionSet]
SET casting_1 = 21178 where character_id = 103238
UPDATE [dbo].[MonsterMotionSet]
SET casting_2 = 21179 where character_id = 103238
UPDATE [dbo].[MonsterMotionSet]
SET casting_3 = 21180 where character_id = 103238
GO
UPDATE [dbo].[MonsterMotionSet]
SET casting_1 = 21189 where character_id = 103239
UPDATE [dbo].[MonsterMotionSet]
SET casting_2 = 21190 where character_id = 103239
UPDATE [dbo].[MonsterMotionSet]
SET casting_3 = 21191 where character_id = 103239
GO
UPDATE [dbo].[MonsterMotionSet]
SET casting_1 = 21200 where character_id = 103240
UPDATE [dbo].[MonsterMotionSet]
SET casting_2 = 21201 where character_id = 103240
UPDATE [dbo].[MonsterMotionSet]
SET casting_3 = 21202 where character_id = 103240
GO
UPDATE [dbo].[MonsterMotionSet]
SET melee_1 = 21211 where character_id = 103241
UPDATE [dbo].[MonsterMotionSet]
SET melee_2 = 21212 where character_id = 103241
UPDATE [dbo].[MonsterMotionSet]
SET melee_3 = 21213 where character_id = 103241
GO
UPDATE [dbo].[MonsterMotionSet]
SET melee_1 = 21237 where character_id = 103245
UPDATE [dbo].[MonsterMotionSet]
SET melee_2 = 21238 where character_id = 103245
UPDATE [dbo].[MonsterMotionSet]
SET melee_3 = 21239 where character_id = 103245
GO
UPDATE [dbo].[CharacterMotion]
SET file_name = 'ain_crazyharlequeengreen_una_cast01_a_biped' where motion_id = 21143
UPDATE [dbo].[CharacterMotion]
SET file_name = 'ain_crazyharlequeengreen_una_cast01_b_biped' where motion_id = 21144
UPDATE [dbo].[CharacterMotion]
SET file_name = 'ain_crazyharlequeengreen_una_cast01_c_biped' where motion_id = 21145
GO
UPDATE [dbo].[CharacterMotion]
SET file_name = 'ain_crazyharlequeenred_una_skill01_a_biped' where motion_id = 21156
UPDATE [dbo].[CharacterMotion]
SET file_name = 'ain_crazyharlequeenred_una_skill01_b_biped' where motion_id = 21157
UPDATE [dbo].[CharacterMotion]
SET file_name = 'ain_crazyharlequeenred_una_skill01_c_biped' where motion_id = 21158
GO
UPDATE [dbo].[CharacterMotion]
SET file_name = 'demon_PersianMonkey_una_cast01_a_biped' where motion_id = 21211
UPDATE [dbo].[CharacterMotion]
SET file_name = 'demon_PersianMonkey_una_cast01_b_biped' where motion_id = 21212
UPDATE [dbo].[CharacterMotion]
SET file_name = 'demon_PersianMonkey_una_cast01_c_biped' where motion_id = 21213
GO
UPDATE dbo.CharacterMotion
SET file_name = 'demon_TheBloodClot_una_skill01_a_biped' where motion_id = 21237
UPDATE dbo.CharacterMotion
SET file_name = 'demon_TheBloodClot_una_skill01_b_biped' where motion_id = 21238
UPDATE dbo.CharacterMotion
SET file_name = 'demon_TheBloodClot_una_skill01_c_biped' where motion_id = 21239
GO
Fix for Talentpoint-quests:
Code:
use Arcadia
UPDATE dbo.QuestLinkResource
SET npc_id = 2082 where quest_id = 3351
UPDATE dbo.QuestLinkResource
SET npc_id = 11244 where quest_id = 3359
UPDATE dbo.QuestLinkResource
SET npc_id = 11241 where quest_id = 3350
GO
Roaming-Mobb Fixes (2x hidden PP, 1x hidden ToLs - those wrong points exist since hidden exists even on retail, too xD):
Code:
use Arcadia
UPDATE dbo.RoamingPointResource
SET x = 201480 where roaming_id = 1202134 and point_id = 1
UPDATE dbo.RoamingPointResource
SET y = 24712 where roaming_id = 901013 and point_id = 0
UPDATE dbo.RoamingPointResource
SET x = 201986 where roaming_id = 1202140 and point_id = 2
GO
Fix for some soulstone-prices ( really bad for ingame-market if you get 200kk per stone :D )
Code:
use Arcadia
update dbo.ItemResource
SET price = 16000 where id = 810004
update dbo.ItemResource
SET price = 16000 where id = 808204
update dbo.ItemResource
SET price = 16000 where id = 807004
update dbo.ItemResource
SET price = 16000 where id = 807304
update dbo.ItemResource
SET price = 16000 where id = 807604
update dbo.ItemResource
SET price = 16000 where id = 807904
update dbo.ItemResource
SET price = 16000 where id = 808504
update dbo.ItemResource
SET price = 16000 where id = 808804
update dbo.ItemResource
SET price = 16000 where id = 809104
update dbo.ItemResource
SET price = 16000 where id = 809404
update dbo.ItemResource
SET price = 16000 where id = 809704
GO