Tyrfing

Please verify that your SQL host, username, password and database name are correct in conf\inter_athena.conf. // MySQL Map Server map_server_ip: 127.0.0.1 map_server_port: 3306 map_server_id: ragnarok <~ should be set to your MySQL username map_server_pw: ragnarok <~ should be set to your MySQL password map_server_db: ragnarok <~ should be set to your MySQL database // MySQL Log Database log_db_ip: 127.0.0.1 log_db_port: 3306 log_db_id: ragnarok <~ should be set to your MySQL username log_db_pw: ragnarok <~ should be set to your MySQL password log_db_db: ragnarok <~ should be set to your MySQL database Pay attention that there are two places that you must update.

No. You have to decide: do you want to log your GM commands and cash to a text file or to your SQL database? If you want to log to a Text File 1. First, disable SQL logs (conf\log_athena.conf, line 40) // Use MySQL Logs? [SQL Version Only] (Note 1) sql_logs: no 2. Uncomment the first lines, comment the last ones. (conf\log_athena.conf, line 141) // Logging files/tables // Following settings specify where to log to. If 'sql_logs' is // enabled, SQL tables are assumed, otherwise flat files. log_gm_db: log/atcommandlog.log log_branch_db: log/branchlog.log log_chat_db: log/chatlog.log log_mvpdrop_db: log/mvplog.log log_npc_db: log/npclog.log log_pick_db: log/picklog.log log_zeny_db: log/zenylog.log log_cash_db: log/cashlog.log log_feeding_db: log/feedinglog.log //log_gm_db: atcommandlog //log_branch_db: branchlog //log_chat_db: chatlog //log_mvpdrop_db: mvplog //log_npc_db: npclog //log_pick_db: picklog //log_zeny_db: zenylog //log_cash_db: cashlog //log_feeding_db: feedinglog If you want to log to a SQL database 1. First, enable SQL logs (conf\log_athena.conf, line 40) // Use MySQL Logs? [SQL Version Only] (Note 1) sql_logs: yes 2. Comment the first lines, uncomment the last ones. (conf\log_athena.conf, line 141) // Logging files/tables // Following settings specify where to log to. If 'sql_logs' is // enabled, SQL tables are assumed, otherwise flat files. // log_gm_db: log/atcommandlog.log // log_branch_db: log/branchlog.log // log_chat_db: log/chatlog.log // log_mvpdrop_db: log/mvplog.log // log_npc_db: log/npclog.log // log_pick_db: log/picklog.log // log_zeny_db: log/zenylog.log // log_cash_db: log/cashlog.log // log_feeding_db: log/feedinglog.log log_gm_db: atcommandlog log_branch_db: branchlog log_chat_db: chatlog log_mvpdrop_db: mvplog log_npc_db: npclog log_pick_db: picklog log_zeny_db: zenylog log_cash_db: cashlog log_feeding_db: feedinglog

rAthena logs these by default at the atcommandlog and cashlog tables. You can verify this in conf\log_athena.conf: // Track Cash Changes // 0 - don't log // 1 - log any changes log_cash: 1 // Log AtCommands & Charcommands (Note 1) // Only commands issued by player groups ('conf/groups.conf') with // 'log_commands' setting set to 'true' will be logged. log_commands: yes // Logging files/tables // Following settings specify where to log to. If 'sql_logs' is // enabled, SQL tables are assumed, otherwise flat files. log_gm_db: atcommandlog log_cash_db: cashlog

Leider funktioniert "Custom Aura" nicht auf NEMO. Vielleicht wird es mit WeeDiffPatcher/Shin'sDiffPatcher funktionieren?

Bitte vergib mein schlechtes Deutsch. Leider funktioniert "Custom Aura" nicht auf NEMO.

rAthena provides international support. Since you don't speak English properly, next time please create your topics in the Portuguese Support sections. O rAthena oferece suporte internacional para não falantes de inglês. Já que você não fala inglês corretamente, da próxima vez por favor crie seus tópicos nas seções de Suporte em Português. Por favor, assegure-se de ter lido os tópicos de orientações sobre como obter ajuda antes de criar seus tópicos para maximizar as chances de solucionar seus problemas da forma mais rápida possível. Se você se refere aos erros que mostrou no seu primeiro post neste tópico, então eu já expliquei o problema neste post. O seu ragnarok está procurando os arquivos de Sprite e Action do item na sua data, e não está encontrando, porque você colocou o nome de arquivo errado nos arquivos de informação de itens. Se você se refere a um novo problema, poste aqui as novas mensagens de erro.

