Talaysen

Hi guys, I've been away from the Ragnarok pServer scene for a while and I've been debating on diving into a new project, I wanted to pick some brains, first. I've been contemplating the potential of the rAthena emulator for making a stand-alone game. I had looked at Stendhal as a potential option, but the gameplay overall is very clunky, character movement seems erratic. Question 1 (Legal): While I know Gravity doesn't condone or approve of private servers, they don't seem to tend to go after private servers from a legal standpoint with any sort of real consistency. It seems like a massive gray area, especially depending on 'how' your server is set up. Much of the quests, combat mechanisms, and other materials in rAthena are designed to work just like Ragnarok Online, but where does this sit legally if you were to create a new type of MMO using rAthena? I can't imagine rAthena operating as long as it has, if Gravity had a problem with it, or if there was a real risk of legal backlash. Question 2 (Clients): Beyond KeyWorld's HTML5 based web browser (which is just magnificent, by the way), I haven't seen anything in regards to clients that aren't simply hexed versions of the Gravity/kRO client. Has there every been any headway in creating an rAthena specific client? Question 2b (Mobile): Follow-up question to #2, has there ever been any headway in regards to the same question, but on a mobile scale? Question 3 (Development): The development of a separate MMO specific to rAthena as an emulator would likely necessitate it's own client because of the different resources, maps, etc. How plausible is this? Question 3b (Minimal Starting Point): What would be the most minimal possible configuration for rAthena that would function as a building block? Essentially, one map, character, maybe an NPC, and a couple of passive (non-hostile) mobs? Question 3c (Maps): It looks like BrowEdit is the go-to tool for editing maps. Are there other alternatives that are in-use? If anyone has any good links to guides on creating new maps from scratch, I'd love em. Cross-Server Synchronization: This is more of an aside than part of this idea, slightly out-of-scope, but one of the most common problems I encountered running RO servers in the past was that players from different regions experienced lag. If multiple servers could be syncronized (chat, major towns where there's no combat/significant load), player gameplay experience would benefit greatly. Ideally, players in two separate regions (US East, Asia) wouldn't see each-other on a normal map because they'd be playing on servers in entirely different regions, but if two players from different regions wanted to play together, joining a party could pull one player or the other to the others server, or the server closest to the middle of the two players, to reduce any latency that might be experienced by grouping. I have no idea what would be involved in such a process, I just wanted to put that one out there, maybe someone with more experience than myself could come up with the logistics on how it could happen. Wrapup: At this point I'm trying to gauge interest and plausibility. rAthena has so many fantastic qualities, and I think a modern take with new graphics, quests, storyline could be a very fun project. This is a 'speculation' standpoint, nothing more. Interest and feedback will determine whether I abandon the idea, or start planning on what type of resources I have available that could be allocated for such an endeavor. If this is something I could get enough people interested in, if treated as a separate project, or maybe a branch of rAthena, but fully under rAthena's control (say, "rAthena Basic), I'd be willing to help provide hosting resources, along with time, and any aspects of the development that I could handle. The idea would be that any maps, NPCs, events, quests, sprites, any materials involved would be open-source/GPL, to allow anyone to use them freely in any way they wished, all of which would be significantly different from traditional RO materials to ensure that the materials are original, new works, completely free from any claim from any group or individual as intellectual property. If I offend anyone with the questions or information here, apologies!

If you guys need a graphic artist for this, I have a guy that does images for t-shirts for different business projects, his stuff tends to turn out pretty amazing, and it's a flat-rate for the image, no royalties or anything. That aside, we've been using Teepublic for selling the shirts. They handle the production, shipping, and everything else, and we net part of the profit from the sales.

The two .htaccess files seem to conflict with each other. I think it's because the CMS' .htaccess is first in the hierarchy, so it overrides the forum .htaccess in certain circumstances. XenForo .htaccess: # Mod_security can interfere with uploading of content such as attachments. If you # cannot attach files, remove the "#" from the lines below. #<IfModule mod_security.c> # SecFilterEngine Off # SecFilterScanPOST Off #</IfModule> ErrorDocument 401 default ErrorDocument 403 default ErrorDocument 404 default ErrorDocument 500 default <IfModule mod_rewrite.c> RewriteEngine On # If you are having problems with the rewrite rules, remove the "#" from the # line that begins "RewriteBase" below. You will also have to change the path # of the rewrite to reflect the path to your XenForo installation. RewriteBase /forum # This line may be needed to enable WebDAV editing with PHP as a CGI. #RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}] RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -l [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^.*$ - [NC,L] RewriteRule ^(data/|js/|styles/|install/|favicon\.ico|crossdomain\.xml|robots\.txt) - [NC,L] RewriteRule ^.*$ index.php [NC,L] </IfModule> I tried adding lines to the CMS' .htaccess to exclude the 'forum' subdirectory from it's rules (both by using rewrite rules and rewrite conditions), but it would then break the forum, because it would completely exclude it from mod_rewrite. What's happening is during certain situations, namely trying to install addons, during the installation process, I'll get redirected to the CMS 404 error page. It seems like it only occurs in situation where it's redirecting after a 'submit' button, or something of the such. Because the .htaccess from the main directory is applied to the main directory and all subdirectories, I'm thinking that the only viable solution is going to be to move the forum to a subdomain. Theoretically, I could put the CMS in a sub-folder of the main directory, and the forum in a separate subfolder, and use a separate .htaccess to handle directing things to their appropriate locations, but it really seems like simply splitting the forum software to a subdomain is the cleanest option available.

I use XenForo. I'm going to be looking at it later tonight, I'll post back if I figure out what causes that.

Liked on FB. I have a forum running on /forum/, and I've noticed that the .htaccess for the CORA CMS interferes with the url paths and certain functionality of the forum. Some times it doesn't, some times it does, but when it does, I get a 'page not found error' from the CMS. The forum itself has it's own .htaccess, so I'm not really sure why it's grabbing the .htaccess for the main site. Any ideas how I could alleviate that?

I've installed Cora, and I'm really, truly impressed. This CMS is beautiful. The back-end reminds of Wordpress in it's simplicity. I'm kind of limited on time tonight, but hopefully by this weekend I'll really be able to dive into it and explore all of the features. I'm working on a new server, so everything is 100% from scratch on my end. Once I get a feel for things, I'll start working on templating it. Couple of things: 1.) On your site (you're likely aware, but), the 'User Management', 'Page Management', 'Post Management', 'Navigation', 'Settings', 'Donate & V4P', 'Cash Shop', 'Widgets' pages give a 404 error. 2.) I did have to modify the .htaccess, as the default setting wasn't correct for my server and resulted in errors. 3.) Very minor error (typo) on the 'Admin Profile' page. The 'Change Password' section, third field, it says 'Admin Old Password', when it should be, say, 'Re-Enter New Password', or something of the such, as it's confirming the new password. Suggestions: 1.) I'm sure it's likely on your agenda, but more widget positions (footer, header, etc) are desirable. 2.) Is it possible for the Server Status widget to also display 'Online Users: #' and 'Peak Users: #'?

