Account config issues

[lukeFile]

Hey guys,

I started with working on a server with the files provided here. (Thanks alot to Ketchup and everyone envolved btw).
It all worked out fine after a little bit of trying around and fixing minor things - now i got the server up and running. I can add accounts and everything.

Now to my problem: In the files provided by Ketchup there is a video as instruction, saying to make an account admin / GM i need to edit the config file in the program file. I did that accordingly, but it doesnt seem to change anything.

Is there any way to check in my DB what kind of rights or role an account has? I dont find a property in the Database that leads on to what kind of role it has. Only shows personal data connected to the account :X

Any ideas?

 

[Ketchup]

UPDATE [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL_DETAIL] SET [m_chLoginAuthority] = 'Z'
UPDATE [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] SET [m_chAuthority] = 'Z'

^ Will set all accounts and characters to god status.

UPDATE [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL_DETAIL] SET [m_chLoginAuthority] = 'Z' WHERE [account] = 'NAME HERE'
UPDATE [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] SET [m_chAuthority] = 'Z' WHERE [m_szName] = 'NAME HERE'

^ Sets per account name AND character name

SELECT * FROM [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL_DETAIL] WHERE [m_chLoginAuthority] = 'Z'
SELECT * FROM  [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [m_chAuthority] = 'Z'

^ Checks what status an account and character have.

Make sure your server is booted down when you execute.

You can also take a look at: https://forum.ragezone.com/f651/official-file-queries-mssql-666188/

 

[lukeFile]

Hey, thanks a lot! Very usefull link aswell, thanks!
I actually came to a somewhat close solution but this is way handier and more thorrow.

I think i have different "Tags" tho due to this:

Code:
#ifndef__GAMEMASTER
#defineAUTH_OBSERVER'D' // Visiteur
#endif // __GAMEMASTER

#defineAUTH_GENERAL'F' // Joueur

#ifdef__GAMEMASTER
#defineAUTH_HELPER'I' // Guide
#defineAUTH_ANIMATOR'J' // Animateur
#defineAUTH_MAPPER'K' // Mappeur
#else // __GAMEMASTER
#defineAUTH_LOGCHATTING'G' // ??
#defineAUTH_JOURNALIST'H' // Journaliste
#defineAUTH_HELPER'J' // Guide
#endif // __GAMEMASTER

#defineAUTH_GAMEMASTER'L' // GM_LEVEL_1
#defineAUTH_GAMEMASTER2'M' // GM_LEVEL_2
#defineAUTH_GAMEMASTER3'N' // GM_LEVEL_3

#defineAUTH_OPERATOR'O' // Operateur
#defineAUTH_ADMINISTRATOR'P' // Administrateur

#ifdef__GAMEMASTER
#defineAUTH_OWNER'Q' // Fondateur
#defineAUTH_DEVELOPER'R' // Developpeur
#endif // __GAMEMASTER



Anyhow. Sadly its still not working :X It got the full database updated when i check the tables in SQL but ingame i cant use any commands.


I salute you, that you´re still helping people with this :bow:



Update:

I tried to narrow down on the problem, so i did a querry increasing my level to 10 for all existing character. That did work :X
I mean i´m very happy about that but also a little confused

 

[Ketchup]

Hey, thanks a lot! Very usefull link aswell, thanks!
I actually came to a somewhat close solution but this is way handier and more thorrow.

I think i have different "Tags" tho due to this:

Code:
#ifndef__GAMEMASTER
#defineAUTH_OBSERVER'D' // Visiteur
#endif // __GAMEMASTER

#defineAUTH_GENERAL'F' // Joueur

#ifdef__GAMEMASTER
#defineAUTH_HELPER'I' // Guide
#defineAUTH_ANIMATOR'J' // Animateur
#defineAUTH_MAPPER'K' // Mappeur
#else // __GAMEMASTER
#defineAUTH_LOGCHATTING'G' // ??
#defineAUTH_JOURNALIST'H' // Journaliste
#defineAUTH_HELPER'J' // Guide
#endif // __GAMEMASTER

#defineAUTH_GAMEMASTER'L' // GM_LEVEL_1
#defineAUTH_GAMEMASTER2'M' // GM_LEVEL_2
#defineAUTH_GAMEMASTER3'N' // GM_LEVEL_3

#defineAUTH_OPERATOR'O' // Operateur
#defineAUTH_ADMINISTRATOR'P' // Administrateur

#ifdef__GAMEMASTER
#defineAUTH_OWNER'Q' // Fondateur
#defineAUTH_DEVELOPER'R' // Developpeur
#endif // __GAMEMASTER



Anyhow. Sadly its still not working :X It got the full database updated when i check the tables in SQL but ingame i cant use any commands.


I salute you, that you´re still helping people with this :bow:



Update:

I tried to narrow down on the problem, so i did a querry increasing my level to 10 for all existing character. That did work :X
I mean i´m very happy about that but also a little confused

You'd need to be more specific with the files your using as those are not my files lol.

 

[lukeFile]

Uhm i´m not aware of the ownership, just saw you post the link in an old thread:

To view the content, you need to sign in or register

It says "Flyff Guru"

 

[Ketchup]

Uhm i´m not aware of the ownership, just saw you post the link in an old thread:

To view the content, you need to sign in or register

It says "Flyff Guru"

Yea not my files, I just put them out there.
Be aware they do have bugs and security issues.

Anyways in config.ini

Authorization
{
	
	Nom Support AUTH_ADMINISTRATOR
	Nom Master AUTH_ADMINISTRATOR
	Nom Masashi AUTH_ADMINISTRATOR
	Nom Natsu AUTH_ADMINISTRATOR
	Nom Michio AUTH_ADMINISTRATOR
	Nom Tatsuya AUTH_ADMINISTRATOR
	
}

Replace it with your account and characters.