Query to add items to new character

i need that Query to add items to new character
like if i make male EU character with robe set i will start with male robe
same to china

i see it before and tested works 100% but didnt remember the link :(

Quote:

---

Originally Posted by nybo94

i hope this help you

PHP Code:

---


-----------------------------------------------------------------------------        
    -- CharList¿¡ ID ³Ö¾îÁֱ⠠      
    -----------------------------------------------------------------------------        
    INSERT _CharNameList VALUES(@CharName, @NewCharID) 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_REVERSE_RETURN_SCROLL',20,1                         
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_03',20,1
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SPEED_UP_BASIC',20,1
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_ARENA_COIN' ,2500,1
    if @RefCharID>=1907 and @RefCharID<=1919 -- male
    begin
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_HALLOWEEN',0,0
    end 
    if @RefCharID>=14875 and @RefCharID<=14887  --male
    begin
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_HALLOWEEN',0,0
    end
    if @RefCharID>=1920 and @RefCharID<=1932 --female
    begin
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_HALLOWEEN',0,0
    end 
    if @RefCharID>=14888 and @RefCharID<=14900  --female
    begin
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_HALLOWEEN',0,0
    end   
    -- Quick Slot Á¤º¸ ÀúÀå¿ë!!!        
    exec _AddNewClientConfig @NewCharID  -- by novice...... for saving client configurations... 


---

---

Hope Help u!

yes thanks bro i got it form other post was you too xD

Thanks Madelyn for help :) I was need it too

I love you ^^