FelixBeta

Here are various SQL queries that can help some administrators/developers to work with accounts and characters. All queries are mostly for 2.2.3 and newer versions. Feel free to add your own useful queries (place them in hide for portability).

A simple and straightforward guide on how to install Microsoft SQL Server 2014 database and management tool on your server. I strongly recommend to avoid any lower versions such as 2005 or 2008/R2 due to their total obsolescence and compatibility issues on modern systems. I'm using SQL 2014 Enterprise Edition, you can easily find it all over internet (prefer respected forums/torrents). Step 1: Unpack your sql 2014 .iso to any folder and run setup.exe as Administrator. Select installation tab and click New SQL Server stand-alone installation. Step 2: Don't mark option to check for updates and just click Next. Step 3: Wait till it scans for requirements and click Next. if needed - install .NET Framework, but usually it don't ask. Step 4: Select SQL Server Feature Installation and click Next. Step 5: Select Database Engine Services, Analysis Services, Management Tools - Complete and click Next. Step 6: As you are installing SQL Server on clean machine, just select Default Instance and leave ID default. Click Next. Step 7: Select Automatic as Startup Type for all services and configure Collation if needed. Russian users may need to make cyrillic collation. Step 8: Click Add Current User, it will automatically add system user in list. Then click Next. Step 9: Select Mixed Mode and enter password that will be used for "sa" login. After this, click Add Current User, it will automatically add system user in list. Step 10: Now just click Install and wait for installation complete. Step 11: Once installation complete you can start SQL Management Tool and connect to your server via default credentials or using sa user with defined password.

Re-check your ODBC setting for BILLING db. Also start your server as administrator You can also adjust zoneserver rfacc.ini: [Options] DBSTR = Provider=MSDASQL;DSN=BILLING;Source=BILLING;UID=sa;PWD=123456;Initial Catalog=BILLING; ErrDBSTR = LogLevel = 2

Hello RF Online Community, We understand the importance of third-party services like security solutions, script development,hosting and Game Control Panels (GameCP) in running a successful RF Online server. This thread aims to collect your valuable feedback, experiences, and recommendations regarding these services. Whether you had an excellent experience or ran into some issues, your insights can help others make informed decisions. Please share your thoughts using the template below: Product/Service Name: Website or Forum Link: Owner Name: Feedback: Thank you for taking the time to share your feedback. Your experiences can go a long way in helping others in our community. Best regards, FelixBeta

Heh Only made this long time ago, and since I don't use AoP, no intention to make newer. 2232 power!

Those are community default RF Online Age Of Patron files. Core of the files are PlayPark updated client as of 12.04.2021 and TriRozhka modified server files Nov 2016 build. Client Information: - Client scripts are synced with server scripts including general portion of Belzeebub update. - Added Russian datatable with 2232 translation, Age of Patron content remains English. Server Information: - Server scripts are synced with client scripts including general portion of Belzeebub update. Server: https://www.mediafire.com/file/ej35qebrswnmhl1/Default_AoP_Server.7z/file Client: https://www.mediafire.com/file/87klwsusfg2j6hh/Default_AoP_Client.7z/file

