[DEV-In work] Database uniquescroll adder

03/13/2012 22:32 Devsome#1
Hello epvp,

I release my half finish programm and all codes you need to add Uniquescrolls.
It's for Titan uniquescrolls only !


ItemdataX.txt (x the last Itemdata in your media.pk2)
You need to edit the 41798 to 41801 to your last numbers
Code:
1	41798	ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	???	xxx	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	1	1	1	255	0	1	0	0	1	0	100000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	xxx	xxx	5	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	-1	MOB_CH_TIGERWOMAN_L3	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	41799	ITEM_SCROLL_MOB_OA_URUCHI_L3	???	xxx	SN_ITEM_SCROLL_MOB_OA_URUCHI_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	1	1	1	255	0	1	0	0	1	0	150000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	xxx	xxx	5	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	-1	MOB_OA_URUCHI_L3	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	41800	ITEM_SCROLL_MOB_KK_ISYUTARU_L3	???	xxx	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	1	1	1	255	0	1	0	0	1	0	200000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	xxx	xxx	5	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	-1	MOB_KK_ISYUTARU_L3	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	41801	ITEM_SCROLL_MOB_TK_BONELORD_L3	???	xxx	SN_ITEM_SCROLL_MOB_TK_BONELORD_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	1	1	1	255	0	1	0	0	1	0	300000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	xxx	xxx	5	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	-1	MOB_TK_BONELORD_L3	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
RefObjCommon
You need to edit the number 41799 to 41802 to your last !
At the end each line 21334 to 21337 , you need to edit it , too !
Code:
1	41799	ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	???	xxx	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	0	1	1	255	3	1	0	0	1	0	100000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	XXX	XXX	21334
1	41800	ITEM_SCROLL_MOB_OA_URUCHI_L3	???	xxx	SN_ITEM_SCROLL_MOB_OA_URUCHI_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	0	1	1	255	3	1	0	0	1	0	150000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	XXX	XXX	21335
1	41801	ITEM_SCROLL_MOB_KK_ISYUTARU_L3	???	xxx	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	0	1	1	255	3	1	0	0	1	0	200000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	XXX	XXX	21336
1	41802	ITEM_SCROLL_MOB_TK_BONELORD_L3	???	xxx	SN_ITEM_SCROLL_MOB_TK_BONELORD_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	0	1	1	255	3	1	0	0	1	0	300000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	XXX	XXX	21337
RefObjItem
Here is the first Number the same as in RefObjCommon the last !!
Code:
21334	5	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	MOB_CH_TIGERWOMAN_L3	-1	xxx                                                                                                                              	-1	xxx	-1	xxxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
21335	5	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	MOB_OA_URUCHI_L3	-1	xxx                                                                                                                              	-1	xxx	-1	xxxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
21336	5	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	MOB_KK_ISYUTARU_L3	-1	xxx                                                                                                                              	-1	xxx	-1	xxxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
21337	5	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	MOB_TK_BONELORD_L3	-1	xxx                                                                                                                              	-1	xxx	-1	xxxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