I'm sorry, I can't understand your English.

He is requesting a script that spawns modified porings in Prontera which drop item ID 1000.

conf\monster.conf: // Should the mob_db names override the mob names specified in the spawn files? // 0: No // 1: always use the mob_db Name column (english mob name) // 2: always use the mob_db JName column (original Kro mob name) override_mob_names: 0 Is this it?

I will NOT make a video. All the information you need is in my post.

English Explanation The Ragnarok Online executable, which we call client, reads from a file all the item information regarding the items you obtain in the game. For each game item, the client checks the file for the item's name, description, as well as the name for the image, Sprite and Action files If you're using a Renewal client, then this information is usually contained within the itemInfo.lub file inside the System folder, or another file if you modified your client to read them from another file (such as itemInfo.lua, for example). If you're using a pre-RE client, then this information is contained within some diferente files from the data folder, which are: data\idnum2itemdesctable.txt Item description if it HAS been identified by a Magnifier. data\idnum2itemdisplaynametable.txt Item name if it HAS been identified by a Magnifier. data\idnum2itemresnametable.txt The name for the Image, Sprite and Action files if it HAS been identified by a Magnifier. They all have the same name, but different extensions. data\num2itemdesctable.txt Item description if it HAS NOT been identified by a Magnifier. data\num2itemdisplaynametable.txt Item name if it HAS NOT been identified by a Magnifier. data\num2itemresnametable.txt The name for Image, Sprite and Action files for the item if it HAS NOT been identified by a Magnifier. Specifically in your case, you probably made a typo while adding the image, Sprite and Action file name in your item information file (itemInfo.lub or the other data files if your client is pre-RE). I say this because the images show that the client looked for the files called fronze_wings.spr and fronze_wings.act, when they probably should have been named frozen_wings.spr and frozen_wings.act, since in English the correct name is "frozen" and not "fronze". ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Portuguese Explanation

Check the following: The itemInfo.lub file MUST be in the System folder, not in the data folder. If you diffed your hexed with the Load Custom lua file instead of iteminfo*.lub patch, then you changed the itemInfo.lub file to another .lua file instead. In this case, you should make sure that your itemInfo.lub file is renamed accordingly. Since the user is Brazilian, I'll provide a portuguese translation of the post.

Por favor, evite discutir em um tópico assuntos relativos a outros tópicos. Porém, já que você já fez isso, aproveito para indicar que já respondi ao seu problema no seu outro tópico. Tyrfing

Topic titles such as "Help me" do not describe your issue at all, so please avoid them. You need to know what client version you are using. RE clients typically load information from the System\itemInfo.lub file, whereas non-RE clients load item information from data\idnum2itemresnumtable.txt. By diffing your RE client, you can also change that to System\itemInfo.lua. The basic difference is that the .lub file format is encrypted, while the .lua isn't, making it easier to add or remove custom items. Since the user is Brazilian, I'll provide a portuguese translation of the post.

Actually, the official ragnarok server a.k.a. AEGIS was originally written by Hakkyu Kim, and it was replete with inefficient code. Throughout history, bits and pieces of AEGIS leaked due to hackers invading ragnarok online's official servers, and they served as a base for creating the open-source emulators.

Como você sabe que a ROenglishRE-master é uma pasta data de 2017? A ROenglishRE é um projeto de tradução para o inglês da pasta data do kRO realizado pelo zackdreaver. O arquivo itemInfo.lua, por exemplo, foi atualizado há 2 meses. Se você procura uma pasta data em inglês mais atualizada do que essa, eu acho que não existe. Você pode tentar extrair os arquivos da GRF do iRO, mas eu acho que estão menos atualizados do que a ROenglishRE, ou tentar traduzir você mesmo os arquivos do kRO.

My bad. Thanks for the fix, pajodex.

What do you mean by custom clans?

I don't mean to be rude, but you could've just tried changing that setting before asking. It would've been much faster.

No need to drop it next time, just repair it. Open your MySQL console and execute the instruction: USE <database> REPAIR TABLE <table_name>;

Use this. * Removed because there was a bug in this version of the script. Please refer to this post for the bug-free version. *

Thanks for your feedback, @Nozomi and @mrmagic. @mrmagic: So, essentially, rAthena provides a very complete item_db which includes items not only from kRO but also from other official servers to widen support? @Nozomi: How did you find out that you needed such files? How did you come across pservero/idro-client-files?

