[HELP]Cant make acc for server RowID NULLED help Please:3

Shaiya Xtreme · 01/11/2012, 21:36

I think your [dbo].[Users_Master] Script is buggy. Use this in a New Query under PS_UserData

Code:

USE [PS_UserData]
GO
/****** Objekt:  Table [dbo].[Users_Master]    Skriptdatum: 01/11/2012 21:32:56 ******/
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) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[Pw] [varchar](12) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[JoinDate] [smalldatetime] 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) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[UserIp] [varchar](15) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[ModiIp] [varchar](15) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[ModiDate] [datetime] NULL,
	[Point] [int] NOT NULL CONSTRAINT [DF_Users_Master_Point]  DEFAULT ((0)),
	[Enpassword] [char](32) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[Birth] [varchar](8) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[lastvote] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Then reopen your ssms an new Query under [dbo].[Users_Master]

Code:

INSERT INTO PS_UserData.dbo.Users_Master 
(UserID,Pw,JoinDate,Admin,AdminLevel,UseQueue,Status,Leave,LeaveDate,UserType,Point,UserIp)
VALUES ('admin','admin123',GETDATE(),0,0,0,0,0,GETDATE(),'N',0,'127.0.0.1')

[DEV]xXDASHXx · 01/12/2012, 03:20

Quote:

Originally Posted by Shaiya Xtreme

I think your [dbo].[Users_Master] Script is buggy. Use this in a New Query under PS_UserData

Code:

USE [PS_UserData]
GO
/****** Objekt:  Table [dbo].[Users_Master]    Skriptdatum: 01/11/2012 21:32:56 ******/
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) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[Pw] [varchar](12) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[JoinDate] [smalldatetime] 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) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[UserIp] [varchar](15) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[ModiIp] [varchar](15) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[ModiDate] [datetime] NULL,
	[Point] [int] NOT NULL CONSTRAINT [DF_Users_Master_Point]  DEFAULT ((0)),
	[Enpassword] [char](32) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[Birth] [varchar](8) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[lastvote] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Then reopen your ssms an new Query under [dbo].[Users_Master]

Code:

INSERT INTO PS_UserData.dbo.Users_Master 
(UserID,Pw,JoinDate,Admin,AdminLevel,UseQueue,Status,Leave,LeaveDate,UserType,Point,UserIp)
VALUES ('admin','admin123',GETDATE(),0,0,0,0,0,GETDATE(),'N',0,'127.0.0.1')

this will or atleast should work but seeing as the ishue at hand is in reguards to row being ident and useruid not ident i would sugest runing

Code:

USE [PS_UserData]
GO
/****** Objekt:  Table [dbo].[Users_Master]    Skriptdatum: 01/11/2012 21:32:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Users_Master](
	[UserUID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [varchar](18) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[Pw] [varchar](12) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[JoinDate] [smalldatetime] 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) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[UserIp] [varchar](15) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[ModiIp] [varchar](15) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[ModiDate] [datetime] NULL,
	[Point] [int] NOT NULL CONSTRAINT [DF_Users_Master_Point]  DEFAULT ((0)),
	[Enpassword] [char](32) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[Birth] [varchar](8) COLLATE Chinese_PRC_Stroke_CI_AS NULL,
	[lastvote] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

it is infact the same code from above except i removed the column row and turned UserUID to ident so it has the auto incrument for it as this is the ishue at hand your db table is not setup to auto incrument useruid so it would requier an actyaly input for the useruid.

aragonik · 01/12/2012, 16:45

Im still not able to create an acount Q_Q fck..

Ok. I made an acc but its admin rights s set as False. how to make an admin acc? and will i ever be able to fix this user_masters bug so i can just make an acc, by doing it normaly insteed of making querys

i found this

Quote:

INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Point, Enpassword, Birth)
VALUES (1,'admin', 'admin123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,0,NULL,NULL);

but then i get

Quote:

Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'Users_Master' when IDENTITY_INSERT is set to OFF.

and im also not able to connect to Nightmare Shaiya server, I have a ServerName ( closed)
and normaly a Nightmare Shaiya server but this one disapeared :/

Shaiya Xtreme · 01/12/2012, 16:53

Again make a new [dbo].[Users_Master] with the Script what i postet! Delete your old [dbo].[Users_Master] and make a new Query with my postet Script.

aragonik · 01/12/2012, 17:06

not working.. feel free to team vieuw me D:

and i searched around.. but cant seeù to find how to Open the serer in the list mhh -_-"

usually i have a ServerName (closed) server and a Nightmare Shaiya server ( open/smooth)
now im having a Nightmare Shaiya ( closed ) a fix for that too? I search but couldnt find how to put it open >.>

Bump.. I rlly need some help D: sorry if this is illigal to BUMP post XD

[DEV]xXDASHXx · 01/13/2012, 04:08

ok im going on a small limb and asuming you will also need the database OMG gameweb also so heres the first thing ta do.

Code:

USE [OMG_GameWEB]
GO
Drop Table [dbo].[GameAccountTBL]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GameAccountTBL](
	[UserUID] [int] IDENTITY(1,1) NOT NULL,
	[GameAccount] [varchar](18) NOT NULL,
	[OneTimePassword] [varchar](32) NOT NULL,
	[OTPExpireDate] [datetime] NULL,
	[DelCharPWD] [varchar](50) NULL,
	[CreateDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]

GO
USE [PS_UserData]
GO
Drop Table [dbo].[Users_Master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Users_Master](
	[UserUID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [varchar](18) NOT NULL,
	[Pw] [varchar](12) NOT NULL,
	[JoinDate] [smalldatetime] NOT NULL 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 DEFAULT ((0)),
	[Enpassword] [char](32) NULL,
	[Birth] [varchar](8) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

excute that in your sql it will deleat both usermaster and omg gameweb tables then recreat to the tables that i myself use set idents and so on... after that is finished there are 3 files in the attached rar file it is a QUICK un secured regestration php setup there is no recaptcha or any of that it requiers userid and pasword only. it executes and installs in both user master and omg gameweb tables.. i comented as much as i felt nesesary to show what it did also i myself did not debug the php scripts so 100% working with them is not sertaint if any errors and no accounts made post back or PM me thrue here and when i have time away from work i will help as much as i can. i do hope this info is what you needed and works for you.

aragonik · 01/13/2012, 17:31

Ty, i did what u said, but idk how to host a php script XD and my site is not done, im using non premium .webs D:

edit: when i try to add an acount manually troug SQL, then i get

No row was updated.

The data in row1 was not commited
Error Source: mscorlib.
Error Message: Index was our of range. Must be non-negative and less
than the size of collection
Parameter name: index

Correct the errrors and retry or press ESC to cancel the change(s)

is what im getting >_>

JohnHeatz · 01/13/2012, 17:37

You need to get XAMP/WAMP installed, and insert the page into your www folder

aragonik · 01/13/2012, 17:44

Aight. I made an acc troug a query.. And when i log in, my Nightmare Shaiya server is CLOSED >.> btw, why cant i just make acounts manually ? shall i re install sql? o;

JohnHeatz · 01/13/2012, 17:48

To make an account "manually" stands for you typing the query, instead of using the "wizard-like" window that you showed on your first post.

If you could create an account, then there isn't anything wrong with your SQL

aragonik · 01/13/2012, 17:52

I could by using a querry, but im not able by typing the information in at the fields.. :/
its a lot handyer with typing it in in those fields then using querys x.x

and do you know why my server is (closed)?

when i shut down my service mgr, server thingies then ps game stands I I>>
And i have to stop ps_game.exe manually by task manager (procces manager) maybe thats why?

Maybe because in my Linked sservers>thheres a script called game, and its not called PS_Game as the others ( PS_DEFINEDB etc etc..) but i cant find how to rename it xD

[DEV]xXDASHXx · 01/13/2012, 23:08

aragon fill free to add me to skype i added my skype info into my profile i will help as much as i can in my free time

aragonik · 01/14/2012, 13:08

DASH and i have been team vieuwing a long time yesterday, and he told me making Acounts is not possibel because of the Identity Value, So he made me some Querys so i can make accs like that

My second problem is that when i log in my server is ( Closed) and Dash and i cant seem to find a fix, he sent me hes Ini files, i changed the encryped pass etc, changed game.exe to 127.0.0.1 and ini's to 127.0.0.1 to be sure its not causing because of my connection or somethin, but my server is still CLOSED insted of Smooth/open
Would love to get a fix for this D:

Maybe its caused because of using a wrong game.exe, If any one has a fitting game.exe on the [Dev Release]Ep5 DB, ( its ep 5.2 i think) i would be really pleased:3
-------------------------------------------------------------------------
#Everything is fixed thanks! I could not change names etc, add users by filling in the Fields, so DASH made Querys for me, I got really irritated by it, re-installed SQL, and now i can do it as it has to be done, by filling the Fields.

DASH sent me hes ini files, that did not make much diff but still ALOT of thanks all <33

I fixed the Server in server list was (closed) and could not get it Smooth/open
I deleted everything in the Shaiyaserver>SERVER backed up the ini's, putted the new files in there i downloaded from here on e*pvpers, placed the Ini's back and everything worked

Thanks all !

#Request Close and Thx if closed