[Guide] How to make Cristmas Tree [Shop]

[Beautiful]

U need only change position in t_shop for NPC id 1189

and add item for this NPC in t_shop_item

[lol102]

how to add the id ?

[lol102]

I dont see the christmas tree (sorry for spam)

[rioking]

SNOWMAN xD

 

[lol102]

How can i make the tree working ?

[Beautiful]

INSERT INTO `t_shop` (`a_keeper_idx`, `a_zone_num`, `a_name`, `a_name_twn`, `a_name_chn`, `a_sell_rate`, `a_buy_rate`, `a_pos_x`, `a_pos_z`, `a_pos_h`, `a_pos_r`, `a_y_layer`, `a_name_thai`, `a_name_thai_eng`, `a_name_jpn`, `a_name_mal`, `a_name_mal_eng`, `a_name_usa`, `a_name_brz`, `a_name_hk`) VALUES
(1189, 0, Christmas Tree, , , 40, 100, your x pos, your z pos, 160, -45, 0, , , , , , , , );

 

Look in game x and z pos, write this to code, paste to console, and have fun))

 

P.S. This code only for Juno town!

[lol102]

I got a message that i have an error in my mysql syntax

[Beautiful]

u strong man -_- very strong...

Send me your code

[lol102]

i add your code in console

[Beautiful]

edit your x pos and your z pos