Jump to content
  • 0

use_sql_db doesn't work


Johnathan

Question


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  21
  • Reputation:   3
  • Joined:  11/29/16
  • Last Seen:  

I'm trying to use the option usb_sql_db: yes in conf\inter_athena.conf, but doesn't work. In mapserv.bat the option appears allowed ([Status]: Using SQL dbs: yes) but the thing is, my custom mobs at mob_db_re (IDs: 3634 to 3656) and my custom items at item_db_re (ID up to 35000) doesn't are loaded.

 

Anyone know what I am doing wrong? Thx.

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

  • Group:  Forum Manager
  • Topic Count:  282
  • Topics Per Day:  0.06
  • Content Count:  3123
  • Reputation:   1617
  • Joined:  03/26/12
  • Last Seen:  

28 minutes ago, Chaos92 said:

insert your custom item/mob in import folder

This is no good if he wants to use SQL.

If you've restarted rAthena/used @reloaditemdb and @reloadmobdb then you should be able to check them with @ii <id of item> or search the items name. Remember they won't be db_re tables if you're using rAthena in pre-re mode.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  41
  • Topics Per Day:  0.01
  • Content Count:  197
  • Reputation:   19
  • Joined:  11/20/11
  • Last Seen:  

i had the same issue its because it still looking for the database mob_db2 and item_db2 you need to comment out and enable the RE tables for custom db.

to do this goto rathena/conf/inter_athena.conf and change these

// Map Database Tables

item_db2_db: item_db2
//item_db2_db: item_db2_re

mob_db2_db: mob_db2
//mob_db2_db: mob_db2_re

mob_skill_db2_db: mob_skill_db2
//mob_skill_db2_db: mob_skill_db2_re

to these

// Map Database Tables

//item_db2_db: item_db2
item_db2_db: item_db2_re

//mob_db2_db: mob_db2
mob_db2_db: mob_db2_re

//mob_skill_db2_db: mob_skill_db2
mob_skill_db2_db: mob_skill_db2_re

 

Edited by mirabell
Link to comment
Share on other sites

  • -1

  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  1550
  • Reputation:   239
  • Joined:  08/03/12
  • Last Seen:  

are u using latest git?

https://github.com/rathena/rathena

insert your custom item/mob in import folder

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...