superman1001

i want to make an npc that will give named swords[4] (id 1102), for example: if the char is named "char01" it will give "car01's sword". if i use getnameditem 1102,getcharid(0); it give a "char01's sword" without slots. so i used this: getitem2 1102,1,1,0,0,255,0,getcharid(0)&0xffff,(getcharid(0)>>16)&0xffff; same as getnameditem... so i tryed this: getitem2 1102,1,1,0,0,0,0,getcharid(0)&0xffff,(getcharid(0)>>16)&0xffff; it give a non-named sword[4] with 2 empty slots and 2 slots with an apple inside... so how to got a char01's sword[4] ?

and a guide or a complete list about bonuses such as bAllStats, bBaseAtk, bMatkRate, bHPDrainRate, etc?

ok thx, so how to execute pure sql in npc script?

Where can i find a complete guide for npc script? and a complete npc functions script reference? and how to read/write to db?

already put in the db, the problem is they are shown as not-usable items in the inventory, so i can't wear even if i double click on them...

the tuxedo and wedding dress are shown as non-wereable item. How to make them wereable? thx

When a Santa's Bag (12132) is used, it change the job skin into santa for 10 min. During this time the char is not able to attack. is it possibile to enable char attach when santa bags is in use? thx

i was looking for something like this: http://rathena.org/b...ite/#entry75235 Ok, i check the free ids, here is the full table: http://sdrv.ms/OkFIdD there are some range not shown in the wiki and some wiki information are wrong. what happen if i put a two-handed sword in the one-handed sword range?

what are the difference of ea and rathena?

so i can't adding all weapon i want? and i can't use custom item id? O.o ..and where have i to put the spr/act?! i already read the custom item wiki, btw there is no any information about weapon folders......

where have i to put the sprites? and how to configure lua files for weapon?

i got problems with some sprites, the sprites are displayed on the character foot! how can i fix it?

let me try... i used ShinsDiffPatcher with weediffgenerator 1.0.2 to make custom ids up to 30.000 then i used luac5.1.4 to rebuild accname.lub and accessoryid.lub (the wiki is wrog, the right params are: -o accessoryid.lub accessoryid.lua) then i setted view_id to 0, restarted server.. and... now when the client load it show this error: btw when i log on and - if u use view_id 0, i can wear it, but nothing is shown - if i use view_id 25001 i see this error: http://img152.images...00/44455045.png wow, i solved it, for now... there was an error in accessoryid.lua, and the spr must have a lower case name... i try do add another one..

there is a thing i don't understand in the "lua guide": so have i to edit the files, delete the modified files and recompile them? how is it possible?

how to use these files? i will check and eventually re-diff as soon as possible

accname.lua, accessoryid.lua nothing itemdb2: 25001, Test_Item, Test Item, 5, 100000, 10, 1000, , 10, , 4, 4294967295, 1, 2, 512, , 0, 0, 25001, , ,

ok but the problem is when the item is wear...

itemslotcounttable.txt 25001#4# idnum2itemdisplaynametable.txt 25001#test_item# idnum2itemdesctable.txt 25001# test item Weight :^777777 1^000000 Applicable Job :^777777 Every Job^000000 # idnum2itemresnametable.txt 25001#test_item#

i want to add some sprite in my server, so i followed this guida: http://rathena.org/wiki/Custom_Items for adding a test item. Server site there are no problems. In client side i got this error: i put the files in correct folders: - data\sprite\¾ÆÀÌÅÛ\test_item.act - data\sprite\¾ÆÀÌÅÛ\test_item.spr - data\sprite\¾Ç¼¼»ç¸®\¿©\¿©_test_item.act - data\sprite\¾Ç¼¼»ç¸®\¿©\¿©_test_item.spr - data\sprite\¾Ç¼¼»ç¸®\³²\³²_test_item.act - data\sprite\¾Ç¼¼»ç¸®\³²\³²_test_item.spr - data\texture\À¯ÀúÀÎÅÍÆäÀ̽º\collection\test_item.bmp - data\texture\À¯ÀúÀÎÅÍÆäÀ̽º\item\test_item.bmp if i create the item, hold in inventory, drop on the groud, it is shown, when i wear it i got the error. what's wrong? and why the client don't use the "test_item" act & spr but that incomprensible name? thx

ok i done and it works! thx a lot!

i get it from here: http://sourceforge.net/projects/rathena/files/trunk/ it was already compiled

in the char selecting screen i got an error: "pachet lenght 112", the client doesn't crash, but in game i can't see any mobs and npcs even if they attack my char. how can i fix?

i solved it! i removed all empty and commented lines, then split every 1500 lines it works both phpmyadmin and mysql workbench thx for all

Hi Asura, thx for your reply. i used mysql workbench but it crash down every time i execute the script, so i try with phpmyadmin that shows that error

i have a problem importing sql script into mysql, i get the pre-compiled r16113 from sourceforge... when i try to import item_db.sql mysql swhows this error: # REPLACE INTO `item_db` VALUES (5693,'No_Fear_Underware','No Fear Underwear',5,0,NULL,0,NULL,10,NULL,0,0xFFFFFFFF,7,2,256,NULL,20,0,30,'bonus bStr,1; bonus bInt,1; bonus bDex,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5694,'No_Fear_P_Headgear','No Fear P Headgear',5,0,NULL,0,NULL,1,NULL,1,0xFFFFFFFE,7,2,256,NULL,20,0,614,'bonus bVit,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5695,'E_Blue_Drooping_Kitty','E Blue Drooping Kitty',5,250000,NULL,500,NULL,1,NULL,0,0,7,2,256,NULL,0,1,277,'bonus bMdef,15;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5696,'E_Flying_Angel','E Flying Angel',5,20,NULL,300,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,10,1,264,'bonus bInt,1; bonus bAgi,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5697,'E_Smoking_Pipe_','E Smoking Pipe',5,20,NULL,100,NULL,0,NULL,0,0,7,2,1,NULL,0,0,55,'bonus bVit,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5698,'E_Pair_OE_Red_Ribbon_','E Pair OE Red Ribbon',5,20,NULL,100,NULL,1,NULL,0,0,7,2,512,NULL,45,0,169,NUL[...] MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REPLACE INTO `item_db` VALUES (5741,'Im_Egg_Shell_Hat','Eternal Egg Shell',5,20,' at line 49 what's wrong?