Jump to content

[Share]Visual NPC to PC transform [Freya/High Five]


pipiou21

Recommended Posts

Ow some! thanks for share it!

shot00005vm.png

 

 

 

 

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

69470452.jpg

22697317.jpg

By d0ds at 2010-11-13

Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...