On the demo, I noticed that the skill window doesn't seem to display learned skills, and doesn't allow the allocation of points. I did some of the basic novice area quests, I'm extraordinarily impressed with how well this works, overall. Excellent job, really. I'm excited about using this for my server, as downloading all the data files is a huge turn-off to prospective players.

Excellent work, KeyWorld. I see that it's been released, if I install it, is it ready for public use? What kind of known issues exist? I wish I could help you with the development, but I just don't have the necessary skills. Once I pay for my classes for this semester, I'll donate something towards the continued development of this, I can do that much. If I have multiple servers (with one login server) will the existing application support that?

Is this still being developed? Is this compatible with rAthena's current version?

It's showing as '30', and when I attempt to change it, it changes back to 30 when I hit submit, however: From the database (server 1): dbname ac_online_stats_event dbusername@host SYSTEM RECURRING 2 MINUTE 2014-04-15 20:17:10 ENABLED 0 utf8 utf8_general_ci latin1_swedish_ci From the database (server 2): dbname2 ac_online_stats_event dbusername2@host SYSTEM RECURRING 2 MINUTE 2014-04-10 08:49:54 ENABLED 0 latin1 latin1_swedish_ci latin1_swedish_ci

Which version are you running? If possible, send me the problematic patch file. Eh, I goofed. I was using the thor generator from the old version of the application rather than the new one. I'm assuming it isn't backwards compatible. I re-created the patches using the new generator and they downloaded + installed without issue. Sorry! Are you running the launcher as an administrator? 1.) (Every Time): Right click and 'Run as Administrator', 2.) (Permanently): Right click the Launcher Icon -> Properties -> Compatibility - Privilege Level - Check 'Run this program as an administrator'.

I was using an old version on a different sever. Will test the new version on that same server when I get off work and post back. Edit: Hmm. I think it might have been the control panel that I use, messing with it. It seems to have a 'catch all' routing system, that redirects you if the page isn't part of the control panel. I moved the data/patch folders from the subdomain to the main domain and it works fine. Edit: I'm trying to patch in two files, when I run the launcher, I'm getting 't_55268F87.tmp is an invalid file'.