How come these don't get patched into data.grf upon updating kRO with rsu-kro-rag-lite.exe and rsu-kro-renewal-lite.exe? I too get the .act and .spr error upon equipping the Item ID: 5979 (C Angel Fluttering), as seen on the annexed image, and a disconnection afterwards, though I'm using a 2015-11-04aRagexe client. Also, I too use the Client resources provided by zackdreaver, which have fixed many of my sprite errors, such as that of equipping an Antique Pipe.

Ok, you seem to be using an rAthena revision that does not support `clear` as an NPC command. Try this adapted version. /////////////////////////////////////////////////////// // ___________ _____.__ // \__ ___/__.__.________/ ____\__| ____ ____ // | | < | |\_ __ \ __\| |/ \ / ___\ // | | \___ | | | \/| | | | | \/ /_/ > // |____| / ____| |__| |__| |__|___| /\___ / // \/ Scripts \//_____/ // //===================================================== // Name: Paid Warper // // Description: // At a cost of items, a player will be warped to a map, // and he may retrieve 1/3 of them by talking to the NPC. // // Customizations: // .currency: set to the Item ID you would like the NPC // to trade for the warps. // // .cost: Amount of .currency item to give for each city. // .equip: Equipment ID to be wearing when claiming items. //===================================================== /////////////////////////////////////////////////////// - script Paid Warper 56,{ function WarpTo; function ClaimCurrency; set .npc_name$, "Paid Warper"; set .currency, 619; setarray .warpable_cities$[0], "Prontera", "Payon", "Morocc"; setarray .cost[0], 3, 3, 3; setarray .equip[0], 2293, 2294, 2295; if (!.initialized) { // Sets .warps$ to the valid warps according to the map the NPC is in for (.@i = 0; .@i < getarraysize(.warpable_cities$); .@i++) { set .warps$, .warps$ + (strtolower(.warpable_cities$[.@i]) == strnpcinfo(4) ? "" : .warpable_cities$[.@i]); if (.@i + 1 != getarraysize(.warpable_cities$)) set .warps$, .warps$ + ":"; } set .initialized, 1; } Begin: mes "[^00cc00"+ .npc_name$ +"^000000]"; mes "Hello, " + strcharinfo(0) + "!"; next; switch (select("Warp:Claim:Cancel")) { case 1: mes "[^00cc00"+ .npc_name$ +"^000000]"; mes "Where would you like to warp to?"; WarpTo(select(.warps$)); case 2: mes "[^00cc00"+ .npc_name$ +"^000000]"; mes "You have accumulated so far:"; for (.@i = 0; .@i < getarraysize(.warpable_cities$); .@i++) { mes .warpable_cities$[.@i] + ": " + warp_accumulator[.@i] + " " + getitemname(.currency); } mes "Which would you like to claim?"; next; ClaimCurrency(select(implode(.warpable_cities$, ":"))); } end; function WarpTo { set .@city, getarg(0) - 1; mes "To warp to " + .warpable_cities$[.@city] + ", you need to provide "+ .cost[.@city] +" "+ getitemname(.currency) + "."; mes "Is that okay?"; if (select("Yes:No") == 1) { if (countitem(.currency) < .cost[.@city]) { next; mes "[^00cc00"+ .npc_name$ +"^000000]"; mes "I am sorry, you need " + .cost[.@city] + " " + getitemname(.currency) + " to warp, but you only have " + countitem(.currency) + "."; next; goto Begin; } delitem .currency,.cost[.@city]; warp_accumulator[.@city]++; atcommand "@go " + .warpable_cities$[.@city]; next; } next; goto Begin; return; } function ClaimCurrency { set .@city, getarg(0) - 1; set .@necessary_equip, .equip[.@city]; if (warp_accumulator[.@city] == 0) { mes "[^00cc00"+ .npc_name$ +"^000000]"; mes "You don't have any "+ getitemname(.currency) +"s to retrieve."; next; } else if(isequipped(.@necessary_equip)) { mes "[^00cc00"+ .npc_name$ +"^000000]"; mes "Here you are!"; getitem .currency,warp_accumulator[.@city]; warp_accumulator[.@city] = 0; next; } else { mes "[^00cc00"+ .npc_name$ +"^000000]"; mes "I'm sorry, you need to be wearing " + getitemname(.@necessary_equip) + " to retrieve your items."; next; } goto Begin; return; } } prontera,163,184,4 duplicate(Paid Warper) Paid Warper#prt 56 payon,177,104,4 duplicate(Paid Warper) Paid Warper#pay 56 morocc,152,97,4 duplicate(Paid Warper) Paid Warper#moc 56

Please, can you provide a screenshot of the error in map_serv?