Jump to content

  •  

kanemi

Member Since 27 Nov 2016
Offline Last Active Dec 09 2016 06:34 PM
-----

Topics I've Started

Show damage player does to others during WoE in the chat box

06 December 2016 - 05:02 PM

As it says. I have hide_woe_damage turned off, and it already shows damage the player is receiving. Now I need damage the player is doing to other players to show, kind of like it does for monsters.


R> Mob stat ratio. Will pay a fair price.

01 December 2016 - 08:26 PM

I need something that can change every mob's attack values, magic attack values, flee needed for dodge values, and HP values. Like, every mob, mini-boss and MVP in the game. Please and thank you!


Really need a filtered WoE damage indicator

30 November 2016 - 11:16 AM

For my server, I need to be able to see damage numbers for only the damage dealt to you, and damage you deal. Without this I fear I don't have a server. Due to all the customization involved in my server some sort of WoE damage indicator is necessary. Is it possible, does anyone know how to do it? If so, I will pay for your services. Don't hesitate to PM me! Thanks.


Need help setting up SQL stuff, the wiki is really sparse on info here

27 November 2016 - 05:40 PM

I tried Google, not much help for the specifics here.

 

From the wiki:

 

 

Your login table should match. Use this SQL query (or make the changes using your favourite SQL gui):


use databasename_rag;
UPDATE login
set `userid` = "[new user]", `user_pass` = "[new password]" where `account_id` = 1;

I don't know where this login table is, or what a 'query' is.

 

About midway down this file, you will find your SQL settings. These will be set as accordingly.


  • The 'sql.db' settings control what the login-server reads for it's database settings.
  • Hostname is the IP of the SQL server.
  • Username is the username you use to login. For security, this should NEVER be root!
  • Password is the password that the user will login with.
  • The database is set to whatever the database name will be. Usually, this is just 'ragnarok'.

For this last one, I tried setting up a server or something with a password, but it would always error when I tested the connection until I removed the password.
I don't know what to do with this info about 'sql.db', and moreover don't see a 'sql.db' section.


Where to begin? Starting a RO server on Windows 10

27 November 2016 - 12:58 PM

Can someone point me in the right direction? I looked at the wiki but it looks like it only has tutorials for Linux or something. I really think I need a completeish guide because I have no clue what I'm doing.

 

Edit: Oh looks like the wiki does have some stuff on Windows lol. sry. I'll check it out for now.

 

Edit 2: Stuck here:

Your login table should match. Use this SQL query (or make the changes using your favourite SQL gui):


use databasename_rag;
UPDATE login
set `userid` = "[new user]", `user_pass` = "[new password]" where `account_id` = 1;

 

What is a login table and how do I use the SQL thingie? I downloaded MySQL and the Workbench zip files and extracted them. Now what?