I've been having some issues getting the patcher to work. I don't think it's misconfiguration, it just seems that it isn't properly communicating with the server. The little news box shows up, and any changes I make show up accordingly. The start button simply will not appear, off a clean, freshly configured Thor download. What protocol is used when it checks for patches/files? Is there a port (on the web server) that might be blocked that could be causing the issue?

Yeah, the IP and ports are correct. I think the event scheduler may have been disabled. It shows up in my database when I do 'SHOW EVENTS', and now the Online Stats are showing that I have '2' (sigh) users online. All three (login/char/map) servers are still showing as offline (red circles). Is that status pulled from the server database, or is it done by TCP/UDP query? Just wondering if maybe it's due to a blocked port on my webhost, or some such silliness. Minor issue: -Cannot toggle 'featured' state of news posts. Changing the setting and hitting submit doesn't save. Feature request: -Some sort of alert mechanic for comments on news articles. (Currently have to manually check for comments, would be nice to have an alert, perhaps on the admin backend notifying a new comment.)

For whatever reason (I've run all of the SQL files, and updates, etc) for my second server, it didn't have the atk:matk column. Server is renewal. I manually added the column. Either way, it fixed that error, the item database is working for the second server, as intended. -- I noticed that the Login/Char/Map servers always appear offline on the Server Information page (?path=ragnarok.s."server"&action=info). Online stats, all time player peak, and this month's player peak are all blank/0. Is this something that isn't finished yet?

Hm, I uploaded all of the sprite and other images files that I had on my other server. I'm getting the dark 'shadow' circle that sits under the character, but nothing else: http://ro.templar-gaming.com/img.php?x=body&s=tgro&c=torment&i=150659 Going to grab the changes from GIT and re-add that other server. Thanks! Edit: #2 is fixed for the original server I added. The item database shows as intended - (I just need to upload some images for the items. ) However, I re-added the second server, and am getting this error: Note: Server #1 displays the item DB, server #2 presents error: Date: Apr 09, 2014 10:27:35 PM URL: http://ro.templar-gaming.com/?path=ragnarok.s.valor.item -------------------------------------------------------------------- Exception ------------------------------------------------------------------- File: /ro/lib/Aqua/SQL/Select.php Line: 508 Type: PDOException Code: 42S22 - Message --------------------------------------------------------- SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.atk:matk' in 'field list' - Trace ------------------------------------------------------------ * Aqua\Site\Dispatcher->dispatch() /ro/index.php:43 * Aqua\Site\Page->action() /ro/lib/Aqua/Site/Dispatcher.php:94 * call_user_func_array() /ro/lib/Aqua/Site/Page.php:70 * Page\Main\Ragnarok\Server\Item->index_action() * Aqua\SQL\Select->query() /ro/application/pages/main/ragnarok/server/item.php:113 * PDOStatement->execute() /ro/lib/Aqua/SQL/Select.php:508 ------- (Unrelated question: Will there be an ability to add menu items from the admin backend, or will it be manually handled through the templating system?)

#2 - Fixed, but: Adding the description column fixed that issue, but I'm getting a new error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.attack:matk' in 'field list' #3: - Modified the data.ini (forgot to remove the ';') - getting new error: Date: Apr 08, 2014 09:53:18 PM URL: /img.php?x=body&s=tgro&c=torment&i=150000 IP Address: 173.64.71.64 -------------------------------------------------------------------- Exception ------------------------------------------------------------------- File: /ro/lib/CharGen/Client.php Line: 110 Type: Aqua\Core\Exception\PHP Code: 2 - Message --------------------------------------------------------- file_put_contents(/home/templar/public_html/ro/assets/client/da- ta/sprite/Àΰ£Ã·/¸Ó¸®Åë/³²/25_³².spr): failed to open stream: No such file or directory - Trace ------------------------------------------------------------ * CharGen\Client::getFile() /ro/img.php:126 * file_put_contents() /ro/lib/CharGen/Client.php:110 * Aqua\Core\Exception\PHP::errorHandler() ----- Aside from those two things, everything else seems to be good to go. Let me know when it's safe to add the second server back in, I'll happily keep testing for bugs/issues and continue reporting them. Thanks a bunch for all of your help! Alright, updated to your changes on GIT. #2: Now results in: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.attack' in 'field list' --- I'm not sure why the CharGen is telling me the folders don't exist.. they do. I vaguely remember having trouble getting this to work when KeyWorld first released those scripts. As it turns out, I still have it installed on one of my subdomains, I manually uploaded all of the palettes/sprites/etc, instead of the GRFs. Going to transfer those files over and see if that resolves it.

Just got off work, will check it in the morning and post back. ------------ Kk, sorry for the delay. If I missed anything, or you need more info, let me know! Added the GRF files to the server, but the issue persist. Checked the error logs, lot of re-occurring stuff, but this is what I've got: 1.) While not necessarily an 'error', in the sense that it would work for most users, the permissions on my shared hosting don't allow for use of 'mkdir()'. img.php, on line 65, attempts to create directories for the guild emblems (servername -> server group). After I created this two folders, the guild emblems started showing up as intended. 2.) (Similar error results when trying to navigate to '?path=ragnarok.server.item' and '?path=ragnarok.server.item&action=shop'.) File: /ro/lib/Aqua/SQL/Select.php (line: 508) URL: /?path=ragnarok.server.item&action=view&arg=7441 Type: PDOException Code: 42522 - Message --------------------------------------------------------- SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.description' in 'field list' - Trace ------------------------------------------------------------ * Aqua\Site\Dispatcher->dispatch() /ro/index.php:43 * Aqua\Site\Page->action() l/ro/lib/Aqua/Site/Dispatcher.php:94 * call_user_func_array() l/ro/lib/Aqua/Site/Page.php:70 * Page\Main\Ragnarok\Server\Item->view_action() * Aqua\Ragnarok\Server\CharMap->item() /ro/application/pages/main/ragnarok/server/item.php:137 * Aqua\SQL\Select->query() /ro/lib/Aqua/Ragnarok/Server/CharMap.php:893 * PDOStatement->execute() /ro/lib/Aqua/SQL/Select.php:508 3.) Date: Apr 08, 2014 10:06:01 AM URL: /img.php?x=body&s=templar&c=torment&i=150000 IP Address: -------------------------------------------------------------------- Exception ------------------------------------------------------------------- File: /ro/lib/functions/image_trim.php Line: 41 Type: Aqua\Core\Exception\PHP Code: 2 - Message --------------------------------------------------------- imagecreatetruecolor(): Invalid image dimensions - Trace ------------------------------------------------------------ * image_trim() /ro/img.php:162 * imagecreatetruecolor() /ro/lib/functions/image_trim.php:41 * Aqua\Core\Exception\PHP::errorHandler() 4.) I don't know if this is due to a misconfiguration on my end, or if this explains the issues on the server status and other pages, but it seems that for this query it's trying to utilize the AquaCore user/database information rather than the rAthena user/database information. I use two separate databases, one for AquaCore and one for my server. (The 't_ro' username is for my AquaCore database. I don't believe this is caused by misconfiguration, simply because other elements, like my character's details, items, zeny, etc, are all being presented correctly, which means it does have some access to the database.) Date: Apr 08, 2014 09:49:59 AM URL: http://ro.templar-gaming.com/?path=ragnarok.server&action=online IP Address: 173.64.71.64 -------------------------------------------------------------------- Exception ------------------------------------------------------------------- File: /ro/lib/Aqua/Ragnarok/Server/CharMap.php Line: 2269 Type: PDOException Code: 42000 - Message --------------------------------------------------------- SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 't_ro'@'localhost' for table 'ac_woe_castles' - Trace ------------------------------------------------------------ * Aqua\Site\Dispatcher->dispatch() /ro/index.php:43 * Aqua\Site\Page->action() /ro/lib/Aqua/Site/Dispatcher.php:94 * call_user_func_array() /ro/lib/Aqua/Site/Page.php:70 * Page\Main\Ragnarok\Server->online_action() * Aqua\Ragnarok\Server\CharMap->woe() /ro/application/pages/main/ragnarok/server.php:85 * Aqua\Ragnarok\Server\CharMap->fetchWoeSchedule() /ro/lib/Aqua/Ragnarok/Server/CharMap.php:1592 * PDO->query() /ro/lib/Aqua/Ragnarok/Server/CharMap.php:2269 5.) When trying to view a character portrait (IE: ?path=ragnarok.server.c.Talaysen), In my console I get: (Failed to load resource: the server responded with a status of 403 (Forbidden) ) at /tpl/scripts/char-stats.js I've tried changing the scripts in this directory to chmod 755, but it doesn't seem to have make a difference.

