Jump to content
  • 0

Use SQL mode but Map Server error.


Outlook

Question


  • Group:  Members
  • Topic Count:  23
  • Topics Per Day:  0.04
  • Content Count:  57
  • Reputation:   4
  • Joined:  07/10/22
  • Last Seen:  

Use SQL mode but Map Server error.

// ALL MySQL Database Table names

// Login Database Tables
login_server_account_db: login
ipban_table: ipbanlist
global_acc_reg_num_table: global_acc_reg_num
global_acc_reg_str_table: global_acc_reg_str

// Char Database Tables
char_db: char
hotkey_db: hotkey
scdata_db: sc_data
cart_db: cart_inventory
inventory_db: inventory
charlog_db: charlog
skill_db: skill
interlog_db: interlog
memo_db: memo
guild_db: guild
guild_alliance_db: guild_alliance
guild_castle_db: guild_castle
guild_expulsion_db: guild_expulsion
guild_member_db: guild_member
guild_skill_db: guild_skill
guild_position_db: guild_position
guild_storage_db: guild_storage
party_db: party
pet_db: pet
friend_db: friends
mail_db: mail
mail_attachment_db: mail_attachments
auction_db: auction
quest_db: quest
homunculus_db: homunculus
skill_homunculus_db: skill_homunculus
mercenary_db: mercenary
mercenary_owner_db: mercenary_owner
elemental_db: elemental
skillcooldown_db: skillcooldown
bonus_script_db: bonus_script
acc_reg_num_table: acc_reg_num
acc_reg_str_table: acc_reg_str
char_reg_str_table: char_reg_str
char_reg_num_table: char_reg_num
clan_table: clan
clan_alliance_table: clan_alliance

// Map Database Tables
barter_table: barter
buyingstore_table: buyingstores
buyingstore_items_table: buyingstore_items
item_table: item_db
renewal-item_table: item_db_re
item2_table: item_db2
renewal-item2_table: item_db2_re
mob_table: mob_db
renewal-mob_table: mob_db_re
mob2_table: mob_db2
renewal-mob2_table: mob_db2_re
mob_skill_table: mob_skill_db
renewal-mob_skill_table: mob_skill_db_re
mob_skill2_table: mob_skill_db2
renewal-mob_skill2_table: mob_skill_db2_re
mapreg_table: mapreg
partybookings_table: party_bookings
sales_table: sales
vending_table: vendings
vending_items_table: vending_items
market_table: market
roulette_table: db_roulette
guild_storage_log: guild_storage_log

// Web Database Tables
// NOTE: The web server reads the login (login) and char (party,guild) tables and map (party_bookings), so it needs
//       the ability to connect to those databases.
guild_emblems: guild_emblems
user_configs: user_configs
char_configs: char_configs
merchant_configs: merchant_configs

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: yes

inter_server_conf: inter_server.yml

import: conf/import/inter_conf.txt

Screenshot 2024-03-17 014849.png

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

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

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: no

 

use the default one.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  23
  • Topics Per Day:  0.04
  • Content Count:  57
  • Reputation:   4
  • Joined:  07/10/22
  • Last Seen:  

On 3/17/2024 at 3:35 AM, Chaos92 said:

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: no

 

use the default one.

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: yes

Link to comment
Share on other sites

  • 0

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

7 hours ago, Outlook said:

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: yes

What I mean is, use the default setup,

use_sql_db: no

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  23
  • Topics Per Day:  0.04
  • Content Count:  57
  • Reputation:   4
  • Joined:  07/10/22
  • Last Seen:  

11 hours ago, Chaos92 said:

What I mean is, use the default setup,

use_sql_db: no

i want to use sql

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: yes

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...