Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya
You last visited: Today at 17:12

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

Advertisement



SQL Database (Users_Master) - Administrative User Issue

Discussion on SQL Database (Users_Master) - Administrative User Issue within the Shaiya forum part of the MMORPGs category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2010
Posts: 5
Received Thanks: 3
SQL Database (Users_Master) - Administrative User Issue

I know I already have another thread on this forum already, and it seems like I am merely sucking information from this website, but I would like to give back to this community in some way for giving me all the help it has already, even before I registered. Anyway...

I have recently set up a private Shaiya server with Hamachi as a networking placeholder for my public network (I receive an error when trying to use my own ISP-given IP, see other thread). I have set up user accounts for other players, including all of the administration team and the few testers we have invited to play with us as we make changes to the server. I am able to create users with Microsoft SQL Server 2005, editing both "GameAccountTBL" in OMG_GameWEB and "Users_Master" in PS_userdata. I don't want every user having GM status, yet every user I create has GM abilities, regardless of the fact that I create users with the value of Admin equaling "False" and the value of AdminLevel being set to "0." Is there an extra database table I need to edit that I may have missed, or perhaps something I may have incorrectly used?

Many thanks to all replies.

- SgtMajorDeath
SgtMajorDeath is offline  
Thanks
1 User
Old 03/09/2010, 06:28   #2
 
ProfNerwosol's Avatar
 
elite*gold: 0
Join Date: Oct 2009
Posts: 449
Received Thanks: 647
Check the link below. It's a registration script.

ProfNerwosol is offline  
Old 03/11/2010, 21:35   #3
 
elite*gold: 0
Join Date: Mar 2010
Posts: 5
Received Thanks: 3
I have used it, ran the query, and have not edited any part of it. MS SQL 2005 reports syntax errors within it. Thank you for the utility, however.
SgtMajorDeath is offline  
Old 03/13/2010, 00:59   #4
 
ProfNerwosol's Avatar
 
elite*gold: 0
Join Date: Oct 2009
Posts: 449
Received Thanks: 647
Post the error. I'll see what I can help with.
ProfNerwosol is offline  
Reply


Similar Threads Similar Threads
Need some help with a Database Issue
08/06/2010 - CO2 Private Server - 9 Replies
Hi, I would like some help on figuring this problem with my database out. (Server type 5165) First off I would like to explain how I thought it worked. Ok, I thought it worked like something out of Excel or how the guides show you. But as I found out its not. How do I get my database to look somewhat readable, and usable to my understanding. No I'm not a idiot, and yes I have less than what I want in experience to code and solve problems like this. All I am asking for is some help with this...
Issue with DB-Bot
07/14/2010 - SRO Private Server - 3 Replies
Hello, when I add a new skill in the bot or when I update a skill it always says: the selected item cannot be used together or the skill is already in use. But the old skill is gone in the game and in the bot but still it says that.. Really frustrating I play on ZSZC sro...
****** User helfen User
04/25/2010 - Off Topic - 7 Replies
Hi, Es gibt doch diese Signaturen wo man Punkte bei Dshini bekommt. Nun hätte ich eine Idee,jeder postet hier seine Signatur rein und ich fasse alle in meinem Beitrag zusammen und so helfen wir uns gegenseitig und unser Wunsch wird schneller erfüllt. wie findet ihr die Idee? Klick Klick Klick
User.ini modification issue.
12/28/2008 - Lineage 2 - 2 Replies
Hello everyone as it is my 1st post here. I've got couple of questions about user.ini enchating and I just wondering if You guys could help me to find out. So the thing is when I am trying to set ghost cam without any zooming limit on it i cannot rotate camera over my character. Also i having problem while setting zoom hack, i mean in reverse side. So when i set it up than client getting stuck and I can't do nothing. And one more thing... If anybody can explain me please, how to set...



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


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.