Special Scrolls Request

[devdash]

iam creating a new server and i have learned all the basics and now i want to start i hope you can help me with
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Race Change Scroll

EXPLAIN: changing character race from European to Chinese and change Chinese to European
NOTE: Auto recall recommended please NO DC required
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Reset Stat Points Scroll

EXPLAIN: reset all the activited & unactivited stat points and give a spcific stat point that i can edit it
NOTE: Auto recall recommended please NO DC required
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Reset Skills Scroll

EXPLAIN: reset all the skills and mysterys and give a spcific skill points that i can edit it
NOTE: Auto recall recommended please NO DC required
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Silk Scroll

EXPLAIN: gives a spcific silk amount that i can edit
NOTE: Auto recall recommended please NO DC required
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Graduate Scroll

EXPLAIN: gives graduate and honor points that i can edit
NOTE: Auto recall recommended please NO DC required
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
thanks in advance, this may help alot of begginers

[devdash]

if anyone there think iam lazy to search, nope i just see alot of ideas over there and iam not the man who should decide which one should i use, so please pick for me, since u got the exp...on that scene

[MrCatGardens]

Silk Scroll

EXPLAIN: gives a spcific silk amount that i can edit
NOTE: Auto recall recommended please NO DC required

This should be simple. Copy a Return Scroll
Then Edit the medialines (description, name, ...)
add some lines to your addlogitem stored procedure. Its like:

if itemid = --here comes your refitemid--
exec --here comes the stored procedure for silk, sth. webpurchasesilk (just search at sp's from account db) --

in the evening i'll be able to send you a real example, but shouldn't be difficult to figure out yourself.

It's every time the same... listen for a specific itemid, execute some statements. maybe you need to declare the accountid, since it's not implemented at addlogitem by default. with the given charid you'll be able to select your accountid

this way works for all scrolls, only the rance changer. here are alot of checks required. like no items at any avatarslot, char needs to be logged of (as far as i can remember)...