Hey, I am trying to disable journeyman mercs.
This is my fake sql / what I intend to do
Code:
select * from merc_npc_types where proficiency=2 (or name like '%journeyman%')
out of that subset compare merc_npc_types.merc_npc_type_id to merc_templates.merc_template_id
if they match set merc_templates.clientversion=1024
my SQL scripting ability is miserable. I know this isn't right but I can't quite get it.
Code:
update merc_templates set clientversion=1204 where
merc_npc_types.merc_type.id
from
merc_npc_types
left outer join
merc_templates
on
merc_npc_types.merc_type.id = merc_templates.merc_template_id
where
merc_npc_types.proficiency=2
or I could do this but it still doesnt set it in the merc_template section
Code:
update merc_types set clientversion=1024 where proficiency_id=2;