refpackageitem
Change the number from 84045 to 84048 , with your numbers.
Code:
1	15	84045	PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	0	EXPAND_TERM_ALL	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	item\etc\e050729_summon_scroll.ddj	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	84046	PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3	0	EXPAND_TERM_ALL	SN_ITEM_SCROLL_MOB_OA_URUCHI_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	item\etc\e050729_summon_scroll.ddj	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	84047	PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	0	EXPAND_TERM_ALL	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	item\etc\e050729_summon_scroll.ddj	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	84048	PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3	0	EXPAND_TERM_ALL	SN_ITEM_SCROLL_MOB_TK_BONELORD_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	item\etc\e050729_summon_scroll.ddj	-1	xxx	-1	xxx	-1	xxx	-1	xxx
refpricepolicyofitem
Here are the price 10.00.00.000 Gold for Tigerwoman, 15.00.00.000 for Uruchi and so on...
Code:
1	15	PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	1	0	100000000	-1	xxx	0	xxx	0	xxx	0	xxx
1	15	PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3	1	0	150000000	-1	xxx	0	xxx	0	xxx	0	xxx
1	15	PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	1	0	200000000	-1	xxx	0	xxx	0	xxx	0	xxx
1	15	PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3	1	0	300000000	-1	xxx	0	xxx	0	xxx	0	xxx
refscrapofpackageitem
Change the last numbers to your last numbers !
Code:
1	15	PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	86691
1	15	PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3	ITEM_SCROLL_MOB_OA_URUCHI_L3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	86692
1	15	PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	ITEM_SCROLL_MOB_KK_ISYUTARU_L3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	86693
1	15	PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3	ITEM_SCROLL_MOB_TK_BONELORD_L3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	86694
refshopgoods
To put it in any NPC , I choose the arena manager (STORE_BATTLE_ARENA_EU_TAB1)
Code:
1	15	STORE_BATTLE_ARENA_EU_TAB1	PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_BATTLE_ARENA_EU_TAB1	PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_BATTLE_ARENA_EU_TAB1	PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	2	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_BATTLE_ARENA_EU_TAB1	PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3	3	-1	xxx	-1	xxx	-1	xxx	-1	xxx
textdata_object
Last but not least the text add the item
Its for all scrolls normal, strong and titan !
Code:
//Unique Scrolls
1	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	0	0	0	0	<sml2>Scroll which summons a special Monster<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Target another player and use the scroll.<br><br><strong><font color="255,236,219,156">Restriction</font></strong><br>Can be used only after targeting a player.<br>Summoned Unique will not spawn with an unique notice.</sml2>	<sml2>Scroll which summons a special Monster<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Target another player and use the scroll.<br><br><strong><font color="255,236,219,156">Restriction</font></strong><br>Can be used only after targeting a player.<br>Summoned Unique will not spawn with an unique notice.</sml2>	0	0	0	0	0	0
1	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN	0	0	0	0	0	0	Tiger Girl Summon Scroll	Tiger Girl Summon Scroll	0	0	0	0	0	0
1	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L2	0	0	0	0	0	0	Strong Tiger Girl Summon Scroll	Strong Tiger Girl Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	0	0	0	0	0	0	Tiger Girl (Titan) Summon Scroll	Tiger Girl (Titan) Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_EU_KERBEROS	0	0	0	Cerberus Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_OA_URUCHI	0	0	0	Uruchi Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_OA_URUCHI_L2	0	0	0	Strong Uruchi Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_OA_URUCHI_L3	0	0	0	0	0	0	Uruchi (Titan) Summon Scroll	Uruchi (Titan) Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_KK_ISYUTARU	0	0	0	Isyutaru Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L2	0	0	0	Strong Isyutaru Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	0	0	0	0	0	0	Isyutaru (Titan) Summon Scroll	Isyutaru (Titan) Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_TK_BONELORD	0	0	0	Lord Yarkan Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_TK_BONELORD_L2	0	0	0	Strong Lord Yarkan Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_TK_BONELORD_L3	0	0	0	0	0	0	Lord Yarkan (Titan) Summon Scroll	Lord Yarkan (Titan) Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_RM_TAHOMET	0	0	0	Demon Shaitan Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_RM_TAHOMET_L2	0	0	0	Strong Demon Shaitan Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_RM_TAHOMET_L3	0	0	0	Demon Shaitan (Titan) Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_TQ_FLAMEMASTER	0	0	0	Shinmoo Summon Scroll	0	0	0	0
1	SN_ITEM_SCROLL_MOB_RM_ROC	0	0	0	Roc Summon Scroll	0	0	0	0



DL Sourcecocode:
[Only registered and activated users can see links. Click Here To Register...]

Programm picture:
[Only registered and activated users can see links. Click Here To Register...]
03/15/2012 16:31 Dr.Abdelfattah#2
Nice work Keep it up
03/17/2012 23:37 6_lucifer_6#3
how should i know that this "tool" wont fck my db up? XD
03/18/2012 02:04 Devsome#4
When I release the tool , I will also write the code you need to do add it on your own.
03/18/2012 10:35 SunSoon#5
where Download ?:P
03/18/2012 12:15 •ᵔBeGodOfWarᵔ•#6
|very fckn awesome tool| thanks :D
03/18/2012 13:37 CapitanJack#7
You using it on own risk ^^
03/21/2012 12:13 CrazyGirL_ZSZC#8
this scrolls will add to npc?
03/21/2012 12:44 CrystalCoder#9
whan you think will be download?
03/21/2012 13:10 BestOnWorld#10
Nice work Keep it up
03/21/2012 19:25 Devsome#11
It will not add to the npc.
At the moment i am a little bit bussy.
But I will release the tool as sone as possible
03/28/2012 12:52 ahmed4ever2u#12
bump
03/28/2012 14:34 Devsome#13
At the moment I'm a bit bussy.
I think I will release the sourcecode + the codes for adding unique scrolls manuel.
04/13/2012 01:40 Devsome#14
I'm busy at the moment.
On this weekend I will release the tool 25% finish and the stuff you can add manual on the database.
04/14/2012 16:58 Devsome#15
Update post 1#

Released the unfinish tool and all the code, but can't change the Thread title !!!!