-
Posts
144 -
Joined
-
Last visited
Profile Information
-
Gender
Male
-
Location
Philippines
-
Server
G-Ragnarok Online 18+(Nude sprite Enable)
Recent Profile Visitors
2,801 profile views
G-RO's Achievements
-
wow thanks for this could you show some example how to define it in script? thanks
-
I mean the function to send email thru Script :). Is it existing now?
-
Are this added to latest rA svn?
-
anyone please help
-
anyone? please
-
Hello Everyone! Just want to ask if this is possible. I want to create an Insert script that will be directed to my another database and this database was not in the vps where my raganarok svn was running. Thank you
-
Error occured on latest rAthena. please see below. thanks for your help
-
Hello Everyone, I hope you'll have a great day :). Can someone provide the sprite name and the location in the GRF of all the 1st Class High sprite, please? Note: 1st class High only ( Novice High, Thief High, Swordsman High, and so on ). Thank you
-
error on login,char and map server/ SSL connection error: unknown error number rathena
G-RO replied to G-RO's question in General Support
Hello Poring king I really appreciate your response. Thank you! <3. However, I already resolved the issue by downgrading from MySQL server 8.+ to MySQL Server 5.+ . -
error on login,char and map server/ SSL connection error: unknown error number rathena
G-RO replied to G-RO's question in General Support
Solved! MySQL Server version 8+ is the problem. Solved by downgrading to MySQL server 5.+ version. -
error on login,char and map server/ SSL connection error: unknown error number rathena
G-RO replied to G-RO's question in General Support
here you go please see the below image -
error on login,char and map server/ SSL connection error: unknown error number rathena
G-RO replied to G-RO's question in General Support
Hello Thank you for your response. However, the Ragnarok DB is just a connection name on my MySQL. the account registered in Administrator is ragnarok. username: ragnarokpasswd: ragnarok port: 3306 Inter_athena.conf are also have the correct details. -
Hello Everyone, Good day! Seeking your kind assistance/advise regarding the below error showing when starting up the Server. Please see the below details of my Char, Maps, and Inter Athena config. Character_Athena.conf // Athena Character configuration file. // Note: "Comments" are all text on the right side of a double slash "//" // Whatever text is commented will not be parsed by the servers, and serves // only as information/reference. // Server Communication username and password. userid: ragnarok passwd: ragnarok // Server name, use alternative character such as ASCII 160 for spaces. // NOTE: Do not use spaces or any of these characters which are not allowed in // Windows filenames \/:*?"<>| // ... or else guild emblems won't work client-side! server_name: rAthena // Wisp name for server: used to send wisp from server to players (between 4 to 23 characters) wisp_server_name: Server // Login Server IP // The character server connects to the login server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. login_ip: 127.0.0.1 // The character server listens on the interface with this IP address. // NOTE: This allows you to run multiple servers on multiple interfaces // while using the same ports for each server. //bind_ip: 127.0.0.1 // Login Server Port login_port: 6900 // Character Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. char_ip: 127.0.0.1 // Character Server Port char_port: 6121 //Time-stamp format which will be printed before all messages. //Can at most be 20 characters long. //Common formats: // %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format) // %H:%M:%S (hour:minute:second, 24 hour format) // %d/%b/%Y (day/Month/year) //For full format information, consult the strftime() manual. //timestamp_format: [%d/%b %H:%M] //If redirected output contains escape sequences (color codes) stdout_with_ansisequence: no //Makes server log selected message types to a file in the /log/ folder //1: Log Warning Messages //2: Log Error and SQL Error messages. //4: Log Debug Messages //Example: "console_msg_log: 7" logs all 3 kinds //Messages logged by this overrides console_silent setting console_msg_log: 0 // File path to store the console messages above console_log_filepath: ./log/char-msg_log.log //Makes server output more silent by ommitting certain types of messages: //1: Hide Information messages //2: Hide Status messages //4: Hide Notice Messages //8: Hide Warning Messages //16: Hide Error and SQL Error messages. //32: Hide Debug Messages //Example: "console_silent: 7" Hides information, status and notice messages (1+2+4) console_silent: 0 // Console Commands // Allow for console commands to be used on/off // This prevents usage of >& log.file console: off // Type of server. // No functional side effects at the moment. // Displayed next to the server name in the client. // 0=normal, 1=maintenance, 2=over 18, 3=paying, 4=P2P char_maintenance: 0 // Enable or disable creation of new characters. // Now it is actually supported [Kevin] char_new: yes // Display (New) in the server list. char_new_display: 0 // Maximum users able to connect to the server. // Set to 0 to disable users to log-in. (-1 means unlimited) max_connect_user: -1 // Group ID that is allowed to bypass the server limit of users. // Or to connect when the char is in maintenance mode (groupid >= allow) // Default: -1 = nobody (there are no groups with ID < 0) // See: conf/groups.conf gm_allow_group: 99 // How often should the server save guild infos? (In seconds) // (character save interval is defined on the map config (autosave_time)) autosave_time: 60 // Display information on the console whenever characters/guilds/parties/pets are loaded/saved? save_log: yes // Starting point for new characters // Format: <map_name>,<x>,<y>{:<map_name>,<x>,<y>...} // Max number of start points is MAX_STARTPOINT in char.hpp (default 5) // Location is randomly picked on character creation. // NOTE: For Doram, this requires client 20151001 or newer. start_point: iz_int,18,26:iz_int01,18,26:iz_int02,18,26:iz_int03,18,26:iz_int04,18,26 start_point_pre: new_1-1,53,111:new_2-1,53,111:new_3-1,53,111:new_4-1,53,111:new_5-1,53,111 start_point_doram: lasa_fild01,48,297 // Starting items for new characters // Max number of items is MAX_STARTITEM in char.cpp (default 32) // Format: <id>,<amount>,<position>{:<id>,<amount>,<position>...} // To auto-equip an item, include the position where it will be equipped; otherwise, use zero. // NOTE: For Doram, this requires client 20151001 or newer. start_items: 1201,1,2:2301,1,16 start_items_doram: 1681,1,2:2301,1,16 // Starting zeny for new characters start_zeny: 0 // Size for the fame-lists fame_list_alchemist: 10 fame_list_blacksmith: 10 fame_list_taekwon: 10 // Guild earned exp modifier. // Adjusts taxed exp before adding it to the guild's exp. For example, if set // to 200, the guild receives double the player's taxed exp. guild_exp_rate: 100 // Name used for unknown characters unknown_char_name: Unknown // To log the character server? log_char: yes // Allow or not identical name for characters but with a different case (upper/lower): // example: Test-test-TEST-TesT; Value: 0 not allowed (default), 1 allowed name_ignoring_case: no // Manage possible letters/symbol in the name of charater. Control character (0x00-0x1f) are never accepted. Possible values are: // NOTE: Applies to character, party and guild names. // 0: no restriction (default) // 1: only letters/symbols in 'char_name_letters' option. // 2: Letters/symbols in 'char_name_letters' option are forbidden. All others are possibles. char_name_option: 1 // Set the letters/symbols that you want use with the 'char_name_option' option. // Note: Don't add spaces unless you mean to add 'space' to the list. char_name_letters: abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890 // Restrict character deletion by BaseLevel // 0: no restriction (players can delete characters of any level) // -X: you can't delete chars with BaseLevel <= X // Y: you can't delete chars with BaseLevel >= Y // e.g. char_del_level: 80 (players can't delete characters with 80+ BaseLevel) char_del_level: 0 // Amount of time in seconds by which the character deletion is delayed. // Default: 86400 (24 hours) // NOTE: Requires client 2010-08-03aragexeRE or newer. char_del_delay: 86400 // Restrict character deletion by email address or birthdate. // This restricts players from changing the langtype and deleting characters. // Defaults based on client date. // 1: Email address // 2: Birthdate // 3: Email address or Birthdate // IMPORTANT! // - This config only works for clients that send 0x0068 or 0x01fb for delete request. // - Use langtype 1 for newer clients (2013+), to use 0x01fb. // - Clients that are not using 0x0068 or 0x01fb, only use birthdate (YYMMDD) as default. char_del_option: 2 // Restrict character deletion as long as he is still in a party or guild // 0: No restriction is applied // 1: Character cannot be deleted as long as he remains in a party // 2: Character cannot be deleted as long as he remains in a guild // 3: Character cannot be deleted as long as he remains in a party or guild(default) char_del_restriction: 3 // Restrict certain class from being created. (Only functional on 20151001aRagexe or later) // 0: No character creation is allowed // 1: Only novice is allowed to be created (pre-renewal default) // 2: Only summoner is allowed to be created // 3: Both novice and summoner can be created (renewal default) // Uncomment to customize the restriction //allowed_job_flag: 3 // Folder that contains the database files. db_path: db //=================================== // Pincode system //=================================== // NOTE: Requires client 2011-03-09aragexeRE or newer. // A window is opened before you can select your character and you will have to enter a pincode by using only your mouse. // Default: yes pincode_enabled: yes // How often does a user have to change his pincode? // 0: never (default) // X: every X days pincode_changetime: 0 // How often can a user enter the wrong pincode? // Default: 3 (client maximum) pincode_maxtry: 3 // Are users forced to use a pincode when the system is enabled? // Default: yes pincode_force: yes // Are repeated numbers allowed? // Default: no pincode_allow_repeated: no // Are sequential numbers allowed? // Default: no pincode_allow_sequential: no //=================================== // Addon system //=================================== // Character moving // NOTE: Requires client 2011-09-28aragexeRE or newer. // Allows users to move their characters between slots. // Default: yes char_move_enabled: yes // Allow users to move a character to a used slot? // If enabled the characters are exchanged. // Default: yes char_movetoused: yes // Allow users to move characters as often as they like? char_moves_unlimited: no // Character renaming // Allow users to rename a character while being in a party? // Default: no char_rename_party: no // Allow users to rename a character while being in a guild? // Default: no char_rename_guild: no // Should we check if sql-tables are correct on server startup ? char_checkdb: yes // Default map if character is in not-existing map when loaded. default_map: prontera default_map_x: 156 default_map_y: 191 // After how many days should inactive clan members be removed from their clan? // 0: never remove them // X: remove clan members if they did not log in for X days // Default: 14 clan_remove_inactive_days: 14 //=================================== // RODEX //=================================== // After how many days should mails be returned to their sender? // 0: never return them // X: return them after X days // Default: 15 mail_return_days: 15 // How many days after a mail was returned to it's sender should it be deleted completely? // 0: never delete them // X: delete them X days after they were returned // Default: 15 mail_delete_days: 15 // Does the Retrieve All button ignore unread mail status? // no: Only return attachments from read mail // yes: Return attachments from all mail // Default: yes mail_retrieve: yes // Should mails without any attachments be returned to their sender? // Default: yes mail_return_empty: yes import: conf/import/char_conf.txt Map_Athena.conf //-------------------------------------------------------------- //rAthena Map-Server Configuration File //-------------------------------------------------------------- // Note: "Comments" are all text on the right side of a double slash "//" // Whatever text is commented will not be parsed by the servers, and serves // only as information/reference. //-------------------------------------------------------------- // Configuration Info //-------------------------------------------------------------- // Interserver communication passwords, set in account.txt (or equiv.) userid: ragnarok passwd: ragnarok // Character Server IP // The map server connects to the character server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. char_ip: 127.0.0.1 // The map server listens on the interface with this IP address. // NOTE: This allows you to run multiple servers on multiple interfaces // while using the same ports for each server. //bind_ip: 127.0.0.1 // Character Server Port char_port: 6121 // Map Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. map_ip: 127.0.0.1 // Map Server Port map_port: 5121 //Time-stamp format which will be printed before all messages. //Can at most be 20 characters long. //Common formats: // %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format) // %H:%M:%S (hour:minute:second, 24 hour format) // %d/%b/%Y (day/Month/year) //For full format information, consult the strftime() manual. //timestamp_format: [%d/%b %H:%M] //If redirected output contains escape sequences (color codes) stdout_with_ansisequence: no //Makes server log selected message types to a file in the /log/ folder //1: Log Warning Messages //2: Log Error and SQL Error messages. //4: Log Debug Messages //Example: "console_msg_log: 7" logs all 3 kinds //Messages logged by this overrides console_silent setting console_msg_log: 0 // File path to store the console messages above console_log_filepath: ./log/map-msg_log.log //Makes server output more silent by omitting certain types of messages: //1: Hide Information messages //2: Hide Status messages //4: Hide Notice Messages //8: Hide Warning Messages //16: Hide Error and SQL Error messages. //32: Hide Debug Messages //Example: "console_silent: 7" Hides information, status and notice messages (1+2+4) console_silent: 0 //Where should all database data be read from? db_path: db // Enable the @guildspy and @partyspy at commands? // Note that enabling them decreases packet sending performance. enable_spy: no // Read map data from GATs and RSWs in GRF files or a data directory // as referenced by grf-files.txt rather than from the mapcache? use_grf: no // Console Commands // Allow for console commands to be used on/off // This prevents usage of >& log.file console: off // Database autosave time // All characters are saved on this time in seconds (example: // autosave of 60 secs with 60 characters online -> one char is saved every // second) autosave_time: 300 // Min database save intervals (in ms) // Prevent saving characters faster than at this rate (prevents char-server // save-load getting too high as character-count increases) minsave_time: 100 // Apart from the autosave_time, players will also get saved when involved // in the following (add as needed): // 1: after every successful trade // 2: after opening vending/every vending transaction // 4: after closing storage/guild storage. // 8: After hatching/returning to egg a pet. // 16: After successfully sending a mail with attachment // 32: After successfully submitting an item for auction // 64: After successfully get/delete/complete a quest // 128: After every bank transaction (deposit/withdraw) // 256: After every attendance reward // 4095: Always // NOTE: These settings decrease the chance of dupes/lost items when there's a // server crash at the expense of increasing the map/char server lag. If your // server rarely crashes, but experiences interserver lag, you may want to set // these off. save_settings: 4095 // Message of the day file, when a character logs on, this message is displayed. motd_txt: conf/motd.txt // When @help or @h is typed when you are a gm, this is displayed for helping new gms understand gm commands. charhelp_txt: conf/charhelp.txt // Load channel config from channel_conf: conf/channels.conf // Maps: import: conf/maps_athena.conf import: conf/import/map_conf.txt Inter Athena.conf // Athena InterServer configuration. // Contains settings shared/used by more than 1 server. // Options for both versions // Log Inter Connections, etc.? log_inter: 1 // Inter Log Filename inter_log_filename: log/inter.log // Level range for sharing within a party party_share_level: 15 // Amount of status points a new character will start with start_status_points: 48 // You can specify the codepage to use in your MySQL tables here. // (Note that this feature requires MySQL 4.1+) //default_codepage: // For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1 // Under windows, you want to use 127.0.0.1. If you see a message like // "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" // and you have localhost, switch it to 127.0.0.1 // Global SQL settings // overridden by local settings when the hostname is defined there // (currently only the login-server reads/obeys these settings) // MySQL Login server login_server_ip: 127.0.0.1 login_server_port: 3306 login_server_id: ragnarok login_server_pw: ragnarok login_server_db: ragnarok login_codepage: login_case_sensitive: no ipban_db_ip: 127.0.0.1 ipban_db_port: 3306 ipban_db_id: ragnarok ipban_db_pw: ragnarok ipban_db_db: ragnarok ipban_codepage: // MySQL Character server char_server_ip: 127.0.0.1 char_server_port: 3306 char_server_id: ragnarok char_server_pw: ragnarok char_server_db: ragnarok // MySQL Map Server map_server_ip: 127.0.0.1 map_server_port: 3306 map_server_id: ragnarok map_server_pw: ragnarok map_server_db: ragnarok // MySQL Log Database log_db_ip: 127.0.0.1 log_db_port: 3306 log_db_id: ragnarok log_db_pw: ragnarok log_db_db: ragnarok log_codepage: log_login_db: loginlog // MySQL Reconnect Settings // - mysql_reconnect_type: // 1: When MySQL disconnects during runtime, the server tries to reconnect // mysql_reconnect_count times and shuts down if unsuccessful. // 2: When mysql disconnects during runtime, it tries to reconnect indefinitely. mysql_reconnect_type: 2 mysql_reconnect_count: 1 // DO NOT CHANGE ANYTHING BEYOND THIS LINE UNLESS YOU KNOW YOUR DATABASE DAMN WELL // this is meant for people who KNOW their stuff, and for some reason want to change their // database layout. [CLOWNISIUS] // 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 item_cash_table: item_cash_db item_cash2_table: item_cash_db2 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 sales_table: sales vending_table: vendings vending_items_table: vending_items market_table: market roulette_table: db_roulette guild_storage_log: guild_storage_log // Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no) use_sql_db: no inter_server_conf: inter_server.yml import: conf/import/inter_conf.txt Login table Mysql Login details: username: ragnarok passwd: ragnarok port: 3306 Thank you so much!
-
Thank you for you reply. Do you know what file or php page where I can edit this page?. thank you
-
Hello Everyone, Good day! I just want to ask if there's an existing addons or code that will let the player attached file in Service Desk? thanks