Ow some! thanks for share it!
EDIT:
ADOPT IN ONE EXECUTE
Here is the SQL script for you to change all your L2Guards to Human Archer w/ Infinity Bow
and a modification to fake_pcs table design.
-- ------------------
-- Script by d0ds™ --
-- ------------------
-- INSERT ALL L2Guard INFO INTO face_pcs TABLE IN OUN EXECUTE
-- ############## START ##############
-- THIS ALTER TABLE MODIFIES THE title_color, and name_color INTO VARCHAR FROM INT TO HUNDLE HEX COLOR CODE
-- SINCE IT WAS int AS DEFAULT.
ALTER TABLE fake_pcs CHANGE title_color title_color VARCHAR(11);
ALTER TABLE fake_pcs CHANGE name_color name_color VARCHAR(11);
-- INSERT DATA
INSERT INTO fake_pcs
(
npc_id,
race,
sex,
class,
title,
title_color,
name,
name_color,
hair_style,
hair_color,
face,
mount,
team,
hero,
pd_under,
pd_under_aug,
pd_head,
pd_head_aug,
pd_rhand,
pd_rhand_aug,
pd_lhand,
pd_lhand_aug,
pd_gloves,
pd_gloves_aug,
pd_chest,
pd_chest_aug,
pd_legs,
pd_legs_aug,
pd_feet,
pd_feet_aug,
pd_back,
pd_back_aug,
pd_lrhand,
pd_lrhand_aug,
pd_hair,
pd_hair_aug,
pd_hair2,
pd_hair2_aug,
pd_rbracelet,
pd_rbracelet_aug,
pd_lbracelet,
pd_lbracelet_aug,
pd_deco1,
pd_deco1_aug,
pd_deco2,
pd_deco2_aug,
pd_deco3,
pd_deco3_aug,
pd_deco4,
pd_deco4_aug,
pd_deco5,
pd_deco5_aug,
pd_deco6,
pd_deco6_aug,
enchant_effect,
pvp_flag,
karma,
fishing,
fishing_x,
fishing_y,
fishing_z,
invisible)
-- SELECT ALL L2Guard npc FROM npc TABLE AND INSERT INTO face_pcs TABLE
SELECT
id , '0', '0', '93', title, 'CC0000', name, 'FFFFFF', '4', '2', '1', '0', '0', '1', '0', '0', '0', '0', '6619', '1', '0', '0', '15582', '0', '16169', '0', '15579', '0', '15585', '0', '14609', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0' FROM npc WHERE type = "L2Guard";
-- ############## END ##############
PREVIEW
By d0ds at 2010-11-13