[Register account manually in SQL by inserting in the table]

Does registering account manually in SQL by inserting in the table causes some bugs?

 

Haven't encountered problems though. Inserted login accounts on the `login` table. The Vote4Point problems must be related on how you configured the CP you used, not Game Database related but Web Database related. 

[2012-04-10a SVN 17230 [ CANNOT SEE GUILD EMBLEM OF OTHER PLAYERS ]]

Try to update on the latest SVN. 

[Add item in all accounts.]

It'll be more easier to have the items "INSERTED" on every account's storage by making a database-side query 

 

Here's the query, for adding the Halter Lead (Item #12622) on all storages of players. the database name is 'ragnarok' for me.

 

 

INSERT INTO `ragnarok`.`storage` (`id`, `account_id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `card0`, `card1`, `card2`, `card3`, `expire_time`, `unique_id`) SELECT  NULL, `login`.`account_id`, '12622', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0' FROM `ragnarok`.`login` WHERE `account_id` > 1;

 

Hope it helps! 

[Color ?]

Hi! As nana said, correctly place the lua files on the skillinfoz folder:

 

data\luafiles514\lua files\skillinfoz

 

Here's the content of my skillinfoz folder, already translated in EN.

 

http://www.mediafire.com/?xhed115x67v6g6n

 

[Status Point Reset [Server Wide]]

Got it. Here's for pre-renewal. It's the SQL query for resetting status points globally while retaining their status points depending on their base levels.

 

UPDATE `char` SET `str` = '5',`agi` = '5',`vit` = '5',`int` = '5',`dex` = '5',`luk` = '5', `status_point`=((((5+base_level/5)*base_level/5)/2)*5 + (base_level/5+3)*(base_level%5)) - 3;

[Status Point Reset [Server Wide]]

There should be a status point formula. I've been googling all over... But I haven't found the status point formula.

[SQLI]

Check your MySQL privileges and accounts, maybe someone has access to an account that shouldn't be. Try to change yoaur password too.

[Status Point Reset [Server Wide]]

Hi, I just want to ask how to reset the status points of all players on the server with automatic reapplication of the all the status points that are "left" just like what the Build Manager NPC does.

 

Because I tried to use this SQL Query

 

UPDATE `char` SET `str` = '0',`agi` = '0',`vit` = '0',`int` = '0',`dex` = '0',`luk` = '0';

 

Well, it updated all the character's status to 0, but the problem is, what about the characters who are currently at their max levels and must have retained the total status points they've aqcuired through leveling.

 

Thank you!

[2012 Client Translation]

It's on your LUA file --> 'data\luafiles514\lua files\navigation' 

 Got a problem, because it's a LUB file. I don't really understand decompiling the lub to luas very well.

Do anyone have a lua file for the npc icon texts? Even if they aren't fully translated, I'll try to help out in translating them.

[r17228: Channel System (replacement for @main)]

so cool! rAthena devs are really awesome!    

[How to Fix Shows [WARNING]]

I'm using the same client 2012-04-10.

 

But in the clientinfo.xml, the version I used was this <version>20</version>

[Color ?]

Maybe you included an official grf to your DATA.INI list from an official RO. They are using 32 bit bmp files on some of the icons and buttons which for some reason is not supported by most of the clients.

 

I encountered that problem too one time, when I tried to include translated english buttons from an official grf to the grf i'm creating. That error pop up too. ILuckily I found translated buttons that were compatible here in rAthena forums.

 

It's because the image bmp file format weren't supported. 

For the gibberish text, I think you should diff your client using Shin's Diff Patcher to have the gibberish Korean text translated to English. Be sure to have the needed plugin for the translation.

[2012 Client Translation]

Hi, I saw this korean words still untranslated. I used Swadon's diff file on Shin's Diff Patcher.

Where can I find these strings so I can have this translated too? Actually, it's the same with those text on the icons on the map (upper right portion) that still appears to have korean gibberish. Related to the names of the NPCs and portals I guess..

 

Just need the help in finding what file I should look into!

 

[2012 Client Translation]

Hi, I'm new and learning hexing. This guide is really cool. Thank you nanakiwurtz for teaching us. I'll try to help out too! 

[Translation for PIN Code Buttons]

here

 

try the search function 1st next time

 

Thank you! Actually, I googled so many buttons.. But it's returning an error "Only 16M and 8Bit are supported"

This one is working!

[Translation for PIN Code Buttons]

Hi, I hope someone can share in the buttons for the PIN Code screen.

 

I downloaded the English translation pack but it seems those new buttons wasn't there.

 

[GM commands and disabling MvP card]

oh wow.. tyvm! and.. now how to disable MvP cards? change the drops not work

 

You need to modify the drop list on the mob db txt files if you want to disable the drops, same as modifying their drop rate percentages

Checkout this link for better information: http://rathena.org/wiki/Custom_Mobs

[[ERROR] Unkown Packet version]

Hi! I also got this problem... The SkipPacketHeaderObfuscation is not appearing on the list of diffs on Shin's Diff Patcher although it's on the plugins folder.

 

You may wanna try out the By pass client for 2012-04-10... http://supportmii.com/ro1/Clients/Bypass_Clients/

It didn't need the skippacketheaderobfuscation... I just loaded the default patch that the program suggested. It worked for me.

 

One more thing.. check the packet version on the clientinfo.xml.. 

 

 

What does this phrase means anyway "SkipPacketHeaderObfuscation"?? XD

[@command that triggers an NPC]

bindatcmd is not used only for existing commands....it allow you to add a "new" @commands using npc script...that bind to certain npc label and execute the label if it's used.

 

Thank you Emistry! bindatcmd is really an easy way for adding a new command via script, but is there any another way to call an NPC by making a new command on the atcommand.c source so it'll really be part of the server files?

[@command that triggers an NPC]

Bindatcmd

 

Thanks for the reply! I tried it on the command @heal and it actually works. My problem though is concerned with the source, adding a new @command which may or may not be with relation to the bindatcmd. For what I've observed, the bindatcmd is used for exisiting @commands already. But if I were to add a new @command that I can connect to the bindatcmd, how will I be able to do that? Thank you!

[@command that triggers an NPC]

Hi! I hope someone would help me in making an @command that triggers an NPC, for example, I will be making a command @bank, and then the Banker NPC will be triggered (the NPCs window will pop-up just like talking to it directly)

[Is there any guides to start-off in Source Modification for rAthena?]

Hi! I really want to start-off learning source modification. But how can I start?

 

I read about the server mod. link on the wiki, but off course, can't really understand it at a first glance.

[Inventory Check for Refined items]

Hi! I hope someone could help me out in making an inventory check whether a player have an item that has an upgrade.

 

I want to make an NPC where it will receive an upgraded headgear/item (+7, +8, +9) and it will do the check whether the player has it (and the correct refinement +) so that the script will continue on making a reward trade..

[Latest item_db and item_db2]

Hi! I hope someone could help me in finding lastest item_dbs that contain the Asgard Bless item. I'm downloaded a lot of item_dbs. Seems I can't get the right one.

[MySQL Error]

Thanks guys!