Those are default server and client files, suitable for learning RF Online game. As any retail file, it has some imperfections that you can adjust or change. From my side, I would recommend you to use Microsoft SQL Server 2014 (Please, don't use old stuff like 2008 that will cause you issues eventually). You can use later versions, but they have external Management tools, which are slow. Don't restore .bak files if you don't know their origin, always try to use database creation scripts from RF_User and RF_World folders, one by one. Server: https://www.mediafire.com/file/e19rrbx4gqvq01e/Default_2232_Server.7z/file RF_User creation sql script (Ready to use) https://www.mediafire.com/file/niatallpdbxjr1i/RF_User_clean_sql2014.sql/file RF_World creation sql script (Ready to use) https://www.mediafire.com/file/ja5t5kgiazs44oz/RF_World_clean_sql2014.sql/file BILLING creation sql script (Ready to use) https://www.mediafire.com/file/eb1p45ao5dzo4za/BILLING_clean_sql2014.sql/file Client: https://www.mediafire.com/file/2hxg0gzvlh9gdvn/Default_2232_Client.7z/file Small developer launcher: https://www.mediafire.com/file/7ag1pk4md503sbu/DevLauncher.7z/file Default R3Engine.ini for english client language: You can create simple .bat file to register your db ODBC. Feel free to change SQL connection provider, names or other data. Start your server As Administrator. ODBC.bat code: @echo off set bil=BILLING set acc=RF_User set wld=RF_World %WINDIR%\System32\odbcconf.exe CONFIGDSN "SQL Server" "DSN=%bil%|Description=|SERVER=(local)|Trusted_Connection=Yes|Database=%bil%" %WINDIR%\System32\odbcconf.exe CONFIGDSN "SQL Server" "DSN=%acc%|Description=|SERVER=(local)|Trusted_Connection=Yes|Database=%acc%" %WINDIR%\System32\odbcconf.exe CONFIGDSN "SQL Server" "DSN=%wld%|Description=|SERVER=(local)|Trusted_Connection=Yes|Database=%wld%"

Dear Community Members, We are thrilled to welcome you to the new RFDev, a community-driven forum inspired by the legacy of the closed rf-dev.net forum that was home to countless RF Online development guides, tutorials, server and client files. We aim to reignite that spirit and create a place where passionate developers and enthusiasts can come together, share, learn, and collaborate. Here's what you can expect from RFDev: Guides & Tutorials: Access a comprehensive collection of guides and tutorials covering various aspects of RF Online game development. Server & Client Files: Find all the essential files to set up and manage your RF Online server, carefully curated and made available by the community. Collaboration: Connect with fellow developers and enthusiasts to work on projects, exchange ideas, and learn from one another. Support: Whether you're just starting or have years of experience, our community is here to provide assistance, feedback, and encouragement. Community Spirit: Be part of a welcoming community that values knowledge-sharing, creativity, and the joy of RF Online development. We believe in the power of community, and we invite you to contribute your wisdom, experiences, and passion. Whether you're looking to start your own RF Online server, create innovative mods, or simply explore the world of RF Online development, RFDev is here to support you every step of the way. Feel free to explore the forum, introduce yourself, and start engaging with like-minded individuals. If you have guides, files, or insights to share, we encourage you to post and help others in their development journey. We're excited to see RFDev grow into a hub for RF Online development, and we're grateful to have you with us. Together, let's honor the legacy of the old rf-dev.net forum and build a thriving community for the future. Welcome to RFDev, where the spirit of RF Online development lives on. Let's create, innovate, and inspire! Best regards, FelixBeta RFDev Team

Dear RFDev Community Members, I hope you're enjoying your time on our forum and finding the Software & Services section useful. I would like to take a moment to remind you of an important aspect of purchasing products or services here. While we strive to create a community of trustworthy and legitimate sellers, it's crucial to remember that RFDev is not responsible for any scams or fraudulent activities that might occur. Before purchasing any software or service, please follow these guidelines: Know the Seller: Research the seller's history on RFDev or other resources like discord groups or forums. Look at their post count, feedback, and how long they have been a member. If possible, talk to other members who have bought from them. Understand the Product or Service: Make sure you completely understand what you are purchasing. Read all the information provided in the advertisement and ask the seller any questions if something is unclear. Use Secure Payment Methods: If possible, use secure and traceable payment methods. Be cautious if the seller insists on non-traceable payment methods. Verify Third-party Reviews: Look for reviews or testimonials from other users who have used the product or service. Honest reviews can give you a better understanding of what to expect. Communicate Clearly: Make sure all the terms of the purchase are clear. If something seems too good to be true, it probably is. Remember, the responsibility of ensuring a safe transaction lies with you. Take your time to do the necessary research and feel free to reach out to the community or moderators if you need assistance. Your vigilance is your best defense against potential scams. Be smart, be safe, and happy shopping on RFDev! If you have any concerns or issues, please do not hesitate to contact us directly. Best regards, FelixBeta RFDev Team

Community Rules Content Sharing: Please do not redistribute content found on RFDev on other websites without the consent of the original creator. We encourage sharing the direct link to our website instead. Some members prefer to exclusively post on RFDev, and we respect that choice. Respect Intellectual Property: While it's not advisable to post others' work without permission, RFDev won't filter or remove leaked content. Although we won't promote leaks, we also won't remove them. Developers are expected to safeguard their intellectual property, and we hope members understand our neutral position on this matter. Third-Party Content Rules: The Third Party Content forum has areas specifically for third-party advertisements. Adhere to the unique rules for each section within this category. Advertisement Locations: Ads are restricted to designated sections and are not permitted elsewhere in the community. Community Guidelines Engage with Reactions: Use the Thanks and Like buttons to respond to posts. Reactions, found at the bottom-right of posts, contribute to your forum reputation. Building your reputation benefits the entire community. Link Sharing: Links to other websites are welcome to foster an open development community. You're free to link to your own or other relevant sites, but we appreciate linking back to RFDev if you do share your own. This isn't mandatory but is certainly valued. File Sharing Recommendations: For sharing content, utilize services like Mega or Mediafire. While forum attachments are capped at 1MB, we prefer that you manage downloads through third-party services to help maintain low disk usage on our website. Support Section Rules These guidelines govern the Support section and the assistance provided by the RFDev team. When creating a post, please: Use a concise and clear thread title. Short questions are acceptable if the query is unambiguous. Choose the applicable game version from the thread tag drop-down menu. Provide a brief summary of the problem. For detailed issues, include: Outline the exact steps to recreate the issue. Provide videos or screenshots to elucidate the issue. Share any additional logs or details to explain your issue further. After resolution: Respond to your thread marking it as resolved. The RFDev Team will then close the thread to signify its resolution. Avoid editing your original post to add "solved" or similar messages. Keep the original issue intact for future reference. If reopening a question, create a new thread linking the existing one and clarify why you are revisiting the question. Additional guidelines: Refrain from unnecessary bumping of support topics. If you find the solution, please share it within the thread. Avoid replying with "use search!" or similar unhelpful comments. Respect different skill levels and only respond if you can offer constructive help. If you choose to respond, be prepared to teach at a level that the original poster can comprehend. The RFDev Team oversees the Support section but is not required to answer questions. Tag staff only for forum moderation issues, not for responses to support queries. Assistance will be provided when time allows; otherwise, the community members offer full support. Regardless of who helps, use Reactions to express gratitude for assistance! Guidelines for Software & Service Promotion These guidelines govern the posting of software and service advertisements on RFDev. Active thread maintainers in this section must adhere to these rules. Non-compliance may lead to thread removal and possible account warnings. Commercial engagement on RFDev mandates a related thread in our advertisement section. Direct marketing to members via private messages, including Discord, is prohibited. You may respond if contacted, but initiating such communication is not allowed. Support for RFDev members regarding your software or service is required through your thread or RFDev private messages. Address questions promptly, ideally within 24 hours. You may direct members to your support channels, but timely responses on RFDev are essential. Inactivity or unresponsiveness may result in ad removal. You may refresh your thread once weekly. If already bumped within the week, only respond to directly address another user's reply. Threads must adhere to provided post templates. Start your thread by copying and pasting the template, then add any extra information, screenshots, or other media after the main description. WARNING: Unauthorized commercial products cannot be marketed to members through any RFDev channels, including Discord. If your product is commercial and lacks an appropriate advertisement, promotion is strictly forbidden. Template for Software Post Name: Price: Latest Version: Release Date: Description: Name: Specify the name of the software. Price: Indicate the price of the software or mention 'Free' if it doesn't cost anything. Latest Version: Provide the current version number of your software. Release Date: State the release date of the latest version. Description: Include detailed information about your software. Template for Service Post Name: Price: Description: Name: Mention the name of the service. Price: List the cost of the service or enter 'Free' if applicable. Description: Provide a comprehensive description of your service. Notices for Advertising & Private Transactions Any RFDev member may post commercial projects or services for sale, without restrictions or obligations. If you appreciate our platform, consider linking back to RFDev on your website or social channels. Third parties operate all threads in this section. Our rules aim to uphold quality standards while limiting RFDev's direct engagement. We strive to moderate content but are not liable for member actions. Posts by RFDev staff in these sections are individually supported, not directly endorsed by RFDev. We urge members to exercise caution in all transactions. Evaluate member activity to assess transaction risks. Feel free to vouch for or review sellers in their thread if satisfied, or allow them to address issues privately if dissatisfied. Discussions of non-RFDev transactions are prohibited. If a transaction did not begin through RFDev, please direct comments to the involved parties. We appreciate your respect for our neutral position. Rules for Team Recruitment Permissible content includes: Team member recruitment. Hiring for particular jobs or tasks. Announcing your availability to join a team. WARNING: If offering work services for sale, utilize the Software & Services section. In Team Recruitment, work must be non-compensated, such as voluntary, open-source, or non-profit projects. Rules for Game Server Advertising Rules for game server ads on RFDev aim to maintain quality. Failure to comply may lead to ad removal and account warnings. These rules may change, so please review them if actively advertising a game server. Although RFDev primarily focuses on RF, ads for other games meeting the requirements are allowed. Ads are restricted to owners, staff, or team members of the server. Ads must stay current, with double posting allowed for updates. Respond to RFDev member inquiries within 24 hours in your ad thread. Avoid overloading ads with media. Ideally, no more than one video and five screenshots. Utilize the provided post template for all ads, incorporating additional content as needed. Mandatory Information in Ads Include the following in your ad: Server Name, Website, registration, and download URLs. Datacenter Location. Server Timezone. Experience Rates. Main Server Language (e.g., English, Russian). Server Age (operating time without a wipe). Other optional details may include: Maximum in-game level. Update frequency. Average player count online. Special event details. Any vital server information players should know.