Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 04:23

  • Please register to post and access all features, it's quick, easy and FREE!

 

Rappelz Private server gm settings

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2009
Posts: 44
Received Thanks: 0
Rappelz Private server gm settings

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



rickske95 is offline  
Old   #2
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,143
Received Thanks: 1,030
You changed the permission value to 100?


ThunderNikk is offline  
Old   #3
 
elite*gold: 0
Join Date: Mar 2009
Posts: 44
Received Thanks: 0
nope should i try that?

still dont work in sql everything is right but when i start server there is nothing changed
rickske95 is offline  
Old   #4
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,143
Received Thanks: 1,030
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.


ThunderNikk is offline  
Old   #5
 
elite*gold: 0
Join Date: Mar 2009
Posts: 44
Received Thanks: 0
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 is offline  
Old   #6
 
elite*gold: 0
Join Date: Mar 2009
Posts: 44
Received Thanks: 0
can someone help me ?

I cant save my character stats in dbo.character nothing changed after save :S
rickske95 is offline  
Old   #7
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,143
Received Thanks: 1,030
Quote:
Originally Posted by rickske95 View Post
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.
ThunderNikk is offline  
Old   #8
 
elite*gold: 0
Join Date: Mar 2009
Posts: 44
Received Thanks: 0
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
rickske95 is offline  
Old   #9
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,143
Received Thanks: 1,030
Some thing like this...

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

Code:
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.
ThunderNikk is offline  
Old   #10
 
elite*gold: 0
Join Date: Mar 2009
Posts: 44
Received Thanks: 0
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
rickske95 is offline  
Old   #11
 
elite*gold: 0
Join Date: Sep 2008
Posts: 120
Received Thanks: 94
Quote:
Originally Posted by rickske95 View Post
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 ...:
Code:
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.
Player95 is offline  
Old   #12
 
elite*gold: 0
Join Date: Mar 2009
Posts: 44
Received Thanks: 0
Dont work 0 errors but nothing changed
rickske95 is offline  
Old   #13
 
elite*gold: 0
Join Date: Sep 2008
Posts: 120
Received Thanks: 94
Well I was a bit brainless ...
The Arcadia database does not contain any Character table. It must be the Telecaster database:

Code:
USE [B]Telecaster[/B]
UPDATE dbo.Character  
SET permission = 1  WHERE name LIKE '%[GM]Authentic%';
Player95 is offline  
Thanks
1 User
Old   #14
 
elite*gold: 0
Join Date: Mar 2009
Posts: 44
Received Thanks: 0
<3 its working thank you!
rickske95 is offline  
Old   #15
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,143
Received Thanks: 1,030
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.


ThunderNikk is offline  
Reply



« Previous Thread | Next Thread »



All times are GMT +1. The time now is 04:23.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.