All pastes #884733 Raw Edit

Something

public text v1 · immutable
#884733 ·published 2008-01-30 15:47 UTC
rendered paste body
update creature_template set modelid_a2=modelid_h where entry in ('12999', '13876', '15384', '16044', '16045', '16046', '16047', '16048', '16465', '16466', '16922', '17047', '17124', '17125', '17126', '17883', '17974', '18263', '19656', '19871', '20226', '20230', '20296', '20617', '20666', '20670', '20767', '20781', '20809', '21039', '21053', '21074', '21142', '21176', '21261', '21262', '21310', '21348', '21429', '21451', '21463', '21489', '21898', '22058', '22096', '22230', '22358', '22457', '22851', '22905', '21252', '22515', '22517', '25173', '17316', '17886', '22023', '22116', '22356', '22367', '22368', '22447', '22798', '22799', '22800', '22801', '23537', '17529', '17847', '19297', '22039', '22040', '22046', '22395', '22417');
update creature_template set modelid_a='17519' where entry='12999';
update creature_template set modelid_a='2581' where entry='17316';
update creature_template set modelid_a='7950' where entry='18263';
update creature_template set modelid_a='17519' where entry='19656';
update creature_template set modelid_a='169' where entry='19871';
update creature_template set modelid_a='16480' where entry='20226';
update creature_template set modelid_a='16480' where entry='20230';
update creature_template set modelid_a='17035' where entry='20296';
update creature_template set modelid_a='17035' where entry='20617';
update creature_template set modelid_a='16480' where entry='20666';
update creature_template set modelid_a='16480' where entry='20670';
update creature_template set modelid_a='17035' where entry='20767';
update creature_template set modelid_a='17035' where entry='20781';
update creature_template set modelid_a='17035' where entry='20809';
update creature_template set modelid_a='17035' where entry='21039';
update creature_template set modelid_a='16480' where entry='21053';
update creature_template set modelid_a='17035' where entry='21074';
update creature_template set modelid_a='17035' where entry='21142';
update creature_template set modelid_a='17035' where entry='21176';
update creature_template set modelid_a='169' where entry='21252';
update creature_template set modelid_a='17035' where entry='21261';
update creature_template set modelid_a='17035' where entry='21262';
update creature_template set modelid_a='16480' where entry='21310';
update creature_template set modelid_a='2582' where entry='21348';
update creature_template set modelid_a='16480' where entry='21429';
update creature_template set modelid_a='16480' where entry='21451';
update creature_template set modelid_a='16480' where entry='21463';
update creature_template set modelid_a='16480' where entry='21489';
update creature_template set modelid_a='17035' where entry='21898';
update creature_template set modelid_a='4626' where entry='22039';
update creature_template set modelid_a='16480' where entry='22058';
update creature_template set modelid_a='16480' where entry='22096';
update creature_template set modelid_a='16480' where entry='22358';
update creature_template set modelid_a='4449' where entry='22395';
update creature_template set modelid_a='4449' where entry='22417';
update creature_template set modelid_a='21027' where entry='22457';
update creature_template set modelid_a='18783' where entry='22515';
update creature_template set modelid_a='18783' where entry='22517';
update creature_template set modelid_a='17035' where entry='22851';
update creature_template set modelid_a='17035' where entry='22905';
update creature_template set modelid_a='1126' where entry='25173';
update creature_template set modelid_a2='16046' where entry='22356';
update creature_template set modelid_a2='16046' where entry='22447';
update creature_template set modelid_a2='16046' where entry='22798';
update creature_template set modelid_a2='16046' where entry='22799';
update creature_template set modelid_a2='16046' where entry='22800';
update creature_template set modelid_a2='16046' where entry='22801';
update creature_template set 
modelid_h=modelid_a,
modelid_h2=modelid_a2
where entry in ('12999', '13876', '15384', '16044', '16045', '16046', '16047', '16048', '16465', '16466', '16922', '17047', '17124', '17125', '17126', '17883', '17974', '18263', '19656', '19871', '20226', '20230', '20296', '20617', '20666', '20670', '20767', '20781', '20809', '21039', '21053', '21074', '21142', '21176', '21261', '21262', '21310', '21348', '21429', '21451', '21463', '21489', '21898', '22058', '22096', '22230', '22358', '22457', '22851', '22905', '21252', '22515', '22517', '25173', '17316', '17886', '22023', '22116', '22356', '22367', '22368', '22447', '22798', '22799', '22800', '22801', '23537', '17529', '17847', '19297', '22039', '22040', '22046', '22395', '22417');