Jump to content

inkjetcanvas

Members
  • Posts

    4
  • Joined

  • Last visited

Posts posted by inkjetcanvas

  1. This is fantastic and worked great for me after I worked out my server config issues. :D

    I also seemed to have problems when I patched up to the latest version -- I'm currently using the unpatched files from ratemyserver.net (07272011 release). I haven't tried patching up but will do that next (after I back up :D )

    Also I'd like to be able to make my own exe's like this... I have ShinsDiffPatcher, but got hung up on which EXE i needed to diff, and what else would be required. The wiki could use a bit more detail in this section. Have the more recent kRO updates make this harder to do?

    Thanks!

  2. Hi!

    I'm setting up a fresh install of rathena, moving over from eathena. I'm having some connection issues between my servers, which I'm wondering is part of my DB setup. I couldn't find anywhere in the wiki which specifies exactly how your DB should be structured.

    I found a really old how-to somewhere which had me set up 2 DB's: ragnarok and login

    1. Should I instead have everything in ragnarok?

    2. What do I need to source from a fresh install from svn trunk? (ie, the files in sql-files)

    Here's what triggered my question:

    my start logs: (./athena-start start > start-logs.txt)

    [info]: Connection request of the char-server 'rAthena -- myRO' @ 192.168.1.116:6121 (account: 'test', pass: 'test', ip: '127.0.0.1')
    [Debug]: at loginlog_sql.c:75 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '127.0.0.1', 'test', '100', 'charserver - rAthena -- [email protected]:6121')
    [Debug]: at account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate` FROM `login` WHERE `account_id` = 1
    [Notice]: Unknown account (account: test, received pass: test, ip: 127.0.0.1)
    [Notice]: Connection of the char-server 'rAthena -- myRO' REFUSED.
    [info]: Closed connection from '127.0.0.1'.
    [Warning]: Connection to Login Server lost.
    

    I don't have a loginlog table in my database anywhere (there was one in the login table from eathena...). But I started fresh dropped my db's when I switched to rathena, and sourced the following into it:

    main.sql
    logs.sql
    item_db.sql
    item_db2.sql
    mob_skill_db2.sql
    mob_skill_db.sql
    mob_db.sql
    mob_db2.sql
    item_db2.sql
    item_db.sql
    item_db_re.sql
    convert_passwords.sql
    

    If it helps: I am only setting up LAN right now for dev. I'm using Debian headless VM.

    I couldn't find a wiki page specific to this part, and I'll be happy to make one once I get my own configs working. :D

    Thanks!

    Turned out I didn't update the first username/pass to test/test. I still can't connect to the server, but that's a different issue. :D

  3. Just going to tack onto this post here instead of making a new one.

    I'm wondering if it's possible to create new custom mercenaries, with new skillsets and such. I know there would be an AI side, but what would need to happen on the db side?

    I was nosing around at : http://rathena.org/doxygen/mercenary_8h_source.html

    But I haven't messed around with athena for maybe 5 years so I'm a bit rusty. :D

    I don't need a walkthrough, just a quick overview of which files would need to be edited to see it happen, if it's possible. Thx!

×
×
  • Create New...