Alright, I temporarily removed the second server (it's still new/fairly inactive, so I can wait until the menus are fixed). Under 'My Account', it's now listing my characters and storage. Character images aren't showing up: /img.php?x=head&s=templar&c=torment&i=150000 Item images aren't showing up, either. /assets/images/item/icon/1478.png Who's Online under 'path=ragnarok.server&action=online' results in 'Unexpected Error'. Monster DB link under 'path=ragnarok.server.mob' menu now works properly. Item DB link under 'path=ragnarok.server.item'' menu results in 'Unexpected Error'. Item Shop (path=ragnarok.server.item&action=shop) results in 'Unexpected Error'. Ladder (path=ragnarok.server.ladder') works properly. All sub-menu links working properly. Since I consider these to be reasonably minor issues (cosmetic is minor, in my book, the core functionality is there). I'm going to start using this live. My players are really good about reporting errors that they find, if any come in, I'll post them here for you.

Oh, ok! I just wanted to make sure I didn't have something incorrectly configured. What about the 'characters' page under 'My Account'? I added the char/map servers, but I'm still getting the 404/page doesn't exist error. Same with the link for storage, under my account. Additionally, the server group is now showing up as a menu item (which is fine, I'm sure that's intentional). Only one of the defined map/char servers (I'll refer to this as the 'sub server') appears on this menu. The following: 'Who's Online', 'Monster DB', 'Item Db',' Item Shop' all return: "Unexpected Error, An unexpected error occurred, please try again later." If I click on the sub-server name, (Valor), it shows the (server information page) with number of accounts registered, the characters registered, guilds, parties. All of this information (and the class information) is correct. It shows the login/char/map servers as offline, which is incorrect. The 'Ladders' page shows character information as it should.

I added the login server and the char/map servers (both sets). When I go to the server group page (path=r.servergroup), it lists both of the sub server pages. Server 1 - Rates - Characters - Players Online Server 2 - Rates - Characters - Players Online The number of characters and players online presented is correct. (The rates on Server #2 aren't right, but I imagine I can tweak that somewhere?) On the server sub-menu (path=r.servergroup.server), I'm getting what appears to be an error? It's a long string of text starting with "object(Aqua\Ragnarok\Server\CharMap)#81 (19) { ["server"]=> &object(Aqua\Ragnarok\Server)#67 (7) { ["key"]=> string(7) " I'd paste the whole thing here, but it has quite a bit of sensitive info in it. This happens for both server #1 and #2. Links in the admin menu for the server (path=r.servergroup.server): Server 1: Zeny Log, Shop Log, MVP Log, NPC Log, Guilds, and Characters(#2) all return blank pages, but no errors. Pick Log, Characters(#1), and Parties return a message of 'Unexpected Error, An unexpected error occurred, please try again later'. Characters appears twice in this menu, the first one directs to 'action=characters', the second directs to 'action=char'. Guilds link directs to 'action=shop'. Parties link directs to 'action=shop'. Atcommand Log returns a list of commands that have been executed on the server. If I can provide any additional information, let me know. Also, I'd be happy to provide you with an admin account on the web control panel, if it'd help you with troubleshooting.

If the 'cache' folder doesn't exist, it results in a few PHP errors when you go to install. The GIT download doesn't include the empty cache folder, but it was an easy fix. Just figured I'd mention it, for anyone else who gets something similar. Also hit a snag on the install process, step 2, create folder: mkdir(): Permission denied Has something to do with permissions on the host that I'm using. While this is easily rectifiable, it doesn't seem that the installer itself likes being halted during this particular process. Is there any sort of check that it could perform prior to attempting the installation? ------------------------ Edit: Problem was being caused by access levels + shared hosting. I just checked the code to see what folders were being created and manually created them, installation went as intended. Question: During the installation process, it gives the option for many different encryption options for passwords. I believe BCrypt is one of the most secure options that I saw in the list, but with rAthena, isn't it MD5 or nothing? Edit: I see that this encryption is -for- the AquaCore user accounts and doesn't affect the password situation for the server accounts. Very impressed by this whole system. Additional (Unrelated) Error: At the bottom of the administrative control panel, I'm getting the following: Fatal error: Uncaught exception 'Aqua\Core\Exception\PHP' with message 'ob_flush(): failed to flush buffer. No buffer to flush' in /home/public_html/ro/lib/Aqua/Http/Response.php:340 Stack trace: #0 [internal function]: Aqua\Core\Exception\PHP::errorHandler(8, 'ob_flush(): fai...', '/home/p...', 340, Array) #1 /home/templar/public_html/ro/lib/Aqua/Http/Response.php(340): ob_flush() #2 /home/public_html/ro/admin/index.php(193): Aqua\Http\Response->send(true) #3 {main} thrown in /home/public_html/ro/lib/Aqua/Http/Response.php on line 340 --------------- Additional Error: Under 'My Account', after linking my account for my server, it shows my character name, sex, last IP, login count and other relevant details, but when I click on 'Characters' or 'Storage', I get a '404, The page you requested does not exist' error.