error when Attaching Database (PS_GameData_Data.MDF)

[nephren]

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
	INSERT INTO PS_UserData.dbo.Users_Master
	(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Enpassword, Point)
	VALUES (1,'CHOOSENAME', 'CHOOSEPW', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,NULL,0);
END

Run this Query and change "CHOOSENAME" and "CHOOSEPW" to your stuff.

Be careful: Do not change the ' '.

[Truth1010]

If you see no data there, it's because the table is empty and waiting for you to add accounts in.. xD



It's a little old, but if you just look at the User_Master table it should work the same for you in making an account. Give that a go and see if you can make an account.

EDIT: Shoo Peripher, I was typing and your post popped up!

[eclipz13]

Yeah iv'e made a few posts about this, but this one was created by me..

I figured if i posted in the other forums that i used to get this far i'd receive more help.. or at least more promptly responses lol

I opened up the DB as it says in that tut.. but it's different in MSSQL2012
It doesn't have the same option to simply open table in the DB
I hit "design" but it doesn't have the same options to simply create the accounts

Can you please add me on FB so we can chat more directly and i can post screen shots and such?

FB = mikeY O Pan

[Truth1010]

Right click, then SELECT x rows to view
Right click, then EDIT x rows to edit/add stuff

Most of us here use 2012 as well, it's mostly the same as 2005, but small changes like that. Design will actually change the layout of the table, so ignore that for now.

[eclipz13]

PS.. when i ran that it said
Msg 544, Level 16, State 1, Line 3
Cannot insert explicit value for identity column in table 'Users_Master' when IDENTITY_INSERT is set to OFF.

Oh awesome.. that worked "view/edit"
BUT when i did what you said it opened it properly.. it shows the gmlight and gmlight123 ..
but when i tried to log using those it wouldn't let me as well :/

Ok. SO the account is created. but it still says it can't be found

Iv'e tried to change the game.exe ip to 192.168.0.17 as well as GamePublicIP=192.168.0.17 in PS_Game.ini

In advance i must thank you both for helping me thus far!!

[Truth1010]

are you trying to connect with the right Game IP?

Sounds like your trying to connect to another server instead of your own.. xD

[eclipz13]

My local ip is 192.168.0.17

[Truth1010]

try make it 127.0.0.1 in the game.exe and your ini files. See if that works for you.

[eclipz13]

That didn't work either

[Truth1010]

Sent you a PM so we don't hit over 100 posts in this 1 thread trying to work out your problem. xD