[rAthena Gui in Windows]

Great work, but nobody uses Windows for production. 

[[Proposal] Remote NPC script loading]

Sounds risky. The lack of access to the source code poses a significant security risk (e.g. leaving backdoor access or sql queries that can be injected). 

Perhaps rA could have a code review committee that will only publish scripts in the marketplace that have been reviewed and tested to be error-free and exploit-free.

Great idea nevertheless.

[[w0w] Advanced Maps Project]

Great release!

[Gepard - whitelist to enable botting.]

The server owner can create an API for you that fetches the vending data. Stop making it complicated, haha.

[PK points to be account bound instead of char bound]

if( countstr( implode( @killed$, "|" ), ""+killedrid, 0 ) <= .rstrk_l ) {
        #pk_points++;
        dispbottom "You've gained one point! Your total is ["+pk_points+"] PK point(s).";
    }

 

[removing close button]

Use goto function if you wish to redirect the players to another menu or message. 

[Poring Race [ Error ] : buildin_getmapxy:]

Just change the function, checkevent. Find a workaround to prevent players from joining when the race is ongoing.

[Episode 5: Mob Spawn and Mob Database]

Hello, everyone!

I'm Lynx of SolaceRO. I'm sharing our old database that's worth 1 month of research and application. I used to own SorinRO back in 2016. It's at episode 6 when it died.

In our database, we have corrected the mob stats, drop, and spawns. Please keep in mind that this is not 100% accurate to the official server. 

I have used the following references:

1. Leaked Aegis files for RussiaRO and MalaysiaRO
2. WoE and Juno Guidebook (based on PhilippineRO)
3. Old emulators (Fusion, Vidar, Freya, jAthena, etc.)

P.S. Use it at your own risk. Review the files before implementing.
 

SorinRO EP5 Spawn & Mob_Db.zip

[PvP Points Shared in Party + Anti-Abuse]

7 minutes ago, Neffletics said:

@Sehrentos Can you share the final code? I'm having problems with points sharing for 2nd++ members.

Nevermind, it was a stupid mistake. I overlooked the "end;" on my script.

[PvP Points Shared in Party + Anti-Abuse]

On 9/25/2018 at 1:29 PM, Strand said:

Hello @Sehrentos

Thank you very much for your help. It totally worked!

@Sehrentos Can you share the final code? I'm having problems with points sharing for 2nd++ members.

[Hello, anyone can this credit agent quest]

Post the whole script here.

[Regarding Private RO Server]

Buy a host and upload your files there.

[Auto Reward Guild Members]

If you will read the documentation, you'll understand how to do it. I suggest that you read it instead of asking others to finish it for you. 

Here's the link to getguildmember script command, that should do the trick.
https://github.com/HerculesWS/Hercules/blob/1f78dc3468f1a4afe1f8bd09ea340a715af1d206/doc/script_commands.txt#L3890

[Reward IP BASE]

if(strcharinfo(2) != $koegid) end; // if the character is not from the guild
goto GetReward;
break;

GetReward:
query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@IP$);
query_sql("SELECT account_id FROM `login` WHERE last_ip = '"+.@IP$+"'", .@AID);

if(getarraysize(.@AID) > 1) end; // If more than 1 account_id shares the same IP
getitem 600,1;
end;

Just make them talk to an NPC with this function. This is the simplest way to do it. I hope it helps. ~

[Gepard Shield Support]

You should directly message Functor on Skype. If you've legitimately bought your license, you should have his Skype ID. 

[Server running into AWS]

Why would you use it? It's only advisable for session-based games. 

For open-world MMORPG like Ragnarok Online, it's just a waste of money. 

[BrowEditor]

You're welcome.

[low]

Then?

[Unknown packet 0x65]

Update your mmo.h, make sure the client date is set properly. Check your packet_db as well.

[clif_parse: Disconnecting session #3 with unknown packet version (p:0x0438,l:19)]

Make sure your mmo.h is set to your client's date. Check your db/packet_db.txt as well.

[how to create own Custom Box like OBB/OCA ??]

Why not call a function instead? 

[How to download Ragexe?]

Right click your desired RagexeRE and then "Save link as..."

[Weird Announcement]

Try diffing your client with "Remove Hourly Announce."

[No "login"]

Your server won't run if login table's missing.

If it's really missing, please run this sql query.

 

CREATE TABLE IF NOT EXISTS `login` (
  `account_id` int(11) unsigned NOT NULL auto_increment,
  `userid` varchar(23) NOT NULL default '',
  `user_pass` varchar(32) NOT NULL default '',
  `sex` enum('M','F','S') NOT NULL default 'M',
  `email` varchar(39) NOT NULL default '',
  `group_id` tinyint(3) NOT NULL default '0',
  `state` int(11) unsigned NOT NULL default '0',
  `unban_time` int(11) unsigned NOT NULL default '0',
  `expiration_time` int(11) unsigned NOT NULL default '0',
  `logincount` mediumint(9) unsigned NOT NULL default '0',
  `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_ip` varchar(100) NOT NULL default '',
  `birthdate` DATE NOT NULL DEFAULT '0000-00-00',
  `character_slots` tinyint(3) unsigned NOT NULL default '0',
  `pincode` varchar(4) NOT NULL DEFAULT '',
  `pincode_change` int(11) unsigned NOT NULL DEFAULT '0',
  `vip_time` int(11) unsigned NOT NULL default '0',
  `old_group` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`account_id`),
  KEY `name` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=2000000; 

INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','[email protected]');

 

[No "login"]

Click on the 'Tables' to see all tables under 'ragnarok' database.