ankana

Hi Bahmut, i have tried to combine the current Miruku data.grf with newest updated english translated data folder. At the moment i try to repack the grf i got an error message GRFRepack Error 2 - i think its because of combining korean and englisch files within one grf file. Does anyone has a complete working english data.grf file? PS: with the current data.grf file from the actual MirukuClient i got many Client Sprite errors because of missing sprites or something else, no item picture is shown, and if i scroll through the npc-item-list to one of the missing items i got sprite errors. I have created shop npc's for all armors, weapons, cards etc. with the item_db file of the current rathena ServerRelease -> but it seems that not all items of the item_db file are within the MirukuClient data.grf. Regards Ankana

If Anyone find this Code useful, maybe someone can move this thread to the "script releases".

Hi@all, does any1 have an english data.grf and rdata.grf for the latest MirukuClient, or give a link so i can download it?

I will test it - if im home later. Thanks in Advance Ankana Yeah - i did it - now everything works as mentioned. I'll post it here, if i'm home in the evening. What is the npc doing: 1) search for a given itemname within the database 2) show a list of available items containing this part of item within the name as a menu (maybe i'll sort them within the menu) 3) ask for an amount of these item 4) put the amount of the selected item into the player's inventory See ya later Ankana prontera.gat,150,186,5 script Item-Distributor 109,{ mes "[item-Distributor]"; mes "Which item are you looking for?"; next; input .@item$; set @nb,query_sql("select `id`,`name_japanese`,`slots` from `item_db` where `name_japanese` LIKE '%"+.@item$+"%'",.@itemid,.@itemname$,.@slots); mes "[item-Distributor]"; mes "Item Search for : "+.@item$; set $@menu$,"Cancel"; for(set .@i, 0;.@i < getarraysize(.@itemid);set .@i, .@i + 1){ set .@menu$,.@menu$+":"+.@itemname$[.@i]+"["+.@slots[.@i]+"]"; //mes .@itemname$[.@i]+"["+.@slots[.@i]+"] (ID "+.@itemid[.@i]+")"; } mes "Please select your wanted Item from the List."; set .@part,select(.@menu$); mes "How Many Items do you want ?"; input .@number; next; set .@part,.@part -2; mes .@number+" "+.@itemname$[.@part]+"(ID "+.@itemid[.@part]+") was created."; getItem .@itemid[.@part],.@number; close; }

Thanks for the quick answer. So referring to your answer i have (i hope correctly) changed the code into: prontera.gat,xxx,yyy,7<tab>script<tab>Item-Watcher<tab>811,{ mes "[item-Watcher]"; mes "Which item are you looking for?"; input .@item$; query_sql "SELECT `id`,`name_english` FROM `item_db` WHERE `name_english` LIKE "+.@item$, .@itemid, .@itemname$; for(set @i, 0; @i < getarraysize(.@itemname); set @i,@i + 1){ mes .@itemname$[@i]+"("+.@itemid$+")"; } So if this is now nearly correct, i now have to find a solution for the switch-menu of the listed items Thanks Ankana

Hi @all Scripter, i need some help with a special npc. I want to create a npc that can search for a given itemname within the database, show the output within the text-window as a menu for the player - and then the player can klick on one of these items and push a button for example "OK", and then the item will be given to the player. I have tried to create this npc, but im not a well scripter, so this is everything i have written so foar: prontera.gat,xxx,yyy,7<tab>script<tab>Item-Watcher<tab>811,{ mes "[item-Watcher]"; mes "Which item are you looking for?"; input @item; query_sql "SELECT id,name_english FROM `itemdb` WHERE `name_english` LIKE @item", @liste; for(set @i, 0; @i < getarraysize(@liste); set @i,@i + 1){ mes @liste[@i]; } .... Can please someone help me. Kind Regards Ankana