douga Posted November 1, 2010 Share Posted November 1, 2010 very nice man good work keep sharing Quote Link to comment Share on other sites More sharing options...
Kup9_RU Posted November 2, 2010 Share Posted November 2, 2010 http://pastebin.com/M0b5yYkW No Code :( Quote Link to comment Share on other sites More sharing options...
Kup9_RU Posted November 3, 2010 Share Posted November 3, 2010 code pliz :( UP! Quote Link to comment Share on other sites More sharing options...
Mazoul Posted November 4, 2010 Share Posted November 4, 2010 code pliz :( UP! http://pastebin.com/3fgbwNKf Quote Link to comment Share on other sites More sharing options...
Kup9_RU Posted November 5, 2010 Share Posted November 5, 2010 thx Big Quote Link to comment Share on other sites More sharing options...
L2Raijin Posted November 5, 2010 Share Posted November 5, 2010 Wow dude ;) thanks for this unique idea! Waiting till u fix broken link Quote Link to comment Share on other sites More sharing options...
Messi00 Posted November 5, 2010 Share Posted November 5, 2010 Thx for this its really usefull :) Quote Link to comment Share on other sites More sharing options...
d0ds™ Posted November 13, 2010 Share Posted November 13, 2010 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 Quote Link to comment Share on other sites More sharing options...
Poseid0nL2 Posted November 14, 2010 Share Posted November 14, 2010 Core Side Dont Work :S Quote Link to comment Share on other sites More sharing options...
lexua Posted November 14, 2010 Share Posted November 14, 2010 where i need get for epilogue or this work on epilogue ? Quote Link to comment Share on other sites More sharing options...
Onix Posted November 14, 2010 Share Posted November 14, 2010 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 . Quote Link to comment Share on other sites More sharing options...
badriniki Posted November 25, 2010 Share Posted November 25, 2010 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? Quote Link to comment Share on other sites More sharing options...
Hardstyle Posted November 26, 2010 Share Posted November 26, 2010 update link please .... Core Side: http://pastebin.com/M0b5yYkW link down.. Quote Link to comment Share on other sites More sharing options...
+cs.tribal Posted November 26, 2010 Share Posted November 26, 2010 can that be applied on l2jserver/freya last revision without any modifications? Quote Link to comment Share on other sites More sharing options...
d0ds™ Posted November 27, 2010 Share Posted November 27, 2010 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! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.