Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 07:29

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

Advertisement



need help log into server

Discussion on need help log into server within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jun 2010
Posts: 17
Received Thanks: 38
need help log into server

I followed the tutorial with pictures and rickicki7 arutema via video ... and all in all I have done everything they have done just that in entering the game (the game starts) with the ID: admin and PSW: admin123 I can not enter the game tells me .. you account does not exist any solution ...?
anyone can add me what i need open in a row for change ID/pass account?
USE [PS_UserData]
GO
/****** Oggetto: Table [dbo].[Users_Master] Data script: 08/01/2012 23:34:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Users_Master](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[UserUID] [int] NOT NULL,
[UserID] [varchar](18) NOT NULL,
[Pw] [varchar](12) NOT NULL,
[JoinDate] [smalldatetime] NOT NULL CONSTRAINT [DF_Users_Master_JoinDate] DEFAULT (getdate()),
[Admin] [bit] NOT NULL,
[AdminLevel] [tinyint] NOT NULL,
[UseQueue] [bit] NOT NULL,
[Status] [smallint] NOT NULL,
[Leave] [tinyint] NOT NULL,
[LeaveDate] [smalldatetime] NULL,
[UserType] [char](1) NOT NULL,
[UserIp] [varchar](15) NULL,
[ModiIp] [varchar](15) NULL,
[ModiDate] [datetime] NULL,
[Point] [int] NOT NULL CONSTRAINT [DF_Users_Master_Point] DEFAULT (0),
[Enpassword] [char](32) NULL,
[Birth] [varchar](8) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
need change anythink from this section?if yes can write me what plz...
-Beddu- is offline  
Old 08/02/2012, 00:25   #2
 
JohnHeatz's Avatar
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
That is just a script to actually create the dbo.Users_Master table, nothing to change there as you must have that table already on your database.

All you need to do is actually create an account there, either use an INSERT query

Code:
Insert into PS_UserData.dbo.Users_Master (column_names) values (values_per_column[if string need to wrap it between ' '])
JohnHeatz is offline  
Reply

Tags
-beddu-




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


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.