Rappelz Private server gm settings

[rickske95]

When I change my character in database and save nothing happens ? i relog whole server and restart but nothing happens i made my name [GM]Authentic changed permission i dont know what i do wrong

[ThunderNikk]

You changed the permission value to 100?

[rickske95]

nope should i try that?

still dont work in sql everything is right but when i start server there is nothing changed

[ThunderNikk]

What are you expecting to change?

Did you type a GM command?

What did you type?

Perhaps you are getting the syntax wrong for the command.

[rickske95]

Gm is not working if i change something in database he saved it but when i use the client login nothing changed so im not gm

[rickske95]

can someone help me ?

I cant save my character stats in dbo.character nothing changed after save :S

[ThunderNikk]

Originally Posted by rickske95

can someone help me ?

I cant save my character stats in dbo.character nothing changed after save :S

Modify the column you need to modify then select another row or column, then save the changes.

Or you can use a script to modify the SQL

I can give you an example when I have my DB in front of me but I can't do it right now or I will type something wrong and it will not work.

[rickske95]

ah okay you have skype mate?

but when i click File menu : Save All i click exit and re open SQL then i will check if it worked but its the same as before nothing changed so idk he is not saving data in sql

[ThunderNikk]

Some thing like this...

Open a new query window while you are connected to the databases and in the window

use
Arcadia
UPDATE [Arcadia].[dbo].[NPCResource]  SET[spawn_type] = 0  WHERE [contact_script] LIKE '%Secroute%'

Except where NPCResource is put Character, and where spawn_type is put the column name for Permission, contact_script gets replaced with what the character name column is, and Secroute can be replaced with your characters name.

Then select execute SQL and it will change your permission.

[rickske95]

i did this
Arcadia
UPDATE [Arcadia].[dbo].[Character] SET[permission] = 1 WHERE [name] LIKE [GM]Authentic

and the message is : Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'Authentic'.

and again nothing changed

[Player95]

Originally Posted by rickske95

i did this
Arcadia
UPDATE [Arcadia].[dbo].[Character] SET[permission] = 1 WHERE [name] LIKE [GM]Authentic

and the message is : Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'Authentic'.

and again nothing changed

Try this ...:

USE Arcadia
UPDATE [Arcadia].[dbo].[Character]  SET permission = 1  WHERE name LIKE '%[GM]Authentic%';

But mostly the right permission is 100.
And just learn the right syntax for SQL. At least google it perhaps ...!? There are enough pages who describe such easy stuff.

[rickske95]

Dont work 0 errors but nothing changed

[Player95]

Well I was a bit brainless ...
The Arcadia database does not contain any Character table. It must be the Telecaster database:

USE [B]Telecaster[/B]
UPDATE dbo.Character  
SET permission = 1  WHERE name LIKE '%[GM]Authentic%';

[rickske95]

<3 its working thank you!

[ThunderNikk]

oops yeah telecaster and permission should still be 100 for GM commands.

Glad to hear that it is working.

Thanks Player95

Good luck with the [GM] tag though, the brackets break the v1.opt file and your window placements will never save for you.

Keep an eye on the size of the v1.opt file in the client because it can get huge being saved to like a giant hard drive.