OK論壇

 找回密碼
 註冊
查看: 5280|回復: 36

R720 SQL架設問題 (換開機黨 沒辦法創角色)

 關閉 [複製鏈接]
  • TA的每日心情
    奮斗
    2015-7-24 12:23 AM
  • 簽到天數: 26 天

    連續簽到: 1 天

    [LV.4]偶爾看看III

    發表於 2013-8-18 04:29:53 | 顯示全部樓層 |閱讀模式
    EA
    私服版號: 3CEAM R605與3CEAM R720
    問題內容: SQL問題
    本帖最後由 owen614012 於 2013-8-21 12:00 AM 編輯

    我原本用 R605 SQL開機 正常
    我改用R720開機 帳號一樣都在 但是角色通通不見 且角色創建失敗
    我試著 辦新帳號 角色也能創建 卻無法進入遊戲 (與伺服器連線失敗)

    這是我的CONF夾 相關之檔案 順序是 char_athena inter_athena login_athena map_athena
    請各位高手 幫我看一下是哪邊輸入有錯誤 (SQL的密碼 我就用*字號代替囉)
    1. // Athena Character configuration file.

    2. // Note: "Comments" are all text on the right side of a double slash "//"
    3. // Whatever text is commented will not be parsed by the servers, and serves
    4. // only as information/reference.

    5. // Server Communication username and password.
    6. userid: s1
    7. passwd: p1

    8. // Server name, use alternative character such as ASCII 160 for spaces.
    9. // NOTE: Do not use spaces in the name, or guild emblems won't work client-side!
    10. server_name: sweet

    11. // Wisp name for server: used to send wisp from server to players (between 4 to 23 characters)
    12. wisp_server_name: sweet

    13. // Login Server IP
    14. // The character server connects to the login server using this IP address.
    15. // NOTE: This is useful when you are running behind a firewall or are on
    16. // a machine with multiple interfaces.
    17. login_ip: sweet2013.hopto.org

    18. // The character server listens on the interface with this IP address.
    19. // NOTE: This allows you to run multiple servers on multiple interfaces
    20. // while using the same ports for each server.
    21. bind_ip: sweet2013.hopto.org

    22. // Login Server Port
    23. login_port: 6900

    24. // Character Server IP
    25. // The IP address which clients will use to connect.
    26. // Set this to what your server's public IP address is.
    27. char_ip: sweet2013.hopto.org

    28. // Character Server Port
    29. char_port: 6121

    30. //Time-stamp format which will be printed before all messages.
    31. //Can at most be 20 characters long.
    32. //Common formats:
    33. // %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
    34. // %H:%M:%S (hour:minute:second, 24 hour format)
    35. // %d/%b/%Y (day/Month/year)
    36. //For full format information, consult the strftime() manual.
    37. //timestamp_format: [%d/%b %H:%M]

    38. //If redirected output contains escape sequences (color codes)
    39. stdout_with_ansisequence: no

    40. //Makes server output more silent by ommitting certain types of messages:
    41. //1: Hide Information messages
    42. //2: Hide Status messages
    43. //4: Hide Notice Messages
    44. //8: Hide Warning Messages
    45. //16: Hide Error and SQL Error messages.
    46. //32: Hide Debug Messages
    47. //Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
    48. console_silent: 0

    49. // Console Commands
    50. // Allow for console commands to be used on/off
    51. // This prevents usage of >& log.file
    52. console: off

    53. // Option to force a player to create an e-mail.
    54. // If a player have default e-mail, and if you activate this option, the player can only connect in the game (to arrive on a map) like follow:
    55. // - Create at least 1 character
    56. // - Select 1 character
    57. // - Select DEL to enter his/her e-mail. (if OK is choosen, client says to the player: 'invalid e-mail')
    58. // - If his/her e-mail is correct, the player enter in the game (an e-mail is saved definitively).
    59. // - If his/her e-mail is incorrect, he/she have 'incorrect e-mail' and must select again DEL.
    60. // - After entering in the game (when the player arrives on a map), DEL and SEL/OK button work normaly for all next connections.
    61. // Resume: If a player have "incorrect/invalid e-mail" when he/she click on 'OK' button,
    62. //         the player must click 'DEL' button and register his/her NEW e-mail to enter in the game
    63. // So, default is 0, because administrator must explain to their players before to activate this option.
    64. email_creation: 0

    65. // Type of server.
    66. // No functional side effects at the moment.
    67. // Displayed next to the server name in the client.
    68. // 0=normal, 1=maintenance, 2=over 18, 3=paying, 4=P2P
    69. char_maintenance: 0

    70. // Enable or disable creation of new characters.
    71. // Now it is actually supported [Kevin]
    72. char_new: 1

    73. // Display (New) in the server list.
    74. char_new_display: 0

    75. // Maximum users able to connect to the server. Set to 0 for unlimited.
    76. max_connect_user: 0

    77. // Minimum GM level that is allowed to bypass the server limit of users.
    78. gm_allow_level: 99

    79. // How often should the server save all files? (In seconds)
    80. // Note: Applies to all data files on TXT servers.
    81. // On SQL servers, it applies to guilds (character save interval is defined on the map config)
    82. autosave_time: 60

    83. // Display information on the console whenever characters/guilds/parties/pets are loaded/saved?
    84. save_log: yes

    85. // Character server flatfile database
    86. char_txt: save/athena.txt

    87. // Friends list flatfile database
    88. friends_txt: save/friends.txt

    89. // Start point, Map name followed by coordinates (x,y)
    90. start_point: brasilis,119,308

    91. // Starting weapon for new characters
    92. start_weapon: 1201

    93. // Starting armor for new characters
    94. start_armor: 2301

    95. // Starting zeny for new characters
    96. start_zeny: 0

    97. // Size for the fame-lists
    98. fame_list_alchemist: 10
    99. fame_list_blacksmith: 10
    100. fame_list_taekwon: 10

    101. // Guild earned exp modifier.
    102. // Adjusts taxed exp before adding it to the guild's exp. For example, if set
    103. // to 200, the guild receives double the player's taxed exp.
    104. guild_exp_rate: 100

    105. // Name used for unknown characters
    106. unknown_char_name: Unknown

    107. // To log the character server?
    108. log_char: 1

    109. // Log Filename
    110. char_log_filename: log/char.log

    111. // Allow or not identical name for characters but with a different case (upper/lower):
    112. // example: Test-test-TEST-TesT; Value: 0 not allowed (default), 1 allowed
    113. name_ignoring_case: no

    114. // Manage possible letters/symbol in the name of charater. Control character (0x00-0x1f) are never accepted. Possible values are:
    115. // NOTE: Applies to character, party and guild names.
    116. // 0: no restriction (default)
    117. // 1: only letters/symbols in 'char_name_letters' option.
    118. // 2: Letters/symbols in 'char_name_letters' option are forbidden. All others are possibles.
    119. char_name_option: 1

    120. // Set the letters/symbols that you want use with the 'char_name_option' option.
    121. // Note: Don't add spaces unless you mean to add 'space' to the list.
    122. char_name_letters: abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890

    123. // How many Characters are allowed per Account ? (0 = disabled)
    124. chars_per_account: 0

    125. // Restrict character deletion by BaseLevel
    126. // 0: no restriction (players can delete characters of any level)
    127. // -X: you can't delete chars with BaseLevel <= X
    128. // Y: you can't delete chars with BaseLevel >= Y
    129. // e.g. char_del_level: 80 (players can't delete characters with 80+ BaseLevel)
    130. char_del_level: 0

    131. // Amount of time in seconds by which the character deletion is delayed.
    132. // Default: 86400 (24 hours)
    133. // NOTE: Requires client 2010-08-03aragexeRE or newer.
    134. char_del_delay: 86400

    135. // What folder the DB files are in (item_db.txt, etc.)
    136. db_path: db

    137. //NOTE: The following online listing options are only for TXT servers.

    138. // Filename of the file which receives the online players list in text
    139. online_txt_filename: online.txt

    140. // Filename of the file which receives the online players list, but in html version
    141. online_html_filename: online.html

    142. // Choose how to display online players.
    143. // (sorting operation with a lot of online players can take time on a slow computer)
    144. // 0: no sorting (default)
    145. // 1: by alphabetical order of their name
    146. // 2: by number of their zenys
    147. // 3: by their base level
    148. // 4: by their job (and job level inside the same job)
    149. // 5: by alphabetical order of their actual map location
    150. online_sorting_option: 0

    151. // Choose which columns that you want display in the online files. Do the addition of these values:
    152. // (if value is 0, no file is done)
    153. // 1: name (just the name, no function like 'GM')
    154. // 2: job
    155. // 4: levels
    156. // 8: map name
    157. // 16: mapname and coordonates
    158. // 32: zenys
    159. // 64: name (with 'GM' if the player is a GM)
    160. // default value: 1 (only name)
    161. online_display_option: 1

    162. // minimum GM level to display 'GM' when we want to display it (default: 1)
    163. online_gm_display_min_level: 20

    164. // refresh time (in sec) of the html file in the explorer (default 20)
    165. online_refresh_html: 20

    166. import: conf/import/char_conf.txt
    複製代碼
    1. // Athena InterServer configuration.

    2. // Options for both versions

    3. // Log Inter Connections, etc.?
    4. log_inter: 1

    5. // Inter Log Filename
    6. inter_log_filename: log/inter.log

    7. // Level range for sharing within a party
    8. party_share_level: 10


    9. // TXT version options only

    10. // Storage flatfile database, used for Karfa storage.
    11. storage_txt: save/storage.txt

    12. // Party flatfile database, for party names, members and other party info.
    13. party_txt: save/party.txt

    14. // Hotkeys flatfile database, where character skill shortcuts are stored.
    15. hotkeys_txt: save/hotkeys.txt

    16. // Guild flatfile database, for guild names, members, and other guild info.
    17. guild_txt: save/guild.txt

    18. // Pet flatfile database, for pet names, and other pet info.
    19. pet_txt: save/pet.txt

    20. // Homunculus flatfile database, for homunculus information.
    21. homun_txt: save/homun.txt

    22. // Castle flatfile database, for emperium war castles, etc.
    23. castle_txt: save/castle.txt

    24. // Status change flatfile database, for status changes that are saved between sessions.
    25. scdata_txt: save/scdata.txt

    26. // Mapserver permanent script variables ($-type)
    27. mapreg_txt: save/mapreg.txt


    28. // SQL version options only

    29. // You can specify the codepage to use in your mySQL tables here.
    30. // (Note that this feature requires MySQL 4.1+)
    31. default_codepage: big5


    32. // For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1
    33. // Under windows, you want to use 127.0.0.1.  If you see a message like
    34. // "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
    35. // and you have localhost, switch it to 127.0.0.1

    36. // Global SQL settings
    37. // overriden by local settings when the hostname is defined there
    38. // (currently only the login-server reads/obeys these settings)
    39. sql.db_hostname: 127.0.0.1
    40. sql.db_port: 3306
    41. sql.db_username: storage2012
    42. sql.db_password: ****
    43. sql.db_database: ragnarok
    44. sql.codepage: big5

    45. // MySQL Character SQL server
    46. char_server_ip: 127.0.0.1
    47. char_server_port: 3306
    48. char_server_id: storage2012
    49. char_server_pw: ****
    50. char_server_db: ragnarok

    51. // MySQL Map SQL Server
    52. map_server_ip: 127.0.0.1
    53. map_server_port: 3306
    54. map_server_id: storage2012
    55. map_server_pw: ****
    56. map_server_db: ragnarok

    57. // MySQL Log SQL Database
    58. log_db_ip: 127.0.0.1
    59. log_db_port: 3306
    60. log_db_id: storage2012
    61. log_db_pw: ****
    62. log_db_db: logs
    63. log_codepage: big5

    64. // DO NOT CHANGE ANYTHING BEYOND THIS LINE UNLESS YOU KNOW YOUR DATABASE DAMN WELL
    65. // this is meant for people who KNOW their stuff, and for some reason want to change their
    66. // database layout. [CLOWNISIUS]

    67. // ALL MySQL Database Table names

    68. // Login Database Tables
    69. loginlog_db: loginlog

    70. // Char Database Tables
    71. char_db: char
    72. hotkey_db: hotkey
    73. scdata_db: sc_data
    74. cart_db: cart_inventory
    75. inventory_db: inventory
    76. charlog_db: charlog
    77. storage_db: storage
    78. reg_db: global_reg_value
    79. skill_db: skill
    80. interlog_db: interlog
    81. memo_db: memo
    82. guild_db: guild
    83. guild_alliance_db: guild_alliance
    84. guild_castle_db: guild_castle
    85. guild_expulsion_db: guild_expulsion
    86. guild_member_db: guild_member
    87. guild_skill_db: guild_skill
    88. guild_position_db: guild_position
    89. guild_storage_db: guild_storage
    90. party_db: party
    91. pet_db: pet
    92. friend_db: friends
    93. mail_db: mail
    94. auction_db: auction
    95. quest_db: quest

    96. // Map Database Tables
    97. item_db_db: item_db
    98. item_db2_db: item_db2
    99. mob_db_db: mob_db
    100. mob_db2_db: mob_db2
    101. mapreg_db: mapreg

    102. //Use SQL item_db and mob_db for the map server
    103. use_sql_db: no

    104. // Nick for sending mainchat
    105. // messages like whisper
    106. main_chat_nick: Main

    107. import: conf/import/inter_conf.txt
    複製代碼
    1. // Athena Login Server configuration file.
    2. // Translated by Peter Kieser <[email protected]>

    3. // Note: "Comments" are all text on the right side of a double slash "//"
    4. // Whatever text is commented will not be parsed by the servers, and serves
    5. // only as information/reference.

    6. // The login server listens on the interface with this IP address.
    7. // NOTE: This allows you to run multiple servers on multiple interfaces
    8. // while using the same ports for each server.
    9. bind_ip: sweet2013.hopto.org

    10. // Login Server Port
    11. login_port: 6900

    12. //Time-stamp format which will be printed before all messages.
    13. //Can at most be 20 characters long.
    14. //Common formats:
    15. // %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
    16. // %H:%M:%S (hour:minute:second, 24 hour format)
    17. // %d/%b/%Y (day/Month/year)
    18. //For full format information, consult the strftime() manual.
    19. //timestamp_format: [%d/%b %H:%M]

    20. //If redirected output contains escape sequences (color codes)
    21. stdout_with_ansisequence: no

    22. //Makes server output more silent by ommitting certain types of messages:
    23. //1: Hide Information messages
    24. //2: Hide Status messages
    25. //4: Hide Notice Messages
    26. //8: Hide Warning Messages
    27. //16: Hide Error and SQL Error messages.
    28. //32: Hide Debug Messages
    29. //Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
    30. console_silent: 0

    31. // Console Commands
    32. // Allow for console commands to be used on/off
    33. // This prevents usage of >& log.file
    34. console: off

    35. // Can you use _M/_F to make new accounts on the server?
    36. new_account: yes

    37. // Account registration flood protection system
    38. // allowed_regs is the number of registrations allowed in time_allowed (in seconds)
    39. allowed_regs: 1
    40. time_allowed: 10

    41. // Log Filename. All operations received by the server are logged in this file.
    42. login_log_filename: log/login.log

    43. // To log the login server?
    44. // NOTE: The login-sql server needs the login logs to enable dynamic pass failure bans.
    45. log_login: yes

    46. // Indicate how to display date in logs, to players, etc.
    47. date_format: %Y-%m-%d %H:%M:%S

    48. // Indicate the minimum GM level of player that the server accepts to connection.
    49. // 0: all players (normal player are 0. it's default), 1-99: GM level at least with level x
    50. min_level_to_connect: 0

    51. // Starting additional sec from now for the limited time at creation of account
    52. // -1: new account are created with UNlimited time (default value)
    53. // 0 or more: new accounts was created by addition of the value (in sec) to the actual time (to set first limited time)
    54. start_limited_time: -1

    55. // Check The clientversion set in the clientinfo ?
    56. check_client_version: no

    57. // What version we would allow to connect? (if the options above is enabled..)
    58. client_version_to_connect: 20

    59. // Store passwords as MD5 hashes instead of plaintext ?
    60. // NOTE: Will not work with clients that use <passwordencrypt>
    61. use_MD5_passwords: no

    62. // Ipban features (SQL only)
    63. ipban.enable: yes
    64. ipban.sql.db_hostname: 127.0.0.1
    65. ipban.sql.db_port: 3306
    66. ipban.sql.db_username: storage2012
    67. ipban.sql.db_password: ****
    68. ipban.sql.db_database: ragnarok
    69. ipban.sql.codepage:
    70. ipban.sql.ipban_table: ipbanlist
    71. // Dynamic password failure ipban system
    72. ipban.dynamic_pass_failure_ban: yes
    73. ipban.dynamic_pass_failure_ban_interval: 5
    74. ipban.dynamic_pass_failure_ban_limit: 7
    75. ipban.dynamic_pass_failure_ban_duration: 5

    76. // Interval (in seconds) to clean up expired IP bans. 0 = disabled. default = 60.
    77. // NOTE: Even if this is disabled, expired IP bans will be cleaned up on login server start/stop.
    78. // Players will still be able to login if an ipban entry exists but the expiration time has already passed.
    79. ipban_cleanup_interval: 60

    80. // Interval (in minutes) to execute a DNS/IP update. Disabled by default.
    81. // Enable it if your server uses a dynamic IP which changes with time.
    82. //ip_sync_interval: 10

    83. // DNS Blacklist Blocking
    84. // If enabled, each incoming connection will be tested against the blacklists
    85. // on the specified dnsbl_servers (comma-separated list)
    86. use_dnsbl: no
    87. dnsbl_servers: dnsbl.deltaanime.net

    88. // Which account engine to use.
    89. // 'auto' selects the first engine available (txt, sql, then others)
    90. // (defaults to auto)
    91. account.engine: auto

    92. // Account data storage configuration
    93. // TXT
    94. account.txt.account_db: save/account.txt
    95. account.txt.case_sensitive: no
    96. // SQL
    97. account.sql.db_hostname: 127.0.0.1
    98. account.sql.db_port: 3306
    99. account.sql.db_username: storage2012
    100. account.sql.db_password: ****
    101. account.sql.db_database: ragnarok
    102. account.sql.codepage:
    103. account.sql.case_sensitive: no
    104. account.sql.account_db: login
    105. account.sql.accreg_db: global_reg_value

    106. import: conf/inter_athena.conf
    107. import: conf/import/login_conf.txt
    複製代碼
    1. //      ______  __    __                                 
    2. //     /\  _  \/\ \__/\ \                                
    3. //   __\ \ \L\ \ \ ,_\ \ \___      __    ___      __     
    4. // /'__`\ \  __ \ \ \/\ \  _ `\  /'__`\/' _ `\  /'__`\   
    5. ///\  __/\ \ \/\ \ \ \_\ \ \ \ \/\  __//\ \/\ \/\ \L\.\_
    6. //\ \____\\ \_\ \_\ \__\\ \_\ \_\ \____\ \_\ \_\ \__/.\_\
    7. // \/____/ \/_/\/_/\/__/ \/_/\/_/\/____/\/_/\/_/\/__/\/_/
    8. //  _   _   _   _   _   _   _     _   _   _   _   _   _
    9. // / \ / \ / \ / \ / \ / \ / \   / \ / \ / \ / \ / \ / \
    10. //( e | n | g | l | i | s | h ) ( A | t | h | e | n | a )
    11. // \_/ \_/ \_/ \_/ \_/ \_/ \_/   \_/ \_/ \_/ \_/ \_/ \_/
    12. //
    13. //--------------------------------------------------------------
    14. //eAthena Map-Server Configuration File
    15. //--------------------------------------------------------------

    16. // Note: "Comments" are all text on the right side of a double slash "//"
    17. // Whatever text is commented will not be parsed by the servers, and serves
    18. // only as information/reference.

    19. //--------------------------------------------------------------
    20. //                        Configuration Info                        
    21. //--------------------------------------------------------------
    22. // Interserver communication passwords, set in account.txt (or equiv.)
    23. userid: s1
    24. passwd: p1

    25. // Character Server IP
    26. // The map server connects to the character server using this IP address.
    27. // NOTE: This is useful when you are running behind a firewall or are on
    28. // a machine with multiple interfaces.
    29. char_ip: sweet2013.hopto.org

    30. // The map server listens on the interface with this IP address.
    31. // NOTE: This allows you to run multiple servers on multiple interfaces
    32. // while using the same ports for each server.
    33. bind_ip: sweet2013.hopto.org

    34. // Character Server Port
    35. char_port: 6121

    36. // Map Server IP
    37. // The IP address which clients will use to connect.
    38. // Set this to what your server's public IP address is.
    39. map_ip: sweet2013.hopto.org

    40. // Map Server Port
    41. map_port: 5121

    42. //Time-stamp format which will be printed before all messages.
    43. //Can at most be 20 characters long.
    44. //Common formats:
    45. // %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
    46. // %H:%M:%S (hour:minute:second, 24 hour format)
    47. // %d/%b/%Y (day/Month/year)
    48. //For full format information, consult the strftime() manual.
    49. //timestamp_format: [%d/%b %H:%M]

    50. //If redirected output contains escape sequences (color codes)
    51. stdout_with_ansisequence: no

    52. //Makes server output more silent by ommitting certain types of messages:
    53. //1: Hide Information messages
    54. //2: Hide Status messages
    55. //4: Hide Notice Messages
    56. //8: Hide Warning Messages
    57. //16: Hide Error and SQL Error messages.
    58. //32: Hide Debug Messages
    59. //Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
    60. console_silent: 0

    61. //Where should the map data be read from?
    62. map_cache_file: db/map_cache.dat

    63. //Where should all database data be read from?
    64. db_path: db

    65. // Enable the @guildspy and @partyspy at commands?
    66. // Note that enabling them decreases packet sending performance.
    67. enable_spy: no

    68. // Read map data from GATs and RSWs in GRF files or a data directory
    69. // as referenced by grf-files.txt rather than from the mapcache?
    70. use_grf: no

    71. // Console Commands
    72. // Allow for console commands to be used on/off
    73. // This prevents usage of >& log.file
    74. console: off

    75. // Database autosave time
    76. // All characters are saved on this time in seconds (example:
    77. // autosave of 60 secs with 60 characters online -> one char is saved every
    78. // second)
    79. autosave_time: 300

    80. // Min database save intervals (in ms)
    81. // Prevent saving characters faster than at this rate (prevents char-server
    82. // save-load getting too high as character-count increases)
    83. minsave_time: 100

    84. // Apart from the autosave_time, players will also get saved when involved
    85. // in the following (add as needed):
    86. // 1: after every successful trade
    87. // 2: after every vending transaction
    88. // 4: after closing storage/guild storage.
    89. // 8: After hatching/returning to egg a pet.
    90. // 16: After successfully sending a mail with attachment
    91. // 32: After successfully submitting an item for auction
    92. // 64: After successfully get/delete/complete a quest
    93. // NOTE: These settings decrease the chance of dupes/lost items when there's a
    94. // server crash at the expense of increasing the map/char server lag. If your
    95. // server rarely crashes, but experiences interserver lag, you may want to set
    96. // these off.
    97. save_settings: 127

    98. // Message of the day file, when a character logs on, this message is displayed.
    99. motd_txt: conf/motd.txt

    100. // When @help or @h is typed when you are a gm, this is displayed for helping new gms understand gm commands.
    101. help_txt: conf/help.txt
    102. help2_txt: conf/help2.txt
    103. charhelp_txt: conf/charhelp.txt

    104. // Scripts
    105. import: npc/scripts_main.conf

    106. // Maps:
    107. import: conf/maps_athena.conf

    108. import: conf/import/map_conf.txt
    複製代碼
    請各位判斷一下 是哪邊設定錯誤 還需要什麼圖片資料等 請留言 我盡量補上 ..
    回復

    使用道具 舉報

  • TA的每日心情

    2017-1-18 12:17 AM
  • 簽到天數: 512 天

    連續簽到: 1 天

    [LV.9]以壇為家II

    發表於 2013-8-18 07:52:54 | 顯示全部樓層
    本帖最後由 grass0916 於 2013-8-18 08:08 AM 編輯

    無法創腳色

    1. 不能創中文名稱 -> 資料庫在建立時並不是使用繁中編碼

    2. 創立腳色會一直出現 character size 錯誤 -> 登入器的日期與服務端封包日期不相同

    //--

    兩者都於版上有超大量的相關解答,

    若找不到再來問吧, 希望樓主不是什麼都不找只打算打伸手牌的人 ^_^
    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    奮斗
    2015-7-24 12:23 AM
  • 簽到天數: 26 天

    連續簽到: 1 天

    [LV.4]偶爾看看III

     樓主| 發表於 2013-8-18 11:36:19 | 顯示全部樓層
    grass0916 發表於 2013-8-18 07:52 AM
    無法創腳色

    1. 不能創中文名稱 -> 資料庫在建立時並不是使用繁中編碼

    你好
    1. 是中文英文都不行 而且用R605開機的 舊帳號 都在
    只是 角色通通不見了 而且不能創角色 ..

    2. 你說的第二點 我就有點看不懂了 ..

    我猜測SQL是正常 (因為R605可以正常開機)
    可能R720 我有哪裡設定錯誤 ..  不知道原因
    回復 支持 反對

    使用道具 舉報

  • TA的每日心情

    2017-1-18 12:17 AM
  • 簽到天數: 512 天

    連續簽到: 1 天

    [LV.9]以壇為家II

    發表於 2013-8-18 11:48:49 | 顯示全部樓層
    owen614012 發表於 2013-8-18 11:36 AM
    你好
    1. 是中文英文都不行 而且用R605開機的 舊帳號 都在
    只是 角色通通不見了 而且不能創角色 ..

    登入器的日期與服務端封包日期不相同

    http://okayro.com/thread-252569-1-1.html

    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    奮斗
    2015-7-24 12:23 AM
  • 簽到天數: 26 天

    連續簽到: 1 天

    [LV.4]偶爾看看III

     樓主| 發表於 2013-8-18 13:16:21 | 顯示全部樓層
    grass0916 發表於 2013-8-18 11:48 AM
    登入器的日期與服務端封包日期不相同

    http://okayro.com/thread-252569-1-1.html

    跟那個問題好像不太一樣
    還是能創新帳號 也能登錄到選角畫面 可以創角 但是一創好不管名字原本打甚麼
    選角畫面那顯示的名子是空白 重開角色就消失 用我R605時用的登錄器創角則是顯示創造失敗

    回復 支持 反對

    使用道具 舉報

  • TA的每日心情

    2017-1-18 12:17 AM
  • 簽到天數: 512 天

    連續簽到: 1 天

    [LV.9]以壇為家II

    發表於 2013-8-18 18:21:29 | 顯示全部樓層
    owen614012 發表於 2013-8-18 01:16 PM
    跟那個問題好像不太一樣
    還是能創新帳號 也能登錄到選角畫面 可以創角 但是一創好不管名字原本打甚麼
    ...

    大概懂你意思

    我曾經遇過你上述的問題

    不過我 "換一個登入器" 就沒事了

    你自己試試看吧

    //--

    可以試著自己做登入器

    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    奮斗
    2015-7-24 12:23 AM
  • 簽到天數: 26 天

    連續簽到: 1 天

    [LV.4]偶爾看看III

     樓主| 發表於 2013-8-18 20:32:54 | 顯示全部樓層
    grass0916 發表於 2013-8-18 06:21 PM
    大概懂你意思

    我曾經遇過你上述的問題

    已經試過 幾款登入器 都是一樣的效果

    我請朋友 用R720開機(玩全乾淨的情況下 TXT版) 可以正常登入
    而我改成 我的IP (SQL 有紀錄) 的時候就會發生一樣的情況

    我想應該是 開機黨有讀取到SQL的帳號 但是SQL的角色沒有讀取到
    所以 連創角(無法儲存的情況下) 自然沒辦法 創角色
    更何況 辦新的帳號 創角色 進去遊戲(與私服器連線中斷)
    在登入一次 角色就不見了 ...
    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    無聊
    2014-4-8 02:29 AM
  • 簽到天數: 33 天

    連續簽到: 2 天

    [LV.5]常住居民I

    發表於 2013-8-18 22:29:16 | 顯示全部樓層
    owen614012 發表於 2013-8-18 08:32 PM
    已經試過 幾款登入器 都是一樣的效果

    我請朋友 用R720開機(玩全乾淨的情況下 TXT版) 可以正常登入

    你有沒有更新SQL資料?
    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    奮斗
    2015-7-24 12:23 AM
  • 簽到天數: 26 天

    連續簽到: 1 天

    [LV.4]偶爾看看III

     樓主| 發表於 2013-8-18 22:32:06 | 顯示全部樓層
    Yu.loveuan 發表於 2013-8-18 10:29 PM
    你有沒有更新SQL資料?

    資料是從R605 輸出出來的

    SQL版本是 AppServ_2.5.10

    我的步驟是
    先輸出 刪除資料庫 解除SQL安裝
    安裝SQL 建立資料庫 再載入角色帳號等資料 ..

    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    無聊
    2014-4-8 02:29 AM
  • 簽到天數: 33 天

    連續簽到: 2 天

    [LV.5]常住居民I

    發表於 2013-8-18 22:36:51 | 顯示全部樓層
    本帖最後由 Yu.loveuan 於 2013-8-18 10:39 PM 編輯
    owen614012 發表於 2013-8-18 10:32 PM
    資料是從R605 輸出出來的

    SQL版本是 AppServ_2.5.10


    我是指模擬器sql-files資料夾內的upgrade_svnxxxxxx.sql這些檔案
    又或者R720的main.sql內容有R605沒有的內容
    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    奮斗
    2015-7-24 12:23 AM
  • 簽到天數: 26 天

    連續簽到: 1 天

    [LV.4]偶爾看看III

     樓主| 發表於 2013-8-18 23:21:52 | 顯示全部樓層
    Yu.loveuan 發表於 2013-8-18 10:36 PM
    我是指模擬器sql-files資料夾內的upgrade_svnxxxxxx.sql這些檔案
    又或者R720的main.sql內容有R605沒有 ...

    應該是沒更新
    R605 跟 R720 的這兩個資料夾 sql-files

    只是裡面的檔案 也沒會進SQL資料庫裡頭 ..

    我的SQL資料庫 只有兩個
    一個是 ragnarok
    一個是 logs

    到理說 裡面的資料(sql-files) 是空白的 會進去開機 = 洗白
    還是說 要匯到哪裡 ragnarok裡?


    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    無聊
    2014-4-8 02:29 AM
  • 簽到天數: 33 天

    連續簽到: 2 天

    [LV.5]常住居民I

    發表於 2013-8-18 23:35:48 | 顯示全部樓層
    本帖最後由 Yu.loveuan 於 2013-8-18 11:37 PM 編輯
    owen614012 發表於 2013-8-18 11:21 PM
    應該是沒更新
    R605 跟 R720 的這兩個資料夾 sql-files


    簡單說就是你要去比對R605的main.sql缺什麼

    你就要從R720的main.sql補什麼

    要不然你沒更新當然那些人物資料不會正常
    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    奮斗
    2015-7-24 12:23 AM
  • 簽到天數: 26 天

    連續簽到: 1 天

    [LV.4]偶爾看看III

     樓主| 發表於 2013-8-19 01:34:43 | 顯示全部樓層
    Yu.loveuan 發表於 2013-8-18 11:35 PM
    簡單說就是你要去比對R605的main.sql缺什麼

    你就要從R720的main.sql補什麼

    也就是 我要 把sql-files資料夾 裡面的SQL檔案
    全部會進去SQL資料庫裡面
    看內容 一一檢查

    然後要怎麼補..?

    我看了 R605裡面的SQL檔案 大部分都是1KB
    應該也沒東西吧
    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    無聊
    2014-4-8 02:29 AM
  • 簽到天數: 33 天

    連續簽到: 2 天

    [LV.5]常住居民I

    發表於 2013-8-19 01:53:56 | 顯示全部樓層
    owen614012 發表於 2013-8-19 01:34 AM
    也就是 我要 把sql-files資料夾 裡面的SQL檔案
    全部會進去SQL資料庫裡面
    看內容 一一檢查

    什麼應該沒東西? 檢查看看不就知道了?
    回復 支持 反對

    使用道具 舉報

  • TA的每日心情
    奮斗
    2015-7-24 12:23 AM
  • 簽到天數: 26 天

    連續簽到: 1 天

    [LV.4]偶爾看看III

     樓主| 發表於 2013-8-19 02:08:10 | 顯示全部樓層
    Yu.loveuan 發表於 2013-8-19 01:53 AM
    什麼應該沒東西? 檢查看看不就知道了?

    R605和R720 的 main.sql
    載入之後 一樣都是 37個語法 36個儲存項目 並沒有少 ..
    回復 支持 反對

    使用道具 舉報

    您需要登錄後才可以回帖 登錄 | 註冊

    本版積分規則

    Archiver|手機版|小黑屋|OK討論區

    GMT+8, 2024-5-7 07:05 PM , Processed in 0.070454 second(s), 30 queries , Gzip On.

    Powered by Discuz! X3.4

    Copyright © 2001-2020, Tencent Cloud.

    快速回復 返回頂部 返回列表