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

[douga]

very nice man good work keep sharing

[Kup9_RU]

http://pastebin.com/M0b5yYkW

 

No Code :(

[Kup9_RU]

code pliz :(

UP!

[Mazoul]

code pliz :(

UP!

 

http://pastebin.com/3fgbwNKf

[Kup9_RU]

thx Big

[L2Raijin]

Wow dude ;) thanks for this unique idea!

Waiting till u fix broken link

[Messi00]

Thx for this its really usefull :)

[d0ds™]

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

[Poseid0nL2]

Core Side Dont Work :S

[lexua]

where i need get for epilogue or this work on epilogue ?

[Onix]

where i need get for epilogue or this work on epilogue ?

 

you can add it on epilogue too, but you need change imports and edit a little sql file .

[badriniki]

I have one question, if i make one Fake PC did it will be writed in comunity board? :) if not, how i can make it if have any idea?

[Hardstyle]

update link please ....

Core Side:

http://pastebin.com/M0b5yYkW

 

link down..

 

[+cs.tribal]

can that be applied on l2jserver/freya last revision without any modifications?

[d0ds™]

can that be applied on l2jserver/freya last revision without any modifications?

hmmm.. I think its okay... I use latest Freya Rev.. and no errors!