Eisetley

Ok, there's something wrong with script for creating ipbanlist and workbench refuses to execute script after it. How do I fix it? -- Table structure for table `ipbanlist` -- CREATE TABLE IF NOT EXISTS `ipbanlist` ( `list` varchar(255) NOT NULL default '', `btime` datetime NOT NULL, `rtime` datetime NOT NULL, `reason` varchar(255) NOT NULL default '', KEY (`list`) ) ENGINE=MyISAM;

I downloaded and installed community server + workbench from official source yesterday so it's most likely the recent version.

I'm trying to set up the newest rA I've just downloaded from git and there's no "login" table after importing main.sql. There's also an error: 11:03:57 CREATE TABLE IF NOT EXISTS `ipbanlist` ( `list` varchar(255) NOT NULL default '', `btime` datetime NOT NULL, `rtime` datetime NOT NULL, `reason` varchar(255) NOT NULL default '', KEY (`list`) ) ENGINE=MyISAM Error Code: 1071. Specified key was too long; max key length is 1000 bytes 0.046 sec What should I do? @edit I created the login table by running a separate script, but there are more errors. ragnarok.market, ragnarok.sc_data, ragnarok.mapreg are missing.

WAN I think, I want it to be visible for everyone so my friends from different cities can play with me.

No error message, just perpetual "Please wait" when I try to log in. No messages in the console too. PACKETVER is already defined as 20120410.

I'm trying to connect to my server that's running on the same computer on vbox virtual machine. The servers are working fine I think. I can't connect to them with client. Im using a 2012-04-10a exe. Client runs on the host system (Win 8.1), server runs on the guest system (Win7). I don't want to use any offline pack, I need my friends to be able to log in. I have forwarded ports 6900, 5121 and 6121. Exe is diffed to read datafolder first. My clientinfo looks like this: <?xml version="1.0" encoding="euc-kr" ?> <clientinfo> <desc>Ragnarok Client Information</desc> <servicetype>korea</servicetype> <servertype>sakray</servertype> <hideaccountlist /> <passwordencrypt /> <passwordencrypt2 /> <extendedslot /> <readfolder /> <connection> <display>ragnarok</display> <desc>Ragnarok Online</desc> <balloon>this is a tool tip</balloon> <address>(my global ip)</address> <port>6900</port> <version>30</version> <langtype>1</langtype> <registrationweb>REGISTRATION URL HERE</registrationweb> <yellow> <admin>2000001</admin> <admin>2000002</admin> <admin>2000003</admin> </yellow> <loading> <image>loading00.jpg</image> <image>loading01.jpg</image> <image>loading02.jpg</image> <image>loading03.jpg</image> <image>loading04.jpg</image> <image>loading05.jpg</image> <image>loading06.jpg</image> <image>loading07.jpg</image> <image>loading08.jpg</image> <image>loading09.jpg</image> <image>loading10.jpg</image> </loading> </connection> </clientinfo> Packet version is set to 20120410 in defines_pre.h, as I understand packet_db.txt isn't used anymore and you don't have to edit mmo.h and clif.h. I can't figure out what I'm doing wron, halp pls. The other thing that bothers me is what kRO client I should use. Since the thing I'm aiming for is a preRE server, do I really have to download a 2016 or 2017 client with all the unnecessary data inside grfs? I'd download an older one from RMS, but downloading data.grf from depositfiles takes about 11 hours. A magnet link or google drive link with full 2012/2013 kRO folder would be appreciated.

Thanks, Megumin. I hope your panties are ok. How about clientinfo.xml and packet_db.txt? How should they look for this client version? I can't find packet_db inside rA folder by the way.

I can compile with #define PACKETVER 20170614, when I change it to 20120410 it gives me this battle.cpp error. #if PACKETVER > 20120000 && PACKETVER < 20130515 /* Exact date (when it started) not known */ if (battle_config.feature_auction) { ShowWarning("conf/battle/feature.conf:feature.auction is enabled but it is not stable on PACKETVER "EXPAND_AND_QUOTE(PACKETVER)", disabling...\n"); ShowWarning("conf/battle/feature.conf:feature.auction change value to '2' to silence this warning and maintain it enabled\n"); battle_config.feature_auction = 0; } That's the part that gives an error.

When you open packets.h it says I go to defines_pre.h and do it. It looks like this: // Copyright (c) rAthena Dev Teams - Licensed under GNU GPL // For more information, see LICENCE in the main folder #ifndef _CONFIG_CUSTOM_DEFINES_PRE_H_ #define _CONFIG_CUSTOM_DEFINES_PRE_H_ //#define PACKETVER 20120410 /** * rAthena configuration file (http://rathena.org) * For detailed guidance on these check http://rathena.org/wiki/SRC/config/ **/ #define PACKETVER 20120410 #endif // _CONFIG_CUSTOM_DEFINES_PRE_H_ I get a bunch of errors when trying to compile (attachment). When I paste #define PACKETVER 20151104 into defines_pre.h (the one that's in packets.h by default) it compiles fine. Also, should I change packet version somewhere else, like clientinfo.xml? I'm using 2012-04-10aRagexeRE.

Compilation successful. Had to download Windows 8.1 SDK separately and install it.

Pre-Compiled rA won't do. Fug dis, last time I was at least able to compile it, now I tried with VS2013, 2015 and 2017 and none of them work.

Hello. I'm trying to set up a simple pre-re server for me and my friends. I'm probably trying this for the 3rd time because there are always issues that make me give up at some point (like now I can't compile the server with VS2017 because of missing std files). What I want is basically a server with pre-re mechanics and few simple modifications like star gladiator comfort skills working as passive, a few custom items, nothing super fancy really. I just wanted to make sure these things will work together and I'm not wasting my time again. rA version: The one I've just downloaded from https://github.com/rathena/rathena (27 dec 2017) Client: 2015-11-04aRagexe Data folder (4.0):